<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.utilities.CscCalendar,com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@page import="com.csc.library.utilities.CscTime,java.text.DecimalFormat"%>
<%@page import="com.csc.library.database.DataSet,java.util.HashMap"%>
<jsp:useBean id="TAU224_EXP" class="com.csc.library.system.Task" scope="page" />
<%
response.setHeader("Cache-Control","must-revalidate");
response.setContentType("application/vnd.ms-excel; UTF-8");
response.setHeader("Content-Disposition", "inline; filename=" + "export.xls");
TAU224_EXP.setChannel(request, response);
HelpEntry screen = (HelpEntry) TAU224_EXP.process("HelpEntry", "TAU224HELP");
screen.setMaxLine(-1);
DecimalFormat dmfm = new DecimalFormat("#,###,##0.00");
CheckNull chk = new CheckNull();
String filter = chk.chkNullString(request.getParameter("__filter"));
screen.inq.setFilter(filter);
if(!filter.equals("")){
screen.process();
}
ThaiUtilities thai=new ThaiUtilities();
java.text.DecimalFormat df=new java.text.DecimalFormat("#0.00");
HashMap hmTime0id = new HashMap();
String sql="select employeeid,time0id,dateid from ttime_current ";
if(!(request.getParameter("__fixCon") ==null || request.getParameter("__fixCon") =="")){
sql+=" where "+request.getParameter("__fixCon");
CscCalendar cal = new CscCalendar();
DataSet ds = new DataSet(sql,screen.getUProfile().getDbName(),"ttime_current");
try{
ds.setFetchAll(false);
ds.initConnection(screen.getUProfile());
String dateid ="";
while(ds.next()){
cal.setDate(ds.getString("dateid"));
dateid = cal.getYYYYMMDD();
hmTime0id.put(ds.getString("employeeid")+":"+dateid,ds.getString("time0id"));
}
}catch(Exception ex){
out.print("Error : DataSet !!!!!! ");
}finally{
ds.closeConnection();
}
}
//----end init time0id from ttime_current
%>
<html ng-app="myHR">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<!-- <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> -->
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script type='text/javascript' src='../JS/DATEINPUT.js'></script>
<script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script>
<script src="../JS/angular-1.3.15/angular.js"></script>
<script type='text/JavaScript' SRC='../JS/ANGULAR/SWAPLANG.js'></script>
<script language="javascript">getTitleName();</script>
<STYLE type=text/css>
FONT.holiday {
FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
font-size: 12px;
color: #FF00FF;
}
FONT.week {
/*FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";*/
font-size: 12px;
color: #FFA700;
}
FONT.absent {
FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
font-size: 12px;
color: #FF0000;
}
TD.tdholiday{
FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
background-color: FF9999;
font-size: 12px;
color: #3366CC;
height: 14px;
border: 1px solid #CCCCCC;
}
TABLE.rockSizeTable{
width: 1100px;
cell-spacing:0;
}
A {
text-decoration: underline;
}
.absent A.absent {
color: #FF0000;
text-decoration: underline;
}
.holiday A.holiday {
color: #FF00FF;
text-decoration: underline;
}
.week A.week {
color: #FFA700;
text-decoration: underline;
}
td.colorRow0{
background-color:#FFFFFF;
border:1px solid #CCCCCC;
color:#3366CC;
font-size:12px;
height:14px;
}
td.colorRow1{
background-color:#EFEFEF;
border:1px solid #CCCCCC;
color:#3366CC;
font-size:12px;
height:14px;
}
td.header_aga{
-moz-background-clip:border;
-moz-background-inline-policy:continuous;
-moz-background-origin:padding;
background:#BBBBBB none repeat scroll 0 0;
border:1px solid #BBBBBB;
font-size:12px;
font-weight:bold;
}
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
var sw = new swaplang2();
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a && i<a.length && (x=a[i]) && x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0 && parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n]) && d.all) x=d.all[n]; for (i=0;!x && i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x && d.layers && i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
function linkDetail(empid, dateid, time0id){
with (document.cscform){
location = "TAU122.jsp?__employeeid="+empid+"&__dateid="+dateid+"&__time0id="+time0id+"&__search=true"+getAllCondition()+"&__whereCuz="+__fixCon.value;
}
}
</script>
</head>
<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SEARCH.gif')">
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="TAU224_EXP.jsp" ng-controller="Swaplang as sw">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__screen" value="TAU224_EXP">
<input type="hidden" name="__cmd" value="search">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__calendar">
<input type="hidden" name="__employeeid" value="">
<input type="hidden" name="__dateid" value="">
<input type="hidden" name="__time0id" value="">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input type="hidden" name="__helpReturn" value="<%=request.getParameter("__helpReturn")%>">
<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")%>">
<script language="javascript">getInputFormatDate();</script>
<%
String emp1="",emp2="",bu1="",bu2="",bu3="",bu4="",bu5="",date1="",date2="",bu1_desc="",bu2_desc="",bu3_desc="",bu4_desc="",bu5_desc="",punch_before="2.30",punch_after="2.30";
if (request.getParameter("__date1")!=null) date1=request.getParameter("__date1");
if (request.getParameter("__date2")!=null) date2=request.getParameter("__date2");
if (request.getParameter("__emp1")!=null) emp1=request.getParameter("__emp1");
if (request.getParameter("__emp2")!=null) emp2=request.getParameter("__emp2");
if (request.getParameter("__bu1")!=null) bu1=request.getParameter("__bu1");
if (request.getParameter("__bu2")!=null) bu2=request.getParameter("__bu2");
if (request.getParameter("__bu3")!=null) bu3=request.getParameter("__bu3");
if (request.getParameter("__bu4")!=null) bu4=request.getParameter("__bu4");
if (request.getParameter("__bu5")!=null) bu5=request.getParameter("__bu5");
if (request.getParameter("__bu1_desc")!=null) bu1_desc=request.getParameter("__bu1_desc");
if (request.getParameter("__bu2_desc")!=null) bu2_desc=request.getParameter("__bu2_desc");
if (request.getParameter("__bu3_desc")!=null) bu3_desc=request.getParameter("__bu3_desc");
if (request.getParameter("__bu4_desc")!=null) bu4_desc=request.getParameter("__bu4_desc");
if (request.getParameter("__bu5_desc")!=null) bu5_desc=request.getParameter("__bu5_desc");
if (request.getParameter("__punch_before")!=null) punch_before=request.getParameter("__punch_before");
if (request.getParameter("__punch_after")!=null) punch_after=request.getParameter("__punch_after");
%>
<br>
<table height="" align="center" cellpadding="0" cellspacing="0" border="1" class="largest">
<%
String cmd = request.getParameter("__cmd");
String goPage = request.getParameter("__goPage");
%>
<tr>
<td colspan="4">
<table height="" align="center" cellpadding="0" cellspacing="0" class="largest" border="1">
<tr bgcolor="#0099FF">
<td width="10%" class=""><div align="center"><strong><%=screen.getLabel("employeeid")%></strong></div></td>
<td width="10%" class=""><div align="center"><strong>ชื่อ - สกุล</strong></div></td>
<td width="10%" class=""><div align="center"><strong>วัน</strong></div></td>
<td width="5%" class=""><div align="center"><strong>รหัสกะ</strong></div></td>
<td width="5%" class=""><div align="center"><strong><%=screen.getLabel("eventgrp")%></strong></div></td>
<td width="5%" class=""><div align="center"><strong>เวลาเริ่มต้นของกะ</strong></div></td>
<td width="5%" class=""><div align="center"><strong>เวลาสิ้นสุดของกะ</strong></div></td>
<td width="5%" class=""><div align="center"><strong>บันทึกเวลาเข้า</strong></div></td>
<td width="5%" class=""><div align="center"><strong>บันทึกเวลาออก</strong></div></td>
<td width="5%" class=""><div align="center"><strong>เข้างานก่อนเวลา</strong></div></td>
<td width="5%" class=""><div align="center"><strong>ออกงานหลังเวลา</strong></div></td>
<!-- <td width="5%" class="header_aga"><div align="center"><strong><script language="javascript">sw.write('SW000330');</script></strong></div></td>
<td width="5%" class="header_aga"><div align="center"><strong><script language="javascript">sw.write('SW000331');</script></strong></div></td>
<td width="5%" class="header_aga"><div align="center"><strong><script language="javascript">sw.write('SW000764');</script></strong></div></td> -->
<td width="5%" class=""><div align="center"><strong>ชม. โอที</strong></div></td>
<td width="5%" class=""><div align="center"><strong>จำนวนชม.ทำงานต่อวัน</strong></div></td>
<td width="5%" class=""><div align="center"><strong>โอที 1</strong></div></td>
<td width="5%" class=""><div align="center"><strong>โอที 1.5</strong></div></td>
<td width="5%" class=""><div align="center"><strong>โอที 2</strong></div></td>
<td width="5%" class=""><div align="center"><strong>โอที 3</strong></div></td>
</tr>
<%
//float late=0, leave=0, ot=0, absent=0;
CscTime late = new CscTime();
CscTime leave = new CscTime();
CscTime ot = new CscTime();
CscTime absent = new CscTime();
float leave_day = 0;
int rowColor =1; // for swap row color
CscCalendar oldCsc = new CscCalendar();
// out.print(screen.inq.getFilter());
while(screen.nextRec()) {
if(screen.checkLinePage()) {
String cFont = "";
if (screen.getString("eventgrp").equalsIgnoreCase("J")){
cFont ="absent";
} else if (screen.getString("eventgrp").equalsIgnoreCase("H")){
cFont ="week";
} else if (screen.getString("eventgrp").equalsIgnoreCase("I")){
cFont ="holiday";
}
%>
<tr >
<%
CscCalendar csc = new CscCalendar(screen.getString("dateid"));
if(!csc.equals(oldCsc)){
rowColor++;
oldCsc = csc;
}
%>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("employeeid")%></font></div></td>
<td class=""><div align="left"><font class="<%=cFont%>"> <%=screen.getString("memployee","fullname")%></font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("dateid")%></font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("time0id")%></font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("MEVENTGRP", "tsdesc")%></font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("c_tm_bg")%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("c_tm_en")%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("forget_in").equals("0")?screen.getString("m_tm_bg"):screen.getString("doctype").equals("A")?screen.getString("c_tm_bg"):"-"%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("forget_out").equals("0")?screen.getString("m_tm_en"):screen.getString("doctype").equals("A")?screen.getString("c_tm_en"):"-"%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("forget_in").equals("0")?screen.getString("punch_before"):screen.getString("doctype").equals("A")?screen.getString("punch_before"):"-"%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("forget_out").equals("0")?screen.getString("punch_after"):screen.getString("doctype").equals("A")?screen.getString("punch_after"):"-"%> </font></div></td>
<!-- <td class="colorRow<%//=(rowColor%2)%>"><div align="center"><font class="<%//=cFont%>"><%//=screen.getString("lt")%></font></div></td> -->
<!-- ขาดงาน ถ้า doctype เป็น A -- m_lv จะเป็นลา -->
<!-- <td class="colorRow<%//=(rowColor%2)%>"><div align="center"><font class="<%//=cFont%>"><%//=(screen.getString("doctype").equals("A"))?screen.getString("m_lv"):"0.00"%></font></div></td> -->
<!-- ขาดงาน ถ้า event เป็น J -- m_lv จะเป็นขาดงาน -->
<!-- <td class="colorRow<%//=(rowColor%2)%>"><div align="center"><font class="<%//=cFont%>"><%//=(screen.getString("eventgrp").equals("J"))?screen.getString("m_lv"):"0.00"%></font></div></td> -->
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("ac_ot")%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("hour_d")%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("ot1")%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("ot5")%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("ot2")%> </font></div></td>
<td class=""><div align="center"><font class="<%=cFont%>"><%=screen.getString("ot3")%> </font></div></td>
</tr>
<%
}
if(screen.outLinePage()) {
break;
}
}
%>
</table> </td>
</tr>
</table>
</form>
<br>
</body>
</html>