REKAPITULASI REALISASI KOMITMEN P3DN PEMERINTAH KOTA SAMARINDA

Tanggal Awal

Tanggal Akhir

@if ($request->pd or Auth::user()->hasRole('admin-opd') or Auth::user()->hasRole('admin-PPTK|monev')) {{-- --}} {{-- --}} {{-- --}} {{-- @php dd($prokers->flatten()->sum('pagu_sum')); @endphp --}} {{-- --}} {{-- --}} {{-- $item->pagu * ($item->fisik/$item->volume)*100 --}} {{-- --}} {{-- --}} {{-- --}} {{-- Proker --}} @forelse ($prokers as $pr) {{-- Proker Program --}} @foreach ($pr->ProkerProgram as $pm) {{-- pagu --}} {{-- --}} {{-- nilai kontrak --}} {{-- --}} {{-- sisa pagu --}} {{-- --}} {{-- Fisik% --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- Proker Kegiatan --}} @foreach ($pm->ProkerKegiatan as $pk) {{-- --}} {{-- @php dump($pk->kegiatan_nilai_kontrak); @endphp --}} {{-- --}} {{-- --}} {{-- @php dump($pk->PersentaseFisik); @endphp --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- Proker Sub Kegiatan --}} @foreach ($pk->ProkerSubKegiatan as $sk) {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} @foreach ($sk->RincianKegiatan as $rk) {{-- --}} {{-- --}} {{-- --}} @endforeach @endforeach @endforeach @endforeach {{-- Akhir Proker Program --}} @empty @endforelse

No	Kode	Program/Kegiatan/Sub Kegiatan/Pekerjaan	PA/KPA	PPTK	Pagu (Rp)	Nilai Kontrak (Rp)	Sisa Pagu (Rp)	Realisasi			TKDN (%)	SKPD Pelaksana	Permasalahan	Tindak Lanjut	Dokumen
								Fisik	Keuangan
								%	RP	%
TOTAL					Rp{{ number_format($prokers->flatten()->sum('pagu_sum'), 0, ',', '.') }}	Rp{{number_format($prokers->flatten()->sum('nilai_kontrak_sum'), 0, ',', '.')}}	Rp{{number_format($prokers->flatten()->sum("pagu_berjalan_sum") - $prokers->flatten()->sum("nilai_kontrak_sum"), 0, ',', '.')}}	{{ number_format($prokers->flatten()->sum('PercentFisik')/($prokers->flatten()->sum('pagu_sum') > 0 ? $prokers->flatten()->sum('pagu_sum'):1), 2, ',', '.')}}%	{{ number_format(($prokers->flatten()->sum('pagu_sum') * ($prokers->flatten()->sum('realisasi_fisik_sum') / $prokers->flatten()->sum('volume_sum')) * 100) / $prokers->flatten()->sum('pagu_sum') ) }}		Rp{{number_format($prokers->flatten()->sum("realisasi_keuangan_sum"), 0, ',', '.')}}	{{number_format(($prokers->flatten()->sum("realisasi_keuangan_sum")/($prokers->flatten()->sum('pagu_sum') > 0 ? $prokers->flatten()->sum('pagu_sum'):1))*100, 2, ',', '.')}}%	{{ number_format(($prokers->flatten()->sum("TkdnAkumulasi") / $prokers->flatten()->sum('pagu_sum')), 2, ',', '.')}}%
{{ $loop->iteration }}	{{ $pm->program->kode }}	{{ $pm->program->nama_program }}			Rp{{ number_format($pm->program_pagu_sum, 0, ',', '.') }}	Rp{{number_format($pm->program_nilai_kontrak_sum, 0, ',', '.')}}	Rp{{number_format($pm->program_pagu_berjalan_sum - $pm->program_nilai_kontrak_sum, 0, ',', '.')}}	{{ number_format((@$pm->program_pagu_sum * ($pm->program_realisasi_fisik_sum/$pm->program_volume_sum)*100))}}%	{{ number_format($pm->PercentFisik/($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, ',', '.')}}%	{{ number_format(($pm->TkdnAkumulasi/$pm->program_pagu_sum), 2, ',', '.') }}%	{{ $pr->opd->nama_perangkat_daerah }}
	{{ $pk->kegiatan->kode }}	{{ $pk->kegiatan->nama_kegiatan }}			Rp{{ number_format($pk->kegiatan_pagu_sum, 0, ',', '.') }}	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)}}%	{{ number_format($pk->PersentaseFisik/($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum:1),2)}}%	{{ number_format($pk->PercentFisik / ($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, ',', '.')}}%	{{ number_format(($pk->TkdnAkumulasi/$pk->kegiatan_pagu_sum) ,2,',','.') }}%	{{ $pk->TkdnAkumulasi }}	{{ $pr->opd->nama_perangkat_daerah }}
	{{ $sk->subKegiatan->kode }}	{{ $sk->subKegiatan->nama_sub_kegiatan }}	{{ @$sk->Kpa->nama }}	{{ @$sk->Pptk->nama }}	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->PercentFisik / $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, ',', '.')}}%	{{ number_format(($sk->TkdnAkumulasi/$sk->sub_kegiatan_pagu_sum), 2, ',', '.') }}%	{{ $sk->TkdnAkumulasi }}	{{ $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?number_format(($rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi')/($rk->volume == 0 ? 1 : $rk->volume ))*100, 2, ',', '.'):"0"}}%	Rp{{ $rk->RealisasiRincianKegiatan ? number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum(function ($item) { return is_numeric($item->realisasi) ? $item->realisasi : 0; }), 0, ',', '.') : "-" }}	{{$rk->RealisasiRincianKegiatan?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"}}%	{{ number_format($rk->RealisasiRincianKegiatan->tkdn, 2, ',', '.') }}%	{{ $pr->opd->nama_perangkat_daerah }}		@if ($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->count()) {{ $rk->RealisasiRincianKegiatan->permasalahanTindakLanjut()->first()->permasalahan }} @endif	@if ($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->count()) {{ $rk->RealisasiRincianKegiatan->permasalahanTindakLanjut()->first()->tindaklanjut }} @endif
Tidak ada Data

@else {{-- --}} {{-- --}} {{-- --}} {{-- --}} @foreach($opd as $pd) {{-- --}} {{-- --}} {{-- --}} @endforeach

No	Kode	Perangkat Daerah	Pagu	Pagu	Pagu Komitmen (60%)	Realisasi				Realisasi Komitmen
						Fisik	Keuangan		Status	Status
						(%)	(Rp)	Pembayaran (%)	Status	(%)	(%)
Pemerintah Kota Samarinda			Rp{{number_format($total_pagu , 0, ',', '.')}}	Rp{{number_format($total_pagu , 0, ',', '.')}}	Rp{{number_format($total_pagu_komitmen_baru , 0, ',', '.')}}	{{$total_pagu > 0 ?number_format($total_percent_fisik/($total_pagu > 0 ? $total_pagu : 1), 2, ',', '.'):0}}%	Rp{{number_format($total_reakuangan , 0, ',', '.')}}	{{number_format(($total_reakuangan/($total_nilai_kontrak > 0 ? ($total_nilai_kontrak + $total_pagu_tanpa_realisasi) : 1))*100, 2, ',', '.')}}%	{{number_format(($total_reakuangan/($total_pagu > 0 ? $total_pagu : 1))*100, 2, ',', '.')}}%	{{ ($total_reakuangan >= $total_pagu_komitmen_baru) ? 'Telah Tercapai' : 'Belum Tercapai' }}	{{number_format(($total_reakuangan/($total_pagu_komitmen_baru > 0 ? $total_pagu_komitmen_baru : 1))*100, 2, ',', '.')}}%
{{$loop->iteration}}	{{$pd->kode}}	{{$pd->nama_perangkat_daerah}}	Rp{{ number_format($pd->total_pagu , 0, ',', '.') }}	{{ number_format(($pd->total_pagu/$opd->sum('total_pagu'))*100 , 2, ',', '.') }}%	Rp{{ number_format($pd->total_pagu , 0, ',', '.') }}	Rp{{ number_format($pd->pagu_komitmen_baru , 0, ',', '.') }}	{{ number_format($pd->total_pagu > 0?($pd->total_realisasi/($pd->total_pagu > 0 ? $pd->total_pagu : 1)):0, 2, ',', '.') }}%	Rp{{ number_format($pd->realisasi_keuangan_pd , 0, ',', '.') }}	{{ number_format($pd->realisasi_keuangan_pd/($pd->total_nilai_kontrak > 0 ? $pd->total_nilai_kontrak + $pd->total_pagu_tanpa_realisasi : 1)*100 , 2, ',', '.') }}%	{{ number_format($pd->realisasi_keuangan_pd/($pd->total_pagu > 0 ? $pd->total_pagu : 1)*100 , 2, ',', '.') }}%	{{ ($pd->realisasi_keuangan_pd >= $pd->pagu_komitmen_baru) ? 'Telah Tercapai' : 'Belum Tercapai' }}	{{ number_format($pd->realisasi_keuangan_pd/($pd->pagu_komitmen_baru > 0 ? $pd->pagu_komitmen_baru : 1)*100 , 2, ',', '.') }}%

@endif

REKAPITULASI REALISASI KOMITMEN P3DN PEMERINTAH KOTA SAMARINDA

No

Kode

Perangkat Daerah

Pagu

Pagu

Pagu Komitmen (60%)

Realisasi

Realisasi Komitmen

Fisik

Keuangan

Status

Status

(%)

(Rp)

Pembayaran (%)

(%)

(%)

Pemerintah Kota Samarinda

Rp{{number_format($total_pagu , 0, ',', '.')}}

Rp{{number_format($total_pagu , 0, ',', '.')}}

Rp{{number_format($total_pagu_komitmen_baru , 0, ',', '.')}}

{{$total_pagu > 0 ?number_format($total_percent_fisik/($total_pagu > 0 ? $total_pagu : 1), 2, ',', '.'):0}}%

Rp{{number_format($total_reakuangan , 0, ',', '.')}}

{{number_format(($total_reakuangan/($total_nilai_kontrak > 0 ? ($total_nilai_kontrak + $total_pagu_tanpa_realisasi) : 1))*100, 2, ',', '.')}}%

{{number_format(($total_reakuangan/($total_pagu > 0 ? $total_pagu : 1))*100, 2, ',', '.')}}%

{{ ($total_reakuangan >= $total_pagu_komitmen_baru) ? 'Telah Tercapai' : 'Belum Tercapai' }}

{{number_format(($total_reakuangan/($total_pagu_komitmen_baru > 0 ? $total_pagu_komitmen_baru : 1))*100, 2, ',', '.')}}%