public function rptWithdrawAction() { // action body try { $this->view->from_date = date('Y-m-d'); $this->view->to_date = date('Y-m-d'); $money_type = -1; if ($this->getRequest()->isPost()) { $formdata = $this->getRequest()->getPost(); $this->view->selected = $formdata['sender_name']; $this->view->type_money = $formdata['type_money']; $this->view->from_date = $formdata['from_date']; $this->view->to_date = $formdata['to_date']; $this->view->txtsearch = $formdata['txt_search']; $money_type = $formdata['type_money']; } else { $this->view->selected = -1; $formdata = array('sender_name' => -1); $formdata = array('txt_search' => '', 'tran_type' => -1, 'from_date' => date('Y-m-d'), 'to_date' => date('Y-m-d'), 'type_money' => -1, 'sender_name' => -1); } $db_tran = new Application_Model_DbTable_DbKbank(); $rows = $db_tran->getRptWithdrawKbank($formdata); $key = 0; foreach ($rows as $index => $value) { $dollar_exist = (int) $value['wd_amountdollar']; $bath_exist = (int) $value['wd_amountbath']; $riel_exist = (int) $value['wd_amountriel']; if (!empty($dollar_exist) and ($money_type == 1 or $money_type == -1)) { $rs[$key] = $this->addWithDrawRecord($key, $value); $rs[$key]['before_amount'] = $value['dollar_before']; $rs[$key]['w_amount'] = $value['wd_amountdollar']; $rs[$key]['money_type'] = 1; $key++; } if (!empty($bath_exist) and ($money_type == 2 or $money_type == -1)) { $rs[$key] = $this->addWithDrawRecord($key, $value); $rs[$key]['before_amount'] = $value['bath_before']; $rs[$key]['w_amount'] = $value['wd_amountbath']; $rs[$key]['money_type'] = 2; $key++; } if (!empty($riel_exist) and ($money_type == 3 or $money_type == -1)) { $rs[$key] = $this->addWithDrawRecord($key, $value); $rs[$key]['before_amount'] = $value['riel_before']; $rs[$key]['w_amount'] = $value['wd_amountriel']; $rs[$key]['money_type'] = 3; $key++; } } $this->view->money_type = $this->money_type; $cur = new Application_Model_DbTable_DbCurrencies(); $this->view->currencylist = $cur->getCurrencyList(); $sender = new Application_Model_DbTable_DbSender(); $_sender = $sender->getAllSenderKbank(); array_unshift($_sender, array('id' => '-1', "name" => "ជ្រើសរើសឈ្មោះអ្នកផ្ញើរ")); $this->view->senderlist = $_sender; if (empty($rs)) { $rs = array('err' => 1, 'msg' => 'មិនទាន់មានទន្និន័យនូវឡើយទេ!'); } $this->view->depositlist = $rs; } catch (Exception $e) { $this->view->msg = "ការផ្លាស់ប្តូរមិនជោគជ័យ"; } }
public function extendDateAction() { $tr_id = $this->getRequest()->getParam('tr_id'); $tr_id = empty($tr_id) ? 0 : $tr_id; if ($this->getRequest()->isPost()) { try { $data = $this->getRequest()->getPost(); $db = new Application_Model_DbTable_DbKbank(); $db->extendDateByTran($data); Application_Form_FrmMessage::Sucessfull('ការពន្យាពេលប្រតិបត្តិការនេះជោគជ័យ', self::REDIRECT_URL . '/index/index'); } catch (Exception $e) { Application_Form_FrmMessage::Sucessfull('ការពន្យាពេលប្រតិបត្តិការនេះបរាជ័យ', self::REDIRECT_URL . '/index/index'); } } if (empty($tr_id)) { Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/index/index'); } $db = new Application_Model_DbTable_DbKbank(); $rs = $db->getTranKbankById($tr_id); if (empty($rs)) { Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/index/index'); } $this->view->rs = $rs; $session_user = new Zend_Session_Namespace('auth'); $this->view->user_name = $session_user->last_name . ' ' . $session_user->first_name; $db_keycode = new Application_Model_DbTable_DbKeycode(); $this->view->keycode = $db_keycode->getKeyCodeMiniInv(); $pro = new Application_Model_DbTable_DbProvinces(); $provinces = $pro->getProvinceList(); array_unshift($provinces, array('id' => '0', "name" => "ជ្រើសរើសខេត្តដកប្រាក់", 'num' => 0)); $this->view->provinces = $provinces; $subagent = new Application_Model_DbTable_DbSubAgent(); $this->view->subagent = $subagent->getSubAgentListSelectTrns(); $agent = new Application_Model_DbTable_DbAgents(); $this->view->agent = $agent->getAgentListSelectTrns(); $sender = new Application_Model_DbTable_DbSender(); $_sender = $sender->getAllSenderKbank(); array_unshift($_sender, array('id' => '-1', "name" => "បន្ថែមឈ្មោះអ្នកផ្ញើរ")); $this->view->sender = $_sender; $cur = new Application_Model_DbTable_DbCurrencies(); $this->view->currency = $cur->getCurrencyList(); $this->view->pay_term = $this->pay_term; $this->view->invoice_no = Application_Model_GlobalClass::getInvoiceWithdraw(2); $db = new Application_Model_DbTable_DbKbank(); $this->view->new_acc = $acc_no = $db->getAccountNumberForKBank(); }
public function selectAction() { if ($this->getRequest()->isPost()) { $_data = $this->getRequest()->getPost(); //print_r($_data);exit(); try { $_dbmodel = new Application_Model_DbTable_DbPayment(); $_dbmodel->addTransFound($_data); Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', "/payment/index/index"); } catch (Exception $e) { echo $e->getMessage(); exit; $this->view->msg = 'ការបញ្ចូលមិនជោគជ័យ'; } } $this->view->invoice_no = Application_Model_GlobalClass::getInvoiceWithdraw(4); $sender = new Application_Model_DbTable_DbSender(); $this->view->senderlist = $sender->getAllSenderNameOwe(); $db_keycode = new Application_Model_DbTable_DbKeycode(); $this->view->keycode = $db_keycode->getKeyCodeMiniInv(); $session_user = new Zend_Session_Namespace('auth'); $this->view->user_name = $session_user->last_name . ' ' . $session_user->first_name; $cur = new Application_Model_DbTable_DbCurrencies(); $currency = $cur->getCurrencyList(); $this->view->currency = $this->_helpfilteroption($currency); $curr = $this->_helpfilteroption($currency); array_unshift($curr, array('id' => '-1', "name" => "សងប្រភេទប្រាក់ផ្សេង", 'symbol' => 'other')); $this->view->pay_currencytype = $curr; $db_rate = new Application_Model_DbTable_DbPayment(); $this->view->rate = $db_rate->getRateAll(); }
public function editedAction() { $tr_id = $this->getRequest()->getParam('tr_id'); $tr_id = empty($tr_id) ? 0 : $tr_id; if ($this->getRequest()->isPost()) { try { $data = $this->getRequest()->getPost(); $db = new Application_Model_DbTable_DbKbank(); $db->editWithDrawById($data); Application_Form_FrmMessage::Sucessfull('ការកែប្រែប្រតិបត្តិការនេះជោគជ័យ', self::REDIRECT_URL . '/withdraw/index'); } catch (Exception $e) { Application_Form_FrmMessage::Sucessfull('ការកែប្រែប្រតិបត្តិការនេះបរាជ័យ', self::REDIRECT_URL . '/withdraw/index'); } } $db = new Application_Model_DbTable_DbKbank(); $rs = $db->getTranWithDrawById($tr_id); if (empty($rs)) { Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL . '/index/index'); } $this->view->rs = $rs; $session_user = new Zend_Session_Namespace('auth'); $this->view->user_name = $session_user->last_name . ' ' . $session_user->first_name; $db_keycode = new Application_Model_DbTable_DbKeycode(); $this->view->keycode = $db_keycode->getKeyCodeMiniInv(); $sender = new Application_Model_DbTable_DbSender(); $_sender = $sender->getAllSenderKbank(); $this->view->sender = $_sender; }
public function viewAction() { $id = $this->getRequest()->getParam("id"); if ($this->getRequest()->isPost()) { //if have post = delete $_data = $this->getRequest()->getPost(); try { $_dbmodel = new Application_Model_DbTable_DbPayout(); $_data["id"] = $id; $_dbmodel->deletePayout($_data); Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', "/loan/payout/index"); } catch (Exception $e) { echo $e->getMessage(); exit; $this->view->msg = 'ការបញ្ចូលមិនជោគជ័យ'; } } $sender = new Application_Model_DbTable_DbSender(); $this->view->senderlist = $sender->getAllSenderNameOweAll(); $_dbmodel = new Application_Model_DbTable_DbPayout(); $row = $_dbmodel->getPayoutbyInvoice($id); $this->view->edite_found = $row; $this->view->po_invoice_no = $row['po_invoice_no']; $db_keycode = new Application_Model_DbTable_DbKeycode(); $this->view->keycode = $db_keycode->getKeyCodeMiniInv(); $session_user = new Zend_Session_Namespace('auth'); $this->view->user_name = $session_user->last_name . ' ' . $session_user->first_name; }
public function editedAction() { $tr_id = $this->getRequest()->getParam('tr_id'); $tr_id = empty($tr_id) ? 0 : $tr_id; $db = new Application_Model_DbTable_DbCustomerLoan(); if ($this->getRequest()->isPost()) { try { $data = $this->getRequest()->getPost(); $db->updateTranLoanById($data); Application_Form_FrmMessage::Sucessfull('ការកែប្រែប្រតិបត្តិការនេះជោគជ័យ', self::REDIRECT_URL); } catch (Exception $e) { echo $e->getMessage(); exit; Application_Form_FrmMessage::Sucessfull('ការកែប្រែប្រតិបត្តិការនេះបរាជ័យ', self::REDIRECT_URL); } } $rs = $db->getTranLaonById($tr_id); if (empty($rs)) { Application_Form_FrmMessage::Sucessfull('មិនអាចទាញយកទិន្នន័យមកកែប្រែបានទេ ', self::REDIRECT_URL . '/index/index'); } $this->view->rs = $rs; $result = array(); $db_tran = new Application_Model_DbTable_DbCustomerLoan(); $rows = $db_tran->getBorrowDetail($tr_id); $result = array('amount_dollar' => '', 'rate_dollar' => '', 'amount_bath' => '', 'rate_bath' => '', 'amount_riel' => '', 'rate_riel' => ''); foreach ($rows as $key => $rs) { if ($rs['currency_type'] == 1) { $result['amount_dollar'] = $rs['loan_amount']; $result['rate_dollar'] = $rs['laon_rate']; } elseif ($rs['currency_type'] == 2) { $result['amount_bath'] = $rs['loan_amount']; $result['rate_bath'] = $rs['laon_rate']; } else { $result['amount_riel'] = $rs['loan_amount']; $result['rate_riel'] = $rs['laon_rate']; } } $this->view->row = $result; // print_r($result); $session_user = new Zend_Session_Namespace('auth'); $this->view->user_name = $session_user->last_name . ' ' . $session_user->first_name; $db_keycode = new Application_Model_DbTable_DbKeycode(); $this->view->keycode = $db_keycode->getKeyCodeMiniInv(); $sender = new Application_Model_DbTable_DbSender(); $_sender = $sender->getAllSenderKbank(2); $this->view->sender = $_sender; $db_rate = new Application_Model_DbTable_DbRate(); $this->view->rate = $db_rate->getCurrentRate(); $cur = new Application_Model_DbTable_DbCurrencies(); $this->view->currency = $cur->getCurrencyList(); }