function getTemplateData($id)
{
global $_LABELS;
global $_CONF;
$loan = new LOAN($id);
$loan->load_borrower($loan->data['client_id']);
$data = $loan->data;
$data['status_controls'] = $loan->status_controls();
if ($loan->survey_check()) {
$data['survey'] = $_LABELS['results'];
$data['href_survey'] = sprintf('index.php?scr_name=SV.SCR.viewGraph&client_id=%s&survey_id=%s', $loan->data['client_id'], $_CONF['survey_id']);
} else {
$data['survey'] = $_LABELS['applySurvey'];
$data['href_survey'] = sprintf('index.php?scr_name=SV.SCR.applySurveyStepB&loan_id=%s&client_id=%s&id=%s', $loan->data['id'], $loan->data['client_id'], $_CONF['survey_id']);
}
$c = 0;
if (!$loan->isFrost()) {
$data['buttondata'][$c]['id'] = "LN.SCR.addILoan";
$data['buttondata'][$c]['href'] = "index.php?scr_name=LN.SCR.addILoan&ref=LN.SCR.requestILoan&id=" . $id;
$data['buttondata'][$c]['alt'] = $_LABELS['edit'];
$data['buttondata'][$c]['onClick'] = "";
$data['buttondata'][$c]['ico'] = "edit";
$c++;
}
$data['buttondata'][$c]['id'] = "LN.SCR.viewLoanMaster";
$data['buttondata'][$c]['href'] = sprintf('index.php?scr_name=LN.SCR.viewLoanMaster&id=%s', $data['master_id']);
$data['buttondata'][$c]['alt'] = $_LABELS['LN.SCR.viewLoanMaster'];
$data['buttondata'][$c]['onClick'] = "";
$data['buttondata'][$c]['ico'] = "view";
$c++;
if ($loan->data['status'] == 'G') {
$data['buttondata'][$c]['id'] = "LN.SCR.addPayment";
$data['buttondata'][$c]['href'] = 'javascript:openWin("index.popup.php?scr_name=LN.SCR.addPayment&ref=LN.SCR.viewILoan&id=' . $id . '","addPayment","menubar=no,scrollbars=yes,resizable=yes,width=700,height=320")';
$data['buttondata'][$c]['alt'] = $_LABELS['LN.SCR.addPayment'];
$data['buttondata'][$c]['onClick'] = "";
$data['buttondata'][$c]['ico'] = "money_payment";
$c++;
}
if ($loan->data['status'] == 'G') {
$data['buttondata'][$c]['id'] = "LN.SCR.addPaymentFull";
$data['buttondata'][$c]['href'] = 'javascript:openWin("index.popup.php?scr_name=LN.SCR.addPaymentFull&id=' . $id . '","addPayment","menubar=no,scrollbars=yes,resizable=yes,width=700,height=320")';
$data['buttondata'][$c]['alt'] = $_LABELS['LN.SCR.addPaymentFull'];
$data['buttondata'][$c]['onClick'] = "";
$data['buttondata'][$c]['ico'] = "money_payment_full";
$c++;
}
$data['buttondata'][$c]['id'] = "LN.SCR.pmtPlan";
$data['buttondata'][$c]['href'] = 'javascript:openWin("index.popup.php?scr_name=LN.SCR.pmtPlan&ref=LN.SCR.viewILoan&id=' . $id . '","pmtPlan","menubar=no,scrollbars=yes,resizable=yes,width=700,height=320")';
$data['buttondata'][$c]['alt'] = $_LABELS['LN.SCR.pmtPlan'];
$data['buttondata'][$c]['onClick'] = "";
$data['buttondata'][$c]['ico'] = "money_plan";
$c++;
$data['buttondata'][$c]['id'] = "LN.RPT.loanStatusHistory";
$data['buttondata'][$c]['href'] = 'javascript:openWin("index.popup.php?scr_name=LN.RPT.loanStatusHistory&ref=LN.SCR.viewILoan&id=' . $id . '","ClientIOM","menubar=no,scrollbars=yes,resizable=yes,width=700,height=320")';
$data['buttondata'][$c]['alt'] = $_LABELS['statusHistory'];
$data['buttondata'][$c]['onClick'] = "";
$data['buttondata'][$c]['ico'] = "money_history";
$c++;
return $data;
}
$data['riskB'] = max(0, $dataB[$val['zone_id']][$val['program_id']][$val['advisor_id']]);
$data['riskC'] = max(0, $dataC[$val['zone_id']][$val['program_id']][$val['advisor_id']]);
$data['riskD'] = max(0, $dataD[$val['zone_id']][$val['program_id']][$val['advisor_id']]);
WEBPAGE::$dbh->query(sprintf("insert into tblRiskPortfolio (date,zone_id,program_id,advisor_id,balance,riskA,riskB,riskC,riskD) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s')", $p_date, $val['zone_id'], $val['program_id'], $val['advisor_id'], $val['kp'], $data['riskA'], $data['riskB'], $data['riskC'], $data['riskD']));
}
//require 'index.cron.delinquency.inc';
//actualiza cartera en atraso
$dloans = WEBPAGE::$dbh->getAll("select loan_id from tblLoansCurrentData where cn_delay > 0");
require_once 'Date.php';
require_once './includes/LN.LIB.functions.inc';
require_once 'class/loan_type.php';
require_once 'class/loan.php';
$c = 0;
$ldata = array();
foreach ($dloans as $key => $val) {
$loan = new LOAN($val['loan_id']);
$balance_kp = $loan->data['balance_kp'];
$hits = 0;
while ($loan->data['xp_pmt_date'] <= $loan->data['cn_date'] && $balance_kp > 0) {
$data = $loan->getNextPaymentData();
$loan->data['xp_pmt_date'] = $data['xp_pmt_date'];
$loan->data['xp_pmt'] = $data['xp_pmt'];
$loan->data['balance_kp'] = $data['balance_kp'];
$loan->data['balance_kaf'] = $data['balance_kaf'];
$loan->data['balance_kat'] = $data['balance_kat'];
$loan->data['r_from_date'] = $data['r_from_date'];
$ldata[$c]['fees'] += $data['fees'];
$ldata[$c]['insurances'] += $data['insurances'];
$ldata[$c]['principal'] += $data['principal'];
$ldata[$c]['interest'] += $data['interest'];
$ldata[$c]['delay'] += $data['delay'];
