@extends('company.layout.content')

@section('customTitle')
{{ __('company.Reports.menu.Reservations Reports') }}
@endsection

@section('customStyle')
<link href='{{ asset("company/$locale/assets/css/elements/alert.css") }}' rel="stylesheet" type="text/css" />
<link href='{{ asset("company/$locale/plugins/table/datatable/custom_dt_html5.css") }}' rel="stylesheet" type="text/css" />
<link href='{{ asset("company/$locale/plugins/flatpickr/flatpickr.css") }}' rel="stylesheet" type="text/css" />
<link href='{{ asset("company/$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">{{ __('company.Reports.menu.Reservations 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">{{ __('company.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">{{ __('company.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">{{ __('company.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">{{ __('company.Between Two Dates') }}</label>
                                            <input id="betweenTwoDatesFilter" class="form-control " placeholder="{{ __('company.Between Two Dates') }}">
                                        </div>
                                    </div>

                                    <div class="form-row">
                                        @if ($branches)
                                        <div class="form-group col-md mb-0">
                                            <label for="branchFilter">{{ __('company.Reports.fields.Branch') }}</label>
                                            <select id="branchFilter" class="form-control basic">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                @foreach ($branches as $branch)
                                                <option value="{{ $branch->id }}">{{ $branch->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        @endif

                                        <div class="form-group col-md mb-0">
                                            <label for="categoryFilter">{{ __('company.Reports.fields.Category') }}</label>
                                            <select id="categoryFilter" class="form-control basic">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                @foreach ($categories as $category)
                                                <option value="{{ $category->id }}">{{ $category->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>

                                        <div class="form-group col-md mb-0">
                                            <label for="userGenderFilter">{{ __('company.contracts for') }}</label>
                                            <select id="userGenderFilter" class="form-control basic">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                <option value="male">{{ __("company.male customers") }}</option>
                                                <option value="female">{{ __("company.female customers") }}</option>
                                            </select>
                                        </div>

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

                                        <div class="form-group col-md mb-0">
                                            <label for="statusFilter">{{ __('validation.attributes.status') }}</label>
                                            <select id="statusFilter" class="form-control basic">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                                <option value="confirmed">{{ __("company.Reservations.fields.confirmed") }}</option>
                                                <option value="canceled">{{ __("company.Reservations.fields.canceled") }}</option>
                                                <option value="finished">{{ __("company.Reservations.fields.finished") }}</option>
                                            </select>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>

                        <table id="reservationsTable" class="table table-hover dataTable text-center">
                            <thead>
                                <tr>
                                    <th>{{ __('validation.attributes.code') }}</th>
                                    <th>{{ __('validation.attributes.car_code') }}</th>
                                    <th>{{ __('validation.attributes.car') }}</th>
                                    <th>{{ __('validation.attributes.username') }}</th>
                                    <th>{{ __('validation.attributes.start_date') }}</th>
                                    <th>{{ __('validation.attributes.end_date') }}</th>
                                    <th>{{ __('validation.attributes.number_of_days') }}</th>
                                    <th>{{ __('validation.attributes.base_price') }}</th>
                                    <th>{{ __('validation.attributes.total_services_price') }}</th>
                                    <th>{{ __('validation.attributes.discount_amount') }}</th>
                                    <th>{{ __('validation.attributes.total_amount') }}</th>
                                    <th>{{ __('validation.attributes.status') }}</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr>
                                    <th>{{ __('validation.attributes.code') }}</th>
                                    <th>{{ __('validation.attributes.car_code') }}</th>
                                    <th>{{ __('validation.attributes.car') }}</th>
                                    <th>{{ __('validation.attributes.username') }}</th>
                                    <th>{{ __('validation.attributes.start_date') }}</th>
                                    <th>{{ __('validation.attributes.end_date') }}</th>
                                    <th>{{ __('validation.attributes.number_of_days') }}</th>
                                    <th>{{ __('validation.attributes.base_price') }}</th>
                                    <th>{{ __('validation.attributes.total_services_price') }}</th>
                                    <th>{{ __('validation.attributes.discount_amount') }}</th>
                                    <th>{{ __('validation.attributes.total_amount') }}</th>
                                    <th>{{ __('validation.attributes.status') }}</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('customScript')

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

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

<script>
    var reservationsTable = initializeDataTable("#reservationsTable",{
        columns : [
            {data: "code"},
            {data: "car_code"},
            {data: "car",searchable: false,orderable: false},
            {data: "user",searchable: false,orderable: false},
            {data: "start_date"},
            {data: "end_date"},
            {data: "days_number"},
            {data: "final_price"},
            {data: "total_services_price"},
            {data: "discount_amount"},
            {data: "total_price_with_tax"},
            {data: "status"},
            {data: "plate",  visible: false},
            {data: "user",name:'name'  ,visible: false},
            {data: "user",name:'user.name'  ,visible: false},
            {data: "user",name:'mobile'  ,visible: false},
            {data: "user",name:'user.mobile'  ,visible: false},
            {data: "user",name:'user.identification_number'  ,visible: false},
            {data: "user",name:'user.email'  ,visible: false},
            {data: "user",name:'user.driver_license_number'  ,visible: false},
        ],
        buttons: {
            buttons: [{
                    extend: 'excel',
                    className: 'btn btn-sm',
                    exportOptions: {
                        columns: [0, 1, 2, 3, 4, 5, 6, 7]
                    }
                },
                {
                    extend: 'print',
                    className: 'btn btn-sm',
                    exportOptions: {
                        columns: [0, 1, 2, 3, 4, 5, 6, 7]
                    }
                }
            ]
        },

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

    $("#yearFilter,#monthFilter,#dayFilter,#branchFilter,#categoryFilter,#userGenderFilter,#userFilter,#statusFilter").on("change",function(){
        reloadDataTable(reservationsTable,{
            year: $("#yearFilter").val(),
            month: $("#monthFilter").val(),
            day: $("#dayFilter").val(),
            branch: $("#branchFilter").val(),
            category: $("#categoryFilter").val(),
            gender: $("#userGenderFilter").val(),
            user: $("#userFilter").val(),
            status: $("#statusFilter").val(),
        });
    });

    


    $("#betweenTwoDatesFilter").flatpickr({
        mode: "range",
        maxDate: "today",
        locale: {
            rangeSeparator: " -- "
        },
        onChange: function (selectedDates, dateStr) {
            reloadDataTable(reservationsTable, {
                dateRange: dateStr,
            });
        }
    });
    ajaxSelect2('#userFilter','/company/select2/usersInCompany',{
        withAll: true
    })

</script>
@endsection