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