@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">Faturas</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">
                        Faturas Cadastradas 
                    </div>
                </div>
            
            </div>

            <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>Total Faturado</th>
                            <th>Total Vencido</th>
                            <th class="">% Incumprimento</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($canais as $canal)
                            @if ($origem == $canal->id || $origem == null)
                                {{-- <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->totalfaturado, 2, ',', '.') }}</td>
                                    <td>{{ number_format($canal->totalvencido, 2, ',', '.') }}</td>
                                    <td class="">{{ (isset($canal->totalvencido) && isset($canal->totalfaturado)) ? number_format($canal->totalvencido / $canal->totalfaturado * 100,2) : 0 }}%</td>
                                </tr>
                            @endif
                        @endforeach
                        <tr class="text-center table-secondary">
                            <td>Total</td>
                            <td>{{ number_format($totais['totalfaturado'], 2, ',', '.') }}</td>
                            <td>{{ number_format($totais['totalvencido'], 2, ',', '.') }}</td>
                            <td class="">{{ (isset($totais['totalvencido']) && isset($totais['totalfaturado'])) ? number_format($totais['totalvencido'] / $totais['totalfaturado'] * 100,2) : 0 }}%</td>
                        </tr>
                    </tbody>
                </table>
            </div>

            <hr class="mx-3">

            <div class="px-3 pb-3">
                <br>

                <div id="tabelashow_cliente_fatura" class="table-responsive">
                    <table class=" tabelashow table table-bordered table-hover" >
                        <thead style="display: table-row-group">
                            <tr>
                                <th>Canal</th>
                                <th><div style="width:100px;">Nome Cliente</div></th>
                                <th>Fatura</th>
                                <th>Valor</th>
                                <th>Emissão</th>
                                <th>Vencimento</th>
                                <th>Vencido</th>
                                <th>Status</th>
                                @if($permissao->exibir_todas_faturas)
                                    <th class="">Gestor</th>
                                @endif
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($faturas->sortBy('dt_vencimento') as $item)
                            <tr>
                                <td>{{ $item->canal->nome_canal }}</td>

                                @if($item->origem == "IM" and isset($item->cliente_im->nome))
                                        <td>{{ $item->cliente_im->nome }}</td>
                                @elseif($item->origem =="TFUEL"  and isset($item->cliente_tfuel->nome))
                                        <td>{{ $item->cliente_tfuel->nome }}</td>
                                @else
                                        <td>Cliente Não encontrado</td>
                                @endif
                                
                                <td>{{ $item->num_documento }}</td>

                                <td>{{ number_format($item->valor_total, 2, ',', '.') }}</td>

                                <td>{{ date('d/m/Y', strtotime($item->dt_emissao)) }}</td>

                                <td>{{ date('d/m/Y', strtotime($item->dt_vencimento)) }}</td>

                                @if ($item->status == "Pendente")
                                    @if($item->dt_vencimento < \Carbon\Carbon::now()) 
                                        <td class="bg-danger ">
                                            Sim
                                        </td>
                                    @else
                                        <td class="">
                                            Não
                                        </td>
                                    @endif
                                @else
                                    <td class=""></td>
                                @endif

                                @if ($item->sinistro == "Sim")
                                    <td>
                                        Sinistrado
                                    </td>
                                @else
                                    <td @if ($item->status == "Paga") class="bg-success" @elseif ($item->status == "PPago") style="background-color: #ffc000;" @elseif($item->status == "Promessa de PagamentoV") class="bg-danger"  @endif>
                                        {{ $item->status }}
                                    </td>
                                @endif

                                @if($permissao->exibir_todas_faturas)
                                    @if($item->origem == "IM" and isset($item->cliente_im->gestor_user->name))
                                            <td class="">{{ $item->cliente_im->gestor_user->name }}</td>
                                    @elseif($item->origem =="TFUEL"  and isset($item->cliente_tfuel->gestor_user->name))
                                            <td class="">{{ $item->cliente_tfuel->gestor_user->name }}</td>
                                    @else
                                            <td class=""></td>
                                    @endif
                                @endif
                            </tr>
                            @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": false,
          "ordering": true,
          "info": true,
          "autoWidth": false,
          "responsive": false,
          "order": [[1, "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('#DataTables_Table_0_wrapper .col-md-6:eq(0)');
    
    </script>

@endsection