@php   use App\Models\profil; @endphp

@extends('base')

@section('content')
    
    <div class="alert alert-success text-center">LISTE DES FORMULES</div>
    <div class="row col-md-12">
        <div class="form-group col-md-2" >
            <label for="centrale_export_excel" ><b>Centrale</b></label>
            <select  id="centrale_export_excel" class="form-control" style="width: 100%;">
                <option value="0">Aucune</option>
                            </select>
        </div>
        <div class="form-group col-md-1 " >
            <button class="btn btn-success" style="margin-top:25%;margin-left:0%" id="export_excel">Export excel</button>

        </div>
        <div class="form-group col-md-2 offset-md-6" >
            <label for="definir_production" ><b>Définir en production</b></label>
            <select  id="definir_production" class="form-control" style="width: 100%;">
                <option value="3">Toutes</option>
                <option value="0">Non défini en production</option>
                <option value="1">Défini en production</option>
            </select>
        </div>
        <div class="form-group col-md-1 " >
                    </div>
        <div class="form-group col-md-2" id="block_recherche_formule_normee" style="display: none;">
            <label for="recherche_formule_normee" ><b>Formule normée</b></label>
            <select  id="recherche_formule_normee" class="form-control" style="width: 100%;">
                <option value="3">Toutes</option>
                <option value="0">Formule non normée</option>
                <option value="1">Formule normée</option>
            </select>

        </div>
        <div class="form-group col-md-1 " id="btn_export_excel_cout" style="display: none;">
            <button class="btn btn-success" style="margin-top:25%;margin-left:0%" id="export_excel_avec_cout">excel avec cout</button>

        </div>

    </div>
    <button class="btn btn-success refrech" style="display:none" id="rafraichir">refrech</button>
    <div id="filtre"><button type="button" class="fermer btn btn-danger" >X</button></div><div id="affiche_formule"></div>
    <div class="col-md-12 text-center">Nombre de formule(s) : <span class="badge" style="background : #dff0d8; color: #000; font-size: 15px; margin-bottom:0.5%;"> </span></div>
    <div class="table-responsive">
        <table class="table table-striped table-hover table-bordered" id="table_formule">
            <thead style="background-color:#28a745; color:white">
            <tr>
                <th scope="col" class="text-center formule_code">CODE</th>
                <th scope="col" class="text-center formule_fac">CODE FAC</th>
                <th scope="col" class="text-center formule_recherche">RECHERCHE</th>
                <th scope="col" class="text-center formule_app">APPELLATION COMMERCIALE</th>
                <th scope="col" class="text-center formule_app">CARACTERISTIQUE</th>
                <th scope="col" class="text-center">DES BETON</th>
                <th scope="col" class="text-center">TYPE BETON</th>
                <th scope="col" class="text-center">CL RESISTANCE</th>
                <th scope="col" class="text-center">CL ENVIRON</th>
                <th scope="col" class="text-center">CL CHLORURE</th>
                <th scope="col" class="text-center">SPECIFICITE</th>
                <th scope="col" class="text-center">NATURE ADD</th>
                <th scope="col" class="text-center">FAMILLE</th>
                <th scope="col" class="text-center">Cl CONSISTANCE</th>
                <th scope="col" class="text-center">TVA</th>
                <th scope="col" class="text-center">GROUPE TARIF</th>
                <th scope="col" class="text-center">DEF PROD</th>
                <th scope="col" class="text-center" aria-label="Rendering engine: activate to sort column ascending">SUPPRIMER</th>
            </tr>
            <tr style='background-color: whitesmoke'>
                <th scope="col" class="filterhead text-center formule_code">CODE</th>
                <th scope="col" class="filterhead text-center formule_fac">CODE FAC</th>
                <th scope="col" class="filterhead text-center formule_recherche">RECHERCHE</th>
                <th scope="col" class="filterhead text-center formule_app">APPELLATION COMMERCIALE</th>
                <th scope="col" class="filterhead text-center formule_app">CARACTERSTIQUE</th>
                <th scope="col" class="filterhead text-center">DES BETON</th>
                <th scope="col" class="filterhead text-center">TYPE BETON</th>
                <th scope="col" class="filterhead text-center">CL RESISTANCE</th>
                <th scope="col" class="filterhead text-center">CL ENVIRON</th>
                <th scope="col" class="filterhead text-center">CL CHLORURE</th>
                <th scope="col" class="filterhead text-center">SPECIFICITE</th>
                <th scope="col" class="filterhead text-center">NATURE ADD</th>
                <th scope="col" class="filterhead text-center">FAMILLE</th>
                <th scope="col" class="filterhead text-center">Cl CONSISTQNCE</th>
                <th scope="col" class="filterhead text-center">TVA</th>
                <th scope="col" class="filterhead text-center">GROUPE TARIF</th>
                <th scope="col" class="filterhead text-center">DEF PROD</th>
                <th scope="col" class="filterhead text-center" aria-label="Rendering engine: activate to sort column ascending">SUPPRIMER</th>
            </tr>
            </thead>
            <tbody class="tbody_formule">




            </tbody>

        </table>
    </div>



    <script>

        $(function() { // Dom ready

            $('title').text("FORMULE - SMART CENTRAL");

            $("#filtre").click(function(e) {
                e.preventDefault();
                $("#affiche_formule").hide();
                $("#filtre").hide();

            });
            $(".fermer").click(function(e) {
                e.preventDefault();
                $("#filtre").click();
            });
            $(".ajouter_formule").click(function(e) {
                e.preventDefault();
                $("#filtre").show();
                $("#affiche_formule").empty();
                $("#affiche_formule").show();

                function reponse(retour) {

                    $("#affiche_formule").html(retour);

                }

                $.get('{{url('formule/creer')}}' ,reponse, 'html');



            });
            var table = $('#table_formule').on('processing.dt', function (e, settings, processing) {

                $('.ring').css('display', processing ? 'block' : 'none');
                $('#filtre_loading').css('display', processing ? 'block' : 'none');
            }).DataTable({
                scrollX: true,
                orderCellsTop: true,
                // fixedHeader: true,
                scrollCollapse: true,
                autoWidth: true,
                paging: true,
                ordering: true,
                iDisplayLength: {{$parametres->parametre_nombre_ligne_grille}},
                dom: 'lBfrtip',
                buttons: [

                    { "extend": 'excel', "text": 'Export excel', "className": 'btn btn-success', title: 'Liste de(s) formule(s) ',
                    }
                ],
                'ajax': {
                    'url': '{{url('formule/table')}}',
                    'type': 'GET',
                    "data": {
                        'definir_production': function() { return $('#definir_production').val() },
                        'centrale_id': function() { return $('#centrale_export_excel').val() },
                        'formule_normee': function() { return $("#recherche_formule_normee").val() },

                    },


                    'dataSrc': function (json) {

                        $('.badge').html(json.recordsTotal);

                        return json.data;
                    },
                },



                columnDefs: [
                    {
                        "targets": 3,
                        "createdCell": function(td, cellData, rowData, row, col) {

                            $(td).css('background-color', rowData['DT_appCommercial']);

                        }
                    },
                    { "className": "text-center align-middle modifier_formule th_cursor_pointer font-weight-bold", "targets": [0] },
                    { "className": "text-center align-middle supprimer_formule th_cursor_pointer font-weight-bold", "targets": [17] },
                    {'className': 'text-center align-middle ', 'targets': '_all'},
                ],
                initComplete: function () {
                    var api = this.api();
                    // console.log(api)
                    // Setup - add a text input to each header cell
                    $('.filterhead', api.table().header()).each( function () {
                        var title = $(this).text();
                        $(this).html( '<input type="text" placeholder="'+title+'" class="column_search" style="width:100%" />' );
                    } );

                    api.columns.adjust();

                }
            });
            $('table thead').on('keyup', '.column_search', function () {
                // console.log('bonjour');
                table
                    .column($(this).parent().index())
                    .search(this.value)
                    .draw();
            });
            $(".btn-success").css("color", "#fff");
            $(".btn-success").css("background-color", "#218838");
            $(".btn-success").css("#1e7e34", "#1e7e34");

            $("#rafraichir").click(function (e){
                e.preventDefault();
                table.ajax.reload(null, false);

            });
            $('#table_formule tbody').on('click', '.modifier_formule', function(e) {
                e.preventDefault();
                var data = table.row($(this).parents('tr')).data();
                var id_formule = data['DT_RowId'];
                $("#filtre").show();
                $("#affiche_formule").empty();
                $("#affiche_formule").show();
                function reponse(retour) {
                    $("#affiche_formule").html(retour);
                }

                $.get('{{url('formule')}}/'+id_formule+'/modifier' ,reponse, 'html');


            });
            $('#table_formule tbody').on('click', '.supprimer_formule', function(e) {
                e.preventDefault();


                var data = table.row($(this).parents('tr')).data();
                var id_formule = data['DT_RowId'];

                if (confirm("Êtes-vous sûr(e)?")) {
                    function reponse(retour) {
                        $("#message_base_supprimer").html(retour.message);
                        $("#message_base_supprimer").show();
                        setTimeout(function() {
                            $('#message_base_supprimer').hide();
                        }, 3000);
                        if (retour.success) {
                            setTimeout(function() {
                                table.ajax.reload(null, false);
                            }, 3000);


                        }

                    }
                    $.ajax({
                        url: '{{url('formule')}}/' + id_formule + '/supprimer',
                        method: 'DELETE',
                        data: {
                            _token: '{{ csrf_token() }}' // Assurez-vous d'inclure le jeton CSRF pour les requêtes DELETE
                        },
                        success: function(response) {
                            // Traitement de la réponse retournée par le serveur
                            reponse(response)
                        },
                        error: function(xhr, status, error) {
                            // Gestion des erreurs
                            console.error(error);
                        }
                    })
                }

            });

            $('#centrale_export_excel').change(function(e) {
                e.preventDefault();

                if ($('#centrale_export_excel').val() == 0) {

                    $('#block_recherche_formule_normee').hide();
                    $('#btn_export_excel_cout').hide();

                } else {
                    $('#recherche_formule_normee').val(3);
                    $('#block_recherche_formule_normee').show();
                    $('#btn_export_excel_cout').show();
                }
                $("#rafraichir").click();

            });
            $("#recherche_formule_normee").change(function(e) {
                e.preventDefault();
                $("#rafraichir").click();
            });
        });

        $("#export_excel").click(function(e) {
            e.preventDefault();



            window.open("{{url('formule/exporter_formule?centrale_id=')}}" + $('#centrale_export_excel').val() , '_target', 'toolbar=0,location=0,menubar=0');

        });
        $("#export_excel_avec_cout").click(function(e) {
            e.preventDefault();



            window.open("{{url('formule/exporter_formule_cout?centrale_id=')}}" + $('#centrale_export_excel').val() , '_target', 'toolbar=0,location=0,menubar=0');

        });

    </script>
@endsection