function addBalanceByUser($user_id, $data)
{
$db = $this->getAdapter();
$db_loan = new Application_Model_DbTable_DbLoanAgent();
$db->beginTransaction();
try {
foreach ($data as $k => $val) {
if ($k != "dollar" && $k != "bath" && $k != "rail") {
continue;
}
$currency_type = 0;
if ($k == "dollar") {
$currency_type = 1;
} elseif ($k == "bath") {
$currency_type = 2;
} elseif ($k == "rail") {
$currency_type = 3;
}
$amount = floatval($this->getCurrentBalanceByUser($user_id, $currency_type)) + floatval($val);
$this->updateBalanceByUserId($user_id, $currency_type, $amount);
$db_loan->saveLoanByUserId($user_id, $currency_type, $val);
}
return $db->commit();
} catch (Exception $e) {
$db->rollBack();
// echo $e->getMessage(); exit;
}
}
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;
}