function showList() { $this->beforeLogin(); $today = date('Y-m-d'); $yesterday = date('Y-m-d', strtotime('-1 day')); $user = $_SESSION['user']['name']; $subscribes = \App\Model\Subscribe::whereUser($user)->whereStatus(0)->get(); $subscribeIds = []; foreach ($subscribes as $v) { $subscribeIds[] = $v->source; } $newsListOfToday = \App\Model\News::where('gmt_create', '>', $today)->whereIn('source', $subscribeIds)->orderBy('id', 'desc')->get(); foreach ($newsListOfToday as &$v) { $v->source = \App\Model\Source::whereId($v->source)->first(); } $newsListOfYesterday = \App\Model\News::where('gmt_create', '>', $yesterday)->whereIn('source', $subscribeIds)->where('gmt_create', '<', $today)->orderBy('id', 'desc')->get(); foreach ($newsListOfYesterday as &$v) { $v->source = \App\Model\Source::whereId($v->source)->first(); } return view('home/index', ['newsListOfToday' => $newsListOfToday, 'newsListOfYesterday' => $newsListOfYesterday, 'today' => date('m-d'), 'yesterday' => date('m-d', strtotime('-1 day'))]); }
/** * Display the specified resource. * Hiển thị chi tiết 01 bài viết và các comments nếu có * @param int $id * @return Response */ public function show($news_url) { $news = News::where('news_url', $news_url)->first(); $news->comment; return Response::json($news); }
function getById($id) { return News::where('id', $id)->get(); }