<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@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.session.*,com.csc.library.components.*,com.csc.library.report.*,java.util.*,java.text.DecimalFormat,com.csc.library.database.DataSet;"%> <jsp:useBean id="VACACCRUE001" scope="page" class="com.csc.library.system.Task" /> <jsp:useBean id="SAVEDATA" class="com.csc.library.databean.Vacaccrue_save" scope="page" /> <html ng-app="myHR"> <% CheckNull chk = new CheckNull(); CscCalendar cs = new CscCalendar(); VACACCRUE001.setChannel(request ,response); HelpEntry screen = (HelpEntry) VACACCRUE001.process("HelpEntry", "VACACCRUE001"); SAVEDATA.setUProfile(screen.getUProfile()); // --------------- SetData ---------------- // int year = cs.getYear(); String calYos = cs.getYYYYMMDD(); String getLeaveType = chk.chkNullString(request.getParameter("__getLeavetype"),""); String leavetype = chk.chkNullString(request.getParameter("__leavetype"),""); String cmd = chk.chkNullString(VACACCRUE001.getParameter("__cmd"),""); String bu1 = chk.chkNullString(VACACCRUE001.getParameter("__bu1")); String bu2 = chk.chkNullString(VACACCRUE001.getParameter("__bu2")); String bu3 = chk.chkNullString(VACACCRUE001.getParameter("__bu3")); String bu4 = chk.chkNullString(VACACCRUE001.getParameter("__bu4")); String bu5 = chk.chkNullString(VACACCRUE001.getParameter("__bu5")); String emp1 = chk.chkNullString(VACACCRUE001.getParameter("__emp1")); String emp2 = chk.chkNullString(VACACCRUE001.getParameter("__emp2")); String period1 = chk.chkNullString(VACACCRUE001.getParameter("__period1")); String period2 = chk.chkNullString(VACACCRUE001.getParameter("__period2")); String periodgrp = chk.chkNullString(VACACCRUE001.getParameter("__period_group")); String years = chk.chkNullString(VACACCRUE001.getParameter("__year")); String getFixcon = chk.chkNullString(VACACCRUE001.getParameter("__fixCon"),""); String orderBy = chk.chkNullString(VACACCRUE001.getParameter("__OrderBy_option")); String language = screen.getUProfile().get("lang"); DbInquiry inqVac = new InitialInquiry(screen.getUProfile()).getDbInquiry("TVACATION_ACCRUAL"); int i =0; int setRow =30; int receivePage = chk.chkNullStringToInt(VACACCRUE001.getParameter("__page")); if(receivePage == 0){ receivePage = 1; } int StartRec = (setRow * receivePage) - (setRow); int endRec = 1; int row_total =0; //screen.process(); // --------------- BEAN ---------------- // if (cmd.equalsIgnoreCase("save")) { System.out.println("*********************** save condition ***********************"); cmd = "savecomplete"; } if(cmd.equalsIgnoreCase("search")) { DbInquiry inqMemployee = new InitialInquiry(screen.getUProfile()).getDbInquiry("memployee"); inqMemployee.setColumn("employeeid,emp_prefix,fname,lname,efname,elname"); inqVac.setColumn("employeeid,yos,last_year,this_year,as_of_period,this_period,total,taken,balance,planning,available,as_at_date,year"); inqVac.setFilter(getFixcon); inqVac.putChild(inqMemployee); i = StartRec; } ListBox listSearchBy = new ListBox(); listSearchBy.setUProfile(screen.getUProfile()); listSearchBy.setName("SearchBy_option"); listSearchBy.setValidCode("SEARCH_BY"); listSearchBy.setDisable("false"); listSearchBy.setChecked(chk.chkNullString(VACACCRUE001.getParameter("__SearchBy_option"),"EMPLOYEEID")); ListBox listOrderBy = new ListBox(); listOrderBy.setUProfile(screen.getUProfile()); listOrderBy.setName("OrderBy_option"); listOrderBy.setValidCode("ORDER_BY_VAC"); listOrderBy.setDisable("false"); listOrderBy.setChecked(chk.chkNullString(VACACCRUE001.getParameter("__OrderBy_option"),"EMPLOYEEID")); ListBox listCondition = new ListBox(); listCondition.setUProfile(screen.getUProfile()); listCondition.setName("Condition_option"); listCondition.setValidCode("ARITHMETICSEARCH"); listCondition.setDisable("false"); listCondition.setChecked(chk.chkNullString(VACACCRUE001.getParameter("Condition_option"),"Less")); ListBox listLeaveType = new ListBox(); listLeaveType.setUProfile(screen.getUProfile()); listLeaveType.setName("Leave_option"); listLeaveType.setValidCode("LEAVE_TYPE"); listLeaveType.setDisable("false"); listLeaveType.setChecked(chk.chkNullString(VACACCRUE001.getParameter("Leave_option"),"Working day")); ListBox listPeriodType = new ListBox(); listPeriodType.setUProfile(screen.getUProfile()); listPeriodType.setName("Period_option"); listPeriodType.setValidCode("PERIOD_TYPE"); listPeriodType.setDisable("false"); listPeriodType.setChecked(chk.chkNullString(VACACCRUE001.getParameter("Period_option"),"January")); DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("VACATION_PROFILE"); inq.setColumn("VAC_CODE,VACID,TDESC,EDESC"); inq.refresh(); row_total = inqVac.recCount(); //screen.process(); %> <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"> <script src="../JS/jquery-1.7.2.js"></script> <script src="../JS/SCREEN.js"></script> <script src="../JS/angular-1.3.15/angular.js"></script> <script type='text/JavaScript' SRC='../JS/ANGULAR/SWAPLANG.js'></script> <script type="text/javascript" src="/hr/dwr/interface/CscCalendar.js"></script> <script type='text/javascript' src='../JS/ICONSMENU.js'></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script> <script src="../JS/VIEWCALENDAR.js"></script> <script src='../JS/ICONSMENU.js'></script> <script src='../JS/HOTKEY.js'></script> <script src="../JS/DATEINPUT.js"></script> <script src="../JS/CscBase.js"></script> <script src="../JS/CscCalendar.js"></script> <script>getTitleName();</script> <script TYPE='text/JavaScript' SRC='../JS/CscCalendarV3.js'></script> <script type="text/JavaScript"> //--> //var sw = new swaplang2(); function goHelp(helpName,inputName){ with(document.cscform){ var helpReturn; var fixcon; var lang = '<%=screen.getUProfile().get("lang")%>'; if(inputName.indexOf("__emp") > -1){ helpReturn = inputName+":employeeid" fixcon = "employeeid in(select employeeid from tvacation_accrual)"; linkHelp_Return(helpName,helpReturn,fixcon); }else if(inputName=="__period_group"){ helpReturn = inputName+":groupid" linkHelp_Return(helpName,helpReturn,fixcon); }else if(inputName=="__period1"){ helpReturn = inputName+":period" var getPeriodGroup = __period_group.value; if(getPeriodGroup != ""){ fixcon = "groupid ='"+getPeriodGroup+"'"; linkHelp_Return(helpName,helpReturn,fixcon); }else{ if(lang == 'eng'){ alert("Please Choose Period Group First."); }else{ alert("กรุณาเลือกกลุ่มช่วงเวลาก่อน"); } } }else if(inputName=="__period2"){ helpReturn = inputName+":period" var getPeriodGroup = __period_group.value; if(getPeriodGroup != ""){ fixcon = "groupid ='"+getPeriodGroup+"'"; linkHelp_Return(helpName,helpReturn,fixcon); }else{ if(lang == 'eng'){ alert("Please Choose Period Group First."); }else{ alert("กรุณาเลือกกลุ่มช่วงเวลาก่อน"); } } } } } function goHelpBu(helpName,inputName){ var helpReturn; var fixcon; if(inputName=="__job" ) helpReturn="__bu1:bu1,__bu2:bu2,__bu3:bu3,__bu4:bu4,__bu5:bu5,__bu1_desc,__bu2_desc,__bu3_desc,__bu4_desc,__bu5_desc"; else if(inputName=="__bu1" ) helpReturn="__bu1:bu1id,__bu1_desc:tdesc"; //fixcon = "bu1 in(select bu1 from vacaccrue)"; else if(inputName=="__bu2" ) helpReturn="__bu2:bu2id,__bu2_desc:tdesc"; // fixcon = "bu2 in(select bu2 from vacaccrue)"; else if(inputName=="__bu3" ) helpReturn="__bu3:bu3id,__bu3_desc:tdesc"; //fixcon = "bu3 in(select bu3 from vacaccrue)"; else if(inputName=="__bu4" ) helpReturn="__bu4:bu4id,__bu4_desc:tdesc"; //fixcon = "bu4 in(select bu4 from vacaccrue)"; else if(inputName=="__bu5" ) helpReturn="__bu5:bu5id,__bu5_desc:tdesc"; //fixcon = "bu5 in(select bu5 from vacaccrue)"; linkHelp_Return(helpName,helpReturn); } function GoSearch(){ with(document.cscform){ var filterheal=""; //var month = __Period_option.value; filterheal=checkCondition2(filterheal,__emp1,__emp2,"employeeid"); filterheal=checkCondition(filterheal,__bu1,"bu1"); filterheal=checkCondition(filterheal,__bu2,"bu2"); filterheal=checkCondition(filterheal,__bu3,"bu3"); filterheal=checkCondition(filterheal,__bu4,"bu4"); filterheal=checkCondition(filterheal,__bu5,"bu5"); filterheal=checkCondition(filterheal,__period_group,"periodgroup"); filterheal=checkCondition(filterheal,__leavetype,"EVENTGRP"); filterheal=checkCondition(filterheal,__year,"year"); var start_period = __period1.value; var end_period = __period2.value; if(start_period == "" && end_period == ""){ //Do nothing }else if (start_period == "" && end_period != ""){ __period1.value = end_period; filterheal=checkCondition(filterheal,__period1,"start_period"); filterheal=checkCondition(filterheal,__period2,"end_period"); }else if (start_period != "" && end_period == ""){ __period2.value = start_period; filterheal=checkCondition(filterheal,__period1,"start_period"); filterheal=checkCondition(filterheal,__period2,"end_period"); }else{ filterheal=checkCondition(filterheal,__period1,"start_period"); filterheal=checkCondition(filterheal,__period2,"end_period"); } __fixCon.value=filterheal; console.log(" filterheal >>>>>>>>"+filterheal); //__getLeavetype.value = $('select[name=__leavetype]').find(":selected").text(); search(); } } function checkCondition(filcon,objname,targetname){ with(document.cscform){ if(objname.value.length>0){ filcon=checkFilter(filcon); filcon += targetname+"='"+objname.value+"'"; }else{ return filcon; } return filcon; } } function checkConditionNull(filcon,targetname){ with(document.cscform){ filcon=checkFilter(filcon); filcon += targetname+"!=''"; return filcon; } } function checkCondition2(filcon,objname1,objname2,targetname){ with(document.cscform){ if(objname1.value.length>0 && targetname === "employeeid"){ if(objname2.value.length>0){ filcon=checkFilter(filcon); filcon+= targetname+" between '"+objname1.value+"' and '"+objname2.value+"'"; }else{ filcon=checkFilter(filcon); filcon+= targetname+" between '"+objname1.value+"' and '"+objname1.value+"'"; } }else if(objname2.value.length>0 && targetname === "employeeid"){ filcon=checkFilter(filcon); filcon+= targetname+" between '"+objname2.value+"' and '"+objname2.value+"'"; }else{ return filcon; } return filcon; } } function checkFilter(fil){ if(fil.length>0) fil+=" and "; return fil; } function chkval(data){ with(document.cscform){ GoSearch(); } } $(document).ready(function(){ }); </script> </head> <!-- <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="setdefaultDate();"> --> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <form name="cscform" method="post" action ="VACACCRUE001.jsp" ng-controller="Swaplang as sw" > <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <input type="hidden" name="__cmd" value="<%=VACACCRUE001.getParameter("__cmd")%>"> <input type="hidden" name="__screen" value="VACACCRUE001"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__calendar" value=""> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__filterMemployee" value="companyid='<%=screen.getUProfile().get("companyid")%>'"> <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__temp" value=""> <input type="hidden" name="__curDate" value="<%=new CscCalendar().getDate()%>"> <input type="hidden" name="__confirm" value="s"> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__employeeid" value="<%=screen.getUProfile().get("employeeid")%>"> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <!-- <input type="hidden" name="__getLeavetype" value="<%=getLeaveType%>"> --> <input type="hidden" name="__monthforseach" value=""> <!----------END CSC INITIAL ZONE --------------------------> <div align="center"> <table height="" align="center" cellpadding="0" cellspacing="0" border="1" class="largest"> <tr bgcolor="#3366CC"> <td height="20" class="header" colspan="4">Vacation Accrual,<swaplang code='SW011656'></swaplang> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <td align="right"><strong><swaplang code='SW000350'></swaplang> </strong></td> <td colspan="3"><input type="text" name="__emp1" size="15" value="<%=emp1%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__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="__emp2" size="15" value="<%=emp2%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__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></span> </td> </tr> <tr> <td align="right"><swaplang code='SW000309'></swaplang> </td> <td colspan="3"><input type="text" name="__bu1" size="15" value="<%=bu1%>"> <a href="javascript:goHelpBu('MBU1HELP','__bu1')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu1" border="0" align="absmiddle"></a> <input name="__bu1_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu1_desc"))%>" size="50" readonly=""> </td> </tr> <tr> <td align="right"><swaplang code='SW000310'></swaplang> </td> <td colspan="3"><input type="text" name="__bu2" size="15" value="<%=bu2%>"> <a href="javascript:goHelpBu('MBU2HELP','__bu2')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu2" border="0" align="absmiddle"></a> <input name="__bu2_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu2_desc"))%>" size="50" readonly=""> </td> </tr> <tr> <td align="right"><swaplang code='SW000311'></swaplang> </td> <td colspan="3"><input type="text" name="__bu3" size="15" value="<%=bu3%>"> <a href="javascript:goHelpBu('MBU3HELP','__bu3')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu3" border="0" align="absmiddle"></a> <input name="__bu3_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu3_desc"))%>" size="50" readonly=""> </td> </tr> <tr> <td align="right"><swaplang code='SW000312'></swaplang> </td> <td colspan="3"><input type="text" name="__bu4" size="15" value="<%=bu4%>"> <a href="javascript:goHelpBu('MBU4HELP','__bu4')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu4','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu4" border="0" align="absmiddle"></a> <input name="__bu4_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu4_desc"))%>" size="50" readonly=""> </td> </tr> <tr> <td align="right"><swaplang code='SW000313'></swaplang> </td> <td colspan="3"><input type="text" name="__bu5" size="15" value="<%=bu5%>"> <a href="javascript:goHelpBu('MBU5HELP','__bu5')" 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> <input name="__bu5_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu5_desc"))%>" size="50" readonly=""> </td> </tr> <tr> <td align="right"><swaplang code='SW011708'></swaplang> </td><!-- SW011708 - กลุ่มระยะเวลา (Period Group)--> <td align="left"><span class="columnobject1"> <input type="text" name="__period_group" size="5" value="<%=periodgrp%>"> <a href="javascript:goHelp('MVACATION_PERIOD_GROUPHELP','__period_group')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgPeriodGroup','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgPeriodGroup" border="0" align="absmiddle"></a> </span> <swaplang code='SW011709'></swaplang> <input type="text" name="__period1" size="2" value="<%=period1%>"> <a href="javascript:goHelp('MVACATION_PERIODHELP','__period1')" 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> <swaplang code='SW011710'></swaplang> <input type="text" name="__period2" size="2" value="<%=period2%>"> <a href="javascript:goHelp('MVACATION_PERIODHELP','__period2')" 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> Year <select name="__year"> <option value=""></option> <% String sql1 = "select distinct(year) from tvacation_accrual order by year;"; DataSet ds1 = new DataSet(sql1, screen.getUProfile().get("dbname"), "tvacation_accrual"); ds1.initConnection(screen.getUProfile()); while (ds1.next()) { %><option value="<%=ds1.getString("year")%>" <%=(years.equals(ds1.getString("year")))?"selected":""%>><%=ds1.getString("year")%></option> <%} ds1.closeConnection(); %> <!-- <input type="text" name="__year" size="5" value="<%=years%>"> --> </select> </span> </td> </tr> <tr> <td><div align="right"><swaplang code='SW000004'></swaplang> </div></td> <td><%=listOrderBy.process()%></td> <td><!--div align="right"><script language="javascript">swapLang('Search By');</script> </div--></td> <td><%//=listSearchBy.process()%></td> </tr> <tr> <td><div align="right"><swaplang code='SW000300'></swaplang> </div></td> <!--td><%=listCondition.process()%></td--> <td><select name="__leavetype"> <option value=""></option> <% while(inq.next()) {%> <option value="<%=inq.getString("VACID")%>" <% if(leavetype.equals(inq.getString("VACID"))){%>selected<%}%>> <%=(language.equals("eng"))?inq.getString("EDESC"):inq.getString("TDESC")%></option> <%}%> </select></td> <td> <td></td> </tr> <tr class="medium"> <td colspan="4"><div align="center"><a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" alt="Submit" border="0" align="absmiddle"></a></div></td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <tr> <%if(cmd.equalsIgnoreCase("search")){%> <td colspan="4" align="left"> <select style="float:right;" id="__page" name='__page' onChange="chkval(this)"> <% int pagecount=row_total/setRow; int pagemod=row_total%setRow; int __start = 0; int __end = 0; if(pagemod>0){ pagecount++; } if(pagecount>0){ for(int j=1;j<=pagecount;j++){ __end = j*setRow; __start =__end-setRow+1; if(receivePage == j){ out.print("<option name="+j+" value="+j+" start="+__start+" end="+__end+" selected>"+j+" </option>"); } else { out.print("<option name="+j+" value="+j+" start="+__start+" end="+__end+">"+j+"</option>"); } } }else{ out.print("<option name='1' value='1' start='1' end="+setRow+">1</option>"); } %> </select> </td> </tr> <tr> <td colspan="4"> <table class="largest" border="1" align="center" cellpadding="1" cellspacing="1" bgcolor="#666666"> <tr> <td align="center" width="2%" class="title1"><swaplang code='SW001393'></swaplang></td> <td align="center" width="3%" class="title1"><swaplang code='SW000602'></swaplang></td> <td align="center" width="5%" class="title1"><swaplang code='SW006940'></swaplang></td> <td align="center" width="3%" class="title1"><swaplang code='SW011643'></swaplang></td> <td align="center" width="3%" class="title1"><swaplang code='SW011644'></swaplang></td> <td align="center" width="3%" class="title1"><swaplang code='SW011645'></swaplang></td> <td align="center" width="3%" class="title1"><swaplang code='SW011711'></swaplang></td> <td align="center" width="3%" class="title1"><swaplang code='SW011712'></swaplang></td> <td align="center" width="3%" class="title1"><swaplang code='SW009694'></swaplang></td> <td align="center" width="4%" class="title1"><swaplang code='SW011649'></swaplang></td> <td align="center" width="4%" class="title1"><swaplang code='SW011651'></swaplang></td> <td align="center" width="4%" class="title1"><swaplang code='SW011653'></swaplang></td> <td align="center" width="4%" class="title1"><swaplang code='SW011654'></swaplang></td> <td align="center" width="4%" class="title1"><swaplang code='SW011655'></swaplang></td> </tr> <!-- >ปิด หัวตารางๆ <!--> <% int page_total_row = 0; inqVac.setOrderBy(orderBy); inqVac.refresh(); inqVac.go(StartRec); while(inqVac.next()){ i++; if(i<=setRow + StartRec){ page_total_row++; // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> SET DATA INQ <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< // //String month_amounth = SAVEDATA.Calsalary(inqVac.getString("employeeid"),thisMonth); //String taken_amounth = SAVEDATA.Calsalary(inqVac.getString("employeeid"),taken); //String balance_amounth = SAVEDATA.Calsalary(inqVac.getString("employeeid"),balance);*/ %> <tr> <% CscCalendar c = new CscCalendar(inqVac.getString("AS_AT_DATE")); String as_at_date = c.getDDMMYYYY(); %> <td align="center" width="2%" ><%=i%></td> <td align="center" width="3%" > <%=inqVac.getString("employeeid")%> </td> <td align="left" width="5%"> <%=inqVac.getString("memployee","fullname")%> </td> <td align="center" width="3%"> <%=inqVac.getString("YOS")%> </td> <td align="center" width="3%"> <%=inqVac.getString("LAST_YEAR")%> </td> <td align="center" width="3%"> <%=inqVac.getString("THIS_YEAR")%> </td> <td align="center" width="3%"> <%=inqVac.getString("AS_OF_PERIOD")%> </td> <td align="center" width="3%"> <%=inqVac.getString("THIS_PERIOD")%> </td> <td align="center" width="3%"> <%=inqVac.getString("total")%> </td> <td align="center" width="4%"> <%=inqVac.getString("TAKEN")%> </td> <td align="center" width="4%"> <%=inqVac.getString("BALANCE")%> </div></td> <td align="center" width="4%"> <%=inqVac.getString("PLANNING")%> </td> <td align="center" width="4%"> <%=inqVac.getString("AVAILABLE")%> </td> <td align="center" width="4%"> <%=as_at_date%> </td> </tr> <% }//End if(i<=setRow + StartRec) else{ break; } }//End inqVac.next() }//End if(cmd = search)%> </table> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> </table> </div> </form> </body> </html>