@extends('models')
@section('titre-page', 'CA par produit')
@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">CA par produit</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="row g-2">

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

            <div class="row g-2">

                <div class="col-xl-4">
                    <div class="card custom-card border-top-card border-top-primary rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Nb. lignes</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="nbreLigne">0</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-xl-8">
                    <div class="card custom-card border-top-card border-top-primary rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Total Brut HT</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold " id="totalBrutHt">0 F</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            </div>

        </div>

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

            <div class="row g-2">

                <div class="col-xl-6">
                    <div class="card custom-card border-top-card border-top-primary rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Total Avoir</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalAvoir">0 F</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-xl-6">
                    <div class="card custom-card border-top-card border-top-primary rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Ratio</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalRatio">0 %</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>

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

            <div class="row g-2">

                <div class="col-xl-12">
                    <div class="card custom-card border-top-card border-top-primary rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Total HT</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalHT">0 F</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>



            </div>
        </div>


        <div class="col-xl-4">
            <div class="row g-2">

                <div class="col-xl-5">
                    <div class="card custom-card border-top-card border-top-primary rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Total TVA</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalTVA">0 F</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-xl-7">
                    <div class="card custom-card border-top-card border-top-primary rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Total TTC</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalTTC">0 F</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

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

    <div class="row g-2">

        <div class="col-xl-1">
            <div class="card custom-card border-top-card border-top-warning rounded-0">
                <div class="card-body p-3 py-2">
                    <div class="text-center">
                        <p class="fs-14 text-muted mb-1">Remise</p>
                        <div class="d-flex align-items-center justify-content-center flex-wrap">
                            <div class="mb-0 fw-semibold" id="totalRemise">0 F</div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

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

            <div class="row g-2">

                <div class="col-xl-6">
                    <div class="card custom-card border-top-card border-top-warning rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Total Achat</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalAchat">0 F</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-xl-6">
                    <div class="card custom-card border-top-card border-top-warning rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Bénéfice Brut</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalBenefBrut">0 F</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            </div>

        </div>

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

            <div class="row g-2">

                <div class="col-xl-6">
                    <div class="card custom-card border-top-card border-top-warning rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Bénéfice Net</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalBenefNet">0 F</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-xl-6">
                    <div class="card custom-card border-top-card border-top-warning rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">TM Brut</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalTMBrut">0 %</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>

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

            <div class="row g-2">

                <div class="col-xl-6">
                    <div class="card custom-card border-top-card border-top-warning rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">TM Net</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalTMNet">0 %</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-xl-6">
                    <div class="card custom-card border-top-card border-top-warning rounded-0">
                        <div class="card-body p-3 py-2">
                            <div class="text-center">
                                <p class="fs-14 text-muted mb-1">Répart</p>
                                <div class="d-flex align-items-center justify-content-center flex-wrap">
                                    <div class="mb-0 fw-semibold" id="totalRepart">0 %</div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
        </div>



    </div>
    <div class="card">
        <div class="card-header">

            <div class="row g-2">
                <div class="col-xl-5 mb-1">
                    <div class="row g-2">
                        <div class="col-xl-5">
                            <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-7">
                            <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" style="padding :6px"
                                id="dateInputSearch">
                        </div>
                    </div>
                </div>

                <div class="col-xl-3 mb-1">
                    <label for="" class="mt-2 ">Produit </label> <span class="mt-2 me-2">:</span>
                    <select class="Pselect2 form-select" name="" id="ProduitListSelect">
                    </select>
                </div>
                <div class="col-xl-2">
                    <label for="" class="mt-2 ">Laboratoire </label> <span class="mt-2 me-2">:</span>
                    <select name="form-select" id="selIDLABORATOIRE"></select>
                </div>
                <div class="col-xl-2">
                    <label for="" class="mt-2 ">Fournisseur </label> <span class="mt-2 me-2">:</span>
                    <select name="form-select" id="selIDFOURNISSEUR"></select>
                </div>
                <div class="col-xl-2">
                    <label for="" class="mt-2">TM Brut </label> <span class="mt-2 me-2">:</span>
                    <select class="Pselect2 form-select" id="tmbrut">
                        <option value="1"> Tous</option>
                        <option value="2"> > N</option>
                        <option value="3"> >= N</option>
                        <option value="4"> < N</option>
                        <option value="5"> <= N</option>
                        <option value="6"> = N</option>
                        <option value="7"> <> N </option>
                    </select>
                </div>
                <div class="col-xl-2">
                    <label for="" class="mt-2 me-2">N (%) </label>
                    <input type="text" value="0" class="form-control text-center" style="padding :6px"
                        id="Valeurn">
                </div>
                <div class="col-xl-2">
                    <label for="" class="mt-2">TM Net </label> <span>:</span>
                    <select class="Pselect2 form-select text-center" id="tmnet">
                        <option value="1"> Tous</option>
                        <option value="2"> > V </option>
                        <option value="3"> >= V </option>
                        <option value="4"> < V </option>
                        <option value="5"> <= V </option>
                        <option value="6"> = V </option>
                        <option value="7">  <> V </option>
                    </select>
                </div>
                <div class="col-xl-2">
                    <label for="" class="mt-2 me-2">V (%)</label>
                    <input type="text" name="" value="0" class="form-control text-center"
                        style="padding :6px" id="Valeurv">
                </div>
                <div class="col-xl-2" style="margin-top:34px;">
                    <div class="d-flex justify-content-center">
                        <div id="BlockBtnSearch" class="me-1">
                            <span role="button" id="ActualisationDonnee"
                                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 id="BlockBtnPrint">
                            <span role="button" id="ImprimerCAparProduit"
                                class="badge bg-warning d-flex justify-content-center align-items-center"
                                style="height: 33px; width:60px;">
                                <i class="ri ri-printer-line" style="font-size:17px;"></i></span>
                            </span>
                        </div>


                        <div id="BlockBtnLoad" style="display:none">
                            <span role="button" class="badge bg-warning d-flex justify-content-center align-items-center"
                                style="height: 33px; width:60px;">
                                <span class="spinner-border spinner-border-sm" role="status" aria-hidden="true"></span>
                            </span>
                        </div>

                        <div style="margin-left:4px">
                            <span role="button" id="ExporterExcelCAparProduit"
                                class="badge bg-success d-flex justify-content-center align-items-center"
                                style="height: 33px; width:60px;">
                                <i class="ri ri-file-excel-2-line" style="font-size:17px;"></i></span>
                            </span>
                        </div>
                    </div>
                </div>
            </div>


        </div>
        <div class="card-body">

            <div id="pdf-link" style="display:none"></div>

            <div class="table-responsive">

                <table class="tablehover table table-striped text-nowrap tablehover w-100 openModalProduit_"
                    id="tabListCAProduit">
                    <thead class="bg-thead">
                        <tr>
                            <th style="display:none">IDProduit</th>
                            <th>Produit</th>
                            <th>Bureau achat</th>
                            <th>Fournisseur</th>
                            <th>Laboratoire</th>
                            <th>Nature</th>
                            <th>Valeur VENTE HT Brut</th>
                            <th>Valeur AVOIR HT</th>
                            <th>Ratio Avoir</th>
                            <th>Valeur VENTE HT</th>
                            <th>Remise</th>
                            <th>Tva</th>
                            <th>Valeur VENTE TTC</th>
                            <th>Valeur de revient HT</th>
                            <th>Bénéfice Net</th>
                            <th>TM Brut</th>
                            <th>TM Net</th>
                            <th>Répartition</th>
                        </tr>
                    </thead>
                </table>
            </div>

        </div>
    </div>

@endsection

@section('script')

    <script>
        $(document).ready(function() {

            function listingLaboSimple(){

                return new Promise(function(resolve, reject) {

                    $.ajax({

                        url: '{{ route("listingLaboSimple") }}',
                        type: 'GET',
                        dataType: 'json',
                        beforeSend: progressHandler(),
                        success: function(response) {

                            if (response.success != 1) {

                                notifError(response.msg)
                            }

                            resolve(response)
                            completeHandler()
                        },
                        error: function(error) {

                            notifError('Échec de l\'opération.')
                            reject()

                            completeHandler()
                        }
                    })
                })
            }

            listingLaboSimple()
                .then((response) => {

                    if (response.success == 1) {
                        
                        let data = response.data

                        data.unshift({
                            IDLABORATOIRE : 0,
                            NomLaboratoire : 'TOUS'
                        })

                        populateSelect('#selIDLABORATOIRE', {

                            data : data,
                            valueKey : 'IDLABORATOIRE',
                            textKey : 'NomLaboratoire'
                        })

                        $('#selIDLABORATOIRE').select2()
                    }
                })

            function listeFournisseurSimple(){

                return new Promise(function(resolve, reject) {

                    $.ajax({

                        url: "{{ route('listeFournisseurSimple') }}",
                        type: 'GET',
                        dataType: 'json',
                        beforeSend: progressHandler(),
                        success: function(response) {

                            if (response.success != 1) {

                                notifError(response.msg)
                            }

                            completeHandler()
                            resolve(response)
                        },
                        error: function(error) {

                            notifError('Échec de l\'opération.')
                            reject()

                            completeHandler()
                        }
                    })
                })
            }

            listeFournisseurSimple()
                .then((response) => {

                    if (response.success == 1) {
                        
                        let data = response.data

                        data.unshift({
                            IDFOURNISSEUR : 0,
                            NomFournisseur : 'TOUS'
                        })

                        populateSelect('#selIDFOURNISSEUR', {

                            data : data,
                            valueKey : 'IDFOURNISSEUR',
                            textKey : 'NomFournisseur',
                        })

                        $('#selIDFOURNISSEUR').select2()
                    }
                })

            listeAgence();
            listeProduit();

            $date = dissocierDate($('#dateInputSearch').val())

            $Agence = $('#AgenceListSelect').val();
            $dateDeb = $date[0]
            $dateFin = $date[1]


            placeboutonPreferenceColonne('tabListCAProduit', 'CAProduitShowColonne', 2)
            recuperationPreferenceColonneUtilisateur('tabListCAProduit', 'CAProduitShowColonne')
            $(document).on('click', '.CAProduitShowColonne', function() {
                appliquerPreferenceColonne('tabListCAProduit', 'Chiffre-affaire-Par_produit', $(this),
                    'CAProduitShowColonne')
            })

            recuperationCAParProduit($Agence, $dateDeb, $dateFin, 0, 0, 0, 0, 0, 0, 0)

            $(document).on('click', '#ActualisationDonnee', function() {

                $date = dissocierDate($('#dateInputSearch').val())

                $Agence = $('#AgenceListSelect').val();
                $dateDeb = $date[0]
                $dateFin = $date[1]
                $produit = $('#ProduitListSelect').val();
                $tmBrut = $('#tmbrut').val();
                $N = $('#Valeurn').val();
                $tmNet = $('#tmnet').val();
                $V = $('#Valeurv').val();
                $IDLABORATOIRE = $('#selIDLABORATOIRE').val()
                $IDFOURNISSEUR = $('#selIDFOURNISSEUR').val()


                recuperationCAParProduit($Agence, $dateDeb, $dateFin, $produit, $tmBrut, $N, $tmNet, $V, $IDFOURNISSEUR, $IDLABORATOIRE)

            })

            $(document).on('click', '#ImprimerCAparProduit', function() {
                let table = $('#tabListCAProduit').DataTable();
                if (table.rows().count() === 0) {
                    notifWarning('Le tableau est vide')
                    return false;
                }

                $('#BlockBtnPrint').css('display', 'none');
                $('#BlockBtnLoad').css('display', 'block');
                $date = dissocierDate($('#dateInputSearch').val())
                $Agence = $('#AgenceListSelect').val();
                $dateDeb = $date[0]
                $dateFin = $date[1]
                $produit = $('#ProduitListSelect').val();
                $tmBrut = $('#tmbrut').val();
                $N = $('#Valeurn').val();
                $tmNet = $('#tmnet').val();
                $V = $('#Valeurv').val();


                $.ajax({
                    url: "{{ route('caParProduit.get') }}",
                    type: 'GET',
                    data: {
                        AgenceSelect: $Agence,
                        DebutPeriode: $dateDeb,
                        FinPeriode: $dateFin,
                        IDProduit: $produit,
                        TMBrut: $tmBrut,
                        TMNet: $tmNet,
                        valeurN: $N,
                        valeurV: $V,
                        Impression: 1
                    },
                    // Augmentez le délai d'attente à 10 secondes (valeur en millisecondes)
                    success: function(resp) {

                        $('#BlockBtnPrint').css('display', 'block');
                        $('#BlockBtnLoad').css('display', 'none');

                        if (resp.NotData) {
                            notif('danger', 'Erreur', resp.msg)
                        } else {

                            var downloadLink =
                                '<a id="download-link" href="data:application/pdf;base64,' +
                                resp.pdf +
                                '" download="document.pdf" target="_blank">Télécharger PDF</a>';
                            $('#pdf-link').html(downloadLink);

                            // Simuler un clic sur le lien de téléchargement
                            $('#download-link')[0].click();
                        }
                    },
                    error: function(xhr, status, error) {
                        // Gestion des erreurs
                    }
                });
            })

            $(document).on('click', '#ExporterExcelCAparProduit', function() {

                let table = $('#tabListCAProduit').DataTable();
                if (table.rows().count() === 0) {
                    notifWarning('Le tableau est vide')
                    return false;
                }
                TableToExcel.convert(document.getElementById("tabListCAProduit"), {

                    name: "CA_PRODUIT_" + $dateDeb + "_" + $dateFin + "_" + formatDateToYmdHisMs() +
                        ".xlsx",
                    sheet: {
                        name: "Feuille 1"
                    }
                })
            })

            $('#Valeurn').on('keydown', function(event) {
                // Autoriser les chiffres, le point, la touche retour arrière, et les touches de navigation
                const allowedKeys = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '.', 'Backspace',
                    'ArrowLeft', 'ArrowRight', 'Tab', 'Delete'
                ];

                // Vérifier si la touche est autorisée
                if (!allowedKeys.includes(event.key)) {
                    event.preventDefault();
                }

                // Empêcher plus d'un point
                if (event.key === '.' && $(this).val().includes('.')) {
                    event.preventDefault();
                }
            });

            $('#Valeurn').on('input', function() {
                let value = $(this).val();
                // Supprimer les caractères non numériques sauf le point
                $(this).val(value.replace(/[^0-9.]/g, ''));

                // Empêcher plus d'un point
                const parts = $(this).val().split('.');
                if (parts.length > 2) {
                    $(this).val(parts[0] + '.' + parts.slice(1).join(''));
                }
            });


            $('#Valeurv').on('keydown', function(event) {
                // Autoriser les chiffres, le point, la touche retour arrière, et les touches de navigation
                const allowedKeys = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '.', 'Backspace',
                    'ArrowLeft', 'ArrowRight', 'Tab', 'Delete'
                ];
                // Vérifier si la touche est autorisée
                if (!allowedKeys.includes(event.key)) {
                    event.preventDefault();
                }
                // Empêcher plus d'un point
                if (event.key === '.' && $(this).val().includes('.')) {
                    event.preventDefault();
                }
            });

            $('#Valeurv').on('input', function() {
                let value = $(this).val();
                // Supprimer les caractères non numériques sauf le point
                $(this).val(value.replace(/[^0-9.]/g, ''));

                // Empêcher plus d'un point
                const parts = $(this).val().split('.');
                if (parts.length > 2) {
                    $(this).val(parts[0] + '.' + parts.slice(1).join(''));
                }
            });

        })

        function recuperationCAParProduit($Agence, $dateDeb, $dateFin, $produit, $tmBrut, $N, $tmNet, $V, $IDFOURNISSEUR, $IDLABORATOIRE) {

            var table = $('#tabListCAProduit').DataTable();
            table.clear().draw();
            MarequetesAjax("{{ route('caParProduit.get') }}", "GET", {
                    AgenceSelect: $Agence,
                    DebutPeriode: $dateDeb,
                    FinPeriode: $dateFin,
                    IDProduit: $produit,
                    TMBrut: $tmBrut,
                    TMNet: $tmNet,
                    valeurN: $N,
                    valeurV: $V,
                    IDFOURNISSEUR : $IDFOURNISSEUR,
                    IDLABORATOIRE : $IDLABORATOIRE

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

                    if (resp.error) {
                        notifError(resp.msg)
                        completeHandler()
                        return false;
                    }
                    completeHandler()
                    $('#nbreLigne').text(resp.NbreLigne)
                    $('#totalBrutHt').text(formatNumber(resp.dataTotaux[0].T1_HTBrut) + ' F')
                    $('#totalAvoir').text(formatNumber(resp.dataTotaux[0].T1_AvoirHTCat) + ' F')
                    $('#totalRatio').text(formatNumber(resp.dataTotaux[0].T1_RatioAvoirCat) + '%')
                    $('#totalHT').text(formatNumber(resp.dataTotaux[0].T1_HTCat) + ' F')
                    $('#totalRemise').text(formatNumber(resp.dataTotaux[0].T1_RemiseCat) + ' F')
                    $('#totalTVA').text(formatNumber(resp.dataTotaux[0].T1_TaxeCat) + ' F')
                    $('#totalTTC').text(formatNumber(resp.dataTotaux[0].T1_TTCCat) + ' F')
                    $('#totalAchat').text(formatNumber(resp.dataTotaux[0].T1_AchatCat) + ' F')
                    $('#totalBenefBrut').text(formatNumber(resp.dataTotaux[0].T1_BeneficeBruteCat) + ' F')
                    $('#totalBenefNet').text(formatNumber(resp.dataTotaux[0].T1_BeneficeNetteCat) + ' F')
                    $('#totalTMBrut').text(formatNumber(resp.dataTotaux[0].T1_MargeBruteCat) + '%')
                    $('#totalTMNet').text(formatNumber(resp.dataTotaux[0].T1_MargeNetteCat) + '%')
                    $('#totalRepart').text(formatNumber(resp.dataTotaux[0].T1_RepartitionCat) + '%')

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

                        table.row.add([
                            value.IDPRODUIT,
                            value.DesignationProduit,
                            value.NomBureauAchat,
                            value.NomFournisseur,
                            value.NomLaboratoire,
                            value.LibelleCategorieProduit,
                            formatNumber(value.C_HTBrut),
                            formatNumber(value.C_HTAvoir),
                            formatNumber(value.C_RatioAvoir) + '%',
                            formatNumber(value.C_HT),
                            formatNumber(value.C_Remise),
                            formatNumber(value.C_Taxe),
                            formatNumber(value.C_TTC),
                            formatNumber(value.C_Achat),
                            formatNumber(value.C_BeneficeNette),
                            formatNumber(value.C_MargeBrute) + '%',
                            formatNumber(value.C_MargeNette) + '%',
                            formatNumber(value.C_RepartitionCat),
                        ])

                    })

                    table.draw();

                }, function() {},
                function() {
                    progressHandler()
                })

            new $.fn.dataTable.FixedHeader(table);
            table.fixedHeader.headerOffset(50)
        }

        function listeProduit() {
            MarequetesAjax("{{ route('listingProduitSimple') }}", "GET", null, null, true, "JSON", function(resp) {
                $('#ProduitListSelect').html('')
                $('#ProduitListSelect').append('<option value="0" selected>Tous</option>')
                $.each(resp.data, function(key, value) {
                    $('#ProduitListSelect').append('<option value="' + value.IDPRODUIT + '">' + value
                        .DesignationProduit + '</option>');
                })
            })
        }

        function formatNumberInput(input) {
            input.value = input.value.replace(/,/g, ',');
            if (!isNaN(parseFloat(input.value)) && isFinite(input.value)) {
                input.value = parseFloat(input.value).toFixed(2);
            } else {
                input.value = '';
                alert('Veuillez saisir un nombre valide');
            }
        }
    </script>
@endsection