<%@page contentType="text/html; charset=TIS620" 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="java.text.DecimalFormat" %> <% request.setCharacterEncoding("TIS620"); %> <jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page" /> <jsp:setProperty name="EMV" property="appname" value="empview" /> <% EMV.setChannel(request, response); CscCalendar cs = new CscCalendar(); CscCalendar cs1 = new CscCalendar("01-"+cs.getMM()+"-"+cs.getYear()); CscCalendar cs2 = new CscCalendar(cs.getEndDateOfMonth()+"-"+cs.getMM()+"-"+cs.getYear()); if (request.getParameter("date_start")!=null && request.getParameter("date_end")!=null) { cs1 = new CscCalendar(request.getParameter("date_start")); cs2 = new CscCalendar(request.getParameter("date_end")); } CheckNull chk = new CheckNull(); String displayLate = chk.chkNullString((String) request.getParameter("display_late")); String displayAbsent = chk.chkNullString((String) request.getParameter("display_absent")); String displayLeave = chk.chkNullString((String) request.getParameter("display_leave")); String displayOT = chk.chkNullString((String) request.getParameter("display_ot")); HelpEntry screen = (HelpEntry) EMV.process("HelpEntry", "PI_WORKINGTIMEHELP"); String filter = "employeeid = '"+EMV.getUProfile().getEmvEmpId()+"' "+ "and (dateid between '"+cs1.getYYYYMMDD()+"' and '"+cs2.getYYYYMMDD()+"')"; String filter_display = ""; if (displayLate.equals("on")) { filter_display = " (lt>0) "; } if (displayAbsent.equals("on")) { if (!filter_display.equals("")) { filter_display += " or (eventgrp='J') "; } else filter_display = " (eventgrp='J') "; } if (displayLeave.equals("on")) { if (!filter_display.equals("")) { filter_display += " or (m_lv>0 and (tr_type like 'A%')) "; } else filter_display = " (m_lv>0 and (tr_type like 'A%')) "; } if (displayOT.equals("on")) { if (!filter_display.equals("")) { filter_display += " or (ac_ot>0) "; } else filter_display = " (ac_ot>0) "; } if (!filter_display.equals("")) { filter += " and ("+filter_display+")"; } screen.inq.setFilter(filter); screen.inq.refresh(); //screen.nextRec(); FormulaString fs = new FormulaString(); DecimalFormat df = new DecimalFormat("0.00"); DecimalFormat df2 = new DecimalFormat("00.00"); %> <script language="JavaScript" type="text/javascript" src="../JS/EVENTS.js"></script> <script language="JavaScript" type="text/javascript" src="../JS/DDMENU.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> <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> <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.holiday { color: #FF00FF; } font.week { color: #FF0000; } font.absent { color: #0000FF; text-decoration: blink; } --> </style> <div class="content"> <form name="cscform" method="post" action="?"> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__screen" value="TAU_CSCWF_WORKINGTIME"> <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" > <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <div class="content-box2"> <div class="content-header"><h2><script language="javascript">swapLang('Working Time Detail')</script></h2></div> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="table-search-condition"> <tr> <td class="column-input"> <strong><script language="javascript">swapLang('Date')</script></strong> <% if (request.getParameter("date_start")==null) { %> <input name="date_start" type="text" value="<%=cs1.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('วN1aAิeมต้1(DDMMYYYY)')" onMouseOut="toolTip()"> <% } else {%> <input name="date_start" type="text" value="<%=request.getParameter("date_start")%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('วN1aAิeมต้1(DDMMYYYY)')" onMouseOut="toolTip()"> <% }%> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar1','','../IMAGES/EMPVIEW/ICON_CALENDAR.gif',1)"> <img src="../IMAGES/EMPVIEW/ICON_CALENDAR.gif" name="calendar1" width="20" height="20" border="0" align="absmiddle" onClick="viewCal('date_start')" alt="Calendar"></a> - <% if (request.getParameter("date_end")==null) { %> <input name="date_end" type="text" value="<%=cs2.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('วN1Eิ้1EOด(DDMMYYYY)')" onMouseOut="toolTip()"> <% } else {%> <input name="date_end" type="text" value="<%=request.getParameter("date_end")%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('วN1Eิ้1EOด(DDMMYYYY)')" onMouseOut="toolTip()"> <% }%> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar2','','../IMAGES/EMPVIEW/ICON_CALENDAR.gif',1)"> <img src="../IMAGES/EMPVIEW/ICON_CALENDAR.gif" name="calendar2" width="20" height="20" border="0" align="absmiddle" onClick="viewCal('date_end')" alt="Calendar"></a> <a href="javascript:search();"><img src="../IMAGES/EMPVIEW/BUTTON/SEARCH.gif" width="60" height="23" border="0" align="absmiddle" /></a></td> </table> <table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list"> <tr> <!--nuiss edit 15/10/2551 --> <!-- จO! width="10%" aป็1 width="12%"--> <td width="12%" class="column-header"><script language="javascript">swapLang('Date')</script></td> <td width="6%" class="column-header"><script language="javascript">swapLang('Day')</script></td> <!-- จO! width="12%" aป็1 width="14%"--> <td width="14%" class="column-header"><script language="javascript">swapLang('Working Time')</script></td> <td width="14%" class="column-header"><script language="javascript">swapLang('SwipeTime')</script></td> <td width="10%" class="column-header"><script language="javascript">swapLang('Day Type')</script></td> <td width="5%" class="column-header"><script language="javascript">swapLang('Late')</script></td> <td width="5%" class="column-header"><script language="javascript">swapLang('Absent')</script></td> <td width="5%" class="column-header"><script language="javascript">swapLang('Leave')</script></td> <td width="5%" class="column-header"><script language="javascript">swapLang('OT')</script></td> <!-- จO! width="5%" aป็1 width="4%"--> <td width="4%" class="column-header"><script language="javascript">swapLang('OT1')</script></td> <td width="4%" class="column-header"><script language="javascript">swapLang('OT1.5')</script></td> <td width="4%" class="column-header"><script language="javascript">swapLang('OT2')</script></td> <td width="4%" class="column-header"><script language="javascript">swapLang('OT3')</script></td> <td width="4%" class="column-header"><script language="javascript">swapLang('Work')</script></td> <td width="4%" class="column-header"><script language="javascript">swapLang('Other')</script></td> </tr> <% HashMap hmHoliday = new HashMap(); try { DbInquiry inqHoliday = new InitialInquiry(screen.getUProfile()).getDbInquiry(); inqHoliday.setSchemaName(screen.getUProfile().getSchemaName()); inqHoliday.initMyTable("Mholiday1", "", ""); inqHoliday.setColumn("*"); DbInquiry inqTime = new InitialInquiry(screen.getUProfile()).getDbInquiry(); inqTime.setSchemaName(screen.getUProfile().getSchemaName()); inqTime.initMyTable("Mtime0", "", ""); inqTime.setColumn("*"); inqTime.putChild(inqHoliday); DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry(); inqEmp.setSchemaName(screen.getUProfile().getSchemaName()); inqEmp.initMyTable("Memployee", "employeeid='"+EMV.getUProfile().getEmvEmpId()+"'", ""); //inqEmp.setColumn("*"); inqEmp.setColumn("employeeid,companyid,fname,lname,efname,elname,emp_prefix,emp_level,time0,bu1,bu2,bu3,bu4,bu5"); inqEmp.putChild(inqTime); inqEmp.refresh(); while (inqEmp.next()) { DbInquiry childTime = (DbInquiry) inqEmp.getChild("Mtime0"); DbInquiry child = (DbInquiry) childTime.getChild("Mholiday1"); do { CscCalendar cHol = new CscCalendar(child.getString("hdate")); hmHoliday.put(cHol.getDDMMYYYY(), child.getString("tdesc")); } while (child.next()); } } catch (Exception e) {} //out.println(hmHoliday); %> <% String holiday = ""; CscTime ct_late = new CscTime(); CscTime ct_absent = new CscTime(); CscTime ct_leave = new CscTime(); CscTime ct_ot = new CscTime(); CscTime ct_ot1 = new CscTime(); CscTime ct_ot5 = new CscTime(); CscTime ct_ot2 = new CscTime(); CscTime ct_ot3 = new CscTime(); CscTime ct_work = new CscTime(); while (screen.inq.next()) { DbRecord rec = screen.inq.getCurrentDbRecord(); CscCalendar cDate = new CscCalendar(rec.getString("dateid")); String day = "", cFont = ""; if (((String) screen.getUProfile().get("lang")).equalsIgnoreCase("THA")) { //แEดงวN1จN1ทAi , อNงคOA, 3Oธ aป็1ต้1 day = cDate.getDOWTHI(); } else day = cDate.getDOWENG(); if (rec.getString("eventgrp").equals("H")) { cFont = "week"; } else if (rec.getString("eventgrp").equals("I")) { cFont = "holiday"; //holiday += cDate.getDDMMYYYY()+" "+((String) hmHoliday.get(cDate.getDDMMYYYY()))+", "; String tmp = ((String) hmHoliday.get(cDate.getDDMMYYYY())); if (tmp==null) tmp=""; holiday += cDate.getDDMMYYYY()+" "+tmp+", "; } else if (rec.getString("eventgrp").equals("J")) { cFont = "absent"; } %> <tr> <td class="column-text-center"><font class="<%=cFont%>"><%=cDate.getDDMMYYYY()%></font></td> <td class="column-text-center"><font class="<%=cFont%>"><%=day%></font></td> <td class="column-text-center"><font class="<%=cFont%>"><%=df2.format(rec.getDouble("c_tm_bg"))%> - <%=df2.format(rec.getDouble("c_tm_en"))%></font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% String time_in = ""; String time_out = ""; if (rec.getString("forget_in").equals("1")) { time_in = "__.__"; } else time_in = df2.format(rec.getDouble("m_tm_bg")); if (rec.getString("forget_out").equals("1")) { time_out = "__.__"; } else time_out = df2.format(rec.getDouble("m_tm_en")); out.println(time_in+" - "+time_out); %></font> </td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getString("eventgrp").equals("H") || rec.getString("eventgrp").equals("I")) { %> <script language="javascript">swapLang('Holiday')</script> <% } else { out.println(screen.getString("meventgrp","tdesc")); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getDouble("lt")>0) { ct_late.add(rec.getDouble("lt")); out.println(df.format(rec.getDouble("lt"))); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getString("eventgrp").equals("J") && rec.getDouble("m_lv")>0) { ct_absent.add(rec.getDouble("m_lv")); out.println(df.format(rec.getDouble("m_lv"))); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (!rec.getString("eventgrp").equals("J") && rec.getDouble("m_lv")>0) { ct_leave.add(rec.getDouble("m_lv")); out.println(df.format(rec.getDouble("m_lv"))); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getDouble("ac_ot")>0) { ct_ot.add(rec.getDouble("ac_ot")); out.println(df.format(rec.getDouble("ac_ot"))); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getDouble("ot1")>0) { ct_ot1.add(rec.getDouble("ot1")); out.println(df.format(rec.getDouble("ot1"))); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getDouble("ot5")>0) { ct_ot5.add(rec.getDouble("ot5")); out.println(df.format(rec.getDouble("ot5"))); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getDouble("ot2")>0) { ct_ot2.add(rec.getDouble("ot2")); out.println(df.format(rec.getDouble("ot2"))); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getDouble("ot3")>0) { ct_ot3.add(rec.getDouble("ot3")); out.println(df.format(rec.getDouble("ot3"))); } %> </font></td> <td class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getDouble("hour_d")>0) { ct_work.add(rec.getDouble("hour_d")); out.println(df.format(rec.getDouble("hour_d"))); } %> </font></td> <td nowrap="nowrap" class="column-text-center"><font class="<%=cFont%>"> <% if (rec.getDouble("unused1")>0) { %><img src="../IMAGES/EMPVIEW/BULLETS/BLUE.gif" width="5" height="5" border="0" align="absmiddle" /><% } %> <% if (rec.getDouble("unused2")>0) { %><img src="../IMAGES/EMPVIEW/BULLETS/GREEN.gif" width="5" height="5" border="0" align="absmiddle" /><% } %> <% if (rec.getDouble("unused3")>0) { %><img src="../IMAGES/EMPVIEW/BULLETS/RED.gif" width="5" height="5" border="0" align="absmiddle" /><% } %> <% if (rec.getDouble("unused4")>0) { %><img src="../IMAGES/EMPVIEW/BULLETS/SKY-BLUE.gif" width="5" height="5" border="0" align="absmiddle" /><% } %> <% if (rec.getDouble("unused5")>0) { %><img src="../IMAGES/EMPVIEW/BULLETS/VIOLET.gif" width="5" height="5" border="0" align="absmiddle" /><% } %> </td> </tr> <% } //while (screen.inq.next()) %> <!-- Display Summary --> <tr> <td class="column-text-right" colspan="5"><script language="javascript">swapLang('Total')</script> </td> <td class="column-text-center"><%=(ct_late.getFloat()==0)?"":df.format(ct_late.getFloat())%></td> <td class="column-text-center"><%=(ct_absent.getFloat()==0)?"":df.format(ct_absent.getFloat())%></td> <td class="column-text-center"><%=(ct_leave.getFloat()==0)?"":df.format(ct_leave.getFloat())%></td> <td class="column-text-center"><%=(ct_ot.getFloat()==0)?"":df.format(ct_ot.getFloat())%></td> <td class="column-text-center"><%=(ct_ot1.getFloat()==0)?"":df.format(ct_ot1.getFloat())%></td> <td class="column-text-center"><%=(ct_ot5.getFloat()==0)?"":df.format(ct_ot5.getFloat())%></td> <td class="column-text-center"><%=(ct_ot2.getFloat()==0)?"":df.format(ct_ot2.getFloat())%></td> <td class="column-text-center"><%=(ct_ot3.getFloat()==0)?"":df.format(ct_ot3.getFloat())%></td> <td class="column-text-center"><%=(ct_work.getFloat()==0)?"":df.format(ct_work.getFloat())%></td> <td class="column-text-center"></td> </tr> <% String color1 = "", color2 = "", color3= "", color4 = "", color5 = ""; try { color1 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1021"); color2 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1022"); color3 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1023"); color4 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1024"); color5 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1025"); } catch (Exception e) {} %> <tr> <td colspan="15" class="column-text"> <!--img src="../IMAGES/EMPVIEW/BULLETS/BLUE.gif" border="0" align="absmiddle" /> <%=color1%>, <img src="../IMAGES/EMPVIEW/BULLETS/GREEN.gif" border="0" align="absmiddle" /> <%=color2%>, <img src="../IMAGES/EMPVIEW/BULLETS/RED.gif" border="0" align="absmiddle" /> <%=color3%>, <img src="../IMAGES/EMPVIEW/BULLETS/SKY-BLUE.gif" border="0" align="absmiddle" /> <%=color4%>, <img src="../IMAGES/EMPVIEW/BULLETS/VIOLET.gif" border="0" align="absmiddle" /> <%=color5%> <br--> <%=holiday%> </td> </tr> </table> <div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div> </div>