@extends('models')
@section('substock')
    open active
@endsection
@section('stock')
    active
@endsection
{{-- @section('TrfInterSite', 'active') --}}
@section('titre-page', 'Listing des mouvements à rembourser')
@section('content-body')
    <style>
        .height-input {
            height: 2.5rem !important;
        }

        input::-webkit-outer-spin-button,
        input::-webkit-inner-spin-button {
            -webkit-appearance: none;
        }

        ul.ui-autocomplete {
            z-index: 1100;
        }

        .ui-autocomplete {
            max-height: 350px;
            max-width: 1000px;
            overflow-y: auto;
            /* position: static !important; */
        }

        .ui-menu-item .ui-state-active {
            background: #D7C5FF8E;
            border: none;
            color: black
        }

        .ui-menu .ui-menu-item-wrapper {
            position: relative;
            padding: 1px 1em 1px 0.4em !important;
        }

        .autocomplete-table {
            width: 100%;
            border-collapse: collapse;
        }

        .autocomplete-table th,
        .autocomplete-table td {
            border-left: 1px solid #ddd;
            border-right: 1px solid #ddd;
            padding: 8px;
        }

        .autocomplete-table th {
            background-color: #b9b9b9;
        }

        .ui-menu-item {
            cursor: pointer;
        }

        .ui-menu-item-wrapper {
            white-space: nowrap;
        }

        input[type="text"] {
            text-align: center
        }

        @media (min-width: 1200px) {
            .modal-xl {
                --bs-modal-width: 1260px !important;
            }
        }

        .modal-open-noscroll {
            overflow: hidden;
        }

        #tableDetailBl tbody tr:not(.rupture):hover {
            background-color: #f0f0f0;
            /* Couleur de fond lors du survol */
        }

        body.modal-open {
            overflow: hidden;
        }

        [data-filepond-item-state='processing-complete'] .filepond--item-panel {
            background-color: green;
        }
    </style>

    <!-- 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-3">
                <div class="col-xl-6 col-lg-6 col-md-4 mt-2">
                    <nav>
                        <ol class="breadcrumb mb-0">
                            <li class="breadcrumb-item text-light"><a href="javascript:void(0);">Stocks</a></li>
                            <li class="breadcrumb-item active" aria-current="page">Listing des mouvements à rembourser</li>
                        </ol>
                    </nav>
                </div>
                <div class="col-xl-6 col-lg-6 col-md-8 col-sm-12 mt-xl-0 mt-2 mx-0 ">
                    <div class="row justify-content-end">

                        <div class="col-xl-6 col-sm-3 col-md-3 d-flex justify-content-center">
                            <button class=" btn btn-wave waves-effect waves-light btn-dark-light w-100" id="btnGenerer">
                                <i class='bx bx-repost mt-1 me-1'></i>  Générer les réclamation fournisseurs
                            </button>
                        </div>
                        {{-- <div class="col-xl-3 col-sm-3 col-md-3 d-flex justify-content-center">
                            <button class=" btn btn-wave waves-effect waves-light btn-warning-light w-100" id="btnImprimer">
                                <i class="bx bx-printer mt-1 me-1"></i> Imprimer
                            </button>
                        </div> --}}
                    </div>
                </div>

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

    <!-- Start:: row-7 -->
    <div class="row">
        <div class="col-xl-12">
            <div class="card custom-card">
                <div class="card-body">
                    <div class="row px-4">

                        <div class="col-xl-4 col-lg-3 col-sm-3 col-6 d-flex align-items-center">
                            <div class="me-2">
                                <span class="avatar avatar-rounded bg-primary-transparent text-primary">
                                    <i class="bx bx-dice-3" style="font-size: 24px"></i>
                                </span>
                            </div>
                            <div class="flex-fill">
                                <p class="fs-18 mb-0 text-primary fw-semibold" id="nbreligne"></p>
                                <span class="text-muted fs-12">Nbre ligne</span>
                            </div>
                        </div>
                        <div class="col-xl-4 col-lg-3 col-sm-3 col-6 d-flex align-items-center">
                            <div class="me-2">
                                <span class="avatar avatar-rounded bg-light text-default">
                                    <i class="bi bi-cash-stack " style="font-size: 24px"></i>

                                </span>
                            </div>
                            <div class="flex-fill">
                                <p class="fs-18 mb-0 fw-semibold" id="nbreRemb"></p>
                                <span class="text-muted fs-12">Nbre à rembourser</span>
                            </div>
                        </div>
                        <div class="col-xl-4 col-lg-3 col-sm-3 col-1 d-flex align-items-center">
                            <div class="me-2">
                                <span class="avatar avatar-rounded bg-success-transparent">
                                    <i class="bi bi-cash-stack " style="font-size: 24px"></i>

                                </span>
                            </div>
                            <div class="flex-fill">
                                <p class="fs-18 mb-0 text-success fw-semibold" id="valeurRemb"></p>
                                <span class="text-muted fs-12">Valeur à rembourser</span>
                            </div>
                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- End:: row-7 -->

    <div class="row">
        <div class="col-xl-12 mb-2">
            <div class="accordion " id="">
                <div class="accordion-item">
                    <h2 class="accordion-header" id="headingOne">
                        <button class="accordion-button bg-danger-gradient" type="button" data-bs-toggle="collapse"
                            data-bs-target="#correction_collapse" aria-expanded="true" aria-controls="correction_collapse">
                            Filtre
                        </button>
                    </h2>
                    <div id="correction_collapse" class="accordion-collapse collapse show" aria-labelledby="headingOne"
                        data-bs-parent="#correction_collapse">
                        <div class="accordion-body">

                            
                                <div class="row">
                                    <div class="col-xl-11">
                                        <div class="row">

                                            <div class="col-xl-4 mb-2">
                                                <p class="mb-0 text-muted">Période</p>
                                                <input type="text" class="form-control" id="periode" name="periode">
                                            </div>

                                            <div class="col-xl-4 mb-2">
                                                <p class="mb-0 text-muted">Fournisseur</p>
                                                <select class="form-select" name="IDFOURNISSEUR" id="IDFOURNISSEUR">
                                                    <option value="0">TOUS</option>
                                                    @foreach ($FOURNISSEUR as $item)
                                                        <option value="{{ $item->IDFOURNISSEUR }}">
                                                            {{ $item->NomFournisseur }}
                                                        </option>
                                                    @endforeach
                                                </select>
                                            </div>


                                            <div class="col-xl-4 mb-2">
                                                <p class="mb-0 text-muted">Motif de mouvement</p>
                                                <select class="form-select" name="IDCORRECTION_MOTIF" id="IDCORRECTION_MOTIF">
                                                    <option value="0">TOUS</option>
                                                    @foreach ($CORRECTION_MOTIF as $item)
                                                        <option value="{{ $item->IDCORRECTION_MOTIF }}">
                                                            {{ $item->LibelleMotifCorrection }}
                                                        </option>
                                                    @endforeach
                                                </select>
                                            </div>

                                            <div class="col-xl-4 mb-2">
                                                <p class="mb-0 text-muted">Produit</p>
                                                <select class="form-select" name="IDPRODUIT" id="IDPRODUIT">
                                                    <option value="0">TOUS</option>
                                                    @foreach ($PRODUIT as $item)
                                                    <option value="{{ $item->IDPRODUIT}}">{{ $item->DesignationProduit}}</option>
                                                        
                                                    @endforeach
                                                </select>
                                            </div>

                                            <div class="col-xl-4  mb-2">
                                                <p class="mb-0 text-muted">Motif de réclamation</p>
                                                <select class="form-select" name="IDRETOURFSEUR_MOTIF" id="IDRETOURFSEUR_MOTIF">
                                                    <option value="0">TOUS</option>
                                                    @foreach ($RETOURFSEUR_MOTIF as $item)
                                                    <option value="{{ $item->IDRETOURFSEUR_MOTIF}}">{{ $item->LibelleMotifRetour}}</option>
                                                        
                                                    @endforeach
                                                </select>
                                            </div>

                                            <div class="col-xl-4 mb-2">
                                                <p class="mb-0 text-muted">Laboratoire</p>
                                                <select class="form-select" name="IDLABORATOIRE" id="IDLABORATOIRE">
                                                    <option value="0">TOUS</option>
                                                    @foreach ($LABORATOIRE as $item)
                                                        <option value="{{ $item->IDLABORATOIRE }}">
                                                            {{ $item->NomLaboratoire }}
                                                        </option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-1">
                                        <div class="row flex-fill">
                                            <div class="col-xl-12">
                                                <button class="btn btn-primary w-100" type="submit" id="btnSearch" data-bs-toggle="tooltip"
                                                    data-bs-placement="bottom"
                                                    data-bs-custom-class="tooltip-secondary"
                                                    data-bs-trigger="hover"
                                                    title="Filtrer">
                                                    <i class='bx bx-search-alt'></i>
                                                </button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="row">
        <div class=" col-xl-12">
            <div class="card  custom-card">

                <div class="card-body">
                    <div class="table-responsive">
                        <table class="tablehover table table-striped tablehover text-nowrap w-100 openModalProduit no-footer dataTable"
                            id="tableListeRembourse">
                            <thead class="table-header-primary">
                                <tr id="tableHead">
                                    <th class="text-center" data-column="action" data-class="text-center">
                                        <input class="form-check-input me-1" type="checkbox" id="checkAll">
                                        #
                                    </th>
                                    
                                    <th class="text-center" data-column="NumeroCorrection" data-class="text-center">N° Correction</th>
                                    <th class="text-center" data-column="CodeCipProduit1" data-class="text-center">CIP 1</th>
                                    <th class="text-center" data-column="DesignationProduit" data-class="text-start">Désignation</th>
                                    <th class="text-center" data-column="NumeroTracabilite" data-class="text-center">NTSP</th>
                                    <th class="text-center" data-column="NumeroLotProduit" data-class="text-center">Numéro de Lot</th>
                                    <th class="text-center" data-column="DatePeremption" data-class="text-center">Date péremption</th>
                                    <th class="text-center" data-column="NomZoneStockage" data-class="text-center">Zone stockage</th>
                                    <th class="text-center" data-column="NomFournisseur" data-class="text-start">Fournisseur</th>
                                    <th class="text-center" data-column="LibelleMotifCorrection" data-class="text-start">Motif</th>
                                    <th class="text-center" data-column="LibelleMotifRetour" data-class="text-start">Motif de Remboursement</th>
                                    <th class="text-center" data-column="NomLaboratoire" data-class="text-start">Laboratoire</th>
                                    <th class="text-center" data-column="QteCorrigee" data-class="text-center">Quantité</th>
                                    <th class="text-center" data-column="PrixRMP" data-class="text-center">Prix de Revient</th>
                                    <th class="text-center" data-column="TotalTaxe" data-class="text-center">Taxe</th>
                                    <th class="text-center" data-column="TotalTTC" data-class="text-end">Total à Rembourser</th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
@endsection

@section('script')
    <script>
        $(document).ready(function() {
            
            $("#IDFOURNISSEUR").select2()
            $("#IDCORRECTION_MOTIF").select2()
            $("#IDPRODUIT").select2()
            $("#IDRETOURFSEUR_MOTIF").select2()
            $("#IDLABORATOIRE").select2()
            
            chargerSelectlisteAgence()
            chargerSelectProduit()
            dateRange("#periode", -90)
            function chargerSelectlisteAgence() {
                $.ajax({
                    url: '{{ route('listeAgence') }}',
                    type: 'GET',
                    dataType: 'json',
                    success: function(response) {
                        // // console.log(response)
                        $('#IDAGENCE').html('')

                        $('#IDAGENCE').append('<option value="0">TOUS</option>')
                        $.each(response.data, function(key, value) {
                            $('#IDAGENCE').append(
                                `<option value="${value["IDAGENCE"]}">${value["NomAgence"]}</option>`
                            )
                        })

                        $('#IDAGENCE').val('{{ session()->get('IDAGENCE') }}').change()
                    }
                })
            }

            function chargerSelectProduit() {

                $.ajax({
                    url: '{{ route('listingProduitSimple') }}',
                    type: 'GET',
                    dataType: 'json',
                    success: function(response) {

                        $('#produit').html('')
                        $('#produit').append('<option value="0">TOUS LES PRODUITS</option>')
                        $('#produit_add').html('')
                        $('#produit_add').append('<option value="0">TOUS LES PRODUITS</option>')

                        $.each(response.data, function(key, value) {
                            $('#produit').append(
                                `<option value="${value["IDPRODUIT"]}">${value["DesignationProduit"]}</option>`
                            )
                            $('#produit_add').append(
                                `<option value="${value["IDPRODUIT"]}">${value["DesignationProduit"]}</option>`
                            )
                        })
                        $('#produit').select2()
                        $('#produit_add').select2({
                            dropdownParent: $('#modalAdd')
                        })
                    }
                })
            }

            function getDataMvt() {
                $.ajax({
                    type: "get",
                    url: "{{ route('stock.etatMvtRembourse.listing') }}",
                    data: {
                        periode : $("#periode").val(),
                        IDFOURNISSEUR : $("#IDFOURNISSEUR").val(),
                        IDCORRECTION_MOTIF : $("#IDCORRECTION_MOTIF").val(),
                        IDPRODUIT : $("#IDPRODUIT").val(),
                        IDRETOURFSEUR_MOTIF : $("#IDRETOURFSEUR_MOTIF").val(),
                        IDLABORATOIRE : $("#IDLABORATOIRE").val(),
                    },
                    beforeSend: progressHandler(),
                    dataType: "json",
                    success: function(response) {
                        console.log(response)
                        if (response.error == false) {
                            tableListeEtatPerime = remplissageDataTable({
                                IdentifiantDuTableau: '#tableListeRembourse',
                                obj: response.data,
                            })

                            let divShowPer = $('#tableListeRembourse_filter')
                            let BroDivShowPer = divShowPer.parent().parent()
                            let child = BroDivShowPer.children().eq(0)
                            let child2 = BroDivShowPer.children().eq(1)

                            child2.removeClass('col-md-6')
                            child2.addClass('col-md-4 d-flex  justify-content-end')
                          
                            child.removeClass('col-md-6')
                            child.addClass('d-flex pt-2 col-md-8')
                            child.append(`
                                         <span class="d-flex align-items-center px-2" style="cursor : pointer;">
                                                <i class='ri ri-file-excel-2-line text-success me-1' style="font-size : 18px; cursor : pointer;"></i>
                                                <span id="btn-export-rembourse" class="fw-bold" style="cursor : pointer;">Exporter</span>
                                            </span>
                                        `)

                            $("#nbreligne").text(response.data.length)
                            $("#nbreRemb").text(response.nbreArembourse)
                            $("#valeurRemb").text(response.montantArembourse)
                            completeHandler()
                            return 0
                        }
                        completeHandler()
                    },
                    error: function(response) {
                        // console.log(response)
                        completeHandler()
                        notifError(response.messages)
                    }
                });
            }

            var tableListeEtatPerime = $("#tableListeRembourse").DataTable({
                language: languageTable,
                // pagingType: 'full_numbers',
                pageLength: 25,
                lengthChange: true,
                order: [],
            })

            _('checkAll').addEventListener('click', function() {
                let value = this.checked
                let tableListeTransfert = $("#tableListeRembourse").DataTable()
                let lignes = tableListeTransfert.rows().nodes()
                $(lignes).find('#checkLigne').prop('checked', value)
            })

            $(document).on("click", "#btnSearch", function() {
                getDataMvt()
            }).on("click", "#btnGenerer", function() {
                let data = tableListeEtatPerime.rows().data().toArray()
                let liste = listeLigneSelectionne("#tableListeRembourse", "#checkLigne")
                filteredData = data.filter(row => liste.includes(String(row.IDCORRECTION_LIGNE)))

                if (liste.length <= 0) {
                    alertSwal("Cocher une ou plusieurs lignes !!!")
                    return false
                }

                $.ajax({
                    type: "POST",
                    url: "{{ route("stock.etatMvtRembourse.generer") }}",
                    data: {
                        data : filteredData,
                        _token : "{{ csrf_token() }}"
                    },
                    dataType: "json",
                    beforeSend: progressHandler(),
                    success: function (response) {
                        console.log(response)
                        if(response.error == false){
                            notifSuccess(response.messages)
                            $("#btnSearch").click()
                        }else{
                            notifWarning(response.messages)
                        }
                        completeHandler()
                    }, 
                    error :function (response) { 
                        completeHandler()
                     }
                });
            })


             $(document).on('click','#btn-export-rembourse',function(){
                var data =  getCleanedTableData('tableListeRembourse')
                const filename =file_name("REMBOURSEMENT");
                const tabs_format = { M: '#,##0', O: '#,##0'};
                download_excel_file('{{route("export_global_excel.export")}}', data,filename,['#'],tabs_format)
            })

            

        })
    </script>
@endsection