@extends('layouts.admin')
@section('title', 'Inventory costing')
@section('content')
@php
  $valueCents = $layers->sum(fn ($layer) => (int) round($layer->qty_remaining * $layer->unit_cost_cents));
@endphp
<x-admin.page title="Inventory costing" subtitle="FIFO cost layers by variant and location.">
    <div class="mb-5 grid gap-4 sm:grid-cols-3">
        <x-admin.card><div class="text-xs uppercase tracking-wide text-[#6d7175]">Layers</div><div class="mt-1 text-2xl font-semibold text-[#202223]">{{ $layers->total() }}</div></x-admin.card>
        <x-admin.card><div class="text-xs uppercase tracking-wide text-[#6d7175]">Qty on page</div><div class="mt-1 text-2xl font-semibold text-[#202223]">{{ number_format($layers->sum('qty_remaining'), 2) }}</div></x-admin.card>
        <x-admin.card><div class="text-xs uppercase tracking-wide text-[#6d7175]">Page value</div><div class="mt-1 text-2xl font-semibold text-[#202223]">AUD {{ number_format($valueCents / 100, 2) }}</div></x-admin.card>
    </div>

    <x-admin.advanced-table
        id="inventory-costing"
        :search-url="route('admin.accounting.inventory-costing')"
        :columns="['variant'=>'Variant','location'=>'Location','method'=>'Method','qty'=>'Qty remaining','unit'=>'Unit cost']"
    >
        <x-slot:filters>
            <form method="get" action="{{ route('admin.accounting.inventory-costing') }}" class="flex items-end gap-3">
                <div>
                    <label class="admin-label">Method</label>
                    <select name="method" class="admin-input" onchange="this.form.submit()">
                        <option value="">All</option>
                        @foreach(['fifo','avg'] as $method)
                            <option value="{{ $method }}" @selected(request('method')===$method)>{{ strtoupper($method) }}</option>
                        @endforeach
                    </select>
                </div>
                <a href="{{ route('admin.accounting.inventory-costing') }}" class="admin-btn">Clear</a>
            </form>
        </x-slot:filters>

        <thead>
            <tr>
                <th data-col="variant">Variant</th>
                <th data-col="location">Location</th>
                <th data-col="method">Method</th>
                <th data-col="qty">Qty remaining</th>
                <th data-col="unit">Unit cost</th>
            </tr>
        </thead>
        <tbody>
            @forelse($layers as $layer)
                <tr>
                    <td data-col="variant" class="font-medium">{{ $layer->variant?->sku ?? '#'.$layer->variant_id }}</td>
                    <td data-col="location" class="text-[#6d7175]">{{ $layer->location?->name ?? '#'.$layer->location_id }}</td>
                    <td data-col="method"><x-admin.badge tone="info">{{ strtoupper($layer->method) }}</x-admin.badge></td>
                    <td data-col="qty" class="tabular-nums">{{ $layer->qty_remaining }}</td>
                    <td data-col="unit" class="tabular-nums font-medium">AUD {{ number_format($layer->unit_cost_cents / 100, 2) }}</td>
                </tr>
            @empty
                <tr><td colspan="5" class="p-12 text-center text-[#6d7175]">No cost layers.</td></tr>
            @endforelse
        </tbody>
        <x-slot:footer>{{ $layers->links() }}</x-slot:footer>
    </x-admin.advanced-table>
</x-admin.page>
@endsection