LAPORAN PELAYANAN BERDASARKAN PROVINSI
Periode {{ \Carbon\Carbon::parse($start_date)->isoFormat('D MMMM Y') }} s/d {{ \Carbon\Carbon::parse($end_date)->isoFormat('D MMMM Y') }}

@foreach ($data_kawasan as $kawasan) @endforeach @foreach ($data_provinsi as $key => $provinsi) @foreach ($data_kawasan as $kawasan) @endforeach @endforeach @foreach ($data_kawasan as $kawasan) @endforeach

No	Provinsi	Kawasan	Total
		{{ $kawasan->nama ?? '-' }}
{{ $loop->iteration }}	{{ $provinsi->nama ?? '-' }}	@php $value = \App\Models\Imigran::where('id_provinsi', $provinsi->id) ->where('id_kawasan', $kawasan->id) ->whereBetween('tanggal_kedatangan', [$start_date, $end_date]) ->count(); @endphp {{ $value > 0 ? $value : '-' }}	@php $total_value = \App\Models\Imigran::where('id_provinsi', $provinsi->id) ->whereBetween('tanggal_kedatangan', [$start_date, $end_date]) ->count(); @endphp {{ $total_value > 0 ? $total_value : '-' }}
Total		@php $total = \App\Models\Imigran::where('id_kawasan', $kawasan->id) ->whereBetween('tanggal_kedatangan', [$start_date, $end_date]) ->count(); @endphp {{ $total }}	@php $grand_total = 0; foreach ($data_kawasan as $kawasan) { $total_kawasan = \App\Models\Imigran::where('id_kawasan', $kawasan->id) ->whereBetween('tanggal_kedatangan', [$start_date, $end_date]) ->count(); $grand_total = $grand_total + $total_kawasan; } @endphp {{ $grand_total }}