<!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.database.*"%>
<%@page import="java.util.*,java.io.*"%>
<%@page import="com.csc.library.components.ListBox"%>
<jsp:useBean id="TRR012" class="com.csc.library.system.Task" scope="page" />
<%
TRR012.setChannel(request, response);
HelpEntry screen = (HelpEntry) TRR012.process("HelpEntry","TRR012HELP");
CheckNull chk = new CheckNull();
%>
<html>
<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 rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT.css">
<link rel="stylesheet" type="text/css" href="../CSS/EMV_TEXT.css">
<script language="JavaScript" src="../JS/SCREEN.js"></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language="javascript">getInputFormatDate();</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function back(unit){
with(window.opener.document.cscform){
locateId.value =unit;
}
window.close();
}
function GoExport() {
with( document.cscform) {
if(chkValid()){
__export.value = "1";
target="_blank";
action = "TRR012_EXP.jsp";
submit();
target="";
action = "?";
}
}
}
function Print(){
with( document.cscform) {
//alert("Export");
__export.value = "0";
target="_blank";
action = "TRR012_EXP.jsp";
submit();
target="";
action = "?";
}
}
function chkValid(){
with(document.cscform){
if(__emp_start.value != "" && __emp_end.value == ""){
alert("กรุณาเลือกพนักงานสิ้นสุด");
return false;
}
if(__emp_start.value == "" && __emp_end.value != ""){
alert("กรุณาเลือกพนักงานเริ่มต้น");
return false;
}
if(__start_date.value != "" && __end_date.value == ""){
alert("กรุณาเลือกวันที่สิ้นสุด");
return false;
}
if(__start_date.value == "" && __end_date.value != ""){
alert("กรุณาเลื่อกวันที่เริ่มต้น");
return false;
}
}
return true;
}
function GoSearch(){
with( document.cscform){
submit();
}
}
function goHelp(helpName,inputName){
with(document.cscform){
var fixcon_tmp = "";
var helpReturn;
if(inputName == "__emp_start"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":employeeid";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
if(inputName == "__emp_end"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":employeeid";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
if(inputName == "__emp_position"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":positionid,MPOSITION@TDESC";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
if(inputName == "__emp_bu1"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":bu1id,MBU1@TDESC";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
if(inputName == "__emp_bu2"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":bu2id,MBU2@TDESC";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
if(inputName == "__emp_bu3"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":bu3id,MBU3@TDESC";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
if(inputName == "__emp_bu4"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":bu4id,MBU4@TDESC";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
if(inputName == "__emp_bu5"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":bu5id,MBU5@TDESC";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
if(inputName == "__couseid"){
fixcon_tmp = __fixCon.value;
helpReturn = inputName+":crsid,MCOURSE@CRSDESC";
__fixCon.value = "";
linkHelp_Return(helpName,helpReturn);
__fixCon.value = fixcon_tmp;
}
}
}
//-->
</script>
</head>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" action="?">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="TRR012">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__orderBy" value="<%=chk.chkNullString(request.getParameter("__orderBy"))%>">
<input type="hidden" name="__helpReturn" value="<%=chk.chkNullString(request.getParameter("__helpReturn"))%>">
<input type="hidden" name="__fieldSearch" value="<%=chk.chkNullString(request.getParameter("__fieldSearch"))%>">
<input type="hidden" name="__helpName" value="<%=chk.chkNullString(request.getParameter("__helpName"))%>">
<input type="hidden" name="__pageCall" value="<%=chk.chkNullString(request.getParameter("__screen"))%>">
<input type="hidden" name="__fixCon" value="<%=chk.chkNullString(request.getParameter("__fixCon"))%>">
<input type="hidden" name="__export" value="">
<input type="hidden" name="__calendar" value="">
<input type="hidden" name="__dateformat" value="DD-MM-YYYY">
<br>
<div align="center" class="box-search-condition">
<table class="large" cellpadding="0" cellspacing="0" width="100%" >
<tr>
<td class='content-title'>TRR012,
<SCRIPT language="JavaScript">swapLang("Report Training And Seminar Summary");</SCRIPT>
</td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="1" width="100%" align="center" class="table-search-condition">
<tr>
<td class="column-label" colspan="2"> </td>
</tr>
<tr>
<td class="column-label" width="25%">
<div align="right">
<script>swapLang("Start Employee ID");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__emp_start" >
<a href="javascript:goHelp('MEMPLOYEEHELP','__emp_start');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__emp_start_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__emp_start_image" width="20" height="20" border="0" align="absmiddle"></a>
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("End Employee ID");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__emp_end" >
<a href="javascript:goHelp('MEMPLOYEEHELP','__emp_end');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__emp_end_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__emp_end_image" width="20" height="20" border="0" align="absmiddle"></a>
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Position");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__emp_position" >
<a href="javascript:goHelp('MPOSITIONHELP','__emp_position');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__emp_position_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__emp_position_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MPOSITION@TDESC" size="40">
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Business Unit 1");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__emp_bu1" >
<a href="javascript:goHelp('MBU1HELP','__emp_bu1');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__emp_bu1_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__emp_bu1_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MBU1@TDESC" size="40">
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Business Unit 2");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__emp_bu2" >
<a href="javascript:goHelp('MBU2HELP','__emp_bu2');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__emp_bu2_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__emp_bu2_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MBU2@TDESC" size="40">
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Business Unit 3");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__emp_bu3" >
<a href="javascript:goHelp('MBU3HELP','__emp_bu3');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__emp_bu3_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__emp_bu3_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MBU3@TDESC" size="40">
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Business Unit 4");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__emp_bu4" >
<a href="javascript:goHelp('MBU4HELP','__emp_bu4');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__emp_bu4_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__emp_bu4_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MBU4@TDESC" size="40">
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Business Unit 5");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__emp_bu5" >
<a href="javascript:goHelp('MBU5HELP','__emp_bu5');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__emp_bu5_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__emp_bu5_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MBU5@TDESC" size="40">
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Crourse");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__couseid" >
<a href="javascript:goHelp('MCOURSEHELP','__couseid');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__couseid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__couseid_image" width="20" height="20" border="0" align="absmiddle"></a>
<input name="MCOURSE@CRSDESC" size="40">
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Start date");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__start_date" maxlength="10" value="" onkeypress="chkIntegerOfDate(this.value,event);" onkeyup="sysIsEdit();formatDate(this);" onblur="chkInputDate2(this,__end_date);" onfocus="this.select();" alt="เปิดจองตั้งแต่วันที่" onmouseover="toolTip('วันที่เริ่มต้น');" onmouseout="toolTip()
">
<a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="calendar" name="Image5" border="0" align="absmiddle" id="Image154" onclick="viewCal('__start_date')"></a>
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("End date");</script> :
</div>
</td>
<td class="column-input">
<input type="text" size="10" name="__end_date" maxlength="10" value="" onkeypress="chkIntegerOfDate(this.value,event);" onkeyup="sysIsEdit();formatDate(this);" onblur="chkInputDate2(__start_date,this);" onfocus="this.select();" alt="เปิดจองตั้งแต่วันที่" onmouseover="toolTip('วันที่สิ้นสุด');" onmouseout="toolTip()
">
<a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="calendar" name="Image5" border="0" align="absmiddle" id="Image154" onclick="viewCal('__end_date')"></a>
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Year");</script> :
</div>
</td>
<td class="column-input">
<select name="__years">
<%
CscCalendar cscc = new CscCalendar();
for(int i = 0; i < 5; i++){
%>
<option value="<%=cscc.getYear()%>" <%=chk.chkNullString(request.getParameter("__years")).equals(cscc.getYear()+"")?"selected":""%>><%=cscc.getYear()%></option>
<%
cscc.decYear(1);
}
%>
</select>
</td>
</tr>
<tr>
<td class="column-label" >
<div align="right">
<script>swapLang("Type of training");</script> :
</div>
</td>
<td class="column-input">
<%
ListBox lb = new ListBox();
lb.setUProfile(screen.getUProfile());
lb.setName("traintype");
lb.setValidCode("APPLICANT_TYPE");
lb.setChecked(chk.chkNullString(request.getParameter("__traintype")));
%>
<%=lb.process()%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="1" width="100%" align="center" class="table-search-condition">
<tr>
<td class="column-label"> </td>
</tr>
<tr>
<td class="column-label">
<div align="center">
<a href="javascript:Print();">
<img src="../IMAGES/MYNOTE/BUTTON/BUTTON_PRINT.gif" border="0">
</a>
<a style="display:none;" href="javascript:GoSearch();">
<img src="../IMAGES/MYNOTE/BUTTON/BUTTON_SEARCH.gif" border="0">
</a>
<a href="javascript:GoExport();">
<img src="../IMAGES/MYNOTE/BUTTON/BUTTON_EXPORT.gif" border="0">
</a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr style="display:none;">
<td>
<table border="1" cellpadding="0" cellspacing="1" align="center" class="largest">
<tr>
<td class="row1" align="center"><script language="JavaScript">swapLang("Employee ID");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("Name And Lastname");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("Position");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("ฝ่าย / ส่วน");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("กลุ่มงาน");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("Course");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("Start Date Training");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("End Date Training");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("Start Time Training");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("End Time Training");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("Sum Hour");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("ประเภทการอบรม");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("สถาบัน");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("Trainner");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("Location");</script></td>
<td class="row1" align="center"><script language="JavaScript">swapLang("ค่าใช้จ่ายในการอบรม");</script></td>
</tr>
<%
String filter = "";
if(!chk.chkNullString(request.getParameter("__emp_start")).equals("") && !chk.chkNullString(request.getParameter("__emp_end")).equals("")){
filter += " M.EMPLOYEEID BETWEEN '" + chk.chkNullString(request.getParameter("__emp_start")) + "' AND '" + chk.chkNullString(request.getParameter("__emp_end")) + "' ";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__emp_position")).equals("")){
filter += "M.EMP_POSITION = '" + chk.chkNullString(request.getParameter("__emp_position")) + "' ";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__emp_bu1")).equals("")){
filter += " TN.BU1 = '" + chk.chkNullString(request.getParameter("__emp_bu1")) + "'";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__emp_bu2")).equals("")){
filter += " TN.BU2 = '" + chk.chkNullString(request.getParameter("__emp_bu2")) + "'";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__emp_bu3")).equals("")){
filter += " TN.BU3 = '" + chk.chkNullString(request.getParameter("__emp_bu3")) + "'";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__emp_bu4")).equals("")){
filter += " TN.BU4 = '" + chk.chkNullString(request.getParameter("__emp_bu4")) + "'";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__emp_bu5")).equals("")){
filter += " TN.BU5 = '" + chk.chkNullString(request.getParameter("__emp_bu5")) + "'";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__couseid")).equals("")){
filter += " T.CRSID = '" + chk.chkNullString(request.getParameter("__couseid")) + "'";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__start_date")).equals("") && !chk.chkNullString(request.getParameter("__end_date")).equals("")){
filter += " T.CLASSDATEFRM BETWEEN '" + chk.chkNullString(request.getParameter("__start_date")) + "' AND '" + chk.chkNullString(request.getParameter("__end_date")) + "' ";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(chk.chkNullString(request.getParameter("__start_date")).equals("") && chk.chkNullString(request.getParameter("__end_date")).equals("") && !chk.chkNullString(request.getParameter("__years")).equals("")){
filter += " T.CLASSDATEFRM LIKE '" + chk.chkNullString(request.getParameter("__years")) + "-%'";
}
if(!filter.equalsIgnoreCase("")){
filter += " AND ";
}
if(!chk.chkNullString(request.getParameter("__traintype")).equals("")){
filter += " T.TRAIN_TYPE = '" + chk.chkNullString(request.getParameter("__traintype")) + "'";
}
if(!filter.equalsIgnoreCase("")){
filter = " WHERE " + filter;
}
String sql = "SELECT T.TRAININGID, " +
" M.EMPLOYEEID AS EMP_ID, " +
" (MP.TDESC || M.FNAME || ' ' || M.LNAME) AS FULLNAME, " +
" MPT.TDESC AS POSITION, " +
" B4.TDESC AS B4, " +
" B2.TDESC AS B2, " +
" MC.CRSDESC AS COURSE, " +
" TT.START_DATE AS DATE_ST, " +
" TT.END_DATE AS DATE_EN, " +
" TT.START_TIME AS TIME_ST, " +
" TT.END_TIME AS TIME_EN, " +
//" --TT.END_TIME - TT.START_TIME AS SUM_TIME, " +
" TT.T_HOUR AS SUM_TIME, " +
" MCT.CRSTYDESC COURSE_TYPE, " +
" AD.INSTDESC AS ACADEMY, " +
" TNN.TRAINER, " +
" CASE WHEN TRL.LOCDESC IS NULL THEN ' ' ELSE TRL.LOCDESC END AS LOCATIONS, " +
" (CASE WHEN TEXP.EXPENSEPERCAPITA IS NULL OR TEXP.EXPENSEPERCAPITA = '' " +
" THEN 0 " +
" ELSE TEXP.EXPENSEPERCAPITA " +
" END) AS EXPS " +
" FROM TTRAINTRNEE TN " +
" LEFT OUTER JOIN TTRAINING T ON(T.TRAININGID = TN.TRAININGID) " +
" INNER JOIN MEMPLOYEE M ON (M.EMPLOYEEID = TN.TRAINEEID) " +
" INNER JOIN MBU4 B4 ON (TN.BU4 = B4.BU4ID) " +
" INNER JOIN MBU2 B2 ON (TN.BU2 = B2.BU2ID) " +
" LEFT JOIN MCOURSE MC ON(MC.CRSID = T.CRSID) " +
" LEFT JOIN TTRAININGTIME TT ON (TN.TRAININGID = TT.TRAININGID) " +
" LEFT JOIN MACADEMY AD ON (T.INSTID = AD.INSTID) " +
" INNER JOIN MPREFIX MP ON(M.EMP_PREFIX = MP.PREFIXID) " +
" INNER JOIN MPOSITION MPT ON (M.EMP_POSITION = MPT.POSITIONID) " +
" LEFT JOIN MCOURSETYPE MCT ON (MCT.CRSTYID = MC.CRSTYID) " +
" LEFT OUTER JOIN ( " +
" SELECT " +
" TTN.TRAININGID, " +
" (MTNP.TDESC || MTN.TRFNAME || ' ' || MTN.TRLNAME) AS TRAINER " +
" FROM TTRAINTRNER TTN " +
" INNER JOIN MTRAINER MTN ON(TTN.TRAINERID = MTN.TRAINERID) " +
" INNER JOIN MPREFIX MTNP ON (MTN.PREFIXID = MTNP.PREFIXID) " +
" ) TNN ON (TN.TRAININGID = TNN.TRAININGID) " +
" LEFT OUTER JOIN MTRLOCATION TRL ON (T.LOCID = TRL.LOCID) " +
" LEFT OUTER JOIN TTRAINEXP TEXP ON (T.TRAININGID = TEXP.TRAININGID) " +
" " + filter + " " +
" GROUP BY T.TRAININGID,M.EMPLOYEEID,MP.TDESC,M.FNAME,M.LNAME,MPT.TDESC,B4.TDESC,B2.TDESC, " +
" MC.CRSDESC,TT.START_DATE,TT.END_DATE,TT.START_TIME,TT.END_TIME,TT.T_HOUR,MCT.CRSTYDESC, " +
" AD.INSTDESC,TNN.TRAINER,TRL.LOCDESC,TEXP.EXPENSEPERCAPITA " +
" ORDER BY T.TRAININGID,M.EMPLOYEEID";
//out.print(sql);
String tableName = "TTRAINTRNEE";
DataSet ds = new DataSet(sql, screen.getUProfile().getDbName(), tableName);
ds.initConnection(screen.getUProfile());
while(ds.next()){
%>
<tr>
<td class="row3"><%=ds.getString("emp_id")%></td>
<td class="row3"><%=ds.getString("fullname")%></td>
<td class="row3"><%=ds.getString("position")%></td>
<td class="row3"><%=ds.getString("b4")%></td>
<td class="row3"><%=ds.getString("b2")%></td>
<td class="row3"><%=ds.getString("course")%></td>
<td class="row3"><%=ds.getString("date_st")%></td>
<td class="row3"><%=ds.getString("date_en")%></td>
<td class="row3"><%=ds.getString("time_st")%></td>
<td class="row3"><%=ds.getString("time_en")%></td>
<td class="row3"><%=ds.getString("sum_time")%></td>
<td class="row3"><%=ds.getString("course_type")%></td>
<td class="row3"><%=ds.getString("academy")%></td>
<td class="row3"><%=ds.getString("trainer")%></td>
<td class="row3"><%=ds.getString("locations")%></td>
<td class="row3"><%=ds.getString("exps")%></td>
</tr>
<%
}
ds.closeConnection();
%>
</table>
</td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr bordercolor="0069B3">
<td class="bottom"></td>
</tr>
</table>
</div>
</form>
</body>
</html>