@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">Detail Amount Beasiswa : <strong style="color: #008384;">{{ $beasiswa->department }}</strong></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%;">Nama Karyawan</th>
                                            <th style="text-align:right; width:20%;">Total Pengajuan</th>
                                            <th style="text-align:right;width:15%;">Negeri (Org)</th>
                                            <th style="text-align:right; width:15%;">Total Nominal Negeri</th>
                                            <th style="text-align:right; width:15%;">Swasta (Org)</th>
                                            <th style="text-align:right; width:15%;">Total Nominal Swasta</th>
                                            <th style="text-align:right; width:20%;">Total Nominal</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->nama_karyawan }}</td>
                                                <td style="text-align:right; width:15%;">{{ $item->Jumlah_Pengajuan }}</td>
                                                <td style="text-align:right; width:15%;">{{ $item->Jumlah_negeri }}</td>
                                                <td style="text-align:right; width:15%;">Rp 
                                                    {{ number_format($item->nominal_negeri, 0, ',', '.') }}</td>
                                                <td style="text-align:right; width:15%;">{{ $item->Jumlah_swasta }}</td>
                                                <td style="text-align:right; width:15%;">Rp 
                                                    {{ number_format($item->nominal_swasta, 0, ',', '.') }}</td>
                                                <td style="text-align:right; width:20%;">Rp
                                                    {{ number_format($item->Total_Nominal, 0, ',', '.') }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th colspan="3" class="text-end">Total</th>
                                            <th class="text-end" id="tfoot-jumlah-negeri">0</th>
                                            <th class="text-end" id="tfoot-nominal-negeri">Rp 0</th>
                                            <th class="text-end" id="tfoot-jumlah-swasta">0</th>
                                            <th class="text-end" id="tfoot-nominal-swasta">Rp 0</th>
                                            <th class="text-end" id="tfoot-jumlah-pengajuan">0</th>
                                            <th class="text-end" id="tfoot-total-nominal">Rp 0</th>
                                        </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)) {
                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' // Include all visible columns
                        }
                    },
                    {
                        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'
                        }
                    },
                    {
                        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'
                        }
                    }
                ],
                footerCallback: function(row, data, start, end, display) {
                    const api = this.api();

                    // Column indices based on table structure
                    const jumlahNegeriIdx = 4; // Negeri (Org)
                    const nominalNegeriIdx = 5; // Nominal Negeri
                    const jumlahSwastaIdx = 6; // Swasta (Org)
                    const nominalSwastaIdx = 7; // Nominal Swasta
                    const jumlahPengajuanIdx = 3; // Total Pengajuan
                    const totalNominalIdx = 8; // Total Nominal

                    // Debugging: Log indices
                    console.log('Indices:', {
                        jumlahNegeriIdx,
                        nominalNegeriIdx,
                        jumlahSwastaIdx,
                        nominalSwastaIdx,
                        jumlahPengajuanIdx,
                        totalNominalIdx
                    });

                    // Helper function to parse Rupiah values
                    const parseRupiah = (val) => {
                        const cleaned = String(val).replace(/[^0-9]/g, '');
                        return parseInt(cleaned) || 0;
                    };

                    // Calculate total for Jumlah Negeri
                    const totalJumlahNegeri = api
                        .column(jumlahNegeriIdx, {
                            search: 'applied'
                        })
                        .data()
                        .reduce((sum, val) => sum + (parseInt(val) || 0), 0);
                    $(api.column(jumlahNegeriIdx).footer()).html(totalJumlahNegeri.toLocaleString(
                        'id-ID'));

                    // Calculate total for Nominal Negeri
                    const totalNominalNegeri = api
                        .column(nominalNegeriIdx, {
                            search: 'applied'
                        })
                        .data()
                        .reduce((sum, val) => sum + parseRupiah(val), 0);
                    $(api.column(nominalNegeriIdx).footer()).html('Rp ' + totalNominalNegeri.toLocaleString(
                        'id-ID'));

                    // Calculate total for Jumlah Swasta
                    const totalJumlahSwasta = api
                        .column(jumlahSwastaIdx, {
                            search: 'applied'
                        })
                        .data()
                        .reduce((sum, val) => sum + (parseInt(val) || 0), 0);
                    $(api.column(jumlahSwastaIdx).footer()).html(totalJumlahSwasta.toLocaleString(
                        'id-ID'));

                    // Calculate total for Nominal Swasta
                    const totalNominalSwasta = api
                        .column(nominalSwastaIdx, {
                            search: 'applied'
                        })
                        .data()
                        .reduce((sum, val) => sum + parseRupiah(val), 0);
                    $(api.column(nominalSwastaIdx).footer()).html('Rp ' + totalNominalSwasta.toLocaleString(
                        'id-ID'));

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

                    // Calculate total for Total Nominal
                    const totalNominal = api
                        .column(totalNominalIdx, {
                            search: 'applied'
                        })
                        .data()
                        .reduce((sum, val) => sum + parseRupiah(val), 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 (if needed)
            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