Esempio n. 1
0
 public function index($subject_id = 0)
 {
     $subject = Subject::findOrFail($subject_id);
     $teachers = Teacher::whereHas('subjects', function ($q) use($subject) {
         $q->where('subject_subjects.id', $subject->id);
     })->get();
     $active_teachers = Teacher::isActive()->whereNotIn('teachers.id', $teachers->pluck('id')->toArray())->pluck('name', 'id')->toArray();
     return view('subject::teachers.index', compact('subject', 'teachers', 'active_teachers'));
 }
Esempio n. 2
0
 public function teachers($id)
 {
     $subjects = Teacher::whereHas('subjects', function ($query) use($id) {
         $query->where('subject_subjects.id', $id);
     })->isActive()->get();
     return $subjects;
 }