@extends('products.layout')

@section('content')

<div class="card mt-5">
  <h2 class="card-header">Products management</h2>
  <div class="card-body">

        @session('success')
            <div class="alert alert-success" role="alert"> {{ $value }} </div>
        @endsession
@if (auth()->user()->hasRole('Admin'))
        <div class="d-grid gap-2 d-md-flex justify-content-md-end">
            <a class="btn btn-success btn-sm" href="{{ route('products.create') }}"> <i class="fa fa-plus"></i> Create New Product</a>
        </div>
@endif
<form method="GET" action="{{ route('products.filtered') }}">
    <label for="category">Category:</label>
<select name="category" id="category"class="form-control" onchange=form.submit()>
    <option value="">-- Select Category --</option>
    @forelse ($categories as $category )
        <option value="{{ $category->name}}" {{ request('category')==$category->name ? 'selected' : ''}} >
            {{ $category->name}}
        </option>
    @empty
        
    @endforelse
</select>
<br>
    <label for="sku">Sku:</label>
<select name="sku" id="sku"class="form-control" onchange=form.submit()>
    <option value="">-- Select Sku --</option>
    @forelse ($sku_distinct as $sku_name)
        <option value="{{ $sku_name->sku}}" {{ request('sku')==$sku_name->sku ? 'selected' : ''}} >
            {{ $sku_name->sku}}
        </option>
    @empty
        
    @endforelse
</select>

</form>


        <table class="table table-bordered table-striped mt-4">
            <thead>
                <tr>
                    <th width="80px">No</th>
                    <th>Category</th>
                    <th>Sku</th>
                    <th>Name</th>
                    <th>Status</th>
                    <th width="250px">Action</th>
                </tr>
            </thead>

            <tbody>
            @forelse ($products as $product)
                <tr>
                    <td>{{ ++$i }}</td>
                    <td>{{ $product->categoria }}</td>
                    <td>{{ $product->sku }}</td>
                    <td>{{ $product->name }}</td>
                    <td>{{ $product->status }}</td>
                    <td>
                        <form action="{{ route('products.destroy',$product->id) }}" method="POST">

                            <a class="btn btn-info btn-sm" href="{{ route('products.show',$product->id) }}"><i class="fa-solid fa-list"></i> Show</a>

                            <a class="btn btn-primary btn-sm" href="{{ route('products.edit',$product->id) }}"><i class="fa-solid fa-pen-to-square"></i> Edit</a>

                            @csrf
                            @method('DELETE')

                            <button type="submit" class="btn btn-danger btn-sm"><i class="fa-solid fa-trash"></i> Delete</button>
                        </form>
                    </td>
                </tr>
            @empty
                <tr>
                    <td colspan="5">
                    <span class="text-danger">
                         <strong>No Product Found!</strong>
                    </span>
                    </td>
                </tr>
            @endforelse
            </tbody>

        </table>

        {!! $products->links() !!}

  </div>
</div>
@endsection