@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">Report Mensal</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-10 col-md-11">
                    Report Mensal
                </div>
                <div class="col-2 col-md-1">
                    <a href="{{route('report_mensal_create')}}"> <button class="btn btn-primary btn-sm" 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>Mês</th>
                                <th>Falha de Caixa Mês Anterior</th>
                                <th>Quebras</th>
                                <th>Justificativa Report Mensal</th>
                                <th>Anexo Report Mensal</th>
                                <th>Usuário Report Mensal</th>
                                <th>Senha</th>
                                <th>data Expiração Senha</th>
                                <th>Usuario Que enviou Email</th>
                                <th>Data Envio Email</th>
                                <th>Anexo</th>
                                <th>Ações</th>
                            </tr>
                        </thead>
                        <tbody>

                            @foreach($report_mensal 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()->withTrashed()->first()->nome_posto ?? '' }}</td>
                                <td>{{ $item->posto->gestor_posto->name ?? '' }}</td>
                                <td>{{ $item->mes }}</td>
                                <td>{{ $item->falha_de_caixa ? $item->falha_de_caixa . ' €' : ''}} </td>
                                <td>{{ $item->quebras_alt ? $item->quebras_alt . ' €' : ''}} </td>
                                <td>{{ $item->justificativa_report_mensal ? $item->justificativa_report_mensal : ''}} </td>
                                <td>
                                    @if ($item->anexo_report_mensal)
                                        <a href="{{ asset('storage/report_mensal/' . $item->anexo_report_mensal) }}" target="_blank">{{$item->anexo_report_mensal}}</a>
                                    @endif
                                </td>
                                <td>{{ $item->user->name ?? ''}}</td>
                                <td>{{ $item->senha_provisoria ?? ''}}</td>
                                <td>
                                    {{ $item->data_criacao_senha ? 
                                       \Carbon\Carbon::parse($item->data_criacao_senha)
                                           ->addDays(10)
                                           ->format('d-m-Y') : 
                                       '' 
                                    }}
                                </td>
                                        {{-- {{dd($item)}}                    pegar o nome do usuario  --}}
                                <td>{{$item->usuarioQueEnviouEmail->name??'' }} </td>
                                   
                                <td>{{$item->data_envio_email ?
                                    \Carbon\Carbon::parse($item->data_envio_email)
                                           ->format('d-m-Y') : 
                                       '' }}</td>
                                <td>
                                    @if (isset($item->anexo_fatura) || isset($item->anexo_recibo_verde))
                                        @if(isset($item->anexo_fatura))
                                            <a href="{{ Storage::url('mapa_comissoes/' . $item->anexo_fatura) }}" target="_blank" title="{{$item->anexo_fatura}}">
                                                <i class="fas fa-file" style="font-size: 24px; color: #ef6b01; margin-right: 20px;"></i> 
                                            </a>
                                        @endif

                                        @if(isset($item->anexo_recibo_verde))
                                            <a href="{{ Storage::url('mapa_comissoes/' . $item->anexo_recibo_verde) }}" target="_blank" title="{{$item->anexo_recibo_verde}}">
                                                <i class="fas fa-file" style="font-size: 24px; color: #ef6b01; margin-right: 10px;"></i> 
                                            </a>
                                        @endif
                                    @else
                                        {{ '' }}
                                    @endif
                                
                                </td>
                                {{-- <td>
                                    @if ($item->anexo_recibo_verde)
                                        <a href="{{ Storage::url('mapa_comissoes/' . $item->anexo_recibo_verde) }}" target="_blank">
                                            {{ $item->anexo_recibo_verde }}
                                        </a>
                                    @else
                                        {{ '' }}
                                    @endif
                                </td> --}}
                                <td class="text-right " style="width: 300px;">
                                        @if($item->questionarioId != null)
                                            <a href="{{route('report_mensal_questionario_visualizar', ['report_id' => $item->id, 'questionario_id'=> $item->questionarioId ])}} "><button class="btn btn-primary btn-sm" id="btn_editar" role="button" title="Editar">Visualizar Questionario</button></a>
                                        @else

                                        @endif
                                    <a href="{{route('gerar_relatorio_comissoes', ['report_mensal' => $item->id])}} "><button class="btn btn-primary btn-sm" id="btn_mapa_comissoes" role="button" title="Mapa de Comissões">Mapa de Comissões</button></a>
                                    <a href="{{route('report_mensal_edit', ['report_mensal_id' => $item->id])}} "><button class="btn btn-primary btn-sm" id="btn_editar" role="button" title="Editar">Editar</button></a>
                                    <a href="{{ route('report_mensal_destroy', $item->id) }}" id="btn_excluir_link">
                                        <button class="btn btn-primary btn-sm" role="button" title="Excluir" onclick="return confirmarExclusao()">Excluir</button>
                                    </a>
                                </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