⚠️ Low Stock Alert Report

Generated on: {{ $report_date }}

Stock Threshold: {{ $threshold }} units or less

@if($summary['critical_items'] > 0)
🚨 CRITICAL ALERT: {{ $summary['critical_items'] }} item(s) are completely out of stock!
@elseif($summary['items_needing_immediate_action'] > 0)
⚠️ WARNING: {{ $summary['items_needing_immediate_action'] }} item(s) need immediate reordering (less than 3 days of stock remaining).
@endif

Summary Overview

Total Low Stock Items: {{ number_format($summary['total_items']) }}
Critical (Out of Stock): {{ number_format($summary['critical_items']) }}
Very Low (1-5 units): {{ number_format($summary['very_low_items']) }}
Low (6-{{ $threshold }} units): {{ number_format($summary['low_items']) }}
Items Needing Immediate Action: {{ number_format($summary['items_needing_immediate_action']) }}
Total Reorder Value: ${{ number_format($summary['total_reorder_value'], 2) }}
@if(!empty($critical_items))
🚨 Critical Items (Out of Stock)
@foreach($critical_items as $item) @endforeach
Product ID Supplier Supplier P/N Warehouse Location Available Reserved Status
{{ $item['product_id'] }} {{ $item['supplier'] }} {{ $item['supplier_part_number'] ?? 'N/A' }} {{ $item['warehouse'] }} {{ $item['location'] }} {{ $item['available'] }} {{ $item['reserved'] }} OUT OF STOCK
@endif @if(!empty($very_low_items))
⚠️ Very Low Stock Items (1-5 units)
@foreach($very_low_items as $item) @endforeach
Product ID Supplier Supplier P/N Warehouse Location Quantity Available Reserved Value
{{ $item['product_id'] }} {{ $item['supplier'] }} {{ $item['supplier_part_number'] ?? 'N/A' }} {{ $item['warehouse'] }} {{ $item['location'] }} {{ $item['quantity'] }} {{ $item['available'] }} {{ $item['reserved'] }} ${{ number_format($item['value'], 2) }}
@endif @if(!empty($low_items))
Low Stock Items (6-{{ $threshold }} units)
@foreach($low_items as $item) @endforeach
Product ID Supplier Supplier P/N Warehouse Location Quantity Available Reserved Value
{{ $item['product_id'] }} {{ $item['supplier'] }} {{ $item['supplier_part_number'] ?? 'N/A' }} {{ $item['warehouse'] }} {{ $item['location'] }} {{ $item['quantity'] }} {{ $item['available'] }} {{ $item['reserved'] }} ${{ number_format($item['value'], 2) }}
@endif @if(!empty($reorder_suggestions))
📦 Reorder Recommendations
@foreach($reorder_suggestions as $item) @endforeach
Product ID Supplier Warehouse Current Available Daily Usage Days Left Reorder Point Order Qty Est. Value Priority
{{ $item['product_id'] }} {{ $item['supplier'] }} {{ $item['warehouse'] }} {{ $item['current_quantity'] }} {{ $item['available_quantity'] }} {{ $item['avg_daily_usage'] }} {{ $item['days_until_stockout'] < 999 ? $item['days_until_stockout'] : 'N/A' }} {{ $item['reorder_point'] }} {{ $item['suggested_quantity'] }} ${{ number_format($item['estimated_value'], 2) }} @switch($item['priority']) @case(1) CRITICAL @break @case(2) VERY URGENT @break @case(3) URGENT @break @case(4) LOW @break @default MONITOR @endswitch
@endif @if(!empty($by_supplier))
📋 Orders by Supplier
@foreach($by_supplier as $supplier_group)
{{ $supplier_group['supplier'] }} ({{ $supplier_group['total_items'] }} items, Total: ${{ number_format($supplier_group['total_value'], 2) }})
@foreach($supplier_group['items'] as $item) @endforeach
Product ID Supplier P/N Current Qty Order Qty Est. Value Priority
{{ $item['product_id'] }} {{ $item['supplier_part_number'] ?? 'N/A' }} {{ $item['current_quantity'] }} {{ $item['suggested_quantity'] }} ${{ number_format($item['estimated_value'], 2) }} @switch($item['priority']) @case(1) CRITICAL @break @case(2) VERY URGENT @break @case(3) URGENT @break @default LOW @endswitch
@endforeach @endif @if(empty($critical_items) && empty($very_low_items) && empty($low_items))

No items found below the specified threshold of {{ $threshold }} units.

All inventory levels are currently adequate.

@endif

This report was automatically generated by WHIMS - Inventory Management System

© {{ date('Y') }} Go-Parts. All rights reserved.