LAPORAN PEMBIAYAAN FASILITAS KEPULANGAN JENAZAH
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_cargo as $key => $cargo) @if ($key == 0) @endif @foreach ($data_kawasan as $kawasan) @endforeach @endforeach @foreach ($data_kawasan as $kawasan) @endforeach @foreach ($data_kepulangan as $key => $kepulangan) @if ($key == 0) @endif @foreach ($data_kawasan as $kawasan) @endforeach @endforeach @foreach ($data_kawasan as $kawasan) @endforeach

Fasilitas Kepulangan Jenazah		Kawasan	Total
		{{ $kawasan->nama ?? '-' }}
CARGO	{{ $cargo->nama ?? '-' }}	@php $value = \App\Models\Imigran::whereHas('jenazah', function ($query) use ($cargo) { $query->where('id_cargo', $cargo->id); }) ->where('id_kawasan', $kawasan->id) ->whereBetween('tanggal_kedatangan', [$start_date, $end_date]) ->count(); @endphp {{ $value > 0 ? $value : '-' }}	@php $total_value = \App\Models\Imigran::whereHas('jenazah', function ($query) use ($cargo) { $query->where('id_cargo', $cargo->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) ->whereHas('jenazah') ->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) ->whereHas('jenazah') ->whereBetween('tanggal_kedatangan', [$start_date, $end_date]) ->count(); $grand_total = $grand_total + $total_kawasan; } @endphp {{ $grand_total }}
KEPULANGAN	{{ $kepulangan->nama ?? '-' }}	@php $value = \App\Models\Imigran::where('id_kepulangan', $kepulangan->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_kepulangan', $kepulangan->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) ->whereHas('jenazah') ->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) ->whereHas('jenazah') ->whereBetween('tanggal_kedatangan', [$start_date, $end_date]) ->count(); $grand_total = $grand_total + $total_kawasan; } @endphp {{ $grand_total }}