<%@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.*,com.csc.library.formula.FormulaString" %> <jsp:useBean id="TAU143" class="com.csc.library.system.Task" scope="page"/> <% TAU143.setChannel(request,response); HelpEntry screen = (HelpEntry) TAU143.process("HelpEntry","TAU143HELP"); screen.process(); screen.nextRec(); screen.referLangOff(); //out.println(request.getParameter("__date_start")); //out.println(request.getParameter("__date_end")); CheckNull chkNull=new CheckNull(); String empid =chkNull.chkNullString(request.getParameter("__employeeid"),screen.getString("employeeid")); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <style type=text/css> FONT.error { FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif"; font-size: 14px; color: #FF0000; } </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 language="javascript">getTitleName();</script> <script src="../JS/VIEWCALENDAR.js"></script> <script language="javascript"> function chkDateTime1(valueSearch){ // 23/03/2004 var tmpval=""; with(document.cscform){ // tmpval=valueSearch.substring(2,3); 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){ //alert("date_start.value -> "+valueSearch); var valueSearch1=valueSearch.split("-"); //alert("0 - >"+valueSearch1[0]+" #1 - >"+valueSearch1[1]+" #2 - >"+valueSearch1[2]); if(valueSearch1.length==3){ if(valueSearch1[0].length==4){ //alert("length -> "+valueSearch1[0].length); 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); //alert(a+"--"+b); __date_start.value=a; __date_end.value=b; __fixCon.value="employeeid= '"+__employeeid.value+"'"; //__childFilter.value="tadjtime0:dt_bg between '"+a+"' and '"+b+"'"; submit(); document.cscform.submit(); } } function pageDesc(c){ with(document.cscform){ var a=chkDateTime1(date_start.value); var b=chkDateTime1(date_end.value); //alert(a+"--"+b); action="TAU144.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+"'"; //__childFilter.value="ttime_current1:m_dt_bg between '"+a+"' and '"+b+"' and eventgrp='"+c+"'"; //alert(__fixCon.value); submit(); } } function gotoDetail(page){ with(document.cscform){ var a=chkDateTime1(date_start.value); var b=chkDateTime1(date_end.value); __cmd.value = ""; __date_start.value = a; __date_end.value = b; __fixCon.value = " employeeid='<%=request.getParameter("__employeeid")%>' and lv_type = 'LT' and dateid >= '"+a+"' and dateid <= '"+b+"'"; action = "TARS001.jsp"; submit(); } } function chkEmpid(){ window.document.forms[0].__employeeid.value=window.parent.document.forms[0].__employeeid.value; //set__help(); } function checkCF() {checkConfirm();} function goHelp(helpName,inputName){ with(document.cscform){ var helpReturn=""; var fcon=__fixCon.value; if(inputName=="__employeeid" ){ helpReturn="__employeeid:employeeid,MEMPLOYEE@FULLNAME"; //fcon="employeeid in ("+__subordinate.value+")"; } if(fcon=="") linkHelp_Return(helpName,helpReturn); else helpPageCon(helpName,helpReturn,fcon); } } function linkHelp(help,input){ var fixcon=""; with(document.cscform){ fixcon=" ((employeeid in ("+__emp1.value+") ) or (employee in ("+__emp2.value+"))) " var param="PRU084.jsp?__helpName="+help+"&__fieldSearch="+input+"&__pageCall="+__screen.value+"&__fixCon="+fixcon; window.open(param,"Help","left=150,top=150,width=600,height=400,resizable=yes,scrollbars=yes,toolbar=no,status=yes"); } } </script> <!--meta http-equiv="refresh" content="1" url=PRU002.html--> <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" ></br> <% CscCalendar cs=new CscCalendar(); %> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" > <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <script language="javascript">//chkEmpid();</script> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__screen" value="TAU143"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__helpReturn" value=""> <input type="hidden" name="__helpName" value=""> <input type="hidden" name="__pageCall" > <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__calendar"> <script language="javascript">getInputFormatDate();</script> <!--input type="hidden" name="__subordinate" value="<%//=screen.getUProfile().get("subordinateid")%>" --> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__fixCon" > <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__childFilter" > <% 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) {} //out.println(sDate+" "+eDate+"<br>"); %> <!--input type="hidden" name="__date_start" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>"> <input type="hidden" name="__date_end" value="<%=cs.getDDMMYYYY()%>"--> <input type="hidden" name="__date_start" value="<%=sDate%>"> <input type="hidden" name="__date_end" value="<%=eDate%>"> <input type="hidden" name="__dateFilter" value=""> <input type="hidden" name="__empID" value="<%=screen.getString("employeeid")%>"> <input type="hidden" name="__empName" value="<%=screen.getString("fullname")%>"> <div align="center"> <table class="medium"> <tr> <td class="header" colspan="2" >TAU143, <script language="javascript">swapLang('History of Leave for Employee');</script> </td> </tr> <tr> <td colspan="2"> <div align="center"> <center> <table cellspacing="0" cellpadding="0" style="width:90%"> <tr> <td colspan="2" class="blankspace"></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("Employee Code");</script> </td> <td> <input type="text" name="__employeeid" size="15" value="<%=screen.getString("employeeid")%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid','')" 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" width="20" height="20" border="0" align="absmiddle"></a> </td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang('Name Surname');</script> </td> <td><input type="text" name="MEMPLOYEE@FULLNAME" value="<%=screen.getString("FULLNAME")%>" disabled size="34"></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang('Date Period');</script> </td> <td class="columnobject1"> <input name="date_start" type="text" value="<%=request.getParameter("__date_start")%>" size="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()"> <script language="javascript">chkDateStart(document.cscform.date_start.value,"date_start");</script> <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> - <input name="date_end" type="text" value="<%=request.getParameter("__date_end")%>" size="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()"> <script language="javascript">chkDateStart(document.cscform.date_end.value,"date_end");</script> <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 class="blankspace" colspan="2"></td> </tr> <tr > <td colspan="2"> <table style="width:100%"> <tr> <td rowspan="2" height="35" width="300" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang('Leave Type');</script></b></div></td> <td width="100" height="17" class="row3"><div align="CENTER"><b><script language="javascript">swapLang("Limit_Last_Year");</script></b></div></td> <td width="100" height="17" class="row3"><div align="CENTER"><b><script language="javascript">swapLang("Limit");</script></b></div></td> <td width="100" height="17" class="row3"><div align="CENTER"><b><script language="javascript">swapLang("Used");</script></b></div></td> <td width="100" height="17" class="row3"><div align="CENTER"><b><script language="javascript">swapLang("Remain");</script></b></div></td> </tr> <tr bordercolor="#3399FF"> <td width="100" height="10" class="row3"><div align="CENTER">[<script language="javascript">swapLang("DD HH SS");</script>]<!--script language="javascript">swapLang("DD HH SS");</script--></div></td> <td width="100" height="10" class="row3"><div align="CENTER">[<script language="javascript">swapLang("DD HH SS");</script>]<!--script language="javascript">swapLang("DD HH SS");</script--></div></td> <td width="100" height="10" class="row3"><div align="CENTER">[<script language="javascript">swapLang("DD HH SS");</script>]<!--script language="javascript">swapLang("DD HH SS");</script--></div></td> <td width="100" height="10" class="row3"><div align="CENTER">[<script language="javascript">swapLang("DD HH SS");</script>]<!--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"; DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee"); inqEmp.setSchemaName(screen.getUProfile().getSchemaName()); inqEmp.setFilter("employeeid='"+screen.getString("employeeid")+"'"); //inqEmp.setColumn("employeeid, companyid, emp_level, vacation0, vacation1, vacation0_get"); inqEmp.setColumn("employeeid, companyid, emp_level, vacation0, vacation1"); inqEmp.refresh(); if (inqEmp.next()){ vacation0 = inqEmp.getString("vacation0"); vacation1 = inqEmp.getString("vacation1"); //vacation0_get = inqEmp.getString("vacation0_get"); } String cFont = "";String c_limit = "";String c_used = "";String c_remain=""; FormulaString fs = new FormulaString(); 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 display=1 and branchid = (select BRANCH from MEMPLOYEE where EMPLOYEEID = '" + empid + "')"); //inq.setFilter("daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9' and eventgrpid !='LT'"); 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"); if (screen.inq.getString(a+"_remain").indexOf('-')>-1) { cFont = "error"; } else cFont = ""; %> <% c_limit = screen.inq.getString(a+"_limit"); c_used = screen.inq.getString(a+"_used"); c_remain = screen.inq.getString(a+"_remain"); String leaveadvance = chkNull.chkNullString(screen.inq.getString(a+"_leaveadvance")); String list[] = {vacation0,vacation1,c_used,c_remain}; if (type.equals("7")) { if (vacation0.equals("")) { vacation0 = "00:00:00"; } if (vacation1.equals("")) { vacation1= "00:00:00"; } list[0] = vacation0; list[1] = vacation1; } else { list[0] = ""; list[1] = c_limit; } %> <tr> <td height="19"> <div align="left"> <a href="javascript:pageDesc('<%=b%>')"><%=screen.inq.getString(a+"_desc")%></a> <%if(leaveadvance.length() > 0){%> <font style="color: #FF0000;font-size=12px;">(<script language="javascript">swapLang("Leave Advance");</script> <%=leaveadvance%>)</font> <%}%> </div> </td> <td height="19"> <div align="center"><font class='<%=cFont%>'><%=list[0]%></font></div></td> <td height="19"> <div align="center"><font class='<%=cFont%>'><%=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%>'><%=list[3]%></font></div></td> </tr> <% } if ( screen.inq.getString("simmemployee_tadjtime0$lt_times").equals("0") ) { cFont = ""; }else{ cFont = "error"; } %> <tr > <td height="19"> <div align="left"> <a href="javascript:gotoDetail('late');"><script language="javascript">swapLang("late");</script></a> </div> </td> <td height="19"> <div align="center"><font class='<%=cFont%>'>รวม <%=(screen.inq.getString("simmemployee_tadjtime0$lt_times")).length()>0?screen.inq.getString("simmemployee_tadjtime0$lt_times"):"0"%> ครั้ง</font></div></td> <td height="19"> <div align="center"><font class='<%=cFont%>'>00:00:00</font></div></td> <td height="19"> <div align="center"><font class='<%=cFont%>'><%=screen.inq.getString("simmemployee_tadjtime0$lt_hour_fs")%></font></div></td> <td height="19"> <div align="center"><font class='<%=cFont%>'><%=screen.inq.getString("simmemployee_tadjtime0$lt_times").equals("0")?"":"-"%><%=screen.inq.getString("simmemployee_tadjtime0$lt_hour_fs")%></font></div></td> </tr> </table> </td> </tr> </table> </center> </div> </td> </tr> <tr> <td class="bottom" > </td> </tr> </table> </div> </form> </body> </html>