invisio v2.0

<?php

include('header.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);

$sql_system = "SELECT * FROM tbl_system_setting WHERE setting_id = '1';";
$rs_system = mysqli_query($connection, $sql_system);
$row_system = mysqli_fetch_array($rs_system);

$key = $row_system['secure_text'];
$pointer = $row_system['secure_pointer'];

$member_id = $_GET["id"];
$temp_member_id = explode(".", $member_id);
$member_id = bigsara_decode($temp_member_id[0], $temp_member_id[1]);
$register_type = $_GET["type"];

switch ($register_type) {
    case '1':
        $table = "tbl_member_detail_employer";
        break;
    case '2':
        $table = "tbl_member_detail_company";
        break;
    case '3':
        $table = "tbl_member_detail_agency";
        break;
    case '4':
        $table = "tbl_member_detail_worker";
        break;
}

$sql = "SELECT * FROM `$table` WHERE `member_id` = '$member_id'";
$rs = mysqli_query($connection, $sql);
$row = mysqli_fetch_array($rs);

$sql_payment = "SELECT * FROM tbl_member_payment WHERE member_id = '$member_id' ";
$rs_payment = mysqli_query($connection, $sql_payment) or die($connection->error);
$row_payment = mysqli_fetch_assoc($rs_payment);
$payment_status = $row_payment['approve_result'];

<!-- 
                    <div class="row">
                        <div class="col-12 mb-3">
                            <div class="ibox">
                                <div class="ibox-content pt-3">
                                    <div class="row">
                                        <div class="col-12 mb-5">
                                            <label for=""><b>หมายเหตุ</b></label><br>
                                            <hr>
                                            <div class="row">
                                                <div class="col-12">
                                                    <textarea name="remark" id="remark" cols="30" rows="5" class="form-control"></textarea>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row mb-3">
                        <div class="col">
                            <button class="btn btn-primary btn-block w-100" id="top_menu4" onclick="ApproveMember('<?php echo $member_id; ?>','1','<?php echo $payment_status; ?>')"><i class="fa fa-check"></i> ส่งกรรมการ</button>
                        </div>
                        <div class="col">
                            <button class="btn btn-warning btn-block w-100" id="top_menu4" onclick="ApproveMember('<?php echo $member_id; ?>','0','<?php echo $payment_status; ?>')"><i class="fa fa-close"></i> ขอข้อมูลเพิ่มเติม</button>
                        </div>
                    </div> -->

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

<?php include('footer.php'); ?>

const queryString = window.location.search;
            const urlParams = new URLSearchParams(queryString);
            const member_id = urlParams.get('id')
            const member_type = urlParams.get('type')
            const member_level = urlParams.get('level')

$("#btn_print").attr("href", "https://efa-member.com/main/print/application_form?id=" + member_id);

GetData(1)
        });

// function GetModalEdit(payment_id) {

//     $('#myModal').modal('show');
        //     $('#showModal').load("ajax/setting_member/get_modal_payment.php", {
        //             payment_id: payment_id,

//         },
        //         function() {

//         });
        // }

function GetData(type) {

if (type == 1) {

$("#show_list").load("ajax/member_detail/get_member_detail.php", {
                    member_id: member_id,
                    member_type: member_type,
                    member_level: member_level
                }, function() {
                    $('#Loading1').hide();
                });

// $("#member_doc").load("ajax/setting_member/get_member_doc.php", {
                //     member_id: member_id,
                //     member_type: member_type,
                //     member_level: member_level
                // }, function() {
                //     $('#Loading2').hide();
                // });

// $("#member_payment").load("ajax/member_detail/get_member_payment.php", {
                //     member_id: member_id,
                //     member_type: member_type,
                //     member_level: member_level
                // }, function() {
                //     $('.dataTables-example').DataTable({
                //         ordering: false,
                //         pageLength: 25,
                //         responsive: true,
                //     });
                //     $('#Loading3').hide();
                // });

} else if (type == 4) {

}
        }

function ApprovePayment(payment_id, status) {

let approve_remark = $("#approve_remark").val();
            let admin_id = localStorage.getItem("admin_id");

$.ajax({
                    type: "post",
                    url: "ajax/setting_member/update_status.php",
                    data: {
                        payment_id: payment_id,
                        status: status,
                        approve_remark: approve_remark,
                        admin_id: admin_id
                    },
                    dataType: "json",
                    success: function(data) {
                        if (data.result == 1) {
                            swal({
                                title: "แจ้งเตือน",
                                text: "บันทึกเรียบร้อยแล้ว",
                                type: "success"
                            }, function() {
                                $('#myModal').modal('hide');
                                swal.close();
                                GetData(1)
                                NonTicket()
                            })
                        } else if (data.result == 0) {
                            swal({
                                title: "แจ้งเตือน",
                                text: "ไม่สามารถบันทึกได้ กรุณาลองอีกครั้ง",
                                type: "error"
                            })
                        } else if (data.result == 9) {
                            swal({
                                title: "แจ้งเตือน",
                                text: "ติดต่อเซิฟเวอร์ไม่สำเร็จ กรุณาลองอีกครั้ง",
                                type: "error"
                            })
                        }
                    }
                });

});
        }

function ApproveMember(member_id, status, payment_status) {
            let remark = $("#remark").val();

if (status != 0) {

if (payment_status != 1) {
                    swal({
                        title: 'การชำระเงินยังไม่ผ่านการอนุมัติ',
                        text: '',
                        type: 'warning',
                        showConfirmButton: false,
                        timer: 1500
                    });
                    return false;
                }
            }

swal({
                title: 'กรุณายืนยันเพื่อทำรายการ',
                type: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#3085d6',
                cancelButtonColor: '#d33',
                cancelButtonText: 'ยกเลิก',
                confirmButtonText: 'ยืนยัน',
                closeOnConfirm: false
            }, function() {
                $.ajax({
                    type: "POST",
                    url: "ajax/setting_member/update_approve.php",
                    data: {
                        member_id: member_id,
                        status: status,
                        remark: remark
                    },
                    dataType: "json",
                    success: function(data) {
                        if (data.result == 1) {
                            swal({
                                title: 'บันทึกสำเร็จ',
                                type: 'success',
                                showConfirmButton: false,
                                timer: 1500
                            }, function() {
                                $("#myModal").modal('hide');
                                swal.close();
                                window.location.href = "index_setting_member";
                            });
                        } else if (data.result == 0) {
                            swal({
                                title: 'แจ้งเตือน',
                                text: '',
                                type: 'warning',
                                showConfirmButton: false,
                                timer: 1500
                            });
                        } else if (data.result == 9) {
                            swal({
                                title: 'แจ้งเตือน',
                                text: 'ไม่สามารถติดต่อเซิฟเวอร์ได้ กรุณาลองใหม่อีกครั้ง',
                                type: 'warning',
                                showConfirmButton: false,
                                timer: 1500
                            });
                        }
                    }
                });
            })
        }

function UpdatePayment(payment_id) {

var formData = new FormData($("#payment_slip")[0]);

$.ajax({
                type: "post",
                url: "ajax/setting_member/update_payment",
                data: formData,
                dataType: "json",
                cache: false,
                contentType: false,
                processData: false,
                success: function(responseData) {
                    if (responseData.status == 1) {
                        swal({
                            title: "แจ้งเตือน",
                            text: "แจ้งชำระเงินเรียบร้อยแล้ว",
                            type: "success"
                        }, function() {
                            swal.close();
                            $("#myModal").modal("hide");
                            GetData(1)
                        })
                    } else {
                        swal({
                            title: "แจ้งเตือน",
                            text: "ติดต่อเซิฟเวอร์ไม่สำเร็จกรุณาลองอีกครั้ง",
                            type: "error"
                        })
                    }
                }
            });
        }

</html>