public function students($classroom_id, $student_id = null) { $classroom = Classroom::findOrFail($classroom_id); //->has('students', '<=', 'classrooms.attendees_limit') $classrooms = Classroom::select(DB::raw('CONCAT(hour , "-", code , "-" , day) as code , id'))->where('subject_subject_id', $classroom->subject_subject_id)->whereIn('classrooms.gender', [$classroom->gender, 'b'])->inCurrentSemester()->pluck('code', 'id')->toArray(); $days = $this->days; foreach ($classrooms as $key => $value) { $day = substr($value, -1); $new_day = $days[$day]; $classrooms[$key] = substr_replace($classrooms[$key], $new_day, -1); } $subjects = Subject::where('id', $classroom->subject_subject_id)->first()->name; $students = Student::with(['classrooms' => function ($query) use($classroom_id, $student_id) { return $query->where('classrooms.id', $classroom_id); }]); if (isset($student_id)) { $students = $students->whereHas('classrooms', function ($query) use($classroom_id, $student_id) { $query->where('classrooms.id', $classroom_id)->where('students.username', $student_id); })->get(); } else { $students = $students->whereHas('classrooms', function ($query) use($classroom_id, $student_id) { $query->where('classrooms.id', $classroom_id); })->get(); } // dd($classrooms); return view('classrooms::classrooms.students', compact('students', 'classroom', 'classrooms', 'subjects')); }
public function classroomsedit($student_id, $classroom_id) { $student = Student::findOrFail($student_id); //$subjects = Subject::with('classroom')->Student($student->id)->findOrFail($subject_id); $subject_id = Classroom::findOrFail($classroom_id)->subject_subject_id; $classrooms = Classroom::with('students')->where('subject_subject_id', $subject_id)->get(); // dd($subject_id); // $classroom_id= $classrooms->id; return view('students::classrooms.edit', compact('classroom_id', 'student', 'classrooms', 'student_id')); }