@extends('layouts.app')

@section('content')
    <!-- start page title -->
    <div class="row">
        <div class="col-12">
            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                <h4 class="mb-sm-0 font-size-18">Current Stock</h4>

                <div class="page-title-right">
                    <ol class="breadcrumb m-0">
                        <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboards</a></li>
                        <li class="breadcrumb-item active">Current Stock</li>
                    </ol>
                </div>

            </div>
        </div>
    </div>
    <!-- end page title -->

    @include('validate')

    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-body">
                    <h4 class="card-title mb-4">Current Stock</h4>

                    <form method="POST" action="{{ route('currentstock') }}">
                        <div class="row mb-4 mt-4">



                            <div class="col-md-4 mb-3">
                                <select class="form-control select2" name="product_id" id="product_id">
                                    <option value="">Products</option>
                                    @foreach ($productData as $product)
                                        <option value="{{ $product->id }}">{{ $product->product_name }}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-4 mb-3">
                                <select class="form-control select2" name="category_id" id="category_id">
                                    <option value="">Categories</option>
                                    @foreach ($categoriesData as $category)
                                        <option value="{{ $category->id }}">{{ $category->category_name }}</option>
                                        @foreach ($category->subcategories as $subcategories)
                                            <option value="{{ $subcategories->id }}"> -- {{ $subcategories->category_name }}
                                            </option>
                                        @endforeach
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-12 mb-3">
                                @csrf
                                <button class="btn btn-info float-end" type="submit">SEARCH</button>
                            </div>


                        </div>
                    </form>


                    <div class="row mb-4">

                        <div class="col-md-12">

                            <div class="table-responsive">
                                <table class="table mb-0">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Product Code</th>
                                            <th>Product</th>
                                            <th>Category</th>
                                            <th>Unit</th>
                                            <th>Current Stock</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse ($stockList as $stockKey => $stock)
                                            <tr>
                                                <th scope="row">{{ $stockKey + 1 }}</th>
                                                <td>{{ $stock->product->product_code ?? '' }}</td>
                                                <td>{{ $stock->product->product_name ?? '' }}</td>
                                                <td>{{ $stock->product->category->category_name ?? '' }}</td>
                                                <td>{{ $stock->unit->unit_code ?? '' }}</td>
                                                <td>{{ round($stock->stock_qty, 2) }} </td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="6">No Details Found.</td>
                                            </tr>
                                        @endforelse


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

                        </div>

                    </div>




                </div>
            </div>
        </div><!--end col-->
    </div>
@endsection

@push('scripts')
    <script>
        $('.select2').select2();
    </script>
@endpush