From 546daa78721e6abdbc89afcecc158118c2239865 Mon Sep 17 00:00:00 2001
From: George Halkiadakis <gchalkiadakis@sklavenitis.co.gr>
Date: Wed, 26 Apr 2023 21:43:02 +0300
Subject: alfa.3 version; backend designer and front-end embeder enabled

---
 public/app/models/cms/Course_model.php | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

(limited to 'public/app/models/cms/Course_model.php')

diff --git a/public/app/models/cms/Course_model.php b/public/app/models/cms/Course_model.php
index 54f49cf..6614993 100644
--- a/public/app/models/cms/Course_model.php
+++ b/public/app/models/cms/Course_model.php
@@ -288,5 +288,27 @@ class Course_model {
     }
 
 
+    /** pages
+     * 
+     * return all pages as array;
+     * array key of each item shall be the page-id
+     * 
+     * @param void
+     * @return array
+     */
+    public static function pages()
+    {
+        $result = [];
+        $pages =  Registry::use('database')->runQuery("SELECT * FROM page", []);
+        foreach($pages as $key => $page) {
+            $result[ $page['id'] ] = [
+                'title' => $page['title'],
+                'body' => $page['body'],
+                'status' => $page['status']
+            ];
+        }
+        // print_r($result); die();
+        return $result;
+    }
 
 }
-- 
cgit v1.2.3