@extends('layouts.app')
@section('title','Expired / Near Expiry Report')
@section('content')
<h1 class="text-lg font-bold text-gray-900 mb-4">Expired / Near Expiry Report</h1>
<div class="grid grid-cols-2 gap-3 mb-4"><div class="stat-card" style="border-left:3px solid #dc2626"><p class="text-xs text-gray-400">Expired Batches</p><p class="text-xl font-bold text-red-600">{{ $expired->count() }}</p></div><div class="stat-card" style="border-left:3px solid #f59e0b"><p class="text-xs text-gray-400">Expiring (< 3 months)</p><p class="text-xl font-bold text-amber-600">{{ $nearExpiry->count() }}</p></div></div>
@if($expired->count())<div class="bg-white rounded-xl border shadow-sm mb-4"><div class="px-5 py-3 border-b bg-red-50"><h3 class="text-sm font-bold text-red-700">Expired Stock</h3></div><table class="w-full"><thead><tr class="bg-gray-50"><th class="table-header">Drug</th><th class="table-header">Batch</th><th class="table-header">Expiry</th><th class="table-header text-right">Qty Remaining</th></tr></thead><tbody>@foreach($expired as $b)<tr class="border-b border-gray-50"><td class="table-cell text-xs font-medium">{{ $b->drugItem->name ?? '' }}</td><td class="table-cell font-mono text-xs">{{ $b->batch_number }}</td><td class="table-cell text-xs text-red-600 font-bold">{{ $b->expiry_date->format('d M Y') }}</td><td class="table-cell text-right text-xs">{{ $b->quantity_remaining }}</td></tr>@endforeach</tbody></table></div>@endif
@if($nearExpiry->count())<div class="bg-white rounded-xl border shadow-sm"><div class="px-5 py-3 border-b bg-amber-50"><h3 class="text-sm font-bold text-amber-700">Expiring Soon</h3></div><table class="w-full"><thead><tr class="bg-gray-50"><th class="table-header">Drug</th><th class="table-header">Batch</th><th class="table-header">Expiry</th><th class="table-header text-right">Qty Remaining</th></tr></thead><tbody>@foreach($nearExpiry as $b)<tr class="border-b border-gray-50"><td class="table-cell text-xs font-medium">{{ $b->drugItem->name ?? '' }}</td><td class="table-cell font-mono text-xs">{{ $b->batch_number }}</td><td class="table-cell text-xs text-amber-600 font-semibold">{{ $b->expiry_date->format('d M Y') }}</td><td class="table-cell text-right text-xs">{{ $b->quantity_remaining }}</td></tr>@endforeach</tbody></table></div>@endif
@endsection