<%@page contentType="text/html; charset=UTF-8"%>
<%@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.*" %>
<%@ page import="java.rmi.RemoteException" %>
<jsp:useBean id="TRH011" class="com.csc.library.system.Task" scope="page"/>
<%
TRH011.setChannel(request,response);
UIManager screen = (UIManager) TRH011.process("SingleEntry","TRH011");
screen.referLangOn();
CheckNull chk = new CheckNull();
String isgen = chk.chkNullString(request.getParameter("__isgen"));
String isDelete = chk.chkNullString(request.getParameter("__isDelete"));
if(isgen.equals("1")){
deleteHtraintrnee(screen.getUProfile(),isDelete);
}
%>
<%!
private void deleteHtraintrnee(UProfile up,String isDelete) throws RemoteException {
if (!isDelete.equals("")) {
String[] myRecord = isDelete.split("#");
for (int i = 0; i < myRecord.length; i++) {
String trainingID = myRecord[i].split("@")[0];
String empID = myRecord[i].split("@")[1];
DbRecord recHTraining = new InitialRecord(up).getDbRecord("htraining");
recHTraining.setColumn("*");
recHTraining.set("TRAININGID", trainingID);
recHTraining.set("COMPANYID", up.get("COMPANYID"));
if (recHTraining.search() > 0) {
recHTraining.delete();
}
DbRecord recHTraintrnee = new InitialRecord(up).getDbRecord("HTRAINTRNEE");
recHTraintrnee.setColumn("*");
recHTraintrnee.set("TRAININGID", trainingID);
recHTraintrnee.set("TRAINEEID", empID);
recHTraintrnee.set("COMPANYID", up.get("COMPANYID"));
if (recHTraintrnee.search() > 0) {
recHTraintrnee.delete();
}
}
}
}
%>
<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">
<link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css">
<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script language='javascript' src="../JS/VIEWCALENDAR.js"></script>
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script>
<script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script>
<script language="JavaScript" src="../JS/HOTKEY.js"></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script language="javascript">
function GoSave(){alert(MyCode[150]);}
function GoUpdate(){alert(MyCode[150]);}
function GoDelete(){alert(MyCode[150]);}
function GoClean(){alert(MyCode[150]);}
function GoSearch(){search();}
function childMulti(record){
with(document.cscform){
window.open(__childMulti.value+".jsp?__cmd=&__gorec="+record+
"&__ack=edit&__employeeid="+__employeeid.value+
"&__headMulti="+__headMulti.value+
"&__companyid="+__companyid.value,"","width=600,height=300");
}
}
function addMulti(){
with(document.cscform){
if(notBlankOnThisPage()){
window.open(/*__childMulti.value+*/"TRH011_A.jsp?__cmd=&__gorec=&__ack=add"+
"&__employeeid="+__employeeid.value+
"&__headMulti="+__headMulti.value+
"&__companyid="+__companyid.value,"Trainee","left=150,top=150,width=680,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
}
function deleteMulti(){
with(document.cscform){
bCon=confirm(MyCode[4]);
if (bCon==true) {
mframe.document.cscform.__cmd.value="DelChild";
mframe.document.cscform.submit();
}
}
}
function checkAll(){
with(mframe.document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox")
elements[i].checked=true;
}
}
}
function decheckAll(){
with(mframe.document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox")
elements[i].checked=false;
}
}
}
function viewTraining(trainingid){
with(document.cscform){
/*window.open("TRH003_6H.jsp?"+
"__fixCon=trainingid='"+trainingid+
"'&__trainingid="+trainingid+
"&__companyid="+__companyid.value,"viewTraining","left=150,top=150,width=680,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes");*/
var tempAction = action;
var tempTarget = target;
var tempHelp = __help.value;
var tempCmd=__cmd.value;
action="TRE005_PHATRA.jsp";
__help.value="__trainingid$"+trainingid+";__companyid$100;";
__cmd.value="search";
submit();
action=tempAction;
target=tempTarget;
__help.value=tempHelp ;
__cmd.value=tempCmd;
}
}
function viewTrainingTime(trainingid,crsid){
with(document.cscform){
window.open("TRH011_T.jsp?"+
"__fixCon=trainingid='"+trainingid+
"'&__trainingid="+trainingid+
"&__crsid="+crsid+
"&__companyid="+__companyid.value,"viewTrainingTime","left=150,top=150,width=680,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function checkAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox") {
elements[i].checked=true;
}
}
}
}
function decheckAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox") {
elements[i].checked=false;
}
}
}
}
function delMulti(){
with(document.cscform){
var tmpValue = "";
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox") {
if(elements[i].checked==true){
tmpValue += elements[i].name+"#";
}
}
}
if(tmpValue != "") {
bCon=confirm(MyCode[4]);
if (bCon==true) {
__isgen.value = "1";
__isDelete.value = tmpValue;
submit();
}
}else{
}
}
}
function goPreview(fName){
window.open("../FileDownload.jsp?uploadfield=htraintrnee.certificate&filename="+fName);
}
</script>
</head>
<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif')" ><div class="centered">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="TRH011.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input name="__cmd" type="hidden" value="">
<input type="hidden" name="__calendar">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__screen" value="TRH011">
<input type="hidden" name="__multiTable" value="">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__childMulti" value="TRE002_2">
<input type="hidden" name="__gorec" value="">
<input type="hidden" name="__ack" value="">
<input type="hidden" name ="__headMulti" value="TRE002">
<input name="__companyid" type="hidden" value="<%=screen.getUProfile().get("companyid")%>">
<input name="__fixCon" type="hidden" value="">
<input name="__notNull" type="hidden" value="<%=screen.getRequire()%>">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__isDelete" value="">
<input type="hidden" name="__isgen" value="0">
<div align="center">
<table cellpadding="0" cellspacing="0" class = "largest" colspan="2">
<tr >
<td class="header" colspan="2">TRH011,
<script language='javascript'>swapLang('Training History by trainee');</script> </td>
</tr>
<tr >
<td colspan="2">
<div align="center">
<table cellspacing="0" cellpadding="0" class = "largest" colspan="2">
<tr>
<td class="blankspace" colspan="2"></td>
</tr>
<%
if(request.getParameter("viewonly") == null){
%>
<tr>
<td align = "right" width = "20%"><%=screen.getLabel("EMPLOYEEID")%> </td>
<td align = "left" width = "80%"> <%=screen.getInput("EMPLOYEEID")%></td>
</tr>
<%
}else{
%>
<tr>
<td align = "right" width = "20%"><%=screen.getLabel("EMPLOYEEID")%> </td>
<td align = "left" width = "80%"> <%=screen.getDataLabel("EMPLOYEEID")%></td>
</tr>
<%
}
if(!screen.getDataLabel("EMPLOYEEID").equals("")){
screen.referLangOff();
%>
<tr>
<td align = "right"><%=screen.getLabel("FNAME")%> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("MPREFIX","TDESC")%> <%=screen.getDataLabel("FNAME")%> <%=screen.getDataLabel("LNAME")%></font></td>
</tr>
<tr>
<td align = "right"><%=screen.getLabel("EFNAME")%> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("MPREFIX","EDESC")%> <%=screen.getDataLabel("EFNAME")%> <%=screen.getDataLabel("ELNAME")%></font></td>
</tr>
<%screen.referLangOn();%>
<tr>
<td align = "right"><script language='javascript'>swapLang('Position');</script> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("EMP_POSITION")%> : <%=screen.getDataLabel("MPOSITION","TDESC")%></font></td>
</tr>
<%if(!screen.getDataLabel("MJOBCODE","TDESC").equals("")){%>
<tr>
<td align = "right"><script language='javascript'>swapLang('Job Description');</script> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("JOB")%> : <%=screen.getDataLabel("MJOBCODE","TDESC")%></font></td>
</tr>
<%}if(!screen.getDataLabel("MGROUP","TDESC").equals("")){%>
<tr>
<td align = "right"><%=screen.getLabel("EMP_GROUP")%> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("EMP_GROUP")%> : <%=screen.getDataLabel("MGROUP","TDESC")%></font></td>
</tr>
<%}%>
<tr>
<td align = "right"><span swlang code="BU1">Division</span><!-- <script language='javascript'>swapLang('BU1');</script> --> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("BU1")%> : <%=screen.getDataLabel("MBU1","TDESC")%></font></td>
</tr>
<%if(!screen.getDataLabel("MBU2","TDESC").equals("")){%>
<tr>
<td align = "right"><%=screen.getLabel("BU2")%> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("BU2")%> : <%=screen.getDataLabel("MBU2","TDESC")%></font></td>
</tr>
<%}if(!screen.getDataLabel("MBU3","TDESC").equals("")){%>
<tr>
<td align = "right"><%=screen.getLabel("BU3")%> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("BU3")%> : <%=screen.getDataLabel("MBU3","TDESC")%></font></td>
</tr>
<%}if(!screen.getDataLabel("MBU4","TDESC").equals("")){%>
<tr>
<td align = "right"><%=screen.getLabel("BU4")%> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("BU4")%> : <%=screen.getDataLabel("MBU4","TDESC")%></font></td>
</tr>
<%}if(!screen.getDataLabel("MBU5","TDESC").equals("")){%>
<tr>
<td align = "right"><%=screen.getLabel("BU5")%> </td>
<td align = "left"><font class = "normal"> <%=screen.getDataLabel("BU5")%> : <%=screen.getDataLabel("MBU5","TDESC")%></font></td>
</tr>
<%}
}
%>
<tr>
<td class="inframe" colspan="2"></td>
</tr>
</table>
</div>
</td>
</tr>
<tr >
<td colspan="2">
<div align="center">
<table border="1" cellpadding="0" cellspacing="1" id="rsTable" name="rsTable" bgcolor="#333333" class="largest tablewithborder" cols="9">
<tr>
<td width="3%" class="row3"><a href="javascript:sortTable(0, rsTable);"><div align="center"> <script language='javascript'>swapLang('Del');</script></div></a></td>
<td width="5%" class="row3"><a href="javascript:sortTable(1, rsTable);"><div align="center"> <script language='javascript'>swapLang('Seq no');</script></div></a></td>
<td width="9%" class="row3"><a href="javascript:sortTable(2, rsTable);"><div align="center"> <%=screen.getLabel("HTRAINING","CRSID")%></div></a></td>
<td width="24%" class="row3"><a href="javascript:sortTable(3, rsTable);"><div align="center"><span swlang code="SW000653">Course</span> <!-- <script language='javascript'>swapLang('Course');</script> --></div></a></td>
<td width="10%" class="row3"><a href="javascript:sortTable(4, rsTable);"><div align="center"> <%=screen.getLabel("HTRAINING","TRAININGID")%></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(5, rsTable);"><div align="center"> <%=screen.getLabel("HTRAINING","TRTITLE")%></div></a></td>
<td width="8%" class="row3"><a href="javascript:sortTable(6, rsTable);"><div align="center"> <script language='javascript'>swapLang('Start date');</script></div></a></td>
<td width="8%" class="row3"><a href="javascript:sortTable(7, rsTable);"><div align="center"> <script language='javascript'>swapLang('End date');</script></div></a></td>
<%--<td width="15%" class="row3"><a href="javascript:sortTable(17, rsTable);"><div align="center"> <%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"วันที่อบรมซ้ำ":"Re-current Date"%></div></a></td>--%>
<td width="7%" class="row3"><a href="javascript:sortTable(8, rsTable);"><div align="center"> <script language='javascript'>swapLang('Training Type');</script></div></a></td>
<td width="7%" class="row3"><a href="javascript:sortTable(9, rsTable);"><div align="center"> <script language='javascript'>swapLang('Training Place');</script></div></a></td>
<td width="10%" class="row3"><a href="javascript:sortTable(10, rsTable);"><div align="center"> <%=screen.getLabel("HTRAINING","COUNTRYT")%></div></a></td>
<td width="10%" class="row3"><a href="javascript:sortTable(11, rsTable);"><div align="center"> <script language='javascript'>swapLang('Training result');</script></div></a></td>
<td width="9%" class="row3"><a href="javascript:sortTable(12, rsTable);"><div align="center"> <script language='javascript'>swapLang('Training Time');</script></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(13, rsTable);"><div align="center"> <span swlang code='SW013251'>Actual</span></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(14, rsTable);"><div align="center"> <lable swlang code ="SW013292">Bond Expense</lable></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(18, rsTable);"><div align="center"> <script language='javascript'>swapLang('Start Date');</script></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(19, rsTable);"><div align="center"> <script language='javascript'>swapLang('End Date');</script></div></a></td>
<td width="20%" class="row3"><a href="javascript:sortTable(15, rsTable);"><div align="center"> <script language='javascript'>swapLang('Duration');</script></div></a></td>
<td width="20%" class="row3"><a href="javascript:sortTable(16, rsTable);"><div align="center"> <script language='javascript'>swapLang('Duration Every');</script></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(20, rsTable);"><div align="center"> <script language='javascript'>swapLang('Status');</script></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(21, rsTable);"><div align="center"> <%=screen.getLabel("HTRAINING","REVIEW")%></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(22, rsTable);"><div align="center"> <script language='javascript'>swapLang('Report');</script></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(23, rsTable);"><div align="center"> <script language='javascript'>swapLang('Training Duration');</script></div></a></td>
<td width="15%" class="row3"><a href="javascript:sortTable(24, rsTable);"><div align="center"> <script language='javascript'>swapLang('Certificates');</script></div></a></td>
</tr>
<%
int count = 1;
DbInquiry dba=(DbInquiry) screen.getRecord().getChild("HTRAINTRNEE");
dba.clearChild();
if(dba.recCount()>0){
CscCalendar date = new CscCalendar("");
dba.refresh();
while(dba.next()){
%>
<tr>
<td class="inframe"><div align="center"><input type="checkbox" id="" name="<%=dba.getString("TRAININGID")%>@<%=dba.getString("HTRAINTRNEE","TRAINEEID")%>" ></div></td>
<td class="inframe"><div align="center"><%=count%></div></td>
<td class="inframe"><div align="center"><%=dba.getString("HTRAINING","CRSID")%></div></td>
<td class="inframe"><div align="left"> <%=dba.getString("MCOURSE","CRSDESC")%></div></td>
<td class="inframe"><div align="center"><a href="javascript:viewTraining('<%=dba.getString("TRAININGID")%>');"><%=dba.getString("TRAININGID")%></a></div></td>
<td class="inframe"><div align="left"> <%=dba.getString("HTRAINING","TRTITLE")%></div></td>
<%date.setDate(dba.getString("HTRAINING","CLASSDATEFRM"));%>
<td class="inframe"><div align="center"> <%=date.getDDMMYYYY()%></div></td>
<%date.setDate(dba.getString("HTRAINING","CLASSDATETO"));%>
<td class="inframe"><div align="center"> <%=date.getDDMMYYYY()%></div></td>
<%--<td class="inframe"><div align="center"> <%=dba.getString("HTRAINING","RDO_RECURRENT").equals("1")?dba.getString("HTRAINING","RECURRENT_STARTDATE"):""%></div></td>--%>
<td class="inframe"><div align="center"><%=dba.getCurrentDbRecord().getSystemCode("MTRAINTYPE","TRAIN_TYPE")%></div></td>
<td class="inframe"><div align="center"><%=dba.getString("HTRAINING","locid")%></div></td>
<td class="inframe"><div align="center"><%=dba.getString("HTRAINING","COUNTRYT")%></div></td>
<td class="inframe"><div align="center"><%=dba.getCurrentDbRecord().getSystemCode("MTRAINSTAT","TRSUCCESS")%><%//=(!dba.getString("TRSTATID").equals(""))?dba.getCurrentDbRecord().getSystemCode("MTRAINSTAT","TRSUCCESS"):""%><%//=dba.getCurrentDbRecord().getSystemCode("MTRAINSTAT","TRSUCCESS")%></div></td>
<td class="inframe"><div align="center"><button type="button" class="btn btn-primary width100" swlang code="SW000599" onClick="viewTrainingTime('<%=dba.getString("TRAININGID")%>','<%=dba.getString("HTRAINING","CRSID")%>');">CHECK</button></div></td>
<td class="inframe"><div align="center"><%=dba.getString("HTRAINING","BUDUSED")%></div></td>
<%if(!dba.getString("HTRAINING","is_external").equals("1")){%>
<td class="inframe"><div align="center"> <%=dba.getString("MCOURSE","EXPENSE")%></div></td>
<td class="inframe"><div align="center"> <%=date.getDDMMYYYY()%></div></td>
<%
CscCalendar classdatefrm = new CscCalendar(dba.getString("HTRAINING","CLASSDATEFRM"));
classdatefrm.incDate(new CheckNull().chkNullStringToInt(dba.getString("MCOURSE","EXPENSES_DURATION")));
%>
<td class="inframe"><div align="center"> <%=classdatefrm.getDDMMYYYY()%></div></td>
<td class="inframe"><div align="center"> <%=dba.getString("MCOURSE","EXPENSES_DURATION")%></div></td>
<td class="inframe"><div align="center"> <%=dba.getCurrentDbRecord().getSystemCode("MCOURSE","EXPENSES_EVERY")%></div></td>
<%
CscCalendar now = new CscCalendar();
CscCalendar endDate = new CscCalendar(dba.getString("MCOURSE","EXPENSES_ENDDATE"));
%>
<td class="inframe"><div align="center"> <%=now.afterDate(endDate)?"Without_Bond_Expense"
:"Without_Bond_Expense"%></div></td>
<%}else{%>
<td class="inframe"><div align="center"> <%=dba.getString("HTRAINING","EXPENSE")%></div></td>
<td class="inframe"><div align="center"> <%=dba.getString("HTRAINING","EXPENSES_DURATION")%></div></td>
<td class="inframe"><div align="center"> <%=dba.getCurrentDbRecord().getSystemCode("HTRAINING","EXPENSES_EVERY")%></div></td>
<td class="inframe"><div align="center"> <%=dba.getString("HTRAINING","RDO_RECURRENT").equals("1")?dba.getString("HTRAINING","RECURRENT_STARTDATE"):""%></div></td>
<td class="inframe"><div align="center"> <%=dba.getString("HTRAINING","EXPENSES_STARTDATE")%></div></td>
<td class="inframe"><div align="center"> <%=dba.getString("HTRAINING","EXPENSES_ENDDATE")%></div></td>
<td class="inframe"><div align="center"> <%=dba.getCurrentDbRecord().getSystemCode("HTRAINING","EXPENSES_STATUS")%></div></td>
<%}%>
<td class="inframe"><div align="center"><%=dba.getString("HTRAINING","REVIEW")%></div></td>
<td class="inframe"><div align="center"> <%=dba.getString("ISREPORT").equals("")?"":dba.getCurrentDbRecord().getSystemCode("ISREPORT")%></div></td>
<td class="inframe"><div align="center"><%=dba.getString("HTRAINING","DURATION")%></div></td>
<td class="inframe"><div align="center">
<%
if(!dba.getString("HTRAINTRNEE","CERTIFICATE").equals("")) {
%>
<a href="javascript:goPreview('<%=dba.getString("HTRAINTRNEE","CERTIFICATE")%>')"><img src="../IMAGES/BUTTON/MAIN/DOWNLOAD24.gif" alt="download" width="24" height="24" border="0"></a>
<%
}
%>
</div></td>
</tr>
<%
count++;
}
}
%>
</table>
</div>
</td>
</tr>
<tr>
<td class="blankspace" colspan="2"></td>
</tr>
<%if(!screen.getDataLabel("EMPLOYEEID").equals("0")){%>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW013163" onClick="checkAll();">Select All</button>
<button type="button" class="btn btn-primary width100" swlang code="SW013164" onClick="decheckAll();">Deselect All</button>
<button type="button" class="btn btn-primary width100" swlang code="SW013165" onClick="addMulti();">Add</button>
<button type="button" class="btn btn-primary width100" swlang code="SW013166" onClick="delMulti();">Delete</button>
</div>
</td>
</tr>
<%}%>
<tr>
<td class="blankspace" colspan="2"></td>
</tr>
<tr >
<td class="bottom"></td>
</tr>
</table>
</div>
<!----------BEGIN CSC ENDING ZONE ------------------------>
<%=screen.endJSP()%>
<!----------END CSC ENDING ZONE -------------------------->
</form>
<%
screen.referLangOff();
%>
</body>
</html>