Important: Fixed issue with IDs, User id was being overwritten by Dep…

…artment id. When creating a course, the teacher id was actually the department id
jstudioo · Jul 28, 2019 · 4994c62 · 4994c62
1 parent 011cc8c
commit 4994c62
Showing 1 changed file with 2 additions and 1 deletion.
diff --git a/app/Http/Controllers/SettingController.php b/app/Http/Controllers/SettingController.php
@@ -16,7 +16,8 @@ public function index() {
         $classes     = Myclass::all();
         $sections    = Section::all();
         $departments = Department::bySchool(\Auth::user()->school_id)->get();
-        $teachers = User::join('departments', 'departments.id', '=', 'users.department_id')
+        $teachers = User::select('departments.*', 'users.*')
+			->join('departments', 'departments.id', '=', 'users.department_id')
             ->where('role', 'teacher')
             ->orderBy('name', 'ASC')
             ->where('active', 1)