Rentang Waktu : {{ $tanggal_awal }} s.d {{ $tanggal_akhir }}
Rentang Waktu : {{ $tanggal_awal }} s.d {{ $tanggal_akhir }}
| No | Kode | Program/Kegiatan/Sub Kegiatan | PA/KPA | PPTK | Pagu (Rp) | Nilai Kontrak (Rp) | Sisa Pagu (Rp) | Realisasi | SKPD Pelaksana | Permasalahan | Tindak Lanjut | Dokumen | SPJ | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fisik | Keuangan | ||||||||||||||||||
| % | RP | % | |||||||||||||||||
| TOTAL | Rp. {{ number_format($prokers->flatten()->sum('pagu_sum')) }} | Rp {{number_format($prokers->flatten()->sum('nilai_kontrak_sum'))}} | Rp. {{number_format($prokers->flatten()->sum("pagu_berjalan_sum") - $prokers->flatten()->sum("nilai_kontrak_sum"))}} | {{ number_format($prokers->flatten()->sum('PersentaseFisik')/($prokers->flatten()->sum('pagu_sum') > 0 ? $prokers->flatten()->sum('pagu_sum'):1),2)}}% | Rp. {{number_format($prokers->flatten()->sum("realisasi_keuangan_sum"))}} | {{number_format(($prokers->flatten()->sum("realisasi_keuangan_sum")/($prokers->flatten()->sum('pagu_sum') > 0 ? $prokers->flatten()->sum('pagu_sum'):1))*100,2)}}% | |||||||||||||
| TOTAL | Rp{{ number_format($totalPaguSum , 0, ',', '.') }} | Rp{{ number_format($totalNilaiKontrakSum , 0, ',', '.') }} | Rp{{ number_format($totalSelisih , 0, ',', '.') }} | {{ number_format($totalPersentaseFisik, 2 , ',', '.') }}% | Rp{{ number_format($totalRealisasiKeuanganSum , 0, ',', '.') }} | {{ number_format($totalPersentaseRealisasiKeuangan, 2 , ',', '.') }}% | |||||||||||||
| {{ $_GET['noData'] }} | {{ $pm->program->kode }} | {{ $pm->program->nama_program }} | {{-- pagu --}}Rp{{ number_format($pm->program_pagu_sum , 0, ',', '.') }} | {{-- nilai kontrak --}}Rp{{number_format($pm->program_nilai_kontrak_sum , 0, ',', '.')}} | {{-- sisa pagu --}}Rp{{number_format($pm->program_pagu_berjalan_sum - $pm->program_nilai_kontrak_sum , 0, ',', '.')}} | {{-- Fisik% --}} {{--{{ number_format((@$pm->program_pagu_sum * ($pm->program_realisasi_fisik_sum/$pm->program_volume_sum)*100))}}% | --}}{{ number_format($pm->PersentaseFisik/($pm->program_pagu_sum > 0 ? $pm->program_pagu_sum:1), 2 , ',', '.')}}% | {{--{{ number_format(($pm->program_pagu_sum * ($pm->program_realisasi_fisik_sum / max($pm->program_volume_sum, 1)) * 100)/ $pm->program_pagu_sum ) }}% | --}} {{--{{ number_format(($pm->program_pagu_sum * ($pm->program_realisasi_fisik_sum / max($pm->program_volume_sum, 1)) * 100) / $pm->program_pagu_sum ) }} | --}} {{----}} | Rp{{number_format($pm->program_realisasi_keuangan_sum , 0, ',', '.')}} | {{number_format(($pm->program_realisasi_keuangan_sum/($pm->program_pagu_sum > 0 ? $pm->program_pagu_sum:1))*100, 2 , ',', '.')}}% | {{ $pr->opd->nama_perangkat_daerah }} | ||||||
| {{ $pk->kegiatan->kode }} | {{ $pk->kegiatan->nama_kegiatan }} | Rp{{ number_format($pk->kegiatan_pagu_sum , 0, ',', '.') }} | {{-- @php dump($pk->kegiatan_nilai_kontrak); @endphp --}}Rp{{number_format($pk->kegiatan_nilai_kontrak_sum , 0, ',', '.')}} | Rp{{number_format($pk->kegiatan_pagu_berjalan_sum - $pk->kegiatan_nilai_kontrak_sum , 0, ',', '.')}} | {{--{{ number_format($pk->kegiatan_realisasi_fisik_sum/($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum:1),2)}}% | --}} {{-- @php dump($pk->PersentaseFisik); @endphp --}} {{--{{ number_format($pk->PersentaseFisik/($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum:1),2)}}% | --}}{{ number_format($pk->PersentaseFisik / ($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum : 1) , 2 , ',', '.') }}% | {{----}} | Rp{{number_format($pk->kegiatan_realisasi_keuangan_sum , 0, ',', '.')}} | {{number_format(($pk->kegiatan_realisasi_keuangan_sum/($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum:1))*100 , 2 , ',', '.')}}% | {{ $pr->opd->nama_perangkat_daerah }} | ||||||||
| {{ $sk->subKegiatan->kode }} | {{ $sk->subKegiatan->nama_sub_kegiatan }} | {{ $sk->Kpa->nama ?? "kpa belum di atur" }} | {{ $sk->Pptk->nama ?? "pptk belum di atur" }} | Rp{{ number_format($sk->sub_kegiatan_pagu_sum , 0, ',', '.') }} | Rp{{number_format($sk->sub_kegiatan_nilai_kontrak_sum , 0, ',', '.')}} | Rp{{number_format($sk->sub_kegiatan_pagu_berjalan_sum - $sk->sub_kegiatan_nilai_kontrak_sum , 0, ',', '.')}} | {{--{{ number_format(($sk->sub_kegiatan_pagu_sum * ($sk->sub_kegiatan_realisasi_fisik_sum / max($sk->sub_kegiatan_volume_sum, 1)) * 100)/ $sk->sub_kegiatan_pagu_sum ,2 ) }}% | --}}{{ number_format($sk->PersentaseFisik / ($sk->sub_kegiatan_pagu_sum == 0 ? 1 : $sk->sub_kegiatan_pagu_sum) , 2 , ',', '.') }}% | Rp{{number_format($sk->sub_kegiatan_realisasi_keuangan_sum , 0, ',', '.')}} | {{number_format(($sk->sub_kegiatan_realisasi_keuangan_sum/($sk->sub_kegiatan_pagu_sum > 0 ? $sk->sub_kegiatan_pagu_sum : 1))*100 , 2 , ',', '.')}}% | {{ $pr->opd->nama_perangkat_daerah }} | ||||||||
| {{ $rk->kode_rekening }} | {{ $rk->uraian }} | {{ @$sk->Kpa->nama }} | {{ @$sk->Pptk->nama }} | Rp{{ number_format($rk->pagu, 0, ',', '.') }} | Rp{{ number_format($rk->customnilaikontrak, 0, ',', '.') }} | Rp{{ number_format($rk->paguberjalan - $rk->customnilaikontrak, 0, ',', '.') }} | {{$rk->RealisasiRincianKegiatan->realisasiFisik?number_format(($rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi')/($rk->volume == 0 ? 1 : $rk->volume ))*100 , 2 , ',', '.'):"0"}}% | Rp{{ $rk->RealisasiRincianKegiatan->realisasiKeuangan ? number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum(function ($item) { return is_numeric($item->realisasi) ? $item->realisasi : 0; }), 0, ',', '.') : "-" }} | {{$rk->RealisasiRincianKegiatan->realisasiKeuangan?number_format(($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum(function ($item) { return is_numeric($item->realisasi) ? $item->realisasi : 0; })/($rk->pagu != 0 ? $rk->pagu : 1 ))*100 , 2 , ',', '.'):"0"}}% | {{ $pr->opd->nama_perangkat_daerah }} | @if ($rk->permasalahanTindakLanjut->isNotEmpty()) {{ $rk->permasalahanTindakLanjut->first()->permasalahan }} @endif | @if ($rk->permasalahanTindakLanjut->isNotEmpty()) {{ $rk->permasalahanTindakLanjut->first()->tindaklanjut }} @endif | |||||||
| Tidak ada data | |||||||||||||||||||