PHP product::where方法代码示例

 public function validarNoRepitname($text)
 {
     $products = product::where('nombre', '=', $text)->first();
     return $products;
 }

 /**
  * Productscat::getAllProduct()
  * get all the product belong to a category ,direct or indirect).
  * @param mixed $condition
  * @param mixed $offset
  * @param mixed $limit
  * @return
  */
 function getAllProduct($condition = array(), $orderBy = "id", $orderDirection = "desc", $offset = null, $limit = null)
 {
     $listChildCat = $this->getAllChildCat();
     $listIntChildCat = array();
     foreach ($listChildCat as $row) {
         array_push($listIntChildCat, $row->id);
         //     array_push($listNameChildCat,$row->name);
     }
     array_push($listIntChildCat, $this->id);
     //$CI =& get_instance();
     //$CI->firephp->log("child",$listNameChildCat);
     $product = new product();
     $product->where_in_related_productcat('id', $listIntChildCat);
     $product->order_by($orderBy, $orderDirection);
     if (count($condition) > 0) {
         $product->where($condition);
     }
     $product->distinct();
     $product->get_iterated($limit, $offset);
     return $product;
 }

 function priceTable($id = "0")
 {
     $dis['base_url'] = base_url();
     if ($id != "0") {
         $id = explode("_", $id);
         $id = $id[1];
         $manu = new Productmanufacture($id);
         $product = new product();
         $product->where('productmanufacture_id', $id);
         $product->where('status', enum::PRODUCT_AVAILABLE);
         $product->order_by('name', 'asc');
         $product->get_iterated();
         $dis['product'] = $product;
         $this->load->view('front/product/ajaxPriceTable', $dis);
     } else {
         //manufacture
         $manu = new Productmanufacture();
         $manu->where('isShow', 1);
         $manu->get_iterated();
         $dis['manu'] = $manu;
         $dis['view'] = 'product/priceTable';
         $this->viewfront($dis);
     }
 }

 function search()
 {
     $viewMode = $this->uri->segment(2, "") == "" ? "ma-tran" : $this->uri->segment(2);
     $orderBy = $this->uri->segment(3, "") == "" ? "moi-nhat" : $this->uri->segment(3);
     $page = $this->uri->segment(4, "") == "" ? "trang-1" : $this->uri->segment(4);
     if ($_SERVER['REQUEST_METHOD'] == "POST") {
         $searchKey = $this->input->post('searchKey');
         $this->session->set_userdata('searchKey', $searchKey);
     }
     $searchKey = $this->session->userdata('searchkey');
     $limit = $viewMode == "ma-tran" ? 15 : 10;
     $offset = ($this->getPageNumber($page) - 1) * $limit;
     $product = new Product();
     if (trim($searchKey) != "") {
         $product->like('name', $searchKey);
     }
     $product->where('active', 1);
     $product->order_by($this->getOrderBy($orderBy), $this->getOrderDirection($orderBy));
     $product->get_paged_iterated();
     $dis['product'] = $product;
     $dis['pageUrl'] = "tim-kiem";
     $config['base_url'] = site_url($url . "/" . $viewMode . "/" . $orderBy . "/trang-");
     $config['total_rows'] = $product->paged->total_rows;
     $config['per_page'] = $limit;
     $config['use_page_numbers'] = TRUE;
     $config['uri_segment'] = 4;
     $config['num_links'] = 3;
     $config['full_tag_open'] = '<span class="pagin">';
     $config['full_tag_close'] = "</span>";
     $config['first_link'] = FALSE;
     $config['first_tag_open'] = '';
     $config['first_tag_close'] = '';
     $config['last_link'] = FALSE;
     $config['last_tag_open'] = '';
     $config['last_tag_close'] = '';
     $config['next_link'] = '<img src="' . base_url() . 'images/pagination_next.png" />';
     $config['next_tag_open'] = '';
     $config['next_tag_close'] = '';
     $config['prev_link'] = '<img src="' . base_url() . 'images/pagination_pre.png" /';
     $config['prev_tag_open'] = '';
     $config['prev_tag_close'] = '';
     $config['num_tag_open'] = '';
     $config['num_tag_close'] = '';
     $config['cur_tag_open'] = '<span class="active">';
     $config['cur_tag_close'] = '</span>';
     $this->pagination->initialize($config);
     if ($viewMode == 'ma-tran') {
         $dis['view'] = 'product/product_grid';
     } else {
         $dis['view'] = 'product/product_list';
     }
     $productSaleOff = new product();
     $productSaleOff->where('active', 1);
     $productSaleOff->where('isSale', 1);
     $productSaleOff->order_by('id', 'desc');
     $productSaleOff->get_iterated(15);
     $dis['productSaleOff'] = $productSaleOff;
     $dis['base_url'] = base_url();
     $this->viewfront($dis);
 }