From bf823c5063b5ad863e7e7cc313fb1406ddd14a98 Mon Sep 17 00:00:00 2001
From: horus
Date: Mon, 13 Apr 2020 23:25:42 +0200
Subject: Add new page popular topics.

---
 app/Http/Controllers/IndexController.php | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'app/Http/Controllers/IndexController.php')

diff --git a/app/Http/Controllers/IndexController.php b/app/Http/Controllers/IndexController.php
index cb401b5..bb1d301 100644
--- a/app/Http/Controllers/IndexController.php
+++ b/app/Http/Controllers/IndexController.php
@@ -104,4 +104,20 @@ class IndexController extends Controller
 
             return view('list', ["articles" => $articles, "count" => $count]);
     }
+
+    public function populartopics() {
+	    $topics = DB::select("
+			SELECT
+			    c.name,
+			    count(c.name) AS count
+			FROM category AS c
+			JOIN
+				article_category AS ac ON c.id = ac.category_id
+			GROUP BY
+				c.name
+			ORDER BY count(c.name) DESC;");
+#echo "<pre>"; var_dump($topics);exit;
+
+	    return view('topicpopular', ['topics' => $topics ]);
+    }
 }
-- 
cgit v1.2.3