@extends('layouts.app')
@section('title', 'Financial Reports')

@section('content')
<div class="space-y-6" x-data x-init="setTimeout(() => window.renderCharts(), 30)">
    <div class="flex flex-col sm:flex-row sm:items-center sm:justify-between gap-3">
        <div>
            <h1 class="text-xl font-bold">Financial Reports</h1>
            <p class="text-sm text-ink-muted">Restaurant and bar profit &amp; loss, cash flow, and outstanding balances.</p>
        </div>
        <div class="flex flex-wrap items-center gap-2">
            <x-period-filter :period="$period" :from="$from" :to="$to" />
            <x-export-menu route="reports.financial.export" :params="['period' => $period, 'from' => $from->format('Y-m-d'), 'to' => $to->format('Y-m-d')]" />
        </div>
    </div>

    <div class="grid grid-cols-2 lg:grid-cols-4 gap-4">
        <x-stat-card label="Net profit" value="{{ number_format($netProfit, 2) }}" icon="trending-up" tone="{{ $netProfit >= 0 ? 'emerald' : 'rose' }}" />
        <x-stat-card label="Restaurant GP" value="{{ number_format($restaurantGP, 2) }}" icon="utensils" tone="primary" />
        <x-stat-card label="Bar GP" value="{{ number_format($barGP, 2) }}" icon="martini" tone="violet" />
        <x-stat-card label="Total expenses" value="{{ number_format($expensesTotal, 2) }}" icon="receipt" tone="amber" />
    </div>

    <div class="grid lg:grid-cols-2 gap-4">
        <div class="card card-pad">
            <p class="text-sm font-semibold mb-3">Sales vs cost vs profit</p>
            <div class="h-64">
                <canvas data-chart='{
                    "type":"bar","legend":true,
                    "labels": ["Restaurant", "Bar"],
                    "datasets": [
                        {"label": "Sales", "data": [{{ $restaurantSales }}, {{ $barSales }}], "backgroundColor": "#0F6E5E"},
                        {"label": "Cost", "data": [{{ $restaurantCost }}, {{ $barCost }}], "backgroundColor": "#C98A2C"},
                        {"label": "Gross profit", "data": [{{ $restaurantGP }}, {{ $barGP }}], "backgroundColor": "#2A6F97"}
                    ]
                }'></canvas>
            </div>
        </div>
        @if ($expensesByCategory->isNotEmpty())
            <div class="card card-pad">
                <p class="text-sm font-semibold mb-3">Expenses by category</p>
                <div class="h-64">
                    <canvas data-chart='{
                        "type":"pie","legend":true,
                        "labels": {!! $expensesByCategory->keys()->toJson() !!},
                        "datasets": [{"data": {!! $expensesByCategory->values()->toJson() !!}, "backgroundColor": ["#0F6E5E","#C98A2C","#2A6F97","#8B978F","#B3402F","#63AB9B","#7C3AED"]}]
                    }'></canvas>
                </div>
            </div>
        @endif
    </div>

    <div class="grid lg:grid-cols-2 gap-4">
        <div class="card card-pad">
            <h3 class="font-display font-bold mb-3">Profit &amp; Loss</h3>
            <table class="data-table">
                <tbody>
                    <tr><td class="font-semibold" colspan="2">Restaurant</td></tr>
                    <tr><td class="pl-4">Sales</td><td class="text-right">{{ number_format($restaurantSales, 2) }}</td></tr>
                    <tr><td class="pl-4">− Food cost</td><td class="text-right">({{ number_format($restaurantCost, 2) }})</td></tr>
                    <tr class="font-semibold"><td class="pl-4">= Gross profit</td><td class="text-right">{{ number_format($restaurantGP, 2) }}</td></tr>

                    <tr><td class="font-semibold pt-3" colspan="2">Bar</td></tr>
                    <tr><td class="pl-4">Sales</td><td class="text-right">{{ number_format($barSales, 2) }}</td></tr>
                    <tr><td class="pl-4">− Beverage cost</td><td class="text-right">({{ number_format($barCost, 2) }})</td></tr>
                    <tr class="font-semibold"><td class="pl-4">= Gross profit</td><td class="text-right">{{ number_format($barGP, 2) }}</td></tr>

                    <tr><td class="font-semibold pt-3" colspan="2">Overall</td></tr>
                    <tr><td class="pl-4">Restaurant profit</td><td class="text-right">{{ number_format($restaurantGP, 2) }}</td></tr>
                    <tr><td class="pl-4">Bar profit</td><td class="text-right">{{ number_format($barGP, 2) }}</td></tr>
                    <tr><td class="pl-4">Other income</td><td class="text-right">{{ number_format($otherIncome, 2) }}</td></tr>
                    <tr><td class="pl-4">− Expenses</td><td class="text-right">({{ number_format($expensesTotal, 2) }})</td></tr>
                    <tr class="font-bold border-t border-line"><td class="pl-4">= Net profit</td><td class="text-right {{ $netProfit < 0 ? 'text-danger' : 'text-success' }}">{{ number_format($netProfit, 2) }}</td></tr>
                </tbody>
            </table>
        </div>

        <div class="space-y-4">
            <div class="card card-pad">
                <h3 class="font-display font-bold mb-3">Expenses by category</h3>
                <table class="data-table">
                    <tbody>
                        @forelse ($expensesByCategory as $name => $amount)
                            <tr><td>{{ $name }}</td><td class="text-right">{{ number_format($amount, 2) }}</td></tr>
                        @empty
                            <tr><td class="text-ink-muted text-center py-4" colspan="2">No approved expenses in this period.</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>

            <div class="card card-pad">
                <h3 class="font-display font-bold mb-3">Cash flow &amp; balances</h3>
                <table class="data-table">
                    <tbody>
                        <tr><td>Cash received (all methods)</td><td class="text-right">{{ number_format($cashIn, 2) }}</td></tr>
                        <tr><td>Cash paid out (expenses)</td><td class="text-right">({{ number_format($cashOut, 2) }})</td></tr>
                        <tr class="font-semibold border-t border-line"><td>Net cash movement</td><td class="text-right">{{ number_format($cashIn - $cashOut, 2) }}</td></tr>
                        <tr><td class="pt-3">Unpaid orders/tabs (no payment yet)</td><td class="text-right pt-3">{{ number_format($creditOutstanding, 2) }}</td></tr>
                        @can('data.customer_balances')
                        <tr><td>Customer account balances owed</td><td class="text-right">{{ number_format($customerBalances->sum('balance'), 2) }}</td></tr>
                        <tr><td>Supplier balances owed</td><td class="text-right">{{ number_format($supplierBalances->sum('balance'), 2) }}</td></tr>
                        @endcan
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    @can('data.customer_balances')
    @if ($customerBalances->isNotEmpty())
        <div class="card overflow-x-auto">
            <table class="data-table">
                <thead><tr><th>Customer</th><th>Contact</th><th class="text-right">Balance owed</th></tr></thead>
                <tbody>
                    @foreach ($customerBalances as $customer)
                        <tr><td><a href="{{ route('sales.customers.ledger', $customer) }}" class="hover:underline">{{ $customer->name }}</a></td><td>{{ $customer->phone ?? '—' }}</td><td class="text-right font-semibold">{{ number_format($customer->balance, 2) }}</td></tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    @endif

    @if ($supplierBalances->isNotEmpty())
        <div class="card overflow-x-auto">
            <table class="data-table">
                <thead><tr><th>Supplier</th><th>Contact</th><th class="text-right">Balance owed</th></tr></thead>
                <tbody>
                    @foreach ($supplierBalances as $supplier)
                        <tr><td><a href="{{ route('purchasing.suppliers.ledger', $supplier) }}" class="hover:underline">{{ $supplier->name }}</a></td><td>{{ $supplier->phone ?? '—' }}</td><td class="text-right font-semibold">{{ number_format($supplier->balance, 2) }}</td></tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    @endif
    @endcan
</div>
@endsection