@php $ste = DB::table('booking') ->select('booking.*', 'student_attendence.*','students.*', 'students.id as sid', DB::raw("CONCAT(students.firstname,' ',students.lastname) as studentname"), 'student_attendence.is_student_present as attendence', 'users.name', 'users.mobile as usermobile') // select fields from both tables ->join('students', 'booking.student_id', '=', 'students.id') ->leftjoin('users', 'students.user_id', '=', 'users.id') ->leftJoin('student_attendence', 'student_attendence.booking_id', '=', 'booking.id') // join studentattendence ->where('booking.class_id', $class_id) ->where(['student_attendence.class_date' => $datec, 'student_attendence.class_id' => $class_id]) ->whereNotNull('booking.student_id') ->where('booking.is_hide_student', 'no') ->whereNotIn('booking.booking_status', ['move', 'move_to_full_term', 'cancel']) ->orderBy('students.lastname', 'asc') ->get(); //echo "toArray());exit; @endphp

Class Date: {{ date('d/m/Y', strtotime($datec)) }}Student: {{ count($ste) }}

{{ $classage->franchise->name }} {{ $classage->venue->name }} {{ ucfirst($classage->weekday) }} {{ $classage->classage->class_age_from . '-' . $classage->classage->class_age_to }} years {{ date('H:ia', strtotime($classage->start_time)) }}-{{ date('H:ia', strtotime($classage->end_time)) }}

@foreach ($ste as $st)

Name

Register

Age

DOB

Gender

Medical Notes

Contact