@if(count($reportData) > 0)
    <style>
        /* General Table Styling */
        .ledger-table { width: 100% !important; border-collapse: collapse !important; table-layout: auto !important; }
        .ledger-table th, .ledger-table td { border: 1px solid #dee2e6 !important; padding: 8px 10px !important; font-size: 13px !important; color: #333 !important; vertical-align: middle !important; }
        .text-right { text-align: right !important; padding-right: 15px !important; }
        .text-center { text-align: center !important; }
        .branch-ref-no { text-align: left !important; white-space: nowrap !important; padding-left: 15px !important; min-width: 160px !important; }
        
        /* Interactive Search Box Styling */
        .search-box { border: 1px solid #00c292; border-radius: 20px; padding: 5px 15px; width: 100%; max-width: 350px; font-size: 13px; box-shadow: 0 2px 5px rgba(0,0,0,0.1); outline: none; transition: 0.3s;}
        .search-box:focus { box-shadow: 0 2px 8px rgba(0, 194, 146, 0.4); border-color: #00a67c; }

        @media print {
            body { -webkit-print-color-adjust: exact !important; }
            .ledger-table th { background-color: #00c292 !important; color: white !important; }
            .branch-ref-no { white-space: nowrap !important; } 
            .text-danger { color: #fb3a3a !important; }
            .hide-on-print { display: none !important; } 
        }
    </style>

    <div class="panel panel-info">
        <div class="panel-body" id="printableArea">
            

            
            <div class="row" style="margin-bottom: 10px;">
                <div class="col-md-6 col-xs-6">
                    <p><strong>Customer:</strong> {{ (isset($customer_id) && is_scalar($customer_id) && isset($customer[$customer_id])) ? $customer[$customer_id] : ($previousLedger->customer_name ?? 'N/A') }}</p>
                </div>
                <div class="col-md-6 col-xs-6 text-right">
                    <p><strong>From:</strong> {{ date('d-M-Y', strtotime($start_date)) }} <strong>To:</strong> {{ date('d-M-Y', strtotime($end_date)) }}</p>
                </div>
            </div>

            <div class="row hide-on-print" style="margin-bottom: 15px;">
                <div class="col-md-12">
                    <div class="pull-right">
                        <input type="text" id="ledgerSearchInput" class="search-box" placeholder="🔍 Search by Date, Ref No, or Amount...">
                    </div>
                </div>
            </div>

            <div class="table-responsive">
                <table class="table ledger-table" id="ledgerMainTable">
                    <thead>
                        <tr style="background-color: #00c292; color: white;">
                            <th class="text-center">S/L</th>
                            <th class="text-center">Date</th>
                            <th class="text-center">Particulars</th>
                            <th class="text-left" style="padding-left: 15px !important;">Branch-Ref NO</th>
                            <th class="text-center">Sales/Pur. Payment (Debit)</th>
                            <th class="text-center">Sales Return (Credit)</th>
                            <th class="text-center">Collection / Purchase (Credit)</th>
                            <th class="text-center">Due Balance</th>
                        </tr>
                    </thead>
                    <tbody>
                    @php
                        $totalDebit = $totalCredit = $totalReturn = $totalPurchase = $totalPurchasePayment = 0;
                        if(isset($previousLedger)) {
                            $previousTotalBill = $previousLedger->total_bill;
                            $previousPaymentAmount = $previousLedger->payment_amount;
                            $previousDue = $previousLedger->total_due + $customerOpeningDue;
                        } else {
                            $previousTotalBill = $previousPaymentAmount = $previousDue = 0;
                        }
                        $runningBalance = $previousDue;
                    @endphp

                    <tr style="background-color: #fcfcfc;">
                        <td colspan="4" class="text-left"><strong>Previous Ledger ({{ date('d-M-Y', strtotime($start_date)) }}):</strong></td>
                        <td class="text-right"><strong>{{ number_format($previousTotalBill, 2) }}</strong></td>
                        <td class="text-right">0.00</td>
                        <td class="text-right"><strong>{{ number_format($previousPaymentAmount, 2) }}</strong></td>
                        <td class="text-right"><strong>{{ number_format($previousDue, 2) }}</strong></td>
                    </tr>

                    @foreach($reportData as $value)
                        @php
                            $row_debit = 0; $row_credit = 0; $row_return = 0;

                            if($value->table_name == 'sales' || $value->table_name == 'purchase_payment') {
                                $row_debit = $value->amount;
                                $runningBalance += $row_debit;
                                if ($value->table_name == 'sales') $totalDebit += $row_debit;
                                else $totalPurchasePayment += $row_debit;
                            } 
                            else {
                                $row_credit = $value->amount;
                                $runningBalance -= $row_credit;
                                if($value->table_name == 'sale_return') {
                                    $row_return = $value->amount; $totalReturn += $row_return;
                                } elseif($value->table_name == 'purchase') {
                                    $totalPurchase += $value->amount;
                                } else {
                                    $totalCredit += $value->amount;
                                }
                            }

                            $branchCode = 'N/A';
                            if(!empty($value->branch_name) && $value->branch_name != 'N/A'){
                                $words = explode(' ', $value->branch_name);
                                $branchCode = '';
                                foreach($words as $w) { $branchCode .= strtoupper(substr($w, 0, 1)); }
                            }
                        @endphp
                        
                        <tr class="filterable-row">
                            <td class="text-center">{{ $loop->iteration }}</td>
                            <td class="text-center" style="white-space: nowrap;">{{ date('d-M-Y', strtotime($value->date)) }}</td>
                            <td>{{ ucwords(str_replace('_', ' ', $value->table_name)) }}</td>
                            <td class="branch-ref-no">{{ $branchCode }}-{{ $value->code }}</td>
                            <td class="text-right">{{ $row_debit > 0 ? number_format($row_debit, 2) : '' }}</td>
                            <td class="text-right">{{ $row_return > 0 ? number_format($row_return, 2) : '' }}</td>
                            <td class="text-right">{{ ($row_credit > 0 && $value->table_name != 'sale_return') ? number_format($row_credit, 2) : '' }}</td>
                            <td class="text-right"><strong>{{ number_format($runningBalance, 2) }}</strong></td>
                        </tr>
                    @endforeach
                    
                    <tr style="background-color: #f9f9f9; font-weight: bold;">
                        <td colspan="4" class="text-left"><strong>Final Ledger:</strong></td>
                        <td class="text-right">{{ number_format($totalDebit + $totalPurchasePayment + $previousTotalBill, 2) }}</td>
                        <td class="text-right">{{ number_format($totalReturn, 2) }}</td>
                        <td class="text-right">{{ number_format($totalCredit + $totalPurchase + $previousPaymentAmount, 2) }}</td>
                        <td class="text-right text-danger">{{ number_format($runningBalance, 2) }}</td>
                    </tr>
                    </tbody>
                </table>
            </div>

            <div class="row" style="margin-top: 30px; page-break-inside: avoid;">
                <div class="col-md-6 col-xs-12">
                    <table class="table table-bordered ledger-table">
                        <thead>
                            <tr style="background-color: #f4f4f4;">
                                <th colspan="2" class="text-center" style="font-weight: bold; color: #333;">MIS Snapshot (Summary)</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td><strong>Total Sales (Invoice Amount)</strong></td>
                                <td class="text-right">{{ number_format($totalDebit, 2) }}</td>
                            </tr>
                            <tr>
                                <td><strong>Total Collection (Cash/Bank)</strong></td>
                                <td class="text-right">{{ number_format($totalCredit, 2) }}</td>
                            </tr>
                            <tr>
                                <td><strong>Total Sales Return</strong></td>
                                <td class="text-right">{{ number_format($totalReturn, 2) }}</td>
                            </tr>
                            @if($totalPurchase > 0 || $totalPurchasePayment > 0)
                            <tr>
                                <td><strong>Total Purchase (Combined)</strong></td>
                                <td class="text-right">{{ number_format($totalPurchase, 2) }}</td>
                            </tr>
                            <tr>
                                <td><strong>Total Paid for Purchase</strong></td>
                                <td class="text-right">{{ number_format($totalPurchasePayment, 2) }}</td>
                            </tr>
                            @endif
                            <tr style="background-color: #eee; font-weight: bold;">
                                <td>Net Balance Status</td>
                                <td class="text-right">
                                    @if($runningBalance > 0)
                                        <span class="text-danger">Receivable: {{ number_format($runningBalance, 2) }}</span>
                                    @else
                                        <span class="text-success">Payable: {{ number_format(abs($runningBalance), 2) }}</span>
                                    @endif
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div> 
    </div>

    <script>
        $(document).ready(function(){
            $("#ledgerSearchInput").on("keyup", function() {
                // Removing commas from input for numeric search
                var searchValue = $(this).val().toLowerCase().replace(/,/g, ''); 
                
                $("#ledgerMainTable tbody tr.filterable-row").filter(function() {
                    var rowText = $(this).text().toLowerCase();
                    // Removing commas from row text to match numeric input
                    var rowTextNoCommas = rowText.replace(/,/g, ''); 
                    
                    // Logic to check if either direct text or comma-less text matches
                    var isMatch = rowText.indexOf(searchValue) > -1 || rowTextNoCommas.indexOf(searchValue) > -1;
                    
                    $(this).toggle(isMatch);
                });
            });
        });
    </script>
@endif