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 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 = "ការផ្លាស់ប្តូរមិនជោគជ័យ";
}
}
function updateMoneyTransfer($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');
$rec_date = $data['status'] == 0 ? null : date('Y-m-d h:i:s');
$session_user = new Zend_Session_Namespace('auth');
$mt_id = $data['id'];
$old_data = $this->getTransactionDetailByID($mt_id);
// print_r($old_data); exit;
$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['status'], '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, 'recieved_date' => $rec_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);
$where = $this->getAdapter()->quoteInto('id=?', $mt_id);
$this->update($_data, $where);
$this->_name = "cs_transactions_owe";
$_data['total_money_owe'] = $data['total'];
unset($_data['return_money']);
$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['rate_perday'] = $data['rate_perday'];
$_data['total_money_owe'] = $data['total'];
$_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;
unset($_data['status_loan']);
unset($_data['return_money']);
// $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);
$exist = $this->TransaOweNotexist($mt_id);
if (!empty($exist)) {
$where = $this->getAdapter()->quoteInto('money_tran_id=?', $mt_id);
$this->update($_data, $where);
} else {
if (!empty($data['loan'])) {
$_data['rate_perday'] = $data['rate_perday'];
$_data['money_tran_id'] = $mt_id;
$this->insert($_data);
}
}
$tran_type = $data['tran_type'];
$old_agent = $old_data['agent_id'];
$old_amount_type = $old_data['amount_type'];
$old_amount = $old_data['amount'] + $old_data['commission_agent'];
$new_agent = $_data['agent_id'];
$new_amount_type = $_data['amount_type'];
$new_amount = $_data['amount'] + $_data['commission_agent'];
$db_cap = new Application_Model_DbTable_DbCapitalAgent();
$db_cap->updateBalanceWithCondiction($tran_type, $old_agent, $old_amount_type, $old_amount, $new_agent, $new_amount_type, $new_amount);
return $db->commit();
} catch (Exception $e) {
$db->rollBack();
}
}
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 addTransFound($_data)
{
$this->_name = "cs_trans_found";
$capital_dollar = empty($_data['money_dollar']) ? 0 : $_data['money_dollar'];
$refund_dollar = empty($_data['refund_dollar']) ? 0 : $_data['refund_dollar'];
$_data['refund_dollar'] = $capital_dollar < $refund_dollar ? $capital_dollar : $refund_dollar;
$capital_bath = empty($_data['money_bath']) ? 0 : $_data['money_bath'];
$refund_bath = empty($_data['refund_bath']) ? 0 : $_data['refund_bath'];
$_data['refund_bath'] = $capital_bath < $refund_bath ? $capital_bath : $refund_bath;
$capital_reil = empty($_data['money_kh']) ? 0 : $_data['money_kh'];
$refund_kh = empty($_data['refund_kh']) ? 0 : $_data['refund_kh'];
$_data['refund_kh'] = $capital_reil < $refund_kh ? $capital_reil : $refund_kh;
$_refund_dollar = empty($_data['refund_dollar']) ? 0 : $_data['refund_dollar'];
$_refund_bath = empty($_data['refund_bath']) ? 0 : $_data['refund_bath'];
$_refund_riel = empty($_data['refund_kh']) ? 0 : $_data['refund_kh'];
$exchange_dollar = empty($_data['exchange_dollar']) ? 0 : $_data['exchange_dollar'];
$exchange_bath = empty($_data['exchange_bath']) ? 0 : $_data['exchange_bath'];
$exchange_riel = empty($_data['exchange_riel']) ? 0 : $_data['exchange_riel'];
$dollar_id = empty($_data['money_dollar_id']) ? 0 : $_data['money_dollar_id'];
$bath_id = empty($_data['money_bath_id']) ? 0 : $_data['money_bath_id'];
$riel_id = empty($_data['money_kh_id']) ? 0 : $_data['money_kh_id'];
$db_sender = new Application_Model_DbTable_DbKbank();
$sender_id = $db_sender->getSenderIdbyName($_data['sender_name']);
$session_user = new Zend_Session_Namespace('auth');
$db = $this->getAdapter();
$db->beginTransaction();
try {
$arr_remain = array('money_tran_id' => '0', 'sender_name' => $sender_id, 'invoice_no' => $_data["invoice_no"], 'rate_perday' => $_data["remain_rate_perday"], 'commission_agent' => '0', 'status' => '0', 'status_loan' => '2', 'cut_service' => '0', 'send_date' => date('Y-m-d'), 'exchange_rate_db' => $exchange_dollar, 'exchange_rate_dr' => $exchange_bath, 'exchange_rate_rb' => $exchange_riel, 'user_id' => $session_user->user_id);
$arr_status_loan = array('status_loan' => 3);
if (!empty($_data["refund_dollar"])) {
$this->_name = "cs_trans_found";
$_arr = array("invoice_found" => $_data["invoice_no"], "sender_id" => $sender_id, "capital" => $capital_dollar, "refund" => $_refund_dollar, "exchange_rate_db" => $exchange_dollar, "exchange_rate_dr" => $exchange_bath, "exchange_rate_rb" => $exchange_riel, "date_refund" => date('Y-m-d'), "curency_type" => '1', "tran_id" => $dollar_id);
$found_id = $this->insert($_arr);
$this->updateOwe('id', $dollar_id, $arr_status_loan);
/*insert to capital*/
if (empty($_data['pay_all'])) {
//if pay sigle
if ($_data['pay_currencytype'] > -1) {
$_ref_dollar_tocap = empty($_data['rrconvertto_dollar']) ? $_data['refund_dollar'] : $_data['rrconvertto_dollar'];
$org_currtype = $_data['pay_currencytype'];
} else {
$org_currtype = 1;
$_ref_dollar_tocap = $_data['refund_dollar'];
}
} else {
//if multy payment
$org_currtype = $_data['from_amount_type'];
$_ref_dollar_tocap = empty($_data['rrconvertto_dollar']) ? $_data['refund_dollar'] : $_data['rrconvertto_dollar'];
if ($org_currtype == 1) {
$_ref_dollar_tocap = $_data['refund_dollar'];
}
}
$this->culToCapital($found_id, $org_currtype, $_ref_dollar_tocap);
//print_r($_arr);echo '<br/><br/>';
$remain = $capital_dollar - $_refund_dollar;
//echo $remain.'<br/><br/>';
if ($remain <= 0) {
$remain = 0;
}
$arr_remain['amount'] = $remain;
$arr_remain['total_money'] = $remain;
$arr_remain['total_money_owe'] = $remain;
$arr_remain['amount_type'] = 1;
$this->addOwe($arr_remain);
//$found_id = $this->insert($_arr);
//$_data["curency_type"]=1; $this->addCashFound($_data);
}
if (!empty($_data["refund_bath"])) {
$this->_name = "cs_trans_found";
$_arr = array("invoice_found" => $_data["invoice_no"], "sender_id" => $sender_id, "capital" => $capital_bath, "refund" => $_refund_bath, "exchange_rate_db" => $exchange_dollar, "exchange_rate_dr" => $exchange_bath, "exchange_rate_rb" => $exchange_riel, "date_refund" => date('Y-m-d'), "curency_type" => '2', "tran_id" => $bath_id);
$found_id = $this->insert($_arr);
$this->updateOwe('id', $bath_id, $arr_status_loan);
/*insert to capital*/
if (empty($_data['pay_all'])) {
//if pay sigle
if ($_data['pay_currencytype'] > -1) {
$_ref_bath_tocap = empty($_data['rrconvertto_bath']) ? $_data['refund_bath'] : $_data['rrconvertto_bath'];
$org_currtype = $_data['pay_currencytype'];
} else {
$org_currtype = 2;
$_ref_bath_tocap = $_data['refund_bath'];
}
} else {
//if multy payment
$org_currtype = $_data['from_amount_type'];
$_ref_bath_tocap = empty($_data['rrconvertto_bath']) ? $_data['refund_bath'] : $_data['rrconvertto_bath'];
if ($org_currtype == 1) {
$_ref_bath_tocap = $_data['refund_dollar'];
}
}
$this->culToCapital($found_id, $org_currtype, $_ref_bath_tocap);
//print_r($_arr);echo '<br/><br/>';
$remain = $capital_bath - $_refund_bath;
//echo $remain.'<br/><br/>';
if ($remain <= 0) {
$remain = 0;
}
$arr_remain['amount'] = $remain;
$arr_remain['total_money'] = $remain;
$arr_remain['total_money_owe'] = $remain;
$arr_remain['amount_type'] = 2;
$this->addOwe($arr_remain);
//$found_id = $this->insert($_arr);
//$_data["curency_type"]=2; $this->addCashFound($_data);
}
if (!empty($_data["refund_kh"])) {
$this->_name = "cs_trans_found";
$_arr = array("invoice_found" => $_data["invoice_no"], "sender_id" => $sender_id, "capital" => $capital_reil, "refund" => $_refund_riel, "exchange_rate_db" => $exchange_dollar, "exchange_rate_dr" => $exchange_bath, "exchange_rate_rb" => $exchange_riel, "date_refund" => date('Y-m-d'), "curency_type" => '3', "tran_id" => $riel_id);
$found_id = $this->insert($_arr);
$this->updateOwe('id', $riel_id, $arr_status_loan);
/*insert to capital*/
if (empty($_data['pay_all'])) {
//if pay sigle
if ($_data['pay_currencytype'] > -1) {
$_ref_riel_tocap = empty($_data['rrconvertto_riel']) ? $_data['refund_kh'] : $_data['rrconvertto_riel'];
$org_currtype = $_data['pay_currencytype'];
} else {
$org_currtype = 3;
$_ref_riel_tocap = $_data['refund_kh'];
}
} else {
//if multy payment
$org_currtype = $_data['from_amount_type'];
$_ref_riel_tocap = empty($_data['rrconvertto_riel']) ? $_data['refund_kh'] : $_data['rrconvertto_riel'];
if ($org_currtype == 1) {
$_ref_riel_tocap = $_data['refund_kh'];
}
}
$this->culToCapital($found_id, $org_currtype, $_ref_riel_tocap);
//print_r($_arr);echo '<br/><br/>';
$remain = $capital_reil - $_refund_riel;
//echo $remain.'<br/><br/>';
if ($remain <= 0) {
$remain = 0;
}
$arr_remain['amount'] = $remain;
$arr_remain['total_money'] = $remain;
$arr_remain['total_money_owe'] = $remain;
$arr_remain['amount_type'] = 3;
//print_r($arr_remain);echo 'arr_remain<br/><br/>';
$this->addOwe($arr_remain);
}
return $db->commit();
} catch (Exception $e) {
$db->rollBack();
// echo $e->getMessage();exit();
}
}
public function getDebtBysenderAction()
{
if ($this->getRequest()->isPost()) {
$_data = $this->getRequest()->getPost();
$_db = new Application_Model_DbTable_DbPayment();
$db_sender = new Application_Model_DbTable_DbKbank();
$sender_id = $db_sender->getSenderIdbyName($_data['sender_name']);
$moneys = $_db->getAddDebtSenderNameById($sender_id);
print_r(Zend_Json::encode($moneys));
exit;
}
}
function getMoneykbankAction()
{
if ($this->getRequest()->isPost()) {
$_data = $this->getRequest()->getPost();
$_db = new Application_Model_DbTable_DbKbank();
$moneys = $_db->getAllMoneyDeposit($_data['sender_name']);
//$moneys = 1;
print_r(Zend_Json::encode($moneys));
exit;
}
}
