<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,com.csc.library.databean.*,com.csc.library.components.*,java.util.*;"%>
<jsp:useBean id="REC010_WF" class="com.csc.library.system.Task" scope="page" /><%
	REC010_WF.setChannel(request, response);
	HelpEntry screen = (HelpEntry) REC010_WF.process("HelpEntry", "VW_REQUESTHELP");
	screen.setMaxLine(20);	
	//screen.getInquiry().setFilter(" requestid in ((select requestid from mcandidatere where candidatestatus='7') except (select requestid from mapptran))");//ไม่ต้องใช้แล้ว เพราะ เพิ่ม candidatestatus = 8 อีกอัน 
	//screen.getInquiry().setFilter("req_status='2' and requestid in (select requestid from mcandidatere where candidatestatus in ('7','8')) ");
	screen.getInquiry().setFilter("req_status='2'");
	screen.process();
	
			
%>
<html>
<head>
<title><%=screen.getInquiry().getCurrentDbRecord().getDescription()%></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="../JS/SCREEN.js"></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language='javascript' src='./JS/SWAPLANG.js'></script>
<script language="JavaScript" type="text/JavaScript">
<!--
//-->

function goPages(requestid,pages,status){
	with(document.cscform){
		__requestid.value = requestid
		if(status=="2")
			action = pages+".jsp";
		else
			action = "REC810.jsp";			  
		__cmd.value="search";
		submit();
	}
}

</script>
</head>
<%
		String helpReturn="";
		if(request.getParameter("__helpReturn")!=null){
			helpReturn=request.getParameter("__helpReturn");
		}
%>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" >
  <!----------BEGIN CSC INITIAL ZONE ------------------------>
  <%=screen.InitialVariable()%>
  <!----------END CSC INITIAL ZONE -------------------------->
  <input type="hidden" name="__cmd" value="">
  <input type="hidden" name="__help" value="">
  <input type="hidden" name="__goPage" value="">
  <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
  <input type="hidden" name="__helpReturn" value="<%=helpReturn%>">
  <input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>">
  <input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>">
  <input type="hidden" name="__fixCon" value=" requestid in ((select requestid from mcandidatere where candidatestatus='7'))">
  <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
  <input type="hidden" name="__requestid" value="">
  <br>
  <div align="center">
    <table height="" align="center" cellpadding="0" cellspacing="0" >
      <tr bgcolor="#3366CC">
        <td  height="20" class="header">REC010_WF,
          <script language="javaScript">swapLang("Employment Approve")</script>
          &nbsp;</td>
      </tr>
      <tr bgcolor="#3366CC">
        <td><table class="maxsize" border="1" cellspacing="1" cellpadding="1">
            <tr>
              <td><table class="maxsize" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td colspan="4"  class="blankspace" ></td>
                  </tr>
                  <tr>
                    <td width="15%"><div align="right">
                        <script language="javascript">swapLang('Order By');</script>
                        &nbsp; </div></td>
                    <td><%=screen.getTagOrder()%></td>
                    <td width="20%"><div align="right">
                        <script language="javascript">swapLang('Search By');</script>
                        &nbsp;</div></td>
                    <td><%=screen.getTagSearchBy()%></td>
                  </tr>
                  <tr>
                    <td><div align="right">
                        <script language="javascript">swapLang('Condition');</script>
                        &nbsp; </div></td>
                    <td><%=screen.getTagConSearch()%></td>
                    <td><div align="right">
                        <script language="javascript">swapLang('Key Value');</script>
                        &nbsp;</div></td>
                    <td><%=screen.getTagValueSearch()%> <a href="javascript:search();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" height="20" border="0" align="middle"></a></td>
                  </tr>
                  <tr>
                    <td colspan="4"  class="blankspace" ></td>
                  </tr>
                  <tr>
                    <td colspan="4"><div align="right"><%=screen.getPageTag()%></div></td>
                  </tr>
                </table></td>
            </tr>
          </table></td>
      </tr>
      <tr>
        <td><br>
          <table height="" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="inframe">
            <tr>
              <td width="6%" nowrap class="title1"><div align="center">&nbsp;&nbsp;<script language="javaScript">swapLang('Code')</script></div></td>
              <td width="15%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('Job name')</script></div></td>
              <td width="17%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('Position name')</script></div></td>
              <td width="7%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('Business Unit 1')</script></div></td>
              <td width="7%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('Business Unit 2')</script></div></td>
              <td width="7%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('Business Unit 3')</script></div></td>
              <!-- <td width="7%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('No of requirement')</script></div></td>
              <td width="7%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('No of wanted')</script></div></td> -->
              <td width="9%" nowrap class="title1"><div align="center"><%=screen.getLabel("emp_type")%></div></td>
              <!-- <td width="9%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('Required date')</script></div></td> -->
              <td width="9%" nowrap class="title1"><div align="center"><script language="javaScript">swapLang('วันที่ประกาศผลการคัดเลือก')</script></div></td>
            </tr>
            <% 
		CheckNull chk = new CheckNull();
		ArrayList reqList = new ArrayList();
		while(screen.nextRec()){ 
			if(screen.checkLinePage()){   
				screen.referLangOn();
				int emp_start = Integer.parseInt(chk.chkNullString(screen.getString("emp_num"),"0"));
				int emp_entered = Integer.parseInt(chk.chkNullString(screen.getString("emp_numentered"),"0"));
				int emp_want = emp_start - emp_entered;
			%>
            <tr>
              <td height="21" nowrap  class="forborder2" ><div align="center"nowrap><a href="javascript:goPages('<%=screen.getString("requestid")%>','REC901','<%=screen.getString("req_status")%>');"><%=screen.getString("requestid")%></a></div></td>
                <td nowrap  class="forborder2"><div align="center">&nbsp;<%=screen.getString("job")%></div></td>
                <td nowrap  class="forborder2"><div align="center">&nbsp;<%=screen.getString("position")%></div></td>
                <td nowrap  class="forborder2"><div align="center">&nbsp;<%=screen.getString("bu1")%></div></td>
                <td nowrap  class="forborder2"><div align="center">&nbsp;<%=screen.getString("bu2")%></div></td>
                <td nowrap  class="forborder2"><div align="center">&nbsp;<%=screen.getString("bu3")%></div></td>
				<!-- <td nowrap  class="forborder2"><div align="center">&nbsp;<%//=screen.getString("emp_num")%></div></td>
				<td nowrap  class="forborder2"><div align="center">&nbsp;<%//=String.valueOf(emp_want)%></div></td> -->
				<td nowrap  class="forborder2"><div align="center">&nbsp;<%=screen.getInquiry().getCurrentDbRecord().getSystemCode("emp_type")%></div></td>
				<!-- <td nowrap  class="forborder2"><div align="center"nowrap>&nbsp;<%//=screen.getString("startdate")%></div></td> -->
				<td nowrap  class="forborder2"><div align="center">&nbsp;<%=screen.getDataLabel("MREQUEST","CONCLUSION_DATE")%></div></td>
            </tr>
            <%
				screen.referLangOff();
			}
			if(screen.outLinePage()){ break; }
		}
			%>
          </table></td>
      </tr>
      <tr>
        <td ></td>
      </tr>
      <tr>
        <td class="bottom"></td>
      </tr>
    </table>
  </div>
</form>
</body>
</html>