alfa.3 version; backend designer and front-end embeder enabled

1 files changed, 231 insertions, 36 deletions

diff --git a/public/app/controllers/admin/Course_admin.php b/public/app/controllers/admin/Course_admin.php
index 72ddc79..f68ead2 100644
--- a/public/app/controllers/admin/Course_admin.php
+++ b/public/app/controllers/admin/Course_admin.php
@@ -168,11 +168,12 @@ class Course_admin {
         );
 
         if (isset($post['media'])) {
-            // update media's privileges
+            // update media's privileges; NOTE: media table
             self::update_medias_privileges($post['media'], $post['privilege_id']);
 
-            // set lesson's media files
-            self::create_medias_for_lesson($post['media'], $id, $post['privilege_id']);
+            // set lesson's media files; NOTE: lesson_media table
+            // ERROR: self::create_medias_for_lesson($post['media'], $id, $post['privilege_id']);
+            self::create_medias_for_lesson($post['media'], $id);
         }
 
         return true;
@@ -226,41 +227,13 @@ class Course_admin {
 
         if (isset($post['media'])) {
             // update lesson's media files
-            self::create_medias_for_lesson($post['media'], $post['id'], $post['privilege_id']);
+            // ERROR: self::create_medias_for_lesson($post['media'], $post['id'], $post['privilege_id']);
+            self::create_medias_for_lesson($post['media'], $post['id']);
         }
 
         return true;
     }
 
-    /** update medias privileges
-     * 
-     * @param $medias (array) : array of media id(s)
-     * @param $privilege (int) : privilege id
-     * @return true (always)
-     */
-    private static function update_medias_privileges($medias, $privilege)
-    {
-        // create WHERE IN (LIST) holders and params for prepare statement
-        $params = [ ':privilege' => $privilege];
-        $holders = [];
-        foreach($medias as $key => $media) {
-            $params[':id'.$key] = $media;
-            $holders[] = ':id'.$key;
-        }
-        $list = '('. implode(',', $holders) .')';
-
-        // print_r(['params' => $params, 'list' => $list]); die();
-
-        Registry::use('database')->runQuery(
-            "UPDATE media SET privilege_id = :privilege
-            WHERE id IN {$list}",
-            $params
-        );
-
-        return true;
-    }
-
-
 
     ## -------------------------------------------------------------------------
     ##
@@ -271,6 +244,7 @@ class Course_admin {
 
     /** files
      * echo all files
+     * 
      * @return (array)
      */
     public static function files()
@@ -434,11 +408,12 @@ class Course_admin {
     }
 
 
-    /** create media for post
+    /** create media for lesson
+     * 
+     * links lesson to each media-file of the media `id`s array
      * 
-     * links post to each media-file of the media `id`s array
      * @param $media (array): a list of media-file `id`s
-     * @param $post_id (int)
+     * @param $lesson_id (int)
      */
     private static function create_medias_for_lesson($medias, $lesson_id)
     {
@@ -449,6 +424,22 @@ class Course_admin {
     }
 
 
+    /** create media for page
+     * 
+     * links page to each media-file of the media `id`s array
+     * 
+     * @param $media (array): a list of media-file `id`s
+     * @param $page_id (int)
+     */
+    private static function create_medias_for_page($medias, $page_id)
+    {
+        foreach($medias as $key => $medi) {
+            self::link_media_to_page($medi, $page_id);   // link to page
+        }
+        return true;
+    }
+
+
     /** link one media-file to a specific post
      *
      * NOTE:
@@ -471,5 +462,209 @@ class Course_admin {
         return true;
     }
 
+    /** link one media-file to a specific page
+     *
+     * NOTE:
+     * the method does not check if media is linked already
+     * so be sure that the pair of (media_id, page_id) not exist
+     * 
+     * @param $media_id (int)
+     * @param $page_id (int)
+     */
+    private static function link_media_to_page( $media_id, $page_id )
+    {
+        Registry::use('database')->runQuery(
+            "INSERT INTO page_media (page_id, media_id)
+            VALUES (:page, :media)",
+            [
+                'page' => $page_id,
+                'media' => $media_id,
+            ]
+        );
+        return true;
+    }
+
+
+    /** update medias privileges
+     * 
+     * UPDATE media SET privige WHERE IN {list}
+     * 
+     * @param $medias (array) : array of media id(s)
+     * @param $privilege (int) : privilege id
+     * @return true (always)
+     */
+    private static function update_medias_privileges($medias, $privilege)
+    {
+        // create WHERE IN (LIST) holders and params for prepare statement
+        $params = [ ':privilege' => $privilege];
+        $holders = [];
+        foreach($medias as $key => $media) {
+            $params[':id'.$key] = $media;
+            $holders[] = ':id'.$key;
+        }
+        $list = '('. implode(',', $holders) .')';
+
+        // print_r(['params' => $params, 'list' => $list]); die();
+
+        Registry::use('database')->runQuery(
+            "UPDATE media SET privilege_id = :privilege
+            WHERE id IN {$list}",
+            $params
+        );
+
+        return true;
+    }
+
+
+
+
+
+
+    ## -------------------------------------------------------------------------
+    ##
+    ## PAGE METHODS
+    ##
+    ## -------------------------------------------------------------------------
+
+
+    /** all pages
+     * 
+     */
+    public static function all_pages()
+    {
+        Render::json(Registry::use('database')->runQuery(
+            "SELECT * FROM page", []
+        ));
+    }
+
+
+    /** get_page
+     * 
+     * @param $id (int) : page's id
+     */
+    public static function get_page($id)
+    {
+        // get (first) page with id = $id; render as json
+        Render::json(Registry::use('database')->query(
+            "SELECT page.*, 
+            ( SELECT
+                CONCAT('[', GROUP_CONCAT(JSON_OBJECT(
+                    'id', media.id,
+                    'label', media.label,
+                    'type', media.type,
+                    'path', media.path )),
+                ']')
+                FROM media
+                LEFT JOIN page_media ON page_media.media_id = media.id
+                WHERE page_media.page_id = :id
+            ) AS medias_json
+            FROM page
+            WHERE page.id = :id",
+            [ ':id' => $id]
+        )->getFirst());
+    }
+
+
+    /** add_page
+     * insert a new page
+     * 
+     * all parametres are passed via $_POST array
+     * 
+     * POST @param title
+     * POST @param body
+     * POST @param status (int): 0 = draft , 1 = published
+     */
+    public static function add_page()
+    {
+        $post = Registry::get('REQUEST')->POST;
+
+        // insert page content into daabase
+        $id = Registry::use('database')->query(
+            "INSERT INTO page (title, `body`, `status`)
+            VALUES (:title, :body, :status)",
+            [
+                ':title' => $post['title'],
+                ':body' => $post['body'],
+                'status' => $post['status']
+            ]
+        )->lastInsertID();
+
+
+        if (isset($post['media'])) {
+            // update media's privileges;
+            // NOTE: media table; pages have public files (privilege_id=0)
+            self::update_medias_privileges($post['media'], 0);
+
+            // set page's media files
+            // NOTE: page_media table
+            self::create_medias_for_page($post['media'], $id);
+        }
+
+        self::update_pages_cache();     // update pages cache
+
+        return true;
+    }
+
+
+    /** update_page
+     * 
+     * POST @param id (int)
+     * POST @param title
+     * POST @param body
+     * POST @param status (int): 0 = draft , 1 = published
+     */
+    public static function update_page()
+    {
+        $post = Registry::get('REQUEST')->POST;
+
+        // print_r($post); die();
+
+        // update page's content
+        Registry::use('database')->query(
+            "UPDATE page
+                SET title = :title, `body` = :body, `status` = :status
+            WHERE id = :id",
+            [
+                ':id' => $post['id'],
+                ':title' => $post['title'],
+                ':body' => $post['body'],
+                ':status' => $post['status']
+            ]
+        );
+
+        if (isset($post['media'])) {
+            // update media's privileges
+            self::update_medias_privileges($post['media'], 0);
+        }
+
+        // remove all old page's links to media files
+        Registry::use('database')->runQuery(
+            "DELETE from page_media WHERE page_id = :page",
+            [ ':page' => $post['id'] ]
+        );
+
+        if (isset($post['media'])) {
+            // update page's media files
+            self::create_medias_for_page($post['media'], $post['id']);
+        }
+
+        self::update_pages_cache();     // update pages cache
+
+        return true;
+    }
+
+
+    /** update pages cache
+     * --- -- -- - - -
+     * Forces re-caching of pages tree
+     * Shall run if anything changes to courses
+     * 
+     * @param void
+     * @return (array): ['tree' => ..., 'breadcrumbs' => ... ]
+     */
+    public static function update_pages_cache()
+    {
+        return Cache_service::pages_list(PROXY_IGNORE_CACHE);
+    }
 
 }
\ No newline at end of file