@foreach ($tanggals as $tanggal) @endforeach @endforeach @foreach ($gurus as $guru) @foreach ($tanggals as $tanggal) @php $isMinggu = \Carbon\Carbon::parse($tanggal)->isoFormat('dddd') === 'Minggu'; $isLibur = $libur->pluck('tanggal')->contains($tanggal); $absensiHarian = $absens->where('guru_id', $guru->id)->where('tanggal', $tanggal); $absMasuk = $absensiHarian->where('type', 'masuk')->first(); $absPulang = $absensiHarian->where('type', 'pulang')->first(); @endphp @endforeach @endforeach

#	Nama Guru	Insentif (Rp.)	JK	{{ \Carbon\Carbon::parse($tanggal)->format('d') }}	{{ \Carbon\Carbon::parse($tanggal)->format('d') }}	Hadir TW	Pulang TW	Hadir TL	Pulang Cepat	H	HT	S	I	A
{{ $loop->iteration }}	{{ $guru->user->name }}	'{{ number_format($absens->where('guru_id', $guru->id)->sum('bonus'), 0, ',', '.') }}	{{ $guru->user->jk == 'laki-laki' ? 'L' : 'P' }}	{{ $isMinggu || $isLibur ? '' : (isset($absMasuk->created_at) ? \Carbon\Carbon::parse($absMasuk->created_at)->format('H:i') : '') }}	{{ $isMinggu || $isLibur ? '' : (isset($absPulang->created_at) ? \Carbon\Carbon::parse($absPulang->created_at)->format('H:i') : '') }}	{{ $absens->where('guru_id', $guru->id)->where('type', 'masuk')->where('status', 'h')->count() }}	{{ $absens->where('guru_id', $guru->id)->where('type', 'pulang')->where('status', 'h')->count() }}	{{ $absens->where('guru_id', $guru->id)->where('type', 'masuk')->where('status', 'ht')->count() }}	{{ $absens->where('guru_id', $guru->id)->where('type', 'pulang')->where('status', 'ht')->count() }}	{{ $absens->where('guru_id', $guru->id)->where('status', 's')->count() }}	{{ $absens->where('guru_id', $guru->id)->where('status', 'i')->count() }}	{{ $absens->where('guru_id', $guru->id)->where('status', 'a')->count() }}