public function index() { $tags = Request::input('tags'); $categories = Request::input('categories'); $sort = Request::input('sort', 'created_at'); $order = Request::input('order', 'desc'); $searcher = Article::whereRaw('1=1'); trim($tags) != '' && $searcher->whereRaw('tags like \'%"' . $tags . '"%\''); trim($categories) != '' && $searcher->whereRaw('categories like \'%"' . $categories . '"%\''); isset($sort) && isset($order) && $searcher->orderBy($sort, $order); $articles = $searcher->paginate(10); $hot_articles = (new DuoShuo())->getHotArticles([], false); $categories = []; $tags = []; return Response::view('frontend.index', ['articles' => $articles, 'hotArticles' => $hot_articles]); }
/** * 显示文章列表(页面) * * @return Response */ public function index() { if (Request::ajax() && array_key_exists('HTTP_X_PJAX', $_SERVER) && $_SERVER['HTTP_X_PJAX']) { return response()->view('backend.article'); } else { if (Request::ajax()) { $search = Request::input('search', ''); $sort = Request::input('sort'); $order = Request::input('order'); $limit = Request::input('limit'); $offset = Request::input('offset'); // \DB::enableQueryLog(); $searcher = Article::whereRaw('1=1'); trim($search) != '' && $searcher->whereRaw('concat(title,content_md) like \'%' . $search . '%\''); $total = $searcher->count(); isset($offset) && isset($limit) && $searcher->skip($offset)->take($limit); isset($sort) && isset($order) && $searcher->orderBy($sort, $order); $data = $searcher->get(); return ['total' => $total, 'rows' => $data]; } } return response('错误的列表', 404); }