<%@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.util.*"%> <%@page import="com.csc.library.utilities.CscCalendar,com.csc.library.entry.HelpEntry,com.csc.library.system.*"%> <%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.formula.FormulaString" %> <%@page import="com.csc.library.timeattendance.DayShift,com.csc.library.timeattendance.Shift,com.csc.library.timeattendance.WorkingShift" %> <%@page import="java.text.DecimalFormat" %> <% request.setCharacterEncoding("UTF-8"); %> <jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page" /> <jsp:setProperty name="EMV" property="appname" value="empview" /> <% EMV.setChannel(request, response); HelpEntry screen = (HelpEntry)EMV.process("HelpEntry", "PI_LEAVEHELP"); screen.inq.setFilter("employeeid = '"+EMV.getUProfile().getEmvEmpId()+"' "); screen.inq.refresh(); screen.nextRec(); CscCalendar cs=new CscCalendar(); FormulaString fs = new FormulaString(); CheckNull chkNull=new CheckNull(); String empid =chkNull.chkNullString(request.getParameter("__employeeid"),screen.getString("employeeid")); %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <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_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" /> <style type=text/css> <!-- font.error { color: #FF0000; } --> </style> <!-- 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">setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="JavaScript" type="text/javascript"> function pageDesc(lv, desc){ with(document.cscform){ var emp=__empID.value; var a=chkDateTime1(date1.value); var b=chkDateTime1(date2.value); //alert(date1.value+"==="+date2.value); var lv_filter="lv_type='"+lv+"'"; __fixCon.value=" employeeid='"+emp+"' and (dateid between '"+date1.value+"' and '"+date2.value+"') and "+lv_filter; //alert(__fixCon.value); window.open("PI_LEAVEDESC.jsp?__cmd="+ "&__date1="+a+"&__date2="+b+ "&__empID="+__empID.value+"&__empName="+__empName.value+ "&__lv_desc="+desc+ "&__fixCon="+__fixCon.value, "Tleave_summary","left=150,top=100,width=700,height=300,toolbar=no,status=yes,scrollbars=yes,resizable=yes" ); //submit(); } } </script> <style type="text/css"> #header { background: #FFFFFF ; } </style> <!-- End Scripts --> <!-- Begin Head --> <!-- 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="sidebar"><!-- InstanceBeginEditable name="side_bar" --> <jsp:include page="EMV_SIDEBAR.jsp" flush="true" /> <!-- InstanceEndEditable --> </div> <div id="content"><!-- InstanceBeginEditable name="main_content" --> <jsp:include page="EMV_HELPBAR.jsp" flush="true" /> <!-- Begin Main Content --> <div class="content"> <form name="cscform" method="post" action="PI_LEAVE.jsp"> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__screen" value="PI_LEAVE"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__helpReturn" value=""> <input type="hidden" name="__helpName" value=""> <input type="hidden" name="__pageCall" > <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__calendar"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__fixCon" > <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__childFilter" > <input type="hidden" name="__empID" value="<%=screen.getString("employeeid")%>"> <input type="hidden" name="__empName" value="<%=screen.getString("fullname")%>"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <% String d1 = ""; String d2 = ""; CscCalendar c1 = null; CscCalendar c2 = null; try { d1 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1001"); d2 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1002"); if (d1!=null && d2!=null && !d1.equals("") && !d2.equals("")) { c1 = new CscCalendar(d1); c2 = new CscCalendar(d2); } } catch (Exception e) {} %> <div class="content-box2"> <div class="content-header"><h2><script language="javascript">swapLang('Employee Privilege Leave')</script> <% //out.println(c1+" : "+c2); if (c1!=null && c2!=null && !c1.equals(c2)) { if (screen.getUProfile().get("lang").equalsIgnoreCase("tha")) { out.println("["+c1.getDDThaiYYYY()+" - "+c2.getDDThaiYYYY()+"]"); } else { out.println("["+c1.getDDEngYYYY()+" - "+c2.getDDEngYYYY()+"]"); } } %> </h2></div> <table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list"> <tr> <td width="44%" class="column-header" rowspan="2"><script language="javascript">swapLang('Leave Type')</script></td> <td width="14%" class="column-header"><script language="javascript">swapLang('Limit Last Year')</script></td> <td width="14%" class="column-header"><script language="javascript">swapLang('Limit')</script></td> <td width="14%" class="column-header"><script language="javascript">swapLang('Used')</script></td> <td width="14%" class="column-header"><script language="javascript">swapLang('Remain')</script></td> </tr> <tr> <td class="column-header"><script language="javascript">swapLang('DD HH')</script></td> <td class="column-header"><script language="javascript">swapLang('DD HH')</script></td> <td class="column-header"><script language="javascript">swapLang('DD HH')</script></td> <td class="column-header"><script language="javascript">swapLang('DD HH')</script></td> </tr> <% //String vacation0_get = "00:00:00"; String vacation0 = "00:00:00"; String vacation1 = "00:00:00"; DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee"); inqEmp.setSchemaName(screen.getUProfile().getSchemaName()); inqEmp.setFilter("employeeid='"+EMV.getUProfile().getEmvEmpId()+"'"); inqEmp.setColumn("employeeid, companyid, emp_level, vacation0, vacation1"); inqEmp.refresh(); if (inqEmp.next()){ vacation0 = inqEmp.getString("vacation0"); vacation1 = inqEmp.getString("vacation1"); //vacation0_get = inqEmp.getString("vacation0_get"); } %> <% String cFont = ""; String c_limit = ""; String c_used = ""; String c_remain = ""; String fld = getMConfigValue(screen.getUProfile(), "TALVFD"); DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("Meventgrp1"); inq.setSchemaName(screen.getUProfile().getSchemaName()); inq.setFilter("(daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9') and display=1 and branchid = (select " +fld+" from MEMPLOYEE where EMPLOYEEID = '" + empid + "')"); inq.setColumn("*"); inq.setOrderBy("display_order"); inq.refresh(); while(inq.next()){ String a="simmemployee_tadjtime0$"+ inq.getString("eventgrpid"); String b= inq.getString("eventgrpid"); String type = inq.getString("daytype"); String dis_limit = inq.getString("display_limit"); if (screen.inq.getString(a+"_remain").indexOf('-')>-1) { cFont = "error"; } else cFont = ""; c_limit = screen.inq.getString(a+"_limit"); c_used = screen.inq.getString(a+"_used"); c_remain = screen.inq.getString(a+"_remain"); String leaveadvance = chkNull.chkNullString(screen.inq.getString(a+"_leaveadvance")); String list[] = {vacation0,vacation1,c_used,c_remain}; if (type.equals("7")) { if (vacation0.equals("")) { vacation0 = "00:00:00"; } if (vacation1.equals("")) { vacation1= "00:00:00"; } list[0] = vacation0; list[1] = vacation1; } else { list[0] = ""; list[1] = c_limit; } %> <tr> <td class="column-text"> <% if (screen.inq.getString(a+"_used").equals("") || screen.inq.getString(a+"_used").equals("00:00:00")) { %> <font class="<%=cFont%>"><%=screen.inq.getString(a+"_desc")%></font> <% } else { %> <a href="javascript:pageDesc('<%=b%>','<%=screen.inq.getString(a+"_desc")%>')"><font class="<%=cFont%>"><%=screen.inq.getString(a+"_desc")%></font></a> <% } %> <%if(type.equals("7") && leaveadvance.length() > 0){%> <font class='error'>(<script language="javascript">swapLang("Leave Advance");</script> <%=leaveadvance%>)</font> <%}%> </td> <td class="column-text-right"> <font class="<%=cFont%>"><%=getDDHH(list[0])%> </font> </td> <td nowrap="nowrap" class="column-text-right"> <font class="<%=cFont%>"><%=(dis_limit.equals("1"))?getDDHH(list[1]):"00:00"%> </font> </td> <td nowrap="nowrap" class="column-text-right"> <font class="<%=cFont%>"><%=getDDHH(list[2])%> </font> </td> <td nowrap="nowrap" class="column-text-right"> <font class="<%=cFont%>"><%=(dis_limit.equals("1"))?getDDHH(list[3]):"00:00"%> </font> </td> </tr> <% } %> </table> <input type="hidden" name="date1" value="<%=screen.inq.getString("$date_begin")%>"> <input type="hidden" name="date2" value="<%=screen.inq.getString("$date_end")%>"> <div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div> </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> <%! public String getDDHH(String fm){ String tmp = ""; try { String dat[] = fm.split(":"); tmp = dat[0] + ":" + dat[1] ; }catch(Exception e){ e.printStackTrace(); } return tmp ; } public String getMConfigValue(UProfile upf, String filed){ String srt = ""; try { srt = (String) StaticConfig.getConfigCompany(upf, filed) ; }catch(Exception e){ e.printStackTrace(); } return srt ; } %>