@extends('layouts.layout_pagina',
[
    'icone_titulo'=>'far fa-list-alt',
    'titulo'=>'Relatorio - Venda de Produtos',
    'breadcrumb'=>['Consulta','Relatório Vendas']
])

@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/relatorio_vendas.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 d-flex justify-content-between bg-primary-gradient">
            <h3> Relatorio - Vendas de Produtos </h3>                
        </div>
        <div class="card-body">
            <form method="GET" action="{{route('relatorio.vendas.pesquisa')}}">
                <div class="row" >
                    <div class="col col-sm-2 text-left">
                        <label class="col-form-label text-md-left">Início</label>
                        <br/>
                        <input class="form-control" type="date" name="dataInicio" required/>
                    </div>

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

                    <div class="col col-sm-3 text-left">
                        <label class="col-form-label text-md-left">Clientes</label>
                        <br/>
                        <select name="cliente" class="form-control">
                            <option value="">Todos...</option>
                            @foreach($listaClientes as $key => $value)
                                <option value="{{$key}}">{{$value}}</option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col col-sm-3 text-left">
                        <label class="col-form-label text-md-left">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 col-sm-2 text-left">
                        <label for="btnPesquisa" class="col-form-label text-md-left">&nbsp;</label>
                        <br/>
                        <button id="btnPesquisa" type="submit" class="btn btn-success"><i class="fas fa-search"></i> Pesquisar</button>
                    </div>
                </div>
            </form>
        </div>
        <div class="card-body">
            <div class="row" >
                <div class="col panel panel-primary table-responsive">
                    <table id="tbRelatorioVendas" class="table table-hover text-left">
                            <thead>
                                <tr>
                                    <th>Cod.</th>
                                    <th>Data/Hora</th>                                   
                                    <th>Cliente</th>
                                    <th>Produto</th>
                                    <th>Vendedor</th> 
                                    <th>Qtde</th>
                                    <th>Preço</th>
                                    <th>Total</th>                                                                          
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($listaVenda as $lista)
                                    <tr>
                                        <td>{{$lista->getId()}}</td>
                                        <td>{{date('d/m/Y', strtotime($lista->getDtCriacao()))}}</td>                                         
                                        <td>{{substr($lista->Cliente->getNome(), 0, 15)}}</td>                                           
                                        <td>{{$lista->Produto->getDescricao()}}</td>
                                        <td>{{$lista->Usuario->getNome()}}</td>
                                        <td>{{$lista->getQuantidade()}}</td>
                                        <td>{{$lista->getValorUnitario()}}</td>
                                        <td>{{$lista->getValorTotal()}}</td>                            
                                        <input type="hidden" id="{{$lista->getId()}}_id" data="{{$lista->getId()}}"/>
                                    </tr>
                                @endforeach
                            </tbody>
                            <tr>
                                <td colspan="10" class="text-right" style="font-size:20px"><b>R$ {{number_format($totalValor,2,',','.')}}</b></td>
                            </tr>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

@endsection