@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_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 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>
                <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="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><div style="width:200px;">Gestor de Cliente</div></th>
                            <th><div style="">Canal</div></th>
                            <th><div style="width:200px;">Nome</div></th>
                            <th><div style="">Plafond Aprovado</div></th>
                            <th><div style="">Faturado</div></th>
                            <th><div style="">Plafond Disponível</div></th>
                            <th><div style="">Vencidos até 30DD</div></th>
                            <th><div style="">Vencidos de 30DD a 60DD</div></th>
                            <th><div style="">Vencidos >60DD</div></th>

                            <th class="d-none d-print-none"><div style="">Plafond Aprovado</div></th>
                            <th class="d-none d-print-none"><div style="">Faturado</div></th>
                            <th class="d-none d-print-none"><div style="">Plafond Disponível</div></th>
                            <th class="d-none d-print-none"><div style="">Vencidos até 30DD</div></th>
                            <th class="d-none d-print-none"><div style="">Vencidos de 30DD a 60DD</div></th>
                            <th class="d-none d-print-none"><div style="">Vencidos >60DD</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>{{ $canal == 'tfuel' ? $item->tfuel_plafond : $item->im_plafond }}</td>
                                    <td>{{ $canal == 'tfuel' ? $item->total_tfuel : $item->total_im }}</td>
                                    <td>{{ $canal == 'tfuel' ? $item->tfuel_plafond - $item->total_tfuel : $item->im_plafond - $item->total_im }}</td>
                                    <td>{{ $canal == 'tfuel' ? $item->vencidas_30_dias_tfuel : $item->vencidas_30_dias_im }}</td>
                                    <td>{{ $canal == 'tfuel' ? $item->vencidas_30_60_dias_tfuel : $item->vencidas_30_60_dias_im }}</td>
                                    <td>{{ $canal == 'tfuel' ? $item->vencidas_mais_60_dias_tfuel : $item->vencidas_mais_60_dias_im }}</td>

                                    <td class="d-none d-print-none">{{ $canal == 'tfuel' ? $item->tfuel_plafond : $item->im_plafond }}</td>
                                    <td class="d-none d-print-none">{{ $canal == 'tfuel' ? $item->total_tfuel : $item->total_im }}</td>
                                    <td class="d-none d-print-none">{{ $canal == 'tfuel' ? $item->tfuel_plafond - $item->total_tfuel : $item->im_plafond - $item->total_im }}</td>
                                    <td class="d-none d-print-none">{{ $canal == 'tfuel' ? $item->vencidas_30_dias_tfuel : $item->vencidas_30_dias_im }}</td>
                                    <td class="d-none d-print-none">{{ $canal == 'tfuel' ? $item->vencidas_30_60_dias_tfuel : $item->vencidas_30_60_dias_im }}</td>
                                    <td class="d-none d-print-none">{{ $canal == 'tfuel' ? $item->vencidas_mais_60_dias_tfuel : $item->vencidas_mais_60_dias_im }}</td>
                                </tr>
                            @endforeach
                        @endforeach
                    </tbody>
                </table>
            </div>
        </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,
          "columnDefs": [
                {
                    "targets": [3, 4, 5, 6, 7, 8],
                    render: $.fn.dataTable.render.number('.', ',', 2),
                    "className": 'noExp',
                },

                {
                    "targets": [9, 10, 11, 12, 13, 14],
                    "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": 100,
                    "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