public function lists(Request $request) { $types = $request->input('types'); $key = $request->input('key'); $query = Guide::select(); if ($types != null) { $query->where('types', $types); } if ($key != null) { $query->where('title', 'like', '%' . $key . '%')->orWhere('area', 'like', '%' . $key . '%')->orWhere('tags', 'like', '%' . $key . '%'); } $guides = $query->orderBy('id', 'desc')->paginate(5); $comments = GuideComment::where('isbest', '=', 1)->orderBy('id', 'desc')->with('guide', 'user')->take(5)->get(); return view('guide.list', compact('guides', 'comments', 'types', 'key')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $key = ''; $isbest = $request->input('isbest', 1); if ($request->has('key')) { $key = $request->input('key'); $query = Guide::where('title', 'like', '%' . $key . '%')->orWhere('area', 'like', '%' . $key . '%'); } else { $query = Guide::select(); } $query->where('isbest', $isbest); if ($isbest == 1) { $query->orderBy('orders', 'asc'); } else { $query->orderBy('id', 'desc'); } $guides = $query->paginate(20); return view('admin.guide.index', compact('key', 'guides', 'isbest')); }