@php
    $rows = array_reverse($overageHistory ?? []);
@endphp
<div class="card shadow-sm border-0 mt-3">
    <div class="card-header bg-white fw-bold">
        <i class="fas fa-money-bill-wave me-2 text-success"></i>Overage Payment History
    </div>
    <div class="card-body">
        @if(empty($rows))
        <div class="alert alert-info mb-0">
            কোন বকেয়া পেমেন্ট ইতিহাস পাওয়া যায়নি।
        </div>
        @else
        @php
            $totalAmount = collect($rows)->sum(fn ($r) => (float) ($r['payment_amount'] ?? 0));
            $paidCount = collect($rows)->filter(fn ($r) => in_array($r['payment_status'] ?? '', ['approved', 'completed', 'paid'], true))->count();
            $pendingCount = collect($rows)->filter(fn ($r) => ($r['payment_status'] ?? '') === 'pending')->count();
            $rejectedCount = collect($rows)->filter(fn ($r) => ($r['payment_status'] ?? '') === 'rejected')->count();
        @endphp
        <div class="table-responsive">
            <table class="table table-bordered table-hover align-middle mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Payment #</th>
                        <th>Payment Date</th>
                        <th>Payment Method</th>
                        <th>Payment Amount</th>
                        <th>Overage Count</th>
                        <th>Status</th>
                        <th>Details</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($rows as $row)
                    @php
                        $st = $row['payment_status'] ?? 'pending';
                        $stClass = match($st) {
                            'approved', 'completed', 'paid' => 'success',
                            'pending' => 'warning',
                            'rejected' => 'danger',
                            default => 'secondary',
                        };
                        $method = $row['payment_method'] ?? 'bank_transfer';
                        $overages = is_array($row['overages'] ?? null) ? $row['overages'] : [];
                    @endphp
                    <tr>
                        <td><strong>#{{ $row['payment_id'] ?? substr($row['id'] ?? '—', 0, 8) }}</strong></td>
                        <td>
                            {{ isset($row['payment_date']) ? \Carbon\Carbon::parse($row['payment_date'])->format('d M Y, h:i A') : '—' }}
                        </td>
                        <td>
                            <span class="badge bg-info">
                                <i class="fas fa-university me-1"></i>
                                {{ $row['payment_method_text'] ?? ($method === 'bank_transfer' ? 'Bank Transfer' : ucfirst($method)) }}
                            </span>
                        </td>
                        <td><strong>{{ number_format($row['payment_amount'] ?? 0, 2) }} ৳</strong></td>
                        <td><span class="badge bg-primary">{{ (int) ($row['overage_count'] ?? count($overages)) }} টি বকেয়া</span></td>
                        <td>
                            <span class="badge bg-{{ $stClass }}">{{ ucfirst($st) }}</span>
                            @if(! empty($row['status_text']))
                            <br><small class="text-muted">{{ $row['status_text'] }}</small>
                            @endif
                        </td>
                        <td>
                            @if(! empty($overages))
                            <button type="button" class="btn btn-sm btn-outline-info"
                                    data-bs-toggle="modal"
                                    data-bs-target="#overageDetailModal{{ $loop->index }}">
                                <i class="fas fa-eye me-1"></i>Details
                            </button>
                            @else
                            <span class="text-muted">—</span>
                            @endif
                        </td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="table-light">
                    <tr>
                        <td colspan="3" class="text-end fw-semibold">Total Payments:</td>
                        <td colspan="4"><strong>{{ count($rows) }} times</strong></td>
                    </tr>
                    <tr>
                        <td colspan="3" class="text-end fw-semibold">Total Amount:</td>
                        <td colspan="4"><strong>{{ number_format($totalAmount, 2) }} ৳</strong></td>
                    </tr>
                    @if($paidCount > 0)
                    <tr class="table-success">
                        <td colspan="3" class="text-end fw-semibold">Paid:</td>
                        <td colspan="4"><strong>{{ $paidCount }} times</strong></td>
                    </tr>
                    @endif
                    @if($pendingCount > 0)
                    <tr class="table-warning">
                        <td colspan="3" class="text-end fw-semibold">Pending:</td>
                        <td colspan="4"><strong>{{ $pendingCount }} times</strong></td>
                    </tr>
                    @endif
                    @if($rejectedCount > 0)
                    <tr class="table-danger">
                        <td colspan="3" class="text-end fw-semibold">Rejected:</td>
                        <td colspan="4"><strong>{{ $rejectedCount }} times</strong></td>
                    </tr>
                    @endif
                </tfoot>
            </table>
        </div>

        @foreach($rows as $row)
        @php $overages = is_array($row['overages'] ?? null) ? $row['overages'] : []; @endphp
        @if(! empty($overages))
        <div class="modal fade" id="overageDetailModal{{ $loop->index }}" tabindex="-1">
            <div class="modal-dialog modal-lg">
                <div class="modal-content">
                    <div class="modal-header bg-info text-white">
                        <h5 class="modal-title">
                            <i class="fas fa-info-circle me-2"></i>
                            Payment #{{ $row['payment_id'] ?? substr($row['id'] ?? '—', 0, 8) }} — বিস্তারিত
                        </h5>
                        <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body">
                        <h6 class="mb-3">Overage paid in this payment:</h6>
                        <div class="table-responsive">
                            <table class="table table-sm table-bordered">
                                <thead class="table-light">
                                    <tr>
                                        <th>Order #</th>
                                        <th>Date</th>
                                        <th>Rate</th>
                                        <th>Amount</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($overages as $item)
                                    <tr>
                                        <td>{{ $item['order_id'] ?? '—' }}</td>
                                        <td>{{ $item['date'] ?? '—' }}</td>
                                        <td>{{ number_format($item['rate'] ?? 0, 2) }} ৳</td>
                                        <td>{{ number_format($item['amount'] ?? 0, 2) }} ৳</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        @endif
        @endforeach
        @endif
    </div>
</div>