<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %>
<%@ include file="../CHECKPROFILE.jsp" %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="REV009" scope="page" class="com.csc.library.system.Task"/>
<jsp:setProperty name="REV009" property="appname" value="empview" />
<%
REV009.setChannel(request ,response);
HelpEntry screen=(HelpEntry) REV009.process("HelpEntry","REV009HELP");
screen.process();
screen.nextRec();
CheckNull chkNull = new CheckNull();
%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" ng-app="myHR">
<head>
<title>Requisition Details</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" href="<%=request.getContextPath()%>/CSS/font-awesome.css">
<link rel="stylesheet" type="text/css" href="../CSS/Bootstrap/css/bootstrap.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMPVIEW_LAYOUT.min.css" />
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type="text/javascript" src="../JS/UTILITIES.js"></script>
<script type="text/javascript" src="../JS/DDMENU.js"></script>
<script type="text/javascript"src="../JS/EVENTS.js"></script>
<script type="text/javascript"src="../JS/ACTIVE_OBJECT.js"></script>
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script src='../JS/EMPLOYEE.js'></script>
<script src='../JS/DATEINPUT.js'></script>
<script src='../JS/VIEWCALENDAR.js'></script>
<script src='../JS/ICONSMENU.js'></script>
<script src='../JS/HOTKEY.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>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script>getTitleName();</script>
<script type="text/JavaScript">
function toolTip(){}
</script>
</head>
<body>
<div class="bg-com"></div>
<div class="container csc-content">
<form name="cscform" class="form-horizontal" method="post" action="">
<%=screen.InitialVariable()%>
<input type="hidden"name="__screen" value="REV009">
<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("MAPPLICANT","APPLICANTID")%>">
<input type="hidden" name="aname" value="<%=screen.getDataLabel("MAPPLICANT","FNAME")%> <%=screen.getDataLabel("MAPPLICANT","LNAME")%>">
<input type="hidden" name="mail" value="<%=screen.getDataLabel("MAPPLICANT","EMAIL")%>">
<input type="hidden" name="__disengage_reason">
<input name="from" type="hidden" value='<%=screen.getUProfile().get("email")%>'>
<input type="hidden" name="__calendar">
<input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>">
<script>getInputFormatDate();</script>
<script>setPageTitle(swap2String('Interview Score'));</script>
<div class="csc-block-white">
<div class="container csc-content">
<div class="center">
<h4 swlang code='SW002168'>Interview Score</h4>
</div>
<table class="table table-head table-hover table-bordered table-title-left table-left table-fixed">
<tr>
<th class="table-title" colspan="4" swlang code='SW002172'>Details</th>
</tr>
<tr>
<th><%=screen.getLabel("REQUESTID")%></th>
<td><%=screen.getDataLabel("REQUESTID")%></td>
<th><%=screen.getLabel("MAPPLICANT","FULLNAME")%></th>
<td><%=screen.getDataLabel("MAPPLICANT","FULLNAME")%></td>
</tr>
<tr>
<th><%=screen.getLabel("MAPPLICANT","APPLICANTID")%></th>
<td><%=screen.getDataLabel("MAPPLICANT","APPLICANTID")%></td>
<th swlang code='SW000057'>Position</th>
<td><%=screen.getDataLabel("MAPPLICANT","JOBNAME").equals("")?screen.getDataLabel("MAPPLICANT","FREETEXTJOB") :screen.getDataLabel("MAPPLICANT","JOBNAME")%></td>
</tr>
<tr>
<th><%=screen.getLabel("DATE_INTERVIEW")%></th>
<td><%=screen.getDataLabel("DATE_INTERVIEW")%></td>
<th><%=screen.getLabel("MAPPLICANT","EXP_STARTDATE")%></th>
<td><%=screen.getDataLabel("MAPPLICANT","EXP_STARTDATE")%></td>
</tr>
</table>
<table class="table table-head table-hover table-bordered table-title-left">
<thead>
<tr>
<th class="table-title" colspan="3" swlang code='SW002168'>Interview Score</th>
</tr>
<tr>
<th swlang code='SW001393'>No.</th>
<th swlang code='SW002172'>Details</th>
<th swlang code='SW000013'>Score</th>
</tr>
</thead>
<tbody>
<%
DbInquiry dba = new InitialInquiry(screen.getUProfile()).getDbInquiry("mcand_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();
float 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;
float sum=0;
do{
if(eachTopic.equalsIgnoreCase(dba.getString("assessid"))){
sum+=Float.parseFloat(dba.getString("score"));
}
else{
%>
<tr>
<td><center><%=i++%></center></td>
<td><%=topicDesc%></td>
<td class="trash"><%=sum%></td>
</tr>
<%
eachTopic=dba.getString("assessid");
topicDesc = dba.getString("MINTERVIEW_ASSESS","TDESC");
total+=sum;
sum=Float.parseFloat(dba.getString("score"));
}
}while(dba.next());
total+=sum;
%>
<tr>
<td><center><%=i++%></center></td>
<td><%=topicDesc%></td>
<td class="trash"><%=sum%></td>
</tr>
<%
}
}
%>
<tr>
<td class="result-right" colspan="2" swlang code='SW005586'>Total Score</td>
<td class="result-right" name="sumscore"><%=total%></td>
</tr>
<%
do{
%>
<tr>
<td class="result-right" colspan="2"><%=screen.getLabel("RECORD_DATE")%> </td>
<td class="result"><center><%=screen.getDataLabel("RECORD_DATE")%></center></td>
</tr>
<tr>
<td class="result-right" colspan="2" swlang code='SW004819'>Committee</td>
<td class="result"><%=screen.getDataLabel("MEMPLOYEE","FULLNAME")%></td>
</tr>
<tr>
<td class="result-right" colspan="2"><%=screen.getLabel("OTHERCOMMENT")%> </td>
<td class="result"><%=screen.getDataLabel("OTHERCOMMENT")%></td>
</tr>
<%
}while(screen.nextRec());
%>
</tbody>
</table>
<div class="center">
<a href="javascript:close();" swlang code='SW012104' class="btn btn-primary">Close</a>
</div>
</div>
</div>
<%=screen.endJSP()%>
</form>
</div>
</body>
</html>