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