function listAll($offset = 0, $limit = 20) { $products = new Product(); $products->order_by('id', 'desc'); $searchKey = ""; if ($_SERVER['REQUEST_METHOD'] == "GET") { } else { $searchKey = $this->input->post("search_name"); $products->distinct(); $products->group_start(); $products->like('name_vietnamese', $searchKey); $products->or_like('seo_keyword', $searchKey); $products->group_end(); } $products->get_paged($offset, $limit, TRUE); setPagination($this->admin . 'products/listAll/', $products->paged->total_rows, $limit, 4); $dis['base_url'] = base_url(); $dis['view'] = 'products/list'; $dis['products'] = $products; $dis['menu_active'] = "Sản phẩm"; $dis['title_table'] = "Trang hiện tại:" . $products->paged->current_page . '/' . $products->paged->total_pages; $dis['title'] = "Tất cả sản phẩm"; $dis['searchKey'] = $searchKey; $dis['nav_menu'] = array(array("type" => "add", "text" => "Thêm", "link" => "{$this->admin_url}products/edit", "onclick" => "")); $this->viewadmin($dis); }
public function extractCategory() { $category = Product::distinct('category')->get()->toArray(); $cats = array('' => 'All'); //print_r($category); foreach ($category as $cat) { $cats[$cat[0]] = $cat[0]; } return $cats; }
public static function ExtractProductCategory($selection = true) { $category = Product::distinct('category')->get()->toArray(); if ($selection) { $cats = array('' => 'All'); } else { $cats = array(); } //print_r($category); foreach ($category as $cat) { $cats[$cat[0]] = $cat[0]; } return $cats; }