<%@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.report.*;"%> <jsp:useBean id="WEL112_CPN" class="com.csc.library.system.Task" scope="page" /> <% WEL112_CPN.setChannel(request, response); HelpEntry screen = (HelpEntry) WEL112_CPN.process("HelpEntry","WEL112_CPN"); screen.inq.setFilter("status='1' and approvestatus='1' and (batchid is not null and batchid!='')"); CheckNull chk=new CheckNull(); ReportUDF rf=new ReportUDF(); ThaiUtilities thail = new ThaiUtilities(); CscCalendar cs=new CscCalendar(); java.text.DecimalFormat df=new java.text.DecimalFormat("#,###,##0.00"); String condition=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__fixCon"))); String emp1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__employeeid1"))); String emp2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__employeeid2"))); String welid1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__welid1"))); String welid2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__welid2"))); String stdate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__approvedate1"))); String endate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__approvedate2"))); String com1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__complainid1"))); String com2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__complainid2"))); String refdoc1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__refdoc1"))); String refdoc2=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__refdoc2"))); String branch=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__branch"))); String batchid=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__batchid"))); String payments=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__payments"),"1")); String mystatus=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__mystatus"))); String mystatuslist=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__mystatuslist"))); if(mystatuslist.length()>0&&mystatus.length()>0){ try{ DbRecord complain=new InitialRecord(screen.getUProfile()).getDbRecord("mcomplain"); complain.setColumn("complainid,companyid,payable,caseid,batchid"); String[] mstatuslist=mystatuslist.split(","); String[] tm; for(int i=0;i<mstatuslist.length;i++){ tm=mstatuslist[i].split("\\|"); //out.println("<br>-----"+mstatuslist[i]); if(tm.length==2){ complain.set("complainid",tm[0]); complain.set("caseid",tm[1]); if(complain.search()==1){ if(mystatus.equals("2")){ complain.set("batchid",""); complain.set("payable","0"); }else{ complain.set("batchid",complain.getString("batchid")); complain.set("payable",mystatus); } //out.println("="+mystatus); complain.save(); } } } }catch(Exception ex){ out.print("ERROR"); } } screen.inq.clearSubFilter(); //screen.inq.setFilter("budyear",budyear,"","="); if(batchid.length()>0){ screen.inq.setFilter("batchid",batchid,"","between"); } if(branch.length()>0){ screen.inq.setFilter("branch",branch,"","between"); } if(refdoc1.length()>0){ screen.inq.setFilter("refdoc",refdoc1,refdoc2,"between"); } if(com1.length()>0){ screen.inq.setFilter("complainid",com1,com2,"between"); } if(emp1.length()>0){ screen.inq.setFilter("employeeid",emp1,emp2,"between"); } if(welid1.length()>0){ screen.inq.setFilter("welid",welid1,welid2,"between"); } if(payments.length()>0){ screen.inq.setFilter("payable",payments,"","="); } if(stdate.length()>0 || endate.length()>0){ String spstdate[] =stdate.split("-"); String spendate[] =endate.split("-"); if(spstdate.length==3){ if(spstdate[0].length()==4) stdate=spstdate[0]+"-"+spstdate[1]+"-"+spstdate[2]; else stdate=spstdate[2]+"-"+spstdate[1]+"-"+spstdate[1]; } if(spendate.length==3){ if(spendate[0].length()==4) stdate=spendate[0]+"-"+spendate[1]+"-"+spendate[2]; else{ endate=spendate[2]+"-"+spendate[1]+"-"+spendate[1]; } } } if(stdate.length()>0){ screen.inq.setFilter("approvedate",stdate,endate,"between"); } //screen.setMaxLine(3); screen.process(); %> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" > <link href="../CSS/MENU.css" rel="stylesheet" type="text/css"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <script language='javascript' src="../JS/VIEWCALENDAR.js"></script> <script language="JavaScript" src="../JS/SCREEN.js"></script> <script type='text/javascript' src="../JS/ICONSMENU.js"></script> <script language='javascript' src="../JS/HOTKEY.js"></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="JavaScript" type="text/JavaScript"> <!-- function GoSearch() { document.cscform.__goPage.value="1"; search(); } function GoSave() {} function GoDelete(){ } function GoUpdate(){} function goHelp(helpName,inputName){ var helpReturn; var fixcon=document.cscform.__fixCon.value; document.cscform.__fixCon.value=""; if(inputName=="__branch" ){ helpReturn="__branch:branchid"; }else if(inputName=="__batchid" ){ helpReturn="__batchid:batchid"; }else if(inputName=="__employeeid1" ){ helpReturn="__employeeid1:employeeid"; }else if(inputName=="__employeeid2" ){ helpReturn="__employeeid2:employeeid"; }else if(inputName=="__refdoc1" ){ helpReturn="__refdoc1:refdoc"; }else if(inputName=="__refdoc2" ){ helpReturn="__refdoc2:refdoc"; }else if(inputName=="__complainid1" ){ helpReturn="__complainid1:complainid"; }else if(inputName=="__complainid2" ){ helpReturn="__complainid2:complainid"; }else if(inputName=="__welid1" ){ helpReturn="__welid1:welid"; }else if(inputName=="__welid2" ){ helpReturn="__welid2:welid"; } linkHelp_Return(helpName,helpReturn); document.cscform.__fixCon.value=fixcon; } function GoClean() { clearText(); } //--> </script> <script type="text/javascript" src="../JS/jquery-1.3.2.min.js"></script> <script type="text/javascript" src="../JS/jquery/js/jquery-ui.js"></script> <script type="text/javascript" src="../JS/jquery.blockUI.js"></script> <link href="../JS/jquery/css/redmond/jquery-ui-1.7.1.custom.css" rel="stylesheet" type="text/css"> <script> function showDate(mypicker){ $(function() { $("#"+mypicker.id).datepicker({dateFormat: "dd-mm-yy",showAnim: "fadeIn",showOn: "focus",direction: 'up'}); }); } function clearText(){ $(":input[type=text]").each(function () { this.value = ""; }); } function saveStatus(objstatus){ with(document.cscform){ __mystatus.value=objstatus; var mystatuslist=""; $(":input[type=checkbox]").each(function () { if(this.checked){ mystatuslist+=this.value+','; } }); __mystatuslist.value=mystatuslist; submit(); } } function exportData(){ with(document.cscform){ action="WEL113_CPN.jsp"; submit(); } } </script> <style type="text/css"> <!-- .style1 {color: #FF0000} --> </style> </head> <body onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')"> <div class="centered"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action="WEL112_CPN.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__help" value=""> <input type="hidden" name="__goPage" value="<%=chk.chkNullString(request.getParameter("__goPage"),"1")%>"> <input type="hidden" name="__notNull" value="<%//=screen.getRequire()%>"> <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="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__lockPage" value=""> <input type="hidden" name="__calendar"> <input type="hidden" name="__screen" value="WEL112_CPN"> <input type="hidden" name="__webid"> <input type="hidden" name="__readposter"> <script language="javascript">getInputFormatDate();</script> <input name="__fixCon" type="hidden" value="<%=condition%>"> <input type="hidden" name="__employeeid" value=""> <input type="hidden" name="__docno" value=""> <input type="hidden" name="__formulaid" value=""> <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>"> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input name="__complainid" type="hidden" value=""> <input name="__mystatus" type="hidden" value=""> <input name="__mystatuslist" type="hidden" value=""> <script language="JavaScript" src="../JS/HOTKEY.js"></script> <script language="javascript"> var titlename=swap2String('Payment to AS400'); document.write(Icons("WEL112_CPN,"+titlename)); </script> <br> <table cellpadding="0" cellspacing="0" class="largest"> <tr > <td colspan="2" class="header" >WEL112_CPN, <script language="javascript">swapLang(titlename);</script> </td> </tr> <tr > <td > <table class="maxsize" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td > <table width="638" border="0" align="center" cellpadding="0" cellspacing="1" class="inframe"> <tr class="maxsize"> <td width="15%"> <div align="right"> <script language="javascript">swapLang('Order By');</script> </div></td> <td width="538"><%=screen.getTagOrder()%></td> </tr> <tr> <td class="columnlabel"><span> <script language="javascript">swapLang("Approve date");</script> </span></td> <td><input type="text" id="approvedate1" name="__approvedate1" size="10" maxlength="8" onClick="showDate(this);" onFocus="showDate(this);" onMouseDown="showDate(this);" onKeyup = "formatDate(this)" readonly value="<%=stdate%>"> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image121','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image121" width="20" border="0" align="absmiddle" id="Image12" onClick="viewCal('__approvedate1')"></a> - <input type="text" id="approvedate2" name="__approvedate2" size="10" maxlength="8" onClick="showDate(this);" onFocus="showDate(this);" onMouseDown="showDate(this);" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(__approvedate1,this)" readonly value="<%=endate%>"> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image122','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image122" width="20" border="0" align="absmiddle" id="Image122" onClick="viewCal('__approvedate2')"></a></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("Company");</script> </td> <td><input type="text" name="__branch" size="15" readonly value="<%=branch%>"> <a href="javascript:goHelp('MBRANCHHELP','__branch');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image316','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image316" width="20" border="0" align="absmiddle" id="Image316"></a></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("Batchid");</script> </td> <td><input type="text" name="__batchid" size="25" value="<%=batchid%>"> <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__batchid');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image317','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image317" width="20" border="0" align="absmiddle" id="Image317"></a></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("Employee Code");</script> </td> <td><input type="text" name="__employeeid1" size="15" readonly value="<%=emp1%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image311','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image311" width="20" border="0" align="absmiddle" id="Image311"></a> <input type="text" name="__employeeid2" size="15" readonly value="<%=emp2%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image31','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image31" width="20" border="0" align="absmiddle" id="Image31"></a></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("Doc No.");</script> </td> <td><input type="text" name="__refdoc1" value="<%=refdoc1%>" size="15" readonly > <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__refdoc1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image313','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image313" width="20" border="0" align="absmiddle" id="Image313"></a> <input type="text" name="__refdoc2" value="<%=refdoc2%>" size="15" readonly > <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__refdoc2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image312','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image312" width="20" border="0" align="absmiddle" id="Image312"></a></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("Complain Code");</script> </td> <td><input type="text" name="__complainid1" value="<%=com1%>" size="15" readonly > <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__complainid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image314','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image314" width="20" border="0" align="absmiddle" id="Image314"></a> <input type="text" name="__complainid2" value="<%=com2%>" size="15" readonly > <a href="javascript:goHelp('MCOMPLAINHELP_CPN','__complainid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image315','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image315" width="20" border="0" align="absmiddle" id="Image315"></a></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("Welfare Code");</script> </td> <td><input type="text" name="__welid1" value="<%=welid1%>" size="15" readonly > <a href="javascript:goHelp('MWELFAREHELP','__welid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image314','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image314" width="20" border="0" align="absmiddle" id="Image314"></a> <input type="text" name="__welid2" value="<%=welid2%>" size="15" readonly > <a href="javascript:goHelp('MWELFAREHELP','__welid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image315','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image315" width="20" border="0" align="absmiddle" id="Image315"></a></td> </tr> <tr> <td class="columnlabel"><script language="javascript">swapLang("Payment");</script> </td> <td> <select name="__payments"> <option value="">...</option> <% String curetype[]=rf.getSystemCode("PAYSTATUS",screen.getUProfile().get("lang")); String tmp[]; String tmpStr=""; for(int i=0;i<curetype.length-1;i++){ tmp=curetype[i].split(","); if(!tmp[0].equals("2")){ tmpStr+="<option value='"+tmp[0]+"'"; if(chk.chkNullString(request.getParameter("__payments")).equals(tmp[0])){ tmpStr+=" selected "; } tmpStr+=">"+tmp[1]+"</option>"; } } %> <%=tmpStr%> </select> </td> </tr> <tr> <td class="columnlabel_baseline"></td> <td> <a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" border="0"></a><a href="javascript:clearText()"><img src="../IMAGES/BUTTON/CLEAR.gif" width="73" height="23" border="0"></a></td> </tr> <tr> <td class="columnlabel_baseline2"><div align="right"><script language="javascript">swapLang('Found Data');</script> <%=screen.getRecCount()%></div></td> <td class="columnlabel_baseline2"><div align="right"> <%=screen.getPageTag()%></div></td> </tr> </table> </td> </tr> <tr> <td> <table border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="inframe"> <tr class="title1"> <td width="9%" nowrap class="row3"><div align="center"><script language="javascript">swapLang('Select');</script></div></td> <td width="21%" nowrap class="row3"><div align="center"><%=screen.getLabel("welid")%></div></td> <td width="18%" nowrap class="row3"><div align="center"><%=screen.getLabel("employeeid")%></div></td> <td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("complainid")%></div></td> <td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("caseid")%></div></td> <td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("refdoc")%></div></td> <td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("refno")%></div></td> <td width="9%" nowrap class="row3"><div align="center"><%=screen.getLabel("cost")%></div></td> <td width="12%" nowrap class="row3"><div align="center"><%=screen.getLabel("occurdate")%> </div></td> <td width="13%" nowrap class="row3"><div align="center"><%=screen.getLabel("batchid")%></div></td> </tr> <% while (screen.nextRec()) {%> <tr > <td width="9%" nowrap ><div align="center"><input type="checkbox" name="__docheck" value="<%=screen.getString("complainid")+"|"+screen.getString("caseid")%>"></div></td> <td width="21%" nowrap ><%=screen.getString("mwelfare","tdesc")%></td> <td width="18%" nowrap ><%=screen.getString("employeeid")%> <%=screen.getString("memployee","fullname")%></td> <td width="9%" nowrap ><%=screen.getString("complainid")%></td> <td width="9%" nowrap ><%=screen.getString("caseid")%></td> <td width="9%" nowrap ><%=screen.getString("refdoc")%></td> <td width="9%" nowrap ><%=screen.getString("refno")%></td> <td width="9%" nowrap ><%=screen.getString("cost")%></td> <td width="12%" nowrap ><%=screen.getString("occurdate")%> </td> <td width="13%" nowrap ><%=screen.getString("batchid")%></td> </tr> <%}%> <tr> <td colspan="10" class="blankspace"></td> </tr> <tr> <td class="blankspace style1" colspan="10"><div align="center"><a href="javascript:checkAll();"><img src="../IMAGES/BUTTON/SELECTALL.gif" border="0" align="middle"></a> <a href="javascript:decheckAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif" border="0" align="middle"></a> <a href="javascript:saveStatus('3')"><img src="../IMAGES/BUTTON/CONFIRM.gif" width="73" height="23" border="0" align="middle"></a> <a href="javascript:saveStatus('2')"><img src="../IMAGES/BUTTON/REJECT.gif" width="73" height="23" border="0" align="middle"></a> <a href="javascript:exportData()"><img src="../IMAGES/BUTTON/EXPORT.gif" width="73" height="23" border="0" align="middle"></a></div></td> </tr> <tr> <td colspan="10" class="bottom"></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> <br> </form> </div> </body> </html>