@php
    $selisih = $periode->tahun_akhir - $periode->tahun_awal + 1;
@endphp
<div id="tableSubKegiatanRenstra" class="table-responsive" style="border-radius:2px !important; width:100%;">
    <table class="table table-bordered table-hover table-sm">
        <thead>
        <tr>
            <th rowspan="2" colspan="3" style="vertical-align: middle; width:10px !important;">
                SUB KEGIATAN
            </th>
            <th rowspan="2" style="vertical-align: middle; width:10px !important;">
                SASARAN SUB KEGIATAN
            </th>
            <th rowspan="2" colspan="3" style="vertical-align: middle;">
                INDIKATOR SUB KEGIATAN
            </th>
            <th rowspan="2" style="vertical-align: middle;" class="text-center">
                SATUAN
            </th>
            <th colspan="{{ ($periode->tahun_akhir - $periode->tahun_awal) + 1 }}" style="vertical-align: middle;" class="text-center">
                TARGET
            </th>
        </tr>
        <tr>
            @for($i=$periode->tahun_awal; $i <= $periode->tahun_akhir; $i++)
                <th class="text-center">{{ $i }}</th>
            @endfor
        </tr>
        </thead>
        <tbody>
        @if($renstraSubKegiatan->isNotEmpty())
            @foreach($renstraSubKegiatan as $idxKegiatan => $kegiatan)
                @php
                    $idxKegiatan = $idxKegiatan + 1;
                @endphp
                <tr>
                    <td colspan="{{ 8 + $selisih }}" class="bg-success text-white">
                        <small>
                            <b>
                                {{ $kegiatan->kode_perencanaan .' '. $kegiatan->perencanaan->nama() }}
                            </b>
                        </small>
                    </td>
                </tr>

                @foreach($kegiatan->renstraSubKegiatan as $idxSubKegiatan => $subKegiatan)
                    @php
                        $idxSubKegiatan = $idxSubKegiatan + 1;
                        $indikators = $subKegiatan->renstraSubKegiatanIndikator;
                        $indikatorCount = $indikators->count();
                    @endphp

                    @if($indikatorCount < 2)

                        <tr data-kegiatan="{{ $kegiatan->kode_perencanaan .'. '. $kegiatan->perencanaan->nama() }}">
                            <td class="text-center">
                                <small>
                                    <div class="dropdown">
                                        <button class="btn p-0" type="button" id="dropdownMenuButton"
                                                data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                            <i class="icon-lg text-muted pb-3px" data-feather="settings"></i>
                                        </button>
                                        <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                            <a class="dropdown-item d-flex align-items-center renstraEditSubKegiatan"
                                               href="#"
                                               data-sub-kegiatan-id="{{ encrypt($subKegiatan->id) }}">
                                                <i data-feather="edit-2" class="icon-sm mr-1"></i>
                                                <span class="">Ubah</span></a>
                                            <a class="dropdown-item d-flex align-items-center renstraDestroySubKegiatan"
                                               href="#" data-sub-kegiatan-id="{{ encrypt($subKegiatan->id) }}">
                                                <i data-feather="trash" class="icon-sm mr-1"></i>
                                                <span class="">Hapus</span>
                                            </a>
                                            <div class="dropdown-divider"></div>
                                            <a class="dropdown-item d-flex align-items-center renstraAddSubKegiatanIndikator"
                                               href="#"
                                               data-sub-kegiatan-id="{{ encrypt($subKegiatan->id) }}">
                                                <i data-feather="plus-circle" class="icon-sm mr-1"></i>
                                                <span class="">Tambah Indikator</span>
                                            </a>
                                        </div>
                                    </div>
                                </small>
                            </td>
                            <td class="text-center">
                                <small>
                                    {{ $subKegiatan->kode_perencanaan }}
                                </small>
                            </td>
                            <td>
                                <small>
                                    {{ $subKegiatan->perencanaan->nama() }}
                                </small>
                            </td>
                            @if($indikatorCount > 0)
                                @php
                                    $indikator = $indikators->first();
                                    $indikatorTarget = $indikator->renstraSubKegiatanIndikatorTarget;
                                    $trxIku = $indikator->trxIku
                                                    ->filter(function ($iku){
                                                        return $iku->trxRkt?->trxPk->isNotEmpty();
                                                    })
                                                    ->unique('jabatan_organisasi_aktif_id')
                                                    ->values();
                                    $nilai = $indikator->orientasi_hasil + $indikator->relevansi_sasaran_atasan + $indikator->ketepatan;
                                @endphp
                                <td>
                                    <small>
                                        {{ $indikator->sasaran_sub_kegiatan }}
                                    </small>
                                </td>
                                <td class="text-center">
                                    <small>
                                        <div class="dropdown">
                                            <button class="btn p-0" type="button" id="dropdownMenuButton"
                                                    data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                <i class="icon-lg text-muted pb-3px" data-feather="settings"></i>
                                            </button>
                                            <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                                <a class="dropdown-item d-flex align-items-center renstraEditSubKegiatanIndikator"
                                                   href="#"
                                                   data-sub-kegiatan-indikator-id="{{ encrypt($indikator->id) }}">
                                                    <i data-feather="edit-2" class="icon-sm mr-1"></i>
                                                    <span class="">Ubah</span></a>
                                                <a class="dropdown-item d-flex align-items-center renstraDestroySubKegiatanIndikator"
                                                   href="#"
                                                   data-sub-kegiatan-indikator-id="{{ encrypt($indikator->id) }}">
                                                    <i data-feather="trash" class="icon-sm mr-1"></i>
                                                    <span class="">Hapus</span></a>
                                            </div>
                                        </div>
                                    </small>
                                </td>
                                <td class="text-center">
                                    <small>
                                        1
                                    </small>
                                </td>
                                <td>
                                    <small>
                                        {{ $indikator->indikator }}
                                    </small>
                                </td>
                                <td class="text-center">
                                    <small>
                                        {{ $indikator->satuan }}
                                    </small>
                                </td>
                                @if($indikatorTarget->isNotEmpty())
                                    @for($i=$periode->tahun_awal; $i <= $periode->tahun_akhir; $i++)
                                        <td class="text-center">
                                            <small>
                                                @if($indikatorTarget->where('tahun', $i)->first()->target != 0)
                                                    {{ $indikatorTarget->where('tahun', $i)->first()->target }}
                                                @else
                                                    N/A
                                                @endif
                                            </small>
                                        </td>
                                    @endfor
                                @else
                                    @for($i=$periode->tahun_awal; $i <= $periode->tahun_akhir; $i++)
                                        <td class="text-center">-</td>
                                    @endfor
                                @endif
                            @else
                                @for($i=1; $i <= 10; $i++)
                                    <td class="text-center"></td>
                                @endfor
                            @endif
                        </tr>

                    @else
                        @php
                            $indikator = $indikators->first();
                            $indikatorTarget = $indikator->renstraSubKegiatanIndikatorTarget;
                            $trxIku = $indikator->trxIku
                                                    ->filter(function ($iku){
                                                        return $iku->trxRkt?->trxPk->isNotEmpty();
                                                    })
                                                    ->unique('jabatan_organisasi_aktif_id')
                                                    ->values();
                            $nilai = $indikator->orientasi_hasil + $indikator->relevansi_sasaran_atasan + $indikator->ketepatan;
                        @endphp

                        <tr data-kegiatan="{{ $kegiatan->kode_perencanaan .'. '. $kegiatan->perencanaan->nama() }}">
                            <td rowspan="{{ $indikatorCount }}" class="text-center">
                                <small>
                                    <div class="dropdown">
                                        <button class="btn p-0" type="button" id="dropdownMenuButton"
                                                data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                            <i class="icon-lg text-muted pb-3px" data-feather="settings"></i>
                                        </button>
                                        <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                            <a class="dropdown-item d-flex align-items-center renstraEditSubKegiatan"
                                               href="#" data-sub-kegiatan-id="{{ encrypt($subKegiatan->id) }}">
                                                <i data-feather="edit-2" class="icon-sm mr-1"></i>
                                                <span class="">Ubah</span>
                                            </a>
                                            <a class="dropdown-item d-flex align-items-center renstraDestroySubKegiatan"
                                               href="#"
                                               data-sub-kegiatan-id="{{ encrypt($subKegiatan->id) }}">
                                                <i data-feather="trash" class="icon-sm mr-1"></i>
                                                <span class="">Hapus</span>
                                            </a>
                                            <div class="dropdown-divider"></div>
                                            <a class="dropdown-item d-flex align-items-center renstraAddSubKegiatanIndikator"
                                               href="#"
                                               data-sub-kegiatan-id="{{ encrypt($subKegiatan->id) }}">
                                                <i data-feather="plus-circle" class="icon-sm mr-1"></i>
                                                <span class="">Tambah Indikator</span>
                                            </a>
                                        </div>
                                    </div>
                                </small>
                            </td>
                            <td rowspan="{{ $indikatorCount }}" class="text-center">
                                <small>
                                    {{ $subKegiatan->kode_perencanaan }}
                                </small>
                            </td>
                            <td rowspan="{{ $indikatorCount }}">
                                <small>
                                    {{ $subKegiatan->perencanaan->nama() }}
                                </small>
                            </td>

                            <td>
                                <small>
                                    {{ $indikator->sasaran_sub_kegiatan }}
                                </small>
                            </td>
                            <td class="text-center">
                                <small>
                                    <div class="dropdown">
                                        <button class="btn p-0" type="button" id="dropdownMenuButton"
                                                data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                            <i class="icon-lg text-muted pb-3px" data-feather="settings"></i>
                                        </button>
                                        <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                            <a class="dropdown-item d-flex align-items-center renstraEditSubKegiatanIndikator"
                                               href="#"
                                               data-sub-kegiatan-indikator-id="{{ encrypt($indikator->id) }}">
                                                <i data-feather="edit-2" class="icon-sm mr-1"></i>
                                                <span class="">Ubah</span>
                                            </a>
                                            <a class="dropdown-item d-flex align-items-center renstraDestroySubKegiatanIndikator"
                                               href="#"
                                               data-sub-kegiatan-indikator-id="{{ encrypt($indikator->id) }}">
                                                <i data-feather="trash" class="icon-sm mr-1"></i>
                                                <span class="">Hapus</span>
                                            </a>
                                        </div>
                                    </div>
                                </small>
                            </td>
                            <td class="text-center">
                                <small>
                                    1
                                </small>
                            </td>
                            <td>
                                <small>
                                    {{ $indikator->indikator }}
                                </small>
                            </td>
                            <td class="text-center">
                                <small>
                                    {{ $indikator->satuan }}
                                </small>
                            </td>
                            @if($indikatorTarget->isNotEmpty())
                                @for($i=$periode->tahun_awal; $i <= $periode->tahun_akhir; $i++)
                                    <td class="text-center">
                                        <small>
                                            @if($indikatorTarget->where('tahun', $i)->first()->target != 0)
                                                {{ $indikatorTarget->where('tahun', $i)->first()->target }}
                                            @else
                                                N/A
                                            @endif
                                        </small>
                                    </td>
                                @endfor
                            @else
                                @for($i=$periode->tahun_awal; $i <= $periode->tahun_akhir; $i++)
                                    <td class="text-center">-</td>
                                @endfor
                            @endif
                        </tr>

                        @foreach($indikators->slice(1) as $idxIndikator => $indikator)
                            @php
                                $idxIndikator = $idxIndikator + 1;
                                $indikatorTarget = $indikator->renstraSubKegiatanIndikatorTarget;
                                $trxIku = $indikator->trxIku
                                                    ->filter(function ($iku){
                                                        return $iku->trxRkt?->trxPk->isNotEmpty();
                                                    })
                                                    ->unique('jabatan_organisasi_aktif_id')
                                                    ->values();
                                $nilai = $indikator->orientasi_hasil + $indikator->relevansi_sasaran_atasan + $indikator->ketepatan;
                            @endphp

                            <tr>
                                <td>
                                    <small>
                                        {{ $indikator->sasaran_sub_kegiatan }}
                                    </small>
                                </td>
                                <td class="text-center">
                                    <small>
                                        <div class="dropdown">
                                            <button class="btn p-0" type="button" id="dropdownMenuButton"
                                                    data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                <i class="icon-lg text-muted pb-3px" data-feather="settings"></i>
                                            </button>
                                            <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">
                                                <a class="dropdown-item d-flex align-items-center renstraEditSubKegiatanIndikator"
                                                   href="#"
                                                   data-sub-kegiatan-indikator-id="{{ encrypt($indikator->id) }}">
                                                    <i data-feather="edit-2" class="icon-sm mr-1"></i>
                                                    <span class="">Ubah</span>
                                                </a>
                                                <a class="dropdown-item d-flex align-items-center renstraDestroySubKegiatanIndikator"
                                                   href="#"
                                                   data-sub-kegiatan-indikator-id="{{ encrypt($indikator->id) }}">
                                                    <i data-feather="trash" class="icon-sm mr-1"></i>
                                                    <span class="">Hapus</span>
                                                </a>
                                            </div>
                                        </div>
                                    </small>
                                </td>
                                <td class="text-center">
                                    <small>
                                        {{ $idxIndikator }}
                                    </small>
                                </td>
                                <td>
                                    <small>
                                        {{ $indikator->indikator }}
                                    </small>
                                </td>
                                <td class="text-center">
                                    <small>
                                        {{ $indikator->satuan }}
                                    </small>
                                </td>


                                @if($indikatorTarget->isNotEmpty())
                                    @for($i=$periode->tahun_awal; $i <= $periode->tahun_akhir; $i++)
                                        <td class="text-center">
                                            <small>
                                                @if($indikatorTarget->where('tahun', $i)->first()->target != 0)
                                                    {{ $indikatorTarget->where('tahun', $i)->first()->target }}
                                                @else
                                                    N/A
                                                @endif
                                            </small>
                                        </td>
                                    @endfor
                                @else
                                    @for($i=$periode->tahun_awal; $i <= $periode->tahun_akhir; $i++)
                                        <td class="text-center">-</td>
                                    @endfor
                                @endif
                            </tr>

                        @endforeach
                    @endif
                @endforeach
            @endforeach
        @else
            <tr>
                <td colspan="{{ 8 + $selisih }}">Data tidak ditemukan</td>
            </tr>
        @endif
    </table>
</div>