| 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, ',', '.') }} |
|
|
|
|
{{-- | --}}
@foreach ($bidangs as $bidang)
|
{{ $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, ',', '.') }} |
|
|
|
|
{{-- | --}}
@foreach ($bidang->RincianSubBidang as $subbidang)
| {{ $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, ',', '.') }} |
|
|
|
|
{{-- | --}}
@foreach ($subbidang->prokerSubKegiatan as $keysk => $rincianKegiatans)
@php
[$namaSK, $kodeSK] = explode('_', $keysk);
@endphp
| {{ $kodeSK }} |
{{ $namaSK }} |
Rp{{ number_format($rincianKegiatans->flatten()->sum('pagu') , 0, ',', '.') }} |
Rp{{ 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('keuangan') , 0, ',', '.') }} |
{{ number_format(($rincianKegiatans->flatten()->sum('keuangan')/$rincianKegiatans->flatten()->sum('pagu'))*100 ,2 , ',', '.') }}%
|
Rp{{ number_format($rincianKegiatans->flatten()->sum('paguBerjalan') - $rincianKegiatans->flatten()->sum('customnilaikontrak') , 0, ',', '.') }} |
|
|
|
|
{{-- | --}}
@foreach ($rincianKegiatans as $rk)
| {{ $rk->kode_rekening }} |
{{ $rk->uraian }} |
Rp{{ number_format($rk->pagu , 0, ',', '.') }} |
Rp{{ number_format($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"}}%
|
Rp{{ number_format($rk->paguBerjalan - $rk->customnilaikontrak , 0, ',', '.') }} |
{{ $rk->Opd->nama_perangkat_daerah }} |
{{ $rk->ProkerSubKegiatan->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']))
@php
if (file_exists($file_path)) {
$data = file_get_contents($file_path, false, stream_context_create($opciones_ssl));
$base64 = base64_encode($data);
$path_img = 'data:image/' . $extencion . ';base64,' . $base64;
} else {
$path_img = null;
}
@endphp
@if($path_img)
@else
Tidak Dapat Memuat Gambar
@endif
@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')
Download File
@else
File tidak didukung
@endif
Tidak Dapat Load Dokumen
@endforelse
@empty
Tidak Ada Dokumentasi
@endforelse
| --}}
@endforeach
@endforeach
@endforeach
@endforeach
{{-- @forelse($rk->RealisasiRincianKegiatan->dokumen as $doc)
@empty
-
@endforelse --}}
{{-- @empty
| Tidak Ada Data |
@endforelse --}}