UMKM
@role('admin|admin-opd|monev')
@endrole
No | Kode/Kode Rekening | Sub Kegiatan/Pekerjaan | Pagu | Nilai Kontrak | Realisasi | SKPD PELAKSANA | PPTK | |||
---|---|---|---|---|---|---|---|---|---|---|
Fisik (%) | KEU (Rp) | KEU (%) | ||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
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, ',', '.')}}% | {{--{{ number_format($ProkerSubKegiatanTotal->flatten()->sum('PercentFisik') / ( 4212054791937 > 0 ? 4212054791937 : 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('CustomNilaiKontrak'), 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->CustomNilaiKontrak, 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 ?? '-' }} |
{{ $ProkerSubKegiatans->appends(request()->query())->links(); }}
{{--
Loading --}}
{{-- {{-- Rp{{ number_format($rk->flatten()->sum('customnilaikontrak') , 0, ',', '.') }} --}}