<!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 &nbsp; </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>&nbsp;&nbsp;
										<%
											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>