<%@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,com.csc.library.database.MyHashMap" %>
<% 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);
HelpEntry screen = (HelpEntry) EMV.process("HelpEntry", "COM_SWIPETIME_RESULTHELP");
screen.inq.refresh();
//screen.nextRec();
CheckNull chk = new CheckNull();
String swipeDate = chk.chkNullString((String) request.getParameter("swipedate"));
CscCalendar cs = new CscCalendar();
if (!swipeDate.equals("")) {
cs = new CscCalendar(swipeDate);
}
String displayBu2 = chk.chkNullString((String) request.getParameter("display_bu2"));
%>
<!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=TIS620" />
<!-- 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" />
<!-- 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" 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>
<script language="JavaScript">
function GoSearch(){
with(document.cscform){
search();
}
}
</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="COM_SWIPETIME_RESULT.jsp">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="COM_SWIPETIME_RESULT">
<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="__goPage" value="">
<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" value="<%=request.getParameter("__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>
<script language="javascript">initToolTips();</script>
<div class="content-box2">
<div class="content-header"><h2><script language="javascript">swapLang('Swipe Time Result')</script></h2></div>
<table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list">
<tr>
<td class="column-header" colspan="6"><script language="javascript">swapLang('Date')</script>
<% if (request.getParameter("swipedate")==null) { %>
<input name="swipedate" type="text" value="<%=cs.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onKeypress = "chkIntegerOfDate(this.value)" onBlur="chkInputDate(this);" onMouseOver="toolTip('วันที่(DDMMYYYY)')" onMouseOut="toolTip()">
<% } else {%>
<input name="swipedate" type="text" value="<%=request.getParameter("swipedate")%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onKeypress = "chkIntegerOfDate(this.value)" onBlur="chkInputDate(this);" onMouseOver="toolTip('วันที่(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('swipedate')" alt="Calendar"></a>
<input type="checkbox" name="display_bu2"><script language="javascript">swapLang('Display Business Unit 2')</script>
<a href="javascript:GoSearch();"><img src="../IMAGES/EMPVIEW/BUTTON/SEARCH.gif" width="60" height="23" border="0" align="absmiddle"></a> </td>
</tr>
<tr>
<td class="column-header" width="50%" rowspan="2"><script language="javascript">swapLang('Business Unit')</script></td>
<td class="column-header" width="10%" rowspan="2"><script language="javascript">swapLang('Total Emp')</script></td>
<td class="column-header" width="30%" colspan="3"><script language="javascript">swapLang('SwipeTime Type')</script></td>
<td class="column-header" width="10%" rowspan="2"><script language="javascript">swapLang('SwipeTime Total')</script></td>
</tr>
<tr>
<td class="column-header" width="10%"><script language="javascript">swapLang('Yes')</script></td>
<td class="column-header" width="10%"><script language="javascript">swapLang('Not')</script></td>
<td class="column-header" width="10%"><script language="javascript">swapLang('NA')</script></td>
</tr>
<%
DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry();
inq.setSchemaName(screen.getUProfile().getSchemaName());
inq.initMyTable("Ttimetemp", "", "");
inq.setColumn("*");
int emp=0, typeYES=0, typeNO=0, typeNA=0, swipe=0;
while(screen.nextRec()) {
int emp_Bu1=0, typeYES_Bu1=0, typeNO_Bu1=0, typeNA_Bu1=0, swipe_Bu1=0;
%>
<% if (displayBu2.equals("on")) { %>
<tr>
<td class="column-text" colspan="6"><%=screen.getString("bu1id")%> : <%=screen.getString("tdesc")%></td>
</tr>
<% } %>
<%
DbInquiry inqBu2 = (DbInquiry) screen.inq.getChild("mbu2");
if (inqBu2.recCount()>0) {
do {
int emp_Bu2=0, typeYES_Bu2=0, typeNO_Bu2=0, typeNA_Bu2=0, swipe_Bu2=0;
DbInquiry inqEmp = (DbInquiry) inqBu2.getChild("memployee");
if (inqEmp.recCount()>0) {
emp += inqEmp.recCount();
emp_Bu1 += inqEmp.recCount();
emp_Bu2 = inqEmp.recCount();
do {
DbInquiry inqTime = (DbInquiry) inqBu2.getChild("mtime0");
if (inqTime.getString("sticktm").equals("Y") || inqTime.getString("sticktm").equals("I") || inqTime.getString("sticktm").equals("O")) {
typeYES++;
typeYES_Bu1++;
typeYES_Bu2++;
} else if (inqTime.getString("sticktm").equals("")) {
typeNA++;
typeNA_Bu1++;
typeNA_Bu2++;
} else {
typeNO++;
typeNO_Bu1++;
typeNO_Bu2++;
}
inq.setFilter("employeeid='"+inqEmp.getString("employeeid")+"' and swipedate='"+cs.getYYYYMMDD()+"'");
inq.refresh();
if (inq.recCount()>0) {
swipe++;
swipe_Bu1++;
swipe_Bu2++;
}
} while (inqEmp.next());
} //if (inqEmp.recCount()>0)
%>
<% if (displayBu2.equals("on")) { %>
<tr>
<td class="column-text"> <%=inqBu2.getString("bu2id")%> : <%=inqBu2.getString("tdesc")%></td>
<td class="column-text-center"><%=emp_Bu2%></td>
<td class="column-text-center"><%=typeYES_Bu2%></td>
<td class="column-text-center"><%=typeNO_Bu2%></td>
<td class="column-text-center"><%=typeNA_Bu2%></td>
<td class="column-text-center"><%=swipe_Bu2%></td>
</tr>
<% } %>
<%
} while (inqBu2.next());
} //if (inqBu2.recCount()>0)
%>
<% if (displayBu2.equals("on")) { %>
<tr>
<td class="column-text"> <script language="javascript">swapLang('Total')</script></td>
<td class="column-text-center"><%=emp_Bu1%></td>
<td class="column-text-center"><%=typeYES_Bu1%></td>
<td class="column-text-center"><%=typeNO_Bu1%></td>
<td class="column-text-center"><%=typeNA_Bu1%></td>
<td class="column-text-center"><%=swipe_Bu1%></td>
</tr>
<% } else { %>
<tr>
<td class="column-text"><%=screen.getString("bu1id")%> : <%=screen.getString("tdesc")%></td>
<td class="column-text-center"><%=emp_Bu1%></td>
<td class="column-text-center"><%=typeYES_Bu1%></td>
<td class="column-text-center"><%=typeNO_Bu1%></td>
<td class="column-text-center"><%=typeNA_Bu1%></td>
<td class="column-text-center"><%=swipe_Bu1%></td>
</tr>
<% } %>
<%
} //while(screen.nextRec())
%>
<tr>
<td class="column-text"><script language="javascript">swapLang('Total All')</script></td>
<td class="column-text-center"><%=emp%></td>
<td class="column-text-center"><%=typeYES%></td>
<td class="column-text-center"><%=typeNO%></td>
<td class="column-text-center"><%=typeNA%></td>
<td class="column-text-center"><%=swipe%></td>
</tr>
</table>
<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>