public function indexAction()
{
try {
$db_tran = new Application_Model_DbTable_DbKbank();
//create sesesion
$session_withdraw = new Zend_Session_Namespace('search_withdraw');
if (empty($session_withdraw->limit)) {
$session_withdraw->limit = Application_Form_FrmNavigation::getLimit();
$session_withdraw->type_money = -1;
$session_withdraw->sender = -1;
$session_withdraw->txtsearch = "";
$session_withdraw->from_date = date('Y-m-d');
$session_withdraw->to_date = date('Y-m-d');
$session_withdraw->lock();
}
//start page nevigation
$limit = $session_withdraw->limit;
$start = $this->getRequest()->getParam('limit_satrt', 0);
$this->view->from_date = $session_withdraw->from_date;
$this->view->to_date = $session_withdraw->to_date;
$this->view->sender_id = $session_withdraw->sender;
$cur = new Application_Model_DbTable_DbCurrencies();
$this->view->currencylist = $cur->getCurrencyList();
$this->view->type_money = $session_withdraw->type_money;
$this->view->txtsearch = $session_withdraw->txtsearch;
if ($this->getRequest()->isPost()) {
$formdata = $this->getRequest()->getPost();
// print_r($formdata);
$session_withdraw->unlock();
$session_withdraw->txtsearch = $formdata['txt_search'];
$session_withdraw->limit = $formdata['rows_per_page'];
$session_withdraw->type_money = $formdata['type_money'];
$session_withdraw->sender = $formdata['sender'];
$session_withdraw->from_date = $formdata['from_date'];
$session_withdraw->to_date = $formdata['to_date'];
$session_withdraw->lock();
$this->view->txtsearch = $formdata['txt_search'];
$this->view->type_money = $formdata['type_money'];
$this->view->sender_id = $formdata['sender'];
$this->view->from_date = $session_withdraw->from_date;
$this->view->to_date = $session_withdraw->to_date;
$limit = $session_withdraw->limit;
$trans = $db_tran->getTranWithDrawListBy($formdata, $start, $limit);
$record_count = $db_tran->getTranWithDrawListTotal($formdata);
} else {
$formdata = array('txt_search' => $session_withdraw->txtsearch, 'tran_type' => $session_withdraw->tran_type, 'from_date' => $session_withdraw->from_date, 'to_date' => $session_withdraw->to_date, 'type_money' => $session_withdraw->type_money, 'sender' => $session_withdraw->sender);
$trans = $db_tran->getTranWithDrawListBy($formdata, $start, $limit);
$record_count = $db_tran->getTranWithDrawListTotal($formdata);
}
$result = array();
$row_num = $start;
if (!empty($trans)) {
foreach ($trans as $i => $tran) {
$expired = '';
$is_expired = 0;
$result[$i] = array('num' => ++$row_num, 'id' => $tran['id'], 'sender_name' => $tran['sender_name'], 'tel' => $tran['tel'], 'account_no' => $tran['acc_no'], 'invoice' => $tran['invoice'], 'amount_dollar' => $tran['wd_amountdollar'] . " \$", 'amount_bath' => $tran['wd_amountbath'] . " B", 'amount_riel' => $tran['wd_amountriel'] . " R", 'create_date' => date_format(date_create($tran['create_date']), "d/m/Y"));
}
} else {
$result = array('err' => 1, 'msg' => 'មិនទាន់មានទន្និន័យនូវឡើយទេ!');
}
$this->view->tranlist = 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_mt');
$this->view->result_row = $page->getResultRows();
$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();
} catch (Exception $e) {
}
}
