PHP Item::with方法代码示例

 public function storeComment($itemId, Request $request)
 {
     $item = Item::with('comments.user')->findOrFail($itemId);
     $comment = new Comment(['user_id' => $request->userId, 'message' => $request->message]);
     $newComment = $item->comments()->save($comment);
     $result = Comment::with('user')->findOrFail($newComment->id);
     event(new UserPostedAComment($result));
     return $result;
 }

 public function show($id)
 {
     $list = Dramalist::find($id);
     $list->load(['user' => function ($query) {
         $query->select('id', 'name');
     }]);
     $items = Item::with(['drama' => function ($query) {
         $query->select('id', 'title', 'type', 'era', 'genre', 'original', 'count', 'state', 'sc', 'poster_url');
     }, 'episode' => function ($query) {
         $query->select('id', 'title', 'alias', 'release_date', 'duration', 'poster_url');
     }])->select('id', 'no', 'drama_id', 'episode_id', 'review', 'created_at', 'updated_at')->where('list_id', $id)->orderBy('no')->paginate(20);
     return view('list.show', ['list' => $list, 'items' => $items]);
 }

 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     $start = microtime(true);
     $collection = Item::with('files')->search($this->argument('term'))->get()->take($this->argument('results'));
     $rows = [];
     foreach ($collection as $item) {
         $path = $item->path;
         $rows[] = ['Item', $item->title, $path];
         foreach ($item->files as $file) {
             $rows[] = ['File', "- {$file->filename}", "{$path}/{$file->filename}"];
         }
     }
     $end = microtime(true);
     $this->table(['type', 'filename', 'path'], $rows);
     $this->line("Took " . round($end - $start, 3) . "s to search");
 }

 public function getEdit($id = null)
 {
     $item = \App\Item::with('stores')->find($id);
     //Get data for the item to be edited
     $amounts_for_dropdown = [0, 25, 50, 75, 100];
     $locations_for_dropdown = ['Aisle', 'Bakery', 'Bulk', 'Dairy', 'Meat', 'Produce', 'Seafood', 'Specialty'];
     $storeModel = new \App\Store();
     //Call the model to get an array of all the possible stores with their id
     $stores_for_checkbox = $storeModel->getStoresForCheckboxes();
     $stores_for_this_item = [];
     foreach ($item->stores as $store) {
         //Create an array of store names for this food item
         $stores_for_this_item[] = $store->name;
     }
     return view('items.edit')->with(['item' => $item, 'amounts_for_dropdown' => $amounts_for_dropdown, 'locations_for_dropdown' => $locations_for_dropdown, 'stores_for_checkbox' => $stores_for_checkbox, 'stores_for_this_item' => $stores_for_this_item]);
 }

 public function demo()
 {
     $new_items = Item::with('itemTags', 'itemInto.item', 'itemFrom.item', 'itemMaps')->get();
     return View::make('item.alldemo')->with('items', $new_items);
 }

 /**
  * Show the form for editing the specified resource.
  *
  * @param  int $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $categories = $this->categories;
     try {
         $item = Item::with('images')->findOrFail($id);
     } catch (ModelNotFoundException $ex) {
         Flash::error('No item found' . $ex);
         return redirect()->route('store.items.index');
     }
     return view('store.items.edit', compact('item', 'categories'));
 }