示例#1
0
 public function getCategory($cat_slug = null)
 {
     $categories = Categories::where('category_slug', $cat_slug)->lists('id');
     // Get Category According to SLUG
     $allCoupons = Coupons::whereIn('category_id', $categories)->paginate(20);
     // Get Coupons According to Category Selected
     $type = 'category';
     $data = array('pageTitle' => 'CouponJadu - Get Latest Coupons', 'allCoupons' => $allCoupons, 'allCategories' => $this->allCategories, 'allStores' => $this->allStores, 'type' => $type);
     return View::make('home', $data);
 }
 public function getForm($id = null)
 {
     $dataAdmin = new PrProviders();
     $modelProviders = new PrTypes();
     $modelCategories = new Categories();
     $listProviders = $modelProviders->where('flagactive', PrTypes::STATE_ACTIVE)->lists('name_type', 'id')->toArray();
     $listProviders = [null => 'Select un tipo'] + $listProviders;
     $listCategories = $modelCategories->where('flagactive', Categories::STATE_ACTIVE)->lists('name_category', 'id')->toArray();
     $listCategories = [null => 'Select una categoria'] + $listCategories;
     if (!is_null($id)) {
         $dataAdmin = PrProviders::find($id);
     }
     return viewc('admin.' . self::NAMEC . '.form', compact('dataAdmin', 'listProviders'), ['listCategories' => $listCategories, 'listCategories' => $listCategories]);
 }
示例#3
0
 public function searching($term)
 {
     $condition = array("New" => 1, "Perfect" => 2, "Good" => 3, "Blemist" => 4);
     $cond_prod_ids = array();
     $product_ids = array();
     $pro_ids = array();
     $brand_prod_ids = array();
     $cat_prod_ids = array();
     $tag_prod_ids = array();
     //Search by product condition
     if (in_array($term, $condition)) {
         $cond_prod_ids = Product::where("condition", "=", $condition[$term])->lists('products_id');
     }
     //Search by product attribute name
     $product_values_ids = ProductsOptionsValues::where('products_options_values_name', 'LIKE', '%' . $term . '%')->lists('products_options_values_id');
     if ($product_values_ids) {
         $product_ids = DB::table('bn_products_attributes')->whereIn('options_values_id', $product_values_ids)->lists('products_id');
     }
     //Search by product name or description
     $pro_ids = ProductsDescription::where('products_name', 'LIKE', '%' . $term . '%')->orWhere('products_description', 'LIKE', '%' . $term . '%')->lists('products_id');
     //Search by product brand
     $brand_ids = Brands::where('brand_name', 'LIKE', '%' . $term . '%')->lists('brands_id');
     if ($brand_ids) {
         $brand_prod_ids = Product::whereIn("brand", $brand_ids)->lists('products_id');
     }
     //Search product by category
     $cat_ids = Categories::where('title', 'LIKE', '%' . $term . '%')->lists('categories_id');
     if ($cat_ids) {
         $cat_prod_ids = DB::table('bn_products_to_categories')->whereIn('categories_id', $cat_ids)->lists('products_id');
     }
     //Search product by tags
     $tag_ids = Tags::where('title', 'LIKE', '%' . $term . '%')->lists('tags_id');
     if ($tag_ids) {
         $tag_prod_ids = DB::table('bn_products_to_tags')->whereIn('tags_id', $tag_ids)->lists('products_id');
     }
     $result_prod_ids = array_merge($product_ids, $cond_prod_ids, $pro_ids, $brand_prod_ids, $cat_prod_ids, $tag_prod_ids);
     $products = Product::whereIn('products_id', $result_prod_ids)->where('products_status', '1')->paginate(15);
     //->get();
     if ($products) {
         $products = $this->product_add_detail($products);
         return $this->response(array('statusCode' => 100, 'statusDescription' => 'Success', 'products' => json_decode($products->toJson(), true)));
     } else {
         return $this->response(array('statusCode' => 400, 'statusDescription' => 'Not Found'));
     }
 }
示例#4
0
 public function show_subcategories($id)
 {
     $Category = Categories::where('parent_id', '=', $id)->get();
     return $this->response(array('statusCode' => 100, 'statusDescription' => "Success", 'categories' => json_decode($Category, true)));
 }