From ae8b6f88a0c31703d5e846fd1717a26b74d5da3b Mon Sep 17 00:00:00 2001
From: Syndamia <kamen@syndamia.com>
Date: Sun, 9 Feb 2025 20:52:35 +0200
Subject: feat: Better home cards, show total view count of pages

---
 models/webpage.php | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'models/webpage.php')

diff --git a/models/webpage.php b/models/webpage.php
index 90ffb45..a42c300 100644
--- a/models/webpage.php
+++ b/models/webpage.php
@@ -70,6 +70,15 @@ class Webpage extends Table {
         );
     }
 
+    function totalViewCount() : int {
+        return Table::_get_all(
+            'Webpages',
+            'Database\Webpage',
+            "WHERE URL = \"$this->URL\"",
+            "SUM(Visits) as WID"
+        )[0]->WID;
+    }
+
     function previousPageId() : int {
         $foundId = Table::_get_all(
             "Webpages",
-- 
cgit v1.2.3