@extends('admin.template.master')

@section('title')
    <section class="content-header">
        <h1>
            Customer Discount
        </h1>
        <ol class="breadcrumb">
            <li><a href="{!! url('/dashboard/') !!}"><i class="fa fa-dashboard"></i> Home</a></li>
            <li class="active">Customer Discount</li>
        </ol>
    </section>
@endsection

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

        @if(Session::has('message'))
            <div class="row">
                <div class="col-xs-12">
                    <div class="alert alert-success alert-dismissible">
                        <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                        {{Session('message')}}
                    </div>
                </div>
            </div>
        @endif

        <div class="row">
            <div class="col-xs-12">
                <div class="box">
                    <div class="box-header">
                        <h3 class="box-title">Question Filter</h3>
                    </div>

                    <div class="box-body">
                        <div class="row">
                            <div class="col-md-12">
                                <div class="row">
                                    <div class="input-daterange" id="datepicker">
                                        <div class="form-group col-md-3">
                                            {!! Form::label('from_date', 'From Date') !!}
                                                {!! Form::date('from_date', \Carbon\Carbon::now(), ['class' => 'form-control', 'id' => 'from_date']) !!}
                                        </div>

                                        <div class="form-group col-md-3">
                                                {!! Form::label('to_date', 'To Date') !!}
                                                {!! Form::date('to_date', \Carbon\Carbon::now(), ['class' => 'form-control', 'id' => 'to_date']) !!}
                                        </div>
                                    </div>

                                    <div class="form-group col-md-3">
                                        {!! Form::label('status', 'Status') !!}
                                        <select class="form-control" name="status" id="status">
                                            <option value="">All</option>
                                            <option value="pending">Pending</option>
                                            <option value="approved">Approved</option>
                                            <option value="deny">Reject</option>
                                        </select>
                                    </div>

                                    <div class="form-group col-md-3" style="margin-top:25px">
                                        <button type="button" id="dateSearch" class="btn btn-sm btn-primary btn-order-search">Search</button>
                                    </div>
                                </div>
                            </div>
                        </div>

                    </div>
                </div>

                <div class="box">
                    <div class="box-header">
                        <h3 class="box-title">List</h3>
                    </div>
                    <div class="box-body table-responsive">

                        <table class="table table-hover" id="customer_table">
                            <thead>
                            <tr>
                                <th>#</th>
                                <th>Order No</th>
                                <th>Customer Phone</th>
                                <th>Previous Grand Total</th>
                                <th>Discount Amount</th>
                                <th>New Grand Total</th>
                                <th>Status</th>
                                <th>Created Date</th>
                                <th>Created By</th>
                                <th style="width: 57px;">Action</th>
                            </tr>
                            </thead>
                            <tfoot>
                                <tr>
                                    <th colspan="3" style="text-align:right">Total:</th>
                                    <th id="total_prev_grand_total"></th>
                                    <th id="total_discount_price"></th>
                                    <th id="total_new_grand_total"></th>
                                    <th colspan="4"></th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection

@section('javascripts')
    <script type="text/javascript">
        $(document).ready(function () {
            var oTable = $('#customer_table').DataTable({
                "processing": true,
                "serverSide": true,
                "ajax": {
                    url: "{{ route('get-customer-discount-data') }}",
                    data: function (d) {
                        d.from_date = $('#from_date').val();
                        d.to_date = $('#to_date').val();
                        d.status = $('#status').val();
                    }
                },
                "order": [[0, "desc"]],
                "stateSave": true,
                "columns": [
                    {data: 'id'},
                    {data: 'order_id'},
                    {data: 'customer_id'},
                    {data: 'prev_grand_total'},
                    {data: 'discount_price'},
                    {data: 'new_grand_total'},
                    {data: 'status'},
                    {data: 'created_at'},
                    {data: 'created_by'},
                    {data: 'action', searchable: false, orderable: false}
                ],
                "footerCallback": function (row, data, start, end, display) {
                    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 over all pages for prev_grand_total
                    totalPrevGrandTotal = api
                        .column(3)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Total over all pages for discount_price
                    totalDiscountPrice = api
                        .column(4)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Total over all pages for new_grand_total
                    totalNewGrandTotal = api
                        .column(5)
                        .data()
                        .reduce(function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0);

                    // Update footer with the sums
                    $(api.column(3).footer()).html(totalPrevGrandTotal.toFixed(2));
                    $(api.column(4).footer()).html(totalDiscountPrice.toFixed(2));
                    $(api.column(5).footer()).html(totalNewGrandTotal.toFixed(2));
                }
            });

            $('.btn-order-search').on('click', function() {
                oTable.draw();
            });
        });


    </script>
@endsection