From 9121554ce064629dc7aef74434b65ee10756a8a7 Mon Sep 17 00:00:00 2001
From: Georgi Nikolov <ggeorgi60@gmail.com>
Date: Sun, 26 Jan 2025 20:28:22 +0200
Subject: Added a navbar on top of the archived pages

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

(limited to 'models')

diff --git a/models/webpage.php b/models/webpage.php
index 3445f62..e6d964f 100644
--- a/models/webpage.php
+++ b/models/webpage.php
@@ -27,6 +27,39 @@ class Webpage extends Table {
         );
     }
 
+    static function getPageById(int $id) : Webpage {
+        return Table::_fromDB(
+            "SELECT * FROM Webpages WHERE WID = \"$id\"",
+            "Database\Webpage"
+        );
+    }
+
+    static function getPreviousPageId(string $url, string $date) : int {
+        $foundId = Table::_get_all(
+            "Webpages",
+            "Database\Webpage",
+            "WHERE URL = \"$url\" && Date < \"$date\" ORDER BY Date DESC LIMIT 1",
+            "WID"
+        );
+        if (count($foundId) > 0) {
+            return $foundId[0]->WID;
+        }
+        return 0;
+    }
+
+    static function getNextPageId(string $url, string $date) : int {
+        $foundId = Table::_get_all(
+            "Webpages",
+            "Database\Webpage",
+            "WHERE URL = \"$url\" && Date > \"$date\" ORDER BY Date ASC LIMIT 1",
+            "WID"
+        );
+        if (count($foundId) > 0) {
+            return $foundId[0]->WID;
+        }
+        return 0;
+    }
+
     static function getPagesCount() : int {
         return Table::_get_entries_count("Webpages");
     }
-- 
cgit v1.2.3