/**
* 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'));
}
