@foreach ($ProkerSubKegiatans as $psk) @foreach ($psk->RincianKegiatan as $rk) @endforeach @endforeach
No Kode/Kode Rekening Sub Kegiatan/Pekerjaan Pagu Nilai Kontrak Realisasi SKPD PELAKSANA PPTK
Fisik (%) KEU (Rp) KEU (%)
TOTAL Rp{{ number_format($ProkerSubKegiatanTotal->flatten()->sum('sub_kegiatan_pagu_sum'), 0, ',', '.') }} Rp{{ number_format($ProkerSubKegiatanTotal->flatten()->sum('sub_kegiatan_nilai_kontrak_sum'), 0, ',', '.') }} {{ number_format($ProkerSubKegiatanTotal->flatten()->sum('PercentFisik')/($ProkerSubKegiatanTotal->flatten()->sum('sub_kegiatan_pagu_sum') > 0 ? $ProkerSubKegiatanTotal->flatten()->sum('sub_kegiatan_pagu_sum'):1) ,2, ',', '.')}}% Rp{{number_format($ProkerSubKegiatanTotal->flatten()->sum("sub_kegiatan_realisasi_keuangan_sum"), 0, ',', '.')}} {{number_format(($ProkerSubKegiatanTotal->flatten()->sum("sub_kegiatan_realisasi_keuangan_sum")/($ProkerSubKegiatanTotal->flatten()->sum('sub_kegiatan_pagu_sum') > 0 ? $ProkerSubKegiatanTotal->flatten()->sum('sub_kegiatan_pagu_sum') : 1))*100, 2, ',', '.')}}%
{{ $loop->iteration }} {{$psk->SubKegiatan->kode }} {{$psk->SubKegiatan->nama_sub_kegiatan }} Rp{{ number_format($psk->RincianKegiatan->sum('pagu'), 0, ',', '.') }} Rp{{ number_format($psk->RincianKegiatan->sum('kontrak'), 0, ',', '.') }} {{ number_format($psk->RincianKegiatan->map(function ($rinciankegiatan) { return ( $rinciankegiatan->RealisasiRincianKegiatan ? $rinciankegiatan->pagu * ($rinciankegiatan->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') / max($rinciankegiatan->volume,1)) * 100 : 0); })->sum() / ($psk->RincianKegiatan->sum('pagu') == 0 ? 1: $psk->RincianKegiatan->sum('pagu')) ,2 , ',', '.') }}% Rp{{ number_format($psk->RincianKegiatan->sum('keuangan') , 0, ',', '.') }} {{ number_format(($psk->RincianKegiatan->sum('keuangan')/($psk->RincianKegiatan->sum('pagu') == 0 ? 1 : $psk->RincianKegiatan->sum('pagu')))*100 ,2 , ',', '.') }}%
{{$rk->kode_rekening}} {{$rk->uraian}} Rp{{ number_format($rk->pagu, 0, ',', '.') }} Rp{{ number_format($rk->kontrak, 0, ',', '.') }} {{$rk->RealisasiRincianKegiatan ? number_format(( $rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') / ($rk->volume == 0 ? 1 : $rk->volume )) * 100 ,2 , ',', '.'):"0"}}% Rp{{ number_format($rk->RealisasiRincianKegiatan ? $rk->RealisasiRincianKegiatan->Keuangan : 0, 0, ',', '.') }} {{ number_format(( $rk->RealisasiRincianKegiatan ? $rk->RealisasiRincianKegiatan->Keuangan / ($rk->pagu == 0 ? 1 : $rk->pagu) : 0)*100 ,2 , ',', '.') }}% {{ $rk->Opd->nama_perangkat_daerah }} {{ $rk->ProkerSubKegiatan->pptk->nama ?? '-' }}