@extends('admin.layouts.master')
@section('title', 'Add Product Inventory')
@section('content')

    <section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-lg-12 mt-2">
                    <div class="card card-primary card-outline">

                        <!-- /.card-header -->
                        <div class="card-body">
                            <form class="form-horizontal pb-2" action="{{ route('admin.product-inventory.store') }}"
                                method="post">
                                @csrf

                                <div class="row">

                                    <div class="form-group col-3">
                                        <label for="product_id">Product</label>
                                        <select id="product_id" name="product_id" class="form-control select2">
                                            @foreach ($products as $product)
                                                <option value="{{ $product->id }}">
                                                    {{ $product->category->category_name }}-{{ $product->subCategory->sub_category_name }}-{{ $product->product_name }}
                                                </option>
                                            @endforeach
                                            @if ($errors->has('product_id'))
                                                <p class="text-danger"> {{ $errors->first('product_id') }} </p>
                                            @endif
                                        </select>
                                    </div>

                                    <div class="col-3">
                                        <label for="quantity" class="control-label">{{ __('Quantity') }}<span
                                                class="text-danger">*</span></label>
                                        <input type="text" id="quantity" class="form-control" name="quantity"
                                            value="{{ old('quantity') }}" placeholder="{{ __('Enter Quantity') }}">
                                        @if ($errors->has('quantity'))
                                            <p class="text-danger">{{ $errors->first('quantity') }}</p>
                                        @endif
                                    </div>

                                    <div class="form-group col-3">
                                        <label for="entry_date">{{ __('Entry  Date') }} <span
                                                class="text-danger">*</span></label>
                                        <input type="date" class="form-control" id="entry_date" name="entry_date"
                                            value="{{ old('entry_date') ?? date('Y-m-d') }}"
                                            placeholder="Enter Entry Date">
                                        @if ($errors->has('entry_date'))
                                            <p class="text-danger"> {{ $errors->first('entry_date') }} </p>
                                        @endif
                                    </div>

                                    <div class="col-3 align-self-center mt-3">
                                        <button type="submit" class="btn btn-primary">{{ __('Save') }}</button>
                                    </div>

                                </div>

                            </form>

                            <hr class="m-0">

                            <div class="row">

                                <div class="col">

                                    <div class="card-body">
                                        <table class="table table-striped table-bordered datatable">
                                            <thead>
                                                <tr>
                                                    <th>{{ __('#') }}</th>
                                                    <th>{{ __('Product Name') }}</th>
                                                    <th>{{ __('Quantity') }}</th>
                                                    <th>{{ __('Date') }}</th>
                                                    <th>{{ __('Current Stock') }}</th>
                                                </tr>
                                            </thead>
                                            <tbody>

                                                @foreach ($productInventoryDetails as $id => $inventory)
                                                    <tr>
                                                        <td>
                                                            {{ ++$id }}
                                                        </td>

                                                        <td>
                                                            {{ $inventory->product->category->category_name }}-{{ $inventory->product->subCategory->sub_category_name }}-{{ $inventory->product->product_name }}
                                                        </td>

                                                        <td>
                                                            {{ $inventory->quantity }}
                                                        </td>

                                                        <td>{{ \Carbon\Carbon::parse($inventory->created_at)->format('d-m-Y') }}
                                                        </td>
                                                        @php
                                                            $latestInventory = \App\Models\ProductInventory::where(
                                                                'product_id',
                                                                $inventory->product->id,
                                                            )
                                                                ->orderBy('created_at', 'desc')
                                                                ->first();
                                                        @endphp
                                                        <td>
                                                            {{ $latestInventory->current_stock }}
                                                        </td>
                                                    </tr>
                                                @endforeach

                                            </tbody>
                                        </table>
                                    </div>

                                </div>

                            </div>

                        </div>

    </section>


@endsection