@extends('layouts.index')

@push('css')
<link rel="stylesheet" type="text/css" href="{{asset('assets/libs/bootstrap-datepicker/css/bootstrap-datepicker.min.css')}}">
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<link rel="stylesheet" type="text/css" href="{{asset('assets/css/custom.css')}}">

{{-- bootstrapt tabel plugins --}}
<link rel="stylesheet" href="https://unpkg.com/bootstrap-table@1.21.4/dist/bootstrap-table.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.8.1/font/bootstrap-icons.css">
<link href="https://unpkg.com/bootstrap-table@1.21.4/dist/extensions/sticky-header/bootstrap-table-sticky-header.css" rel="stylesheet">
<link rel="stylesheet" type="text/css" href="{{asset('assets/libs/bootstrap-datepicker/css/bootstrap-datepicker.min.css')}}">

@endpush

@section('content')

<div class="page-content">
    <div class="container-fluid">

        <!-- start page title -->
        <div class="row">
            <div class="col-12">
                <div class="page-title-box d-flex align-items-center justify-content-between">
                    <div class="page-title">
                        <h4 class="mb-0 font-size-18">DID</h4>
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item active">Welcome to {{ env('APP_NAME') }}</li>
                        </ol>
                    </div>
                </div>
            </div>
        </div>
        <!-- end page title -->

        <div class="page-content-wrapper">

            <div class="row">
                <div class="col">
                    <div class="card">
                        <div class="card-body">
                            <div class="d-flex justify-content-between w-100 align-items-center mt-5 table-responsive">
                                @role('admin|admin-opd|monev')
                                    <form action="" class="d-flex w-100 mx-4">
                                        <div class="mx-1 w-50" style="margin-top:28px">
                                            <select name="pd" id="" class="form-control select-opd">
                                                @role('admin|monev')
                                                    @if(Auth::user()->opd_id == null)
                                                        <option value="all" @if($request->get('pd') == 'all') SELECTED @endif>Pemerintah Kota Samarinda</option>
                                                    @endif
                                                @endrole
                                                
                                                @role('admin')
                                                    {{-- <option value="">Pilih Perangkat Daerah</option> --}}
                                                    @foreach ($opd as $item)
                                                        <option value="{{ $item->id }}" @if($request->get('pd') == $item->id ) SELECTED @endif>{{ $item->nama_perangkat_daerah }}</option>
                                                    @endforeach
                                                @endrole

                                                @role('admin-opd|monev')
                                                    @foreach ($opd as $item)
                                                        <option value="{{ $item->id }}"  @if(Auth::user()->opd_id == $item->id ) SELECTED @endif>{{ $item->nama_perangkat_daerah }}</option>
                                                    @endforeach
                                                @endrole
                                            </select>
                                        </div>
                                    
                                        <div class="mx-1">
                                            <label for="tanggal_awal">Tanggal Awal</label>
                                            <input id="tanggal_awal" type="text" value="{{ ($request->tanggal_awal) ? $request->tanggal_awal : '' }}" name="tanggal_awal" class="form-control tanggal_awal_akhir" autocomplete="off">
                                        </div>
                                    
                                        <div class="mx-1">
                                            <label for="tanggal_akhir">Tanggal Akhir</label>
                                            <input id="tanggal_akhir" type="text" value="{{ ($request->tanggal_akhir) ? $request->tanggal_akhir : '' }}" name="tanggal_akhir" class="form-control tanggal_awal_akhir" autocomplete="off">
                                        </div>
                                    
                                        <div class="mx-1" style="margin-top:28px">
                                            <button class="btn btn-warning">Filter</button>
                                        </div>
                                    
                                        <div class="mx-1" style="margin-top:28px">
                                            <a href="{{url('/dau')}}" class="btn btn-success">Reset</a> 
                                        </div>
                                    
                                        <div class="mx-1" style="margin-top:28px">
                                            <button class="btn btn-success" type="submit" name="printpdf" value="print">
                                                <img height="20" src="{{ asset('pdf-download-icon.png') }}" alt="download-to-pdf">
                                            </button>
                                        </div>
                                    </form>
                                    @endrole
                            </div>
                            <div class="d-flex flex-column justify-content-center w-100 align-items-around"
                                style="display: block">

                                <div class="table-responsive py-4" style="padding: 25px;">
                                    <table id="table" class="table table-flush" data-height="500" data-show-columns="true">
                                        <thead class="thead-light">
                                            <tr class="biasa">
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">No</th>
                                                <th class="align-middle text-center" class="break-word" style="background: rgb(220, 218, 218)" rowspan="3">Kode</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">Program/Kegiatan/Sub Kegiatan/Pekerjaan</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">PA/KPA</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">PPTK</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">Pagu (Rp)</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">Nilai Kontrak (Rp)</th>
                                                <th class   ="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">Sisa Pagu (Rp)</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" colspan="3">Realisasi</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">SKPD Pelaksana</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">Permasalahan</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">Tindak Lanjut</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">Dokumen</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" rowspan="3">SPJ</th>
                                            </tr>
                                            <tr class="biasa text-center">
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)">Fisik</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)" colspan="2">Keuangan</th>
                                            </tr>
                                            <tr class="biasa text-center">
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)">%</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)">RP</th>
                                                <th class="align-middle text-center" style="background: rgb(220, 218, 218)">%</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr class="table-info">
                                                <td class="align-middle text-center" colspan="5">TOTAL</td>
                                                {{-- @php
                                                    dd($prokers->flatten()->sum('pagu_sum'));
                                                @endphp --}}
                                                <td class="text-nowrap" >Rp{{ number_format($prokers->flatten()->sum('pagu_sum') , 0, ',', '.') }}</td>
                                                <td class="text-nowrap">Rp{{number_format($prokers->flatten()->sum('nilai_kontrak_sum') , 0, ',', '.')}}</td>
                                                <td class="text-nowrap">Rp{{number_format($prokers->flatten()->sum("pagu_berjalan_sum") - $prokers->flatten()->sum("nilai_kontrak_sum") , 0, ',', '.')}}</td>
                                                <td>{{ number_format($prokers->flatten()->sum('PersentaseFisik')/($prokers->flatten()->sum('pagu_sum') > 0 ? $prokers->flatten()->sum('pagu_sum'):1),2, ',', '.')}}%</td>
                                                {{-- $item->pagu * ($item->fisik/$item->volume)*100 --}}
                                                {{-- <td>{{ number_format(($prokers->flatten()->sum('pagu_sum') * ($prokers->flatten()->sum('realisasi_fisik_sum') / $prokers->flatten()->sum('volume_sum')) * 100) / $prokers->flatten()->sum('pagu_sum') )  }}</td> --}}
                                                {{-- <td></td> --}}
                                                <td class="text-nowrap text-end">Rp{{number_format($prokers->flatten()->sum("realisasi_keuangan_sum") , 0, ',', '.')}}</td>
                                                <td class="text-center">{{number_format(($prokers->flatten()->sum("realisasi_keuangan_sum")/($prokers->flatten()->sum('pagu_sum') > 0 ? $prokers->flatten()->sum('pagu_sum'):1))*100,2 , ',', '.')}}%</td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                            </tr>
                                            {{-- Proker --}}
                                            @forelse ($prokers as $pr)
                                                
                                                {{-- Proker Program --}}
                                                @foreach ($pr->ProkerProgram as $pm)
                                                    <tr class="table-success">
                                                        <td>{{ $loop->iteration }}</td>
                                                        <td>{{ $pm->program->kode }}</td>
                                                        <td colspan="3">{{ $pm->program->nama_program }}</td>
                                                        {{-- pagu --}}
                                                        <td class="text-nowrap text-end">Rp{{ number_format($pm->program_pagu_sum , 0, ',', '.') }}</td>
                                                        {{-- nilai kontrak --}}
                                                        <td class="text-nowrap text-end">Rp{{number_format($pm->program_nilai_kontrak_sum , 0, ',', '.')}}</td>
                                                        {{-- sisa pagu --}}
                                                        <td class="text-nowrap text-end">Rp{{number_format($pm->program_pagu_berjalan_sum - $pm->program_nilai_kontrak_sum , 0, ',', '.')}}</td>
                                                        {{-- Fisik% --}}
                                                        {{-- <td>{{ number_format((@$pm->program_pagu_sum * ($pm->program_realisasi_fisik_sum/$pm->program_volume_sum)*100))}}%</td> --}}
                                                        <td class="text-center">{{ number_format($pm->PersentaseFisik/($pm->program_pagu_sum > 0 ? $pm->program_pagu_sum:1),2, ',', '.')}}%</td>
                                                        {{-- <td>{{ number_format(($pm->program_pagu_sum * ($pm->program_realisasi_fisik_sum / max($pm->program_volume_sum, 1)) * 100)/ $pm->program_pagu_sum  ) }}%</td> --}}
                                                        {{-- <td>{{ number_format(($pm->program_pagu_sum * ($pm->program_realisasi_fisik_sum / max($pm->program_volume_sum, 1)) * 100) / $pm->program_pagu_sum )  }}</td> --}}
                                                        {{-- <td></td> --}}
                                                        <td class="text-nowrap text-end">Rp{{number_format($pm->program_realisasi_keuangan_sum , 0, ',', '.')}}</td>
                                                        <td class="text-center">{{number_format(($pm->program_realisasi_keuangan_sum/($pm->program_pagu_sum > 0 ? $pm->program_pagu_sum:1))*100,2, ',', '.')}}%</td>
                                                        <td>{{ $pr->opd->nama_perangkat_daerah }}</td>
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                        <td></td>
                                                    </tr>
                                                    {{-- Proker Kegiatan --}}
                                                    @foreach ($pm->ProkerKegiatan as $pk)
                                                        <tr class="table-primary">
                                                            <td></td>
                                                            <td>{{ $pk->kegiatan->kode }}</td>
                                                            <td colspan="3">{{ $pk->kegiatan->nama_kegiatan }}</td>
                                                            <td class="text-nowrap text-end">Rp{{ number_format($pk->kegiatan_pagu_sum, 0, ',', '.') }}</td>
                                                            {{-- @php
                                                                dump($pk->kegiatan_nilai_kontrak);
                                                            @endphp --}}
                                                            <td class="text-nowrap text-end">Rp{{number_format($pk->kegiatan_nilai_kontrak_sum, 0, ',', '.')}}</td>
                                                            <td class="text-nowrap text-end">Rp{{number_format($pk->kegiatan_pagu_berjalan_sum - $pk->kegiatan_nilai_kontrak_sum, 0, ',', '.')}}</td>
                                                            {{-- <td>{{ number_format($pk->kegiatan_realisasi_fisik_sum/($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum:1),2)}}%</td> --}}
                                                            {{-- @php
                                                                dump($pk->PersentaseFisik);
                                                            @endphp --}}
                                                            {{-- <td>{{ number_format($pk->PersentaseFisik/($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum:1),2)}}%</td> --}}
                                                            <td class="text-center">{{ number_format($pk->PersentaseFisik / ($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum : 1) , 2, ',', '.') }}%</td>
                                                            {{-- <td></td> --}}
                                                            <td class="text-nowrap text-end">Rp{{number_format($pk->kegiatan_realisasi_keuangan_sum, 0, ',', '.')}}</td>
                                                            <td class="text-center">{{number_format(($pk->kegiatan_realisasi_keuangan_sum/($pk->kegiatan_pagu_sum > 0 ? $pk->kegiatan_pagu_sum:1))*100,2, ',', '.')}}%</td>
                                                            <td>{{ $pr->opd->nama_perangkat_daerah }}</td>
                                                            <td></td>
                                                            <td></td>
                                                            <td></td>
                                                            <td></td>
                                                        </tr>
                                                        {{-- Proker Sub Kegiatan --}}
                                                        @foreach ($pk->ProkerSubKegiatan as $sk)
                                                            <tr class="table-light">
                                                                <td></td>
                                                                <td>{{ $sk->subKegiatan->kode }}</td>
                                                                <td>{{ $sk->subKegiatan->nama_sub_kegiatan }}</td>
                                                                <td>{{ @$sk->Kpa->nama }}</td>
                                                                <td>{{ @$sk->Pptk->nama }}</td>
                                                                <td class="text-nowrap text-end">Rp{{ number_format($sk->sub_kegiatan_pagu_sum, 0, ',', '.') }}</td>
                                                                <td class="text-nowrap text-end">Rp{{number_format($sk->sub_kegiatan_nilai_kontrak_sum, 0, ',', '.')}}</td>
                                                                <td class="text-nowrap text-end">Rp{{number_format($sk->sub_kegiatan_pagu_berjalan_sum - $sk->sub_kegiatan_nilai_kontrak_sum, 0, ',', '.')}}</td>
                                                                {{-- <td>{{ number_format(($sk->sub_kegiatan_pagu_sum * ($sk->sub_kegiatan_realisasi_fisik_sum / max($sk->sub_kegiatan_volume_sum, 1)) * 100)/ $sk->sub_kegiatan_pagu_sum ,2 ) }}%</td> --}}
                                                                <td class="text-center">{{ number_format($sk->PersentaseFisik / $sk->sub_kegiatan_pagu_sum , 2, ',', '.') }}%</td>
                                                                <td class="text-nowrap text-end">Rp{{number_format($sk->sub_kegiatan_realisasi_keuangan_sum, 0, ',', '.')}}</td>
                                                                <td class="text-center">{{number_format(($sk->sub_kegiatan_realisasi_keuangan_sum/($sk->sub_kegiatan_pagu_sum > 0 ? $sk->sub_kegiatan_pagu_sum : 1))*100,2, ',', '.')}}%</td>
                                                                <td>{{ $pr->opd->nama_perangkat_daerah }}</td>
                                                                <td></td>
                                                                <td></td>
                                                                <td></td>
                                                                <td></td>
                                                            </tr>
                                                            @foreach ($sk->RincianKegiatan as $rk)
                                                                <tr class="table-light">
                                                                    <td></td>                                                                
                                                                    <td>{{ $rk->kode_rekening }}</td>
                                                                    <td>{{ $rk->uraian }}</td>
                                                                    <td>{{ @$sk->Kpa->nama }}</td>
                                                                    <td>{{ @$sk->Pptk->nama }}</td>
                                                                    <td class="text-nowrap text-end">Rp{{ number_format($rk->pagu , 0, ',', '.') }}</td>
                                                                    <td class="text-nowrap text-end">Rp{{ number_format($rk->kontrak , 0, ',', '.') }}</td>
                                                                    <td class="text-nowrap text-end">Rp{{ number_format($rk->paguberjalan - $rk->kontrak , 0, ',', '.') }}</td>
                                                                    <td class="text-center">{{$rk->RealisasiRincianKegiatan?number_format(($rk->RealisasiRincianKegiatan->realisasiFisik->sum('realisasi')/($rk->volume == 0 ? 1 : $rk->volume ))*100 , 2, ',', '.'):"0"}}%</td>
                                                                    <td class="text-nowrap text-end">
                                                                        Rp{{ $rk->RealisasiRincianKegiatan ? number_format($rk->RealisasiRincianKegiatan->realisasiKeuangan->sum(function ($item) {
                                                                            return is_numeric($item->realisasi) ? $item->realisasi : 0;
                                                                            }), 0, ',', '.') : "-" }}                                    
                                                                    </td>
                                                                    <td class="text-center">
                                                                        {{$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"}}%
                                                                    </td>
                                                                    <td>{{ $pr->opd->nama_perangkat_daerah }}</td>
                                                                    <td></td>
                                                                    <td>
                                                                        @if ($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->count())
                                                                            {{ $rk->RealisasiRincianKegiatan->permasalahanTindakLanjut()->first()->permasalahan }}
                                                                        @endif
                                                                    </td>
                                                                    <td>
                                                                        @if ($rk->RealisasiRincianKegiatan->permasalahanTindakLanjut->count())
                                                                            {{ $rk->RealisasiRincianKegiatan->permasalahanTindakLanjut()->first()->tindaklanjut }}
                                                                        @endif
                                                                    </td>
                                                                    <td></td>
                                                                </tr>
                                                            @endforeach
                                                        @endforeach
                                                    @endforeach
                                                @endforeach
                                                {{-- Akhir Proker Program --}}
                                            @empty
                                                <tr>
                                                    <td class="text-center" colspan="17">Tidak ada Data</td>
                                                </tr>
                                            @endforelse
                                            
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>
</div>


@endsection

@push('js')
{{-- bootrapt tabel --}}
<script src="https://unpkg.com/bootstrap-table@1.21.4/dist/bootstrap-table.min.js"></script>
<script src="https://unpkg.com/bootstrap-table@1.21.4/dist/extensions/sticky-header/bootstrap-table-sticky-header.min.js"></script>

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
<script src="{{asset('assets/libs/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script type="text/javascript">
    $('.select-opd').select2({
       width:'100%',
    });

    $('.tanggal_awal_akhir').datepicker({
        format:'yyyy-mm-dd',
        autoclose:true,
    });

    $(document).ready(function() {
        navbarHeight = parseInt($('#page-topbar').css('height'));
        $('#table').bootstrapTable({
            // stickyHeader: true,
            showFullscreen: true,
            stickyHeaderOffsetY: navbarHeight,
            theadClasses: "table-light",
        }).on('load-fullscreen.bs.table', function () {
            // Add icon when entering fullscreen mode
            $('.fullscreen.btn').html('<i class="fas fa-compress"></i> Fullscreen');
        }).on('unload-fullscreen.bs.table', function () {
            // Remove icon when exiting fullscreen mode
            $('.fullscreen.btn').html('<i class="fas fa-expand"></i> Fullscreen');
        });
    });

</script>

@endpush