<%@ 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>&nbsp;</td>
		      </tr>
		      <tr>
		        <td class="blankspace">&nbsp;</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">&nbsp;</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">&nbsp;</td>
		      </tr>
		      <tr>
		        <td class="bottom">&nbsp;</td>
		      </tr>
		    </table>
		    <br>
		  </div>
		</form>
	</body>
</html>