@extends('layouts.app')

@section('content')

@include('users.partials.header', [
    'title' => __('Comparacion Farmacia'),
    'description' => __(''),
    'class' => 'col-lg-12'
]) 

<style>
    #Table-promoaciones tbody tr{
        cursor: pointer;
    }

    #table_farmacia tbody tr{
        cursor:pointer;
    }
</style>

<div class="container-fluid mt--7">
    <div class="row">
        <div class="col-xl-12 order-xl-1">
            <div class="card shadow">

                <div class="card-body">
                    <div class="table-responsive" style="overflow-x: hidden !important;">
                        <!-- Projects table -->
                    <div class="row">
           
                        <div class="col-sm-2 col-md-2 col-lg-4">
                            {{Form::label('fecha','Fecha Cliente')}}

                            <div id="reportrangeCliente" style="background: #fff; cursor: pointer; padding: 9px 10px; border: 1px solid #ccc;border-radius: 8px !important;">
                                <i class="fa fa-calendar" aria-hidden="true"></i>&nbsp;
                                <span>August 17, 2021 - September 15, 2021</span> <i class="fa fa-caret-down" aria-hidden="true"></i>
                                </div>
                        </div>

                        <div class="col-sm-2 col-md-2 col-lg-4">
                            {{Form::label('fecha','Fecha Vendelo')}}

                            <div id="reportrange" style="background: #fff; cursor: pointer; padding: 9px 10px; border: 1px solid #ccc;border-radius: 8px !important;">
                                <i class="fa fa-calendar" aria-hidden="true"></i>&nbsp;
                                <span>August 17, 2021 - September 15, 2021</span> <i class="fa fa-caret-down" aria-hidden="true"></i>
                                </div>
                        </div>
                        <div class="col-md-4">
                            {{Form::label('Farmacia','Farmacia')}}
                           
                            <select name="farmacia_list" id="farmacia_list" class="form-control">
                                <option value="">Filtrar por farmacia</option>
                                @foreach($ListaFarmacia as $ListaFarmacias)
                                    <option value="{{$ListaFarmacias['codigo']}}" >{{$ListaFarmacias['nombre']}}</option>
                                @endforeach

                                

                            </select>
                        </div>
                        <div class="col-sm-2 col-md-2 col-lg-4">
                            {{Form::label('generar_reporte','Acciones',['class'=>'col-md-12 pl-0'])}}
                        <button class="btn btn-success btn_generar_reporte">Filtrar</button>
                        <button type="button" class="btn btn-success btn_exportar">Exportar Excel</button>
                    
                        </div>
                   



                    </div>
                        <br>
         
                        {{-- <table class="table align-items-center table-flush table-striped" id="Table-promoaciones" >
                            <thead class="thead-light">
                                <tr>
                                    <th scope="col"><b>ID</b></th>
                                    <th scope="col"><b>NOMBRE</b></th>
                                    <th scope="col"><b>CLASIFICACION</b></th>
                                </tr>
                            </thead>
                            <tbody>

                            </tbody>
                        </table> --}}
                    </div>
                    <div class="row comparacion_card">
     
                    </div>

                </div>

            </div>
        </div>
    </div>
    {{-- <div class="lds-roller"><div></div><div></div><div></div><div></div><div></div><div></div><div></div><div></div></div> --}}
</div>
{{-- <input type="text" name="" id="global" value="nacional" hidden> --}}
<div class="modal fade" id="exampleModalEdit" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true"></div>


    
@endsection

@section('js')
<script type="text/javascript" src="https://unpkg.com/xlsx@0.15.1/dist/xlsx.full.min.js"></script>
<script>
     $.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
  });
  
  $("#farmacia_list").select2();
  
  start = moment().subtract(6, 'days');
end = moment();




$('#reportrange span,#reportrangeCliente span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
$('#reportrange').daterangepicker({
       startDate: start,
       endDate: end,
       ranges: {
        'Hoy': [moment(), moment()],
     'Ayer': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
     'Últimos 7 días': [moment().subtract(6, 'days'), moment()],
     'Últimos 30 días': [moment().subtract(29, 'days'), moment()],
     'Este mes': [moment().startOf('month'), moment().endOf('month')],
     'El mes pasado': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
     'Este año': [moment().startOf('year'), moment().endOf('year')],
     'El año pasado': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')]
         }

   }, function (start, end) {
       
       $('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));

          
          $('.lds-roller').show();
        
          var start=$("#reportrange").data('daterangepicker').startDate.format('YYYYMMDD');
           var end=$("#reportrange").data('daterangepicker').endDate.format('YYYYMMDD');
        //    table_nueva.ajax.reload();
   
         
     }); 

$('#reportrangeCliente').daterangepicker({
       startDate: start,
       endDate: end,
       ranges: {
        'Hoy': [moment(), moment()],
     'Ayer': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
     'Últimos 7 días': [moment().subtract(6, 'days'), moment()],
     'Últimos 30 días': [moment().subtract(29, 'days'), moment()],
     'Este mes': [moment().startOf('month'), moment().endOf('month')],
     'El mes pasado': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
     'Este año': [moment().startOf('year'), moment().endOf('year')],
     'El año pasado': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')]
         }

   }, function (start, end) {
       
       $('#reportrangeCliente span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));

          
          $('.lds-roller').show();
        
          var start=$("#reportrangeCliente").data('daterangepicker').startDate.format('YYYYMMDD');
           var end=$("#reportrangeCliente").data('daterangepicker').endDate.format('YYYYMMDD');
        //    table_nueva.ajax.reload();
   
         
     });  


     $(".btn_generar_reporte").on('click',function(){
// Realizar la solicitud AJAX para obtener los datos
let start_date=$("#reportrange").data('daterangepicker').startDate.format('YYYY-MM-DD');
        let end_date=$("#reportrange").data('daterangepicker').endDate.format('YYYY-MM-DD');
        let start_date_cliente=$("#reportrangeCliente").data('daterangepicker').startDate.format('YYYY-MM-DD');
        let end_date_cliente=$("#reportrangeCliente").data('daterangepicker').endDate.format('YYYY-MM-DD');
        var farmacia_list=$("#farmacia_list").val();

      $.ajax({
        url: "{{route('getDatosVentasFarmacia')}}", // Cambia esto a la URL de tu API
        data:{
            start_date:start_date,
            end_date:end_date,
            start_date_cliente:start_date_cliente,
            end_date_cliente:end_date_cliente,
            farmacia_list:farmacia_list
        },
        method: 'GET',
        beforeSend: function() {
            // Mostrar el loader
            Swal.fire({
    title: 'Cargando...',
    text: 'Por favor, espera',
    allowOutsideClick: false,
    allowEscapeKey: false,
    showConfirmButton: false,
    didOpen: () => {
        Swal.showLoading();
    }
});

        },
        success: function(response) {
            
            $(".comparacion_card").html(response);
            // Inicializar DataTable para table_servidor
            generarDatatable(true);

   
        },
        error: function(xhr, status, error) {
            console.error('Error al obtener los datos:', error);
        },
        complete:function(){
            // Ocultar el loader
           Swal.close();
        }
    });
     });


     $(document).on('click','#table_farmacia tbody tr',function(){
    let url="{{route('ComparacionFacturaDetalle')}}";
    let cod_cliente=$(this).attr("cod_cliente");
    let start_date=$("#reportrange").data('daterangepicker').startDate.format('YYYY-MM-DD');
    let end_date=$("#reportrange").data('daterangepicker').endDate.format('YYYY-MM-DD');

    let start_date_cliente=$("#reportrangeCliente").data('daterangepicker').startDate.format('YYYY-MM-DD')
    let end_date_cliente=$("#reportrangeCliente").data('daterangepicker').endDate.format('YYYY-MM-DD')
  
    url=url+"?cod_cliente="+cod_cliente+"&start_date="+start_date+"&end_date="+end_date+"&start_date_cliente="+start_date_cliente+"&end_date_cliente="+end_date_cliente;
    window.location.href=url;
});

$(".btn_exportar").on('click',function(){
    generarDatatable(false);
    ExportToExcel('xlsx','Listado de clientes');
    generarDatatable(true);


    
});

function generarDatatable(paging){
    $('#table_farmacia').DataTable().destroy(); 
    $('#table_farmacia').DataTable({
            
            paging: paging,
            info: false,
            processing: true,
            serverSide: false,
            lengthMenu: [
                [10, 25, 50, -1],
                [10, 25, 50, 'All']
            ],
            language: {
                searchPlaceholder: "Buscar",
                decimal: "",
                emptyTable: "No hay información",
                info: "Mostrando _START_ a _END_ de _TOTAL_ Entradas",
                infoEmpty: "Mostrando 0 to 0 of 0 Entradas",
                infoFiltered: "(Filtrado de _MAX_ total entradas)",
                infoPostFix: "",
                thousands: ",",
                lengthMenu: "Mostrar _MENU_",
                loadingRecords: "Cargando...",
                processing: "Procesando...",
                search: "",
                zeroRecords: "Sin resultados encontrados",
                paginate: {
                    first: "Primero",
                    last: "Ultimo",
                    next: "Siguiente",
                    previous: "Anterior"
                }
            }
        });
}

function ExportToExcel(type,nombre, fn, dl) {
            var elt = document.getElementById('table_farmacia');
            var wb = XLSX.utils.table_to_book(elt, { sheet: "sheet1",date_format: "YYYY-MM-DD",raw : true });
            return dl ?
                XLSX.write(wb, { bookType: type, bookSST: false, type: 'base64',raw: true }) :
                XLSX.writeFile(wb, fn || (nombre+'.' + (type || 'xlsx')));
        }




</script>

@endsection