public function index(Request $request)
{
if ($request->has('sort')) {
$sort = $request->input('sort');
} else {
$sort = 'id';
}
$lists = Dramalist::with(['user' => function ($query) {
$query->select('id', 'name');
}])->select('id', 'user_id', 'title', 'introduction', 'created_at', 'updated_at')->orderBy($sort, 'desc')->paginate(50);
return view('list.index', ['lists' => $lists, 'sort' => $sort]);
}
public function lists($id)
{
$episode = Episode::find($id, ['id', 'drama_id', 'title']);
$drama = Drama::find($episode->drama_id, ['id', 'title']);
$items = Item::select('list_id', 'created_at')->where('episode_id', $id)->orderBy('id', 'desc')->paginate(50);
$listids = $items->pluck('list_id');
$lists = Dramalist::with(['user' => function ($query) {
$query->select('id', 'name');
}])->select('id', 'title', 'user_id')->whereIn('id', $listids)->get();
return view('episode.lists', ['episode' => $episode, 'drama' => $drama, 'items' => $items, 'lists' => $lists]);
}
