<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@page contentType="text/html; charset=UTF-8" %> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*" %> <%@page import="java.util.*,java.io.*,java.text.DecimalFormat,com.csc.library.database.*,com.csc.library.components.*" %> <jsp:useBean id="TRRE039" class="com.csc.library.system.Task" scope="page"/> <% TRRE039.setChannel(request, response); HelpEntry screen = (HelpEntry) TRRE039.process("HelpEntry", "MEMPLOYEEHELP"); screen.setMaxLine(10); screen.process(); CheckNull chk = new CheckNull(); %> <html ng-app="myHR"> <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 language="JavaScript" src="../JS/SCREEN.js"></script> <script language="javascript" src="../JS/DATEINPUT.js"></script> <script language="javascript" src="../JS/VIEWCALENDAR.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">setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="JavaScript" type="text/JavaScript"> var url = "TRRE039_EXP.jsp?"; function GoExport() { with (document.cscform) { __export.value = "1"; var urlexport = url + "__export=1&__empfilter=" + getEmployeeFilter() + "&__coursefilter=" + getCourseFilter(); action = urlexport; submit(); } } function goHelp(helpName,inputName) { var helpReturn = ""; var fixCon = ""; if (inputName.indexOf("__empid") > -1) { helpReturn=inputName+":employeeid"; } else if (inputName=="__branch" ) { helpReturn=inputName+":branchid,MBRANCH@TDESC"; } else if (inputName=="__bu1" ) { helpReturn=inputName+":bu1id,MBU1@TDESC"; } else if (inputName=="__bu2" ) { helpReturn=inputName+":bu2id,MBU2@TDESC"; } else if (inputName=="__bu3" ) { helpReturn=inputName+":bu3id,MBU3@TDESC"; } else if (inputName=="__bu4" ) { helpReturn=inputName+":bu4id,MBU4@TDESC"; } else if (inputName=="__bu5" ) { helpReturn=inputName+":bu5id,MBU5@TDESC"; } else if (inputName=="__trainingid" ) { helpReturn=inputName+":trainingid,HTRAINING@TRTITLE"; } else if (inputName=="__courseid" ) { helpReturn=inputName+":crsid,MCOURSE@CRSDESC"; } else if (inputName=="__trcatid" ) { helpReturn=inputName+":trcatid,MTRCAT@TDESC"; } else if (inputName=="__crsgid" ) { helpReturn=inputName+":crsgid,MCOURSEGROUP@TDESC"; } else if (inputName=="__crstyid" ) { helpReturn=inputName+":crstyid,MCOURSETYPE@CRSTYDESC"; } linkHelp_Return(helpName,helpReturn,fixCon); } $(function(){ $('#btn_view').on('click',function(){ var urlview = url + "__empfilter=" + getEmployeeFilter() + "&__coursefilter=" + getCourseFilter(); console.log(urlview); viewIframe(urlview); $('#contrainer_iframe').show(); }); function viewIframe(urlaction){ $('#mframe').prop('src', urlaction); } }); function getEmployeeFilter(){ var filter = ""; if($('input[name="__empid_start"]').val() !== "" || $('input[name="__empid_end"]').val() !== ""){ var emp_start = $('input[name="__empid_start"]').val(); var empid_end = $('input[name="__empid_end"]').val(); if(emp_start === ""){ emp_start = empid_end; } else if(empid_end === ""){ empid_end = emp_start; } filter = chkFilter(filter) + "employeeid between '"+emp_start+"' and '"+empid_end+"'"; } if(document.cscform.__status.value !== ""){ filter = chkFilter(filter) + "status = '"+$('select[name="__status"]').val()+"'"; } if($('input[name="__branch"]').val() !== ""){ filter = chkFilter(filter) + "branch = '"+$('input[name="__branch"]').val()+"'"; } if($('input[name="__bu1"]').val() !== ""){ filter = chkFilter(filter) + "bu1 = '"+$('input[name="__bu1"]').val()+"'"; } if($('input[name="__bu2"]').val() !== ""){ filter = chkFilter(filter) + "bu2 = '"+$('input[name="__bu2"]').val()+"'"; } if($('input[name="__bu3"]').val() !== ""){ filter = chkFilter(filter) + "bu3 = '"+$('input[name="__bu3"]').val()+"'"; } if($('input[name="__bu4"]').val() !== ""){ filter = chkFilter(filter) + "bu4 = '"+$('input[name="__bu4"]').val()+"'"; } if($('input[name="__bu5"]').val() !== ""){ filter = chkFilter(filter) + "bu5 = '"+$('input[name="__bu5"]').val()+"'"; } return filter; } function getCourseFilter(){ var mainfilter = ""; var empfilter = getEmployeeFilter(); if($('input[name="__checkboxrecurrent"]').prop("checked")){ mainfilter = chkFilter(mainfilter) + "rdo_recurrent = '1'"; } if(empfilter !== ""){ mainfilter = chkFilter(mainfilter) + "(crsid in (select crsid from ttraining where trainingid in (select trainingid from ttraintrnee where traineeid in (select employeeid from memployee where "+empfilter+"))) or crsid in (select crsid from htraining where trainingid in (select trainingid from htraintrnee where traineeid in (select employeeid from memployee where "+empfilter+"))))"; } else { mainfilter = chkFilter(mainfilter) + "(crsid in (select crsid from ttraining where trainingid in (select trainingid from ttraintrnee where traineeid in (select employeeid from memployee))) or crsid in (select crsid from htraining where trainingid in (select trainingid from htraintrnee where traineeid in (select employeeid from memployee))))"; } if($('input[name="__courseid"]').val() !== ""){ mainfilter = chkFilter(mainfilter) + "crsid = '"+$('input[name="__courseid"]').val()+"'"; } if($('input[name="__trcatid"]').val() !== ""){ mainfilter = chkFilter(mainfilter) + "trcatid = '"+$('input[name="__trcatid"]').val()+"'"; } if($('input[name="__crsgid"]').val() !== ""){ mainfilter = chkFilter(mainfilter) + "crsgid = '"+$('input[name="__crsgid"]').val()+"'"; } if($('input[name="__crstyid"]').val() !== ""){ mainfilter = chkFilter(mainfilter) + "crstyid = '"+$('input[name="__crstyid"]').val()+"'"; } var filter = ""; if($('input[name="__trainingid"]').val() !== ""){ filter = chkFilter(filter) + "trainingid = '"+$('input[name="__trainingid"]').val()+"'"; } if($('select[name="__train_type"]').val() !== ""){ filter = chkFilter(filter) + "trtyid in (select trtyid from mtraintype where train_type = '"+$('select[name="__train_type"]').val()+"')"; } if(filter !== ""){ mainfilter = chkFilter(mainfilter) + "(crsid in (select crsid from htraining where "+filter+") or crsid in (select crsid from ttraining where "+filter+"))"; } return mainfilter; } function chkFilter(filter){ if(filter!==""){ filter+=" and "; } return filter; } function getDateYYYYMMDD(dateinput){ /*var datearr = dateinput.split("\-"); return datearr[2] + "-" + datearr[1] + "-" +datearr[0];*/ return dateinput; } </script> </head> <body leftmargin="0" topmargin="0"> <form name="cscform" method="post" action="TRRE039.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__screen" value="TRRE039"/> <input type="hidden" name="__cmd" value=""/> <input type="hidden" name="__help" value=""/> <input type="hidden" name="__goPage" value=""/> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"/> <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>"/> <input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>"/> <input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>"/> <input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>"/> <input type="hidden" name="__export" value=""/> <input type="hidden" name="__calendar" value=""/> <script language="JavaScript" >getInputFormatDate();</script> <br/> <div align="center"> <table class="large" cellpadding="0" cellspacing="0"> <tr> <td class="header">TRRE039, Report Summary Training Plan </td> </tr> <tr> <td> <table align="center"> <tr> <td class="columnlabel" swlang code="SW000274">Employee ID</td> <td> <input type="text" name="__empid_start" size="15" value=""/> <a href="javascript:goHelp('MEMPLOYEEHELP','__empid_start');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__empid_start_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__empid_start_image" width="20" height="20" border="0" align="absmiddle"></a> - <input type="text" name="__empid_end" size="15" value=""/> <a href="javascript:goHelp('MEMPLOYEEHELP','__empid_end');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__empid_end_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__empid_end_image" width="20" height="20" border="0" align="absmiddle"></a> </td> </tr> <tr> <td class="columnlabel">Employee Status</td> <td> <% ListBox listboxStatus = new ListBox(); listboxStatus.setUProfile(screen.getUProfile()); listboxStatus.setName("status"); listboxStatus.setTable("MEMPL_STATUSHELP","STATUSCODE","EDESC","","SORT",""); listboxStatus.setDisable("false"); listboxStatus.setBlank(true); out.println(listboxStatus.process()); %> </td> </tr> <tr> <td class="columnlabel" swlang code="SW000008">Branch</td> <td> <input type="text" name="__branch" size="15" value=""/> <a href="javascript:goHelp('MBRANCHHELP','__branch');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__branch_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__branch_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MBRANCH@TDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel"><%=screen.getInquiry().getCurrentDbRecord().getField("BU1").getDescription()%></td> <td> <input type="text" name="__bu1" size="15" value=""/> <a href="javascript:goHelp('MBU1HELP','__bu1');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu1_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu1_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MBU1@TDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel"><%=screen.getInquiry().getCurrentDbRecord().getField("BU2").getDescription()%></td> <td> <input type="text" name="__bu2" size="15" value=""/> <a href="javascript:goHelp('MBU2HELP','__bu2');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu2_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu2_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MBU2@TDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel"><%=screen.getInquiry().getCurrentDbRecord().getField("BU3").getDescription()%></td> <td> <input type="text" name="__bu3" size="15" value=""/> <a href="javascript:goHelp('MBU3HELP','__bu3');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu3_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu3_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MBU3@TDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel"><%=screen.getInquiry().getCurrentDbRecord().getField("BU4").getDescription()%></td> <td> <input type="text" name="__bu4" size="15" value=""/> <a href="javascript:goHelp('MBU4HELP','__bu4');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu4_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu4_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MBU4@TDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel"><%=screen.getInquiry().getCurrentDbRecord().getField("BU5").getDescription()%></td> <td> <input type="text" name="__bu5" size="15" value=""/> <a href="javascript:goHelp('MBU5HELP','__bu5');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu5_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu5_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MBU5@TDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel" swlang code="SW001050">Training ID</td> <td> <input type="text" name="__trainingid" size="15" value=""/> <a href="javascript:goHelp('HTRAININGHELP','__trainingid');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__trainingid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__trainingid_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="HTRAINING@TRTITLE" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel" swlang code="SW011988">Course ID</td> <td> <input type="text" name="__courseid" size="15" value=""/> <a href="javascript:goHelp('MCOURSEHELP','__courseid');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__courseid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__courseid_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MCOURSE@CRSDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel">Course Categories</td> <td> <input type="text" name="__trcatid" size="15" value=""/> <a href="javascript:goHelp('MTRCATHELP','__trcatid');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__trcatid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__trcatid_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MTRCAT@TDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel">Course groups</td> <td> <input type="text" name="__crsgid" size="15" value=""/> <a href="javascript:goHelp('MCOURSEGROUPHELP','__crsgid');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__crsgid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__crsgid_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MCOURSEGROUP@TDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel" swlang code="SW000390">Course Type</td> <td> <input type="text" name="__crstyid" size="15" value=""/> <a href="javascript:goHelp('MCOURSETYPEHELP','__crstyid');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__crstyid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__crstyid_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="MCOURSETYPE@CRSTYDESC" size="35" value="" disabled/> </td> </tr> <tr> <td class="columnlabel">Train Type</td> <td> <% ListBox listboxTrainType = new ListBox(); listboxTrainType.setUProfile(screen.getUProfile()); listboxTrainType.setName("train_type"); listboxTrainType.setValidCode("APPLICANT_TYPE"); listboxTrainType.setDisable("false"); listboxTrainType.setBlank(true); out.println(listboxTrainType.process()); %> </td> </tr> <tr> <td class="columnlabel"></td> <td> <input type="checkbox" name="__checkboxrecurrent" value="1" checked> Show Recurrent Only </td> </tr> </table> </td> </tr> <tr> <td align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW012859" id="btn_view">VIEW</button> <button type="button" class="btn btn-primary width100" swlang code="SW013178" onClick="javascript:GoExport();">EXPORT</button> </td> </tr> <tr> <td class="blankspace"></td> </tr> <tr id="contrainer_iframe" style="display:none"> <td> <iframe id="mframe" frameborder="0" name="mframe" src="" width="100%" height="650"></iframe> </td> </tr> <tr> <td class="blankspace"></td> </tr> <tr bordercolor="0069B3"> <td class="bottom"></td> </tr> </table> </div> </form> </body> </html>