@extends('layouts.finance')

@section('title', 'Inventory')
@section('subtitle', 'Voucher stock, costs and margins')

@section('content')
    @php
        $totalUnits = $products->sum(fn($p) => $p->stock);
        $totalValue = $products->sum(fn($p) => $metrics->usd($p->stock * (float) $p->cost_price, $p->currency));
        $avgMargin = $products->count() ? $products->avg(fn($p) => (float) $p->selling_price > 0 ? (((float) $p->selling_price - (float) $p->cost_price) / (float) $p->selling_price) * 100 : 0) : 0;
    @endphp
    <div class="grid grid-4 mb">
        @include('finance.partials.kpi', ['label' => 'SKUs', 'value' => $products->count()])
        @include('finance.partials.kpi', ['label' => 'Total Units', 'value' => number_format($totalUnits)])
        @include('finance.partials.kpi', ['label' => 'Total Value', 'value' => $metrics->money($totalValue)])
        @include('finance.partials.kpi', ['label' => 'Avg Margin', 'value' => number_format($avgMargin, 1).'%'])
    </div>
    <section class="card mb">
        <div class="section-head"><h2>Add Inventory Item</h2></div>
        <div class="card-pad">
            <form method="POST" action="{{ route('finance.inventory.store') }}" class="row-form">
                @csrf
                <div><label class="label">SKU</label><input class="field" name="sku"></div>
                <div><label class="label">Name</label><input class="field" name="name" required></div>
                <div><label class="label">Supplier</label><input class="field" name="category"></div>
                <div><label class="label">Cost</label><input class="field" type="number" step="0.01" min="0" name="cost_price" value="0"></div>
                <div><label class="label">Sell Price</label><input class="field" type="number" step="0.01" min="0" name="selling_price" value="0"></div>
                <div><label class="label">Currency</label><select class="field" name="currency"><option>USD</option><option>PKR</option><option>AUD</option></select></div>
                <input type="hidden" name="is_active" value="1"><button class="btn btn-primary">+ Add Item</button>
            </form>
        </div>
    </section>
    <section class="card">
        <div class="section-head"><h2>Voucher Inventory</h2></div>
        <table>
            <thead><tr><th>SKU</th><th>Name</th><th>Supplier</th><th>Qty</th><th>Cost</th><th>Sell</th><th>Cur.</th><th>Margin</th><th></th></tr></thead>
            <tbody>
            @forelse($products as $product)
                <tr>
                    <form id="product-{{ $product->id }}" method="POST" action="{{ route('finance.inventory.update', $product) }}">@csrf @method('PUT')</form>
                    <td><input form="product-{{ $product->id }}" class="field" name="sku" value="{{ $product->sku }}"></td>
                    <td><input form="product-{{ $product->id }}" class="field" name="name" value="{{ $product->name }}"></td>
                    <td><input form="product-{{ $product->id }}" class="field" name="category" value="{{ $product->category }}"></td>
                    <td>{{ number_format($product->stock) }}</td>
                    <td><input form="product-{{ $product->id }}" class="field right" type="number" step="0.01" name="cost_price" value="{{ $product->cost_price }}"></td>
                    <td><input form="product-{{ $product->id }}" class="field right" type="number" step="0.01" name="selling_price" value="{{ $product->selling_price }}"></td>
                    <td><select form="product-{{ $product->id }}" class="field" name="currency"><option @selected($product->currency === 'USD')>USD</option><option @selected($product->currency === 'PKR')>PKR</option><option @selected($product->currency === 'AUD')>AUD</option></select></td>
                    <td>{{ (float) $product->selling_price > 0 ? number_format((((float) $product->selling_price - (float) $product->cost_price) / (float) $product->selling_price) * 100, 1) : '0.0' }}%</td>
                    <td class="actions"><input form="product-{{ $product->id }}" type="hidden" name="is_active" value="{{ $product->is_active ? 1 : 0 }}"><input form="product-{{ $product->id }}" type="hidden" name="description" value="{{ $product->description }}"><button form="product-{{ $product->id }}" class="btn btn-sm">Save</button><form method="POST" action="{{ route('finance.inventory.destroy', $product) }}">@csrf @method('DELETE')<button class="btn btn-sm btn-danger">Delete</button></form></td>
                </tr>
            @empty
                <tr><td colspan="9" class="muted">No inventory items yet.</td></tr>
            @endforelse
            </tbody>
        </table>
    </section>
@endsection