<%@ page contentType="text/html; charset=UTF-8" language="java" %> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,java.text.*,com.csc.library.databean.*,java.util.Enumeration"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <% request.setCharacterEncoding("UTF-8"); %> <jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page"/> <jsp:setProperty name="EMV" property="appname" value="empview" /> <% CheckNull chk=new CheckNull(); DecimalFormat df = new DecimalFormat("#,###,##0.00"); DecimalFormat df2 = new DecimalFormat("00"); EMV.setChannel(request, response); HelpEntry screen = (HelpEntry) EMV.process("HelpEntry","EMV_PAYSLIP_REHELP"); screen.inq.setFilter(" EMPLOYEEID='"+screen.getUProfile().get("employeeid")+"'"); screen.inq.refresh(); screen.inq.next(); String paymentDate = screen.getInquiry().getChild("tpy_his0").getString("gendate"); int PeriodMonth = Integer.parseInt(chk.chkNullString(request.getParameter("PERIOD_MONTH"),"")); int PeriodYear = Integer.parseInt(chk.chkNullString(request.getParameter("PERIOD_YEAR"),"")); %> <!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=UTF-8" /> <!-- 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_DEFAULT.css" /> <link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT.css" /> <link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT_ONE.css" /> <link rel="stylesheet" type="text/css" href="../CSS/EMV_TEXT.css" /> <style type="text/css"> .bg-gray { background: #ddd !important; } </style> --> <!-- End CSS Links --> <!-- Begin Scripts --> <script language="JavaScript" type="text/javascript"src="../JS/EVENTS.js"></script> <script language="JavaScript" type="text/javascript" src="../JS/UTILITIES.js"></script> <script language="JavaScript" type="text/javascript"src="../JS/ACTIVE_OBJECT.js"></script> <!-- Begin script for Dropdown Menu --> <!-- DO NOT EDIT --> <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/SCREEN.js"></script> <script language="JavaScript" type="text/javascript"> setLang("<%=screen.getUProfile().get("lang")%>"); setPageTitle(swap2String("Working Information")); function viewData(){ with(document.cscform){ if(__employeeid.value!=""){ __cmd.value="search"; var m= months.value; if(m<10){ m="0"+m; } FILTERDATE.value="gendate>='"+years.value+"-"+m+"-"+"01' and gendate <='"+years.value+"-"+m+"-"+"31'"; mm.value=m; yyyy.value=years.value; submit(); }else{ alert(MyCode[0]); } } } </script> <style> .inc-desc{ font-family: Cordia New; font-size: 14.0px; font-weight: bold; } .emp-info{ font-family: Cordia New; font-size: 12.0px; font-weight: bold; } .emp-info-normal{ font-family: Cordia New; font-size: 12.0px; } </style> <!-- End Scripts --> <!-- Begin Head --> <!-- End Head --> <!-- InstanceEndEditable --> </head> <body> <table style="width: 600px" cellpadding="0" cellspacing="0" border="0" bgcolor="white" align="center"> <tr> <td style="width: 150px"><img src="../IMAGES/EMPVIEW/HondaLogoLessing.jpg" width="118" height="25"/><br><span style="font-family: Cordia New; font-size: 12.0px; font-weight: bold;">Honda Leasing (Thailand) Co.,Ltd.</span></td> <td style="width: 250px"><span style="font-family: Cordia New; font-size: 12.0px; font-weight: bold;">บริษัท ฮอนด้า ลีสซิ่ง (ประเทศไทย) จำกัด</span><br><span style="font-family: Cordia New; font-size: 10.0px; font-style: italic;">2784 Soi Sukumvit 66/1, Bangna,Bangkok 10260 Telephone (662) 736-4200</span></td> <td style="width: 200px" ><span style="font-family: sansserif; font-size: 24.0px;">e-Payslip</span></td> </tr> </table> <table style="width: 600px" cellpadding="0" cellspacing="0" border="0" bgcolor="white" align="center"> <tr valign="top"> <td colspan="3"> </td> </tr> <tr> <td style="width: 250px"><span class="emp-info">ประจำเดือน (Of the month) : <%=new CscCalendar(PeriodYear,PeriodMonth,1).getThaiLongMonth()+" "+PeriodYear%> </span></td> <td style="width: 350px" colspan="2"><span class="emp-info">วันที่จ่ายเงิน (Payment Date) :<%=new CscCalendar(paymentDate).getDate()+" "+new CscCalendar(paymentDate).getThaiLongMonth()+" "+PeriodYear%> </span></td> </tr> <tr> <td style="width: 250px"><span class="emp-info">ชื่อ-นามสกุล (Employee Name) : <%=screen.getString("FULLNAME")%></span></td> <td style="width: 175px"><span class="emp-info">รหัสพนักงาน (Employee Code) : <%=screen.getString("EMPLOYEEID")%></span></td> <td style="width: 175px"><span class="emp-info">วันที่เริ่มทำงาน (Hire Date) : <%=new CscCalendar( screen.getString("startdate")).getDate()+" "+new CscCalendar( screen.getString("startdate")).getThaiLongMonth()+" "+new CscCalendar( screen.getString("startdate")).getYear()%></span></td> </tr> <tr> <td style="width: 250px"><span class="emp-info">ตำแหน่ง (Position) : <%=screen.getInquiry().getChild("mposition").getString("tdesc")%></span></td> <td style="width: 350px" colspan="2"><span class="emp-info">หน่วยงาน (Organization) : <%=screen.getInquiry().getChild("mbu3").getString("tdesc")%></span></td> </tr> <tr> <!-- <td><span class="emp-info"> </span></td> --> <td><span class="emp-info" >สถานที่ปฎิบัติงาน (Location) :</span></td> </tr> </table> <table style="width: 600px" cellpadding="0" cellspacing="0" border="0" bgcolor="white" align="center"> <tr valign="top"> <td colspan="42"> </td> </tr> <tr valign="top"> <td colspan="42"><span style="font-family: Cordia New; color: #FF0000; font-size: 12.0px; font-weight: bold;">หมายเหตุ บริษัทถือว่าข้อความในเอกสารฉบับนี้เป็นความลับ ห้ามเปิดเผยให้ผู้อื่นทราบโดยเด็ดขาด</span></td> </tr> <tr valign="top"> <td colspan="42"><span style="font-family: Cordia New; font-size: 12.0px; font-style: italic;">Please Use this e-letter as the payroll or other income payment slip. The infomation is confidential. please do not reveal it to any one.</span></td> </tr> </table> <table style="width: 600px" cellpadding="0" cellspacing="0" border="0" bgcolor="white" align="center"> <tr valign="top"> <td colspan="3" style="width:300px; background-color: #FF9999; border-top: solid 1px #000000; border-left: solid 1px #000000; border-bottom:1px solid #000000;text-align:center" ><span class="inc-desc">รายได้(Earnings)</span></td> <td colspan="3" style="width:300px; background-color: #FF9999; border-top: solid 1px #000000; border-left: solid 1px #000000; border-bottom:1px solid #000000; border-right:1px solid #000000;text-align:center" ><span class="inc-desc">รายการหัก(Deductions)</span></td> </tr> <tr valign="top"> <td style="width:200px; background-color: #FFCCCC; border-left: solid 1px #000000; border-bottom:1px solid #000000;text-align:center" ><span class="inc-desc">รายละเอียด (Description)</span></td> <td style="width:50px; background-color: #FFCCCC; border-left: solid 1px #000000; border-bottom:1px solid #000000;text-align:center" ><span class="inc-desc">Hours</span></td> <td style="width:50px; background-color: #FFCCCC; border-left: solid 1px #000000; border-bottom:1px solid #000000;text-align:center" ><span class="inc-desc">Amount</span></td> <td style="width:200px; background-color: #FFCCCC; border-left: solid 1px #000000; border-bottom:1px solid #000000;text-align:center" ><span class="inc-desc">รายละเอียด (Description)</span></td> <td style="width:50px; background-color: #FFCCCC; border-left: solid 1px #000000; border-bottom:1px solid #000000;text-align:center" ><span class="inc-desc">Hours</span></td> <td style="width:50px; background-color: #FFCCCC; border-left: solid 1px #000000; border-bottom:1px solid #000000;border-right:1px solid #000000;text-align:center" ><span class="inc-desc">Amount</span></td> </tr> <% double incomes=0; double deducts=0; for(int i=1;i<=15;i++){ double income = new CheckNull().chkNullStringToDouble(screen.getInquiry().getChild("tpy_his0").getString("incformula"+df2.format(i))); double deduct = new CheckNull().chkNullStringToDouble(screen.getInquiry().getChild("tpy_his0").getString("expformula"+df2.format(i))); //out.print(deduct+"<br>"); incomes+=income; deducts+=deduct; %> <tr valign="top"> <td style="border-left: solid 1px #000000;"><span class="inc-desc"> <%=screen.getInquiry().getChild("tpy_his0").getString("inccaption"+df2.format(i))%></span></td> <td style="border-left: solid 1px #000000;"><span class="inc-desc"> </span></td> <td style="border-left: solid 1px #000000;text-align:right;padding-right:2px;"><span class="inc-desc"> <%=(income>0?df.format(income):"")%></span></td> <td style="border-left: solid 1px #000000;"><span class="inc-desc"> <%=screen.getInquiry().getChild("tpy_his0").getString("expcaption"+df2.format(i))%></span></td> <td style="border-left: solid 1px #000000;"><span class="inc-desc"> </span></td> <td style="border-left: solid 1px #000000;border-right: solid 1px #000000;text-align:right;padding-right:2px;"> <span class="inc-desc"><%=(deduct>0?df.format(deduct):"")%></span></td> </tr> <%}%> <tr valign="top"> <td style="width:250px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000;" colspan="2"><span class="inc-desc"> รวมรายได้ (Gross Earning)</span></td> <td style="width:50px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000;text-align:right;padding-right:2px;"><span class="inc-desc"><%=df.format(incomes)%></span></td> <td style="width:250px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000;" colspan="2"><span class="inc-desc"> รวมรายหัก (Gross Deductions)</span></td> <td style="width:50px; border: solid 1px #000000;text-align:right;padding-right:2px;"><span class="inc-desc"><%=df.format(deducts)%></span></td> </tr> <tr valign="top"> <td style="width:250px;" colspan="3"> </td> <td style="width:250px; border-left: solid 1px #000000; border-bottom: solid 1px #000000;" colspan="2"><span class="inc-desc"> เงินได้สุทธิ (Net Pay)</span></td> <td style="width:50px; border-left: solid 1px #000000; border-bottom: solid 1px #000000;border-right: solid 1px #000000;text-align:right;padding-right:2px;"><span class="inc-desc"><%=df.format(incomes-deducts)%></span></td> </tr> <table> <br> <table style="width: 600px" cellpadding="0" cellspacing="0" border="0" bgcolor="white" align="center"> <tr valign="top"> <td style="width:85px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info">เงินเดือนทั้งปี<br/>Salary YTD</span></td> <td style="width:85px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000; text-align: center;"><span class="emp-info">รายได้อื่นทั้งปี<br/>Other Income YTD</span></td> <td style="width:85px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000; text-align: center;"><span class="emp-info">ภาษีทั้งปี<br/>TAX YTD</span></td> <td style="width:85px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000; text-align: center;"><span class="emp-info">ประกันสังคมทั้งปี<br/>Social Security YTD</span></td> <td style="width:90px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000; text-align: center;"><span class="emp-info">เงินกองทุนฯสะสมทั้งปี<br/>Provident Fund YTD</span></td> <td style="width:85px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000; text-align: center;"><span class="emp-info">รายการหักอื่นทั้งปี<br/>Other Deduct YTD</span></td> <td style="width:85px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000; border-right: solid 1px #000000; text-align: center;"><span class="emp-info">รายได้สุทธิทั้งปี<br/>Net Income YTD</span></td> </tr> <tr valign="top"> <td style="width:85px; border-left: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("salary_ytd")))%></span></td> <td style="width:85px; border-left: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("other_income_ytd")))%></span></td> <td style="width:85px; border-left: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("tax_ytd")))%></span></td> <td style="width:85px; border-left: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("social_ytd")))%></span></td> <td style="width:90px; border-left: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("pvf_ytd")))%></span></td> <td style="width:85px; border-left: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("other_deduct_ytd")))%></span></td> <td style="width:85px; border-left: solid 1px #000000; border-bottom: solid 1px #000000; border-right: solid 1px #000000;text-align: center;"><span class="emp-info"> <%=df.format(Double.parseDouble(screen.getInquiry().getString("salary_ytd"))+Double.parseDouble(screen.getInquiry().getString("other_income_ytd"))-Double.parseDouble(screen.getInquiry().getString("tax_ytd"))-Double.parseDouble(screen.getInquiry().getString("social_ytd"))-Double.parseDouble(screen.getInquiry().getString("pvf_ytd"))- Double.parseDouble(screen.getInquiry().getString("other_deduct_ytd")))%> </span></td> </tr> </table> <br> <table style="width: 600px" cellpadding="0" cellspacing="0" border="0" bgcolor="white" align="center"> <tr valign="top"> <td style="width:85px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000;border-right: solid 1px #000000;text-align: center;"><span class="emp-info">บัญชีธนาคาร<br/>Bank Account/Branch</span></td> <td style="width:85px; "> </td> <td style="width:120px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info">เงินกองทุนสำรองฯส่วนพนักงาน<br/>PVF Employee Accum.</span></td> <td style="width:120px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info">เงินกองทุนสำรองฯส่วนบริษัท<br/>PVF Company Accum.</span></td> <td style="width:120px; border-left: solid 1px #000000; border-top: solid 1px #000000; border-bottom: solid 1px #000000;border-right: solid 1px #000000;text-align: center;"><span class="emp-info">เงินกองทุนสำรองฯรวม<br/>PVF Total</span></td> <td style="width:35px; "> </span></td> <td style="width:35px; "> </td> </tr> <tr valign="top"> <td style="border-left: solid 1px #000000; border-bottom: solid 1px #000000;border-right: solid 1px #000000;text-align: center;"><span class="emp-info"><%=screen.getInquiry().getChild("mempl_bank").getString("bankid")%> <%=screen.getInquiry().getChild("mempl_bank").getString("accountid")%></span></td> <td> </td> <td style="border-left: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("emp_pvf")))%></span></td> <td style="border-left: solid 1px #000000; border-bottom: solid 1px #000000;text-align: center;"><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("com_pvf")))%></span></td> <td style="border-left: solid 1px #000000; border-bottom: solid 1px #000000;border-right: solid 1px #000000;text-align: center;" ><span class="emp-info"><%=df.format(Double.parseDouble(screen.getInquiry().getString("emp_pvf"))+Double.parseDouble(screen.getInquiry().getString("com_pvf")))%></span></td> <td> </span></td> <td> </td> </tr> </table> <br> <table style="width: 600px" cellpadding="0" cellspacing="0" border="0" bgcolor="white" align="center"> <tr> <td style="width: 300px"> </td> <td style="width: 300px"><span class="emp-info"><b>เรียน ท่านผู้เกี่ยวข้อง</b></span><br><span class="emp-info-normal">เอกสารฉบับนี้เป็นเอกสารสำคัญ มีลายเซนต์ผู้มีอำนาจลงนามจากระบบอิเลคทรอนิคส์<br/>ออกโดย บริษัท ฮอนด้า ลีสซิ่ง (ประเทศไทย) จำกัด ซึ่งสามารถใช้แทนหนังสือรับรอง<br/>การทำงานและหนังสือรับรองเงินเดือนได้</span></td> </tr> <tr> <td colspan="2"> </td> </tr> <tr> <td style="width: 300px"> </td> <td style="width: 300px"><span class="emp-info"><b>To whom it may concern</b></span><br><span class="emp-info-normal">This is certify that document is electronically issued with the authorized<br/>person's signature by Honda Leasing (Thailand) Co.,Ltd. The document<br/>can be used as a reference for employment status and salary verification.</span></td> </tr> </table> <br> <br> <table style="width: 600px" cellpadding="0" cellspacing="0" border="0" bgcolor="white" align="center"> <tr> <td style="width: 450px" colspan="3"> </td> <td style="width: 150px" align="center" > <img src="HondaPic/signature.jpg" border="0"/></td> </tr> <tr> <td style="width: 450px" colspan="3"> </td> <td style="width: 150px" align="center" ><span class="emp-info">Date : <%=new CscCalendar().getDate()+" "+new CscCalendar().getThaiLongMonth()+" "+new CscCalendar().getEngYYYY()%></span></td> </tr> </table> </body> </html>