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')); }
public function teachers($id) { $subjects = Teacher::whereHas('subjects', function ($query) use($id) { $query->where('subject_subjects.id', $id); })->isActive()->get(); return $subjects; }