public function catDate($cat, $date) { $article = new Article(); $items = Article::select('id', 'body', 'title', 'head', 'published_at', 'slug', 'author', 'translate_slug', 'img', 'lang')->whereBetween('published_at', [$date . ' 00:00:00', $date . ' 23:59:00'])->published()->bycatslug($cat)->language()->latest()->take(get_setting('pagination_num'))->get(); $count = Article::whereBetween('published_at', [$date . ' 00:00:00', $date . ' 23:59:00'])->published()->bycatslug($cat)->language()->count(); return view('theme.pages.view.date', compact('items', 'article', 'count', 'date', 'cat')); }
public function showArticleByYear($year) { $maxYear = (int) substr(Article::max('created_at'), 0, 4); $minYear = (int) substr(Article::min('created_at'), 0, 4); $between = $this->getYearsBetween($year); $articles = Article::whereBetween('created_at', $between)->orderBy('id', 'DESC')->get(); $lenght = count($articles) / 10; $imageDir = $this->parseData($articles); return view('article', compact('articles', 'lenght', 'imageDir', 'maxYear', 'minYear')); }