Notes Therapist Momkind.id - {{ $date->format('F Y') }}

@php $groupedTherapists = $therapists->groupBy('order_no'); $parseStart = function($slot) { $slot = preg_replace('/\s+/', '', $slot); $parts = explode('-', $slot); $start = $parts[0] ?? '00.00'; $start = str_replace('.', ':', $start); try { return \Carbon\Carbon::createFromFormat('H:i', $start)->format('H:i'); } catch (\Exception $e) { return $start; } }; @endphp @for($day = 1; $day <= $daysInMonth; $day++) @endfor @foreach($groupedTherapists as $orderNo => $therapistGroup) @php $sortedGroup = $therapistGroup->sortBy(function($t) use ($parseStart) { return $parseStart($t->time_slot); })->values(); $rowCount = $sortedGroup->count(); @endphp @foreach($sortedGroup as $index => $therapist) @if($index === 0) @endif @for($day = 1; $day <= $daysInMonth; $day++) @php $scheduleDate = \Carbon\Carbon::create($date->year, $date->month, $day); $entry = $therapist->getScheduleEntry($scheduleDate); $bgColor = $entry ? $entry->bg_color : '#ffffff'; $content = $entry ? $entry->content : ''; @endphp @endfor @endforeach @endforeach

NO	TERAPIS	DOMISILI	TRANSPORT	JAM	{{ $day }}
{{ $orderNo }}	{{ $therapist->name }}	{{ $therapist->domicile }}	{{ $therapist->transportation }}	{{ $therapist->time_slot }}	{{ $content }}

@php header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename="notes-' . $date->format('F-Y') . '.xls"'); @endphp