@extends('layouts.layout_pagina',
[
    'icone_titulo'=>'far fa-list-alt',
    'titulo'=>'Relatório - Estoques Excluídos',
    'breadcrumb'=>['Relatório','Estoques Excluídos']
])

@section('css')
    <link rel="stylesheet" href="{{{ URL::asset('js/DataTables/datatables.min.css') }}}" />
    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.6.4/css/buttons.dataTables.min.css" />
@endsection

@section('scripts')
    <script src="{{{ URL::asset('js/DataTables/datatables.min.js') }}}"></script>
    <script src="{{{ URL::asset('js/views/relatorio/estoqueexclusao/list.js') }}}"></script> 
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
    <script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.print.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.6.4/js/buttons.flash.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.6.4/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.6.4/js/buttons.print.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
@endsection

@section('pagina')
    
    <div class="container-fluid">       
        <div class="card mt-2">
            <div class="card-header cor-card-header text-white bg-primary-gradient">
                <div class="row" >
                    <div class="col-12 col-md-8">
                        <h3> Relatorio - Estoques Excluídos </h3> 
                    </div>
                </div>               
            </div>
            <div class="card-body">
                <form method="GET" action="{{route('relatorio.estoque_exclusao.pesquisa')}}">
                    <div class="row" >
                        <div class="col-md-1"></div>
                        <div class="col-12 col-md-2">
                            <label class="col-form-label">Início</label>
                            <br/>
                            <input class="form-control" type="date" name="dataInicio" required/>
                        </div>

                        <div class="col-12 col-md-2">
                            <label class="col-form-label">Termino</label>
                            <br/>
                            <input class="form-control" type="date" name="dataFinal" required/>
                        </div>

                        <div class="col-12 col-md-4">
                            <label class="col-form-label">Produto</label>
                            <br/>
                            <select name="produto" class="form-control">
                                <option value="">Todos...</option>
                                @foreach($listaProdutos as $key => $value)
                                    <option value="{{$key}}">{{$value}}</option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-12 col-md-2 text-center">
                            <label for="btnPesquisa" class="col-form-label">&nbsp;</label>
                            <br/>
                            <button id="btnPesquisa" type="submit" class="btn btn-success"><i class="fas fa-search"></i> Pesquisar</button>
                        </div>
                        <div class="col-md-1"></div>
                    </div>
                </form>
            </div>
            <div class="card-body">
                <div class="row" >
                    <div class="col-12 col-md-12 table-responsive">
                        <table id="tbEstoquesExclusoes" class="table table-hover text-left" style="width:100%">
                            <thead>
                                <tr>
                                    <th>Cod.</th>
                                    <th>Data/Hora</th>
                                    <th>Produto</th>
                                    <th>Usuário</th>
                                    <th>Quantidade</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($listaEstoquesExclusoes as $lista)
                                    <tr>
                                        <td>{{$lista['id']}}</td>
                                        <td>{{date('d/m/Y', strtotime($lista['dt_criacao']))}}</td>
                                        <td>{{$lista->Estoque->Produto['descricao']}}</td>
                                        <td>{{$lista->Usuario['nome']}}</td>
                                        <td>{{$lista['quantidade']}}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
                <div class="card mt-2">
                    <div class="card-header cor-card-header text-white bg-primary-gradient">
                        <div class="row">
                            <div class="col-12 col-md-12 text-center">
                                <h3> Totalização </h3>
                            </div>
                        </div>
                    </div>
                    <div class="card-body">
                        <div class="row" >
                            <div class="col col-md-12 text-center">
                                <label>Quantidade Itens Excluídos: {{$totalItens}}</label>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection