@extends('layouts.index')

@section('content')

@include('layouts.include._breadcrumb')

<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">Data Anggaran {{ $title }}</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="card-title">
                                <div class="row">
                                    <div class="col-6">
                                        <h3 class="mb-0">Data Anggaran {{$title}}</h3>
                                    </div>
                                </div>

                                <div class="row mt-5">
                                    @role('admin')
                                        <div class="col-md-2 m-2">
                                            <form action="">
                                                @csrf
                                                <input type="hidden" name="refresh" value="1">
                                                <button type="submit" class="btn btn-primary btn-generate">Perbaharui Data Anggaran</button>
                                            </form>
                                        </div>
                                    @endrole
                                    <div class="col-md-{{ Auth::user()->hasRole('admin') ? 9 : 12 }} m-2">
                                        <div class="progress" style="height:35px; display:none;">
                                            <div class="progress-bar progress-bar-striped progress-bar-animated" style="width:0%"><span style="font-size:14px;">Sedang melakukan pembaruan... <span class="percent-now"></span></span> </div>
                                        </div>

                                        @if(isset($lastUpdatedAt))
                                            <div class="alert alert-success d-flex align-items-center" id="last_update_at" style="height:36px;">
                                                <i class="fa fa-clock"></i> &nbsp; Terakhir diperbarui pada {{ \Carbon\Carbon::parse($lastUpdatedAt)->format('Y-m-d H:i:s') }}
                                            </div>
                                        @else
                                            <div class="alert alert-success d-flex align-items-center" id="last_update_at" style="height:36px;">
                                                Belum pernah diperbarui
                                            </div>
                                        @endif
                                    </div>
                                </div>
                            </div>
                            <div class="table-responsive py-4">
                                <table class="table table-hover" id="datatable_number_reset">
                                    <thead class="table-primary">
                                        <tr>
                                            <th class="text-center" rowspan="3">No</th>
                                            <th class="text-center" rowspan="3">Nama / NIP / Telpon</th>
                                            <th class="text-center" rowspan="3">Bagian / Bidang / UPT / Kel</th>
                                            <th class="text-center" rowspan="3">OPD</th>
                                            <th class="text-center" rowspan="3">Status</th>
                                            <th class="text-center" rowspan="3">Anggaran</th>
                                            <th class="text-center" colspan="4">Realisasi</th>
                                        </tr>
                                        <tr>
                                            <th class="text-center">Fisik</th>
                                            <th class="text-center" colspan="3">Keuangan</th>
                                        </tr>
                                        <tr>
                                            <th class="text-center">%</th>
                                            <th class="text-center">Rp</th>
                                            <th class="text-center">Pembayaran</th>
                                            <th class="text-center">Penyerapan</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach($pptk as $data)
                                            <tr>
                                                <td>{{$loop->iteration}}</td>
                                                <td>{{$data->nama}} / {{ $data->nip }} / {{ $data->telpon }}</td>
                                                <td>{{$data->bidang}}</td>
                                                <td>{{$data->nama_perangkat_daerah ?? '-'}}</td>
                                                <td>
                                                    @if ($data->status == 1)
                                                        <button type="button" class="btn btn-success btn-sm"> Aktif </button>
                                                    @else
                                                        <button type="button" class="btn btn-danger btn-sm"> Tidak Aktif </button>
                                                    @endif
                                                </td>
                                                <td class="text-end" data-sort="{{ $data->total_pagu }}">
                                                    Rp{{ number_format($data->total_pagu, 0, ',', '.') }}
                                                </td>
                                                <td class="text-center">
                                                    {{ number_format($data->total_realisasi/($data->total_pagu > 0 ? $data->total_pagu:1),2, ',', '.')}}%
                                                </td>
                                                <td class="text-end">
                                                    Rp{{ number_format($data->realisasi_keuangan, 0, ',', '.') }}
                                                </td>
                                                <td class="text-center">
                                                    {{number_format(($data->realisasi_keuangan/ ($data->total_nilai_kontrak > 0 ? $data->total_nilai_kontrak+$data->total_pagu_tanpa_realisasi:1))*100,2, ',', '.')}}%
                                                    {{-- {{number_format(($data->realisasi_keuangan/ ($data->total_nilai_kontrak > 0 ? $data->total_nilai_kontrak:1))*100,2, ',', '.')}}% --}}
                                                </td>
                                                <td class="text-center">
                                                    {{number_format(($data->realisasi_keuangan/($data->total_pagu > 0 ?$data->total_pagu:1))*100,2, ',', '.')}}%
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>
</div>
@endsection

@push('js')
<script>
    $(document).ready(function() {
        if ($.fn.DataTable.isDataTable('#datatable_number_reset')) {
            $('#datatable_number_reset').DataTable().clear().destroy();
        }
    
        var table = $('#datatable_number_reset').DataTable({
            "order": [],
            "columnDefs": [
                { "orderable": false, "targets": 0 } // disable sort for 'No' column
            ]
        });
    
        table.on('draw.dt', function() {
            var PageInfo = table.page.info(); // get current page info
            table.column(0, { page: 'current' }).nodes().each(function(cell, i) {
                cell.innerHTML = i + 1 + PageInfo.start;
            });
        });
    });
</script>
    
@endpush