@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">Questionário de Qualidade</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 ($errorsEmail = Session::get('emailsErros'))
        <div class="alert alert-warning">
            <ul>
                @foreach ($errorsEmail as $error)
                    <li>{{ $error }}</li>
                @endforeach
            </ul>
        </div>
    @endif

    <div class="card mx-3 mt-3">
            <div class="card-header">
                <div class="row">  
                    <div class="col-3">
                        Filtros
                    </div>
                    <div class="col-9 text-right">
                    
                    </div>
                </div>
            </div>
            
            <div class="pt-3 pl-3 pr-3 ml-3 mr-3 mb-3 collapse show" id="filtroPVPs">
                <form action=""  method="GET" class="pd-3 ">
                    <div class="row form-group align-items-end">
                        <div class="col-sm-2">
                            <label for="data_inicio">Data Início</label>
                            <input type="date" name="data_inicio" id="data_inicio" class="form-control" value="{{ $filtros['data_inicio'] ?? date('Y-m-01') }}">
                        </div>
                        <div class="col-sm-2">
                            <label for="data_fim">Data Fim</label>
                            <input type="date" name="data_fim" id="data_fim" class="form-control" value="{{ $filtros['data_fim'] ?? date('Y-m-d') }}">
                        </div>
                        <div class="col-sm-3">
                            <label for="posto_id">Posto</label>
                            <select name="posto_id" id="posto_id" class="form-control">
                                <option value="">Selecione</option>
                                @foreach($postos as $posto)
                                    <option value="{{ $posto->id }}" @if(isset($filtros['posto_id']) && $filtros['posto_id'] == $posto->id) selected @endif>{{ $posto->nome_posto }}</option>
                                @endforeach
                            </select>
                        </div>
                        
                        <div class="col-sm-3">
                            <label for="gestor_id" class="col-form-label ">Gestor</label>
                            <select name="gestor_id" id="gestor_id" class="form-control">
                                <option value="">Selecione</option>
                                @foreach($gestores as $gestor)
                                    <option value="{{ $gestor->id }}" @if(isset($filtros['gestor_id']) && $filtros['gestor_id'] == $gestor->id) selected @endif>{{ $gestor->name }}</option>
                                @endforeach
                
                            </select>
                        </div>
                       
                        <div class="col-sm-2">
                            <button class="btn btn-primary rounded mx-auto col-12">Consultar</button>
                        </div>

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

    <div class="card mx-3 mt-3">
        <div class="card-header">
            <div class="row">
                <div class="col-10 col-md-10">
                    Report Mensal
                </div>
                <div class="col-2 col-md-2">
                    <a href="{{route('report_mensal_questionario')}}"> <button class="btn btn-primary btn-sm col-12" id="btn_adicionar" role="button" title="Adicionar">Adicionar</button></a>
                </div>
            </div>
        </div>
        <div class="card-body">
            <div class="row ">
                <div class="col-sm-12  table-responsive">
                    <table id="tabela1" class="table table-sm text-sm table-bordered text-center">
                        <thead>
                            <tr>
                                <th>id</th>
                                <th>Data</th>
                                <th>Posto</th>
                                <th>Gestor do Posto</th></th>
                                <th>Usuário</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($questinarioReportMensal as $item)
                                <tr>
                                    <td>{{ $item->id }}</td>
                                    <td>{{date('d/m/Y', strtotime( $item->created_at)) }}</td>
                                    {{-- <td>{{ $item->posto->nome_posto ?? ''}}</td> --}}
                                    <td>{{ $item->posto->nome_posto ?? $item->reportMensal->posto->nome_posto ?? '' }}</td>
                                    <td>{{ $item->posto->gestor_posto->name ?? $item->reportMensal->posto->gestor_posto->name ?? '' }}</td>
                                    <td>{{ $item->user->name ?? ''}}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </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>
     function confirmarExclusao() {
        return confirm("Tem certeza de que deseja excluir este item?");
    }

    $('#tabela1').DataTable( {

        "paging": true,
        "lengthChange": true,
        "searching": true,
        "ordering": true,
        "info": true,
        "autoWidth": false,
        "responsive": true,
        "order": [[3, "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": 8,
                "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