@extends('company.layout.content')

@section('customTitle')
{{ __('company.Reports.menu.Cars 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.Cars 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="brandFilter">{{ __('company.Reports.fields.Brand') }}</label>
                                            <select id="brandFilter" class="form-control ">
                                                <option value="" selected>{{ __('general.all') }}</option>
                                            </select>
                                        </div>

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

                        <table id="carTable" class="table table-hover text-center">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>{{__('company.Reports.fields.Car')}}</th>
                                    <th>{{__('company.Reports.fields.Brand')}}</th>
                                    <th>{{__('company.Reports.fields.Branch')}}</th>
                                    <th>{{__('company.Reports.fields.Daily Price')}}</th>
                                    <th>{{__('company.Reports.fields.Weekly Price')}}</th>
                                    <th>{{__('company.Reports.fields.Monthly Price')}}</th>
                                    <th>{{__('company.Status')}}</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr>
                                    <th>#</th>
                                    <th>{{__('company.Reports.fields.Car')}}</th>
                                    <th>{{__('company.Reports.fields.Brand')}}</th>
                                    <th>{{__('company.Reports.fields.Branch')}}</th>
                                    <th>{{__('company.Reports.fields.Daily Price')}}</th>
                                    <th>{{__('company.Reports.fields.Weekly Price')}}</th>
                                    <th>{{__('company.Reports.fields.Monthly Price')}}</th>
                                    <th>{{__('company.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 carTable = initializeDataTable("#carTable", {
            columns: [{
                    data: "id"
                },
                {
                    data: "car",
                    searchable: false,
                    orderable: false
                },
                {
                    data: "brand",
                    searchable: false,
                    orderable: false
                },
                {
                    data: "branch",
                    searchable: false,
                    orderable: false
                },
                {
                    data: "daily_price",
                },
                {
                    data: "weekly_price",
                },
                {
                    data: "monthly_price",
                },
                {
                    data: "is_active",
                }
            ],
            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,#brandFilter,#modelFilter").on("change", function () {
        reloadDataTable(carTable, {
            year: $("#yearFilter").val(),
            month: $("#monthFilter").val(),
            day: $("#dayFilter").val(),
            branch: $("#branchFilter").val(),
            category: $("#categoryFilter").val(),
            brand: $("#brandFilter").val(),
            model: $("#modelFilter").val(),
        });
    });

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


ajaxSelect2('#brandFilter','/company/select2/brandsInCompany',{
    withAll : true
});
</script>
@endsection