@extends('layouts.app') @section('title', 'Inventory Report') @section('breadcrumb') @endsection @section('content') {{-- Summary Stats --}}
{{ $products->count() }}
Total Products
Rs. {{ number_format($totalValue, 0) }}
Stock Value (Retail)
{{ $lowStock->count() }}
Low Stock Items
{{ $outOfStock->count() }}
Out of Stock
{{-- Stock Value Summary --}}
Stock Valuation
Cost Value Rs. {{ number_format($totalCost, 2) }}
Retail Value Rs. {{ number_format($totalValue, 2) }}

Potential Profit Rs. {{ number_format($potentialProfit, 2) }}
{{-- Stock by Category --}}
Stock by Category
@forelse($stockByCategory as $category => $data)
{{ $category ?? 'Uncategorized' }} {{ $data['count'] }} products
{{ number_format($data['quantity']) }} units Rs. {{ number_format($data['value'], 0) }}
@empty
No categories
@endforelse
{{-- Low Stock & Out of Stock Alerts --}}
Low Stock Alert
{{ $lowStock->count() }}
@forelse($lowStock->take(10) as $product)
@if($product->image) {{ $product->name }} @else @endif
{{ $product->name }}
{{ $product->sku }}
{{ $product->stock_quantity }} left Min: {{ $product->min_stock }}
@empty

All items in stock

@endforelse
Out of Stock
{{ $outOfStock->count() }}
@forelse($outOfStock->take(10) as $product)
@if($product->image) {{ $product->name }} @else @endif
{{ $product->name }}
{{ $product->sku }}
Out of Stock
@empty

No items out of stock

@endforelse
{{-- Top Selling Products --}}
Top Selling (30 days)
@forelse($topSelling as $index => $product)
{{ $index + 1 }}
{{ $product->product_name }}
{{ number_format($product->total_sold) }} units sold
@empty

No sales data

@endforelse
{{-- All Products Table --}}
All Products Stock
{{ $products->count() }} products
@foreach($products->sortBy('stock_quantity')->take(50) as $product) @endforeach
Image Product Category Supplier Stock Min Stock Unit Cost Price Sell Price Stock Value Status
@if($product->image) {{ $product->name }} @else @endif
{{ $product->name }}
{{ $product->sku }} @if($product->barcode) Barcode: {{ $product->barcode }} @endif
{{ $product->category?->name ?? '-' }} {{ $product->supplier?->name ?? '-' }} @if(!$product->track_stock) N/A @else {{ number_format($product->stock_quantity, 2) }} @endif {{ number_format($product->min_stock ?? 0, 2) }} {{ strtoupper($product->unit ?? 'PCS') }} Rs. {{ number_format($product->cost_price, 2) }} Rs. {{ number_format($product->selling_price, 2) }} Rs. {{ number_format($product->selling_price * $product->stock_quantity, 0) }} @if(!$product->track_stock) Untracked @elseif($product->isOutOfStock()) Out of Stock @elseif($product->isLowStock()) Low Stock @else In Stock @endif
@push('styles') @endpush @endsection