public function rptbalanceAgentAction()
{
// Get Session User
$session_user = new Zend_Session_Namespace('auth');
$b = new Application_Model_DbTable_DbCapitalAgent();
$usr_mod = new Application_Model_DbTable_DbAgents();
$agents_list = $usr_mod->getAgentListSelect();
$user_id = $agents_list[0]['id'];
$month = date("n");
if ($this->getRequest()->isPost()) {
$formdata = $this->getRequest()->getPost();
$user_id = $formdata['user_id'];
if ($formdata['actions'] == "add_capital") {
$b->addBalanceByUser($user_id, $formdata);
} else {
$month = $formdata['month'];
}
}
$this->view->users = $agents_list;
$this->view->balance = $b->getCurrentBallancesByCurrentUser($user_id);
$this->view->user_id = $user_id;
$this->view->month = $month;
// For view
$db_loan = new Application_Model_DbTable_DbLoanAgent();
$trans = $db_loan->getLoanDataByUserId($user_id, $month);
if (empty($trans)) {
$trans = array('err' => 1, 'msg' => 'មិនទាន់មានទន្និន័យនូវឡើយទេ!');
}
$this->view->tranlist = $trans;
}
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();
}
}
