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);
}
