@extends('layouts.school')
@section('title', 'Trial Balance')
@section('header', 'Trial Balance')
@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">As of</label>
            <input type="date" name="as_of" value="{{ $asOf }}" 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="mb-4 flex items-center gap-2 text-sm">
        <span class="inline-flex items-center rounded-full px-2.5 py-0.5 text-xs font-medium
            {{ $balance['balanced'] ? 'bg-green-50 text-green-700' : 'bg-red-50 text-red-700' }}">
            {{ $balance['balanced'] ? 'Balanced' : 'Out of balance' }}
        </span>
        <span class="text-gray-500">{{ $balance['rows']->count() }} account(s)</span>
    </div>

    <div class="overflow-hidden rounded-xl bg-white shadow-sm ring-1 ring-gray-900/5">
        <div class="overflow-x-auto">
            <table class="min-w-full text-sm">
                <thead>
                    <tr class="border-b border-gray-100 text-left text-xs font-semibold uppercase tracking-wider text-gray-500">
                        <th class="px-4 py-3">Account</th>
                        <th class="px-4 py-3 text-right">Debit</th>
                        <th class="px-4 py-3 text-right">Credit</th>
                        <th class="px-4 py-3 text-right">Balance</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-100">
                    @forelse ($balance['rows'] as $row)
                        <tr>
                            <td class="px-4 py-2.5 font-mono text-xs text-gray-900">{{ $row['account'] }}</td>
                            <td class="px-4 py-2.5 text-right font-medium text-green-700">₦{{ number_format($row['debit'], 2) }}</td>
                            <td class="px-4 py-2.5 text-right font-medium text-red-600">₦{{ number_format($row['credit'], 2) }}</td>
                            <td class="px-4 py-2.5 text-right font-semibold {{ $row['balance'] >= 0 ? 'text-gray-900' : 'text-red-700' }}">₦{{ number_format(abs($row['balance']), 2) }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="4" class="px-4 py-10 text-center text-xs text-gray-400">No cashbook entries yet.</td></tr>
                    @endforelse
                </tbody>
                @if ($balance['rows']->isNotEmpty())
                    <tfoot>
                        <tr class="border-t border-gray-100 bg-gray-50">
                            <td class="px-4 py-3 text-sm font-bold text-gray-900">Totals</td>
                            <td class="px-4 py-3 text-right text-sm font-bold text-green-700">₦{{ number_format($balance['totals']['debit'], 2) }}</td>
                            <td class="px-4 py-3 text-right text-sm font-bold text-red-600">₦{{ number_format($balance['totals']['credit'], 2) }}</td>
                            <td class="px-4 py-3"></td>
                        </tr>
                    </tfoot>
                @endif
            </table>
        </div>
    </div>
@endsection