@extends ('backend.layouts.app')
@section('title', 'e4m Analytics')
@section('content')
    <div class="box box-info">
        <div class="box-header with-border card-header">
            <h3 class="box-title" style="display: block;">Articles Analytics</h3>
            <div class="box-body">
                Article Publish Date <input type="date" id="filter-date" class="form-control"
                    style="width: 200px; margin-bottom: 10px;">
                Article Publish Date <input type="date" id="filter-date-end" class="form-control"
                    style="width: 200px; margin-bottom: 10px;">

                <div class="table-responsive data-table-wrapper">
                    <table id="publish-table" class="table table-condensed table-hover table-bordered">
                        <thead>
                            <tr>
                                <th>Article Id</th>
                                <th>Title</th>
                                <th>Author</th>
                                <th>Category</th>
                                <th>URL</th>
                                <th>Number Hits</th>
                                <th>Active Users</th>
                                <th>Updated At</th>
                                <th>Publish Date</th>
                            </tr>
                        </thead>
                        <thead class="transparent-bg">
                            <tr>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                            </tr>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('after-scripts')
    {{-- For DataTables --}}
    <script src="https://storage.googleapis.com/e4m-news-photo/news-photo/cms-js/dataTable.js"></script>

    <script>
        //Below written line is short form of writing $(document).ready(function() { })
        $(function() {
            var dataTable = $('#publish-table').DataTable({
                processing: true,
                serverSide: true,
                "iDisplayLength": 10,
                ajax: {
                    url: '{{ route('admin.articles.getanalyticsdetailsbydate') }}',
                    type: 'POST',
                    data: function(d) {
                        d.filter_date = $('#filter-date').val() || null;
                        d.filter_date_end = $('#filter-date-end').val() || null;
                        console.log("Sending date filter:", d.filter_date, d
                            .filter_date_end); // Debugging
                    }
                },
                columns: [{
                        data: 'article_id',
                        name: 'ga.article_id' // ✅ Use correct table alias
                    },
                    {
                        data: 'title',
                        name: 'articles.title'
                    },
                    {
                        data: 'authorname',
                        name: 'articles.authorname'
                    },
                    {
                        data: 'category_name',
                        name: 'articles.category_name'
                    },
                    {
                        data: 'url',
                        name: 'articles.url'
                    },
                    {
                        data: 'number_hits',
                        name: 'tbl_google_analytics.number_hits'
                    },
                    {
                        data: 'active_users',
                        name: 'tbl_google_analytics.active_users'
                    },
                    {
                        data: 'updated_at',
                        name: 'tbl_google_analytics.updated_at'
                    },
                    {
                        data: 'publish_date',
                        name: 'publish_date'
                    }
                ],

                columnDefs: [{
                        orderable: true,
                        targets: [6]
                    } // ✅ Ensure sorting is enabled on "Number Hits"
                ],
                searchDelay: 500
            });

            // Reload table when date changes
            $('#filter-date').on('change', function() {
                console.log("Date changed:", $(this).val()); // Debugging line
                dataTable.ajax.reload();
            });
            $('#filter-date-end').on('change', function() {
                console.log("Date changed:", $(this).val()); // Debugging line
                dataTable.ajax.reload();
            });
        });
    </script>

@endsection