Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getProducts($type){
- //İstenilen kısmın ürün kategorileri
- $cats = $this->db->query("SELECT * FROM products_cats WHERE parent_cat_id!='-1' AND cat_type='$type'");
- $cats = $cats->result();
- $cat_ids = array();
- $product_datas = array();
- foreach($cats as $cat){
- //Kategoriye ait ürünler
- $query = $this->db->query("SELECT * FROM product_cat_connector WHERE cat_id='$cat->cat_id'");
- $products = $query->result();
- foreach($products as $product){
- if(!array_key_exists($product->product_id,$product_datas)){
- $productQuery = $this->db->query("SELECT * FROM products_main WHERE product_id='$product->product_id'");
- $productMain = $productQuery->row();
- $product_datas[$product->product_id]=array(
- 'cat_name'=>$this->language->key($cat->cat_name_key),
- 'name'=>$this->language->key($productMain->product_name_key),
- 'seo' =>$productMain->product_seo_key,
- 'order' =>$productMain->product_order,
- 'product_hit' =>$productMain->product_hit,
- 'product_status' =>$productMain->product_status
- );
- }
- }
- }
- ksort($product_datas);
- return $product_datas ;
- }
Add Comment
Please, Sign In to add comment