@extends('layouts.app')

@section('title', 'Stores Ledger')

@section('content')
    @php
        $money = fn ($v) => \App\Support\Fmt::money($v);
        $num = fn ($v) => \App\Support\Fmt::plain($v, 2);
        $day = fn ($v) => \App\Support\Fmt::day($v instanceof \DateTimeInterface ? $v->format('Y-m-d') : $v);
        $sel = 'h-9 w-full rounded-lg border border-input bg-transparent px-3 text-sm outline-none focus-visible:border-ring focus-visible:ring-3 focus-visible:ring-ring/50';
        $th = 'px-4 py-2 text-left text-xs font-medium text-muted-foreground';
        $thr = 'px-4 py-2 text-right text-xs font-medium text-muted-foreground';
        $csv = fn ($name, $params = []) => route($name, array_filter($params, fn ($v) => $v !== 'all' && $v !== '' && $v !== 'both'));
        $movParams = ['store' => $filters['store'], 'type' => $filters['type'], 'direction' => $filters['direction'],
                      'document' => $filters['document'], 'category' => $filters['category'],
                      'from' => $filters['from'], 'to' => $filters['to'], 'q' => $filters['q']];
        $tabs = [
            ['key' => 'movements', 'label' => 'Movements', 'href' => route('kitchen.stores-ledger', $filters + ['tab' => 'movements'])],
            ['key' => 'summary', 'label' => 'Ledger summary', 'href' => route('kitchen.stores-ledger', $filters + ['tab' => 'summary'])],
            ['key' => 'bin', 'label' => 'Bin card', 'href' => route('kitchen.stores-ledger', $filters + ['tab' => 'bin'])],
        ];
    @endphp
    <div class="flex flex-col gap-6">
        <div>
            <p class="text-xs font-medium text-muted-foreground">Every receipt, issue, transfer, waste and adjustment posted to the stores</p>
            <h1 class="text-lg font-semibold">Stores Ledger</h1>
        </div>

        @include('partials.flashes')

        <div class="flex flex-wrap items-center justify-between gap-3">
            <div class="flex flex-wrap gap-1 rounded-lg border border-border bg-card p-1">
                @foreach ($tabs as $t)
                    <a href="{{ $t['href'] }}"
                       class="rounded-md px-3 py-1.5 text-sm transition-colors {{ $tab === $t['key'] ? 'bg-accent font-medium text-accent-foreground' : 'text-muted-foreground hover:bg-accent' }}">
                        {{ $t['label'] }}
                    </a>
                @endforeach
            </div>
            <div class="flex flex-wrap gap-2">
                <a href="{{ route('kitchen.stores-ledger.csv', $movParams) }}"
                   class="flex h-9 items-center rounded-lg border border-border px-3 text-sm hover:bg-accent">Movements CSV</a>
                <a href="{{ route('kitchen.stores-ledger.summary.csv') }}"
                   class="flex h-9 items-center rounded-lg border border-border px-3 text-sm hover:bg-accent">Summary CSV</a>
                @if ($binItem)
                    <a href="{{ route('kitchen.stores-ledger.bin.csv', ['bin_item' => $binItem]) }}"
                       class="flex h-9 items-center rounded-lg border border-border px-3 text-sm hover:bg-accent">Bin card CSV</a>
                @endif
            </div>
        </div>

        <div class="grid grid-cols-2 gap-3 lg:grid-cols-4">
            @foreach ([
                ['label' => 'Movements shown', 'value' => (string) $movements->count()],
                ['label' => 'Movements posted', 'value' => (string) $totalPosted],
                ['label' => 'Items tracked', 'value' => (string) $items->count()],
                ['label' => 'Items in summary', 'value' => (string) $summary->count()],
            ] as $card)
                <div class="rounded-xl border border-border bg-card p-4">
                    <span class="block text-lg font-semibold tabular-nums">{{ $card['value'] }}</span>
                    <span class="block text-xs text-muted-foreground">{{ $card['label'] }}</span>
                </div>
            @endforeach
        </div>

        @if ($tab === 'movements')
            <div class="rounded-xl border border-border bg-card">
                <form method="get" action="{{ route('kitchen.stores-ledger') }}" class="grid gap-3 border-b border-border p-4 md:grid-cols-6">
                    <input type="hidden" name="tab" value="movements">
                    <x-field label="Search"><x-input name="q" value="{{ $filters['q'] }}" placeholder="Item, document, by" /></x-field>
                    <x-field label="Store">
                        <select name="store" class="{{ $sel }}">
                            @foreach ($storeOptions as $id => $name)
                                <option value="{{ $id }}" @selected($filters['store'] === (string) $id)>{{ $name }}</option>
                            @endforeach
                        </select>
                    </x-field>
                    <x-field label="Type">
                        <select name="type" class="{{ $sel }}">
                            <option value="all">All types</option>
                            @foreach ($types as $t)
                                <option value="{{ $t }}" @selected($filters['type'] === $t)>{{ $t }}</option>
                            @endforeach
                        </select>
                    </x-field>
                    <x-field label="Direction">
                        <select name="direction" class="{{ $sel }}">
                            <option value="all">Both</option>
                            <option value="In" @selected($filters['direction'] === 'In')>In</option>
                            <option value="Out" @selected($filters['direction'] === 'Out')>Out</option>
                        </select>
                    </x-field>
                    <x-field label="Document">
                        <select name="document" class="{{ $sel }}">
                            <option value="all">All documents</option>
                            @foreach ($documents as $d)
                                <option value="{{ $d }}" @selected($filters['document'] === $d)>{{ $d }}</option>
                            @endforeach
                        </select>
                    </x-field>
                    <x-field label="Category">
                        <select name="category" class="{{ $sel }}">
                            <option value="both" @selected($filters['category'] === 'both')>Food &amp; non-food</option>
                            @foreach ($categories as $c)
                                <option value="{{ strtolower(str_replace('-', '', $c)) }}" @selected($filters['category'] === strtolower(str_replace('-', '', $c)))>{{ $c }}</option>
                            @endforeach
                        </select>
                    </x-field>
                    <x-field label="From"><x-input type="date" name="from" value="{{ $filters['from'] }}" /></x-field>
                    <x-field label="To"><x-input type="date" name="to" value="{{ $filters['to'] }}" /></x-field>
                    <div class="flex items-end gap-2 md:col-span-2">
                        <button class="h-9 rounded-lg bg-primary px-3 text-sm font-medium text-primary-foreground hover:bg-primary/90">Filter</button>
                        <a href="{{ route('kitchen.stores-ledger', ['tab' => 'movements']) }}"
                           class="flex h-9 items-center rounded-lg border border-border px-3 text-sm hover:bg-accent">Reset</a>
                    </div>
                </form>

                <div class="overflow-x-auto">
                    <table class="w-full text-sm">
                        <thead>
                            <tr class="border-b border-border">
                                <th class="{{ $th }}">Date</th>
                                <th class="{{ $th }}">Item</th>
                                <th class="{{ $th }}">Store</th>
                                <th class="{{ $th }}">Type</th>
                                <th class="{{ $thr }}">In</th>
                                <th class="{{ $thr }}">Out</th>
                                <th class="{{ $thr }}">Unit cost</th>
                                <th class="{{ $thr }}">Value</th>
                                <th class="{{ $thr }}">Balance after</th>
                                <th class="{{ $th }}">Document</th>
                                <th class="{{ $th }}">By</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($movements as $m)
                                <tr class="border-b border-border/60 last:border-0">
                                    <td class="px-4 py-2 text-xs">{{ $day($m->moved_on) }}</td>
                                    <td class="px-4 py-2 font-medium">{{ $m->item?->name ?? '—' }}</td>
                                    <td class="px-4 py-2">{{ $m->store?->name ?? '—' }}</td>
                                    <td class="px-4 py-2 text-xs">{{ $m->type }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums text-emerald-700">{{ $m->qty_in > 0 ? $num($m->qty_in) : '—' }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums text-rose-700">{{ $m->qty_out > 0 ? $num($m->qty_out) : '—' }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums">{{ $money($m->unit_cost) }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums">{{ $money($m->value) }}</td>
                                    <td class="px-4 py-2 text-right font-medium tabular-nums">{{ $num($m->balance_after) }}</td>
                                    <td class="px-4 py-2 font-mono text-[11px]">{{ $m->document ?: '—' }}</td>
                                    <td class="px-4 py-2 text-xs">{{ $m->by }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="11" class="px-4 py-8 text-center text-muted-foreground">No movements match these filters.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        @elseif ($tab === 'summary')
            <div class="rounded-xl border border-border bg-card">
                <div class="flex items-center justify-between border-b border-border px-4 py-3">
                    <h2 class="text-sm font-medium">Opening to closing rollup per item</h2>
                    <span class="text-xs text-muted-foreground">{{ $summary->count() }} item(s)</span>
                </div>
                <div class="overflow-x-auto">
                    <table class="w-full text-sm">
                        <thead>
                            <tr class="border-b border-border">
                                <th class="{{ $th }}">Item</th>
                                <th class="{{ $thr }}">Opening</th>
                                <th class="{{ $thr }}">Receipts</th>
                                <th class="{{ $thr }}">Issues</th>
                                <th class="{{ $thr }}">Transfer in</th>
                                <th class="{{ $thr }}">Transfer out</th>
                                <th class="{{ $thr }}">Waste</th>
                                <th class="{{ $thr }}">Adjustment</th>
                                <th class="{{ $thr }}">Closing</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($summary as $r)
                                <tr class="border-b border-border/60 last:border-0">
                                    <td class="px-4 py-2 font-medium">{{ $r['item'] }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums">{{ $num($r['opening']) }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums text-emerald-700">{{ $num($r['receipts']) }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums text-rose-700">{{ $num($r['issues']) }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums">{{ $num($r['transfer_in']) }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums">{{ $num($r['transfer_out']) }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums">{{ $num($r['waste']) }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums">{{ \App\Support\Fmt::signed($r['adjustment']) }}</td>
                                    <td class="px-4 py-2 text-right font-medium tabular-nums">{{ $num($r['closing']) }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="9" class="px-4 py-8 text-center text-muted-foreground">Nothing posted to the ledger yet.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        @else
            <div class="rounded-xl border border-border bg-card">
                <form method="get" action="{{ route('kitchen.stores-ledger') }}" class="flex flex-wrap items-end gap-3 border-b border-border p-4">
                    <input type="hidden" name="tab" value="bin">
                    <div class="min-w-64">
                        <x-field label="Item">
                            <select name="bin_item" class="{{ $sel }}" onchange="this.form.submit()">
                                <option value="">Select an item &mdash; choose one to see its bin card</option>
                                @foreach ($items as $item)
                                    <option value="{{ $item->id }}" @selected((string) $binItem === (string) $item->id)>
                                        {{ $item->name }} ({{ $item->store?->name }})
                                    </option>
                                @endforeach
                            </select>
                        </x-field>
                    </div>
                    <noscript><button class="h-9 rounded-lg bg-primary px-3 text-sm font-medium text-primary-foreground">Show</button></noscript>
                </form>

                <div class="overflow-x-auto">
                    <table class="w-full text-sm">
                        <thead>
                            <tr class="border-b border-border">
                                <th class="{{ $th }}">Date</th>
                                <th class="{{ $th }}">Store</th>
                                <th class="{{ $th }}">Type</th>
                                <th class="{{ $th }}">Document</th>
                                <th class="{{ $thr }}">In</th>
                                <th class="{{ $thr }}">Out</th>
                                <th class="{{ $thr }}">Unit cost</th>
                                <th class="{{ $thr }}">Balance after</th>
                                <th class="{{ $th }}">By</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($binMovements as $m)
                                <tr class="border-b border-border/60 last:border-0">
                                    <td class="px-4 py-2 text-xs">{{ $day($m->moved_on) }}</td>
                                    <td class="px-4 py-2">{{ $m->store?->name ?? '—' }}</td>
                                    <td class="px-4 py-2 text-xs">{{ $m->type }}</td>
                                    <td class="px-4 py-2 font-mono text-[11px]">{{ $m->document ?: '—' }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums text-emerald-700">{{ $m->qty_in > 0 ? $num($m->qty_in) : '—' }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums text-rose-700">{{ $m->qty_out > 0 ? $num($m->qty_out) : '—' }}</td>
                                    <td class="px-4 py-2 text-right tabular-nums">{{ $money($m->unit_cost) }}</td>
                                    <td class="px-4 py-2 text-right font-medium tabular-nums">{{ $num($m->balance_after) }}</td>
                                    <td class="px-4 py-2 text-xs">{{ $m->by }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="9" class="px-4 py-8 text-center text-muted-foreground">
                                    {{ $binItem ? 'No movements posted for this item yet.' : 'Select an item to open its bin card.' }}
                                </td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        @endif
    </div>
@endsection