<!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 = "TRRE037_EXP.jsp?__trainingid="+__trainingid.value;
window.open(param);
}
}
function GoProcess(){
with( document.cscform){
var lang = '<%=up.get("lang")%>'
if(__trainingid.value == ''){
if(lang == "tha"){
alert("กรุณาเลือกรหัสรุ่น!!")
}else{
alert("Please Choose TrainingID!!")
}
}else{
__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="TRRE037.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%//=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="TRRE037">
<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">TRRE037,<%=up.get("lang").equalsIgnoreCase("THA")?"รายงานแบบประเมินการจัดฝึกอบรม":"Training 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>
</table>
<table class="maxsize" border="1" cellpadding="0" cellspacing="1" bgcolor="#ffffff">
<%
int row = 0;
int group_count = 0;
DbInquiry inqtrain_aps = new InitialInquiry(up).getDbInquiry("ttrainaps");
DbInquiry inqform = new InitialInquiry(up).getDbInquiry("mtrassform");
DbInquiry inqformno = new InitialInquiry(up).getDbInquiry("mtrassformno");
DbInquiry inqgroup = new InitialInquiry(up).getDbInquiry("mtrassgrp_sup");
DbInquiry inqtopic = new InitialInquiry(up).getDbInquiry("mtrassgrp");
inqform.setColumn("*");
inqformno.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();
// get GroupDesc
String sql1 = "select DISTINCT(asgid) from mtrassformno where apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"'";
DataSet ds_group = new DataSet(sql1, up.get("dbname"), "");
ds_group.setFetchAll(false);
ds_group.initConnection(up);
double avg1 = 0.00;
double avg2 = 0.00;
double total_totalavg = 0.00;
MyHashMap myhm = new MyHashMap();
while(inqform.next()){
row++;
// inqformno.setFilter("apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"'");
// inqformno.refresh();
%>
<%
if(inqform.isFirst()){
%>
<tr>
<td class="row1" rowspan='2' align="center"><%=up.get("lang").equalsIgnoreCase("THA")?"ลำดับ":"Seq"%></td>
<%
while(ds_group.next()){
inqgroup.setColumn("*");
inqgroup.setFilter("asgid = '"+ds_group.getString("asgid")+"'");
inqgroup.refresh();
inqgroup.next();
group_count++;
inqformno.setFilter("apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"' and asgid='"+ds_group.getString("asgid")+"' and apsassessor = '"+inqform.getString("apsassessor")+"'");
inqformno.refresh();
%>
<td class="row1" colspan='<%=inqformno.recCount()+1%>' align="center"><%=inqgroup.getString("tdesc")%></td>
<%
}
%>
<td class="row1" rowspan='2' align="center"><%=up.get("lang").equalsIgnoreCase("THA")?"รวม":"Total"%></td>
</tr>
<tr>
<%
ds_group.setFetchAll(false);
ds_group.initConnection(up);
while(ds_group.next()){
// get TopicDesc
inqformno.setFilter("apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"' and asgid='"+ds_group.getString("asgid")+"' and apsassessor = '"+inqform.getString("apsassessor")+"'");
inqformno.refresh();
while(inqformno.next()){
inqtopic.setColumn("*");
inqtopic.setFilter("asid = '"+inqformno.getString("asid")+"'");
inqtopic.refresh();
while(inqtopic.next()){
%>
<td class="row1" align="center"><%=inqtopic.getString("tdesc")%></td>
<%
}
}
%>
<td class="row1" align="center"><%=up.get("lang").equalsIgnoreCase("THA")?"ค่าเฉลี่ย":"Average"%></td>
<%
}
%>
</tr>
<%
}
%>
<tr>
<td><center><%=row%></center></td>
<%
ds_group.setFetchAll(false);
ds_group.initConnection(up);
while(ds_group.next()){
avg1 = 0.00;
inqformno.setFilter("apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"' and asgid='"+ds_group.getString("asgid")+"' and apsassessor = '"+inqform.getString("apsassessor")+"'");
inqformno.refresh();
while(inqformno.next()){
avg1 += Double.valueOf(inqformno.getString("asrscore"))/ inqformno.recCount();
myhm.putToSum(ds_group.getString("asgid")+inqformno.getString("asid"),chk.chkNullStringToDouble(inqformno.getString("asrscore")));
%>
<td align="center"><%=inqformno.getString("asrscore")%></td>
<%
}
%>
<td align="center"><%=del_fomat.format(avg1).equals(".00")?"0.00":del_fomat.format(avg1)%></td>
<%
avg2 += avg1;
myhm.putToSum(ds_group.getString("asgid"),avg1);
}
%>
<td align="center"><%=del_fomat.format(avg2/group_count).equals(".00")?"0.00":del_fomat.format(avg2/group_count)%></td>
</tr>
<%
}
%>
<tr>
<td></td>
<%
ds_group.setFetchAll(false);
ds_group.initConnection(up);
while(ds_group.next()){
inqformno.setFilter("apsid = '"+inqtrain_aps.getString("apsid")+"' and trainingid = '"+inqtrain_aps.getString("trainingid")+"' and asgid='"+ds_group.getString("asgid")+"' and apsassessor = '"+inqform.getString("apsassessor")+"'");
inqformno.refresh();
while(inqformno.next()){
%>
<td align="center"><%=del_fomat.format(myhm.getDouble(ds_group.getString("asgid")+inqformno.getString("asid"))/row).equals(".00")?"0.00":del_fomat.format(myhm.getDouble(ds_group.getString("asgid")+inqformno.getString("asid"))/row)%></td>
<%
}
%>
<td align="center"><%=del_fomat.format(myhm.getDouble(ds_group.getString("asgid"))/row).equals(".00")?"0.00":del_fomat.format(myhm.getDouble(ds_group.getString("asgid"))/row)%></td>
<%
total_totalavg += myhm.getDouble(ds_group.getString("asgid"));
}
%>
<td align="center"><%=del_fomat.format(total_totalavg/group_count).equals(".00")?"0.00":del_fomat.format(total_totalavg/group_count)%></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>