@extends('admin.layout.master')
@push('css')

    <link rel="stylesheet"
          href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datetimepicker/4.7.14/css/bootstrap-datetimepicker.min.css">
    <style>

        table.table-bordered.dataTable th:last-child, table.table-bordered.dataTable td:last-child {
            border-right-width: 1px;
        }

        .input-group-btn {
            top: 13px;
        }
    </style>

@endpush
@section('content')
    <main id="app-main" class="app-main">

    <div class="wrap">
        <section class="app-content">
            <h3>@lang('admin.products_report')</h3>
        </section><!-- #dash-content -->
    </div><!-- .wrap -->

    <div class="col-md-12">
        <div class="widget">
            <header class="widget-header">
                <h4 class="widget-title">@lang('admin.products_report')</h4>
            </header><!-- .widget-header -->
            <hr class="widget-separator">
            <div class="widget-body">
                <div class="row">
                    <form action="{{ route('products_report_print') }}" method="get" id="print_form" target="_blank">
                        @csrf
                    </form>
                    <div class="col-md-3" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">

                        <div class="form-group">
                            <div class="input-group date" id="datetimepicker1">
                                <label for="from_date">@lang('admin.from_date')</label>
                                <input type="text" form="print_form" class="form-control" id="from_date"
                                       name="from_date"
                                       value="">
                                <span class="input-group-btn">
                                        <button class="btn btn-default" type="button"><i
                                                class="fa fa-calendar"></i></button>
                                    </span>
                            </div>
                        </div>
                    </div>

                    <div class="col-md-3" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">

                        <div class="form-group">
                            <div class="input-group date" id="datetimepicker2">
                                <label for="to_date">@lang('admin.to_date')</label>
                                <input type="text" form="print_form" class="form-control" id="to_date" name="to_date"
                                       value="">
                                <span class="input-group-btn">
                                        <button class="btn btn-default" type="button"><i
                                                class="fa fa-calendar"></i></button>
                                    </span>
                            </div>
                        </div>
                    </div>

                    <div class="col-md-3" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <div class="form-group">
                            <label for="shipping_type">@lang('admin.shipping_type')</label>
                            <select name="shipping_type" form="print_form" class="form-control" id="shipping_type">
                                <option value="">@lang('admin.all')</option>
                                @foreach ($shippingTypes as $shippingType)
                                    <option value="{{ $shippingType->id }}">{{ $shippingType->name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-md-3" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <div class="form-group">
                            <label for="company_id">@lang('admin.company')</label>
                            <select name="company_id" form="print_form" class="form-control" id="company_id">
                                <option value="">@lang('admin.all')</option>
                                @foreach ($companies as $company)
                                    <option value="{{ $company->id }}">{{ $company->name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row">

                    @php

                        $order_status = ['wait','refused','accepted','shipped','complete'];

                    @endphp

                    <div class="col-md-2" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <div class="form-group">
                            <label for="status">@lang('admin.status')</label>
                            <select name="status" form="print_form" class="form-control" id="status">
                                <option value="">@lang('admin.all')</option>
                                @foreach ($order_status as $status)
                                    <option value="{{ $status }}">{{ $status }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-md-2" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <div class="form-group">
                            <label for="status">@lang('admin.choose_status_product')</label>
                            <select class="form-control select2 status_product" form="print_form" id="status_product" name="status_product">
                                <option value=" ">@lang('admin.choose_status_product')</option>
                                <option value='1'>@lang('admin.processing')</option>
                                <option value="2">@lang('admin.to_get_ready')</option>
                                <option value="3">@lang('admin.ongoing_delivery')</option>
                                <option value="4">@lang('admin.Deliverd')</option>
                                <option value="5">@lang('admin.canceled_after_processing')</option>
                                <option value="6">@lang('admin.canceled_after_ready')</option>
                                <option value="7">@lang('admin.returned')</option>
                                <option value="8">@lang('admin.failed')</option>
                                <option value="9">@lang('admin.refused')</option>
                                <option value="10">@lang('admin.cancel_from_admin')</option>
                            </select>
                        </div>
                    </div>

                    <div class="col-md-2" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <div class="form-group">
                            <label for="payment_type">@lang('admin.payment_type')</label>
                            <select name="payment_type" form="print_form" class="form-control" id="payment_type">
                                <option value="">@lang('admin.all')</option>
                                @foreach ($paymentTypes as $type)
                                    <option value="{{ $type->id }}">{{ $type->name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>

                    <div class="col-md-1" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <div class="form-group">
                            <button type="button" id="btnFiterSubmitSearch"
                                    class="btn btn-info"
                                    style="margin-top: 25px; float: {{ app()->getLocale() == 'ar' ? 'left' : '' }}">@lang('admin.filter')</button>
                        </div>
                    </div>

                    <div class="col-md-2" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <a class="btn btn-primary top-block" style="margin-top: 15px" href="javascript:void(0)">
                            <div>@lang('admin.total_sales')</div>
                            <div id="total">0</div>
                        </a>
                    </div>

                    <div class="col-md-2" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <button type="submit" class="btn btn-success" name="print" value="refund" form="print_form"
                                style="margin-top: 15px"
                                href="javascript:void(0)">
                            <i class="fa fa-print"></i>
                            <span>@lang('admin.refund_request_print')</span>
                        </button>
                    </div>

                    <div class="col-md-2" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">
                        <button type="submit" class="btn btn-success" name="print" value="supply" form="print_form"
                                style="margin-top: 15px"
                                href="javascript:void(0)">
                            <i class="fa fa-print"></i>
                            <span>@lang('admin.supply_request_print')</span>
                        </button>
                    </div>
                </div>
                <div class="table-responsive">
                    <div id="default-datatable_wrapper" class="dataTables_wrapper form-inline dt-bootstrap">
                        <div class="row">
                            <div class="col-md-12">
                                <div>
                                    <div class="col-md-12">
                                        <div class="widget">

                                            <div class="widget-body">
                                                <table id="products_report" class="table table-striped table-bordered"
                                                       style="width:100%">
                                                </table>
                                            </div>
                                        </div><!-- .widget-body -->
                                    </div><!-- .widget -->
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    </main>
@endsection

@push('js')
    <script>
        $('#datetimepicker1').datetimepicker();
        $('#datetimepicker2').datetimepicker();

        $('#btnFiterSubmitSearch').click(function () {
            $('#products_report').DataTable().draw(true);
        });

        $(document).ready(function () {
            var table = $('#products_report').DataTable({
                responsive: true,
                processing: true,
                serverSide: true,
                autoWidth: false,
                ajax: {
                    url: "{{ route('products_report') }}",
                    type: 'GET',
                    data: function (d) {
                        d.from_date = $('#from_date').val();
                        d.to_date = $('#to_date').val();
                        d.shipping_type = $('#shipping_type').val();
                        d.company_id = $('#company_id').val();
                        d.status = $('#status').val();
                        d.payment_type = $('#payment_type').val();
                        d.status_product = $('#status_product').val();
                    }
                },
                columns: [
                    {data: 'id', name: 'id', title: 'id'},
                    {data: 'image', name: 'image', title: "@lang('admin.image')"},
                    {data: 'name', name: 'name', title: "@lang('admin.name')"},
                    {data: 'orderNumber', name: 'orderNumber', title: "@lang('admin.orderNumber')"},
                    {data: 'company', name: 'company', title: "@lang('admin.company')"},
                    {data: 'status', name: 'status', title: "@lang('admin.status')"},
                    {data: 'status_product', name: 'status_product', title: "@lang('admin.choose_status_product')"},
                    {data: 'date', name: 'date', title: "@lang('admin.order_date')"},
                    {data: 'phone', name: 'phone', title: "@lang('admin.phone')"},
                    {data: 'price', name: 'price', title: "@lang('admin.price')"},
                    {data: 'quantity', name: 'quantity', title: "@lang('admin.quantity')"},
                    {data: 'total', name: 'total', title: "@lang('admin.total')"},
                ],
                footerCallback: function (tfoot, data, start, end, display) {
                    var api = this.api();
                    // var api = this.api(), data;
                    //
                    // // Remove the formatting to get integer data for summation
                    // var intVal = function ( i ) {
                    //     return typeof i === 'string' ?
                    //         i.replace(/[\$,]/g, '')*1 :
                    //         typeof i === 'number' ?
                    //             i : 0;
                    // };
                    // total = api
                    //     .column( 10 )
                    //     .data()
                    //     .reduce( function (a, b) {
                    //         return intVal(a) + intVal(b);
                    //     }, 0 );
                    // $('#total').html(total);

                    this.api().columns(10).every(function () {
                        var column = this;

                        var sum = column
                            .data()
                            .reduce(function (a, b) {
                                var x = parseFloat(a) || 0;
                                var y = parseFloat(b) || 0;
                                return x + y;
                            }, 0);
                        $('#total').html(sum);
                    });
                }
            });
        });
    </script>


@endpush