function LOAN_TYPE($id = '')
{
global $_CONF;
if ($id) {
$this->data = current(WEBPAGE::$dbh->getAll(sprintf("\r\n select\r\n lt.*, c.currency, c.symbol, CONCAT(uc.first,' ',uc.last) AS creator,\r\n DATE_FORMAT(lt.creator_date,'%s') AS f_creator_date,\r\n\t\t CONCAT(ue.first,' ',ue.last) AS editor,\r\n\t\t DATE_FORMAT(lt.editor_date,'%s') AS f_editor_date\r\n from\r\n tblLoanTypes AS lt, tblCurrencys AS c, tblUsers AS uc, tblUsers AS ue\r\n where\r\n lt.id=%s AND c.id = lt.currency_id AND lt.creator_id = uc.id AND lt.editor_id = ue.id", $_CONF['date_format_mysql'], $_CONF['date_format_mysql'], $id)));
$this->data['rates_e'] = CalEffRate($this->data['rates_r'], $this->data['fees_at'], $this->data['fees_af'], $this->data['installment'], $this->data['calendar_type'], $this->data['payment_frequency']);
} else {
$this->data['creator_date'] = date('Y-m-d');
$this->data['creator_id'] = WEBPAGE::$userID;
$this->frostdata = array();
}
}
private function load_defaults($loanTypeID = '')
{
if ($loanTypeID) {
$ltype = new LOAN_TYPE($loanTypeID);
$this->data['modality'] = $ltype->data['description'];
$this->data['installment'] = $ltype->data['installment'];
$this->data['installment_lock'] = $ltype->data['installment_lock'];
$this->data['payment_frequency'] = $ltype->data['payment_frequency'];
$this->data['calendar_type'] = $ltype->data['calendar_type'];
$this->data['margin_c'] = $ltype->data['margin_c'];
$this->data['margin_c_lock'] = $ltype->data['margin_c_lock'];
$this->data['margin_r'] = $ltype->data['margin_r'];
$this->data['margin_k'] = $ltype->data['margin_k'];
$this->data['margin_d'] = $ltype->data['margin_d'];
$this->data['margin_d_lock'] = $ltype->data['margin_d_lock'];
$this->data['rates_r'] = $ltype->data['rates_r'];
$this->data['rates_r_lock'] = $ltype->data['rates_r_lock'];
$this->data['rates_d'] = $ltype->data['rates_d'];
$this->data['rates_d_lock'] = $ltype->data['rates_d_lock'];
$this->data['fees_at'] = $ltype->data['fees_at'];
$this->data['fees_at_lock'] = $ltype->data['fees_at_lock'];
$this->data['fees_af'] = $ltype->data['fees_af'];
$this->data['fees_af_lock'] = $ltype->data['fees_af_lock'];
$this->data['rates_e'] = round(CalEffRate($this->data['rates_r'], $this->data['fees_at'], $this->data['fees_af'], $this->data['installment'], $this->data['calendar_type'], $this->data['payment_frequency']), 2);
$this->data['borrower_type'] = $ltype->data['borrower_type'];
$this->data['savings_p_lock'] = $ltype->data['savings_p_lock'];
}
}
