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 update(Request $request, $id)
{
$this->validate($request, ['sc' => 'required', 'job' => 'required']);
$role = Role::find($id);
if ($sc = Sc::select('id')->where('name', $request->input('sc'))->first()) {
$role->sc_id = $sc->id;
} else {
return redirect()->back()->withInput()->withErrors('未找到该SC');
}
$role->job = $request->input('job');
$role->note = $request->input('note');
$role->user_id = $request->user()->id;
if ($role->save()) {
return redirect()->route('episode.sc', [$role->episode_id]);
} else {
return redirect()->back()->withInput()->withErrors('修改失败');
}
}
public function search(Request $request)
{
$keyword = $request->input('q');
$scs = Sc::select('name', 'alias')->where('name', 'LIKE', '%' . $keyword . '%')->orWhere('alias', 'LIKE', '%' . $keyword . '%')->get();
return $scs;
}
