@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="mb-0">Result {{ $title_menu }}</h5>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                <div class="nav-wrapper row">
                                    <div class="col">
                                        {{-- button back --}}
                                        <button class="btn btn-secondary mb-0" onclick="history.back()"><i
                                                class="fas fa-circle-left me-1"> </i><span
                                                class="font-weight-bold">Kembali</button>
                                    </div>
                                    <div class="col-md-3 md-auto justify-content-end row">
                                        <div class="row mb-3">
                                            <div class="col-12">
                                                <label for="filterKategori" class="form-label mb-1">
                                                    Filter Kategori
                                                </label>

                                                <select id="filterKategori" class="form-select form-select-sm">
                                                    <option value="" data-value="">
                                                        Semua Kategori
                                                    </option>

                                                    @foreach ($kategori_list as $item)
                                                        <option value="{{ trim($item->name) }}"
                                                            data-value="{{ $item->value }}"
                                                            {{ (string) ($filter['kategori'] ?? '') === (string) $item->value ? 'selected' : '' }}>
                                                            {{ $item->name }}
                                                        </option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                {{-- TOTAL TAGIHAN DISPLAY --}}
                                <div class="mb-3 p-2"
                                    style="background-color: #f8f9fa; border-left: 4px solid #00b7bd; border-radius: 4px;">
                                    <small class="text-muted" style="display: block; margin-bottom: 2px;">Total
                                        Tagihan</small>
                                    <span id="totalTagihan" class="text-dark fw-bold" style="font-size: 1.1rem;">Rp.
                                        {{ $table_result && count($table_result) > 0 ? number_format($table_result->sum('total_bill'), 0, ',', '.') : '0' }}</span>
                                </div>

                                {{-- FORM HIDDEN --}}
                                <form id="filterForm" style="display:none">
                                    @foreach ($filter as $key => $value)
                                        <input type="hidden" name="{{ $key }}" value="{{ $value }}">
                                    @endforeach
                                </form>

                                <table class="table table-bordered table-striped display" id="list_{{ $dmenu }}">
                                    @if ($table_result && count($table_result) > 0)
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th>No</th>
                                                <th class="text-center">Status SPV</th>
                                                <th class="text-center">Status Head HRD</th>
                                                <th>No Kartu Halo</th>
                                                <th>Kategori</th>
                                                <th>NIK</th>
                                                <th>Nama Karyawan</th>
                                                <th>Departemen</th>
                                                <th class="text-end">Abodemen (Rp.)</th>
                                                <th class="text-end">Lain-lain (Rp.)</th>
                                                <th class="text-end">PPN 11% (Rp.)</th>
                                                <th class="text-end">Total Tagihan (Rp.)</th>
                                                <th>Created At</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($table_result as $detail)
                                                <tr
                                                    {{ @$detail->isactive == '0' || @$detail->ISACTIVE == '0' ? 'class=not style=background-color:#ffe9ed;' : '' }}>
                                                    <td>{{ $loop->iteration }}</td>
                                                    <td class="text-center">
                                                        @if ($detail->approve_spv == 'approved')
                                                            <span class="badge bg-success" style="font-size: 11px;"><i
                                                                    class="fas fa-check-circle me-1"></i>Approved</span>
                                                        @elseif($detail->approve_spv == 'rejected')
                                                            <span class="badge bg-danger" style="font-size: 11px;"><i
                                                                    class="fas fa-times-circle me-1"></i>Ditolak</span>
                                                        @else
                                                            <span class="badge bg-warning text-white"
                                                                style="font-size: 11px;"><i
                                                                    class="fas fa-clock me-1"></i>Pending</span>
                                                        @endif
                                                    </td>
                                                    <td class="text-center">
                                                        @if ($detail->approve_head_hrd == 'approved')
                                                            <span class="badge bg-success" style="font-size: 11px;"><i
                                                                    class="fas fa-check-circle me-1"></i>Approved</span>
                                                        @elseif($detail->approve_head_hrd == 'rejected')
                                                            <span class="badge bg-danger" style="font-size: 11px;"><i
                                                                    class="fas fa-times-circle me-1"></i>Ditolak</span>
                                                        @else
                                                            <span class="badge bg-warning text-white"
                                                                style="font-size: 11px;"><i
                                                                    class="fas fa-clock me-1"></i>Pending</span>
                                                        @endif
                                                    </td>
                                                    <td>{{ $detail->phone_number }}</td>
                                                    <td data-search="{{ trim($detail->kategori_kartu) }}"
                                                        data-filter="{{ trim($detail->kategori_kartu) }}"
                                                        data-order="{{ $detail->kategori_value }}">
                                                        @if ((string) $detail->kategori_value === '1')
                                                            <span class="badge bg-primary">
                                                                User
                                                            </span>
                                                        @elseif ((string) $detail->kategori_value === '2')
                                                            <span class="badge bg-info text-dark">
                                                                Operasional
                                                            </span>
                                                        @else
                                                            <span class="badge bg-secondary">
                                                                {{ $detail->kategori_kartu }}
                                                            </span>
                                                        @endif
                                                    </td>
                                                    <td>{{ $detail->nik }}</td>
                                                    <td>{{ $detail->employee_name }}</td>
                                                    <td>{{ $detail->department_name }}</td>
                                                    <td class="text-end">
                                                        {{ number_format($detail->abodemen, 0, ',', '.') }}</td>
                                                    <td class="text-end">
                                                        {{ number_format($detail->other_bill, 0, ',', '.') }}</td>
                                                    <td class="text-end">{{ number_format($detail->tax, 0, ',', '.') }}
                                                    </td>
                                                    <td class="text-end fw-bold">
                                                        {{ number_format($detail->total_bill, 0, ',', '.') }}</td>
                                                    <td>{{ $detail->created_at }}</td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    @endif
                                </table>
                            </div>
                        </div>

                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                @if ($table_result)
                                    <div class="nav-wrapper" id="noted"><code>Note : <i aria-hidden="true"
                                                style="color: #ffc2cd;" class="fas fa-circle"></i> Data not active</code>
                                    </div>
                                @else
                                    <div class="nav-wrapper"><code> Data not found!</code></div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    {{-- check flag js on dmenu --}}
    @if ($jsmenu == '1')
        @if (view()->exists("js.{$dmenu}"))
            @push('addjs')
                {{-- file js in folder (resources/views/js) --}}
                @include('js.' . $dmenu);
            @endpush
        @else
            @push('addjs')
                <script>
                    Swal.fire({
                        title: 'JS Not Found!!',
                        text: 'Please Create File JS',
                        icon: 'error',
                        confirmButtonColor: '#028284'
                    });
                </script>
            @endpush
        @endif
    @endif
@endsection
@push('js')
    <script>
        let columnAbjad = '';

        function formatRupiah(value) {
            let number = parseInt(value, 10) || 0;
            return 'Rp. ' + number.toString().replace(/\B(?=(\d{3})+(?!\d))/g, '.');
        }

        // Function untuk menghitung total berdasarkan data yang terlihat di tabel
        function updateTotalDisplay() {
            let total = 0;
            let table = $('#list_{{ $dmenu }}').DataTable();

            // Ambil semua row yang terlihat (visible rows)
            table.rows({
                search: 'applied'
            }).data().each(function(row) {
                // Column index 8 adalah Total Tagihan (0-indexed)
                let totalCell = row[11];
                if (totalCell) {
                    // Remove "Rp. " dan parsing ke number
                    let amount = parseInt(totalCell.replace(/[^\d]/g, '')) || 0;
                    total += amount;
                }
            });

            // Update display dengan format Rupiah
            let formattedTotal = formatRupiah(total);

            $('#totalTagihan').text(formattedTotal);
        }

        $(document).ready(function() {
            const tableId = 'list_{{ $dmenu }}';
            const tableSelector = '#' + tableId;
            const table = $(tableSelector).DataTable();

            let indexStatus = 0;
            let selectedCategoryName = '';

            /*
            |--------------------------------------------------------------------------
            | Cari index kolom filter bawaan
            |--------------------------------------------------------------------------
            */
            const numColumns = table.columns().count();
            const filterAlias = '{{ @$table_class->alias }}'
                .trim()
                .toLowerCase();

            for (let index = 0; index < numColumns; index++) {
                const header = table
                    .column(index)
                    .header();

                if (!header) {
                    continue;
                }

                const columnName = header.textContent
                    .trim();

                const lowerColumnName = columnName
                    .toLowerCase();

                if (lowerColumnName === 'status') {
                    columnAbjad = String.fromCharCode(
                        65 + index
                    );
                }

                if (
                    filterAlias !== '' &&
                    lowerColumnName === filterAlias
                ) {
                    indexStatus = index;
                }
            }

            /*
            |--------------------------------------------------------------------------
            | Filter bawaan dari table_class
            |--------------------------------------------------------------------------
            */
            const defaultFilterSelector =
                '#{{ @$table_class->field }}';

            if (
                defaultFilterSelector !== '#' &&
                $(defaultFilterSelector).length
            ) {
                $(defaultFilterSelector)
                    .off('change.defaultTableFilter')
                    .on(
                        'change.defaultTableFilter',
                        function() {
                            table
                                .column(indexStatus)
                                .search($(this).val())
                                .draw();
                        }
                    );
            }

            /*
            |--------------------------------------------------------------------------
            | Hapus filter kategori lama
            |--------------------------------------------------------------------------
            |
            | Diperlukan agar filter tidak didaftarkan berkali-kali.
            |
            */
            if (window.reportCategoryFilter) {
                const oldFilterIndex =
                    $.fn.dataTable.ext.search.indexOf(
                        window.reportCategoryFilter
                    );

                if (oldFilterIndex !== -1) {
                    $.fn.dataTable.ext.search.splice(
                        oldFilterIndex,
                        1
                    );
                }
            }

            /*
            |--------------------------------------------------------------------------
            | Custom filter kategori
            |--------------------------------------------------------------------------
            |
            | data[4] adalah kolom Kategori.
            | HTML badge akan diubah menjadi teks bersih.
            |
            */
            window.reportCategoryFilter = function(
                settings,
                rowData,
                dataIndex
            ) {
                /*
                 * Jangan memengaruhi DataTable lain.
                 */
                if (settings.nTable.id !== tableId) {
                    return true;
                }

                /*
                 * Semua kategori.
                 */
                if (selectedCategoryName === '') {
                    return true;
                }

                /*
                 * Ambil teks bersih dari badge HTML.
                 */
                const rowCategory = $('<div>')
                    .html(rowData[4] ?? '')
                    .text()
                    .replace(/\s+/g, ' ')
                    .trim()
                    .toLowerCase();

                return rowCategory === selectedCategoryName;
            };

            $.fn.dataTable.ext.search.push(
                window.reportCategoryFilter
            );

            /*
            |--------------------------------------------------------------------------
            | Hidden input untuk export
            |--------------------------------------------------------------------------
            */
            function updateHiddenCategory(value) {
                let $kategoriInput = $(
                    '#filterForm input[name="kategori"]'
                );

                if ($kategoriInput.length === 0) {
                    $('#filterForm').append(
                        '<input type="hidden" ' +
                        'name="kategori" value="">'
                    );

                    $kategoriInput = $(
                        '#filterForm input[name="kategori"]'
                    );
                }

                $kategoriInput.val(value);
            }

            /*
            |--------------------------------------------------------------------------
            | Terapkan filter kategori
            |--------------------------------------------------------------------------
            */
            function applyCategoryFilter() {
                const $select = $('#filterKategori');
                const $selectedOption =
                    $select.find('option:selected');

                /*
                 * Berdasarkan Blade kamu:
                 *
                 * value      = User / Operasional
                 * data-value = 1 / 2
                 */
                const selectedName = String(
                        $select.val() || ''
                    )
                    .replace(/\s+/g, ' ')
                    .trim()
                    .toLowerCase();

                const selectedValue = String(
                    $selectedOption.data('value') ?? ''
                ).trim();

                selectedCategoryName = selectedName;

                /*
                 * Export menggunakan kode 1 atau 2.
                 */
                updateHiddenCategory(
                    selectedValue
                );

                /*
                 * Menjalankan custom filter.
                 */
                table.draw();
            }

            /*
            |--------------------------------------------------------------------------
            | Event dropdown kategori
            |--------------------------------------------------------------------------
            */
            $('#filterKategori')
                .off('change.categoryFilter')
                .on(
                    'change.categoryFilter',
                    function() {
                        applyCategoryFilter();
                    }
                );

            /*
            |--------------------------------------------------------------------------
            | Catatan tabel
            |--------------------------------------------------------------------------
            */
            const hasExpired = $('.exp').length > 0;
            const hasStock = $('.stock').length > 0;

            if (hasExpired && hasStock) {
                $('#noted').html(`
            <code>
                Note :
                (
                    <i
                        aria-hidden="true"
                        style="color:#ffc2cd;"
                        class="fas fa-circle"
                    ></i>
                    Data not active
                ),
                (
                    <i
                        aria-hidden="true"
                        style="color:#ffe768;"
                        class="fas fa-circle"
                    ></i>
                    Data Expired
                ),
                (
                    <i
                        aria-hidden="true"
                        style="color:#f93c3c;"
                        class="fas fa-circle"
                    ></i>
                    Stock &lt; Min Stock
                )
            </code>
        `);
            } else if (hasExpired) {
                $('#noted').html(`
            <code>
                Note :
                (
                    <i
                        aria-hidden="true"
                        style="color:#ffc2cd;"
                        class="fas fa-circle"
                    ></i>
                    Data not active
                ),
                (
                    <i
                        aria-hidden="true"
                        style="color:#ffe768;"
                        class="fas fa-circle"
                    ></i>
                    Data Expired
                )
            </code>
        `);
            } else if (hasStock) {
                $('#noted').html(`
            <code>
                Note :
                (
                    <i
                        aria-hidden="true"
                        style="color:#ffc2cd;"
                        class="fas fa-circle"
                    ></i>
                    Data not active
                ),
                (
                    <i
                        aria-hidden="true"
                        style="color:#f93c3c;"
                        class="fas fa-circle"
                    ></i>
                    Stock &lt; Min Stock
                )
            </code>
        `);
            }

            /*
            |--------------------------------------------------------------------------
            | Update total setiap tabel berubah
            |--------------------------------------------------------------------------
            */
            table.off('draw.categoryTotal');

            table.on(
                'draw.categoryTotal',
                function() {
                    updateTotalDisplay();
                }
            );

            /*
            |--------------------------------------------------------------------------
            | Terapkan filter awal
            |--------------------------------------------------------------------------
            |
            | Berguna ketika nilai kategori sudah selected dari controller.
            |
            */
            applyCategoryFilter();
            updateTotalDisplay();
        });

        $('#list_{{ $dmenu }}').DataTable({
            "language": {
                "search": "Cari :",
                "lengthMenu": "Tampilkan _MENU_ baris",
                "zeroRecords": "Maaf - Data tidak ada",
                "info": "Data _START_ - _END_ dari _TOTAL_",
                "infoEmpty": "Tidak ada data",
                "infoFiltered": "(pencarian dari _MAX_ data)"
            },
            responsive: true,
            dom: '<"row"<"col-sm-8"B><"col-sm-4"<"float-end"f>>>rtip',
            buttons: [{
                    text: '<i class="fas fa-file-excel me-1 text-lg text-success"></i><span class="font-weight-bold"> Excel</span>',
                    action: function(e, dt, node, config) {
                        let params = $('#filterForm').serialize();
                        let url = "{{ route('exportTagihanExcel') }}";
                        if (params) {
                            url += "?" + params;
                        }
                        window.open(url, '_blank');
                    }
                },
                {
                    text: '<i class="fas fa-print me-1 text-lg text-info"></i><span class="font-weight-bold"> Print PDF</span>',
                    action: function(e, dt, node, config) {
                        let params = $('#filterForm').serialize();
                        let printUrl = "{{ route('exportTagihanPDF') }}?mode=print";

                        if (params) {
                            printUrl += "&" + params;
                        }

                        $.ajax({
                            url: "{{ route('checkApprovalTagihan') }}",
                            type: "GET",
                            data: $('#filterForm').serialize(),
                            beforeSend: function() {
                                Swal.fire({
                                    title: 'Memeriksa approval...',
                                    text: 'Mohon tunggu sebentar',
                                    allowOutsideClick: false,
                                    didOpen: () => {
                                        Swal.showLoading();
                                    }
                                });
                            },
                            success: function(res) {
                                Swal.close();

                                if (!res.success) {
                                    Swal.fire({
                                        icon: 'error',
                                        title: 'Gagal',
                                        text: 'Gagal memeriksa status approval.'
                                    });
                                    return;
                                }

                                if (res.total_data <= 0) {
                                    Swal.fire({
                                        icon: 'warning',
                                        title: 'Data Kosong',
                                        text: 'Tidak ada data tagihan yang bisa dicetak.'
                                    });
                                    return;
                                }

                                // Kalau semua sudah approved, langsung print
                                if (res.is_all_approved) {
                                    window.open(printUrl, "_blank");
                                    return;
                                }

                                // Kalau masih ada pending/reject/null, munculkan konfirmasi
                                Swal.fire({
                                    icon: 'warning',
                                    title: 'Tagihan Belum Full Approved',
                                    html: `
                                        <div class="text-start">
                                            <p class="mb-2">
                                                Masih ada tagihan yang belum mendapatkan approval lengkap dari
                                                <b>SPV</b> dan <b>Head HRD</b>.
                                            </p>

                                            <table class="table table-sm table-bordered mt-2 mb-2">
                                                <tr>
                                                    <th>Total Data</th>
                                                    <td>${res.total_data}</td>
                                                </tr>
                                                <tr>
                                                    <th>Sudah Approved</th>
                                                    <td>${res.total_approved}</td>
                                                </tr>
                                                <tr>
                                                    <th>Pending / Belum Approval</th>
                                                    <td class="text-warning fw-bold">${res.total_pending}</td>
                                                </tr>
                                                <tr>
                                                    <th>Rejected</th>
                                                    <td class="text-danger fw-bold">${res.total_rejected}</td>
                                                </tr>
                                            </table>

                                            <p class="mb-0 text-danger">
                                                Dokumen ini akan digunakan sebagai dasar pemberian data tagihan ke Finance.
                                                Tetap lanjutkan cetak PDF?
                                            </p>
                                        </div>
                                    `,
                                    showCancelButton: true,
                                    confirmButtonText: 'Tetap Cetak PDF',
                                    cancelButtonText: 'Batal',
                                    confirmButtonColor: '#028284',
                                    cancelButtonColor: '#6c757d',
                                    reverseButtons: true
                                }).then((result) => {
                                    if (result.isConfirmed) {
                                        window.open(printUrl, "_blank");
                                    }
                                });
                            },
                            error: function() {
                                Swal.close();

                                Swal.fire({
                                    icon: 'error',
                                    title: 'Error',
                                    text: 'Terjadi kesalahan saat memeriksa status approval.'
                                });
                            }
                        });
                    }
                }
            ]

        });

        // Styling & authorization
        $('.dt-button').addClass('btn btn-secondary').removeClass('dt-button');
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjtagihantlp/resources/views/report/rptbil/result.blade.php</b> on line <b>694</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjtagihantlp/resources/views/report/rptbil/result.blade.php</b> on line <b>694</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjtagihantlp/resources/views/report/rptbil/result.blade.php</b> on line <b>695</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjtagihantlp/resources/views/report/rptbil/result.blade.php</b> on line <b>695</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjtagihantlp/resources/views/report/rptbil/result.blade.php</b> on line <b>696</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjtagihantlp/resources/views/report/rptbil/result.blade.php</b> on line <b>696</b><br />

        // Update total saat search, filter, atau pagination
        $('#list_{{ $dmenu }}').on('draw.dt', function() {
            updateTotalDisplay();
        });
    </script>
@endpush