@extends('layout')@section('c')<div class="head"><h1>Inventory</h1></div>
<div class="kpis"><div class="kpi f"><span>Stock value (at average cost)</span><b>{{ number_format($value,2) }}</b></div><div class="kpi f"><span>Low-stock items</span><b>{{ $lowCount }}</b></div></div>
<details class="card"><summary><b>＋ Add item</b></summary><form method="post" action="{{ url('/') }}/inventory" style="margin-top:10px">@csrf<div class="fg">
<label>Name *<input name="name" required></label><label>SKU<input name="sku"></label><label>Category<input name="category"></label><label>Unit<input name="unit" value="pcs"></label>
<label>Reorder level<input type="number" step="0.01" name="reorder_level" value="0"></label><label>Location<input name="location"></label></div><button>Add item</button></form></details>
<form method="get" class="card"><input name="q" value="{{ request('q') }}" placeholder="Search name, SKU, category">
<label style="display:inline-flex;gap:6px;align-items:center"><input type="checkbox" name="low" value="1" @checked($low) onchange="this.form.submit()" style="width:auto"> Low stock only</label><button>Search</button></form>
<div class="card" style="padding:0;overflow:auto"><table><tr><th>SKU</th><th>Name</th><th>Category</th><th>Quantity</th><th>Avg cost</th><th>Value</th><th>Status</th></tr>
@foreach($rows as $i)@php $low2 = $i->reorder_level>0 && $i->quantity<=$i->reorder_level; @endphp
<tr><td>{{ $i->sku }}</td><td><a href="{{ url('/') }}/inventory/{{ $i->id }}"><b>{{ $i->name }}</b></a></td><td>{{ $i->category }}</td><td>{{ number_format($i->quantity,2) }} {{ $i->unit }}</td><td>{{ number_format($i->avg_cost,2) }}</td><td>{{ number_format($i->quantity*$i->avg_cost,2) }}</td>
<td>@if($low2)<span class="pill bad">Low stock</span>@else<span class="pill done">OK</span>@endif</td></tr>@endforeach
@if(!$rows->count())<tr><td colspan="7" class="muted">No items found.</td></tr>@endif</table></div>@endsection