diff options
Diffstat (limited to 'app')
| -rw-r--r-- | app/Http/Controllers/IndexController.php | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/app/Http/Controllers/IndexController.php b/app/Http/Controllers/IndexController.php index 62bec0e..7e7b31b 100644 --- a/app/Http/Controllers/IndexController.php +++ b/app/Http/Controllers/IndexController.php @@ -48,7 +48,11 @@ class IndexController extends Controller public function new() { - $articles = Article::orderBy('created_at', 'desc'); + $articles = Article::join('discussion', 'discussion.article_id', '=', 'view_article.id') + ->select('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') + ->groupBy('view_article.id', 'view_article.article_id', 'view_article.url', 'view_article.title', 'view_article.excerpt_html', 'view_article.impact', 'view_article.upvotes', 'view_article.comments', 'view_article.repost') + ->orderByRaw('MAX(discussion.posted_on) DESC'); + $count = $articles->count(); $articles = $articles->simplePaginate(10); |