<!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> </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> </div></td> <td><%=screen.getTagOrder()%></td> <td width="20%"><div align="right"> <script language="javascript">swapLang('Search By');</script> </div></td> <td><%=screen.getTagSearchBy()%></td> </tr> <tr> <td><div align="right"> <script language="javascript">swapLang('Condition');</script> </div></td> <td><%=screen.getTagConSearch()%></td> <td><div align="right"> <script language="javascript">swapLang('Key Value');</script> </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"> <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"> <%=screen.getString("job")%></div></td> <td nowrap class="forborder2"><div align="center"> <%=screen.getString("position")%></div></td> <td nowrap class="forborder2"><div align="center"> <%=screen.getString("bu1")%></div></td> <td nowrap class="forborder2"><div align="center"> <%=screen.getString("bu2")%></div></td> <td nowrap class="forborder2"><div align="center"> <%=screen.getString("bu3")%></div></td> <!-- <td nowrap class="forborder2"><div align="center"> <%//=screen.getString("emp_num")%></div></td> <td nowrap class="forborder2"><div align="center"> <%//=String.valueOf(emp_want)%></div></td> --> <td nowrap class="forborder2"><div align="center"> <%=screen.getInquiry().getCurrentDbRecord().getSystemCode("emp_type")%></div></td> <!-- <td nowrap class="forborder2"><div align="center"nowrap> <%//=screen.getString("startdate")%></div></td> --> <td nowrap class="forborder2"><div align="center"> <%=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>