<%@ 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"> <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%"> <%=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%"> <%=ds_emp.getString("employeeid")%></td> <td class="column-text" width="20%" rowspan="5"> </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" > <%=ds_emp.getString("position_"+lang)%></td> <td class="column-header-right" nowrap><script language="javascript">swapLang('BU1');</script></td> <td class="column-text" > <%=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" > <%=ds_emp.getString("bu2_"+lang)%></td> <td class="column-header-right" nowrap><script language="javascript">swapLang('BU3');</script></td> <td class="column-text" > <%=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"> <%=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"> </td> </tr> </table> <% } ds_emp.closeConnection(); } %>