public function loansaddAction()
{
$this->view->title = $this->view->translate("New loan");
$loanForm = new Loans_Form_Loan();
$this->view->form = $loanForm;
$systemDate = $this->view->dateconvert->phpnormalformat(date('Y-m-d'));
$this->view->form->begindate->setValue($systemDate);
$product = new Loans_Model_Product();
$product = $product->fetchAllProductNames();
foreach ($product as $product) {
$loanForm->product_id->addMultiOption($product['id'], $product['name']);
}
$membertype_id1 = $this->view->adm->viewRecord("ourbank_master_membertypes", "id", "DESC");
foreach ($membertype_id1 as $membertype_id) {
$loanForm->applicableto->addMultiOption($membertype_id['id'], $membertype_id['type']);
}
$loan = new Loans_Model_Loan();
// $glsubcode = $loan->fetchAllglsubcode('3');//ledger id for Assets
// foreach($glsubcode as $glsubcode) {
// $loanForm->glsubcode_id->addMultiOption($glsubcode['id'],$glsubcode['header']."[".$glsubcode['glsubcode']."]");
// }
// $glsubcode = $loan->fetchAllglsubcode('2');//ledger id for income 2
// foreach($glsubcode as $glsubcode) {
// $loanForm->fee_glsubcode_id->addMultiOption($glsubcode['id'],$glsubcode['header']."[".$glsubcode['glsubcode']."]");
// $loanForm->interest_glsubcode_id->addMultiOption($glsubcode['id'],$glsubcode['header']."[".$glsubcode['glsubcode']."]");
// }
$interesttype1 = $this->view->adm->viewRecord("ourbank_master_interesttypes", "id", "ASC");
foreach ($interesttype1 as $interesttypes) {
$loanForm->interesttype_id->addMultiOption($interesttypes['id'], $interesttypes['description']);
}
if ($this->_request->isPost() && $this->_request->getPost('Submit')) {
$formData = $this->_request->getPost();
if ($this->_request->isPost()) {
$formData = $this->_request->getPost();
if ($loanForm->isValid($formData)) {
$begindate1 = $this->view->dateconvert->phpmysqlformat($this->_request->getParam('begindate'));
$closedate1 = $this->view->dateconvert->phpmysqlformat($this->_request->getParam('closedate'));
$begindate = $this->_request->getParam('begindate');
$closedate = $this->_request->getParam('closedate');
$minmumloanamount = $this->_request->getParam('minmumloanamount');
$maximunloanamount = $this->_request->getParam('maximunloanamount');
$minimumfrequency = $this->_request->getParam('minimumfrequency');
$maximumfrequency = $this->_request->getParam('maximumfrequency');
if ($begindate1 > $closedate1) {
$this->view->datesinfo = "Closed date must be greater than begining date" . -$begindate;
} elseif ($minmumloanamount > $maximunloanamount) {
$this->view->amounts = "Max amount must be greater than min amount" . -$minmumloanamount;
} elseif ($minimumfrequency > $maximumfrequency) {
$this->view->freequency = "Maximum frequency must be greater than min frequency" . -$minimumfrequency;
} else {
$productdetails = new Loans_Model_Loan();
$headerCon = "A";
$glsubcode = $loan->getGlCode('Loans');
$glcode = $loan->getGlCodeid('Loans');
$glcodeexist = $loan->getGlCodeexist('Loans');
$glco = substr($glcodeexist, 1, 2);
if ($glsubcode) {
$first = substr($glsubcode, 0, 3);
$existcode = substr($glsubcode, 3, 3);
$existcode++;
$last = str_pad($existcode, 3, 0, STR_PAD_LEFT);
$newglsubcode = $first . $last;
} else {
$glcodeId = $headerCon . $glco . "001";
$newglsubcode = $glcodeId;
}
$date = date("y/m/d H:i:s");
$glsubcodeid = $this->view->adm->addRecord('ourbank_glsubcode', array('id' => '', 'glsubcode' => $newglsubcode, 'glcode_id' => $glcode, 'subledger_id' => $glcode, 'header' => $formData['offerproductname'], 'description' => $formData['offerproduct_description'], 'created_date' => $date, 'created_by' => $this->view->createdby));
$result = $productdetails->addProductDetails($formData, $glsubcodeid);
$offerproduct_id = Zend_Db_Table::getDefaultAdapter()->lastInsertId('ourbank_productsoffer', 'id');
$productloandetails = new Loans_Model_Productsloan();
$result = $productloandetails->Addproductsloan($formData, $offerproduct_id);
$From = $this->_request->getParam('from');
$To = $this->_request->getParam('to');
$Rate = $this->_request->getParam('rate');
$period_ofrange_description = $From . -$To;
$interestLoans = new Loans_Model_Interest();
$result = $interestLoans->Addinterestdetails($From, $To, $Rate, $period_ofrange_description, $offerproduct_id);
$memberCount = $this->_request->getParam('memberCount');
for ($i = 1; $i <= $memberCount; $i++) {
$From = $this->_request->getParam('from' . $i);
$To = $this->_request->getParam('to' . $i);
$Rate = $this->_request->getParam('rate' . $i);
$period_ofrange_description = $From . -$To;
if ($From) {
$fMember = $productdetails->insertRow5('ourbank_interest_periods', array('id' => '', 'period_ofrange_monthfrom' => $From, 'period_ofrange_monthto' => $To, 'period_ofrange_description' => $period_ofrange_description, 'offerproduct_id' => $offerproduct_id, 'Interest' => $Rate, 'intereststatus_id' => 3));
}
}
$this->_redirect('/loans/index');
}
}
}
}
}
