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