@extends('layouts.dashboardnew')

@section('content')

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

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

                        <div class="media border-bottom-1 pt-3 pb-3">
                            <i class="fa-solid fa-shop" style="font-size: 26px;"></i>
                            <div class="media-body">
                                <h5 class="mt-2">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">
                                <label class="m-t-20">Seleccione el Producto</label>
                                <select class="form-control" name="idproducto" required>
                                  <option value="" selected disabled>Seleccione una Opción</option>
                           
                                    @foreach($productos as $product)
                                     <option value="{{$product->ID}}">{{$product->post_title}}</option>
                                    @endforeach    
                            
                                 </select>  
                            </div>
                            
                            
                    <div class="col-md-3">
                    
                       <label class="m-t-20">Fecha desde</label>
                       <input class="form-control datepicker" type="text" name="fecha1" required >
                     
                    </div>
                
                    <div class="col-md-3">
                    
                       <label class="m-t-20">Fecha hasta</label>
                       <input class="form-control datepicker" type="text" name="fecha2" required />
                      
                    </div>
                            
                            <div class="col-md-2" style="margin-top: 2rem !important;">
                                <button class="btn btn-info btn-block" type="submit"> Buscar</button>
                            </div>    

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



<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    
			<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
					  $producto = DB::table($settings->prefijo_wp.'posts')->select('post_title')->where('ID', '=', $inv->idproducto)->first();
					  $pago = DB::table('pagocarritos')->where('idcompra', '=', $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
						      {{ $pago->name }}
						    @endif
						</td>
						<td class="text-center">
						    @if($inv->iduser != 0)
						      {{ $inv->user->user_email }}
						    @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">
						    @if($producto != null)
						      {{ $producto->post_title }}
						    @endif
						</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')