@extends('models')
@section('titre-page', 'Escompte ristourne')
@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);">Administration</a></li>
                        <li class="breadcrumb-item active" aria-current="page">Escompte ristourne</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">

          <input type="hidden" id="decrypted-id" value="{{ $id_}}">
        <div class="row g-2">
            <div class="col-xl-5 mb-2">
                <div class="row g-2">
                    <div class="col-xl-6">
                        <label for="" class="mt-2 me-2">CA Mini :</label> 
                        <input type="number" name="" class="form-control text-center" style="padding :6px" id="CAMini">
                    </div>

                    <div class="col-xl-6">
                        <label for="" class="mt-2 me-2">CA Maxi :</label>
                        <input type="number" name="" class="form-control text-center" style="padding :6px" id="CAMaxi">
                    </div>
                </div>
            </div>

            <div class="col-xl-3 mb-2">
                <div class="row g-2">
                    <div class="col-xl-4">
                        <label for="" class="mt-2 ">T.ristourne  </label> <span class="mt-2 me-2">:</span>
                        <input type="text" name="" class="form-control text-center" style="padding :6px" id="TauxRistourne">
                    </div>
                    <div class="col-xl-4">
                        <label for="" class="mt-2 ">Escpt 5 jrs  </label> <span class="mt-2 me-2">:</span>
                        <input type="text" name="" class="form-control text-center" style="padding :6px" id="escompte5Jrs">
                    </div>
                    <div class="col-xl-4">
                        <label for="" class="mt-2 ">Escpt 8 jrs  </label> <span class="mt-2 me-2">:</span>
                        <input type="text" name="" class="form-control text-center" style="padding :6px" id="escompte8Jrs">
                    </div>
                </div>
            </div>

            <div class="col-xl-3 mb-3">
                <div class="row g-2">
                    <div class="col-xl-4">
                        <label for="" class="mt-2 ">Escpt 10 jrs  </label> <span class="mt-2 me-2">:</span>
                        <input type="text" name="" class="form-control text-center" style="padding :6px" id="escompte10Jrs">
                    </div>

                    <div class="col-xl-4">
                        <label for="" class="mt-2 ">Escpt 15 jrs  </label> <span class="mt-2 me-2">:</span>
                        <input type="text"  class="form-control text-center" style="padding :6px" id="escompte15Jrs">
                    </div>

                    <div class="col-xl-4">
                        <label for="" class="mt-2 ">Offre fidélité  </label> <span class="mt-2 me-2">:</span>
                        <input type="text" name="" class="form-control text-center" style="padding :6px" id="OffreFidelite">
                    </div>

                    <input type="hidden" value="0" class="form-control" style="padding :6px" id="IDPALIER_ESCOMPTERISTOURNE_HIDDEN">  
            </div>
        </div>
        <div class="col-xl-1">
           <div class="d-flex justify-content-center mt-4">
              <div id="BlockBtnSearch ">
                <button  id="BtnAjouterEscompteRistourne" class="btn btn-primary " >Ajouter</button>
              </div>
           </div>
        </div>
    </div>
    <div class="table-responsive">
        <table class="tablehover table table-striped text-nowrap w-100" id="EscompteRistournePalierTable">
            <thead class="bg-thead">
                <tr>
                    <th>Actions</th>
                    <th>CA Mini</th>
                    <th>CA Maxi</th>
                    <th>Taux Ristourne</th>
                    <th>Escompte 5 Jrs</th>
                    <th>Escompte 8 Jrs</th>
                    <th>Escompte 10 Jrs</th>
                    <th>Escompte 15 Jrs</th>
                    <th>Offre Fidélité</th>
                </tr>
            </thead>
        </table>
    </div>
    </div>
</div>


@endsection

@section('script')

<script>

$(document).ready(function(){

    InputMaxValue('#escompte15Jrs',3,2)
    InputMaxValue('#escompte10Jrs',3,2)
    InputMaxValue('#escompte8Jrs',3,2)
    InputMaxValue('#escompte5Jrs',3,2)
    InputMaxValue('#OffreFidelite',3,2)
    InputMaxValue('#TauxRistourne',3,2)

    $('#BtnAjouterEscompteRistourne').on('click',function(){

        var CaMini        =  parseFloat($('#CAMini').val().replace(',','.'));
        var CaMaxi        =  parseFloat($('#CAMaxi').val().replace(',','.'));
        var tauxRistourne = parseFloat($('#TauxRistourne').val().replace(',','.'))
        var escompte15Jrs = parseFloat($('#escompte15Jrs').val().replace(',','.'))
        var escompte10Jrs = parseFloat($('#escompte10Jrs').val().replace(',','.'))
        var escompte8Jrs  = parseFloat($('#escompte8Jrs').val().replace(',','.'))
        var escompte5Jrs  = parseFloat($('#escompte5Jrs').val().replace(',','.'))
        var offreFidelite = parseFloat($('#OffreFidelite').val().replace(',','.'))
         
        if(CaMini >= CaMaxi){
            notifWarning('Le CA mini. ne peut être supérieur ou égal au CA maxi !')
            return false;
        }

        if($('#CAMini').val().length == 0){
            notifWarning('Renseigner le CA mini svp!')
            return false;
        }
          if($('#CAMaxi').val().length == 0){
            notifWarning('Renseigner le CA maxi svp!')
            return false;
        }

        if( tauxRistourne < 0  || escompte10Jrs < 0 
         || escompte8Jrs  < 0  || escompte5Jrs  < 0
         || offreFidelite < 0  || offreFidelite < 0  ){
            notifWarning('Aucun taux ne doit être inférieur à zéro !')
            return false;
        }

         if( tauxRistourne == 0  &&  escompte10Jrs == 0 
         &&  escompte8Jrs  == 0  &&  escompte5Jrs  == 0
         &&  offreFidelite == 0  &&  offreFidelite == 0  ){
            notifWarning('Veuillez renseigner au moins un taux pour le palier !')
            return false;
        }
        var postData = {

            'CAMini'       :CaMini,
            'CAMaxi'       :CaMaxi,
            'TauxRistourne':tauxRistourne,
            'escompte5Jrs' :escompte5Jrs,
            'escompte8Jrs' :escompte8Jrs,
            'escompte10Jrs':escompte10Jrs,
            'escompte15Jrs':escompte15Jrs,
            'OffreFidelite':offreFidelite,
            'IDPALIER_ESCOMPTERISTOURNE_HIDDEN':$('#IDPALIER_ESCOMPTERISTOURNE_HIDDEN').val()
        };

        var postDataJson = JSON.stringify(postData);

            MarequetesAjax("{{ route('escompteRistourne.add') }}", "POST",postDataJson , 'application/json', false, "JSON", function(resp) {
                            console.log(resp.error)
                             if(resp.error){
                                    notifError(resp.msg)
                                    return false
                                }
                            if(resp.succes){
                                notifSuccess(resp.msg)
                                recuperationEcompteRistourne()
                                $('#BtnAjouterEscompteRistourne').text('Ajouter')
                                $('#CAMini').val('');
                                $('#CAMaxi').val('');
                                $('#TauxRistourne').val('')
                                $('#escompte15Jrs').val('')
                                $('#escompte10Jrs').val('')
                                $('#escompte8Jrs').val('')
                                $('#escompte5Jrs').val('')
                                $('#OffreFidelite').val('')
                            }
            })
            
    })

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

        var id = $(this).data('id')
        $('#IDPALIER_ESCOMPTERISTOURNE_HIDDEN').val(id)
        $('#BtnAjouterEscompteRistourne').text('Modifier')

        MarequetesAjax("{{ route('escompteRistourne.get') }}", "GET",{IDPALIER_ESCOMPTERISTOURNE_HIDDEN :id }, null, true, "JSON", function(resp) {
            
                    if(resp.error){
                        notifError(resp.msg)
                        return false
                    }
                  
                    $('#CAMini').val(parseInt(resp.data[0].BorneCaMini ?? 0));
                    $('#CAMaxi').val(parseInt(resp.data[0].BorneCaMaxi ?? 0));
                    $('#TauxRistourne').val(parseInt(resp.data[0].TauxRistourne ?? 0))
                    $('#escompte15Jrs').val(parseInt(resp.data[0].TauxEscompte15 ?? 0))
                    $('#escompte10Jrs').val(parseInt(resp.data[0].TauxEscompte10 ?? 0))
                    $('#escompte8Jrs').val(parseInt(resp.data[0].TauxEscompte8 ?? 0))
                    $('#escompte5Jrs').val(parseInt(resp.data[0].TauxEscompte5 ?? 0))
                    $('#OffreFidelite').val(parseInt(resp.data[0].TauxOffreFidelite ?? 0))
                })
    })

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

                 var id = $(this).data('id')
                 confirmMdp('{{ csrf_token() }}', ()=>{

                        MarequetesAjax("{{ route('escompteRistourne.delete') }}", "GET",{IDPALIER_ESCOMPTERISTOURNE_HIDDEN : id}, null, true, "JSON", function(resp) {
                               if(resp.error){
                                    notifError(resp.msg)
                                    return false
                                }
                        if(resp.succes){
                            notifSuccess(resp.msg)
                            recuperationEcompteRistourne()
                        }
                    })
                 })
    })

    divShowPer = $('#EscompteRistournePalierTable_length')
        let BroDivShowPer = divShowPer.parent().parent()
        let search = BroDivShowPer.children().eq(1).removeClass('col-md-6')
        search.addClass('col-md-4 pt-4')
        let child = BroDivShowPer.children().eq(0).removeClass('col-md-6')
        child.addClass('d-flex col-md-8 pt-4')
        child.append(
            `
            <div style="z-index:99;margin-left:20px">
                <select class="form-select w-100" id="select-box" >
                </select>
            </div>

            <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                <i class='ri ri-file-excel-2-line text-success me-1 mt-1' style="font-size : 18px; cursor : pointer;"></i>
                <span id="btn-export-excel-escompte-ristourne" class="fw-bold mt-1" style="cursor : pointer;">Exporter</span>
            </span>
            `
    )

    recuperation_categorie_client($('#decrypted-id').val())
    recuperationEcompteRistourne($('#decrypted-id').val())
   
    $(document).on('change','#select-box',function(){
        var val = $(this).val()
        recuperationEcompteRistourne(val)
    })

    $(document).on('click','#btn-export-excel-escompte-ristourne',function(){
        var data =  remplissage_avec_row_add_DataTable('EscompteRistournePalierTable')
        const filename =file_name("ESCOMPTE_RISTOURNE");
        const tabs_format = {A:'#,##0',B:'#,##0', C:'0%', D:'0%', E:'0%', F:'0%', G:'0%', H:'0%'};
        download_excel_file('/export_global_excel', data, filename,['Actions'],tabs_format)
    })
})

function recuperationEcompteRistourne($id=null){

          MarequetesAjax("{{ route('escompteRistourne.get') }}", "GET",{id_categorie_client:$id}, null, true, "JSON", function(resp) {

                            table = $('#EscompteRistournePalierTable').DataTable();
                            table.clear().draw();
                               if(resp.error){
                                    notifError(resp.msg)
                                    return false
                                }
                           if(resp.succes){

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

                                    table.row.add([
                                        '<a class="btn btn-sm btn-icon btn-outline-warning" data-id="'+value.IDPALIER_ESCOMPTERISTOURNE+'"  data-bs-toggle="tooltip" data-bs-custom-class="tooltip-primary" data-bs-placement="top" title="Modifier" id="ModifierESCOMPTERISTOURNE">\
                                        <i class="bx bxs-edit" style="font-size : 17px;cursor : pointer;"></i>\
                                        </a>\
                                        <a class="btn btn-sm btn-icon btn-outline-danger" data-bs-toggle="tooltip" data-bs-custom-class="tooltip-primary" data-bs-placement="top" title="Supprimer"  data-id="'+value.IDPALIER_ESCOMPTERISTOURNE+'" id="SupprimerESCOMPTERISTOURNE">\
                                                    <i class="bx bxs-trash"style="font-size : 14px;cursor : pointer;"></i>\
                                        </a>',
                                        formatNumber(value.BorneCaMini),
                                        formatNumber(value.BorneCaMaxi),
                                        (value.TauxRistourne ?? 0)+' %',
                                        (value.TauxEscompte5 ?? 0)+' %',
                                        (value.TauxEscompte8 ?? 0)+' %',
                                        (value.TauxEscompte10 ?? 0)+' %',
                                        (value.TauxEscompte15 ?? 0)+' %',
                                        (value.TauxOffreFidelite ?? 0)+' %',
                                        
                                    ]);
                                })

                                table.draw();
                           } 
                        
                    })


}

function recuperation_categorie_client($id){

    $.ajax({
        type: "GET",
        url: "{{route('categorie_client.get')}}",
        dataType: "json",
        success: function (resp) {
            $('#select-box').empty()
            $('#select-box').append(`<option value="">PALIERS STANDARS </option>`)
            $.each(resp.data,function(key,value){
                if($id ==value.IDCATEGORIE_CLIENT ){
                    $('#select-box').append(`
                    <option value="${value.IDCATEGORIE_CLIENT}" selected>${value.LieblleCategorieClient}</option>
               `) 
                }else{
                    $('#select-box').append(`
                            <option value="${value.IDCATEGORIE_CLIENT}">${value.LieblleCategorieClient}</option>
                    `) 
                }
            })
        }
    });
}
</script>

@endsection