@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">Gestão Plafond</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

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

            <div class="row">
                <div class="col-md-4">
                    Relatório Plafond
                </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="#filtroGestaoPlafond" role="button" aria-expanded="false" aria-controls="filtroGestaoPlafond" title="Adicionar"><i class="fas fa-plus" title="Adicionar" aria-hidden="true"></i></button>
                </div>
            </div>

        <form action="{{ route('gestao_plafond_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="filtroGestaoPlafond">
                <div class="form-group row pd-3 ">
                                
                    @if ($permissao->exibir_todos_clientes)
                        <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=""></option>
                                @foreach ($gestores as $gestor)
                                    <option value="{{ $gestor->id }}" @if($filtros['gestor'] == $gestor->id) selected @endif>{{ $gestor->name }}</option>
                                @endforeach
                            </select>
                        </div>
                    @endif
    
                    <div class="col-md-3">
                        <label for="plafond" class=" control-label my-auto mr-2">Com Plafond</label>
                        <select name="plafond" id="plafond" class="form-control">
                            <option value=""></option>
                            <option @if($filtros['plafond'] == 'disponivel') selected @endif value="disponivel">Plafond Disponivel</option>
                            <option @if($filtros['plafond'] == 'ultrapassado') selected @endif value="ultrapassado">Plafond Ultrapassado</option>
                        </select>
                    </div>
    
    
                    <div class="col-md-3">
                        <label for="valor_inicio" class=" control-label my-auto mr-2">Valor Plafond - Início</label>
                        <input type="number" name="valor_inicio" id="valor_inicio" class="form-control" value="{{ old('valor_inicio', $filtros['valor_inicio']) }}">
                    </div>
    
                    <div class="col-md-3">
                        <label for="valor_fim" class=" control-label my-auto mr-2">Valor Plafond - Fim</label>
                        <input type="number" name="valor_fim" id="valor_fim" class="form-control" {{ old('valor_fim', $filtros['valor_fim']) }}>
                    </div>
                </div>
                <div class="form-group row pd-3 ">

                    <div class="col-md-3">
                        <label for="canalF" class=" control-label my-auto mr-2">Canal</label>
                        <select name="canalF[]" id="canalF" multiple class="form-control">
                            <option value=""></option>
                            @foreach ($canais as $canal)
                                <option @if(is_array($filtros['canais']) && in_array($canal->id, $filtros['canais'])) selected @endif value="{{ $canal->id }}">{{ $canal->nome_canal }}</option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-3">
                        <label for="ano" class="">Ano</label>
                        <select name="ano"   id="ano" class=" form-control" required>
                            @foreach ($anos->sort() as $key => $ano)
                                <option @if($filtros['ano'] == $ano) selected @endif value="{{ $ano }}">{{ $ano }}</option>
                            @endforeach
                        </select> 
                    </div>
    
                    
                </div>
                <div class="form-group row">
                    <div class="col-12 text-center">
                        <button class="btn btn-primary rounded mx-auto ">Consultar</button>
                    </div>
                </div>
            </div>

        </form>

        <div class="mx-auto">
                        {{-- {{ $clientes->onEachSide(5)->links() }}  --}}
        </div>

        <div class="px-3 pb-3">
            <br>
            <div class="table-responsive">
                <table id="tabelashow" class="table table-striped table-bordered table-hover">
                    <thead>
                        <tr>
                            {{-- <th>ID</th> --}}
                            <th class="text-center align-middle"><div style="width:200px;">Gestor de Cliente</div></th>
                            <th class="text-center align-middle"><div style="">Canal</div></th>
                            <th class="text-center align-middle"><div style="width:200px;">Nome</div></th>
                            
                            <th class="text-center align-middle"><div style="">Plafond Aprovado</div></th>
                            <th class="text-center align-middle"><div style="">Total</div></th>
                            <th class="text-center align-middle"><div style="">Plafond Disponível</div></th>
                            <th class="text-center align-middle"><div style="">Consumo Mensal (média)</div></th>
                            <th class="text-center align-middle"><div style="">Trimestre 1 (média)</div></th>
                            <th class="text-center align-middle"><div style="">Trimestre 2 (média)</div></th>
                            <th class="text-center align-middle"><div style="">Trimestre 3 (média)</div></th>
                            <th class="text-center align-middle"><div style="">Trimestre 4 (média)</div></th>
                            <th class="text-center align-middle"><div style="">Total Litros</div></th>
                            <th class="text-center align-middle"><div style="">Total Euros</div></th>
                            
                            <th class="d-none d-print-none text-center align-middle"><div style="">Plafond Aprovado</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Total</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Plafond Disponível</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Consumo Mensal (média)</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Trimestre 1 (média)</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Trimestre 2 (média)</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Trimestre 3 (média)</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Trimestre 4 (média)</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Total Litros</div></th>
                            <th class="d-none d-print-none text-center align-middle"><div style="">Total Euros</div></th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($clientes as $item)
                            @foreach ($canaisPlafond as $canal)
                                <tr class="
                                    {{-- @if ($canal == 'tfuel')
                                        @if ($item->vencidas_mais_60_dias_tfuel > 0 && $item->tfuel_plafond - $item->total_tfuel < 0)
                                            bg-danger
                                        @endif
                                    @else
                                        @if ($item->vencidas_mais_60_dias_im > 0 && $item->im_plafond - $item->total_im < 0)
                                            bg-danger
                                        @endif
                                    @endif --}}
                                ">
                                    <td>{{ $item->gestor_user()->exists() > 0 ? Str::upper($item->gestor_user->name) : '' }}</td>
                                    <td>{{ Str::upper($canal) }}</td>
                                    <td>{{ Str::upper($item->nome) }}</td>
                                    
                                    <td>
                                        @if($canal == 'tfuel')
                                            {{ $item->tfuel_plafond ? $item->tfuel_plafond : 0  }} 
                                        @else
                                            {{ $item->im_plafond ? $item->im_plafond : 0  }} 
                                        @endif
                                    </td>
                                    <td>{{ $item->dadosPlafond[$canal]['valor_total'] }}</td>
                                    <td>{{ $canal == 'tfuel' ? $item->tfuel_plafond - $item->dadosPlafond[$canal]['pendentes'] : $item->im_plafond - $item->dadosPlafond[$canal]['pendentes'] }}</td>
                                    <td>{{ $item->dadosPlafond[$canal]['consumo_total'] / 12 }}</td>
                                    <td class="
                                        @if ($canal == 'tfuel')
                                            @if ($item->tfuel_plafond < $item->dadosPlafond[$canal]['consumo_tri_um'])
                                                bg-danger
                                            @endif
                                        @else
                                            @if ($item->im_plafond < $item->dadosPlafond[$canal]['consumo_tri_um'])
                                                bg-danger
                                            @endif
                                        @endif
                                    
                                    ">{{ $item->dadosPlafond[$canal]['consumo_tri_um']  }}</td>
                                    <td class="
                                        @if ($canal == 'tfuel')
                                            @if ($item->tfuel_plafond < $item->dadosPlafond[$canal]['consumo_tri_dois'])
                                                bg-danger
                                            @endif
                                        @else
                                            @if ($item->im_plafond < $item->dadosPlafond[$canal]['consumo_tri_dois'])
                                                bg-danger
                                            @endif
                                        @endif
                                    
                                    ">{{ $item->dadosPlafond[$canal]['consumo_tri_dois']  }}</td>
                                    <td class="
                                        @if ($canal == 'tfuel')
                                            @if ($item->tfuel_plafond < $item->dadosPlafond[$canal]['consumo_tri_tres'])
                                                bg-danger
                                            @endif
                                        @else
                                            @if ($item->im_plafond < $item->dadosPlafond[$canal]['consumo_tri_tres'])
                                                bg-danger
                                            @endif
                                        @endif
                                    
                                    ">{{ $item->dadosPlafond[$canal]['consumo_tri_tres']  }}</td>
                                    <td class="
                                        @if ($canal == 'tfuel')
                                            @if ($item->tfuel_plafond < $item->dadosPlafond[$canal]['consumo_tri_quatro'])
                                                bg-danger
                                            @endif
                                        @else
                                            @if ($item->im_plafond < $item->dadosPlafond[$canal]['consumo_tri_quatro'])
                                                bg-danger
                                            @endif
                                        @endif
                                    
                                    ">{{ $item->dadosPlafond[$canal]['consumo_tri_quatro']  }}</td>
                                    <td>{{ $item->dadosPlafond[$canal]['consumo_total'] }}</td>
                                    <td>{{ $item->dadosPlafond[$canal]['valor_total'] }}</td>
                                    
                                    <td class="d-none d-print-none">
                                        @if($canal == 'tfuel')
                                            {{ $item->tfuel_plafond ? $item->tfuel_plafond : 0  }} 
                                        @else
                                            {{ $item->im_plafond ? $item->im_plafond : 0  }} 
                                        @endif
                                    </td>
                                    <td class="d-none d-print-none">{{ $item->dadosPlafond[$canal]['valor_total'] }}</td>
                                    <td class="d-none d-print-none">{{ $canal == 'tfuel' ? $item->tfuel_plafond - $item->dadosPlafond[$canal]['pendentes'] : $item->im_plafond - $item->dadosPlafond[$canal]['pendentes'] }}</td>
                                    <td class="d-none d-print-none">{{ $item->dadosPlafond[$canal]['consumo_total'] / 12 }}</td>
                                    <td class="d-none d-print-none" class="
                                        @if ($canal == 'tfuel')
                                            @if ($item->tfuel_plafond < $item->dadosPlafond[$canal]['consumo_tri_um'])
                                                bg-danger
                                            @endif
                                        @else
                                            @if ($item->im_plafond < $item->dadosPlafond[$canal]['consumo_tri_um'])
                                                bg-danger
                                            @endif
                                        @endif
                                    
                                    ">{{ $item->dadosPlafond[$canal]['consumo_tri_um']  }}</td>
                                    <td class="d-none d-print-none" class="
                                        @if ($canal == 'tfuel')
                                            @if ($item->tfuel_plafond < $item->dadosPlafond[$canal]['consumo_tri_dois'])
                                                bg-danger
                                            @endif
                                        @else
                                            @if ($item->im_plafond < $item->dadosPlafond[$canal]['consumo_tri_dois'])
                                                bg-danger
                                            @endif
                                        @endif
                                    
                                    ">{{ $item->dadosPlafond[$canal]['consumo_tri_dois']  }}</td>
                                    <td class="d-none d-print-none" class="
                                        @if ($canal == 'tfuel')
                                            @if ($item->tfuel_plafond < $item->dadosPlafond[$canal]['consumo_tri_tres'])
                                                bg-danger
                                            @endif
                                        @else
                                            @if ($item->im_plafond < $item->dadosPlafond[$canal]['consumo_tri_tres'])
                                                bg-danger
                                            @endif
                                        @endif
                                    
                                    ">{{ $item->dadosPlafond[$canal]['consumo_tri_tres']  }}</td>
                                    <td class="d-none d-print-none" class="
                                        @if ($canal == 'tfuel')
                                            @if ($item->tfuel_plafond < $item->dadosPlafond[$canal]['consumo_tri_quatro'])
                                                bg-danger
                                            @endif
                                        @else
                                            @if ($item->im_plafond < $item->dadosPlafond[$canal]['consumo_tri_quatro'])
                                                bg-danger
                                            @endif
                                        @endif
                                    
                                    ">{{ $item->dadosPlafond[$canal]['consumo_tri_quatro']  }}</td>
                                    <td class="d-none d-print-none">{{ $item->dadosPlafond[$canal]['consumo_total'] }}</td>
                                    <td class="d-none d-print-none">{{ $item->dadosPlafond[$canal]['valor_total'] }}</td>
                                </tr>
                            @endforeach
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>

        <div class="mx-auto">
            {{-- {{ $clientes->onEachSide(5)->links() }}  --}}
        </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": false,
          "ordering": false,
          "info": false,
          "autoWidth": false,
          "responsive": true,
          "columnDefs": [
                {
                    "targets": [3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
                    render: $.fn.dataTable.render.number('.', ',', 2),
                    "className": 'noExp',
                },
                {
                    "targets": [13, 14, 15, 16, 17, 18, 19, 20, 21, 22],
                    render: $.fn.dataTable.render.number('.', ',', 2),
                    "className": 'noVis',
                },
                

            ],
          "order": [[0, "asc"]],
          "buttons": [
                 {
                    "extend": "csv",
                    "text": "CSV",
                    "exportOptions": {
                        "columns": ":not(.noExp)"
                    }
                 },
                 {
                    "extend": "excel",
                    "text": "Excel",
                    "exportOptions": {
                        "columns": ":not(.noExp)"
                    }
                 },
                 {
                    "extend": "pdf",
                    "text": "PDF",
                    "exportOptions": {
                        "columns": ":not(.noExp)"
                    }
                 },
                 {
                    "extend":"print",
                    "text":"Imprimir",
                    "exportOptions": {
                        "columns": ":not(.noExp)"
                    }
                }, 
                {
                    "extend":"colvis",
                    "text":"Colunas",
                    "columns": ":not(.noVis)"
                }
            ],
          "lengthMenu": [[8, 10, 20, 25, 50, 100, -1], [8, 10, 20, 25, 50, 100, "All"]],
          "pageLength": -1,
                    "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