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'));
}
