@extends('adminlte.app')

@section('content')
    
    <div class="content-wrapper pb-3">

           <!-- Content Header (Page header) -->
        <div class="content-header">
            <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                <h1 class="m-0">Relatório Vendas</h1>
                </div><!-- /.col -->
                <div class="col-sm-6">
                
                </div><!-- /.col -->
            </div><!-- /.row -->
            </div><!-- /.container-fluid -->
        </div>
        <!-- /.content-header -->
        @if ($message = Session::get('success'))
            <div class="alert alert-success">
                <p>{{ $message }}</p>
            </div>
        @endif
        @if ($message = Session::get('danger'))
            <div class="alert alert-danger">
                <p>{{ $message }}</p>
            </div>
        @endif

        <div class="card mx-3 mt-3">
            
            <div class="card-header">

                <div class="row">
                    <div class="col-md-4">
                        {{ $dados['title'] }} 
                    </div>
                    {{-- <div class="col-md-8 text-right">
                        @if($permissao->importar_faturas)
                            <a href="/faturas/importar"> <button class="d-print-none btn btn-primary rounded">Importar CSV</button></a>
                        @endif
                        <button  class="btn btn-primary rounded d-print-none" data-toggle="collapse" data-target=".multi-collapse" aria-expanded="false"  aria-controls="asda" >Expandir Todos</button>
                        <button  id="btn_recolher_todos" class="btn btn-primary rounded d-print-none" >Recolher Todos</button>
                        <button  class="btn btn-primary rounded d-print-none" onclick="window.print()">Imprimir</button>
                        <form action="{{ route('faturas_imprimirfaturas') }}" method="POST" class="d-inline-block" target="_blank">
                            @csrf
                            <input type="hidden" name="filtros" value="{{ json_encode($filtros) }}">
                            <button  class="btn btn-primary rounded d-print-none">Faturas Simplificadas</button>
                        </form>
                    </div> --}}
                </div>
                
            
            </div>

            <div class="row pl-3 ml-3 pb-0 pt-0 mt-3 mr-3 bg-dark text-white d-print-none">
                <div class="col-sm-11">
                    Filtros
                 </div> 
                 <div class="col-ms-1">
                     <button class="btn btn-primary btn-sm" data-toggle="collapse" href="#filtroVendas" role="button" aria-expanded="false" aria-controls="filtroVendas" title="Mostrar Filtros"><i class="fas fa-plus" title="Adicionar" aria-hidden="true"></i></button>
                 </div>
             </div>
     
            <form action="{{ route('relatorio_vendas_consultar') }}" id="form_filtrar" method="GET" class="pt-4" >
                <div class="border p-3 ml-3 mr-3 mb-3 bg-light collapse" id="filtroVendas">
        
                    <div class="form-group row pd-3 ">

                        <div class="col-md-3">
                            <label for="data_suporte" class=" control-label my-auto mr-2">Início do Intervalo</label>
                            <input type="date" name="data_suporte" id="data_suporte" value ="{{ old('data_suporte', date('Y-m-d', strtotime($filtros['data_inicio'])) ) }}" class=" form-control " required>
                        </div>
                        
                        <div class="col-md-3">
                            <label for="data_suporte_fim" class=" control-label my-auto mr-2">Fim do Intervalo</label>
                            <input type="date" name="data_suporte_fim" id="data_suporte_fim" value="{{ old('data_suporte_fim', date('Y-m-d', strtotime($filtros['data_fim'])) ) }}" class=" form-control " required>
                        </div>
    
                        <div class="col-md-3">
                            <label for="gestor" class=" control-label my-auto mr-2">Gestor</label>
                            <select name="gestor" id="gestor" class=" form-control" >
                                <option value="">Todos</option>
                                @foreach ($gestores as $gestor)
                                    <option @if($filtros['gestor'] == $gestor->id ) selected @endif value="{{ $gestor->id }}">{{ $gestor->name }}</option>
                                @endforeach
                            </select>
                        </div>
    
    
                        <div class="col-md-3">
                            
                            <label for="tipo_relatorio" class=" control-label my-auto mr-2">Tipo de Relatório</label>
                            <select name="tipo_relatorio"   id="tipo_relatorio" class=" form-control" required>
                                <option disabled selected value="">Selecione</option>
                                <option @if($filtros['tipo_relatorio'] == 'lclientes') selected @endif value="lclientes">Litros por Clientes</option>
                                <option @if($filtros['tipo_relatorio'] == 'lprodutos') selected @endif value="lprodutos">Litros por Produto</option>
                                <option @if($filtros['tipo_relatorio'] == 'ltempo') selected @endif value="ltempo">Litros por DIA, SEMANA, MES, TRIMESTRE</option>
                                <option @if($filtros['tipo_relatorio'] == 'eclientes') selected @endif value="eclientes">Euros por Clientes</option>
                                <option @if($filtros['tipo_relatorio'] == 'eprodutos') selected @endif value="eprodutos">Euros por Produto</option>
                                <option @if($filtros['tipo_relatorio'] == 'pmclientes') selected @endif value="pmclientes">Preço Medio de Venda por Cliente</option>
                                <option @if($filtros['tipo_relatorio'] == 'pmprodutos') selected @endif value="pmprodutos">Preço Medio de Venda por Produto</option>
                                <option @if($filtros['tipo_relatorio'] == 'oportunidades') selected @endif value="oportunidades ">Oportunidades </option>
                                <option @if($filtros['tipo_relatorio'] == 'vizinhos') selected @endif value="vizinhos">Vizinhos</option>
                            </select> 
                        </div>
                    </div>

                    <div class="col-sm-3 mt-4">
                        <button id="btn_filtrar" class="btn btn-primary mt-3" type="submit">Filtrar</button>
                    </div>
                </div>

            </form>


            <div class="border mx-3 mt-4">
                <table class="table table-sm table-bordered table-hover mb-0">
                    <thead>
                        <tr class="text-center table-primary">
                            <th>Canal </th>
                            <th>Valor </th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($dados['canais'] as $canal)
                            {{-- <tr class="text-center @if ($loop->index == 1) bg-cyan @elseif ($loop->index == 2) bg-blue @elseif ($loop->index == 3) bg-teal @else bg-purple @endif"> --}}
                            <tr class="text-center">
                                <td>{{ $canal->nome_canal }}</td>
                                {{-- <td>{{ number_format($canal->valor, 2, ',', '.') }}</td> --}}
                                <td>
                                    @if(is_numeric( $canal->valor ) && floor( $canal->valor ) != $canal->valor)
                                        {{ number_format($canal->valor, 2, ',', ' ' ) }}
                                    @else
                                        {{ number_format($canal->valor, 0, ',', ' ') }}
                                    @endif
                                </td>
                            </tr>
                        @endforeach
                        <tr class="text-center table-secondary">
                            <td>Total</td>
                            {{-- <td>{{ number_format( $dados['canais']->sum('valor'), 2, ',', '.') }}</td> --}}
                            <td>
                                @if(is_numeric( $dados['canais']->sum('valor') ) && floor( $dados['canais']->sum('valor') ) != $dados['canais']->sum('valor'))
                                    {{ number_format($dados['canais']->sum('valor'), 2, ',', ' ' ) }}
                                @else
                                    {{ number_format($dados['canais']->sum('valor'), 0, ',', ' ') }}
                                @endif
                            </td>
                            {{-- <td>{{ number_format( array_sum(array_column($dados['canais'], 'valor')), 2, ',', '.') }}</td> --}}
                        </tr>
                    </tbody>
                </table>
            </div>

            <hr class="mx-3">
            

            <div class="px-3 my-4">
                <table class="table table-sm table-bordered table-hover mb-0 tabelashow">
                    <thead>
                        <tr class="text-center table-primary">
                            @foreach ($dados['headers'] as $header )
                            <th>{{ $header }}</th>
                            @endforeach
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($dados['vendas'] as $venda)
                            <tr>
                                @foreach ($dados['headers'] as $header )
                                    <td>{{ $venda[$dados['headers']['h' . $loop->iteration]] }}</td>
                                @endforeach
                            </tr>
                            @endforeach
                    </tbody>
                </table>
            </div>

        </div>
    </div>
    <!-- DataTables  & Plugins -->
    <script src={{ asset('/plugins/datatables/jquery.dataTables.min.js') }}></script>
    <script src={{ asset('/plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}></script>
    <script src={{ asset('/plugins/datatables-responsive/js/dataTables.responsive.min.js') }}></script>
    <script src={{ asset('/plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}></script>
    <script src={{ asset('/plugins/datatables-buttons/js/dataTables.buttons.min.js') }}></script>
    <script src={{ asset('/plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}></script>
    <script src={{ asset('/plugins/jszip/jszip.min.js') }}></script>
    <script src={{ asset('/plugins/pdfmake/pdfmake.min.js') }}></script>
    <script src={{ asset('/plugins/pdfmake/vfs_fonts.js') }}></script>
    <script src={{ asset('/plugins/datatables-buttons/js/buttons.html5.min.js') }}></script>
    <script src={{ asset('/plugins/datatables-buttons/js/buttons.print.min.js') }}></script>
    <script src={{ asset('/plugins/datatables-buttons/js/buttons.colVis.min.js') }}></script>


    <script>

       $('.tabelashow').DataTable( {
        
          "paging": true,
          "lengthChange": true,
          "searching": true,
          "ordering": true,
          "info": true,
          "autoWidth": false,
          "responsive": true,
          "order": [[0, "asc"]],
          "buttons": [ "csv", "excel", "pdf", {"extend":"print","text":"Imprimir"}, {"extend":"colvis","text":"Colunas"}],
          "lengthMenu": [[8, 10, 20, 25, 50, -1], [8, 10, 20, 25, 50, "All"]],
          "pageLength": 5,
                    "bJQueryUI": true,
                    "oLanguage": {
                        "sProcessing":   "Processando...",
                        "sLengthMenu":   "Registros _MENU_ ",
                        "sZeroRecords":  "Não foram encontrados resultados",
                        "sInfo":         "Mostrando de _START_ até _END_ de _TOTAL_ registros",
                        "sInfoEmpty":    "Mostrando de 0 até 0 de 0 registros",
                        "sInfoFiltered": "",
                        "sInfoPostFix":  "",
                        "sSearch":       "Buscar:",
                        "sUrl":          "",
                        "oPaginate": {
                            "sFirst":    "Primeiro",
                            "sPrevious": "Anterior",
                            "sNext":     "Seguinte",
                            "sLast":     "Último"
                        }
                    }
    
        } ).buttons().container().appendTo('#tabelashow_wrapper .col-md-6:eq(0)');
    
    </script>
@endsection