@extends('dashboard.layout.content')

@section('customTitle')
{{ __('dashboard.Menu.General 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.General 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-2 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-2 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-2 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 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 mb-0">
                                            <label for="companyFilter">{{ __('validation.attributes.company') }}</label>
                                            <select id="companyFilter" class="form-control">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                            </select>
                                        </div>

                                        <div class="form-group col-md mb-0">
                                            <label for="sortFilter">{{ __('dashboard.sortBy') }}</label>
                                            <select id="sortFilter" class="form-control basic">
                                                <option value="" selected>{{ __('dashboard.default') }}</option>
                                                <option value="reservations_counts_asc">{{ __('general.reservations_counts_asc') }}</option>
                                                <option value="reservations_counts_desc">{{ __('general.reservations_counts_desc') }}</option>
                                                <option value="contracts_counts_asc">{{ __('dashboard.contracts_counts_asc') }}</option>
                                                <option value="contracts_counts_desc">{{ __('dashboard.contracts_counts_desc') }}</option>
                                                <option value="ratings_avg_asc">{{ __('dashboard.ratings_avg_asc') }}</option>
                                                <option value="ratings_avg_desc">{{ __('dashboard.ratings_avg_desc') }}</option>
                                            </select>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>

                        <table id="branchesTable" class="table table-hover text-center">
                            <thead>
                                <tr>
                                    <th>{{ __('validation.attributes.ar_name') }}</th>
                                    <th>{{ __('validation.attributes.en_name') }}</th>
                                    <th>{{ __('dashboard.contracts_counts') }}</th>
                                    <th>{{ __('general.reservations_counts') }}</th>
                                    <th>{{ __('dashboard.ratings_avg') }}</th>

                                </tr>
                            </thead>

                            <tfoot>
                                <tr>
                                    <th>{{ __('validation.attributes.ar_name') }}</th>
                                    <th>{{ __('validation.attributes.en_name') }}</th>
                                    <th>{{ __('dashboard.contracts_counts') }}</th>
                                    <th>{{ __('general.reservations_counts') }}</th>
                                    <th>{{ __('dashboard.ratings_avg') }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <div class="row layout-top-spacing">
            <div class="col-md-12 layout-spacing widget-content widget-content-area br-6">
                <canvas id="reservationsAndContractsChart" width="100%" height="500"></canvas>
            </div>

            <div class="col-md-12 layout-spacing widget-content widget-content-area br-6">
                <canvas id="RatingChart" width="100%" height="500"></canvas>
            </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 src="https://cdn.jsdelivr.net/npm/chart.js@3.6.0/dist/chart.min.js"></script>

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

</script>
<script>
    var branchesTable = initializeDataTable("#branchesTable", {
        columns: [{
                data: "ar_name",
            },
            {
                data: "en_name",
            },
            {
                data: "contracts_count"
            },
            {
                data: "reservations_count",
            },
            {
                data: "pivot_ratings_avg_value",
            }
        ],
        buttons: {
            buttons: [{
                    extend: 'excel',
                    className: 'btn btn-sm',
                    exportOptions: {
                        columns: [0, 1, 2, 3, 4]
                    }
                },
                {
                    extend: 'print',
                    className: 'btn btn-sm',
                    exportOptions: {
                        columns: [0, 1, 2, 3, 4]
                    }
                }
            ]
        },

        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: "table"
    });

    $("#yearFilter,#monthFilter,#dayFilter,#sortFilter,#companyFilter").on("change", function () {
        reloadDataTable(branchesTable, {
            company: $("#companyFilter").val(),
            year: $("#yearFilter").val(),
            month: $("#monthFilter").val(),
            day: $("#dayFilter").val(),
            sort: $("#sortFilter").val(),
        });

        chartData.year = $("#yearFilter").val();
        chartData.month = $("#monthFilter").val();
        chartData.day = $("#dayFilter").val();
        chartData.company = $("#companyFilter").val();

        if (reservationsAndContractsChart != null) {
            reservationsAndContractsChart.destroy();
        }

        if (ratingChart != null) {
            ratingChart.destroy();
        }

        drawCharts();
    });

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

            if (reservationsAndContractsChart != null) {
                reservationsAndContractsChart.destroy();
            }

            if (ratingChart != null) {
                ratingChart.destroy();
            }

            drawCharts();
        }
    });

    var reservationsAndContractsChart, ratingChart;

    var chartData = {
        dateRange: null,
        year: $("#yearFilter").val(),
        month: $("#monthFilter").val(),
        day: $("#dayFilter").val(),
    };

    function drawCharts() {
        let data = chartData;
        data.subPlace = "chart";
        var reservationsAndContractsContext = document.getElementById('reservationsAndContractsChart');
        var RatingContext = document.getElementById('RatingChart');

        $.ajax({
            url: window.location.href,
            data,
            success: function success(res) {
                reservationsAndContractsChart = new Chart(reservationsAndContractsContext.getContext('2d'), {
                    type: 'line',
                    data: {
                        labels: res.branches,
                        datasets: [{
                                label: "@lang('general.reservations_counts')",
                                data: res.reservations_counts,
                                backgroundColor: "#8e44ad",
                                borderColor: "#9b59b6",
                                borderWidth: 1
                            },
                            {
                                label: "@lang('general.contracts_counts')",
                                data: res.contracts_counts,
                                backgroundColor: "#7bed9f",
                                borderColor: "#2ed573",
                                borderWidth: 1
                            }

                        ]
                    },
                    options: {
                        plugins: {
                            title: {
                                display: true,
                                text: "@lang('general.contracts_and_reservations_chart')"
                            }
                        },
                        maintainAspectRatio: false
                    }
                });


                ratingChart = new Chart(RatingContext.getContext('2d'), {
                    type: 'bar',
                    data: {
                        labels: res.branches,
                        datasets: [{
                            label: "@lang('general.ratings_avg')",
                            data: res.ratings_avgs,
                            backgroundColor: "#1170EE",
                            borderColor: "#1365EC",
                            borderWidth: 1
                        },
                        {
                            label: "@lang('general.ratings_count')",
                            data: res.ratings_counts,
                            backgroundColor: "#EE8F11",
                            borderColor: "#EC9A13",
                            borderWidth: 1
                        }
                    
                        ]
                    },
                    options: {
                        plugins: {
                            title: {
                                display: true,
                                text: "@lang('general.ratings_chart')"
                            }
                        },
                       
                        maintainAspectRatio: false
                    }
                });
            }
        });
    }

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

</script>
@endsection