@extends('layouts.admin')
@section('title', 'Financial reports')
@section('content')
@php
  $tbDebit = collect($trialBalance)->sum('debit_cents');
  $tbCredit = collect($trialBalance)->sum('credit_cents');
@endphp
<x-admin.page title="Financial reports" subtitle="Live trial balance, P&L, balance sheet, aging, and GRNI.">
    <div class="mb-5 grid gap-4 sm:grid-cols-2 xl:grid-cols-4">
        <x-admin.card>
            <div class="text-xs uppercase tracking-wide text-[#6d7175]">Trial balance debit</div>
            <div class="mt-1 text-2xl font-semibold">AUD {{ number_format($tbDebit / 100, 2) }}</div>
        </x-admin.card>
        <x-admin.card>
            <div class="text-xs uppercase tracking-wide text-[#6d7175]">Trial balance credit</div>
            <div class="mt-1 text-2xl font-semibold">AUD {{ number_format($tbCredit / 100, 2) }}</div>
        </x-admin.card>
        <x-admin.card>
            <div class="text-xs uppercase tracking-wide text-[#6d7175]">Net profit</div>
            <div class="mt-1 text-2xl font-semibold">AUD {{ number_format(($profitAndLoss['profit_cents'] ?? 0) / 100, 2) }}</div>
        </x-admin.card>
        <x-admin.card>
            <div class="text-xs uppercase tracking-wide text-[#6d7175]">GRNI</div>
            <div class="mt-1 text-2xl font-semibold">AUD {{ number_format(($grni['balance_cents'] ?? 0) / 100, 2) }}</div>
        </x-admin.card>
    </div>

    <div class="grid gap-5 xl:grid-cols-2">
        <x-admin.section title="Trial balance">
            <div class="max-h-80 overflow-auto">
                <table class="admin-table w-full">
                    <thead><tr><th>Account</th><th class="text-right">Debit</th><th class="text-right">Credit</th></tr></thead>
                    <tbody>
                        @foreach($trialBalance as $row)
                            <tr>
                                <td><span class="font-mono text-xs text-[#6d7175]">{{ $row['account_code'] }}</span> {{ $row['account_name'] }}</td>
                                <td class="text-right tabular-nums">{{ number_format($row['debit_cents'] / 100, 2) }}</td>
                                <td class="text-right tabular-nums">{{ number_format($row['credit_cents'] / 100, 2) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </x-admin.section>

        <x-admin.section title="Profit and loss">
            <div class="mb-4 flex justify-between text-sm">
                <span class="text-[#6d7175]">Revenue</span>
                <span class="font-medium tabular-nums">AUD {{ number_format(($profitAndLoss['revenue_cents'] ?? 0) / 100, 2) }}</span>
            </div>
            <div class="mb-4 flex justify-between text-sm">
                <span class="text-[#6d7175]">Expenses</span>
                <span class="font-medium tabular-nums">AUD {{ number_format(($profitAndLoss['expense_cents'] ?? 0) / 100, 2) }}</span>
            </div>
            <div class="flex justify-between border-t border-[var(--color-admin-border)] pt-3 font-semibold">
                <span>Profit</span>
                <span class="tabular-nums">AUD {{ number_format(($profitAndLoss['profit_cents'] ?? 0) / 100, 2) }}</span>
            </div>
        </x-admin.section>

        <x-admin.section title="AP aging">
            <table class="admin-table w-full">
                <thead><tr><th>Bill</th><th class="text-right">Outstanding</th><th class="text-right">Days</th></tr></thead>
                <tbody>
                    @forelse($apAging as $row)
                        <tr>
                            <td>{{ $row['number'] }}</td>
                            <td class="text-right tabular-nums">{{ number_format($row['outstanding_cents'] / 100, 2) }}</td>
                            <td class="text-right">{{ $row['days_overdue'] }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="3" class="p-6 text-center text-[#6d7175]">No open AP.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </x-admin.section>

        <x-admin.section title="AR aging">
            <table class="admin-table w-full">
                <thead><tr><th>Invoice</th><th class="text-right">Outstanding</th></tr></thead>
                <tbody>
                    @forelse($arAging as $row)
                        <tr>
                            <td>{{ $row['number'] }}</td>
                            <td class="text-right tabular-nums">{{ number_format($row['outstanding_cents'] / 100, 2) }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="2" class="p-6 text-center text-[#6d7175]">No open AR.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </x-admin.section>
    </div>
</x-admin.page>
@endsection