<%@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">
                    &nbsp;<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()">&nbsp;
				  	<% } 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()">&nbsp;
			  	<% }%>
				  		<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>&nbsp;&nbsp;&nbsp;-&nbsp;&nbsp;&nbsp; 
					<% 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()">&nbsp;
				   	<% } 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()">&nbsp;
			  	  <% }%>
			  		  <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>&nbsp;</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" />&nbsp;<%=color1%>,&nbsp;&nbsp;
                    <img src="../IMAGES/EMPVIEW/BULLETS/GREEN.gif" border="0" align="absmiddle" />&nbsp;<%=color2%>,&nbsp;&nbsp;
                    <img src="../IMAGES/EMPVIEW/BULLETS/RED.gif" border="0" align="absmiddle" />&nbsp;<%=color3%>,&nbsp;&nbsp;
                    <img src="../IMAGES/EMPVIEW/BULLETS/SKY-BLUE.gif" border="0" align="absmiddle" />&nbsp;<%=color4%>,&nbsp;&nbsp;
                	<img src="../IMAGES/EMPVIEW/BULLETS/VIOLET.gif" border="0" align="absmiddle" />&nbsp;<%=color5%>&nbsp;&nbsp;
                    <br-->
                  	<%=holiday%>
              	</td>
          	</tr> 
            </table>           	
            <div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div>
          </div>