public function rptbalanceAction()
{
// Get Session User
$session_user = new Zend_Session_Namespace('auth');
$b = new Application_Model_DbTable_DbCapital();
$user_id = $session_user->user_id;
$month = date("n");
if ($this->getRequest()->isPost()) {
$formdata = $this->getRequest()->getPost();
$user_id = $formdata['user_id'];
if ($formdata['actions'] == "add_capital") {
if ($formdata['dollar'] != 0 or $formdata['bath'] != 0 or $formdata['rail'] != 0) {
$b->addBalanceByUser($user_id, $formdata);
}
} else {
$month = $formdata['month'];
}
}
$usr_mod = new Application_Model_DbTable_DbUsers();
$this->view->users = $usr_mod->getUserListSelect();
$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_DbLoan();
$trans = $db_loan->getLoanDataByUserId($user_id, $month);
if (empty($trans)) {
$trans = array('err' => 1, 'msg' => 'មិនទាន់មានទន្និន័យនូវឡើយទេ!');
}
$this->view->tranlist = $trans;
}
public function balanceAction()
{
$session_user = new Zend_Session_Namespace('auth');
$b = new Application_Model_DbTable_DbCapital();
$user_id = $session_user->user_id;
if ($this->getRequest()->isPost()) {
$formdata = $this->getRequest()->getPost();
$user_id = $formdata['user_id'];
if ($formdata['actions'] == "add_capital") {
//$b->addBalanceByUser($user_id, $formdata);
}
}
$cp_db = new Application_Model_DbTable_DbCapital();
$rs_d = $cp_db->DetechCapitalExist($user_id, 1, null);
//check if add capital exist
$rs_b = $cp_db->DetechCapitalExist($user_id, 2, null);
//check if add capital exist
$rs_r = $cp_db->DetechCapitalExist($user_id, 3, null);
//check if add capital exist
$total_balance = array('dollar' => empty($rs_d) ? 0 : $rs_d['amount'], 'baht' => empty($rs_b) ? 0 : $rs_b['amount'], 'riel' => empty($rs_r) ? 0 : $rs_r['amount']);
$balance = $b->getCurrentBallancesByCurrentUser($user_id);
$arr_img = array();
foreach ($balance as $key => $val) {
if ($key == 'dollar') {
$k = 'dollar';
} elseif ($key == 'bath') {
$k = 'baht';
} else {
$k = 'riel';
}
if ($total_balance[$k] > $val) {
$arr_img[$k] = array('amount' => $total_balance[$k] - $val, 'img' => 'up');
} elseif ($total_balance[$k] < $val) {
$arr_img[$k] = array('amount' => $val - $total_balance[$k], 'img' => 'down');
} else {
$arr_img[$k] = array('amount' => 0, 'img' => '');
}
}
$usr_mod = new Application_Model_DbTable_DbUsers();
$this->view->users = $usr_mod->getUserListSelect();
$this->view->balance = $balance;
$this->view->total_balance = $total_balance;
$this->view->img = $arr_img;
$this->view->user_id = $user_id;
}
