@extends('layouts.app')
@section('title','Profit & Loss Summary')
@section('styles')<style>@media print{.no-print{display:none!important}body{background:#fff}}</style>@endsection
@section('content')

<h1 class="text-lg font-bold text-gray-900 mb-1">Profit & Loss Summary</h1>
<p class="text-xs text-gray-500 mb-3">{{ $from->format('d M Y') }} — {{ $to->format('d M Y') }}</p>

@php $exportType = 'profit-loss'; @endphp
@include('reports._date-filter')

@php
    // Two distinct net positions — both meaningful, different purposes.
    // Cash Net   = Collections − Expenses Paid   (pure cash-flow view)
    // Accrual Net = Invoiced − Expenses Paid     (mixed; what the old card showed)
    $cashNet    = $collections - $expensesPaid;
    $accrualNet = $revenue - $expensesPaid;
@endphp

{{-- ═══ HEADLINE CARDS ═══════════════════════════════════════════════
     Four cards: Invoiced + Collections + Expenses Paid + Cash Net.
     Tooltips on each tile clarify the definition. --}}
<div class="grid grid-cols-2 md:grid-cols-4 gap-3 mb-2">
    <div class="stat-card" title="Total invoice value billed in this period. Includes paid, partially paid, and unpaid invoices.">
        <p class="text-xs text-gray-400 uppercase">Invoiced</p>
        <p class="text-xl font-bold">KES {{ number_format($revenue) }}</p>
        <p class="text-[11px] text-gray-400 mt-1">All invoices raised</p>
    </div>
    <div class="stat-card" title="Cash actually collected — completed payments only. Pending, failed, and refunded payments excluded.">
        <p class="text-xs text-gray-400 uppercase">Collections</p>
        <p class="text-xl font-bold text-green-600">KES {{ number_format($collections) }}</p>
        <p class="text-[11px] text-gray-400 mt-1">Completed payments</p>
    </div>
    <div class="stat-card" title="Cash actually paid out for expenses (ExpensePayment.payment_date). Distinct from expenses recorded but unpaid.">
        <p class="text-xs text-gray-400 uppercase">Expenses Paid</p>
        <p class="text-xl font-bold text-red-600">KES {{ number_format($expensesPaid) }}</p>
        <p class="text-[11px] text-gray-400 mt-1">Cash-out only</p>
    </div>
    <div class="stat-card" style="border-left:4px solid {{ $cashNet >= 0 ? '#16a34a' : '#dc2626' }}" title="Collections minus Expenses Paid — pure cash-flow view of P&L.">
        <p class="text-xs text-gray-400 uppercase">Cash Net</p>
        <p class="text-xl font-bold {{ $cashNet >= 0 ? 'text-green-600' : 'text-red-600' }}">KES {{ number_format($cashNet) }}</p>
        <p class="text-[11px] text-gray-400 mt-1">Collections − Expenses Paid</p>
    </div>
</div>

{{-- ═══ RECONCILIATION NOTE ═══════════════════════════════════════════
     The relationship between Invoiced, Collections, and the gap is
     non-obvious for non-finance users. This panel explains it in
     plain language. --}}
@php $arGap = $revenue - $collections; @endphp
@if($revenue > 0)
<div class="bg-blue-50 border border-blue-200 rounded-lg px-4 py-3 mb-4 text-xs">
    <p class="text-blue-900 leading-snug">
        <strong>Invoiced − Collections = KES {{ number_format($arGap) }}.</strong>
        This gap is money the hospital billed but hasn't yet collected — it sits in
        <strong>Accounts Receivable</strong> (patients owing balances + insurance claims pending settlement).
        See <a href="{{ route('reports.open-balance') }}" class="text-blue-700 underline">Open Balance report</a> for the breakdown.
    </p>
    @if($accrualNet !== $cashNet)
        <p class="text-blue-800 mt-2 leading-snug">
            <strong>Accrual Net (Invoiced − Expenses Paid):</strong>
            KES {{ number_format($accrualNet) }} —
            this is the figure if you treat unbilled receivables as already-earned revenue.
            <strong>Cash Net</strong> (above) is the conservative measure based on cash actually in hand.
        </p>
    @endif
</div>
@endif

{{-- ═══ DEPARTMENT + CATEGORY BREAKDOWNS ═══════════════════════════ --}}
<div class="grid grid-cols-1 md:grid-cols-2 gap-4">
    <div class="bg-white rounded-xl border shadow-sm">
        <div class="px-5 py-3 border-b">
            <h3 class="text-sm font-bold">Revenue by Department</h3>
            <p class="text-[11px] text-gray-400 mt-0.5">By invoice line department (pharmacy, lab, consultation, etc.)</p>
        </div>
        <table class="w-full">
            <tbody>
                @forelse($revenueByDept as $r)
                <tr class="border-b border-gray-50">
                    <td class="table-cell text-xs font-medium">{{ $r->department ?: 'Other' }}</td>
                    <td class="table-cell text-right text-xs font-semibold">KES {{ number_format($r->total) }}</td>
                </tr>
                @empty
                <tr><td colspan="2" class="table-cell text-center text-gray-400 py-6 text-xs">No invoiced revenue in window.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
    <div class="bg-white rounded-xl border shadow-sm">
        <div class="px-5 py-3 border-b">
            <h3 class="text-sm font-bold">Expenses by Category</h3>
            <p class="text-[11px] text-gray-400 mt-0.5">By recorded expense date (accrual basis)</p>
        </div>
        <table class="w-full">
            <tbody>
                @forelse($expensesByCategory as $e)
                <tr class="border-b border-gray-50">
                    <td class="table-cell text-xs font-medium">{{ $e->category }}</td>
                    <td class="table-cell text-right text-xs font-semibold text-red-600">KES {{ number_format($e->total) }}</td>
                </tr>
                @empty
                <tr><td colspan="2" class="table-cell text-center text-gray-400 py-6 text-xs">No expenses recorded in window.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>
@endsection