<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@page contentType="text/html; charset=UTF-8"%> <%@page import="java.text.DecimalFormat,com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,com.csc.library.components.*;"%> <jsp:useBean id="PRU047" class="com.csc.library.system.Task" scope="page" /><% PRU047.setChannel(request, response); UIManager screen = (UIManager) PRU047.process("SingleEntry", "PRU047"); screen.referLangOff(); DbInquiry dbi=(DbInquiry)screen.getRecord("Mempl_fix").getChild("memployee"); dbi.getCurrentDbRecord().setProperties(true); ListBox lisbx=new ListBox(((DbInquiry)screen.getRecord("Mempl_fix").getChild("memployee")).getCurrentDbRecord().getField("status"),new MyFont(),new MyFont()); lisbx.setUProfile(screen.getUProfile()); lisbx.process(); CheckNull chk=new CheckNull(); String ack=chk.chkNullString(request.getParameter("__cmd")); String confirm=chk.chkNullString(request.getParameter("__confirm")); //out.print("<br>"+ack); //out.print("<br><br>"+screen.getRecord("memployee").getString("employeeid")); if(ack.equals("save")&&(confirm.equals("c"))){ screen.clean(); ((DbInquiry)screen.getRecord("Mempl_fix").getChild("mprefix")).clearField(); }else{ if(ack.equals("save")&&(!confirm.equals("c"))){ DbRecord db=screen.getRecord("Mempl_fix"); db.set("employeeid",chk.chkNullString(request.getParameter("__employeeid"))); db.set("companyid",chk.chkNullString(request.getParameter("__companyid"))); db.search(); } } %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" > <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <script type='text/javascript' src='../JS/SCREEN.js'></script> <script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="javascript">getTitleName();</script> <script language='javascript' src='../JS/EMPLOYEE.js'></script> <script src="../JS/VIEWCALENDAR.js"></script> <script language="JavaScript" src="../JS/DATEINPUT.js"></script> <script language="JavaScript" src='../JS/ICONSMENU.js'></script> <script language='javascript' src='../JS/HOTKEY.js'></script> <script language="JavaScript" type="text/JavaScript"> <!-- if (!Number.toFixed){ Number.toFixed = function (x) { var temp = this; temp=Math.ceil(temp*Math.pow(10,x))/Math.pow(10,x); return temp; } } function setDecimal(){ with(document.cscform){ for(var i=0;i<elements.length;i++){ if(elements[i].name.indexOf("__MFIXTAB$")>-1){ elements[i].value=parseFloat(elements[i].value).toFixed(2); } } } } function GoSave(){ if(nullCheck()){ with(document.cscform){ aCon=confirm(MyCode[3]);// จะบันทึกหรือไม if (aCon==true) { for(var i=0;i<elements.length;i++){ if(elements[i].name.indexOf("datemfixtab")==0){ if(elements[i].value.indexOf("-")>0){ obj = eval("document.cscform.__"+elements[i].name.substring(4)); tmp=elements[i].value.split("-"); obj.value=tmp[2]+"-"+tmp[1]+"-"+tmp[0]; } }else{ if(elements[i].className.indexOf("numeric")>-1){ elements[i].value=elements[i].value.replace(",", ""); } } } save(); } } } } function GoUpdate(){ setDecimal(); update(); } function GoDelete(){ alert("ไม่สามารถใช้งานได้"); // edelete(); } function GoSearch(){ search(); } //function save(){ // with(document.cscform){ // __confirm.value="2"; // __cmd.value = "save"; // alert("cmd:"+__cmd.value); // submit(); // } //} //--> </script> <body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif')" > <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="get" action="PRU047.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__screen" value="PRU047"> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__notNull" value="employeeid,<%=screen.getRequire()%>"> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__help" value=""> <input type="hidden" name="__afterUpdate" value=""> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__emp_level" value="<%=screen.getDataLabel("emp_level")%>"> <input type="hidden" name="__calendar" value=""> <script language="JavaScript" >getInputFormatDate();</script> <script language="javascript"> var titlename=swap2String('Income and Deduction Table'); document.write(Icons("PRU047,"+titlename)); </script> <br> <% String tprefix=screen.getDataLabel("MPREFIX","TDESC"); String eprefix=screen.getDataLabel("MPREFIX","EDESC"); /*if(ack.equals("save")){ screen.getRecord().clearChild(); eprefix=""; tprefix=""; }*/ %> <div align="center"> <!-- ++++++++++++++++++++++++++++++++ Table 1 +++++++++++++++++++++++++++++++++++--> <table cellpadding="0" cellspacing="0" > <tr> <td class="header">PRU047, <script language="JavaScript">swapLang("Income and Deduction Table");</script> </td> </tr> <tr> <td><br> <!-- ++++++++++++++++++++++++++++++++ Table 2 +++++++++++++++++++++++++++++++++++--> <table border="1" cellpadding="0" cellspacing="0" class="largest" align="center"> <tr> <td><!-- ++++++++++++++++++++++++++++++++ Table 3 +++++++++++++++++++++++++++++++++++--> <table cellspacing="0" cellpadding="0" class="inframe"> <tr> <td></td> <td></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("employeeid")%> </td> <td> <INPUT TYPE="text" Name="__employeeid" SIZE="10" MAXLENGTH="6" VALUE="<%=screen.getDataLabel("employeeid")%>" onMouseOver="toolTip('รหัสพนักงาน')" onMouseOut="toolTip()" onKeyPress="chkSpecialStr();" onBlur="trimValue(this);" onFocus="this.select();" > <A href="javascript:linkHelp('MEMPLOYEEHELP','__employeeid');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('__employeeid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__employeeid_image" width="20" height="20" border="0" align="absmiddle"></a> <%=dbi.getCurrentDbRecord().getField("status").getDescription()%> <%=lisbx.getInput()%> </td> </tr> <tr> <td height="22" class="columnlabel" ><%=dbi.getCurrentDbRecord().getField("fname").getDescription()%> * </td> <td><input name="MPREFIX@TDESC" type="text" readonly size="10" value="<%=tprefix%>"> <input name="__fname" type="text" size="20" readonly value="<%=screen.getDataLabel("memployee","fname")%>"> <input name="__lname" type="text" size="20" readonly value="<%=screen.getDataLabel("memployee","lname")%>"> </td> </tr> <tr> <td class="columnlabel"><%=dbi.getCurrentDbRecord().getField("efname").getDescription()%> </td> <td><input name="MPREFIX@EDESC" type="text" readonly size="10" value="<%=eprefix%>"> <input name="__efname" type="text" size="20" readonly value="<%=screen.getDataLabel("memployee","efname")%>"> <input name="__elname" type="text" size="20" readonly value="<%=screen.getDataLabel("memployee","elname")%>"> </td> </tr> <tr> <td > </td> <td > </td> </tr> </table> <!-- ++++++++++++++++++++++++++++++++ Table 3 closed +++++++++++++++++++++++++++++++++++--> </td> </tr> </table> <!-- ++++++++++++++++++++++++++++++++ Table 2 closed +++++++++++++++++++++++++++++++++++--> <br> <!-- ++++++++++++++++++++++++++++++++ Table 4 +++++++++++++++++++++++++++++++++++--> <table border="1" cellpadding="0" cellspacing="0" class="larget" align="center"> <tr> <td><!-- ++++++++++++++++++++++++++++++++ Table 5 +++++++++++++++++++++++++++++++++++--> <table cellpadding="0" cellspacing="0" > <tr> <td><!-- ++++++++++++++++++++++++++++++++ Table 6 +++++++++++++++++++++++++++++++++++--> <table border="0" cellpadding="0" cellspacing="1" bgcolor="#333333"> <tr> <td align="center" class="row3"><script language="javascript">swapLang('Code');</script></td> <td width="255" align="center" class="row3"><script language="javascript">swapLang('Description');</script></td> <td width="210" align="center" class="row3" ><script language="javascript">swapLang('Amount');</script></td> </tr> <% String stFilter = " companyid = '"+screen.getUProfile().get("companyid")+"'"; DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry(); inq.setSchemaName(screen.getUProfile().getSchemaName()); inq.initMyTable("mfixtab",stFilter,"fixtab_index,fixtabid"); inq.setColumn("fixtabid,fixtab_type,maxlength,fixtab_index"); inq.setVerifyOff(); inq.setOrderBy("fixtab_index,fixtabid"); inq.refresh(); String fixCode ; String getName ; DecimalFormat dc = new DecimalFormat(); dc.applyPattern(screen.getUProfile().get("formatnumber")); String value=""; String temp=""; while (inq.next()) { temp=""; fixCode = inq.getString("fixtabid").toString(); getName = "mfixtab$"+fixCode; if(!(ack.equals("save")&&(confirm.equals("c")))){ temp=screen.getDataLabel(getName); } if(inq.getString("fixtab_type").equals("1")){ if(temp.equals(""))temp="0.00"; else temp=temp.replaceAll(",",""); value=dc.format(Double.parseDouble(temp)); %> <tr> <td align="center"><%=fixCode%></td> <td> <%=screen.getLabel(getName)%></td> <td align="center" ><INPUT TYPE='text' Name='__<%=getName%>' SIZE='15' MAXLENGTH='<%=inq.getString("maxlength")%>' VALUE='<%=value%>' onMouseOver="toolTip('<%=screen.getLabel(getName)%>')" onChange="sysIsEdit();" onMouseOut="toolTip()" onKeyPress="checkWordNumber(this.value);" onKeyUp="checkComma(this,2);" dir="" onBlur="checkNumFloat(this,0.00,1000000);" onFocus="callDelComma(this);" class="numeric" ></td> </tr> <% }else if(inq.getString("fixtab_type").equals("2")){ if(temp.equals("0.00"))temp=""; value=temp; %> <tr> <td align="center"><%=fixCode%></td> <td align="left"> <%=screen.getLabel(getName)%></td> <td align="center" ><INPUT TYPE='text' Name='__<%=getName%>' SIZE='15' MAXLENGTH='<%=inq.getString("maxlength")%>' VALUE='<%=value%>' onMouseOver="toolTip('<%=screen.getLabel(getName)%>')" onClick="" onChange="sysIsEdit();" onMouseOut="toolTip()" onKeyPress="chkSpecialStr();" onKeyUp="" dir="" onBlur="trimValue(this);" onFocus="this.select();" class="" ></td> </tr> <% }else if(inq.getString("fixtab_type").equals("3")){ if(temp.equals(""))temp="0"; else temp=temp.replaceAll(",",""); value=temp; %> <tr> <td align="center"><%=fixCode%></td> <td align="left"> <%=screen.getLabel(getName)%></td> <td align="center" ><INPUT TYPE='text' Name='__<%=getName%>' SIZE='15' MAXLENGTH='<%=inq.getString("maxlength")%>' VALUE='<%=value%>' onMouseOver="toolTip('<%=screen.getLabel(getName)%>')" onChange="sysIsEdit();" onMouseOut="toolTip()" onKeyPress="chkInteger();" onKeyUp="" dir="" onBlur="checkNumFloat(this,0.00,1000000);" onFocus="callDelComma(this);" class="numeric" ></td> </tr> <% }else if(inq.getString("fixtab_type").equals("5")){ if(temp.equals("0.00"))temp=""; value=temp; %> <tr> <td align="center"><%=fixCode%></td> <td align="left"> <%//=screen.getLabel(getName)%></td> <td align="center" ><INPUT TYPE="hidden" Name="__<%=getName%>" SIZE="10" MAXLENGTH='10' VALUE="<%=value%>"> <% if(!value.equals("")){ CscCalendar cscDate = new CscCalendar(value); value = cscDate.getDDMMYYYY(); } %> <INPUT TYPE="text" Name="date<%=getName%>" SIZE="10" MAXLENGTH='10' VALUE="<%=value%>" onChange="sysIsEdit();" onMouseOver="toolTip('<%=screen.getLabel(getName)%>')" onMouseOut="toolTip()" onKeyPress="chkIntegerOfDate(this.value);" onKeyUp="formatDate(this);" onBlur="chkInputDate(this);" onFocus="this.select();" > <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('effolname','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('date<%=getName%>');"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="<%=getName+"c"%>" width="20" height="20" border="0" align="absmiddle"></a></td> </tr> <% } }//while %> </table> <!-- ++++++++++++++++++++++++++++++++ Table 6 closed +++++++++++++++++++++++++++++++++++--> </td> </tr> </table> <!-- ++++++++++++++++++++++++++++++++ Table 5 closed +++++++++++++++++++++++++++++++++++--> </td> </tr> </table> <!-- ++++++++++++++++++++++++++++++++ Table 4 closed +++++++++++++++++++++++++++++++++++--> </td> </tr> <tr> <td class="blankspace"></td> </tr> <tr> <td align="right"><script language="javascript">printEditCheck('<%=screen.getDataLabel("edit_by")%>','<%=screen.getDataLabel("edit_date")%>','<%=screen.getDataLabel("edit_time")%>','<%=screen.getDataLabel("approve")%>');</script> </td> </tr> <tr> <td class="blankspace"></td> </tr> <tr> <td class="bottom"></td> </tr> </table> <!-- ++++++++++++++++++++++++++++++++ Table 1 closed +++++++++++++++++++++++++++++++++++--> </div> <!----------BEGIN CSC ENDING ZONE ------------------------> <%=screen.endJSP()%> <!----------END CSC ENDING ZONE --------------------------> </FORM> </body> </html>