public function indexLocationAction() { $db = new Application_Model_DbTable_DbGlobal(); $formFilter = new Product_Form_FrmProductFilter(); $frmsearch = $formFilter->searchLocation(); $this->view->formFilter = $frmsearch; $list = new Application_Form_Frmlist(); $sql = "select loc.LocationId, loc.Name, loc.contact, loc.phone,username, loc.status,remark \n\t\tfrom tb_sublocation AS loc\n\t\tINNER JOIN rsv_acl_user as u ON\n\t\tu.user_id=loc.user_id\n\t\tWHERE Name!='' "; if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); if ($post['location_name'] != '') { $sql .= " AND Name LIKE '%" . $post['location_name'] . "%'"; } if ($post['contact_name'] != '') { $sql .= " AND contact LIKE '%" . $post['contact_name'] . "%'"; } if ($post['address_name'] != '') { $sql .= " AND stock_add LIKE '%" . $post['address_name'] . "%'"; } if ($post['phone'] != '') { $sql .= " AND phone LIKE '%" . $post['phone'] . "%'"; } } $sql .= " ORDER BY loc.LocationId DESC"; $rows = $db->getGlobalDb($sql); $columns = array("LOCATION_NAME", "CON_NAME", "PHONE_NUM", "BY_USER", "STATUS", "REMARK"); $link = array('module' => 'product', 'controller' => 'index', 'action' => 'detail-stock'); $urlEdit = BASE_URL . "/product/index/update-stock"; $glClass = new Application_Model_GlobalClass(); $rows = $glClass->getImgStatus($rows, BASE_URL, true); $this->view->list = $list->getCheckList(1, $columns, $rows, array('name' => $link), $urlEdit); Application_Model_Decorator::removeAllDecorator($formFilter); }