<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.formula.*"%> <%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.timeattendance.*"%> <%@page import="com.csc.library.timeattendance.GenShift,java.util.TreeMap,java.util.Iterator,java.util.HashMap"%> <jsp:useBean id="SHOWLEAVE" class="com.csc.library.system.Task" scope="page" /> <% CheckNull chkNull=new CheckNull(); SHOWLEAVE.setChannel(request ,response); HelpEntry screen = (HelpEntry) SHOWLEAVE.process("HelpEntry","SHOWLEAVEHELP"); String empid =chkNull.chkNullString(request.getParameter("__employeeid"),screen.getString("employeeid")); screen.getInquiry().setFilter("employeeid = '"+empid+"'"); screen.process(); screen.nextRec(); // out.println("employeeid -->> "+screen.getString("employeeid")+"<br>"); // out.println("employeeid -->> "+request.getParameter("__employeeid")); CscCalendar cs = new CscCalendar(); String sDate = "01-"+cs.getMM()+"-"+cs.getYear(); String eDate = cs.getDDMMYYYY(); try { sDate = StaticConfig.getConfigCompany(screen.getUProfile(), "ta1001"); eDate = StaticConfig.getConfigCompany(screen.getUProfile(), "ta1002"); } catch (Exception e) {} CscCalendar cssDate = new CscCalendar(sDate); CscCalendar cseDate = new CscCalendar(eDate); //out.println(cssDate.getDDMMYYYY()+" "+cseDate.getDDMMYYYY()+"<br>"); String openWith =chkNull.chkNullString(request.getParameter("openWith"),""); %> <html> <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 language="JavaScript" src="../JS/SCREEN.js"></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</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 back(unit){ with(window.opener.document.cscform){ locateId.value =unit; } window.close(); } function pageDesc2(c){ with(document.cscform){ // var a=chkDateTime1(date_start.value); // var b=chkDateTime1(date_end.value); var a = '<%=cssDate.getYYYYMMDD()%>'; var b = '<%=cseDate.getYYYYMMDD()%>'; //alert(a+"--"+b); __fixCon.value=" employeeid='<%=request.getParameter("__employeeid")%>' and dateid between '"+a+"' and '"+b+"' and lv_type='"+c+"'"; window.open("TAU144.jsp?__cmd=&__gorec="+ "&__date_start="+a+ "&__date_end="+b+"&__fixCon="+__fixCon.value, "Child","left=150,top=20,width=700,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); //__childFilter.value="ttime_current1:m_dt_bg between '"+a+"' and '"+b+"' and eventgrp='"+c+"'"; //alert(__fixCon.value); submit(); } } function pageDesc(c){ /*with(document.cscform){ var a = '<%//=cssDate.getYYYYMMDD()%>'; var b = '<%//=cseDate.getYYYYMMDD()%>'; action="SHOWNLEAVE_DETAIL.jsp?__cmd=&__gorec="+ "&__date_start="+a+ "&__date_end="+b; __fixCon.value=" employeeid='<%//=request.getParameter("__employeeid")%>' and dateid between '"+a+"' and '"+b+"' and lv_type='"+c+"' "; if(c == 'OTL') __fixCon.value += " and is_otl='0'"; window.open ("SHOWNLEAVE_DETAIL.jsp?__empID="+__empID.value+"&__empName="+__empName.value +"&__cmd=&__gorec="+ "&__date_start="+a+"&__date_end="+b+"&__fixCon="+__fixCon.value ,"mywindow","width=595,height=200,scrollbars=1"); }*/ with(document.cscform){ var a = '<%=cssDate.getYYYYMMDD()%>'; var b = '<%=cseDate.getYYYYMMDD()%>'; action="SHOWLEAVE_WF_DESC.jsp?__cmd=&__gorec="+ "&__date_start="+a+"&__date_end="+b; __fixCon.value=" employeeid='<%=request.getParameter("__employeeid")%>' and dateid between '"+a+"' and '"+b+"' and lv_type='"+c+"'"; //alert(__fixCon.value); submit(); } } //--> </script> </head> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <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="SHOWLEAVE"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__goPage" value=""> <input type="hidden" name="__orderBy" value=""> <input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>"> <input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>"> <input type="hidden" name="__fixCon" value="employeeid='<%=empid%>'"> <input type="hidden" name="__empID" value="<%=empid%>"> <input type="hidden" name="__empName" value="<%=screen.getDataLabel("fullname")%>"> <table cellpadding="0" cellspacing="0" class="inframe" > <tr > <td colspan="2"> <div align="center"> <table class="maxsize" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#666666" > <tr> <td colspan="6"><div align="center"><script language="javascript">swapLang("Leave Statistic");</script> <script language="javascript">swapLang("Start Date");</script> <%=cssDate.getDDMMYYYY()%> <script language="javascript">swapLang("End Date");</script> <%=cseDate.getDDMMYYYY()%> </div> </td> </tr> <tr > <td width="390" class="row3" rowspan="2"><div align="CENTER"><b><script language="javascript">swapLang("Leave Type");</script></b></div></td> <td width="228" height="17" class="row3"><div align="CENTER"><b> <script language="javascript">swapLang("Limit Last Year");</script> <script language="javascript">swapLang("End");</script> <br><%=screen.inq.getString("lastleavedate")%></b></div></td> <td width="204" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Limit");</script></b></div></td> <td width="204" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Used");</script></b></div></td> <td width="207" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Remain");</script></b></div></td> </tr> <tr> <td width="228" height="10" class="row3"><div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td> <td width="204" height="10" class="row3"><div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td> <td width="204" height="10" class="row3"><div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td> <td width="207" height="10" class="row3"><div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td> </tr> <% String vacation0_get = "00:00:00"; String vacation0 = "00:00:00"; String vacation1 = "00:00:00"; FormulaString fs = new FormulaString(); DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee"); inqEmp.setSchemaName(screen.getUProfile().getSchemaName()); inqEmp.setFilter("employeeid='"+empid+"'"); inqEmp.setColumn("employeeid, companyid, emp_level, vacation0, vacation1, vacation0_get"); inqEmp.refresh(); if (inqEmp.next()){ vacation0 = inqEmp.getString("vacation0"); vacation1 = inqEmp.getString("vacation1"); vacation0_get = inqEmp.getString("vacation0_get"); } %> <% String cFont = ""; String v0_limit = ""; String v1_limit = ""; DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("Meventgrp1"); inq.setSchemaName(screen.getUProfile().getSchemaName()); inq.setFilter("(daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9') and BRANCHID = (select BRANCH from MEMPLOYEE where EMPLOYEEID = '" +empid+ "')"); //inq.setFilter("(daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9') "); inq.setOrderBy("display_order"); inq.setColumn("*"); inq.refresh(); while(inq.next()){ String a="simmemployee_tadjtime0$"+ inq.getString("eventgrpid"); String b= inq.getString("eventgrpid"); String type = inq.getString("daytype"); //boolean display = inq.getString("display_limit").equals("1"); String event_desc = inq.getString("event_desc"); if (screen.inq.getString(a+"_remain").indexOf('-')>-1) { cFont = "error"; } else cFont = ""; %> <tr > <td height="19" class="row-data"><div align="left"> <a href="javascript:pageDesc('<%=b%>')"><%=screen.inq.getString(a+"_desc")%></a></div></td> <% String result = ""; String c_limit = chkNull.chkNullString(screen.inq.getString(a+"_limit"),"00:00"); String c_used = chkNull.chkNullString(screen.inq.getString(a+"_used"),"00:00"); String c_remain = chkNull.chkNullString(screen.inq.getString(a+"_remain"),"00:00"); String list[] = {vacation0,vacation1,c_used,c_remain}; String list_value[] = {"","","",""}; if (type.equals("7")) { if (vacation0.equals("")) { vacation0 = "00:00:00"; /*} else { if (!vacation0.equals(vacation1)) { vacation0 = vacation0_get; }*/ } if (vacation1.equals("")) { vacation1= "00:00:00"; } list[0] = vacation0; list[1] = vacation1; } else { list[0] = ""; list[1] = c_limit; } for(int i = 0; i<list.length; i++){ String splitTime[] = list[i].split(":"); int day = chkNull.chkNullStringToInt(splitTime[0]); if(splitTime.length > 2){ if (Float.parseFloat(splitTime[1]) == 0) { result = day + ".0"; } else if (Float.parseFloat(splitTime[1]) <= 4.5) { result = day + ".5"; } else { result = day + ".0"; } list_value[i] = result; } } %> <input type="hidden" name="<%="L"+b+"_USED"%>" value="<%=fs.DhmToM(screen.inq.getString(a+"_used"), 8)%>"> <td height="19"><div align="center"> <font class='<%=cFont%>'> <% //if(b.equals("A01") || openWith.equals("HR")){ out.print(list[0]); //}else{ // out.println(""); //}//end if %> </font>   </div> </td> <td height="19"><div align="center"> <font class='<%=cFont%>'> <% out.print(list[1]); %> </font>   </div></td> <td height="19"><div align="center"> <font class='<%=cFont%>'> <%=list[2]%> </font>   </div></td> <td height="19"><div align="center"> <font class='<%=cFont%>'> <% out.print(list[3]); %> </font>   </div></td> </tr> <% }%> </table> </div></td> </tr> </td> </tr> </table> </form> </body> </html>