@extends('layouts.app')

@section('contents')
<div class="content ">
    <div class="mb-4">
        <nav style="--bs-breadcrumb-divider: '>';" aria-label="breadcrumb">
            <ol class="breadcrumb">
                <li class="breadcrumb-item">
                    <a href="{{url('dashboard')}}">
                        <i class="bi bi-globe2 small me-2"></i> Dashboard
                    </a>
                </li>
                <li class="breadcrumb-item active" aria-current="page">Top 20 Customers</li>
            </ol>
        </nav>
    </div>
    <div class="d-flex gap-3 mb-4 d-print-none">
        
        <div class="col-md-3">
            <div class="form-group">
                <div class="input-group">
                    <input class="form-control" placeholder="Date Range" name="datepicker" type="text" id="datepicker">
                </div>
            </div>
        </div>
    </div>
    <div class="table-responsive">

        <table id="orders" class="table table-custom table-lg table-striped">
            <thead>
                <tr>
                    <th>Sl No</th>
                    <th>Customer ID</th>
                    <th>Customer</th>
                    <th>Telephone</th>
                    <th>Invoices </th>
                    <th>Sales</th>
                </tr>
            </thead>
        </table>
    </div>
</div>
@endsection
@push('script')
<script src="https://twitter.github.io/typeahead.js/js/handlebars.js"></script>
<script>
    $(document).ready(function () {
        var start = moment().startOf('year');
        var end = moment().endOf('year');
        $('#datepicker').daterangepicker({
            startDate: start,
            endDate: end,
            ranges: {
                'Today': [moment(), moment()],
                'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                'This Month': [moment().startOf('month'), moment().endOf('month')],
                'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
                'This Month Last Year': [moment().subtract(1, 'year').startOf('month'), moment().subtract(1, 'year').endOf('month')],
                'This Year': [moment().startOf('year'), moment().endOf('year')],
                'Last Year': [moment().subtract(1, 'year').startOf('year'), moment().subtract(1, 'year').endOf('year')],
                'Current Financial Year': [moment().startOf('month'), moment().startOf('month').subtract(1, 'days').add(1, 'year')],
                'Last Financial Year': [moment().month(3).startOf('month').subtract(1, 'year'), moment().month(3).startOf('month').subtract(1, 'days')]
            },

        }, callbackSetDate());

        function callbackSetDate() {
            $('#datepicker span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
                        // updateExportFilters();
                        $('#export_start_date').val(start.format('YYYY-MM-DD'))
                        $('#export_end_date').val(end.format('YYYY-MM-DD'))
                        $('#export_date_type').val($('#date_type_dropdown').val())
                    }
                    if ($("#orders").length) {

                        var i = 1;
                        var table = $("#orders").DataTable({
                            "processing": true,
                            "lengthChange": true,
                            "serverSide": true,
                            "dom": '<"dt-buttons"Bf><"clear">lirtp',
                            "paging": true,
                            "scrollX": false,
                    // "responsive":true,
                    'stateSave': true,
                    "autoWidth": false,

                    "ajax": {
                        url: "{{ route('top-20-customers') }}",
                        type: 'GET',
                        data: function (d) {
                            var start = '';
                            var end = '';
                            if ($('#datepicker').val() != '') {
                                start = $('#datepicker').data('daterangepicker').startDate.format('YYYY-MM-DD');
                                end = $('#datepicker').data('daterangepicker').endDate.format('YYYY-MM-DD');
                            }
                            d.start_date = start;
                            d.end_date = end;
                            d.search_date_type = $('#date_type_dropdown').val();
                        },
                    },
                    columns: [
                    {
                        "data": "id", searchable:false, orderable: false ,render: function (data, type, row, meta) {
                            return meta.row + meta.settings._iDisplayStart + 1;
                        }
                    },
                    { data: 'customer_id', name: 'customer_id', orderable: false, searchable:false},
                    { data: 'name', name: 'name', orderable: false, searchable:false },                        
                    { data: 'phone', name: 'phone', orderable: false, searchable:false },
                    { data: 'cust_count', name: 'cust_count', orderable: false, searchable:false, default:'-' },
                    { data: 'cust_total', name: 'cust_total', orderable: false, searchable:false },

                    ],
                    columnDefs: [{
                        "defaultContent": "-",
                        "targets": "_all"
                    }],
                    initComplete: function () {
                        this.api().columns().every(function () {
                            var column = this;
                            var input = document.createElement("input");
                            $(input).appendTo($(column.footer()).empty())
                            .on('change', function () {
                                column.search($(this).val(), false, false, true).draw();
                            });
                        });
                    },
                    "fnDrawCallback": function (oSettings) {
                        $(".btn-delete").click(function () {
                            swal({
                                title: "Are you sure want to delete ?",
                                icon: "warning",
                                buttons: true,
                                dangerMode: true,
                            }).then((willDelete) => {
                                if (willDelete) {
                                    var address = $(this).data('value');
                                    delete_location(address);
                                }
                            });
                        });
                    },
                    buttons: [
                    {
                        extend: "copy",
                        className: "btn-sm"
                    },
                    {
                        extend: "csv",
                        className: "btn-sm"
                    },
                    {
                        extend: "excel",
                        className: "btn-sm"
                    },
                    {
                        extend: "pdfHtml5",
                        className: "btn-sm"
                    },
                    {
                        extend: "print",
                        className: "btn-sm"
                    },
                    ]
                });
}
$('#datepicker, #date_type_dropdown').on('change', function (data) {
    updateExportFilters();
    table.ajax.reload();
});

function updateExportFilters() {
    var start = '';
    var end = '';

    if ($('#datepicker').val() != '') {
        start = $('#datepicker').data('daterangepicker').startDate.format('YYYY-MM-DD');
        end = $('#datepicker').data('daterangepicker').endDate.format('YYYY-MM-DD');
    }
    date_type = $('#date_type_dropdown').val();

    $('#export_start_date').val(start);
    $('#export_end_date').val(end);
    $('#export_date_type').val(date_type);
}
});
</script>
@endpush