@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@section('content')
    @php
        $activeTab = str_replace('_', '-', request('tab', 'neraca-lajur'));
        $currentRole = session('user') ? session('user')->idroles : null;
        if ($currentRole === 'viewer' && $activeTab === 'periode') {
            $activeTab = 'neraca-lajur';
        }
    @endphp
    @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="row">
                            <div class="card-header col-md-auto">
                                <h5 class="mb-0">{{ $title_menu }}</h5>
                            </div>
                            <div class="col">
                                {{-- alert --}}
                                @include('components.alert')
                            </div>
                        </div>
                        <hr class="horizontal dark mt-0">

                        {{-- Tab Navigation --}}
                        <div class="row px-4">
                            <div class="col-lg">
                                <ul class="nav nav-tabs" id="reportTabs" role="tablist">
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link {{ $activeTab === 'neraca-lajur' ? 'active' : '' }}"
                                            id="neraca-lajur-tab" data-bs-toggle="tab"
                                            data-bs-target="#neraca-lajur-content" type="button" role="tab"
                                            aria-controls="neraca-lajur-content"
                                            aria-selected="{{ $activeTab === 'neraca-lajur' ? 'true' : 'false' }}">
                                            Neraca Lajur
                                        </button>
                                    </li>
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link {{ $activeTab === 'mutasi' ? 'active' : '' }}"
                                            id="mutasi-tab" data-bs-toggle="tab" data-bs-target="#mutasi-content"
                                            type="button" role="tab" aria-controls="mutasi-content"
                                            aria-selected="{{ $activeTab === 'mutasi' ? 'true' : 'false' }}">
                                            Mutasi
                                        </button>
                                    </li>
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link {{ $activeTab === 'neraca' ? 'active' : '' }}"
                                            id="neraca-tab" data-bs-toggle="tab" data-bs-target="#neraca-content"
                                            type="button" role="tab" aria-controls="neraca-content"
                                            aria-selected="{{ $activeTab === 'neraca' ? 'true' : 'false' }}">
                                            Neraca
                                        </button>
                                    </li>
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link {{ $activeTab === 'neraca-baru' ? 'active' : '' }}"
                                            id="neraca-baru-tab" data-bs-toggle="tab" data-bs-target="#neraca-baru-content"
                                            type="button" role="tab" aria-controls="neraca-baru-content"
                                            aria-selected="{{ $activeTab === 'neraca-baru' ? 'true' : 'false' }}">
                                            Neraca Baru
                                        </button>
                                    </li>
                                    <li class="nav-item" role="presentation">
                                        <button class="nav-link {{ $activeTab === 'laba-rugi' ? 'active' : '' }}"
                                            id="laba-rugi-tab" data-bs-toggle="tab" data-bs-target="#laba-rugi-content"
                                            type="button" role="tab" aria-controls="laba-rugi-content"
                                            aria-selected="{{ $activeTab === 'laba-rugi' ? 'true' : 'false' }}">
                                            Laba / Rugi
                                        </button>
                                    </li>
                                    @if ($currentRole !== 'viewer')
                                        <li class="nav-item" role="presentation">
                                            <button class="nav-link {{ $activeTab === 'periode' ? 'active' : '' }}"
                                                id="periode-tab" data-bs-toggle="tab" data-bs-target="#periode-content"
                                                type="button" role="tab" aria-controls="periode-content"
                                                aria-selected="{{ $activeTab === 'periode' ? 'true' : 'false' }}">
                                                Periode(Tutup Buku)
                                            </button>
                                        </li>
                                    @endif
                                </ul>
                            </div>
                        </div>

                        {{-- Export & Search Section --}}
                        <div class="row px-4 py-3">
                            <div class="col-lg d-flex justify-content-between align-items-center flex-wrap gap-2">
                                <div class="d-flex align-items-center gap-2 flex-wrap">
                                    {{-- Export buttons --}}
                                    @if ($authorize->excel == '1')
                                        <button class="btn btn-secondary mb-0" id="btn-export-excel" title="Export Excel">
                                            <i class="fas fa-file-excel me-1 text-success"></i><span
                                                class="font-weight-bold">Excel</span>
                                        </button>
                                    @endif
                                    @if ($authorize->pdf == '1')
                                        <button class="btn btn-secondary mb-0" id="btn-export-pdf" title="Export PDF">
                                            <i class="fas fa-file-pdf me-1 text-danger"></i><span
                                                class="font-weight-bold">PDF</span>
                                        </button>
                                    @endif
                                    @if ($authorize->print == '1')
                                        <button class="btn btn-secondary mb-0" id="btn-print" title="Print">
                                            <i class="fas fa-print me-1"></i><span class="font-weight-bold">Print</span>
                                        </button>
                                    @endif
                                </div>
                                <div class="d-flex align-items-center">
                                    <input type="text" id="coa-search" class="form-control me-2" placeholder="Cari :"
                                        style="max-width:250px;" value="{{ request('search') }}">
                                </div>
                            </div>
                        </div>

                        {{-- Tab Content --}}
                        <div class="tab-content" id="reportTabContent">
                            {{-- Neraca Lajur Tab --}}
                            <div class="tab-pane {{ $activeTab === 'neraca-lajur' ? 'show active' : '' }}"
                                id="neraca-lajur-content" role="tabpanel" aria-labelledby="neraca-lajur-tab">
                                <div class="row px-4 py-3">
                                    @include('report.rptlpr.partials.neraca_lajur')
                                </div>
                            </div>

                            {{-- Mutasi Tab --}}
                            <div class="tab-pane {{ $activeTab === 'mutasi' ? 'show active' : '' }}" id="mutasi-content"
                                role="tabpanel" aria-labelledby="mutasi-tab">
                                <div class="row px-4 py-3">
                                    @include('report.rptlpr.partials.mutasi')
                                </div>
                            </div>

                            {{-- Neraca Tab --}}
                            <div class="tab-pane {{ $activeTab === 'neraca' ? 'show active' : '' }}" id="neraca-content"
                                role="tabpanel" aria-labelledby="neraca-tab">
                                <div class="row px-4 py-3">
                                    @include('report.rptlpr.partials.neraca')
                                </div>
                            </div>

                            {{-- Neraca Baru Tab --}}
                            <div class="tab-pane {{ $activeTab === 'neraca-baru' ? 'show active' : '' }}"
                                id="neraca-baru-content" role="tabpanel" aria-labelledby="neraca-baru-tab">
                                <div class="row px-4 py-3">
                                    @include('report.rptlpr.partials.neraca_baru')
                                </div>
                            </div>

                            {{-- Laba / Rugi Tab --}}
                            <div class="tab-pane {{ $activeTab === 'laba-rugi' ? 'show active' : '' }}"
                                id="laba-rugi-content" role="tabpanel" aria-labelledby="laba-rugi-tab">
                                <div class="row px-4 py-3">
                                    @include('report.rptlpr.partials.laba_rugi')
                                </div>
                            </div>

                            {{-- Periode Tab --}}
                            @if ($currentRole !== 'viewer')
                                <div class="tab-pane {{ $activeTab === 'periode' ? 'show active' : '' }}"
                                    id="periode-content" role="tabpanel" aria-labelledby="periode-tab">
                                    <div class="row px-4 py-3">
                                        @include('report.rptlpr.partials.periode')
                                    </div>
                                </div>
                            @endif
                        </div>

                        @php
                            $neracaBalanceNotes = [];
                            $neracaBaruTidakBalance = false;

                            $isNeraca = ($activeTab ?? '') === 'neraca';
                            $isNeracaBaru = ($activeTab ?? '') === 'neraca-baru';

                            $sumByPrefix = function ($sections, array $prefixes) {
                                $total = 0.0;

                                $matchesPrefix = function ($value) use ($prefixes) {
                                    $value = (string) $value;

                                    foreach ($prefixes as $prefix) {
                                        if (str_starts_with($value, $prefix)) {
                                            return true;
                                        }
                                    }

                                    return false;
                                };

                                $scanRows = function ($rows) use (&$scanRows, &$total, $matchesPrefix) {
                                    foreach ($rows ?? [] as $row) {
                                        $kode = (string) ($row->kode ?? '');

                                        if ($matchesPrefix($kode)) {
                                            $total += (float) ($row->amount ?? 0);
                                            continue;
                                        }

                                        if (!empty($row->children)) {
                                            $scanRows($row->children);
                                        }
                                    }
                                };

                                foreach ($sections ?? [] as $section) {
                                    $scanRows($section->rows ?? []);
                                }

                                return $total;
                            };

                            if ($isNeraca && !empty($neraca_result ?? [])) {
                                foreach ($neraca_result as $result) {
                                    $assetTotal = $sumByPrefix($result->sections ?? [], ['1']);

                                    $liabilityEquityTotal = $sumByPrefix($result->sections ?? [], ['2', '3']);

                                    $selisih = abs(abs($assetTotal) - abs($liabilityEquityTotal));

                                    if ($selisih > 0.0001) {
                                        $periode = $result->periode ?? null;

                                        if ($periode) {
                                            try {
                                                $periodeLabel = \Carbon\Carbon::createFromFormat('Y-m', $periode)
                                                    ->locale('id')
                                                    ->translatedFormat('F Y');
                                            } catch (\Exception $e) {
                                                $periodeLabel = $periode;
                                            }

                                            $neracaBalanceNotes[] = $periodeLabel;
                                        }
                                    }
                                }

                                $neracaBalanceNotes = array_values(array_unique($neracaBalanceNotes));
                            }

                            if ($isNeracaBaru && !empty($neraca_baru_result ?? [])) {
                                $assetTotalBaru = 0.0;
                                $liabilityEquityTotalBaru = 0.0;

                                foreach ($neraca_baru_result as $result) {
                                    $assetTotalBaru += $sumByPrefix($result->sections ?? [], ['1']);

                                    $liabilityEquityTotalBaru += $sumByPrefix($result->sections ?? [], ['2', '3']);
                                }

                                $selisihBaru = abs(abs($assetTotalBaru) - abs($liabilityEquityTotalBaru));

                                $neracaBaruTidakBalance = $selisihBaru > 0.0001;
                            }
                        @endphp
                        <div class="row px-4 py-2">
                            <div class="col-lg">

                                <div class="nav-wrapper" id="noted">
                                    <code>
                                        Note :
                                        <i aria-hidden="true" style="color: #ffc2cd;" class="fas fa-circle">
                                        </i>
                                        Data not active
                                    </code>
                                </div>

                                {{-- NERACA: tampilkan bulan yang tidak balance --}}
                                @if ($isNeraca && !empty($neracaBalanceNotes))
                                    <div class="nav-wrapper mt-1" id="balance-note">
                                        <code>
                                            Note :
                                            <i aria-hidden="true" style="color: #dc3545;" class="fas fa-circle">
                                            </i>

                                            Belum Balance:
                                            {{ implode(', ', $neracaBalanceNotes) }}
                                        </code>
                                    </div>
                                @endif

                                {{-- NERACA BARU: hanya cek total --}}
                                @if ($isNeracaBaru && $neracaBaruTidakBalance)
                                    <div class="nav-wrapper mt-1" id="balance-note-new">
                                        <code>
                                            Note :
                                            <i aria-hidden="true" style="color: #dc3545;" class="fas fa-circle">
                                            </i>

                                            Belum Balance
                                        </code>
                                    </div>
                                @endif

                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('js')
    {{-- xlsx-js-style for styled Excel export --}}
    <script src="https://cdn.jsdelivr.net/npm/xlsx-js-style@1.2.0/dist/xlsx.bundle.js"></script>
    {{-- jsPDF + AutoTable for PDF export --}}
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.8.2/jspdf.plugin.autotable.min.js"></script>

    <script>
        $(document).ready(function() {
            const urlParams = new URLSearchParams(window.location.search);
            const tabFromUrl = urlParams.get('tab');
            let currentTab = 'neraca-lajur-tab';
            if (tabFromUrl) {
                currentTab = tabFromUrl.replace(/_/g, '-') + '-tab';
            }

            const isViewer = @json($currentRole === 'viewer');
            if (isViewer && currentTab === 'periode-tab') {
                currentTab = 'neraca-lajur-tab';
            }

            // Sync the active tab on load using Bootstrap's native API
            const tabEl = document.getElementById(currentTab);
            if (tabEl) {
                const tabInstance = bootstrap.Tab.getOrCreateInstance(tabEl);
                if (!tabEl.classList.contains('active')) {
                    tabInstance.show();
                }
            }

            // Initialize Bootstrap tabs / DataTables
            initializeDataTables();

            // Trigger search on load if there's an initial search query
            $('#coa-search').trigger('input');

            function updateBalanceNote(tabId) {
                const balanceNote = document.getElementById('balance-note');
                if (!balanceNote) return;

                if (tabId === 'neraca-tab' || tabId === 'neraca-baru-tab') {
                    balanceNote.classList.remove('d-none');
                } else {
                    balanceNote.classList.add('d-none');
                }
            }

            updateBalanceNote(currentTab);

            // Tab switching event: update URL parameter, init datatables, and re-apply search
            const tabButtons = document.querySelectorAll('#reportTabs button');
            tabButtons.forEach(button => {
                button.addEventListener('shown.bs.tab', function(e) {
                    const tabId = e.target.id;
                    const tabName = tabId.replace('-tab', '').replace(/-/g, '_');
                    const url = new URL(window.location.href);
                    url.searchParams.set('tab', tabName);
                    window.history.replaceState({}, '', url.toString());

                    updateBalanceNote(tabId);
                    initializeDataTables();
                    $('#coa-search').trigger('input');
                });
            });

            // Initialize DataTables for each tab
            function initializeDataTables() {
                ['neraca_lajur', 'mutasi', 'neraca', 'neraca_baru', 'laba_rugi', 'periode'].forEach(function(
                    tabName) {
                    const tableId = '#table_' + tabName;
                    if ($(tableId).length && !$.fn.DataTable.isDataTable(tableId)) {
                        $(tableId).DataTable({
                            searching: true,
                            dom: 'lrtip',
                            paging: true,
                            info: true,
                            autoWidth: false,
                            pageLength: 10,
                            language: {
                                paginate: {
                                    previous: 'Previous',
                                    next: 'Next'
                                }
                            }
                        });
                    }
                });
            }

            /* ── Tree toggle ─────────────────────────────────────── */
            $(document).on('click', 'td.coa-toggle', function(e) {
                e.stopPropagation();
                var rowId = $(this).data('coaId');
                var icon = $(this).find('i');
                var parentRow = $(this).closest('tr');
                var childRows = $('tr[data-parent="' + rowId + '"]');

                if (childRows.first().is(':visible')) {
                    collapseChildren(rowId);
                    icon.removeClass('fa-chevron-down').addClass('fa-chevron-right');
                } else {
                    var last = parentRow;
                    childRows.each(function() {
                        var ch = $(this);
                        ch.insertAfter(last);
                        ch.show();
                        last = ch;
                    });
                    icon.removeClass('fa-chevron-right').addClass('fa-chevron-down');
                }
            });

            function collapseChildren(parentId) {
                $('tr[data-parent="' + parentId + '"]').each(function() {
                    var childId = $(this).data('id');
                    $(this).hide();
                    $('td.coa-toggle[data-coa-id="' + childId + '"]').find('i').removeClass(
                        'fa-chevron-down').addClass('fa-chevron-right');
                    collapseChildren(childId);
                });
            }

            /* ── Expand all children ─────────────────────────────── */
            function expandAll() {
                $('tr[data-id]').show();
                $('.coa-toggle i').removeClass('fa-chevron-right').addClass('fa-chevron-down');
            }

            /* ── Search ──────────────────────────────────────────── */
            $('#coa-search').on('input', function() {
                var search = $(this).val().toLowerCase();

                // Determine the active tab
                var activeTabButton = document.querySelector('#reportTabs button.active');
                var activeTabId = activeTabButton ? activeTabButton.getAttribute('data-bs-target') : null;

                if (activeTabId === '#neraca-lajur-content') {
                    // --- NERACA LAJUR SEARCH ---
                    if (search === '') {
                        $('#neraca-lajur-table tbody tr[data-id]').each(function() {
                            $(this).data('parent') ? $(this).hide() : $(this).show();
                        });
                        $('#neraca-lajur-table i.neraca-toggle').removeClass('fa-chevron-down').addClass(
                            'fa-chevron-right');
                    } else {
                        // Hide all rows initially
                        $('#neraca-lajur-table tbody tr[data-id]').hide();

                        // Show matching rows and their ancestors
                        $('#neraca-lajur-table tbody tr[data-id]').each(function() {
                            var row = $(this);
                            var coaId = row.find('.coa-id').text().toLowerCase();
                            var coaNama = row.find('.coa-nama').text().toLowerCase();
                            if (coaId.includes(search) || coaNama.includes(search)) {
                                row.show();
                                showNeracaLajurAncestors(row);
                            }
                        });
                    }
                } else if (activeTabId === '#mutasi-content') {
                    // --- MUTASI SEARCH ---
                    $('#mutasi-table tbody tr').each(function() {
                        var row = $(this);
                        var rowText = row.text().toLowerCase();
                        if (search === '' || rowText.includes(search)) {
                            row.show();
                        } else {
                            row.hide();
                        }
                    });
                } else if (activeTabId === '#neraca-content') {
                    // --- NERACA SEARCH ---
                    if (search === '') {
                        // Reset to default view
                        $('#neraca-comparison-table tbody tr').each(function() {
                            var row = $(this);
                            var targetSection = row.attr('data-target-section');
                            if (targetSection) {
                                // Section header
                                row.show();
                                row.find('.section-toggle-icon').removeClass('fa-chevron-down')
                                    .addClass('fa-chevron-right');
                            } else if (row.attr('data-neraca-id')) {
                                // Data row
                                row.hide();
                                row.find('i.neraca-toggle').removeClass('fa-chevron-down').addClass(
                                    'fa-chevron-right');
                            } else {
                                // Other layout / total rows
                                row.show();
                            }
                        });
                    } else {
                        // Hide all details rows and section headers first
                        $('#neraca-comparison-table tbody tr[data-neraca-id]').hide();
                        $('#neraca-comparison-table tbody tr.section-header-toggle').hide();

                        // Keep layout/total rows hidden too, unless they match
                        $('#neraca-comparison-table tbody tr').not(
                            '[data-neraca-id], .section-header-toggle').hide();

                        $('#neraca-comparison-table tbody tr').each(function() {
                            var row = $(this);
                            var rowText = row.text().toLowerCase();

                            if (row.attr('data-neraca-id')) {
                                if (rowText.includes(search)) {
                                    row.show();
                                    showNeracaAncestors(row);
                                }
                            } else {
                                // Plain header/total layout rows
                                if (rowText.includes(search)) {
                                    row.show();
                                }
                            }
                        });
                    }
                } else if (activeTabId === '#laba-rugi-content') {
                    // --- LABA RUGI SEARCH ---
                    if (search === '') {
                        // Reset to default view
                        $('#table_laba_rugi_mockup tbody tr').each(function() {
                            var row = $(this);
                            var dataId = row.attr('data-id');
                            if (dataId) {
                                if (dataId.startsWith('lr-field-')) {
                                    row.show();
                                    row.find('i.neraca-toggle').removeClass('fa-chevron-right')
                                        .addClass('fa-chevron-down');
                                } else {
                                    var parentId = row.attr('data-parent');
                                    if (parentId && parentId.startsWith('lr-field-')) {
                                        row.show();
                                        row.find('i.neraca-toggle').removeClass('fa-chevron-down')
                                            .addClass('fa-chevron-right');
                                    } else {
                                        row.hide();
                                        row.find('i.neraca-toggle').removeClass('fa-chevron-down')
                                            .addClass('fa-chevron-right');
                                    }
                                }
                            } else {
                                row.show();
                            }
                        });
                    } else {
                        // Hide all rows initially
                        $('#table_laba_rugi_mockup tbody tr').hide();

                        $('#table_laba_rugi_mockup tbody tr').each(function() {
                            var row = $(this);
                            var rowText = row.text().toLowerCase();
                            if (rowText.includes(search)) {
                                row.show();
                                showLabaRugiAncestors(row);
                            }
                        });
                    }
                } else if (activeTabId === '#periode-content') {
                    // --- PERIODE (TUTUP BUKU) SEARCH ---
                    if ($.fn.DataTable.isDataTable('#table_periode')) {
                        var table = $('#table_periode').DataTable();
                        table.search(search).draw();
                    }
                }
            });

            // Ancestor visibility helpers
            function showNeracaLajurAncestors(row) {
                var parentId = row.attr('data-parent');
                if (parentId) {
                    var parentRow = $('#neraca-lajur-table tr[data-id="' + parentId + '"]');
                    if (parentRow.length) {
                        parentRow.show();
                        parentRow.find('i.neraca-toggle').removeClass('fa-chevron-right').addClass(
                            'fa-chevron-down');
                        showNeracaLajurAncestors(parentRow);
                    }
                }
            }

            function showNeracaAncestors(row) {
                var parentId = row.attr('data-neraca-parent');
                if (parentId) {
                    var parentRow = $('#neraca-comparison-table tr[data-neraca-id="' + parentId + '"]');
                    if (parentRow.length) {
                        parentRow.show();
                        parentRow.find('i.neraca-toggle').removeClass('fa-chevron-right').addClass(
                            'fa-chevron-down');
                        showNeracaAncestors(parentRow);
                    }
                }
                var sectionId = row.attr('data-neraca-section');
                if (sectionId) {
                    var sectionHeader = $('#neraca-comparison-table tr[data-target-section="' + sectionId + '"]');
                    if (sectionHeader.length) {
                        sectionHeader.show();
                        sectionHeader.find('.section-toggle-icon').removeClass('fa-chevron-right').addClass(
                            'fa-chevron-down');
                    }
                }
            }

            function showLabaRugiAncestors(row) {
                var parentId = row.attr('data-parent');
                if (parentId) {
                    var parentRow = $('#table_laba_rugi_mockup tr[data-id="' + parentId + '"]');
                    if (parentRow.length) {
                        parentRow.show();
                        parentRow.find('i.neraca-toggle').removeClass('fa-chevron-right').addClass(
                            'fa-chevron-down');
                        showLabaRugiAncestors(parentRow);
                    }
                }
            }

            /* ── Collect visible rows and headers dynamically from active table DOM ── */
            function getActiveTableData() {
                var activeTab = document.querySelector('.tab-pane.active');
                if (!activeTab) return {
                    headers: [],
                    rows: []
                };

                var table = activeTab.querySelector('table');
                if (!table) return {
                    headers: [],
                    rows: []
                };

                // Get headers
                var headers = [];
                var headerRows = table.querySelectorAll('thead tr');
                if (headerRows.length === 2) {
                    // Specific logic for Neraca Lajur headers
                    headers = [
                        'No. COA', 'Chart of Account',
                        'Saldo Awal Debet', 'Saldo Awal Kredit',
                        'Mutasi Debet', 'Mutasi Kredit',
                        'AJE Debet', 'AJE Kredit',
                        'Saldo Akhir Debet', 'Saldo Akhir Kredit'
                    ];
                } else if (headerRows.length === 1) {
                    var ths = headerRows[0].querySelectorAll('th');
                    ths.forEach(function(th) {
                        headers.push(th.textContent.trim());
                    });
                }

                // Get row data
                var rows = [];
                var bodyRows = table.querySelectorAll('tbody tr');
                bodyRows.forEach(function(tr) {
                    var tds = tr.querySelectorAll('td');
                    // Skip the placeholder rows (like "Silakan pilih periode untuk melihat data" or "Tidak ada data...")
                    if (tds.length === 1 && tds[0].hasAttribute('colspan')) {
                        var textLower = tds[0].textContent.toLowerCase();
                        if (textLower.includes('pilih') || textLower.includes('tidak ada') || textLower
                            .includes('ditemukan') || textLower.includes('kosong') || textLower.includes(
                                'template untuk')) {
                            return;
                        }
                    }
                    var rowData = [];
                    tds.forEach(function(td) {
                        var text = td.textContent.trim().replace(/\s+/g, ' ');
                        rowData.push(text);
                    });
                    if (rowData.length > 0) {
                        rows.push(rowData);
                    }
                });

                // Remove Action column if present (useful for Tutup Buku tab)
                if (headers.length > 0 && (headers[headers.length - 1] === 'Action' || headers[headers.length -
                        1] === 'Aksi')) {
                    headers.pop();
                    rows.forEach(function(row) {
                        row.pop();
                    });
                }

                return {
                    headers: headers,
                    rows: rows
                };
            }

            function getExportTitle() {
                var activeTabButton = document.querySelector('#reportTabs button.active');
                var tabName = activeTabButton ? activeTabButton.innerText.trim() : 'Laporan';
                return tabName + ' - ' + new Date().toLocaleDateString('id-ID');
            }

            /* ── Financial Table Parser & Number Parser ──────────────── */
            /* ── Financial Table Parser & Number Parser ──────────────── */
            function parseIndonesianNumber(str) {
                if (!str) return 0;
                var cleaned = str.trim().replace(/[\u200B-\u200D\uFEFF]/g, ''); // strip zero-width spaces
                cleaned = cleaned.replace(/\s+/g, ''); // strip all spaces

                if (cleaned === '0,00' || cleaned === '0.00' || cleaned === '0' || cleaned === '-' || cleaned ===
                    '') return 0;

                var isNegative = false;
                if (cleaned.startsWith('(') && cleaned.endsWith(')')) {
                    isNegative = true;
                    cleaned = cleaned.substring(1, cleaned.length - 1);
                } else if (cleaned.startsWith('-')) {
                    isNegative = true;
                    cleaned = cleaned.substring(1);
                }

                // Determine if Indonesian or US format
                var lastComma = cleaned.lastIndexOf(',');
                var lastDot = cleaned.lastIndexOf('.');

                if (lastComma > lastDot) {
                    // Indonesian format: 12.345,67 -> remove dots, replace comma with dot
                    cleaned = cleaned.replace(/\./g, '').replace(/,/g, '.');
                } else if (lastDot > lastComma) {
                    // US format: 12,345.67 -> remove commas
                    cleaned = cleaned.replace(/,/g, '');
                } else {
                    // No comma or dot, or they are not both present
                    // If there is a comma, replace it with dot
                    cleaned = cleaned.replace(/,/g, '.');
                }

                var val = parseFloat(cleaned);
                if (isNaN(val)) return null;
                return isNegative ? -val : val;
            }

            function parseFinancialTable(tableId) {
                var table = document.querySelector(tableId);
                if (!table) return null;

                var headers = [];
                if (tableId === '#neraca-lajur-table') {
                    headers = [
                        'No. COA', 'Chart of Account',
                        'Saldo Awal Debet', 'Saldo Awal Kredit',
                        'Mutasi Debet', 'Mutasi Kredit',
                        'AJE Debet', 'AJE Kredit',
                        'Saldo Akhir Debet', 'Saldo Akhir Kredit'
                    ];
                } else if (tableId === '#mutasi-table') {
                    headers = ['Tgl', 'COA', 'Nama COA', 'Keterangan', 'Debet', 'Kredit', 'Saldo'];
                } else {
                    var ths = table.querySelectorAll('thead th');
                    ths.forEach(function(th) {
                        headers.push(th.textContent.trim());
                    });
                }

                var rows = [];
                var bodyRows = table.querySelectorAll('tbody tr');
                bodyRows.forEach(function(tr) {
                    var tds = tr.querySelectorAll('td');

                    if (tds.length === 1 && tds[0].getAttribute('colspan') && (tds[0].style.height || tds[0]
                            .style.height === '6px')) {
                        rows.push({
                            type: 'spacer'
                        });
                        return;
                    }

                    if (tds.length === 1 && tds[0].hasAttribute('colspan')) {
                        var textLower = tds[0].textContent.toLowerCase();
                        if (textLower.includes('pilih') || textLower.includes('tidak ada') || textLower
                            .includes('ditemukan') || textLower.includes('kosong') || textLower.includes(
                                'template untuk')) {
                            return;
                        }
                    }

                    var cells = [];
                    tds.forEach(function(td) {
                        cells.push(td.textContent.trim().replace(/\s+/g, ' '));
                    });

                    if (cells.length === 0) return;

                    var isGroupHeader = false;
                    var isSubtotal = false;
                    var isFinal = false;
                    var isDetail = false;
                    var depth = 0;

                    var firstCell = tr.querySelector('td');
                    var trStyle = tr.getAttribute('style') || '';
                    var trClass = tr.getAttribute('class') || '';
                    var trId = tr.getAttribute('data-id') || tr.getAttribute('data-neraca-id') || '';

                    var bgColor = firstCell ? window.getComputedStyle(firstCell).backgroundColor : '';
                    var isNegative = bgColor.includes('252, 234, 234') || bgColor.includes('fceaea') ||
                        bgColor.includes('FCEAEA');

                    if (tableId === '#table_laba_rugi_mockup') {
                        if (trId.startsWith('lr-field-')) {
                            var nameVal = cells[1] || cells[0] || '';
                            if (trId === 'lr-field-total' || nameVal.toLowerCase().includes(
                                    'laba / rugi') || nameVal.toLowerCase().includes('laba/rugi')) {
                                isFinal = true;
                            } else if (bgColor.includes('234, 252, 234') || (firstCell && (firstCell
                                    .classList.contains('font-weight-bold') || firstCell.classList
                                    .contains('font-weight-bolder') || (tr.querySelector(
                                        'td:nth-child(2)') && (tr.querySelector('td:nth-child(2)')
                                        .classList.contains('font-weight-bold') || tr.querySelector(
                                            'td:nth-child(2)').classList.contains(
                                            'font-weight-bolder')))) && nameVal.toLowerCase().includes(
                                    'total'))) {
                                isSubtotal = true;
                            } else {
                                isGroupHeader = true;
                            }
                        } else if (trId.startsWith('lr-')) {
                            isDetail = true;
                            var div = tr.querySelector('td div');
                            if (div) {
                                var pad = parseInt(window.getComputedStyle(div).paddingLeft) || 10;
                                depth = Math.round((pad - 10) / 24);
                            }
                        }
                    } else if (tableId === '#neraca-comparison-table') {
                        var trBg = window.getComputedStyle(tr).backgroundColor;
                        if (trClass.includes('section-header-toggle') || trStyle.includes('#eff3f8') || trBg
                            .includes('239, 243, 248')) {
                            isGroupHeader = true;
                        } else if (trStyle.includes('#3d8b8b') || trBg.includes('61, 139, 139')) {
                            isSubtotal = true;
                        } else if (trId) {
                            isDetail = true;
                            var div = tr.querySelector('td div');
                            if (div) {
                                var pad = parseInt(window.getComputedStyle(div).paddingLeft) || 0;
                                depth = Math.round(pad / 24);
                            }
                        }
                    } else if (tableId === '#neraca-lajur-table') {
                        if (trId === 'total-neraca' || trId === 'total-laba-rugi') {
                            isSubtotal = true;
                        } else if (trId) {
                            var hasChildren = tr.querySelector('.neraca-toggle') !== null;
                            if (hasChildren) {
                                isGroupHeader = true;
                            } else {
                                isDetail = true;
                            }
                            var div = tr.querySelector('td div');
                            if (div) {
                                var pad = parseInt(div.style.paddingLeft || parseInt(window
                                    .getComputedStyle(div).paddingLeft)) || 0;
                                depth = Math.round(pad / 24);
                            }
                        }
                    } else if (tableId === '#mutasi-table') {
                        var isSaldoAwal = cells[3] && cells[3].toLowerCase() === 'saldo awal';
                        if (isSaldoAwal) {
                            isSubtotal = true;
                        } else {
                            isDetail = true;
                        }
                    }

                    rows.push({
                        type: isFinal ? 'final' : (isSubtotal ? 'subtotal' : (isGroupHeader ?
                            'group' : 'detail')),
                        cells: cells,
                        depth: depth,
                        bgColor: bgColor,
                        isNegative: isNegative
                    });
                });

                return {
                    headers: headers,
                    rows: rows
                };
            }

            /* ── Excel export ────────────────────────────────────── */
            function getNeracaBaruTables(activeTab) {
                var blocks = [];
                if (!activeTab) return blocks;

                activeTab.querySelectorAll('.neraca-baru-table').forEach(function(table) {
                    var wrapper = table.closest('.mb-4') || table.parentElement;
                    var heading = [];
                    if (wrapper) {
                        wrapper.querySelectorAll('.text-center.mb-2 h5, .text-center.mb-2 div').forEach(
                            function(el) {
                                var text = el.textContent.trim().replace(/\s+/g, ' ');
                                if (text) heading.push(text);
                            });
                    }

                    var rows = [];
                    table.querySelectorAll('tr').forEach(function(tr) {
                        var cells = [];
                        var visualCol = 0;
                        tr.querySelectorAll('th, td').forEach(function(cell) {
                            var colspan = parseInt(cell.getAttribute('colspan') || '1', 10);
                            var text = cell.textContent.trim().replace(/\s+/g, ' ');
                            var classes = cell.className || '';
                            var isAmount = classes.includes('neraca-baru-amount') || classes
                                .includes('neraca-baru-column-title-saldo') || visualCol ===
                                1 || visualCol === 3;
                            var type = 'detail';

                            if (classes.includes('neraca-baru-side-title')) {
                                type = 'side-title';
                            } else if (classes.includes('neraca-baru-column-title')) {
                                type = 'column-title';
                            } else if (classes.includes('neraca-baru-cell-section')) {
                                type = 'section';
                            } else if (classes.includes('neraca-baru-cell-grand')) {
                                type = 'grand';
                            } else if (classes.includes('neraca-baru-cell-total')) {
                                type = 'total';
                            } else if (classes.includes('neraca-baru-empty')) {
                                type = 'empty';
                            }

                            cells.push({
                                text: text,
                                colspan: colspan,
                                column: visualCol,
                                isAmount: isAmount,
                                negative: classes.includes('text-danger') ||
                                    /^\(.+\)$/.test(text),
                                type: type
                            });
                            visualCol += colspan;
                        });
                        if (cells.length) rows.push(cells);
                    });

                    blocks.push({
                        heading: heading,
                        rows: rows
                    });
                });

                return blocks;
            }

            function showNoNeracaBaruDataMessage(actionText) {
                Swal.fire({
                    title: 'Info',
                    text: 'Tidak ada data untuk ' + actionText,
                    icon: 'info',
                    confirmButtonColor: '#028284'
                });
            }

            function getNeracaBaruExcelStyle(cell) {
                var style = {
                    font: {
                        name: 'Arial',
                        sz: 10,
                        color: {
                            rgb: '2F3E46'
                        }
                    },
                    alignment: {
                        vertical: 'center',
                        horizontal: cell.isAmount ? 'right' : 'left'
                    },
                    border: {
                        top: {
                            style: 'thin',
                            color: {
                                rgb: 'A7D6D6'
                            }
                        },
                        bottom: {
                            style: 'thin',
                            color: {
                                rgb: 'A7D6D6'
                            }
                        },
                        left: {
                            style: 'thin',
                            color: {
                                rgb: 'A7D6D6'
                            }
                        },
                        right: {
                            style: 'thin',
                            color: {
                                rgb: 'A7D6D6'
                            }
                        }
                    }
                };

                if (cell.type === 'side-title' || cell.type === 'column-title') {
                    style.font.bold = true;
                    style.fill = {
                        patternType: 'solid',
                        fgColor: {
                            rgb: 'B0E9EB'
                        }
                    };
                    style.alignment.horizontal = cell.type === 'side-title' ? 'center' : (cell.isAmount ? 'right' :
                        'left');
                } else if (cell.type === 'section') {
                    style.font.bold = true;
                    style.fill = {
                        patternType: 'solid',
                        fgColor: {
                            rgb: 'EFF3F8'
                        }
                    };
                    style.alignment.horizontal = 'center';
                } else if (cell.type === 'total' || cell.type === 'grand') {
                    style.font.bold = true;
                    style.fill = {
                        patternType: 'solid',
                        fgColor: {
                            rgb: 'EAFCEA'
                        }
                    };
                }

                if (cell.negative && cell.isAmount) {
                    style.font.color = {
                        rgb: 'DC3545'
                    };
                }

                return style;
            }

            function exportNeracaBaruExcel(activeTab) {
                var blocks = getNeracaBaruTables(activeTab);
                if (!blocks.length) {
                    showNoNeracaBaruDataMessage('diekspor');
                    return;
                }

                var title = getExportTitle();
                var wb = XLSX.utils.book_new();
                var ws = {};
                var merges = [];
                var rowIdx = 0;

                blocks.forEach(function(block, blockIdx) {
                    if (blockIdx > 0) rowIdx += 2;

                    block.heading.forEach(function(text, headingIdx) {
                        var cellRef = XLSX.utils.encode_cell({
                            r: rowIdx,
                            c: 0
                        });
                        ws[cellRef] = {
                            v: text,
                            t: 's',
                            s: {
                                font: {
                                    name: 'Arial',
                                    sz: headingIdx === 0 ? 13 : 10,
                                    bold: headingIdx < 2,
                                    color: {
                                        rgb: headingIdx === 0 ? '028284' : '2F3E46'
                                    }
                                },
                                alignment: {
                                    horizontal: 'center'
                                }
                            }
                        };
                        merges.push({
                            s: {
                                r: rowIdx,
                                c: 0
                            },
                            e: {
                                r: rowIdx,
                                c: 3
                            }
                        });
                        rowIdx++;
                    });

                    if (block.heading.length) rowIdx++;

                    block.rows.forEach(function(row) {
                        var colIdx = 0;
                        row.forEach(function(cell) {
                            var cellRef = XLSX.utils.encode_cell({
                                r: rowIdx,
                                c: colIdx
                            });
                            var numericValue = null;
                            if (cell.isAmount && cell.type !== 'side-title' && cell.type !==
                                'column-title' && cell.text !== '') {
                                numericValue = parseIndonesianNumber(cell.text);
                            }
                            ws[cellRef] = numericValue !== null ? {
                                v: numericValue,
                                t: 'n',
                                z: '#,##0.00;(#,##0.00);"-"',
                                s: getNeracaBaruExcelStyle(cell)
                            } : {
                                v: cell.text,
                                t: 's',
                                s: getNeracaBaruExcelStyle(cell)
                            };

                            if (cell.colspan > 1) {
                                merges.push({
                                    s: {
                                        r: rowIdx,
                                        c: colIdx
                                    },
                                    e: {
                                        r: rowIdx,
                                        c: colIdx + cell.colspan - 1
                                    }
                                });
                            }
                            colIdx += cell.colspan;
                        });
                        rowIdx++;
                    });
                });

                ws['!merges'] = merges;
                ws['!cols'] = [{
                    wch: 38
                }, {
                    wch: 18
                }, {
                    wch: 38
                }, {
                    wch: 18
                }];
                ws['!ref'] = XLSX.utils.encode_range({
                    s: {
                        r: 0,
                        c: 0
                    },
                    e: {
                        r: Math.max(rowIdx - 1, 0),
                        c: 3
                    }
                });

                XLSX.utils.book_append_sheet(wb, ws, 'Report');
                XLSX.writeFile(wb, title + '.xlsx');
            }

            function getNeracaBaruPdfStyle(cell) {
                var style = {
                    textColor: [47, 62, 70],
                    lineColor: [167, 214, 214],
                    lineWidth: 0.1,
                    halign: cell.isAmount ? 'right' : 'left'
                };

                if (cell.type === 'side-title' || cell.type === 'column-title') {
                    style.fillColor = [176, 233, 235];
                    style.fontStyle = 'bold';
                    if (cell.type === 'side-title') style.halign = 'center';
                } else if (cell.type === 'section') {
                    style.fillColor = [239, 243, 248];
                    style.fontStyle = 'bold';
                    style.halign = 'center';
                } else if (cell.type === 'total' || cell.type === 'grand') {
                    style.fillColor = [234, 252, 234];
                    style.fontStyle = 'bold';
                }

                if (cell.negative && cell.isAmount) {
                    style.textColor = [220, 53, 69];
                }

                return style;
            }

            function exportNeracaBaruPdf(activeTab) {
                var blocks = getNeracaBaruTables(activeTab);
                if (!blocks.length) {
                    showNoNeracaBaruDataMessage('diekspor');
                    return;
                }

                var title = getExportTitle();
                var {
                    jsPDF
                } = window.jspdf;
                var doc = new jsPDF({
                    orientation: 'landscape'
                });
                var startY = 15;

                blocks.forEach(function(block, blockIdx) {
                    if (blockIdx > 0 && startY > 160) {
                        doc.addPage();
                        startY = 15;
                    }

                    block.heading.forEach(function(text, headingIdx) {
                        doc.setFontSize(headingIdx === 0 ? 12 : 9);
                        doc.setFont(undefined, headingIdx < 2 ? 'bold' : 'normal');
                        doc.text(text, doc.internal.pageSize.getWidth() / 2, startY, {
                            align: 'center'
                        });
                        startY += headingIdx === 0 ? 5 : 4;
                    });
                    startY += 3;

                    var body = block.rows.map(function(row) {
                        return row.map(function(cell) {
                            return {
                                content: cell.text,
                                colSpan: cell.colspan,
                                styles: getNeracaBaruPdfStyle(cell)
                            };
                        });
                    });

                    doc.autoTable({
                        startY: startY,
                        body: body,
                        theme: 'grid',
                        margin: {
                            left: 14,
                            right: 14
                        },
                        tableWidth: 'auto',
                        styles: {
                            fontSize: 8,
                            cellPadding: 2.2,
                            overflow: 'linebreak'
                        },
                        columnStyles: {
                            0: {
                                cellWidth: 93
                            },
                            1: {
                                cellWidth: 45,
                                halign: 'right'
                            },
                            2: {
                                cellWidth: 93
                            },
                            3: {
                                cellWidth: 45,
                                halign: 'right'
                            }
                        }
                    });

                    startY = (doc.lastAutoTable ? doc.lastAutoTable.finalY : startY) + 10;
                });

                doc.save(title + '.pdf');
            }

            function exportNeracaBaruPrint(activeTab) {
                var blocks = activeTab ? activeTab.querySelectorAll('.mb-4 .neraca-baru-table') : [];
                if (!blocks.length) {
                    showNoNeracaBaruDataMessage('dicetak');
                    return;
                }

                var title = getExportTitle();
                var reportHtml = Array.from(blocks).map(function(table) {
                    var wrapper = table.closest('.mb-4') || table.parentElement;
                    return wrapper ? wrapper.outerHTML : table.outerHTML;
                }).join('');

                var html = `
                    <html>
                        <head>
                            <title>${title}</title>
                            <style>
                                body { font-family: Arial, sans-serif; font-size: 12px; margin: 20px; color: #2f3e46; }
                                .mb-4 { margin-bottom: 24px; page-break-inside: avoid; }
                                .text-center { text-align: center; }
                                .mb-0 { margin-bottom: 0; }
                                .mb-2 { margin-bottom: 8px; }
                                .text-dark { color: #2f3e46; }
                                .font-weight-bolder, .font-weight-bold { font-weight: 800; }
                                .text-sm { font-size: 12px; }
                                .neraca-baru-table-wrap { width: 100%; border: 1px solid #a7d6d6; border-radius: 0; overflow: visible; }
                                .neraca-baru-table { width: 100%; border-collapse: collapse; font-size: 12px; color: #2f3e46; background: #ffffff; -webkit-print-color-adjust: exact; print-color-adjust: exact; }
                                .neraca-baru-table th, .neraca-baru-table td { border: 1px solid #a7d6d6; padding: 7px 10px; vertical-align: middle; }
                                .neraca-baru-side-title, .neraca-baru-column-title { background: #b0e9eb; color: #2f3e46; font-weight: 800; }
                                .neraca-baru-side-title { text-align: center; font-size: 14px; }
                                .neraca-baru-column-title { text-transform: uppercase; }
                                .neraca-baru-column-title-saldo, .neraca-baru-amount { text-align: right; white-space: nowrap; }
                                .neraca-baru-cell-section { background: #eff3f8; color: #2f3e46; font-weight: 800; text-align: center; text-transform: uppercase; }
                                .neraca-baru-cell-total, .neraca-baru-cell-grand { background: #eafcea; color: #2f3e46; font-weight: 800; }
                                .neraca-baru-amount.text-danger { color: #dc3545 !important; }
                                .neraca-baru-empty { background: #ffffff; }
                            </style>
                        </head>
                        <body>${reportHtml}</body>
                    </html>`;

                var w = window.open('', '_blank');
                w.document.write(html);
                w.document.close();
                w.focus();
                w.print();
                w.close();
            }
            $('#btn-export-excel').on('click', function() {
                var activeTabButton = document.querySelector('#reportTabs button.active');
                var activeTabId = activeTabButton ? activeTabButton.getAttribute('data-bs-target') : null;
                var activeTab = activeTabId ? document.querySelector(activeTabId) : null;
                if (activeTab && activeTab.id === 'neraca-baru-content') {
                    exportNeracaBaruExcel(activeTab);
                    return;
                }
                var isFinancial = activeTab && (activeTab.id === 'laba-rugi-content' || activeTab.id ===
                    'neraca-content' || activeTab.id === 'neraca-lajur-content' || activeTab.id ===
                    'mutasi-content');

                if (isFinancial) {
                    var tableId = '#' + activeTab.querySelector('table').id;
                    var lrData = parseFinancialTable(tableId);
                    if (!lrData || lrData.rows.length === 0) {
                        Swal.fire({
                            title: 'Info',
                            text: 'Tidak ada data untuk diekspor',
                            icon: 'info',
                            confirmButtonColor: '#028284'
                        });
                        return;
                    }

                    var wb = XLSX.utils.book_new();
                    var ws = {};

                    var title = getExportTitle();
                    var startRow = activeTab.id === 'mutasi-content' ? 5 : 4;

                    var titleStyle = {
                        font: {
                            name: 'Arial',
                            sz: 14,
                            bold: true,
                            color: {
                                rgb: '028284'
                            }
                        }
                    };
                    var compStyle = {
                        font: {
                            name: 'Arial',
                            sz: 11,
                            bold: true
                        }
                    };
                    var periodStyle = {
                        font: {
                            name: 'Arial',
                            sz: 10,
                            italic: true
                        }
                    };

                    var titleText = 'Laporan Laba Rugi';
                    if (activeTab.id === 'neraca-content') {
                        titleText = 'Laporan Neraca';
                    } else if (activeTab.id === 'neraca-lajur-content') {
                        titleText = 'Laporan Neraca Lajur';
                    } else if (activeTab.id === 'mutasi-content') {
                        titleText = 'Laporan Mutasi';
                    }
                    ws['A1'] = {
                        v: titleText,
                        t: 's',
                        s: titleStyle
                    };
                    ws['A2'] = {
                        v: "{{ session('nama_perusahaan', 'PT MULTI SPUNINDO JAYA Tbk') }}",
                        t: 's',
                        s: compStyle
                    };

                    function formatIndoMonth(str) {
                        if (!str) return '';
                        var parts = str.split('-');
                        if (parts.length < 2) return str;
                        var year = parts[0];
                        var monthIndex = parseInt(parts[1], 10) - 1;
                        var months = ['Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli',
                            'Agustus', 'September', 'Oktober', 'November', 'Desember'
                        ];
                        return (months[monthIndex] || '') + ' ' + year;
                    }

                    var periodText = '';
                    if (activeTab.id === 'laba-rugi-content') {
                        periodText = 'Untuk Periode: ' + (document.querySelector(
                            '#laba-rugi-content .text-end p.text-xs span')?.textContent || '');
                    } else if (activeTab.id === 'neraca-content') {
                        periodText = 'Periode: ' + (document.querySelector(
                            '#neraca-content .text-end p.text-xs span')?.textContent || '');
                    } else if (activeTab.id === 'neraca-lajur-content') {
                        var pVal = $('#periode-filter').val();
                        periodText = 'Periode: ' + (pVal ? formatIndoMonth(pVal) : '');
                    } else if (activeTab.id === 'mutasi-content') {
                        var pVal = $('#mutasi-periode-filter').val();
                        periodText = 'Periode: ' + (pVal ? formatIndoMonth(pVal) : '');
                    }
                    ws['A3'] = {
                        v: periodText,
                        t: 's',
                        s: periodStyle
                    };

                    if (activeTab.id === 'mutasi-content') {
                        var bankVal = $('#mutasi-bank-filter').val();
                        var bankText = bankVal ? 'Bank: ' + $('#mutasi-bank-filter option:selected').text()
                            .trim() : 'Bank: Semua Bank';
                        ws['A4'] = {
                            v: bankText,
                            t: 's',
                            s: periodStyle
                        };
                    }

                    var headerStyle = {
                        font: {
                            name: 'Arial',
                            sz: 10,
                            bold: true,
                            color: {
                                rgb: 'FFFFFF'
                            }
                        },
                        fill: {
                            patternType: 'solid',
                            fgColor: {
                                rgb: '028284'
                            }
                        },
                        alignment: {
                            horizontal: 'center',
                            vertical: 'center'
                        },
                        border: {
                            top: {
                                style: 'thin',
                                color: {
                                    rgb: '333333'
                                }
                            },
                            bottom: {
                                style: 'medium',
                                color: {
                                    rgb: '333333'
                                }
                            },
                            left: {
                                style: 'thin',
                                color: {
                                    rgb: 'E2E8F0'
                                }
                            },
                            right: {
                                style: 'thin',
                                color: {
                                    rgb: 'E2E8F0'
                                }
                            }
                        }
                    };

                    lrData.headers.forEach((h, colIdx) => {
                        var cellRef = XLSX.utils.encode_cell({
                            r: startRow,
                            c: colIdx
                        });
                        ws[cellRef] = {
                            v: h,
                            t: 's',
                            s: headerStyle
                        };
                    });

                    var currRowIdx = startRow + 1;

                    lrData.rows.forEach((row) => {
                        if (row.type === 'spacer') {
                            currRowIdx++;
                            return;
                        }

                        if (row.type === 'group' && currRowIdx > startRow + 1 && activeTab.id !==
                            'neraca-lajur-content') {
                            currRowIdx++;
                        }

                        row.cells.forEach((val, colIdx) => {
                            var cellRef = XLSX.utils.encode_cell({
                                r: currRowIdx,
                                c: colIdx
                            });

                            var isNum = false;
                            if (activeTab.id === 'neraca-lajur-content') {
                                isNum = colIdx > 1;
                            } else if (activeTab.id === 'laba-rugi-content') {
                                isNum = colIdx > 1;
                            } else if (activeTab.id === 'mutasi-content') {
                                isNum = colIdx > 3;
                            } else {
                                isNum = colIdx > 0;
                            }

                            var styleType = row.type;

                            var cellStyle = {
                                font: {
                                    name: 'Arial',
                                    sz: 10
                                },
                                alignment: {
                                    vertical: 'center',
                                    horizontal: isNum ? 'right' : 'left'
                                },
                                border: {
                                    top: {
                                        style: 'thin',
                                        color: {
                                            rgb: 'E2E8F0'
                                        }
                                    },
                                    bottom: {
                                        style: 'thin',
                                        color: {
                                            rgb: 'E2E8F0'
                                        }
                                    },
                                    left: {
                                        style: 'thin',
                                        color: {
                                            rgb: 'E2E8F0'
                                        }
                                    },
                                    right: {
                                        style: 'thin',
                                        color: {
                                            rgb: 'E2E8F0'
                                        }
                                    }
                                }
                            };

                            if (styleType === 'group') {
                                cellStyle.font.bold = true;
                                cellStyle.fill = {
                                    patternType: 'solid',
                                    fgColor: {
                                        rgb: 'EFF3F8'
                                    }
                                };
                            } else if (styleType === 'subtotal') {
                                cellStyle.font.bold = true;
                                if (activeTab.id === 'neraca-content') {
                                    cellStyle.fill = {
                                        patternType: 'solid',
                                        fgColor: {
                                            rgb: '3D8B8B'
                                        }
                                    };
                                    cellStyle.font.color = {
                                        rgb: 'FFFFFF'
                                    };
                                } else if (activeTab.id === 'neraca-lajur-content') {
                                    cellStyle.fill = {
                                        patternType: 'solid',
                                        fgColor: {
                                            rgb: 'D4F1F1'
                                        }
                                    };
                                } else if (activeTab.id === 'mutasi-content') {
                                    cellStyle.fill = {
                                        patternType: 'solid',
                                        fgColor: {
                                            rgb: 'F0F8F8'
                                        }
                                    };
                                } else {
                                    cellStyle.fill = {
                                        patternType: 'solid',
                                        fgColor: {
                                            rgb: 'EAFCEA'
                                        }
                                    };
                                }
                            } else if (styleType === 'final') {
                                cellStyle.font.bold = true;
                                var bgRgb = row.isNegative ? 'FCEAEA' : 'EAFCEA';
                                cellStyle.fill = {
                                    patternType: 'solid',
                                    fgColor: {
                                        rgb: bgRgb
                                    }
                                };
                                cellStyle.border.bottom = {
                                    style: 'double',
                                    color: {
                                        rgb: '333333'
                                    }
                                };
                            }

                            if (isNum) {
                                var num = parseIndonesianNumber(val);
                                if (num !== null) {
                                    ws[cellRef] = {
                                        v: num,
                                        t: 'n',
                                        z: '#,##0.00;(#,##0.00);"-"',
                                        s: cellStyle
                                    };
                                } else {
                                    ws[cellRef] = {
                                        v: val,
                                        t: 's',
                                        s: cellStyle
                                    };
                                }
                            } else {
                                var indentStr = '';
                                if (activeTab.id === 'neraca-lajur-content') {
                                    if (colIdx === 0 && (styleType === 'detail' ||
                                            styleType === 'group')) {
                                        indentStr = ' '.repeat(row.depth * 4);
                                    }
                                } else {
                                    if (styleType === 'detail' && (activeTab.id !==
                                            'laba-rugi-content' || colIdx === 1)) {
                                        indentStr = ' '.repeat((row.depth + 1) * 4);
                                    }
                                }
                                ws[cellRef] = {
                                    v: indentStr + val,
                                    t: 's',
                                    s: cellStyle
                                };
                            }
                        });
                        currRowIdx++;
                    });

                    var maxCol = lrData.headers.length - 1;
                    ws['!ref'] = XLSX.utils.encode_range({
                        s: {
                            r: 0,
                            c: 0
                        },
                        e: {
                            r: currRowIdx - 1,
                            c: maxCol
                        }
                    });

                    var colWidths = [];
                    for (var c = 0; c <= maxCol; c++) {
                        var maxLen = 10;
                        for (var r = startRow; r < currRowIdx; r++) {
                            var cellRef = XLSX.utils.encode_cell({
                                r: r,
                                c: c
                            });
                            var cell = ws[cellRef];
                            if (cell && cell.v) {
                                maxLen = Math.max(maxLen, cell.v.toString().length);
                            }
                        }
                        colWidths.push({
                            wch: Math.min(Math.max(maxLen + 3, 10), 60)
                        });
                    }
                    ws['!cols'] = colWidths;

                    XLSX.utils.book_append_sheet(wb, ws, 'Report');
                    XLSX.writeFile(wb, title + '.xlsx');
                    return;
                }

                var exportData = getActiveTableData();
                var headers = exportData.headers;
                var rows = exportData.rows;
                var title = getExportTitle();

                if (rows.length === 0) {
                    Swal.fire({
                        title: 'Info',
                        text: 'Tidak ada data untuk diekspor',
                        icon: 'info',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                var wb = XLSX.utils.book_new();
                var ws = {};

                // Write headers
                headers.forEach((h, colIdx) => {
                    var cellRef = XLSX.utils.encode_cell({
                        r: 0,
                        c: colIdx
                    });
                    ws[cellRef] = {
                        v: h,
                        t: 's',
                        s: {
                            font: {
                                name: 'Arial',
                                bold: true
                            }
                        }
                    };
                });

                // Write rows
                rows.forEach((row, rowIdx) => {
                    row.forEach((val, colIdx) => {
                        var cellRef = XLSX.utils.encode_cell({
                            r: rowIdx + 1,
                            c: colIdx
                        });

                        var isTextField = false;
                        var headerLower = (headers[colIdx] || '').toLowerCase();
                        if (colIdx === 0 || headerLower.includes('coa') || headerLower
                            .includes('nama') || headerLower.includes('keterangan') ||
                            headerLower.includes('tanggal') || headerLower.includes('no') ||
                            headerLower.includes('status') || headerLower.includes(
                                'aksi') || headerLower.includes('action')) {
                            isTextField = true;
                        }

                        if (!isTextField) {
                            var num = parseIndonesianNumber(val);
                            if (num !== null) {
                                ws[cellRef] = {
                                    v: num,
                                    t: 'n',
                                    z: '#,##0.00;(#,##0.00);"-"'
                                };
                            } else {
                                ws[cellRef] = {
                                    v: val,
                                    t: 's'
                                };
                            }
                        } else {
                            ws[cellRef] = {
                                v: val,
                                t: 's'
                            };
                        }
                    });
                });

                var maxCol = headers.length - 1;
                ws['!ref'] = XLSX.utils.encode_range({
                    s: {
                        r: 0,
                        c: 0
                    },
                    e: {
                        r: rows.length,
                        c: maxCol
                    }
                });

                var colWidths = headers.map((h, i) => {
                    var maxLen = Math.max(h.length, ...rows.map(r => (r[i] || '').toString()
                        .length));
                    return {
                        wch: Math.min(Math.max(maxLen + 3, 10), 50)
                    };
                });
                ws['!cols'] = colWidths;

                XLSX.utils.book_append_sheet(wb, ws, 'Report');
                XLSX.writeFile(wb, title + '.xlsx');
            });

            /* ── PDF export ──────────────────────────────────────── */
            $('#btn-export-pdf').on('click', function() {
                var activeTabButton = document.querySelector('#reportTabs button.active');
                var activeTabId = activeTabButton ? activeTabButton.getAttribute('data-bs-target') : null;
                var activeTab = activeTabId ? document.querySelector(activeTabId) : null;
                if (activeTab && activeTab.id === 'neraca-baru-content') {
                    exportNeracaBaruPdf(activeTab);
                    return;
                }
                var isFinancial = activeTab && (activeTab.id === 'laba-rugi-content' || activeTab.id ===
                    'neraca-content');

                if (isFinancial) {
                    var tableId = '#' + activeTab.querySelector('table').id;
                    var lrData = parseFinancialTable(tableId);
                    if (!lrData || lrData.rows.length === 0) {
                        Swal.fire({
                            title: 'Info',
                            text: 'Tidak ada data untuk diekspor',
                            icon: 'info',
                            confirmButtonColor: '#028284'
                        });
                        return;
                    }

                    var title = getExportTitle();
                    var {
                        jsPDF
                    } = window.jspdf;
                    var doc = new jsPDF({
                        orientation: 'landscape'
                    });

                    doc.setFontSize(14);
                    doc.text(title, 14, 15);

                    var body = [];
                    var rowStyles = [];
                    var rowDepths = [];

                    lrData.rows.forEach((row) => {
                        if (row.type === 'spacer') {
                            body.push(Array(lrData.headers.length).fill(''));
                            rowStyles.push('spacer');
                            rowDepths.push(0);
                            return;
                        }

                        if (row.type === 'group' && body.length > 0) {
                            body.push(Array(lrData.headers.length).fill(''));
                            rowStyles.push('spacer');
                            rowDepths.push(0);
                        }

                        body.push(row.cells);
                        rowStyles.push(row.type === 'final' && row.isNegative ? 'final-loss' : row
                            .type);
                        rowDepths.push(row.depth);
                    });

                    doc.autoTable({
                        startY: 20,
                        head: [lrData.headers],
                        body: body,
                        styles: {
                            fontSize: 8
                        },
                        headStyles: {
                            fillColor: [2, 130, 132]
                        },
                        didParseCell: function(data) {
                            if (data.row.section === 'head') {
                                return;
                            }
                            var rowType = rowStyles[data.row.index];
                            var depth = rowDepths[data.row.index];

                            var isRightAlign = data.column.index > 1;
                            if (isRightAlign) {
                                data.cell.styles.halign = 'right';
                            }

                            if (rowType === 'group') {
                                data.cell.styles.fontStyle = 'bold';
                                data.cell.styles.fillColor = [239, 243, 248];
                            } else if (rowType === 'subtotal') {
                                data.cell.styles.fontStyle = 'bold';
                                if (activeTab.id === 'neraca-content') {
                                    data.cell.styles.fillColor = [61, 139, 139];
                                    data.cell.styles.textColor = [255, 255, 255];
                                } else {
                                    data.cell.styles.fillColor = [234, 252, 234];
                                }
                            } else if (rowType === 'final') {
                                data.cell.styles.fontStyle = 'bold';
                                data.cell.styles.fillColor = [234, 252, 234];
                            } else if (rowType === 'final-loss') {
                                data.cell.styles.fontStyle = 'bold';
                                data.cell.styles.fillColor = [252, 234, 234];
                            } else if (rowType === 'spacer') {
                                data.cell.styles.fillColor = [255, 255, 255];
                                data.cell.styles.lineWidth = 0;
                            }

                            var targetIndentCol = 1;
                            if (data.column.index === targetIndentCol && rowType === 'detail') {
                                var currentPadding = data.cell.styles.cellPadding;
                                var leftPadding = 5 + ((depth + 1) * 8);
                                if (typeof currentPadding === 'object') {
                                    data.cell.styles.cellPadding = {
                                        top: currentPadding.top,
                                        bottom: currentPadding.bottom,
                                        left: leftPadding,
                                        right: currentPadding.right
                                    };
                                } else {
                                    data.cell.styles.cellPadding = {
                                        top: currentPadding,
                                        bottom: currentPadding,
                                        left: leftPadding,
                                        right: currentPadding
                                    };
                                }
                            }
                        }
                    });

                    doc.save(title + '.pdf');
                    return;
                }

                var exportData = getActiveTableData();
                var headers = exportData.headers;
                var rows = exportData.rows;
                var title = getExportTitle();

                if (rows.length === 0) {
                    Swal.fire({
                        title: 'Info',
                        text: 'Tidak ada data untuk diekspor',
                        icon: 'info',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                var {
                    jsPDF
                } = window.jspdf;
                var doc = new jsPDF({
                    orientation: 'landscape'
                });
                doc.setFontSize(13);
                doc.text(title, 14, 15);
                doc.autoTable({
                    startY: 20,
                    head: [headers],
                    body: rows,
                    styles: {
                        fontSize: 8
                    },
                    headStyles: {
                        fillColor: [0, 183, 189]
                    },
                    didParseCell: function(data) {
                        if (data.row.section === 'head') {
                            return;
                        }
                        if (data.column.index > 0) {
                            var rawText = Array.isArray(data.cell.text) ? data.cell.text.join(
                                ' ') : data.cell.text;
                            var cleanText = rawText ? rawText.trim() : '';
                            if (cleanText && cleanText !== '-' && parseIndonesianNumber(
                                    cleanText) !== null) {
                                data.cell.styles.halign = 'right';
                            }
                        }
                    }
                });
                doc.save(title + '.pdf');
            });

            /* ── Print ───────────────────────────────────────────── */
            $('#btn-print').on('click', function() {
                var activeTabButton = document.querySelector('#reportTabs button.active');
                var activeTabId = activeTabButton ? activeTabButton.getAttribute('data-bs-target') : null;
                var activeTab = activeTabId ? document.querySelector(activeTabId) : null;
                if (activeTab && activeTab.id === 'neraca-baru-content') {
                    exportNeracaBaruPrint(activeTab);
                    return;
                }
                var isFinancial = activeTab && (activeTab.id === 'laba-rugi-content' || activeTab.id ===
                    'neraca-content');

                if (isFinancial) {
                    var tableId = '#' + activeTab.querySelector('table').id;
                    var lrData = parseFinancialTable(tableId);
                    if (!lrData || lrData.rows.length === 0) {
                        Swal.fire({
                            title: 'Info',
                            text: 'Tidak ada data untuk dicetak',
                            icon: 'info',
                            confirmButtonColor: '#028284'
                        });
                        return;
                    }

                    var title = getExportTitle();
                    var rowsHtml = '';

                    var periodText = '';
                    if (activeTab.id === 'laba-rugi-content') {
                        periodText = 'Untuk Periode: ' + (document.querySelector(
                            '#laba-rugi-content .text-end p.text-xs span')?.textContent || '');
                    } else {
                        periodText = 'Periode: ' + (document.querySelector(
                            '#neraca-content .text-end p.text-xs span')?.textContent || '');
                    }

                    lrData.rows.forEach(function(row) {
                        if (row.type === 'spacer') {
                            rowsHtml += '<tr><td colspan="' + lrData.headers.length +
                                '" style="height: 12px; border: none; background-color: #ffffff;"></td></tr>';
                            return;
                        }

                        if (row.type === 'group' && rowsHtml !== '') {
                            rowsHtml += '<tr><td colspan="' + lrData.headers.length +
                                '" style="height: 12px; border: none; background-color: #ffffff;"></td></tr>';
                        }

                        var cols = row.cells.map(function(c, colIdx) {
                            var align = '';
                            var indent = '';
                            if (activeTab.id === 'laba-rugi-content') {
                                if (colIdx > 1) align = 'text-align: right;';
                                if (colIdx === 1 && row.type === 'detail') {
                                    indent = 'padding-left: ' + ((row.depth + 1) * 20) +
                                        'px;';
                                }
                            } else {
                                if (colIdx > 1) align = 'text-align: right;';
                                if (colIdx === 1 && row.type === 'detail') {
                                    indent = 'padding-left: ' + ((row.depth + 1) * 20) +
                                        'px;';
                                }
                            }
                            return '<td style="' + align + ' ' + indent + '">' + c +
                                '</td>';
                        }).join('');

                        var style = '';
                        if (row.type === 'group') {
                            style = 'font-weight: bold; background-color: #eff3f8; color: #2f3e46;';
                        } else if (row.type === 'subtotal') {
                            if (activeTab.id === 'neraca-content') {
                                style =
                                    'font-weight: bold; background-color: #3d8b8b; color: #ffffff;';
                            } else {
                                style =
                                    'font-weight: bold; background-color: #eafcea; color: #2f3e46;';
                            }
                        } else if (row.type === 'final') {
                            var finalColor = row.isNegative ? '#fceaea' : '#eafcea';
                            style = 'font-weight: bold; background-color: ' + finalColor +
                                '; color: #2f3e46;';
                        }

                        rowsHtml += '<tr style="' + style + '">' + cols + '</tr>';
                    });

                    var html = `
                        <html>
                            <head>
                                <title>${title}</title>
                                <style>
                                    body { font-family: Arial, sans-serif; font-size: 12px; margin: 20px; }
                                    table { border-collapse: collapse; width: 100%; -webkit-print-color-adjust: exact; print-color-adjust: exact; }
                                    th, td { border: 1px solid #cce3e3; padding: 8px 10px; text-align: left; }
                                    th { background: #028284; color: white; font-weight: bold; }
                                    .title { font-size: 16px; font-weight: bold; margin-bottom: 2px; color: #028284; }
                                    .company { font-size: 13px; font-weight: bold; margin-bottom: 2px; color: #333; }
                                    .period { font-size: 11px; font-style: italic; margin-bottom: 15px; color: #666; }
                                </style>
                            </head>
                            <body>
                                <div class="title">${activeTab.id === 'laba-rugi-content' ? 'Laporan Laba Rugi' : 'Laporan Neraca'}</div>
                                <div class="company">{{ session('nama_perusahaan', 'PT MULTI SPUNINDO JAYA Tbk') }}</div>
                                <div class="period">${periodText}</div>
                                <table>
                                    <thead><tr><th>${lrData.headers.join('</th><th>')}</th></tr></thead>
                                    <tbody>${rowsHtml}</tbody>
                                </table>
                            </body>
                        </html>`;

                    var w = window.open('', '_blank');
                    w.document.write(html);
                    w.document.close();
                    w.focus();
                    w.print();
                    w.close();
                    return;
                }

                var exportData = getActiveTableData();
                var headers = exportData.headers;
                var rows = exportData.rows;
                var title = getExportTitle();

                if (rows.length === 0) {
                    Swal.fire({
                        title: 'Info',
                        text: 'Tidak ada data untuk dicetak',
                        icon: 'info',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                var rowsHtml = rows.map(function(r) {
                    var cols = r.map(function(c, colIdx) {
                        var align = '';
                        if (colIdx > 0 && c && c !== '-' && parseIndonesianNumber(c) !==
                            null) {
                            align = 'text-align: right;';
                        }
                        return '<td style="' + align + '">' + c + '</td>';
                    }).join('');
                    return '<tr>' + cols + '</tr>';
                }).join('');

                var html = `
                    <html>
                        <head>
                            <title>${title}</title>
                            <style>
                                body { font-family: Arial, sans-serif; font-size: 12px; margin: 20px; }
                                table { border-collapse: collapse; width: 100%; }
                                th, td { border: 1px solid #ccc; padding: 6px 10px; text-align: left; }
                                th { background: #00b7bd4f; font-weight: bold; }
                                .title { margin-bottom: 20px; font-size: 16px; font-weight: bold; }
                            </style>
                        </head>
                        <body>
                            <div class="title">${title}</div>
                            <table>
                                <thead><tr><th>${headers.join('</th><th>')}</th></tr></thead>
                                <tbody>${rowsHtml}</tbody>
                            </table>
                        </body>
                    </html>`;

                var w = window.open('', '_blank');
                w.document.write(html);
                w.document.close();
                w.focus();
                w.print();
                w.close();
            });

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