finally sorting new articles by last discussion

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