@extends('layouts.master')

@section('page_title', ' Account Transaction')
@section('title', ' Account Transaction')
@section('main_item', ' Account Transaction')
@section('sub_item', ' Account Transaction')

@section('content')
    <div class="col-12">
        <div class="card">
            <div class="card-body">

                <h4 class="header-title mt-0">Account Transaction Details</h4>
                <div class="table-responsive dash-social">
                    <table id="datatable" class="table table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>Account Name</th>
                                <th>Paid Date</th>
                                <th>description</th>
                                <th>credit</th>
                                <th>debit</th>
                            </tr>
                        </thead>

                        <tbody>

                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan="2" style="text-align: center"></th>
                                <th style="font-weight: bold">Total</th>
                                <th></th>
                                <th></th>


                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>


@endsection

@section('scripts')

    <script>
        $(document).ready(function() {
            var table = $('#datatable').DataTable({
                buttons: ['copy', 'excel', 'pdf', 'colvis'],
                processing: false,
                serverSide: true,
                ajax: "{{ url('account-transaction-list') }}",
                columnDefs: [{
                    targets: [3, 4],
                    className: 'dt-right'
                }],
                orderCellsTop: true,

                "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 credit_total = api.column(3).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);

                    $(api.column(3).footer()).html(formatNumber(credit_total) + '.00')
                    let debit_total = api.column(4).data().reduce(function(a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);


                    $(api.column(4).footer()).html(formatNumber(debit_total) + '.00')

                },
                columns: [{
                        data: 'account_name',
                        name: 'account_name'
                    },
                    {
                        data: 'payment_date',
                        name: 'payment_date'
                    },
                    {
                        data: 'description',
                        name: 'description'
                    },

                    {
                        data: 'credit',
                        name: 'credit'
                    },
                    {
                        data: 'debit',
                        name: 'credit'
                    }

                ]
            });


            //toast
            $('[data-toggle="tooltip"]').tooltip()


            $(document).on('click', '.delete-acc', 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();
                                } else {
                                    $.toast({
                                        heading: 'Error',
                                        text: response.msg,
                                        position: 'top-right',
                                        bgColor: '#f1646c',
                                        icon: 'error',
                                        showHideTransition: 'fade',
                                        loaderBg: '#ecf0f1'
                                    })


                                }


                            }
                        });

                    }
                })


            });

        });

        $(function() {
            $('[data-toggle="tooltip"]').tooltip()
        })
    </script>
@endsection