From d0c76376fd736a84c7824d8521c5792060f69086 Mon Sep 17 00:00:00 2001 From: Syndamia Date: Sat, 1 Feb 2025 09:13:33 +0200 Subject: feat(views/list): Show all items in a list --- models/archivelist.php | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'models') diff --git a/models/archivelist.php b/models/archivelist.php index 09d5d86..75bee1f 100644 --- a/models/archivelist.php +++ b/models/archivelist.php @@ -38,4 +38,15 @@ class ArchiveList extends Table { "(\"$WID\", \"$this->LID\", \"0\")" ); } + + function allItems() : array { + return Table::_get_all( + 'Webpages', + 'Database\Webpage', + "INNER JOIN ArchiveListsWebpages ON Webpages.WID = ArchiveListsWebpages.WID + WHERE ArchiveListsWebpages.LID = $this->LID + ORDER BY ArchiveListsWebpages.Position ASC", + 'Webpages.*' + ); + } } -- cgit v1.2.3