@extends('layouts.admin')
@section('content')

@can('client_create')
    <title> LISTE DES COMMANDE CLIENTS </title> 
    <div style="margin-bottom: 10px;" class="row">
        <div class="col-lg-12">
            <form action="{{ route('admin.commande_fournisseur_rapport_produit_annuel.rechercher') }}" method="POST">
                @csrf    
                <input  type="number" min="2020" max="2099" step="1" value="" class="form-control" name="annee" />
                <br /> 
                <div class="text-center"> 
                    <input type="submit" class="btn btn-primary" value="Rechercher" />  
                </div>
            </form> 
        </div>
    </div>
@endcan

<div class="card">
    <div class="card-header text-center">
        LISTE DES PRODUITS COMMANDES DE L'ANNEE <strong> {{ $date }} </strong>
    </div>

    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-bordered table-striped table-hover datatable" id="table">
                <thead>
                    <tr>
                        <th>
                           Produit
                        </th>

                        <th>
                            Quantité
                        </th>
                       
                    </tr>
                </thead>
                <tbody>
                    @foreach($rap as $produit => $quantite)
                        <tr>
                            <td>
                                    {{ $produit }}
                            </td>

                            <td>
                                {{ $quantite }}
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
            <div class="text-danger"> TOTAL : {{ number_format($total, 0, '', ' ') }} </div> 
        </div>
    </div>
</div>

<div class="card card-primary">
    <div class="card-header">
        <h3 class="card-title"> Quantité de produit commandé  </h3>
    </div>
    <div class="card-body">
        <div class="chart">
            <canvas id="myChart" width="400" height="200"></canvas>
        </div>
    </div>
<!-- /.card-body -->
</div>
<script src="{{ asset('/plugins/chart.js/Chart.min.js') }}"></script>

<script>
    const ctx = document.getElementById('myChart').getContext('2d');

    const myChart = new Chart(ctx, {
        type: 'bar',
        data: {
            labels: @json($produits),
            datasets: [{
                label: 'Total par produit',
                data: @json($qtes),
                backgroundColor: '#2980b9',
                borderWidth: 1
            }]
        },
        options: {
            scales: {
                y: {
                    beginAtZero: false
                }
            }
        }
    });
</script>
@endsection
@section('scripts')
@parent
<script>
    $(function () {
    let dtButtons = $.extend(true, [], $.fn.dataTable.defaults.buttons)
    

  $.extend(true, $.fn.dataTable.defaults, {
    order: [[ 1, 'desc' ]],
   
    lengthMenu: [0, 5, 10, 20, 50, 100, 200, 500],
  });
     $('.datatable-Client:not(.ajaxTable)').DataTable({ buttons: dtButtons, 
        drawCallback: function () {
            var api = this.api();
            $( api.table().footer() ).html( '<strong>Total Montant : ' +
                api.column( 4, {page:'current'} ).data().sum() +
                ' FCFA <br/>Total Commission : ' +
                api.column( 5, {page:'current'} ).data().sum() + ' FCFA</strong>'
            );
        },
        
    });
     
  //console.log('Sum : ' + table.column( 4 ).data().sum())
    /*
        $('a[data-toggle="tab"]').on('shown.bs.tab', function(e){
            $($.fn.dataTable.tables(true)).DataTable()
                .columns.adjust();
        }).column( 4 ).data().sum();
    */
})
  
</script>


<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>


@endsection