<!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.*,java.text.DecimalFormat"%> <%@ page import="java.util.*,java.io.*,java.sql.*"%> <%@ page import="java.text.SimpleDateFormat" %> <%@ page import="java.util.Locale" %> <%@ page import="java.util.Date" %> <%@ page import="com.csc.library.components.*" %> <%@ page import="com.csc.library.report.ReportUDF" %> <%@ page import="com.csc.api.recruit.*" %> <%@ page import="com.csc.library.databean.Simmcandidatewithgson" %> <%@ page import="com.csc.library.databean.Simmappointmentwithgson" %> <%@ page import="com.csc.library.databean.Simmapplicanthisotherwithgson" %> <%@ page import="com.csc.library.utilities.gsonmapping.*" %> <% CheckNull chk = new CheckNull(); CscCalendar c = new CscCalendar(); ReportUDF udf = new ReportUDF(); UProfile up = null; if (session !=null){ up = (UProfile)session.getAttribute("userprofile"); } String lang = up.get("lang"); String submitdate = chk.chkNullString(request.getParameter("__submitdate")); String submitdate2 = chk.chkNullString(request.getParameter("__submitdate2")); String jobid = chk.chkNullString(request.getParameter("__job")); String job_desc = chk.chkNullString(request.getParameter("__job_desc")); String cmd = chk.chkNullString(request.getParameter("__cmd")); String isprocess =chk.chkNullString(request.getParameter("__isprocess")); String filter = "1=1"; if(!jobid.equals("")){ filter += " and jobid='"+jobid+"'"; } if(!submitdate.equals("") && !submitdate2.equals("")){ filter += " and applicantdate between '"+c.setCscCalendar(submitdate).getYYYYMMDD()+"' and '"+c.setCscCalendar(submitdate2).getYYYYMMDD()+"'"; } DbRecord dbrec = new InitialRecord(up).getDbRecord("memployee"); dbrec.setColumn("*"); %> <html ng-app="myHR"> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap.css" rel="stylesheet"> <script language="JavaScript" src="../JS/SCREEN.js"></script> <SCRIPT TYPE='text/JavaScript' SRC='../JS/DATEINPUT.js'></SCRIPT> <SCRIPT TYPE='text/JavaScript' SRC='../JS/VIEWCALENDAR.js'></SCRIPT> <script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script> <script src="../JS/bootstrap.min.js"></script> <script type="text/javascript" src="../JS/angular-1.3.15/angular.js"></script> <script type="text/javascript" src="../JS/ANGULAR/SCREEN_ANGULAR.js"></script> <script language="javascript">setLang('<%=up.get("lang")%>');</script> <script language="JavaScript" type="text/JavaScript"> function GoExport(){ with(document.cscform){ // alert(__filter.value); var param = "RCR023_EXP.jsp?__filter="+__filter.value; window.open(param); } } function GoProcess(){ with( document.cscform){ __cmd.value = "search" __isprocess.value = "1" submit(); } } function goHelp(helpName,inputName){ var helpReturn; var fixcon; if(inputName=="__job"){ helpReturn = inputName+":jobcodeid,"+inputName+"_desc:tdesc"; } fixcon=""; linkHelp_Return(helpName,helpReturn,fixcon); } $(function() { $('#export').click(function() { GoExport(); }); $('#search').click(function() { GoProcess(); }); }); </script> <style> img[height="20"] { padding: 0px; } .center{ text-align: center; } .wd-40{ width:40%; } </style> </head> <% String helpReturn=""; if(request.getParameter("__helpReturn")!=null){ helpReturn=request.getParameter("__helpReturn"); } String fieldSearch=""; if(request.getParameter("__fieldSearch")!=null){ fieldSearch=request.getParameter("__fieldSearch"); } %> <body leftmargin="0" topmargin="0"> <form name="cscform" method="post" action="RCR023.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%/*=screen.InitialVariable()*/%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__screen" value="RCR023"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__goPage" value=""> <input type="hidden" name="__language" value="<%=up.get("lang")%>"> <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>"> <input type="hidden" name="__helpReturn" value="<%=helpReturn%>"> <input type="hidden" name="__fieldSearch" value="<%=fieldSearch%>"> <input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>"> <input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>"> <input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>"> <input type="hidden" name="__export" value=""> <input type="hidden" name="__isprocess" value="0"> <input type="hidden" name="__filter" value="<%=filter%>"> <input type="hidden" name="__calendar" value=""> <script language="javascript">getInputFormatDate()</script> <br> <div align="center"> <table class="large" cellpadding="0" cellspacing="1" > <tr> <td colspan=2 class="header">RCR023, รายงานสรุปผลการสมัครงาน</td> </tr> <tr> <td colspan=2> <table border="0" cellpadding="0" cellspacing="1" align="center" class="largest"> <tr> <td colspan=2 class="blankspace"></td> </tr> <tr> <td width="40%" align="right"><%=lang.equalsIgnoreCase("tha")?"วันที่ส่งใบสมัคร":"Submit Date"%></td> <td style="text-align: left;"> <input type="text" id="submitdate" name="__submitdate" value="<%=submitdate%>" size="15" maxlength="10" onkeypress="chkIntegerOfDate(this.value,event);" onkeyup="sysIsEdit();formatDate(this);" onblur="chkInputDate(this);" onfocus="this.select();"> <a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('submitdate')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image1" width="20" height="20" border="0" style="vertical-align: middle"></a> - <input type="text" id="submitdate2" name="__submitdate2" value="<%=submitdate2%>" size="15" maxlength="10" onkeypress="chkIntegerOfDate(this.value,event);" onkeyup="sysIsEdit();formatDate(this);" onblur="chkInputDate(this);" onfocus="this.select();"> <a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('submitdate2')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image2" width="20" height="20" border="0" style="vertical-align: middle"></a> </td> </tr> <tr> <td class='wd-40' align="right" swlang code='SW012911'>job </td> <td><input type="text" name="__job" size="15" value="<%=jobid%>"> <a href="javascript:goHelp('MJOBCODEHELP','__job')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgjob','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgjob" border="0" align="absmiddle"></a> <input name="__job_desc" type="text" id="__job_desc" value="<%=job_desc%>" size="50" readonly=""> </td> </tr> <tr> <td colspan=2 class="blankspace"></td> </tr> <tr> <td colspan="2" style="text-align: center;"> <div id="search" class="btn btn-primary btn-sm" style="padding-top: 2px;"> Search </div> <% if(isprocess.equals("1")){ %> <div id="export" class="btn btn-primary btn-sm" style="padding-top: 2px;"> Export </div> <% } %> </td> </tr> </table> <% if(isprocess.equals("1")){ %> <table class="maxsize table table-bordered " border="1" cellpadding="0" cellspacing="1" cols=10 bgcolor="#CCCCCC"> </tr> <td class="row1 center" colspan='11'>รายงานสรุปผลการสมัครงาน</td> </tr> <tr> <td class="row1 center">ตำแหน่งที่ประกาศ</td> <td class="row1 center">ประวัติผู้สมัคร</td> <td class="row1 center">แหล่งที่มา</td> <td class="row1 center">วันที่ส่งใบสมัคร</td> <td class="row1 center">สถานะ</td> <td class="row1 center">วันที่นัดสัมภาษณ์</td> <td class="row1 center">คะแนนสอบ</td> <td class="row1 center">ผู้สัมภาษณ์</td> <td class="row1 center">ผลการสัมภาษณ์</td> <td class="row1 center">ผลการนัดเริ่มงาน</td> <td class="row1 center">วันที่เริ่มงาน</td> </tr> <% // >>>>>>>>>>>> Current Zone <<<<<<<<<<<< String committees = ""; String isappointmentTH = ""; String isappointmentEN = ""; String dateinterview = ""; String dateavailable = ""; DbInquiry inqpre = new InitialInquiry(up).getDbInquiry("mprefix"); DbInquiry inqcan = new InitialInquiry(up).getDbInquiry("Simmcandidatewithgson"); DbInquiry inqpoint = new InitialInquiry(up).getDbInquiry("Simmappointmentwithgson"); DbInquiry inqjob = new InitialInquiry(up).getDbInquiry("mjobcode"); DbInquiry inqsourcejob = new InitialInquiry(up).getDbInquiry("msourcejob"); DbInquiry inqcom = new InitialInquiry(up).getDbInquiry("mcommittee"); DbInquiry inqemp = new InitialInquiry(up).getDbInquiry("memployee"); DbInquiry inqstat = new InitialInquiry(up).getDbInquiry("mstatus"); inqcan.setColumn("*"); inqcom.putChild(inqemp); inqcan.putChild(inqjob); inqcan.putChild(inqpoint); inqcan.putChild(inqstat); inqcan.setFilter(filter); //out.print(filter); inqcan.refresh(); while(inqcan.next()){ committees = ""; Simmcandidatewithgson simmcandidatewithgson = (Simmcandidatewithgson) inqcan.getCurrentDbRecord(); Simmappointmentwithgson simmappointmentwithgson = (Simmappointmentwithgson) inqpoint.getCurrentDbRecord(); inqpre.setFilter("prefixid = '"+simmcandidatewithgson.mcandidatePersonal.prefixid+"'"); inqpre.refresh(); inqpre.next(); inqsourcejob.setFilter("sourcejobid = '"+simmcandidatewithgson.mcandidateOther.sourcejob+"'"); inqsourcejob.refresh(); inqsourcejob.next(); if(simmappointmentwithgson.mappointmentdetail != null){ dateinterview = c.setCscCalendar(simmappointmentwithgson.mappointmentdetail.date).getDDMMYYYY(); isappointmentTH = "มีการนัดหมายแล้ว"; isappointmentEN = "Have an appointment"; }else{ dateinterview = ""; isappointmentTH = "ยังไม่มีการนัดหมาย"; isappointmentEN = "No appointments"; } if(simmcandidatewithgson.mcandidatePersonal != null){ dateavailable = c.setCscCalendar((simmcandidatewithgson.mcandidatePersonal.dateavailable).substring(0,10)).getDDMMYYYY(); }else{ dateavailable = ""; } inqcom.setFilter("requestid = '"+inqpoint.getString("requestid")+"'"); inqcom.refresh(); while(inqcom.next()){ if(committees.equals("")){ committees = inqcom.getString("MEMPLOYEE","fullname"); }else{ committees += ", "+inqcom.getString("MEMPLOYEE","fullname"); } } %> <tr> <td class='center'><%=inqcan.getString("mjobcode","tdesc")%></td> <td class='center'><%=inqpre.getString("tdesc")+simmcandidatewithgson.mcandidatePersonal.fname.tha+" "+simmcandidatewithgson.mcandidatePersonal.lname.tha%></td> <td class='center'><%=inqsourcejob.getString("tdesc")%></td> <td class='center'><%=c.setCscCalendar(inqcan.getString("APPLICANTDATE")).getDDMMYYYY()%></td> <td class='center'><%=lang.equalsIgnoreCase("tha")?isappointmentTH:isappointmentEN%></td> <td class='center'><%=dateinterview%></td> <td class='center'></td> <!--รอ Ma Jung--> <td class='center'><%=committees%></td> <td class='center'><%=inqcan.getString("mstatus","tdesc")%></td> <td class='center'></td> <td class='center'></td> </tr> <% } // >>>>>>>>>>>> History Zone <<<<<<<<<<<< DbInquiry inqapphis = new InitialInquiry(up).getDbInquiry("Simmapplicanthisotherwithgson"); DbInquiry inqemp2 = new InitialInquiry(up).getDbInquiry("memployee"); inqemp2.setColumn("*"); inqapphis.putChild(inqjob); inqapphis.putChild(inqpoint); inqapphis.putChild(inqemp2); inqapphis.putChild(inqstat); inqcom.putChild(inqemp); inqapphis.setColumn("*"); inqapphis.setFilter(filter); inqapphis.refresh(); //out.print(inqapphis.recCount()); while(inqapphis.next()){ Simmapplicanthisotherwithgson simmapplicanthisotherwithgson = (Simmapplicanthisotherwithgson) inqapphis.getCurrentDbRecord(); Simmappointmentwithgson simmappointmentwithgson = (Simmappointmentwithgson) inqpoint.getCurrentDbRecord(); inqpre.setFilter("prefixid = '"+simmapplicanthisotherwithgson.mapplicanthisPersonal.prefixid+"'"); inqpre.refresh(); inqpre.next(); inqsourcejob.setFilter("sourcejobid = '"+simmapplicanthisotherwithgson.mapplicanthisother.sourcejob+"'"); inqsourcejob.refresh(); inqsourcejob.next(); if(simmappointmentwithgson.mappointmentdetail != null){ dateinterview = c.setCscCalendar(simmappointmentwithgson.mappointmentdetail.date).getDDMMYYYY(); isappointmentTH = "มีการนัดหมายแล้ว"; isappointmentEN = "Have an appointment"; }else{ dateinterview = ""; isappointmentTH = "ยังไม่มีการนัดหมาย"; isappointmentEN = "No appointments"; } inqcom.setFilter("requestid = '"+inqpoint.getString("requestid")+"'"); inqcom.refresh(); while(inqcom.next()){ if(committees.equals("")){ committees = inqcom.getString("MEMPLOYEE","fullname"); }else{ committees += ", "+inqcom.getString("MEMPLOYEE","fullname"); } } if(inqapphis.isFirst()){ %> <tr> <td colspan='11'>ประวัติ</td> </tr> <% } %> <tr> <td class='center'><%=inqapphis.getString("mjobcode","tdesc")%></td> <td class='center'><%=inqpre.getString("tdesc")+simmapplicanthisotherwithgson.mapplicanthisPersonal.fname.tha+" "+simmapplicanthisotherwithgson.mapplicanthisPersonal.lname.tha%></td> <td class='center'><%=inqsourcejob.getString("tdesc")%></td> <td class='center'><%=c.setCscCalendar(inqapphis.getString("APPLICANTDATE")).getDDMMYYYY()%></td> <td class='center'><%=lang.equalsIgnoreCase("tha")?isappointmentTH:isappointmentEN%></td> <td class='center'><%=dateinterview%></td> <td class='center'></td> <!--รอ Ma Jung--> <td class='center'><%=committees%></td> <td class='center'><%=inqapphis.getString("mstatus","tdesc")%></td> <td class='center'><%=inqapphis.getString("employeeid").equals("0")?inqapphis.getString("remark"):"ยืนยัน"%></td> <td class='center'><%=inqapphis.getString("employeeid").equals("0")?"":c.setCscCalendar(inqemp2.getString("startdate")).getDDMMYYYY()%></td> </tr> <% } %> </table> <% } %> </td> </tr> <tr> <td colspan=2 class="blankspace"></td> </tr> <tr> <td colspan=2 class="blankspace"></td> </tr> <tr bordercolor="0069B3"> <td colspan=2 class="bottom"></td> </tr> </table> </div> </form> </body> </html>