⚠️ Inventory Expiry Alert

Generated on {{ $generated_at }}

{{ $expired_count }}
Expired
{{ $critical_count }}
Critical (≤7 days)
{{ $warning_count }}
Warning (≤30 days)
@if(count($expired) > 0)
🚫 Expired Items ({{ count($expired) }})
@foreach($expired as $item)
{{ $item['product_name'] }}
EXPIRED
🏷️ Lot: {{ $item['lot_no'] }}
@if($item['batch_no'])
📦 Batch: {{ $item['batch_no'] }}
@endif
📅 Expired: {{ $item['expiry_date'] }}
📊 Stock: {{ $item['stock'] }} units
@if(!empty($item['warehouses']))
📍 Locations: @foreach($item['warehouses'] as $wh) {{ $wh['name'] }} ({{ $wh['qty'] }}){{ !$loop->last ? ', ' : '' }} @endforeach
@endif
@endforeach
@endif @if(count($critical) > 0)
🔴 Critical - Expiring within 7 days ({{ count($critical) }})
@foreach($critical as $item)
{{ $item['product_name'] }}
{{ $item['days'] }} day{{ $item['days'] != 1 ? 's' : '' }}
🏷️ Lot: {{ $item['lot_no'] }}
@if($item['batch_no'])
📦 Batch: {{ $item['batch_no'] }}
@endif
📅 Expiry: {{ $item['expiry_date'] }}
📊 Stock: {{ $item['stock'] }} units
@if(!empty($item['warehouses']))
📍 Locations: @foreach($item['warehouses'] as $wh) {{ $wh['name'] }} ({{ $wh['qty'] }}){{ !$loop->last ? ', ' : '' }} @endforeach
@endif
@endforeach
@endif @if(count($warning) > 0)
🟡 Warning - Expiring within 30 days ({{ count($warning) }})
@foreach($warning as $item)
{{ $item['product_name'] }}
{{ $item['days'] }} days
🏷️ Lot: {{ $item['lot_no'] }}
@if($item['batch_no'])
📦 Batch: {{ $item['batch_no'] }}
@endif
📅 Expiry: {{ $item['expiry_date'] }}
📊 Stock: {{ $item['stock'] }} units
@endforeach
@endif

Take action on expiring inventory to prevent losses.

View All Expiring Items →