@extends('layouts.school')
@section('title', 'Income Statement')
@section('header', 'Income Statement')
@section('content')
    <form method="GET" class="mb-6 flex flex-wrap items-end gap-3">
        <div>
            <label class="block text-xs font-medium text-gray-500 mb-1">From</label>
            <input type="date" name="from" value="{{ $from }}" class="rounded-lg border border-gray-300 px-3 py-2 text-sm focus:border-primary-500 focus:outline-none">
        </div>
        <div>
            <label class="block text-xs font-medium text-gray-500 mb-1">To</label>
            <input type="date" name="to" value="{{ $to }}" class="rounded-lg border border-gray-300 px-3 py-2 text-sm focus:border-primary-500 focus:outline-none">
        </div>
        <button class="rounded-lg bg-gray-100 px-4 py-2 text-sm font-medium text-gray-700 hover:bg-gray-200">Apply</button>
    </form>

    <div class="mx-auto max-w-3xl overflow-hidden rounded-xl bg-white shadow-sm ring-1 ring-gray-900/5">
        <table class="min-w-full">
            <tbody class="divide-y divide-gray-100">
                <tr><td class="px-6 py-3 text-sm font-semibold text-gray-900">Fee collections</td><td class="px-6 py-3 text-sm text-right font-medium text-green-700">₦{{ number_format($statement['fee_income'], 2) }}</td></tr>
                <tr><td class="px-6 py-3 text-sm text-gray-600 pl-10">Other income</td><td class="px-6 py-3 text-sm text-right text-green-700">₦{{ number_format($statement['other_income'], 2) }}</td></tr>
                <tr><td class="px-6 py-3 text-sm text-gray-600 pl-10">Less: refunds</td><td class="px-6 py-3 text-sm text-right text-red-600">(₦{{ number_format($statement['refunds'], 2) }})</td></tr>
                <tr class="bg-gray-50"><td class="px-6 py-3 text-sm font-bold text-gray-900">Total income</td><td class="px-6 py-3 text-sm text-right font-bold text-gray-900">₦{{ number_format($statement['total_income'], 2) }}</td></tr>

                @forelse ($statement['expenses_by_category'] as $category => $amount)
                    <tr><td class="px-6 py-3 text-sm text-gray-600 pl-10">{{ $category }}</td><td class="px-6 py-3 text-sm text-right text-red-600">(₦{{ number_format($amount, 2) }})</td></tr>
                @empty
                    <tr><td colspan="2" class="px-6 py-4 text-center text-xs text-gray-400">No expenses in period.</td></tr>
                @endforelse
                @if (!empty($statement['expenses_by_category']))
                    <tr class="bg-gray-50"><td class="px-6 py-3 text-sm font-bold text-gray-900">Total expenses</td><td class="px-6 py-3 text-sm text-right font-bold text-red-600">(₦{{ number_format($statement['total_expenses'], 2) }})</td></tr>
                @endif

                <tr class="bg-primary-50">
                    <td class="px-6 py-4 text-base font-bold {{ $statement['net_surplus'] >= 0 ? 'text-green-800' : 'text-red-800' }}">{{ $statement['net_surplus'] >= 0 ? 'Net surplus' : 'Net deficit' }}</td>
                    <td class="px-6 py-4 text-base text-right font-bold {{ $statement['net_surplus'] >= 0 ? 'text-green-800' : 'text-red-800' }}">₦{{ number_format(abs($statement['net_surplus']), 2) }}</td>
                </tr>
            </tbody>
        </table>
    </div>
@endsection