@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">
    <input type='hidden' id="prezzi_fatturato" value='{{$importi}}'>
    <input type='hidden' id="labels_fatturato" value='{{$label_fatturato}}'>
    
    <input type='hidden' id="prezzi_incassi" value='{{$importi_incassi}}'>
  
    
    
    <h1>Riepilogo Fatturato/Incasso alla data odierna<small style="font-size:small;font-style: italic;">ultimo aggiornamento in data</small>
        <span class="pull-right">
            <div style="color:red">Totale Fatturato {{number_format($totale_fatturato,2)}}</div>
            <br>

            <div style="color:green">Totale Incassato {{number_format($totale_incasso,2)}}</div>
            <br>
            
            
        </span></h1>
    <div class="wrapper wrapper-content animated fadeInRight">

      <div class="row">
                <div class="col-md-12">
                    <div class="ibox float-e-margins">
                        <div class="ibox-title">
                        
                        </div>
                        <div class="ibox-content">
                            <div><iframe class="chartjs-hidden-iframe" style="width: 100%; display: block; border: 0px; height: 0px; margin: 0px; position: absolute; left: 0px; right: 0px; top: 0px; bottom: 0px;"></iframe>
                                <canvas id="lineChart" height="160" width="762" style="display: block; width: 762px; height: 355px;"></canvas>
                            </div>
                        </div>
                    </div>
                </div>
        
        </div>
        
        
        
                   <div class="row">
        <div class="panel">
            <div class="panel-body">
                <div class="col-md-6">
                    <h2>Totale Fatturato Annuo</h2>
                    <table id="table_fatturato" class="table table-striped table-hover dataTable no-footer">
                        <thead>
                            <tr>
                                <th>Anno</th>
                                <th>Mese</th>
                                <th>Importo</th>
                               
                            </tr>
                        </thead>
                        <tbody>
                             @foreach($fatturati as $f)
                             <tr>
                                 <td>{{$f->anno_fatturato}}</td>
                                 <td>{{$f->mese_fatturato}}</td>
                                 <td>{{number_format($f->importo_fatturato,2,',','.')}}</td>
                             </tr>
                             @endforeach
                            
                        </tbody>
                        
                        
                    </table>
                    
                </div>
                <div class="col-md-6">
                     <h2>Totale Incasso Annuo</h2>
                        <table id="table_incassi" class="table table-striped table-hover dataTable no-footer">
                        <thead>
                            <tr>
                                <th>Anno</th>
                                <th>Mese</th>
                                <th>Importo</th>
                                <th>Importo SDD</th>
                            </tr>
                        </thead>
                        <tbody>
                            
                             @foreach($incassi as $i)
                             <tr>
                                 <td>{{$i->anno_incasso}}</td>
                                 <td>{{$i->mese_incasso}}</td>
                                 <td>{{number_format($i->importo_incasso,2,',','.')}}</td>
                                 <td>{{number_format($i->importo_incasso_sdd,2,',','.')}}</td>
                             </tr>
                             @endforeach
                           
             
                        </tbody>
                        
                    </table>
                    
                </div>
            </div>
        </div>
    </div>
                           <div class="row">
        <div class="panel">
            <div class="panel-body">
                <div class="col-md-3">
                    
                </div>
                <div class="col-md-6">
                     <h2>Totale Incasso Mese in Corso</h2>
                        <table id="table_incassi" class="table table-striped table-hover dataTable no-footer">
                        <thead>
                            <tr>
                                <th>Giorno</th>
                                <th>Mese</th>
                                <th>Importo</th>
                            </tr>
                        </thead>
                        <tbody>
                            
                             @foreach($incassi_giorno as $daily)
                             <tr>
                                 <td>{{date('d', strtotime($daily->Datadiregistrazione))}}</td>
                                 <td>{{date('F', strtotime($daily->Datadiregistrazione))}}</td>
                                 <td>{{number_format($daily->TotaleGiorno,2,',','.')}}</td>
                             </tr>
                             @endforeach
                           
                        </tbody>
                        
                    </table>
                    
                </div>
                <div class="col-md-3">
                    
                </div>
            </div>
        </div>
    </div>
</div>
</div>




@endsection 

@section('scripts')
<script>
    
    
     var lineData = {
        labels: JSON.parse(document.getElementById("labels_fatturato").value),
        datasets: [

            {
                label: "Fatturato",
                backgroundColor: 'rgba(248,171,88,0.5)',
                borderColor: "rgba(248,172,89,0.7)",
                pointBackgroundColor: "rgba(255,12,12,1)",
                pointBorderColor: "#fff",
                data: JSON.parse(document.getElementById("prezzi_fatturato").value)
            },{
                label: "Incassi",
                backgroundColor: 'rgba(82, 255, 96, 0.7)',
                pointBorderColor: "#fff",
                data: JSON.parse(document.getElementById("prezzi_incassi").value)
            }
        ]
    };

    var lineOptions = {
        responsive: true
    };


    var ctx = document.getElementById("lineChart").getContext("2d");
    new Chart(ctx, {type: 'line', data: lineData, options:lineOptions});


$('table').dataTable({pageLength:7
        ,bSort : true,
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]}
       );
 

</script>

@endsection