<%@ 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>