@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')




    <div class="content-body">
        <!-- Column selectors with Export Options and print table -->
        <section id="column-selectors">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                        </div>
                        <div class="card-content">
                            <div class="card-body card-dashboard">

                                <div class="table-responsive">

                                    <div class="widget-body">
                                        <div class="text-danger">
                                            <div>@lang('admin.total_sales') :
                                                <span id="total">0</span>
                                            </div>
                                        </div>

                                        <div class="text-danger">
                                            <div>@lang('admin.order_moadal') :
                                                <span id="order_moadal">0</span>
                                            </div>
                                        </div>
                                        <div class="row">
                                            <form action="{{ route('products_report_print') }}" method="get" id="print_form" target="_blank">
                                                @csrf
                                            </form>
                                            <div class="col-md-5" style="float: {{ app()->getLocale() == 'ar' ? 'right' : 'left' }}">

                                                <div class="form-group">
                                                    <div class="input-group date" id="datetimepicker1">
                                                        <label for="from_date">@lang('admin.year')</label>
                                                        <input type="date" form="print_form" class="form-control" id="from_date"
                                                               name="from_date"
                                                               value="">
                                                    </div>
                                                </div>
                                            </div>

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

                                                <div class="form-group">
                                                    <div class="input-group date" id="datetimepicker2">
                                                        <label for="to_date">@lang('admin.month')</label>
                                                        <input type="date" form="print_form" class="form-control" id="to_date" name="to_date"
                                                               value="">

                                                    </div>
                                                </div>
                                            </div>

                                            <div class="col-md-2" >
                                                <button type="button" id="btnFiterSubmitSearch" class="btn btn-info" style="margin-top: 25px; float: left">@lang('admin.filter')</button>
                                            </div>
                                        </div>

                                        <div class="table-responsive">
                                                <table id="products_report" class="table table-striped table-bordered" style="width:100%">
                                                </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!-- Column selectors with Export Options and print table -->

    </div>




@endsection

@push('js')
    <script>
        // $.datetimepicker.setLocale('ar');
        // $('#datetimepicker1').datetimepicker({
        //
        //     format: 'Y',
        // });
        // $('#datetimepicker2').datetimepicker({
        //     format:'M',
        // });

        $('#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('read_year_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();
                    }
                },
                columns: [
                    {data: 'year', name: 'year', title: '@lang('admin.year')'},
                    {data: 'month', name: 'month', title: '@lang('admin.month')'},
                    {data: 'quantity', name: 'quantity', title: '@lang('admin.quantity_order')'},
                    {data: 'total_price', name: 'total_price', title: '@lang('admin.total_price')'},

                ],
                footerCallback: function (tfoot, data, start, end, display) {

                    console.log( data );
                    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( 3 )
                        .data()
                        .reduce( function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0 );
                    $('#total').html(total.toFixed(3));

                    // this.api().columns(3).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