<%@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="TRA011E" class="com.csc.library.system.Task" scope="page"/>
<%
TRA011E.setChannel(request,response);
HelpEntry screen = (HelpEntry) TRA011E.process("HelpEntry","TRA011HELP");
screen.referLangOff();
CheckNull chk=new CheckNull();
String fixcon=chk.chkNullString(request.getParameter("__fixCon"));
String fixconChild=chk.chkNullString(request.getParameter("__childFilter"));
if(fixconChild.length()>0){
screen.getInquiry().setAllRequiredFound(true);
}
String refreshFlag=chk.chkNullString(request.getParameter("__refresh"));
screen.process();
%>
<!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">
<script type='text/javascript' src='../JS/MISC.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 GoSave(){confirmSave();}
function GoUpdate(){update();}
function GoDelete(){edelete();}
function GoSearch(){search();}
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
function goHelp(helpName,inputName){
var helpReturn;
if(inputName=="__crstyid" )
helpReturn="__crstyid:crstyid,MCOURSETYPE@CRSTYDESC";
if(inputName=="__crsid" )
helpReturn="__crsid:crsid,MCOURSE@CRSDESC";
if(inputName=="__trtyid" )
helpReturn="__trtyid:trtyid,MTRAINTYPE@TRTYDESC";
if(inputName=="__instid" )
helpReturn="__instid:instid,MACADEMY@INSTDESC";
if(inputName=="__locid" )
helpReturn="__locid:locid,MTRLOCATION@LOCDESC";
if(inputName=="__roomid" )
helpReturn="__roomid:roomid,MTRROOM@ROOMDESC";
if(inputName=="__trainerid" )
helpReturn="__trainerid:trainerid,MTRAINER@TRFNAME";
linkHelp_Return(helpName,helpReturn);
}
function chkFixCon(){
with(document.cscform){
var data=(__fixCon.value.length>0)?" and ":"";
return data;
}
}
function cheeckcrstyid(){
with(document.cscform){
var data="";
if(__crstyid.value!=""){
//data=";mcourse:crstyid='"+__crstyid.value+"'";
//data=chkFixCon();
data="mcourse:crstyid='"+__crstyid.value+"';";
}
return data;
}
}
function cheeckcrsid(){
with(document.cscform){
var data="";
if(__crsid.value!=""){
data=chkFixCon();
data+=" crsid='"+__crsid.value+"' ";
}
return data;
}
}
function cheeckinstid(){
with(document.cscform){
var data="";
if(__instid.value!=""){
data=chkFixCon();
data+=" instid='"+__instid.value+"' ";
}
return data;
}
}
/*function cheeckcreatedate(){
with(document.cscform){
var data="";
if(__createdate.value!=""){
data=" and year('"+__createdate.value+"')between year(resdatefrm)and year(resdateto)";
}
return data;
}
}*/
function chkDateTime3(valueSearch){ // 23/03/2004
var tmpval="";
with(document.cscform){
// tmpval=valueSearch.substring(2,3);
var valueSearch1=valueSearch.split("-");
if(valueSearch1.length==3){
if(valueSearch1[1].length==1){
valueSearch1[1]="0"+valueSearch1[1];
}
if(valueSearch1[0].length==1){
valueSearch1[0]="0"+valueSearch1[0];
}
valueSearch1[2]=parseInt(valueSearch1[2]);
return valueSearch=valueSearch1[2]+"-"+valueSearch1[1]+"-"+valueSearch1[0];
}
}
}
function cheeckcreatedate(fixcon){
with(document.cscform){
var data="";
if(startdate.value!=""&&enddate.value!=""){
data=chkFixCon();
data+=" ( resdatefrm between '"+chkDateTime3(startdate.value)+"' and '"+chkDateTime3(enddate.value)+"') and (resdateto between '"+chkDateTime3(startdate.value)+"' and '"+chkDateTime3(enddate.value)+"')";
}
return data;
}
}
function cheecktrtyid(){
with(document.cscform){
var data="";
if(__trtyid.value!=""){
//data=";mtraintype:trtyid='"+__trtyid.value+"'";
//data=chkFixCon();
//data+=" trtyid='"+__trtyid.value+"' ";
data="mtraintype:trtyid='"+__trtyid.value+"';";
}
return data;
}
}
function cheecklocid(){
with(document.cscform){
var data="";
if(__locid.value!=""){
//data=";mtrlocation:locid='"+__locid.value+"'";
data=chkFixCon();
data+=" locid='"+__locid.value+"' ";
}
return data;
}
}
function cheecktrainerid(){
with(document.cscform){
var data="";
if(__trainerid.value!=""){
//data=";ttraintrner:trainerid='"+__trainerid.value+"'";
data="ttraintrner:trainerid='"+__trainerid.value+"';";
}
return data;
}
}
/*function cheeckValueSearch(){
with(document.cscform){
var data="";
if(ValueSearch.value!=""){
data=" and (crsid like '%"+ValueSearch.value+"%' or crsdesc like '%"+ValueSearch.value+"%' or trainerid like '%"+ValueSearch.value+"%'";
data+=" or trefname like '%"+ValueSearch.value+"%' or trelname like '%"+ValueSearch.value+"%')";
// or locedesc like '%"+ValueSearch.value+"%')";
}
return data;
}
}*/
function clearForm(){
document.cscform.reset();
}
function SearchTraining(){
document.cscform.__fixCon.value=cheeckcrsid();
document.cscform.__fixCon.value+=cheeckinstid();
document.cscform.__fixCon.value+=cheeckcreatedate(document.cscform.__fixCon.value);
document.cscform.__fixCon.value+=cheecklocid();
var fixcon=document.cscform.__fixCon.value;
document.cscform.__fixCon.value="";
//alert(fixcon);
var childFilter=cheecktrainerid();
childFilter+=cheeckcrstyid()
childFilter+=cheecktrtyid();
document.mframe1.document.forms[0].__fixCon.value= fixcon;
document.mframe1.document.forms[0].__childFilter.value=childFilter;
document.mframe1.document.forms[0].submit();
//**** old ****
//var fixcon=cheeckcrsid()+cheeckinstid();//+cheeckValueSearch();
//var childFilter=cheeckcreatedate(fixcon)+cheeckcrstyid()+cheecktrtyid()+cheecklocid()+cheecktrainerid();
//fixcon+=childFilter;
//alert(childFilter);
//var newfixCon=fixcon.substring(4,fixcon.length);
//var newchildFilter=childFilter.substring(1,childFilter.length);
// alert(newfixCon);
// alert(Trim(newchildFilter));
//document.mframe1.document.forms[0].__fixCon.value= fixcon; //newfixCon;
//document.mframe1.document.forms[0].__childFilter.value=Trim(childFilter);
//document.mframe1.document.forms[0].submit();
//*****
}
function goSearchCon(){
with(document.cscform){
window.open("TRSTRA011.jsp","Search","left=150,top=150,width=600,height=300,toolbar=no,status=yes,scrollbars=no,resizable=no");
}
}
function goPages(trainingid,companyid){
with(document.cscform){
__help.value="__trainingid#"+trainingid;
action="TRE004.jsp";//+"&__trainingid="+trainingid;
submit();
}
}
function GoHelpCourse(trainingid,crsid,companyid){
with(document.cscform){
__help.value="__trainingid#"+trainingid+";__crsid#"+crsid+";__companyid#"+companyid;
action="TRA018.jsp?__backpage ="+__backpage.value;
submit();
}
// window.open("TRA018.jsp?__fixCon=trainingid='"+trainingid+"' and crsid='"+crsid+"' and companyid='"+companyid+"'","CourseDetail","left=150,top=150,width=700,height=280,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
function GoHelpTrainer(trainerid,companyid){
with(document.cscform){
__help.value="__trainerid#"+trainerid;//+",__companyid#"+companyid;
// __fixCon.value="trainerid='"+trainerid+"' and companyid='"+companyid+"'";
action="TRA019.jsp?__backpage ="+__backpage.value;
submit();
}
// window.open("TRA018.jsp?__fixCon=trainingid='"+trainingid+"' and crsid='"+crsid+"' and companyid='"+companyid+"'","CourseDetail","left=150,top=150,width=700,height=280,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
function GoHelpLocation(locid,trainingid,companyid){
with(document.cscform){
__help.value="__trainingid#"+trainingid;//+",__companyid#"+companyid;
__fixCon.value="locid='"+locid+"'";
action="TRA020.jsp?__backpage ="+__backpage.value;
submit();
}
// window.open("TRA018.jsp?__fixCon=trainingid='"+trainingid+"' and crsid='"+crsid+"' and companyid='"+companyid+"'","CourseDetail","left=150,top=150,width=700,height=280,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
function GoHelp1(trainingid,companyid){
with(document.cscform){
__help.value="__trainingid#"+trainingid;//+",__companyid#"+companyid;
action="TRA021.jsp?__backpage ="+__backpage.value;
submit();
}
}
function GoHelpApprove(trainingid,companyid){
with(document.cscform){
__help.value="__trainingid#"+trainingid;//+",__companyid#"+companyid;
action="TRA0212.jsp?__backpage ="+__backpage.value;
submit();
}
}
</script>
</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','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="#">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<%//=screen.getTagConfirm()%>
<!--script language="javascript">checkConfirm();</script-->
<input type="hidden"name="__screen" value="TRA011E">
<input name="__fixCon" type="hidden" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__cmd" value="">
<input type = "hidden" name = "__backpage" value = "TRA011E.jsp">
<input type="hidden" name="__calendar">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<!--input name="__notNull" type="hidden" value="<%//=screen.getRequire()%>"-->
<input type="hidden" name="__user" value="<%=screen.getUProfile().getUserId()%>">
<input name="__companyid" type="hidden" value="<%=screen.getUProfile().get("companyid")%>">
<table border="0" cellspacing="0" cellpadding="0" class="largest" >
<tr>
<td class="header">TRA011C, <script language="javascript">swapLang('Approve Reserver');</script> </td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="1" id="rsTable" name="rsTable" bgcolor="#333333" class="maxsize" cols="11">
<tr >
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(0, rsTable);"><%=screen.getLabel("CRSID")%></a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(1, rsTable);"><script language="javascript">swapLang('Course Name');</script></a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(2, rsTable);"><%=screen.getLabel("TRAININGID")%></a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(3, rsTable);"><%=screen.getLabel("TRTITLE")%></a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(4, rsTable);">
<script language="javascript">swapLang('Date Between');</script></a>
</div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(5, rsTable);"><script language="javascript">swapLang('Trainer');</script></a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(6, rsTable);"><script language="javascript">swapLang('Location');</script></a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(7, rsTable);">
<script language="JavaScript">swapLang('Reserve')</script>
</a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(8, rsTable);"><script language="JavaScript">swapLang('Approver')</script></a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(9, rsTable);"><script language="JavaScript">swapLang('Quantity')</script></a></div></td>
<td nowrap class="row3"><div align="center"><a href="javascript:sortTable(10,rsTable);"><script language="javascript">swapLang('Status');</script></a></div></td>
</tr>
<%while(screen.nextRec()){
screen.referLangOn();
%>
<tr>
<td class="inframe" align = "center"><a href="javascript:GoHelpCourse('<%=screen.getString("TRAININGID")%>','<%=screen.getString("CRSID")%>','<%=screen.getString("COMPANYID")%>');"><%=screen.getString("CRSID")%></a></td>
<td class="inframe" align = "left"><!--a href="javascript:GoHelpCourse('<%//=screen.getString("TRAININGID")%>','<%//=screen.getString("CRSID")%>','<%//=screen.getString("COMPANYID")%>');"--> <%=screen.getString("MCOURSE","CRSEDESC")%><!--/a--></td>
<td nowrap class="inframe">
<div align="center">
<a href="javascript:goPages('<%=screen.getString("TRAININGID")%>','<%=screen.getString("COMPANYID")%>');"><%=screen.getString("TRAININGID")%></a>
</div>
</td>
<td class="inframe"><div align="left"> <%=screen.getString("TRTITLE")%></div></td>
<td nowrap class="inframe"><div align="center"><%=screen.inq.getCurrentDbRecord().getCscCalendar("RESDATEFRM").getDDMMYYYY()%><br><%=screen.inq.getCurrentDbRecord().getCscCalendar("RESDATETO").getDDMMYYYY()%></div></td>
<!--td class="forborder"><div align="center"><%//=screen.getString("TIMESTART")%> - <%//=screen.getString("TIMESTOP")%></div></td-->
<td height="20" class="inframe"><div align="center"><a href="javascript:GoHelpTrainer('<%=screen.getString("MTRAINER","TRAINERID")%>','<%=screen.getString("COMPANYID")%>');">
<%//=screen.getString("TRAINERNAME")%>
<%=screen.getString("MTRAINER","TREFNAME")%>
</a></div></td>
<td class="inframe"><div align="center"><a href="javascript:GoHelpLocation('<%=screen.getString("LOCID")%>','<%=screen.getString("TRAININGID")%>','<%=screen.getString("COMPANYID")%>');"><%=screen.getString("MTRLOCATION","LOCEDESC")%></a></div></td>
<td class="inframe"><div align="center"><a href="javascript:GoHelp1('<%=screen.getString("TRAININGID")%>','<%=screen.getString("COMPANYID")%>');"><%=screen.getString("TOTALRESERVER")%></a></div></td>
<td class="inframe"><div align="center"><a href="javascript:GoHelpApprove('<%=screen.getString("TRAININGID")%>','<%=screen.getString("COMPANYID")%>');"><%=screen.getString("RESERVE_APPROVE")%></a></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>
<%
screen.referLangOff();
}%>
</table>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td align="center"><!--a href="TRA012.jsp?__pages=TRA0121&__childMulti=TRA0121E&__multiTable=TTRAINRESP"><img src="../IMAGES/BUTTON/ADD.gif" border="0"></a--> <a href="javaScript:goSearchCon();"><img src="../IMAGES/BUTTON/SEARCH.gif" border="0"></a></td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td class="bottom"></td>
</tr>
</table>
<p> </p>
</form>
</body>
</html>