@extends('layout.dashboard.index')

@section('content')
@php
use Carbon\Carbon;
@endphp
    <div class="container-fluid">
        <div class="card">
            <div class="card-header border-0 pt-6">
                <div class="card-title">
                    <h2>Rekapitulasi Anggaran</h2>
                </div>
                <div class="card-toolbar">
                    <div class="d-flex gap-4 justify-content-end" data-kt-user-table-toolbar="base">
                        <div class="d-flex align-items-center position-relative">
                            <span class="svg-icon svg-icon-1 position-absolute ms-6">
                                <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"
                                    fill="none">
                                    <rect opacity="0.5" x="17.0365" y="15.1223" width="8.15546" height="2"
                                        rx="1" transform="rotate(45 17.0365 15.1223)" fill="black"></rect>
                                    <path
                                        d="M11 19C6.55556 19 3 15.4444 3 11C3 6.55556 6.55556 3 11 3C15.4444 3 19 6.55556 19 11C19 15.4444 15.4444 19 11 19ZM11 5C7.53333 5 5 7.53333 5 11C5 14.4667 7.53333 17 11 17C14.4667 17 17 14.4667 17 11C17 7.53333 14.4667 5 11 5Z"
                                        fill="black"></path>
                                </svg>
                            </span>
                            <input type="text" id="searchTable"
                                data-kt-user-table-filter="search"class="form-control form-control-solid ps-14"
                                style="width: 400px" placeholder="Cari data departemen" />
                        </div>
                        @if (Auth::user()->role->code !== 'OTH' && Auth::user()->role->code !== 'SLS')
                            <select name="filterDivision" id="filterDivision" class="form-select form-select-solid w-200px">
                                <option value="">Semua Departemen</option>
                            </select>
                        @endif
                        <select name="filterYear" id="filterYear" class="form-select form-select-solid w-150px">
                            <option value="">Pilih Tahun</option>
                            @for ($year = date('Y'); $year >= date('Y') - 2; $year--)
                                <option value="{{ $year }}">{{ $year }}</option>
                            @endfor
                        </select>
                        <select name="filterMonth" id="filterMonth" class="form-select form-select-solid w-150px">
                            <option value="">Pilih Bulan</option>
                            @for ($month = 1; $month <= 12; $month++)
                                <option value="{{ $month }}">
                                    {{-- {{ date('M', mktime(0, 0, 0, $month, 1)) }} --}}
                                    {{ Carbon::create()->month($month)->locale('id')->translatedFormat('M') }}
                                </option>
                            @endfor
                        </select>
                        <button type="button" class="btn btn-success btn-active-success-primary" id="exportBtn">
                            <span class="svg-icon svg-icon-2">
                                <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24"
                                    fill="none">
                                    <rect opacity="0.3" x="12.75" y="4.25" width="12" height="2" rx="1"
                                        transform="rotate(90 12.75 4.25)" fill="black"></rect>
                                    <path
                                        d="M12.0573 6.11875L13.5203 7.87435C13.9121 8.34457 14.6232 8.37683 15.056 7.94401C15.4457 7.5543 15.4641 6.92836 15.0979 6.51643L12.4974 3.59084C12.0996 3.14332 11.4004 3.14332 11.0026 3.59084L8.40206 6.51643C8.0359 6.92836 8.0543 7.5543 8.44401 7.94401C8.87683 8.37683 9.58785 8.34458 9.9797 7.87435L11.4427 6.11875C11.6026 5.92684 11.8974 5.92684 12.0573 6.11875Z"
                                        fill="black"></path>
                                    <path
                                        d="M18.75 8.25H17.75C17.1977 8.25 16.75 8.69772 16.75 9.25C16.75 9.80228 17.1977 10.25 17.75 10.25C18.3023 10.25 18.75 10.6977 18.75 11.25V18.25C18.75 18.8023 18.3023 19.25 17.75 19.25H5.75C5.19772 19.25 4.75 18.8023 4.75 18.25V11.25C4.75 10.6977 5.19771 10.25 5.75 10.25C6.30229 10.25 6.75 9.80228 6.75 9.25C6.75 8.69772 6.30229 8.25 5.75 8.25H4.75C3.64543 8.25 2.75 9.14543 2.75 10.25V19.25C2.75 20.3546 3.64543 21.25 4.75 21.25H18.75C19.8546 21.25 20.75 20.3546 20.75 19.25V10.25C20.75 9.14543 19.8546 8.25 18.75 8.25Z"
                                        fill="#C4C4C4"></path>
                                </svg>
                            </span>Ekspor Data</button>
                    </div>
                </div>
            </div>
            <div class="card-body">
                <div id="kt_table_users_wrapper" class="dataTables_wrapper dt-bootstrap4 no-footer">
                    <div class="table-responsive">
                        <div id="custom-loading"
                            class="position-absolute top-0 start-0 w-100 h-100 
                                d-flex justify-content-center align-items-center"
                            style="background: rgba(255,255,255,0.8); z-index: 10;">

                            <div class="text-center">
                                <div class="spinner-border text-primary" style="width:1rem;height:1rem;"></div>
                                <div class="mt-3 fw-semibold text-gray-700">
                                    Memuat data...
                                </div>
                            </div>
                        </div>
                        <table class="table align-middle table-row-dashed fs-6 gy-5 dataTable no-footer" id="table">
                            <!--begin::Table head-->
                            <thead>
                                <tr class="">
                                    <th>Departemen</th>
                                    <th>Anggaran</th>
                                    <th>Realisasi</th>
                                    <th>Selisih</th>
                                    <th>Non Anggaran</th>
                                </tr>
                            </thead>
                            <tbody class="text-gray-600 fw-bold">

                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <script>
        $(document).ready(function() {
            $.ajaxSetup({
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                }
            });

            // let table = $('#table').DataTable({
            //     processing: false,
            //     serverSide: true,
            //     dom: 'rtip',
            //     scrollX: true,
            //     language: {
            //         processing: `...`
            //     },
            //     ajax: {
            //         url: "{{ route('budget-recap.datatable') }}",
            //         data: function(d) {
            //             d.year = $('#filterYear').val();
            //             d.division = $('#filterDivision').val();
            //         }
            //     },
            //     columns: [],
            //     columnDefs: [{
            //         targets: '_all',
            //         className: 'text-nowrap'
            //     }],
            //     order: [
            //         [1, 'desc']
            //     ],
            //     pageLength: 15,
            // });

            let table = $('#table').DataTable({
                processing: false,
                serverSide: true,
                dom: 'rtip',
                scrollX: true,
                language: {
                    processing: `<div class="d-flex justify-content-center align-items-center">
                                <div class="spinner-border text-primary" style="width:1rem;height:1rem;"></div>
                                <div class="ms-3 fw-semibold text-gray-700">Memuat data...</div>
                            </div>`
                },
                ajax: {
                    url: "{{ route('budget-recap.datatable') }}",
                    data: function(d) {
                        d.year      = $('#filterYear').val();
                        d.month     = $('#filterMonth').val();
                        d.division  = $('#filterDivision').val();
                    },
                    beforeSend: function() {
                        $('#custom-loading').show();
                    },
                    complete: function() {
                        $('#custom-loading').hide();
                    }
                },
                columns: [{
                        data: 'division_name',
                        name: 'division_name',
                        render: function(data) {
                            return '<span class="fw-bold">' + data + '</span>';
                        }
                    },
                    {
                        data: 'total_budget',
                        name: 'total_budget',
                        className: 'text-end',
                        render: function(data, type, row) {
                            return row.total_budget;
                        }
                    },
                    {
                        data: 'total_actual',
                        name: 'total_actual',
                        className: 'text-end',
                        render: function(data, type, row) {
                            return row.total_actual;
                        }
                    },
                    {
                        data: 'difference',
                        name: 'difference',
                        className: 'text-end',
                        render: function(data, type, row) {
                            return row.difference;
                        }
                    },
                    {
                        data: 'total_non_budget',
                        name: 'total_non_budget',
                        className: 'text-end',
                        render: function(data, type, row) {
                            return row.total_non_budget;
                        }
                    }
                ],
                columnDefs: [{
                    targets: '_all',
                    className: 'text-nowrap'
                }],
                order: [
                    [0, 'asc']
                ],
                pageLength: 15,
                initComplete: function() {
                    $('#custom-loading').hide();
                }
            });

            // Filter berdasarkan pencarian
            $('#searchTable').on('keyup', function() {
                table.search(this.value).draw();
            });

            // Filter berdasarkan tahun
            $('#filterYear').on('change', function() {
                table.ajax.reload();
            });
           
            // Filter berdasarkan bulan
            $('#filterMonth').on('change', function() {
                table.ajax.reload();
            });

            // Filter berdasarkan divisi
            $('#filterDivision').on('change', function() {
                table.ajax.reload();
            });

            table.on('processing.dt', function(e, settings, processing) {
                if (processing) {
                    $('#custom-loading').removeClass('d-none');
                } else {
                    $('#custom-loading').addClass('d-none');
                }
            });

            $.ajax({
                url: '/user/division',
                type: 'GET',
                beforeSend: function() {},
                success: function(response) {
                    if (response.success) {
                        let select = $('#filterDivision');
                        select.empty();
                        select.append('<option value="">Semua Departemen</option>');

                        $.each(response.data, function(index, division) {
                            select.append(
                                '<option value="' + division.id + '">' + division.name +
                                '</option>'
                            );
                        });

                        select.trigger('change');
                    }
                },
                error: function() {
                    showToast('Gagal memuat data divisi', 'danger');
                }
            });

            document.getElementById('exportBtn').addEventListener('click', function() {

                let month = $('#filterMonth').val(); // sesuaikan dengan filter kamu
                let year = $('#filterYear').val(); // sesuaikan dengan filter kamu
                let division = $('#filterDivision').val(); // kalau ada

                let url = "{{ route('budget-recap.export') }}?month=" + month +"&year=" + year + "&division=" + division;

                window.location.href = url; // ini trigger download
            });
        });
    </script>
@endsection