public function indexAction() { $storage = new Zend_Auth_Storage_Session(); $data = $storage->read(); if (!$data) { $this->_redirect('index/login'); } $path = $this->view->baseUrl(); $receiptsform = new Receipts_Form_Receipts($path); $this->view->form = $receiptsform; $receipts = new Receipts_Model_Receipts(); $mainBranch = $receipts->getHeadOffice(); foreach ($mainBranch as $mainBranch) { $receiptsform->officeType->addMultiOption($mainBranch['id'], $mainBranch['name']); } $glcode = $receipts->listOfglcode(); foreach ($glcode as $glcodes) { $receiptsform->fromglcode->addMultiOption($glcodes['id'], $glcodes['header']); $receiptsform->toglcode->addMultiOption($glcodes['id'], $glcodes['header'] . " -[" . $glcodes['glcode'] . "]"); } $select = $receipts->paymenttype(); foreach ($select as $paymenttype1) { $receiptsform->paymenttype->addMultiOption($paymenttype1['id'], $paymenttype1['description']); } if ($this->_request->isPost() && $this->_request->getPost('Submit')) { $formData = $this->_request->getPost(); if ($this->_request->isPost()) { $paymenttype = $this->view->paymenttype = $this->_request->getParam('paymenttype'); if ($paymenttype == 1 || $paymenttype == "") { $receiptsform->paymenttype_details->setRequired(false); } if ($receiptsform->isValid($formData)) { $branchid = $this->_request->getParam('subOffice1'); $fromglcode = $this->_request->getParam('fromglcode'); $fromglsubcodeid = $this->_request->getParam('glsubcodeid'); $toglcode = $this->_request->getParam('toglcode'); $toglsubcodeid = $this->_request->getParam('toglsubcodeid'); $amount = $this->_request->getParam('amount'); $transactiondate = $this->_request->getParam('transactiondate'); $description = $this->_request->getParam('description'); $paymenttype_details = $this->_request->getParam('paymenttype_details'); $receipts = new Receipts_Model_Receipts(); $fromledgercode = $receipts->listOfledgercode($fromglcode); foreach ($fromledgercode as $fromledgercodes) { $fromledgertype = $fromledgercodes['description']; } $toledgercode = $receipts->listOfledgercode($toglcode); foreach ($toledgercode as $toledgercodes) { $toledgertype = $toledgercodes['description']; } if ($toglsubcodeid == "") { echo "select the to GL code again"; } elseif ($branchid == "") { echo "select the Office type again"; } elseif ($fromglsubcodeid == "") { echo "select the from GL code again"; } else { $sessionName = new Zend_Session_Namespace('ourbank'); $user_id = $sessionName->primaryuserid; $receipts = new Receipts_Model_Receipts(); if ($fromglcode) { if ($fromledgertype == "Income") { $tablenamefrom = "ourbank_Income"; } elseif ($fromledgertype == "Expenditure") { $tablenamefrom = "ourbank_Expenditure"; } elseif ($fromledgertype == "Assets") { $tablenamefrom = "ourbank_Assets"; } elseif ($fromledgertype == "Liabilities") { $tablenamefrom = "ourbank_Liabilities"; } } if ($toledgertype == "Income") { $tablenameto = "ourbank_Income"; } elseif ($toledgertype == "Expenditure") { $tablenameto = "ourbank_Expenditure"; } elseif ($toledgertype == "Assets") { $tablenameto = "ourbank_Assets"; } elseif ($toledgertype == "Liabilities") { $tablenameto = "ourbank_Liabilities"; } $Transactiondata = array('transaction_id' => '', 'account_id' => '', 'glsubcode_id_from' => $fromglsubcodeid, 'glsubcode_id_to' => $toglsubcodeid, 'transaction_date' => $transactiondate, 'amount_to_bank' => $amount, 'amount_from_bank' => '', 'paymenttype_id' => $paymenttype, 'transactiontype_id' => '1', 'recordstatus_id' => '3', 'reffering_vouchernumber' => $paymenttype_details, 'transaction_description' => $description, 'balance' => '', 'confirmation_flag' => '', 'created_by' => $user_id, 'created_date' => date("Y-m-d")); $transaction_id = $receipts->addtransactions($Transactiondata); if ($fromglcode) { $receipts->addfromaccounts($tablenamefrom, $branchid, $fromglsubcodeid, $toglsubcodeid, $transaction_id, $amount); } $receipts->addtoaccounts($tablenameto, $branchid, $fromglsubcodeid, $toglsubcodeid, $transaction_id, $amount); } } } $this->_redirect('transaction'); } // $this->_redirect('transaction'); }
public function indexAction() { $storage = new Zend_Auth_Storage_Session(); $data = $storage->read(); if (!$data) { $this->_redirect('index/login'); } $path = $this->view->baseUrl(); $username = $this->view->username; $receiptsform = new Cashtransactions_Form_Cashtransactions($path); $this->view->form = $receiptsform; $receipts = new Receipts_Model_Receipts(); $receipts = new Receipts_Model_Receipts(); $mainBranch = $receipts->getHeadOffice($this->view->username); //checking the office wrt username foreach ($mainBranch as $mainBranch) { if ($mainBranch) { $branchid = $mainBranch['id']; } } $glcode = $receipts->listOfglcode(); foreach ($glcode as $glcodes) { $receiptsform->toglcode->addMultiOption($glcodes['id'], $glcodes['header'] . " -[" . $glcodes['glcode'] . "]"); } $select = $receipts->paymenttype(); foreach ($select as $paymenttype1) { $receiptsform->paymenttype->addMultiOption($paymenttype1['id'], $paymenttype1['id'] . " -[" . $paymenttype1['description'] . "]"); } if ($this->_request->isPost() && $this->_request->getPost('Submit')) { $formData = $this->_request->getPost(); if ($this->_request->isPost()) { $paymenttype = $this->view->paymenttype = $this->_request->getParam('paymenttype'); if ($paymenttype == 1 || $paymenttype == "") { $receiptsform->paymenttype_details->setRequired(false); } if ($receiptsform->isValid($formData)) { $toglcode = $this->_request->getParam('toglcode'); $toglsubcodeid = $this->_request->getParam('toglsubcodeid'); $amount = $this->_request->getParam('amount'); $transactiondate = $this->_request->getParam('transactiondate'); $description = $this->_request->getParam('description'); $paymenttype_details = $this->_request->getParam('paymenttype_details'); $balance1 = $this->_request->getParam('amount'); $balance2 = $this->_request->getParam('balance2'); $balance = $balance1 + $balance2; $balance = $balance . '.00'; //to display the latest ledger balance after amount is entered $receipts = new Receipts_Model_Receipts(); //get the ledger codes if ($toglcode) { $toledgercode = $receipts->listOfledgercode($toglcode); foreach ($toledgercode as $toledgercodes) { $toledgertype = $toledgercodes['name']; } } $flag = 0; if ($toglsubcodeid == "") { echo "<font color='red'><b> Select the GL code and GL subcode again</b> </font>"; $flag = 1; } else { $sessionName = new Zend_Session_Namespace('ourbank'); $user_id = $sessionName->primaryuserid; $receipts = new Receipts_Model_Receipts(); if ($toledgertype == "Income") { //check the table related to ledger type $tablenameto = "ourbank_Income"; } elseif ($toledgertype == "Expenditure") { $tablenameto = "ourbank_Expenditure"; } elseif ($toledgertype == "Assets") { $tablenameto = "ourbank_Assets"; } elseif ($toledgertype == "Liabilities") { $tablenameto = "ourbank_Liabilities"; } $Transactiondata = array('transaction_id' => '', 'account_id' => '', 'glsubcode_id_from' => '', 'glsubcode_id_to' => $toglsubcodeid, 'transaction_date' => $transactiondate, 'amount_to_bank' => $amount, 'amount_from_bank' => '', 'paymenttype_id' => $paymenttype, 'transactiontype_id' => '1', 'recordstatus_id' => '3', 'reffering_vouchernumber' => $paymenttype_details, 'transaction_description' => $description, 'balance' => $balance, 'confirmation_flag' => '', 'created_by' => $this->view->createdby, 'created_date' => date("Y-m-d")); //echo '<pre>'; print_r($Transactiondata); echo $toglsubcodeid; echo "/"; echo $tablenameto; $transaction_id = $receipts->addtransactions($Transactiondata); $fromglsubcodeid = 0; $receipts->addtoaccounts($tablenameto, $branchid, $fromglsubcodeid, $toglsubcodeid, $transaction_id, $amount); } if ($flag == 0) { $this->_redirect('transaction'); } } } } }