several hot-fixes; working on lessons flash-management

3 files changed, 27 insertions, 9 deletions

diff --git a/public/app/controllers/admin/Course_admin.php b/public/app/controllers/admin/Course_admin.php
index 90aaa53..bb4deb0 100644
--- a/public/app/controllers/admin/Course_admin.php
+++ b/public/app/controllers/admin/Course_admin.php
@@ -105,6 +105,19 @@ class Course_admin {
     ## -------------------------------------------------------------------------
 
 
+    /** all lessons
+     * 
+     */
+    public static function all_lessons()
+    {
+        Render::json(Registry::use('database')->runQuery(
+            "SELECT lesson.*, lesson_privilege.privilege_id FROM lesson
+            LEFT JOIN lesson_privilege ON lesson_privilege.lesson_id = lesson.id",
+            []
+        ));
+    }
+
+
     /** get_lesson
      * 
      * @param $id (int) : lesson's id
diff --git a/public/app/routes/backend.php b/public/app/routes/backend.php
index 7f4717d..5d6189d 100644
--- a/public/app/routes/backend.php
+++ b/public/app/routes/backend.php
@@ -135,18 +135,26 @@ Route::add('/admin/api/lesson/([0-9]*)', function ($id) {
     Course_admin::get_lesson($id);
 });
 
-
+// ajax: add lesson
+// ---
 Route::add('/admin/api/lesson/add', function () {
     Auth::allowRoles([1, 2, 3]);    // allow few admin-panel roles
     Course_admin::add_lesson();
 }, 'post');
 
-
+// ajax: update lesson
+// ---
 Route::add('/admin/api/lesson/update', function () {
     Auth::allowRoles([1, 2, 3]);    // allow few admin-panel roles
     Course_admin::update_lesson();
 }, 'post');
 
+// ajax: get all lessons
+// ---
+Route::add('/admin/api/lessons', function () {
+    Auth::allowRoles([1, 2, 3]);    // allow few admin-panel roles
+    Course_admin::all_lessons();
+});
 
 
 // admin files /////////////////////////////////////////////////////////////////
diff --git a/public/app/views/admin/lessons.php b/public/app/views/admin/lessons.php
index 6e7afeb..d1cd3ae 100644
--- a/public/app/views/admin/lessons.php
+++ b/public/app/views/admin/lessons.php
@@ -6,9 +6,6 @@
         <a type="button" class="btn pull-right" href="/admin/edit_lesson">
             <i class="fas fa-plus"></i> &nbsp; Νέο Μάθημα
         </a>
-        <button type="button" class="btn"
-        data-bs-toggle="modal" data-bs-target="#manageLessons" data-action="preview">
-        test</button>
     </div>
 </div>
 
@@ -20,8 +17,9 @@
 
                 <table id="dt-lessons" class="table table-responsive dt-table" style="width:100%">
                     <thead>
+                        <th class="dt-id">α/α</th>
                         <th class="dt-title">Τίτλος</th>
-                        <th class="dt-breadcrumb">Κεφάλαιο</th>
+                        <th class="dt-course">Κεφάλαιο</th>
                         <th class="dt-privileges">Πρόσβαση</th>
                         <th class="dt-actions"></th>
                     </thead>
@@ -29,7 +27,6 @@
 
             </div>
 
-
         </div>
     </div>
 </div><!-- /manage -->
@@ -62,9 +59,9 @@
                 </div>
 
                 <div class="row form-group">
-                    <label class="control-label col-sm-12" for="parent_id">Γονική Κατηγορία</label>
+                    <label class="control-label col-sm-12" for="course_id">Κεφάλαιο</label>
                     <div class="col-sm-12">
-                        <select class="form-control form-control-sm form-select form-select-sm" id="parent_id" name="parent_id" required></select>
+                        <select class="form-control form-control-sm form-select form-select-sm" id="course_id" name="course_id" required></select>
                     </div>
                 </div>