public function traineeHome() { $id = Auth::user()->id; $regId = Registration::where('user_id', '=', Auth::user()->id)->pluck('id'); $user_id = Auth::user()->id; $course_ids = TraineeCourse::where('trainee_id', $user_id)->select('course_id')->get(); //$course_ids=Info::where('trainee_login_id', $user_id)->get(); $courseAttendance = []; foreach ($course_ids as $course_id) { $course_name = $this->course_name_by_course_id($course_id->course_id); if (!$course_name->isempty()) { $absent = Attendance::where('course_id', $course_id->course_id)->where('trainee_id', $user_id)->where('trainee_attendance', '=', 'A')->count('id'); $courseAttendance[] = array('course_name' => $course_name, 'absent' => $absent); } } $info = Info::wheretrainee_login_id($user_id)->firstOrFail(); return view('trainee.trainee', compact('regId', 'courseAttendance', 'info')); //dd($regId); return view('trainee.trainee', compact('regId'))->with('id', $id); }