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();
}
