<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <%@ page import="java.util.*"%> <jsp:useBean id="TAU318" class="com.csc.library.system.Task" scope="page" /> <%! public String chkdate(String ds){ String t1,t2=""; int i=0; StringTokenizer stChkFormula = new StringTokenizer(ds,"-"); while (stChkFormula.hasMoreTokens()){ t1 = stChkFormula.nextToken().toString(); if(t1.length()==1){t1="0"+t1;} t2=t2+t1; if(i==0||i==1){t2=t2+"-";} i++; } return t2; } %> <% TAU318.setChannel(request,response); UIManager screen = (UIManager) TAU318.process("MultiEntry","TAU318"); MultiLine multi = screen.getMultiLine("Tadjtime0"); multi.goFirst(); String filter="",ds,de,emp,emptest,x1,x2; ds = request.getParameter("__dstart"); de = request.getParameter("__dend"); System.out.println("date--->"+ds+"<->"+de); emptest=screen.getUProfile().get("actor"); System.out.println("employeeid--->"+emptest); DbTable table = multi.getTable(); System.out.println("getTable-->"+multi.getTable()); if(( ds==null)||ds.equals("") && ( de==null)||de.equals("")) { filter = "(doctype='O' or doctype='B')and employeeid="+"'"+emptest+"'"; } else if(( ds!=null) && ( de!=null)) { x1 = chkdate(ds); x2 = chkdate(de); filter = "(doctype='O' or doctype='B') and (docdate between "+"'"+x1+"' and '"+x2+"') and employeeid="+"'"+emptest+"'"; } System.out.println("filter--->"+filter); table.setFilter(filter); table.setKeyOff(); table.refresh(); java.text.DecimalFormat df=new java.text.DecimalFormat("#0.00"); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <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 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 bdOnload() { with(document.cscform){ var a=chkDateTime1(dstart.value); var b=chkDateTime1(dend.value); __dstart.value=a; __dend.value=b; __cmd.value="search"; submit(); } } 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];} } </script> </head> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <% CscCalendar cs = new CscCalendar();%> <form name="cscform" method="post" action="TAU318.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__screen" value="TAU318"> <input type="hidden" name="__multiTable" value="Tadjtime0"> <input type="hidden" name ="__headMulti" value="TAU318"> <input type="hidden" name="__calendar"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__help" value=""> <input type="hidden" name="__helpReturn" value=""> <input type="hidden" name="__helpName" value=""> <input type="hidden" name="__pageCall" value=""> <input name="__fixCon" type="hidden" value="companyid ='<%=screen.getUProfile().get("companyid")%>'"> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__notNull" value="<%=screen.getRequire()%>"> <input name="__language" type="hidden" value="<%=screen.getUProfile().get("lang")%>"> <% if (request.getParameter("__dstart")==null) { %> <input type="hidden" name="__dstart" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>"> <% } else {%> <input type="hidden" name="__dstart" value="<%=request.getParameter("__dstart")%>"> <%}%> <% if (request.getParameter("__dend")==null) { %> <input type="hidden" name="__dend" value="<%=cs.getDDMMYYYY()%>"> <% } else {%> <input type="hidden" name="__dend" value="<%=request.getParameter("__dend")%>"> <%}%> <input type="hidden" name="__childFilter"> <% String d_start="",d_end=""; if (request.getParameter("__dstart")!=null) d_start=request.getParameter("__dstart"); if (request.getParameter("__dend")!=null) d_end=request.getParameter("__dend"); %> <div align="center"> <br> <table cellpadding="0" cellspacing="0"> <tr > <td width="640" class="header">TAU318, <script language="javascript">swapLang('OT Statistic After Approve');</script> </td> </tr> <tr> <td colspan="2"> <div align="center"> <center> <table cellpadding="0" cellspacing="0"> <tr> <td class="blankspace" colspan="2"></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("employeeid")%> </td> <td width="482"><%=screen.getUProfile().get("actor")%></td> </tr> <tr> <td ><div align="right"><%=screen.getLabel("fname")%> </div></td> <td ><%=screen.getUProfile().get("fullname")%></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang('Time Period');</script> </td> <td> <% if (request.getParameter("dstart")==null) { %> <input name="dstart" type="text" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>" size="10" > <% } else {%> <input name="dstart" type="text" value="<%=request.getParameter("dstart")%>" size="10" > <% }%> <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" width="20" height="20" border="0" align="absmiddle" onClick="viewCal('dstart')" alt="Calendar"></a> <% if (request.getParameter("dend")==null) { %> <input name="dend" type="text" value="<%=cs.getDDMMYYYY()%>" size="10" > <% } else {%> <input name="dend" type="text" value="<%=request.getParameter("dend")%>" size="10" > <% }%> <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" width="20" height="20" border="0" align="absmiddle" onClick="viewCal('dend')" alt="Calendar"></a> <a href="javascript:bdOnload();"> <img src="../IMAGES/BUTTON/SUBMIT.gif" border="0" align="absbottom"></a></td> </tr> <tr> <td class="columnlabel"> </td> <td></td> </tr> <tr align="center"> <td height="21" colspan="2"> <table width="1191" border="0" cellpadding="0" cellspacing="0" class="inframe"> <tr bgcolor="#3366CC"> <td width="62" align="center" class="row3"><%=multi.getLabel("doctype")%></td> <td width="148" align="center" class="row3"><%=multi.getLabel("docdate")%></td> <td width="125" align="center" class="row3"><%=multi.getLabel("tm_bg")%></td> <td width="121" align="center" class="row3"><%=multi.getLabel("tm_en")%></td> <td width="112" align="center" class="row3"><script language="javascript">swapLang('OT Total');</script></td> </tr> <%if(!multi.getDataLabel("doctype").trim().equals("")){ double total=0,tmbg=0,tmen=0; do{ tmbg=Double.parseDouble(multi.getDataLabel("tm_bg")); tmen=Double.parseDouble(multi.getDataLabel("tm_en")); total=tmen-tmbg; if(total<0){ total=total*-1; } %> <tr> <td align="center" class="forborder"><%=multi.getDataLabel("doctype")%></td> <td align="center" class="forborder"><%=multi.getDataLabel("docdate")%></td> <td align="center" class="forborder"><%=tmbg%></td> <td align="center" class="forborder"> <%=tmen%></td> <td align="center" class="forborder"> <%=df.format(total)%> </td> </tr> <%multi.next(); }while(!multi.eof());}%> </table></td> </tr> <tr> <td class="blankspace" colspan="2"></td> </tr> </table> <br> </center> </div></td> </tr> <tr> <td class="bottom"></td> </tr> </table></center> </div> </div> </form> <!--Start ERROR AND WARNING --> <!--END ERROR AND WARNING --> </body> </html>