@extends('layouts.app')
@section('title', 'Bar 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">Bar Reports</h1>
            <p class="text-sm text-ink-muted">Best-sellers, consumption, stock variance and wastage for the bar.@if (str_starts_with($area, 'section:')) <span class="text-amber-700">Showing {{ $areaOptions[$area] ?? 'one counter' }} — sales figures are per counter; stock variance and wastage are recorded per store, not per counter.</span>@endif</p>
        </div>
        <div class="flex flex-wrap items-center gap-2">
            <x-period-filter :period="$period" :from="$from" :to="$to" :areas="count($areaOptions) > 1 ? $areaOptions : []" :area="$area" />
            <x-export-menu route="reports.bar.export" :params="['period' => $period, 'from' => $from->format('Y-m-d'), 'to' => $to->format('Y-m-d'), 'area' => $area]" />
        </div>
    </div>

    <div class="grid grid-cols-2 lg:grid-cols-4 gap-4">
        <x-stat-card label="Bar sales" value="{{ number_format($barSales, 0) }}" icon="martini" tone="violet" />
        @can('data.costs')
        <x-stat-card label="Beverage cost" value="{{ number_format($barCost, 0) }}" icon="package" tone="amber" />
        <x-stat-card label="Bar profit" value="{{ number_format($barProfit, 0) }}" icon="trending-up" tone="{{ $barProfit >= 0 ? 'emerald' : 'rose' }}" />
        @endcan
        <x-stat-card label="Wastage value" value="{{ number_format($wastageValue, 0) }}" icon="trash-2" tone="rose" />
    </div>

    @if ($bestSellers->isNotEmpty())
        <div class="card card-pad">
            <p class="text-sm font-semibold mb-3">Top sellers by revenue</p>
            <div class="h-64">
                <canvas data-chart='{
                    "type":"bar","color":"#7C3AED",
                    "labels": {!! $bestSellers->take(8)->keys()->toJson() !!},
                    "data": {!! $bestSellers->take(8)->pluck("revenue")->toJson() !!}
                }'></canvas>
            </div>
        </div>
    @endif

    <div class="card card-pad">
        <p class="text-sm font-semibold mb-3">Best-selling drinks</p>
        <p class="text-xs text-ink-faint mb-3">Bottle, glass and shot pours appear as separate line items here since each is its own menu product.</p>
        <table class="data-table">
            <thead><tr><th>Item</th><th class="text-right">Qty sold</th><th class="text-right">Revenue</th></tr></thead>
            <tbody>
                @forelse ($bestSellers as $name => $row)
                    <tr><td class="font-medium">{{ $name }}</td><td class="text-right">{{ $row['qty'] }}</td><td class="text-right font-semibold">{{ number_format($row['revenue'], 0) }}</td></tr>
                @empty
                    <tr><td colspan="3" class="text-center text-ink-muted py-8">No sales in this range.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>

    <div class="grid lg:grid-cols-2 gap-6">
        <div class="card card-pad">
            <p class="text-sm font-semibold mb-3">Consumption (units moved)</p>
            <table class="data-table">
                <thead><tr><th>Product</th><th class="text-right">Qty consumed</th></tr></thead>
                <tbody>
                    @forelse ($consumption->sortDesc() as $name => $qty)
                        <tr><td>{{ $name }}</td><td class="text-right font-semibold">{{ number_format($qty, 2) }}</td></tr>
                    @empty
                        <tr><td colspan="2" class="text-center text-ink-muted py-6">No stock movement in this range.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        <div class="card card-pad">
            <p class="text-sm font-semibold mb-3">Wastage ({{ $wastage->count() }} entries)</p>
            <table class="data-table">
                <thead><tr><th>Product</th><th class="text-right">Qty</th><th>Reason</th></tr></thead>
                <tbody>
                    @forelse ($wastage as $entry)
                        <tr><td>{{ $entry->product->name }}</td><td class="text-right">{{ number_format(abs($entry->quantity), 2) }}</td><td class="text-xs text-ink-muted">{{ $entry->reason ?? '—' }}</td></tr>
                    @empty
                        <tr><td colspan="3" class="text-center text-ink-muted py-6">No wastage recorded in this range.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <div class="grid lg:grid-cols-2 gap-6">
        <div class="card card-pad">
            <p class="text-sm font-semibold mb-3">Stock variance (completed stock takes)</p>
            <table class="data-table">
                <thead><tr><th>Product</th><th class="text-right">Expected</th><th class="text-right">Actual</th><th class="text-right">Variance</th></tr></thead>
                <tbody>
                    @forelse ($variance as $v)
                        <tr>
                            <td>{{ $v->product->name }}</td>
                            <td class="text-right">{{ number_format($v->expected_quantity, 2) }}</td>
                            <td class="text-right">{{ number_format($v->actual_quantity, 2) }}</td>
                            <td class="text-right font-semibold {{ $v->variance < 0 ? 'text-danger' : ($v->variance > 0 ? 'text-success' : '') }}">{{ number_format($v->variance, 2) }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="4" class="text-center text-ink-muted py-6">No completed stock take covering the bar in this range.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        <div class="card card-pad">
            <p class="text-sm font-semibold mb-3">Complimentary drinks ({{ $complimentaryItems->count() }})</p>
            <table class="data-table">
                <thead><tr><th>Item</th><th class="text-right">Qty</th><th class="text-right">Value forgone</th></tr></thead>
                <tbody>
                    @forelse ($complimentaryItems->groupBy(fn($i) => $i->product->name) as $name => $group)
                        <tr><td>{{ $name }}</td><td class="text-right">{{ $group->sum('quantity') }}</td><td class="text-right font-semibold">{{ number_format($group->sum(fn($i) => $i->quantity * $i->product->selling_price), 0) }}</td></tr>
                    @empty
                        <tr><td colspan="3" class="text-center text-ink-muted py-6">No complimentary drinks in this range.</td></tr>
                    @endforelse
                </tbody>
                @if ($complimentaryItems->isNotEmpty())
                    <tfoot><tr class="font-bold"><td colspan="2" class="px-4 py-2 text-right">Total forgone</td><td class="px-4 py-2 text-right">{{ number_format($complimentaryValue, 0) }}</td></tr></tfoot>
                @endif
            </table>
        </div>
    </div>
</div>
@endsection