public function addNewSender($_data)
{
$db = $this->getAdapter();
$address = "";
$sender_type = 0;
$acc_no = 0;
if (!empty($_data["address"])) {
$address = $_data["address"];
}
if (!empty($_data["sender_type"])) {
$sender_type = $_data["sender_type"];
}
if (!empty($_data["acc_no"])) {
$acc_no = $_data["acc_no"];
$sql = "SELECT acc_no FROM cs_sender where sender_type=1 AND acc_no='" . $_data["acc_no"] . "' LIMIT 1";
$rs_acc = $db->fetchRow($sql);
if (!empty($rs_acc)) {
$db = new Application_Model_DbTable_DbKbank();
$acc_no = $db->getAccountNumberForKBank();
}
}
$sql = "SELECT sender_name FROM cs_sender where sender_type={$sender_type} AND sender_name='" . $_data["sender_name"] . "' LIMIT 1";
$rs = $db->fetchRow($sql);
if (!empty($rs)) {
return -1;
}
$_arr = array("sender_name" => $_data["sender_name"], "tel" => $_data["sender_tel"], "acc_no" => $acc_no, "address" => $address, "sender_type" => $sender_type);
$id = $this->insert($_arr);
return $id;
}
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 addAction()
{
if ($this->getRequest()->isPost()) {
try {
$data = $this->getRequest()->getPost();
$db = new Application_Model_DbTable_DbKbank();
$db->addWithdrawBySender($data);
Application_Form_FrmMessage::message('ការដកប្រាក់ពីប្រតិបត្តិការនេះដោយជោគជ័យ');
} catch (Exception $e) {
Application_Form_FrmMessage::Sucessfull('ការដកប្រាក់ពីប្រតិបត្តិការនេះបរាជ័យ', self::REDIRECT_URL . '/index/index');
}
}
$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;
$cur = new Application_Model_DbTable_DbCurrencies();
$this->view->invoice_no = Application_Model_GlobalClass::getInvoiceWithdraw();
$db = new Application_Model_DbTable_DbKbank();
$this->view->new_acc = $acc_no = $db->getAccountNumberForKBank();
}
