<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html; charset=UTF-8"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,java.text.DecimalFormat,com.csc.library.components.*,com.csc.library.report.*"%>
<%@ page import="java.util.*,java.io.*,java.sql.*,com.csc.library.database.*"%>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.Locale" %>
<%@ page import="java.util.Date" %>
<%
	CheckNull chk = new CheckNull();
	CscCalendar c = new CscCalendar();
	UProfile up = null;

	if (session !=null){
		up = (UProfile)session.getAttribute("userprofile");
	}

  DecimalFormat del_fomat = new DecimalFormat("#,###.00");

	String cmd = chk.chkNullString(request.getParameter("__cmd"));
	String trainingid =chk.chkNullString(request.getParameter("__trainingid"));
	String trtitle =chk.chkNullString(request.getParameter("__trtitle"));
	String isprocess =chk.chkNullString(request.getParameter("__isprocess"));

	String filter = "1=1";

	if( !trainingid.equals("") ){
		filter += " and trainingid = '"+ trainingid+ "'";
	}

%>

<html ng-app="myHR">
	<head>
		<title></title>
		<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
		<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
		<script language="JavaScript" src="../JS/SCREEN.js"></script>
		<SCRIPT TYPE='text/JavaScript' SRC='../JS/DATEINPUT.js'></SCRIPT>
		<SCRIPT TYPE='text/JavaScript' SRC='../JS/VIEWCALENDAR.js'></SCRIPT>
		<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
		<script type="text/javascript" src="../JS/angular-1.3.15/angular.js"></script>
		<script type="text/javascript" src="../JS/ANGULAR/SCREEN_ANGULAR.js"></script>
		<script language="javascript">setLang('<%=up.get("lang")%>');</script>
		<script language="JavaScript" type="text/JavaScript">
			function goHelp(helpName,inputName){
				var helpReturn;
				if(inputName=="__trainingid" ){
					helpReturn="__trainingid:trainingid,__trtitle:trtitle";
				}

				linkHelp_Return(helpName, helpReturn);
			}

			function GoExport(){
				with(document.cscform){
					// alert(__filter.value);
					var param = "TRRE041_EXP.jsp?__trainingid="+__trainingid.value;
					window.open(param);
				}
			}

			function GoProcess(){
				with( document.cscform){
          __cmd.value = "search"
          __isprocess.value = "1"
          submit();
				}
			}
		</script>
	</head>
	<%
		String helpReturn="";
		if(request.getParameter("__helpReturn")!=null){
		  helpReturn=request.getParameter("__helpReturn");
		}
		String fieldSearch="";
		if(request.getParameter("__fieldSearch")!=null){
		  fieldSearch=request.getParameter("__fieldSearch");
		}
	%>
	<body leftmargin="0" topmargin="0">
		<form name="cscform" method="post" action="TRRE041.jsp">
			<!----------BEGIN CSC INITIAL ZONE ------------------------>
			<%//=screen.InitialVariable()%>
			<!----------END CSC INITIAL ZONE -------------------------->
			<input type="hidden" name="__cmd" value="">
			<input type="hidden" name="__screen" value="TRRE041">
			<input type="hidden" name="__help" value="">
			<input type="hidden" name="__goPage" value="">
			<input type="hidden" name="__language" value="<%=up.get("lang")%>">
			<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
			<input type="hidden" name="__helpReturn" value="<%=helpReturn%>">
			<input type="hidden" name="__fieldSearch" value="<%=fieldSearch%>">
			<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="__astype" value="AP10">
			<input type="hidden" name="__export" value="">
			<input type="hidden" name="__isprocess" value="0">
			<input type="hidden" name="__filter" value="<%=filter%>">
			<script language="javascript">getInputFormatDate()</script>

			<br>
			<div align="center">
				<table class="large" cellpadding="0"  cellspacing="1"  >
					<tr>
						<td  colspan=2 class="header">TRRE041,<%=up.get("lang").equalsIgnoreCase("THA")?"รายงานข้อเสนอแนะการจัดฝึกอบรม":"Training Suggestion Evaluation Report"%></td>
					</tr>
					<tr>
						<td colspan=2>
							<table border="0" cellpadding="0" cellspacing="1"   align="center" class="largest">
								<tr>
									<td colspan=2 class="blankspace"></td>
								</tr>
								<tr>
									<td width="30%" align="right" swlang code="SW001050">Training ID</td>
									<td width="70%">
										<input type="text" name="__trainingid" size="10" value="<%=trainingid%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" >&nbsp;
										<a href="javascript:goHelp('TTRAININGHELP','__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>&nbsp;&nbsp;<input type="text" size="40" name="__trtitle" value="<%=trtitle%>" readonly class="diabled">
									</td>
								</tr>
								<tr>
									<td colspan=2 class="blankspace"></td>
								</tr>
								<tr>
									<td colspan=2 align="center">
										<a href="javascript:GoProcess();"><img src="../IMAGES/BUTTON/SEARCH.gif" border=0/></a>
									</td>
								</tr>
							</table>

							<%
								if(isprocess.equals("1")){
									String trainnername = "";
									DbInquiry inqtrain = new InitialInquiry(up).getDbInquiry("ttraining");
									DbInquiry inqloc = new InitialInquiry(up).getDbInquiry("mtrlocation");
									DbInquiry inqroom = new InitialInquiry(up).getDbInquiry("mtrroom");
									DbInquiry inqcos = new InitialInquiry(up).getDbInquiry("mcourse");
									DbInquiry inqttrnner = new InitialInquiry(up).getDbInquiry("TTRAINTRNER");
									DbInquiry inqmtrnner = new InitialInquiry(up).getDbInquiry("MTRAINER");

									inqtrain.setColumn("*");

									inqtrain.putChild(inqcos);
									inqtrain.putChild(inqloc);
									inqtrain.putChild(inqroom);

									inqtrain.setFilter(filter);
									inqtrain.refresh();
									inqtrain.next();

									inqttrnner.setColumn("*");
									inqttrnner.putChild(inqmtrnner);
									inqttrnner.setFilter("trainingid = '"+inqtrain.getString("trainingid")+"'");
									inqttrnner.referLangOn();
									inqttrnner.refresh();
									while(inqttrnner.next()){
										if(trainnername.equals("")){
											trainnername = inqttrnner.getString("MTRAINER","fullname");
										}else{
											trainnername += " , "+inqttrnner.getString("MTRAINER","fullname");
										}
									}

							%>
							<table class="maxsize" border="1" cellpadding="0" cellspacing="1" bgcolor="#ffffff">
								<tr>
									<td><%=up.get("lang").equalsIgnoreCase("THA")?"หลักสูตร":"course"%></td>
									<td colspan='3'><%=inqtrain.getString("mcourse","CRSDESC")%></td>
								</tr>
								<tr>
									<td><%=up.get("lang").equalsIgnoreCase("THA")?"สถานที่อบรม":"Training Location"%></td>
									<td><%=inqtrain.getString("MTRROOM","roomdesc")+" "+inqtrain.getString("MTRLOCATION","locdesc")%></td>
									<td><%=up.get("lang").equalsIgnoreCase("THA")?"วันที่ฝึกอบรม":"Training Date"%></td>
									<td><%=up.get("lang").equalsIgnoreCase("THA")?new CscCalendar(chk.chkNullString(inqtrain.getString("classdatefrm"))).getThaiDDMMYYYY():new CscCalendar(chk.chkNullString(inqtrain.getString("classdatefrm"))).getDDMMYYYY()%></td>
								</tr>
								<tr>
									<td><%=up.get("lang").equalsIgnoreCase("THA")?"วิทยากร":"Instructor"%></td>
									<td colspan='3'><%=trainnername%></td>
								</tr>
								<tr>
									<td colspan='4' align="center"><%=up.get("lang").equalsIgnoreCase("THA")?"ข้อเสนอแนะ":"Suggestion"%></td>
								</tr>
								<tr>
									<td colspan='4'>ข้อเสนอแนะเกี่ยวกับวิทยากร</td>
								</tr>
								<%
									int i = 0;
									DbInquiry inqtrain_aps = new InitialInquiry(up).getDbInquiry("ttrainaps");
									DbInquiry inqform = new InitialInquiry(up).getDbInquiry("mtrassform");

									inqform.setColumn("*");
									inqtrain_aps.setColumn("*");
									inqtrain_aps.setFilter("trainingid = '"+trainingid+"' and apsid = (select apsid from mtrassform0 where astid = 'tn_aps01')");
									inqtrain_aps.refresh();
									if(inqtrain_aps.next()){
										inqform.setFilter("apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"'");
										inqform.refresh();
										while(inqform.next()){
											if(!inqform.getString("apscomment").equals("")){
												i++;
								%>
								<tr>
									<td colspan='4'><%=i+". "+inqform.getString("apscomment") %></td>
								</tr>
								<%
											}
										}
									}
								%>
								<tr>
									<td colspan='4'>หลักสูตรหรือหัวข้อ ที่ท่านต้องการได้รับการฝึกอบรมเพิ่มเติมในอนาคต</td>
								</tr>
								<%
									int j = 0;
									inqtrain_aps.refresh();
									if(inqtrain_aps.next()){
										inqform.setFilter("apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"'");
										inqform.refresh();
										while(inqform.next()){
											if(!inqform.getString("apsappcomment1").equals("")){
												j++;
								%>
								<tr>
									<td colspan='4'><%=j+". "+inqform.getString("apsappcomment1") %></td>
								</tr>
								<%
											}
										}
									}
								%>
								<tr>
									<td colspan='4'>ระยะเวลาการฝึกอบรมของหลักสูตรนี้</td>
								</tr>
								<tr>
									<td colspan='4'>ข้อเสนอแนะอื่นๆ</td>
								</tr>
								<%
									int k = 0;
									inqtrain_aps.refresh();
									if(inqtrain_aps.next()){
										inqform.setFilter("apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"'");
										inqform.refresh();
										while(inqform.next()){
											if(!inqform.getString("other3").equals("")){
												k++;
								%>
								<tr>
									<td colspan='4'><%=k+". "+inqform.getString("other3") %></td>
								</tr>
								<%
											}
										}
									}
								%>
							</table>
							<%
								}
							%>
						</td>
					</tr>
					<tr>
						<td colspan=2 class="blankspace"></td>
					</tr>
					<%
						if(isprocess.equals("1")){
					%>
					<tr>
						<td colspan=2 align="center">
							<div class="button">
								<a href="javascript:GoExport();"><img src="../IMAGES/BUTTON/EXPORT.gif" border=0 /></a>
							</div>
						</td>
					</tr>
					<%
						}
					%>
					<tr>
						<td colspan=2 class="blankspace"></td>
					</tr>
					<tr bordercolor="0069B3">
						<td colspan=2 class="bottom"></td>
					</tr>
				</table>
			</div>
		</form>
	</body>
</html>