<%@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.*" %> <jsp:useBean id="TAU308" class="com.csc.library.system.Task" scope="page"/> <% TAU308.setChannel(request,response); HelpEntry screen = (HelpEntry) TAU308.process("HelpEntry","TAU308HELP"); screen.process(); screen.nextRec(); screen.referLangOff(); String DateS=""; String DateE=""; try { CscCalendar csBudget = new CscCalendar(); int yearStart = csBudget.getYear(); csBudget.incYear(1); int yearEnd = csBudget.getYear(); DbInquiry inqM = new InitialInquiry(screen.getUProfile()).getDbInquiry(); inqM.initMyTable("Mbudget", "", ""); inqM.setColumn("budid,companyid,years,startdate,enddate"); inqM.setFilter("startdate<='"+yearStart+"-10-01' and enddate >='"+yearEnd+"-09-30' and companyid='"+screen.getUProfile().get("companyid")+"'"); inqM.refresh(); if (inqM.next()) { CscCalendar cs1 = new CscCalendar(inqM.getString("startdate")); CscCalendar cs2 = new CscCalendar(inqM.getString("enddate")); DateS = cs1.getDDMMYYYY(); DateE = cs2.getDDMMYYYY(); } }catch (Exception e) {} %> <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 language="javascript">getTitleName();</script> <script src="../JS/VIEWCALENDAR.js"></script> <script language="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 chkDateStart(valueSearch,date){ var tmpval=""; var data1=""; with(document.cscform){ var valueSearch1=valueSearch.split("-"); if(valueSearch1.length==3){ if(valueSearch1[0].length==4){ data1=valueSearch1[0]; valueSearch1[0]=valueSearch1[2]; valueSearch1[2]=data1; } 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]); if(date=="date_start"){ date_start.value=valueSearch1[0]+"-"+valueSearch1[1]+"-"+valueSearch1[2]; }else{ date_end.value=valueSearch1[0]+"-"+valueSearch1[1]+"-"+valueSearch1[2]; } } //alert("par.value -> "+date_start.value); } } function bdOnload() { with(document.cscform){ var a=chkDateTime1(date_start.value); var b=chkDateTime1(date_end.value); __date_start.value=a; __date_end.value=b; submit(); document.cscform.submit(); } } function pageDesc(c){ with(document.cscform){ var a=chkDateTime1(date_start.value); var b=chkDateTime1(date_end.value); action="TAU309.jsp?__cmd=&__gorec=" +"&__date_start="+a+"&__date_end="+b; __fixCon.value=" employeeid='<%=request.getParameter("__employeeid")%>' and m_dt_bg between '"+a+"' and '"+b+"' and eventgrp='"+c+"'"; submit(); } } function chkEmpid(){ window.document.forms[0].__employeeid.value=window.parent.document.forms[0].__employeeid.value; } function checkCF() {checkConfirm();} </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];} } //--> </script> </head> <body leftmargin="0" topmargin="0" > <% CscCalendar cs=new CscCalendar(); %> <form name="cscform" method="post" > <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__cmd" value=""> <input type="hidden"name="__screen" value="TAU308"> <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 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="<%=request.getParameter("__fixCon")%>"> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__childFilter" > <input type="hidden" name="__employeeid" value="<%=screen.getUProfile().get("actor")%>"> <% if (request.getParameter("__date_start")==null) { %> <% if (!DateS.equals("")&&!DateE.equals("")) {%> <input type="hidden" name="__date_start" value="<%=DateS%>"> <%} else {%> <input type="hidden" name="__date_start" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>"> <% } %> <% } else {%> <input type="hidden" name="__date_start" value="<%=request.getParameter("__date_start")%>"> <%}%> <% if (request.getParameter("__date_end")==null) { %> <% if (!DateS.equals("")&&!DateE.equals("")) {%> <input type="hidden" name="__date_end" value="<%=DateE%>"> <%} else {%> <input type="hidden" name="__date_end" value="<%=cs.getDDMMYYYY()%>"> <% } %> <% } else {%> <input type="hidden" name="__date_end" value="<%=request.getParameter("__date_end")%>"> <%}%> <input type="hidden" name="__dateFilter" value=""> <div align="center"> <table> <tr> <td class="header" colspan="2" >TAU308, <script language="javascript">swapLang('Leave Statistic');</script> </td> </tr> <tr> <td colspan="2"> <div align="center"> <center> <table cellspacing="0" cellpadding="0"> <tr> <td colspan="4" class="blankspace"></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("employeeid")%> </td> <td><%=screen.getUProfile().get("actor")%></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang('Name Surname');</script> </td> <td><%=screen.getUProfile().get("fullname")%></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang('Time Period');</script> </td> <td colspan="3" class="columnobject1"> <% if (request.getParameter("date_start")==null) { %> <% if (!DateS.equals("")&&!DateE.equals("")) {%> <input type="text" name="date_start" value="<%=DateS%>" size="11"> <%} else {%> <input type="text" name="date_start" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>" size="11"> <% } %> <% } else {%> <input type="text" name="date_start" value="<%=request.getParameter("date_start")%>" size="11"> <%}%> <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('date_start')" alt="Calendar"></a> <% if (request.getParameter("date_end")==null) { %> <% if (!DateS.equals("")&&!DateE.equals("")) {%> <input type="text" name="date_end" value="<%=DateE%>" size="11"> <%} else {%> <input type="text" name="date_end" value="<%=cs.getDDMMYYYY()%>" size="11"> <% } %> <% } else {%> <input type="text" name="date_end" value="<%=request.getParameter("date_end")%>" size="11"> <%}%> <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('date_end')" alt="Calendar"></a> <a href="javascript:bdOnload();"><img src="../IMAGES/BUTTON/SUBMIT.gif" alt="Submit" border="0" align="absmiddle"></a> </td> </tr> <tr> <td colspan="5" class="blankspace"> </tr> <tr > <td rowspan="2" height="35" width="186" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Leave Type");</script></b></div></td> <td width="166" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Limit");</script></b></div></td> <td width="134" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Used");</script></b></div></td> <td width="120" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Remain");</script></b></div></td> </tr> <tr> <td width="166" height="10" class="row3"> <div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td> <td width="134" height="10" class="row3"> <div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td> <td width="120" height="10" class="row3"> <div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td> </tr> <% DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("Meventgrp"); inq.setSchemaName(screen.getUProfile().getSchemaName()); inq.setFilter("daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9' "); inq.setColumn("*"); inq.refresh(); while(inq.next()){ String a="simmemployee_tadjtime0$"+ inq.getString("eventgrpid"); String b= inq.getString("eventgrpid"); %> <% if (b.equals("04") || b.equals("13")) { %> <tr > <td width="186" height="19"><div align="CENTER"><a href="javascript:pageDesc('<%=b%>')"><%=screen.getString("memployee",a+"4")%></a></div></td> <td width="166" height="19"> <div align="CENTER">--:--:--</div></td> <td width="134" height="19"> <div align="CENTER"><%=screen.getString("memployee",a+"2")%></div></td> <td width="120" height="19"> <div align="CENTER">--:--:--</div></td> </tr> <% } else { %> <tr > <td width="186" height="19"><div align="CENTER"><a href="javascript:pageDesc('<%=b%>')"><%=screen.getString("memployee",a+"4")%></a></div></td> <td width="166" height="19"> <div align="CENTER"><%=screen.getString("memployee",a+"1")%></div></td> <td width="134" height="19"> <div align="CENTER"><%=screen.getString("memployee",a+"2")%></div></td> <td width="120" height="19"> <div align="CENTER"><%=screen.getString("memployee",a+"3")%></div></td> </tr> <% }%> <% }%> <tr> <td class="blankspace" colspan="4"></td> </tr> </table> </center> </div></td> </tr> <tr> <td class="bottom" > </td> </tr> </table> </div> </form> </body> </html>