public function show(Request $request, $id) { $club = Club::find($id, ['id', 'name', 'information', 'reviews']); $scs = Sc::select('id', 'name')->where('club_id', $id)->get(); $reviews = Screv::with(['user' => function ($query) { $query->select('id', 'name'); }])->select('id', 'user_id', 'title', 'content', 'created_at')->where('model_id', $id)->where('model', 1)->orderBy('id', 'desc')->take(20)->get(); if (Auth::check()) { $userReviews = Screv::select('id', 'title', 'content', 'created_at')->where('user_id', $request->user()->id)->where('model_id', $id)->where('model', 1)->get(); } else { $userReviews = 0; } return view('club.show', ['club' => $club, 'scs' => $scs, 'reviews' => $reviews, 'userReviews' => $userReviews]); }
public function show(Request $request, $id) { $sc = Sc::find($id, ['id', 'name', 'alias', 'club_id', 'jobs', 'information', 'reviews']); $sc->load(['club' => function ($query) { $query->select('id', 'name'); }]); $roles = Role::with(['drama' => function ($query) { $query->select('id', 'title'); }, 'episode' => function ($query) { $query->select('id', 'title'); }])->select('drama_id', 'episode_id', 'job', 'note')->where('sc_id', $id)->orderBy('id', 'desc')->take(10)->get(); $reviews = Screv::with(['user' => function ($query) { $query->select('id', 'name'); }])->select('id', 'user_id', 'title', 'content', 'created_at')->where('model_id', $id)->where('model', 0)->orderBy('id', 'desc')->take(20)->get(); if (Auth::check()) { $userReviews = Screv::select('id', 'title', 'content', 'created_at')->where('user_id', $request->user()->id)->where('model_id', $id)->where('model', 0)->get(); } else { $userReviews = 0; } return view('sc.show', ['sc' => $sc, 'roles' => $roles, 'reviews' => $reviews, 'userReviews' => $userReviews]); }