<!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();" > <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> <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>