public function indexAction() { try { $db = new Partner_Model_DbTable_DbDeposite(); if ($this->getRequest()->isPost()) { $search = $this->getRequest()->getPost(); // print_r($search);exit(); } else { $search = array('adv_search' => '', 'status_search' => -1, 'start_date' => date('Y-m-01'), 'end_date' => date('Y-m-d')); } $rows = $db->getAllDeposite($search); // print_r($rows);exit(); $arr = array(); foreach ($rows as $index => $rs) { $arr[$index] = array('id' => $rs['id'], 'invoice' => $rs['invoice'], 'partner_name' => $rs['partner_name'], 'date' => $rs['date'], 'note' => $rs['note'], 'amount_dollar' => 0, 'amount_riel' => 0, 'amount_bath' => 0, 'status' => $rs['status']); $rs_detail = $db->getGroupDepositeDetail($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, null); $list = new Application_Form_Frmtable(); $collumns = array("លេខវិកាប័ត្ត", "ឈ្មោះដៃគូ", "ថ្ងៃ", "សម្គាល់", "ចំនួនប្រាក់ដុល្លា", "ចំនួនប្រាក់រៀល", "ចំនួនប្រាក់បាត", "status"); $link = array('module' => 'partner', 'controller' => 'deposite', 'action' => 'edit'); $this->view->list = $list->getCheckList(0, $collumns, $arr, array('partner_id' => $link, 'invoice' => $link, 'date' => $link, 'note' => $link)); } catch (Exception $e) { Application_Form_FrmMessage::message("Application Error"); echo $e->getMessage(); //Application_Model_DbTable_DbUserLog::writeMessageError($e->getMessage()); } $pructis = new Partner_Form_FrmPartner(); $frm = $pructis->addPartner(); Application_Model_Decorator::removeAllDecorator($frm); $form = $this->view->frm_partner = $frm; $pructis = new Partner_Form_FrmDeposite(); $frm_de = $pructis->partnerinformation(); Application_Model_Decorator::removeAllDecorator($frm_de); $this->view->frm_deposite = $frm_de; }