<%@ page import="com.csc.library.entry.*,com.csc.library.utilities.*"  contentType="text/html;charset=UTF-8"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.database.*,java.util.*"  contentType="text/html;charset=UTF-8"%>
<jsp:useBean id="REC601HELP" scope="page" class="com.csc.library.system.Task"/><%
		REC601HELP.setChannel(request ,response);
		HelpEntry screen=(HelpEntry) REC601HELP.process("HelpEntry","REC601HELP");
		CheckNull chkNull = new CheckNull();
		screen.getInquiry().setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("__requestid"))+"'");
		screen.process();

	DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("mcommittee");
	DbInquiry emp = new InitialInquiry(screen.getUProfile()).getDbInquiry("mreferee");
	inq.setColumn("employeeid,companyid,requestid");
	inq.setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"))+"'");
	inq.putChild(emp);

	inq.refresh();
	String mailList="";
	while(inq.next()){
		mailList = mailList+inq.getString("mreferee","email")+",";
	}
	if(mailList.length()>0)mailList=mailList.substring(0,mailList.length()-1);


%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html ng-app="myHR">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script type="text/javascript" src='../public/lib/angular/angular.min.js'></script>
<script type="text/javascript" src="../JS/ANGULAR/SCREEN_ANGULAR.js"></script>
<script type='text/javascript' src='../JS/RECSCREEN.js'></script>
<script language='javascript' src='../JS/HOTKEY.js'></script>
<script language='javascript' src='../JS/EMPLOYEE.js'></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language="JavaScript">

function goView(appid,reqid,lineno){
  		with(document.cscform){
		     __help.value="__applicantid$"+appid+";__requestid$"+reqid+";__line_no$"+lineno;
			  action = "REC602.jsp";
			  submit();
		}
}

function mail(){
with(document.cscform){
	var pam="";
	pam="REC605.jsp?&__mail_to="+mailList.value+"&__mail_from="+from.value+"&position="+position.value+"&date="+interviewdate1.value+"&time="+interviewtime1.value+"&place="+interviewplace1.value+"&room="+interviewroom1.value;
	window.open(pam,"","left=150,top=150,width=800,height=500,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
	}
}
</script>
<style type="text/css">
<!--
.style1 {color: #000000}
.style2 {color: #3366CC}
-->
</style>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="" >
<form name="cscform" method="post" action="REC601.jsp" >
  <!----------BEGIN CSC INITIAL ZONE ------------------------>
  <%=screen.InitialVariable()%>
  <!----------END CSC INITIAL ZONE -------------------------->
  <input type="hidden"name="__screen"  value="REC601">
  <input type="hidden" name="__help"  size="50" value="">
  <input name="__fixCon" type="hidden" value="">
  <input type="hidden" name="__cmd"  value="">
  <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
  <input type="hidden" name="gopage"  value="">
  <input type="hidden" name="__referPage" value="">
  <input type="hidden" name="__notNull" value="">
  <input type="hidden" name="__requestid" value="<%=chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("__requestid"))%>">
  <input type="hidden" name="__applicantid" value="">
    <input name="mailList" type="hidden" value="<%=mailList%>">
    <input name="from" type="hidden" value='<%=screen.getUProfile().get("email")%>'>
  <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
  <br>
 <center> <table width="100%"  align="center" cellpadding="0" cellspacing="0" class="normal">
    <tr class="header">
      <td  class="header" align="right">REC601, <%=request.getParameter("__requestid")%>
        <script language="javascript">swapLang('Interview_Appointment');</script></td>
    </tr>
    <%if(screen.nextRec()){	%>
    <tr >
      <td colspan="2"><table border="0" cellpadding="0"  cellspacing="0" class="maxsize" >
			<tr>
				<td align="right" class="columnlabel">&nbsp;&nbsp;</td>
				<td colspan="8" class="columnData">&nbsp;</td>
			</tr>
			<tr>
				<td align="right" class="columnlabel"><b><%=screen.getLabel("REQUESTID")%></b>&nbsp;&nbsp;</td>
				<td colspan="5" class="columnData"><%=screen.getDataLabel("REQUESTID")%></td>
                <td colspan="3" align="left"><%=screen.getLabel("MREQUEST","REQ_STATUS")%>&nbsp;&nbsp;<span class="style1"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("MREQUEST","REQ_STATUS")%>&nbsp;</span></td>
			</tr>
			<tr>
                <td align="right" class="columnlabel"><%=screen.getLabel("MREQUEST","APPROVEDATE") %>&nbsp;&nbsp;</td>
                <td colspan="2" nowrap class="columnData"> <%=screen.getDataLabel("MREQUEST","APPROVEDATE") %>&nbsp;</td>
			</tr>
			<tr>
				<%--<td align="right" class="columnlabel"><script language=JavaScript>swapLang("Job_Title")</script>&nbsp;&nbsp;</td>--%>
				<td align="right" class="columnlabel" ><span swlang code="SW012911">Job_Title</span>&nbsp;&nbsp;</td>
				<td colspan="8" nowrap class="columnData"><%=screen.getDataLabel("MJOBCODE","TDESC")%>&nbsp;&nbsp;</td>
			</tr>
			<tr>
				<td align="right" class="columnlabel" nowrap><script language=JavaScript>swapLang("Position")</script>&nbsp;&nbsp;</td>
				<td class="columnData" nowrap colspan="8"><%=screen.getDataLabel("MPOSITION","TDESC")%><input name="position" type="hidden" value="<%=screen.getDataLabel("MPOSITION","TDESC")%>"></td>
			</tr>
			<tr>
				<td align="right" class="columnlabel" nowrap><script language=JavaScript>swapLang("Business_Unit_1")</script>&nbsp;&nbsp;</td>
				<td class="columnData" nowrap colspan="8"><%=screen.getDataLabel("MBU1","TDESC")%></td>
			</tr>
			<tr>
				<td align="right" class="columnlabel" nowrap><script language=JavaScript>swapLang("Business_Unit_2")</script>&nbsp;&nbsp;</td>
				<td class="columnData" nowrap colspan="8"><%=screen.getDataLabel("MBU2","TDESC")%></td>
			</tr>
			<tr>
				<td align="right" class="columnlabel" nowrap><script language=JavaScript>swapLang("Business_Unit_3")</script>&nbsp;&nbsp;</td>
				<td class="columnData" nowrap colspan="8"><%=screen.getDataLabel("MBU3","TDESC")%></td>
			</tr>
			<tr>
				<td align="right" class="columnlabel" nowrap><script language=JavaScript>swapLang("Business_Unit_4")</script>&nbsp;&nbsp;</td>
				<td class="columnData" nowrap colspan="8"><%=screen.getDataLabel("MBU4","TDESC")%></td>
			</tr>
			<tr>
				<td align="right" class="columnlabel" nowrap><script language=JavaScript>swapLang("Business_Unit_5")</script>&nbsp;&nbsp;</td>
				<td class="columnData" nowrap colspan="8"><%=screen.getDataLabel("MBU5","TDESC")%></td>
			</tr>
			<tr>
				<td align="right" class="columnlabel"><%//=screen.getLabel("MREQUEST","REQ_TYPE") %><script language=JavaScript>swapLang("Employment_Type")</script>&nbsp;&nbsp;</td>
				<td colspan="8" class="columnData"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("MREQUEST","EMP_TYPE")%></td>
			</tr>
			<tr>
				<%--<td align="right" class="columnlabel"><script language="javascript">swapLang('No of Requirement')</script>&nbsp;&nbsp;</td>--%>
				<td align="right" class="columnlabel"><span swlang code="SW012912">required</span>&nbsp;&nbsp;</td>
				<td colspan="5" class="columnData">
					<span class="style1"><%=screen.getDataLabel("MREQUEST","EMP_NUM")%></span>&nbsp;
					<span class="style2">
						<script language="JavaScript">swapLang('Position')</script>
					</span>
				</td>
				<td colspan="2" align="left" nowrap>
					<span swlang code="SW012913"></span>&nbsp;
					<span class="style1"><%=screen.getDataLabel("MREQUEST","MAPPTRAN_NUM")%></span>&nbsp;
					<span class="style2">
						<script language="JavaScript">swapLang('Position')</script>
					</span>
				</td>
			</tr>
			<tr>
				<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Ages')</script>&nbsp;&nbsp;                  </td>
				<td colspan="5" class="columnData"><%=screen.getDataLabel("MREQUEST","FROMAGE")%> - <%=screen.getDataLabel("MREQUEST","TOAGE")%>&nbsp;&nbsp;<span class="style2"><script language="JavaScript">swapLang('Year')</script></span></td>
                <td align="left" colspan="2"><script language="javascript">swapLang('Gender')</script>&nbsp;<span class="style1"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("MREQUEST","SEX")%></span></td>
			</tr>
			<tr>
				<td align="right" class="columnlabel" nowrap><%=screen.getLabel("MREQUEST","REQUEST_BY")%>&nbsp;&nbsp;</td>
				<td class="columnData" nowrap colspan="8"><%=screen.getDataLabel("MEMPLOYEE","FULLNAME")%></td>
			</tr>
			<tr>
				<td align="right" class="columnlabel" nowrap><script language="JavaScript">swapLang('Approved Date')</script>&nbsp;&nbsp;</td>
				<td class="columnData" nowrap colspan="8"><%=screen.getDataLabel("MREQUEST","REQUEST_DATE")%></td>
			</tr>
			<tr>
				<td colspan="8"></td>
			</tr>
			<tr>
				<td colspan="8"><script language="javascript">swapLang('Recorded Applicant List');</script></td>
			</tr>
			<tr>
				<td colspan="8"><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2">
                <tr bgcolor="#3366CC">
                  <td width="50" align="center" nowrap class="row3"><script language="JavaScript">swapLang('Sequence')</script></td>
                  <td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Applicant ID')</script></td>
                  <td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Name')</script> - <script language="JavaScript">swapLang('Lastname')</script></td>
                  <td align="center" nowrap class="row3" swlang code="SW012914"></td>
                  <td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Date')</script></td>
                  <td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Time')</script></td>
                </tr>
                <%
		screen.process();
		int i=1;
    	while(screen.nextRec()){
		//	if(!screen.getDataLabel("CANDIDATESTATUS").equals("")&&Integer.parseInt(screen.getDataLabel("CANDIDATESTATUS"))>=2&&Integer.parseInt(screen.getDataLabel("CANDIDATESTATUS"))!=9){
			Integer candidatestatus = Integer.parseInt(chkNull.chkNullString(screen.getDataLabel("CANDIDATESTATUS"),"0"));
			if(candidatestatus>=1 && candidatestatus!=4 && candidatestatus!=5 && candidatestatus!=10 && candidatestatus!=11){
				String[] arr = screen.getDataLabel("LATEST_APPOINT").split("#");
				String appointment = "-";
				if(!arr[0].equals("-")){
					appointment = new SystemCode().getValue("APPOINTMENT_TYPE", arr[0], screen.getUProfile().get("lang"));
				}
				SystemCode sc = new SystemCode();
				String date = "-";
				if(!arr[1].equals("-")){
					date = new CscCalendar(arr[1]).getDDMMYYYY();
				}
				String time = "-";
				if(!arr[2].equals("-") && !arr[3].equals("-")){
					time = arr[2]+" - "+arr[3];
				}
			%>
                <tr>
                  <td align="center" nowrap><%=i%><%//=screen.getDataLabel("LATEST_APPOINT")%></td>
                  <td align="center" nowrap><a href="javascript:goView('<%=screen.getDataLabel("APPLICANTID")%>','<%=screen.getDataLabel("REQUESTID")%>','<%=screen.getDataLabel("LINE_NO")%>')"><%=screen.getDataLabel("APPLICANTID") %></a></td>
                  <td align="center" nowrap><%=screen.getDataLabel("MAPPLICANT","FULLNAME") %></td>
                  <td align="center" nowrap><%=appointment%></td>
                  <td align="center" nowrap><%=date%></td>
                  <td align="center" nowrap><%=time%></td>
                </tr>

					<input name="interviewplace<%=i%>" type="hidden" value="<%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWPLACE")%>">
					<input name="interviewroom<%=i%>" type="hidden" value="<%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWROOM")%>">
					<input name="interviewdate<%=i%>" type="hidden" value="<%=screen.getDataLabel("MAPPOINTMENT","INTERVIEWDATE")%>">
					<input name="interviewtime<%=i++%>" type="hidden" value="<%//=screen.getDataLabel("MAPPOINTMENT","INTERVIEWTIME")%>">
                <%
			}
		}
			%>
                <!-- <tr>
                  <td colspan="9" align="center"><a href="javaScript:mail();"><img src="../IMAGES/BUTTON/MAIL.gif" align="absmiddle" border="0"></a></td>
                </tr> -->
              </table></td>
          </tr>
          <tr>
            <td colspan="8"><script language="javascript">swapLang('Non-record Applicant List');</script></td>
          </tr>
          <tr>
            <td colspan="8"><table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2">
                <tr bgcolor="#3366CC">
					<td width="50" align="center" nowrap class="row3"><script language="JavaScript">swapLang('Sequence')</script></td>
					<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Applicant ID')</script></td>
					<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Name')</script> - <script language="JavaScript">swapLang('Lastname')</script></td>
					<td align="center" nowrap class="row3"><script language="JavaScript">swapLang('Job')</script></td>
				</tr>
	<%
		screen.process();
		i=1;
		while(screen.nextRec()){
			Integer candidatestatus = Integer.parseInt(chkNull.chkNullString(screen.getDataLabel("CANDIDATESTATUS"),"0"));
			String qualification = screen.getDataLabel("QUALIFICATION");
			String comply_reason = screen.getDataLabel("COMPLY_REASON");
			boolean isQualification = false;
			if(qualification.equals("1") || (qualification.equals("2") && !comply_reason.equals(""))){
				isQualification = true;
			}
			if(candidatestatus==0 && isQualification){
	%>
                <tr>
                  <td align="center" nowrap><%=i++%></td>
                  <td align="center" nowrap><a href="javascript:goView('<%=screen.getDataLabel("APPLICANTID")%>','<%=screen.getDataLabel("REQUESTID")%>','<%=screen.getDataLabel("LINE_NO")%>')"><%=screen.getDataLabel("APPLICANTID") %></a></td>
                  <td align="center" nowrap><%=screen.getDataLabel("MAPPLICANT","FULLNAME") %></td>
                  <td align="center" nowrap><%=screen.getDataLabel("MAPPLICANT","REFEREE1POSITIONID")%>&nbsp;<%=screen.getDataLabel("V1MJOBCODE","TDESC")%>

                </tr>
	<%
			}
		}
	%>
                <tr>
                  <td colspan="9"></td>
                </tr>
              </table></td>
          </tr>
        </table></td>
        <%}
	else {
		%>

	<tr>
		<td><script language="JavaScript">swapLang('No Candidate Found!!')</script></td></tr>
        <%}%>
    </tr>
	<tr>
		<td align="right"><script language="javascript">printEditCheck('<%=screen.getDataLabel("edit_by")%>','<%=screen.getDataLabel("edit_date")%>','<%=screen.getDataLabel("edit_time")%>','<%=screen.getDataLabel("approve")%>');</script>&nbsp;</td>
	</tr>
    <tr bordercolor="0069B3">
      <td  class="bottom"></td>
    </tr>
  </table>
</center>
    <!----------BEGIN CSC ENDING ZONE ------------------------>
  <%=screen.endJSP()%>
  <!----------END CSC ENDING ZONE -------------------------->
</FORM>
</body>
</html>