@extends('dashboard.layout.content')

@section('customTitle')
{{ __('dashboard.Menu.Users Reports') }}
@endsection

@section('customStyle')
<link href='{{ asset("dashboard/$locale/assets/css/elements/alert.css") }}' rel="stylesheet" type="text/css" />
<link href='{{ asset("dashboard/$locale/plugins/table/datatable/custom_dt_html5.css") }}' rel="stylesheet" type="text/css" />
<link href='{{ asset("dashboard/$locale/plugins/flatpickr/flatpickr.css") }}' rel="stylesheet" type="text/css" />
<link href='{{ asset("dashboard/$locale/plugins/flatpickr/custom-flatpickr.css") }}' rel="stylesheet" type="text/css" />
@endsection

@section('customBody')
<div id="content" class="main-content">
    <div class="layout-px-spacing">
        <div class="row layout-top-spacing">
            <div class="col-12 layout-spacing">
                <div class="widget-content widget-content-area br-6">
                    <div class="widget-header">
                        <div class="row">
                            <div class="col-12">
                                <h4 class="text-center">{{ __('dashboard.Menu.Users Reports') }}</h4>
                            </div>
                        </div>
                    </div>
                    <div class="table-responsive">
                        <div class="filter-container">
                            <button class="btn btn-primary filter-button"> <i class="fas fa-filter"></i></button>
                            <div class="filters-inputs" style="display:block">
                                <form>
                                    <div class="form-row">
                                        <div class="form-group col-md-3 mb-0">
                                            <label for="yearFilter">{{ __('dashboard.During Year') }}</label>
                                            <select class="form-control basic " id="yearFilter">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                @foreach (range(2021,date("Y")) as $year)
                                                <option value="{{ $year }}">{{$year}}</option>
                                                @endforeach
                                            </select>
                                        </div>

                                        <div class="form-group col-md-3 mb-0">
                                            <label for="monthFilter">{{ __('dashboard.During Month') }}</label>
                                            <select class="form-control basic" id="monthFilter">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                @foreach (range(1,12) as $month)
                                                <option value="{{ $month }}">{{$month}}</option>
                                                @endforeach
                                            </select>
                                        </div>

                                        <div class="form-group col-md-3 mb-0">
                                            <label for="dayFilter">{{ __('dashboard.During Day') }}</label>
                                            <select class="form-control basic" id="dayFilter">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                @foreach (range(1,31) as $day)
                                                <option value="{{ $day }}">{{$day}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="form-group col-md-3 mb-0">
                                            <label for="betweenTwoDatesFilter">{{ __('dashboard.Between Two Dates') }}</label>
                                            <input id="betweenTwoDatesFilter" class="form-control " placeholder="{{ __('dashboard.Between Two Dates') }}">
                                        </div>

                                    </div>

                                    <div class="form-row">
                                        <div class="form-group col-md-3 mb-0">
                                            <label for="companyFilter">{{ __('validation.attributes.company') }}</label>
                                            <select id="companyFilter" class="form-control basic">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                            </select>
                                        </div>

                                        <div class="form-group col-md-3 mb-0">
                                            <label for="genderFilter">{{ __('validation.attributes.gender') }}</label>
                                            <select id="genderFilter" class="form-control basic">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                <option value="male">{{ __('validation.attributes.male') }}</option>
                                                <option value="female">{{ __('validation.attributes.female') }}</option>
                                            </select>
                                        </div>

                                        <div class="form-group col-md-3 mb-0">
                                            <label for="underAgedFilter">{{ __('validation.attributes.under_aged') }}</label>
                                            <select id="underAgedFilter" class="form-control basic">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                <option value="1">{{ __("general.yes") }}</option>
                                                <option value="0">{{ __("general.no") }}</option>
                                            </select>
                                        </div>

                                        <div class="form-group col-md-3 mb-0">
                                            <label for="deviceTypeFilter">{{ __('validation.attributes.device_type') }}</label>
                                            <select id="deviceTypeFilter" class="form-control basic">
                                                <option value="" selected>{{ __('dashboard.all') }}</option>
                                                <option value="ios">{{ __('general.ios') }}</option>
                                                <option value="android">{{ __('general.android') }}</option>
                                            </select>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>

                        <table id="usersTable" class="table table-hover dataTable text-center">
                            <thead>
                                <tr>
                                    <th>{{ __('validation.attributes.identification_number') }}</th>
                                    <th>{{ __('dashboard.Customer Name') }}</th>
                                    <th>{{ __('validation.attributes.mobile') }}</th>
                                    <th>{{ __('validation.attributes.country') }}</th>
                                    <th>{{ __('validation.attributes.city') }}</th>
                                    <th>{{ __('validation.attributes.age') }}</th>
                                    <th>{{ __('general.reservations_count') }}</th>
                                    <th>{{ __('validation.attributes.device_type') }}</th>
                                </tr>
                            </thead>

                            <tfoot>
                                <tr>
                                    <th>{{ __('validation.attributes.identification_number') }}</th>
                                    <th>{{ __('dashboard.Customer Name') }}</th>
                                    <th>{{ __('validation.attributes.mobile') }}</th>
                                    <th>{{ __('validation.attributes.country') }}</th>
                                    <th>{{ __('validation.attributes.city') }}</th>
                                    <th>{{ __('validation.attributes.age') }}</th>
                                    <th>{{ __('general.reservations_count') }}</th>
                                    <th>{{ __('validation.attributes.device_type') }}</th>
                                </tr>
                            </tfoot>
                        </table>

                        <table id="citiesTable" class="table table-hover dataTable text-center">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>{{ __('validation.attributes.city') }}</th>
                                    <th>{{ __('general.customers_count') }}</th>
                                    <th>{{ __('validation.attributes.has_cars') }}</th>
                                </tr>
                            </thead>

                            <tfoot>
                                <tr>
                                    <th>#</th>
                                    <th>{{ __('validation.attributes.city') }}</th>
                                    <th>{{ __('general.customers_count') }}</th>
                                    <th>{{ __('validation.attributes.has_cars') }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('customScript')

<script src='{{ asset("dashboard/$locale/plugins/flatpickr/flatpickr.js") }}'></script>
<script src='{{ asset("dashboard/$locale/plugins/flatpickr/custom-flatpickr.js") }}'></script>
<script src='{{ asset("dashboard/$locale/plugins/table/datatable/button-ext/dataTables.buttons.min.js") }}'></script>
<script src='{{ asset("dashboard/$locale/plugins/table/datatable/button-ext/jszip.min.js") }}'></script>
<script src='{{ asset("dashboard/$locale/plugins/table/datatable/button-ext/buttons.html5.min.js") }}'></script>
<script src='{{ asset("dashboard/$locale/plugins/table/datatable/button-ext/buttons.print.min.js") }}'></script>

<script>
    $("#reports-menu-box").attr("data-active", "true");
</script>

<script>
    var usersTable = initializeDataTable("#usersTable", {
        columns: [{
                data: "identification_number"
            },
            {
                data: "name"
            },
            {
                data: "mobile",
                className: "ltr"
            },
            {
                data: "country",
                searchable: false,
                orderable: false,
            },
            {
                data: "city",
                searchable: false,
                orderable: false,
            },
            {
                data: "age",
                searchable: false,
                orderable: false,
            },
            {
                data: "reservations_count",
                searchable: false,
                orderable: false,
            },
            {
                data: "device_type",
                searchable: false,
                orderable: false,
            }
        ],

        subPlace: "users_table",

        buttons: {
            buttons: [{
                    extend: 'excel',
                    className: 'btn btn-sm',
                    exportOptions: {
                        columns: [0, 1, 2, 3, 4, 5, 6]
                    }
                },
                {
                    extend: 'print',
                    className: 'btn btn-sm',
                    exportOptions: {
                        columns: [0, 1, 2, 3, 4, 5, 6]
                    }
                }
            ]
        },

        dom: "<'dt--top-section'<'row'<'col-12 col-sm-4 d-flex justify-content-sm-start justify-content-center'l><'col-12 col-sm-4 d-flex justify-content-center 'B><'col-12 col-sm-4 d-flex justify-content-sm-end justify-content-center mt-sm-0 mt-3'f>>>" +
            "<'table-responsive'tr>" +
            "<'dt--bottom-section d-sm-flex justify-content-sm-between text-center'<'dt--pages-count  mb-sm-0 mb-3'i><'dt--pagination'p>>",
    },
    {
        subPlace: "users_table",
    });

    var citiesTable = initializeDataTable("#citiesTable", {
        columns: [
            {data: 'DT_RowIndex', orderable: false, searchable: false },
            {data: "city"},
            {data: "customers_count"},
            { data: "has_cars", }
        ],
        buttons: {
            buttons: [{
                    extend: 'excel',
                    className: 'btn btn-sm',
                    exportOptions: {
                        columns: [0, 1, 2]
                    }
                },
                {
                    extend: 'print',
                    className: 'btn btn-sm',
                    exportOptions: {
                        columns: [0, 1, 2]
                    }
                }
            ]
        },

        dom: "<'dt--top-section'<'row'<'col-12 col-sm-4 d-flex justify-content-sm-start justify-content-center'l><'col-12 col-sm-4 d-flex justify-content-center 'B><'col-12 col-sm-4 d-flex justify-content-sm-end justify-content-center mt-sm-0 mt-3'f>>>" +
            "<'table-responsive'tr>" +
            "<'dt--bottom-section d-sm-flex justify-content-sm-between text-center'<'dt--pages-count  mb-sm-0 mb-3'i><'dt--pagination'p>>",
    },
    {
        subPlace: "cities_table",
    });


    $("#yearFilter,#monthFilter,#dayFilter,#companyFilter,#genderFilter,#underAgedFilter,#sortFilter,#deviceTypeFilter").on("change", function () {
        reloadDataTable(usersTable, {
            year: $("#yearFilter").val(),
            month: $("#monthFilter").val(),
            day: $("#dayFilter").val(),
            company: $("#companyFilter").val(),
            gender: $("#genderFilter").val(),
            under_aged_filter: $("#underAgedFilter").val(),
            sort: $("#sortFilter").val(),
            device_type_filter: $("#deviceTypeFilter").val(),
        });

        reloadDataTable(citiesTable, {
            year: $("#yearFilter").val(),
            month: $("#monthFilter").val(),
            day: $("#dayFilter").val(),
            company: $("#companyFilter").val(),
            gender: $("#genderFilter").val(),
            under_aged_filter: $("#underAgedFilter").val(),
            sort: $("#sortFilter").val(),
            device_type_filter: $("#deviceTypeFilter").val(),
        });
    });

    $("#betweenTwoDatesFilter").flatpickr({
        mode: "range",
        maxDate: "today",
        locale: {
            rangeSeparator: " -- "
        },
        onChange: function (selectedDates, dateStr) {
            reloadDataTable(usersTable, {
                dateRange: dateStr,
            });

            reloadDataTable(citiesTable, {
                dateRange: dateStr,
            });
        }
    });

    ajaxSelect2('#companyFilter','/dashboard/select2/companies',{
        withAll : true
    });

</script>
@endsection