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

Realisasi Pekerjaan Mendesak Pemerintah Kota Samarinda

  1. Welcome to {{ env('APP_NAME') }}
@role('admin|admin-opd|monev')
Reset
@endrole
@foreach ($bidangs as $bidang) @foreach ($bidang->RincianSubBidang as $subbidang) @foreach ($subbidang->prokerSubKegiatan as $keysk => $rincianKegiatans) @php [$namaSK, $kodeSK] = explode('_', $keysk); @endphp @foreach ($rincianKegiatans as $rk) @endforeach @endforeach @endforeach @endforeach
No Kode/Kode Rekening Bidang/Sub Bidang/Sub Kegiatan/Pekerjaan Pagu Nilai Kontrak Realisasi Sisa Pagu Kontrak SKPD PELAKSANA PPTK Permasalahan Tindak Lanjut Dokumentasi
Fisik (%) KEU (Rp) KEU (%)
1 2 3 4 5 6 7 8 9 10 11 12 13 14
TOTAL Rp{{ number_format($bidangs->flatten()->sum('bidang_pagu_sum'), 0, ',', '.') }} Rp{{ number_format($bidangs->flatten()->sum('bidang_nilai_kontrak_sum'), 0, ',', '.') }} {{ 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_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, ',', '.')}}% Rp{{ number_format($bidangs->flatten()->sum('bidang_pagu_berjalan_sum') - $bidangs->flatten()->sum('bidang_nilai_kontrak_sum'), 0, ',', '.') }}
{{ $bidang->nama }} Rp{{ number_format($bidang->bidang_pagu_sum, 0, ',', '.') }} Rp{{ number_format($bidang->bidang_nilai_kontrak_sum, 0, ',', '.') }} {{ number_format($bidang->PercentFisik / $bidang->bidang_pagu_sum , 2, ',', '.') }}% 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 , ',', '.')}}% Rp{{ number_format($bidang->bidang_pagu_berjalan_sum - $bidang->bidang_nilai_kontrak_sum, 0, ',', '.') }}
{{ $subbidang->nomor }} {{ $subbidang->nama }} Rp{{ number_format($subbidang->sub_bidang_pagu_sum, 0, ',', '.') }} Rp{{ number_format($subbidang->sub_bidang_nilai_kontrak_sum, 0, ',', '.') }} {{ number_format($subbidang->PercentFisik / ($subbidang->sub_bidang_pagu_sum > 0 ? $subbidang->sub_bidang_pagu_sum : 1) , 2, ',', '.') }}% 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 , ',', '.')}}% Rp{{ number_format($subbidang->sub_bidang_pagu_berjalan_sum - $subbidang->sub_bidang_nilai_kontrak_sum, 0, ',', '.') }}
{{ $kodeSK }} {{ $namaSK }} Rp{{ number_format($rincianKegiatans->flatten()->sum('pagu') , 0, ',', '.') }} Rp{{ 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('keuangan') , 0, ',', '.') }} {{ number_format(($rincianKegiatans->flatten()->sum('keuangan')/$rincianKegiatans->flatten()->sum('pagu'))*100 ,2 , ',', '.') }}% Rp{{ number_format($rincianKegiatans->flatten()->sum('paguBerjalan') - $rincianKegiatans->flatten()->sum('kontrak') , 0, ',', '.') }}
{{ $rk->kode_rekening }} {{ $rk->uraian }} Rp{{ number_format($rk->pagu , 0, ',', '.') }} Rp{{ number_format($rk->kontrak , 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"}}% 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 }} @forelse($rk->RealisasiRincianKegiatan->dokumen->sortBy('keterangan')->groupBy('keterangan') as $keterangan => $docs) {{ $keterangan == 0 ? 'Dokumen Kontrak, SK dan lain-lain' : ($keterangan == 1 ? 'Dokumentasi Kegiatan' : 'Dokumen Berita Acara Serah Terima') }} @forelse($docs as $doc)
File {{ $loop->iteration }} :
@php $opciones_ssl = array( "ssl" => array( "verify_peer" => false, "verify_peer_name" => false, ), ); $file_path = public_path("assets/document/$doc->file_name"); // Sesuaikan dengan lokasi file $extencion = pathinfo($file_path, PATHINFO_EXTENSION); @endphp @if(in_array(strtolower($extencion), ['jpg', 'jpeg', 'png', 'gif', 'webp'])) file_name") }}" target="_blank"> file_name") }}" alt="{{ $doc->file_name }}" height="100vh"> @elseif(strtolower($extencion) === 'pdf' or strtolower($extencion) === 'xlsx' or strtolower($extencion) === 'xls' or strtolower($extencion) === 'xlsm' or strtolower($extencion) === 'xlsb' or strtolower($extencion) === 'docx' or strtolower($extencion) === 'doc') file_name") }}" target="_blank">📄 Download File
@else

File tidak didukung


@endif
@empty
Tidak Dapat Memuat File
@endforelse @empty
Tidak Ada Dokumentasi
@endforelse
@endsection @push('js') {{-- bootrapt tabel --}} {{-- --}} @endpush