@extends('layouts.app')
@section('title', 'Fee Report')
@section('actions')
    <a href="{{ route('reports.patient-fees.pdf', ['from' => $from, 'to' => $to]) }}" class="btn btn-dark"><i class="bi bi-file-pdf"></i> Export PDF</a>
@endsection

@section('content')
<div class="card p-3 mb-3">
    <form method="GET" class="row g-2 align-items-end">
        <div class="col-6 col-md-3">
            <label class="form-label small mb-1">From Date</label>
            <input type="date" name="from" value="{{ $from }}" class="form-control form-control-sm">
        </div>
        <div class="col-6 col-md-3">
            <label class="form-label small mb-1">To Date</label>
            <input type="date" name="to" value="{{ $to }}" class="form-control form-control-sm">
        </div>
        <div class="col-12 col-md-4">
            <button class="btn btn-sm btn-dark"><i class="bi bi-funnel"></i> Show</button>
            <a href="{{ route('reports.patient-fees') }}" class="btn btn-sm btn-outline-secondary">Today</a>
        </div>
    </form>
    <div class="small text-muted mt-2">Showing {{ \Illuminate\Support\Carbon::parse($from)->format('d M Y') }} — {{ \Illuminate\Support\Carbon::parse($to)->format('d M Y') }} (first-time + repeat visit fees, each on its own date).</div>
</div>

<div class="row g-3 mb-3">
    <div class="col-6 col-lg-3"><div class="card p-3"><div class="text-muted small">Total Patient Fee</div><h4 class="mb-0">{{ number_format($summary->total_fee, 2) }}</h4><small class="text-muted">{{ $summary->count }} visit(s)</small></div></div>
    <div class="col-6 col-lg-3"><div class="card p-3"><div class="text-muted small">Total Received Fee</div><h4 class="mb-0 text-success">{{ number_format($summary->total_received, 2) }}</h4></div></div>
    <div class="col-6 col-lg-3"><div class="card p-3"><div class="text-muted small">Total Remaining Fee</div><h4 class="mb-0 text-danger">{{ number_format($summary->total_remaining, 2) }}</h4></div></div>
    <div class="col-6 col-lg-3"><div class="card p-3"><div class="text-muted small">Total Discount Fee</div><h4 class="mb-0 text-warning">{{ number_format($summary->total_discount, 2) }}</h4></div></div>
</div>

<div class="card p-0 mb-3">
    <div class="table-responsive">
        <table class="table table-sm mb-0 align-middle">
            <thead><tr><th>Serial</th><th>Patient</th><th>Visit Date</th><th>Type</th><th>Patient Fee</th><th>Received</th><th>Remaining</th><th>Discount</th><th>Balance</th><th>Reference</th><th>City</th><th>Area</th></tr></thead>
            <tbody>
            @forelse($rows as $r)
                <tr>
                    <td>{{ $r->serial }}</td>
                    <td><a href="{{ route('patients.show', $r->patient_id) }}">{{ $r->name }}</a></td>
                    <td>{{ \Illuminate\Support\Carbon::parse($r->date)->format('d M Y') }}</td>
                    <td><span class="badge {{ $r->type === 'First Visit' ? 'bg-info text-dark' : 'bg-secondary' }}">{{ $r->type }}</span></td>
                    <td>{{ number_format($r->patient_fee, 2) }}</td>
                    <td>{{ number_format($r->received_fee, 2) }}</td>
                    <td>{{ number_format($r->remaining_fee, 2) }}</td>
                    <td>{{ number_format($r->discount_fee, 2) }}</td>
                    <td>{{ ucfirst($r->balance_type ?? '—') }}</td>
                    <td>{{ $r->reference_name ?? '—' }}</td>
                    <td>{{ $r->city ?? '—' }}</td>
                    <td>{{ $r->area ?? '—' }}</td>
                </tr>
            @empty
                <tr><td colspan="12" class="text-center text-muted py-3">No fee records in this range.</td></tr>
            @endforelse
            </tbody>
            @if($rows->count())
            <tfoot><tr class="fw-bold"><td colspan="4">Total ({{ $summary->count }})</td><td>{{ number_format($summary->total_fee, 2) }}</td><td>{{ number_format($summary->total_received, 2) }}</td><td>{{ number_format($summary->total_remaining, 2) }}</td><td>{{ number_format($summary->total_discount, 2) }}</td><td colspan="4"></td></tr></tfoot>
            @endif
        </table>
    </div>
</div>

<div class="card p-0">
    <div class="px-3 pt-3"><h6 class="mb-0">Remaining Payments Received (in range)</h6></div>
    <div class="table-responsive">
        <table class="table table-sm mb-0 align-middle">
            <thead><tr><th>Payment Date</th><th>Patient</th><th>Amount</th><th>Notes</th></tr></thead>
            <tbody>
            @forelse($payments as $pay)
                <tr>
                    <td>{{ $pay->payment_date->format('d M Y') }}</td>
                    <td><a href="{{ route('patients.show', $pay->patient_id) }}">{{ $pay->patient->name ?? '—' }}</a></td>
                    <td>{{ number_format($pay->payment_amount, 2) }}</td>
                    <td class="small">{{ $pay->notes ?? '—' }}</td>
                </tr>
            @empty
                <tr><td colspan="4" class="text-center text-muted py-3">No remaining payments received in this range.</td></tr>
            @endforelse
            </tbody>
            @if($payments->count())
            <tfoot><tr class="fw-bold"><td colspan="2">Total Received Later</td><td>{{ number_format($payments->sum('payment_amount'), 2) }}</td><td></td></tr></tfoot>
            @endif
        </table>
    </div>
</div>
@endsection