Document

Rentang Waktu : {{ $request->tanggal_awal ?? '-' }} s.d {{ $request->tanggal_akhir ?? '-' }}

Jenis UMK : @if ($request->jenis_umk == '1') UMKM @elseif ($request->jenis_umk == '0')) Non UMKM @else UMKM & Non UMKM @endif

Kode/Kode Rekening	Sub Kegiatan/Pekerjaan	Jenis UMK	UMKM	Pagu	Nilai Kontrak	Sisa Pagu Kontrak	Realisasi	SKPD PELAKSANA	PPTK	Permasalahan	Tindak Lanjut	Dokumentasi
TOTAL	Rp{{ number_format($umks->flatten()->sum('sk_pagu_sum'), 0, ',', '.') }}	Rp{{ number_format($umks->flatten()->sum('sk_nilai_kontrak_sum'), 0, ',', '.') }}	Rp{{ number_format($umks->flatten()->sum('sk_pagu_berjalan_sum') - $umks->flatten()->sum('sk_nilai_kontrak_sum'), 0, ',', '.') }}	{{ number_format($umks->flatten()->sum('PercentFisik')/($umks->flatten()->sum('sk_pagu_sum') > 0 ? $umks->flatten()->sum('sk_pagu_sum'):1), 2, ',', '.')}}%	Rp{{number_format($umks->flatten()->sum("sk_realisasi_keuangan_sum"), 0, ',', '.')}}	{{number_format(($umks->flatten()->sum("sk_realisasi_keuangan_sum")/($umks->flatten()->sum('sk_pagu_sum') > 0 ? $umks->flatten()->sum('sk_pagu_sum'):1))*100, 2, ',', '.')}}%
{{ $sub_kegiatan->subkegiatan->kode }}	{{ $sub_kegiatan->subkegiatan->nama_sub_kegiatan }}			Rp{{ number_format($sub_kegiatan->sk_pagu_sum , 0, ',', '.') }}	Rp{{ number_format($sub_kegiatan->sk_nilai_kontrak_sum , 0, ',', '.') }}	Rp{{ number_format(($sub_kegiatan->sk_pagu_berjalan_sum-$sub_kegiatan->sk_nilai_kontrak_sum) , 0, ',', '.') }}	{{ number_format($sub_kegiatan->PercentFisik/($sub_kegiatan->sk_pagu_sum > 0 ? $sub_kegiatan->sk_pagu_sum:1) , 2, ',', '.')}}%	Rp{{number_format($sub_kegiatan->sk_realisasi_keuangan_sum, 0, ',', '.')}}	{{number_format(($sub_kegiatan->sk_realisasi_keuangan_sum/($sub_kegiatan->sk_pagu_sum > 0 ? $sub_kegiatan->sk_pagu_sum:1))*100, 2, ',', '.')}}%	{{ $sub_kegiatan->Opd->nama_perangkat_daerah }}	{{ $sub_kegiatan->pptk->nama ?? '-' }}
{{ $rk->kode_rekening }}	{{ $rk->uraian }}	{{ $rk->JenisUmk->nama }}	{{ ($rk->umkm == '1') ? "UMKM" : "Non UMKM" }}	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"}}%	{{ $rk->Opd->nama_perangkat_daerah }}	{{ $rk->ProkerSubKegiatan->pptk->nama ?? '-' }}	{{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->permasalahan }}	{{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->tindaklanjut }}	@forelse($rk->RealisasiRincianKegiatan->dokumen as $doc) file_name") }}" target="_blank"> file_name") }}" alt="{{ $doc->file_name }}" height="100vh"> @empty - @endforelse
Tidak Ada Data

Kode/Kode Rekening

Sub Kegiatan/Pekerjaan

Jenis UMK

UMKM

Pagu

Nilai Kontrak

Sisa Pagu Kontrak

Realisasi

SKPD PELAKSANA

PPTK

Permasalahan

Tindak Lanjut

Dokumentasi

Fisik (%)

KEU (Rp)

KEU (%)

TOTAL

Rp{{ number_format($umks->flatten()->sum('sk_pagu_sum'), 0, ',', '.') }}

Rp{{ number_format($umks->flatten()->sum('sk_nilai_kontrak_sum'), 0, ',', '.') }}

Rp{{ number_format($umks->flatten()->sum('sk_pagu_berjalan_sum') - $umks->flatten()->sum('sk_nilai_kontrak_sum'), 0, ',', '.') }}

{{ number_format($umks->flatten()->sum('PercentFisik')/($umks->flatten()->sum('sk_pagu_sum') > 0 ? $umks->flatten()->sum('sk_pagu_sum'):1), 2, ',', '.')}}%

Rp{{number_format($umks->flatten()->sum("sk_realisasi_keuangan_sum"), 0, ',', '.')}}

{{number_format(($umks->flatten()->sum("sk_realisasi_keuangan_sum")/($umks->flatten()->sum('sk_pagu_sum') > 0 ? $umks->flatten()->sum('sk_pagu_sum'):1))*100, 2, ',', '.')}}%

Rp{{ number_format($sub_kegiatan->sk_pagu_sum , 0, ',', '.') }}

Rp{{ number_format($sub_kegiatan->sk_nilai_kontrak_sum , 0, ',', '.') }}

Rp{{ number_format(($sub_kegiatan->sk_pagu_berjalan_sum-$sub_kegiatan->sk_nilai_kontrak_sum) , 0, ',', '.') }}

{{ number_format($sub_kegiatan->PercentFisik/($sub_kegiatan->sk_pagu_sum > 0 ? $sub_kegiatan->sk_pagu_sum:1) , 2, ',', '.')}}%

Rp{{number_format($sub_kegiatan->sk_realisasi_keuangan_sum, 0, ',', '.')}}

{{number_format(($sub_kegiatan->sk_realisasi_keuangan_sum/($sub_kegiatan->sk_pagu_sum > 0 ? $sub_kegiatan->sk_pagu_sum:1))*100, 2, ',', '.')}}%

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"}}%

{{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->permasalahan }}

{{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->tindaklanjut }}

@forelse($rk->RealisasiRincianKegiatan->dokumen as $doc)

file_name") }}" target="_blank">

file_name") }}" alt="{{ $doc->file_name }}" height="100vh">

@empty

@endforelse

Tidak Ada Data

Resume UMK