<%@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.*" %>
<jsp:useBean id="TR010" class="com.csc.library.system.Task" scope="page"/>
<%
TR010.setChannel(request,response);
HelpEntry screen = (HelpEntry) TR010.process("HelpEntry","TR010HELP");
CheckNull chk = new CheckNull();
int maxLine = 20;
int goPage = 1;
try{
goPage = Integer.parseInt(chk.chkNullString(request.getParameter("__goPage"),"1").replace("+","").replace("-",""));
}catch(Exception e){
}
int stop = maxLine * goPage;
int start = stop - (maxLine-1);
screen.setMaxLine(maxLine);
screen.getInquiry().clearOldCondition();
screen.getInquiry().setBetween(start, stop);
screen.getInquiry().setFilter("train_type='1' and resdateto >= '"+new CscCalendar().getYYYYMMDD()+"'");
screen.process();
DbInquiry dbRes = new InitialInquiry(screen.getUProfile()).getDbInquiry("TRESERVER");
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<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 type='text/javascript' src='../JS/SCREEN.js'></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script type='text/javascript' src="../JS/VIEWCALENDAR.js"></script>
<script language="javascript" >
function goPages(trainingid,traineeid,companyid,reserved,crsid){
window.open("TR007_LPN.jsp?__trainingid="+trainingid+"&__traineeid="+traineeid+"&__reserved="+reserved+"&__crsid="+crsid+"&__fixCon=trainingid='"+trainingid+"'","ReservingTraining","left=150,top=1,width=650,height=800,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
function goSearchCon(){
with(document.cscform){
window.open("TRA011_S.jsp","","left=150,top=150,width=600,height=300,toolbar=no,status=yes,scrollbars=no,resizable=no");
}
}
function GoHelpCourse(crsid){
with(document.cscform){
viewCourse(crsid);
}
}
function viewCourse(courseid){
with(document.cscform){
window.open("TRH003_3H.jsp?"+
"&__crsid="+courseid+
"&__companyid="+__companyid.value,"","left=150,top=150,width=600,height=550,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
</script>
<STYLE type=text/css>
FONT.wait {
FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
font-size: 12px;
color: #E85C00;
}
FONT.free {
FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
font-size: 12px;
color: #339900;
}
FONT.stop {
FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
font-size: 12px;
color: #FF0000;
}
</STYLE>
</head>
<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP24.gif','../IMAGES/BUTTON/SWAP/EXIT_SWAP24.gif','../IMAGES/BUTTON/SWAP/HELP_SWAP24.gif','../IMAGES/BUTTON/SWAP/NEW_SWAP24.gif','../IMAGES/BUTTON/SWAP/EDIT_SWAP24.gif','../IMAGES/BUTTON/SWAP/DEL_SWAP24.gif','../IMAGES/BUTTON/SWAP/PROCESS_SWAP24.gif','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<form name="cscform" method="post" action="#">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden"name="__screen" value="TR010">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__calendar">
<input type="hidden" name="__childFilter">
<input type="hidden" name="__goPage">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__user" value="<%=screen.getUProfile().getUserId()%>">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__fixMyPage" value="train_type='1'">
<div align="center" >
<table border="0" cellpadding="0" cellspacing="0" class="largest">
<tr>
<td class="header">TR010,
<script language="javascript">swapLang('Training Reserve');</script></td>
</tr>
<tr>
<td align="right" ><%=screen.getPageTag()%></td>
</tr>
<tr>
<td>
<table class="maxsize tablewithborder" cellpadding="0" cellspacing="1" id="rsTable" name="rsTable" border="0" bgcolor="#333333" cols="12" >
<tr>
<td class="row3" align="center"><a href="javascript:sortTable(0, rsTable);"><script language="JavaScript">swapLang('Reserved')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(1, rsTable);"><%=screen.getLabel("TRAININGID")%></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(2, rsTable);"><%=screen.getLabel("TRTITLE")%></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(3, rsTable);"><script language="JavaScript">swapLang('Course name')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(4, rsTable);"><script language="JavaScript">swapLang('Res Between')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(5, rsTable);"><script language="JavaScript">swapLang('Class Between')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(6, rsTable);"><script language="JavaScript">swapLang('Trainer')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(7, rsTable);"><script language="JavaScript">swapLang('Venue')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(8, rsTable);"><script language="JavaScript">swapLang('Reserve')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(9, rsTable);"><script language="JavaScript">swapLang('Approver')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(10, rsTable);"><script language="JavaScript">swapLang('Limit')</script></a></td>
<td class="row3" align="center"><a href="javascript:sortTable(11, rsTable);"><script language="JavaScript">swapLang('Status')</script></a></td>
</tr>
<%
while(screen.nextRec()){
dbRes.setFilter("reserverid ='"+screen.getUProfile().get("employeeid")+"' and trainingid = '"+screen.getString("TRAININGID")+"'");
dbRes.refresh();
//screen.inq.getCurrentDbRecord().refreshChild("TTRAINTRNER");
%>
<tr>
<td class="inframe" ><div align="center"><input type = "checkbox" name = "<%=screen.getString("TRAININGID")%>" disabled <%=(dbRes.recCount()>0)?"checked":""%> ></div></td>
<td class="inframe" ><div align="center"><a href="javascript:goPages('<%=screen.getString("TRAININGID")%>','<%=screen.getUProfile().getUserId()%>','<%=screen.getString("COMPANYID")%>','<%=(dbRes.recCount()>0)?"true":""%>','<%=screen.getString("CRSID")%>');"><%=screen.getString("TRAININGID")%></a></div></td>
<td class="inframe" ><div align="center"><%=screen.getString("TRTITLE")%></div></td>
<td class="inframe" ><div align="center"><a href="javascript:GoHelpCourse('<%=screen.getString("CRSID")%>');"><%=screen.getString("MCOURSE","CRSEDESC")%></a></div></td>
<%
if(new CscCalendar().afterDate(new CscCalendar(screen.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getYYYYMMDD()))){
%>
<td class="inframe"><div align="center"><font class="warnning"><%=screen.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getDDMMYYYY()%><br><%=screen.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getDDMMYYYY()%></font></div></td>
<%
}else if(new CscCalendar().beforeDate(new CscCalendar(screen.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getYYYYMMDD()))){
%>
<td class="inframe"><div align="center"><font class="wait"><%=screen.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getDDMMYYYY()%><br><%=screen.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getDDMMYYYY()%></font></div></td>
<%
}else{
%>
<td class="inframe"><div align="center"><font class="free"><%=screen.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getDDMMYYYY()%><br><%=screen.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getDDMMYYYY()%></font></div></td>
<%
}
%>
<td class="inframe" nowrap><div align="center"><%=screen.inq.getCurrentDbRecord().getCscCalendar("CLASSDATEFRM").getDDMMYYYY()%><br><%=screen.inq.getCurrentDbRecord().getCscCalendar("CLASSDATETO").getDDMMYYYY()%></div></td>
<td class="inframe" ><div align="center"><%=screen.getString("MTRAINER","FULLNAME")%></div></td>
<td class="inframe" ><div align="center"><%=screen.getString("MTRLOCATION","LOCEDESC")%></div></td>
<td class="inframe" ><div align="center"><%=screen.getString("TOTALRESERVER_RESERV")%></div></td>
<td class="inframe" ><div align="center"><%=screen.getString("TOTALTRAINEE")%></div></td>
<td class="inframe" ><div align="center"><%=screen.getString("QTYVALID")%></div></td>
<td class="inframe"><div align="center"><%=screen.inq.getCurrentDbRecord().getSystemCode("status")%></div></td>
</tr>
<%
}
%>
</table></td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW013168" onClick="goSearchCon();">SEARCH</button>
</div>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td class="bottom"></td>
</tr>
</table>
</div>
</form>
</body>
</html>