1 files changed, 22 insertions, 0 deletions
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;
+    }
 
 }