public function viewAction()
{
// action body
$ag_id = $this->getRequest()->getParam('ag_id');
$db_agent = new Application_Model_DbTable_DbAgents();
$this->view->agent_view = $db_agent->getAgentViewById($ag_id);
}
public function indexAction()
{
// action body
//create sesesion
$session_search_agent = new Zend_Session_Namespace('search_agent');
if (empty($session_search_agent->limit)) {
$session_search_agent->limit = Application_Form_FrmNavigation::getLimit();
$session_search_agent->active = -1;
$session_search_agent->province = -1;
$session_search_agent->txtsearch = '';
$session_search_agent->lock();
}
//start page nevigation
$limit = $session_search_agent->limit;
$start = $this->getRequest()->getParam('limit_satrt', 0);
$pro = new Application_Model_DbTable_DbProvinces();
$this->view->provincelist = $pro->getProvinceList();
$this->view->province = $session_search_agent->province;
$db_agent = new Application_Model_DbTable_DbAgents();
$this->view->activelist = $this->activelist;
$this->view->active = $session_search_agent->active;
if ($this->getRequest()->isPost()) {
$agent_seach_data = $this->getRequest()->getPost();
//set session when submit
$session_search_agent->unlock();
$session_search_agent->limit = $agent_seach_data['rows_per_page'];
$session_search_agent->active = $agent_seach_data['active'];
$session_search_agent->province = $agent_seach_data['province'];
$session_search_agent->txtsearch = $agent_seach_data['txtsearch'];
$session_search_agent->lock();
$this->view->province = $agent_seach_data['province'];
$this->view->txtsearch = $agent_seach_data['txtsearch'];
$this->view->active = $agent_seach_data['active'];
$limit = $session_search_agent->limit;
$agents = $db_agent->getAgentListBy($agent_seach_data, $start, $limit);
$record_count = $db_agent->getAgentListTotal($agent_seach_data);
} else {
if (!empty($session_search_agent->txtsearch) || $session_search_agent->active > -1 || $session_search_agent->province > -1) {
$agent_seach_data = array('active' => $session_search_agent->active, 'province' => $session_search_agent->province, 'txtsearch' => $session_search_agent->txtsearch);
$agents = $db_agent->getAgentListBy($agent_seach_data, $start, $limit);
$record_count = $db_agent->getAgentListTotal($agent_seach_data);
} else {
$agents = $db_agent->getAgentList($start, $limit);
$record_count = $db_agent->getAgentListTotal();
}
}
$result = array();
$row_num = $start;
foreach ($agents as $i => $agent) {
$result[$i] = array('num' => ++$row_num, 'id' => $agent['id'], 'tel' => $agent['tel'], 'name' => $agent['name'], 'proname' => $agent['proname'], 'khan' => $agent['khan'], 'sangkat' => $agent['sangkat'], 'block' => $agent['block']);
}
$this->view->agentlist = Zend_Json::encode($result);
$page = new Application_Form_FrmNavigation(self::REDIRECT_URL, $start, $limit, $record_count);
$page->init(self::REDIRECT_URL, $start, $limit, $record_count);
$this->view->nevigation = $page->navigationPage();
$this->view->rows_per_page = $page->getRowsPerPage($limit, 'frmlist_agent');
$this->view->result_row = $page->getResultRows();
}
public function editedAction()
{
// action body
$ag_id = $this->getRequest()->getParam('ag_id');
$ag_id = empty($ag_id) ? 0 : $ag_id;
$pro = new Application_Model_DbTable_DbProvinces();
$this->view->provinces = $pro->getProvinceListAll();
$db_agent = new Application_Model_DbTable_DbAgents();
$this->view->agent_edit = $db_agent->getAgentEditedById($ag_id);
if ($this->getRequest()->isPost()) {
$agentdata = $this->getRequest()->getPost();
try {
$db = $db_agent->updateAgent($agentdata);
Application_Form_FrmMessage::Sucessfull('ការបញ្ចូលជោគជ័យ', self::REDIRECT_URL);
} catch (Exception $e) {
$this->view->msg = 'ការបញ្ចូលមិនជោគជ័យ';
}
}
}
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;
}
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();
}
