From b594effb847b86fc6b1dae49d7948c46bba35e58 Mon Sep 17 00:00:00 2001
From: George Halkiadakis <gchalkiadakis@sklavenitis.co.gr>
Date: Tue, 25 Apr 2023 16:45:03 +0300
Subject: alfa version; uploaded into test server (coder)

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

(limited to 'public/app/models/cms')

diff --git a/public/app/models/cms/Course_model.php b/public/app/models/cms/Course_model.php
index d8a8a0e..6378226 100644
--- a/public/app/models/cms/Course_model.php
+++ b/public/app/models/cms/Course_model.php
@@ -244,9 +244,8 @@ class Course_model {
 
     /** lessons of course
      * 
-     * @param $course_id
+     * @param $id (int) : course_id
      */
-
     public static function lessons_of_course($id)
     {
         // TODO: order results in some way
@@ -254,11 +253,28 @@ class Course_model {
         return Registry::use('database')->runQuery(
             "SELECT lesson.*, lesson_privilege.privilege_id FROM lesson
             LEFT JOIN lesson_privilege ON lesson_privilege.lesson_id = lesson.id
-            WHERE lesson.status = 1 AND lesson.course_id = :id",
+            WHERE lesson.status = 1 AND lesson.course_id = :id
+            ORDER BY lesson_privilege.privilege_id ASC",
             [':id' => $id]
         );
     }
 
+    /** lesson
+     * 
+     * @param $id (int) : lesson id
+     */
+    public static function lesson($id)
+    {
+        // TODO: order results in some way
+
+        return Registry::use('database')->query(
+            "SELECT lesson.*, lesson_privilege.privilege_id FROM lesson
+            LEFT JOIN lesson_privilege ON lesson_privilege.lesson_id = lesson.id
+            WHERE lesson.status = 1 AND lesson.id = :id",
+            [':id' => $id]
+        )->getFirst();
+    }
+
 
 
     /** files
-- 
cgit v1.2.3