@forelse ($tableData as $index => $row) @isset($row['track_level_session_id']) @endisset @empty @endforelse

Session	Slot Day	Slot Start	Slot End	Date	Available Staffs	Change Staff
{{ $row['session']?->name_en ?? 'Session ' . $index + 1 }}	{{ $row['slot_day'] }}	{{ formatTime($row['slot_start']) }}	{{ formatTime($row['slot_end']) }}	{{ $row['date'] }}	Choose Staff @php $matchingStaff = collect($trackAssignedStaff)->filter(function ( $staffAssigned, ) use ($row, $course) { if (!$staffAssigned->staff || !$staffAssigned->staff->slots) { return false; } $staffSlots = $staffAssigned->staff->slots ->filter(function ($slot) use ($row) { return $slot->slotEmp && strtolower($slot->slotEmp->slot_day) === strtolower($row['slot_day']); }) ->sortBy(function ($slot) { return strtotime($slot->slotEmp->slot_start); }); $requiredStart = strtotime($row['slot_start']); $requiredEnd = strtotime($row['slot_end']); $coveredStart = null; $coveredEnd = null; foreach ($staffSlots as $index => $slot) { $slotStart = strtotime($slot->slotEmp->slot_start); $slotEnd = strtotime($slot->slotEmp->slot_end); if ($coveredStart === null) { $coveredStart = $slotStart; $coveredEnd = $slotEnd; continue; } if ($coveredEnd === $slotStart) { $coveredEnd = $slotEnd; } else { if ( $coveredStart <= $requiredStart && $coveredEnd >= $requiredEnd ) { break; } $coveredStart = $slotStart; $coveredEnd = $slotEnd; } } $isSlotMatch = $coveredStart !== null && $coveredStart <= $requiredStart && $coveredEnd >= $requiredEnd; if (!$isSlotMatch) { return false; } $staffId = $staffAssigned->staff_id; $busy = \App\Models\StaffScheduled::where('staff_id', $staffId) ->where('id', '!=', $course->id) ->where('status', '!=', 'completed') ->whereDate('start_date', '<=', $row['date']) ->whereDate('end_date', '>=', $row['date']) ->whereHas('scheduledSlots', function ($q) use ($row) { $q->where('slot_day', $row['slot_day']) ->whereRaw('slot_start <= ?', [$row['slot_end']]) ->whereRaw('slot_end >= ?', [$row['slot_start']]); }) ->exists(); return !$busy; }); $selectedStaff = $trackAssignedStaff->firstWhere( 'staff_id', $row['staff_id'], ); if ( $selectedStaff && !$matchingStaff->contains('staff_id', $row['staff_id']) ) { $matchingStaff->push($selectedStaff); } @endphp @foreach ($matchingStaff as $staff) staff_id == $row['staff_id'] ? 'selected' : '' }}> {{ $staff->staff->full_name }} @endforeach	Update
No Data Available