<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html; charset=UTF-8"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,java.text.DecimalFormat,com.csc.library.database.*"%>
<%@ page import="java.util.*,java.io.*,java.sql.*"%>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.Locale" %>
<%@ page import="java.util.Date" %>
<%@ include file="../CHECKPROFILE.jsp" %>
<%
CheckNull chk = new CheckNull();
CscCalendar c = new CscCalendar();
DecimalFormat dmfm = new DecimalFormat("0.00");
UProfile mypro = null;
if (session !=null){
mypro = (UProfile)session.getAttribute("userprofile");
}
DecimalFormat dmfm1 = new DecimalFormat("#,##0.00");
DecimalFormat dmfm2 = new DecimalFormat("#,###");
CscCalendar now = new CscCalendar();
SimpleDateFormat df = new SimpleDateFormat("hh:mm a", Locale.ENGLISH);
GregorianCalendar gc= new GregorianCalendar();
//String month = chk.chkNullString(request.getParameter("__month"));
//String year = chk.chkNullString(request.getParameter("__year"));
//String end_date = chk.chkNullString(request.getParameter("__end_date"),now.getDDMMYYYY());
String cmd = chk.chkNullString(request.getParameter("__cmd"));
//CscCalendar calendar = new CscCalendar();
//int year2 = Integer.parseInt(calendar.getEngYYYY());
String branch = chk.chkNullString(request.getParameter("__comid"));
String start_date = chk.chkNullString(request.getParameter("__start_date"),now.getDDMMYYYY());
String end_date = chk.chkNullString(request.getParameter("__end_date"),now.getDDMMYYYY());
CscCalendar start_date2 = new CscCalendar(start_date);
CscCalendar end_date2 = new CscCalendar(end_date);
String f_start_date = start_date2.getYYYYMMDD();
String f_end_date = end_date2.getYYYYMMDD();
String branchid =chk.chkNullString(request.getParameter("__branch"));
String bu1id =chk.chkNullString(request.getParameter("__bu1"));
String bu2id =chk.chkNullString(request.getParameter("__bu2"));
String bu3id =chk.chkNullString(request.getParameter("__bu3"));
String bu4id =chk.chkNullString(request.getParameter("__bu4"));
String bu5id =chk.chkNullString(request.getParameter("__bu5"));
String shift =chk.chkNullString(request.getParameter("__shift"));
String salatype =chk.chkNullString(request.getParameter("__salatype"));
String employeeid =chk.chkNullString(request.getParameter("__employeeid"));
String emptype =chk.chkNullString(request.getParameter("__emp_type"));
//String filter = "1=1";
String filter = "";
String reportfilter = "1=1";
DbInquiry dbssec = new InitialInquiry(uprofile).getDbInquiry("ssecurity");
dbssec.setColumn("*");
dbssec.setFilter("employeeid = '"+uprofile.get("employeeid")+"' AND isviewall ='1'");
dbssec.refresh();
if (dbssec.recCount()>0){
dbssec.next();
if (dbssec.getString("isemp_position").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("positionstatus"),"e.emp_position",dbssec.getString("positionlist"));
reportfilter +=chkMySecurity(dbssec.getString("positionstatus"),"emp_position",dbssec.getString("positionlist"));
}
if (dbssec.getString("isemp_group").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("empgroupstatus"),"e.emp_group",dbssec.getString("empgrouplist"));
reportfilter +=chkMySecurity(dbssec.getString("empgroupstatus"),"emp_group",dbssec.getString("empgrouplist"));
}
if (dbssec.getString("isbu1").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("bu1status"),"e.bu1",dbssec.getString("bu1list"));
reportfilter +=chkMySecurity(dbssec.getString("bu1status"),"bu1",dbssec.getString("bu1list"));
}
if (dbssec.getString("isbu2").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("bu2status"),"e.bu2",dbssec.getString("bu2list"));
reportfilter +=chkMySecurity(dbssec.getString("bu2status"),"bu2",dbssec.getString("bu2list"));
}
if (dbssec.getString("isbu3").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("bu3status"),"e.bu3",dbssec.getString("bu3list"));
reportfilter +=chkMySecurity(dbssec.getString("bu3status"),"bu3",dbssec.getString("bu3list"));
}
if (dbssec.getString("isbu4").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("bu4status"),"e.bu4",dbssec.getString("bu4list"));
reportfilter +=chkMySecurity(dbssec.getString("bu4status"),"bu4",dbssec.getString("bu4list"));
}
if (dbssec.getString("isjob").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("jobstatus"),"e.job",dbssec.getString("joblist"));
reportfilter +=chkMySecurity(dbssec.getString("jobstatus"),"job",dbssec.getString("joblist"));
}
if (dbssec.getString("isbranch").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("branchstatus"),"e.branch",dbssec.getString("branchlist"));
reportfilter +=chkMySecurity(dbssec.getString("branchstatus"),"branch",dbssec.getString("branchlist"));
}
if (dbssec.getString("issalatype").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("salatypestatus"),"e.salatype",dbssec.getString("salatypelist"));
reportfilter +=chkMySecurity(dbssec.getString("salatypestatus"),"salatype",dbssec.getString("salatypelist"));
}
if (dbssec.getString("ispl").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("plstatus"),"e.pl",dbssec.getString("pllist"));
reportfilter +=chkMySecurity(dbssec.getString("plstatus"),"pl",dbssec.getString("pllist"));
}
if (dbssec.getString("isworkarea").equalsIgnoreCase("1")){
filter +=chkMySecurity(dbssec.getString("workareastatus"),"e.workarea",dbssec.getString("workarealist"));
reportfilter +=chkMySecurity(dbssec.getString("workareastatus"),"workarea",dbssec.getString("workarealist"));
}
}
if( !branchid.equals("") ){
filter += " and e.BRANCH = '"+ branchid+ "'";
reportfilter += " and BRANCH = '"+ branchid+ "'";
}
if( !bu1id.equals("") ){
filter += " and e.BU1 = '"+ bu1id+ "'";
reportfilter += " and BU1 = '"+ bu1id+ "'";
}
if( !bu2id.equals("") ){
filter += " and e.BU2 = '"+ bu2id+ "'";
reportfilter += " and BU2 = '"+ bu2id+ "'";
}
if( !bu3id.equals("") ){
filter += " and e.BU3 = '"+ bu3id+ "'";
reportfilter += " and BU3 = '"+ bu3id+ "'";
}
if( !bu4id.equals("") ){
filter += " and e.BU4 = '"+ bu4id+ "'";
reportfilter += " and BU4 = '"+ bu4id+ "'";
}
if( !bu5id.equals("") ){
filter += " and e.BU5 = '"+ bu5id+ "'";
reportfilter += " and BU5 = '"+ bu5id+ "'";
}
if( !shift.equals("") ){
filter += " and e.TIME0 = '"+ shift+ "'";
reportfilter += " and TIME0ID = '"+ shift+ "'";
}
if( !employeeid.equals("") ){
filter += " and t1.employeeid = '"+ employeeid+ "'";
reportfilter += " and employeeid = '"+ employeeid+ "'";
}
if( !emptype.equals("") ){
filter += " and e.emp_type = '"+ emptype+ "'";
reportfilter += " and emp_type = '"+ emptype+ "'";
}
if( !salatype.equals("") ){
filter += " and t1.salatype = '"+ salatype+ "'";
reportfilter += " and salatype = '"+ salatype+ "'";
}
// filter += " and t1.DATEID between '" + f_start_date + "' and '" +f_end_date+"' order by t1.employeeid,t1.dateid,t1.sequence";
// reportfilter += " and DATEID between '" + f_start_date + "' and '" +f_end_date+"'";
DbRecord dbrec = new InitialRecord(mypro).getDbRecord("memployee");
dbrec.setColumn("*");
//************** Start Export Report *************************
ThaiUtilities th = new ThaiUtilities();
UProfile uf = uprofile;
String reportPath = new InitialEnvironment("GLOBAL").getValue("report-path");
String dbName = uf.getDbName();
String comname = uf.get("companyname");
String comTname = th.ASCII2Unicode(uf.get("com_tname"));
String comEname = uf.get("com_ename");
String companyid = uf.get("companyid");
String userId = uf.getUserId();
String app_name = uf.get("appname");
String schemaName = uf.getSchemaName();
String password = uf.getPassword();
String userlevel = uf.getLevel();
String format_date = uf.get("formatdate");
String lang = uf.get("lang").toUpperCase();
String ufullname = uf.get("fullname");
String bu1desc = dbrec.getField("bu1").getDescription();
String bu2desc = dbrec.getField("bu2").getDescription();
String bu3desc = dbrec.getField("bu3").getDescription();
String bu4desc = dbrec.getField("bu4").getDescription();
String bu5desc = dbrec.getField("bu5").getDescription();
//************** End Export Report *************************
%>
<html ng-app="myHR">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css">
<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script language="JavaScript" src="../JS/SCREEN.js"></script>
<SCRIPT TYPE='text/JavaScript' SRC='../JS/DATEINPUT.js'></SCRIPT>
<SCRIPT TYPE='text/JavaScript' SRC='../JS/VIEWCALENDAR.js'></SCRIPT>
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type="text/javascript" src="../JS/angular-1.3.15/angular.js"></script>
<script type="text/javascript" src="../JS/ANGULAR/SCREEN_ANGULAR.js"></script>
<script language="javascript">setLang('<%=uprofile.get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
function goHelp(helpName,inputName){
var helpReturn;
if(inputName=="__branch" ){
helpReturn="__branch:branchid,__branch_desc:tdesc";
}else if(inputName=="__bu1" ){
helpReturn="__bu1:bu1id,__bu1_desc:tdesc";
}else if(inputName=="__bu2" ){
helpReturn="__bu2:bu2id,__bu2_desc:tdesc";
}else if(inputName=="__bu3" ){
helpReturn="__bu3:bu3id,__bu3_desc:tdesc";
}else if(inputName=="__bu4" ){
helpReturn="__bu4:bu4id,__bu4_desc:tdesc";
}else if(inputName=="__bu5" ){
helpReturn="__bu5:bu5id,__bu5_desc:tdesc";
}else if(inputName=="__employeeid" ){
helpReturn="__employeeid:employeeid,__employeeid_desc:fullname";
}else if(inputName=="__shift" ){
helpReturn="__shift:time0id,__shift_desc:tdesc";
}else if(inputName=="__salatype" ){
helpReturn="__salatype:codeid,__salatype_desc:tdesc";
}else if(inputName=="__emp_type" ){
helpReturn="__emp_type:codeid,__emp_type_desc:tdesc";
}
linkHelp_Return(helpName, helpReturn);
}
function back(unit){
with(window.opener.document.cscform){
locateId.value =unit;
}
window.close();
}
function GoExport(){
with(document.cscform){
// alert(__filter.value);
var param = "TAR11129_EXP.jsp?__filter="+__filter.value+"&__start_date="+__start_date.value+"&__end_date="+__end_date.value;
window.open(param);
// __export.value = "1";
// action = "PRU212_EXP.jsp";
// target = "";
// submit();
}
}
function GoProcess(){
with( document.cscform){
__cmd.value = "search"
submit();
}
}
function goPrint(){
with(document.cscform){
goPreview1();
}
}
function goPreview1(){
with(document.cscform){
var reportName = getLang()==="tha"?"รายงานสรุปขาด ลา สาย":"Summary Absent Leave Late Report";
var path = "<%=reportPath%>";
var a = path.substring(0,path.length)+
"?uprofile$dbname=<%=dbName%>"+
"&com_tname=<%=comTname%>"+
"&com_ename=<%=comEname%>"+
"&uprofile$companyid=<%=companyid%>"+
"&uprofile$userid=<%=userId%>"+
"&uprofile$lang=<%=lang%>"+
"&uprofile$appname=<%=app_name%>"+
"&uprofile$schemaname=<%=schemaName%>"+
"&uprofile$emp_level=<%=userlevel%>"+
"&uprofile$formatdate=<%=format_date%>"+
"&__COMPANY=<%=comname%>"+
"&__screen=TAR11126"+
"&__REPORT_XML=TAR11126"+
"&__reportname="+reportName+
"&thaiHeader=รายงานสรุปขาด ลา สาย"+
"&engHeader=Summary Absent Leave Late Report"+
"&__startPage=1"+
"&__fixfilterttime_current1=<%=reportfilter%>"+
"&__conditionid="+
"&__classname=ReportResultSet"+
"&__mmxml="+
"&__expxml="+
"&__export_type=EXPORT"+
"&__file_type=.pdf"+
"&__template=TAR11126.jasper$"+
"&__cmd="+
"&__orderText=employeeid,dateid,time0id,eventgrp"+
"&__language=<%=lang%>"+
"&__groupText="+
"&__ACTORNAME=<%=ufullname%>"+
"&__datethai=วัน<%=now.getLongThiDOW()%>ที่ <%=now.getDate()%> <%=now.getThaiLongMonth()%> พ.ศ. <%=now.getThaiYYYY()%> <%=now.getHHMM()%> น."+
"&__dateeng=<%=now.getEngFull()%> <%=df.format((Date)gc.getTime())%>"+
"&__BU1DESC=<%=bu1desc%>"+
"&__BU2DESC=<%=bu2desc%>"+
"&__BU3DESC=<%=bu3desc%>"+
"&__BU4DESC=<%=bu4desc%>"+
"&__BU5DESC=<%=bu5desc%>"+
"&__reportHeader="+reportName+
"&__evd=<%//=evd%>";
window.open(a);
}
}
</script>
</head>
<%
String helpReturn="";
if(request.getParameter("__helpReturn")!=null){
helpReturn=request.getParameter("__helpReturn");
}
String fieldSearch="";
if(request.getParameter("__fieldSearch")!=null){
fieldSearch=request.getParameter("__fieldSearch");
}
%>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" action="TAR11129.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%//=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="TAR11129">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__language" value="<%=uprofile.get("lang")%>">
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input type="hidden" name="__helpReturn" value="<%=helpReturn%>">
<input type="hidden" name="__fieldSearch" value="<%=fieldSearch%>">
<input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>">
<input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>">
<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>">
<input type="hidden" name="__export" value="">
<input type="hidden" name="__calendar" value="">
<input type="hidden" name="__filter" value="<%=filter%>">
<script language="javascript">getInputFormatDate()</script>
<br>
<div align="center">
<table class="large" cellpadding="0" cellspacing="1" >
<tr>
<td colspan=2 class="header">TAR11129, รายงานสรุป OT ขาดงานและการลาที่ไม่จ่ายค่าจ้าง</td>
</tr>
<tr>
<td colspan=2>
<table border="0" cellpadding="0" cellspacing="1" align="center" class="largest">
<tr>
<td colspan=2 class="blankspace"></td>
</tr>
<tr>
<td width="40%" align="right"><script language="javascript">swapLang("Employeeid")</script> </td>
<td width="60%">
<input type="text" name="__employeeid" size="10" value="<%=chk.chkNullString(request.getParameter("__employeeid"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="หน่วยงานระดับ">
<a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__employeeid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__employeeid_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__employeeid_desc" value="<%=chk.chkNullString(request.getParameter("__employeeid_desc"))%>" readonly class="diabled">
</td>
</tr>
<tr>
<td width="40%" align="right"><script language="javascript">swapLang("Employment Type")</script> </td>
<td width="60%">
<input type="text" name="__emp_type" size="10" value="<%=chk.chkNullString(request.getParameter("__emp_type"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="หน่วยงานระดับ">
<a href="javascript:goHelp('MEMPLOYMENT_TYPEHELP','__emp_type');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__employeeid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__employeeid_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__emp_type_desc" value="<%=chk.chkNullString(request.getParameter("__emp_type_desc"))%>" readonly class="diabled">
</td>
</tr>
<tr>
<td width="40%" align="right"><%=dbrec.getField("branch").getDescription()%> </td>
<td width="60%">
<input type="text" name="__branch" size="10" maxlength="5" value="<%=chk.chkNullString(request.getParameter("__branch"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="บริษัท">
<a href="javascript:goHelp('MBRANCHHELP','__branch');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__branch_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__branch_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__branch_desc" value="<%=chk.chkNullString(request.getParameter("__branch_desc"))%>" readonly class="diabled">
</td>
</tr>
<tr>
<td width="40%" align="right"><%=dbrec.getField("bu1").getDescription()%> </td>
<td width="60%">
<input type="text" name="__bu1" size="10" maxlength="5" value="<%=chk.chkNullString(request.getParameter("__bu1"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="หน่วยงานระดับ">
<a href="javascript:goHelp('MBU1HELP','__bu1');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu1_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu1_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__bu1_desc" value="<%=chk.chkNullString(request.getParameter("__bu1_desc"))%>" readonly class="diabled">
</td>
</tr>
<tr>
<td width="40%" align="right"><%=dbrec.getField("bu2").getDescription()%> </td>
<td width="60%">
<input type="text" name="__bu2" size="10" maxlength="5" value="<%=chk.chkNullString(request.getParameter("__bu2"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="หน่วยงานระดับ">
<a href="javascript:goHelp('MBU2HELP','__bu2');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu2_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu2_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__bu2_desc" value="<%=chk.chkNullString(request.getParameter("__bu2_desc"))%>" readonly class="diabled">
</td>
</tr>
<tr>
<td width="40%" align="right"><%=dbrec.getField("bu3").getDescription()%> </td>
<td width="60%">
<input type="text" name="__bu3" size="10" maxlength="5" value="<%=chk.chkNullString(request.getParameter("__bu3"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="หน่วยงานระดับ">
<a href="javascript:goHelp('MBU3HELP','__bu3');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu3_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu3_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__bu3_desc" value="<%=chk.chkNullString(request.getParameter("__bu3_desc"))%>" readonly class="diabled"></td>
</tr>
<tr>
<td width="40%" align="right"><%=dbrec.getField("bu4").getDescription()%> </td>
<td width="60%">
<input type="text" name="__bu4" size="10" maxlength="5" value="<%=chk.chkNullString(request.getParameter("__bu4"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="หน่วยงานระดับ">
<a href="javascript:goHelp('MBU4HELP','__bu4');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu4_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu4_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__bu4_desc" value="<%=chk.chkNullString(request.getParameter("__bu4_desc"))%>" readonly class="diabled"></td>
</tr>
<tr>
<td width="40%" align="right"><%=dbrec.getField("bu5").getDescription()%> </td>
<td width="60%">
<input type="text" name="__bu5" size="10" maxlength="5" value="<%=chk.chkNullString(request.getParameter("__bu5"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="หน่วยงานระดับ">
<a href="javascript:goHelp('MBU5HELP','__bu5');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__bu5_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__bu5_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__bu5_desc" value="<%=chk.chkNullString(request.getParameter("__bu5_desc"))%>" readonly class="diabled"></td>
</tr>
<tr>
<td width="40%" align="right"><script language="javascript">swapLang('Shift')</script> </td>
<td width="60%">
<input type="text" name="__shift" size="10" maxlength="5" value="<%=chk.chkNullString(request.getParameter("__shift"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="หน่วยงานระดับ">
<a href="javascript:goHelp('MTIME0HELP','__shift');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__shift_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__shift_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__shift_desc" value="<%=chk.chkNullString(request.getParameter("__shift_desc"))%>" readonly class="diabled">
</td>
</tr>
<tr>
<td width="40%" align="right"><script language="javascript">swapLang('Salatype')</script> </td>
<td width="60%">
<input type="text" name="__salatype" size="10" maxlength="5" value="<%=chk.chkNullString(request.getParameter("__salatype"))%>" onkeypress="chkSpecialKey(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="ระยะเวลาการจ่ายเงินเดือน">
<a href="javascript:goHelp('MSALATYPE0HELP','__salatype');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__salatype_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__salatype_image" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" name="__salatype_desc" value="<%=chk.chkNullString(request.getParameter("__salatype_desc"))%>" readonly class="diabled">
</td>
</tr>
<tr>
<td width="40%" align="right"><script language="javascript">swapLang('Date Between')</script> </td>
<td width="60%">
<input type="text" size="10" name="__start_date" maxlength="10" value="<%=chk.chkNullString(request.getParameter("__start_date"),start_date2.getDDMMYYYY())%>" class="txt01" onKeyup = "formatDate(this)" onKeypress = "chkIntegerOfDate(this.value)" onBlur="chkInputDate2(this,__end_date);"> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1311','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image1311" width="20" border="0" align="absmiddle" id="Image1311" onClick="viewCal('__start_date')"></a> -
<input type="text" size="10" name="__end_date" maxlength="10" value="<%=chk.chkNullString(request.getParameter("__end_date"),end_date2.getDDMMYYYY())%>" class="txt01" onKeyup = "formatDate(this)" onKeypress = "chkIntegerOfDate(this.value)" onBlur="chkInputDate2(__start_date,this);"> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1311','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image1311" width="20" border="0" align="absmiddle" id="Image1311" onClick="viewCal('__end_date')"></a>
</td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW013168" onClick="GoProcess();">SEARCH</button>
</div>
</td>
</tr>
</tr>
<%if(cmd.equals("search")){%>
<table height="" align="center" cellpadding="0" cellspacing="1" class="maxsize" border="0" width="100%">
<tr bgcolor="#3366CC">
<td colspan=2>
<table class="maxsize" border="1" cellpadding="0" cellspacing="1" cols=11 bgcolor="#CCCCCC">
<tr>
<td class="row1" rowspan="2" width="4%"><div align="center" swlang code="SW000193"><b>ลำดับ</b></div></td>
<td class="row1" rowspan="2" width="10%"><div align="center" swlang code="SW000274"><b>รหัสพนักงาน</b></div></td>
<td class="row1" rowspan="2" width="10%"><div align="center" swlang code="SW012526"><b>ชื่อพนักงาน</b></div></td>
<td class="row1" rowspan="2" width="6%"><div align="center" swlang code="SW000019"><b>สถานะ</b></div></td>
<td class="row1" rowspan="2" width="10%"><div align="center"><b><%=dbrec.getField("bu4").getDescription()%></b></div></td>
<td class="row1" rowspan="2" width="10%"><div align="center"><b><%=dbrec.getField("bu5").getDescription()%></b></div></td>
<td class="row1" colspan="3" width="30%"><div align="center"><b><%=lang.equals("THA")?"จำนวนชั่วโมง OT (ชั่วโมง)":"OT Hours (Hours)"%></b></div></td>
<td class="row1" rowspan="2" width="10%"><div align="center"><b><%=lang.equals("THA")?"ขาดงาน (ชั่วโมง)":"Absent"%></b></div></td>
<td class="row1" rowspan="2" width="10%"><div align="center"><b><%=lang.equals("THA")?"ลาไม่จ่ายค่าจ้าง (ชั่วโมง)":"Leave Without Pay (Hours)"%></b></div></td>
<td class="row1" rowspan="2" width="10%"><div align="center"><b><%=lang.equals("THA")?"ค่ากะ (บาท)":"Night Shift (Baht)"%></b></div></td>
</tr>
<tr>
<td class="row1"><div align="center"><b>OT 1</b></div></td>
<td class="row1"><div align="center"><b>OT 1.5</b></div></td>
<td class="row1"><div align="center"><b>OT 3</b></div></td>
</tr>
<%
int i=1;
String empid ="";
String fullname = "";
String bu4 = "";
String bu5 = "";
String status = "";
String ot1 = "";
String ot5 = "";
String ot3 = "";
String absent = "";
String leave = "";
String unused = "";
String st_date = new CscCalendar(request.getParameter("__start_date")).getYYYYMMDD();
String en_date = new CscCalendar(request.getParameter("__end_date")).getYYYYMMDD();
Double sum_ot1 = 0.0;
Double sum_ot5 = 0.0;
Double sum_ot3 = 0.0;
Double sum_absent = 0.0;
Double sum_leave = 0.0;
Double sum_unused = 0.0;
Boolean isShow = true;
Boolean isResign = true;
StringBuffer sql = new StringBuffer();
sql.append("select t1.EMPLOYEEID");
sql.append(",dbo.min_to_time(SUM(dbo.time_to_min(t1.OT1))) as OT1 ");
sql.append(",dbo.min_to_time(SUM(dbo.time_to_min(t1.OT5))) as OT5 ");
sql.append(",dbo.min_to_time(SUM(dbo.time_to_min(t1.OT3))) as OT3 ");
sql.append(",(select dbo.min_to_time(SUM(dbo.time_to_min(M_LV))) as M_LV from TTIME_CURRENT1 where EMPLOYEEID=t1.EMPLOYEEID and EVENTGRP='J' and DATEID between '"+st_date+"' and '"+en_date+"') as ABSENT ");
sql.append(",(select dbo.min_to_time(SUM(dbo.time_to_min(M_LV))) as M_LV from TTIME_CURRENT1 where EMPLOYEEID=t1.EMPLOYEEID and LV_TY in (select EVENTGRPID from MEVENTGRP1 where BRANCHID=e.BRANCHID and ISPAY='0') and DATEID between '"+st_date+"' and '"+en_date+"') as LEAVE ");
sql.append(",SUM(t1.UNUSED1) as UNUSED1 ");
sql.append(",SUM(t1.UNUSED2) as UNUSED2 ");
sql.append(",SUM(t1.UNUSED3) as UNUSED3 ");
sql.append(",SUM(t1.UNUSED4) as UNUSED4 ");
sql.append(",SUM(t1.UNUSED5) as UNUSED5 ");
sql.append(",SUM(t1.UNUSED6) as UNUSED6 ");
sql.append(",SUM(t1.UNUSED7) as UNUSED7 ");
sql.append(",SUM(t1.UNUSED8) as UNUSED8 ");
sql.append(",SUM(t1.UNUSED9) as UNUSED9 ");
sql.append(",SUM(t1.UNUSED10) as UNUSED10 ");
sql.append("from TTIME_CURRENT1 t1 ");
sql.append("left join MEMPLOYEE e on t1.EMPLOYEEID=e.EMPLOYEEID ");
sql.append("left join MPREFIX p on e.EMP_PREFIX=p.PREFIXID ");
sql.append("left join MEMPL_STATUS s on e.STATUS=s.STATUSCODE ");
sql.append("left join MBU5 b5 on t1.BU5=b5.BU5ID ");
sql.append("left join MBU4 b4 on t1.BU4=b4.BU4ID ");
sql.append("where t1.DATEID between '"+st_date+"' and '"+en_date+"' "+filter);
sql.append(" group by t1.EMPLOYEEID,e.BRANCHID; ");
//out.print(sql);
String tableName = "ttime_current1";
DataSet ds = new DataSet(sql.toString(), dbName, tableName);
ds.initConnection(uprofile);
DbInquiry empdata = new InitialInquiry(uprofile).getDbInquiry("memployee");
empdata.setColumn("*");
while(ds.next()){
empid = chk.chkNullString(ds.getString("employeeid"));
empdata.setFilter("employeeid = '"+empid+"'");
empdata.refresh();
empdata.next();
fullname = empdata.getString("fullname");
status = empdata.getString("statusname");
bu4 = empdata.getString("bu4name");
bu5 = empdata.getString("bu5name");
ot1 = dmfm.format(chk.chkNullStringToDouble(ds.getString("ot1")));
ot5 = dmfm.format(chk.chkNullStringToDouble(ds.getString("ot5")));
ot3 = dmfm.format(chk.chkNullStringToDouble(ds.getString("ot3")));
absent = dmfm.format(chk.chkNullStringToDouble(ds.getString("absent")));
leave = dmfm.format(chk.chkNullStringToDouble(ds.getString("leave")));
unused = dmfm.format(chk.chkNullStringToDouble(ds.getString("unused1")));
if(chk.chkNullStringToDouble(ds.getString("ot1"))>0 || chk.chkNullStringToDouble(ds.getString("ot5"))>0 || chk.chkNullStringToDouble(ds.getString("ot3"))>0 || chk.chkNullStringToDouble(ds.getString("absent"))>0 || chk.chkNullStringToDouble(ds.getString("leave"))>0 || chk.chkNullStringToDouble(ds.getString("unused1"))>0){
isShow = true;
}else{
isShow = false;
}
if(chk.chkNullString(ds.getString("status")).equals("Y") && chk.chkNullStringToDouble(ds.getString("ot1"))==0 && chk.chkNullStringToDouble(ds.getString("ot5"))==0 && chk.chkNullStringToDouble(ds.getString("ot3"))==0){
isResign = false;
}else{
isResign = true;
}
if(isShow && isResign){
sum_ot1 += TimeToDec(ot1);
sum_ot5 += TimeToDec(ot5);
sum_ot3 += TimeToDec(ot3);
sum_absent += TimeToDec(absent);
sum_leave += TimeToDec(leave);
sum_unused += Double.parseDouble(unused);
%>
<tr>
<td nowrap ><div align="center"><%=i%></div></td>
<td nowrap ><div align="center"><%=empid%></div></td>
<td nowrap ><div align=""><%=fullname%></div></td>
<td nowrap ><div align="center"><%=status%></div></td>
<td nowrap ><div align=""><%=bu4%></div></td>
<td nowrap ><div align=""><%=bu5%></div></td>
<td nowrap ><div align="center"><%=dmfm.format(TimeToDec(ot1))%></div></td>
<td nowrap ><div align="center"><%=dmfm.format(TimeToDec(ot5))%></div></td>
<td nowrap ><div align="center"><%=dmfm.format(TimeToDec(ot3))%></div></td>
<td nowrap ><div align="center"><%=dmfm.format(TimeToDec(absent))%></div></td>
<td nowrap ><div align="center"><%=dmfm.format(TimeToDec(leave))%></div></td>
<td nowrap ><div align="center"><%=unused%></div></td>
</tr>
<%
i++;
}
}
ds.closeConnection();
%>
<tr>
<td nowrap colspan="6"><div align="center"><b>Total</b></div></td>
<td nowrap ><div align="center"><%=dmfm1.format(sum_ot1)%></div></td>
<td nowrap ><div align="center"><%=dmfm1.format(sum_ot5)%></div></td>
<td nowrap ><div align="center"><%=dmfm1.format(sum_ot3)%></div></td>
<td nowrap ><div align="center"><%=dmfm1.format(sum_absent)%></div></td>
<td nowrap ><div align="center"><%=dmfm1.format(sum_leave)%></div></td>
<td nowrap ><div align="center"><%=dmfm1.format(sum_unused)%></div></td>
</tr>
</table>
</td>
</tr>
<%!
private String chkMySecurity(String p_status,String p_field,String p_data){
String mfilter = "";
if (p_status.equalsIgnoreCase("1")){
mfilter =" AND "+p_field+" NOT IN (";
}else if (p_status.equalsIgnoreCase("0")){
mfilter = " AND "+p_field+" IN (";
}
String mdata[] = p_data.split(",");
for (int i=0;i<mdata.length; i++){
mfilter += "'"+mdata[i]+"',";
}
mfilter = mfilter.substring(0,mfilter.length()-1);
mfilter += ")";
return mfilter;
}
private Double TimeToDec(String string) {
try{
String output = "0.00";
String arr[] = string.split("\\.");
Integer min = (int) (Integer.parseInt(arr[1])/0.6);
output = arr[0]+"."+min;
return Double.parseDouble(output);
}catch (Exception e){
return 0.0;
}
}
%>
</table></td></tr>
<tr>
<td colspan=2 class="blankspace"></td>
</tr>
<tr>
<td colspan=2>
<table class="maxsize" align="center" cellpadding="0" cellspacing="0" class="large">
<tr>
<td align="center">
<div class="button">
<a href="javascript:GoExport();"><img src="../IMAGES/BUTTON/EXPORT.gif" border=0 /></a>
<!-- -->
<!-- <a href="javascript:goPrint();"><img src="../IMAGES/BUTTON/PRINT.gif" border="0"></a> -->
</div>
</td>
</tr>
</table>
</td>
</tr>
<%}
%>
<tr>
<td colspan=2 class="blankspace"></td>
</tr>
<tr bordercolor="0069B3">
<td colspan=2 class="bottom"></td>
</tr>
</table>
</form>
</body>
</html>