@extends('layouts.app')

@section('title', 'Statistiche')

@section('content')
<style>
    
    .table-hover > tbody > tr:hover {
    background-color: #1ab394!important;
    color: #ffffff!important;
}

</style>
<div class="row wrapper border-bottom white-bg page-heading">
    
    <h1>Riepilogo Insoluti Utenze alla data odierna</h1>
    
    <div class="wrapper wrapper-content animated fadeInRight">


        
           <div class="row">
        <div class="panel">
            <div class="panel-body">
                <div class="col-md-12">
                    <table id="table_utenze" class="table table-striped table-hover dataTable no-footer">
                        <thead>
                            <tr>
                                <th>Servizio</th>
                                <th>Utenza</th>
                                <th>Agente Attuale</th>
                                <th>Nominativo</th>
                                <th>Codice Fiscale</th>
                                <th>Paritita Iva</th>
                                <th>Categoria Utenza</th>
                                <th>Telefono</th>
                                <th>Telefono 2</th>
                                <th>Numero fattura</th>
                                <th>data emissione</th>
                                <th>data scadenza</th>
                                <th>Importo Residuo</th>
                                <th>Totale Fattura</th>
                                <th>Pagata</th>
                                <th>Rateizzata</th>
                                <th>Stato Utenza</th>
            
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($utenze as $a )
                            <tr>
                                 <td>{{$a['SERVIZIO']}}</td>
                                <td>{{$a['Nr_Utenza']}}</td>
                                 <td>{{$a['AGENTE_ATTUALE']}}</td>
                                <td>{{$a['Nome_completo']}}</td>
                                
                                <td>{{$a['Cod_fiscale']}}</td>
                                <td>{{$a['Partita_iva']}}</td>
                                <td>{{$a['CATEGORIA_UTENZA']}}</td>
                                
                                <td>{{$a['TELEFONO']}}</td>
                                <td>{{$a['TELEFONO_UTENZA']}}</td>
                                <td>{{$a['Nr_documento']}}</td>
                                <td>{{date('d/m/Y',strtotime($a['DATA_EMISSIONE']))}}</td>
                                <td>{{date('d/m/Y',strtotime($a['DATA_SCADENZA']))}}</td>
                                <td>{{number_format($a['Importo_Residuo'],2,'.','')}}</td>
                                <td>{{number_format($a['TOTALEFATTURA'],2,'.','')}}</td>
                                <td>{{$a['Pagata']}}</td>
                                <td>{{$a['Rateizzata']}}</td>
                                <td>{{$a['Stato_utenza']}}</td>
                              
                            </tr>
                            @endforeach
                        </tbody>
                        
                    </table>
                    
                </div>
             
            </div>
        </div>
    </div>
</div>
</div>


@endsection 
@section('scripts')
<script>
$('table').dataTable({pageLength:15
        ,bSort : true,
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]}
       );
       
       
    
</script>
    
}
@endsection