/** * 一覧表示 * * @param Request $request * @return \Illuminate\View\View */ public function index(Request $request) { // カテゴリ $categories = TextDiaryCategory::orderBy('display_order')->get(); $builder = TextDiary::with('textDiaryCategories')->with('flickrs'); if ($request->has('category')) { $builder->whereHas('textDiaryCategories', function ($query) use($request) { // 選択したカテゴリで絞込 $query->where('id', '=', $request->input('category')); }); } $textDiaries = $builder->latest('datetime')->paginate(config('const.max_text_diary')); return view('textDiary.index', compact('categories', 'textDiaries')); }