@extends('layouts.master')

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

@section('content')
    <style>
        div.dt-buttons{
            position:relative;
            float:right;
        }
    </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 for="supplier">Customer</label>
                            <select class="form-control select2" id="contact_id" name="contact_id">
                                <option value="">All</option>
                                @foreach ($customers as $customer)
                                    <option value="{{$customer->id}}">{{$customer->name}}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label for="supplier">Order Status</label>
                            <select class="form-control custom-select" id="status" name="contact_id">
                                <option value="">All</option>
                                <option value="dispatched">Dispatched</option>
                                <option value="pending">Pending</option>
                                <option value="returned">Returned</option>
                                <option value="delivered">Delivered</option>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label 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="com-md-3">
                        <div class="form-group">
                            <label for="waybill_id">Waybill No</label>
                            <div class="input-group">
                                <input id="waybill_id" name="waybill_id" type="text" class="form-control"
                                       placeholder="Search for..." aria-label="Search for...">
                                <span class="input-group-append">
                                    <button id="search-waybill" class="btn btn-sm btn-primary"
                                    type="button"><i class="fas fa-search"></i></button>
                                </span>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
           
        </div>
      
    </div>

    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <button id="bulk-modal" type="button" class="btn btn-secondary px-4 float-right mt-0 mb-3 mr-2">Bulk
                    Status Update
                </button>


                <h4 class="header-title mt-0">Sales Details</h4>
                <div class="table-responsive dash-social">
                    <table id="laravel_datatable" class="table table-hover">
                        <thead class="thead-dark">
                        <tr>
                            <th>Check</th>
                            <th>Date</th>
                            <th>Inoice</th>
                            <th>Waybill No</th>
                            <th>Customer</th>
                            <th>Contact No</th>
                            <th>Invoice Total</th>
                            <th>Grand Total</th>
                            <th>Order Status</th>
                            <th>Payment Status</th>
                            <th>Action</th>

                        </tr>
              
                        </thead>

                        <tbody>

                        </tbody>
                        <tfoot>
                        <tr>
                            <th colspan="6" style="text-align: center"><b>Total: Rs.</b></th>
                           
                            <th>Invoice Total</th>
                            <th>Grand Total</th>
                            <th colspan="3"></th>
                           
                        </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
           
        </div>
    
    </div>
    @include('reports.bulk-status-update')
@endsection

@section('scripts')
    <script>
        $(document).ready(function () {
            $('#reportrange').val('');
            report_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/payment') }}",
                    data: function (d) {
                        d.contact_id = $('#contact_id').val();
                        d.range = $('#reportrange').val();
                        d.status = $('#status').val();
                        d.waybill_id = $('#waybill_id').val();
                    }

                },
                columnDefs: [{
                    "targets": [10],
                    "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 invoice_total = api.column(6).data().reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                  
                    let grand_total = api.column(7).data().reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);

                    $(api.column(6).footer()).html(formatNumber(invoice_total) + '.00')
                    $(api.column(7).footer()).html(formatNumber(grand_total) + '.00')

                }
                ,
                columns: [{
                    data: 'check',
                    name: 'check'
                },
                    {
                        data: 'sale_date',
                        name: 'sale_date'
                    },
                    {
                        data: 'invoice_no',
                        name: 'invoice_no'
                    },
                    {
                        data: 'waybill_id',
                        name: 'waybill.waybill_no'
                    },
                    {
                        data: 'contact_id',
                        name: 'customer.name'
                    },
                    {
                        data: 'contact_no',
                        name: 'customer.mobile'
                    },
                    {
                        data: 'invoice_subtotal',
                        name: 'invoice_subtotal'
                    },
                    {
                        data: 'invoice_nettotal',
                        name: 'invoice_nettotal'
                    },
                    {
                        data: 'status',
                        name: 'status'
                    },
                    {
                        data: 'payment_status',
                        name: 'payment_status'
                    },
                    {
                        data: 'action',
                        name: 'action'
                    },
                ]
            });


            $(document).on('click', '.delete-sale', function (e) {
                e.preventDefault();
                var url = $(this).attr('href');

                Swal.fire({
                    title: 'Are you sure?',
                    text: "You won't be able to revert this!",
                    icon: 'warning',
                    showCancelButton: true,
                    confirmButtonColor: '#3085d6',
                    cancelButtonColor: '#d33',
                    confirmButtonText: 'Yes, delete it!'
                }).then((result) => {
                    if (result.value) {
                        $.ajax({
                            type: "GET",
                            url: url,

                            success: function (response) {
                                if (response.success == 1) {
                                    $.toast({
                                        heading: 'Success',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#1ecab8',
                                        icon: 'success',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })

                                    report_table.ajax.reload();
                                } else {
                                    $.toast({
                                        heading: 'Error',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#f1646c',
                                        icon: 'error',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })
                                }
                            }
                        });
                    }
                })
            });

        });


        $(document).on('change', '#reportrange, #contact_id, #status',
            function () {
                report_table.ajax.reload();
            });

        $(document).on('click', '#search-waybill', function () {
            report_table.ajax.reload();
        })

        function getSelectedOrders() {
            let orders = [];
            $('input[name="sale_id"]:checked').each(function () {
                let value = $(this).val();
                orders.push(value);
            });
            return orders;
        }

        $(document).on('click', '#bulk-modal', function () {
            // $('#bulk_delivery_status').select2();
            let orders = getSelectedOrders();
            if (orders.length >= 1) {
                $('#sale_ids').val(orders);
                $('#bulk-status').modal('show');
            } else {
                Swal.fire(
                    'Error..!',
                    'Please select one or more Sales to bulk update',
                    'warning'
                );
            }
        });

    </script>
    @if(session()->has('msg'))
        <script>
            if ("{{session()->get('msg')['success']}}" == '1') {
                $.toast({
                    heading: 'Success',
                    text: "{{session()->get('msg')['text']}}",
                    position: 'top-right',
                    bgColor: '#1ecab8',
                    icon: 'success',
                    showHideTransition: 'fade',
                    loaderBg: '#ecf0f1'
                })
            } else {
                $.toast({
                    heading: 'Error',
                    text: "{{session()->get('msg')['text']}}",
                    position: 'top-right',
                    bgColor: '#f1646c',
                    icon: 'error',
                    showHideTransition: 'fade',
                    loaderBg: '#ecf0f1'
                })
            }


        </script>
    @endif
@endsection