<%@ page contentType="text/html; charset=UTF-8"%> <%@ page import="com.csc.library.entry.*,com.csc.library.system.Task"%> <%@ page import="com.csc.library.database.*,com.csc.library.session.*" %> <%@ page import="com.csc.library.utilities.*"%> <%@ page import="com.csc.library.components.*" %> <% request.setCharacterEncoding("UTF-8"); %> <% CheckNull chk = new CheckNull(); CscCalendar c = new CscCalendar(); UProfile up = null; if (session !=null){ up = (UProfile)session.getAttribute("userprofile"); } String cmd = request.getParameter("__cmd"); String referid = chk.chkNullString(request.getParameter("__referid")); String refer_desc = chk.chkNullString(request.getParameter("__refer_desc")); String isprocess =chk.chkNullString(request.getParameter("__isprocess")); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <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"> <script language="javascript" src="../JS/SCREEN.js"></script> <script type="text/javascript" src="../JS/jquery-2.1.3.min.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 type='text/javascript' src='../JS/ICONSMENU.js'></script> <script language='javascript' src='../JS/HOTKEY.js'></script> <script src="../JS/bootstrap.min.js"></script> <script language="javascript">setLang("<%=up.get("lang")%>");</script> <script language="JavaScript" type="text/JavaScript"> $(document).ready(function(){ $('#search').click(function() { GoProcess(); }); }); function GoProcess(){ with( document.cscform){ __cmd.value = "search" __isprocess.value = "1" submit(); } } function printPDF(CRSID) { var trainingList = $("input[name=trainingList_"+CRSID+"]").val() var param = "TRRE034_PDF.jsp?__crsid="+CRSID+"&__trainingidList="+trainingList console.log(param); window.open(param,"printPDF","left=150,top=100,width=900,height=450,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } function goHelp(helpName,inputName){ var helpReturn; var fixcon; if(inputName=="__referid"){ helpReturn = inputName+":referid"; } fixcon=""; linkHelp_Return(helpName,helpReturn,fixcon); } </script> </head> <body leftmargin="0" topmargin="0"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script type="text/javascript">initToolTips();</script> <form name="cscform" method="post"> <input type="hidden" name="__language" value="<%=up.get("lang")%>"> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__help" value=""> <input type="hidden" name="__confirm" value=""> <input type="hidden" name="__screen" value="TRRE034"> <input type="hidden" name="__goPage" value =""> <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__isprocess" value="0"> <input type="hidden" name="__companyid" value="<%=up.get("companyid")%>"> <div align="center"> <table border="0" cellpadding="0" cellspacing="0" class="large" > <tr> <td class="header">TRRE034, <span>ฝย./ฝย 2-1</span> </td> </tr> <tr> <td class="blankspace"> </td> </tr> <tr> <td> <table border="1" align="center" cellpadding="0" cellspacing="0" class="largest"> <tr> <td> <table border="0" cellpadding="0" cellspacing="0" class="inframe"> <tr> <td width="40%" class="blankspace"></td> <td width="60%" class="blankspace"></td> </tr> <tr> <tr> <td align="right" swlang code='SW000212'>Ref</td> <td> <input type="text" name="__referid" size="15" value="<%=referid%>"> <a href="javascript:goHelp('HTRAIN_REFERDOC0HELP','__referid')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgreferid','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgreferid" border="0" align="absmiddle"></a> </td> </tr> </tr> <tr> <td colspan="2" class="blankspace"></td> </tr> <tr> <td colspan="2" style="text-align: center;"> <div id="search" class="btn btn-primary btn-sm" style="padding-top: 2px;">Search</div> </td> </tr> <tr> <td colspan="2" nowrap class="blankspace"></td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td class="blankspace"> </td> </tr> <% if(isprocess.equals("1")){ %> <tr> <td><table class="maxsize table table-bordered " align="center" border="1" cellpadding="0" cellspacing="1" bgcolor="#666666" class="inframe"> <tr> <td align="center" class="row3" swlang code="SW000637">CourseID</td> <td align="center" class="row3" swlang code="SW000638">CourseName</td> <td align="center" class="row3" swlang code="SW003523">English course name</td> <td align="center" class="row3" swlang code="SW000610">Course Group</td> <td align="center" class="row3" swlang code="SW005455">Print</td> </tr> <% String trainingidList = ""; DbInquiry inqcrs = new InitialInquiry(up).getDbInquiry("mcourse"); DbInquiry inqcrsgrp = new InitialInquiry(up).getDbInquiry("MCOURSEGROUP"); DbInquiry inqrefer1 = new InitialInquiry(up).getDbInquiry("HTRAIN_REFERDOC1"); inqrefer1.setColumn("*"); inqcrs.putChild(inqcrsgrp); inqcrs.setColumn("*"); inqcrs.setFilter("crsid in(SELECT DISTINCT crsid FROM HTRAIN_REFERDOC1 where referid = '"+referid+"')"); //out.print("filter == "+inqcrs.getFilter()); inqcrs.referLangOff(); inqcrs.refresh(); while(inqcrs.next()){ inqrefer1.setFilter("crsid = '"+inqcrs.getString("CRSID")+"' and referid = '"+referid+"'"); inqrefer1.refresh(); trainingidList = ""; while(inqrefer1.next()){ if(trainingidList.equals("")){ trainingidList = inqrefer1.getString("trainingid"); }else{ trainingidList += ","+inqrefer1.getString("trainingid"); } } %> <tr> <td class="forborder2" align="CENTER"><%=inqcrs.getString("CRSID")%></td> <td class="forborder2"><%=inqcrs.getString("CRSDESC")%></td> <td class="forborder2"><%=inqcrs.getString("CRSEDESC")%></td> <td class="forborder2"><%=inqcrs.getString("MCOURSEGROUP","TDESC")%></td> <td class="forborder2" align="CENTER"> <input type='hidden' name='trainingList_<%=inqcrs.getString("CRSID")%>' value='<%=trainingidList%>'/> <a href="javascript:printPDF('<%=inqcrs.getString("CRSID")%>')"><img src="../IMAGES/BUTTON/PRINTER/PRINTER1.jpg" name="print" border="0" id="print" width="40" height="40"/></a> </td> </tr> <% } %> </table> </td> </tr> <% } %> <tr> <td class="blankspace"> </td> </tr> <tr> <td class="bottom"> </td> </tr> </table> <br> </div> </form> </body> </html>