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

<div class="row">
    <div class="col-lg-12">
        <div class="card card-header-actions h-100">
            <div class="card-header">
                <div class="h5 col-auto">BILLING UNPAID</div>
            </div>
            <div class="row ms-3 me-3">
                <div class="col-lg-6 mt-4">
                    <button class="btn btn-primary text-light me-2 mb-2" type="button" data-bs-toggle="modal"
                        data-bs-target="#create_invoice">
                        <i class="fas fa-file-pen me-2"></i>MANUAL INVOICE&nbsp
                    </button>
                    <span id="export">
                </div>
            </div>
            @include('backend.billing.unpaid.modal.show_invoice')
            @include('backend.billing.unpaid.modal.create_invoice')

            <div class="card-body table-responsive">

                <table id="myTable" class="table table-hover display nowrap" width="100%">
                    <thead>
                        <tr>
                            <th style="text-align:left!important">NO</th>
                            <th style="text-align:left!important">NO INVOICE</th>
                            <th>NAMA LENGKAP</th>
                            <th>WHATSAPP</th>
                            <th>AREA</th>
                            <th>ALAMAT</th>
                            <th>TGL INVOICE</th>
                            <th>JTH TEMPO</th>
                            <th>ITEM</th>
                            <th>PERIODE LANGGANAN</th>
                            <th>TOTAL</th>
                            <th>AKSI</th>
                        </tr>
                    </thead>
                    <tbody>

                    </tbody>
                </table>

            </div>
        </div>
    </div>
</div>

@endsection
@push('scripts')
<script type="text/javascript">
    let table = $('#myTable').DataTable({
        processing: true,
        serverSide: true,
        // scrollX: true,
        order: [
            [12, 'desc']
        ],
        lengthMenu: [10, 25, 50, 100, 200, 500, 1000, 2000],
        ajax: '{{ url()->current() }}',
        dom: "lBfrtip",
        // buttons: ["copy", "csv", "excel", "pdf", "print"],
        // layout: {
        //     topStart: ['buttons', 'pageLength']
        // },
        buttons: [{
            text: '<i class="fas fa-file-export"></i>&nbspEXPORT',
            extend: 'excel',
            filename: 'unpaid-invoices',
            title: '',
            exportOptions: {
                columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 10],
                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: 'no_invoice',
                name: 'no_invoice',
                render: function(data, type, row) {
                    return '<a href="javascript:void(0)" class="text-primary" style="text-decoration:none" id="show_invoice" data-id=' +
                        row.id +
                        '>' + data + '</a>'
                },
            },
            {
                data: 'member.full_name',
                name: 'member.full_name',
            },
            {
                data: 'member.wa',
                name: 'member.wa',
                visible: false,
            },
            {
                data: 'member.kode_area',
                name: 'member.kode_area'
            },
            {
                data: 'member.address',
                name: 'member.address',
                visible: false,
            },
            {
                data: 'invoice_date',
                name: 'invoice_date',
                render: function(data, type, row, meta) {
                    return moment(data).local().format('DD/MM/YYYY');
                },
            },
            {
                data: 'due_date',
                name: 'due_date',
                render: function(data, type, row, meta) {
                    return moment(data).local().format('DD/MM/YYYY');
                },
            },
            {
                data: 'item',
                name: 'item',
                visible: false,
            },
            {
                data: 'subscribe',
                name: 'subscribe',
            },
            {
                data: 'total',
                name: 'total',
                render: $.fn.dataTable.render.number('.', ',', 0, ''),
            },
            {
                data: 'action',
                name: 'action',
                width: '90px',
            },
            {
                data: 'created_at',
                name: 'created_at',
                visible: false,
            },
        ]
    });
    $(
        ".buttons-copy, .buttons-csv, .buttons-print, .buttons-pdf, .buttons-excel"
    ).addClass("btn btn-warning text-light me-2 mb-2");
    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
    });

    // action create
    $('#editInvoice').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 invoice_id = $('#invoice_id').val();

        // collect data by id
        var data = {
            'item': $('#item').val(),
            'ppn': $('#ppn').val(),
            'discount': $('#discount').val(),
            'amount': $('#amount').val(),
        }


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

        // ajax proses
        $.ajax({
            url: `/billing/member/updateInvoice/${invoice_id}`,
            type: "PUT",
            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()
                        $('#show_invoice').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!")
            }

        });
    });

    // dapatkan value kode area dari member_id
    $("#member_id").on("change", function() {
        var member_id = $(this).val();
        $.ajax({
            url: `/billing/unpaid/getMember/${member_id}`,
            type: "GET",
            cache: false,
            data: {
                member_id: member_id,
                '_token': '{{ csrf_token() }}'
            },
            success: function(data) {
                if (data[0].kode_area === null) {
                    $('#fill_area').val('<i>NULL</i>');
                } else {
                    $('#fill_area').val(data[0].kode_area);
                }
                $('#fill_full_name').val(data[0].full_name);
                $('#fill_username').val(data[0].ppp.username);
                $('#fill_password').val(data[0].ppp.value);
                $('#fill_profile').val(data[0].ppp.profile);
                $('#fill_member_id').val(data[0].id);
                $('#fill_id_member').val(data[0].id_member);
                $('#fill_wa').val(data[0].wa);
                let profile_id = data[0].profile_id;
                if (profile_id) {
                    $.ajax({
                        url: `/billing/unpaid/getProfile/${profile_id}`,
                        type: 'GET',
                        data: {
                            profile_id: profile_id,
                            '_token': '{{ csrf_token() }}'
                        },
                        success: function(response) {
                            var today = moment().format('yyyy-MM-DD');
                            var reg_date = data[0].reg_date;
                            var reg_date_start = moment(reg_date).startOf(
                                'month').format('yyyy-MM-DD');
                            var reg_date_end = moment(reg_date).endOf(
                                'month').format('yyyy-MM-DD');
                            var reg_date_format = moment(reg_date).format(
                                'DD/MM/yyyy');
                            var reg_date_end_format = moment(reg_date_end)
                                .format(
                                    'DD/MM/yyyy');
                            var payment_type = data[0].payment_type;
                            var billing_period = data[0].billing_period;
                            var next_due = data[0].next_invoice;

                            var day_cycle = moment(data[0].next_due).format(
                                'DD');
                            var next_due_cycle = moment(data[0]
                                    .next_invoice).set("date", day_cycle)
                                .format("yyyy-MM-DD");

                            var ppn = data[0].ppn;
                            var discount = data[0].discount;
                            var amount_price = response[0].price;
                            var amount_ppn = amount_price * ppn / 100;
                            var amount_discount = amount_price * discount /
                                100;

                            var amount = parseInt(amount_price) + parseInt(
                                amount_ppn) - parseInt(amount_discount);
                            rp_amount = formatRupiah(amount_price
                                .toString(), 2, ',', '.');
                            rp_total_amount = formatRupiah(amount
                                .toString(), 2, ',',
                                '.');
                            var username = data[0].ppp.username;
                            var paket = data[0].ppp.profile;
                            var tgl = data[0].tgl;
                            var count_invoice = data[0].invoice.length;

                            var next_due_format = moment(next_due).format(
                                'DD/MM/yyyy');
                            var next_due_plus = moment(next_due).add(1, 'M')
                                .format('YYYY-MM-DD');
                            var next_due_plus_format = moment(next_due_plus)
                                .format(
                                    'DD/MM/yyyy');
                            var next_due_min = moment(next_due).subtract(1,
                                    'M')
                                .format('YYYY-MM-DD');
                            var next_due_min_format = moment(next_due_min)
                                .format(
                                    'DD/MM/yyyy');

                            var next_due_start = moment(next_due_min)
                                .startOf('month').format('DD/MM/yyyy');
                            var next_due_end = moment(next_due_min).endOf(
                                'month').format('DD/MM/yyyy');
                            var subscribe_prabayar = next_due_format +
                                " s/d " + next_due_plus_format;
                            var subscribe_pascabayar = next_due_min_format +
                                " s/d " + next_due_format;
                            var subscribe_cycle = next_due_start +
                                " s/d " + next_due_end;
                            var subscribe_cycle0 = reg_date_format +
                                " s/d " + reg_date_end_format;


                            jml_day = moment(reg_date_end).diff(
                                reg_date_start, 'days') + 1;
                            jml_usage = moment(reg_date_end).diff(reg_date,
                                'days') + 1;
                            daily_amount0 = amount_price / jml_day;
                            daily_amount = Math.trunc(daily_amount0);
                            prorate0 = jml_usage * daily_amount;
                            prorate = prorate0.toString();
                            rp_prorate = formatRupiah(prorate, 2, ',', '.');
                            //ppn diambil dari harga paket
                            amount_ppn_prorate = prorate0 * ppn / 100;
                            amount_discount_prorate = prorate0 * discount / 100;
                            prorate_with_ppn_discount = parseInt(prorate0) + parseInt(
                                amount_ppn_prorate) - parseInt(amount_discount_prorate);
                            prorate_with_ppn_discount = prorate_with_ppn_discount.toString();
                            rp_prorate_with_ppn_discount = formatRupiah(prorate_with_ppn_discount, 2, ',', '.');

                            var item = "Internet: " + username +
                                " | " +
                                paket;

                            var item_cycle = "Internet: " + username +
                                " | " +
                                paket + " @aktif " + jml_usage + " hari";

                            if (payment_type === 'Prabayar' &&
                                billing_period === 'Fixed Date') {
                                $('#fill_invoice_date').val(today);
                                $('#fill_due_date').val(next_due);
                                $('#fill_subscribe').val(
                                    subscribe_prabayar);
                                $('#fill_validity option:selected').text(
                                    '1 Month');
                                $('#fill_payment_type option:selected')
                                    .text(payment_type);
                                $('#fill_billing_period option:selected')
                                    .text(billing_period);
                                $('#fill_item').val(item);
                                $('#fill_amount').val(rp_amount);
                                $('#fill_ppn').val(ppn);
                                $('#fill_discount').val(discount);
                                $('#fill_payment_total').val(
                                    rp_total_amount);

                                // on change
                                $("#fill_ppn,#fill_discount").on(
                                    "keyup change",
                                    function() {
                                        var jml = document
                                            .getElementById(
                                                'fill_amount').value;
                                        var amount = jml.replace(/\./g,
                                            "");
                                        var ppn = $('#fill_ppn').val();
                                        var discount = $(
                                            '#fill_discount').val();
                                        var amount_ppn = amount * ppn /
                                            100;
                                        var amount_discount = amount *
                                            discount / 100;
                                        if (discount === null) {
                                            var total_with_ppn =
                                                parseInt(
                                                    amount) + parseInt(
                                                    amount_ppn);
                                            var total_plus_ppn =
                                                total_with_ppn
                                                .toString();
                                            rp_total_plus_ppn =
                                                formatRupiah(
                                                    total_plus_ppn,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn);
                                        } else {
                                            var total_with_ppn_discount =
                                                parseInt(amount) +
                                                parseInt(
                                                    amount_ppn) -
                                                parseInt(
                                                    amount_discount);
                                            var total_plus_ppn_discount =
                                                total_with_ppn_discount
                                                .toString();
                                            rp_total_plus_ppn_discount =
                                                formatRupiah(
                                                    total_plus_ppn_discount,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn_discount
                                                );
                                        }
                                    });
                            } else if (payment_type === 'Pascabayar' &&
                                billing_period === 'Fixed Date') {
                                $('#fill_invoice_date').val(today);
                                $('#fill_due_date').val(next_due);
                                $('#fill_subscribe').val(
                                    subscribe_pascabayar);
                                $('#fill_validity option:selected').text(
                                    '1 Month');
                                $('#fill_payment_type option:selected')
                                    .text(payment_type);
                                $('#fill_billing_period option:selected')
                                    .text(billing_period);
                                $('#fill_item').val(item);
                                $('#fill_amount').val(rp_amount);
                                $('#fill_ppn').val(ppn);
                                $('#fill_discount').val(discount);
                                $('#fill_payment_total').val(
                                    rp_total_amount);

                                // on change
                                $("#fill_ppn,#fill_discount").on(
                                    "keyup change",
                                    function() {
                                        var jml = document
                                            .getElementById(
                                                'fill_amount').value;
                                        var amount = jml.replace(/\./g,
                                            "");
                                        var ppn = $('#fill_ppn').val();
                                        var discount = $(
                                            '#fill_discount').val();
                                        var amount_ppn = amount * ppn /
                                            100;
                                        var amount_discount = amount *
                                            discount / 100;
                                        if (discount === null) {
                                            var total_with_ppn =
                                                parseInt(
                                                    amount) + parseInt(
                                                    amount_ppn);
                                            var total_plus_ppn =
                                                total_with_ppn
                                                .toString();
                                            rp_total_plus_ppn =
                                                formatRupiah(
                                                    total_plus_ppn,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn);
                                        } else {
                                            var total_with_ppn_discount =
                                                parseInt(amount) +
                                                parseInt(
                                                    amount_ppn) -
                                                parseInt(
                                                    amount_discount);
                                            var total_plus_ppn_discount =
                                                total_with_ppn_discount
                                                .toString();
                                            rp_total_plus_ppn_discount =
                                                formatRupiah(
                                                    total_plus_ppn_discount,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn_discount
                                                );
                                        }
                                    });
                            } else if (payment_type === 'Pascabayar' &&
                                billing_period === 'Billing Cycle' &&
                                count_invoice > 0) {
                                $('#fill_invoice_date').val(today);
                                $('#fill_due_date').val(next_due_cycle);
                                $('#fill_subscribe').val(
                                    subscribe_cycle);
                                $('#fill_validity option:selected').text(
                                    '1 Month');
                                $('#fill_payment_type option:selected')
                                    .text(payment_type);
                                $('#fill_billing_period option:selected')
                                    .text(billing_period);
                                $('#fill_item').val(item);
                                $('#fill_amount').val(rp_amount);
                                $('#fill_ppn').val(ppn);
                                $('#fill_discount').val(discount);
                                $('#fill_payment_total').val(
                                    rp_total_amount);

                                // on change
                                $("#fill_ppn,#fill_discount").on(
                                    "keyup change",
                                    function() {
                                        var jml = document
                                            .getElementById(
                                                'fill_amount').value;
                                        var amount = jml.replace(/\./g,
                                            "");
                                        var ppn = $('#fill_ppn').val();
                                        var discount = $(
                                            '#fill_discount').val();
                                        var amount_ppn = amount * ppn /
                                            100;
                                        var amount_discount = amount *
                                            discount / 100;
                                        if (discount === null) {
                                            var total_with_ppn =
                                                parseInt(
                                                    amount) + parseInt(
                                                    amount_ppn);
                                            var total_plus_ppn =
                                                total_with_ppn
                                                .toString();
                                            rp_total_plus_ppn =
                                                formatRupiah(
                                                    total_plus_ppn,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn);
                                        } else {
                                            var total_with_ppn_discount =
                                                parseInt(amount) +
                                                parseInt(
                                                    amount_ppn) -
                                                parseInt(
                                                    amount_discount);
                                            var total_plus_ppn_discount =
                                                total_with_ppn_discount
                                                .toString();
                                            rp_total_plus_ppn_discount =
                                                formatRupiah(
                                                    total_plus_ppn_discount,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn_discount
                                                );
                                        }
                                    });
                            } else if (payment_type === 'Pascabayar' &&
                                billing_period === 'Billing Cycle' &&
                                count_invoice === 0 && reg_date !==
                                reg_date_start) {
                                $('#fill_invoice_date').val(today);
                                $('#fill_due_date').val(next_due_cycle);
                                $('#fill_subscribe').val(
                                    subscribe_cycle0);
                                $('#fill_validity option:selected').text(
                                    '1 Month Prorate');
                                $('#fill_payment_type option:selected')
                                    .text(payment_type);
                                $('#fill_billing_period option:selected')
                                    .text(billing_period);
                                $('#fill_item').val(item_cycle);
                                $('#fill_amount').val(rp_prorate);
                                $('#fill_ppn').val(ppn);
                                $('#fill_discount').val(discount);
                                $('#fill_payment_total').val(
                                    rp_prorate_with_ppn_discount);

                                // on change
                                $("#fill_ppn,#fill_discount").on(
                                    "keyup change",
                                    function() {
                                        var jml = document
                                            .getElementById(
                                                'fill_amount').value;
                                        var amount = jml.replace(/\./g,
                                            "");
                                        var ppn = $('#fill_ppn').val();
                                        var discount = $(
                                            '#fill_discount').val();
                                        var amount_ppn = amount * ppn /
                                            100;
                                        var amount_discount = amount *
                                            discount / 100;
                                        if (discount === null) {
                                            var total_with_ppn =
                                                parseInt(
                                                    amount) + parseInt(
                                                    amount_ppn);
                                            var total_plus_ppn =
                                                total_with_ppn
                                                .toString();
                                            rp_total_plus_ppn =
                                                formatRupiah(
                                                    total_plus_ppn,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn);
                                        } else {
                                            var total_with_ppn_discount =
                                                parseInt(amount) +
                                                parseInt(
                                                    amount_ppn) -
                                                parseInt(
                                                    amount_discount);
                                            var total_plus_ppn_discount =
                                                total_with_ppn_discount
                                                .toString();
                                            rp_total_plus_ppn_discount =
                                                formatRupiah(
                                                    total_plus_ppn_discount,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn_discount
                                                );
                                        }
                                    });
                            } else if (payment_type === 'Pascabayar' &&
                                billing_period === 'Billing Cycle' &&
                                count_invoice === 0 && reg_date ===
                                reg_date_start) {
                                $('#fill_invoice_date').val(today);
                                $('#fill_due_date').val(next_due_cycle);
                                $('#fill_subscribe').val(
                                    subscribe_cycle0);
                                $('#fill_validity option:selected').text(
                                    '1 Month');
                                $('#fill_payment_type option:selected')
                                    .text(payment_type);
                                $('#fill_billing_period option:selected')
                                    .text(billing_period);
                                $('#fill_item').val(item);
                                $('#fill_amount').val(rp_amount);
                                $('#fill_ppn').val(ppn);
                                $('#fill_discount').val(discount);
                                $('#fill_payment_total').val(
                                    rp_total_amount);

                                // on change
                                $("#fill_ppn,#fill_discount").on(
                                    "keyup change",
                                    function() {
                                        var jml = document
                                            .getElementById(
                                                'fill_amount').value;
                                        var amount = jml.replace(/\./g,
                                            "");
                                        var ppn = $('#fill_ppn').val();
                                        var discount = $(
                                            '#fill_discount').val();
                                        var amount_ppn = amount * ppn /
                                            100;
                                        var amount_discount = amount *
                                            discount / 100;
                                        if (discount === null) {
                                            var total_with_ppn =
                                                parseInt(
                                                    amount) + parseInt(
                                                    amount_ppn);
                                            var total_plus_ppn =
                                                total_with_ppn
                                                .toString();
                                            rp_total_plus_ppn =
                                                formatRupiah(
                                                    total_plus_ppn,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn);
                                        } else {
                                            var total_with_ppn_discount =
                                                parseInt(amount) +
                                                parseInt(
                                                    amount_ppn) -
                                                parseInt(
                                                    amount_discount);
                                            var total_plus_ppn_discount =
                                                total_with_ppn_discount
                                                .toString();
                                            rp_total_plus_ppn_discount =
                                                formatRupiah(
                                                    total_plus_ppn_discount,
                                                    2, ',', '.');
                                            $('#fill_payment_total')
                                                .val(
                                                    rp_total_plus_ppn_discount
                                                );
                                        }
                                    });
                            }

                            // $('input[type="text"],textarea').reset();



                        }
                    });
                } else {

                }
            }
        });
    });

    $('#generate_invoice').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();
            }
        }

        // collect data by id
        var dataku = {
            'member_id': $(
                    '#fill_member_id'
                )
                .val(),
            'id_member': $(
                    '#fill_id_member'
                )
                .val(),
            'today': $(
                    '#fill_invoice_date'
                )
                .val(),
            'payment_type': $(
                    '#fill_payment_type'
                )
                .val(),
            'billing_period': $(
                    '#fill_billing_period'
                )
                .val(),
            'next_due': $(
                    '#fill_due_date')
                .val(),
            'amount': $('#fill_amount')
                .val(),
            'ppn': $('#fill_ppn').val(),
            'discount': $(
                    '#fill_discount')
                .val(),
            'username': $(
                    '#fill_username')
                .val(),
            'paket': $('#fill_profile')
                .val(),
            'subscribe': $(
                    '#fill_subscribe')
                .val(),
            'item': $('#fill_item')
                .val(),
            'full_name': $(
                '#fill_full_name'
            ).val(),
            'username': $(
                '#fill_username'
            ).val(),
            'password': $(
                '#fill_password'
            ).val(),
            'profile': $(
                '#fill_profile'
            ).val(),
            'wa': $(
                '#fill_wa'
            ).val(),
        }

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

        // ajax proses
        $.ajax({
            url: `/billing/unpaid/generate`,
            type: "POST",
            cache: false,
            data: dataku,
            dataType: "json",

            // tampilkan pesan Success

            success: function(
                data) {
                let invoice_id = data.data.id;
                if (data
                    .success) {
                    Swal.fire({
                        icon: 'success',
                        title: 'Success',
                        text: `${data.message}`,
                        showConfirmButton: false,
                        timer: 1500
                    });
                    
                    $.ajaxSetup({
                        headers: {
                            'X-CSRF-TOKEN': $(
                                    'meta[name="csrf-token"]'
                                )
                                .attr('content')
                        }
                    });

                    // ajax proses
                    $.ajax({
                        url: `/billing/unpaid/generateWA/${invoice_id}`,
                        type: "POST",
                        cache: false,
                        data: dataku,
                        dataType: "json",
                    });
                    setTimeout(
                        function() {
                            location.reload()
                            // $('input, textarea', ).val('');
                            // $('#member_id').val('').trigger('change');
                            // // $('#fill_validity').val('').trigger('change');
                            // $('#fill_payment_type').val('').trigger('change');
                            // $('#fill_billing_period').val('').trigger('change');
                            // $('#create_invoice').modal('hide');
                        }, 1500);
                } else {
                    $.each(data
                        .error,
                        function(
                            key,
                            value
                        ) {
                            var el =
                                $(
                                    document)
                                .find(
                                    '[name="' +
                                    key +
                                    '"]'
                                );
                            el.after(
                                $('<span class= "alert text-sm text-danger">' +
                                    value[
                                        0
                                    ] +
                                    '</span>'
                                )
                            );
                        });
                }
            },

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

        });
    });


    $('#myTable').on('click', '#show_invoice', function() {
        let invoice_id = $(this).data('id');
        if (invoice_id) {
            $.ajax({
                url: `/billing/member/getInvoice/${invoice_id}`,
                type: "GET",
                data: {
                    invoice_id: invoice_id,
                },
                success: function(data) {
                    $("#invoice_id").val(data.data[0].id);
                    $("#full_name").val(data.data[0].member.full_name);
                    $("#no_invoice").val(data.data[0].no_invoice);
                    $("#invoice_date").val(data.data[0].invoice_date);
                    $("#due_date").val(data.data[0].due_date);
                    $("#subscribe").val(data.data[0].subscribe);
                    $("#payment_type option:selected").text(data.data[0].payment_type).val(data
                        .data[0]
                        .payment_type);
                    $("#validity option:selected").text('1 Month');
                    $("#billing_period option:selected").text(data.data[0].billing_period).val(data
                        .data[0]
                        .billing_period);
                    $("#item").val(data.data[0].item);

                    var amount = data.data[0].price;

                    rp_amount = formatRupiah(amount, 2, ',', '.');
                    $('#amount').val(rp_amount);
                    rp_total_amount = formatRupiah(amount, 2, ',', '.');
                    $('#ppn').val(data.data[0].ppn);
                    $('#discount').val(data.data[0].discount);
                    $('#payment_total').val(rp_total_amount);

                    $('#show_invoice').on('shown.bs.modal', function() {
                        var ppn = $('#ppn').val();
                        var discount = $('#discount').val();
                        var amount_ppn = amount * ppn / 100;
                        var amount_discount = amount * discount / 100;
                        if (discount === null) {
                            var total_with_ppn = parseInt(amount) + parseInt(amount_ppn);
                            var total_plus_ppn = total_with_ppn.toString();
                            rp_total_plus_ppn = formatRupiah(total_plus_ppn, 2, ',', '.');
                            $('#payment_total').val(rp_total_plus_ppn);
                        } else {
                            var total_with_ppn_discount = parseInt(amount) + parseInt(
                                amount_ppn) - parseInt(amount_discount);
                            var total_plus_ppn_discount = total_with_ppn_discount
                                .toString();
                            rp_total_plus_ppn_discount = formatRupiah(
                                total_plus_ppn_discount,
                                2, ',', '.');
                            $('#payment_total').val(rp_total_plus_ppn_discount);
                        }
                    })


                    $("#ppn,#discount").on("keyup change", function() {
                        var jml = document.getElementById('amount').value;
                        var amount = jml.replace(/\./g, "");
                        var ppn = $('#ppn').val();
                        var discount = $('#discount').val();
                        var amount_ppn = amount * ppn / 100;
                        var amount_discount = amount * discount / 100;
                        if (discount === null) {
                            var total_with_ppn = parseInt(amount) + parseInt(amount_ppn);
                            var total_plus_ppn = total_with_ppn.toString();
                            rp_total_plus_ppn = formatRupiah(total_plus_ppn, 2, ',', '.');
                            $('#payment_total').val(rp_total_plus_ppn);
                        } else {
                            var total_with_ppn_discount = parseInt(amount) + parseInt(
                                amount_ppn) - parseInt(amount_discount);
                            var total_plus_ppn_discount = total_with_ppn_discount
                                .toString();
                            rp_total_plus_ppn_discount = formatRupiah(
                                total_plus_ppn_discount,
                                2, ',', '.');
                            $('#payment_total').val(rp_total_plus_ppn_discount);
                        }
                    });



                }
            });
        } else {

        }
        $('#show_invoice').modal('show');
    });

    $('#myTable').on('click', '#pay', function() {
        let invoice_id = $(this).data('id');
        let ppp_id = $(this).data('ppp');
        if (invoice_id) {
            $.ajax({
                url: `/billing/member/getInvoice/${invoice_id}`,
                type: "GET",
                data: {
                    invoice_id: invoice_id,
                    ppp_id: ppp_id,
                },
                success: function(data) {
                    var id = data.data[0].id;
                    var full_name = data.data[0].member.full_name;
                    var no_invoice = data.data[0].no_invoice;
                    var invoice_date = data.data[0].invoice_date;
                    var amount = data.data[0].price;
                    var ppn = data.data[0].ppn;
                    var discount = data.data[0].discount;
                    var amount_ppn = amount * ppn / 100;
                    var amount_discount = amount * discount / 100;
                    var total_with_ppn_discount = parseInt(amount) + parseInt(
                        amount_ppn) - parseInt(amount_discount);
                    var total_plus_ppn_discount = total_with_ppn_discount
                        .toString();

                    var payment_type = data.data[0].payment_type;
                    var billing_period = data.data[0].billing_period;
                    var payment_url = data.data[0].payment_url;

                    var subscribe = data.data[0].subscribe;
                    var periode = data.data[0].period;
                    var due_date = data.data[0].due_date;

                    var member_id = data.data[0].member_id;
                    var id_member = data.data[0].member.id_member;
                    var nas = data.ppp[0].nas;
                    var no_wa = data.data[0].member.wa;

                    // collect data pppoe
                    var ppp_id = data.ppp[0].id;
                    var ppp_user = data.ppp[0].username;
                    var ppp_pass = data.ppp[0].value;
                    var ppp_profile = data.ppp[0].profile;
                    var ppp_status = data.ppp[0].status;

                    Swal.fire({
                        title: "Konfirmasi Pembayaran",
                        icon: 'warning',
                        input: "select",
                        inputOptions: {
                            '1': 'Cash',
                            '2': 'Transfer',
                        },
                        inputPlaceholder: 'Metode Pembayaran',
                        text: "INV #" + no_invoice + " a.n " + full_name + "",
                        showCancelButton: !0,
                        confirmButtonText: "Ya, sudah bayar",
                        cancelButtonText: "Batal",
                        reverseButtons: !0,
                        customClass: {
                            input: 'form-select w-auto bg-none width-auto p-3 mx-10',
                        },
                        inputValidator: function(value) {
                            return new Promise(function(resolve, reject) {
                                if (value !== '') {
                                    resolve();
                                } else {
                                    resolve('Harap pilih metode pembayaran');
                                }
                            });
                        }
                    }).then(function(result) {
                        if (result.isConfirmed) {
                            let invoice_id = id;
                            var dataku = {
                                'member_id': member_id,
                                'id_member': id_member,
                                'no_wa': no_wa,
                                'subscribe': subscribe,
                                'periode': periode,
                                'full_name': full_name,
                                'no_invoice': no_invoice,
                                'invoice_date': invoice_date,
                                'amount': amount,
                                'ppn': ppn,
                                'discount': discount,
                                'payment_total': total_plus_ppn_discount,
                                'payment_method': result.value,
                                'payment_type': payment_type,
                                'payment_url': payment_url,
                                'billing_period': billing_period,
                                'due_date': due_date,
                                'ppp_id': ppp_id,
                                'ppp_status': ppp_status,
                                'pppoe_user': ppp_user,
                                'pppoe_pass': ppp_pass,
                                'pppoe_profile': ppp_profile,
                                'nas': nas,
                            }

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

                            // ajax proses
                            $.ajax({
                                url: `/billing/member/payInvoice/${invoice_id}`,
                                type: "PUT",
                                cache: false,
                                data: dataku,
                                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()
                                        });
                                        $.ajaxSetup({
                                            headers: {
                                                'X-CSRF-TOKEN': $(
                                                        'meta[name="csrf-token"]'
                                                    )
                                                    .attr('content')
                                            }
                                        });

                                        // ajax proses
                                        $.ajax({
                                            url: `/billing/member/payInvoiceWA/${invoice_id}`,
                                            type: "POST",
                                            cache: false,
                                            data: dataku,
                                            dataType: "json",
                                        });

                                    } 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!")
                                }

                            });
                        }
                    });
                }
            });
        } else {}

    });

    $('#myTable').on('click', '#delete', function() {

        let id = $(this).data('id');

        Swal.fire({
            title: "Apakah anda yakin?",
            icon: 'warning',
            text: "Data yang sudah dihapus tidak dapat dikembalikan",
            showCancelButton: !0,
            reverseButtons: !0,
            confirmButtonText: "Yes, delete!",
            cancelButtonText: "Cancel",
            confirmButtonColor: "#d33",
            // cancelButtonColor: "#d33",
        }).then(function(result) {
            if (result.isConfirmed) {
                $.ajaxSetup({
                    headers: {
                        'X-CSRF-TOKEN': $(
                                'meta[name="csrf-token"]'
                            )
                            .attr('content')
                    }
                });

                $.ajax({
                    url: `/billing/unpaid/${id}`,
                    type: "POST",
                    cache: false,
                    data: {
                        _method: "DELETE"
                    },
                    dataType: "json",

                    // tampilkan pesan Success
                    success: function(data) {
                        Swal.fire({
                            icon: 'success',
                            title: 'Success',
                            text: `${data.message}`,
                            showConfirmButton: false,
                            timer: 1500
                        });
                        setTimeout(
                            function() {
                                table.ajax.reload()
                            });
                    },

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

                });
            }
        });
    });

    function kapital() {
        let x = document.getElementById("full_name");
        let y = document.getElementById("address");
        x.value = x.value.toUpperCase();
        y.value = y.value.toUpperCase();
    }

    /* Tanpa Rupiah */
    var price = document.getElementById('amount');
    var total = document.getElementById('payment_total');
    var fill_price = document.getElementById('fill_amount');
    var fill_total = document.getElementById('fill_payment_total');
    price.addEventListener('keyup', function(e) {
        price.value = formatRupiah(this.value);
        total.value = formatRupiah(this.value);
    });
    fill_price.addEventListener('keyup', function(e) {
        fill_price.value = formatRupiah(this.value);
        fill_total.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 : '');
    }

    $('#member_id').select2({
        allowClear: true,
        dropdownParent: $("#create_invoice"),
        width: $(this).data('width') ? $(this).data('width') : $(this).hasClass('w-100') ? '100%' : 'style',
        placeholder: $(this).data('placeholder'),
    });
</script>
@endpush