<%@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.components.ListBox" %> <%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.report.ReportUDF" %> <jsp:useBean id="PRU168" class="com.csc.library.system.Task" scope="page"/> <% CheckNull chk=new CheckNull(); PRU168.setChannel(request,response); HelpEntry screen = (HelpEntry) PRU168.process("HelpEntry","MJVTEMPLATEHELP"); ReportUDF reportUDF = new ReportUDF(); String templatefilter = chk.chkNullString(request.getParameter("__templatefilter")); String templateorder = chk.chkNullString(request.getParameter("__templateorder"),"cast(sqnumber as integer) asc"); //out.println("templatefilter ==> "+templatefilter+"<BR>templateorder ==> "+templateorder); screen.getInquiry().setFilter(templatefilter); screen.getInquiry().setOrderBy(templateorder); screen.getInquiry().refresh(); int recCount = screen.getInquiry().recCount(); int maxRec = 30; int goPage = Integer.parseInt( chk.chkNullString(request.getParameter("__goPage"),"1") ); int maxPage = recCount / maxRec; if(recCount%maxRec > 0){ maxPage++; } int startRec = (maxRec * goPage) - maxRec; screen.getInquiry().go(startRec); //out.println("<BR>recCount ==> "+recCount+" , maxRec ==> "+maxRec+" , goPage ==> "+goPage+" , startRec ==> "+startRec+" , maxPage ==> "+maxPage); %> <html ng-app="myHR"> <head> <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 type='text/javascript' src='../JS/SCREEN.js'></script> <script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script> <script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script> <script type='text/javascript' src='../JS/ICONSMENU.js'></script> <script type='text/javascript' src='/hr/dwr/interface/Deletejvsetup.js'></script> <script type='text/javascript' src='/hr/dwr/engine.js'></script> <script src="../JS/jquery-2.1.3.min.js" type="text/javascript"></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="javascript">getTitleName();</script> <script language="javascript"> function checkAll(){ with(document.cscform){ for(i=0;i<elements.length;i++){ if(elements[i].type=="checkbox") elements[i].checked=true; }//end for }//end with }//end function function decheckAll(){ with(document.cscform){ for(i=0;i<elements.length;i++){ if(elements[i].type=="checkbox") elements[i].checked=false; }//end for }//end with }//end function function childMulti(record){ with(document.cscform){ window.open(__childMulti.value+".jsp?"+__childKey.value+"="+record ,"Expertise","width=600,height=300,left=150,top=20,width=700,height=700,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } function addMulti(){ with(document.cscform){ window.open(__childMulti.value+".jsp","Expertise","width=600,height=300,left=150,top=20,width=700,height=700,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } function deleteMulti(){ with(document.cscform){ bCon=confirm(MyCode[4]); if (bCon===true){ var value = getCheckBox(); Deletejvsetup.jvdelete("MJVTEMPLATE", "SQNUMBER", value, function(data){ alert("Delete Complete."); submit(); }); } } } function getCheckBox(){ var value = ""; $(".del_list").each(function(){ if($(this).prop("checked")){ value = chkText(value); value += $(this).val(); } }); return value; } function chkText(str){ if(str.length > 0){ str += ","; } return str; } function GoSave(){ confirmSave(); } function GoUpdate(){ update(); } function GoDelete(){ edelete(); } function GoSearch(){ search(); } function goHelp(helpName,inputName){ var helpReturn; if(inputName=="__fix_njvsq" ) { helpReturn="__fix_njvsq:sqcode,__mjvsequencenumber_sqname:sqname"; linkHelp_Return(helpName,helpReturn); } else if (inputName=="__fix_mcostcode" ) { helpReturn="__fix_mcostcode:maincostcentercode,__mmaincostcenter_edesc:edesc"; linkHelp_Return(helpName,helpReturn); } else if (inputName=="__fix_costcode" ) { helpReturn="__fix_costcode:costcenterid,__mcostcenter0_edesc:edesc"; linkHelp_Return(helpName,helpReturn); } else if (inputName=="__fix_analcode" ) { helpReturn="__fix_analcode:analcode"; linkHelp_Return(helpName,helpReturn); } } function linkHelp_Return(help,input, fixCon){ with(document.cscform){ var filter = fixCon || __fixCon.value; var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off"; win = window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); if(window.focus){win.focus();} } } function searchtemplate(){ with(document.cscform){ __cmd.value = "searchtemplate"; __goPage.value = "1"; setFilter(); setOrderBy(); submit(); } } function setFilter(){ with(document.cscform){ var filter = ""; if(__fix_njvsq.value !== "") filter = chkLength(filter) + "njvsq='"+__fix_njvsq.value+"'"; if(__fix_mcostcode.value !== "") filter = chkLength(filter) + "mcostcode='"+__fix_mcostcode.value+"'"; if(__fix_costcode.value !== "") filter = chkLength(filter) + "costcode='"+__fix_costcode.value+"'"; if(__fix_analcode.value !== "") filter = chkLength(filter) + "( upper(anal_t0) like upper('%"+__fix_analcode.value+"%') or upper(anal_t1) like upper('%"+__fix_analcode.value+"%') or upper(anal_t2) like upper('%"+__fix_analcode.value+"%') or upper(anal_t3) like upper('%"+__fix_analcode.value+"%') or upper(anal_t4) like upper('%"+__fix_analcode.value+"%') or upper(anal_t5) like upper('%"+__fix_analcode.value+"%') or upper(anal_t6) like upper('%"+__fix_analcode.value+"%') or upper(anal_t7) like upper('%"+__fix_analcode.value+"%') or upper(anal_t8) like upper('%"+__fix_analcode.value+"%') or upper(anal_t9) like upper('%"+__fix_analcode.value+"%') )"; if(__fix_flag.value !== "") filter = chkLength(filter) + "flag='"+__fix_flag.value+"'"; __templatefilter.value = filter; } } function setOrderBy(){ with(document.cscform){ var order = __fix_orderby.value; if(order === "SQNUMBER"){ __templateorder.value = "CAST(sqnumber AS INTEGER) ASC"; } else if(order !== ""){ __templateorder.value = " "+order+" ASC"; } } } function chkLength(str){ if(str !== ""){ str += " AND "; } return str; } $(function(){ $('#onpage').change(function(){ with(document.cscform){ __cmd.value = "goPage"; __goPage.value = $(this).val(); submit(); } }); }); </script> </head> <body leftmargin="0" topmargin="0"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action=""> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__cmd" value=""/> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"/> <input type="hidden" name="__screen" value="PRU168"/> <input type="hidden" name="__childMulti" value="PRU168_DETAIL"/> <input type="hidden" name="__childKey" value="__sqnumber"/> <input type="hidden" name="__helpReturn" value=""/> <input type="hidden" name="__help" value=""/> <input type="hidden" name="__helpName" value=""/> <input type="hidden" name="__pageCall" value=""/> <input type="hidden" name="__referPage" value=""/> <input type="hidden" name="__goPage" value=""/> <input type="hidden" name="__templatefilter" value="<%=templatefilter%>"/> <input type="hidden" name="__templateorder" value="<%=templateorder%>"/> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"/> <input type="hidden" name="__fixCon" value="companyid='<%=screen.getUProfile().get("companyid")%>'"/> <input type="hidden" name="__referPage" value=""/> <input type="hidden" name="__user" value="<%=screen.getUProfile().getUserId()%>"/> <div align="center"> <br/> <table cellpadding="0" cellspacing="0" style="width:900px"> <tr > <td class="header" colspan="2">PRU168, <span swlang code="SW012724">Payroll Journal Voucher Template</span> </td> </tr> <tr> <td class="blankspace" colspan="2"></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("NJVSQ")%> :: </td> <td class="columnobject1"> <input type="text" size="15" name="__fix_njvsq" value="<%=chk.chkNullString(request.getParameter("__fix_njvsq"))%>"> <a onmouseover="MM_swapImage('__fix_njvsq_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MJVSEQUENCENUMBERHELP','__fix_njvsq');"><img name="__fix_njvsq_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a> <input name="__mjvsequencenumber_sqname" type="text" readonly="true" value="<%=chk.chkNullString(request.getParameter("__mjvsequencenumber_sqname"))%>" size="40"> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("MCOSTCODE")%> :: </td> <td class="columnobject1"> <input type="text" size="15" name="__fix_mcostcode" value="<%=chk.chkNullString(request.getParameter("__fix_mcostcode"))%>"> <a onmouseover="MM_swapImage('__fix_mcostcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MMAINCOSTCENTERHELP','__fix_mcostcode');"><img name="__fix_mcostcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a> <input name="__mmaincostcenter_edesc" type="text" readonly="true" value="<%=chk.chkNullString(request.getParameter("__mmaincostcenter_edesc"))%>" size="40"> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("COSTCODE")%> :: </td> <td class="columnobject1"> <input type="text" size="15" name="__fix_costcode" value="<%=chk.chkNullString(request.getParameter("__fix_costcode"))%>"> <a onmouseover="MM_swapImage('__fix_costcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MCOSTCENTER0HELP','__fix_costcode');"><img name="__fix_costcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a> <input name="__mcostcenter0_edesc" type="text" readonly="true" value="<%=chk.chkNullString(request.getParameter("__mcostcenter0_edesc"))%>" size="40"> </td> </tr> <tr> <td class="columnlabel">Analysis Code :: </td> <td class="columnobject1"> <input type="text" size="15" name="__fix_analcode" value="<%=chk.chkNullString(request.getParameter("__fix_analcode"))%>"> <a onmouseover="MM_swapImage('__fix_analcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MJVTEMPLATE_DISTINCTANALCODE','__fix_analcode');"><img name="__fix_analcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("FLAG")%> :: </td> <td class="columnobject1"> <% ListBox listboxFlag = new ListBox(); listboxFlag.setUProfile(screen.getUProfile()); listboxFlag.setName("fix_flag"); //ชื่อ ListBox listboxFlag.setValidCode("JVFLAGTEMPLATE"); //tag Systemcode ที่เรียกใช้ listboxFlag.setBlank(true); listboxFlag.setDisable("false"); listboxFlag.setChecked(chk.chkNullString(request.getParameter("__fix_flag"))); out.println(listboxFlag.process()); %> </td> </tr> <tr> <td class="columnlabel"><span swlang code="SW000004">Order By</span> :: </td> <td class="columnobject1"> <% ListBox listboxOrderBy = new ListBox(); listboxOrderBy.setUProfile(screen.getUProfile()); listboxOrderBy.setName("fix_orderby"); //ชื่อ ListBox listboxOrderBy.setValidCode("JVTEMPLATE_ORDERBY"); //tag Systemcode ที่เรียกใช้ listboxOrderBy.setBlank(true); listboxOrderBy.setDisable("false"); listboxOrderBy.setChecked(chk.chkNullString(request.getParameter("__fix_orderby"))); out.println(listboxOrderBy.process()); %> </td> </tr> <tr> <td class="buttonline" colspan="7"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW003537" onClick="searchtemplate();">SEARCH</button> </div> </td> </tr> <tr> <td class="blankspace" colspan="2"></td> </tr> <tr> <td><div> <script language="javascript">swapLang("Found Data");</script> :: <%=recCount%></div></td> <td> <div align="right">Page :: <%if(maxPage != 1){ %> <select id="onpage" size="0"> <% for(int i=1; i<=maxPage; i++){ %> <option value="<%=i%>" <%if(goPage == i){%>selected<%}%>><%=i%></option> <% } %> </select> <%} else { out.println(maxPage); }%> </div> </td> </tr> <tr> <td colspan="2" align="center"> <div align="center"> <table cellpadding="0" cellspacing="0" style="width:900px" class="tablewithborder"> <tr align="center" bgcolor="#CCCCCC"> <td class="row3"> <script language='javascript'>swapLang('Del');</script> </td> <td class="row3"> <%=screen.getLabel("SQNUMBER")%> </td> <td class="row3"> <%=screen.getLabel("NJVSQ")%> </td> <td class="row3"> <%=screen.getLabel("ACCTCODE")%> </td> <td class="row3"> <%=screen.getLabel("ACCTNAME")%> </td> <td class="row3"> <%=screen.getLabel("ACCTTYPE")%> </td> <td class="row3"> <%=screen.getLabel("FLAG")%> </td> <td class="row3"> <%=screen.getLabel("MCOSTCODE")%> </td> <td class="row3"> <%=screen.getLabel("COSTCODE")%> </td> </tr> <% int round = 1; while (screen.nextRec()) { if(round <= maxRec){ %> <tr> <td align="center" class="forborder"><input type="checkbox" class="del_list" value="<%=screen.getDataLabel("SQNUMBER")%>"></td> <td align="center" class="forborder"> <a href="javaScript:childMulti('<%=screen.getDataLabel("SQNUMBER")%>')"><%=screen.getDataLabel("SQNUMBER")%></a></td> <td align="center" class="forborder"> <%=screen.getDataLabel("NJVSQ")%> </td> <td align="left" class="forborder"> <%=screen.getDataLabel("ACCTCODE")%> </td> <td align="left" class="forborder"> <%=screen.getDataLabel("ACCTNAME")%> </td> <td align="center" class="forborder"> <%=reportUDF.getSystemCode("JVACCTYPE", screen.getUProfile().get("lang"), screen.getDataLabel("ACCTTYPE"))%> </td> <td align="left" class="forborder"> <%=reportUDF.getSystemCode("JVFLAG", screen.getUProfile().get("lang"), screen.getDataLabel("FLAG"))%> </td> <td align="center" class="forborder"> <%=screen.getDataLabel("MCOSTCODE")%> </td> <td align="center" class="forborder"> <%=screen.getDataLabel("COSTCODE")%> </td> </tr> <% round++; } else { break; } } %> <tr> <td class="buttonline" colspan="10"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW013163" onClick="checkAll();">Select All</button> <button type="button" class="btn btn-primary width100" swlang code="SW013164" onClick="decheckAll();">Deselect All</button> <button type="button" class="btn btn-primary width100" swlang code="SW013165" onClick="addMulti();">Add</button> <button type="button" class="btn btn-primary width100" swlang code="SW013166" onClick="deleteMulti();">Delete</button> </div> </td> </tr> </table> </td> </tr> <tr> <td class="bottom" colspan="2"></td> </tr> </table> </div> <!----------BEGIN CSC ENDING ZONE ------------------------> <!----------END CSC ENDING ZONE --------------------------> </form> </body> </html>