@extends('layouts.index') @push('css') {{-- bootstrapt tabel plugins --}} @endpush @section('content')

DAK

  1. Welcome to {{ env('APP_NAME') }}
Reset
{{-- --}} {{-- --}} {{-- -- -- --}} {{-- @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 Swakelola Kontraktual Metode Pembayaran Keuangan Fisik
Volume Rp. Volume Rp. Rp. % Volume %
TOTAL Rp{{ number_format($bidangs->flatten()->sum('bidang_pagu_sum'), 0, ',', '.') }} Rp{{number_format($bidangs->flatten()->sum("bidang_realisasi_keuangan_sum"), 0, ',', '.')}} {{number_format(($bidangs->flatten()->sum("bidang_realisasi_keuangan_sum")/($bidangs->flatten()->sum('bidang_pagu_sum') > 0 ? $bidangs->flatten()->sum('bidang_pagu_sum'):1))*100 , 2, ',', '.')}}% {{ number_format($bidangs->flatten()->sum('PercentFisik')/($bidangs->flatten()->sum('bidang_pagu_sum') > 0 ? $bidangs->flatten()->sum('bidang_pagu_sum'):1) ,2, ',', '.')}}% Rp{{ number_format($bidangs->flatten()->sum('bidang_pagu_sum') - $bidangs->flatten()->sum("bidang_realisasi_keuangan_sum"), 0, ',', '.') }} Rp{{ number_format($bidangs->flatten()->sum('bidang_pagu_berjalan_sum') - $bidangs->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->kontrak , 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_nilai_kontrak_sum, 0, ',', '.') }}Rp{{ number_format($bidang->bidang_pagu_berjalan_sum - $bidang->bidang_nilai_kontrak_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_pagu_sum, 0, ',', '.') }}Rp{{ number_format($subbidang->sub_bidang_nilai_kontrak_sum, 0, ',', '.') }}Rp{{ number_format($subbidang->sub_bidang_pagu_berjalan_sum - $subbidang->sub_bidang_nilai_kontrak_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('kontrak') , 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('kontrak') , 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->kontrak , 0, ',', '.') }} {{ $rk->Opd->nama_perangkat_daerah }} {{ $rk->ProkerSubKegiatan->pptk->nama ?? '-' }} {{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->permasalahan }} {{ optional($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->first())->tindaklanjut }}
@endsection @push('js') {{-- bootrapt tabel --}} @endpush