<%@ page import="com.csc.library.entry.*,com.csc.library.session.*,com.csc.library.utilities.*,java.util.*" contentType="text/html;charset=UTF-8"%> <jsp:useBean id="REC122" scope="page" class="com.csc.library.system.Task"/> <% REC122.setChannel(request ,response); HelpEntry screen=(HelpEntry) REC122.process("HelpEntry","REC122"); CheckNull chkNull = new CheckNull(); screen.process(); screen.nextRec(); DbInquiry mcom = new InitialInquiry(screen.getUProfile()).getDbInquiry("hcommittee"); DbInquiry empl = new InitialInquiry(screen.getUProfile()).getDbInquiry("memployee"); mcom.putChild(empl); mcom.setColumn("employeeid,companyid,requestid"); mcom.setFilter("requestid='"+chkNull.chkNullString(request.getParameter("__requestid"),request.getParameter("requestid"))+"'"); mcom.refresh(); Map committeeList = new HashMap(); while(mcom.next()){ committeeList.put(mcom.getString("employeeid"),mcom.getString("memployee","fullname")+" ,"+mcom.getString("memployee","positionname")+" ,"+mcom.getString("memployee","tel_ext")+" ,"); } //System.out.println("======================>"+mcom.getString("memployee","fullname")+","+mcom.getString("memployee","positionname")+","+mcom.getString("memployee","tel_ext")+","); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <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='../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 goHelp(helpName,inputName){ var helpReturn; if(inputName=="__newrequestid" ) helpReturn="__newrequestid:requestid"; linkHelp_Return(helpName,helpReturn); } function GoSave(){ with(document.cscform){ if(acknow[0].checked==true){ __applicantstatus.value="1"; __exp_startdate.value= startdate.value; if(__decision[1].checked==true){ __disengage_reason.value="ไม่เหมาะสมในการจ้าง"; } } else{ __disengage_reason.value=reason.value; } bCon=confirm(MyCode[1]); if (bCon==true) { __confirm.value="s"; __cmd.value = "save"; submit(); } } } function disConclusion(){ with(document.cscform){ var tb = document.getElementById("ccTable"); if(acknow[1].checked==true){ tb.disabled=true; tb.style.display="none"; reason.disabled=false; startdate.disabled=true; startdate.value=""; } else{ tb.disabled=false; tb.style.display=""; reason.disabled=true; startdate.disabled=false; reason.value=""; } } } </script> </head> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad=""> <form name="cscform" method="post" action="REC122.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden"name="__screen" value="REC122"> <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="__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="<%=screen.getDataLabel("HAPPLICANT","APPLICANTID")%>"> <script language="javascript">getInputFormatDate();</script> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <br> <table width="100%" cellpadding="0" cellspacing="0" class="normal"> <tr class="header"> <td class="header" align="right">REC122, <script language="javascript">swapLang('Details');</script></td> </tr> <tr > <td colspan="2"> <table cellpadding="0" cellspacing="0" class="maxsize" > <tr> <td align="right" nowrap class="columnlabel"><%=screen.getLabel("REQUESTID")%></td> <td nowrap class="columnData"> <%=screen.getDataLabel("REQUESTID")%></td> </tr> <tr> <td align="right" nowrap class="columnlabel"><%=screen.getLabel("HAPPLICANT","APPLICANTID")%></td> <td nowrap class="columnData"> <%=screen.getDataLabel("HAPPLICANT","APPLICANTID")%></td> </tr> <tr> <td align="right" nowrap class="columnlabel"><%=screen.getLabel("HAPPLICANT","FULLNAME")%></td> <td nowrap class="columnData"> <%=screen.getDataLabel("HAPPLICANT","FULLNAME")%></td> </tr> <tr> <td align="right" nowrap class="columnlabel"><script language="javascript">swapLang('Position');</script></td> <td nowrap class="columnData"> <%=screen.getDataLabel("HAPPLICANT","JOBNAME").equals("")?screen.getDataLabel("HAPPLICANT","FREETEXTJOB") :screen.getDataLabel("HAPPLICANT","JOBNAME")%></td> </tr> <tr> <td align="right" nowrap class="columnlabel"><%=screen.getLabel("DATE_INTERVIEW")%></td> <td nowrap class="columnData"> <%=screen.getDataLabel("DATE_INTERVIEW")%></td> </tr> <tr> <td align="right" nowrap class="columnlabel"><%=screen.getLabel("HAPPLICANT","EXP_STARTDATE")%></td> <td nowrap class="columnData"> <%=screen.getDataLabel("HAPPLICANT","EXP_STARTDATE")%></td> </tr> <% if(screen.inq.recCount()==committeeList.size()){ //check unrecord-score committee %> </table> </td> </tr> <tr><td> <table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2"> <tr bgcolor="#3366CC"> <td width="5%" align="center" nowrap class="row3"><script language="JavaScript">swapLang('No.')</script></td> <td width="85%" align="center" nowrap class="row3"> <script language="JavaScript">swapLang('Details')</script></td> <td width="10%" align="center" nowrap class="row3"> <script language="JavaScript">swapLang('Score')</script></td> </tr> <% DbInquiry dba = new InitialInquiry(screen.getUProfile()).getDbInquiry("hcand_interview1"); DbInquiry dba1 = new InitialInquiry(screen.getUProfile()).getDbInquiry("minterview_assess"); dba.putChild(dba1); dba.setColumn("*"); dba.setFilter("applicantid='"+screen.getDataLabel("applicantid")+"' and companyid='"+screen.getUProfile().get("companyid")+"' and date_interview='"+new CscCalendar(screen.getDataLabel("date_interview")).getYYYYMMDD()+"'"); dba.setOrderBy("assessid,interviewer"); dba.refresh(); int total=0; //System.out.println("=========================>"+dba.recCount()); if(dba.recCount()>0){ if(dba.next()){ String eachTopic =dba.getString("assessid"); String topicDesc = dba.getString("MINTERVIEW_ASSESS","TDESC"); int i =1; int sum=0; do{ if(eachTopic.equalsIgnoreCase(dba.getString("assessid"))){ sum+=Integer.parseInt(dba.getString("score")); } else{%> <tr> <td><div align="center"><%=i++%></div></td> <td><div align="left"><%=topicDesc%></div></td> <td><div align="center"><%=sum%></div></td> </tr><% eachTopic=dba.getString("assessid"); topicDesc = dba.getString("MINTERVIEW_ASSESS","TDESC"); total+=sum; sum=Integer.parseInt(dba.getString("score")); } }while(dba.next()); total+=sum; %> <tr> <td><div align="center"><%=i++%></div></td> <td><div align="left"><%=topicDesc%></div></td> <td><div align="center"><%=sum%></div></td> </tr> <% } } %> <tr> <td colspan="2" align="center"><b><script language="javascript">swapLang('Total Score');</script></b></td> <td align="center"><input name="sumscore" type="text" size="5" readonly class="numeric" value="<%=total%>"></td> </tr></table> </td></tr> <% do{ %> <tr><td> <table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2"> <tr> <td colspan="4" class="row1"><img src="../IMAGES/RED_FOLDER.gif" width="13" height="16"> </td> </tr> <tr> <td width="21%" align="right"><script language="javascript">swapLang('Committee');</script> : </td> <td width="22%"><%=screen.getDataLabel("MEMPLOYEE","FULLNAME")%></td> <td width="30%" align="right"><%=screen.getLabel("RECORD_DATE")%> :</td> <td width="42%"><%=screen.getDataLabel("RECORD_DATE")%></td> </tr> <tr> <td align="right"><%=screen.getLabel("OTHERCOMMENT")%> :</td> <td colspan="3"><%=screen.getDataLabel("OTHERCOMMENT")%></td> </tr> </table> </td></tr> <% }while(screen.nextRec()); }else{ %> </tr> </table> </td> </tr> <tr><td> <table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="2"> <tr> <td colspan="5" align="left"><b><script language="javascript">swapLang('Unrecord Interviewer');</script></b></td> </tr> <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('Employee 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('Position')</script> </td> <td align="center" nowrap class="row3"> <script language="JavaScript">swapLang('Telephone No.')</script> </td> </tr> <% int i=1; do{ if(committeeList.containsKey(screen.getString("INTERVIEWER"))){ committeeList.remove(screen.getString("INTERVIEWER")); } }while(screen.nextRec()); for(Iterator it = committeeList.keySet().iterator(); it.hasNext();){ String empid = it.next().toString(); String info[] = committeeList.get(empid).toString().split(","); %> <tr> <td align="center" nowrap><%=i++%></td> <td align="center" nowrap><%=empid%></td> <td align="center" nowrap><%=info[0]%></td> <td align="center" nowrap><%=info[1]%></td> <td align="center" nowrap><%=info[2]%></td> </tr> <%} %> <tr> <td colspan="9"></td> </tr> </table> </td></tr> <% } %> <tr bordercolor="0069B3"> <td class="bottom"></td> </tr> </table> <!----------BEGIN CSC ENDING ZONE ------------------------> <%=screen.endJSP()%> <!----------END CSC ENDING ZONE --------------------------> </FORM> </body> </html>