diff options
Diffstat (limited to 'public/app/models')
| -rw-r--r-- | public/app/models/.gitkeep | 0 | ||||
| -rw-r--r-- | public/app/models/cms/Course_model.php | 22 |
2 files changed, 19 insertions, 3 deletions
diff --git a/public/app/models/.gitkeep b/public/app/models/.gitkeep new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/public/app/models/.gitkeep 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 |