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