<%@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.*,com.csc.library.formula.*,java.text.*"%>
<%@page import="com.csc.library.utilities.CscTime"%>
<jsp:useBean id="TAU134_LPN" class="com.csc.library.system.Task" scope="page" />
<%
TAU134_LPN.setChannel(request, response);
HelpEntry screen = (HelpEntry) TAU134_LPN.process("HelpEntry", "TAU134HELP_LPN");
screen.setMaxLine(20);
screen.referLangOn();
screen.process();
ThaiUtilities thai=new ThaiUtilities();
%>
<html>
<head>
<title></title>
<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: #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;
}
</style>
<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 language="javascript">getTitleName();</script>
<script language="JavaScript" type="text/JavaScript">
<!--
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){
//alert("employeeid='"+empid+"' and dateid='"+dateid+"' and time0id='"+time0id+"'");
//location = "TAU122.jsp?__fixCon=employeeid='"+empid+"' and dateid='"+dateid+"' and time0id='"+time0id+"'";
//alert("employeeid#"+empid+",dateid#"+dateid+",time0id#"+time0id);
//location = "TAU122.jsp?__help=employeeid#"+empid+",dateid#"+dateid+",time0id#"+time0id;
location = "TAU122.jsp?__employeeid="+empid+"&__dateid="+dateid+",&__time0id="+time0id;
//submit();
}
}
function addNew(){
with (document.cscform){
empid='';
dateid='';
time0id='';
action = "TAU122.jsp?__employeeid="+empid+"&__dateid="+dateid+",&__time0id="+time0id;
submit();
}
}
function linkHelp_Return(help,input,filter){
with(document.cscform){
var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter;
window.open(param,"Help","left=150,top=150,width=650,height=450,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function chkDateTime1(valueSearch){
var tmpval="";
with(document.cscform){
var valueSearch1=valueSearch.split("-");
if(valueSearch1.length==3){
if(valueSearch1[1].length==1){
valueSearch1[1]="0"+valueSearch1[1];
}
if(valueSearch1[0].length==1){
valueSearch1[0]="0"+valueSearch1[0];
}
valueSearch1[2]=parseInt(valueSearch1[2]);
return valueSearch=valueSearch1[2]+"-"+valueSearch1[1]+"-"+valueSearch1[0];
}
}
}
function goHelp(helpName,inputName,filter){
var helpReturn;
var fixcon;
helpReturn = inputName+":employeeid"
fixcon="";
linkHelp_Return(helpName,helpReturn,fixcon);
}
function goHelpBu(helpName,inputName,filter){
var helpReturn;
var fixcon;
helpReturn = inputName+":bu2id,"+inputName+"_desc:edesc"
fixcon="";
linkHelp_Return(helpName,helpReturn,fixcon);
}
function goHelpBranch(helpName,inputName,filter){
var helpReturn;
var fixcon;
helpReturn = inputName+":branchid,"+inputName+"_desc:edesc"
fixcon="";
linkHelp_Return(helpName,helpReturn,fixcon);
}
function linkPrint(help,input,filter){
setFilter();
with(document.cscform){
var param="TAU319_PRINT.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+__fixCon.value+"&__emp1="+__emp1.value+"&__emp2="+__emp2.value+"&__bu2="+__bu2.value+"&__bu2_desc="+__bu2_desc.value+"&__branch="+__branch.value+"&__branch_desc="+__branch_desc.value+"&__date1="+__date1.value+"&__date2="+__date2.value;
window.open(param,"Print");
}
}
function setSubmit(){
setFilter();
with(document.cscform){
submit();
}
}
function setFilter(){
with(document.cscform){
__cmd.value="search";
var sqlEmp="";
var sqlDate="";
var sqlBu2="";
var sqlBranch="";
if (__emp1.value.length>0&&__emp2.value.length>0)
sqlEmp = " (employeeid between '"+__emp1.value+"' and '"+__emp2.value+"') ";
else if (__emp1.value.length>0&&__emp2.value.length==0)
sqlEmp = " employeeid='"+__emp1.value+"' ";
else if (__emp2.value.length>0&&__emp1.value.length==0)
sqlEmp = " employeeid='"+__emp2.value+"' ";
if (__date1.value.length>0&&__date2.value.length>0)
sqlDate = " (dateid between '"+chkDateTime1(__date1.value)+"' and '"+chkDateTime1(__date2.value)+"') ";
else if (__date1.value.length>0&&__date2.value.length==0)
sqlDate = " dateid='"+chkDateTime1(__date1.value)+"' ";
else if (__date2.value.length>0&&__date1.value.length==0)
sqlDate = " dateid='"+chkDateTime1(__date2.value)+"' ";
if (__bu2.value.length>0)
sqlBu2 = " bu2='"+__bu2.value+"' ";
else
__bu2_desc.value="";
if (__branch.value.length>0)
sqlBranch = " branch='"+__branch.value+"' ";
else __branch_desc.value="";
if (sqlEmp.length>0&&sqlDate.length>0&&sqlBu2.length>0&&sqlBranch.length>0)
__fixCon.value = sqlEmp + " and " + sqlDate + " and "+ sqlBu2 + " and " + sqlBranch;
else if (sqlEmp.length==0&&sqlDate.length>0&&sqlBu2.length>0&&sqlBranch.length>0)
__fixCon.value = sqlDate + " and "+ sqlBu2 + " and " + sqlBranch;
else if (sqlEmp.length>0&&sqlDate.length==0&&sqlBu2.length>0&&sqlBranch.length>0)
__fixCon.value = sqlEmp + " and "+ sqlBu2 + " and " + sqlBranch;
else if (sqlEmp.length>0&&sqlDate.length>0&&sqlBu2.length==0&&sqlBranch.length>0)
__fixCon.value = sqlEmp + " and " + sqlDate + " and " + sqlBranch;
else if (sqlEmp.length>0&&sqlDate.length>0&&sqlBu2.length>0&&sqlBranch.length==0)
__fixCon.value = sqlEmp + " and " + sqlDate + " and "+ sqlBu2;
else if (sqlEmp.length==0&&sqlDate.length==0&&sqlBu2.length>0&&sqlBranch.length>0)
__fixCon.value = sqlBu2 + " and " + sqlBranch;
else if (sqlEmp.length>0&&sqlDate.length==0&&sqlBu2.length==0&&sqlBranch.length>0)
__fixCon.value = sqlEmp + " and " + sqlBranch;
else if (sqlEmp.length>0&&sqlDate.length>0&&sqlBu2.length==0&&sqlBranch.length==0)
__fixCon.value = sqlEmp + " and " + sqlDate;
else if (sqlEmp.length==0&&sqlDate.length>0&&sqlBu2.length>0&&sqlBranch.length==0)
__fixCon.value = sqlDate + " and "+ sqlBu2;
else if (sqlEmp.length==0&&sqlDate.length>0&&sqlBu2.length==0&&sqlBranch.length>0)
__fixCon.value = sqlDate + " and " + sqlBranch;
else if (sqlEmp.length>0&&sqlDate.length==0&&sqlBu2.length>0&&sqlBranch.length==0)
__fixCon.value = sqlEmp + " and " + sqlBu2;
else if (sqlEmp.length>0&&sqlDate.length==0&&sqlBu2.length==0&&sqlBranch.length==0)
__fixCon.value = sqlEmp;
else if (sqlEmp.length==0&&sqlDate.length>0&&sqlBu2.length==0&&sqlBranch.length==0)
__fixCon.value = sqlDate;
else if (sqlEmp.length==0&&sqlDate.length==0&&sqlBu2.length>0&&sqlBranch.length==0)
__fixCon.value = sqlBu2;
else if (sqlEmp.length==0&&sqlDate.length==0&&sqlBu2.length==0&&sqlBranch.length>0)
__fixCon.value = sqlBranch;
else __fixCon.value="";
//alert(__fixCon.value);
//submit();
}
}
</script>
</head>
<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SEARCH.gif')">
<form name="cscform" method="post" action="TAU134_LPN.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__screen" value="TAU134_LPN">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__orderBy" value="">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__helpName" value="">
<input type="hidden" name="__pageCall" value="">
<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>">
<input type="hidden" name="__calendar">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__employeeid" value="">
<input type="hidden" name="__dateid" value="">
<input type="hidden" name="__time0id" value="">
<script language="javascript">getInputFormatDate();</script>
<%
String emp1="",emp2="",bu2="",branch="",date1="",date2="",bu2_desc="",branch_desc="";
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("__bu2")!=null) bu2=request.getParameter("__bu2");
if (request.getParameter("__branch")!=null) branch=request.getParameter("__branch");
if (request.getParameter("__bu2_desc")!=null) bu2_desc=request.getParameter("__bu2_desc");
if (request.getParameter("__branch_desc")!=null) branch_desc=request.getParameter("__branch_desc");
%>
<br>
<table height="" align="center" cellpadding="0" cellspacing="0" border="1" class="rockSizeTable">
<tr bgcolor="#3366CC">
<td height="20" class="header" colspan="4">TAU134_LPN, <script language="javascript">swapLang("Time Current");</script> </td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
<td align="right"><strong>
<script language="javascript">swapLang("Employee Code");</script> </strong></td>
<td colspan="3"><input type="text" name="__emp1" size="15" value="<%=emp1%>">
<a href="javascript:goHelp('MEMPLOYEEHELP','__emp1','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2" border="0" align="absmiddle"></a> -
<input type="text" name="__emp2" size="15" value="<%=emp2%>">
<a href="javascript:goHelp('MEMPLOYEEHELP','__emp2','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image3" border="0" align="absmiddle"></a></span> </td>
</tr>
<tr>
<td align="right"><script language="javascript">swapLang('Business Unit 2');</script> </td>
<td colspan="3"><input type="text" name="__bu2" size="15" value="<%=bu2%>">
<a href="javascript:goHelpBu('MBU2HELP','__bu2','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('999','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2" border="0" align="absmiddle"></a>
<input name="__bu2_desc" type="text" id="__bu2_desc" value="<%=thai.ASCII2Unicode(bu2_desc)%>" size="50" readonly=""> </td>
</tr>
<tr>
<td align="right"><script language="javascript">swapLang('Branch');</script> </td>
<td colspan="3"><input type="text" name="__branch" size="15" value="<%=branch%>">
<a href="javascript:goHelpBranch('MBRANCHHELP','__branch','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('999','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2" border="0" align="absmiddle"></a>
<input name="__branch_desc" type="text" id="__branch_desc" value="<%=thai.ASCII2Unicode(branch_desc)%>" size="50" readonly=""> </td>
</tr>
<tr>
<td align="right"><script language="javascript">swapLang('Period Date');</script> </td>
<td colspan="3"><span class="columnobject1">
<input type="text" name="__date1" size="10" value="<%=date1%>">
<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar1','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar1" border="0" align="absmiddle" onClick="viewCal('__date1')" alt="Calendar"></a> -
<input type="text" name="__date2" size="10" value="<%=date2%>">
<a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar2','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar2" border="0" align="absmiddle" onClick="viewCal('__date2')" alt="Calendar"></a></span></td>
</tr>
<tr>
<td><div align="right"><script language="javascript">swapLang('Order By');</script> </div></td>
<td><%=screen.getTagOrder()%></td>
<td><div align="right"><script language="javascript">swapLang('Search By');</script> </div></td>
<td><%=screen.getTagSearchBy()%></td>
</tr>
<tr>
<td><div align="right"><script language="javascript">swapLang('Condition');</script> </div></td>
<td><%=screen.getTagConSearch()%></td>
<td><div align="right"><script language="javascript">swapLang('Key Value');</script> </div></td>
<td><%=screen.getTagValueSearch()%> <a href="javascript:search();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" height="20" border="0" align="middle"></a></td>
</tr>
<tr class="medium">
<td colspan="4"><div align="center"><a href="javascript:setSubmit();"><img src="../IMAGES/BUTTON/SUBMIT.gif" alt="Submit" border="0" align="absmiddle"></a></div></td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
<tr>
<td class="blankspace" colspan="4"><div align="right">< <%=screen.getPageTag()%> ></div></td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
<!--tr>
<td class="blankspace" colspan="4"><%//=screen.printTableHTML()%></td>
</tr-->
<tr>
<td colspan="4">
<table height="" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#333333" class="maxsize">
<tr>
<td width="6%" height="21" align="center" class="row3"><script language="javascript">swapLang("Date");</script></td>
<td width="3%" align="center" class="row3"><script language="javascript">swapLang("Date");</script></td>
<td width="7%" align="center" class="row3"><%=screen.getLabel("employeeid")%></td>
<td width="14%" align="center" class="row3"><script language="javascript">swapLang('Name Surname')</script></td>
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("Shift");</script></td>
<td width="7%" align="center" class="row3"><script language="javascript">swapLang("Shift Detail");</script></td>
<td width="6%" align="center" class="row3"><script language="javascript">swapLang("Strandard Working Hours")</script></td>
<td width="12%" align="center" class="row3"><script language="javascript">swapLang("Remark")</script></td>
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("Time In")</script></td>
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("Time Out")</script></td>
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("Late Time")</script></td>
<!--td width="51" class="forborder"><div align="center"><%=screen.getLabel("eventgrp")%></div></td-->
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("Late Hours");</script></td>
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("Leave Hours");</script></td>
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("Absent Hours");</script></td>
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("Work Hour Day");</script></td>
<td width="5%" align="center" class="row3"><script language="javascript">swapLang("OT Hours");</script></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();
CscTime total = new CscTime();
CscTime sum_leave = new CscTime();
CscTime hour_d = new CscTime();
//CscCalendar csc2 = new CscCalendar("30-11-2005");
int i=0;
while(screen.nextRec()) {
if(screen.checkLinePage()) {
CscCalendar cs = new CscCalendar(screen.getString("dateid"));
String holiday = "";
String cFont = "";
String cBgTD="forborder";
String m_lv="0.00";
String m_absent="0.00";
//เช็คประเภทวันที่ลา ถ้าเป็น j ถือว่าขาดงาน
if(screen.getString("lv_ty").equalsIgnoreCase("J")){
m_absent = screen.getString("m_lv");
holiday=screen.getString("meventgrp","edesc");
}else if(screen.getString("lv_ty").equalsIgnoreCase("H")){
//holiday=screen.getString("meventgrp","edesc");
holiday = "Weekend";
cFont ="week";
}else if(screen.getString("lv_ty").equalsIgnoreCase("I")){
//holiday=screen.getString("meventgrp","edesc");
holiday="Holiday";
cFont = "holiday";
}else holiday=screen.getString("meventgrp","edesc");
//เช็ควันเสาร์และอาทิตย์ให้แสดง W
/*if(cs.getDOW()==7 || cs.getDOW()==1) {
holiday="Weekend";
cFont ="week";
//cBgTD="tdholiday";
}*/
/*if(!screen.getString("mholiday1","hdate").equals(cs.get)) {
holiday="Holiday";
}*/
//เช็คจำนวนครั้งที่สาย
String lt_total="0";
if(Double.valueOf(screen.getString("lt")).doubleValue() > 0){
lt_total="1";
i++;
}
String tm_in=screen.getString("m_tm_bg");
String tm_out=screen.getString("m_tm_en");
if(screen.getString("forget_in").equals("1")){
tm_in = "0.00";
}
if(screen.getString("forget_out").equals("1")){
tm_out = "0.00";
}
%>
<tr>
<td class="<%=cBgTD%>" align="center"><a href="javascript:linkDetail('<%=screen.getString("employeeid")%>','<%=screen.getString("dateid")%>','<%=screen.getString("time0id")%>')"><font class="<%=cFont%>"><%=screen.getString("dateid")%></font></a></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><script language="javascript">swapLang('<%=cs.getShortEngDOW()%>')</script></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=screen.getString("employeeid")%></font></td>
<td class="<%=cBgTD%>" align="left"><font class="<%=cFont%>"><%=screen.getString("memployee","fullname")%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=screen.getString("mtime0","time0id")%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=screen.getString("mtime0","edesc")%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=screen.getString("hour_s")%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=holiday%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=tm_in%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=tm_out%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=lt_total%></font></td>
<!--td class="forborder"><div align="center"><%//=screen.getString("ttime_current","eventgrp")%></div></td-->
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=screen.getString("lt")%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=m_lv%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=m_absent%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=screen.getString("hour_d")%></font></td>
<td class="<%=cBgTD%>" align="center"><font class="<%=cFont%>"><%=screen.getString("ac_ot")%></font></td>
<%
/*late += Float.valueOf(screen.getString("lt")).floatValue();
leave += Float.valueOf(screen.getString("lv")).floatValue();
absent += Float.valueOf(screen.getString("absent")).floatValue();
ot += Float.valueOf(screen.getString("ot")).floatValue();*/
total.add(Float.valueOf(screen.getString("hour_s")).floatValue());
late.add(Float.valueOf(screen.getString("lt")).floatValue());
leave.add(Float.valueOf(m_lv).floatValue());
absent.add(Float.valueOf(m_absent).floatValue());
hour_d.add(Float.valueOf(screen.getString("hour_d")).floatValue());
ot.add(Float.valueOf(screen.getString("ac_ot")).floatValue());
%>
</tr>
<%
}
if(screen.outLinePage()) { break; }
}
sum_leave.add(leave.getFloat());
sum_leave.add(absent.getFloat());
sum_leave.add(late.getFloat());
FormulaString fs = new FormulaString();
DecimalFormat df = new DecimalFormat("#0.00");
double total2dec=0;
double time2dec=0;
double hour_d2dec=0;
double ot2dec=0;
double per_leave=0;
double per_work=0;
double per_ot=0;
time2dec = fs.Tm_To_Dec(Double.valueOf(""+sum_leave.getFloat()).doubleValue());
total2dec = fs.Tm_To_Dec(Double.valueOf(""+total.getFloat()).doubleValue());
hour_d2dec = fs.Tm_To_Dec(Double.valueOf(""+hour_d.getFloat()).doubleValue());
ot2dec = fs.Tm_To_Dec(Double.valueOf(""+ot.getFloat()).doubleValue());
per_leave = (time2dec*100)/total2dec;
per_work = (hour_d2dec*100)/total2dec;
per_ot = (ot2dec*100)/total2dec;
%>
<tr>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"><script language="javascript">swapLang('total')</script></td>
<td class="row3" align="center"><%=df.format(Double.valueOf(""+total.getFloat()).doubleValue())%></td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"><%=i%></td>
<td class="row3" align="center"><%=late.getFloat()%></td>
<td class="row3" align="center"><%=leave.getFloat()%></td>
<td class="row3" align="center"><%=absent.getFloat()%></td>
<td class="row3" align="center"><%=hour_d.getFloat()%></td>
<td class="row3" align="center"><%=ot.getFloat()%></td>
</tr>
<tr>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center">%</td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td class="row3" align="center"> </td>
<td colspan="3" align="center" class="row3"><%=df.format(per_leave)%> %</td>
<td class="row3" align="center"><%=df.format(per_work)%> %</td>
<td class="row3" align="center"><%=df.format(per_ot)%> %</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="blankspace" colspan="4">
</td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
<tr>
<td class="blankspace" colspan="4"><div align="center"><a href="javascript:addNew();"><img src="../IMAGES/BUTTON/ADD.gif" border="0"></a></div></td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
</table>
</form>
</body>
</html>