public function indexAction()
{
try {
$db_tran = new Application_Model_DbTable_DbKbank();
//create sesesion
$search_kbank = new Zend_Session_Namespace('search_kbank');
if (empty($search_kbank->limit)) {
$search_kbank->limit = Application_Form_FrmNavigation::getLimit();
$search_kbank->type_money = -1;
$search_kbank->txtsearch = "";
$search_kbank->from_date = date('Y-m-d');
$search_kbank->to_date = date('Y-m-d');
$search_kbank->sender = -1;
$search_kbank->lock();
}
//start page nevigation
$limit = $search_kbank->limit;
$start = $this->getRequest()->getParam('limit_satrt', 0);
$this->view->from_date = $search_kbank->from_date;
$this->view->to_date = $search_kbank->to_date;
$this->view->sender_id = $search_kbank->sender;
$cur = new Application_Model_DbTable_DbCurrencies();
$this->view->currencylist = $cur->getCurrencyList();
$this->view->type_money = $search_kbank->type_money;
$this->view->statuslist = $this->statuslist;
$this->view->txtsearch = $search_kbank->txtsearch;
if ($this->getRequest()->isPost()) {
$formdata = $this->getRequest()->getPost();
// print_r($formdata);
$search_kbank->unlock();
$search_kbank->txtsearch = $formdata['txt_search'];
$search_kbank->limit = $formdata['rows_per_page'];
$search_kbank->type_money = $formdata['type_money'];
$search_kbank->from_date = $formdata['from_date'];
$search_kbank->to_date = $formdata['to_date'];
$search_kbank->sender = $formdata['sender'];
$search_kbank->lock();
$this->view->txtsearch = $formdata['txt_search'];
$this->view->type_money = $formdata['type_money'];
$this->view->sender_id = $formdata['sender'];
$this->view->from_date = $search_kbank->from_date;
$this->view->to_date = $search_kbank->to_date;
$limit = $search_kbank->limit;
$trans = $db_tran->getTransactionListBy($formdata, $start, $limit);
$record_count = $db_tran->getTransactionListTotal($formdata);
} else {
$formdata = array('txt_search' => $search_kbank->txtsearch, 'tran_type' => $search_kbank->tran_type, 'from_date' => $search_kbank->from_date, 'to_date' => $search_kbank->to_date, 'type_money' => $search_kbank->type_money, 'sender' => $search_kbank->sender);
$trans = $db_tran->getTransactionListBy($formdata, $start, $limit);
$record_count = $db_tran->getTransactionListTotal($formdata);
}
$result = array();
$row_num = $start;
if (!empty($trans)) {
foreach ($trans as $i => $tran) {
$expired = '';
$is_expired = 0;
$amount = $tran['symbol'] . ' ' . number_format($tran['money_inaccount']);
$sub_agent = empty($tran['subname']) ? "" : "(" . $tran['subname'] . ")";
$inc_no = sprintf("%'010s", $tran['invoice']);
$current_date = $search_kbank->to_date;
$current_date = date_format(date_create($current_date), "d/m/Y");
if ($current_date >= date_format(date_create($tran['end_date']), "d/m/Y")) {
$expired = $current_date - date_format(date_create($tran['end_date']), "d/m/Y");
if ($expired == 0) {
$expired = 'ថ្ងៃនេះ';
} else {
$expired .= ' ថ្ងៃ';
}
$is_expired = 1;
}
$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' => $amount, 'start_date' => date_format(date_create($tran['start_date']), "d/m/Y"), 'expired_date' => date_format(date_create($tran['end_date']), "d/m/Y"), 'amount_month' => $tran['amount_month'] . ' ' . $this->pay_term[$tran['pay_term']], 'amount_expired' => $expired, 'is_expired' => $is_expired, 'is_extend' => $tran["is_extend"] == 1 ? "ពន្យា" : "ផ្ញើរ");
}
} 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;
} catch (Exception $e) {
}
}
