@extends('layouts.master')

@section('page_title', 'Reseller')
@section('title', 'Target User Due Payments')
@section('main_item', 'User Due Payments')
@section('sub_item', ' Target User Due Payments')

@section('content')
    <style>
        div.dt-buttons {
            position: relative;
            float: right;
        }

        div.dataTables_filter {
            margin-top: 7px
        }
    </style>
    <div class="col-md-12">
        <div class="card">
            <div id="accordion">
                <div class="border-bottom card-header" style="background-color: white; cursor: pointer;" data-toggle="collapse"
                    data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                    <h4 class="mb-0 header-title">
                        Filter
                    </h4>
                </div>
                <div id="collapseOne" class="collapse mt-3" aria-labelledby="headingOne" data-parent="#accordion">
                    <div class="card-body">
                        <p class="text-muted mb-3"></p>
                        <div class="row">
                            <div class="col-md-4">
                                <div class="form-group">
                                    <label style="font-weight: bold" for="supplier">Clickom User</label>
                                    <select class="form-control select2" id="clickom_user_id" name="clickom_user_id">
                                        <option value="">All</option>
                                        @foreach ($users as $user)
                                            <option value="{{ $user->id }}">{{ $user->username }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-12">
        <div class="card">
            <div class="card-body">
                <h4 class="header-title mt-0">User Due Payment Details</h4>
                <div class="table-responsive dash-social">
                    <table id="due_payment_laravel_datatable" class="table table-striped">
                        <thead class="thead-dark">
                            <tr>
                                <th>UserName</th>
                                <th>Payment Due</th>
                                <th>Paid Amount</th>
                            </tr>
                        </thead>
                        <tbody>
                        <tfoot>
                            <tr>
                                <th style="font-weight: bold">Total</th>
                                <th></th>
                                <th></th>
                            </tr>
                        </tfoot>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('scripts')
    <script>
        $(document).ready(function() {
            var table = $('#due_payment_laravel_datatable').DataTable({
                dom: 'Blfrtip',
                buttons: [{
                        extend: 'copy',
                        exportOptions: {
                            columns: [0, 1, 2]
                        }
                    },
                    {
                        extend: 'excel',
                        exportOptions: {
                            columns: [0, 1, 2]
                        }
                    },
                    {
                        extend: 'pdf',
                        exportOptions: {
                            columns: [0, 1, 2]
                        }
                    },
                    {
                        extend: 'print',
                        exportOptions: {
                            columns: [0, 1, 2]
                        }
                    },
                ],
                processing: true,
                serverSide: true,
                ajax: {
                    url: "{{ route('reseller.due_payment_list') }}",
                    data: function(d) {
                        d.clickom_user_id = $('#clickom_user_id').val();
                    },
                },
                "fnDrawCallback": function(oSettings) {
                    $.fn.tooltip && $('[data-toggle="tooltip"]').tooltip()
                },
                "footerCallback": function(row, data, start, end, display) {
                    var api = this.api(),
                        data;
                    // converting to interger to find total
                    var intVal = function(i) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '') * 1 :
                            typeof i === 'number' ?
                            i : 0;
                    };
                    let due_amount = api.column(1).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                    $(api.column(1).footer()).html(formatNumber(due_amount) + '.00')
                    var paid_amount = api.column(2).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                    $(api.column(2).footer()).html(formatNumber(paid_amount) + '.00')
                },
                columns: [{
                        data: 'user_id',
                        name: 'user_id'
                    },
                    {
                        data: 'due_amount',
                        name: 'due_amount'
                    },
                    {
                        data: 'paid_amount',
                        name: 'paid_amount'
                    },
                ]
            });
            $(document).on('change', ' #clickom_user_id',
                function() {
                    table.ajax.reload();
                });
        });
    </script>
@endsection