@extends('layouts.app')
@section('main-content')
<div class="container-fluid p-0">
    <nav class="page-breadcrumb">
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Home</a></li>
            <li class="breadcrumb-item">Low Inventory</li>
        </ol>
    </nav>
    <h1 class="h3 mb-3"><strong>Low Inventory</strong></h1>

    <div class="row">
        <div class="col-12">
            <div class="card flex-fill">
                <div class="card-header d-flex justify-content-between">
                    <h5 class="card-title mb-0">Low Stock</h5>
                </div>
                <div class="card-body mt-0 pt-0">
                    @if ($errors->any())
                    <div class="alert alert-danger">
                        <ul>
                            @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                            @endforeach
                        </ul>
                    </div>
                    @endif
                    <!-- <div class="row">
                        <form action="{{ route('inventories.lowstock') }}" method="GET">
                            <div class="col-12 d-flex">
                                <div class="col-md-2">
                                    <div class="col-md-4 d-flex">
                                        <div class="form-group text-nowrap">
                                            <label for="datefrom">Date From</label>
                                            <input type="date" name="datefrom" value="2025-03-01" class="form-control" id="datefrom">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-2">
                                    <div class="col-md-4 d-flex">
                                        <div class="form-group text-nowrap">
                                            <label for="dateto">Date To</label>
                                            <input type="date" name="dateto" value="2025-03-31" class="form-control" id="dateto">
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-2 d-flex align-items-end">
                                    <div class="col-md-4 d-flex">
                                        <div class="form-group text-nowrap">
                                            <button type="submit" class="btn btn-primary form-control" id="submit">Submit</button>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </form>
                    </div> -->
                    <div class="table-responsive pt-2">
                        <table class="table table-striped table-condensed table-lowstock">
                            <thead class="text-nowrap">
                                <th class="text-center">#</th>
                                <th class="text-start">PRODUCTS</th>
                                <th class="text-center">MIN LEVEL</th>
                                <th class="text-center">ONHAND</th>
                                <th class="text-center" rel="facebox" title="Minimum Order Quantity">MOQ</th>
                                <th class="d-none d-xl-table-cell text-end pe-2" rel="facebox" title="Last purchase date">PURCHASE</th>
                            </thead>
                            <tbody>
                                                                @forelse($inventories as $inventory)
                                @if($inventory->onhand < $inventory->threshold)
                                    <tr>
                                        <td class="text-center">1</td>
                                        <td class="text-nowrap"><a href="{{  route('inventories.addstock', $inventory->product_id) }}" target="_parent">{{ $inventory->name }}</a>
                                            <!-- <td class="text-nowrap">{{ $inventory->name }} -->
                                            <p class="mb-0 pb-0">
                                                <small>{{ $inventory->description }}</small>
                                            </p>
                                        </td>
                                        <td class="text-center">{{ $inventory->threshold }}</td>
                                        <td class="text-center">{{ $inventory->onhand }}</td>
                                        <td class="text-center"><span class="badge badge-outline-primary rounded">{{ $inventory->threshold - $inventory->onhand }}</span></td>
                                        <td class="d-none d-xl-table-cell text-end text-nowrap">{{ date('Y-m-d', strtotime($lastPurchase[$inventory->product_id]['created_at'])) }}</td>
                                    </tr>
                                    @endif
                                    @empty
                                    <tr>
                                        <td colspan="5" class="text-center">Record not found</td>
                                    </tr>
                                    @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection