@extends('models')
@section('titre-page', 'Prix de revient')
@section('content-body')

        <div class="d-md-flex d-block align-items-center justify-content-between 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 ">
                    <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">Prix de revient</li>
                        </ol>
                    </nav>
                </div>
            </div>
        </div>
    </div>


    <div class="row g-1">
        
        <div class="col-xl-3">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title">ASSURANCE</h5>
                </div>
                <div class="card-body">
                  <table class="tablehover table table-striped table-bordered table_customize w-100" id="tableAssurance">
                        <thead class="table-header-primary">
                            <tr>
                                <th scope="col">Type d'assurance</th>
                                <th scope="col">Coût/kg</th>
                            </tr>
                        </thead>
                      
                    </table>
                </div>
            </div>
        </div>

        <div class="col-xl-3">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title">TRANSPORT AERIEN</h5>
                </div>
                <div class="p-2">
                   
                        <div class="mb-3">
                            <div class="row g-1">
                                <div class="col-xl-5">
                                    <p for="input-label" class=" mb-0 text-muted">Type d'expédition</p>
                                   <select class="form-select" id="type_expedition" name="type_expedition">
                                        
                                    </select>
                                </div>
                                <div class="col-xl-3">
                                    <p for="input-label" class=" mb-0 text-muted">Coût/kg (€)</p>
                                    <input type="text" class="form-control text-center numberInput" id="cout_transport_aerien_euro" name="cout_transport_aerien_euro" >
                                </div>

                                  <div class="col-xl-4">
                                    <p for="input-label" class=" mb-0 text-muted">Coût/kg (F)</p>
                                    <input type="text" class="form-control text-center numberInput" id="cout_transport_aerien_francs" name="cout_transport_aerien_francs">
                                     <input type="hidden" class="form-control" id="id_transport_aerien_masquer" value="0">
                                
                                    
                                </div>
                            </div>

                            <div class="row g-2 mt-1">
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-primary-light w-100" id="ajout-transport-aerien" style="padding: 1px">Ajouter</button>
                                </div>
                                <div class="col-xl-6">
                                     <button type="button" class="btn btn-danger-light w-100" id="annulation-transport-aerien" style="padding: 1px">Annuler</button>
                                </div>
                               
                            </div>

                        </div>
       

                    <table class="tablehover table table-striped table-bordered mt-3 table_customize w-100" id="tableAerien">
                        <thead class="table-header-primary" >
                            <tr>
                                <th style="padding: 1px;display:none">id_masque</th>
                                <th style="padding: 1px">Type expédition</th>
                                <th scope="col">Coût/kg</th>
                                 <th scope="col">Coût/kg</th>
                            </tr>
                        </thead>
                     
                    </table>
                </div>
            </div>
        </div>

        <div class="col-xl-3">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title">TRANSPORT MARITIME</h5>
                </div>
                <div class="p-2">
                   
                        <div class="mb-3">
                            <div class="row g-1">
                                <div class="col-xl-3">
                                    <p for="input-label" class=" mb-0 text-muted">Type Tc</p>
                                     <input type="text" class="form-control text-center" id="type_tc_transport_maritime" >
                                </div>
                                <div class="col-xl-3">
                                    <p for="input-label" class=" mb-0 text-muted">Volume Tc</p>
                                    <input type="text" class="form-control text-center numberInput" id="volume_tc_transport_maritime">
                                </div>

                                <div class="col-xl-3">
                                    <p for="input-label" class=" mb-0 text-muted">Coût Tc (€)</p>
                                    <input type="text" class="form-control text-center numberInput" id="cout_tc_transport_maritime_euro">
                                </div>

                                <div class="col-xl-3">
                                    <p for="input-label" class=" mb-0 text-muted">Coût Tc (F)</p>
                                    <input type="text" class="form-control text-center numberInput" id="cout_tc_transport_maritime_francs">
                                    <input type="hidden" class="form-control text-center" id="id_transport_maritime_masquer" value="0">
                                </div>
                            </div>

                            <div class="row g-2 mt-1">
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-primary-light w-100" id="ajout-transport-maritime" style="padding: 1px">Ajouter</button>
                                </div>
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-danger-light w-100" id="Annulation-transport-maritime" style="padding: 1px">Annuler</button>
                                </div>
                               
                            </div>
                        </div>
               
                     <table class="tablehover table table-striped table-bordered mt-3 table_customize w-100" id="tableMaritime">
                        <thead class="table-header-primary">
                            <tr>
                                <th style="padding: 6.79px;display:none">id_masque</th>
                                <th style="padding: 6.79px">Type Tc</th>
                                <th style="padding: 6.79px">Volume (m7)</th>
                                 <th style="padding: 6.79px">Coût tc (€)</th>
                                 <th style="padding: 6.79px">Coût tc (CFA)</th>
                            </tr>
                        </thead>
                      
                    </table>
                </div>
            </div>
        </div>

        <div class="col-xl-3">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title">PARAMETRES DOUANE</h5>
                </div>
                <div class="p-2">
                    <form id="formPrixRevient" class="form-horizontal">
                        <div class="mb-3">
                            <div class="row g-1">

                                <div class="col-xl-6">
                                    <p for="input-label" class=" mb-0 text-muted">Référence</p>
                                    <input type="text" class="form-control text-center" id="ref_douane">
                                </div>

                                  <div class="col-xl-6">
                                    <p for="input-label" class=" mb-0 text-muted">Taux douane</p>
                                    <input type="text" class="form-control text-center numberInput" id="taux_douane">
                                    <input type="hidden" class="form-control text-center"  value="0" id="id_douane_masquer" />  
                                </div>
                            </div>

                            <div class="row g-2 mt-1">
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-primary-light w-100" id="ajout-douane" style="padding: 1px">Ajouter</button>
                                </div>
                                <div class="col-xl-6">
                                     <button type="button" class="btn btn-danger-light w-100" id="annulation-douane" style="padding: 1px">Annuler</button>
                                </div>
                              
                            </div>
                        </div>
                    </form>

                     <table class="tablehover table table-striped table-bordered mt-3 table_customize w-100" id="tableDouane">
                        <thead class="table-header-primary">
                            <tr>
                                <th style="display:none">id_masque</th>
                                <th>Référence</th>
                                <th scope="col">Taux douane</th>
                              
                            </tr>
                        </thead>
              
                    </table>
                </div>
            </div>
        </div>
    </div>

    {{-- :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: DEUXIEME BLOC :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: --}}

        <div class="row g-1">
        
        <div class="col-xl-3">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title">CODES DROITS DE DOUANE</h5>
                </div>
                <div class="p-2">

                        <div class="mb-3">
                            <div class="row g-1">
                                <div class="col-xl-6">
                                    <p for="input-label" class=" mb-0 text-muted">Code douane</p>
                                     <input type="text" class="form-control text-center" id="code_couane" >
                                </div>
                              
                                <div class="col-xl-6">
                                    <p for="input-label" class=" mb-0 text-muted">Taux (%)</p>
                                    <input type="text" class="form-control text-center numberInput" id="taux_droit_douane">
                                    <input type="hidden" class="form-control text-center"  value="0" id="id_droit_douane_masquer" />
                                </div>

                            </div>

                            <div class="row g-2 mt-1">
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-primary-light w-100" id="ajout-code-douane" style="padding: 1px">Ajouter</button>
                                </div>
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-danger-light w-100" id="Annulation-code-douane" style="padding: 1px">Annuler</button>
                                </div>
                               
                            </div>
                        </div>
               
                  <table class="tablehover table table-striped table-bordered table_customize w-100" id="tableCodeDroitDouane">
                        <thead class="table-header-primary">
                            <tr>
                                <th style="display: none">id_masque</th>
                                <th scope="col">Code douane</th>
                                <th scope="col">Taux douane</th>
                            </tr>
                        </thead>
                      
                    </table>
                </div>
            </div>
        </div>

        <div class="col-xl-3">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title">TRANSIT LOCAL MARITIME</h5>
                </div>
                <div class="p-2">
                   
                        <div class="mb-3">
                            <div class="row g-1">
                                <div class="col-xl-8">
                                    <p for="input-label" class=" mb-0 text-muted">Catégorie produit</p>
                                   <select class="form-select" id="categorie_produit" >
                                       
                                    </select>
                                </div>
                                <div class="col-xl-4">
                                    <p for="input-label" class=" mb-0 text-muted text-center">Taux (%)</p>
                                    <input type="text" class="form-control text-center numberInput" id="taux_transit_maritime" >
                                    <input type="hidden" class="form-control text-center" id="id_transit_maritime" value="0">
                                </div>

                            </div>

                            <div class="row g-2 mt-1">
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-primary-light w-100" id="ajout-transit-maritime" style="padding: 1px">Ajouter</button>
                                </div>
                                <div class="col-xl-6">
                                     <button type="button" class="btn btn-danger-light w-100" id="annulation-transit-maritime" style="padding: 1px">Annuler</button>
                                </div>
                               
                            </div>

                        </div>
       

                    <table class="tablehover table table-striped table-bordered mt-3 table_customize w-100" id="tableTransitMaritime">
                        <thead class="table-header-primary" >
                            <tr>
                                <th style="padding: 1px;display:none">id_masque</th>
                                <th style="padding: 1px">Catégorie de produit</th>
                                <th scope="col">Taux (%)</th>
                            </tr>
                        </thead>
                     
                    </table>
                </div>
            </div>
        </div>

        <div class="col-xl-3">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title">TRANSIT LOCAL AERIEN</h5>
                </div>
                <div class="p-2">
                   
                        <div class="mb-3">
                            <div class="row g-1">
                                <div class="col-xl-4">
                                    <p for="input-label" class=" mb-0 text-muted">Rubriq cotation</p>
                                     <input type="text" class="form-control text-center" id="cotation_transit_aerien" >
                                </div>
                                <div class="col-xl-4">
                                    <p for="input-label" class=" mb-0 text-muted">Type valeur</p>
                                    <select class="form-select" id="type_valeur_transit_aerien">
                                        <option value="1">FIXE</option>
                                        <option value="2">PAR KILO</option>
                                        <option value="3">TAUX</option>
                                    </select>
                                    <input type="hidden" class="form-control text-center" id="id_transit_aerien" value="0">
                                </div>

                                <div class="col-xl-4">
                                    <p for="input-label" class=" mb-0 text-muted">Valeur</p>
                                    <input type="text" class="form-control text-center numberInput" id="valeur_transit_aerien">
                                </div>

                            </div>

                            <div class="row g-2 mt-1">
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-primary-light w-100" id="ajout-transit-aerien" style="padding: 1px">Ajouter</button>
                                </div>
                                <div class="col-xl-6">
                                    <button type="button" class="btn btn-danger-light w-100" id="Annulation-transit-aerien" style="padding: 1px">Annuler</button>
                                </div>
                               
                            </div>
                        </div>
               
                     <table class="tablehover table table-striped table-bordered mt-3 table_customize w-100" id="tableTransitAerien">
                        <thead class="table-header-primary">
                            <tr>
                                <th style="display:none">id_masque</th>
                                <th>Rubrique</th>
                                <th>Type de valeur</th>
                                 <th>Valeur</th>
                            </tr>
                        </thead>
                      
                    </table>
                </div>
            </div>
        </div>

        <div class="col-xl-3">
            <div class="card" style="height:366px" > 
                <div class="card-header">
                    <h5 class="card-title">AUTRES VARIABLES</h5>
                </div>
                <div class="p-2">
                    <div>
                          <p for="input-label" class=" mb-0 text-muted">Coéficient FOB (%)</p>
                          <input type="text" class="form-control text-end input-autre-variable numberInput percent" id="coef_fob_autre_variable">
                    </div>

                    <div>
                          <p for="input-label" class=" mb-0 text-muted">Montant TS</p>
                          <input type="text" class="form-control text-end input-autre-variable numberInput" id="montant_ts_autre_variable">
                    </div>

                    <div>
                          <p for="input-label" class=" mb-0 text-muted">FD (%)</p>
                          <input type="text" class="form-control text-end input-autre-variable numberInput percent" id="fd_autre_variable">
                    </div>

                    <div>
                          <p for="input-label" class=" mb-0 text-muted">CSD (%)</p>
                          <input type="text" class="form-control text-end input-autre-variable numberInput percent" id="cs_autre_variable">
                    </div>

                </div>
            </div>
        </div>
    </div>
    <!-- End::app-content -->
@endsection

@section('script')

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

        $('#tableAssurance').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": false,
            "autoWidth": true,
            "responsive": false,
            scrollY: "239px",
            language: {
                emptyTable: "Aucune donnée disponible",
                zeroRecords: "Aucun résultat trouvé"
            },
             columnDefs: [
                { targets: 1, className: 'text-center' }
             ],
        });

        $('#tableAerien').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": false,
            "autoWidth": true,
            "responsive": false,
             scrollY: "150px",
              language: {
                emptyTable: "Aucune donnée disponible",
                zeroRecords: "Aucun résultat trouvé"
            },
            columnDefs: [
                    { targets: 0, visible: false },
                     { targets: 2, className: 'text-center' },
                     { targets: 3, className: 'text-end' }
             ],
        });

        $('#tableMaritime').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": false,
            "autoWidth": true,
            "responsive": false,
             scrollY: "150px",
              language: {
                emptyTable: "Aucune donnée disponible",
                zeroRecords: "Aucun résultat trouvé"
            },
             columnDefs: [
                    { targets: 0, visible: false },
                    { targets: [1,2], className: 'text-center' },
                    { targets: [3,4], className: 'text-end' }
             ],
        });

        $('#tableDouane').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": false,
            "autoWidth": true,
            "responsive": false,
             scrollY: "150px",
              language: {
                emptyTable: "Aucune donnée disponible",
                zeroRecords: "Aucun résultat trouvé"
            },
             columnDefs: [
                    { targets: 0, visible: false },
                     { targets: [2], className: 'text-center' }
             ],
             order:[]
        });

        //::::::::::::::::: INITIALISATION DES TABLEAUX DEUXIEME BLOC
        $('#tableCodeDroitDouane').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": false,
            "autoWidth": true,
            "responsive": false,
             scrollY: "150px",
              language: {
                emptyTable: "Aucune donnée disponible",
                zeroRecords: "Aucun résultat trouvé"
            },
             columnDefs: [
                    { targets: 0, visible: false },
                    { targets:[1,2], className: 'text-center' }
             ],
             order:[]
        });

        $('#tableTransitMaritime').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": false,
            "autoWidth": true,
            "responsive": false,
             scrollY: "150px",
              language: {
                emptyTable: "Aucune donnée disponible",
                zeroRecords: "Aucun résultat trouvé"
            },
             columnDefs: [
                    { targets: 0, visible: false },
                     { targets: [2], className: 'text-center' }
             ],
        });

        $('#tableTransitAerien').DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": false,
            "autoWidth": true,
            "responsive": false,
             scrollY: "150px",
              language: {
                emptyTable: "Aucune donnée disponible",
                zeroRecords: "Aucun résultat trouvé"
            },
             columnDefs: [
                    { targets: 0, visible: false },
                     { targets: [2], className: 'text-center' },
                     { targets: [3], className: 'text-end' }
             ],
        });
        //::::::::::::::::: FIN INITIALISATION DES TABLEAUX DEUXIEME BLOC

        recuperation_donnees("{{route('assurance.get')}}", '#tableAssurance',['IDMODEEXPEDITION'],null,'tableAssurance');
        recuperation_donnees("{{route('transport_aerien.get')}}", '#tableAerien', ['IDTYPEEXPEDITION'], null,'tableAerien');
        recuperation_donnees("{{route('transport_maritime.get')}}", '#tableMaritime',[],null,'tableMaritime');
        recuperation_donnees("{{route('douane.get')}}", '#tableDouane',[],null,'tableDouane');
        recuperation_donnees("{{route('code_droit_douane.get')}}", '#tableCodeDroitDouane',[],null,'tableCodeDroitDouane');
        recuperation_donnees("{{route('transit_local_maritime.get')}}", '#tableTransitMaritime',[],null,'tableTransitMaritime');
        recuperation_donnees("{{route('transit_local_aerien.get')}}", '#tableTransitAerien',[],null,'tableTransitAerien');
        recuperation_autres_variables()
        remplirSelect2("{{ route('type_expedition.get') }}",null, "#type_expedition", "IDTYPEEXPEDITION","LibelleTypeExpedition", null, "");
        remplirSelect2("{{ route('categorie_produit.get') }}",null, "#categorie_produit", "IDFAMILLEPRODUIT","LibelleFamilleProduit", null, "");
    

        //::::::::::::::::: ASSURANCE
        $(document).on('change','#champ_valeur_assurance',function(){
            var valeur = $(this).val()
            var assurance_id = $(this).data('id')
            
            formdata = {
                taux: valeur,
                id_assurance : assurance_id,
                _token: '{{ csrf_token() }}'
            }
            Insertion_Or_Update(formdata,'{{route("assurance.update")}}',null,null)
        })
        //::::::::::::::::: TRANSPORT AERIEN
        $('#ajout-transport-aerien').on('click', function(event) {
            event.preventDefault();
            if ($('#type_expedition').val() === '' || $('#cout_transport_aerien_euro').val() === '' || $('#cout_transport_aerien_francs').val() === '') {
                notif('danger','Erreur','Veuillez remplir tous les champs.');
                return;
            }
            const formData = {
                type_expedition: $('#type_expedition').val(),
                cout_transport_aerien_euro: $('#cout_transport_aerien_euro').val(),
                cout_transport_aerien_francs: $('#cout_transport_aerien_francs').val(),
                id_transport_aerien_masquer: $('#id_transport_aerien_masquer').val(),
                _token: '{{ csrf_token() }}'
            };
            Insertion_Or_Update(formData, "{{route('transport_aerien.add')}}", "{{route('transport_aerien.get')}}", '#tableAerien', ['IDTYPEEXPEDITION']);

        });
        $('#annulation-transport-aerien').on('click', function(event) {
            event.preventDefault();
            $('#type_expedition').val('').trigger('change');
            $('#cout_transport_aerien_euro').val('');
            $('#cout_transport_aerien_francs').val('');
            $('#id_transport_aerien_masquer').val(0);
            $('#ajout-transport-aerien').text('Ajouter');
        });

        $('#tableAerien tbody').on('dblclick', 'tr', function () {
            const table = $('#tableAerien').DataTable();
            const rowData = table.row(this).data();
             $(this).toggleClass('selected');
            if (rowData) {
                const id = rowData[0];
                $('#id_transport_aerien_masquer').val(id);
                $('#ajout-transport-aerien').text('Modifier');
                
               recuperation_donnees("{{route('transport_aerien.get')}}", '#tableAerien',null, id);
            }
        });
        //::::::::::::::::: TRANSPORT MARITIME
        $('#cout_tc_transport_maritime_euro').on('keyup',function(){
            var val_euro = $(this).val()
            $.ajax({
                type: "GET",
                url: "{{route('valeur_euro.get')}}",
                dataType: "JSON",
                success: function (resp) {
                 
                    var val_cfa = val_euro * resp.data[0].ValeurEuro
                    $('#cout_tc_transport_maritime_francs').val(val_cfa.toFixed(0)) 
                }
            });
        })
        $('#ajout-transport-maritime').on('click', function(event) {
            event.preventDefault();
            if ($('#type_tc_transport_maritime').val() === '' || $('#volume_tc_transport_maritime').val() === '' || $('#cout_tc_transport_maritime_euro').val() === ''|| $('#cout_tc_transport_maritime_francs').val() === '') {
                notif('danger','Erreur','Veuillez remplir tous les champs.');
                return;
            }
            const formData = {
                type_tc_transport_maritime: $('#type_tc_transport_maritime').val(),
                volume_tc_transport_maritime: $('#volume_tc_transport_maritime').val().trim().replace(',', '.'),
                cout_tc_transport_maritime_euro: $('#cout_tc_transport_maritime_euro').val().trim().replace(',', '.'),
                cout_tc_transport_maritime_francs: $('#cout_tc_transport_maritime_francs').val().trim().replace(',', '.'),
                id_transport_maritime_masquer: $('#id_transport_maritime_masquer').val(),
                _token: '{{ csrf_token() }}'
            };
            Insertion_Or_Update(formData, "{{route('transport_maritime.add')}}", "{{route('transport_maritime.get')}}", '#tableMaritime');
        });

        $('#tableMaritime tbody').on('dblclick', 'tr', function () {
            const table = $('#tableMaritime').DataTable();
            const rowData = table.row(this).data();
             $(this).toggleClass('selected');
            if (rowData) {
                const id = rowData[0];
                $('#id_transport_maritime_masquer').val(id);
                $('#ajout-transport-maritime').text('Modifier');
                recuperation_donnees("{{route('transport_maritime.get')}}", '#tableMaritime',null,id);
            }
        });

        $('#Annulation-transport-maritime').on('click', function(event) {
            event.preventDefault();
            $('#type_tc_transport_maritime').val('');
            $('#volume_tc_transport_maritime').val('');
            $('#cout_tc_transport_maritime_euro').val('');
            $('#cout_tc_transport_maritime_francs').val('');
            $('#id_transport_maritime_masquer').val(0);
            $('#ajout-transport-maritime').text('Ajouter');
        });

         //::::::::::::::::: DOUANE
        $('#ajout-douane').on('click', function(event) {
            event.preventDefault();
            if ($('#ref_douane').val() === '' || $('#taux_douane').val() === '') {
                notif('danger','Erreur','Veuillez remplir tous les champs.');
                return;
            }
            const formData = {
                ref_douane: $('#ref_douane').val(),
                taux_douane: $('#taux_douane').val().trim().replace(',', '.'),
                id_douane_masquer: $('#id_douane_masquer').val(),
                _token: '{{ csrf_token() }}'
            };
            Insertion_Or_Update(formData, "{{route('douane.add')}}", "{{route('douane.get')}}", '#tableDouane');
        });

        $('#tableDouane tbody').on('dblclick', 'tr', function () {
            const table = $('#tableDouane').DataTable();
            const rowData = table.row(this).data();
             $(this).toggleClass('selected');
            if (rowData) {
                const id = rowData[0];
                $('#id_douane_masquer').val(id);
                $('#ajout-douane').text('Modifier');
                recuperation_donnees("{{route('douane.get')}}", '#tableDouane',null,id);
            }
        });

        $('#annulation-douane').on('click', function(event) {
            $('#ref_douane').val('');
            $('#taux_douane').val('');
            $('#id_douane_masquer').val(0);
            $('#ajout-douane').text('Ajouter');
        });



    // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::://
                        // ::::::::::::::::::::::::::::::::::::DEUXIEME LIGNES:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::://
    // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::://  

        //::::::::::::::::: CODE DROIT DE DOUANE
        $('#ajout-code-douane').on('click', function(event) {
            event.preventDefault();
            if ($('#code_couane').val() === '' || $('#taux_droit_douane').val() === '') {
                notif('danger','Erreur','Veuillez remplir tous les champs.');
                return;
            }
            const formData = {
                code_droit_douane: $('#code_couane').val().trim().replace(',', '.'),
                taux_droit_code_douane: $('#taux_droit_douane').val().trim().replace(',', '.'),
                id_code_droit_douane_masquer: $('#id_droit_douane_masquer').val(),
                _token: '{{ csrf_token() }}'
            };
            Insertion_Or_Update(formData, "{{route('code_droit_douane.add')}}", "{{route('code_droit_douane.get')}}", '#tableCodeDroitDouane');
        });
 
        $('#Annulation-code-douane').on('click', function(event) {
            event.preventDefault();
            $('#code_couane').val('');
            $('#taux_droit_douane').val('');
            $('#id_droit_douane_masquer').val(0);
            $('#ajout-code-douane').text('Ajouter');
        });

        $('#tableCodeDroitDouane tbody').on('dblclick', 'tr', function () {
            const table = $('#tableCodeDroitDouane').DataTable();
            const rowData = table.row(this).data();
             $(this).toggleClass('selected');
            if (rowData) {
                const id = rowData[0];
                $('#id_droit_douane_masquer').val(id);
                $('#ajout-code-douane').text('Modifier');
                
               recuperation_donnees("{{route('code_droit_douane.get')}}", '#tableCodeDroitDouane',null, id);
            }
        });


         //::::::::::::::::: TRANSIT LOCAL MARITIME
        $('#ajout-transit-maritime').on('click', function(event) {
            event.preventDefault();
            if ($('#categorie_produit').val() === '' || $('#taux_transit_maritime').val() === '') {
                notif('danger','Erreur','Veuillez remplir tous les champs.');
                return;
            }
            const formData = {
                id_famille_produit_transite_local_maritime: $('#categorie_produit').val(),
                taux_transit_maritime: $('#taux_transit_maritime').val().trim().replace(',', '.'),
                id_transit_maritime: $('#id_transit_maritime').val(),
                _token: '{{ csrf_token() }}'
            };
            Insertion_Or_Update(formData, "{{route('transit_local_maritime.add')}}", "{{route('transit_local_maritime.get')}}", '#tableTransitMaritime');
        });
 
        $('#annulation-transit-maritime').on('click', function(event) {
            event.preventDefault();
            $('#categorie_produit').val('').trigger('change');
            $('#taux_transit_maritime').val('');
            $('#id_transit_maritime').val(0);
            $('#ajout-transit-maritime').text('Ajouter');
        });

        $('#tableTransitMaritime tbody').on('dblclick', 'tr', function () {
            const table = $('#tableTransitMaritime').DataTable();
            const rowData = table.row(this).data();
             $(this).toggleClass('selected');
            if (rowData) {
                const id = rowData[0];
                $('#id_transit_maritime').val(id);
                $('#ajout-transit-maritime').text('Modifier');
               recuperation_donnees("{{route('transit_local_maritime.get')}}", '#tableTransitMaritime',null, id);
            }
        });

        //::::::::::::::::: TRANSIT LOCAL AERIEN
        $('#ajout-transit-aerien').on('click', function(event) {
            event.preventDefault();
            if ($('#cotation_transit_aerien').val() === '' || $('#type_valeur_transit_aerien').val() === '' || $('#valeur_transit_aerien').val() === '') {
                notif('danger','Erreur','Veuillez remplir tous les champs.');
                return;
            }
            const formData = {
                cotation_transit_aerien: $('#cotation_transit_aerien').val().trim().replace(',', '.'),
                type_valeur_transit_aerien: $('#type_valeur_transit_aerien').val().trim().replace(',', '.'),
                valeur_transit_aerien: $('#valeur_transit_aerien').val().trim().replace(',', '.'),
                id_transit_aerien: $('#id_transit_aerien').val().trim().replace(',', '.'),
                _token: '{{ csrf_token() }}'
            };
            Insertion_Or_Update(formData, "{{route('transit_local_aerien.add')}}", "{{route('transit_local_aerien.get')}}", '#tableTransitAerien');
        });

        $('#Annulation-transit-aerien').on('click', function(event) {
            event.preventDefault();
            $('#cotation_transit_aerien').val('');
            $('#type_valeur_transit_aerien').val('1').trigger('change');
            $('#valeur_transit_aerien').val('');
            $('#id_transit_aerien').val(0);
            $('#ajout-transit-aerien').text('Ajouter');
        });

        $('#tableTransitAerien tbody').on('dblclick', 'tr', function () {
            const table = $('#tableTransitAerien').DataTable();
            const rowData = table.row(this).data();
             $(this).toggleClass('selected');
            if (rowData) {
                const id = rowData[0];
                $('#id_transit_aerien').val(id);
                $('#ajout-transit-aerien').text('Modifier');
                
               recuperation_donnees("{{route('transit_local_aerien.get')}}", '#tableTransitAerien',null, id);
            }
        });

        //::::::::::::::::: AUTRES VARIABLES

        $('.percent').on('blur', function () {
            let val = $(this).val().trim().replace(',', '.');
            if (!isNaN(val) && val !== '') {
                val = parseFloat(val).toFixed(2).replace('.', ',');
                $(this).val(val);
            }
        });

        $('.input-autre-variable').on('change', function() {
            const formData = {
                coef_fob_autre_variable: $('#coef_fob_autre_variable').val(),
                montant_ts_autre_variable: $('#montant_ts_autre_variable').val(),
                fd_autre_variable: $('#fd_autre_variable').val(),
                cs_autre_variable: $('#cs_autre_variable').val(),
                _token: '{{ csrf_token() }}'
            };
            $.ajax({
                url: "{{ route('autres_variables.update') }}",
                type: 'POST',
                data: formData,
                success: function(resp) {
                    if(resp.error){
                        notif('danger','Erreur',resp.msg);
                        return false;
                    }
                    notif('success','Succès','Les autres variables ont été mises à jour avec succès.');
                },
                error: function(xhr, status, error) {
                    notif('danger','Erreur','Erreur lors de la mise à jour des autres variables : ' + error);
                }
            });
        });
                   
       
    });

    function addRowToTable(tableId, rowData, columnsToExclude = []) {
        var table = $(tableId).DataTable();
        table.clear();

        $.each(rowData, function(index, value) {
            if (Array.isArray(value)) {
                table.row.add(value);
            } else if (typeof value === 'object') {
                // Filtrer les colonnes à exclure
                const filtered = Object.entries(value)
                    .filter(([key]) => !columnsToExclude.includes(key))
                    .map(([_, val]) => val);

                table.row.add(filtered);
            }
        });

        table.draw();
    }

    function Insertion_Or_Update($formData, $url, $url_recuperation,$table ,$columnsToExclude = []) {

        $.ajax({
            url:  $url,
            type: 'POST',
            data: $formData,
            success: function(resp) {
                if(resp.error){
                    notif('danger','Erreur',resp.msg);
                    return false;
                }
                recuperation_donnees($url_recuperation ,$table,$columnsToExclude, null);
            },
            error: function(xhr, status, error) {
                notif('danger','Erreur','Erreur lors de l\'enregistrement des données : ' + error);
            }
        });
    }
    function recuperation_donnees($url, $tableId, $columnsToExclude = [],$id = null,$table = null) {
       
        $.ajax({
            url: $url,
            type: 'GET',
            data:{
                id:$id
            },
            beforeSend: function() {
                 afficherMessageTemporaire($table);
            },
            success: function(data) {
                if($tableId =='#tableAerien'&& $id !== null){
                  $('#type_expedition').val(data[0].IDTYPEEXPEDITION).trigger('change');
                  $('#cout_transport_aerien_euro').val(data[0].CoutDevise);
                  $('#cout_transport_aerien_francs').val(data[0].CoutFrancs);
                  return false
                } 

                if($tableId =='#tableMaritime'&& $id !== null){
                  $('#type_tc_transport_maritime').val(data[0].TypeConteneur);
                  $('#volume_tc_transport_maritime').val(data[0].VolumeConteneur);
                  $('#cout_tc_transport_maritime_euro').val(data[0].CoutDevise);
                  $('#cout_tc_transport_maritime_francs').val(data[0].CoutFrancs);
                  return false
                } 
                if($tableId =='#tableDouane'&& $id !== null){
                  $('#ref_douane').val(data[0].ReferenceDedouanement);
                  $('#taux_douane').val(data[0].TauxDedouanement);
                  return false
                } 

                if($tableId =='#tableCodeDroitDouane'&& $id !== null){
                  $('#code_couane').val(data[0].CodeDroitDouane);
                  $('#taux_droit_douane').val(data[0].TauxDroitDouane);
                  return false
                }

                if($tableId =='#tableTransitMaritime'&& $id !== null){
                  $('#categorie_produit').val(data[0].IDFAMILLEPRODUIT).trigger('change');
                  $('#taux_transit_maritime').val(data[0].TauxTransitMaritime);
                  return false
                }
                if($tableId =='#tableTransitAerien'&& $id !== null){
                  $('#cotation_transit_aerien').val(data[0].RubriqueTransitAerien);
                  if(data[0].TypeValeurTLA == "FIXE"){
                     $('#type_valeur_transit_aerien').val(1).trigger('change');
                  }
                 if(data[0].TypeValeurTLA == "PAR KILO"){
                    $('#type_valeur_transit_aerien').val(2).trigger('change');
                 }
                 if(data[0].TypeValeurTLA == "TAUX"){
                    $('#type_valeur_transit_aerien').val(3).trigger('change');
                }
                  $('#valeur_transit_aerien').val(data[0].ValeurTransitAerien);
                  return false
                }

              addRowToTable($tableId, data,$columnsToExclude);
            },
            error: function(xhr, status, error) {
                console.error('Error fetching data:', error);
            }
        });
    }

    function initializeDataTable(tableId) {
        $(tableId).DataTable({
            "paging": false,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": false,
            "autoWidth": true,
            "responsive": false
        });
    }

    function recuperation_autres_variables() {
        
        $.ajax({
            type: "GET",
            url: "{{ route('autres_variables.get') }}",
            dataType: "JSON",
            success: function (response) {
                if (response.error) {
                    notif('danger', 'Erreur', response.msg);
                    return false;
                }
                
                $('#coef_fob_autre_variable').val(response[0].CoefficientFOB);
                $('#montant_ts_autre_variable').val(response[0].TSDouane);
                $('#fd_autre_variable').val(response[0].FormaliteDedouanementFD.replace('.', ','));
                $('#cs_autre_variable').val(response[0].CommisssionSurDeboursCSD);
                
            }
        });
    }
</script>
@endsection