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