@extends('backend.layouts.app')
@section('main')
@section('title', 'Transaction')

<div class="col-lg-12">
    <div class="card card-header-actions">
        <div class="card-header">
            <div class="h5 col-auto">TRANSAKSI KEUANGAN</div>
        </div>
        <div class="row ms-3 me-3">
            <div class="col-lg-4 mt-4">
                    <div class="btn-group">
                        <button type="button" class="btn btn-primary dropdown-toggle me-2 mb-2" data-bs-toggle="dropdown"
                            aria-expanded="false">
                            <i class="fas fa-plus me-2"></i>CREATE
                        </button>
                        <ul class="dropdown-menu">
                            <li><a class="dropdown-item" type="button" data-bs-toggle="modal"
                                    data-bs-target="#create_income">Pemasukan</a></li>
                            <li><a class="dropdown-item" type="button" data-bs-toggle="modal"
                                    data-bs-target="#create_expense">Pengeluaran</a></li>
                        </ul>
                    </div>
                    <span id="export"></span>
            </div>

            <div class="col-lg-8">
                <div class="row mt-4">
                    <div class="col-xl-4 col-md-6">
                        <!-- Dashboard info widget 1-->
                        <div class="card border-start-lg border-start-primary">
                            <div class="card-body py-3">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <span>TOTAL SALDO (IDR)</span>
                                        <div class="h5 fw-bold text-primary mb-1">
                                            {{ number_format($totalBalance, 0, '.', '.') }}
                                        </div>
                                        <div class="text-sm mt-1 fw-bold d-inline-flex align-items-center">

                                            Bulan Ini : {{ number_format($balanceMonth, 0, '.', '.') }}
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-4 col-md-6">
                        <!-- Dashboard info widget 2-->
                        <div class="card border-start-lg border-start-success">
                            <div class="card-body py-3">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <span>TOTAL PEMASUKAN (IDR)</span>
                                        <div class="h5 fw-bold text-success mb-1">
                                            {{ number_format($totalIncome, 0, '.', '.') }}
                                        </div>
                                        <div class="text-sm mt-1 fw-bold d-inline-flex align-items-center">
                                            Bulan Ini : {{ number_format($incomeMonth, 0, '.', '.') }}
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-4 col-md-6">
                        <!-- Dashboard info widget 3-->
                        <div class="card border-start-lg border-start-danger">
                            <div class="card-body py-3">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <span>TOTAL PENGELUARAN (IDR)</span>
                                        <div class="h5 text-danger mb-1">{{ number_format($totalExpense, 0, '.', '.') }}
                                        </div>
                                        <div class="text-sm mt-1 fw-bold d-inline-flex align-items-center">
                                            Bulan Ini : {{ number_format($expenseMonth, 0, '.', '.') }}
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <hr class="m-0">

        @include('backend.finance.modal.create_income')
        @include('backend.finance.modal.create_expense')
        <div class="card-body table-responsive">
            <div class="row mb-3">
                <div class="col-lg-3">
                    <div class="form-group mb-3">
                        <label for="mindate" class="mb-1">DARI TANGGAL</label>
                        <input type="date" data-column="1" class="form-control daterange" id="mindate"
                            name="mindate">
                    </div>
                </div>
                <div class="col-lg-3">
                    <div class="form-group mb-3">
                        <label for="maxdate" class="mb-1">SAMPAI TANGGAL</label>
                        <input type="date" data-column="1" class="form-control daterange" id="maxdate"
                            name="maxdate">
                    </div>
                </div>
                <div class="col-lg-3">
                    <div class="form-group mb-3">
                        <label for="filter_type" class="mb-1">TIPE TRANSAKSI</label>
                        <select data-column="5" class="form-select" id="filter_type" name="filter_type">
                            <option value="">Filter Tipe</option>
                            <option value="1|2|3">Pemasukan</option>
                            <option value="4|5|6">Pengeluaran</option>
                        </select>
                    </div>
                </div>
                <div class="col-lg-3">
                    <div class="form-group mb-3">
                        <label for="filter_item" class="mb-1">KATEGORI</label>
                        <select data-column="2" class="form-select" id="filter_item" name="filter_item">
                            <option value="">Filter Kategori</option>
                            <option value="Invoice">Invoice</option>
                            <option value="Hotspot">Hotspot</option>
                            <option value="Regist PSB">Regist PSB</option>
                            <option value="Fee Mitra">Fee Mitra</option>
                            <option value="Operasional">Operasional</option>
                            <option value="Belanja">Belanja</option>
                            <option value="Lainnya">Lainnya</option>
                        </select>
                    </div>
                </div>
            </div>
            <table id="myTable" class="table table-hover display nowrap" width="100%">
                <thead>
                    <tr>
                        <th style="text-align:left!important">NO</th>
                        <th>TANGGAL</th>
                        <th>KATEGORI</th>
                        <th>DESKRIPSI</th>
                        <th style="text-align:left!important">TOTAL</th>
                        <th>TIPE</th>
                        <th>METODE</th>
                        <th>ADMIN</th>
                        {{-- <th>Action</th> --}}
                    </tr>
                </thead>
                <tbody>

                </tbody>
            </table>
        </div>
    </div>
</div>


@endsection
@push('scripts')
<script type="text/javascript">
    let table = $('#myTable').DataTable({
        processing: true,
        serverSide: true,
        // scrollX: true,
        order: [
            [1, 'desc']
        ],
        ajax: '{{ url()->current() }}',
        dom: "lBfrtip",
        lengthMenu: [10, 25, 50, 100, 200, 500, 1000, 10000],
        layout: {
            topStart: ['buttons', 'pageLength']
        },
        buttons: [{
            text: '<i class="fas fa-file-export"></i>&nbspEXPORT',
            className: 'btn btn-warning text-light me-2 mb-2',
            extend: 'excel',
            filename: 'transaction-report',
            title: '',
            exportOptions: {
                columns: [1, 2, 3, 4, 5, 6, 7],
                format: {
                    body: function(data, row, column, node) {
                        data = $('<p>' + data + '</p>').text();
                        return $.isNumeric(data.replace('.', '')) ? data.replace('.', '') : data;
                    }
                }
            },
        }],
        columns: [{
                data: null,
                'sortable': false,
                render: function(data, type, row, meta) {
                    return meta.row + meta.settings._iDisplayStart + 1;
                }
            },
            {
                data: 'tanggal',
                name: 'tanggal',
                render: function(data, type, row, meta) {
                    return moment(data).local().format('DD/MM/YYYY HH:mm:ss');
                },
            },
            {
                data: 'item',
                name: 'item',
                // render: function(data) {
                //     if (data === 'Invoice') {
                //         return '<span class="badge bg-primary">' + data + '</span>'
                //     } else if (data === 'Hotspot') {
                //         return '<span class="badge bg-secondary">' + data + '</span>'
                //     } else if (data === 'Operasional') {
                //         return '<span class="badge bg-warning">' + data + '</span>'
                //     }else if (data === 'Belanja') {
                //         return '<span class="badge bg-cyan">' + data + '</span>'
                //     }
                // },
            },
            {
                data: 'deskripsi',
                name: 'deskripsi',
            },
            {
                data: 'price',
                name: 'price',
                render: $.fn.dataTable.render.number('.', ',', 0, ''),
            },
            {
                data: 'type',
                name: 'type',
                render: function(data) {
                    if (data === 1) {
                        return '<span class="text-success">Income</span>'
                    } else if (data === 2) {
                        return '<span class="text-success">Income</span>'
                    } else if (data === 3) {
                        return '<span class="text-success">Income</span>'
                    } else {
                        return '<span class="text-danger">Expense</span>'
                    }

                },
            },
            {
                data: 'payment_method',
                name: 'payment_method',
                render: function(data) {
                    if (data === 1) {
                        return '<span>Cash</span>'
                    } else {
                        return '<span>Transfer</span>'
                    }

                },
            },

            {
                data: 'admin',
                name: 'admin',
            },
            // {
            //     data: 'action',
            //     name: 'action',
            //     width: '90px',
            // },
        ]
    });

    table.buttons().container().addClass("d-inline").appendTo('#export');

    /* custom button event print */
    $(document).on('click', '#export', function() {
        $(".buttons-print")[0].click(); //trigger the click event
    });

    table.on('preXhr.dt', function(e, settings, data) {
        data.start_date = $('#mindate').val();
        data.end_date = $('#maxdate').val();
    });

    $('#maxdate').change(function() {
        table.ajax.reload();
        return false;
    });

    $('#filter_item').change(function() {
        table.column($(this).data('column'))
            .search($(this).val())
            .draw();
    });

    $('#filter_type').change(function() {
        var any_string = $(this).val().toString();
        table.column($(this).data('column'))
            .search(any_string, true, false)
            .draw();
    });

    // action create
    $('#store_income').click(function(e) {
        e.preventDefault();
        var error_ele = document.getElementsByClassName('alert text-sm');
        if (error_ele.length > 0) {
            for (var i = error_ele.length - 1; i >= 0; i--) {
                error_ele[i].remove();
            }
        }
        let transaction_id = $('#transaction_id').val();

        // collect data by id
        var data = {
            'tanggal': $('#tanggal_ci').val(),
            'type': $('#type_ci').val(),
            'item': $('#item_ci').val(),
            'deskripsi': $('#deskripsi_ci').val(),
            'price': $('#price_ci').val(),
            'payment_method': $('#payment_method_ci').val(),
        }


        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
        });

        // ajax proses
        $.ajax({
            url: `/income`,
            type: "POST",
            cache: false,
            data: data,
            dataType: "json",

            // tampilkan pesan Success

            success: function(data) {
                if (data.success) {
                    Swal.fire({

                        icon: 'success',
                        title: 'Success',
                        text: `${data.message}`,
                        showConfirmButton: false,
                        timer: 1500
                    });
                    setTimeout(function() {
                        table.ajax.reload()
                        $('input, textarea', ).val('');
                        $('#create_income').modal('hide');
                    });
                } else {
                    $.each(data.error, function(key, value) {
                        var el = $(document).find('[name="' + key + '"]');
                        el.after($('<span class= "alert text-sm text-danger">' + value[0] +
                            '</div>'));
                    });
                }
            },

            error: function(err) {
                $("#message").html("Some Error Occurred!")
            }

        });
    });

    $('#store_expense').click(function(e) {
        e.preventDefault();
        var error_ele = document.getElementsByClassName('alert text-sm');
        if (error_ele.length > 0) {
            for (var i = error_ele.length - 1; i >= 0; i--) {
                error_ele[i].remove();
            }
        }
        let transaction_id = $('#transaction_id').val();

        // collect data by id
        var data = {
            'tanggal': $('#tanggal_ce').val(),
            'type': $('#type_ce').val(),
            'item': $('#item_ce').val(),
            'deskripsi': $('#deskripsi_ce').val(),
            'price': $('#price_ce').val(),
            'payment_method': $('#payment_method_ce').val(),
        }


        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
        });

        // ajax proses
        $.ajax({
            url: `/expense`,
            type: "POST",
            cache: false,
            data: data,
            dataType: "json",

            // tampilkan pesan Success

            success: function(data) {
                if (data.success) {
                    Swal.fire({

                        icon: 'success',
                        title: 'Success',
                        text: `${data.message}`,
                        showConfirmButton: false,
                        timer: 1500
                    });
                    setTimeout(function() {
                        table.ajax.reload()
                        $('input, textarea', ).val('');
                        $('#create_expense').modal('hide');
                    });
                } else {
                    $.each(data.error, function(key, value) {
                        var el = $(document).find('[name="' + key + '"]');
                        el.after($('<span class= "alert text-sm text-danger">' + value[0] +
                            '</div>'));
                    });
                }
            },

            error: function(err) {
                $("#message").html("Some Error Occurred!")
            }

        });
    });

    $('#create_income').on('shown.bs.modal', function(e) {
        document.getElementById('tanggal_ci').valueAsDate = new Date();
    })
    $('#create_expense').on('shown.bs.modal', function(e) {
        document.getElementById('tanggal_ce').valueAsDate = new Date();
    })

    /* Tanpa Rupiah */
    var price_ce = document.getElementById('price_ce');
    price_ce.addEventListener('keyup', function(e) {
        price_ce.value = formatRupiah(this.value);
    });

    /* Tanpa Rupiah */
    var price_ci = document.getElementById('price_ci');
    price_ci.addEventListener('keyup', function(e) {
        price_ci.value = formatRupiah(this.value);
    });

    /* Fungsi */
    function formatRupiah(angka, prefix) {
        var number_string = angka.replace(/[^,\d]/g, '').toString(),
            split = number_string.split(','),
            sisa = split[0].length % 3,
            rupiah = split[0].substr(0, sisa),
            ribuan = split[0].substr(sisa).match(/\d{3}/gi);

        if (ribuan) {
            separator = sisa ? '.' : '';
            rupiah += separator + ribuan.join('.');
        }

        rupiah = split[1] != undefined ? rupiah + ',' + split[1] : rupiah;
        return prefix == undefined ? rupiah : (rupiah ? '' + rupiah : '');
    }
</script>
@endpush