@extends('layouts.app')
@section('title','Open Balance Report')
@section('content')

<div class="flex items-baseline justify-between mb-1">
    <h1 class="text-lg font-bold text-gray-900">Accounts Receivable</h1>
    <span class="text-xs text-gray-400">Live figure (not date-bound)</span>
</div>
<p class="text-xs text-gray-500 mb-4">Money owed to the hospital right now — patient-owed plus insurance claims still pending settlement.</p>

{{-- ═══ CANONICAL A/R CARDS ═══════════════════════════════════════════════
     These three cards are the canonical A/R figures Dashboard also shows.
     "Total A/R" = "Patient-Owed" + "Insurance-Owed". --}}
<div class="grid grid-cols-3 gap-3 mb-3">
    <div class="stat-card" style="border-left:3px solid #dc2626" title="Total money owed to the hospital — sum of patient-owed and insurance-owed. Matches the A/R figure on the Dashboard.">
        <p class="text-xs text-gray-400 uppercase">Total A/R</p>
        <p class="text-xl font-bold text-red-600">KES {{ number_format($totalAr) }}</p>
    </div>
    <div class="stat-card" title="Patients with unpaid invoices (excluding insurance/corporate, write-offs, and cancelled visits).">
        <p class="text-xs text-gray-400 uppercase">Patient-Owed</p>
        <p class="text-xl font-bold">KES {{ number_format($arPatient) }}</p>
    </div>
    <div class="stat-card" title="Insurance/corporate claims submitted but not yet remitted. From insurance_claims table — distinct from invoices marked 'paid' at cashier.">
        <p class="text-xs text-gray-400 uppercase">Insurance Pending</p>
        <p class="text-xl font-bold text-blue-600">KES {{ number_format($arInsurer) }}</p>
    </div>
</div>

{{-- ═══ SECONDARY: GROSS OPEN BALANCE (RECONCILIATION ONLY) ═════════════
     This used to be the headline number. Kept here as a separate, smaller
     line because some legacy workflows reference it. The note explains
     why the canonical A/R above is the operational figure. --}}
@if($grossOpenBalance != $totalAr)
<div class="bg-amber-50 border border-amber-200 rounded-lg px-4 py-3 mb-4 text-xs">
    <div class="flex items-baseline justify-between gap-3">
        <div>
            <span class="font-semibold text-amber-900">Gross Open Balance:</span>
            <span class="font-mono text-amber-900">KES {{ number_format($grossOpenBalance) }}</span>
        </div>
        <span class="text-amber-700">Difference: KES {{ number_format($grossOpenBalance - $totalAr) }}</span>
    </div>
    <p class="text-amber-800 mt-1 leading-snug">
        The gross figure includes <strong>written-off invoices</strong>, <strong>cancelled-visit balances</strong>, and
        <strong>insurance invoices</strong> that have been pseudo-paid at the cashier. These are not
        actually collectable. The canonical A/R figure above is what finance should track.
    </p>
</div>
@endif

{{-- ═══ INVOICE LISTING — patient-owed only ═════════════════════════════
     Insurance/corporate invoices are NOT listed here because they're
     accounted for in the insurance_claims table (and in the "Insurance
     Pending" card above). For per-claim aging, see the Claims Aging
     report. --}}
<div class="bg-white rounded-xl border shadow-sm overflow-x-auto">
    <div class="px-4 py-2 border-b border-gray-100 bg-gray-50 text-xs text-gray-500">
        Showing {{ $invoices->count() }} patient-owed invoices that contribute to A/R.
        Insurance claims are tracked separately in
        <a href="{{ route('reports.claims-aging') }}" class="text-cr-600 hover:underline">Claims Aging</a>.
    </div>
    <table class="w-full">
        <thead><tr class="bg-gray-50">
            <th class="table-header">Patient</th>
            <th class="table-header">MRN</th>
            <th class="table-header">Visit</th>
            <th class="table-header">Payer</th>
            <th class="table-header text-right">Billed</th>
            <th class="table-header text-right">Paid</th>
            <th class="table-header text-right">Balance</th>
        </tr></thead>
        <tbody>
            @forelse($invoices as $inv)
            <tr class="border-b border-gray-50">
                <td class="table-cell text-xs font-medium">{{ $inv->patient->full_name ?? '' }}</td>
                <td class="table-cell font-mono text-xs">{{ $inv->patient->mrn ?? '' }}</td>
                <td class="table-cell font-mono text-xs">{{ $inv->visit->visit_number ?? '' }}</td>
                <td class="table-cell text-xs capitalize">{{ $inv->payment_mode ?: '—' }}</td>
                <td class="table-cell text-right text-xs">{{ number_format($inv->total_amount) }}</td>
                <td class="table-cell text-right text-xs">{{ number_format($inv->amount_paid) }}</td>
                <td class="table-cell text-right text-xs text-red-600 font-bold">{{ number_format($inv->balance) }}</td>
            </tr>
            @empty
            <tr><td colspan="7" class="table-cell text-center text-gray-400 py-8">No patient-owed open balances right now.</td></tr>
            @endforelse
        </tbody>
    </table>
</div>
@endsection