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'];