@extends('layouts.master')

@section('page_title','Courier Summary Report')
@section('title','Courier Summary Report')
@section('main_item','Courier Summary Report')
@section('sub_item','Courier Summary Report')

@section('content')
    <style>
        div.dt-buttons{
            position:relative;
            float:right;
        }
        div.dataTables_filter{
            margin-top: 7px
        }
    </style>
<div class="col-12">
        <div class="card">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-3">
                        <div class="form-group">
                            <label style="font-weight: bold" for="supplier">Date Range</label>
                            <div class="input-group">
                                <input type="text" class="form-control" name="dates-d" id="reportrange" readonly>
                                <div class="input-group-append">
                                    <span class="input-group-text"><i class="dripicons-calendar"></i></span>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-md-4">
                        <div class="form-group">
                            <label style="font-weight: bold" for="courier">Select courier</label>
                            <select class="form-control select2" id="courier" name="courier">
                                <option value="all">All</option>
                                @foreach ($couriers as $courier)
                                    <option value="{{$courier->id}}">{{$courier->name}}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                </div>
            </div>
           
        </div>
       
    </div>

<div class="col-md-12">
    <div class="card">
        <div class="card-body">
                <div class="table-responsive dash-social">
                        <table id="laravel_datatable" class="table table-hover">
                            <thead class="thead-dark">
                                <tr>
                                    <th>Courier Name</th>
                                    <th>Net Total</th>
                                    <th>Direct Payment</th>
                                    <th>Courier Cost</th>
                                    <th>Courier Balance</th>
                                    <th>Courier Paid Amount</th>
                                    <th>Balance</th>
                                </tr>
                           
                            </thead>
                            <tbody>
                            </tbody>
                            <tfoot>
                                <tr>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                    <th></th>
                                </tr>
                                </tfoot>
                        </table>
                    </div>
        </div>
        <!--end card-body-->
    </div>
    <!--end card-->
</div>

@endsection

@section('scripts')

<script>


        $(document).ready(function () {
            $('#reportrange').val('');
            let table = $('#laravel_datatable').DataTable({
                lengthMenu: [
                    [25, 50, 100 ,-1],
                    ['25 ', '50 ', '100' ,'All']
                ],
                dom: 'Blfrtip',
                buttons: [
                    'copy', 'csv', 'excel', 'pdf', 'print'
                ],
                processing: true,
                serverSide: true,
                ajax: {

                    url: "{{ url('reports/courier-summary-report')  }}",
                    data: function (d) {
                        d.range = $('#reportrange').val();
                        d.courier = $('#courier').val();
                    }

                },
                columnDefs: [{
                    "targets": [0],
                    "orderable": false,
                    "searchable": false,

                }],
                "fnDrawCallback": function (oSettings) {
                    $.fn.tooltip && $('[data-toggle="tooltip"]').tooltip()
                },
                "footerCallback": function (row, data, start, end, display) {
                    var api = this.api(), data;
                   
                    var intVal = function (i) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '') * 1 :
                            typeof i === 'number' ?
                                i : 0;
                    };

                    
                    let net_total = api.column(1).data().reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                  
                    let total_courier_amount = api.column(3).data().reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                     let total_direct_amount = api.column(2).data().reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                    
                    let total_courier_balance_payment = api.column(4).data().reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                  
                    let total_courier_paid_amount = api.column(5).data().reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                   
                    let total_courier_balance = api.column(6).data().reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);

                    $(api.column(1).footer()).html(numFormat(net_total));
                    $(api.column(2).footer()).html(numFormat(total_direct_amount));
                    $(api.column(3).footer()).html(numFormat(total_courier_amount));
                    $(api.column(4).footer()).html(numFormat(total_courier_balance_payment));
                    $(api.column(5).footer()).html(numFormat(total_courier_paid_amount));
                    $(api.column(6).footer()).html(numFormat(total_courier_balance));

                }
                ,
                columns: [{
                        data: 'name',
                        name: 'name'
                    },
                    {
                        data: 'net_total',
                        name: 'net_total'
                    },
                    {
                        data: 'direct_payment',
                        name: 'direct_payment'
                    },
                    {
                        data: 'total_courier_amount',
                        name: 'total_courier_amount'
                    },
                    {
                        data: 'total_courier_balance_payment',
                        name: 'total_courier_balance_payment'
                    },
                    {
                        data: 'total_courier_paid_amount',
                        name: 'total_courier_paid_amount'
                    },
                    {
                        data: 'total_courier_balance',
                        name: 'total_courier_balance'
                    },
                ]
            });

            let numFormat = $.fn.dataTable.render.number( '\,', '.', 2, '' ).display;
        $(document).on('change','#reportrange , #courier', function () {
               table.ajax.reload();
           });

        });
    </script>

@endsection