@extends('layouts.master')

@section('page_title', 'Expense Payments')
@section('title', 'Expense Payments')
@section('main_item', 'Expense')
@section('sub_item', 'Expense Payments')

@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" @if ($setting->business_location != '1') style="display: none" @endif>
                        <div class="form-group">
                            <label class="required" style="font-weight: bold" for="activate_code">business
                                Location</label>
                            <select class="form-control select2" id="location_id" name="location_id">
                                <option value="">All</option>
                                @if (Auth::user()->role_id == '1')
                                    @foreach ($business_locations as $business_location)
                                        @if ($business_location->is_active == '1')
                                            <option value="{{ $business_location->id }}">{{ $business_location->name }}
                                            </option>
                                        @else
                                        @endif
                                    @endforeach
                                @else
                                    @foreach ($business_locations 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">Expense</label>
                            <select class="form-control select2" id="expense_id1" name="expense_id1">
                                <option value="">All</option>
                                @foreach ($expenses as $expense)
                                    <option value="{{ $expense->id }}">{{ $expense->ref_no }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label style="font-weight: bold" for="account_id">Account</label>
                            <select class="form-control select2" id="account_id" name="account_id">
                                <option value="">All</option>
                                @foreach ($accounts as $account)
                                    <option value="{{ $account->id }}">{{ $account->account_name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                </div>
            </div>
            <!--end card-body-->
        </div>
        <!--end card-->
    </div>

        </div>
    </div>
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <h4 class="header-title mt-0">Expense Payments</h4>
                <div class="table-responsive dash-social">
                    <table id="expense_payment_table" class="table table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>Action</th>
                                <th>Payment Date</th>
                                <th>Business Location</th>
                                <th>Payment Ref No</th>
                                <th>Expense Ref No</th>
                                <th>Amount</th>
                                <th>Payment Method</th>
                                <th>Payment Account</th>
                                <th>Payment Note</th>
                            </tr>
                        </thead>
                        <tbody>
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan="4" style="text-align: center"></th>
                                <th style="font-weight: bold">Total</th>
                                <th colspan="3"></th>

                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <div id="edit-payment" class="modal fade">
    </div>
@endsection

@section('scripts')

    <script>
        $(document).ready(function() {
            $("#account_id").select2();
            $("#expense_id1").select2();
            $("#location_id").select2();
            $('#mdate').val(moment(new Date()).format("YYYY-MM-DD"));
            table = $('#expense_payment_table').DataTable({
                dom: 'Blfrtip',
                buttons: [

                    {
                        extend: 'copy',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                    {
                        extend: 'excel',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                    {
                        extend: 'pdf',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                    {
                        extend: 'print',
                        exportOptions: {
                            columns: [1, 2, 3, 4, 5, 6, 7]
                        }
                    },
                ],
                lengthMenu: [
                    [25, 50, 100, -1],
                    ['25 ', '50 ', '100', 'All']
                ],
                processing: false,
                serverSide: true,
                ajax: {
                    url: "{{ route('expense-payments.index') }}",
                    data: function(d) {
                        d.expense_id = $('#expense_id1').val();
                        d.location_id = $('#location_id').val();
                        d.account_id = $('#account_id').val();
                        d.range = $('#reportrange').val();

                    }
                },
                columnDefs: [{
                        "targets": [5],
                        "orderable": false,
                        "searchable": false,
                    },
                    {
                        "targets": [],
                        "orderable": false,
                        "searchable": false,
                        "visible": false,
                    },
                ],
                "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 grand_total = api.column(5).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);
                    $(api.column(5).footer()).html(formatNumber(grand_total) + '.00')
                },
                columns: [{
                        data: 'action',
                        name: 'action'
                    },
                    {
                        data: 'payment_date',
                        name: 'payment_date'
                    },
                    {
                        data: 'location_id',
                        name: 'location_id'
                    },
                    {
                        data: 'payment_ref_no',
                        name: 'payment_ref_no'
                    },
                    {
                        data: 'ref_no',
                        name: 'ref_no'
                    },
                    {
                        data: 'amount',
                        name: 'amount'
                    },

                    {
                        data: 'payment_method',
                        name: 'payment_method'
                    },
                    {
                        data: 'payment_account',
                        name: 'payment_account'
                    },
                    {
                        data: 'payment_note',
                        name: 'payment_note'
                    },
                ]
            });

            //toast
            $('[data-toggle="tooltip"]').tooltip()
            $(document).on('change', '#reportrange, #account_id, #expense_id1, #location_id', function() {
                table.ajax.reload();
            })

        });

        $(document).on('click', '#edit_payment', function() {
            var today = new Date().toLocaleDateString();
            $('#edit-payment').load($(this).data('href'), function() {
                $('#mdate').bootstrapMaterialDatePicker({
                    weekStart: 0,
                    time: false
                });
                $('#edit-payment').modal('show');
            })
        });
        $(document).on('click', '.delete-contact', 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'
                                })

                                table.ajax.reload();
                            }
                        }
                    });
                }
            })
        });
    </script>

@endsection