@extends('layouts.dashboardnew')

@section('content')


<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-body">

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

                        <div class="d-flex align-items-start">
                            <i class="fa-solid fa-shop" style="font-size: 23px;"></i>
                            <div class="w-100">
                                <h5 class="mt-1">Filtrar por Producto</h5>
                            </div>
                        </div>

                    </div>

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

                        <form method="GET" action="{{ route('reporte-movimientos-filtro') }}">
                            
                            <div class="row pt-3">
                            
                            <input type="hidden" name="tipo" value="2">

                            <div class="col-md-3">
                                <div class="form-group mb-3">
                                    <label class="">Seleccione el Producto</label>
                                    <select class="form-control select2-single" name="idproducto" required>
                                       <option value="" selected disabled>Seleccione una Opción</option>
                           
                                          @foreach($productos as $product)
                                           <option value="{{$product->id}}">{{$product->title}}</option>
                                          @endforeach    
                            
                                     </select> 
                                 </div> 
                            </div>

                            <div class="col-md-3">
                                <div class="form-group mb-3">
                                    <label>Fecha desde</label>
                                    <input class="form-control datepicker" type="text" name="fecha1" required >
                                </div>
                            </div>
                
                            <div class="col-md-3">
                                <div class="form-group mb-3">
                                    <label>Fecha hasta</label>
                                    <input class="form-control datepicker" type="text" name="fecha2" required />
                                </div>
                            </div>

                            
                            <div class="col-md-2 mt-3">
                                <div class="form-group mb-3">
                                   <button class="btn btn-info btn-block" type="submit"> Buscar</button>
                                </div>   
                            </div>    

                            </div> 
                        </form>
                               
                    </div>
            </div>
        </div>
    </div>
</div>                    


<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <div class="table-responsive">
                
            <table class="table table-striped table-bordered zero-configuration">
                <thead>
                    <tr>
                        <th class="text-center">#</th>
                        <th class="text-center">ID</th>
                        <th class="text-center">Usuario</th>
                        <th class="text-center">Correo</th>
                        <th class="text-center">ID de Compra</th>
                        <th class="text-center">Tipo</th>
                        <th class="text-center">ID Producto</th>
                        <th class="text-center">Nombre del Producto</th>
                        <th class="text-center">Cantidad</th>
                        <th class="text-center">Concepto</th>
                        <th class="text-center">Fecha</th>
                    </tr>
                </thead>

                <tbody>
                    @foreach ($inventario as $inv)
                    
                    @php
                      $pago = DB::table('pagocarritos')->where('id', '=', $inv->idcompra)->first();
                    @endphp
                    
                    <tr>
                        <td class="text-center">{{ $inv->id }}</td>
                        <td class="text-center">
                            @if($inv->iduser != 0)
                              {{ $inv->iduser }}
                            @endif
                        </td>
                        <td class="text-center">
                            @if($inv->iduser != 0)
                              {{ $inv->user->display_name }}
                            @else
                              @if($pago != null)
                              {{ $pago->nombre }} {{ $pago->apellido }}
                              @endif
                            @endif
                        </td>
                        <td class="text-center">
                            @if($inv->iduser != 0)
                              {{ $inv->user->user_email }}
                            @else
                              @if($pago != null)
                                {{ $pago->correo }}
                              @endif
                            @endif
                        </td>
                        <td class="text-center">{{ $inv->idcompra }}</td>
                        <td class="text-center">{{ $inv->tipo }}</td>
                        <td class="text-center">{{ $inv->idproducto }}</td>
                        <td class="text-center">{{ $inv->tienda->title }}</td>
                        <td class="text-center">{{ $inv->cantidad }}</td>
                        <td class="text-center">{{ $inv->concepto }}</td>
                        <td class="text-center">{{ date('d-m-Y', strtotime($inv->fecha)) }}</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
                
                </div>
            </div>
        </div>
    </div>
</div>            

@endsection

@include('usuario.componentes.scripBotones')