public function indexAction() { if ($this->getRequest()->isPost()) { $data = $this->getRequest()->getPost(); $search = array('adv_search' => $data['adv_search'], 'send_name_id' => $data['send_name'], 'status_search' => $data['status_search'], 'start_date' => $data['start_date'], 'end_date' => $data['end_date']); } else { $search = array('status_search' => -1, 'start_date' => date('Y-m-01'), 'end_date' => date('Y-m-d')); } try { $db = new Keeping_Model_DbTable_DbKeeping(); $rs_rows = $db->getAllKeeping($search); //call frome model $arr = array(); foreach ($rs_rows as $index => $rs) { $arr[$index] = array('id' => $rs['id'], 'invoice_number' => $rs['invoice_number'], 'client_name' => $rs['client_name'], 'date_keeping' => $rs['date_keeping'], 'amount_keeping' => $rs['amount_keeping'] . ' ' . $rs['name_en'], 'exp_date' => $rs['exp_date'], 'amount_dollar' => 0, 'amount_riel' => 0, 'amount_bath' => 0, 'status' => $rs['status']); $rs_detail = $db->getGroupKeepingdetail($rs['id']); foreach ($rs_detail as $key => $r) { if ($r['currency_type'] == 3) { $arr[$index]['amount_riel'] = $r['amount']; } elseif ($r['currency_type'] == 1) { $arr[$index]['amount_dollar'] = $r['amount']; } elseif ($r['currency_type'] == 2) { $arr[$index]['amount_bath'] = $r['amount']; } } } $glClass = new Application_Model_GlobalClass(); $arr = $glClass->getImgActive($arr, BASE_URL, true); $list = new Application_Form_Frmtable(); $collumns = array("វិក័យប័ត្រ", "ឈ្មោះអ្នកផ្ញើរ ", "កាលបរិច្ឆេទ ផ្ញើរ", "រយះពេលផ្ញើរ ", "ផុតកំណត់ត្រឹមថ្ងៃ", "ចំនួនប្រាក់ដុល្លា", "ចំនួនប្រាក់រៀល", "ចំនួនប្រាក់បាត", "status"); $link = array('module' => 'Keeping', 'controller' => 'index', 'action' => 'edit'); $this->view->list = $list->getCheckList(0, $collumns, $arr, array('client_name' => $link, 'date_keeping' => $link, 'invoice_numer' => $link)); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); echo $e->getMessage(); Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } $sendmoney = new Keeping_Form_FrmSendMoney(); //$db= new Keeping_Model_DbTable_DbKeeping(); $frm = $sendmoney->addSendMoney(); //echo $frm;exit(); Application_Model_Decorator::removeAllDecorator($frm); $this->view->frm = $frm; }