@extends('models')
@section('titre-page', 'Evaluation personnel')
@section('content-body')
    <!-- Page Header -->
    <div class="d-md-flex d-block align-items-center justify-content-between mt-4 page-header-breadcrumb ">
        <!-- Start:: row-7 -->
        <div class="col-xl-12 col-12">
            <div class="row mb-2">
                <div class="col-xl-7 col-md-4 mt-2">
                    <nav>
                        <ol class="breadcrumb mb-0">
                            <li class="breadcrumb-item text-light"><a href="javascript:void(0);">Contrôles</a></li>
                            <li class="breadcrumb-item active" aria-current="page">Evaluation personnel</li>
                        </ol>
                    </nav>
                </div>

                <div class="col-xl-5 col-md-8">
                    {{-- <button class="btn btn-primary" id="verifycode">check</button> --}}
                </div>
            </div>
        </div>
    </div>
    <div class="card">

        <div class="card-body">
            <nav class="nav nav-pills flex-column flex-sm-row mb-3" role="tablist">
                <a class="flex-sm-fill text-sm-center nav-link active" id="onglet1" data-bs-toggle="tab" role="tab"
                    aria-current="page" href="#BacARecuperer" aria-selected="true">EVALUATION TELEMARKET</a>
                <a class="flex-sm-fill text-sm-center nav-link" id="onglet2" data-bs-toggle="tab" role="tab"
                    aria-current="page" href="#BacEnCoursDeLivraison" aria-selected="false">EVALUATION COLLECTEUR</a>

                <a class="flex-sm-fill text-sm-center nav-link" id="onglet3" data-bs-toggle="tab" role="tab"
                    aria-current="page" href="#BacArechercher" aria-selected="false">EVALUATION CONTROLEUR</a>

                <a class="flex-sm-fill text-sm-center nav-link" id="onglet4" data-bs-toggle="tab" role="tab"
                    aria-current="page" href="#BacDisponible" aria-selected="false">EVALUTION LIVREUR</a>
            </nav>

            <div class="tab-content" id="tabs" >
                <div class="tab-pane text-muted active" id="BacARecuperer" role="tabpanel">
                    <div class="row mb-3">

                        <div class="col-xl-3">
                            <label for="" class="mt-2">N° Commande </label> <span class="mt-2 me-2">:</span>
                            <input type="text" class="form-control " style="padding :6px" id="numeroCmde">
                        </div>

                        <div class="col-xl-2">
                            <label for="" class="mt-2">Agence</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select AgenceListSelect" id="AgenceListSelect"  @disabled(checkIfDroit('DG_AccesMultiSite'))>
                            </select>
                        </div>

                        <div class="col-xl-3">
                            <label for="" class="mt-2">Période </label> <span class="mt-2 me-2">:</span>
                            <input type="text" name="daterange" class="form-control text-center dateInputSearch2"
                                style="padding :6px" id="dateInputSearch">
                        </div>

                        <div class="col-xl-3">
                            <label for="" class="mt-2">Télémarket</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select livreur" id="telemarket">
                            </select>
                        </div>

                        <div class="col-xl-1">
                            <div id="BlockBtnSearch" class="mt-4">
                                <span role="button" id="FilterEvaluationTelemaket"
                                    class="badge bg-primary d-flex justify-content-center align-items-center"
                                    style="height: 33px; width:60px;"><i class="ri ri-search-line"
                                        style="font-size:17px;"></i></span>
                            </div>
                        </div>
                    </div>

                    <div class="table-responsive">
                        <table class="tablehover table table-striped text-nowrap w-100" id="evalutationTelemaket1Table">
                            <thead class="bg-thead">
                                <tr>
                                    <th>Télémarket</th>
                                    <th>Nbre de commande</th>
                                    <th>Nbre ligne</th>
                                    <th>Montant total commande</th>
                                    <th>Temps de saisie</th>
                                    <th>Vitesses</th>
                                    <th>Nb de ligne saisie/jours</th>
                                </tr>
                            </thead>
                        </table>
                    </div>

                    <div class="table-responsive">
                        <table class="tablehover table table-striped text-nowrap w-100 " id="EvalutationTelemaket2Table">
                            <thead class="bg-thead">
                                <tr>
                                    <th>Date</th>
                                    <th>N° commande</th>
                                    <th>Nbre ligne</th>
                                    <th>Début commande</th>
                                    <th>Fin commande</th>
                                    <th>Temps mis</th>
                                    <th>Télémarket</th>
                                    <th>Vitesse</th>
                                    <th>Client</th>

                                </tr>
                            </thead>
                        </table>
                    </div>





                </div>

                {{-- ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: --}}

                <div class="tab-pane text-muted " id="BacEnCoursDeLivraison" role="tabpanel">

                    <div class="row mb-3">

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

                            <label for="" class="mt-2">N° Facture </label> <span class="mt-2 me-2">:</span>
                            <input type="text" class="form-control " style="padding :6px"
                                id="NumeroFactureCollecteur">
                        </div>

                        <div class="col-xl-2">

                            <label for="" class="mt-2">Agence</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select AgenceListSelect" id="AgenceCollecteur"  @disabled(checkIfDroit('DG_AccesMultiSite'))>
                            </select>
                        </div>

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

                            <label for="" class="mt-2">Période </label> <span class="mt-2 me-2">:</span>
                            <input type="text" name="daterange"
                                class="form-control dateInputSearchCollecteur text-center" style="padding :6px"
                                id="dateInputSearch">

                        </div>

                        <div class="col-xl-3">
                            <label for="" class="mt-2">Collecteur</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select livreur" id="collecteur">
                            </select>
                        </div>

                        <div class="col-xl-1">
                            <div class="mt-4">
                                <span role="button" id="FilterEvaluationCollecteur"
                                    class="badge bg-primary d-flex justify-content-center align-items-center"
                                    style="height: 33px; width:60px;"><i class="ri ri-search-line"
                                        style="font-size:17px;"></i></span>
                            </div>
                        </div>

                    </div>




                    <div class="table-responsive">
                        <table class="tablehover table table-striped text-nowrap" id="EvalutationCollecteur1Table"
                            style="width:100%">
                            <thead class="bg-thead">
                                <tr>
                                    <th>Collecteur</th>
                                    <th>Nbre de facture</th>
                                    <th>Nbre ligne</th>
                                    <th>Montant total facture</th>
                                    <th>Montant total collecté</th>
                                    <th>Temps de collecte</th>
                                    <th>Vitesse</th>
                                    <th>Nb de ligne collecté/jours</th>
                                </tr>
                            </thead>
                        </table>
                    </div>



                    <div class="table-responsive">
                        <table class="tablehover table table-striped text-nowrap w-100" id="EvalutationCollecteur2Table">
                            <thead class="bg-thead">
                                <tr>
                                    <th>Date</th>
                                    <th>N° facture</th>
                                    <th>Nbre ligne</th>
                                    <th>Début collecte</th>
                                    <th>Fin collecte</th>
                                    <th>Temps mis</th>
                                    <th>Collecteur</th>

                                    <th>Vitesse</th>

                                </tr>
                            </thead>
                        </table>
                    </div>


                </div>

                {{-- ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: --}}

                <div class="tab-pane text-muted " id="BacArechercher" role="tabpanel">

                    <div class="row mb-3">

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

                            <label for="" class="mt-2">N° Facture </label> <span class="mt-2 me-2">:</span>
                            <input type="text" class="form-control " style="padding :6px"
                                id="NumeroFactureCoControleur">
                        </div>

                        <div class="col-xl-2">

                            <label for="" class="mt-2">Agence</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select AgenceListSelect" id="AgenceControleur"  @disabled(checkIfDroit('DG_AccesMultiSite'))>
                            </select>
                        </div>

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

                            <label for="" class="mt-2">Période </label> <span class="mt-2 me-2">:</span>
                            <input type="text" name="daterange"
                                class="form-control dateInputSearchControleur text-center" style="padding :6px"
                                id="dateInputSearch">

                        </div>

                        <div class="col-xl-3">
                            <label for="" class="mt-2">Contrôleur</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select livreur" id="controleur">
                            </select>
                        </div>

                        <div class="col-xl-1">
                            <div class="mt-4">
                                <span role="button" id="FilterEvaluationControleur"
                                    class="badge bg-primary d-flex justify-content-center align-items-center"
                                    style="height: 33px; width:60px;"><i class="ri ri-search-line"
                                        style="font-size:17px;"></i></span>
                            </div>
                        </div>

                    </div>



                    <div class="table-responsive">
                        <table class="tablehover table table-striped text-nowrap w-100" id="EvalutationControleur1Table">
                            <thead class="bg-thead">
                                <tr>
                                    <th>Controleur</th>
                                    <th>Nbre de facture</th>
                                    <th>Nbre ligne</th>
                                    <th>Montant total facture</th>
                                    <th>Montant total collecté</th>
                                    <th>Temps de contrôle</th>
                                    <th>Vitesse</th>
                                    <th>Nb de ligne contrôlé/jours</th>
                                </tr>
                            </thead>
                        </table>
                    </div>



                    <div class="table-responsive">
                        <table class="tablehover table table-striped text-nowrap w-100" id="EvalutationControleur2Table">
                            <thead class="bg-thead">
                                <tr>
                                    <th>Date</th>
                                    <th>N° facture</th>
                                    <th>Nbre ligne</th>
                                    <th>Début contrôle</th>
                                    <th>Fin contrôle</th>
                                    <th>Temps mis</th>
                                    <th>Contrôleur</th>
                                    <th>Vitesse</th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>

                {{-- ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: --}}

                <div class="tab-pane text-muted " id="BacDisponible" role="tabpanel">

                    <div class="row mb-3">


                        <div class="col-xl-2">

                            <label for="" class="mt-2">Agences</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select AgenceListSelect" id="AgenceLivreur"  @disabled(checkIfDroit('DG_AccesMultiSite'))>
                            </select>
                        </div>

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

                            <label for="" class="mt-2">Tournées</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select " id="tournee">
                            </select>
                        </div>

                        <div class="col-xl-2">

                            <label for="" class="mt-2">Période </label> <span class="mt-2 me-2">:</span>
                            <input type="text" name="daterange" class="form-control dateInputSearch2 text-center"
                                style="padding :6px" id="PeriodeLivreur">

                        </div>

                        <div class="col-xl-4">
                            <label for="" class="mt-2">Livreur</label> <span class="mt-2 me-2">:</span>
                            <select class="Pselect2 form-select livreur" id="Filterlivreur">
                            </select>
                        </div>

                        <div class="col-xl-1">
                            <div class="mt-4">
                                <span role="button" id="FilterEvaluationLivreur"
                                    class="badge bg-primary d-flex justify-content-center align-items-center"
                                    style="height: 33px; width:60px;"><i class="ri ri-search-line"
                                        style="font-size:17px;"></i></span>
                            </div>
                        </div>

                    </div>


                    <div class="table-responsive">
                        <table class="tablehover table table-striped text-nowrap w-100" id="BigTableEvalutationLivreur">
                            <thead class="bg-thead">
                                <tr>
                                    <th>Date</th>
                                    <th>N° Expédition</th>

                                    <th>Heure depart</th>
                                    <th>Tournée</th>
                                    <th>Nbre colis</th>
                                    <th>Nbre Officines</th>

                                    <th>Véhicule/Moto</th>
                                    <th>Km départ</th>
                                    <th>Livreur</th>
                                    <th>Heure retour</th>

                                    <th>Km retour</th>
                                    <th>Durée</th>
                                    <th>Km parcourus</th>
                                </tr>
                            </thead>
                        </table>

                    </div>


                    <div class="row">

                        <div class="col-xl-4">
                            <span class="badge bg-success"> <i class="ti ti-star"></i> Evaluation livreur</span>
                            <div class="table-responsive">
                                <table class="tablehover table table-striped text-nowrap w-100"
                                    id="SmallTableEvalutationLivreur1">
                                    <thead class="bg-thead">
                                        <tr>
                                            <th>Livreur</th>
                                            <th>Nbre tournées</th>
                                            <th>Km parcourus</th>
                                            <th>Durée</th>
                                            <th>Nbre colis</th>
                                            <th>Nbre Officines</th>
                                            <th>Total CA</th>
                                        </tr>
                                    </thead>
                                </table>

                            </div>

                        </div>

                        <div class="col-xl-4">
                            <span class="badge bg-success"> <i class="ti ti-star"></i> Mesure des données des tournées et
                                rentabilité</span>
                            <div class="table-responsive">
                                <table class="tablehover table table-striped text-nowrap w-100"
                                    id="SmallTableEvalutationLivreur2">
                                    <thead class="bg-thead">
                                        <tr>

                                            <th>Tournées</th>
                                            <th>Km parcourus</th>
                                            <th>Durée</th>
                                            <th>Nbre colis</th>
                                            <th>Nbre Officines</th>
                                            <th>Total CA</th>
                                        </tr>
                                    </thead>
                                </table>

                            </div>

                        </div>

                        <div class="col-xl-4">
                            <span class="badge bg-success"> <i class="ti ti-star"></i> Extreme</span>
                            <div class="table-responsive">
                                <table class="tablehover table table-striped text-nowrap w-100"
                                    id="SmallTablEvalutationeLivreur3">
                                    <thead class="bg-thead">
                                        <tr>

                                            <th>Tournées</th>
                                            <th>Km parcourus(Meilleurs)</th>
                                            <th>Durée</th>
                                            <th>Km parcourus(Mauvaise)</th>
                                            <th>Durée</th>
                                        </tr>
                                    </thead>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>
    @endsection

    @section('script')
        <script>
            $(document).ready(function() {

                var onglet = 1;

                listeAgence();
                listingComboTourneeClient('#tournee')
                listingComboPersonnel('.livreur')

                divShowPer = $('#evalutationTelemaket1Table_filter')
                let BroDivShowPer = divShowPer.parent().prev()
                BroDivShowPer.addClass('d-flex')
                BroDivShowPer.append(
                    `
                        <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                                    <i class='ri ri-file-excel-2-line text-success me-1' style="font-size : 18px; cursor : pointer;"></i>
                                    <span id="btn-export-Telemaket1Table-excel" class="fw-bold" style="cursor : pointer;">Exporter</span>
                                </span>
                        `
                )

                divShowPer1 = $('#EvalutationControleur1Table_filter')
                let BroDivShowPer1 = divShowPer1.parent().prev()
                BroDivShowPer1.addClass('d-flex')
                BroDivShowPer1.append(
                    `
                        <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                                    <i class='ri ri-file-excel-2-line text-success me-1' style="font-size : 18px; cursor : pointer;"></i>
                                    <span id="btn-export-Controleur1Table-excel" class="fw-bold" style="cursor : pointer;">Exporter</span>
                                </span>
                        `
                )

                divShowPer2 = $('#EvalutationCollecteur1Table_filter')
                let BroDivShowPer2 = divShowPer2.parent().prev()
                BroDivShowPer2.addClass('d-flex')
                BroDivShowPer2.append(
                    `
                        <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                                    <i class='ri ri-file-excel-2-line text-success me-1' style="font-size : 18px; cursor : pointer;"></i>
                                    <span id="btn-export-Collecteur1Table-excel" class="fw-bold" style="cursor : pointer;">Exporter</span>
                                </span>
                        `
                )

                divShowPer3 = $('#BigTableEvalutationLivreur_filter')
                let BroDivShowPer3 = divShowPer3.parent().prev()
                BroDivShowPer3.addClass('d-flex')
                BroDivShowPer3.append(
                    `
                        <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                                    <i class='ri ri-file-excel-2-line text-success me-1' style="font-size : 18px; cursor : pointer;"></i>
                                    <span id="btn-export-EvalutationLivreur-excel" class="fw-bold" style="cursor : pointer;">Exporter</span>
                                </span>
                        `
                )

                divShowPer4 = $('#EvalutationTelemaket2Table_filter')
                let BroDivShowPer4 = divShowPer4.parent().prev()
                BroDivShowPer4.addClass('d-flex')
                BroDivShowPer4.append(
                    `
                        <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                                    <i class='ri ri-file-excel-2-line text-success me-1' style="font-size : 18px; cursor : pointer;"></i>
                                    <span id="btn-export-Telemaket2Table-excel" class="fw-bold" style="cursor : pointer;">Exporter</span>
                                </span>
                        `
                )

                divShowPer5 = $('#EvalutationCollecteur2Table_filter')
                let BroDivShowPer5 = divShowPer5.parent().prev()
                BroDivShowPer5.addClass('d-flex')
                BroDivShowPer5.append(
                    `
                        <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                                    <i class='ri ri-file-excel-2-line text-success me-1' style="font-size : 18px; cursor : pointer;"></i>
                                    <span id="btn-export-Collecteur2Table-excel" class="fw-bold" style="cursor : pointer;">Exporter</span>
                                </span>
                        `
                )

                divShowPer6 = $('#EvalutationControleur2Table_filter')
                let BroDivShowPer6 = divShowPer6.parent().prev()
                BroDivShowPer6.addClass('d-flex')
                BroDivShowPer6.append(
                    `
                        <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                                    <i class='ri ri-file-excel-2-line text-success me-1' style="font-size : 18px; cursor : pointer;"></i>
                                    <span id="btn-export-Controleur2Table-excel" class="fw-bold" style="cursor : pointer;">Exporter</span>
                                </span>
                        `
                )

                tableTelemarket1 = $('#evalutationTelemaket1Table').DataTable();
                tableTelemarket2 = $('#EvalutationTelemaket2Table').DataTable();
                tablenCollecteur1 = $('#EvalutationCollecteur1Table').DataTable();
                tableCollecteur2 = $('#EvalutationCollecteur2Table').DataTable();
                tableControleur1 = $('#EvalutationControleur1Table').DataTable();
                tableControleur2 = $('#EvalutationControleur2Table').DataTable();
                TableEvalutationExpeditionLivreur = $('#BigTableEvalutationLivreur').DataTable();
                SmallTableEvalutationLivreur1 = $('#SmallTableEvalutationLivreur1').DataTable();
                SmallTableEvalutationLivreur2 = $('#SmallTableEvalutationLivreur2').DataTable();
                SmallTablEvalutationeLivreur3 = $('#SmallTablEvalutationeLivreur3').DataTable();

                document.querySelectorAll('a[data-bs-toggle="tab"]').forEach(tab => {
                    tab.addEventListener('shown.bs.tab', event => {
                        // Onglet activé
                        const activatedTab = event.target; 
                        // if (activatedTab.id === "onglet1") {
                        // // targetPane.innerHTML += "<p><b>Ligne ajoutée au Profile</b></p>";
                        // }
                        if (activatedTab.id === "onglet2") {
                            tablenCollecteur1.draw()
                            tableCollecteur2.draw()
                        }
                        if (activatedTab.id === "onglet3") {
                        tableControleur1.draw()
                        tableControleur2.draw()
                        }
                        if (activatedTab.id === "onglet4") {
                        TableEvalutationExpeditionLivreur.draw()
                        SmallTableEvalutationLivreur1.draw()
                        SmallTableEvalutationLivreur2.draw()
                        SmallTablEvalutationeLivreur3.draw()
                        }
                    });
                });

                // EVALUATION TELEMARKET
                $(document).on('click', '#FilterEvaluationTelemaket', function() {

                    $date = dissocierDate($('#dateInputSearch').val())
                    $dateDeb = $date[0]
                    $dateFin = $date[1]

                    MarequetesAjax("{{ route('evaluationTelemaket.get') }}", "GET", {
                            'agence': $('#AgenceListSelect').val(),
                            'DateDeb': $dateDeb,
                            'DateFin': $dateFin,
                            'Telemaket': $('#telemarket').val(),
                            'numeroCommande': $('#numeroCmde').val(),
                        }, null, true, "JSON", function(resp) {
                            completeHandler()
                            if (resp.error) {
                                notifError(resp.msg)
                                return false;
                            }

                            
                            tableTelemarket1.clear().draw();

                            $.each(resp.tableauEvaTelemarket, function(key, value) {
                                tableTelemarket1.row.add([
                                    value.NomTelemarket,
                                    formatNumberPerf(value.NbCommande),
                                    value.NbLigneCmdeTotal,
                                    formatNumberPerf(value.MontantTotal),
                                    value.DureeEcouleConverti,
                                    value.VitesseTelemakert,
                                    formatNumberPerf(value.NbLigneSaisieParJour)
                                ]);
                            })

                            tableTelemarket1.draw();
                            
                            tableTelemarket2.clear().draw();

                            $.each(resp.tableauEvaTelemarket2, function(key, value) {

                                tableTelemarket2.row.add([

                                    formatDate(value.DateCommandeClient),
                                    value.NumeroCommandeClient,
                                    formatNumberPerf(value.NbreLigne_CommandeClient),
                                    formatDate(value.CreeLe),
                                    formatDate(value.DateCommandeClient),

                                    value.tempsEcoule,
                                    value.NomTelemarket,
                                    value.duree,
                                    value.NomClient,

                                ]);
                            })

                            tableTelemarket2.draw();

                            //fixeTableHeader(table)
                        }, function() {},
                        function() {
                            progressHandler()
                        })
                })

                // EVALUATION COLLECTEUR
                $(document).on('click', '#FilterEvaluationCollecteur', function() {


                    $date = dissocierDate($('.dateInputSearchCollecteur').val())
                    $dateDeb = $date[0]
                    $dateFin = $date[1]

                    MarequetesAjax("{{ route('evaluationCollecteur.get') }}", "GET", {
                            'agence': $('#AgenceCollecteur').val(),
                            'DateDeb': $dateDeb,
                            'DateFin': $dateFin,
                            'collecteur': $('#collecteur').val(),
                            'numerofacture': $('#NumeroFactureCollecteur').val(),

                        }, null, true, "JSON", function(resp) {

                            completeHandler()


                            if (resp.error) {
                                notifError(resp.msg)
                                return false;
                            }

                            

                            tablenCollecteur1.clear().draw();

                            $.each(resp.tableauEvaCollecteur1, function(key, value) {

                                tablenCollecteur1.row.add([

                                    value.NomCollecteur,
                                    formatNumberPerf(value.NbCommandeClient),
                                    formatNumberPerf(value.NbreLigneCmdeTotal),
                                    formatNumberPerf(value.SomFacture),
                                    formatNumberPerf(value.SomTotalCollecte),
                                    value.DureeEcoule,
                                    value.VitesseCollecteur,
                                    formatNumberPerf(value.NbreLigneSaisieParJour)
                                ]);
                            })

                            tablenCollecteur1.draw();

                            

                            tableCollecteur2.clear().draw();

                            $.each(resp.tableauEvaCollecteur2, function(key, value) {

                                tableCollecteur2.row.add([

                                    formatDate(value.DateFact),
                                    value.NumFact,
                                    formatNumberPerf(value.NbLigneFacTotal),
                                    formatDate(value.DDebutCollecte),
                                    formatDate(value.DFinCollecte),

                                    value.DureeEcoule,
                                    value.NomCollecteur,
                                    value.VitesseCollecteur,

                                ]);
                            })

                            tableCollecteur2.draw();

                            //fixeTableHeader(table)
                        }, function() {},
                        function() {
                            progressHandler()
                        })
                })


                // EVALUATION CONTROLEUR
                $(document).on('click', '#FilterEvaluationControleur', function() {


                    $date = dissocierDate($('.dateInputSearchControleur').val())
                    $dateDeb = $date[0]
                    $dateFin = $date[1]

                    MarequetesAjax("{{ route('evaluationControleur.get') }}", "GET", {
                            'agence': $('#AgenceCollecteur').val(),
                            'DateDeb': $dateDeb,
                            'DateFin': $dateFin,
                            'controleur': $('#Controleur').val(),
                            'numerofacture': $('#NumeroFactureCoControleur').val(),

                        }, null, true, "JSON", function(resp) {

                            completeHandler()


                            if (resp.error) {
                                notifError(resp.msg)
                                return false;
                            }

                            

                            tableControleur1.clear().draw();

                            $.each(resp.tableauEvaControleur1, function(key, value) {

                                tableControleur1.row.add([

                                    value.NomControleur,
                                    formatNumberPerf(value.NbCommandeClient),
                                    formatNumberPerf(value.NbreLigneCmdeTotal),
                                    formatNumberPerf(value.SomFacture),
                                    formatNumberPerf(value.SomTotalControle),
                                    value.DureeEcoule,
                                    value.VitesseControleur,
                                    formatNumberPerf(value.NbreLigneSaisieParJour)
                                ]);
                            })

                            tableControleur1.draw();



                            

                            tableControleur2.clear().draw();

                            $.each(resp.tableauEvaControleur2, function(key, value) {

                                tableControleur2.row.add([

                                    formatDate(value.DateFact),
                                    value.NumeroFacture,
                                    formatNumberPerf(value.NbLigne),
                                    formatDate(value.DDebutControle),
                                    formatDate(value.DFinControle),
                                    value.DureeEcoule,
                                    value.NomControleur,
                                    value.VitesseControle,

                                ]);
                            })

                            tableControleur2.draw();

                            //fixeTableHeader(table)
                        }, function() {},
                        function() {
                            progressHandler()
                        })
                })

                // EVALUATION LVREUR
                $(document).on('click', '#FilterEvaluationLivreur', function() {

                    $date = dissocierDate($('#PeriodeLivreur').val())
                    $dateDeb = $date[0]
                    $dateFin = $date[1]

                    MarequetesAjax("{{ route('evaluationLivreur.get') }}", "GET", {
                            'tournee': $('#tournee').val(),
                            'DateDeb': $dateDeb,
                            'DateFin': $dateFin,
                            'livreur': $('#Filterlivreur').val(),
                            'agence': $('#AgenceLivreur').val(),
                        }, null, true, "JSON", function(resp) {
                            completeHandler()
                            if (resp.error) {
                                notifError(resp.msg)
                                return false;
                            }

                            
                            TableEvalutationExpeditionLivreur.clear().draw();
                            $.each(resp.ExpeditionListe, function(key, value) {
                                TableEvalutationExpeditionLivreur.row.add([
                                    formatDate(value.DateHeureDepart, false),
                                    value.NumeroExpediTionTournee,
                                    formatDate(value.DateHeureDepart),
                                    value.LibelleTournee,
                                    formatNumberPerf(value.LaSomme_Colis),
                                    value.LeComptage_Officine,
                                    value.TypeVehicule,
                                    formatNumberPerf(value.KilometreDepart),
                                    value.NomPrenomPersonnel,
                                    formatDate(value.DateHeureRetour),
                                    formatNumberPerf(value.KilometreRetour),
                                    value.Duree,
                                    formatNumberPerf(value.CKmParcouru)
                                ]);
                            })

                            TableEvalutationExpeditionLivreur.draw();
                            
                            SmallTableEvalutationLivreur1.clear().draw();

                            $.each(resp.tabEvaLivreur, function(key, value) {

                                SmallTableEvalutationLivreur1.row.add([
                                    value.NomLivreur,
                                    formatNumberPerf(value.NbreTournee),
                                    value.kilometreParcouru,
                                    value.Duree,
                                    formatNumberPerf(value.NbreColis),
                                    formatNumberPerf(value.NbreOfficines),
                                    formatNumberPerf(value.TotalCa),
                                ]);
                            })

                            SmallTableEvalutationLivreur1.draw();
                            

                            SmallTableEvalutationLivreur2.clear().draw();

                            $.each(resp.tabEvaLivreurRentabilite, function(key, value) {

                                SmallTableEvalutationLivreur2.row.add([
                                    value.Tournee,
                                    formatNumberPerf(value.kilometreParcourus),
                                    value.Duree,
                                    formatNumberPerf(value.NbreColis),
                                    formatNumberPerf(value.NbreOfficine),
                                    formatNumberPerf(value.TotalCa),
                                ]);
                            })

                            SmallTableEvalutationLivreur2.draw();
                            
                            SmallTablEvalutationeLivreur3.clear().draw();
                            $.each(resp.tabExtremeParTournee, function(key, value) {
                                SmallTablEvalutationeLivreur3.row.add([
                                    value.LibelleTournee,
                                    formatNumberPerf(value.MeilleureDistance),
                                    value.LaDuree_MeilleureDistance,
                                    formatNumberPerf(value.MauvaiseDistance),
                                    value.LaDuree_MauvaiseDistance,
                                ]);
                            })

                            SmallTablEvalutationeLivreur3.draw();
                            //fixeTableHeader(table)
                        }, function() {},
                        function() {
                            progressHandler()
                        })
                })



                $(document).on('click', '#btn-export-Telemaket1Table-excel', function() {
                    var data = remplissage_avec_row_add_DataTable('evalutationTelemaket1Table')
                    const filename = file_name("EVALUATION_TELEMAKET");
                    download_excel_file('{{ route('export_global_excel.export') }}', data, filename, ['#'])
                })

                $(document).on('click', '#btn-export-Telemaket2Table-excel', function() {
                    var data = remplissage_avec_row_add_DataTable('EvalutationTelemaket2Table')
                    const filename = file_name("EVALUATION_TELEMAKET_2");
                    download_excel_file('{{ route('export_global_excel.export') }}', data, filename, ['#'])
                })

                $(document).on('click', '#btn-export-Controleur1Table-excel', function() {
                    var data = remplissage_avec_row_add_DataTable('EvalutationControleur1Table')
                    const filename = file_name("EVALUATION_CONTROLEUR");
                    download_excel_file('{{ route('export_global_excel.export') }}', data, filename, ['#'])
                })

                $(document).on('click', '#btn-export-Controleur2Table-excel', function() {
                    var data = remplissage_avec_row_add_DataTable('EvalutationControleur2Table')
                    const filename = file_name("EVALUATION_CONTROLEUR_2");
                    download_excel_file('{{ route('export_global_excel.export') }}', data, filename, ['#'])
                })

                $(document).on('click', '#btn-export-Collecteur1Table-excel', function() {
                    var data = remplissage_avec_row_add_DataTable('EvalutationCollecteur1Table')
                    const filename = file_name("EVALUATION_COLLECTEUR");
                    download_excel_file('{{ route('export_global_excel.export') }}', data, filename, ['#'])
                })

                $(document).on('click', '#btn-export-Collecteur2Table-excel', function() {
                    var data = remplissage_avec_row_add_DataTable('EvalutationCollecteur2Table')
                    const filename = file_name("EVALUATION_COLLECTEUR_2");
                    download_excel_file('{{ route('export_global_excel.export') }}', data, filename, ['#'])
                })

                $(document).on('click', '#btn-export-EvalutationLivreur-excel', function() {
                    var data = remplissage_avec_row_add_DataTable('BigTableEvalutationLivreur')
                    const filename = file_name("EVALUATION_LIVREUR");
                    download_excel_file('{{ route('export_global_excel.export') }}', data, filename, ['#'])
                })



            })
        </script>
    @endsection