//function which is triggered when week option is selected from a select tag
function selectWeek(){
var week = $("#week").val();
var tableObjBuilderRow = "";
if(week != ""){
$.post(baseUrl + "admin/getdebtorsbyinspector").done(function(data){
var recordCount = 0; var loanRepayment = ""; var loanSavings = ""; var loanDetails = ""; var dayId = 0; var dayName = ""; var dayDBName = ""; var chkbxId = ""; var accountNumber = ""; var agreementId = "";
var data = $.parseJSON(data);
if(data != "" || data != 0){
//get debtors
for(var i = 0; i < data['row'].length; i++) {
recordCount ++;
tableObjBuilderRow +="<tr>"
tableObjBuilderRow +="<td scope='row'>" + recordCount + "</td>";
accountNumber = data['row'][i].account_number;
agreementId = data['row'][i].transaction_year_advance_agreement_id;
tableObjBuilderRow +="<td>" + accountNumber + "</td>";
tableObjBuilderRow +="<td>" + data['row'][i].fullname + "</td>";
tableObjBuilderRow +="<td>" + data['row'][i].amount + "</td>";
loanSavings = data['row'][i].savings;
loanRepayment = parseInt(data['row'][i].repayment) - parseInt(data['row'][i].savings);
//get debtor's savings
var debtordetails = "account_number=" + accountNumber + "&agreement_id=" + data['row'][i].transaction_year_advance_agreement_id + "&week=" + week;
$.post(baseUrl + "admin/getdebtorssavingsbyinspector", debtordetails).done(function(data1){
var data1 = $.parseJSON(data1);
if(data1 != 0 ){
for(var day = 0; day < 5; day++){
dayDBName = data1['column'][day].dayname;
dayId = getDayId(dayDBName);//this function convert day of the week name to day number
dayName = getDayName(day);//this function convert day of the week number to day name
chkbxId = agreementId + "_" + dayName;
loanDetails = agreementId + "&" + loanSavings + "&" + accountNumber + "&" + day + "&" + week;
tableObjBuilderRow +="<td>[" + loanSavings + "] <input type='checkbox' id='"+ chkbxId + "' name='' value='"+ loanDetails +"' onclick='dailySavings(this)'></td>";
tableObjBuilderRow +="<td>[" + loanRepayment + "] <input type='checkbox' id='' name='' value='"+ loanDetails +"' onclick='dailyRepayment(this)'></td>";
}
}else{
// on error
// alert(data);
}
});
tableObjBuilderRow +="<td id='weeklytotal_" + accountNumber + "'></td>";
tableObjBuilderRow +="</tr>"
}
//last row for column total
tableObjBuilderRow +="<tr>"
tableObjBuilderRow +="<th colspan='3'></th>";
tableObjBuilderRow +="<th style='text-align:center;'>C-Total</th>";
tableObjBuilderRow +="<th id='mon_savings_total'></th>";
tableObjBuilderRow +="<th id='mon_repayment_total'></th>";
tableObjBuilderRow +="<th id='tue_savings_total'></th>";
tableObjBuilderRow +="<th id='tue_repayment_total'></th>";
tableObjBuilderRow +="<th id='wed_savings_total'></th>";
tableObjBuilderRow +="<th id='wed_repayment_total'></th>";
tableObjBuilderRow +="<th id='thur_savings_total'></th>";
tableObjBuilderRow +="<th id='thur_repayment_total'></th>";
tableObjBuilderRow +="<th id='fri_savings_total'></th>";
tableObjBuilderRow +="<th id='fri_repayment_total'></th>";
tableObjBuilderRow +="</tr>"
$("#tbl_loan_debtor").html(tableObjBuilderRow);
}else{
// alert(data);
}
});
}
}