@if (!isset($_GET['generate']))
Resume DAK

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

@else @if ($_GET['page'] == '1')
Resume DAK

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

@endif @endif @if (!isset($_GET['generate'])) Loading @endif @if (isset($_GET['generate']) && $_GET['generate'] == 'true') {{-- --}} {{-- --}} {{-- {{-- -- @foreach ($ProkerSubKegiatan as $sk) {{-- -- -- -- -- -- @foreach ($sk->rincianBidang as $keybidang => $bidang) {{-- -- @foreach ($bidang as $keysubbidang => $subbidang) {{-- -- @foreach ($subbidang as $rk) {{-- -- {{-- -- {{-- --}} {{-- -- @if ($rk->RealisasiRincianKegiatan->metode === 'swakelola') @else @endif @endforeach @endforeach @endforeach {{-- -- {{-- -- @foreach ($sk->RincianKegiatan as $rk) @endforeach @endforeach --}} @if ($_GET['page'] == '1') {{-- -- -- --}} @endif {{-- @foreach ($ProkerSubKegiatan as $sk) @foreach ($sk->rincianBidang as $keybidang => $bidang) -- -- @foreach ($bidang as $keysubbidang => $subbidang) -- -- @foreach ($subbidang as $rk) -- -- -- -- -- -- -- -- @if ($rk->RealisasiRincianKegiatan->metode === 'swakelola') @else @endif @endforeach @endforeach @endforeach @foreach ($sk->RincianKegiatan as $rk) @endforeach @endforeach --}} @foreach ($bidangs as $bidang) {{-- @php dd($bidang); @endphp --}} @foreach ($bidang->RincianSubBidang as $subbidang) {{-- --}} {{-- --}} {{-- @php dd($subbidang->ProkerSubKegiatan); @endphp --}} @foreach ($subbidang->prokerSubKegiatan as $keysk => $rincianKegiatans) @php [$namaSK, $kodeSK] = explode('_', $keysk); // dd($subbidang->prokerSubKegiatan); @endphp {{-- --}} {{-- --}} {{-- --}} @foreach ($rincianKegiatans as $rk) {{-- --}} {{-- --}} {{-- --}} {{-- --}} @if ($rk->RealisasiRincianKegiatan->metode === 'swakelola') @else @endif @endforeach @endforeach @endforeach @endforeach
NoBidang/Sub Bidang/Sub Kegiatan/Paket Pekerjaan Perencanaan Kegiatan Mekanisme Pelaksanaan Realisasi Sisa Pagu Sisa Pagu Kontrak SKPD Pelaksanaan PPTK Kodefikasi/Keterangan Permasalahan Tindak Lanjut
Volume Satuan Jumlah Penerimaan manfaatHarga Satuan(Rp)Pagu(Rp) Swakelola Kontraktual Metode Pembayaran Keuangan Fisik
Volume Rp. (dalam Rupiah) Volume Rp. (dalam Rupiah) Rp. (dalam Rupiah) % Volume %
TOTAL Rp{{ number_format($ProkerSubKegiatan->flatten()->sum('sub_kegiatan_pagu_sum'), 0, ',', '.') }} Rp{{number_format($ProkerSubKegiatan->flatten()->sum("sub_kegiatan_realisasi_keuangan_sum"), 0, ',', '.')}} {{number_format(($ProkerSubKegiatan->flatten()->sum("sub_kegiatan_realisasi_keuangan_sum")/($ProkerSubKegiatan->flatten()->sum('sub_kegiatan_pagu_sum') > 0 ? $ProkerSubKegiatan->flatten()->sum('sub_kegiatan_pagu_sum'):1))*100 , 2, ',', '.')}}% {{ number_format($ProkerSubKegiatan->flatten()->sum('PercentFisik')/($ProkerSubKegiatan->flatten()->sum('sub_kegiatan_pagu_sum') > 0 ? $ProkerSubKegiatan->flatten()->sum('sub_kegiatan_pagu_sum'):1),2 , ',', '.')}}% Rp{{ number_format($ProkerSubKegiatan->flatten()->sum('sub_kegiatan_pagu_sum') - $ProkerSubKegiatan->flatten()->sum("sub_kegiatan_realisasi_keuangan_sum"), 0, ',', '.') }} Rp{{ number_format($ProkerSubKegiatan->flatten()->sum('sub_kegiatan_pagu_berjalan_sum') - $ProkerSubKegiatan->flatten()->sum("sub_kegiatan_nilai_kontrak_sum"), 0, ',', '.') }}
{{ $sk->subKegiatan->nama_sub_kegiatan }} Rp{{ number_format($sk->sub_kegiatan_pagu_sum, 0, ',', '.') }} 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->PercentFisik/($sk->sub_kegiatan_pagu_sum ?? 1) , 2, ',', '.') }}% Rp{{ number_format($sk->sub_kegiatan_pagu_sum - $sk->sub_kegiatan_realisasi_keuangan_sum, 0, ',', '.') }} Rp{{ number_format($sk->sub_kegiatan_pagu_berjalan_sum - $sk->sub_kegiatan_nilai_kontrak_sum, 0, ',', '.') }} {{ $sk->Opd->nama_perangkat_daerah }}
{{ $keybidang }}
{{ $keysubbidang }}
{{ $rk->uraian }} {{ $rk->volume }} {{ $rk->satuan }} Rp. {{ number_format($rk->pagu/$rk->volume) }}Rp{{ number_format($rk->pagu , 0, ',', '.') }}{{ $rk->volume }} {{ $rk->volume }} Rp.{{ number_format($rk->RealisasiRincianKegiatan->nilai_kontrak) }}{{ $rk->RealisasiRincianKegiatan->metode }}{{ $rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} Rp{{ number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi'), 0, ',', '.') }} {{ $rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} Rp{{ number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi'), 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->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} {{$rk->RealisasiRincianKegiatan?number_format(($rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi')/($rk->volume == 0 ? 1 : $rk->volume ))*100 , 2, ',', '.'):"0"}}% Rp{{ number_format($rk->pagu - $rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi'), 0, ',', '.') }} Rp{{ number_format($rk->paguberjalan - $rk->customnilaikontrak, 0, ',', '.') }} {{ $sk->Opd->nama_perangkat_daerah }} {{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->permasalahan }} {{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->tindaklanjut }}
{{ $sk->subKegiatan->nama_sub_kegiatan }} Rp{{ number_format($sk->sub_kegiatan_pagu_sum, 0, ',', '.') }} 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->PercentFisik/($sk->sub_kegiatan_pagu_sum ?? 1) , 2, ',', '.') }}% Rp{{ number_format($sk->sub_kegiatan_pagu_sum - $sk->sub_kegiatan_realisasi_keuangan_sum, 0, ',', '.') }} Rp{{ number_format($sk->sub_kegiatan_pagu_berjalan_sum - $sk->sub_kegiatan_nilai_kontrak_sum, 0, ',', '.') }} {{ $sk->Opd->nama_perangkat_daerah }}
{{$rk->uraian}} {{$rk->volume}} {{$rk->satuan}} Rp{{ number_format($rk->pagu, 0, ',', '.') }}
TOTAL Rp{{ number_format($bidangsTotal->flatten()->sum('bidang_pagu_sum'), 0, ',', '.') }} Rp{{number_format($bidangsTotal->flatten()->sum("bidang_realisasi_keuangan_sum"), 0, ',', '.')}} {{number_format(($bidangsTotal->flatten()->sum("bidang_realisasi_keuangan_sum")/($bidangsTotal->flatten()->sum('bidang_pagu_sum') > 0 ? $bidangsTotal->flatten()->sum('bidang_pagu_sum'):1))*100 , 2, ',', '.')}}% {{ number_format($bidangsTotal->flatten()->sum('PercentFisik')/($bidangsTotal->flatten()->sum('bidang_pagu_sum') > 0 ? $bidangsTotal->flatten()->sum('bidang_pagu_sum'):1) ,2, ',', '.')}}% Rp{{ number_format($bidangsTotal->flatten()->sum('bidang_pagu_sum') - $bidangsTotal->flatten()->sum("bidang_realisasi_keuangan_sum"), 0, ',', '.') }} Rp{{ number_format($bidangsTotal->flatten()->sum('bidang_pagu_berjalan_sum') - $bidangsTotal->flatten()->sum("bidang_nilai_kontrak_sum"), 0, ',', '.') }}
{{ $keybidang }}
{{ $keysubbidang }}
{{ $rk->uraian }} {{ $rk->volume }} {{ $rk->satuan }} Rp. {{ number_format($rk->pagu/$rk->volume) }}Rp{{ number_format($rk->pagu , 0, ',', '.') }}{{ $rk->volume }} {{ $rk->volume }} Rp.{{ number_format($rk->RealisasiRincianKegiatan->nilai_kontrak) }}{{ $rk->RealisasiRincianKegiatan->metode }}{{ $rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} Rp{{ number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi'), 0, ',', '.') }} {{ $rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} Rp{{ number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi'), 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->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} {{$rk->RealisasiRincianKegiatan?number_format(($rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi')/($rk->volume == 0 ? 1 : $rk->volume ))*100 , 2, ',', '.'):"0"}}% Rp{{ number_format($rk->pagu - $rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi') , 0, ',', '.') }} Rp{{ number_format($rk->paguberjalan - $rk->customnilaikontrak , 0, ',', '.') }} {{ $sk->Opd->nama_perangkat_daerah }} {{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->permasalahan }} {{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->tindaklanjut }}
{{ $sk->subKegiatan->nama_sub_kegiatan }} Rp{{ number_format($sk->sub_kegiatan_pagu_sum, 0, ',', '.') }} 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->PercentFisik/($sk->sub_kegiatan_pagu_sum ?? 1) , 2, ',', '.') }}% Rp{{ number_format($sk->sub_kegiatan_pagu_sum - $sk->sub_kegiatan_realisasi_keuangan_sum, 0, ',', '.') }} Rp{{ number_format($sk->sub_kegiatan_pagu_berjalan_sum - $sk->sub_kegiatan_nilai_kontrak_sum, 0, ',', '.') }} {{ $sk->Opd->nama_perangkat_daerah }}
{{$rk->uraian}} {{$rk->volume}} {{$rk->satuan}} Rp{{ number_format($rk->pagu, 0, ',', '.') }}
{{ $bidang->nama }} Rp{{ number_format($bidang->bidang_pagu_sum, 0, ',', '.') }} Rp{{number_format($bidang->bidang_realisasi_keuangan_sum, 0, ',', '.')}} {{number_format(($bidang->bidang_realisasi_keuangan_sum/($bidang->bidang_pagu_sum > 0 ? $bidang->bidang_pagu_sum : 1))*100,2 , ',', '.')}}% {{ number_format($bidang->PercentFisik / $bidang->bidang_pagu_sum , 2, ',', '.') }}%
{{ $subbidang->nomor }}{{ $subbidang->nama }} Rp{{ number_format($subbidang->sub_bidang_pagu_sum, 0, ',', '.') }} Rp{{number_format($subbidang->sub_bidang_realisasi_keuangan_sum, 0, ',', '.')}} {{number_format(($subbidang->sub_bidang_realisasi_keuangan_sum/($subbidang->sub_bidang_pagu_sum > 0 ? $subbidang->sub_bidang_pagu_sum : 1))*100,2 , ',', '.')}}% {{ number_format($subbidang->PercentFisik / ($subbidang->sub_bidang_pagu_sum > 0 ? $subbidang->sub_bidang_pagu_sum : 1) , 2, ',', '.') }}%
{{ $namaSK }} Rp{{ number_format($rincianKegiatans->flatten()->sum('pagu') , 0, ',', '.') }} Rp{{ number_format($rincianKegiatans->flatten()->sum('keuangan') , 0, ',', '.') }} {{number_format(($rincianKegiatans->flatten()->sum('keuangan')/($rincianKegiatans->flatten()->sum('pagu') > 0 ? $rincianKegiatans->flatten()->sum('pagu') : 1))*100,2, ',', '.')}}% {{ number_format($rincianKegiatans->flatten()->sum('customnilaikontrak') , 0, ',', '.')}}{{ number_format($rincianKegiatans->map(function ($rinciankegiatan) { return ($rinciankegiatan->pagu * ($rinciankegiatan->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') / max($rinciankegiatan->volume,1)) * 100); })->sum() / $rincianKegiatans->flatten()->sum('pagu') ,2 , ',', '.') }}% Rp{{ number_format($rincianKegiatans->flatten()->sum('pagu') - $rincianKegiatans->flatten()->sum('keuangan'), 0, ',', '.') }} Rp{{ number_format($rincianKegiatans->flatten()->sum('paguBerjalan') - $rincianKegiatans->flatten()->sum('customnilaikontrak') , 0, ',', '.') }} {{ $rincianKegiatans->first()->opd->nama_perangkat_daerah }} {{ $rincianKegiatans->SubKegiatan->nama_sub_kegiatan }} Rp{{ number_format($sk->sub_kegiatan_pagu_sum, 0, ',', '.') }} 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->PercentFisik/($sk->sub_kegiatan_pagu_sum ?? 1) , 2, ',', '.') }}% Rp{{ number_format($sk->sub_kegiatan_pagu_sum - $sk->sub_kegiatan_realisasi_keuangan_sum, 0, ',', '.') }} Rp{{ number_format($sk->sub_kegiatan_pagu_berjalan_sum - $sk->sub_kegiatan_nilai_kontrak_sum, 0, ',', '.') }} {{ $sk->Opd->nama_perangkat_daerah }}
{{ $rk->uraian }} {{ $rk->volume }} {{ $rk->satuan }} Rp. {{ number_format($rk->pagu/$rk->volume) }}Rp{{ number_format($rk->pagu , 0, ',', '.') }}{{ $rk->volume }} {{ $rk->volume }} Rp.{{ number_format($rk->RealisasiRincianKegiatan->nilai_kontrak) }}{{ $rk->RealisasiRincianKegiatan->metode }}{{ $rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} Rp{{ number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi'), 0, ',', '.') }} {{ $rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} Rp{{ number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi'), 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->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi') }} {{$rk->RealisasiRincianKegiatan?number_format(($rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi')/($rk->volume == 0 ? 1 : $rk->volume ))*100 , 2, ',', '.'):"0"}}% Rp{{ number_format($rk->pagu - $rk->RealisasiRincianKegiatan->realisasiKeuangan->sum('realisasi') , 0, ',', '.') }} Rp{{ number_format($rk->paguberjalan - $rk->customnilaikontrak , 0, ',', '.') }} {{ $rk->Opd->nama_perangkat_daerah }} {{ $rk->ProkerSubKegiatan->pptk->nama ?? '-' }} {{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->permasalahan }} {{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->tindaklanjut }}
@endif
http://e-tepian.samarindakota.go.id/
@if (!isset($_GET['generate'])) @endif