@extends('layouts.master')

@section('page_title', 'Profit / Payment Report')
@section('title', 'Profit / Payment Report')
@section('main_item', 'Reports')
@section('sub_item', 'Profit / Payment Report')

@section('content')
    <div class="col-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 show mt-3" aria-labelledby="headingOne" data-parent="#accordion">
            <div class="card-body">
            
                <div class="row">
                    <div class="col-md-4">
                        <label style="font-weight: bold" for="reportrange"> Business Location </label>
                        <div class="input-group">
                            <select class="form-control select2" id="location" name="location">
                                <option value="">All Location</option>
                                @if (Auth::user()->role_id == '1')
                                    @foreach ($users_access_location as $business_location)
                                        @if ($business_location->is_active == '1')
                                            <option value="{{ $business_location->id }}">
                                                {{ $business_location->name }}
                                            </option>
                                        @else
                                        @endif
                                    @endforeach
                                @else
                                    @foreach ($users_access_location as $business_location)
                                        @if ($business_location->is_active == '1')
                                            <option value="{{ $business_location->business_location_id }}">
                                                {{ $business_location->name }}
                                            </option>
                                        @else
                                        @endif
                                    @endforeach
                                @endif
                            </select>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label style="font-weight: bold" for="reportrange"> Date </label>
                            <div class="input-group">
                                <input type="text" class="form-control" name="dates-d" id="reportrange" value=""
                                    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">
                        <label style="font-weight: bold" for="reportrange"> Campaign Name  </label>
                        <div class="input-group">
                            <select class="form-control select2" id="order_batch" name="order_batch">
                                <option value="">All</option>
                                @foreach ($order_batchs as $order_batch)
                                    <option value="{{ $order_batch->id }}">
                                        {{ $order_batch->batch_name }}
                                    </option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
        </div>
    </div>
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <div class="table-responsive dash-social">
                    <table id="laravel_datatable_payment" class="table table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>Business Location</th>
                                <th>Sale Date</th>
                                <th>Paid Date</th>
                                <th>Campaign Batch Id</th>
                                <th>Amount</th>
                                <th>Courier Name</th>
                                <th>Customer Name</th>
                                <th>Payment Method</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                        <tfoot>
                            <tr>
                                <th colspan="3" style="text-align: center"></th>
                                <th style="font-weight: bold">Total Amount</th>
                                <th colspan=""></th>
                            </tr>
                        </tfoot>
                        </tbody>
                    </table>
                </div>
            </div>
            <!--end card-body-->
        </div>
        <!--end card-->
    </div>
    <div id="payment" class="modal fade"></div>
@endsection
@section('scripts')
    <script>
        $(document).ready(function() {
            var report_table = $('#laravel_datatable_payment').DataTable({
                dom: 'Blfrtip',
                lengthMenu: [
                    [25, 50, 100, 500, ],
                    ['25 ', '50 ', '100', '500', ]
                ],
                buttons: [{
                        extend: 'copy',
                        exportOptions: {
                            columns: [0, 1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                    {
                        extend: 'excel',
                        exportOptions: {
                            columns: [0, 1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                    {
                        extend: 'pdf',
                        exportOptions: {
                            columns: [0, 1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                    {
                        extend: 'print',
                        exportOptions: {
                            columns: [0, 1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                ],
                processing: true,
                serverSide: true,
                ajax: {
                    url: "{{ url('/report/sell/payment') }}",
                    data: function(d) {
                        d.location = $('#location').val();
                        d.order_batch = $('#order_batch').val();
                        d.range = $('#reportrange').val();
                    }
                },
                "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 grand_total = api.column(4).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                    $(api.column(4).footer()).html(formatNumber(grand_total) + '.00')
                },
                columnDefs: [{
                    "targets": [01, 03, ],
                    "orderable": false,
                    "searchable": false,
                }],

                columns: [{
                        data: 'location',
                        name: 'location'
                    },
                    {
                        data: 'sale_date',
                        name: 'sale_date'
                    },
                    {
                        data: 'paid_date',
                        name: 'paid_date'
                    },
                    {
                        data: 'order_batch',
                        name: 'order_batch'
                    },
                    {
                        data: 'sale_payments.amount',
                        name: 'sale_payments.amount'
                    },
                    {
                        data: 'couriers.name',
                        name: 'couriers.name'
                    },
                    {
                        data: 'contacts.name',
                        name: 'contacts.name'
                    },
                    {
                        data: 'payment_method',
                        name: 'payment_method'
                    },
                    {
                        data: 'action',
                        name: 'action'
                    },
                ]
            });
            $('[data-toggle="tooltip"]').tooltip()

            function tableReload() {
                report_table.ajax.reload();
            }
            $(document).on('change',
                '#reportrange, #order_batch, #location',
                function() {
                    report_table.ajax.reload();
                });
        });
        $(document).on('click', '#view_payments', function() {
            let href = $(this).data('href');
            $('#payment').load(href, function() {
                $('#payment').modal('show');
            })
        });
    </script>
@endsection