@php use App\Models\Student; use App\Models\EnrollmentModule\{EnrollmentClass, EnrollmentClassHistory}; use Carbon\Carbon; $getStudentEnrollmentIds = $student->student_allenrollments->pluck('id')->toArray(); $getStudentEnrollmentClasses = EnrollmentClass::whereIn('enrollment_id', $getStudentEnrollmentIds)->get(); // $getClassesIds = $getStudentEnrollmentClasses->pluck('class_id')->toArray(); $getStudentEnrollmentClassesIds = $getStudentEnrollmentClasses->pluck('id')->toArray(); $enrollmentClassHistories = EnrollmentClassHistory::join('enrollment_classes', 'enrollment_classes.id', '=', 'enrollment_class_histories.enrollment_class_id') ->join('da_classes', 'da_classes.id', '=', 'enrollment_classes.class_id') ->whereIn('enrollment_class_histories.enrollment_class_id', $getStudentEnrollmentClassesIds) // Use enrollment_id from enrollment_classes ->where(function ($query) { $query->where('enrollment_class_histories.status', 1) // Admitted ->orWhere('enrollment_class_histories.status', 2); // Graduated }) ->select('enrollment_class_histories.*', 'enrollment_classes.class_id', 'da_classes.name') // Select necessary columns ->get(); @endphp