@extends('base')
@php
    use App\fonctions\definir_date_selection_fonction;
    $dates = (new definir_date_selection_fonction())->definir_date_selection($parametre->parametre_date_grille_generale);
@endphp
@section('content')
    <input type="hidden" name="session" id="session" value="{{ $user->name }}">
    <input type="hidden" name="recherche_default" id="recherche_default" value="{{ request('recherche_default', '') }}">

    <div class="ring">
        Loading...
        <span id="span_loading"></span>
    </div>

    <div id="filtre_loading"></div>

    <div class="alert alert-success text-center">LISTE DES DEVIS</div>

    <div class="form-row">
        <div class="form-group col-md-2">
            <label for="date_debut">Début:</label>
            <input type="date" class="form-control" style="color:black !important" id="date_debut" value="{{ $dates['debut'] }}">
        </div>

        <div class="form-group col-md-2">
            <label for="date_fin">Fin:</label>
            <input type="date" class="form-control" style="color:black !important" id="date_fin" value="{{ $dates['fin'] }}">
        </div>

        <div class="col-md-4" style="text-align: right;padding-top: 2%;padding-right: 3%;">
            <button class="btn btn-success refrech" >Rafraichir</button>
            @if ($profil->profil_devis == 2 || $profil->profil_devis == 4 || $profil->profil_devis == 5)
                <button class="btn btn-success ajouter_devis" >Ajouter</button>
            @endif
        </div>
    </div>

    <div class="form-row" style="margin-bottom:2%;">
        <div class="form-group col-md-2">
            <label for="recherche_societe_devis">Société</label>
            <select class="form-control" style="color:black !important" id="recherche_societe_devis">
                <option value="0">Toutes</option>
                @foreach ($societes as $societe)
                    <option value="{{ $societe->ID_Societe }}">{{ $societe->Societe_Code }} -> {{ $societe->Societe_Nom_Societe }}</option>
                @endforeach
            </select>
        </div>

        <div class="form-group col-md-2">
            <label for="recherche_commercial_devis">Commercial</label>
            <select class="form-control" style="color:black !important" id="recherche_commercial_devis">
                <option value="0">Tous</option>
                @foreach ($commerciaux as $commercial)
                    <option value="{{ $commercial->id_commercial }}">{{ $commercial->commercial_prenom }} {{ $commercial->commercial_nom }}</option>
                @endforeach
            </select>
        </div>

        <div class="form-group col-md-2">
            <label for="etat_devis_grille">Etat devis</label>
            <select class="form-control" style="color:black !important" id="etat_devis_grille">
                <option value="6">Tous</option>
                <option value="0">En cours</option>
                <option value="1">Gagné(commande)</option>
                <option value="2">Perdu</option>
                <option value="3">Renégocier</option>
                <option value="4">Abandonner</option>
                <option value="5">Autre</option>
            </select>
        </div>

        <div class="form-group col-md-2">
            <label for="filtre_relance">Relance dans (jours)</label>
            <input type="number" class="form-control" id="filtre_relance" style="color:black !important" value="" min="0">
        </div>
    </div>

    <div id="filtre"><button type="button" class="fermer btn btn-danger">X</button></div>
    <div id="affiche_devis"></div>

    <div class="col-md-12 text-center" style="margin-bottom: 10px;">
        Nombre de devis : <span class="badge badge-success" style="background : #dff0d8; color: #000; font-size: 15px;">0</span>
    </div>

    <div class="table-responsive">
        <table class="table table-striped table-hover table-bordered" id="table_devis" style="width:100%">
            <thead style="background-color:#28a745; color:white">
                <tr>
                    <th scope="col" class="text-center">D</th>
                    <th scope="col" class="text-center">CODE</th>
                    <th scope="col" class="text-center">DATE</th>
                    <th scope="col" class="text-center">RELANCE</th>
                    <th scope="col" class="text-center">CODE CLI</th>
                    <th scope="col" class="text-center">CLIENT</th>
                    <th scope="col" class="text-center">CODE CHAN</th>
                    <th scope="col" class="text-center">CHANTIER</th>
                    <th scope="col" class="text-center">QTE PREV</th>
                    <th scope="col" class="text-center">DATE LIVRAISON</th>
                    <th scope="col" class="text-center">REFERENCE</th>
                    <th scope="col" class="text-center">PROJET</th>
                    <th scope="col" class="text-center">CONTACT</th>
                    <th scope="col" class="text-center">MAIL</th>
                    <th scope="col" class="text-center">COMMERCIAL</th>
                    <th scope="col" class="text-center">CENTRALE</th>
                    <th scope="col" class="text-center">PDF</th>
                    <th scope="col" class="text-center">ETAT</th>
                    <th scope="col" class="text-center">SUPPRIMER</th>
                </tr>
            </thead>
            <tbody class="tbody_devis"></tbody>
        </table>
    </div>

    <script>
        function format(rowData) {
            var div = $('<div/>').addClass('loading').text('Loading...');
            $.ajax({
                url: '{{ route("devis_laravel.ligne_devis_table") }}',
                data: {
                    devis_code: rowData[1].replace(/<\/?[^>]+(>|$)/g, "") // Strip HTML tags to get raw devis_code
                },
                dataType: 'json',
                success: function(json) {
                    div.html(json.ligne_devis_tableau).removeClass('loading');
                    // Initialize Sortable for Drag and Drop
                    div.find(".tbody_lignes_devis_sortable").sortable({
                        handle: ".handle-drag",
                        placeholder: "ui-state-highlight",
                        axis: "y",
                        update: function(event, ui) {
                            var ids = [];
                            div.find(".sortable-row").each(function() {
                                ids.push($(this).data("id"));
                            });
                            $.ajax({
                                url: '{{ route("devis_laravel.reordonner_lignes") }}',
                                method: 'POST',
                                data: {
                                    _token: '{{ csrf_token() }}',
                                    ids: ids
                                },
                                success: function(response) {
                                    if(response.success) {
                                        // Refresh only the expanded table details or show message
                                        $("#message").html(response.message).show();
                                        setTimeout(function() { $("#message").hide(); }, 1500);
                                        // Reload the line table to get new prices/totals if recalculated
                                        $.ajax({
                                            url: '{{ route("devis_laravel.ligne_devis_table") }}',
                                            data: { devis_code: rowData[1].replace(/<\/?[^>]+(>|$)/g, "") },
                                            dataType: 'json',
                                            success: function(newJson) {
                                                div.html(newJson.ligne_devis_tableau);
                                            }
                                        });
                                    }
                                }
                            });
                        }
                    });
                }
            });
            return div;
        }

        $(document).ready(function() {
            var text = "DEVIS - SMART CENTRAL  ";
            $('title').text(text);

            $("#filtre").click(function(e) {
                e.preventDefault();
                $("#affiche_devis").hide().empty();
                $("#filtre").hide();
            });

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

            $(".ajouter_devis").click(function(e) {
                e.preventDefault();
                $("#filtre").show();
                $("#affiche_devis").empty().show();
                $.get('{{ route("devis_laravel.creer") }}', {}, function(retourHTML) {
                    $("#affiche_devis").html(retourHTML);
                }, "html");
            });

            $.fn.dataTable.moment('DD/MM/YYYY');
            var table = $('#table_devis').DataTable({
                scrollX: true,
                scrollCollapse: true,
                autoWidth: true,
                paging: true,
                dom: 'Blfrtip',
                "pageLength": 100,
                buttons: [
                    { "extend": 'excel', "text": 'Export excel', "className": 'btn btn-success', title: 'Liste devis ' }
                ],
                "ajax": {
                    "url": '{{ route("devis_laravel.table") }}',
                    "type": "GET",
                    "data": function(d) {
                        d.date_debut = $('#date_debut').val();
                        d.date_fin = $('#date_fin').val();
                        d.etat_devis = $("#etat_devis_grille").val();
                        d.societe_id = $("#recherche_societe_devis").val();
                        d.commercial_id = $("#recherche_commercial_devis").val();
                        d.jours_relance = $("#filtre_relance").val();
                    },
                    "dataSrc": function(json) {
                        $(".badge").html(json.recordsFiltered);
                        return json.data;
                    }
                },
                "search": {
                    "search": $('#recherche_default').val()
                },
                columnDefs: [
                    {
                        "targets": 5,
                        "createdCell": function(td, cellData, rowData, row, col) {
                            if (rowData['DT_ClientColor'] != "") {
                                $(td).css('background-color', rowData['DT_ClientColor']);
                            }
                        }
                    },
                    {
                        "targets": 16,
                        "data": function(json) {
                            var valeur = json[18]; // Files list
                            var text = '<div class="btn-group" role="group"><button id="btnpdf" type="button" class="btn btn-success dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><i style="color:white" class="far fa-file-pdf"></i></button><div class="dropdown-menu" aria-labelledby="btnpdf">';
                            for (var i = 0; i < valeur.length; i++) {
                                if (valeur[i] != '.' && valeur[i] != '..') {
                                    text += '<a class="dropdown-item les_pdf" nom_dossier_pdf="' + valeur[i] + '">' + valeur[i] + '</a>';
                                }
                            }
                            text += '</div></div>';
                            return text;
                        },
                        "defaultContent": null
                    },
                    {
                        "targets": 0,
                        "data": null,
                        "orderable": false,
                        "className": 'details-control',
                        "defaultContent": ''
                    },
                    { "className": "text-center align-middle modif_devis th_cursor_pointer", "targets": [1] },
                    { "className": "text-center align-middle supp_devis th_cursor_pointer", "targets": [18] },
                    { "className": "text-center align-middle ", "targets": "_all" },
                    { "width": "170px", "targets": [2, 3] },
                    { "width": "170px", "targets": [5] },
                    { "width": "170", "targets": [12] }
                ],
                "order": [[1, 'asc']]
            });

            $(".btn-success").css({"color": "#fff", "background-color": "#218838"});

            $('#table_devis tbody').on('click', 'td.details-control', function() {
                var tr = $(this).closest('tr');
                var row = table.row(tr);
                if (row.child.isShown()) {
                    row.child.hide();
                    tr.removeClass('shown');
                } else {
                    row.child(format(row.data())).show();
                    tr.addClass('shown');
                }
            });

            $(".refrech").click(function(e) {
                table.ajax.reload(null, false);
            });

            $("#date_debut, #date_fin, #etat_devis_grille, #recherche_societe_devis, #recherche_commercial_devis").change(function() {
                table.ajax.reload(null, false);
            });

            $("#filtre_relance").on("change keyup", function() {
                if ($(this).val() != '') {
                    $("#etat_devis_grille").val('0');
                }
                table.ajax.reload(null, false);
            });

            $('#table_devis tbody').on('click', '.modif_devis', function(e) {
                e.preventDefault();
                var data = table.row($(this).parents('tr')).data();
                var id_devis = data['DT_RowId'];
                $("#filtre").show();
                $("#affiche_devis").empty().show();
                var url = '{{ route("devis_laravel.modifier", ["devis" => "devis_id_temp"]) }}';
                url = url.replace('devis_id_temp', id_devis);
                $.get(url, {}, function(retourHTML) {
                    $("#affiche_devis").html(retourHTML);
                }, "html");
            });

            $('#table_devis tbody').on('click', '.les_pdf', function(e) {
                e.preventDefault();
                var data = table.row($(this).parents('tr')).data();
                var id_devis = data['DT_RowId'];
                var nom_dossier = $(this).attr('nom_dossier_pdf');
                $.get(App.modeleclientUrl + "devis/" + nom_dossier + "/index.php", { 'id_devis': id_devis }, function(retourPHP) {
                    window.open("pdf/telecharger_pdf.php?nom_pdf=" + retourPHP.nom_pdf, '_blank');
                }, 'json');
            });

            $('#table_devis tbody').on('click', '.supp_devis', function(e) {
                e.preventDefault();
                var data = table.row($(this).parents('tr')).data();
                var id_devis = data['DT_RowId'];
                $("#message").empty();
                if (confirm("Êtes-vous sûr(e)?")) {
                    var url = '{{ route("devis_laravel.supprimer", ["devis" => "devis_id_temp"]) }}';
                    url = url.replace('devis_id_temp', id_devis);
                    $.ajax({
                        url: url,
                        method: 'DELETE',
                        data: {
                            _token: '{{ csrf_token() }}'
                        },
                        success: function(retourPHP) {
                            $("#message").html(retourPHP.message).show();
                            setTimeout(function() { $("#message").hide(); }, 1500);
                            setTimeout(function() { $(".refrech").click(); }, 1500);
                        }
                    });
                }
            });
        });
    </script>
@endsection