@extends('Kitchen.layout')

@section('content')

<div class="row align-items-center justify-content-between mb-3 mt-3">
    <div class="col-auto">
        <h5>Aging — Batch Expiry Tracker</h5>
    </div>
</div>

<div class="card p-0 m-2">
    <div class="table-responsive pt-0 pb-2">
        <table class="table">
            <thead>
                <tr>
                    <th>Sno</th>
                    <th>Category</th>
                    <th>Product Name</th>
                    <th>Product Id</th>
                    <th>Batch</th>
                    <th>Stock (this batch)</th>
                    <th>Packed Date</th>
                    <th>Expiry Date</th>
                    <th>Status</th>
                </tr>
            </thead>
            <tbody>
                @forelse($batches as $index => $batch)
                    @php
                        $today = \Carbon\Carbon::today();
                        $expiry = \Carbon\Carbon::parse($batch->expiry_date);
                        $daysLeft = $today->diffInDays($expiry, false);

                        if ($daysLeft < 0) {
                            $rowClass = 'table-danger';
                            $statusText = 'Expired (' . abs($daysLeft) . ' days ago)';
                        } elseif ($daysLeft == 0) {
                            $rowClass = 'table-danger';
                            $statusText = 'Expires Today';
                        } elseif ($daysLeft <= 3) {
                            $rowClass = 'table-warning';
                            $statusText = $daysLeft . ' day(s) left';
                        } else {
                            $rowClass = '';
                            $statusText = $daysLeft . ' day(s) left';
                        }
                    @endphp
                    <tr class="{{ $rowClass }}">
                        <td>{{ $index + 1 }}</td>
                        <td>{{ $batch->product->category?->category ?? '-' }}</td>
                        <td>{{ $batch->product->product_name ?? '-' }}</td>
                        <td>{{ $batch->product->product_id ?? '-' }}</td>
                        <td>Batch {{ $batch->batch_number }}</td>
                        <td>{{ $batch->stock }}</td>
                        <td>{{ $batch->packed_date ? \Carbon\Carbon::parse($batch->packed_date)->format('d-m-Y') : '-' }}</td>
                        <td>{{ \Carbon\Carbon::parse($batch->expiry_date)->format('d-m-Y') }}</td>
                        <td><strong>{{ $statusText }}</strong></td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="9" class="text-center py-4 text-muted">
                            No batches with expiry date set.
                        </td>
                    </tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>

@endsection