public function init() { $this->view->pageTitle = "Loans"; $storage = new Zend_Auth_Storage_Session(); $data = $storage->read(); if (!$data) { $this->_redirect('index/login'); // once session get expired it will redirect to Login page } $sessionName = new Zend_Session_Namespace('ourbank'); $userid = $this->view->createdby = $sessionName->primaryuserid; // get the stored session id $login = new App_Model_Users(); $loginname = $login->username($userid); foreach ($loginname as $loginname) { $this->view->username = $loginname['username']; // get the user name } $this->view->adm = new App_Model_Adm(); $this->view->dateconvert = new App_Model_dateConvertor(); $dbobj = new Loans_Model_Loan(); $glcodevalues = $dbobj->getAllGlcode(); $name = array('loan'); $saving = "not exist"; foreach ($glcodevalues as $glcodes) { if (in_array($glcodes->header, $name)) { $saving = "exist"; } } $desc = array('for loan'); if ($saving == "not exist") { for ($i = 0; $i < 1; $i++) { $Ledgertypeid = $this->view->adm->getsingleRecord('ourbank_master_ledgertypes', 'id', 'name', 'Assets'); // Get id for Liability $generateGl = $dbobj->generateGlCode($Ledgertypeid); // get Maximum value for particular ledger $glCode = $generateGl->id; $result = $this->view->adm->getRecord('ourbank_master_ledgertypes', 'id', $Ledgertypeid); // Get id for Liability foreach ($result as $result1) { $headerCon = substr($result1['name'], 0, 1); } if ($glCode) { $fetchGlcode = $this->view->adm->getsingleRecord('ourbank_glcode', 'glcode', 'id', $glCode); // Get glcode $glCode = substr($fetchGlcode, 1, 2); $glcodeId = str_pad($headerCon . str_pad($glCode + 1, 2, 0, STR_PAD_LEFT), 8 - strlen($glCode), "0"); $glcode = $glcodeId; } else { $glcodeId = str_pad($headerCon . "01", 6, "0"); $glcode = $glcodeId; } $dbobj->insertGlcode(array('id' => '', 'glcode' => $glcode, 'ledgertype_id' => $Ledgertypeid, 'header' => $name[$i], 'description' => $desc[$i], 'created_date' => date("Y-m-d"), 'created_by' => $this->view->createdby)); } } }