<%@ page import="com.csc.library.entry.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.database.*,java.util.*" contentType="text/html;charset=UTF-8"%> <%@ page import="com.csc.library.databean.*" %> <%@ page import="com.csc.library.loancalculation.*" %> <%request.setCharacterEncoding("UTF-8");%> <!-- <jsp:useBean id="PRU097" scope="page" class="com.csc.library.system.Task"/> --> <% PRU097.setChannel(request ,response); CheckNull chkNull = new CheckNull(); UIManager screen=(UIManager)PRU097.process("ChildEntry","SIMEMPL_LOAN"); //out.println(screen.getTable("SIMEMPL_LOAN").getChildTable()); screen.getTable("SIMEMPL_LOAN").getChildTable(); //out.println(((Simempl_loan)screen.getTable("SIMEMPL_LOAN").getCurrentRecordManager()).getParam()); String chkcarry = chkNull.chkNullString(request.getParameter("__chkcarry")); if(!chkNull.chkNullString(request.getParameter("__genList"),"").equals("") && request.getParameter("__genList")!= null){ //out.print("gen"+chkNull.chkNullString(request.getParameter("__genList"))); Simempl_loan myln = (Simempl_loan) screen.getTable("SIMEMPL_LOAN").getCurrentRecordManager(); myln.setParam(screen.getTable("SIMEMPL_LOAN").getParam()); myln.saveLoan1(); }else if(!chkNull.chkNullString(request.getParameter("__reCalculate"),"").equals("") && request.getParameter("__reCalculate")!= null){ //out.print("re Calulate:"+chkNull.chkNullString(request.getParameter("__reCalculate"))+"SEQ:"+chkNull.chkNullStringToInt(request.getParameter("__seq"))); Simempl_loan myln = (Simempl_loan) screen.getTable("SIMEMPL_LOAN").getCurrentRecordManager(); myln.setParam(screen.getTable("SIMEMPL_LOAN").getParam()); myln.saveLoan1(); //out.println("__reCalculate"); }else if(chkcarry.equals("1")){ Simempl_loan myln = (Simempl_loan) screen.getTable("SIMEMPL_LOAN").getCurrentRecordManager(); myln.setParam(screen.getTable("SIMEMPL_LOAN").getParam()); myln.saveLoan1(); } String CarryData = chkNull.chkNullString(screen.getDataLabel("carry")); %> <html> <head> <title></title> <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 language="javascript" type='text/javascript' src='../JS/SCREEN.js'></script> <script language="javascript" src="../JS/VIEWCALENDAR.js"></script> <script language="javascript" src="../JS/EMPLOYEE.js"></script> <script language="javascript" src="../JS/DATEINPUT.js"></script> <script language="javascript">getTitleName();</script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</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 language="JavaScript" type="text/JavaScript"> function setcmd1(acktion){ if(nullCheck()){ with(document.cscform){ if(check_Time('__startdate')&&check_Time('__enddate')&&(__contractnoid.value.length>0)){ __chkcarry.value=""; bCon=confirm(MyCode[1]); if (bCon==true) { if(acktion=="save"){ __cmdchild.value="save"; __show.value=""; } } submit(); }else{ alert(MyCode[0]); } } } } function goHelp(helpName,inputName){ with(document.cscform){ var helpReturn=""; var fcon=__fixCon.value; if(inputName=="__loantype" ) helpReturn="__loantype:loanid,MLOAN_TDESC:tdesc"; if(inputName=="__payment_formula" ) helpReturn="__payment_formula:formulaid,MFORMULA@TDESC"; if(inputName=="__business_type" ) helpReturn="__business_type:groupid,MGROUP@TDESC"; if(inputName=="__roundid") helpReturn="__roundid:roundid,MROUND_TDESC:tdesc"; if(inputName=="__amounttab" ) helpReturn="__amounttab:amounttabid,MAMOUNTTAB_TDESC:tdesc"; linkHelp_Return(helpName,helpReturn); } } function back() { with(window.opener.document.cscform) { __cmd.value = 'ack'; submit(); } } function setGenerate() { with(window.cscform) { if( nullCheck() ){ __genList.value = 'gen'; __show.value="gen"; __cmd.value="ack"; __chkcarry.value="0"; if($("input[name='__carry']").is(":checked")){ __chkcarry.value="1"; } else{ $("input[name='balance_carry']").val("0.00"); } submit(); } } } function setAfterGen(){ with(document.cscform){ //alert(__genList.value+":"+__ack.value); if((__genList.value != "gen" && __show.value == "gen")){ //alert(); __contractnoid.value='<%=chkNull.chkNullString(request.getParameter("__contractnoid"))%>'; __loantype.value='<%=chkNull.chkNullString(request.getParameter("__loantype"))%>'; MLOAN_TDESC.value='<%=chkNull.chkNullString(request.getParameter("MLOAN_TDESC"))%>'; __startdate.value='<%=chkNull.chkNullString(request.getParameter("__startdate"),new CscCalendar().getDDMMYYYY())%>'; __enddate.value='<%=chkNull.chkNullString(request.getParameter("__enddate"),new CscCalendar().getDDMMYYYY())%>'; __loanprinciple.value='<%=chkNull.chkNullString(request.getParameter("__loanprinciple"),"0.00")%>'; __intrate.value='<%=chkNull.chkNullString(request.getParameter("__intrate"),"0.00")%>'; __roundid.value='<%=chkNull.chkNullString(request.getParameter("__roundid"))%>'; MROUND_TDESC.value='<%=chkNull.chkNullString(request.getParameter("MROUND_TDESC"))%>'; __caltype.value='<%=chkNull.chkNullString(request.getParameter("__caltype"),"0")%>'; __firstloandate.value='<%=chkNull.chkNullString(request.getParameter("__firstloandate"),new CscCalendar().getDDMMYYYY())%>'; __cal_cycle.value='<%=chkNull.chkNullString(request.getParameter("__cal_cycle"),"0")%>'; __obj_loan.value='<%=chkNull.chkNullString(request.getParameter("__obj_loan"))%>'; __amounttab.value='<%=chkNull.chkNullString(request.getParameter("__amounttab"))%>'; MAMOUNTTAB_TDESC.value='<%=chkNull.chkNullString(request.getParameter("MAMOUNTTAB_TDESC"))%>'; } } } function linkSavePay(page,seq,amt,pay_status){ with(document.cscform){ window.open(page+".jsp?" +"&__employeeid="+__employeeid.value +"&__companyid="+__companyid.value +"&__contractnoid="+__contractnoid.value +"&__seq_no="+seq +"&__pay_status="+pay_status +"&__amount="+amt,"savePay","left=150,top=150,width=600,height=300,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } function chkEqualsDate(obj1,obj2) { with(document.cscform){ if( obj2.value != "" && obj1.value != "" ){ var date1 = obj1.value.split("-"); var date2 = obj2.value.split("-"); } } } function chkInputDate2(obj1,obj2) { if (obj1.value != "" && obj2.value == "") { obj2.value = obj1.value; } if (obj2.value != "" && obj1.value == "") { obj1.value =obj2.value; } var temp1 = obj1.value; var temp2 = obj2.value; var tempdate1 = obj1.value.split("-"); var tempdate2 = obj2.value.split("-"); var chk = true; if (obj1.value == "") { obj1.value = datePresent(); } if (obj2.value == "") { obj2.value = datePresent(); } if (!chkInputDate(obj1)) { chk = false; } else if (!chkInputDate(obj2)) { chk = false; } else if (!checkFdateEdate(obj1.value,obj2.value)) { alert("วันที่ไม่ถูกต้อง"); chk = false; obj2.select(); obj2.value = obj1.value; } return chk; } (function($) { $(function() { $(".chkCarryAll").each(function(index) { var status = $(this).val(); if(status=="3.0"){ document.cscform.__status.value=status; $(".carry").attr("checked",true); $("input[name='__seq']").val("1"); return false; } }); $(".carry").click(function(){ var mssth = "ยืนยันการยกยอด"; var mssen = "confirm carry"; var carry = $(this).val(); var language = $("input[name=__language]").val(); var mss =(language=="tha")?mssth:mssen; if(carry=="1"){ if(confirm(mss)){ $("#chkcarry").val(carry); $("input[name=__seq]").val("1"); $("input[name='balance_carry']").val($("#balance").val()); $("form:cscform").submit(); }else{ $(this).attr("checked",false); $("#chkcarry").val("0"); $("input[name='__seq']").val("0"); } } }); }); })(jQuery); </script> </head> <body onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')" > <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action="PRU097.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__sysisedit" value=""> <input type="hidden" name="__calendar" value=""> <input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__cmdchild" value=""> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__headMulti" value="<%=request.getParameter("__headMulti")%>"> <input type="hidden" name="__screen" value="SIMEMPL_LOAN"> <input type="hidden"name="__screenpage" value="<%=request.getServletPath()%>"> <input type="hidden" name="__ack" value="<%=request.getParameter("__ack")%>"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__maxrec" value="<%=screen.getTable("SIMEMPL_LOAN").recCount()%>"> <input type="hidden" name="__gorec" value="<%=request.getParameter("__gorec")%>"> <input type="hidden" name ="__employeeid" value="<%=request.getParameter("__employeeid")%>"> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__notNull" value="<%=screen.getRequire()%>"> <input type="hidden" name="__genList" value=""> <input type="hidden" name ="__show" value="<%=chkNull.chkNullString(request.getParameter("__show"))%>"> <input type="hidden" name="__minorkeylist" value="<%=chkNull.chkNullString(request.getParameter("__minorkeylist"))%>"> <input type="hidden" name="__reCalculate" value=""> <input type="hidden" name="__seq" value="0"> <input type="hidden" name="__payseq" value="0.00"> <input type="hidden" name="__pay_status" value=""> <input type="hidden" name="__chkcarry" id="chkcarry" value=""> <input type="hidden" name="__status" id="status" value="<%=chkNull.chkNullString(request.getParameter("__status"))%>"> <script language="javascript">getInputFormatDate();</script> <div align="center"> <table cellspacing="0"> <tr> <td class="header" colspan="2">PRU097,<SCRIPT language="JavaScript">swapLang('Sub Loan Detail');</SCRIPT></td> </tr> <tr > <td> <table cellpadding="0" cellspacing="0"> <tr> <td colspan="2" class="blankspace"></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("contractnoid")%> </td> <td class="columnobject1"> <input type ='text' name="__contractnoid" size="15" value="<%=screen.getDataLabel("contractnoid")%>" onFocus="this.select();" onKeyPress="chkNotThaiChaOnly(this);" onMouseOver="toolTip('เลขที่สัญญา')" > </td> </tr> <% screen.referLangOn(); %> <tr> <td class="columnlabel"><%=screen.getLabel("loantype")%> </td> <td class="columnobject1"><%=screen.getInput("loantype")%><input name="MLOAN_TDESC" type="text" size="40" readOnly value="<%=screen.getDataLabel("mloan","tdesc")%>"> </tr> <% screen.referLangOff(); %> <tr> <td class="columnlabel"><%=screen.getLabel("startdate")%> </td> <td class="columnobject1"><%=screen.getInput("startdate")%> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image109','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__startdate')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image109" width="20" height="20" border="0" align="absmiddle"></a> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("enddate")%> </td> <td class="columnobject1"><%=screen.getInput("enddate")%> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1091','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__enddate')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image1091" width="20" height="20" border="0" align="absmiddle" id="Image1091"></a> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("loanprinciple")%> </td> <td class="columnobject1"><%=screen.getInput("loanprinciple")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("intrate")%> </td> <td class="columnobject1"><%=screen.getInput("intrate")%> %</td> </tr> <% screen.referLangOn(); %> <tr> <td class="columnlabel"><%=screen.getLabel("roundid")%> </td> <td class="columnobject1"><%=screen.getInput("roundid")%><input type ='text' readOnly name="MROUND_TDESC" size="40" value="<%=screen.getDataLabel("MROUND","TDESC")%>"> </td> </tr> <% screen.referLangOff(); %> <tr> <td class="columnlabel"><%=screen.getLabel("caltype")%> </td> <td class="columnobject1"><%=screen.getInput("caltype")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("firstloandate")%> </td> <td class="columnobject1"><%=screen.getInput("firstloandate")%> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1093','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('__firstloandate')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image1093" width="20" height="20" border="0" align="absmiddle" id="Image1093"></a> </td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("cal_cycle")%> </td> <td class="columnobject1"><%=screen.getInput("cal_cycle")%></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("amounttab")%> </td> <td ><%=screen.getInput("amounttab")%><input type ='text' readOnly name="MAMOUNTTAB_TDESC" size="30" value="<%=screen.getDataLabel("MAMOUNTTAB","TDESC")%>"></td> </tr> <tr> <td class="columnlabel"><%=screen.getLabel("obj_loan")%> </td> <td ><%=screen.getInput("obj_loan")%><%//=screen.getInput("loan_every")%></td> </tr> <tr> <td class="columnlabel"><SCRIPT language="JavaScript">swapLang('Status Carry');</SCRIPT> </td> <td > <input name="__carry" onmouseover="toolTip('สถานะยกยอด')" onmouseout="toolTip()" type="checkbox" value="1" class="carry" /> <SCRIPT language="JavaScript">swapLang('Yes Carry');</SCRIPT><input type="text" name="balance_carry" size="7" value="<%=chkNull.chkNullString(request.getParameter("balance_carry"),screen.getDataLabel("mempl_loan1","carry"))%> "readonly> บาท </td> </tr> <tr> <td class="columnlabel">เงินกู้คงค้าง </td> <td ><input type="text" size="7" name="__rate_pay"value="<%=chkNull.chkNullString(request.getParameter("_rate_pay"))%>" disabled> บาท</td> </tr> <tr> <td class="columnlabel"> </td> <td > <button type="button" class="btn btn-primary width100" swlang code="SW013176" onClick="setGenerate();">GENDATA</button></td> </tr> <tr> <td colspan="2" class="blankspace"></td> </tr> <tr> <td colspan="2" class="buttonline" ><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#999999" class="maxsize"> <tr> <td><div align="center"><strong> <SCRIPT language="JavaScript">swapLang('Seq');</SCRIPT> </strong></div></td> <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","loanpaydate")%> </strong></div></td> <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","principle")%> </strong></div></td> <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","interest")%> </strong></div></td> <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","amount")%> </strong></div></td> <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","balance")%> </strong></div></td> <td ><div align="center"><strong><SCRIPT language="JavaScript">swapLang('Pay_status');</SCRIPT> </strong></div></td> <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","pay")%> </strong></div></td> </tr> <% if((request.getParameter("__contractnoid")!=null)&&(screen.getUProfile().getObject("loan"+request.getParameter("__employeeid"))!=null)){ if(!((request.getParameter("__cmdchild")!=null)&&(!request.getParameter("__cmdchild").equals(""))) || chkNull.chkNullString(request.getParameter("__show")).equalsIgnoreCase("show")){ HashMap HAllContract = (HashMap)screen.getUProfile().getObject("loan"+request.getParameter("__employeeid")); DbTable dbTab = (DbTable)HAllContract.get(request.getParameter("__contractnoid")); //out.print("contractnoid = "+request.getParameter("__contractnoid")); dbTab.first(); double amount_pay = 0.00; // int pay = 0; // int amount = 0; for(int i = 0;i<dbTab.recCount();i++){ amount_pay = (dbTab.getDouble("amount")-dbTab.getDouble("pay")); //if(dbTab.getString("contractnoid").equalsIgnoreCase(request.getParameter("__contractnoid"))){ %> <tr> <td><div align="center"><%=dbTab.getString("seq_no")%> </div></td> <td> <div align="center"> <% if(dbTab.getString("pay_status").equals("2")){ if( i == 0 ){ datagenerate(dbTab.getDouble("balance")+dbTab.getDouble("amount")); } out.print("<a href=\"javascript:linkSavePay('PRU097_1','"+dbTab.getString("seq_no")+"','"+dbTab.getDouble("amount")+"','"+dbTab.getString("pay_status")+"');\">"); }%> <%=new CscCalendar(dbTab.getString("loanpaydate")).getDDMMYYYY()%> <%if(dbTab.getString("pay_status").equals("1") && dbTab.getString("pay_status").equals("0")){ out.print("</a>"); } else if(dbTab.getString("pay_status").equals("1")){ data(dbTab.getDouble("balance")); } else if(dbTab.getString("pay_status").equals("3")){ datacarry(0); } %> </div> </td> <td><div align="center"><%=dbTab.getDouble("principle")%> </div></td> <td><div align="center"><%=dbTab.getDouble("interest")%> </div></td> <td><div align="center"><%=dbTab.getDouble("amount")%> </div></td> <td><div align="right"><%=dbTab.getDouble("balance")%> </div></td> <td><div align="center"> <%=dbTab.getCurrentRecordManager().getSystemCode("pay_status")%> <input type="hidden" class="chkCarryAll" value="<%=dbTab.getDouble("pay_status")%>" ></div></div></td> <td><div align="center"><%=dbTab.getDouble("pay")%> </div></td> </tr> <% //} dbTab.next(); } } } else{ dataadd(0); } %> <%! double val; private void data(double a){ this.val = a; } private void datacarry(double a){ this.val = a; } private void datagenerate(double a){ this.val = a; } private void dataadd(double a){ this.val = a; } private double getData(){ return this.val; } %> </table></td> </tr> <tr> <td colspan="2" class="blankspace" > </td> </tr> <tr> <td class="buttonline" colspan="7"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW013169" onClick="setcmd1('save');">OK</button> <button type="button" class="btn btn-primary width100" swlang code="SW013174" onClick="backhead();">BACK</button> </div> </td> </tr> </table> </td> </tr> <tr> <td colspan="2" class="blankspace"></td> </tr> <tr> <td class="bottom"></td> </tr> </table> <input type="hidden" id="balance" name="balance "value="<%=chkNull.chkNullString(request.getParameter("balance"),String.valueOf(getData()))%>"> </div> <script language="javascript">setAfterGen();</script> <!----------BEGIN CSC ENDING ZONE ------------------------> <%=screen.endJSP()%> <!----------END CSC ENDING ZONE --------------------------> </form> </form> <% if((request.getParameter("__cmdchild")!=null)&&(!request.getParameter("__cmdchild").equals(""))){%> <script language="javascript">back();</script> <%}%> <script> $(function(){ $("input[name='__rate_pay']").val($("#balance").val()); }); </script> </body> </html>