@extends('layouts.app')
@section('title', 'Batch Report')

@section('content')
@php
    $statusBadges = [
        'expired' => ['danger', 'Expired'],
        'expiring' => ['warning', 'Expiring soon'],
        'valid' => ['success', 'Good'],
        'none' => ['secondary', 'No expiry'],
    ];
@endphp
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center flex-wrap gap-2 mb-3">
        <div>
            <h4 class="fw-bold mb-0">Batch Report</h4>
            <small class="text-muted">Search a batch number to see every item received under it</small>
        </div>
        @include('partials.pdf-button')
    </div>

    <!-- Totals -->
    <div class="row g-3 mb-3">
        <div class="col-6 col-md-3">
            <div class="card border-0 shadow-sm h-100"><div class="card-body">
                <div class="small text-muted fw-semibold text-uppercase">Batches</div>
                <div class="h4 fw-bold mb-0">{{ number_format($totals['batches']) }}</div>
            </div></div>
        </div>
        <div class="col-6 col-md-3">
            <div class="card border-0 shadow-sm h-100"><div class="card-body">
                <div class="small text-muted fw-semibold text-uppercase">Units in stock</div>
                <div class="h4 fw-bold mb-0">{{ number_format($totals['in_stock']) }}</div>
            </div></div>
        </div>
        <div class="col-6 col-md-3">
            <a href="{{ route('reports.batches', ['status' => 'expiring']) }}" class="text-decoration-none">
                <div class="card border-0 shadow-sm h-100" style="background:#fff7ed"><div class="card-body">
                    <div class="small fw-semibold text-uppercase" style="color:#c2410c">Expiring in 30 days</div>
                    <div class="h4 fw-bold mb-0" style="color:#c2410c">{{ number_format($totals['expiring']) }}</div>
                </div></div>
            </a>
        </div>
        <div class="col-6 col-md-3">
            <a href="{{ route('reports.batches', ['status' => 'expired']) }}" class="text-decoration-none">
                <div class="card border-0 shadow-sm h-100" style="background:#fef2f2"><div class="card-body">
                    <div class="small fw-semibold text-uppercase text-danger">Expired, still in stock</div>
                    <div class="h4 fw-bold mb-0 text-danger">{{ number_format($totals['expired']) }}</div>
                </div></div>
            </a>
        </div>
    </div>

    <!-- Search -->
    <form method="GET" action="{{ route('reports.batches') }}" class="card border-0 shadow-sm mb-3 d-print-none">
        <div class="card-body d-flex flex-wrap gap-2">
            <div class="position-relative flex-grow-1" style="min-width: 220px;">
                <i class="bi bi-search position-absolute text-muted" style="left: 12px; top: 50%; transform: translateY(-50%);"></i>
                <input type="search" name="search" value="{{ $search }}" class="form-control ps-5" placeholder="Batch number, product or SKU" autofocus>
            </div>
            <select name="status" class="form-select" style="max-width: 200px;" onchange="this.form.submit()">
                <option value="all" @selected($status === 'all')>All batches</option>
                <option value="in_stock" @selected($status === 'in_stock')>In stock</option>
                <option value="expiring" @selected($status === 'expiring')>Expiring in 30 days</option>
                <option value="expired" @selected($status === 'expired')>Expired</option>
                <option value="used_up" @selected($status === 'used_up')>Used up</option>
            </select>
            <button class="btn btn-primary px-4">Search</button>
            @if($search !== '' || $status !== 'all')
                <a href="{{ route('reports.batches') }}" class="btn btn-light border">Clear</a>
            @endif
        </div>
    </form>

    <!-- One card per batch number -->
    @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 * (float) ($b->unit_cost ?? $b->product?->purchase_price ?? 0));
        @endphp
        <div class="card border-0 shadow-sm mb-3">
            <div class="card-header bg-white d-flex justify-content-between align-items-center flex-wrap gap-2 py-3">
                <div>
                    <span class="text-muted small text-uppercase fw-semibold">Batch</span>
                    <span class="h5 fw-bold mb-0 ms-1">{{ $group->batch_no }}</span>
                </div>
                <div class="small text-muted">
                    {{ $items->count() }} {{ Str::plural('item', $items->count()) }}
                    · <strong class="text-dark">{{ number_format($units) }}</strong> in stock
                    · {{ formatCurrency($value) }}
                </div>
            </div>
            <div class="table-responsive">
                <table class="table table-hover align-middle mb-0 small">
                    <thead class="table-light text-muted text-uppercase" style="font-size: .72rem;">
                        <tr>
                            <th class="ps-3">Product</th>
                            <th>Expiry</th>
                            <th>Received</th>
                            <th class="text-end">Received qty</th>
                            <th class="text-end">Sold</th>
                            <th class="text-end">In stock</th>
                            <th class="text-end">Value</th>
                            <th class="pe-3">Status</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($items as $batch)
                            @php
                                $remaining = (float) $batch->quantity_remaining;
                                [$badge, $label] = $remaining > 0 ? $statusBadges[$batch->expiryStatus()] : ['secondary', 'Used up'];
                                $days = $batch->expiry_date ? (int) \Carbon\Carbon::today()->diffInDays($batch->expiry_date, false) : null;
                            @endphp
                            <tr class="{{ $remaining > 0 ? '' : 'text-muted' }}">
                                <td class="ps-3">
                                    @if($batch->product)
                                        <a href="{{ route('products.edit', $batch->product) }}#batches" class="fw-semibold text-decoration-none">{{ $batch->product->name }}</a>
                                        <div class="text-muted" style="font-size: .72rem;">{{ $batch->product->sku }}</div>
                                    @else
                                        <span class="text-danger">Deleted product</span>
                                    @endif
                                </td>
                                <td>
                                    {{ $batch->expiry_date ? $batch->expiry_date->format('d M Y') : '—' }}
                                    @if($days !== null && $remaining > 0)
                                        <div style="font-size: .72rem;" class="{{ $days < 0 ? 'text-danger' : ($days <= 30 ? 'text-warning-emphasis' : 'text-muted') }}">
                                            {{ $days < 0 ? abs($days) . ' days ago' : ($days === 0 ? 'today' : 'in ' . $days . ' days') }}
                                        </div>
                                    @endif
                                </td>
                                <td>{{ ($batch->received_at ?? $batch->created_at)->format('d M Y') }}</td>
                                <td class="text-end">{{ (float) $batch->quantity_received }}</td>
                                <td class="text-end">{{ (float) ($sold[$batch->id] ?? 0) }}</td>
                                <td class="text-end fw-bold">{{ $remaining }}</td>
                                <td class="text-end">{{ formatCurrency($remaining * (float) ($batch->unit_cost ?? $batch->product?->purchase_price ?? 0)) }}</td>
                                <td class="pe-3"><span class="badge bg-{{ $badge }}">{{ $label }}</span></td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    @empty
        <div class="card border-0 shadow-sm">
            <div class="card-body text-center text-muted py-5">
                <i class="bi bi-layers fs-1 opacity-25 d-block mb-2"></i>
                {{ $search !== '' ? 'No batch matches "' . $search . '".' : 'No batches yet.' }}
            </div>
        </div>
    @endforelse

    <div class="d-print-none">{{ $groups->links() }}</div>
</div>
@endsection