@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 {{ $title_menu }}</h5>
                        </div>
                        <hr class="horizontal dark mt-0">

                        {{-- Buttons row --}}
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                <div class="nav-wrapper row">
                                    <div class="col-auto">
                                        {{-- 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</span>
                                        </button>
                                    </div>

                                    @php
                                        $user = DB::table('users')->where('username', session('username'))->first();
                                    @endphp

                                    <div class="col-auto ms-auto d-flex align-items-center">
                                        @if (in_array($user->idroles, ['fnce', 'admins']))
                                            <button class="btn me-2" style="background-color: #8A38F5; color: white"
                                                id="finishAllBtn" onclick="finishAll()">
                                                <i class="fas fa-check me-1"></i>
                                                <span class="font-weight-bold">Finish All</span>
                                            </button>

                                            <button class="btn me-2" style="background-color: #dc3545; color: white"
                                                id="rejectBtn" onclick="rejectData()">
                                                <i class="fas fa-times me-1"></i>
                                                <span class="font-weight-bold">Reject</span>
                                            </button>

                                            <button class="btn me-2" style="background-color: #d63384; color: white"
                                                onclick="openSetEffDateModal()">
                                                <i class="fas fa-calendar me-1"></i>
                                                <span class="font-weight-bold">Set Eff Date</span>
                                            </button>

                                            {{-- Export Dropdown --}}
                                            <div class="btn-group me-2">
                                                <button class="btn btn-success" type="button" title="Export Data"
                                                    style="background-color: #fd7e14; border-color: #2b56ca; color: white;">
                                                    <i class="fas fa-file-excel me-1"></i>
                                                    <span class="font-weight-bold">Export</span>
                                                </button>
                                                <button type="button"
                                                    class="btn btn-success dropdown-toggle dropdown-toggle-split"
                                                    data-bs-toggle="dropdown" aria-expanded="false"
                                                    style="background-color: #fd7e14; border-color: #2b56ca; color: white;">
                                                    <span class="visually-hidden">Toggle Dropdown</span>
                                                </button>
                                                <ul class="dropdown-menu">
                                                    <li><button type="button" class="btn btn-md mx-2 mb-0 w-90"
                                                            style="background-color: #2237bf; color: white;"
                                                            onclick="exportBCA()">
                                                            BCA
                                                        </button></li>
                                                    <li>
                                                        <hr class="dropdown-divider">
                                                    </li>
                                                    <li><button type="button" class="btn btn-md mx-2 mb-0 w-90"
                                                            style="background-color: #da3e1b; color: white;"
                                                            onclick="exportUOBLLG()">
                                                            UOB LLG
                                                        </button></li>
                                                    <li>
                                                    <li>
                                                        <hr class="dropdown-divider">
                                                    </li>
                                                    <li><button type="button" class="btn btn-md mx-2 mb-0 w-90"
                                                            style="background-color: #54da1b; color: white;"
                                                            onclick="exportUOBBIF()">
                                                            UOB BIF
                                                        </button></li>
                                                    <li>
                                                        <hr class="dropdown-divider">
                                                    </li>
                                                    <li><button type="button" class="btn btn-md mx-2 mb-0 w-90"
                                                            style="background-color: #198754; color: white;"
                                                            onclick="exportMandiri()">
                                                            Mandiri
                                                        </button></li>
                                                </ul>
                                            </div>

                                            <button class="btn btn-primary" onclick="generateID()">
                                                <i class="fas fa-redo me-1"></i>
                                                <span class="font-weight-bold">Generate ID</span>
                                            </button>
                                        @endif
                                    </div>

                                </div>
                            </div>
                        </div>

                        {{-- Filter row (jika ada table_class) --}}
                        @if (isset($table_class) && $table_class)
                            <div class="row px-4 py-2">
                                <div class="col-lg">
                                    <div class="nav-wrapper">
                                        <div class="col-lg-3 ms-auto">
                                            {{-- set value filter --}}
                                                                                        @foreach ($filter as $key => $value)
                                                <input type="hidden" name="f{{ $key }}"
                                                    value="{{ $value }}" />
                                                @php
                                                    if (
                                                        preg_replace('/\s+/', '', strtolower(@$table_class->alias)) ==
                                                        preg_replace('/\s+/', '', strtolower($key))
                                                    ) {
                                                        $check_filter = $value == '%' ? '' : $value;
                                                    }
                                                @endphp
                                            @endforeach
                                            {{-- display label alias on class filter --}}
                                            Filter {{ @$table_class->alias }} :
                                            <select class="form-select" id="{{ @$table_class->field }}"
                                                style="width: 150px;">
                                                @if (@$table_class->query != '')
                                                    @if ($check_filter != '')
                                                        @php $data_query = DB::select(@$table_class->query); @endphp
                                                        @foreach ($data_query as $q)
                                                            <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/msjbeasiswa/resources/views/report/rptfba/result.blade.php</b> on line <b>136</b><br />
                                                            @if ($check_filter == $sAsArray[0])
                                                                <option value="{{ $sAsArray[0] }}">{{ $sAsArray[0] }} -
                                                                    {{ $sAsArray[1] }}</option>
                                                            @endif
                                                        @endforeach
                                                    @else
                                                        <option value="" selected>% - All</option>
                                                        @php $data_query = DB::select(@$table_class->query); @endphp
                                                        @foreach ($data_query as $q)
                                                            <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/msjbeasiswa/resources/views/report/rptfba/result.blade.php</b> on line <b>146</b><br />
                                                            <option value="{{ $sAsArray[0] }}">{{ $sAsArray[0] }} -
                                                                {{ $sAsArray[1] }}</option>
                                                        @endforeach
                                                    @endif
                                                @endif
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        @endif

                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_{{ $dmenu }}">
                                    <thead class="thead-light" style="background-color: #00b7bd4f;">
                                        <tr>
                                            <th>
                                                <input type="checkbox" id="checkAll"
                                                    style="transform: scale(1.5); margin: 5px;">
                                            </th>
                                            <th>No</th>
                                            <th>Nama Periode</th>
                                            <th>ID Pengajuan</th>
                                            <th>Nama Ortu Wali</th>
                                            <th>NIK</th>
                                            <th>Department</th>
                                            <th>Nama Anak</th>
                                            <th>Jenjang</th>
                                            <th>Bank Penerima</th>
                                            <th>No Rekening</th>
                                            <th>Nominal</th>
                                            <th>Eff_Date</th>
                                            <th>Status</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if ($table_result && $table_result->isNotEmpty())
                                            @foreach ($table_result as $index => $detail)
                                                <tr
                                                    {{ @$detail->isactive == '0' || @$detail->ISACTIVE == '0' ? 'class=not style=background-color:#ffe9ed;' : (@$detail->{'trs_status'} == 'rejected' ? 'style=background-color:#fff3cd;' : ($detail->Status == '1' ? 'style=background-color:#ebf6f7;' : '')) }}>
                                                    <td>
                                                        <input type="checkbox" class="row-checkbox"
                                                            value="{{ $detail->{'ID Pengajuan'} }}"
                                                            data-nominal="{{ $detail->{'Nominal'} }}"
                                                            style="transform: scale(1.5); margin: 5px;">
                                                    </td>
                                                    <td>{{ $loop->iteration }}</td>
                                                    <td>{{ $detail->{'Nama Periode'} }}</td>
                                                    <td>{{ $detail->{'ID Pengajuan'} }}</td>
                                                    <td>{{ $detail->{'Nama Ortu Wali'} }}</td>
                                                    <td>{{ $detail->{'NIK'} }}</td>
                                                    <td>{{ $detail->{'Department'} }}</td>
                                                    <td>{{ $detail->{'Nama Anak'} }}</td>
                                                    <td>{{ $detail->{'Jenjang'} }}</td>
                                                    <td>{{ $detail->{'Bank Penerima'} }}</td>
                                                    <td>{{ $detail->{'No Rekening'} }}</td>
                                                    <td>Rp {{ number_format($detail->{'Nominal'}, 0, ',', '.') }}</td>
                                                    <td>{{ $detail->{'Eff_Date'} ?? '-' }}</td>
                                                    <td>
                                                        <span class="badge"
                                                            style="background-color: {{ $detail->{'Status'} == '1' ? '#016e70' : '#da3e1b' }}; color: white;">
                                                            {{ $detail->{'Status'} == '1' ? 'SELESAI' : 'BELUM' }}
                                                        </span>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @endif
                                    </tbody>
                                    @if ($table_result && $table_result->isNotEmpty())
                                        <tfoot class="thead-light" style="background-color: #f8f9fa; font-weight: bold;">
                                            <tr>
                                                <th></th>
                                                <th colspan="12" class="text-start">
                                                    <span class="font-weight-bold">Total : </span>
                                                    <span id="total-nominal" class="font-weight-bold">Rp
                                                        {{ number_format($total_nominal ?? 0, 0, ',', '.') }}</span>
                                                </th>
                                                <th></th>
                                            </tr>
                                        </tfoot>
                                    @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: #ebf6f7;" class="fas fa-circle"></i> Data selesai
                                            ditransfer | <i aria-hidden="true"
                                                style="color: #fff3cd;" class="fas fa-circle"></i> Rejected by Finance</code>
                                    </div>
                                @else
                                    <div class="nav-wrapper"><code>Data not found!</code></div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade" id="setEffDateModal" tabindex="-1" role="dialog">
        <div class="modal-dialog modal-dialog-centered" role="document">
            <div class="modal-content">
                <form action="{{ route('rptfba.updateEffDate') }}" method="POST" id="setEffDateForm">
                    @csrf
                    <div class="modal-header">
                        <h5 class="modal-title">SET EFF DATE</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body">
                        <div class="form-group">
                            <label>Eff Date</label>
                            <input type="date" name="eff_date" class="form-control" required>
                        </div>
                        <div class="alert alert-info mt-3">
                            <span class="text-sm"><strong id="selectedCount">0</strong> data dipilih</span>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
                        <button type="submit" class="btn btn-primary">Simpan</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

    @push('js')
    <script>
        function rejectData() {
            let selectedIds = [];
            $('.row-checkbox:checked').each(function() {
                selectedIds.push($(this).val());
            });

            if (selectedIds.length === 0) {
                Swal.fire({
                    icon: 'warning',
                    title: 'Peringatan',
                    text: 'Pilih minimal satu data untuk di-reject!',
                    confirmButtonColor: '#3085d6'
                });
                return;
            }

            Swal.fire({
                icon: 'warning',
                title: 'Konfirmasi Reject',
                text: `Anda yakin ingin me-reject ${selectedIds.length} data terpilih? Silakan masukkan alasan penolakan:`,
                input: 'textarea',
                inputPlaceholder: 'Tulis alasan Anda...',
                inputAttributes: {
                    'aria-label': 'Tulis alasan Anda...'
                },
                showCancelButton: true,
                confirmButtonText: 'Ya, Reject',
                cancelButtonText: 'Batal',
                confirmButtonColor: '#dc3545',
                cancelButtonColor: '#6c757d',
                preConfirm: (notes) => {
                    if (!notes) {
                        Swal.showValidationMessage('Alasan penolakan wajib diisi!')
                    }
                    return notes;
                }
            }).then((result) => {
                if (result.isConfirmed) {
                    $.ajax({
                        url: '{{ url("rptfba/reject-data") }}',
                        type: 'POST',
                        data: {
                            _token: '{{ csrf_token() }}',
                            selected_ids: selectedIds,
                            notes: result.value
                        },
                        success: function(response) {
                            if (response.success) {
                                Swal.fire({
                                    icon: 'success',
                                    title: 'Berhasil',
                                    text: response.message,
                                    confirmButtonColor: '#028284'
                                }).then(() => {
                                    location.reload();
                                });
                            } else {
                                Swal.fire({
                                    icon: 'error',
                                    title: 'Gagal',
                                    text: response.message || 'Terjadi kesalahan saat memproses data.',
                                    confirmButtonColor: '#d33'
                                });
                            }
                        },
                        error: function(xhr) {
                            let errorMessage = 'Terjadi kesalahan sistem.';
                            if (xhr.responseJSON && xhr.responseJSON.message) {
                                errorMessage = xhr.responseJSON.message;
                            }
                            Swal.fire({
                                icon: 'error',
                                title: 'Gagal',
                                html: errorMessage,
                                confirmButtonColor: '#d33'
                            });
                        }
                    });
                }
            });
        }
    </script>
    @endpush

    {{-- check flag js on dmenu --}}
    @if ($jsmenu == '1')
        @if (view()->exists("js.{$dmenu}"))
            @push('addjs')
                @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('css')
    <style>
        .thead-light th {
            background-color: #00b7bd4f !important;
            text-align: center;
        }

        .table tfoot th {
            font-weight: bold;
            text-align: right;
            background-color: #f8f9fa;
        }

        .form-check-input {
            cursor: pointer;
            transform: scale(1.5);
            margin: 5px;
        }

        .btn {
            font-weight: bold;
            height: 38px;
            display: flex;
            align-items: center;
            justify-content: center;
            white-space: nowrap;
        }

        .btn-group>.btn {
            height: 38px;
            display: flex;
            align-items: center;
        }

        .btn+.btn,
        .btn-group+.btn {
            margin-left: 0.5rem;
        }

        .d-flex.align-items-center>* {
            margin-bottom: 0 !important;
        }
    </style>
@endpush

@push('js')
    {{-- <script src="https://cdn.jsdelivr.net/npm/exceljs/dist/exceljs.min.js"></script> --}}
    <script src="./assets/js/plugins/exceljs.min.js"></script>
    <script src="./assets/js/plugins/xlsx.full.min.js"></script>

    {{-- CDN ExcelJS untuk export BCA --}}
    <script>
        let table;
        let columnAbjad = '';
        // let statusColumnIndex = -1;
        let isCheckAllActive = false; //flag untuk track check all di semua halaman
        let totalSelected = 0;
        let totalDefault = 0;
        let nominalIndex = -1;
        let selectedCheckboxes = {};

        $(document).ready(function() {
            totalSelected = {{ $total_nominal ?? 0 }}; // Initial dari controller
            totalDefault = {{ $total_nominal ?? 0 }};

            table = $('#list_{{ $dmenu }}').DataTable();
            let indexStatus = 0;
            let numColumns = table.columns().count();
            let columnNames = '';
            let filter = '{{ @$table_class->alias ?? '' }}'.toLowerCase();
            for (let index = 0; index < numColumns; index++) {
                columnNames = table.columns(index).header()[0].textContent;
                let filtercolom = columnNames.toLowerCase();
                if (columnNames == 'Status' || columnNames == 'status' || columnNames == 'STATUS') {
                    statusColumnIndex = index;
                    columnAbjad = String.fromCharCode(65 + index);
                }
                if (filtercolom == filter) {
                    indexStatus = index;
                }
                if (columnNames.toLowerCase().includes('nominal')) {
                    nominalIndex = index;
                }
            }
            // redraw table where filter
            $('#{{ @$table_class->field ?? '' }}').change(function() {
                table.column(indexStatus).search($(this).val()).draw();
            });

            // check note
            if ($('*').hasClass('exp')) {
                $('#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>`
                );
            }
            if ($('*').hasClass('stock')) {
                $('#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 < Min Stock )</code>`
                );
            }
            if ($('*').hasClass('exp') && $('*').hasClass('stock')) {
                $('#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 < Min Stock )</code>`
                );
            }

            //Tambah SweetAlert buat pesan session dari controller (success/error setelah update), kasih feedback user tanpa flash halaman
            @if (session('swal_success'))
                Swal.fire({
                    icon: 'success',
                    title: 'Berhasil',
                    text: '{{ session('swal_success') }}',
                    confirmButtonColor: '#028284'
                });
            @endif
            @if (session('swal_error'))
                Swal.fire({
                    icon: 'error',
                    title: 'Gagal',
                    text: '{{ session('swal_error') }}',
                    confirmButtonColor: '#028284'
                });
            @endif

            updateTotal();
        });

        function updateTotal() {
            totalSelected = 0;

            if (isCheckAllActive) {
                // Check All: Hitung SEMUA data dari column Nominal
                if (nominalIndex >= 0) {
                    // const allData = table.rows().data(); // rows() tanpa filter
                    // for (let i = 0; i < allData.length; i++) {
                    //     const val = allData[i][nominalIndex]; // Ambil nilai Nominal
                    //     let cleanVal = (val || '').toString()
                    //         .replace(/Rp\s*/i, '')
                    //         .replace(/\./g, '')
                    //         .replace(',', '.')
                    //         .replace(/[^0-9.-]+/g, '');
                    //     totalSelected += parseFloat(cleanVal) || 0;
                    // }

                    Object.values(selectedCheckboxes).forEach(nominal => {
                        totalSelected += nominal;
                    });
                }

                // } else if (Object.keys(selectedCheckboxes).length > 0) {
                //     Object.values(selectedCheckboxes).forEach(nominal => {
                //         totalSelected += nominal;
                //     });
            } else {
                totalSelected = totalDefault;
            }



            $('#total-nominal').text('Rp ' + totalSelected.toLocaleString('id-ID'));
        }

        // FULL INIT DI LUAR READY()
        $('#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: false,
            dom: 'Bfrtip',
            buttons: [
                // Excel Button
                {
                    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) {

                        const stripHTML = (input) => {
                            if (input == null) return '';
                            return String(input).replace(/<[^>]+>/g, '').trim();
                        };

                        let selectedIds = Object.keys(selectedCheckboxes);
                        if (selectedIds.length === 0) {
                            Swal.fire({
                                icon: 'warning',
                                title: 'Perhatian',
                                text: 'Pilih minimal 1 data dulu!',
                                confirmButtonColor: '#028284'
                            });
                            return;
                        }

                        const allRows = dt.rows({
                            search: 'applied'
                        }).data().toArray();

                        const rowsToExport = allRows
                            .filter(row => selectedIds.includes(stripHTML(row[3])) && stripHTML(row[13]) !== 'SELESAI')
                            .map(row => ({
                                id: stripHTML(row[3]),
                                nama_ortu: stripHTML(row[4]),
                                nama_anak: stripHTML(row[7]),
                                jenjang: stripHTML(row[8]),
                                departemen : stripHTML(row[6]),
                                bank: stripHTML(row[9]),
                                norek: stripHTML(row[10]),
                                nominal: stripHTML(row[11]),
                                eff_date: stripHTML(row[12]),
                                periode: stripHTML(row[2])
                            }))
                            .sort((a, b) => a.nama_anak.localeCompare(b.nama_anak));

                        const parseAmount = (raw) => Number(String(raw || '0').replace(/[^\d]/g, '')) || 0;
                        const total = rowsToExport.reduce((sum, r) => sum + parseAmount(r.nominal), 0);
                        const periode = rowsToExport[0]?.periode || 'Periode Beasiswa';

                        // Approval data (sama seperti PDF)
                        const approvalData = [{
                                status: 'Approved',
                                name: `{!! $hrd->count() ? $hrd->map(fn($i) => $i->firstname . ' ' . $i->lastname)->join(' & ') : 'N/A' !!}`,
                                role: 'HRD',
                                date: `{!! $timestamp->latest_hrd ?? 'N/A' !!}`
                            },
                            {
                                status: 'Approved',
                                name: `{!! data_get($headhrd, '0.firstname') . ' ' . data_get($headhrd, '0.lastname', 'N/A') !!}`,
                                role: 'Head HRD',
                                date: `{!! $timestamp->latest_headhrd ?? 'N/A' !!}`
                            },
                            {
                                status: 'Approved',
                                name: `{!! data_get($sp, '0.firstname') . ' ' . data_get($sp, '0.lastname', 'N/A') !!}`,
                                role: 'SP',
                                date: `{!! $timestamp->latest_sp ?? 'N/A' !!}`
                            },
                            {
                                status: 'Finished',
                                name: `{!! data_get($finance, '0.firstname') . ' ' . data_get($finance, '0.lastname', 'N/A') !!}`,
                                role: 'Finance',
                                date: `{!! $timestamp->latest_finance ?? 'N/A' !!}`
                            }
                        ];

                        // BUAT EXCEL
                        const wb = XLSX.utils.book_new();
                        const data = [];

                        // Header perusahaan (merge full)
                        data.push(['PT. MULTI SPUNINDO JAYA Tbk']);
                        data.push(['REPORT DATA TRANSFER PENGAJUAN BEASISWA']);
                        data.push([periode]);
                        data.push([]); // spacer

                        data.push(['INFORMASI LAPORAN']);
                        data.push(['Debited and Charges Acc',
                            ': 7880583885 (PT. Multi Spunindo Jaya Tbk)'
                        ]);
                        data.push(['Remark', `: ${periode}`]);
                        data.push(['Currency', ': IDR']);
                        data.push([]); // spacer

                        // BARIS TOTAL — INI YANG DIPERBAIKI!
                        data.push(['TOTAL:', 'Rp ' + total.toLocaleString(
                            'id-ID')]); // <<-- TOTAL DI KOLOM B
                        data.push([]); // spacer
                        data.push([]); // spacer

                        // Header tabel detail
                        data.push(['No', 'Transaction ID', 'Employee Name', 'Receiver Name',
                            'Receiver Bank Name', 'Credited Acc.', 'Amount (Rp)', 'Eff. Date',
                            'Keterangan'
                        ]);

                        // Isi data
                        rowsToExport.forEach((r, i) => {
                            data.push([
                                i + 1,
                                r.id,
                                r.nama_ortu,
                                r.nama_anak,
                                r.bank,
                                r.norek,
                                parseAmount(r.nominal),
                                r.eff_date,
                                `Scholarship ${r.nama_anak} (${r.nama_ortu} ${r.departemen} ${r.periode})`
                            ]);
                        });

                        data.push([]);
                        data.push(['APPROVAL DETAILS']);
                        data.push(['Status', 'Name', 'Role', 'Date']);
                        approvalData.forEach(a => data.push([a.status, a.name, a.role, a.date]));

                        const ws = XLSX.utils.aoa_to_sheet(data);

                        // MERGE YANG BENAR (total di baris 10, kolom A & B)
                        ws['!merges'] = [{
                                s: {
                                    r: 0,
                                    c: 0
                                },
                                e: {
                                    r: 0,
                                    c: 8
                                }
                            }, // PT. MULTI...
                            {
                                s: {
                                    r: 1,
                                    c: 0
                                },
                                e: {
                                    r: 1,
                                    c: 8
                                }
                            }, // Judul report
                            {
                                s: {
                                    r: 2,
                                    c: 0
                                },
                                e: {
                                    r: 2,
                                    c: 8
                                }
                            }, // Periode
                            {
                                s: {
                                    r: 9,
                                    c: 0
                                },
                                e: {
                                    r: 9,
                                    c: 0
                                }
                            } // TOTAL: (hanya kolom A)
                            // Kolom B (total amount) tidak di-merge, biar bisa di-style
                        ];

                        // STYLING TOTAL (bold + warna toska)
                        if (ws['A10']) {
                            ws['A10'].s = {
                                font: {
                                    bold: true,
                                    sz: 14,
                                    color: {
                                        rgb: "FF028284"
                                    }
                                }
                            };
                        }
                        if (ws['B10']) {
                            ws['B10'].s = {
                                font: {
                                    bold: true,
                                    sz: 14,
                                    color: {
                                        rgb: "FF028284"
                                    }
                                },
                                alignment: {
                                    horizontal: "right"
                                }
                            };
                        }

                        // Header tabel warna toska
                        'ABCDEFGHI'.split('').forEach((col, idx) => {
                            const cellAddr = col + '13';
                            if (ws[cellAddr]) {
                                ws[cellAddr].s = {
                                    fill: {
                                        fgColor: {
                                            rgb: "FF028284"
                                        }
                                    },
                                    font: {
                                        bold: true,
                                        color: {
                                            rgb: "FFFFFFFF"
                                        }
                                    },
                                    alignment: {
                                        horizontal: "center"
                                    }
                                };
                            }
                        });

                        // Format kolom Amount
                        rowsToExport.forEach((_, i) => {
                            const cell = ws['G' + (14 + i)];
                            if (cell) cell.z = '#,##0';
                        });

                        // Lebar kolom
                        ws['!cols'] = [{
                                wch: 6
                            }, {
                                wch: 20
                            }, {
                                wch: 28
                            }, {
                                wch: 28
                            }, {
                                wch: 22
                            },
                            {
                                wch: 20
                            }, {
                                wch: 20
                            }, {
                                wch: 16
                            }, {
                                wch: 65
                            }
                        ];

                        XLSX.utils.book_append_sheet(wb, ws, "Report Beasiswa");
                        XLSX.writeFile(wb, `Report_Beasiswa_${new Date().toISOString().slice(0,10)}.xlsx`);

                        Swal.fire('Success', `Export ${rowsToExport.length} data berhasil!`,
                            'success');
                    }
                },
                // PDF Button
                {
                    text: '<i class="fas fa-file-pdf me-1 text-lg text-danger"></i><span class="font-weight-bold"> PDF</span>',
                    action: function(e, dt, node, config) {
                        // Strip HTML function
                        const stripHTML = (input) => {
                            if (input == null) return '';
                            return String(input).replace(/<[^>]+>/g, '').trim();
                        };

                        // Get selected data
                        let selectedIds = Object.keys(selectedCheckboxes);
                        if (selectedIds.length === 0) {
                            Swal.fire({
                                icon: 'warning',
                                title: 'Perhatian',
                                text: 'Pilih minimal 1 data dengan checkbox terlebih dahulu',
                                confirmButtonColor: '#028284'
                            });
                            return;
                        }

                        const allRows = dt.rows({
                            search: 'applied'
                        }).data().toArray();

                        const rowsToExport = allRows
                            .filter(row => selectedIds.includes(stripHTML(row[3])) && stripHTML(row[13]) !== 'SELESAI')
                            .map(row => ({
                                id: stripHTML(row[3]) || 'N/A',
                                nama_ortu: stripHTML(row[4]) || 'N/A',
                                nama_anak: stripHTML(row[7]) || 'N/A',
                                bank: stripHTML(row[9]) || 'N/A',
                                norek: stripHTML(row[10]) || 'N/A',
                                nominal: stripHTML(row[11]) || '0',
                                eff_date: stripHTML(row[12]) || 'N/A',
                                periode: stripHTML(row[2]) || 'N/A'
                             }))
                            .sort((a, b) => a.nama_anak.localeCompare(b.nama_anak));

                        const parseAmount = (raw) => {
                            const amountStr = String(raw || '0')
                                .replace(/Rp\s?/i, '')
                                .replace(/\./g, '')
                                .replace(/,/g, '')
                                .replace(/ -$/g, '')
                                .trim();
                            return Number(amountStr) || 0;
                        };

                        const total = rowsToExport.reduce((sum, row) => sum + parseAmount(row.nominal), 0);

                        const formatDate = (rawDate) => {
                            if (rawDate && rawDate.trim() !== '' && rawDate.trim() !== '-' && rawDate
                                .trim() !== ' - ' && rawDate !== 'N/A') {
                                if (rawDate.includes('/')) {
                                    const parts = rawDate.split('/');
                                    if (parts.length === 3) {
                                        const day = parts[0].padStart(2, '0');
                                        const month = parseInt(parts[1], 10) - 1;
                                        const year = parts[2].split(' ')[0];
                                        const date = new Date(year, month, day);
                                        if (!isNaN(date.getTime())) {
                                            return date.toLocaleDateString('id-ID', {
                                                day: 'numeric',
                                                month: 'long',
                                                year: 'numeric'
                                            });
                                        }
                                    }
                                } else {
                                    const date = new Date(rawDate);
                                    if (!isNaN(date.getTime())) {
                                        return date.toLocaleDateString('id-ID', {
                                            day: 'numeric',
                                            month: 'long',
                                            year: 'numeric'
                                        });
                                    }
                                }
                            }
                            const now = new Date();
                            return now.toLocaleDateString('id-ID', {
                                day: 'numeric',
                                month: 'long',
                                year: 'numeric'
                            });
                        };

                        const periode_date = rowsToExport[0]?.periode || 'Periode Beasiswa';
                        const remark1 = periode_date;

                        // Prepare approval data from controller-passed variables
                        const hrdData = {!! json_encode(
                            $hrd->map(function ($item) {
                                    return [
                                        'name' => $item->firstname . ' ' . $item->lastname,
                                        'role' => $item->role_name,
                                    ];
                                })->toArray(),
                        ) !!};
                        const headHrdData = {!! json_encode(
                            $headhrd->map(function ($item) {
                                    return [
                                        'name' => $item->firstname . ' ' . $item->lastname,
                                        'role' => $item->role_name,
                                    ];
                                })->toArray(),
                        ) !!};
                        const spData = {!! json_encode(
                            $sp->map(function ($item) {
                                    return [
                                        'name' => $item->firstname . ' ' . $item->lastname,
                                        'role' => $item->role_name,
                                    ];
                                })->toArray(),
                        ) !!};
                        const financeData = {!! json_encode(
                            $finance->map(function ($item) {
                                    return [
                                        'name' => $item->firstname . ' ' . $item->lastname,
                                        'role' => $item->role_name,
                                    ];
                                })->toArray(),
                        ) !!};
                        const timestamps = {!! json_encode($timestamp) !!};

                        const approvalData = [{
                                status: 'Approved',
                                name: hrdData.length > 0 ? hrdData.map(item => item.name).join(' & ') :
                                    'N/A',
                                role: hrdData.length > 0 ? hrdData[0].role : 'HRD',
                                date: timestamps.latest_hrd ? formatDate(timestamps.latest_hrd) : 'N/A'
                            },
                            {
                                status: 'Approved',
                                name: headHrdData.length > 0 ? headHrdData[0].name : 'N/A',
                                role: headHrdData.length > 0 ? headHrdData[0].role : 'Head HRD',
                                date: timestamps.latest_headhrd ? formatDate(timestamps
                                    .latest_headhrd) : 'N/A'
                            },
                            {
                                status: 'Approved',
                                name: spData.length > 0 ? spData[0].name : 'N/A',
                                role: spData.length > 0 ? spData[0].role : 'SP',
                                date: timestamps.latest_sp ? formatDate(timestamps.latest_sp) : 'N/A'
                            },
                            {
                                status: 'Finished',
                                name: financeData.length > 0 ? financeData[0].name : 'N/A',
                                role: financeData.length > 0 ? financeData[0].role : 'Finance',
                                date: timestamps.latest_finance ? formatDate(timestamps
                                    .latest_finance) : 'N/A'
                            }
                        ];

                        // Preload logo
                        const logoUrl = '{{ asset('img/logo_complete.png') }}';
                        const img = new Image();
                        img.crossOrigin = 'Anonymous';
                        img.src = logoUrl;

                        img.onload = function() {
                            const canvas = document.createElement('canvas');
                            canvas.width = img.width;
                            canvas.height = img.height;
                            const ctx = canvas.getContext('2d');
                            ctx.drawImage(img, 0, 0);
                            const base64Logo = canvas.toDataURL('image/png');

                            const docDefinition = {
                                pageSize: 'A4',
                                pageOrientation: 'landscape',
                                pageMargins: [20, 20, 20, 20],
                                content: [{
                                        columns: [{
                                                image: 'logo',
                                                width: 100
                                            },
                                            {
                                                stack: [{
                                                        text: 'PT. MULTI SPUNINDO JAYA Tbk',
                                                        bold: true,
                                                        fontSize: 14,
                                                        alignment: 'right'
                                                    },
                                                    {
                                                        text: 'REPORT DATA TRANSFER PENGAJUAN BEASISWA',
                                                        bold: true,
                                                        fontSize: 12,
                                                        alignment: 'right'
                                                    },
                                                    {
                                                        text: periode_date,
                                                        fontSize: 10,
                                                        alignment: 'right',
                                                        italics: true
                                                    }
                                                ],
                                                width: '*'
                                            }
                                        ],
                                        margin: [0, 0, 0, 15]
                                    },
                                    {
                                        canvas: [{
                                            type: 'line',
                                            x1: 0,
                                            y1: 0,
                                            x2: 800,
                                            y2: 0,
                                            lineWidth: 1.5,
                                            lineColor: '#028284'
                                        }]
                                    },
                                    {
                                        stack: [{
                                                text: 'INFORMASI LAPORAN',
                                                fontSize: 14,
                                                bold: true,
                                                margin: [0, 15, 0, 10]
                                            },
                                            {
                                                table: {
                                                    widths: [200, '*'],
                                                    body: [
                                                        [{
                                                            text: 'Debited and Charges Acc',
                                                            bold: true
                                                        }, {
                                                            text: ': 7880583885 (PT. Multi Spunindo Jaya Tbk)'
                                                        }],
                                                        [{
                                                            text: 'Remark',
                                                            bold: true
                                                        }, {
                                                            text: `: ${remark1}`
                                                        }],
                                                        [{
                                                            text: 'Currency',
                                                            bold: true
                                                        }, {
                                                            text: ': IDR'
                                                        }]
                                                    ]
                                                },
                                                layout: 'noBorders',
                                                fontSize: 12,
                                                margin: [0, 0, 0, 15]
                                            }
                                        ]
                                    },
                                    {
                                        columns: [{
                                                text: 'DETAIL DATA TRANSFER',
                                                style: 'subheader'
                                            },
                                            {
                                                text: `TOTAL: Rp ${total.toLocaleString('id-ID')}`,
                                                style: 'total'
                                            }
                                        ]
                                    },
                                    {
                                        canvas: [{
                                            type: 'line',
                                            x1: 0,
                                            y1: 0,
                                            x2: 800,
                                            y2: 0,
                                            lineWidth: 1,
                                            lineColor: '#000000'
                                        }],
                                        margin: [0, 10, 0, 15]
                                    },
                                    {
                                        table: {
                                            headerRows: 1,
                                            widths: [25, 'auto', '*', 'auto', 'auto', 100,
                                                'auto', 'auto'
                                            ],
                                            body: [
                                                [{
                                                        text: 'No',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Transaction ID',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Employee Name',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Receiver Name',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Receiver Bank Name',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Credited Acc.',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Amount (Rp)',
                                                        style: 'tableHeader',
                                                        alignment: 'right'
                                                    },
                                                    {
                                                        text: 'Eff. Date',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    }
                                                ],
                                                ...rowsToExport.map((row, index) => [{
                                                        text: index + 1,
                                                        alignment: 'center'
                                                    },
                                                    row.id,
                                                    row.nama_ortu,
                                                    row.nama_anak,
                                                    row.bank,
                                                    {
                                                        text: row.norek,
                                                        alignment: 'right'
                                                    },
                                                    {
                                                        text: parseAmount(row.nominal)
                                                            .toLocaleString('id-ID'),
                                                        alignment: 'right'
                                                    },
                                                    formatDate(row.eff_date)
                                                ])
                                            ]
                                        },
                                        layout: {
                                            hLineWidth: function(i, node) {
                                                return 1;
                                            },
                                            vLineWidth: function(i, node) {
                                                return 1;
                                            },
                                            hLineColor: function(i, node) {
                                                return '#000000';
                                            },
                                            vLineColor: function(i, node) {
                                                return '#000000';
                                            },
                                            fillColor: function(rowIndex, node, columnIndex) {
                                                return rowIndex === 0 ? '#000000' : null;
                                            },
                                            fontSize: 11,
                                            color: function(rowIndex, node, columnIndex) {
                                                return rowIndex === 0 ? '#ffffff' :
                                                    '#000000';
                                            }
                                        }
                                    },
                                    {
                                        text: 'APPROVAL DETAILS',
                                        style: 'subheader',
                                        margin: [0, 40, 0, 10]
                                    },
                                    {
                                        canvas: [{
                                            type: 'line',
                                            x1: 0,
                                            y1: 0,
                                            x2: 800,
                                            y2: 0,
                                            lineWidth: 1,
                                            lineColor: '#000000'
                                        }],
                                        margin: [0, 0, 0, 10]
                                    },
                                    {
                                        table: {
                                            headerRows: 1,
                                            widths: ['auto', '*', '*', '*'],
                                            body: [
                                                [{
                                                        text: 'Status',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Name',
                                                        style: 'tableHeader',
                                                        alignment: 'left'
                                                    },
                                                    {
                                                        text: 'Role',
                                                        style: 'tableHeader',
                                                        alignment: 'left'
                                                    },
                                                    {
                                                        text: 'Date',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    }
                                                ],
                                                ...approvalData.map(row => [{
                                                        text: row.status || 'N/A',
                                                        style: row.status ===
                                                            'Approved' ?
                                                            'badgeApproved' : row
                                                            .status === 'Finished' ?
                                                            'badgeFinished' :
                                                            'badgeDefault',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: row.name || 'N/A',
                                                        alignment: 'left'
                                                    },
                                                    {
                                                        text: row.role || 'N/A',
                                                        alignment: 'left'
                                                    },
                                                    {
                                                        text: row.date || 'N/A',
                                                        alignment: 'center'
                                                    }
                                                ])
                                            ]
                                        },
                                        layout: {
                                            hLineWidth: function(i, node) {
                                                return 1;
                                            },
                                            vLineWidth: function(i, node) {
                                                return 1;
                                            },
                                            hLineColor: function(i, node) {
                                                return '#000000';
                                            },
                                            vLineColor: function(i, node) {
                                                return '#000000';
                                            },
                                            fillColor: function(rowIndex, node, columnIndex) {
                                                return rowIndex === 0 ? '#000000' : null;
                                            },
                                            fontSize: 11,
                                            color: function(rowIndex, node, columnIndex) {
                                                return rowIndex === 0 ? '#ffffff' :
                                                    '#000000';
                                            }
                                        }
                                    }
                                ],
                                styles: {
                                    subheader: {
                                        fontSize: 14,
                                        bold: true,
                                        color: '#028284'
                                    },
                                    total: {
                                        fontSize: 14,
                                        bold: true,
                                        alignment: 'right',
                                        color: '#028284'
                                    },
                                    tableHeader: {
                                        bold: true,
                                        fontSize: 12,
                                        color: '#000000',
                                        fillColor: '#ebf6f7'
                                    },
                                    badgeApproved: {
                                        fontSize: 10,
                                        color: '#ffffff',
                                        fillColor: '#28a745', // Green for Approved
                                        margin: [5, 2, 5, 2],
                                        padding: [5, 2, 5, 2]
                                    },
                                    badgeFinished: {
                                        fontSize: 10,
                                        color: '#ffffff',
                                        fillColor: '#007bff', // Blue for Finished
                                        margin: [5, 2, 5, 2],
                                        padding: [5, 2, 5, 2]
                                    },
                                    badgeDefault: {
                                        fontSize: 10,
                                        color: '#ffffff',
                                        fillColor: '#6c757d', // Gray for N/A or unexpected status
                                        margin: [5, 2, 5, 2],
                                        padding: [5, 2, 5, 2]
                                    }
                                },
                                images: {
                                    logo: base64Logo
                                }
                            };

                            pdfMake.createPdf(docDefinition).download('Report_Beasiswa.pdf');

                            Swal.fire({
                                icon: 'success',
                                title: 'Berhasil',
                                text: `Berhasil export ${rowsToExport.length} data ke PDF`,
                                confirmButtonColor: '#028284'
                            }).then((result) => {
                                if (result.isConfirmed) {
                                    location.reload();
                                }
                            });
                        };

                        img.onerror = function() {
                            Swal.fire({
                                icon: 'error',
                                title: 'Gagal',
                                text: 'Gagal memuat logo. Gunakan base64 untuk logo_small.png.',
                                confirmButtonColor: '#028284'
                            });
                        };
                    }
                },
                {
                    extend: 'print',
                    text: '<i class="fas fa-print me-1 text-lg text-info"></i><span class="font-weight-bold"> Print</span>',
                    action: function(e, dt, node, config) {
                        // Strip HTML function
                        const stripHTML = (input) => {
                            if (input == null) return '';
                            return String(input).replace(/<[^>]+>/g, '').trim();
                        };

                        // Get selected data
                        let selectedIds = Object.keys(selectedCheckboxes);
                        if (selectedIds.length === 0) {
                            Swal.fire({
                                icon: 'warning',
                                title: 'Perhatian',
                                text: 'Pilih minimal 1 data dengan checkbox terlebih dahulu',
                                confirmButtonColor: '#028284'
                            });
                            return;
                        }

                        const allRows = dt.rows({
                            search: 'applied'
                        }).data().toArray();
                        const rowsToExport = allRows
                            .filter(row => selectedIds.includes(stripHTML(row[3])) && stripHTML(row[13]) !== 'SELESAI')
                            .map(row => ({
                                id: stripHTML(row[3]) || 'N/A',
                                nama_ortu: stripHTML(row[4]) || 'N/A',
                                nama_anak: stripHTML(row[7]) || 'N/A',
                                bank: stripHTML(row[9]) || 'N/A',
                                norek: stripHTML(row[10]) || 'N/A',
                                nominal: stripHTML(row[11]) || '0',
                                eff_date: stripHTML(row[12]) || 'N/A',
                                periode: stripHTML(row[2]) || 'N/A'
                            }))
                            .sort((a, b) => a.nama_anak.localeCompare(b.nama_anak));

                        const parseAmount = (raw) => {
                            const amountStr = String(raw || '0')
                                .replace(/Rp\s?/i, '')
                                .replace(/\./g, '')
                                .replace(/,/g, '')
                                .replace(/ -$/g, '')
                                .trim();
                            return Number(amountStr) || 0;
                        };
                        const total = rowsToExport.reduce((sum, row) => sum + parseAmount(row.nominal), 0);

                        const formatDate = (rawDate) => {
                            if (rawDate && rawDate.trim() !== '' && rawDate.trim() !== '-' && rawDate
                                .trim() !== ' - ' && rawDate !== 'N/A') {
                                if (rawDate.includes('/')) {
                                    const parts = rawDate.split('/');
                                    if (parts.length === 3) {
                                        const day = parts[0].padStart(2, '0');
                                        const month = parseInt(parts[1], 10) - 1;
                                        const year = parts[2].split(' ')[0];
                                        const date = new Date(year, month, day);
                                        if (!isNaN(date.getTime())) {
                                            return date.toLocaleDateString('id-ID', {
                                                day: 'numeric',
                                                month: 'long',
                                                year: 'numeric'
                                            });
                                        }
                                    }
                                } else {
                                    const date = new Date(rawDate);
                                    if (!isNaN(date.getTime())) {
                                        return date.toLocaleDateString('id-ID', {
                                            day: 'numeric',
                                            month: 'long',
                                            year: 'numeric'
                                        });
                                    }
                                }
                            }
                            const now = new Date();
                            return now.toLocaleDateString('id-ID', {
                                day: 'numeric',
                                month: 'long',
                                year: 'numeric'
                            });
                        };

                        const periode_date = rowsToExport[0]?.periode || 'Periode Beasiswa';
                        const remark1 = periode_date;

                        // Prepare approval data from controller-passed variables
                        const hrdData = {!! json_encode(
                            $hrd->map(function ($item) {
                                    return [
                                        'name' => $item->firstname . ' ' . $item->lastname,
                                        'role' => $item->role_name,
                                    ];
                                })->toArray(),
                        ) !!};
                        const headHrdData = {!! json_encode(
                            $headhrd->map(function ($item) {
                                    return [
                                        'name' => $item->firstname . ' ' . $item->lastname,
                                        'role' => $item->role_name,
                                    ];
                                })->toArray(),
                        ) !!};
                        const spData = {!! json_encode(
                            $sp->map(function ($item) {
                                    return [
                                        'name' => $item->firstname . ' ' . $item->lastname,
                                        'role' => $item->role_name,
                                    ];
                                })->toArray(),
                        ) !!};
                        const financeData = {!! json_encode(
                            $finance->map(function ($item) {
                                    return [
                                        'name' => $item->firstname . ' ' . $item->lastname,
                                        'role' => $item->role_name,
                                    ];
                                })->toArray(),
                        ) !!};
                        const timestamps = {!! json_encode($timestamp) !!};

                        const approvalData = [{
                                status: 'Approved',
                                name: hrdData.length > 0 ? hrdData.map(item => item.name).join(' & ') :
                                    'N/A',
                                role: hrdData.length > 0 ? hrdData[0].role : 'HRD',
                                date: timestamps.latest_hrd ? formatDate(timestamps.latest_hrd) : 'N/A'
                            },
                            {
                                status: 'Approved',
                                name: headHrdData.length > 0 ? headHrdData[0].name : 'N/A',
                                role: headHrdData.length > 0 ? headHrdData[0].role : 'Head HRD',
                                date: timestamps.latest_headhrd ? formatDate(timestamps
                                    .latest_headhrd) : 'N/A'
                            },
                            {
                                status: 'Approved',
                                name: spData.length > 0 ? spData[0].name : 'N/A',
                                role: spData.length > 0 ? spData[0].role : 'SP',
                                date: timestamps.latest_sp ? formatDate(timestamps.latest_sp) : 'N/A'
                            },
                            {
                                status: 'Finished',
                                name: financeData.length > 0 ? financeData[0].name : 'N/A',
                                role: financeData.length > 0 ? financeData[0].role : 'Finance',
                                date: timestamps.latest_finance ? formatDate(timestamps
                                    .latest_finance) : 'N/A'
                            }
                        ];

                        // Preload logo
                        const logoUrl = '{{ asset('img/logo_complete.png') }}';
                        const img = new Image();
                        img.crossOrigin = 'Anonymous';
                        img.src = logoUrl;

                        img.onload = function() {
                            const canvas = document.createElement('canvas');
                            canvas.width = img.width;
                            canvas.height = img.height;
                            const ctx = canvas.getContext('2d');
                            ctx.drawImage(img, 0, 0);
                            const base64Logo = canvas.toDataURL('image/png');

                            const docDefinition = {
                                pageSize: 'A4',
                                pageOrientation: 'landscape',
                                pageMargins: [20, 20, 20, 20],
                                content: [{
                                        columns: [{
                                                image: 'logo',
                                                width: 100
                                            },
                                            {
                                                stack: [{
                                                        text: 'PT. MULTI SPUNINDO JAYA Tbk',
                                                        bold: true,
                                                        fontSize: 14,
                                                        alignment: 'right'
                                                    },
                                                    {
                                                        text: 'REPORT DATA TRANSFER PENGAJUAN BEASISWA',
                                                        bold: true,
                                                        fontSize: 12,
                                                        alignment: 'right'
                                                    },
                                                    {
                                                        text: periode_date,
                                                        fontSize: 10,
                                                        alignment: 'right',
                                                        italics: true
                                                    }
                                                ],
                                                width: '*'
                                            }
                                        ],
                                        margin: [0, 0, 0, 15]
                                    },
                                    {
                                        canvas: [{
                                            type: 'line',
                                            x1: 0,
                                            y1: 0,
                                            x2: 800,
                                            y2: 0,
                                            lineWidth: 1.5,
                                            lineColor: '#028284'
                                        }]
                                    },
                                    {
                                        stack: [{
                                                text: 'INFORMASI LAPORAN',
                                                fontSize: 14,
                                                bold: true,
                                                margin: [0, 15, 0, 10]
                                            },
                                            {
                                                table: {
                                                    widths: [200, '*'],
                                                    body: [
                                                        [{
                                                            text: 'Debited and Charges Acc',
                                                            bold: true
                                                        }, {
                                                            text: ': 7880583885 (PT. Multi Spunindo Jaya Tbk)'
                                                        }],
                                                        [{
                                                            text: 'Remark',
                                                            bold: true
                                                        }, {
                                                            text: `: ${remark1}`
                                                        }],
                                                        [{
                                                            text: 'Currency',
                                                            bold: true
                                                        }, {
                                                            text: ': IDR'
                                                        }]
                                                    ]
                                                },
                                                layout: 'noBorders',
                                                fontSize: 12,
                                                margin: [0, 0, 0, 15]
                                            }
                                        ]
                                    },
                                    {
                                        columns: [{
                                                text: 'DETAIL DATA TRANSFER',
                                                style: 'subheader'
                                            },
                                            {
                                                text: `TOTAL: Rp ${total.toLocaleString('id-ID')}`,
                                                style: 'total'
                                            }
                                        ]
                                    },
                                    {
                                        canvas: [{
                                            type: 'line',
                                            x1: 0,
                                            y1: 0,
                                            x2: 800,
                                            y2: 0,
                                            lineWidth: 1,
                                            lineColor: '#000000'
                                        }],
                                        margin: [0, 10, 0, 15]
                                    },
                                    {
                                        table: {
                                            headerRows: 1,
                                            widths: [25, 'auto', '*', 'auto', 'auto', 100, '*',
                                                100
                                            ],
                                            body: [
                                                [{
                                                        text: 'No',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Transaction ID',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Employee Name',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Receiver Name',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Receiver Bank Name',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Credited Acc.',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Amount (Rp)',
                                                        style: 'tableHeader',
                                                        alignment: 'right'
                                                    },
                                                    {
                                                        text: 'Eff. Date',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    }
                                                ],
                                                ...rowsToExport.map((row, index) => [{
                                                        text: index + 1,
                                                        alignment: 'center'
                                                    },
                                                    row.id,
                                                    row.nama_ortu,
                                                    row.nama_anak,
                                                    row.bank,
                                                    {
                                                        text: row.norek,
                                                        alignment: 'right'
                                                    },
                                                    {
                                                        text: parseAmount(row.nominal)
                                                            .toLocaleString('id-ID'),
                                                        alignment: 'right'
                                                    },
                                                    formatDate(row.eff_date)
                                                ])
                                            ]
                                        },
                                        layout: {
                                            hLineWidth: function(i, node) {
                                                return 1;
                                            },
                                            vLineWidth: function(i, node) {
                                                return 1;
                                            },
                                            hLineColor: function(i, node) {
                                                return '#000000';
                                            },
                                            vLineColor: function(i, node) {
                                                return '#000000';
                                            },
                                            fillColor: function(rowIndex, node, columnIndex) {
                                                return rowIndex === 0 ? '#000000' : null;
                                            },
                                            fontSize: 11,
                                            color: function(rowIndex, node, columnIndex) {
                                                return rowIndex === 0 ? '#ffffff' :
                                                    '#000000';
                                            }
                                        }
                                    },
                                    {
                                        text: 'APPROVAL DETAILS',
                                        style: 'subheader',
                                        margin: [0, 40, 0, 10]
                                    },
                                    {
                                        canvas: [{
                                            type: 'line',
                                            x1: 0,
                                            y1: 0,
                                            x2: 800,
                                            y2: 0,
                                            lineWidth: 1,
                                            lineColor: '#000000'
                                        }],
                                        margin: [0, 0, 0, 10]
                                    },
                                    {
                                        table: {
                                            headerRows: 1,
                                            widths: ['auto', '*', '*', '*'],
                                            body: [
                                                [{
                                                        text: 'Status',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: 'Name',
                                                        style: 'tableHeader',
                                                        alignment: 'left'
                                                    },
                                                    {
                                                        text: 'Role',
                                                        style: 'tableHeader',
                                                        alignment: 'left'
                                                    },
                                                    {
                                                        text: 'Date',
                                                        style: 'tableHeader',
                                                        alignment: 'center'
                                                    }
                                                ],
                                                ...approvalData.map(row => [{
                                                        text: row.status || 'N/A',
                                                        style: row.status ===
                                                            'Approved' ?
                                                            'badgeApproved' : row
                                                            .status === 'Finished' ?
                                                            'badgeFinished' :
                                                            'badgeDefault',
                                                        alignment: 'center'
                                                    },
                                                    {
                                                        text: row.name || 'N/A',
                                                        alignment: 'left'
                                                    },
                                                    {
                                                        text: row.role || 'N/A',
                                                        alignment: 'left'
                                                    },
                                                    {
                                                        text: row.date || 'N/A',
                                                        alignment: 'center'
                                                    }
                                                ])
                                            ]
                                        },
                                        layout: {
                                            hLineWidth: function(i, node) {
                                                return 1;
                                            },
                                            vLineWidth: function(i, node) {
                                                return 1;
                                            },
                                            hLineColor: function(i, node) {
                                                return '#000000';
                                            },
                                            vLineColor: function(i, node) {
                                                return '#000000';
                                            },
                                            fillColor: function(rowIndex, node, columnIndex) {
                                                return rowIndex === 0 ? '#000000' : null;
                                            },
                                            fontSize: 11,
                                            color: function(rowIndex, node, columnIndex) {
                                                return rowIndex === 0 ? '#ffffff' :
                                                    '#000000';
                                            }
                                        }
                                    }
                                ],
                                styles: {
                                    subheader: {
                                        fontSize: 14,
                                        bold: true,
                                        color: '#028284'
                                    },
                                    total: {
                                        fontSize: 14,
                                        bold: true,
                                        alignment: 'right',
                                        color: '#028284'
                                    },
                                    tableHeader: {
                                        bold: true,
                                        fontSize: 12,
                                        color: '#000000',
                                        fillColor: '#ebf6f7'
                                    },
                                    badgeApproved: {
                                        fontSize: 10,
                                        color: '#ffffff',
                                        fillColor: '#28a745', // Green for Approved
                                        margin: [5, 2, 5, 2],
                                        padding: [5, 2, 5, 2]
                                    },
                                    badgeFinished: {
                                        fontSize: 10,
                                        color: '#ffffff',
                                        fillColor: '#007bff', // Blue for Finished
                                        margin: [5, 2, 5, 2],
                                        padding: [5, 2, 5, 2]
                                    },
                                    badgeDefault: {
                                        fontSize: 10,
                                        color: '#ffffff',
                                        fillColor: '#6c757d', // Gray for N/A or unexpected status
                                        margin: [5, 2, 5, 2],
                                        padding: [5, 2, 5, 2]
                                    }
                                },
                                images: {
                                    logo: base64Logo
                                }
                            };

                            pdfMake.createPdf(docDefinition).print();

                            Swal.fire({
                                icon: 'success',
                                title: 'Berhasil',
                                text: `Berhasil export ${rowsToExport.length} data ke PDF`,
                                confirmButtonColor: '#028284'
                            }).then((result) => {
                                if (result.isConfirmed) {
                                    location.reload();
                                }
                            });
                        };

                        img.onerror = function() {
                            Swal.fire({
                                icon: 'error',
                                title: 'Gagal',
                                text: 'Gagal memuat logo. Gunakan base64 untuk logo_small.png.',
                                confirmButtonColor: '#028284'
                            });
                        };
                    },
                    orientation: 'landscape',
                    pageSize: 'A4',
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    }
                },
            ],

            columnDefs: [{
                    targets: 0,
                    orderable: false
                }, // Kolom 0 (checkbox) gak bisa sort
                {
                    targets: 1, // Kolom 1 (No) dynamic numbering
                    orderable: false,
                    render: function(data, type, row, meta) {
                        if (type === 'display') {
                            return meta.row + meta.settings._iDisplayStart + 1; // Urut 1,2,3... auto
                        }
                        return data;
                    }
                }
            ],
            order: [
                [1, 'asc']
            ]
        });

        //set color button datatables
        $('.dt-button').addClass('btn btn-secondary');
        $('.dt-button').removeClass('dt-button');
        //check authorize button datatables - COMMENT UNTUK TEST
                        
        // ============ CHECKBOX EVENTS  ============

        $(document).on('change', '#checkAll', function() {
            isCheckAllActive = this.checked;

            if (this.checked) {

                selectedCheckboxes = {};

                const allData = table.rows().data();
                for (let i = 0; i < allData.length; i++) {
                    const id = allData[i][3]; // Index 3 = ID_Pengajuan
                    const nominalRaw = allData[i][nominalIndex]; // Ambil Nominal
                    let cleanVal = (nominalRaw || '').toString()
                        .replace(/Rp\s*/i, '')
                        .replace(/\./g, '')
                        .replace(',', '.')
                        .replace(/[^0-9.-]+/g, '');
                    const nominal = parseFloat(cleanVal) || 0;
                    selectedCheckboxes[id] = nominal;
                }
                $('.row-checkbox').prop('checked', true);
            } else {
                // Uncheck All
                selectedCheckboxes = {};
                isCheckAllActive = false;

                table.rows().every(function() {
                    const checkbox = $(this.node()).find('.row-checkbox');
                    checkbox.prop('checked', false);
                });

                $('.row-checkbox').prop('checked', false);
            }

            //  console.log('selectedCheckboxes:', selectedCheckboxes);

            updateTotal();
        });

        // Event Individual Checkbox
        $(document).on('change', '.row-checkbox', function() {
            const id = $(this).val();
            const nominal = parseFloat($(this).data('nominal')) || 0;

            if (this.checked) {
                // Tambahkan ke object
                $('#checkAll').prop('checked', true);
                isCheckAllActive = true;
                selectedCheckboxes[id] = nominal;
            } else {
                // Hapus dari object
                delete selectedCheckboxes[id];

                // Uncheck "Check All" button
                $('#checkAll').prop('checked', false);
                isCheckAllActive = false;
            }

            // console.log('selectedCheckboxes:', nominal);

            updateTotal();
        });

        // Event Page Change: Restore checkbox state
        $(document).on('page.dt', '#list_{{ $dmenu }}', function() {
            // Tunggu DataTables selesai render
            setTimeout(function() {
                // Restore checkbox yang sudah di-check sebelumnya
                $('.row-checkbox').each(function() {
                    const id = $(this).val();
                    if (selectedCheckboxes[id] !== undefined) {
                        $(this).prop('checked', true);
                    }
                });

                // Sync Check All button
                if (isCheckAllActive) {
                    $('#checkAll').prop('checked', true);
                }
            }, 100); // Delay 100ms biar DOM sudah ready
        });


        // Handle form submission Set Eff Date via AJAX
        $('#setEffDateForm').on('submit', function(e) {
            e.preventDefault();
            const form = $(this);
            const submitButton = form.find('button[type="submit"]');
            submitButton.prop('disabled', true).html(
                '<span class="spinner-border spinner-border-sm me-2" role="status" aria-hidden="true"></span>Saving...'
            );

            $.ajax({
                url: form.attr('action'),
                type: 'POST',
                data: form.serialize(),
                success: function(response) {
                    submitButton.prop('disabled', false).html('Simpan');
                    $('#setEffDateModal').modal('hide');
                    if (response.status === 'success') {
                        Swal.fire({
                            icon: 'success',
                            title: 'Berhasil',
                            text: response.message,
                            confirmButtonColor: '#028284'
                        }).then(() => {
                            location.reload(); // Reload di dalam .then() (tetap di if block)
                        });
                    } else {
                        Swal.fire({
                            icon: 'error',
                            title: 'Gagal',
                            text: response.message,
                            confirmButtonColor: '#028284'
                        });
                    }
                },
                error: function(xhr) {
                    submitButton.prop('disabled', false).html('Simpan');
                    let errorMessage = 'Terjadi kesalahan sistem';
                    if (xhr.status === 422) {
                        let errors = xhr.responseJSON.errors;
                        errorMessage = Object.values(errors).flat().join('<br>');
                    } else if (xhr.responseJSON && xhr.responseJSON.message) {
                        errorMessage = xhr.responseJSON.message;
                    }
                    Swal.fire({
                        icon: 'error',
                        title: 'Gagal',
                        html: errorMessage,
                        confirmButtonColor: '#028284'
                    });
                }
            });
        });

        //  Tambah fungsi openSetEffDateModal buat handle seleksi checkbox, validasi, dan input hidden dinamis; dipanggil dari onclick button, enable update multi-select
        function openSetEffDateModal() {
            // const selectedIds = [];
            const selectedIds = Object.keys(selectedCheckboxes);


            if (selectedIds.length === 0) {
                Swal.fire({
                    icon: 'warning',
                    title: 'Perhatian',
                    text: 'Pilih minimal 1 data terlebih dahulu',
                    confirmButtonColor: '#028284'
                });
                return;
            }
            $('#selectedCount').text(selectedIds.length);
            $('input[name="selected_ids[]"]').remove();
            selectedIds.forEach((id) => {
                $("#setEffDateForm").append(
                    `<input type="hidden" name="selected_ids[]" value="${id}">`
                );
            });

            // Auto-set current date ke input name="eff_date" (format YYYY-MM-DD untuk type="date")
            const now = new Date();
            const year = now.getFullYear(); // 2025
            const month = (now.getMonth() + 1).toString().padStart(2, "0"); // 10
            const day = now.getDate().toString().padStart(2, "0"); // 15
            const currentDateFormatted = `${year}-${month}-${day}`;


            $('input[name="eff_date"]').val(currentDateFormatted);

            $("#setEffDateModal").modal("show");

        }

        const bulanID = ['Jan', 'Feb', 'Mar', 'Apr', 'Mei', 'Jun', 'Jul', 'Agu', 'Sep', 'Okt', 'Nov', 'Des'];


        function parseEffDate(rawDateStr, filterEffDateParam = null) {
            // Prioritas 1: Per row (handle ' - ', null,')
            if (rawDateStr && rawDateStr.trim() !== '' && rawDateStr.trim() !== '-' && rawDateStr.trim() !== ' - ') {
                // Split 'dd/mm/yyyy' atau 'd/m/yyyy'
                const parts = rawDateStr.split('/');
                if (parts.length === 3) {
                    let day = parseInt(parts[0], 10);
                    let month = parseInt(parts[1], 10);
                    let year = parseInt(parts[2], 10);

                    // Pad day ke 2 digit
                    day = day.toString().padStart(2, '0');

                    // VALIDASI & FORMAT MONTH: Pakai native JS biar aman, fallback ke current month kalau invalid
                    let monthName = '';
                    if (month >= 1 && month <= 12) {
                        // Buat Date object sementara untuk format nama bulan
                        const tempDate = new Date(year, month - 1, 1); // month -1 karena JS Date 0=Jan
                        monthName = tempDate.toLocaleDateString('id-ID', {
                            month: 'short'
                        }); // 'Okt', 'Jan', dll.
                    } else {
                        // Fallback: Pakai bulan current date
                        console.warn(`Invalid month ${month} for date ${rawDateStr}`);
                        return '';
                    }

                    return `${day} ${monthName} ${year}`;
                }
            }


            if (filterEffDateParam) {
                const parts = filterEffDateParam.split('/');
                if (parts.length === 3) {
                    let day = parseInt(parts[0], 10);
                    let month = parseInt(parts[1], 10);
                    let year = parseInt(parts[2], 10);
                    day = day.toString().padStart(2, '0');
                    let monthName = '';
                    if (month >= 1 && month <= 12) {
                        const tempDate = new Date(year, month - 1, 1);
                        monthName = tempDate.toLocaleDateString('id-ID', {
                            month: 'short'
                        });
                    } else {
                        return '';
                    }
                    return `${day} ${monthName} ${year}`;
                }
            }

            return '';
        }



        function isPureBCA(bankPenerima) {
            if (!bankPenerima) return false;

            const bank = String(bankPenerima).toLowerCase().trim();

            if (bank === 'bca') return true;
            if (bank.includes('digital') || bank.includes('syariah')) return false;

            return false;
        }

        function exportBCA() {
            let selectedIds = [];

            selectedIds = Object.keys(selectedCheckboxes);

            if (selectedIds.length === 0) {
                Swal.fire({
                    icon: 'warning',
                    title: 'Perhatian',
                    text: 'Pilih minimal 1 data dengan checkbox terlebih dahulu',
                    confirmButtonColor: '#028284'
                });
                return;
            }

            // Ambil SEMUA rows yang terfilter dulu (seperti sebelumnya)
            const allRows = table.rows({
                search: 'applied'
            }).data().toArray();

            const rowsToExport = allRows.filter(row => selectedIds.includes(row[3]) && stripHTML(row[13]) !== 'SELESAI')
                                        .sort((a, b) => stripHTML(a[7]).localeCompare(stripHTML(b[7])));

            if (rowsToExport.length === 0) {
                Swal.fire({
                    icon: 'warning',
                    title: 'Tidak ada data',
                    text: 'Data yang dipilih tidak valid atau tidak ditemukan. Export dibatalkan.',
                    confirmButtonColor: '#028284'
                });
                return;
            }

            const exportData = @json($export_data ?? []);
            const filterEffDate = @json($filter['eff_date'] ?? null); // Dinamis dari filter, bisa null

            const workbook = new ExcelJS.Workbook();
            const worksheet = workbook.addWorksheet('Data');

            // Bulan ID untuk format manual dd Mon YYYY
            const bulanID = ['Jan', 'Feb', 'Mar', 'Apr', 'Mei', 'Jun', 'Jul', 'Agu', 'Sep', 'Okt', 'Nov', 'Des'];

            const headerRow = worksheet.addRow([
                'No', 'Transaction ID', 'Transfer Type', 'Debited Acc.', 'Beneficiary ID',
                'Credited Acc.', 'Amount', 'Eff. Date', 'Transaction Purpose', 'Currency',
                'Charges Type', 'Charges Acc.', 'Remark 1', 'Remark 2', 'Receiver Bank Cd',
                'Receiver Bank Name', 'Receiver Name', 'Receiver Cust. Type',
                'Receiver Cust. Residen', 'Transaction Cd', 'Beneficiary Email'
            ]);

            headerRow.eachCell((cell) => {
                cell.font = {
                    bold: true,
                    color: {
                        argb: 'FFFFFFFF'
                    }
                };
                cell.fill = {
                    type: 'pattern',
                    pattern: 'solid',
                    fgColor: {
                        argb: '00000000'
                    }
                };
                cell.alignment = {
                    vertical: 'middle',
                    horizontal: 'center'
                };
            });


            const nonBCACount = rowsToExport.filter(row => {
                return !isPureBCA(row[9]); // bank penerima
            }).length;
            // const bulkMethod = nonBCACount >= 10 ? 'BIF' : 'LLG';


            rowsToExport.forEach((data, index) => {
                const idPengajuan = data[3];
                const extra = exportData[idPengajuan] || {
                    nama_bank: '',
                    email_karyawan: '',
                    kode_swift: ''
                };

                const isBCA = isPureBCA(data[9]);

                // Tentukan Transfer Type berdasarkan BCA atau bukan
                let transferType = '';
                if (isBCA) {
                    transferType = 'BCA';
                } else {
                    transferType = 'LLG'; // LLG atau BIF
                }

                // Amount dari index 11
                const amountStr = String(data[11] || '0')
                    .replace(/Rp\s?/i, '')
                    .replace(/\./g, '')
                    .replace(/,/g, '')
                    .replace(/ -$/g, '')
                    .trim();
                const amount = Number(amountStr) || 0;


                const formattedEffDate = parseEffDate(data[12], filterEffDate); // Dinamis, fallback otomatis


                const bankCode = extra.kode_swift || '';
                const receiverBankCd = isBCA ? '' : bankCode;

                worksheet.addRow([
                    index + 1, // No
                    idPengajuan, // Transaction ID = ID_Pengajuan
                    transferType, // Transfer Type
                    7880853885, // Debited Acc. (hardcoded)
                    '', // Beneficiary ID (kosong)
                    data[10], // Credited Acc. = No_Rekening (index 10)
                    amount, // Amount (number, sekarang bener 2000000)
                    formattedEffDate, // Eff. Date per row (dd Mon YYYY, dinamis)
                    '', // Transaction Purpose (kosong)
                    'IDR', // Currency
                    'OUR', // Charges Type
                    7880853885, // Charges Acc.
                    data[2], // remark1
                    '', // Remark 2
                    receiverBankCd, // Receiver Bank Cd
                    isBCA ? '' : (extra.nama_bank || data[9] || ''), //Receiver Bank Name (pakai index 9)
                    data[7] || '', //Receiver Name = Nama_Anak (index 7)
                    isBCA ? '' : 1, // Receiver Cust. Type
                    isBCA ? '' : 1, // Receiver Cust. Residen
                    isBCA ? '' : 99, // Transaction Cd
                    extra.email_karyawan, // Beneficiary Email
                ]);
            });

            // Download
            workbook.xlsx.writeBuffer().then(function(buffer) {
                const blob = new Blob([buffer], {
                    type: 'application/octet-stream'
                });
                const link = document.createElement('a');
                link.href = URL.createObjectURL(blob);
                link.download = 'Transfer_Beasiswa_BCA.xlsx';
                link.click();
            });
        }


        // Fungsi strip HTML untuk clean row data
        function stripHTML(str) {
            if (!str) return '';
            return str.replace(/<[^>]*>/g, '').replace(/\s+/g, ' ').trim();
        }

        // parseEffDateForUOB
        function parseEffDateForUOB(rawDateStr, filterEffDateParam) {
            let parsed = parseEffDate(rawDateStr, filterEffDateParam);

            // ✅ Jika parseEffDate return empty, langsung return null
            if (!parsed || parsed === '') {
                return null;
            }

            const parts = parsed.split(' ');
            const day = parts[0].padStart(2, '0');
            const monthIndo = parts[1];
            const year = parts[2];

            const monthMap = {
                'Jan': 'Jan', 'Feb': 'Feb', 'Mar': 'Mar', 'Apr': 'Apr',
                'Mei': 'May', 'Jun': 'Jun', 'Jul': 'Jul', 'Agu': 'Aug',
                'Sep': 'Sep', 'Okt': 'Oct', 'Nov': 'Nov', 'Des': 'Dec'
            };

            const monthEng = monthMap[monthIndo] || monthIndo.substring(0, 3);
            const yearShort = year.slice(-2);
            const monthNum = Object.keys(monthMap).indexOf(monthIndo) + 1 ||
                            (new Date(year + ' ' + monthIndo + ' 1').getMonth() + 1);

            return {
                main: `${day}-${monthEng}-${yearShort}`,
                dupl: `${day}/${monthNum.toString().padStart(2, '0')}/${year}`
            };
        }

        function exportUOBBIF() {
            try {
                // Helper untuk parse amount
                const parseAmount = (raw) => {
                    const amountStr = String(raw || '0')
                        .replace(/Rp\s?/i, '')
                        .replace(/\./g, '')
                        .replace(/,/g, '')
                        .replace(/ -$/g, '')
                        .trim();
                    const amt = Number(amountStr) || 0;
                    return amt;
                };

                // Helper untuk format amount dengan koma (untuk kolom "Nominal Bayar")
                const formatAmountWithComma = (num) => {
                    return num.toLocaleString('en-US');
                };

                let selectedIds = [];
                selectedIds = Object.keys(selectedCheckboxes);

                if (selectedIds.length === 0) {
                    Swal.fire({
                        icon: 'warning',
                        title: 'Perhatian',
                        text: 'Pilih minimal 1 data dengan checkbox',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                // Ambil FULL rows
                const allRows = table.rows().data().toArray();


                const rowsToExport = allRows
                    .filter(row => selectedIds.includes(stripHTML(row[3])) && stripHTML(row[13]) !== 'SELESAI')
                    .map(row => ({
                        id: stripHTML(row[3]), // ID_Pengajuan (index 3)
                        periode: stripHTML(row[2]), // Nama_Periode (index 2)
                        remark1: stripHTML(row[2]), // Placeholder dari periode
                        nama_anak: stripHTML(row[7]), // Nama_Anak (index 7)
                        bank: stripHTML(row[9]), // Bank_Penerima (index 9)
                        norek: stripHTML(row[10]), // No_Rekening (index 10)
                        nominal: stripHTML(row[11]), // Nominal (index 11)
                        eff: stripHTML(row[12]) || '' //Eff_Date (index 12)
                    }))
                    .sort((a, b) => a.nama_anak.localeCompare(b.nama_anak));

                if (rowsToExport.length === 0) {
                    console.error('No match found:', {
                        selectedIds,
                        sampleRowIndex3: allRows[0] ? stripHTML(allRows[0][3]) : 'N/A'
                    });
                    Swal.fire({
                        icon: 'warning',
                        title: 'Tidak ada data',
                        text: 'Data yang dipilih tidak valid. Cek console.',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                console.log('Success: Selected', selectedIds.length, 'rows. Sample ID:', rowsToExport[0]
                    .id); // Debug ID_Pengajuan

                const exportData = @json($export_data ?? []);
                const filterEffDate = @json($filter['eff_date'] ?? null);

                // Hitung total amount
                const totalAmount = rowsToExport.reduce((sum, row) => sum + parseAmount(row.nominal), 0);
                const isBIF = totalAmount < 250000000;

                const SEP = ',';
                const EOL = '\r\n';

                // Helper untuk escape CSV
                const esc = v => {
                    if (v == null) return '';
                    let s = String(v).replace(/\r?\n/g, ' ');
                    if (s.includes('"')) s = s.replace(/"/g, '""');
                    if (s.includes(SEP)) s = `"${s}"`;
                    return s;
                };

                // === GENERATE BIF CSV ===
                const headersIndoBIF = [
                    'Jenis Rekening', 'Tujuan Transaksi', 'Nomor Rekening Debit', 'Mata Uang Rekening Debit',
                    'Nominal Bayar (Min: Rp. 10,000 ; Maks: Rp.250,000,000)', 'Nama Bank Tujuan', 'Kota Bank Tujuan',
                    'Nomor Rekening Tujuan', 'Nama Penerima', 'Detail Pembayaran', 'Tanggal Valuta', 'Alamat Penerima',
                    'Status Kewarganegaraan Penerima', 'Sandi Tujuan Transaksi', 'Hubungan Pelaku Transaksi',
                    'Kategori Penerima',
                    'Kode Booking', 'Alamat Email Penerima', 'Mata Uang Pembayaran', 'No Referensi Nasabah',
                    'Kode Bank Tujuan',
                    'Kode Kota Bank Tujuan', '', '', '', '', '', '', '', '', '', ''
                ];

                const headersEngBIF = [
                    'Account Type', 'Transaction Purpose', 'Debit Account No', 'Debit Account Currency',
                    'Payment Amount (Min: IDR 10,000 ; Max: IDR 250,000,000)', 'Beneficiary Bank Name',
                    'Beneficiary Bank City',
                    'Beneficiary Account Number', 'Beneficiary Name', 'Payment Details', 'Value Date',
                    'Beneficiary Address',
                    'Beneficiary Citizenship Status', 'Transaction Purpose Code', 'Transactor Relationship',
                    'Beneficiary Category',
                    'FX Booking Code', 'Beneficiary Email Address', 'Payment Currency', 'Customer Reff No',
                    'Beneficiary Bank Code',
                    'Beneficiary Bank City Code', 'Value Date', 'Beneficiary Citizenship Status',
                    'Transaction Purpose Code',
                    'Transactor Relationship', 'Beneficiary Category', 'Payment Amount', 'SALA', 'Account Type',
                    'Transaction Purpose'
                ];

                const bannerRowBIF = (textB, textD = '') => {
                    const row = Array(headersEngBIF.length).fill('');
                    row[1] = textB ?? '';
                    row[3] = textD ?? '';
                    return row.map(esc).join(SEP);
                };

                let csvBIF = '';

                // METADATA SECTION BIF
                csvBIF += bannerRowBIF('Identitas Perusahaan / Company Identification') + EOL;
                csvBIF += bannerRowBIF('ID Perusahaan / Company ID', 'MULTISPUNBIBP') + EOL;
                csvBIF += bannerRowBIF('Nama Perusahaan / Company Name', 'PT MULTI SPUNINDO JAYA Tbk') + EOL;
                csvBIF += bannerRowBIF('SALA', 'NO') + EOL;

                // Empty rows
                const emptyRowBIF = Array(headersEngBIF.length).fill('').map(esc).join(SEP);
                for (let i = 0; i < 4; i++) csvBIF += emptyRowBIF + EOL;

                // HEADERS BIF
                csvBIF += headersIndoBIF.map(esc).join(SEP) + EOL;
                csvBIF += headersEngBIF.map(esc).join(SEP) + EOL;

                // DATA ROWS BIF
                    let seq = 1;
                    rowsToExport.forEach((row) => {
                        const idPengajuan = row.id;
                        const extra = exportData[idPengajuan] || {
                            nama_bank: row.bank,
                            email_karyawan: '',
                            kode_swift: ''
                        };

                        const amount = parseAmount(row.nominal);
                        const nominalBayar = formatAmountWithComma(amount);
                        const effDateObj = parseEffDateForUOB(row.eff, filterEffDate);

                        const effDateMain = effDateObj ? effDateObj.main : '';
                        const effDateDupl = effDateObj ? effDateObj.dupl : '';

                        // [OLD]
                        // const refNo = effDateDupl ?
                        //     `25${effDateDupl.split('/')[1]}${effDateDupl.split('/')[0]}${seq.toString().padStart(8, '0')}` :
                        //     '';
                        // [OLD] di rowData pakai: idPengajuan (bukan refNo)

                        // Format: YYMMDD + 5 digit counter (contoh: 26022700000, 26022700001)
                        // Jika tidak ada effDateDupl, gunakan tanggal saat ini
                        let refNoDate;
                        if (effDateDupl) {
                            const parts = effDateDupl.split('/');
                            refNoDate = parts[2].slice(-2) + parts[1] + parts[0];
                        } else {
                            const now = new Date();
                            refNoDate = now.getFullYear().toString().slice(-2) +
                                       (now.getMonth() + 1).toString().padStart(2, '0') +
                                       now.getDate().toString().padStart(2, '0');
                        }
                        const refNo = refNoDate + seq.toString().padStart(5, '0');
                        seq++;
                        const detailPerRow = (row.remark1 || '').trim();

                        const rowData = [
                            'BFA - Account Number',
                            '99 - Others',
                            '3033020692',
                            'IDR',
                            nominalBayar,
                            extra.nama_bank || row.bank,
                            'SURABAYA',
                            row.norek,
                            row.nama_anak,
                            detailPerRow,
                            effDateMain,
                            'Surabaya',
                            '01 - Warga Negara / Citizen',
                            '2670 - Jasa lainnya / Other services',
                            'N - Non Afiliasi / Non Affiliated',
                            'A0 - Individu / Individual',
                            '',
                            extra.email_karyawan,
                            'IDR ',
                            // idPengajuan,
                            refNo,
                            extra.kode_swift,
                            '1200',
                            effDateDupl,
                            '01',
                            '2670',
                            'N',
                            'A0',
                            amount,
                            'NO',
                            'BFA',
                            '99'
                        ];

                        csvBIF += rowData.map(esc).join(SEP) + EOL;
                    });

                // // TRAILING EMPTY ROWS BIF
                // for (let i = 0; i < 20; i++) {
                //     csvBIF += ',,,,,,,,,,,,,,,,,,  ,,,,,,,,,,,,' + EOL;
                // }

                // === DOWNLOAD BOTH CSVs ===
                const BOM = new Uint8Array([0xEF, 0xBB, 0xBF]);

                // Download BIF first
                const blobBIF = new Blob([BOM, csvBIF], {
                    type: 'text/csv;charset=utf-8;'
                });

                const urlBIF = URL.createObjectURL(blobBIF);
                const aBIF = document.createElement('a');
                aBIF.href = urlBIF;
                aBIF.download = 'Transfer_Beasiswa_UOB_BIF.csv';
                document.body.appendChild(aBIF);
                aBIF.click();
                document.body.removeChild(aBIF);
                URL.revokeObjectURL(urlBIF);

            } catch (error) {
                console.error('Error exportUOB:', error);
                Swal.fire({
                    icon: 'error',
                    title: 'Error',
                    text: error.message,
                    confirmButtonColor: '#028284'
                });
            }
        }

        function exportUOBLLG(){
            try {
                // Helper untuk parse amount
                const parseAmount = (raw) => {
                    const amountStr = String(raw || '0')
                        .replace(/Rp\s?/i, '')
                        .replace(/\./g, '')
                        .replace(/,/g, '')
                        .replace(/ -$/g, '')
                        .trim();
                    const amt = Number(amountStr) || 0;
                    return amt;
                };

                // Helper untuk format amount dengan koma (untuk kolom "Nominal Bayar")
                const formatAmountWithComma = (num) => {
                    return num.toLocaleString('en-US');
                };

                let selectedIds = [];
                selectedIds = Object.keys(selectedCheckboxes);

                if (selectedIds.length === 0) {
                    Swal.fire({
                        icon: 'warning',
                        title: 'Perhatian',
                        text: 'Pilih minimal 1 data dengan checkbox',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                // Ambil FULL rows
                const allRows = table.rows().data().toArray();

                const rowsToExport = allRows
                    .filter(row => selectedIds.includes(stripHTML(row[3])) && stripHTML(row[13]) !== 'SELESAI')
                    .map(row => ({
                        id: stripHTML(row[3]), // ID_Pengajuan (index 3)
                        periode: stripHTML(row[2]), // Nama_Periode (index 2)
                        remark1: stripHTML(row[2]), // Placeholder dari periode
                        nama_anak: stripHTML(row[7]), // Nama_Anak (index 7)
                        bank: stripHTML(row[9]), // Bank_Penerima (index 9)
                        norek: stripHTML(row[10]), // No_Rekening (index 10)
                        nominal: stripHTML(row[11]), // Nominal (index 11)
                        eff: stripHTML(row[12]) || '' //Eff_Date (index 12)
                    }))
                    .sort((a, b) => a.nama_anak.localeCompare(b.nama_anak));

                if (rowsToExport.length === 0) {
                    console.error('No match found:', {
                        selectedIds,
                        sampleRowIndex3: allRows[0] ? stripHTML(allRows[0][3]) : 'N/A'
                    });
                    Swal.fire({
                        icon: 'warning',
                        title: 'Tidak ada data',
                        text: 'Data yang dipilih tidak valid. Cek console.',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                console.log('Success: Selected', selectedIds.length, 'rows. Sample ID:', rowsToExport[0]
                    .id); // Debug ID_Pengajuan

                const exportData = @json($export_data ?? []);
                const filterEffDate = @json($filter['eff_date'] ?? null);

                // Hitung total amount
                const totalAmount = rowsToExport.reduce((sum, row) => sum + parseAmount(row.nominal), 0);
                const isBIF = totalAmount < 250000000;

                const SEP = ',';
                const EOL = '\r\n';

                // Helper untuk escape CSV
                const esc = v => {
                    if (v == null) return '';
                    let s = String(v).replace(/\r?\n/g, ' ');
                    if (s.includes('"')) s = s.replace(/"/g, '""');
                    if (s.includes(SEP)) s = `"${s}"`;
                    return s;
                };

                // === GENERATE LLG CSV ===
                const llgHeadersIndo = [
                    'Jenis Transaksi *) ', 'Nomor Rekening Debit *) ', 'Mata Uang Rekening Debit *) ',
                    'Nominal Bayar *) ', 'Nama Bank Tujuan *) ', 'Kota Bank Tujuan *) ', 'Nomor Rekening Tujuan *) ',
                    'Nama Penerima *) ', 'Detail Pembayaran *) ', 'Tanggal Valuta *) ', 'Alamat Penerima *) ',
                    'Tipe Penerima *) ', 'Status Kependudukan Penerima *) ', 'Status Kewarganegaraan Penerima *) ',
                    'Sandi Tujuan Transaksi *) ', 'Hubungan Pelaku Transaksi *) ', 'Kategori Penerima *) ',
                    'Kode Booking', 'Alamat Email Penerima', 'Mata Uang Pembayaran', 'No Referensi Nasabah',
                    'Kode Bank Tujuan', 'Kode Kota Bank Tujuan', 'Kode Bank ATM', '', '', '', '', '', '', '', '', ''
                ];

                const llgHeadersEng = [
                    'Transaction Type', 'Debit Account No', 'Debit Account Currency', 'Payment Amount',
                    'Beneficiary Bank Name', 'Beneficiary Bank City', 'Beneficiary Account Number', 'Beneficiary Name',
                    'Payment Details', 'Value Date', 'Beneficiary Address', 'Beneficiary Type',
                    'Beneficiary Resident Status', 'Beneficiary Citizenship Status', 'Transaction Purpose Code',
                    'Transactor Relationship', 'Beneficiary Category', 'FX Booking Code', 'Beneficiary Email Address',
                    'Payment Currency', 'Customer Reff No', 'Beneficiary Bank Code', 'Beneficiary Bank City Code',
                    'ATM Bank Code', 'Value Date', 'Beneficiary Type', 'Beneficiary Resident Status',
                    'Beneficiary Citizenship Status', 'Transaction Purpose Code', 'Transactor Relationship',
                    'Beneficiary Category', 'Payment Amount', 'SALA'
                ];

                const bannerRowLLG = (textB, textD = '') => {
                    const row = Array(llgHeadersEng.length).fill('');
                    row[0] = '';
                    row[1] = textB ?? '';
                    row[2] = '';
                    row[3] = textD ?? '';
                    return row.map(esc).join(SEP);
                };

                let csvLLG = '';

                // METADATA SECTION LLG
                csvLLG += bannerRowLLG('Identitas Perusahaan / Company Identification') + EOL;
                csvLLG += bannerRowLLG('ID Perusahaan / Company ID', 'MULTISPUNBIBP') + EOL;
                csvLLG += bannerRowLLG('Nama Perusahaan / Company Name', 'PT MULTI SPUNINDO JAYA TBK') + EOL;
                csvLLG += bannerRowLLG('SALA *)', 'NO') + EOL;

                // One empty after SALA
                const emptyRowLLG = Array(llgHeadersEng.length).fill('').map(esc).join(SEP);
                csvLLG += emptyRowLLG + EOL;

                // Mandatory note row
                const mandatoryRow = ['', '*) wajib diisi / mandatory fields'].concat(Array(llgHeadersEng.length - 2).fill(
                    ''));
                csvLLG += mandatoryRow.map(esc).join(SEP) + EOL;

                // Three empties
                for (let i = 0; i < 3; i++) csvLLG += emptyRowLLG + EOL;

                // HEADERS LLG
                csvLLG += llgHeadersIndo.map(esc).join(SEP) + EOL;
                csvLLG += llgHeadersEng.map(esc).join(SEP) + EOL;

                let seq = 1;
                    rowsToExport.forEach((row) => {
                        const idPengajuan = row.id;
                        const extra = exportData[idPengajuan] || {
                            nama_bank: row.bank,
                            email_karyawan: '',
                            kode_swift: ''
                        };

                        const amount = parseAmount(row.nominal);
                        const nominalBayar = formatAmountWithComma(amount);
                        const effDateObj = parseEffDateForUOB(row.eff, filterEffDate);

                        const effDateMain = effDateObj ? effDateObj.main : '';
                        const effDateDupl = effDateObj ? effDateObj.dupl : '';

                        // [OLD] const refNo = effDateDupl ?
                        //     `25${effDateDupl.split('/')[1]}${effDateDupl.split('/')[0]}${seq.toString().padStart(8, '0')}` :
                        //     '';

                        // Format: YYMMDD + 5 digit counter (contoh: 26022700000, 26022700001)
                        // Jika tidak ada effDateDupl, gunakan tanggal saat ini
                        let refNoDate;
                        if (effDateDupl) {
                            const parts = effDateDupl.split('/');
                            refNoDate = parts[2].slice(-2) + parts[1] + parts[0];
                        } else {
                            const now = new Date();
                            refNoDate = now.getFullYear().toString().slice(-2) +
                                       (now.getMonth() + 1).toString().padStart(2, '0') +
                                       now.getDate().toString().padStart(2, '0');
                        }
                        const refNo = refNoDate + seq.toString().padStart(5, '0');
                        seq++;
                        const detailPerRow = (row.remark1 || '').trim();

                        const rowDataLLG = [
                            'LLG',
                            '3033020692',
                            'IDR',
                            nominalBayar,
                            extra.nama_bank || row.bank,
                            'SURABAYA',
                            row.norek,
                            row.nama_anak,
                            detailPerRow,
                            effDateMain,
                            'Surabaya',
                            '02 - Perusahaan / Company',
                            '01 - Penduduk / Resident',
                            '01 - Warga Negara / Citizen',
                            '2670 - Jasa lainnya / Other services',
                            'N - Non Afiliasi / Non Affiliated',
                            'E0 - Perusahaan / Company',
                            '',
                            extra.email_karyawan,
                            ' IDR ',
                            refNo,
                            extra.kode_swift || 'CENAIDJA',
                            '1200',
                            '014',
                            effDateDupl,
                            '02',
                            '01',
                            '01',
                            '2670',
                            'N',
                            'E0',
                            amount,
                            'NO'
                        ];

                        csvLLG += rowDataLLG.map(esc).join(SEP) + EOL;
                    });

                // // TRAILING EMPTY ROWS LLG
                // for (let i = 0; i < 7; i++) {
                //     csvLLG += ',,,,,,,,,,,,,,,,,,  ,,,,,,,,,,,,' + EOL;
                // }

                // === DOWNLOAD BOTH CSVs ===
                const BOM = new Uint8Array([0xEF, 0xBB, 0xBF]);


                    const blobLLG = new Blob([BOM, csvLLG], {
                        type: 'text/csv;charset=utf-8;'
                    });
                    const urlLLG = URL.createObjectURL(blobLLG);
                    const aLLG = document.createElement('a');
                    aLLG.href = urlLLG;
                    aLLG.download = 'Transfer_Beasiswa_UOB_LLG.csv';
                    document.body.appendChild(aLLG);
                    aLLG.click();
                    document.body.removeChild(aLLG);
                    URL.revokeObjectURL(urlLLG);
            } catch (error) {
                console.error('Error exportUOB:', error);
                Swal.fire({
                    icon: 'error',
                    title: 'Error',
                    text: error.message,
                    confirmButtonColor: '#028284'
                });
            }

        }

        function exportMandiri() {
            try {
                // Helper untuk parse amount
                const parseAmount = (raw) => {
                    const amountStr = String(raw || '0')
                        .replace(/Rp\s?/i, '')
                        .replace(/\./g, '')
                        .replace(/,/g, '')
                        .replace(/ -$/g, '')
                        .trim();
                    return Number(amountStr) || 0;
                };

                // Helper untuk escape CSV (menangani koma dan kutip)
                const esc = v => {
                    if (v == null) return '';
                    let s = String(v).replace(/\r?\n/g, ' ');
                    if (s.includes('"')) s = s.replace(/"/g, '""');
                    if (s.includes(',')) s = `"${s}"`;
                    return s;
                };

                // Helper untuk format tanggal ke YYYYMMDD
                const formatDateYYYYMMDD = (rawDateStr, filterEffDate) => {
                    if (rawDateStr && rawDateStr.trim() !== '' && rawDateStr.trim() !== '-' && rawDateStr.trim() !==
                        ' - ') {
                        const parts = rawDateStr.split('/');
                        if (parts.length === 3) {
                            const day = parts[0].padStart(2, '0');
                            const month = parts[1].padStart(2, '0');
                            const year = parts[2];
                            return `${year}${month}${day}`;
                        }
                    }

                    if (filterEffDate) {
                        const parts = filterEffDate.split('/');
                        if (parts.length === 3) {
                            const day = parts[0].padStart(2, '0');
                            const month = parts[1].padStart(2, '0');
                            const year = parts[2];
                            return `${year}${month}${day}`;
                        }
                    }

                    return '';
                };

                // Ambil data yang dipilih
                let selectedIds = [];
                selectedIds = Object.keys(selectedCheckboxes);


                if (selectedIds.length === 0) {
                    Swal.fire({
                        icon: 'warning',
                        title: 'Perhatian',
                        text: 'Pilih minimal 1 data dengan checkbox terlebih dahulu',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                // Ambil semua rows yang terfilter
                const allRows = table.rows({
                    search: 'applied'
                }).data().toArray();
                const rowsToExport = allRows
                    .filter(row => selectedIds.includes(stripHTML(row[3])) && stripHTML(row[13]) !== 'SELESAI')
                    .map(row => ({
                        id: stripHTML(row[3]), // ID_Pengajuan
                        norek: stripHTML(row[10]), // No_Rekening
                        nama: stripHTML(row[7]), // Nama_Anak
                        bank: stripHTML(row[9]), // Bank_Penerima
                        nominal: stripHTML(row[11]), // Nominal
                        eff_date: stripHTML(row[12]) // Eff_Date
                    }))
                    .sort((a, b) => a.nama.localeCompare(b.nama));

                if (rowsToExport.length === 0) {
                    Swal.fire({
                        icon: 'warning',
                        title: 'Tidak ada data',
                        text: 'Data yang dipilih tidak valid atau tidak ditemukan.',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                // Ambil export_data dari controller
                const exportData = @json($export_data ?? []);
                const filterEffDate = @json($filter['eff_date'] ?? null);

                // Hitung total amount dan total baris
                const totalAmount = rowsToExport.reduce((sum, row) => sum + parseAmount(row.nominal), 0);
                const totalRows = rowsToExport.length;

                const effDate = formatDateYYYYMMDD(rowsToExport[0]?.eff_date, filterEffDate);
                const headerRow = Array(44).fill(''); // Total 44 kolom (A sampai AR)
                headerRow[0] = 'P'; // A
                headerRow[1] = effDate; // B: YYYYMMDD
                headerRow[2] = '1410024778888'; // C: Rekening Sumber
                headerRow[3] = totalRows; // D: Total baris - 1
                headerRow[4] = totalAmount; // E: Total amount

                // Siapkan array untuk semua baris CSV
                const csvRows = [];
                csvRows.push(headerRow.map(esc).join(','));

                // Proses baris data (baris 2 dst.)
                rowsToExport.forEach(row => {
                    const idPengajuan = row.id;
                    const extra = exportData[idPengajuan] || {
                        nama_bank: row.bank,
                        kode_swift: '',
                        email_karyawan: ''
                    };

                    // Tentukan IBU (sesama Mandiri) atau LBU (bank lain)
                    const isMandiri = row.bank.toLowerCase().includes('mandiri');
                    const transferType = isMandiri ? 'IBU' : 'LBU';

                    const dataRow = Array(44).fill('');
                    dataRow[0] = row.norek; // A: No. Rekening Tujuan
                    dataRow[1] = row.nama; // B: Nama Penerima
                    dataRow[5] = 'IDR'; // F: Currency
                    dataRow[6] = parseAmount(row.nominal); // G: Amount
                    dataRow[7] = 'PEMBAYARAN'; // H: Remark
                    dataRow[9] = transferType; // J: IBU/LBU
                    dataRow[10] = extra.kode_swift || ''; // K: SWIFT Code
                    dataRow[11] = extra.alias_bank || row.bank; // L: Nama Bank
                    dataRow[12] = 'SURABAYA'; // M: Beneficiary Address (contoh dari file)
                    dataRow[16] = 'N'; // Q: N
                    dataRow[38] = 'OUR'; // AM: OUR
                    dataRow[39] = '1'; // AN: 1
                    dataRow[40] = 'E'; // AO: E

                    csvRows.push(dataRow.map(esc).join(','));
                });

                const csvContent = csvRows.join('\r\n');

                const BOM = new Uint8Array([0xEF, 0xBB, 0xBF]);
                const blob = new Blob([BOM, csvContent], {
                    type: 'text/csv;charset=utf-8;'
                });
                const url = URL.createObjectURL(blob);
                const link = document.createElement('a');
                link.href = url;
                link.download = 'Transfer_Beasiswa_Mandiri.csv';
                document.body.appendChild(link);
                link.click();
                document.body.removeChild(link);
                URL.revokeObjectURL(url);

                Swal.fire({
                    icon: 'success',
                    title: 'Berhasil',
                    text: `Berhasil export ${rowsToExport.length} data ke CSV Mandiri`,
                    confirmButtonColor: '#028284'
                });

            } catch (error) {
                console.error('Error exportMandiri:', error);
                Swal.fire({
                    icon: 'error',
                    title: 'Gagal',
                    text: 'Terjadi kesalahan saat export: ' + error.message,
                    confirmButtonColor: '#028284'
                });
            }
        }

        // Finish All function
        function finishAll() {
            let selectedIds = [];
            selectedIds = Object.keys(selectedCheckboxes);

            if (selectedIds.length === 0) {
                Swal.fire({
                    icon: 'warning',
                    title: 'Perhatian',
                    text: 'Pilih minimal 1 data dengan checkbox terlebih dahulu',
                    confirmButtonColor: '#028284'
                });
                return;
            }

            Swal.fire({
                icon: 'question',
                title: 'Konfirmasi',
                text: `Apakah Anda yakin ingin menyelesaikan ${selectedIds.length} transaksi beasiswa?`,
                showCancelButton: true,
                confirmButtonText: 'Ya, Selesaikan',
                cancelButtonText: 'Batal',
                confirmButtonColor: '#028284',
                cancelButtonColor: '#d33'
            }).then((result) => {
                if (result.isConfirmed) {
                    $.ajax({
                        url: '{{ route('rptfba.finishAll') }}', // Ensure this route exists
                        type: 'POST',
                        data: {
                            _token: '{{ csrf_token() }}',
                            selected_ids: selectedIds
                        },
                        success: function(response) {
                            if (response.status === 'success') {
                                Swal.fire({
                                    icon: 'success',
                                    title: 'Berhasil',
                                    text: response.message,
                                    confirmButtonColor: '#028284'
                                }).then(() => {
                                    location.reload();
                                });
                            } else {
                                Swal.fire({
                                    icon: 'error',
                                    title: 'Gagal',
                                    text: response.message,
                                    confirmButtonColor: '#028284'
                                });
                            }
                        },
                        error: function(xhr) {
                            let errorMessage = 'Terjadi kesalahan sistem';
                            if (xhr.status === 422) {
                                let errors = xhr.responseJSON.errors;
                                errorMessage = Object.values(errors).flat().join('<br>');
                            } else if (xhr.responseJSON && xhr.responseJSON.message) {
                                errorMessage = xhr.responseJSON.message;
                            }
                            Swal.fire({
                                icon: 'error',
                                title: 'Gagal',
                                html: errorMessage,
                                confirmButtonColor: '#028284'
                            });
                        }
                    });
                }
            });
        }

        // regenerate id
        function generateID() {
            try {
                // Ambil data yang dipilih
                let selectedIds = [];
                selectedIds = Object.keys(selectedCheckboxes);

                if (selectedIds.length === 0) {
                    Swal.fire({
                        icon: 'warning',
                        title: 'Perhatian',
                        text: 'Pilih minimal 1 data dengan checkbox terlebih dahulu',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                // Ambil semua rows yang terfilter
                const allRows = table.rows({
                    search: 'applied'
                }).data().toArray();
                const rowsToExport = allRows
                    .filter(row => selectedIds.includes(stripHTML(row[3])))
                    .map(row => ({
                        id: stripHTML(row[3]), // ID_Pengajuan
                        norek: stripHTML(row[10]) // No_Rekening (index 10)
                    }));

                if (rowsToExport.length === 0) {
                    Swal.fire({
                        icon: 'warning',
                        title: 'Tidak ada data',
                        text: 'Data yang dipilih tidak valid atau tidak ditemukan.',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                // Kirim data ke server untuk generate ID baru
                Swal.fire({
                    title: `Konfirmasi Generate ID`,
                    html: `
        <div class="text-center">
            <p>Apakah Anda yakin ingin menghasilkan ID baru untuk <strong>${rowsToExport.length}</strong> data yang dipilih?</p>
        </div>
    `,
                    icon: 'question',
                    showCancelButton: true,
                    confirmButtonText: `Ya, Generate ID`,
                    cancelButtonText: 'Batal',
                    confirmButtonColor: '#28a745',
                    cancelButtonColor: '#dc3545',
                    reverseButtons: true,
                    customClass: {
                        confirmButton: 'btn btn-success',
                        cancelButton: 'btn btn-secondary'
                    }
                }).then((result) => {
                    if (result.isConfirmed) {
                        $.ajax({
                            url: '{{ route('rptfba.generateID') }}', // Pastikan route ini ada
                            type: 'POST',
                            data: {
                                _token: '{{ csrf_token() }}',
                                data: rowsToExport // Kirim array { id, norek }
                            },
                            success: function(response) {
                                if (response.status === 'success') {
                                    Swal.fire({
                                        icon: 'success',
                                        title: 'Berhasil',
                                        text: `Berhasil menghasilkan ${response.updated_count} ID baru`,
                                        confirmButtonColor: '#028284'
                                    }).then(() => {
                                        location
                                            .reload(); // Reload halaman untuk memperbarui tabel
                                    });
                                } else {
                                    Swal.fire({
                                        icon: 'error',
                                        title: 'Gagal',
                                        text: response.message || 'Gagal menghasilkan ID baru',
                                        confirmButtonColor: '#028284'
                                    });
                                }
                            },
                            error: function(xhr) {
                                let errorMessage = 'Terjadi kesalahan sistem';
                                if (xhr.status === 422) {
                                    let errors = xhr.responseJSON.errors;
                                    errorMessage = Object.values(errors).flat().join('<br>');
                                } else if (xhr.responseJSON && xhr.responseJSON.message) {
                                    errorMessage = xhr.responseJSON.message;
                                }
                                Swal.fire({
                                    icon: 'error',
                                    title: 'Gagal',
                                    html: errorMessage,
                                    confirmButtonColor: '#028284'
                                });
                            }
                        });
                    }
                    // else if (result.isDismissed) {
                    //     location.reload(); // Reload halaman jika tombol Batal diklik
                    // }
                });
            } catch (error) {
                console.error('Error generateID:', error);
                Swal.fire({
                    icon: 'error',
                    title: 'Gagal',
                    text: 'Terjadi kesalahan saat menghasilkan ID: ' + error.message,
                    confirmButtonColor: '#028284'
                });
            }
        }
        // function delete
        function deleteData(name, msg) {
            let pesan = confirm('Apakah Anda Yakin ' + msg + ' Data ' + name + ' ini ?');
            if (pesan) return true;
            else return false;
        }
    </script>
@endpush