@extends('pdf.layout')

@section('content')
@php
    $today = \Carbon\Carbon::today();
    $value = $expiryItems->getCollection()->sum(fn ($b) => (float) $b->quantity_remaining * (float) ($b->unit_cost ?? $b->product?->purchase_price ?? 0));
@endphp

<table class="kpis">
    <tr>
        <td><div class="kpi"><div class="label">Batches with expiry</div><div class="value">{{ number_format($totalItems) }}</div><div class="note">in stock</div></div></td>
        <td><div class="kpi"><div class="label">Expired</div><div class="value neg">{{ number_format($expiredItems) }}</div><div class="note">remove from the shelf</div></div></td>
        <td><div class="kpi"><div class="label">Expiring in 30 days</div><div class="value">{{ number_format($expiringSoonItems) }}</div><div class="note">sell first</div></div></td>
        <td><div class="kpi"><div class="label">Value listed</div><div class="value">MWK {{ number_format($value, 2) }}</div><div class="note">at cost</div></div></td>
    </tr>
</table>

@if($expiryItems->count())
<table class="data">
    <thead>
        <tr><th>Product</th><th>Batch</th><th>Supplier</th><th>Received</th><th>Expiry</th><th class="r">Days left</th><th class="r">Qty</th><th class="r">Value (MWK)</th><th class="c">Status</th></tr>
    </thead>
    <tbody>
        @foreach($expiryItems as $b)
            @php
                $days = $b->expiry_date ? (int) $today->diffInDays($b->expiry_date, false) : null;
                [$class, $text] = $days === null ? ['badge-grey', 'No date'] : ($days < 0 ? ['badge-red', 'Expired'] : ($days <= 30 ? ['badge-amber', 'Expiring soon'] : ['badge-green', 'Valid']));
            @endphp
            <tr>
                <td>{{ $b->product?->name ?? 'Deleted product' }}<div class="small muted">{{ $b->product?->sku }}</div></td>
                <td class="b">{{ $b->batch_no }}</td>
                <td>{{ $b->purchaseItem?->purchase?->supplier?->name ?? $b->product?->supplier?->name ?? '-' }}</td>
                <td class="nowrap">{{ ($b->received_at ?? $b->created_at)->format('d M Y') }}</td>
                <td class="nowrap b">{{ $b->expiry_date?->format('d M Y') }}</td>
                <td class="r {{ $days !== null && $days < 0 ? 'neg' : '' }}">{{ $days === null ? '-' : ($days < 0 ? abs($days) . ' ago' : $days) }}</td>
                <td class="r">{{ (float) $b->quantity_remaining }}</td>
                <td class="r">{{ number_format((float) $b->quantity_remaining * (float) ($b->unit_cost ?? $b->product?->purchase_price ?? 0), 2) }}</td>
                <td class="c"><span class="badge {{ $class }}">{{ $text }}</span></td>
            </tr>
        @endforeach
        <tr class="total"><td colspan="6">Total ({{ $expiryItems->count() }} batches)</td><td class="r">{{ (float) $expiryItems->getCollection()->sum('quantity_remaining') }}</td><td class="r">{{ number_format($value, 2) }}</td><td></td></tr>
    </tbody>
</table>
@else
    <div class="empty">No batches match these filters.</div>
@endif
@endsection