<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@ page contentType="text/html; charset=UTF-8"%> <%@ page import="com.csc.library.entry.*" %> <%@ page import="com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.components.*" %> <jsp:useBean id="ASR002" scope="page" class="com.csc.library.system.Task"/> <% ASR002.setChannel(request ,response); ReportEntry screen=null; screen=(ReportEntry)ASR002.process("ReportEntry",request.getParameter("__screen")); UProfile uf=screen.getUProfile(); com.csc.library.report.ReportUDF systemCode = new com.csc.library.report.ReportUDF(); CscCalendar cur = new CscCalendar(); CheckNull chk = new CheckNull(); ListBox listLeaveType = new ListBox(); listLeaveType.setUProfile(screen.getUProfile()); listLeaveType.setName("Leave_option"); listLeaveType.setValidCode("LEAVE_TYPE"); listLeaveType.setDisable("false"); listLeaveType.setChecked(chk.chkNullString(ASR002.getParameter("Leave_option"),"Working day")); DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("VACATION_PROFILE"); inq.setColumn("VAC_CODE,VACID,TDESC,EDESC"); inq.refresh(); %> <html ng-app="myHR"> <head> <title>ReportOption</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script> <script type='text/javascript' src="../JS/bootstrap.js"></script> <script src="../JS/SCREEN.js"></script> <script src="../JS/jquery-1.7.2.js"></script> <script src="../JS/angular-1.3.15/angular.js"></script> <script type='text/JavaScript' SRC='../JS/ANGULAR/SCREEN_ANGULAR.js'></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script> <script src="../JS/VIEWCALENDAR.js"></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 back(){ var filter = "1=1 "; with(document.cscform){ if(__condition$emp1.value!=""&&__condition$emp2.value!=""){ filter += " and employeeid between '"+__condition$emp1.value+"' and '"+__condition$emp2.value+"' "; }else if(__condition$emp1.value!=""&&__condition$emp2.value==""){ filter += " and employeeid = '"+__condition$emp1.value+"' "; }else if(__condition$emp1.value==""&&__condition$emp2.value!=""){ filter += " and employeeid = '"+__condition$emp2.value+"' "; } if(__condition$periodgroup.value!=""){ filter += " and periodgroup = '"+__condition$periodgroup.value+"' "; } if(__condition$start_period.value!=""&&__condition$end_period.value!=""){ filter += " and start_period = '"+__condition$start_period.value+"' and end_period = '"+__condition$end_period.value+"' "; }else if(__condition$start_period.value!=""&&__condition$end_period.value==""){ filter += " and start_period = '"+__condition$start_period.value+"' and end_period = '"+__condition$start_period.value+"' "; }else if(__condition$start_period.value==""&&__condition$end_period.value!=""){ filter += " and start_period = '"+__condition$end_period.value+"' and end_period = '"+__condition$end_period.value+"' "; } if(__condition$year_process.value!=""){ filter += " and year = '"+__condition$year_process.value+"' "; } if(__condition$eventgrp.value!=""){ filter += " and eventgrp = '"+__condition$eventgrp.value+"' "; } if(__condition$year_process.value!=""&&__condition$start_period.value!=""&&__condition$end_period.value!=""){ filter += setFilterEmp(); }else if(__condition$year_process.value!=""&&__condition$start_period.value!=""&&__condition$end_period.value==""){ filter += setFilterEmp_start(); }else if(__condition$year_process.value!=""&&__condition$start_period.value==""&&__condition$end_period.value!=""){ filter += setFilterEmp_end(); } var group_by = __groupby_vac.value; } with(window.opener.document.cscform){ //alert(filter); __fixfilterTvacation_accrual.value = filter; __GROUPBY_VAC.value = group_by; } window.close(); } function setFilterEmp(){ with(document.cscform){ var filter =""; var yyyy = __condition$year_process.value; var start_mm = __condition$start_period_month.value; var start_dd = __condition$start_period_date.value; if(start_dd.length==1){ start_dd = "0"+start_dd; } var start_yyyymmdd = yyyy+"-"+start_mm+"-"+start_dd; var end_mm = __condition$end_period_month.value; var end_dd = ""; if(end_mm=="01"||end_mm=="03"||end_mm=="05"||end_mm=="07"||end_mm=="08"||end_mm=="10"||end_mm=="12"){ end_dd = "31"; }else if(end_mm=="02"){ if(yyyy%4==0){ end_dd = "29"; }else{ end_dd = "28"; } }else{ end_dd = "30"; } var end_yyyymmdd = yyyy+"-"+end_mm+"-"+end_dd; filter += " and employeeid in (select employeeid from memployee where status in ('A','V','Y') and startdate <='"+start_yyyymmdd+"' and resigndate >'"+end_yyyymmdd+"' ) "; } return filter; } function setFilterEmp_start(){ with(document.cscform){ var filter =""; var yyyy = __condition$year_process.value; var start_mm = __condition$start_period_month.value; var start_dd = __condition$start_period_date.value; if(start_dd.length==1){ start_dd = "0"+start_dd; } var start_yyyymmdd = yyyy+"-"+start_mm+"-"+start_dd; var end_mm = __condition$start_period_month.value; var end_dd = ""; if(end_mm=="01"||end_mm=="03"||end_mm=="05"||end_mm=="07"||end_mm=="08"||end_mm=="10"||end_mm=="12"){ end_dd = "31"; }else if(end_mm=="02"){ if(yyyy%4==0){ end_dd = "29"; }else{ end_dd = "28"; } }else{ end_dd = "30"; } var end_yyyymmdd = yyyy+"-"+end_mm+"-"+end_dd; filter += " and employeeid in (select employeeid from memployee where status in ('A','V','Y') and startdate <='"+start_yyyymmdd+"' and resigndate >'"+end_yyyymmdd+"' ) "; } return filter; } function setFilterEmp_end(){ with(document.cscform){ var filter =""; var yyyy = __condition$year_process.value; var start_mm = __condition$end_period_month.value; var start_dd = __condition$end_period_date.value; if(start_dd.length==1){ start_dd = "0"+start_dd; } var start_yyyymmdd = yyyy+"-"+start_mm+"-"+start_dd; var end_mm = __condition$end_period_month.value; var end_dd = ""; if(end_mm=="01"||end_mm=="03"||end_mm=="05"||end_mm=="07"||end_mm=="08"||end_mm=="10"||end_mm=="12"){ end_dd = "31"; }else if(end_mm=="02"){ if(yyyy%4==0){ end_dd = "29"; }else{ end_dd = "28"; } }else{ end_dd = "30"; } var end_yyyymmdd = yyyy+"-"+end_mm+"-"+end_dd; filter += " and employeeid in (select employeeid from memployee where status in ('A','V','Y') and startdate <='"+start_yyyymmdd+"' and resigndate >'"+end_yyyymmdd+"' ) "; } return filter; } function goHelp(helpName,inputName){ with(document.cscform){ var helpReturn; var fixcon = ''; if(inputName.indexOf("__condition$emp") > -1){ helpReturn = inputName+":employeeid" linkHelp_Return(helpName,helpReturn,fixcon); }else if(inputName=="__condition$periodgroup"){ helpReturn = inputName+":groupid" linkHelp_Return(helpName,helpReturn,fixcon); }else if(inputName=="__condition$start_period" || inputName=="__condition$end_period"){ if(__condition$periodgroup.value==''){ alert(MyCode[219]); }else{ fixcon = "groupid='"+__condition$periodgroup.value+"'"; helpReturn = inputName+":period,"+inputName+"_date:period_date,"+inputName+"_month:period_month"; linkHelp_Return(helpName,helpReturn,fixcon); } } } } function linkHelp_Return(help,input){ with(document.cscform){ var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__checkVerify=off"; window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } //--> </script> </head> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')"> <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="__language" value ="<%=screen.getUProfile().get("lang")%>"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__calendar"> <div align="center"> <br> <table cellpadding="0" cellspacing="0"> <tr > <td class="header"> <script language="javascript">swapLang('Report Option');</script> </td> </tr> <tr > <td colspan="2"> <div align="center"> <table cellpadding="0" cellspacing="0" > <tr> <td colspan="2" class="blankspace"></td> </tr> <tr> <td align="right" swlang code='SW000350'>Employee ID</td> <td> <input type="text" name="__condition$emp1" size="15" value="<%//=emp1%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__condition$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="__condition$emp2" size="15" value="<%//=emp2%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__condition$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> </td> </tr> <tr> <td align="right" swlang code='SW011708'>Period Group</td> <td> <input type="text" name="__condition$periodgroup" size="10" value="<%//=periodgroup%>"> <a href="javascript:goHelp('MVACATION_PERIOD_GROUPHELP','__condition$periodgroup','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5" border="0" align="absmiddle"></a> </td> </tr> <tr> <td align="right" swlang code='SW001331'>From</td> <td align="left" > <input type="text" name="__condition$start_period" size="2" value="<%//=start_period%>"> <a href="javascript:goHelp('MVACATION_PERIODHELP','__condition$start_period','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5" border="0" align="absmiddle"></a> <span swlang code="SW000002">Date</span><input type="text" name="__condition$start_period_date" size="1" value="<%//=start_period%>" readonly> <span swlang code="SW000800">Month</span><input type="text" name="__condition$start_period_month" size="1" value="<%//=start_period%>" readonly> </td> </tr> <tr> <td align="right" swlang code='SW005755'>To</td> <td align="left" > <input type="text" name="__condition$end_period" size="2" value="<%//=end_period%>"> <a href="javascript:goHelp('MVACATION_PERIODHELP','__condition$end_period','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5" border="0" align="absmiddle"></a> <span swlang code="SW000002">Date</span><input type="text" name="__condition$end_period_date" size="1" value="<%//=start_period%>" readonly> <span swlang code="SW000800">Month</span><input type="text" name="__condition$end_period_month" size="1" value="<%//=start_period%>" readonly> </td> </tr> <tr> <td align="right" swlang code='SW000717'>Year</td> <td align="left" > <input type="text" name="__condition$year_process" size="5" value="<%//=year_process%>"> </td> </tr> <tr> <td><div align="right" swlang code='SW000300'>Leave Type</div></td> <td> <select name="__condition$eventgrp"> <% while(inq.next()){ %> <option value="<%=inq.getString("VAC_CODE")%>" <%//=(eventgrp.equals(inq.getString("VAC_CODE")))?"selected":""%>> <%=(screen.getUProfile().get("lang").equalsIgnoreCase("THA"))?inq.getString("TDESC"):inq.getString("EDESC")%></option> <% } %> </select> </td> </tr> <tr> <% ListBox listbox1 = new ListBox(); listbox1.setUProfile(screen.getUProfile()); listbox1.setName("groupby_vac"); //ชื่อ ListBox listbox1.setValidCode("GROUP_BY_VAC"); //tag Systemcode ที่เรียกใช้ %> <td><div align="right" swlang code='SW000122'>Group By</div></td> <td ><%=listbox1.process()%></td> </tr> <tr> <td colspan="2" class="blankspace"></td> </tr> <tr> <td class="buttonline" colspan="7"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW013169" onClick="back();">OK</button> <button type="button" class="btn btn-primary width100" swlang code="SW006927" onClick="window.close();">CANCEL</button> </div> </td> </tr> <tr > <td colspan="2" class="blankspace"></td> </tr> </table> </div></td> </tr> <tr bordercolor="0069B3"> <td class="bottom"></td> </tr> </table> </div> <INPUT TYPE="hidden" NAME="__screen" VALUE="<%=request.getParameter("__screen")%>"> </form> </body> </html>