@extends('layouts.layout_pagina',
[
    'icone_titulo'=>'fas fa-search',
    'titulo'=>'Relatorio - Compras de Produtos',
    'breadcrumb'=>['Consulta','Consulta Compras']
])

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

@section('scripts')
    <script src="{{{ URL::asset('js/DataTables/datatables.min.js') }}}"></script>
     <script src="{{{ URL::asset('js/views/consulta/consulta_compras.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 bg-primary-gradient" style="height: 50px; align-items: center">               
            <h2> Relatorio - Compras de Produtos </h2>          
        </div>
        <div class="card-body">
            <form method="GET" action="{{route('consulta.compras.pesquisa')}}">
                <div class="row" >
                    <div class="col-md-2"></div>
                    <div class="col-12 col-md-3">
                        <label class="col-form-label">Início</label>
                        <br/>
                        <input class="form-control" type="date" name="dataInicio"/>
                    </div>

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

                    <div class="col-12 col-sm-2">
                        <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-2"></div>
                </div>
            </form>
        </div>
        <div class="card-body">
            <div class="row" >
                <div class="col panel panel-primary table-responsive">
                    <table id="tbConsultaCompra" class="table table-hover text-left" style="width:100%">
                            <thead>
                                <tr>
                                    <th>Cod.</th>  
                                    <th>Data</th>                                        
                                    <th>NF</th>
                                    <th>Produto</th>
                                    <th>Qtde</th>
                                    <th>Preço</th>
                                    <th>Total</th>                                        
                                    <th>Usuário</th>
                                    <!-- <th></th> -->
                                </tr>
                            </thead>
                            <tbody>
                                @php 
                                    $total = 0;                                                                              
                                @endphp
                                @foreach($listaCompra as $lista)
                                    <tr>
                                        <td>{{$lista->getId()}}</td>
                                        <td>{{date('d/m/Y', strtotime($lista->getDtCriacao()))}}</td>                                           
                                        <td>{{$lista->getNotaFiscal()}}</td>
                                        <td>{{$lista->Produto->getDescricao()}}</td>
                                        <td>{{$lista->getQuantidade()}}</td>
                                        <td class="mask_moeda">{{$lista->getValorUnitario()}}</td>
                                        <td class="mask_moeda">{{$lista->getValorTotal()}}</td>
                                        <input type="hidden" id="{{$lista->getId()}}_id" data="{{$lista->getId()}}"/>
                                        <td>{{$lista->Usuario->getNome()}}</td>
                                    </tr>
                                    @php 
                                        $total= $total + $lista->getValorTotal(); 
                                    @endphp 
                                @endforeach
                            </tbody>
                    </table>
                </div>
            </div>
            
            <div class="card mt-2">                    
                <div class="card-header cor-card-header text-white d-flex bg-primary-gradient" style="height: 50px; align-items: center">               
                    <h2> Totalização </h2>                          
                </div>
              
                <div class="card-body">
                    <div class="row" >

                         <div class="col-sm-6 col-md-8">                               
                        </div>
    
                        <div class="col-sm-6 col-md-4">
                            <div class="card card-stats card-round">
                                <div class="card-body ">
                                    <div class="row">
                                        <div class="col-5">
                                            <div class="icon-big text-center">
                                                <i class="flaticon-coins text-success"></i>
                                            </div>
                                        </div>
                                        <div class="col-7 col-stats">
                                            <div class="numbers">
                                                <p class="card-category"> Total Geral:</p>
                                                <h4 class="card-title">R$ {{number_format($total,2,',','.')}}</h4>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>      
                      
    
                        
                        
                    </div>
    
    
    
                </div>


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

@endsection