@extends('layouts.squelette')
<!-- ************************************** -->
@section('titre')
{{ __("Tableau de bord") }}
@endsection
<!-- ************************************** -->
@section('titre_page')
{{ __("Indicateurs") }}
@endsection
<!-- ************************************** -->

@section('contenu')

<div class="row">
    <div class="col-md-3">

        <div class="info-box">
            <span class="info-box-icon bg-info-dash"><i class="far fa-thumbs-up"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">{{ __('CA') }}
                    {{-- <font size="2">( {{ session('nbjours_indicateurs', '60')}} derniers jours )</font> --}}
                    <font size="2">mois en cours</font>
                    <span class="float-right badge bg-info" data-toggle="tooltip" data-placement="top" title="Somme des factures clients.">
                        <i class="icon fas fa-info"></i>
                    </span>
                </span>
                <span class="info-box-number">{!! number_format($Q_CA, 2, ',', ' ') !!} €</span>

            </div>
        </div>

    </div>
    <div class="col-md-3">

        <div class="info-box">
            <span class="info-box-icon bg-info-dash"><i class="far fa-calendar-alt"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">{{ __('Marge') }}
                    {{-- <font size="2">( {{ session('nbjours_indicateurs', '60')}} derniers jours )</font> --}}
                    <font size="2">mois en cours</font>
                    <span class="float-right badge bg-info" data-toggle="tooltip" data-placement="top" title="Différence entre le total des factures clients et prestataires.">
                        <i class="icon fas fa-info"></i>
                    </span>
                </span>
                <span class="info-box-number">{!! number_format($Q_CA - $Q_Charges, 2, ',', ' ') !!} € ({!! $taux !!} %)</span>
            </div>
        </div>

    </div>
    <div class="col-md-3">

        <div class="info-box">
            <span class="info-box-icon bg-info-dash2"><i class="far fa-address-book"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">{{ __('Délai devis prestataires') }}
                    <font size="2">( {{ session('nbjours_indicateurs', '60')}} derniers jours )</font>
                    <span class="float-right badge bg-info" data-toggle="tooltip" data-placement="top" title="Différence entre les dates de retour souhaité et les dates de retour réel des devis prestataires.">
                        <i class="icon fas fa-info"></i>
                    </span>
                </span>
                <span class="info-box-number">{{ @$Q_DDP[0]->total ? $Q_DDP[0]->total.__(" jours") : 'NC'  }}</span>
            </div>
        </div>

    </div>
    <div class="col-md-3">

        <div class="info-box">
            <span class="info-box-icon bg-info-dash2"><i class="fas fa-users"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">{{ __('Délai devis client') }}
                    <font size="2">( {{ session('nbjours_indicateurs', '60')}} derniers jours )</font>
                    <span class="float-right badge bg-info" data-toggle="tooltip" data-placement="top" title="Différence entre les date de réalisation des devis et la date du retour client des devis clients.">
                        <i class="icon fas fa-info"></i>
                    </span>
                </span>
                <span class="info-box-number">{{ @$Q_DDC[0]->DelaiMoyenC ? $Q_DDC[0]->DelaiMoyenC.__(" jours") : 'NC'  }} </span>
            </div>
        </div>

    </div>
</div>

<div class="row">
    <div class="col-md-6">
        <!-- PIE CHART -->
        <div class="card card-widget">
            <div class="card-dashboard">
                <h2 class="my-0">{{ __('Top 6 activités année en cours') }}</h2>
            </div>
            <div class="card-body">
                <canvas id="pieChart" style="min-height: 250px; height: 250px; max-height: 250px; max-width: 100%;"></canvas>
            </div>
        </div>
    </div>
    <div class="col-md-3">

        <!-- ******************************TOP 7 ****************************************************-->
        <div class="card card-widget ">
            <div class="card-dashboard">
                <h2 class="my-0">{{ __('Top 7 des clients (nombre année en cours)') }}</h2>
            </div>
            <div class="card-footer p-0">
                <ul class="list-group">
                    @foreach (@$top10 as $client)
                    <li class="nav-item">
                        <a href="/customers/{{ @$client->cus_id }}/editCus" class="nav-link" target="_blank">{{ @$client->cus_socialReason }}<span class="float-right">{{ @$client->total }} </span></a>
                    </li>
                    @endforeach
                </ul>
            </div>
        </div>

    </div>
    <div class="col-md-3">

        <!-- ******************************TOP 7 CA****************************************************-->
        <div class="card card-widget ">
            <div class="card-dashboard">
                <h2 class="my-0">{{ __('Top 7 des clients (CA année en cours)') }}</h2>
            </div>
            <div class="card-footer p-0">
                <ul class="list-group">
                    @foreach (@$top10CA as $client)
                    <li class="nav-item">
                        <a href="/customers/{{ @$client->cus_id }}/editCus" class="nav-link" target="_blank">{{ @$client->cus_socialReason }}<span class="float-right">{{ number_format(@$client->total, 2, ',', ' ') }} €</span></a>
                    </li>
                    @endforeach
                </ul>
            </div>
        </div>

    </div>

</div>


<div class="row">
    <div class="col-md-6">

        <!-- ******************************GRAPHIQUE DES CA ****************************************************-->
        <div class="card card-widget">
            <div class="card-dashboard">
                <div class="d-flex justify-content-between">
                    <h2 class="my-0">{{ __('Chiffre d\'affaires') }}</h2>
                </div>
            </div>
            <div class="card-body">
                <div class="d-flex">

                </div>

                <div class="position-relative mb-4">
                    <canvas id="sales-chart" height="150"></canvas>
                </div>

                <div class="d-flex flex-row justify-content-end">

                </div>
            </div>
        </div>
    </div>
    <div class="col-md-6">
        <!-- ******************************GRAPHIQUE DES NB INTERVENTIONS ****************************************************-->
        <div class="card card-widget">
            <div class="card-dashboard">
                <div class="d-flex justify-content-between">
                    <h2 class="my-0">{{ __('Nombre d\'interventions') }}</h2>
                </div>
            </div>
            <div class="card-body">
                <div class="d-flex">

                </div>
                <!-- /.d-flex -->

                <div class="position-relative mb-4">
                    <canvas id="nbsales-chart" height="150"></canvas>
                </div>

                <div class="d-flex flex-row justify-content-end">

                </div>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <!-- DI -->

    <div class="col-md-3">

        <div class="small-box bg-info">
            <div class="inner">
                <span class="float-right badge bg-warning" data-toggle="tooltip" data-placement="top" title="Par rapport aux dates de création des DI.">
                    <i class="icon fas fa-info"></i>
                </span>
                <h4>{{ __('Nombre d\'interventions') }}</h4>
                <p>
                    <ul>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Jour') }}</div>
                            <div>{{ $stats_di[0]->di_d }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Semaine') }}</div>
                            <div>{{ $stats_di[0]->di_w }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Mois') }}</div>
                            <div>{{ $stats_di[0]->di_m }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Année') }}</div>
                            <div>{{ $stats_di[0]->di_y }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Année N-1 (a date)') }}</div>
                            <div>{{ $stats_di[0]->di_y1 }}</div>
                        </li>
                    </ul>
                </p>
            </div>
            <div class="icon">
                <i class="fas fa-truck"></i>
            </div>
            <!--<a href="#" class="small-box-footer">{{ __('Accèder aux interventions') }} <i class="fas fa-arrow-circle-right"></i></a>-->
        </div>

    </div>
    <!-- FACTURES PRESTATAIRES VALIDEES -->
    <div class="col-md-3">

        <div class="small-box bg-info">
            <div class="inner">
                <span class="float-right badge bg-warning" data-toggle="tooltip" data-placement="top" title="Par rapport à la date de création des factures.">
                    <i class="icon fas fa-info"></i>
                </span>
                <h4>{{ __('Factures prestataires enregistrées') }}</h4>
                <p>
                    <ul class="list-group">
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Jour') }}</div>
                            <div>{{ number_format($factP_validees[0]->fv_d, 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Semaine') }}</div>
                            <div>{{ number_format($factP_validees[0]->fv_w, 2, ',', ' ')  }} € </div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Mois') }}</div>
                            <div>{{ number_format($factP_validees[0]->fv_m, 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Année fiscale') }}</div>
                            <div>{{ number_format($factP_validees[0]->fv_y, 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Année fiscale N-1 (a date)') }}</div>
                            <div>{{ number_format($factP_validees[0]->fv_y1, 2, ',', ' ')  }} €</div>
                        </li>
                    </ul>
                </p>
            </div>
            <div class="icon">
                <i class="fas fa-file-invoice-dollar"></i>
            </div>
            <!--<a href="#" class="small-box-footer">{{ __('Accèder aux factures') }} <i class="fas fa-arrow-circle-right"></i></a>-->
        </div>

    </div>
    <!-- FACTURES CLIENTS VALIDEES -->
    <div class="col-md-3">

        <div class="small-box bg-info">
            <div class="inner">
                <span class="float-right badge bg-warning" data-toggle="tooltip" data-placement="top" title="Par rapport à la date de création des factures.">
                    <i class="icon fas fa-info"></i>
                </span>
                <h4>{{ __('Factures clients payées') }}</h4>
                <p>
                    <ul class="list-group">
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Jour') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_d, 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Semaine') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_w, 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Mois') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_m, 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Année fiscale ') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_y, 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Année fiscale N-1 (a date)') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_y1, 2, ',', ' ')  }} €</div>
                        </li>
                    </ul>
                </p>
            </div>
            <div class="icon">
                <i class="fas fa-file-invoice-dollar"></i>
            </div>
            <!--<a href="#" class="small-box-footer">{{ __('Accèder aux factures') }} <i class="fas fa-arrow-circle-right"></i></a>-->
        </div>

    </div>

    <!-- MARGE -->
    <div class="col-md-3">

        <div class="small-box bg-info">
            <div class="inner">
                <span class="float-right badge bg-warning" data-toggle="tooltip" data-placement="top" title="Par rapport à la date de création des factures.">
                    <i class="icon fas fa-info"></i>
                </span>
                <h4>{{ __('Marge') }}</h4>
                <p>
                    <ul class="list-group">
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Jour') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_d-$factP_validees[0]->fv_d, 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Semaine') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_w-$factP_validees[0]->fv_w , 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Mois') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_m-$factP_validees[0]->fv_m , 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Année fiscale') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_y-$factP_validees[0]->fv_y , 2, ',', ' ')  }} €</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Total Année fiscale N-1 (a date)') }}</div>
                            <div>{{ number_format($factC_validees[0]->fv_y1-$factP_validees[0]->fv_y1 , 2, ',', ' ')  }} €</div>
                        </li>
                    </ul>
                </p>
            </div>
            <div class="icon">
                <i class="fas fa-file-invoice-dollar"></i>
            </div>
            <!--<a href="#" class="small-box-footer">{{ __('Accèder aux factures') }} <i class="fas fa-arrow-circle-right"></i></a>-->
        </div>

    </div>

</div>
<div class="row">
    <div class="col-md-6">

            <div class="card">
                <div class="card-header bg-info">
                <h3 class="card-title"><font color="#000000">Délais prestataires (en nombre de jours) par rapport aux dates des devis</font></h3>
                </div>
                <!-- /.card-header -->
                <div class="card-body p-0">
                <table class="table table-sm">
                    <thead>
                    <tr>
                        <th>Description</th>
                        <th>Mois en cours</th>
                        <th>Année en cours</th>
                        <th>Année N-1 (à date)</th>
                    </tr>
                    </thead>
                    <tbody>
                    <tr>
                        <td>Demande devis à réception devis</td>
                        <td><span class="badge bg-info">{{ $delais_prestas[1]['mois'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_prestas[1]['annee'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_prestas[1]['annee_prec'] }}</span></td>
                    </tr>
                    <tr>
                        <td>Validation devis et date planification commande </td>
                        <td><span class="badge bg-info">{{ $delais_prestas[3]['mois'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_prestas[3]['annee'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_prestas[3]['annee_prec'] }}</span></td>
                    </tr>
                    <tr>
                        <td>Date retour souhaitée et date retour réelle</td>
                        <td><span class="badge bg-info">{{ $delais_prestas[2]['mois'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_prestas[2]['annee'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_prestas[2]['annee_prec'] }}</span></td>
                    </tr>
                    </tbody>
                </table>
                </div>
                <!-- /.card-body -->
            </div>
            <!-- /.card -->

            <div class="card">
                <div class="card-header bg-info">
                <h3 class="card-title"><font color="#000000">Délais interventions (en nombre de jours) par rapport aux dates de création</font></h3>
                </div>
                <!-- /.card-header -->
                <div class="card-body p-0">
                <table class="table table-sm">
                    <thead>
                    <tr>
                        <th>Description</th>
                        <th>Mois en cours</th>
                        <th>Année en cours</th>
                        <th>Année N-1 (à date)</th>
                    </tr>
                    </thead>
                    <tbody>
                    <tr>
                        <td>Création et planification</td>
                        <td><span class="badge bg-info">{{ $delais_di[1]['mois'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_di[1]['annee'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_di[1]['annee_prec'] }}</span></td>
                    </tr>
                    <tr>
                        <td>Planification réelle et planification souhaitée par le client</td>
                        <td><span class="badge bg-info">{{ $delais_di[2]['mois'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_di[2]['annee'] }}</span></td>
                        <td><span class="badge bg-info">{{ $delais_di[2]['annee_prec'] }}</span></td>
                    </tr>
                    </tbody>
                </table>
                </div>
                <!-- /.card-body -->
            </div>

    </div>

    <div class="col-md-6">


        <div class="card">
            <div class="card-header bg-info">
            <h3 class="card-title"><font color="#000000">Délais clients (par rapport à la date des devis)</font></h3>
            </div>
            <!-- /.card-header -->
            <div class="card-body p-0">
            <table class="table table-sm">
                <thead>
                <tr>
                    <th>Description</th>
                    <th>Mois en cours</th>
                    <th>Année en cours</th>
                    <th>Année N-1 (à date)</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td>Envoi du devis et validation par le client</td>
                    <td><span class="badge bg-info">{{ $delais_clients[1]['mois'] }}</span></td>
                    <td><span class="badge bg-info">{{ $delais_clients[1]['annee'] }}</span></td>
                    <td><span class="badge bg-info">{{ $delais_clients[1]['annee_prec'] }}</span></td>
                </tr>
                <tr>
                    <td>Création du devis et validation par le client</td>
                    <td><span class="badge bg-info">{{ $delais_clients[2]['mois'] }}</span></td>
                    <td><span class="badge bg-info">{{ $delais_clients[2]['annee'] }}</span></td>
                    <td><span class="badge bg-info">{{ $delais_clients[2]['annee_prec'] }}</span></td>
                </tr>

                <tr>
                    <td>Création du devis et envoi au client</td>
                    <td><span class="badge bg-info">{{ $delais_clients[3]['mois'] }}</span></td>
                    <td><span class="badge bg-info">{{ $delais_clients[3]['annee'] }}</span></td>
                    <td><span class="badge bg-info">{{ $delais_clients[3]['annee_prec'] }}</span></td>
                </tr>
                </tbody>
            </table>
            </div>
            <!-- /.card-body -->
        </div>

    </div>
</div>

{{-- <div class="row">
    <!-- Délais -->
    <div class="col-md-4 mt-3">

        <div class="small-box bg-warning">
            <div class="inner">
                <h4>{{ __('Délais - jour') }}</h4>
                <p>
                    <ul class="list-group">
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Création DI à planifier') }}</div>
                            <div>{{ $delai2[0]->valeur }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Demande de devis à réception devis') }}</div>
                            <div>{{ $delai1[0]->del_jour }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Réception devis à validation devis') }}</div>
                            <div>{{ $delai3[0]->del_jour }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Planifié à réaliser') }}</div>
                            <div>{{ $delai4[0]->del_jour }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Réalisé à clôturer') }}</div>
                            <div>{{ $delai5[0]->del_jour }} {{ __('jours') }}</div>
                        </li>
                    </ul>
                </p>
            </div>
            <div class="icon">
                <i class="fas fa-calendar-day"></i>
            </div>
            <!--<a href="#" class="small-box-footer">{{ __('Accèder aux ') }} <i class="fas fa-arrow-circle-right"></i></a>-->
        </div>
    </div>

    <div class="col-md-4 mt-3">

        <div class="small-box bg-warning">
            <div class="inner">
                <h4>{{ __('Délais - mois') }}</h4>
                <p>
                    <ul class="list-group">
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Création DI à planifier') }}</div>
                            <div>{{ $delai2[0]->valeur }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Demande de devis à réception devis') }}</div>
                            <div>{{ $delai1[0]->del_mois }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Réception devis à validation devis') }}</div>
                            <div>{{ $delai3[0]->del_mois }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Planifié à réaliser') }}</div>
                            <div>{{ $delai4[0]->del_mois }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Réalisé à clôturer') }}</div>
                            <div>{{ $delai5[0]->del_mois }} {{ __('jours') }}</div>
                        </li>
                    </ul>
                </p>
            </div>
            <div class="icon">
                <i class="fas fa-calendar-alt"></i>
            </div>
            <!--<a href="#" class="small-box-footer">{{ __('Accèder aux ') }} <i class="fas fa-arrow-circle-right"></i></a>-->
        </div>

    </div>

    <div class="col-md-4 mt-3">

        <div class="small-box bg-warning">
            <div class="inner">
                <h4>{{ __('Délais - année') }}</h4>
                <p>
                    <ul class="list-group">
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Création DI à planifier') }}</div>
                            <div>{{ $delai2[0]->valeur }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Demande de devis à réception devis') }}</div>
                            <div>{{ $delai1[0]->del_annee }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Réception devis à validation devis') }}</div>
                            <div>{{ $delai3[0]->del_annee }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Planifié à réaliser') }}</div>
                            <div>{{ $delai4[0]->del_annee }} {{ __('jours') }}</div>
                        </li>
                        <li class="d-flex justify-content-between">
                            <div>{{ __('Réalisé à clôturer') }}</div>
                            <div>{{ $delai5[0]->del_annee }} {{ __('jours') }}</div>
                        </li>
                    </ul>
                </p>
            </div>
            <div class="icon">
                <i class="far fa-calendar"></i>
            </div>
            <!--<a href="#" class="small-box-footer">{{ __('Accèder aux ') }} <i class="fas fa-arrow-circle-right"></i></a>-->
        </div>

    </div>

</div>

--}}
@endsection

@section('js_footer')
<script src="{{ asset('plugins/chart.js/Chart.min.js')}}"></script>

<!--Passage des données au fichier js -->
<script>
    var stats_activite = {!! json_encode($stats_activite) !!};
    var labelsGraph = {!! json_encode($labelsGraph) !!};
    var montants = {!!json_encode($montants) !!};
    var nombre = {!!json_encode($nombre) !!};
</script>
<script src="{{ asset('js/indicateur.js')}}"></script>
@endsection

@section('modale')

@endsection