/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $data = FeaturedProduct::orderBy('rank', 'asc')->with('product')->get(); $categories = Category::get(); $products = Product::get(); return view('admin.image.featured-product', compact('data', 'categories', 'products')); }
public function ProductOfCate($slug) { $cate_id = Category::where('slug', '=', $slug)->first(); $categories = Category::all(); $productOfcate = Product::where('category_id', $cate_id->id)->orderBy('created_at', 'DESC')->get(); $featured_products = FeaturedProduct::orderBy('rank', 'ASC')->get(); foreach ($featured_products as $i) { $id[] = $i->product_id; } $featured_photo = Photo::whereIn('product_id', $id)->get(); $lastest_product = Product::orderBy('created_at', 'DESC')->limit(8)->get(); return view('pages.category', compact('productOfcate', 'cate_id', 'categories', 'featured_products', 'featured_photo', 'lastest_product')); }