<%@ 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>