public function typePriceAction() { $formFilter = new Product_Form_FrmItemPrice(); $frmsearch = $formFilter->searchPriceType(null); Application_Model_Decorator::removeAllDecorator($frmsearch); $this->view->formFilter = $frmsearch; $list = new Application_Form_Frmlist(); $db = new Application_Model_DbTable_DbGlobal(); $request = $this->getRequest(); $id = $request->getParam("id", NULL); $sql = "SELECT type_id,price_type_name,pt.desc,public\n\t\tFROM tb_price_type AS pt\n\t\tWHERE price_type_name !='' "; if ($this->getRequest()->isPost()) { $post = $this->getRequest()->getPost(); if ($post['price_type'] != '') { $sql .= " AND price_type_name LIKE '%" . trim($post['price_type']) . "%'"; } if ($post['status'] != '') { $sql .= " AND public =" . trim($post['status']); } } // //echo $sql;exit(); // $sql .= " GROUP BY p.pro_id,pt.type_id"; //echo $sql; $rows = $db->getGlobalDb($sql); $glClass = new Application_Model_GlobalClass(); $rows = $glClass->getpublic($rows, BASE_URL, true); $columns = array("TYPE_PRICE", "DESC_CAP", "ACTIVE", "DEACTIVE"); $link = array('module' => 'product', 'controller' => 'adjust-stock', 'action' => 'add-type-price'); $urlEdit = BASE_URL . "/product/adjust-stock/add-type-price"; $this->view->list = $list->getCheckList(1, $columns, $rows, array('item_name' => $link, 'Name' => $link), $urlEdit); Application_Model_Decorator::removeAllDecorator($formFilter); }