<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@ page import="com.csc.library.database.*,com.csc.library.session.*, com.csc.library.download.FileDownloadUtils2, com.csc.library.utilities.*"  %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="screen" class="com.csc.library.system.Task" scope="page"/>
<%	
		CheckNull chk = new CheckNull();
		ThaiUtilities chkChar = new ThaiUtilities();
		screen.setChannel(request,response);
		screen.checkProfile();
		if(screen.getUProfile() != null){
			DataSet ds_emp = new DataSet();
			ds_emp.setInfo(
					"select emp.employeeid, picture "+
					", mprefix.tdesc+emp.fname+' '+emp.lname name_tha "+
					", mprefix.edesc+emp.efname+' '+emp.elname name_eng "+
					", mbu1.tdesc bu1_tha, mbu1.edesc bu1_eng "+
					", mbu2.tdesc bu2_tha, mbu2.edesc bu2_eng "+
					", mbu3.tdesc bu3_tha, mbu3.edesc bu3_eng "+
					", mposition.tdesc position_tha, mposition.edesc position_eng "+
					", mbranch.tdesc branch_tha, mbranch.edesc branch_eng "+ 
				"from	(	select employeeid, emp_prefix, fname, lname, efname, elname "+
								", bu1, bu2, bu3, emp_position, branch, bossid "+
							"from memployee "+
							"where employeeid = '"+chk.chkNullString(request.getParameter("employeeid"))+"' "+
						") as emp "+
					"left outer join mbu1 on bu1id = emp.bu1 "+
					"left outer join mbu2 on bu2id = emp.bu2 "+
					"left outer join mbu3 on bu3id = emp.bu3 "+
					"left outer join mprefix on prefixid = emp.emp_prefix "+
					"left outer join mposition on positionid = emp.emp_position "+
					"left outer join mbranch on branchid = emp.branch "+
					"left outer join memployee boss on boss.employeeid = emp.bossid "+
					"left outer join mprefix prefix_boss on prefix_boss.prefixid = boss.emp_prefix "
					, (String)screen.getUProfile().get("dbname"), "tapstran");
			ds_emp.initConnection(screen.getUProfile());
			if(ds_emp.next()){
				String lang = screen.getUProfile().get("lang");

				FileDownloadUtils2 utils = new FileDownloadUtils2();
				utils.setUploadField("memployee", "picture");
				utils.setFilename(ds_emp.getString("picture"));
				String url = utils.getViewUrl();
%>
	<script language="JavaScript"  type="text/javascript" src="../JS/UTILITIES.js"></script>
	<div class="content-header">
		<div align="left">
			&nbsp;<script language="JavaScript">swapLang('Personal Information')</script>
		</div>
	</div>
	<table   border="0" cellpadding="0" cellspacing="1" class="table-content-list" colspan = "6" width="100%">	
		<tr>
			<td class="column-header-right" width="10%" nowrap><script language="javascript">swapLang('Name Surname');</script></td>
			<td class="column-text"  width="25%">&nbsp;<%=ds_emp.getString("name_"+lang)%></td>
			<td class="column-header-right" width="10%" nowrap><script language="javascript">swapLang('Employee ID');</script></td>
			<td class="column-text"  width="25%">&nbsp;<%=ds_emp.getString("employeeid")%></td>
			<td class="column-text"  width="20%" rowspan="5">&nbsp;</td>
			<td class="column-text-center"  width="10%" rowspan="5"><div class="employee-pic"><img id="employeepic" src="<%=url%>" alt="Employee Picture"  border="1" class="border-black" onload="resizeImg(this,95,95);" /></div></td>
		</tr>
		<tr>
			<td class="column-header-right" nowrap><script language="javascript">swapLang('Position');</script></td>
			<td class="column-text" >&nbsp;<%=ds_emp.getString("position_"+lang)%></td>
			<td class="column-header-right" nowrap><script language="javascript">swapLang('BU1');</script></td>
			<td class="column-text" >&nbsp;<%=ds_emp.getString("bu1_"+lang)%></td>
		</tr>
		<tr>
			<td class="column-header-right" nowrap><script language="javascript">swapLang('BU2');</script></td>
			<td class="column-text" >&nbsp;<%=ds_emp.getString("bu2_"+lang)%></td>
			<td class="column-header-right" nowrap><script language="javascript">swapLang('BU3');</script></td>
			<td class="column-text" >&nbsp;<%=ds_emp.getString("bu3_"+lang)%></td>
		</tr>
		<tr>
			<td class="column-header-right" nowrap><script language="javascript">swapLang('Branch');</script></td>
			<td class="column-text" colspan="3">&nbsp;<%=ds_emp.getString("branch_"+lang)%></td>
		</tr>
		<tr>
			<td class="column-header-right" nowrap><script language="javascript">swapLang('Boss');</script></td>
			<td class="column-text" colspan="3">&nbsp;</td>
		</tr>
	</table>
	<%		}
				ds_emp.closeConnection();
			}
	%>