<%@ 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")%>&nbsp;</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")%>&nbsp;</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")%>&nbsp;</td>
              <td  class="columnobject1"><%=screen.getInput("startdate")%>&nbsp;&nbsp;<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")%>&nbsp;</td>
              <td  class="columnobject1"><%=screen.getInput("enddate")%>&nbsp;&nbsp;<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")%>&nbsp;</td>
              <td  class="columnobject1"><%=screen.getInput("loanprinciple")%></td>
            </tr>
            <tr>
              <td class="columnlabel"><%=screen.getLabel("intrate")%>&nbsp;</td>
              <td  class="columnobject1"><%=screen.getInput("intrate")%>&nbsp;%</td>
            </tr>
			  <% screen.referLangOn(); %>
              <tr> 
                <td class="columnlabel"><%=screen.getLabel("roundid")%>&nbsp;</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")%>&nbsp;</td>
                <td class="columnobject1"><%=screen.getInput("caltype")%></td>
              </tr>
			<tr>
              <td class="columnlabel"><%=screen.getLabel("firstloandate")%>&nbsp;</td>
              <td  class="columnobject1"><%=screen.getInput("firstloandate")%>&nbsp;&nbsp;<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")%>&nbsp;</td>
                <td class="columnobject1"><%=screen.getInput("cal_cycle")%></td>
            </tr>
			<tr> 
                <td class="columnlabel"><%=screen.getLabel("amounttab")%>&nbsp;</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")%>&nbsp;</td>
                <td ><%=screen.getInput("obj_loan")%><%//=screen.getInput("loan_every")%></td>
            </tr>
			<tr> 
                <td class="columnlabel"><SCRIPT language="JavaScript">swapLang('Status Carry');</SCRIPT>&nbsp;</td>
                <td >&nbsp;&nbsp;<input name="__carry" onmouseover="toolTip('สถานะยกยอด')" onmouseout="toolTip()" type="checkbox" value="1"  class="carry" />&nbsp;<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>&nbspบาท
				</td>
            </tr>

			<tr> 
                <td class="columnlabel">เงินกู้คงค้าง&nbsp;</td>
                <td ><input type="text" size="7" name="__rate_pay"value="<%=chkNull.chkNullString(request.getParameter("_rate_pay"))%>" disabled>&nbspบาท</td>
            </tr>
            <tr>
                <td class="columnlabel">&nbsp;</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")%>&nbsp;</strong></div></td>
                  <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","principle")%>&nbsp;</strong></div></td>
                  <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","interest")%>&nbsp;</strong></div></td>
                  <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","amount")%>&nbsp;</strong></div></td>
                  <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","balance")%>&nbsp;</strong></div></td>
                  <td ><div align="center"><strong><SCRIPT language="JavaScript">swapLang('Pay_status');</SCRIPT>&nbsp;</strong></div></td>
                  <td ><div align="center"><strong><%=screen.getLabel("mempl_loan1","pay")%>&nbsp;</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")%>&nbsp;</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);
					   }
					   %>&nbsp;
					</div>
				   </td>
                  <td><div align="center"><%=dbTab.getDouble("principle")%>&nbsp;</div></td>
                  <td><div align="center"><%=dbTab.getDouble("interest")%>&nbsp;</div></td>
                  <td><div align="center"><%=dbTab.getDouble("amount")%>&nbsp;</div></td>
                  <td><div align="right"><%=dbTab.getDouble("balance")%>&nbsp;</div></td>
                  <td><div align="center">
				<%=dbTab.getCurrentRecordManager().getSystemCode("pay_status")%>&nbsp;<input type="hidden" class="chkCarryAll" value="<%=dbTab.getDouble("pay_status")%>" ></div></div></td>
				  <td><div align="center"><%=dbTab.getDouble("pay")%>&nbsp;</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"  >&nbsp;</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>&nbsp;
								<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>