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