From 4123e50ad63c2db8150bed396c6de44ec30fbffd Mon Sep 17 00:00:00 2001 From: horus Date: Sun, 29 Mar 2026 04:42:34 +0200 Subject: finally sorting new articles by last discussion --- app/Http/Controllers/IndexController.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'app/Http/Controllers/IndexController.php') 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); -- cgit v1.2.3