@extends('layouts.admin')
@section('title', 'Reports')
@section('page', 'reports')
@section('content')
@php $cur = config('clinic.currency.symbol'); @endphp
<div class="page-content report-page-content">
    <div class="report-page-head">
        <div class="report-heading-wrap">
            <div class="report-breadcrumbs"><i class="bi bi-chevron-left"></i><span>Reports</span><i class="bi bi-chevron-right"></i><strong>Financial Report</strong></div>
            <div class="report-title-row">
                <div class="report-title-icon"><i class="bi bi-bar-chart-fill"></i></div>
                <div><h1 class="page-title">Executive Financial Report & Revenue Audit</h1><p class="page-subtitle">Total fees collected, outstanding treatment balances, and projected upcoming fees.</p></div>
            </div>
        </div>
        <div class="report-head-actions">
            <div class="report-date-control"><i class="bi bi-calendar3"></i><span>{{ now()->startOfMonth()->format('d M Y') }} - {{ now()->endOfMonth()->format('d M Y') }}</span></div>
            <button type="button" class="btn-primary-teal" onclick="window.print()"><i class="bi bi-printer me-1"></i> Print Audit Statement</button>
        </div>
    </div>

    <section class="report-stat-grid">
        <article class="report-stat-card collected">
            <div class="report-stat-icon"><i class="bi bi-wallet2"></i></div>
            <div><div class="report-stat-label">TOTAL FEES COLLECTED</div><div class="report-stat-value">{{ $cur }}{{ number_format($summary['paid'],2) }}</div><div class="report-stat-meta">from {{ $summary['installments'] }} part-payment installments</div></div>
        </article>
        <article class="report-stat-card pending">
            <div class="report-stat-icon"><i class="bi bi-exclamation-triangle"></i></div>
            <div><div class="report-stat-label">TOTAL DUES PENDING</div><div class="report-stat-value">{{ $cur }}{{ number_format($summary['outstanding'],2) }}</div><div class="report-stat-meta"><b>{{ $summary['dues_patients'] }} Patients</b> pending settlement</div></div>
        </article>
        <article class="report-stat-card expected">
            <div class="report-stat-icon"><i class="bi bi-calendar-event"></i></div>
            <div><div class="report-stat-label">NEXT MONTH EXPECTED</div><div class="report-stat-value">{{ $cur }}{{ number_format($summary['next_expected'],2) }}</div><div class="report-stat-meta"><b>Projected Inflow</b> from scheduled follow-ups</div></div>
        </article>
        <article class="report-stat-card treatment">
            <div class="report-stat-icon"><i class="bi bi-file-earmark-text"></i></div>
            <div><div class="report-stat-label">TOTAL TREATMENT VALUE</div><div class="report-stat-value">{{ $cur }}{{ number_format($summary['billed'],2) }}</div><div class="report-stat-meta">Billed to date</div></div>
        </article>
    </section>

    <div class="row g-3 mt-1">
        <div class="col-lg-6"><section class="card-admin"><div class="panel-head"><div class="panel-title">Service-wise Revenue (Clinical Disease / Diagnosis)</div></div>
            <div class="table-responsive"><table class="table admin-table mb-0"><thead><tr><th>Name</th><th>Treatments</th><th>Revenue</th></tr></thead><tbody>
                @forelse($byService as $r)<tr><td>{{ $r->name }}</td><td>{{ $r->c }}</td><td><strong>{{ $cur }}{{ number_format($r->rev,0) }}</strong></td></tr>@empty<tr><td colspan="3" class="text-center text-secondary py-3">No data.</td></tr>@endforelse
            </tbody></table></div></section>
        </div>
        <div class="col-lg-6"><section class="card-admin"><div class="panel-head"><div class="panel-title">Doctor-wise Revenue</div></div>
            <div class="table-responsive"><table class="table admin-table mb-0"><thead><tr><th>Doctor</th><th>Revenue</th></tr></thead><tbody>
                @forelse($byDoctor as $r)<tr><td>{{ $r->name }}</td><td><strong>{{ $cur }}{{ number_format($r->rev,0) }}</strong></td></tr>@empty<tr><td colspan="2" class="text-center text-secondary py-3">No data.</td></tr>@endforelse
            </tbody></table></div></section>
        </div>
        <div class="col-lg-6"><section class="card-admin"><div class="panel-head"><div class="panel-title">Department-wise Revenue</div></div>
            <div class="table-responsive"><table class="table admin-table mb-0"><thead><tr><th>Department</th><th>Revenue</th></tr></thead><tbody>
                @forelse($byDept as $r)<tr><td>{{ $r->name }}</td><td><strong>{{ $cur }}{{ number_format($r->rev,0) }}</strong></td></tr>@empty<tr><td colspan="2" class="text-center text-secondary py-3">No data.</td></tr>@endforelse
            </tbody></table></div></section>
        </div>
        <div class="col-lg-6"><section class="card-admin"><div class="panel-head"><div class="panel-title">Revenue Audit — Payment Methods</div></div>
            <div class="table-responsive"><table class="table admin-table mb-0"><thead><tr><th>Method</th><th>Count</th><th>Total</th></tr></thead><tbody>
                @forelse($byMethod as $r)<tr><td>{{ strtoupper($r->method) }}</td><td>{{ $r->c }}</td><td><strong>{{ $cur }}{{ number_format($r->total,0) }}</strong></td></tr>@empty<tr><td colspan="3" class="text-center text-secondary py-3">No data.</td></tr>@endforelse
            </tbody></table></div></section>
        </div>
    </div>

    <section class="card-admin mt-3"><div class="panel-head"><div class="panel-title">Recent Part-Payment Receipts</div></div>
        <div class="table-responsive"><table class="table admin-table mb-0"><thead><tr><th>Receipt</th><th>Patient</th><th>Amount</th><th>Method</th><th>Recorded By</th><th>Date</th></tr></thead><tbody>
            @forelse($recent as $p)<tr><td>{{ $p->receipt_no }}</td><td>{{ $p->patient?->full_name ?? '—' }}</td><td><strong>{{ $cur }}{{ number_format($p->amount,2) }}</strong></td><td>{{ strtoupper($p->method) }}</td><td>{{ $p->collectedBy?->name ?? '—' }}</td><td>{{ $p->payment_date->format('d M Y') }}</td></tr>@empty<tr><td colspan="6" class="text-center text-secondary py-3">No payments recorded.</td></tr>@endforelse
        </tbody></table></div>
    </section>
</div>
@endsection