<!DOCTYPE html>
<%@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,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);
EmvHelpEntry screen = (EmvHelpEntry) EMV.process("EmvHelpEntry", "STAT_ATTHELP");
CheckNull chk = new CheckNull();
String fixcon = chk.chkNullString(request.getParameter("__fixCon"));
String employeeid = chk.chkNullString(request.getParameter("__employeeid"));
String emp_name = chk.chkNullString(request.getParameter("MEMPLOYEE@FULLNAME"));
CscCalendar sdate = new CscCalendar(chk.chkNullString(request.getParameter("date_start")));
CscCalendar edate = new CscCalendar(chk.chkNullString(request.getParameter("date_end")));
// actor detail
String lang = screen.getUProfile().get("lang");
String actorid = screen.getUProfile().get("employeeid");
String actor_name = (lang.equalsIgnoreCase("tha"))?screen.getUProfile().get("tfullname"):screen.getUProfile().get("efullname");
// employee display
String emp_display = (employeeid.length() > 0)? employeeid:actorid;
String name_display = (employeeid.length() > 0)? emp_name:actor_name;
screen.setMaxLine(15);
screen.getInquiry().setFilter(fixcon); // set filter to tot_m_date0
int beginRow=((Integer.parseInt(screen.goPage)-1)*screen.maxLine)+1;
int endRow=(Integer.parseInt(screen.goPage))*screen.maxLine;
screen.getInquiry().setBetween(beginRow, endRow);
screen.process();
%>
<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>
$(document).ready(function(){
//datepicker function
var myLang='<%=screen.getUProfile().get("lang")%>';
var swap = new swaplang();
var titlename = swap.swap2String("SW012359");
setPageTitle(titlename);
if (myLang=="tha"){
$.datepicker.setDefaults($.datepicker.regional['tha']);
}
$("input[name=date_start]").hover(function(){
$("input[name=date_start]").datepicker({
dateFormat:"dd-mm-yy",
maxDate:-1,
defaultDate:-1,
changeMonth: true,
changeYear: true
});
$("input[name=date_end]").datepicker("destroy");
});
$("input[name=date_end]").change(function(){
if ($("input[name=date_start]").val()>$("input[name=date_end]").val()){
$("input[name=date_start]").val($("input[name=date_end]").val());
} else if ($("input[name=date_start]").val()==""){
$("input[name=date_start]").val($("input[name=date_end]").val());
}
});
$("input[name=date_end]").hover(function(){
$("input[name=date_end]").datepicker({
minDate: new Date(ConvertDate($("input[name=date_start]").val())),
dateFormat:"dd-mm-yy",
changeMonth: true,
changeYear: true
});
});
});
function goHelp(helpName,inputName){
var helpReturn;
var actid = "<%=actorid%>";
//var con = "employeeid = '1000180'";
var con = "employeeid = '" + actid + "' or employeeid in (select employeeid from msupervisor where supervisor like ',%25"+actid+"%25,')";
helpReturn="__employeeid:employeeid,MEMPLOYEE@FULLNAME";
linkHelp_Return(helpName,helpReturn,con);
}
function GoSearch(){
with(document.cscform){
//__fixCon.value = "employeeid = '" + __employeeid.value + "' and (wf_ref_doc is not null or wf_ref_doc != ' ')";
__fixCon.value = "forget_date between '" + getConDate(date_start) + "' and '" + getConDate(date_end) + "' and fscardid in (select fscardid from tforgetcard0 where employeeid = '" + __employeeid.value + "')";
search();
}
}
function getConDate(obj){
with(document.cscform){
var d = obj.value.split("-");
return d[2] + "-" + d[1] + "-" + d[0];
}
}
function pageDesc(empCode, empName){
with(document.cscform){
var a=chkDateTime1(date_start.value);
var b=chkDateTime1(date_end.value);
window.open("EMP_SWIPETIME.jsp?__cmd="+
"&__date_start="+a+"&__date_end="+b+
"&date_start="+a+"&date_end="+b+
"&__empID="+empCode+"&__empName="+empName,
"Memployee","left=150,top=100,width=750,height=350,toolbar=no,status=yes,scrollbars=yes,resizable=yes"
);
//submit();
}
}
function goPage(select_page){
with( document.cscform ){
if( select_page != "#" ){
__goPage.value = select_page;
submit();
}
}
}
</script>
<section>
<div class="container csc-content">
<form name="cscform" class="form-horizontal" method="post" action="STAT_ATT_VIEW.jsp">
<%=screen.InitialVariable()%>
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="STAT_ATT_VIEW">
<input type="hidden" name="__help" value="">
<INPUT TYPE="hidden" NAME="__goPage" 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" value="<%=fixcon%>">
<input type="hidden" name="__language" value="<%=lang%>">
<input type="hidden" name="__childFilter" >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<div class="csc-block">
<div class="center">
<h2 class="csc-block-head" swlang code='SW012359'>Statistic of Change Requisition</h2>
</div>
<div class="form-horizontal">
<div class="row">
<div class="form-group">
<div class="col-md-2 col-sm-2"></div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW000307'>Employee</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-4">
<div class="input-group">
<input class="form-control" name="__employeeid" readonly value="<%=emp_display%>" size="10">
<a class="input-group-addon" href="javascript:goHelp('MEMPLOYEEHELP','__employeeid')">
<i class="fa fa-search"></i>
</a>
</div>
</div>
<div class="col-md-3 col-sm-3 col-xs-5">
<input class="form-control" type="text" name="MEMPLOYEE@FULLNAME" value="<%=name_display%>" readonly size="40"></td>
</div>
</div>
</div>
<div class="row">
<div class="form-group">
<div class="col-md-2 col-sm-2"></div>
<div class="col-md-2 col-sm-2 col-xs-2">
<label class="control-label label-right" swlang code='SW001033'>Date</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-4">
<%
CscCalendar cs = new CscCalendar();
if (request.getParameter("date_start")==null) {
CscCalendar csNow = new CscCalendar();
%>
<input class="form-control" name="date_start" type="text" value="<%=csNow.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)" >
<% } else {%>
<input class="form-control" 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)">
<% }%>
</div>
<div class="col-md-1 col-sm-1 col-xs-1">
<label class="control-label label-right" swlang code='SW002095'>To</label>
</div>
<div class="col-md-2 col-sm-2 col-xs-4">
<% if (request.getParameter("date_end")==null) { %>
<input class="form-control" name="date_end" type="text" value="<%=cs.getDDMMYYYY()%>" size="9" maxlength="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)" >
<% } else {%>
<input class="form-control" 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)" >
<% }%>
</div>
</div>
</div>
<div class="center">
<a class="btn btn-primary" href="javascript:GoSearch();" swlang code='SW003537'>Search</a>
</div>
</div>
</div>
<%
int browse_page = 0;
int row = 0;
if(fixcon.length() > 0){
screen.process();
browse_page = Integer.parseInt(screen.goPage);
row = screen.inq.recCount();
}
%>
<span class="detail-table">
<span swlang code='SW001771'>Found Data</span> : <%=row%>
<span swlang code='SW001780'>records</span>
</span>
<span class="detail-table label-right">
<span swlang code='SW001120'>Page</span> : <%=screen.getPageTagNew()%>
</span>
<div class="table-responsive">
<table class="table table-head table-hover table-bordered table-title-left table-content-center">
<thead>
<tr>
<th class="table-title" colspan=5>
<span swlang code='SW002350'>Stat att</span>
(
<%
CscCalendar c1 = new CscCalendar();
CscCalendar c2 = new CscCalendar();
if (request.getParameter("date_start")==null && request.getParameter("date_end")==null) {
//.
} else {
c1 = new CscCalendar(request.getParameter("date_start"));
c2 = new CscCalendar(request.getParameter("date_end"));
}
if (screen.getUProfile().get("lang").equals("tha")) {
out.println(c1.getThaiFull()+" - "+c2.getThaiFull());
} else {
out.println(c1.getEngFull()+" - "+c2.getEngFull());
}
%>
)
</th>
</tr>
<tr>
<th swlang code='SW002354'>FSCARDID</th>
<th swlang code='SW002355'>Forget date</th>
<th swlang code='SW002356'>Forget time</th>
<th swlang code='SW000302'>Remark</th>
<th swlang code='SW002347'>Wf ref doc</th>
</tr>
</thead>
<tbody>
<%
if(fixcon.length() > 0){
screen.process();
browse_page = Integer.parseInt(screen.goPage);
row = screen.inq.recCount();
while( screen.nextRec() ){
DbInquiry child = (DbInquiry) screen.getInquiry().getCurrentDbRecord().getChild("tforgetcard0");
%>
<tr>
<td><%=screen.getString("fscardid")%></td>
<td><%=screen.getString("forget_date")%></td>
<td><%=screen.getString("forget_time")%></td>
<td><%=screen.getString("remark")%></td>
<td><%=child.getString("wf_ref_doc")%></td>
</tr>
<%
}
}
%>
</tbody>
</table>
</div>
</form>
</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>