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; }