function insertMoneyTransfer($data) { $percent = empty($data['percent']) ? 0 : $data['percent']; $send_date = $data['send_date'] . ' ' . date('h:i:s'); $exp_date = $data['epx_date'] . ' ' . date('h:i:s'); $session_user = new Zend_Session_Namespace('auth'); $db = $this->getAdapter(); $db->beginTransaction(); try { $agent_id = $data['agent_id']; $_data = array('sender_name' => $data['sender'], 'reciever_name' => $data['reciever'], 'reciever_tel' => $data['reciever_tel'], 'invoice_no' => $data['invoice_no'], 'amount' => $data['amount'], 'amount_type' => $data['type_money'], 'commission' => empty($data['commission']) ? 0 : $data['commission'], 'commission_type' => $data['type_money'], 'commission_percent' => $percent, 'commission_agent' => $data['commission_agent'], 'recieved' => $data['recieve_money'], 'recieved_type' => $data['type_money'], 'status' => $data['tran_type'] == 0 ? 0 : 2, 'status_loan' => empty($data['loan']) ? 0 : $data['loan'], 'cut_service' => empty($data['minus']) ? 0 : $data['minus'], 'agent_id' => $agent_id, 'subagent_id' => empty($data['sub_agent_id']) ? 0 : $data['sub_agent_id'], 'send_date' => $send_date, 'expire_date' => $exp_date, 'transfer_money' => $data['gave'], 'total_money' => $data['total'], 'return_money' => $data['return_money'], 'tran_type' => $data['tran_type'], 'is_kbank' => empty($data['is_kbank']) ? 0 : $data['is_kbank'], 'user_id' => $session_user->user_id); $tran_no = $this->insert($_data); $db_sender = new Application_Model_DbTable_DbKbank(); $sender_id = $db_sender->getSenderIdbyName($data['sender']); // $db_rate=new Application_Model_DbTable_DbRate(); // $rate = $db_rate->getCurrentRate(); $_data['sender_name'] = $sender_id; $_data['exchange_rate_db'] = $data['BD']; $_data['exchange_rate_dr'] = $data['RD']; $_data['exchange_rate_rb'] = $data['RB']; $_data['is_orgdebt'] = 1; $db_cap = new Application_Model_DbTable_DbCapital(); //for data capital if (!empty($data['loan'])) { //IF DEBT $this->_name = "cs_transactions_owe"; $_data['money_tran_id'] = $tran_no; $_data['rate_perday'] = $data['rate_perday']; $money_type = 1; if ($data['type_money'] == 1) { $total_debt = $data['total'] + $data['debt_dollar']; } elseif ($data['type_money'] == 2) { $total_debt = $data['total'] + $data['debt_bath']; $money_type = 2; } else { $total_debt = $data['total'] + $data['debt_khmer']; $money_type = 3; } $this->updateStatustoPaid($sender_id, $money_type); //update old tran debt to paid below add new debt $_data['total_money_owe'] = $total_debt; unset($_data['return_money']); unset($_data['is_kbank']); $this->insert($_data); if ($data['tran_type'] == 0) { //debt with tran type = transfer $amount = $data['total']; } else { $amount = -$data['total']; //យើងអស់លុយប៉ុន្តែយើងជំពាក់គេ } $income = 0; // $tran_type=7;//remain debt before pls ckeck condition ; $tran_type = 2; //remain debt ; } else { //add owe if money kbank differ money transfer $_data['money_tran_id'] = $tran_no; $_data['rate_perday'] = $data['rate_perday']; $_data['total_money_owe'] = $data['total']; $_data['status_loan'] = 1; unset($_data['return_money']); // if($data['tran_type'] == 0){//with tran type = transfer // $amount = $data['total']; // }else{ // $amount = -$data['total'];//វេចូល // } // $income = 1; if ($data['tran_type'] == 0) { //with tran type = transfer $amount = $data['total']; } else { $amount = -$data['total']; //វេចូល } // for add withdraw to send if sender use kbank account if (!empty($data['is_kbank'])) { if ($data['type_money'] == 1 and empty($data['debt_dollar'])) { //if kbank no money for transfer $this->AddOweTransationBysender($_data); } elseif ($data['type_money'] == 2 and empty($data['debt_bath'])) { $this->AddOweTransationBysender($_data); } elseif ($data['type_money'] == 3 and empty($data['debt_khmer'])) { $this->AddOweTransationBysender($_data); } $w_dollar = 0; $w_bath = 0; $w_riel = 0; $b_dollar = 0; $b_bath = 0; $b_riel = 0; $invoice = Application_Model_GlobalClass::getInvoiceWithdraw(); $db_draw = new Application_Model_DbTable_DbKbank(); $sender_id = $db_draw->getSenderIdbyName($data['sender']); //covert sender name to sender id $remain_from_kbank = 0; $total_withdraw = $data['total']; if ($data['type_money'] == 1) { $w_dollar = $data['total']; $remain_from_kbank = $data['debt_dollar'] - $data['total']; if ($data['debt_dollar'] < $data['total']) { $w_dollar = $data['debt_dollar']; $total_withdraw = $w_dollar; } } elseif ($data['type_money'] == 2) { $w_bath = $data['total']; $remain_from_kbank = $data['debt_bath'] - $data['total']; if ($data['debt_bath'] < $data['total']) { $w_bath = $data['debt_bath']; $total_withdraw = $w_bath; } } else { $w_riel = $data['total']; $remain_from_kbank = $data['debt_khmer'] - $data['total']; if ($data['debt_khmer'] < $data['total']) { $w_riel = $data['debt_khmer']; $total_withdraw = $w_riel; } } ///if transfer more thand money in kbank so we add this send dept if ($remain_from_kbank < 0) { $_data['total_money_owe'] = -$remain_from_kbank; //if money tranfer larg than money in kbank $debt_id = $this->AddOweTransationBysender($_data); $arr = array('tran_id' => $tran_no, 'tran_type' => 8, 'curr_type' => $data['type_money'], 'amount' => -$remain_from_kbank, 'user_id' => $session_user->user_id, 'income' => 0); $ass = $db_cap->addMoneyToCapitalDetail($arr); } //if money have in account kbank if (!empty($data['debt_dollar'])) { $b_dollar = $data['debt_dollar']; } if (!empty($data['debt_bath'])) { $b_bath = $data['debt_bath']; } if (!empty($data['debt_khmer'])) { $b_riel = $data['debt_khmer']; } // $amount = 0; if ($b_dollar > 0 or $b_bath or $b_riel > 0) { $_arr = array('sender' => $sender_id, 'invoice_no' => $invoice, 'withdraw_dollar' => $w_dollar, 'withdraw_bath' => $w_bath, 'withdraw_riel' => $w_riel, 'debt_dollar' => $b_dollar, 'debt_bath' => $b_bath, 'debt_riel' => $b_riel, 'send_date' => $data['send_date']); $db_draw->addWithdrawBySendName($_arr); $tran_no = $db->lastInsertId(); $arr = array('tran_id' => $tran_no, 'tran_type' => 7, 'curr_type' => $data['type_money'], 'amount' => -$total_withdraw, 'user_id' => $session_user->user_id, 'income' => 0); $ass = $db_cap->addMoneyToCapitalDetail($arr); } $income = 0; // if($data['tran_type'] == 0){//with tran type = transfer // $amount = $data['total']; // }else{ // $amount = -$data['total'];//វេចូល // } } else { // if($data['tran_type'] == 0){//with tran type = transfer // $amount = $data['total']; // }else{ // $amount = -$data['total'];//វេចូល // } $income = 1; ///update date current capital if get money from sender//////////////////// $rs = $db_cap->DetechCapitalExist($session_user->user_id, $data['type_money']); if (!empty($rs)) { //update new user $arr = array('amount' => $rs['amount'] + $amount); $db_cap->updateCurrentBalanceById($rs['id'], $arr); } else { $date = date("Y-m-d H:i:s"); //change it to current edit $arr = array('amount' => $amount, 'currencyType' => $data['type_money'], 'userid' => $session_user->user_id, 'statusDate' => $date); $db_cap->AddCurrentBalanceById($arr); } } $tran_type = 2; //transfer } ////for add capital detail $date = date("Y-m-d H:i:s"); //change it to current edit $arr = array('tran_id' => $tran_no, 'tran_type' => $tran_type, 'curr_type' => $data['type_money'], 'amount' => $amount, 'user_id' => $session_user->user_id, 'income' => $income); $ass = $db_cap->addMoneyToCapitalDetail($arr); return $db->commit(); } catch (Exception $e) { $db->rollBack(); // echo 1111; // echo $e->getMessage();exit(); } }
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(); }
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 addAction() { if ($this->getRequest()->isPost()) { try { $data = $this->getRequest()->getPost(); $db = new Application_Model_DbTable_DbCustomerLoan(); $db->AddNewTranLoan($data); Application_Form_FrmMessage::message('ការបញ្ចូលប្រតិបត្តិការដោយជោគជ័យ'); } catch (Exception $e) { echo $e->getMessage(); exit; 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(2); array_unshift($_sender, array('id' => '-1', "name" => "បន្ថែមឈ្មោះអ្នកផ្ញើរ", 'tel' => '')); $this->view->sender = $_sender; $cur = new Application_Model_DbTable_DbCurrencies(); $this->view->invoice_no = Application_Model_GlobalClass::getInvoiceWithdraw(5); $db_rate = new Application_Model_DbTable_DbRate(); $this->view->rate = $db_rate->getCurrentRate(); $cur = new Application_Model_DbTable_DbCurrencies(); $this->view->currency = $cur->getCurrencyList(); }