PHP Product::with方法代码示例

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $data = Product::with('category')->get();
     $data = DB::table('products')->leftJoin('categories', 'products.category_id', '=', 'categories.id')->leftJoin('photos', 'products.id', '=', 'photos.product_id')->select('products.*', 'categories.name as cname', 'photos.path as photo')->orderBy('cname')->paginate(self::perPage);
     //dd($data);
     return view('admin.product.index', compact('data'));
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $pro = new Product();
     $adSlotObj = new Adslot();
     $catObj = new Category();
     $brandObj = new Brand();
     /*getting all products for all slots(currently we have 7 slots)*/
     $adSlot_data = $adSlotObj->with(['products'])->get();
     /*t1-t7*/
     // dd($adSlot_data[4]['products'][0]);
     $category_temp_data = $catObj->orderBy('created_at')->take(10)->get();
     /*f1-f10*/
     $brand_data = $brandObj->with(['products'])->get();
     $category_data = [];
     foreach ($category_temp_data as $cat_id) {
         $cat_latest_product = $pro->where('category_id', '=', $cat_id['id'])->orderBy('created_at')->take(1)->pluck('photo_1');
         $cat_latest_product_id = $pro->where('category_id', '=', $cat_id['id'])->orderBy('created_at')->take(1)->pluck('id');
         $cat_random_product = $pro->where('category_id', '=', $cat_id['id'])->orderBy(DB::raw('RAND()'))->take(6)->get();
         $cat_brands = $pro->with(['brand'])->where('category_id', '=', $cat_id['id'])->take(5)->get();
         $cat_products_random_photos = [];
         foreach ($cat_random_product as $photo) {
             $cat_products_random_photos[] = $photo;
         }
         $category_data[] = ['color' => $cat_id['color'], 'floor' => $cat_id['floor'], 'name' => $cat_id['name'], 'desc' => $cat_id['description'], 'logo' => $cat_id['logo'], 'latest_photo_id' => $cat_latest_product_id, 'latest_photo' => $cat_latest_product, 'random_photos' => $cat_products_random_photos, 'brands' => $cat_brands];
     }
     return view('landing_page', compact(['adSlot_data', 'category_data']));
 }

 public function add($id, $quantity, $color = false, $config = false)
 {
     $product = Product::with(['color', 'category'])->find($id);
     $this->items[$id]['product'] = $product;
     $this->items[$id]['quantity'] = $quantity;
     $this->items[$id]['color'] = $color;
     $this->items[$id]['configuration'] = $config;
 }

 public function index(Request $request)
 {
     $q = $request->get('q');
     if ($q) {
     }
     $products = Product::with('brand')->with('stock')->with('unit')->where('name', 'LIKE', '%' . $q . '%')->orderBy('id', 'desc')->paginate(6);
     return $products;
 }

 public function all()
 {
     $products = Product::with('category')->get();
     if ($products->isEmpty()) {
         return $this->responseNotFound(['Products is empty']);
     }
     // Parse Result
     $result = $this->parseProducts($products);
     return $this->responseOk($result);
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $idxs = $this->getParameters()->getFilteringParameters()['ids'];
     $idxs ?: null;
     // avoid 'unused' warning
     /*echo "<pre>";
       print_r(Product::with('pricelists')->get());
       echo "</pre>";
       exit();*/
     return $this->getResponse(Product::with('pricelists')->get());
 }

 /**
  * @param $product_id
  * @return Product|Product[]|Collection|null
  */
 public function byIDWithBiddingDetails($item_id)
 {
     $base_relationships = array("bids");
     $relationships = $base_relationships;
     /** @var Collection $products */
     $products = Cache::remember('product' . implode("_", $product_id), CATALOG_CACHE_TIMEOUT, function () use($item_id, $base_relationships) {
         return Product::with($base_relationships)->whereIn('product_id', $item_id)->get();
     });
     foreach ($products as $product) {
         $product->prepare();
     }
     return $return_first ? $products->first() : $products;
 }

 public function index()
 {
     $categories = Input::get('cat');
     $per_page = 1000;
     //!IMPORTANT
     if ($categories != "") {
         if (Input::get("page") != "") {
             $page = (int) Input::get("page");
         } else {
             $page = 1;
         }
         if ($page == 1) {
             $page_calc = 0;
         } else {
             $page_calc = $page;
         }
         $cat_array = explode(",", $categories);
         $all_products = Product::join('product_cat', 'products.id', '=', 'product_cat.product_id')->whereIn('product_cat.cat_id', $cat_array)->get();
         $all_products_count = count($all_products);
         $last_page = ($all_products_count - $per_page) / $per_page + 1;
         $products_pivot = Product::join('product_cat', 'products.id', '=', 'product_cat.product_id')->whereIn('product_cat.cat_id', $cat_array)->skip($page_calc * $per_page - 1)->take($per_page)->get();
         $unique_products = [];
         foreach ($products_pivot as $item) {
             $found = false;
             foreach ($unique_products as $compare_item) {
                 if ($item->product_id == $compare_item->product_id) {
                     $found = true;
                     break;
                 }
             }
             if (!$found) {
                 $unique_products[] = $item;
             }
         }
         $products = [];
         foreach ($unique_products as $product) {
             $new_product = Product::find($product->product_id);
             $new_product->product_photos = $new_product->product_photos()->where("is_preview", "=", 1)->get();
             $products[] = $new_product;
         }
         $products = $this->buildPaginationResponse($products, $all_products_count, $per_page, $page, $last_page, $categories);
     } else {
         //            $products = Product::paginate($per_page);
         $products = Product::with("product_photos")->with(array('product_photos' => function ($query) {
             $query->where('is_preview', '=', 1);
         }));
         $products = $products->paginate($per_page);
     }
     return $products;
 }

 public function detail($id)
 {
     $page = 'catalog';
     $title = Menu::where('key', $page)->value('name');
     $menuHtml = $this->menuHtml($page);
     $menuItems = Menu::all();
     $bottomMenuHtml = view('bottom', ['menuItems' => $menuItems])->render();
     $pageInfo = Page::where('key', $page)->first();
     $categories = Category::orderBy('sort', 'asc')->get();
     $product = Product::with(['category', 'color'])->find($id);
     $product->increment('views');
     $recommended = Product::with('category')->take(4)->get();
     $smallCart = $this->smallCart();
     $cartItem = $this->cartItem($product->id);
     $page = $product;
     $page->title = $product->name;
     return view('site.product', ['menuHtml' => $menuHtml, 'menuBottomHtml' => $bottomMenuHtml, 'title' => $title, 'page' => $page, 'product' => $product, 'categories' => $categories, 'recommended' => $recommended, 'count' => $smallCart['count'], 'sum' => $smallCart['sum'], 'currentItem' => $cartItem, 'currentProductCategory' => $product->category]);
 }

 /**
  * Define your route model bindings, pattern filters, etc.
  *
  * @param  \Illuminate\Routing\Router  $router
  * @return void
  */
 public function boot(Router $router)
 {
     parent::boot($router);
     $router->bind('book', function ($barcode) {
         return Product::where('barcode', $barcode)->firstOrFail();
     });
     $router->bind('unpublished', function ($barcode) {
         $product = Product::with(['organizations' => function ($query) {
             $query->find(Auth::user()->organization->id);
         }, 'is'])->where('barcode', $barcode)->firstOrFail();
         if ($product->organizations->first()->pivot->published == 0) {
             return $product;
         }
         return false;
     });
     $router->bind('user', function ($hash) {
         return User::where('hash', $hash)->first();
     });
 }

 public function index($page = '')
 {
     //        $title = Menu::where('key', $page)->value('name');
     $categories = Category::orderBy('sort', 'asc')->get();
     $menuHtml = $this->menuHtml($page);
     if (session()->has('cart')) {
         $cartItems = session()->get('cart');
         $sum = $cartItems->sum();
         $count = count($cartItems->all());
     } else {
         $sum = 0;
         $count = 0;
     }
     $menuItems = Menu::all();
     $products = Product::with('category')->orderBy('views', 'desc')->take(8)->get();
     $bottomMenuHtml = view('bottom', ['menuItems' => $menuItems])->render();
     $page = Page::where('key', 'index')->first();
     return view('index', ['menuHtml' => $menuHtml, 'menuBottomHtml' => $bottomMenuHtml, 'categories' => $categories, 'count' => $count, 'sum' => $sum, 'products' => $products, 'indexFlag' => true, 'page' => $page]);
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int $id
  * @return Response
  */
 public function edit($id)
 {
     $data['checkbox'] = Size::all();
     $data['product'] = Product::with('brands', 'size', 'category')->find($id);
     return view('product.edit', $data);
 }

 public function showTrainCarProduct($id, $depoId, ProductRepositoryInterface $productFromRepository, ProductCart $cart)
 {
     try {
         $product = Product::with(['price', 'price.stantion'])->where('id', $id)->first();
     } catch (ModelNotFoundException $e) {
         abort(404);
     }
     if (!$product) {
         abort(404);
     }
     if ($product->category_id) {
         $productParams = $productFromRepository->getProductProperties($id, true);
     } else {
         $productParams = $productFromRepository->getProductProperties($id, false);
     }
     $prices = $product->price;
     $pricesArr = [];
     foreach ($prices as $price) {
         if ($price->price > 0 && $price->amount > 0) {
             $pricesArr[$price->stantion[0]->train_road->tr_name][] = ['stantion_name' => $price->stantion[0]->stantion_name, 'stantion_id' => $price->stantion[0]->id, 'price_id' => $price->id, 'product_id' => $product->id, 'price' => $price->price, 'amount' => $price->amount];
         }
     }
     unset($prices);
     if (Auth::guest()) {
         $userID = 0;
     } else {
         $userID = Auth::user()->id;
     }
     $sumAndCount = $this->getGeneralViewOfCart($cart);
     return view('purchases.showTrainCarProduct', ['p' => 'purchases', 'depoId' => $depoId, 'productParams' => $productParams, 'prices' => $pricesArr, 'product' => $product, 'userID' => $userID, 'productsCount' => $sumAndCount['productsCount'], 'productsSum' => $sumAndCount['productsSum']]);
 }

 public function getDetail($id)
 {
     $mark = Mark::find($id);
     $products = Product::with('mark')->where('mark_id', '=', $id)->get();
     return view("products.detail")->with(array('mark' => $mark, 'products' => $products));
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $product = Product::with(['price'])->where('id', $id)->first();
     DB::transaction(function () use($product) {
         $product->price()->detach();
         foreach ($product->price as $price) {
             $price->delete();
         }
         $product->delete();
     });
     return back()->with('alert-success', 'Товар ' . $product->name . ' удален');
 }