/** * Get the query object to be processed by datatables. * * @return \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder */ public function query() { $articles = Article::with('category')->whereHas('category', function ($q) { $q->where('language_id', session('current_lang')->id); }); return $this->applyScopes($articles); }
/** * Get article data from 'LTF Talk' category to first page * @return mixed */ public function getLatestTalk() { $category = 'LTF Talk'; $talk = Article::with(['category', 'user'])->whereHas('category', function ($query) use($category) { $query->where('title', '=', $category); })->published()->orderBy('published_at', 'desc')->take(1)->get(); return $talk; }