<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@page contentType="text/html; charset=UTF-8"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.SystemCode" %> <%@ page import="com.csc.library.utilities.*,com.csc.library.session.*" %> <jsp:useBean id="PRU127" scope="page" class="com.csc.library.system.Task" /> <html> <% PRU127.setChannel(request ,response); ProcessEntry screen=(ProcessEntry)PRU127.process("ProcessEntry","PPayrollPosting"); screen.process(); CscCalendar cs=new CscCalendar(); UProfile up=screen.getUProfile(); String companyid = (String)up.get("companyid"); //add Permission Salatype0 By yamatos 10/08/2015 String permission = ""; DbInquiry dimsalatype0_permission = new InitialInquiry(screen.getUProfile()).getDbInquiry("MSALATYPE0_PERMISSION"); dimsalatype0_permission.setColumn("*"); dimsalatype0_permission.setFilter("UPPER(USERNAMEID) = UPPER('"+screen.getUProfile().get("userid")+"') AND PER_PERIOD_END = '1'"); dimsalatype0_permission.refresh(); while(dimsalatype0_permission.next()){ permission = chkStr(permission)+dimsalatype0_permission.getString("SALATYPE"); } permission = "codeid in ('"+permission+"') and companyid = '"+screen.getUProfile().get("companyid")+"' AND ACTIVE_STATUS = '1'"; DbInquiry sala0=new InitialInquiry(up).getDbInquiry("Msalatype0",permission,"",false); sala0.setColumn("*"); String filter = "(posted = 1 OR posted = 0)"; DbInquiry sala1 = new InitialInquiry(up).getDbInquiry("Msalatype1",filter,"start_date",false); sala1.setColumn("*"); sala0.putChild(sala1); sala0.refresh(); sala0.referLangOn(); %> <%! private String chkStr(String source){ if(source.length() > 0){ source += "','"; } return source; } %> <html> <head> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <script type='text/javascript' src='../JS/SCREEN.js'></script> <script language='javascript'>setLang('<%=up.get("lang")%>');</script> <script language="javascript">getTitleName();</script> <script language="javascript"> <!-- function process() { with(document.cscform){ bCon=confirm(MyCode[168]); if (bCon==true) { __cmd .value = "save"; submit(); } } } function linkHelp_Return(help,input,filter) { with(document.cscform) { var nInput = input; if(input.indexOf(":")>0){ nInput=input.substring(0,input.indexOf(":")); } obj = eval("document.cscform."+nInput); if((obj=="")||(obj.value=="")){ var param="PRU125HELP.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off"; }else{ var param="PRU125HELP.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off&__valueSearch="+obj.value; } win = window.open(param,"Help","left=150,top=150,width=500,height=200,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); if(window.focus){win.focus();} } } function goHelp(helpName,inputName,filter,companyid){ var helpReturn; var fixcon; helpReturn = inputName+":employeeid"; fixcon="salatype='"+filter+"' and companyid='"+companyid+"'"; linkHelp_Return(helpName,helpReturn,fixcon); } 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> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head> <body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <div class="centered"> <form name="cscform" method="post" action=""> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__screen" value="PRU127"> <input type="hidden" name="__fixCon" value="companyid='<%=companyid%>'"> <input type="hidden" name="__tname" value="ระบบเงินเดือน"> <input type="hidden" name="__ename" value="Payroll"> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__help" value=""> <input type="hidden" name="__tname" value="ระบบเงินเดือน"> <input type="hidden" name="__ename" value="Payroll"> <input type="hidden" name="__user" value="<%=up.getUserId()%>"> <input type="hidden" name="__companyid"value='<%=companyid%>'> <input type="hidden" name="__name" value="Process Payroll Posting"> <input type="hidden" name="__ptype" value="PR2"> <input type="hidden" name="__prclass" value="PPayrollPosting"> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <div align="center"> <table width="640" cellpadding="0" cellspacing="0" > <tr > <td colspan="7" class="header" >PRU127, <script language="javascript">swapLang('Posting Payroll Transaction');</script> </td> </tr> <tr > <td ><table width="100%" border="0" cellpadding="0" cellspacing="0 "id="rsTable" name="rsTable" cols=9 class="row1"> <tr> <td width="26" height="23" class="row1"><div align="center"><script language="javascript">swapLang('Process');</script></div></td> <td width="39" bgcolor="#3366CC" class="row1"><div align="center"><%=sala0.getCurrentDbRecord().getField("codeid").getDescription()%></div></td> <td width="110" bgcolor="#3366CC" class="row1"><div align="center"><%=sala0.getCurrentDbRecord().getField("edesc").getDescription()%></div></td> <td width="86" bgcolor="#3366CC" class="row1"><div align="center"><%=sala0.getCurrentDbRecord().getField("salary_interval").getDescription()%></div></td> <td width="74" bgcolor="#3366CC" class="row1"><div align="center"><%=sala0.getCurrentDbRecord().getField("salary_lst").getDescription()%></div></td> <td width="73" bgcolor="#3366CC" class="row1"><div align="center"><%=sala0.getCurrentDbRecord().getField("salary_nxt").getDescription()%></div></td> <td width="120" bgcolor="#3366CC" class="row1"><div align="center"><script language="javascript">swapLang('Employee Code');</script></div></td> <td width="135" bgcolor="#3366CC" class="row1"><div align="center">คำนวณกลางงวด</div></td> <td width="125" bgcolor="#3366CC" class="row1"><div align="center">วันที่คำนวณ</div></td </tr> <% while(sala0.next()){ String codeid = sala0.getString("codeid"); DbInquiry tmp = (DbInquiry)sala0.getChild("Msalatype1"); // tmp.refresh(); // tmp.next(); %> <tr> <td height="21" class="forborder"> <div align="center"> <input type="checkbox" name="__condition$<%=codeid%>$process" value="" <%=( tmp.getString("posted").equals("0")?"disabled":"")%>> </div> <div align="center"></div></td> <td class="forborder"><div align="center"><%=codeid%></div></td> <td class="forborder"><div align="center"><%=sala0.getString("edesc")%></div></td> <td class="forborder"><div align="center"><%=sala0.getString("salary_interval")%> <%=SystemCode.getValue("every",sala0.getString("salary_every"))%></div></td> <td class="forborder"><div align="center"><%=new CscCalendar(tmp.getString("start_date")).getDDMMYYYY() %></div></td> <td class="forborder"><div align="center"><%=new CscCalendar(tmp.getString("end_date")).getDDMMYYYY() %></div></td> <input type="hidden" name="__condition$<%=codeid%>$gendate" value="<%=tmp.getString("end_date")%>"> <input type="hidden" name="__condition$<%=codeid%>$cal_tax" value="<%=tmp.getString("cal_tax")%>"> <input type="hidden" name="__condition$<%=codeid%>$cal_soc" value="<%=tmp.getString("cal_soc")%>"> <input type="hidden" name="__condition$<%=codeid%>$cal_pvf" value="<%=tmp.getString("cal_pvf")%>"> <td valign="baseline" class="forborder"><div align="center"> <input name="__condition$<%=codeid%>$1" type="text" size="10" maxlength="10"> <a href="javascript:goHelp('MEMPLOYEEHELP','__condition$<%=codeid%>$1','<%=codeid%>','<%=companyid%>');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image15','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image15" width="20" height="20" border="0" align="absmiddle"></a> <input name="__condition$<%=codeid%>$2" type="text" size="10" maxlength="10"> <a href="javascript:goHelp('MEMPLOYEEHELP','__condition$<%=codeid%>$2','<%=codeid%>','<%=companyid%>');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image16332','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image16332" width="20" height="20" border="0" align="absmiddle" id="Image163"></a></div></td> <td class="forborder"><div align="left"> <input type="radio" name="__condition$<%=codeid%>$is_new_gendate" value="1">ใช่ <input type="radio" name="__condition$<%=codeid%>$is_new_gendate" value="0" checked>ไม่ใช่</div> </td> <td class="forborder"><div align="center"> <input type="text" name="__condition$<%=codeid%>$new_gendate" value="<%=cs.getDDMMYYYY()%>" style="width:80px" onfocus="this.select();setFormatDatePayroll(this,'DDMMYYYY');" onkeypress="chkInteger(event);" onkeyup="sysIsEdit();formatDate(this);" onblur=""> <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" border="0" align="absmiddle" onClick="viewCal('__condition$<%=codeid%>$new_gendate')" alt="Calendar"></a> </div></td> <tr> <%}%> <td colspan="7"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="70%" colspan="7" class="blankspace"></td> </tr> <tr> <td colspan="7" class="blankspace"></td> </tr> <tr> <td colspan="7"><div align="center"><img src="../IMAGES/BUTTON/SELECTALL.gif" onClick="checkAll()"> <img src="../IMAGES/BUTTON/DESELECTALL.gif" onClick="decheckAll()"> <a href="javascript:process();"><img src="../IMAGES/BUTTON/PROCESS.gif" border="0"></a> </div></td> </tr> <tr> <td colspan="7" class="blankspace"> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td class="bottom" > </td> </tr> </table> </div> <!----------BEGIN CSC ENDING ZONE ------------------------> <%=screen.endJSP()%> <!----------END CSC ENDING ZONE --------------------------> </form> </body> </html>