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