<%@ page import="com.csc.library.entry.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.database.*,java.util.*,java.text.DecimalFormat" contentType="text/html;charset=UTF-8"%>
<jsp:useBean id="REC801_TPBS" scope="page" class="com.csc.library.system.Task"/><%@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.*,com.csc.library.database.*;"%>
<%
REC801_TPBS.setChannel(request ,response);
UIManager screen=(UIManager) REC801_TPBS.process("MultiEntry","REC801_TPBS");
MultiLine multi = screen.getMultiLine("MCANDIDATERE");
MultiLine multi_committee = screen.getMultiLine("MCOMMITTEE");
CheckNull chkNull = new CheckNull();
%>
<!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 language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script language='javascript' src='../JS/EMPLOYEE.js'></script>
<script language='javascript' src='../JS/DATEINPUT.js'></script>
<script language='javascript' src='../JS/VIEWCALENDAR.js'></script>
<script language="JavaScript" src='../JS/ICONSMENU.js'></script>
<script language='javascript' src='../JS/HOTKEY.js'></script>
<script language="JavaScript" type="text/JavaScript">
function GoSave(){confirmSave();}
function GoClean(){}
function GoUpdate(){update();}
function GoDelete(){alert(MyCode[150]);
//edelete();
}
function GoSearch(){search();}
function goView(appid,date){
with(document.cscform){
__fixCon.value="applicantid='"+appid+"' and date_interview='"+date+"' and requestid= '"+__requestid.value+"'";
__help.value="__applicantid#"+appid+";";
action = "REC802.jsp";
submit();
}
}
function goView(appid,email,date,fullname,position){
with(document.cscform){
//__fixCon.value="applicantid='"+appid+"' and date_interview='"+date+"' and requestid= '"+__requestid.value+"'";
//__help.value="__applicantid#"+appid+";";
__appid.value=appid;
__fullname.value = fullname;
__position.value=position;
__email.value = email;
__backpage.value = "REC801_TPBS";
action = "REC802.jsp";
submit();
}
}
function linkChildPru(page){
with(document.cscform){
window.open(page+".jsp?__gorec="+__gorec.value+"&__ack=add&__headMulti="+__headMulti.value+"&__RecNo="+__maxrec.value+"&__line_no="+__line_no.value,page,"left=150,top=150,width=680,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function childMulti(record){
with(document.cscform){
window.open(__childMulti.value+".jsp?__cmd=&__gorec="+record+
"&__ack=edit&__requestid="+__requestid.value+
"&__headMulti="+__headMulti.value+
"&__companyid="+__companyid.value+"&__line_no="+__line_no.value,"Child","left=150,top=20,width=700,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function setCandidateStatus(obj){
with(document.cscform){
var objname = obj.name.replace("INTERVIEW_RESULT","CANDIDATESTATUS");
if(obj.value==""){ // ยังไม่ได้ทำอะไร
eval(objname).value = "3";
}else if(obj.value=="1"){ // ผ่าน
eval(objname).value = "6";
}if(obj.value=="2"){ // ไม่ผ่าน
eval(objname).value = "4";
}if(obj.value=="3"){ // รอเปรียบเทียบ
eval(objname).value = "3";
}
}
}
function goFormReadonly_bak(apsassessy,apsassessor,apsid){
with(document.cscform){
window.open("../EMPVIEW/APS_EMV704_PHATRA.jsp?apsid="+apsid+"&apsassessor="+apsassessor+
"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=1&isread=1&appname=recruit&isadmin=1","form","left=150,top=150,width=800,height=800,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function goFormReadonly(apsassessy,apsassessor,apsid,lineno){
with(document.cscform){
var site = __formPage.value
var page = "../EMPVIEW/APS_EMV704_PHATRA.jsp";
/*if(apsid.indexOf("TPBS")>-1){
page = "../EMPVIEW/APS_EMV704_TPBS.jsp";
}else if(apsid.indexOf("COOK")>-1){
page = "../EMPVIEW/APS_EMV704_COOK.jsp";
}*/
if(site!=""){
page = "../EMPVIEW/APS_EMV704_"+site+".jsp";
}
window.open(page+"?apsid="+apsid+"&apsassessor="+apsassessor+"&apsassessy="+apsassessy+"&bpage="+__screen.value+"&ass_level=1&isread=1&appname=recruit&isadmin=1&__line_no="+lineno,"form","left=150,top=150,width=1200,height=800,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function chkInterviewResult(){
with(document.cscform){
var elements = document.getElementsByTagName('input')
for(var i=0; i<elements.length; i++) {
var input = elements[i];
if(input.name.indexOf("__MCANDIDATERE$INTERVIEW_RESULT$")>-1){
// alert(input.value+': '+input.checked);
var objname = input.name.replace("INTERVIEW_RESULT","CANDIDATESTATUS");
if(input.value==""){ // ยังไม่ได้ทำอะไร
eval(objname).value = "3";
}else if(input.value=="1"){ // ผ่าน
eval(objname).value = "6";
}if(input.value=="2"){ // ไม่ผ่าน
eval(objname).value = "4";
}if(input.value=="3"){ // รอเปรียบเทียบ
eval(objname).value = "3";
}
}
}
}
}
</script>
<style type="text/css">
<!--
.style1 {color: #000000}
.style2 {color: #3366CC}
-->
</style>
</head>
<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif','../IMAGES/BUTTON/SWAP/EXIT_SWAP24.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<div class="centered">
<form name="cscform" method="post" action="REC801_TPBS.jsp" >
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<script language="javascript">getInputFormatDate();</script>
<input name="__cmd" type="hidden" value="">
<input name="__screen" type="hidden" value="REC801_TPBS">
<input name="__calendar" type="hidden">
<input name="__notNull" type="hidden" value="">
<input name="__help" type="hidden" value="">
<input name="__gorec" type="hidden" value="">
<input name="__headMulti" type="hidden" value="REC801_TPBS">
<input name="__childMulti" type="hidden" value="REC102B">
<input name="__multiTable" type="hidden" value="MCANDIDATERE">
<input name="__ack" type="hidden" value="">
<input name="__maxrec" type="hidden" value="<%=screen.getTable("MCANDIDATERE").recCount()%>">
<input name="__language" type="hidden" value='<%=screen.getUProfile().get("lang")%>'>
<input name="__lastrec" type="hidden" value="<%=screen.getTable("MCANDIDATERE").recCount()%>">
<input name="__companyid" type="hidden" value='<%=screen.getUProfile().get("companyid")%>'>
<input name="__employeeid" type="hidden" value='<%=screen.getUProfile().get("employeeid")%>'>
<input name="__afterUpdate" type="hidden" value="">
<input name="__referPage" type="hidden" value="">
<input name="__fixCon" type="hidden" value="">
<input type="hidden" name="__list" VALUE="<%=chkNull.chkNullString(request.getParameter("__list"),"")%>">
<input type="hidden" name="__autonum" value="">
<input type="hidden" name="__clean" value="1">
<input type="hidden" name="__appid" value="">
<input type="hidden" name="__fullname" value="">
<input type="hidden" name="__position" value="">
<input type="hidden" name="__email" value="">
<input type="hidden" name="__backpage" value="">
<input type="hidden" name="__formPage" value="<%=chkNull.chkNullString(StaticConfig.getConfigCompany(screen.getUProfile(),"APS_FORM"))%>">
<script language="JavaScript" src="../JS/HOTKEY.js"></script>
<script language="javascript">getInputFormatDate();</script>
<script language="javascript">initToolTips();</script>
<script language="javascript">
var titlename=swap2String("Interview Conclusion");
document.write(Icons("REC801_TPBS,"+titlename));
</script>
<br>
<table border="0" align="center" cellpadding="0" cellspacing="0" class="medium">
<tr>
<td class="header"><div align="right">REC801_TPBS,
<script language="javaScript">swapLang("Interview Conclusion")</script>
</div></td>
</tr>
<tr>
<td class="blankspace"> </td>
</tr>
<tr>
<%//screen.referLangOn();%>
<td><div align="center">
<table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2" cols="4">
<tr><%=screen.getInput("REQUESTID")%>
<td align="right" class="columnlabel"><%=screen.getLabel("REQUESTID")%> </td>
<td colspan="5" class="columnData"><%=screen.getDataLabel("REQUESTID")%></td>
<td colspan="3" align="left"><%=screen.getLabel("REQ_STATUS")%> <span class="style1"><%=screen.getRecord().getSystemCode("REQ_STATUS")%></span> </td>
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("APPROVEDATE")%> </td>
<td nowrap colspan="3" class="columnData"><%=screen.getDataLabel("APPROVEDATE")%> </td>
</tr>
<tr>
<td align="right" class="columnlabel"><%//=screen.getLabel("JOBID")%><span swlang code="SW012911">swapLang("Job Title")</span> </td>
<td colspan="2" nowrap class="columnData"><%=screen.getDataLabel("MJOBCODE","TDESC")%> </td>
</tr>
<tr>
<td align="right" class="columnlabel"><%//=screen.getLabel("POSITIONID")%><script language="javaScript">swapLang("Position")</script> </td>
<td colspan="5" nowrap class="columnData"><%=screen.getDataLabel("MPOSITION","TDESC")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Business Unit 1')</script> </td>
<td colspan="5" nowrap class="columnData"><%=screen.getDataLabel("MBU1","TDESC")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Business Unit 2')</script> </td>
<td colspan="5" nowrap class="columnData"><%=screen.getDataLabel("MBU2","TDESC")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Business Unit 3')</script> </td>
<td colspan="5" nowrap class="columnData"><%=screen.getDataLabel("MBU3","TDESC")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Business Unit 4')</script> </td>
<td colspan="5" nowrap class="columnData"><%=screen.getDataLabel("MBU4","TDESC")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Business Unit 5')</script> </td>
<td colspan="5" nowrap class="columnData"><%=screen.getDataLabel("MBU5","TDESC")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("EMP_TYPE")%> </td>
<td colspan="5" class="columnData"><%=screen.getRecord().getSystemCode("EMP_TYPE")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><span swlang code="SW012912">swapLang('No of Requirement')</span> </td>
<td colspan="5" class="columnData"><span class="style1"><%=screen.getDataLabel("EMP_NUM")%></span> <span class="style2"><script language="JavaScript">swapLang('Position')</script></span></td>
<td colspan="2" align="left" nowrap><span swlang code="SW012913">swapLang('No Of Been Employed')</span> <span class="style1"><%=screen.getDataLabel("MAPPTRAN_NUM")%></span> <span class="style2"><script language="JavaScript">swapLang('Position')</script></span></td>
</tr>
<tr style=display:none>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Salary range')</script> </td>
<td colspan="2" class="columnData"><%=screen.getDataLabel("FROMSALARY")%> - <%=screen.getDataLabel("TOSALARY")%>
<span class="style2"> <script language="JavaScript">swapLang('Baht')</script></span></td>
</tr>
<tr>
<td align="right" class="columnlabel"><script language="JavaScript">swapLang('Ages')</script> </td>
<td colspan="5" class="columnData"><%=screen.getDataLabel("FROMAGE")%> - <%=screen.getDataLabel("TOAGE")%>
<span class="style2"> <script language="JavaScript">swapLang('Year')</script></span></td>
<td align="left" colspan="2"><script language="javascript">swapLang('Gender')</script> <span class="style1"><%=screen.getRecord().getSystemCode("SEX")%></span></td>
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("REQUEST_BY")%> </td>
<td colspan="4" class="columnData"><%=screen.getDataLabel("MEMPLOYEE","FULLNAME")%></td>
</tr>
<tr>
<td align="right" class="columnlabel"><%=screen.getLabel("REQUEST_DATE")%> </td>
<td colspan="2" class="columnData"><%=screen.getDataLabel("REQUEST_DATE")%></td>
</tr>
<tr>
<td colspan="9"><hr></td>
</tr>
<tr>
<td colspan="9"><script language="javascript">swapLang('Interview Score Recorded Applicant List');</script></td>
</tr>
<tr>
<td colspan="9">
<table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2">
<%
LinkedHashMap hm_committee = new LinkedHashMap();
multi_committee.getTable().setFilter("committee_type = '1' ");
multi_committee.goFirst();
for(int i=1;!multi_committee.eof();multi_committee.next(),i++){
hm_committee.put(multi_committee.getDataLabel("MCOMMITTEE","EMPLOYEEID"),multi_committee.getDataLabel("MREFEREE","FULLNAME"));
}
%>
<tr bgcolor="#3366CC">
<td width="50" align="center" nowrap class="row3"><script language="JavaScript">swapLang('Sequence')</script></td>
<td align="center" nowrap class="row3"><span swlang code="SW012916">swapLang('สรุปผล')</span></td>
<td align="center" nowrap class="row3"><span swlang code="SW012917">swapLang('ลำดับรอเปรียบเทียบ')</span></td>
<td align="center" nowrap class="row3"><span swlang code="SW002159">swapLang('Applicant ID')</span></td>
<td align="center" nowrap class="row3"><span swlang code="SW000195">swapLang('Name')</span> - <span swlang code="SW000214">swapLang('Lastname')</span></td>
<td align="center" nowrap class="row3"><span swlang code="SW002334">swapLang('วันที่สัมภาษณ์')</span></td>
<%
Iterator<String> it_committee = hm_committee.keySet().iterator();
while(it_committee.hasNext()){
String employeeid = it_committee.next();
String fullname = (String)hm_committee.get(employeeid);
%>
<td align="center" nowrap class="row3"><span swlang code="SW000013">swapLang('คะแนน')</span><br><%=fullname%></td>
<%
}
%>
<td align="center" nowrap class="row3"><span swlang code="SW006925">swapLang('คะแนนเฉลี่ย')</span></td>
</tr>
<%
// multi.getTable().setFilter(" cast(candidatestatus as float) >= 3 and candidatestatus not in ('4','5','10','11') ");
multi.getTable().setFilter(" candidatestatus = '3' ");
multi.getTable().refresh();
multi.goFirst();
for(int i=1;!multi.eof();multi.next(),i++){
String line_no = multi.getDataLabel("MCANDIDATERE",multi.getTable().getMinorKey());
%>
<tr>
<td align="center" nowrap><%=i%></td>
<td align="center" nowrap>
<%
ListBox listbox = new ListBox();
listbox.setUProfile(screen.getUProfile());
listbox.setName("MCANDIDATERE$INTERVIEW_RESULT$"+line_no);
listbox.setValidCode("RESULT_RECRUIT");
String interview_result = chkNull.chkNullString(multi.getDataLabel("MCANDIDATERE","INTERVIEW_RESULT"),"3");
listbox.setChecked(chkNull.chkNullString(request.getParameter("__MCANDIDATERE$INTERVIEW_RESULT$"+line_no),interview_result));
// listbox.setChecked(chkNull.chkNullString(request.getParameter("__MCANDIDATERE$INTERVIEW_RESULT$"+line_no),multi.getDataLabel("MCANDIDATERE","INTERVIEW_RESULT")));
listbox.setonChange("setCandidateStatus(this);");
// listbox.setBlank(true);
%>
<%=listbox.process()%>
</td>
<td align="center" nowrap><%//=multi.getInput("MCANDIDATERE","RANKING")%>
<input name="__MCANDIDATERE$RANKING$<%=line_no%>" class="numeric" onmouseout="toolTip()" onkeyup="sysIsEdit();" onkeypress="chkInteger(event);" onfocus="callDelComma(this);" onblur="checkNumInt(this,0,900000000);" type="text" size="2" maxLength="2" alt="ลำดับรอเปรียบเทียบ" value="<%=chkNull.chkNullString(request.getParameter("__MCANDIDATERE$RANKING$"+line_no),multi.getDataLabel("MCANDIDATERE","RANKING"))%>"/>
<input type="hidden" name="__MCANDIDATERE$CANDIDATESTATUS$<%=line_no%>" value="<%=chkNull.chkNullString(request.getParameter("__MCANDIDATERE$CANDIDATESTATUS$"+line_no),multi.getDataLabel("MCANDIDATERE","CANDIDATESTATUS"))%>"/>
</td>
<td align="center" nowrap>
<a href="javascript:goView('<%=multi.getDataLabel("APPLICANTID") %>','<%=multi.getDataLabel("MAPPLICANT","EMAIL")%>','<%=new CscCalendar(multi.getDataLabel("MAPPOINTMENT","INTERVIEWDATE")).getYYYYMMDD() %>','<%=multi.getDataLabel("MAPPLICANT","FULLNAME")%>','<%=multi.getDataLabel("MAPPLICANT","JOBNAME").equals("")?multi.getDataLabel("MAPPLICANT","FREETEXTJOB") :multi.getDataLabel("MAPPLICANT","JOBNAME")%>')"><%=multi.getDataLabel("APPLICANTID") %></a>
</td>
<td align="center" nowrap><%=multi.getDataLabel("MAPPLICANT","FULLNAME") %></td>
<td align="center" nowrap><%=multi.getDataLabel("MAPPOINTMENT","INTERVIEWDATE") %></td>
<%
DecimalFormat df = new DecimalFormat("0.00");
int num_committee = 0;
Double sum_score = 0.00;
Iterator<String> it_committee2 = hm_committee.keySet().iterator();
while(it_committee2.hasNext()){
String employeeid = it_committee2.next();
String score = this.getDataTapstran(screen.getUProfile(), screen.getDataLabel("INTERVIEWFORM"), employeeid, multi.getDataLabel("APPLICANTID"), "apsscore");
String grade = this.getDataTapstran(screen.getUProfile(), screen.getDataLabel("INTERVIEWFORM"), employeeid, multi.getDataLabel("APPLICANTID"), "apsgrade");
if(!grade.equals("")){
grade = "("+new SystemCode().getValue("STATUS_APSGRADE",grade,"tha")+")";
}
if(!score.equals("-")){
num_committee++;
sum_score = sum_score+Double.parseDouble(score);
}
%>
<td align="center" nowrap>
<%
if(!screen.getDataLabel("INTERVIEWFORM").equals("")){
%>
<a href="javascript:goFormReadonly('<%=multi.getDataLabel("APPLICANTID")%>','<%=employeeid%>','<%=screen.getDataLabel("INTERVIEWFORM") %>','1');"><%=score%><%=grade%></a>
<%}else{%>
-
<%}%>
</td>
<%
}
String average_score = "-";
if(num_committee>0){
average_score = df.format(sum_score/num_committee);
}
%>
<td align="center" nowrap><%=average_score%></td>
</tr>
<%
}
%>
<tr>
<td colspan="9"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="8" align="right"> </td>
</tr>
</table>
</div></td>
</tr>
<tr bordercolor="0069B3">
<td align="right"><script language="javascript">printEditCheck('<%=screen.getDataLabel("edit_by")%>','<%=screen.getDataLabel("edit_date")%>','<%=screen.getDataLabel("edit_time")%>','<%=screen.getDataLabel("approve")%>');</script> </td>
</tr>
<tr bordercolor="0069B3">
<td class="bottom"></td>
</tr>
</table>
<script language="javascript">chkInterviewResult();</script>
<!----------BEGIN CSC ENDING ZONE ------------------------>
<%=screen.endJSP()%>
<!----------END CSC ENDING ZONE -------------------------->
</form>
</div>
<%
screen.referLangOff();
%>
</body>
</html>
<%!
private String getDataTapstran(UProfile upf, String apsid, String apsassessor, String apsassessy, String field){
try{
String score = "-";
DbInquiry inq = new InitialInquiry(upf).getDbInquiry("Tapstran", false);
inq.setColumn("apsid,apsassessy,apsassessor,companyid,apsscore,apsgrade");
inq.setFilter("apsid='"+apsid+"' and apsassessor='"+apsassessor+"' and apsassessy='"+apsassessy+"' ");
// System.out.print("filter :: "+inq.getFilter());
inq.refresh();
if(inq.next()){
score = inq.getString(field);
if(score.equals("0.00")){
score = "-";
}
}
return score;
}catch(Exception e){
return "-";
}
}
%>