@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
@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 Amount Beasiswa</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">
                                        {{-- Back Button --}}
                                        <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</span>
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_{{ $dmenu ?? 'result' }}" width="100%">
                                    <thead class="thead-light" style="background-color: #00b7bd4f;">
                                        <tr>
                                            <th style="width:5%;">No</th>
                                            <th style="width:20%;">Periode</th>
                                            <th style="width:20%;">Department</th>
                                            <th style="width:15%;">Jumlah Pemohon</th>
                                            <th style="width:15%;">Jumlah Pengajuan</th>
                                            <th style="text-align:right; width:20%;">Total Nominal</th>
                                            <th style="width:15%;">Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($table_result as $index => $item)
                                            <tr>
                                                <td style="width:5%;">{{ $loop->iteration }}</td>
                                                <td style="width:20%;">{{ $item->Nama_Periode }}</td>
                                                <td style="width:20%;">{{ $item->Department }}</td>
                                                <td style="text-align:right; width:15%;">{{ $item->Jumlah_Pemohon }}</td>
                                                <td style="text-align:right; width:15%;">{{ $item->Jumlah_Pengajuan }}</td>
                                                <td style="text-align:right; width:20%;">Rp
                                                    {{ number_format($item->Total_Nominal, 0, ',', '.') }}</td>
                                                <td class="action-buttons" style="width:15%;">
                                                    <form action="{{ url($url_menu . '/show') }}" method="GET">
                                                        <input type="hidden" name="id_periode"
                                                            value="{{ $item->id_periode }}">
                                                        <input type="hidden" name="id_department"
                                                            value="{{ $item->id_department }}">
                                                        <button type="submit" class="btn btn-primary mb-0 py-1 px-2 action-btn"
                                                             title="View Data">
                                                        <i class="fas fa-eye"></i></button>
                                                    </form>
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th colspan="3" class="text-end">Total</th>
                                            <th class="text-end" id="tfoot-jumlah-pemohon">0</th>
                                            <th class="text-end" id="tfoot-jumlah-pengajuan">0</th>
                                            <th class="text-end" id="tfoot-total-nominal">Rp 0</th>
                                            <th></th> <!-- Empty cell for Action column -->
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                @if ($table_result->isNotEmpty())
                                @else
                                    <div class="nav-wrapper"><code>Data not found!</code></div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('css')
    <style>
        .text-center {
            text-align: center;
        }

        td.text-center .approval-badge {
            display: inline-block !important;
            width: 100px !important;
            padding: 6px 12px !important;
            font-size: 14px !important;
            color: white !important;
        }

        td.text-center .approval-badge.bg-pending {
            background-color: #ff9800 !important;
        }

        .thead-light th {
            background-color: #00b7bd4f !important;
            text-align: center;
        }

        .table tfoot th {
            font-weight: bold;
            text-align: right;
        }
    </style>
@endpush

@push('js')
    <script>
        $(document).ready(function() {
            let table = $('#list_{{ $dmenu ?? 'result' }}');

            // Debugging: Log the table ID to ensure it's correct
            console.log('Table ID:', table.attr('id'));

            // Initialize DataTable
            if ($.fn.DataTable.isDataTable(table)) {
                // Destroy existing instance to avoid conflicts
                table.DataTable().destroy();
            }

            table = table.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: 'Bfrtip',
                buttons: [{
                        extend: 'excelHtml5',
                        text: '<i class="fas fa-file-excel me-1 text-lg text-success"></i><span class="font-weight-bold"> Excel</span>',
                        exportOptions: {
                            columns: ':visible:not(:last-child)' // Exclude the Action column
                        }
                    },
                    {
                        extend: 'pdfHtml5',
                        text: '<i class="fas fa-file-pdf me-1 text-lg text-danger"></i><span class="font-weight-bold"> PDF</span>',
                        orientation: 'landscape',
                        pageSize: 'A4',
                        exportOptions: {
                            columns: ':visible:not(:last-child)'
                        }
                    },
                    {
                        extend: 'print',
                        text: '<i class="fas fa-print me-1 text-lg text-info"></i><span class="font-weight-bold"> Print</span>',
                        orientation: 'landscape',
                        pageSize: 'A4',
                        exportOptions: {
                            columns: ':visible:not(:last-child)'
                        }
                    }
                ],
                footerCallback: function(row, data, start, end, display) {
                    const api = this.api();

                    // Column indices (based on table structure)
                    const pemohonIdx = 3; // Jumlah Pemohon (4th column)
                    const pengajuanIdx = 4; // Jumlah Pengajuan (5th column)
                    const totalNominalIdx = 5; // Total Nominal (6th column)

                    // Debugging: Log indices
                    console.log('Indices:', {
                        pemohonIdx,
                        pengajuanIdx,
                        totalNominalIdx
                    });

                    // Calculate total for Jumlah Pemohon
                    const totalPemohon = api
                        .column(pemohonIdx, {
                            search: 'applied'
                        })
                        .data()
                        .reduce((sum, val) => {
                            const num = parseInt(val) || 0;
                            console.log('Pemohon value:', val, 'Parsed:', num);
                            return sum + num;
                        }, 0);
                    $(api.column(pemohonIdx).footer()).html(totalPemohon.toLocaleString('id-ID'));

                    // Calculate total for Jumlah Pengajuan
                    const totalPengajuan = api
                        .column(pengajuanIdx, {
                            search: 'applied'
                        })
                        .data()
                        .reduce((sum, val) => {
                            const num = parseInt(val) || 0;
                            console.log('Pengajuan value:', val, 'Parsed:', num);
                            return sum + num;
                        }, 0);
                    $(api.column(pengajuanIdx).footer()).html(totalPengajuan.toLocaleString('id-ID'));

                    // Calculate total for Total Nominal
                    const totalNominal = api
                        .column(totalNominalIdx, {
                            search: 'applied'
                        })
                        .data()
                        .reduce((sum, val) => {
                            // Remove 'Rp', spaces, dots, and other non-numeric chars
                            const cleaned = String(val).replace(/[^0-9]/g, '');
                            const num = parseInt(cleaned) || 0;
                            console.log('Nominal value:', val, 'Parsed:', num);
                            return sum + num;
                        }, 0);
                    $(api.column(totalNominalIdx).footer()).html('Rp ' + totalNominal.toLocaleString(
                        'id-ID'));
                }
            });

            // Style DataTable buttons
            $('.dt-button').addClass('btn btn-secondary').removeClass('dt-button');

            // Check authorization for buttons
            @if ($authorize->excel == '0')
                table.buttons('.buttons-excel').remove();
            @endif
            @if ($authorize->pdf == '0')
                table.buttons('.buttons-pdf').remove();
            @endif
            @if ($authorize->print == '0')
                table.buttons('.buttons-print').remove();
            @endif

            // Debugging: Log buttons after initialization
            console.log('Buttons initialized:', table.buttons().nodes().length);

            // Delete confirmation function
            window.deleteData = function(event, name, msg) {
                event.preventDefault();
                Swal.fire({
                    title: 'Konfirmasi',
                    text: `Apakah Anda Yakin ${msg} Data ${name} ini?`,
                    icon: 'warning',
                    showCancelButton: true,
                    confirmButtonText: `Ya, ${msg}`,
                    cancelButtonText: 'Batal',
                    confirmButtonColor: '#028284'
                }).then((result) => {
                    if (result.isConfirmed) {
                        event.target.closest('form').submit();
                    }
                });
            };
        });
    </script>
@endpush