@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.read_year_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.read_year_report')</h4>
                <p id="total" style="float: left;font-size: 27px;
    color: red;"></p>
            </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-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="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-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="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-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">
                    <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>
        // $.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($.number(total , 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