@extends('layouts.app')

@section('title', 'Inventory Report')

@section('content')
<div class="d-flex justify-content-between align-items-center mb-4">
    <h1 class="page-title mb-0">Inventory Report</h1>
    <a href="{{ route('reports.index') }}" class="btn btn-outline-secondary">Back</a>
</div>

<div class="row g-3 mb-4">
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="text-muted small">Total Products</div>
                <div class="fw-bold fs-4">{{ $products->count() }}</div>
            </div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="text-muted small">Low Stock (≤5)</div>
                <div class="fw-bold fs-4 text-warning">{{ $lowStock }}</div>
            </div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="text-muted small">Out of Stock</div>
                <div class="fw-bold fs-4 text-danger">{{ $outOfStock }}</div>
            </div>
        </div>
    </div>
</div>

<div class="card mb-4">
    <div class="card-body">
        <div class="d-flex justify-content-between align-items-center">
            <h5 class="mb-0">Total Inventory Value</h5>
            <div class="fw-bold fs-4">₹{{ number_format($totalValue, 2) }}</div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-bordered table-hover align-middle mb-0">
                <thead>
                    <tr>
                        <th>Product</th>
                        <th>Category</th>
                        <th>Size</th>
                        <th>Color</th>
                        <th>Purchase Price</th>
                        <th>Selling Price</th>
                        <th>Quantity</th>
                        <th>Value</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($products as $product)
                        <tr>
                            <td class="fw-medium">{{ $product->name }}</td>
                            <td>{{ $product->category->name ?? '—' }}</td>
                            <td>{{ $product->size ?? '—' }}</td>
                            <td>{{ $product->color ?? '—' }}</td>
                            <td>₹{{ number_format($product->purchase_price, 2) }}</td>
                            <td>₹{{ number_format($product->selling_price, 2) }}</td>
                            <td>{{ $product->quantity }}</td>
                            <td>₹{{ number_format($product->quantity * $product->selling_price, 2) }}</td>
                            <td>
                                @if($product->quantity <= 0)
                                    <span class="badge bg-danger">Out of Stock</span>
                                @elseif($product->quantity <= 5)
                                    <span class="badge bg-warning">Low Stock</span>
                                @else
                                    <span class="badge bg-success">In Stock</span>
                                @endif
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="text-center text-muted py-4">No products found.</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection