public function sc($id)
{
$episode = Episode::find($id, ['id', 'drama_id', 'title']);
$drama = Drama::find($episode->drama_id, ['title']);
$roles = Role::with(['sc' => function ($query) {
$query->select('id', 'name');
}])->select('id', 'sc_id', 'job', 'note')->where('episode_id', $id)->orderBy('job')->get();
$episodes = Episode::select('id', 'title')->where('drama_id', $episode->drama_id)->where('id', '!=', $id)->get();
return view('episode.sc', ['episode' => $episode, 'drama' => $drama, 'roles' => $roles, 'episodes' => $episodes]);
}
public function sc($id)
{
$drama = Drama::find($id, ['id', 'title']);
$episodes = Episode::select('id', 'title')->where('drama_id', $id)->orderByRaw('release_date, id')->get();
$roles = Role::with(['sc' => function ($query) {
$query->select('id', 'name');
}])->select('id', 'episode_id', 'sc_id', 'job', 'note')->where('drama_id', $id)->orderBy('job')->get();
$roles = $roles->groupBy('episode_id');
return view('drama.sc', ['drama' => $drama, 'episodes' => $episodes, 'roles' => $roles]);
}
