@php
    use Carbon\Carbon;
@endphp
@extends('layouts.main')
@section('title', 'API Hits Records for ' . $monthname)
@section('content')
    <!-- push external head elements to head -->
    @push('head')
        <link rel="stylesheet" href="{{ asset('plugins/DataTables/datatables.min.css') }}">
    @endpush

    <div class="container-fluid">
        <div class="page-header">
            <div class="row align-items-end">
                <div class="col-lg-8">
                    <div class="page-header-title">
                        <i class="ik ik-edit bg-blue"></i>
                        <div class="d-inline">
                            <h5>{{ __('Datewise API Records') }}</h5>

                        </div>
                    </div>
                </div>
                <div class="col-lg-4">
                    <nav class="breadcrumb-container" aria-label="breadcrumb">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item">
                                <a href="{{ route('dashboard') }}"><i class="ik ik-home"></i></a>
                            </li>
                            <li class="breadcrumb-item"><a href="#">{{ __('Datewise Records') }}</a></li>
                        </ol>
                    </nav>
                </div>
            </div>
        </div>

        <div class = "row clearfix">
            <div class="col-xl-12 col-md-6">
                <div class="card table-card">
                    <div class="card-header">
                        <h3>DateWise API Records</h3>
                    </div>
                    <div class="card-block p-2">
                        <div class="table-responsive">
                            <table class="table table-bordered table-hover mb-0">
                                <thead>
                                    <tr>
                                        <th>S.no</th>
                                        <th>Date</th>
                                        <th>Total API Hits</th>
                                        <th>GeoCoding API Hits</th>
                                        <th>Direction API Hits</th>
                                        <th>GeoLocation API Hits</th>
                                        
                                    </tr>
                                </thead>
                                <tbody>

                                </tbody>
                                <tfoot>
                                    <tr>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                </tfoot>

                            </table>
                        </div>

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

    @push('script')
        <script src="{{ asset('js/datatables.js') }}"></script>
        <script src="{{ asset('plugins/DataTables/datatables.min.js') }}"></script>
        <script>
            $(document).ready(function() {
                let month = "{{ $month }}";
                var searchable = [];
                var selectable = [];
                var dTable = $('.table').DataTable({
                    order: [],
                    processing: true,
                    responsive: false,
                    serverSide: true,
                    processing: true,
                    pageLength: 32,
                    ordering: false,
                    language: {
                        processing: '<i class="ace-icon fa fa-spinner fa-spin orange bigger-500" style="font-size:60px;margin-top:50px;"></i>'
                    },
                    scroller: {
                        loadingIndicator: false
                    },
                    pagingType: "full_numbers",
                    dom: "<'row'<'col-sm-12 text-center'B>>tipr",
                    ajax: {
                        url: '{{ url('/datewisereporting') }}/' + month,
                        type: "get",
                        dataSrc: function(json) {
                            updateFooter(json.totals); // Call footer update
                            return json.data;
                        }
                    },
                    columns: [

                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'date',
                            name: 'date',
                        },
                        {
                            data: 'totalapihits',
                            name: 'totalapihits'
                        },
                        {
                            data: 'noofgeocoding',
                            name: 'noofgeocoding'
                        },
                        {
                            data: 'noofdirection',
                            name: 'noofdirection'
                        },
                        {
                            data: 'noofgeolocation',
                            name: 'noofgeolocation'
                        }
                    ],
                    buttons: [

                        {
                            extend: 'csv',
                            className: 'btn-sm btn-success',
                            title: 'HeaderDetails',
                            header: true,
                            footer: true,
                            exportOptions: {
                                // columns: ':visible'
                            }
                        }, {
                            extend: 'pdf',
                            className: 'btn-sm btn-primary',
                            header: true,
                            footer: true,
                            exportOptions: {
                               
                            }
                        },


                    ],
                    initComplete: function() {
                        var api = this.api();
                        api.columns(searchable).every(function() {
                            var column = this;
                            var input = document.createElement("input");
                            input.setAttribute('placeholder', $(column.header()).text());
                            input.setAttribute('style',
                                'width: 140px; height:25px; border:1px solid whitesmoke;');

                            $(input).appendTo($(column.header()).empty())
                                .on('keyup', function() {
                                    column.search($(this).val(), false, false, true).draw();
                                });

                            $('input', this.column(column).header()).on('click', function(e) {
                                e.stopPropagation();
                            });
                        });

                        api.columns(selectable).every(function(i, x) {
                            var column = this;

                            var select = $(
                                    '<select style="width: 140px; height:25px; border:1px solid whitesmoke; font-size: 12px; font-weight:bold;"><option value="">' +
                                    $(column.header()).text() + '</option></select>')
                                .appendTo($(column.header()).empty())
                                .on('change', function(e) {
                                    var val = $.fn.dataTable.util.escapeRegex(
                                        $(this).val()
                                    );
                                    column.search(val ? '^' + val + '$' : '', true, false)
                                        .draw();
                                    e.stopPropagation();
                                });

                            $.each(dropdownList[i], function(j, v) {
                                select.append('<option value="' + v + '">' + v +
                                    '</option>')
                            });
                        });
                    }
                });

                function updateFooter(totals) {
                    if (!totals) return;
                    $('.table tfoot th').eq(0).html('');
                    $('.table tfoot th').eq(1).html('Total');
                    $('.table tfoot th').eq(2).html(totals.totalapihitscount);
                    $('.table tfoot th').eq(3).html(totals.totalcountgeocoding);
                    $('.table tfoot th').eq(4).html(totals.totalcountdirection);
                    $('.table tfoot th').eq(5).html('0');
                }
            });
        </script>
    @endpush

@endsection