@extends('layouts.school')
@section('title', 'Collections Report')
@section('header', 'Collections Report')
@section('content')
    <div class="grid grid-cols-1 gap-6 lg:grid-cols-2">
        <div class="overflow-hidden rounded-xl bg-white shadow-sm ring-1 ring-gray-900/5">
            <h3 class="border-b border-gray-100 px-6 py-4 text-sm font-semibold text-gray-900">By Fee Category</h3>
            <table class="min-w-full divide-y divide-gray-200">
                <thead class="bg-gray-50"><tr>
                    <th class="px-6 py-3 text-left text-xs font-semibold uppercase text-gray-500">Category</th>
                    <th class="px-6 py-3 text-right text-xs font-semibold uppercase text-gray-500">Billed</th>
                    <th class="px-6 py-3 text-right text-xs font-semibold uppercase text-gray-500">Collected</th>
                    <th class="px-6 py-3 text-right text-xs font-semibold uppercase text-gray-500">Rate</th>
                </tr></thead>
                <tbody class="divide-y divide-gray-100">
                    @forelse ($byCategory as $row)
                        @php $rate = $row['billed'] > 0 ? round($row['collected'] / $row['billed'] * 100) : 0; @endphp
                        <tr class="hover:bg-gray-50">
                            <td class="px-6 py-3 text-sm font-medium text-gray-900">{{ $row['category'] }}</td>
                            <td class="px-6 py-3 text-sm text-right text-gray-600">₦{{ number_format($row['billed'], 0) }}</td>
                            <td class="px-6 py-3 text-sm text-right font-medium text-green-700">₦{{ number_format($row['collected'], 0) }}</td>
                            <td class="px-6 py-3 text-sm text-right {{ $rate >= 80 ? 'text-green-600' : ($rate >= 50 ? 'text-yellow-600' : 'text-red-600') }}">{{ $rate }}%</td>
                        </tr>
                    @empty
                        <tr><td colspan="4" class="px-6 py-12 text-center text-sm text-gray-500">No invoice items yet.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>

        <div class="rounded-xl bg-white p-6 shadow-sm ring-1 ring-gray-900/5">
            <h3 class="text-sm font-semibold text-gray-900">Monthly Collections (Current Year)</h3>
            @if (empty($byMonth))
                <p class="mt-4 text-sm text-gray-500">No collections recorded yet.</p>
            @else
                @php $max = max($byMonth); @endphp
                <div class="mt-4 space-y-3">
                    @foreach ($byMonth as $month => $total)
                        <div>
                            <div class="flex justify-between text-xs text-gray-500"><span>{{ \Carbon\Carbon::parse($month . '-01')->format('M Y') }}</span><span>₦{{ number_format($total, 0) }}</span></div>
                            <div class="mt-1 h-2 w-full rounded-full bg-gray-100"><div class="h-2 rounded-full bg-green-500" style="width: {{ $max > 0 ? max(3, round($total / $max * 100)) : 0 }}%"></div></div>
                        </div>
                    @endforeach
                </div>
            @endif
        </div>
    </div>
@endsection