/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $key = ''; if ($request->has('key')) { $key = $request->input('key'); $query = GuideComment::where('title', 'like', '%' . $key . '%')->orWhere('content', 'like', '%' . $key . '%'); } else { $query = GuideComment::select(); } $comments = $query->orderBy('guide_id', 'asc')->orderBy('id', 'desc')->with('guide', 'user')->paginate(20); return view('admin.guide.comments', compact('key', 'comments')); }
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')); }