{{--Pemerintah Kabupaten--}} @php // Check RPJMD $rpjmd = 0; $rpjmdSasaran = $rpjmdTujuan->pluck('rpjmdSasaran')->collapse(); if ( $rpjmdTujuan->isNotEmpty() ) { $rpjmd = $rpjmd + 1; } if ( $rpjmdSasaran->isNotEmpty() ) { $rpjmd = $rpjmd + 1; } // Check IKU $rpjmdTujuanIndikator = $rpjmdTujuan->pluck('rpjmdTujuanIndikator')->collapse(); $rpjmdSasaranIndikator = $rpjmdSasaran->pluck('rpjmdSasaranIndikator')->collapse(); $rpjmdTujuanTrxIku = $rpjmdTujuanIndikator->pluck('trxIku')->collapse(); $rpjmdSasaranTrxIku = $rpjmdSasaranIndikator->pluck('trxIku')->collapse(); // Check RKT $rpjmdTujuanTrxRkt = $rpjmdTujuanTrxIku->pluck('trxRkt'); $rpjmdSasaranTrxRkt = $rpjmdSasaranTrxIku->pluck('trxRkt'); // Check PK $rpjmdTujuanTrxPk = $rpjmdTujuanTrxRkt->pluck('trxPk')->collapse()->unique('id')->values()->last(); $rpjmdSasaranTrxPk = $rpjmdSasaranTrxRkt->pluck('trxPk')->collapse()->unique('id')->values()->last(); // Check RENAKSI $rpjmdTujuanTrxRenaksiNull = $rpjmdTujuanTrxPk?->trxRenaksi()->whereNull('target_fisik')->count(); $rpjmdTujuanTrxRenaksiNotNull = $rpjmdTujuanTrxPk?->trxRenaksi()->whereNotNull('target_fisik')->count(); $rpjmdSasaranTrxRenaksiNull = $rpjmdSasaranTrxPk?->trxRenaksi()->whereNull('target_fisik')->count(); $rpjmdSasaranTrxRenaksiNotNull = $rpjmdSasaranTrxPk?->trxRenaksi()->whereNotNull('target_fisik')->count(); // dd($trxRenaksiNull, $trxRenaksiNotNull) @endphp {{--RPJMD--}} {{--IKU--}} {{--RKT--}} {{--PK--}} {{--RENAKSI--}} {{--Perangkat Daerah--}} @foreach ($listSkpd as $idx => $opd) @php // $skpd = $opd->aktif()->withPivot(['nama', 'singkatan'])->first(); // Check RENSTRA $renstra = 0; $tujuan = $opd->organisasi->renstraTujuan; $sasaran = $tujuan->pluck('renstraSasaran')->collapse(); $program = $sasaran->pluck('renstraProgram')->collapse(); $kegiatan = $program->pluck('renstraKegiatan')->collapse(); $subKegiatan = $kegiatan->pluck('renstraSubKegiatan')->collapse(); if ( $tujuan->isNotEmpty() ) { $renstra = $renstra + 1; } if ( $sasaran->isNotEmpty() ) { $renstra = $renstra + 1; } if ( $program->isNotEmpty() ) { $renstra = $renstra + 1; } if ( $kegiatan->isNotEmpty() ) { $renstra = $renstra + 1; } if ( $subKegiatan->isNotEmpty() ) { $renstra = $renstra + 1; } // Check IKU $sasaranIndikator = $sasaran->pluck('renstraSasaranIndikator')->collapse(); $sasaranTrxIku = $sasaranIndikator->pluck('trxIku')->collapse(); // Check RKT $sasaranTrxRkt = $sasaranTrxIku->pluck('trxRkt'); // Check PK $trxPk = $sasaranTrxRkt->pluck('trxPk')->collapse()->unique('id')->where('jenis_pk', $jenisApbd)->where('is_posting', 1)->values()->last(); // Check RENAKSI $trxRenaksiNull = $trxPk?->trxRenaksi()->whereNull('target_fisik')->count(); $trxRenaksiNotNull = $trxPk?->trxRenaksi()->whereNotNull('target_fisik')->count(); @endphp {{--RENSTRA--}} {{--IKU--}} {{--RKT--}} {{--PK--}} {{--RENAKSI--}} @endforeach

NO	KODE	ORGANISASI PERANGKAT DAERAH	RPJMD/RENSTRA	PERENCANAAN
				IKU	RKT	PK	RENAKSI
1	-	{!! strtoupper($listKab->nama) !!}	@if ($rpjmd === 2) @elseif ($rpjmd > 0 && $rpjmd < 2) @else @endif	@if ($rpjmdTujuanTrxIku->count() > 0 && $rpjmdSasaranTrxIku->count() > 0 && $rpjmdTujuanIndikator->count() > 0 && $rpjmdSasaranIndikator->count() > 0) @elseif ($rpjmdTujuanIndikator->count() !== $rpjmdTujuanTrxIku->count() && $rpjmdTujuanTrxIku->count() > 0 && $rpjmdSasaranIndikator->count() !== $rpjmdSasaranTrxIku->count() && $rpjmdSasaranTrxIku->count() > 0) @else @endif	@if ($rpjmdTujuanTrxRkt->count() > 0 && $rpjmdSasaranTrxRkt->count() > 0 && $rpjmdTujuanIndikator->count() > 0 && $rpjmdSasaranIndikator->count() > 0) @elseif ($rpjmdTujuanIndikator->count() !== $rpjmdTujuanTrxRkt->count() && $rpjmdTujuanTrxRkt->count() > 0 && $rpjmdSasaranIndikator->count() !== $rpjmdSasaranTrxRkt->count() && $rpjmdSasaranTrxRkt->count() > 0) @else @endif	@if (!is_null($rpjmdTujuanTrxPk) && $rpjmdTujuanTrxPk->is_posting && !is_null($rpjmdSasaranTrxPk) && $rpjmdSasaranTrxPk->is_posting) @elseif (!is_null($rpjmdTujuanTrxPk) && !$rpjmdTujuanTrxPk->is_posting && !is_null($rpjmdSasaranTrxPk) && !$rpjmdSasaranTrxPk->is_posting) @else @endif	@if ($rpjmdTujuanTrxRenaksiNull === 0 && $rpjmdSasaranTrxRenaksiNull === 0) @elseif ($rpjmdTujuanTrxRenaksiNull !== 0 && $rpjmdTujuanTrxRenaksiNotNull > 0 && $rpjmdSasaranTrxRenaksiNull !== 0 && $rpjmdSasaranTrxRenaksiNotNull > 0) @else @endif
{!! $idx + 2 !!}	{!! $opd->kode_organisasi !!}	{!! strtoupper($opd->nama) !!}	@if ($renstra === 5) @elseif ($renstra > 0 && $renstra < 5) @else @endif	@if ($sasaranTrxIku->count() > 0 && $sasaranIndikator->count() === $sasaranTrxIku->groupBy('rencana_kinerja_id')->count()) @elseif ($sasaranIndikator->count() !== $sasaranTrxIku->groupBy('rencana_kinerja_id')->count() && $sasaranTrxIku->groupBy('rencana_kinerja_id')->count() > 0) @else @endif	@if ($sasaranTrxRkt->count() > 0 && $sasaranIndikator->count() === $sasaranTrxIku->groupBy('rencana_kinerja_id')->count()) @elseif ($sasaranIndikator->count() !== $sasaranTrxIku->groupBy('rencana_kinerja_id')->count() && $sasaranTrxIku->groupBy('rencana_kinerja_id')->count() > 0) @else @endif	@if (!is_null($trxPk) && $trxPk->is_posting) @elseif (!is_null($trxPk) && !$trxPk->is_posting) @else @endif	@if ($trxRenaksiNotNull > 0) @else @endif