@for ($i = 1; $i <= $number_of_days; $i++) @endfor @php $last_period_id = 0; $lab_index = -1; @endphp @foreach ($branch->periods()->where("active",1)->get() as $period) @php $last_schedule_period_id = 0; @endphp @foreach ($period->schedule_periods as $schedule_period) @php $lab_index = -1; @endphp @foreach ($branch->class_rooms()->->where("active",1)->get() as $class_room) @if ($period->id != $last_period_id) @endif @php $last_period_id = $period->id; @endphp @if ($schedule_period->id != $last_schedule_period_id) @endif @php $lab_index++; $last_schedule_period_id = $schedule_period->id; @endphp @for ($i = 1; $i <= $number_of_days; $i++) @php // dd([$course_sessions,date('Y-m-d',strtotime("$year-$month-$i"))]); $course_sessions_rslt = $course_sessions ->where("class_room_id", $class_room->id) ->where("schedule_period_id", $schedule_period->id) ->where("session_date" ,date('Y-m-d',strtotime("$year-$month-$i"))); // var_dump($course_sessions->count()); if ($course_sessions_rslt->count()>0){ foreach ($course_sessions_rslt as $course_session) { // ENUM('pending', 'running', 'canceled', 'completed') if ($course_session->status == "pending") $color ="bg-yellow-300"; elseif($course_session->status == "running") $color ="bg-blue-500"; elseif($course_session->status == "canceled") $color ="bg-red-700"; elseif($course_session->status == "completed") $color ="bg-green-700"; else $color ="text-gray-800"; echo ''; } }else{ echo ''; } @endphp @endfor @endforeach @endforeach @endforeach

			{{date('D', strtotime( "$year-$month-$i" ))}} {{ $i }}/{{ $month }}
{{ $period->name }}	{{ date('h:i', strtotime($schedule_period->from)) . '-' . date('h:i', strtotime($schedule_period->to)) }}	{{ $branch->class_rooms->get($lab_index)->name }}	'; echo ""; echo " (".$course_session->session_number.") ".$course_session->course->course_level->name ; if ($course_session->instructor) echo "-", $course_session->instructor->name; echo ""; echo '