{{--Perangkat Daerah--}}
@foreach ($listSkpd as $idxOpd => $opd)
    @php
        $organisasi = $opd->organisasi;
        $tujuan = $organisasi->renstraTujuan;
        $sasaran = $tujuan->pluck('renstraSasaran')->collapse();
        $sasaranIndikator = $sasaran->pluck('renstraSasaranIndikator')->collapse();
        $target = $sasaranIndikator->pluck('renstraSasaranIndikatorTarget')->collapse();
        $trxIku = $sasaranIndikator->pluck('trxIku')->map(function ($q, $i) use($target) {
            $trxIku = $q->last();
            if (!is_null($trxIku)) {
                $target = $target->where('renstra_sasaran_indikator_id', $trxIku->rencana_kinerja_id)->first();
                $trxRkt = $trxIku->trxRkt;
                $trxPk = $trxRkt->trxPk->last();
                if (!is_null($trxPk)) {
                    $trxRenaksi = $trxPk->trxPkDetail->where('trx_rkt_id', $trxRkt->id)->last()->trxRenaksi;
                    $trxIku->renaksi = $trxRenaksi;
                    $trxIku->capaian = $trxRkt->persentase;
                    $trxIku->has_pk = true;
                }
                else {
                    $trxIku->capaian = 0;
                    $trxIku->has_pk = false;
                }
            }
            return $trxIku;
        });

        $targetNotNull = $trxIku->filter(function ($iku){
           return !is_null($iku);
        })->values();

         $label1 = $trxIku->where('capaian', '<=', 50)->where('has_pk', true);
         $label2 = $trxIku->where('capaian', '>', 50)->where('capaian', '<=', 65)->where('has_pk', true);
         $label3 = $trxIku->where('capaian', '>', 65)->where('capaian', '<=', 75)->where('has_pk', true);
         $label4 = $trxIku->where('capaian', '>', 75)->where('capaian', '<=', 90)->where('has_pk', true);
         $label5 = $trxIku->where('capaian', '>', 90)->where('capaian', '<=', 100)->where('has_pk', true);
         $label6 = $trxIku->where('capaian', '>', 100)->where('has_pk', true)
    @endphp
    <tr>
        <td rowspan="6" class="text-center align-top">
            <small class="font-weight-bold">{!! $idxOpd + 2 !!}</small>
        </td>
        @if(\Illuminate\Support\Facades\Auth::user())
            <td colspan="10" class="pl-3">
                <small class="font-weight-bold">{!! strtoupper($opd->nama) !!}</small>
            </td>
        @else
            <td colspan="9" class="pl-3">
                <small class="font-weight-bold">{!! strtoupper($opd->nama) !!}</small>
            </td>
        @endif
    </tr>

    {{--Triwulan--}}
    @foreach (['I', 'II', 'III', 'IV'] as $triwulan)
        @php
            $renaksi = $trxIku->map(function ($v) use($triwulan) {
                if(isset($v->renaksi)) {
                    $v->triwulan = $v->renaksi->where('triwulan', $triwulan)->whereNotNull('target_fisik')->last();
                    if (!is_null($v->triwulan) && !is_null($v->triwulan->realisasi_fisik) && $v->triwulan->target_fisik != 0 && $v->triwulan->realisasi_fisik != 0) {
                        $v->capaian_triwulan = $v->triwulan?->persentase_fisik;
                    }
                    else {
                        $v->capaian_triwulan = 0;
                    }
                }
                return $v;
            });

            $targetTriwulan = $renaksi->whereNotNull('triwulan');

            $labelTriwulan1 = $targetTriwulan->where('capaian_triwulan', '>=', 0)->where('capaian_triwulan', '<=', 50);
            $labelTriwulan2 = $targetTriwulan->where('capaian_triwulan', '>', 50)->where('capaian_triwulan', '<=', 65);
            $labelTriwulan3 = $targetTriwulan->where('capaian_triwulan', '>', 65)->where('capaian_triwulan', '<=', 75);
            $labelTriwulan4 = $targetTriwulan->where('capaian_triwulan', '>', 75)->where('capaian_triwulan', '<=', 90);
            $labelTriwulan5 = $targetTriwulan->where('capaian_triwulan', '>', 90)->where('capaian_triwulan', '<=', 100);
            $labelTriwulan6 = $targetTriwulan->where('capaian_triwulan', '>', 100);

            if (str_contains($opd->nama, 'Dinas Koperasi')) {
                $namaOPD = 'DINAS KOPERASI USAHA KECIL DAN MENENGAH, PERINDUSTRIAN DAN TENAGA KERJA';
            } else {
                $namaOPD = strtoupper($opd->nama);
            }
        @endphp
        <tr>
            <td class="pl-4">
                <small>Triwulan {!! $triwulan !!}</small>
            </td>

            {{--Jumlah Target--}}
            <td class="text-center align-middle">
                @if ($targetTriwulan?->count() > 0)
                    <a type="button"
                       onclick="Tabulasi.ListIndikator('triwulan', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_0', '{!! $triwulan !!}')">
                                <span class="badge badge-pill badge-info">
                                    <small class="font-weight-bold">{!! $targetTriwulan?->count() !!}</small>
                                </span>
                    </a>
                @endif
            </td>

            {{--Target <= 50--}}
            <td class="text-center align-middle">
                @if ($labelTriwulan1?->count() > 0)
                    <a type="button"
                       onclick="Tabulasi.ListIndikator('triwulan', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_1', '{!! $triwulan !!}')">
                                <span class="badge badge-pill badge-danger">
                                    <small class="font-weight-bold">{!! $labelTriwulan1?->count() !!}</small>
                                </span>
                    </a>
                @endif
            </td>

            {{--Target > 50 <= 65--}}
            <td class="text-center align-middle">
                @if ($labelTriwulan2?->count() > 0)
                    <a type="button"
                       onclick="Tabulasi.ListIndikator('triwulan', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_2', '{!! $triwulan !!}')">
                                <span class="badge badge-pill badge-orange">
                                    <small class="font-weight-bold">{!! $labelTriwulan2?->count() !!}</small>
                                </span>
                    </a>
                @endif
            </td>

            {{--Target > 65 <= 75--}}
            <td class="text-center align-middle">
                @if ($labelTriwulan3?->count() > 0)
                    <a type="button"
                       onclick="Tabulasi.ListIndikator('triwulan', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_3', '{!! $triwulan !!}')">
                                <span class="badge badge-pill badge-warning">
                                    <small class="font-weight-bold">{!! $labelTriwulan3?->count() !!}</small>
                                </span>
                    </a>
                @endif
            </td>

            {{--Target > 75 <= 90--}}
            <td class="text-center align-middle">
                @if ($labelTriwulan4?->count() > 0)
                    <a type="button"
                       onclick="Tabulasi.ListIndikator('triwulan', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_4', '{!! $triwulan !!}')">
                                <span class="badge badge-pill badge-success">
                                    <small class="font-weight-bold">{!! $labelTriwulan4?->count() !!}</small>
                                </span>
                    </a>
                @endif
            </td>

            {{--Target > 90 <= 100--}}
            <td class="text-center align-middle">
                @if ($labelTriwulan5?->count() > 0)
                    <a type="button"
                       onclick="Tabulasi.ListIndikator('triwulan', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_5', '{!! $triwulan !!}')">
                                <span class="badge badge-pill badge-primary">
                                    <small class="font-weight-bold">{!! $labelTriwulan5?->count() !!}</small>
                                </span>
                    </a>
                @endif
            </td>

            {{--Target > 100--}}
            <td class="text-center align-middle">
                @if ($labelTriwulan6?->count() > 0)
                    <a type="button"
                       onclick="Tabulasi.ListIndikator('triwulan', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_6', '{!! $triwulan !!}')">
                                <span class="badge badge-pill badge-violet">
                                    <small class="font-weight-bold">{!! $labelTriwulan6?->count() !!}</small>
                                </span>
                    </a>
                @endif
            </td>

            {{--Jumlah Indikator--}}
            <td class="text-center align-middle">
                @if ($target?->count() > 0)
                    <a type="button"
                       onclick="Tabulasi.ListIndikator('triwulan', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_7', '{!! $triwulan !!}')">
                                <span class="badge badge-pill badge-secondary">
                                    <small class="font-weight-bold">{!! $target?->count() !!}</small>
                                </span>
                    </a>
                @endif
            </td>

            @auth
                @php
                    $rekomendasi = $opd->rekomendasi_pengukuran
                                      ->where('triwulan',$triwulan)
                                      ->where('jenis',$request['jenis_apbd']);

                @endphp

                @if(\Illuminate\Support\Facades\Auth::user()->hasRole('adminKab'))
                    @if($rekomendasi->first()==null)
                        <td>
                            <button onclick="show_rekomendasi(this)"
                                    data-status="empty"
                                    data-organisasi="{{$opd->kode_organisasi}}"
                                    data-triwulan="{{$triwulan}}"
                                    class="btn btn-danger btn-block btn-sm">
                                Rekomendasi
                            </button>
                        </td>
                    @else
                        <td>
                            <button class="btn btn-info btn-block btn-sm"
                                    onclick="show_rekomendasi(this)"
                                    data-status="update"
                                    data-triwulan="{{$triwulan}}"
                                    data-id="{{$rekomendasi->first()->id}}"
                            >Rekomendasi</button>
                        </td>
                    @endif
                @else
                    @php
                        $own_kode_organisasi = \Illuminate\Support\Facades\Auth::user()->kode_organisasi;
                    @endphp

                    @if($opd->kode_organisasi===$own_kode_organisasi)
                        @if($rekomendasi->first()!=null)
                            <td>
                                <button class="btn btn-info btn-block btn-sm"
                                        onclick="show_rekomendasi_view(this)"
                                        data-status="update"
                                        data-id="{{$rekomendasi->first()->id}}"
                                >Rekomendasi</button>
                            </td>
                        @else
                            <td>{{ $rekomendasi->first()?->recomend }}</td>
                        @endif
                    @else
                        <td>
                            -
                        </td>
                    @endif
                @endif

            @endauth


        </tr>
    @endforeach

    {{--Tahunan--}}
    <tr>
        <td class="pl-4">
            <small>Tahun {!! $tahun !!}</small>
        </td>

        {{--Jumlah Target--}}
        <td class="text-center align-middle">
            @if ($targetNotNull->count() > 0)
                <a type="button"
                   onclick="Tabulasi.ListIndikator('tahun', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_0')">
                            <span class="badge badge-pill badge-info">
                                <small class="font-weight-bold">{!! $targetNotNull->count() !!}</small>
                            </span>
                </a>
            @endif
        </td>

        {{--Target <= 50--}}
        <td class="text-center align-middle">
            @if ($label1?->count() > 0)
                <a type="button"
                   onclick="Tabulasi.ListIndikator('tahun', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_1')">
                            <span class="badge badge-pill badge-danger">
                                <small class="font-weight-bold">{!! $label1?->count() !!}</small>
                            </span>
                </a>
            @endif
        </td>

        {{--Target > 50 <= 65--}}
        <td class="text-center align-middle">
            @if ($label2?->count() > 0)
                <a type="button"
                   onclick="Tabulasi.ListIndikator('tahun', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_2')">
                            <span class="badge badge-pill badge-orange">
                                <small class="font-weight-bold">{!! $label2?->count() !!}</small>
                            </span>
                </a>
            @endif
        </td>

        {{--Target > 65 <= 75--}}
        <td class="text-center align-middle">
            @if ($label3?->count() > 0)
                <a type="button"
                   onclick="Tabulasi.ListIndikator('tahun', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_3')">
                            <span class="badge badge-pill badge-warning">
                                <small class="font-weight-bold">{!! $label3?->count() !!}</small>
                            </span>
                </a>
            @endif
        </td>

        {{--Target > 75 <= 90--}}
        <td class="text-center align-middle">
            @if ($label4?->count() > 0)
                <a type="button"
                   onclick="Tabulasi.ListIndikator('tahun', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_4')">
                            <span class="badge badge-pill badge-success">
                                <small class="font-weight-bold">{!! $label4?->count() !!}</small>
                            </span>
                </a>
            @endif
        </td>

        {{--Target > 90 <=100--}}
        <td class="text-center align-middle">
            @if ($label5?->count() > 0)
                <a type="button"
                   onclick="Tabulasi.ListIndikator('tahun', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_5')">
                            <span class="badge badge-pill badge-primary">
                                <small class="font-weight-bold">{!! $label5?->count() !!}</small>
                            </span>
                </a>
            @endif
        </td>

        {{--Target > 100--}}
        <td class="text-center align-middle">
            @if ($label6?->count() > 0)
                <a type="button"
                   onclick="Tabulasi.ListIndikator('tahun', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_6')">
                            <span class="badge badge-pill badge-violet">
                                <small class="font-weight-bold">{!! $label6?->count() !!}</small>
                            </span>
                </a>
            @endif
        </td>

        {{--Jumlah Indikator--}}
        <td class="text-center align-middle">
            @if ($sasaranIndikator->count() > 0)
                <a type="button"
                   onclick="Tabulasi.ListIndikator('tahun', '{!! $opd->kode_organisasi !!}', '{!! $namaOPD !!}', {!! $tahun !!}, 'label_7')">
                            <span class="badge badge-pill badge-secondary">
                                <small class="font-weight-bold">{!! $sasaranIndikator->count() !!}</small>
                            </span>
                </a>
            @endif
        </td>
    </tr>
@endforeach