@if($sale->type == 'installment')

@php
    $installmentNo = (int) $sale->installment_no;
    $totalAmount = (float) $sale->total - $sale->received;

    $installmentAmount = $installmentNo > 0 ? ($totalAmount / $installmentNo) : 0;

    $startDate = \Carbon\Carbon::parse($sale->installment_date)->startOfDay();

    // total paid from ledgers
    $totalPaid = $saleLedger->sum('amount');
    $remainingAmount = $totalAmount - $totalPaid;

    // We'll consume ledger payments month by month
    $ledgerIndex = 0;
    $ledgerList = $saleLedger->values();
@endphp

<hr>

<div class="py-3 d-flex justify-content-between align-items-center">
    <h3 class="text-bold">Monthly Installment Plan</h3>
    <h5 class="text-bold">Total Amount: {{ number_format($totalAmount, 2) }}</h5>
</div>

<table class="table table-bordered">
    <thead>
    <tr>
        <th>Sr</th>
        <th>Month</th>
        <th>Due Date</th>
        <th>Installment Amount</th>
        <th>Paid Date</th>
        <th>Paid</th>
        <th>Pending</th>
        <th>Remaining</th>
    </tr>
    </thead>

    <tbody>
    @php $runningRemaining = $totalAmount; @endphp

    @for($i = 0; $i < $installmentNo; $i++)

        @php
            $dueDate = $startDate->copy()->addMonths($i);
            $rowDue = $installmentAmount;

            $paidThisMonth = 0;
            $paidDate = null;

            // ✅ Apply ledger payments into this installment row
            while ($ledgerIndex < $ledgerList->count() && $paidThisMonth < $rowDue) {
                $ledger = $ledgerList[$ledgerIndex];

                $availableAmount = (float) $ledger->amount;
                $need = $rowDue - $paidThisMonth;

                $apply = min($need, $availableAmount);

                if ($apply > 0) {
                    $paidThisMonth += $apply;

                    if (!$paidDate) {
                        $paidDate = $ledger->date;
                    }

                    $ledger->amount = $availableAmount - $apply;

                    if ($ledger->amount == 0) {
                        $ledgerIndex++;
                    }
                } else {
                    $ledgerIndex++;
                }
            }

            $pending = max(0, $rowDue - $paidThisMonth);
            $runningRemaining -= $paidThisMonth;

            if ($runningRemaining < 0) {
                $runningRemaining = 0;
            }
        @endphp

        <tr>
            <td>{{ $i+1 }}</td>
            <td>{{ $dueDate->format('F Y') }}</td>
            <td>{{ $dueDate->format('d M Y') }}</td>
            <td>{{ number_format($rowDue, 2) }}</td>
            <td>{{ $paidDate ? \Carbon\Carbon::parse($paidDate)->format('d M Y') : '' }}</td>
            <td>{{ number_format($paidThisMonth, 2) }}</td>
            <td>{{ number_format($pending, 2) }}</td>
            <td>{{ number_format($runningRemaining, 2) }}</td>
        </tr>

    @endfor

    <tr class="text-bold">
        <td colspan="3">Total</td>
        <td>{{ number_format($totalAmount, 2) }}</td>
        <td></td>
        <td>{{ number_format($totalPaid, 2) }}</td>
        <td>{{ number_format($totalAmount - $totalPaid, 2) }}</td>
        <td>{{ number_format($totalAmount - $totalPaid, 2) }}</td>
    </tr>

    </tbody>
</table>

@endif