<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*"  %>
<% request.setCharacterEncoding("TIS620"); %>
<jsp:useBean id="TREMP001" class="com.csc.library.system.Task" scope="page" />
<jsp:setProperty name="TREMP001" property="appname" value="empview" />
<%
	TREMP001.setChannel(request, response);	
	HelpEntry screen = (HelpEntry)TREMP001.process("HelpEntry", "TREMP001"); 
	
	CheckNull chk = new CheckNull();
	CscCalendar csc = new CscCalendar();

	screen.getInquiry().setFilter("employeeid = '"+chk.chkNullString(request.getParameter("empid"),screen.getUProfile().get("employeeid"))+"'");

	screen.process();
	screen.nextRec();
	screen.referLangOn();
	String thislang = screen.getUProfile().get("lang");
	DbInquiry inq = null;
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="../Templates/template-emv-main.dwt.jsp" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Employee View</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=TIS620" />
<!-- InstanceBeginEditable name="head" -->
<!-- Begin CSS Links -->
<link rel="stylesheet" type="text/css" href="../CSS/DDMENU.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_DEFAULT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT_TWO.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_TEXT.css" />
<!-- End CSS Links -->
<!-- Begin Scripts -->
<!-- Begin script for Dropdown Menu -->
<!-- DO NOT EDIT -->
<script language="JavaScript" type="text/javascript" src="../JS/EVENTS.js"></script>
<script language="JavaScript"  type="text/javascript" src="../JS/DDMENU.js"></script>
<!--[if lt IE 7]><script language="JavaScript" type="text/javascript" src="../JS/IEHOVER-FIX.js"></script><![endif]-->
<!-- DO NOT EDIT -->
<!-- End script for Dropdown Menu -->
<script language="JavaScript" type="text/javascript" src="../JS/UTILITIES.js"></script>
<script language="JavaScript" type="text/javascript" src="../JS/ACTIVE_OBJECT.js"></script>
<script language="JavaScript" type="text/javascript" src="../JS/SCREEN.js"></script>
<script language="JavaScript" type="text/javascript" src="../JS/DATEINPUT.js"></script>
<script language="JavaScript" type="text/javascript" src="../JS/VIEWCALENDAR.js"></script>
<script language="JavaScript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language='javascript'>
	function viewHtraining(trainingid){
		var tmp = trainingid;
		with(document.cscform){
			window.open("TREMP006.jsp?__fixCon=trainingid='"+tmp+"'","HTRAINING","left=150,top=150,width=700,height=700,toolbar=no,status=no,scrollbars=yes,resizable=yes");
		}
	}
	function viewTtraining(trainingid){
		var tmp = trainingid;
		with(document.cscform){
			window.open("TREMP009.jsp?__fixCon=trainingid='"+tmp+"'","TTRAINING","left=150,top=150,width=700,height=700,toolbar=no,status=no,scrollbars=yes,resizable=yes");
		}
	}
	function viewTtraining_Time(trainingid){
		var tmp = trainingid;
		with(document.cscform){
			window.open("TREMP011.jsp?__fixCon=trainingid='"+tmp+"'","TTRAININGTIME","left=150,top=150,width=700,height=300,toolbar=no,status=no,scrollbars=yes,resizable=yes");
		}
	}
	function viewHtraining_Time(trainingid){
		var tmp = trainingid;
		with(document.cscform){
			window.open("TREMP012.jsp?__fixCon=trainingid='"+tmp+"'","TTRAININGTIME","left=150,top=150,width=700,height=300,toolbar=no,status=no,scrollbars=yes,resizable=yes");
		}
	}
	function viewCourse(crsid){
		var tmp = crsid;
		with(document.cscform){
			window.open("TREMP007.jsp?__fixCon=crsid='"+tmp+"'","COURSE","left=150,top=150,width=700,height=700,toolbar=no,status=no,scrollbars=yes,resizable=yes");
		}
	}
</script>
<!-- End Scripts -->
<!-- Begin Head -->
<style type="text/css">
#header {
 	background: #FFFFFF ;
}
</style>
<!-- End Head -->
<!-- InstanceEndEditable -->
</head>
<body>
<div id="wrapper">
  <div id="header"><!-- InstanceBeginEditable name="header" -->
    <jsp:include page="EMV_HEADER.jsp" flush="true" />
   <!-- InstanceEndEditable -->  </div>
  <div id="topnav"><!-- InstanceBeginEditable name="top_navigation" -->
  	<jsp:include page="EMV_TOPMENU.jsp" flush="true" />
    <!-- InstanceEndEditable -->  </div>
  <div id="container">
    
    <div id="content"><!-- InstanceBeginEditable name="main_content" -->
    <!-- Begin Main Content -->
      <jsp:include page="../EMPVIEW/EMV_HELPBAR.jsp" flush="true" />
      <div class="content">
		<div class="content-box1">
		<form name="cscform" method="post" action="TREMP001.jsp">

		<!-- BEGIN CSC INITIAL ZONE -->

		<%=screen.InitialVariable()%>

		<!-- END CSC INITIAL ZONE -->

			<input type="hidden"name="__screen"  value="TREMP001">
			<input type="hidden" name="__fixCon" value="">
			<input type="hidden" name="__help" value="">
			<input type="hidden" name="__keyList" value="">
			<input type="hidden" name="__cmd"  value="">
			<input type="hidden" name="__calendar">
			<script language="javascript">//getInputFormatDate();</script>
			<input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>">
			<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
			<input type = "hidden" name = "__backpage" value = "<%=request.getParameter("__backpage")%>">
					<div class="content-header"><h2><script language="javascript">swapLang('History and Training Plan Detail');</script></h2></div>
							<table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content" cols="5">	
								<%
									boolean bs_page = !chk.chkNullString(request.getParameter("empid")).equals("");
									int px = (bs_page)?30:40;
									int py = (bs_page)?10:0;
								%>
								<tr>
									<td class="column-label" width="15%"><script language="javascript">swapLang('Employee ID');</script></td>
									<td class="column-text" width="30%" ><%=screen.getString("employeeid")%></td>
									<td class="column-label" width="15%"><script language="javascript">swapLang('Work Age');</script></td>
									<td class="column-text" width="<%=px%>%"><%=screen.getString("empworkagesym")%></td>		
									<td class="column-text-right" width="<%=py%>%" rowspan="4">
										<%
											if(bs_page){
										%>
                                        <img id="employeepic" src="<%=screen.getInquiry().getCurrentDbRecord().getViewUrl("picture")%>" onload="resizeImg(this,100,100);" alt="Employee Picture" width="88" height="88" border="1" class="border-black" />
										<%
											}
										%>
									</td>
								</tr>
								<tr>
									<td class="column-label" width="15%"><script language="javascript">swapLang('Name Surname');</script></td>
									<%
										DbRecord rec = new InitialRecord(screen.getUProfile()).getDbRecord("mprefix");
										rec.setColumn("prefixid,tdesc,edesc");
										rec.set("prefixid", screen.getString("emp_prefix"));
										rec.search();
									%>
									<td class="column-text" width="30%"><%=((thislang.equals("tha"))?rec.getString("tdesc"):rec.getString("edesc"))+""+screen.getString("FNAME")+" "+screen.getString("LNAME")%></td>
									<td class="column-label" ><script language="javascript">swapLang('Position');</script></td>
									<%
										rec = new InitialRecord(screen.getUProfile()).getDbRecord("mposition");
										rec.setColumn("positionid,tdesc,edesc,companyid");
										rec.set("positionid", screen.getString("emp_position"));
										rec.set("companyid", screen.getString("companyid"));
										rec.search();
									%>
									<td class="column-text" ><%=((thislang.equals("tha"))?rec.getString("tdesc"):rec.getString("edesc"))%></td>							
								</tr>
								<tr>
									<td class="column-label" ><script language="javascript">swapLang('Job Description');</script></td>
									<%
										rec = new InitialRecord(screen.getUProfile()).getDbRecord("mjobcode");
										rec.setColumn("jobcodeid,tdesc,edesc,companyid");
										rec.set("jobcodeid", screen.getString("job"));
										rec.set("companyid", screen.getString("companyid"));
										rec.search();
									%>
									<td class="column-text" ><%=((thislang.equals("tha"))?rec.getString("tdesc"):rec.getString("edesc"))%></td>
									<td class="column-label" ><script language="javascript">swapLang('BU1');</script></td>
									<%
										rec = new InitialRecord(screen.getUProfile()).getDbRecord("mbu1");
										rec.setColumn("bu1id,tdesc,edesc,companyid");
										rec.set("bu1id", screen.getString("bu1"));
										rec.set("companyid", screen.getString("companyid"));
										rec.search();
									%>
									<td class="column-text" ><%=((thislang.equals("tha"))?rec.getString("tdesc"):rec.getString("edesc"))%></td>
								</tr>
								<tr>
									<td class="column-label" ><script language="javascript">swapLang('BU2');</script></td>
										<%
										rec = new InitialRecord(screen.getUProfile()).getDbRecord("mbu2");
										rec.setColumn("bu2id,tdesc,edesc,companyid");
										rec.set("bu2id", screen.getString("bu2"));
										rec.set("companyid", screen.getString("companyid"));
										rec.search();
									%>
									<td class="column-text" ><%=((thislang.equals("tha"))?rec.getString("tdesc"):rec.getString("edesc"))%></td>
									<td class="column-label" ><script language="javascript">swapLang('BU3');</script></td>
									<%
										rec = new InitialRecord(screen.getUProfile()).getDbRecord("mbu3");
										rec.setColumn("bu3id,tdesc,edesc,companyid");
										rec.set("bu3id", screen.getString("bu3"));
										rec.set("companyid", screen.getString("companyid"));
										rec.search();
									%>
									<td class="column-text" ><%=((thislang.equals("tha"))?rec.getString("tdesc"):rec.getString("edesc"))%></td>
								</tr>
							</table>
						<div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div>	
					<%
								DbRecord crs = new InitialRecord(screen.getUProfile()).getDbRecord("mcourse");
								crs.setColumn("crsid,crsdesc,crsedesc,companyid");
								inq = (DbInquiry) screen.getInquiry().getChild("TTRAINTRNEE");
								if(inq.recCount()>0){
										
					%>
									<table width="100%" border="0" cellpadding="0" cellspacing="0" class="table-content-list">		
										<tr>
											<td class="column-header" width="100%"><script language="javascript">swapLang('Training Plan');</script></td>
										</tr>
									</table>	
									<table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list" cols="4">
										<tr>
											<td class="column-header" width="55%" ><script language="javascript">swapLang('Course');</script></td>
											<td class="column-header" width="15%" ><script language="javascript">swapLang('Training ID');</script></td>
											<td class="column-header" width="20%" ><script language="javascript">swapLang('Between Date');</script></td>
											<td class="column-header" width="10%" ><script language="javascript">swapLang('Source');</script></td>
										</tr>
					<%
									do{
											crs.set("crsid", inq.getString("ttraining","crsid"));
											crs.set("companyid", inq.getString("ttraining","companyid"));							
					%>
										<tr>
											<td class="column-text"><a href="javascript:viewCourse('<%=inq.getString("TTRAINING","CRSID")%>');"><%=inq.getString("TTRAINING","CRSID")%>&nbsp;:&nbsp;<%=(crs.search()==1)?((thislang.equals("tha"))?crs.getString("crsdesc"):crs.getString("crsedesc")):""%></a></td>
											<td class="column-text"><a href="javascript:viewTtraining('<%=inq.getString("TRAININGID")%>');"><%=inq.getString("TRAININGID")%></a></td>
											<td class="column-text-center"><a href="javascript:viewTtraining_Time('<%=inq.getString("TRAININGID")%>');"><%//=inq.getCurrentDbRecord().getCscCalendar("CLASSDATEFRM").getDDMMYYYY()+" - "+inq.getCurrentDbRecord().getCscCalendar("CLASSDATETO").getDDMMYYYY()%><%=new CscCalendar(inq.getString("TTRAINING","CLASSDATEFRM")).getDDMMYYYY()+" - "+new CscCalendar(inq.getString("TTRAINING","CLASSDATETO")).getDDMMYYYY()%></a></td>
											<td class="column-text-center"><%=inq.getCurrentDbRecord().getSystemCode("TRNEE_REGIST")%></td>
										</tr>
									
					<%	
									}while(inq.next());
					%>
									</table>
								<div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div>	
					<%
								}
				
								inq = (DbInquiry) screen.getInquiry().getChild("HTRAINTRNEE");

								if(inq.recCount()>0){
										DbRecord stat = new InitialRecord(screen.getUProfile()).getDbRecord("mtrainstat");
										stat.setColumn("trstatid,trsuccess,companyid");
					%>
									<table width="100%" border="0" cellpadding="0" cellspacing="0" class="table-content-list">		
										<tr>
											<td class="column-header" width="100%"><script language="javascript">swapLang('Training History');</script></td>
										</tr>
									</table>	
									<table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list" cols="4">
										<tr>
											<td class="column-header" width="55%" ><script language="javascript">swapLang('Course');</script></td>
											<td class="column-header" width="15%" ><script language="javascript">swapLang('Training ID');</script></td>
											<td class="column-header" width="20%" ><script language="javascript">swapLang('Between Date');</script></td>
											<td class="column-header" width="20%" ><script language="javascript">swapLang('Pretest');</script></td>
											<td class="column-header" width="20%" ><script language="javascript">swapLang('Posttest');</script></td>
											<td class="column-header" width="10%" ><script language="javascript">swapLang('Training Result');</script></td>
										</tr>
					<%
									do{
											stat.set("trstatid", inq.getString("htraintrnee","trstatid"));
											stat.set("companyid", inq.getString("htraintrnee","companyid"));	
											crs.set("crsid", inq.getString("htraining","crsid"));
											crs.set("companyid", inq.getString("htraining","companyid"));																						
						
					%>
										<tr>
											<td class="column-text"><a href="javascript:viewCourse('<%=inq.getString("HTRAINING","CRSID")%>');"><%=inq.getString("HTRAINING","CRSID")%>&nbsp;:&nbsp;<%=(crs.search()==1)?((thislang.equals("tha"))?crs.getString("crsdesc"):crs.getString("crsedesc")):""%></a></td>
											<td class="column-text"><a href="javascript:viewHtraining('<%=inq.getString("TRAININGID")%>');"><%=inq.getString("TRAININGID")%></a></td>
											<td class="column-text-center"><%//=inq.getCurrentDbRecord().getCscCalendar("CLASSDATEFRM").getDDMMYYYY()+" - "+inq.getCurrentDbRecord().getCscCalendar("CLASSDATETO").getDDMMYYYY()%><%=new CscCalendar(inq.getString("HTRAINING","CLASSDATEFRM")).getDDMMYYYY()+" - "+new CscCalendar(inq.getString("HTRAINING","CLASSDATETO")).getDDMMYYYY()%></td>
											<td class="column-text-center"><%=chk.chkNullString(inq.getString("PRETEST"),"0.00")%></td>
											<td class="column-text-center"><%=chk.chkNullString(inq.getString("POSTTEST"),"0.00")%></td>
											<td class="column-text-center"><%=(stat.search()==1)?stat.getSystemCode("trsuccess"):""%></td>

										</tr>
									
					<%	
									}while(inq.next());
					%>
									</table>
					<%
								}
					%>				
	</form>
	</div>
  </div>
      <!-- End Main Content -->
      <!-- InstanceEndEditable -->    </div>
  </div>
  <div id="footer"><!-- InstanceBeginEditable name="footer" -->
  <jsp:include page="EMV_FOOTER.jsp" flush="true" />
  <!-- InstanceEndEditable -->  </div>
</div>
</body>
<!-- InstanceEnd --></html>