@extends('layouts.app')
@section('title','Stock Balance')
@section('content')
<div class="page-header">
    <div><div class="page-title">Stock Balance Report</div><div class="page-subtitle">Current inventory levels by item</div></div>
    <div class="page-actions"><button onclick="window.print()" class="btn btn-secondary"><i class="fas fa-print"></i> Print</button></div>
</div>
<form method="GET" class="card mb-4" style="padding:16px;">
    <div style="display:grid;grid-template-columns:1fr 1fr auto;gap:12px;align-items:end;">
        <div><label class="form-label">Filter by Category</label>
            <select name="category_id" class="form-control">
                <option value="">All Categories</option>
                @foreach($categories as $c)<option value="{{ $c->id }}" {{ request('category_id')==$c->id?'selected':'' }}>{{ $c->name }}</option>@endforeach
            </select>
        </div>
        <div><label class="form-label">Filter by Warehouse</label>
            <select name="warehouse_id" class="form-control">
                <option value="">All Warehouses</option>
                @foreach($warehouses as $w)<option value="{{ $w->id }}" {{ request('warehouse_id')==$w->id?'selected':'' }}>{{ $w->name }}</option>@endforeach
            </select>
        </div>
        <button type="submit" class="btn btn-primary">Filter</button>
    </div>
</form>

@php
    $totalValue = $items->sum('value');
    $lowStockCount = $items->where('low_stock',true)->count();
@endphp

<div style="display:grid;grid-template-columns:repeat(3,1fr);gap:12px;margin-bottom:20px;">
    <div class="card" style="padding:16px;"><div style="font-size:11px;color:var(--text-muted);font-weight:600;text-transform:uppercase;margin-bottom:4px;">Total Items</div><div style="font-size:20px;font-weight:700;">{{ $items->count() }}</div></div>
    <div class="card" style="padding:16px;"><div style="font-size:11px;color:var(--text-muted);font-weight:600;text-transform:uppercase;margin-bottom:4px;">Total Stock Value</div><div style="font-size:20px;font-weight:700;color:var(--primary);">৳{{ number_format($totalValue,2) }}</div></div>
    <div class="card" style="padding:16px;{{ $lowStockCount>0?'border-color:var(--warning);':'' }}"><div style="font-size:11px;color:var(--text-muted);font-weight:600;text-transform:uppercase;margin-bottom:4px;">Low Stock Items</div><div style="font-size:20px;font-weight:700;color:{{ $lowStockCount>0?'var(--danger)':'var(--success)' }};">{{ $lowStockCount }}</div></div>
</div>

<div class="card">
    <div class="table-wrapper">
        <table>
            <thead>
                <tr>
                    <th>Code</th><th>Item Name</th><th>Category</th><th>Unit</th>
                    <th class="text-right">In</th><th class="text-right">Out</th>
                    <th class="text-right">Balance</th><th class="text-right">Rate</th>
                    <th class="text-right">Value</th><th>Status</th>
                </tr>
            </thead>
            <tbody>
                @forelse($items as $item)
                <tr>
                    <td class="font-mono" style="font-size:12px;">{{ $item['code'] }}</td>
                    <td style="font-weight:500;">{{ $item['name'] }}</td>
                    <td style="color:var(--text-muted);">{{ $item['category'] ?? '-' }}</td>
                    <td>{{ $item['unit'] }}</td>
                    <td class="text-right" style="color:var(--success);">{{ number_format($item['qty_in'],2) }}</td>
                    <td class="text-right" style="color:var(--danger);">{{ number_format($item['qty_out'],2) }}</td>
                    <td class="text-right font-semibold">{{ number_format($item['balance'],2) }}</td>
                    <td class="text-right">৳{{ number_format($item['rate'],2) }}</td>
                    <td class="text-right font-semibold">৳{{ number_format($item['value'],2) }}</td>
                    <td>
                        @if($item['low_stock'])
                            <span class="badge badge-danger">Low Stock</span>
                        @elseif($item['balance'] == 0)
                            <span class="badge badge-secondary">Out of Stock</span>
                        @else
                            <span class="badge badge-success">OK</span>
                        @endif
                    </td>
                </tr>
                @empty
                <tr><td colspan="10" class="text-center text-muted" style="padding:40px;">No stock data found</td></tr>
                @endforelse
            </tbody>
            <tfoot>
                <tr>
                    <td colspan="8" style="padding:12px 16px;font-weight:700;">Total Stock Value</td>
                    <td class="text-right" style="padding:12px 16px;font-weight:700;color:var(--primary);">৳{{ number_format($totalValue,2) }}</td>
                    <td></td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>
@endsection