@extends('pdf.layout')

@section('content')
@php
    $today = \Carbon\Carbon::today();
    $cost = fn ($b) => (float) ($b->unit_cost ?? $b->product?->purchase_price ?? 0);
@endphp

<table class="kpis">
    <tr>
        <td><div class="kpi"><div class="label">Batches</div><div class="value">{{ number_format($totals['batches']) }}</div></div></td>
        <td><div class="kpi"><div class="label">Units in stock</div><div class="value">{{ number_format($totals['in_stock']) }}</div></div></td>
        <td><div class="kpi"><div class="label">Expiring in 30 days</div><div class="value">{{ number_format($totals['expiring']) }}</div></div></td>
        <td><div class="kpi"><div class="label">Expired, still in stock</div><div class="value neg">{{ number_format($totals['expired']) }}</div></div></td>
    </tr>
</table>

@forelse($groups as $group)
    @php
        $items = $batches[$group->batch_no] ?? collect();
        $units = $items->sum(fn ($b) => (float) $b->quantity_remaining);
        $value = $items->sum(fn ($b) => (float) $b->quantity_remaining * $cost($b));
    @endphp
    <h3>Batch {{ $group->batch_no }} <span class="muted small">- {{ $items->count() }} item(s), {{ number_format($units) }} in stock, MWK {{ number_format($value, 2) }}</span></h3>
    <table class="data">
        <thead>
            <tr><th style="width: 32%;">Product</th><th>Expiry</th><th>Received</th><th class="r">Received qty</th><th class="r">Sold</th><th class="r">In stock</th><th class="r">Value (MWK)</th><th class="c">Status</th></tr>
        </thead>
        <tbody>
            @foreach($items as $b)
                @php
                    $left = (float) $b->quantity_remaining;
                    $days = $b->expiry_date ? (int) $today->diffInDays($b->expiry_date, false) : null;
                    [$class, $text] = $left <= 0 ? ['badge-grey', 'Used up']
                        : ($days === null ? ['badge-grey', 'No expiry'] : ($days < 0 ? ['badge-red', 'Expired'] : ($days <= 30 ? ['badge-amber', 'Expiring'] : ['badge-green', 'Good'])));
                @endphp
                <tr>
                    <td>{{ $b->product->name ?? 'Deleted product' }}<div class="small muted">{{ $b->product->sku ?? '' }}</div></td>
                    <td class="nowrap">{{ $b->expiry_date?->format('d M Y') ?? '-' }}@if($days !== null && $left > 0)<div class="small {{ $days < 0 ? 'neg' : 'muted' }}">{{ $days < 0 ? abs($days) . ' days ago' : ($days === 0 ? 'today' : 'in ' . $days . ' days') }}</div>@endif</td>
                    <td class="nowrap">{{ ($b->received_at ?? $b->created_at)->format('d M Y') }}</td>
                    <td class="r">{{ (float) $b->quantity_received }}</td>
                    <td class="r">{{ (float) ($sold[$b->id] ?? 0) }}</td>
                    <td class="r b">{{ $left }}</td>
                    <td class="r">{{ number_format($left * $cost($b), 2) }}</td>
                    <td class="c"><span class="badge {{ $class }}">{{ $text }}</span></td>
                </tr>
            @endforeach
        </tbody>
    </table>
@empty
    <div class="empty">No batches match these filters.</div>
@endforelse
@endsection