<!DOCTYPE html>
<%@page contentType="text/html; charset=UTF-8" language="java" %>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*,java.util.*"%>
<%@page import="com.csc.library.utilities.CscCalendar,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" %>
<%@ include file="../CHECKPROFILE.jsp" %>
<% 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);
CheckNull chk = new CheckNull();
String empIDReq = chk.chkNullString((String) request.getParameter("__employeeid"));
String empNameReq = chk.chkNullString((String) request.getParameter("__employeename"));
String bu1IDReq = chk.chkNullString((String) request.getParameter("__bu1id"));
String bu1DescReq = chk.chkNullString((String) request.getParameter("__bu1desc"));
String bu2IDReq = chk.chkNullString((String) request.getParameter("__bu2id"));
String bu2DescReq = chk.chkNullString((String) request.getParameter("__bu2desc"));
String bu3IDReq = chk.chkNullString((String) request.getParameter("__bu3id"));
String bu3DescReq = chk.chkNullString((String) request.getParameter("__bu3desc"));
String dateStartReq = chk.chkNullString((String) request.getParameter("date_start"));
String dateEndReq = chk.chkNullString((String) request.getParameter("date_end"));
EmvHelpEntry screen = (EmvHelpEntry) EMV.process("EmvHelpEntry", "COM_SWIPETIMEHELP");
DbInquiry dbinq = new InitialInquiry(screen.getUProfile()).getDbInquiry("mfpdevice1");
dbinq.setColumn("*");
screen.setMaxLine(20);
//Check Filter From Condition in Screen
String filter = "";
if (!empIDReq.equals("")) {
filter += "employeeid='"+empIDReq+"'";
}
if (!bu1IDReq.equals("")) {
if (filter.equals("")) {
filter += " bu1='"+bu1IDReq+"'";
} else filter += " and bu1='"+bu1IDReq+"'";
}
if (!bu2IDReq.equals("")) {
if (filter.equals("")) {
filter += " bu2='"+bu2IDReq+"'";
} else filter += " and bu2='"+bu2IDReq+"'";
}
if (!bu3IDReq.equals("")) {
if (filter.equals("")) {
filter += " bu3='"+bu3IDReq+"'";
} else filter += " and bu3='"+bu3IDReq+"'";
}
if (!dateStartReq.equals("") && !dateEndReq.equals("")) {
CscCalendar c1 = new CscCalendar(dateStartReq);
CscCalendar c2 = new CscCalendar(dateEndReq);
if (filter.equals("")) {
filter += " (swipedate between '"+c1.getYYYYMMDD()+"' and '"+c2.getYYYYMMDD()+"') ";
} else filter += " and (swipedate between '"+c1.getYYYYMMDD()+"' and '"+c2.getYYYYMMDD()+"') ";
}else{
CscCalendar c1 = new CscCalendar().decDate(5);
CscCalendar c2 = new CscCalendar();
filter += " (swipedate between '"+c1.getYYYYMMDD()+"' and '"+c2.getYYYYMMDD()+"') ";
}
//out.print("<br><br> nuiss debuging filter is: "+filter);
//nuiss edit 15/10/2551
//ถ้าไม่มี where clause ไม่ต้อง retrieve
if(filter.trim().equals("")){
}else{
screen.inq.setFilter(filter);
}//end if
screen.inq.refresh();
screen.process();
//screen.nextRec();
CscCalendar cs1 = new CscCalendar();
cs1.decDate(5);
CscCalendar cs2 = new CscCalendar();
FormulaString fs = new FormulaString();
DecimalFormat df = new DecimalFormat("0.00");
DecimalFormat df2 = new DecimalFormat("00.00");
%>
<html xmlns="http://www.w3.org/1999/xhtml" ng-app="myHR">
<head>
<title>Employee View</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>
<body>
<div class="bg-com"></div>
<jsp:include page="EMV_HEADMENU.jsp" flush="true" />
<script type="text/javascript">
setLang("<%=screen.getUProfile().get("lang")%>");
var swap = new swaplang();
var titlename = swap.swap2String("SW001860");
setPageTitle(titlename);
function goHelp(helpName,inputName){
with(document.cscform){
var helpReturn="";
var fcon=__fixCon.value;
var sub_value = "";
if (inputName=="__employeeid") {
helpReturn = inputName+":employeeid,__employeename:fullname"
linkHelp_Return(helpName,helpReturn);
} else if (inputName=="__bu1id") {
helpReturn = inputName+":bu1id,__bu1desc:tdesc"
linkHelp_Return(helpName,helpReturn);
} else if (inputName=="__bu2id") {
helpReturn = inputName+":bu2id,__bu2desc:tdesc"
linkHelp_Return(helpName,helpReturn);
} else if (inputName=="__bu3id") {
helpReturn = inputName+":bu3id,__bu3desc:tdesc"
linkHelp_Return(helpName,helpReturn);
}
__fixCon.value = "";
}
}
function GoSearch(){
with(document.cscform){
search();
}
}
$(document).ready(function(){
//datepicker function
var myLang='<%=screen.getUProfile().get("lang")%>';
if (myLang=="tha"){
$.datepicker.setDefaults($.datepicker.regional['tha']);
}
$("input[name=date_start]").hover(function(){
$("input[name=date_start]").datepicker({
dateFormat:"dd-mm-yy",
defaultDate: -5,
changeMonth: true,
changeYear: true
});
$("input[name=date_end]").datepicker("destroy");
});
$("input[name=date_start]").change(function(){
if ($("input[name=date_start]").val()>$("input[name=date_end]").val()){
$("input[name=date_end]").val($("input[name=date_start]").val());
}
});
$("input[name=date_end]").hover(function(){
$("input[name=date_end]").datepicker({
dateFormat:"dd-mm-yy",
minDate: new Date(ConvertDate($("input[name=date_start]").val())),
changeMonth: true,
changeYear: true
});
});
});
</script>
<section>
<div class="container csc-content">
<div class="csc-block">
<form name="cscform" class="form-horizontal" method="post" action="COM_SWIPETIME.jsp">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="COM_SWIPETIME">
<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 type="text/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 class="center">
<h2 swlang code='SW001860' class="csc-block-head">Raw Data</h2>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-4 col-sm-4 col-xs-4">
<label class="control-label label-right"><%=screen.getLabel("employeeid")%></label>
</div>
<div class="col-md-8 col-sm-8 col-xs-8">
<div class="col-md-3 col-sm-3 col-xs-3">
<div class="input-group">
<input type="text" class="form-control" name="__employeeid"
value="<%=empIDReq%>">
<a class="input-group-addon" href="javascript:goHelp('MEMPLOYEEHELP','__employeeid');">
<i class="fa fa-search"></i>
</a>
</div>
</div>
<div class="col-md-5 col-sm-5 col-xs-5">
<input type="text" name="__employeename" class="text form-control" readonly="readonly" value="<%=empNameReq%>">
</div>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-4 col-sm-4 col-xs-4">
<label class="control-label label-right" ><%=screen.getLabel("memployee","bu1")%></label>
</div>
<div class="col-md-8 col-sm-8 col-xs-8">
<div class="col-md-3 col-sm-3 col-xs-3">
<div class="input-group">
<input type="text" class="form-control" name="__bu1id"
value="<%=bu1IDReq%>">
<a class="input-group-addon" href="javascript:goHelp('MBU1HELP','__bu1id');">
<i class="fa fa-search"></i>
</a>
</div>
</div>
<div class="col-md-5 col-sm-5 col-xs-5">
<input type="text" name="__bu1desc" class="text form-control" readonly="readonly" value="<%=bu1IDReq%>">
</div>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-4 col-sm-4 col-xs-4">
<label class="control-label label-right" ><%=screen.getLabel("memployee","bu2")%></label>
</div>
<div class="col-md-8 col-sm-8 col-xs-8">
<div class="col-md-3 col-sm-3 col-xs-3">
<div class="input-group">
<input type="text" class="form-control" name="__bu2id"
value="<%=bu2IDReq%>">
<a class="input-group-addon" href="javascript:goHelp('MBU2HELP','__bu2id');">
<i class="fa fa-search"></i>
</a>
</div>
</div>
<div class="col-md-5 col-sm-5 col-xs-5">
<input type="text" name="__bu2desc" class="text form-control" readonly="readonly" value="<%=bu2IDReq%>">
</div>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-4 col-sm-4 col-xs-4">
<label class="control-label label-right" ><%=screen.getLabel("memployee","bu3")%></label>
</div>
<div class="col-md-8 col-sm-8 col-xs-8">
<div class="col-md-3 col-sm-3 col-xs-3">
<div class="input-group">
<input type="text" class="form-control" name="__bu3id"
value="<%=bu3IDReq%>">
<a class="input-group-addon" href="javascript:goHelp('MBU3HELP','__bu3id');">
<i class="fa fa-search"></i>
</a>
</div>
</div>
<div class="col-md-5 col-sm-5 col-xs-5">
<input type="text" name="__bu3desc" class="text form-control" readonly="readonly" value="<%=bu3IDReq%>">
</div>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-4 col-sm-4 col-xs-4">
<label class="control-label label-right" swlang code='SW001033'>Date</label>
</div>
<div class="col-md-8 col-sm-8 col-xs-8">
<div class="col-md-3 col-sm-3 col-xs-3">
<%
if (request.getParameter("date_start")==null){
%>
<input name="date_start" type="text" class="form-control" value="<%=cs1.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)">
<%
} else{
%>
<input name="date_start" type="text" class="form-control" value="<%=request.getParameter("date_start")%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)">
<%
}
%>
</div>
<div class="col-md-1s col-sm-1 col-xs-1">
<label class="control-label"> - </label>
</div>
<div class="col-md-3 col-sm-3 col-xs-3">
<%
if (request.getParameter("date_end")==null){
%>
<input name="date_end" type="text" class="form-control" value="<%=cs2.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)">
<%
} else{
%>
<input name="date_end" type="text" class="form-control" value="<%=request.getParameter("date_end")%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)">
<%
}
%>
</div>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="center">
<a href="javascript:GoSearch();" class="btn btn-primary" swlang code="SW003537">Search</a>
</div>
</div>
</div>
</form>
</div> <!-- end csc-block-->
<% String cmd = chk.chkNullString(request.getParameter("__cmd"),""); %>
<span class="detail-table">
<span swlang code='SW001771'>Found Data</span> : <%= screen.getInquiry().recCount() %>
<span swlang code='SW001780'>records</span>
</span>
<span class="detail-table label-right">
<span swlang code='SW001120'>Page</span> : <%=screen.getPageTagNew()%>
</span>
<table class="table table-head table-hover table-bordered table-content-center">
<thead>
<tr>
<th swLang code="SW000602">EmployeeID</th>
<th swlang code='SW007745'>Name Surname</th>
<th swlang code="SW012762">Punch Date</th>
<th swlang code="SW012763">Punch Time</th>
<th swlang code='SW012764'>Punch Source</th>
<th swlang code='SW001875'>MachineID</th>
<th swlang code='SW012652'>Devices Names</th>
</tr>
</thead>
<tbody>
<%
int i=1;
String tmpEmp = "", tmpDate = "";
String empID = "", empName = "", date = "";
String empclass="";
String devicename="";
if (cmd!=null) {
while(screen.nextRec()) {
if (screen.checkLinePage()) {
CscCalendar cDate = new CscCalendar(screen.getString("swipedate"));
if (tmpDate.equals(cDate.getDDMMYYYY())) {
date = "";
} else {
date = cDate.getDDMMYYYY();
}
if (tmpEmp.equals(screen.getString("employeeid"))) {
empID = "";
empName = "";
empclass="";
} else {
empclass="result";
empID = screen.getString("employeeid");
empName = screen.getString("memployee","fullname");
date = cDate.getDDMMYYYY();
}
dbinq.setFilter("device_no ='"+screen.getString("machinno")+"'");
dbinq.refresh();
if (dbinq.recCount()>0) {
dbinq.next();
if (dbinq.getString("device_desc").equals("")) {
devicename = dbinq.getString("device_no");
} else {
devicename = dbinq.getString("device_no") + " : " + dbinq.getString("device_desc");
}
}else if(screen.getString("wf_status").equalsIgnoreCase("Z")){
devicename = "ZeeMe";
}else {
devicename = "";
}
%>
<tr>
<td><%=empID%></td>
<td><%=empName%></td>
<td><%=date%></td>
<td><%=df2.format(screen.inq.getCurrentDbRecord().getDouble("swipetime"))%></td>
<td><%=screen.inq.getCurrentDbRecord().getSystemCode("source")%></td>
<td><%=screen.getString("machinno")%></td>
<td><%=devicename%></td>
</tr>
<%
tmpEmp = screen.getString("employeeid");
tmpDate = cDate.getDDMMYYYY();
}
if (screen.outLinePage()) {
tmpEmp = "";
tmpDate = "";
break;
}
i++;
}
}
%>
</tbody>
</table>
</div>
<a href="#top" id="top-button">
<i class="fa fa-angle-up"></i>
<div class="top-word">Back to top</div>
</a>
</section>
<jsp:include page="FOOTER.jsp" flush="true" />
</body>
</html>