invisio v2.0

<?php

include('../../../config/main_function.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);

$member_id = mysqli_real_escape_string($connection, $_POST["member_id"]);
$temp_member_id = explode(".", $member_id);
$member_id = bigsara_decode($temp_member_id[0], $temp_member_id[1]);

$sql = "SELECT *,(SELECT register_type FROM tbl_member WHERE `member_id` = '$member_id' ) AS register_type FROM `tbl_member_payment` WHERE `member_id` = '$member_id' ORDER BY `create_datetime` DESC LIMIT 1";
$rs = mysqli_query($connection, $sql);
$row = mysqli_fetch_array($rs);

$gb_ref = $row["gb_ref_no"];
$payment_id = $row["payment_id"];
$coupon_id = $row["coupon_id"];

if (!empty($coupon_id)) {
    $sql_coupon = "SELECT * FROM tbl_discount_coupon WHERE coupon_id ='$coupon_id'";
    $res_coupon = mysqli_query($connection, $sql_coupon);
    $row_coupon = mysqli_fetch_assoc($res_coupon);
    $package_price = $row['payment_amount'] - $row_coupon['discount_amount'];

$coupon_code = $row_coupon['coupon_code'];

} else {
    $package_price = $row['payment_amount'];
}

switch ($row['member_level']) {
    case 'g9k1s':
        $level = "ทั่วไป";
        break;
    case 'kki22':
        $level = "วิสามัญ";
        break;
    case 'x9fkq':
        $level = "สามัญ";
        break;
    case '6foes':
        $level = "กิตติมศักดิ์";
        break;
}

switch ($row['register_type']) {
    case '1':
        $type = "นายจ้าง";
        break;
    case '2':
        $type = "บนจ.";
        break;
    case '3':
        $type = "Agency";
        break;
    case '4':
        $type = "แรงงาน";
        break;
}

$secret_key = "EsfFkLjzSaK56YrsnARsAY7DnmSmnbF5";
$headers = array('Accept' => 'application/x-www-form-urlencoded');
$data = [
    'token' => "3FD4Imt0GzjkPAzKCQoELXsa2HIPJW26CwDz3vhiYe7wMstwVJ9QG5xu0LRypGV5PG0RBsocrrB7rNceuLKLcUsIjAx4pamwgKzKiHGmyc9ADiwavdmVi3lvRxssBr7WG2aaTgUjShMyJ//Mm+0jGiB857uj4miMxRoNWDeXE7+RmAeq",
    'amount' => number_format($package_price, 2, '.', ''),
    'referenceNo' => $gb_ref,
    'backgroundUrl' => "https://efa-member.com/main/ajax/payment/GBPrimeWebhook"
];

$payload = json_encode($data);

$ch = curl_init('https://api.gbprimepay.com/gbp/gateway/qrcode/text');
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_USERPWD, $secret_key . ':');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

$result = curl_exec($ch);

curl_close($ch);

$chargeResp = json_decode($result, true);

$urlQRCode = 'https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=' . $chargeResp['qrcode'];

$sql_bank = "SELECT * FROM tbl_bank";
$res_bank = mysqli_query($connection, $sql_bank);
$row_bank = mysqli_fetch_assoc($res_bank);

?>
<style>
    .line_through {
        text-decoration: line-through;
    }
</style>
<div class="text-center">
    <h2 class="font-bold">ชำระเงินค่าสมัคร</h2>
    <p><strong>ประเภท :</strong> <?php echo $type; ?></p>
    <p><strong>ระดับสมาชิก :</strong> <?php echo $level; ?> </p>
    <p id="discount" hidden><strong>ส่วนลด :</strong> <?php echo $row_coupon['discount_amount']; ?> <span><button class="badge bg-danger" onclick="DelCoupon()">ลบ</button></span></p>
    <p><strong>ค่าสมัคร รายปี :</strong> <span id="payment_amount"><?php echo number_format($row['payment_amount']); ?></span> <span id="total_dis" class="" hidden><?php echo number_format($package_price); ?></span></p>
    <button class="btn btn-success" onclick="DiscountModal()">กรอกโค้ดส่วนลด</button>
</div>
<hr>
<div class="row mb-3 border-bottom pb-3">
    <div class="col-6">
        <button class="btn btn-primary btn-xs btn-block btn-payment" type="button" data-id="#showFrom">
            <i class="fa fa-5x fa-money"></i><br>
            แนบหลักฐาน
        </button>
    </div>
    <div class="col-6">
        <button class="btn btn-default btn-xs btn-block btn-payment" type="button" data-id="#showQr">
            <i class="fa fa-5x fa-qrcode"></i><br>
            QR Payment
        </button>
    </div>
</div>
<div id="showFrom" class="from-payment">
    <form id="formPayment" method="post" enctype="multipart/form-data">
        <input type="hidden" name="payment_id" id="payment_id" value="<?php echo $payment_id; ?>">
        <input type="hidden" name="member_id" id="member_id" value="<?php echo $member_id; ?>">
        <div class="row">
            <div class="col-3 mb-3">
                <img src="../../backoffice/img/<?php echo $row_bank['logo'] ?>" class="w-100" />
                
            </div>
            <div class="col-9 mb-3">
                <strong><?php echo $row_bank['bank_name'] ?></strong><br>
                <strong>เลขที่บัญชี : </strong><?php echo $row_bank['account_number'] ?><br>
                <strong>ชื่อบัญชี : </strong><?php echo $row_bank['account_name'] ?><br>
            </div>

<div class="col-12 mb-3">
                <label for="">หลักฐานการชำระเงิน</label>
                <div class="custom-file">
                    <input id="slip_image" name="slip_image" type="file" class="custom-file-input" onchange="validateFileImageType(this)">
                    <label for="slip_image" class="custom-file-label">Choose file...</label>
                </div>
            </div>
            <div class="col-12">
                <label for="">วันที่โอน</label>
                <div class="form-group" id="data_1">
                    
                    <div class="input-group date">
                        <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                        <input type="text" class="form-control bg-white date" id="transfer_date" name="transfer_date" value="<?php echo date("d/m/Y") ?>" readonly>
                    </div>
                </div>
            </div>
            <div class="col-12">
                <label for="">เวลาที่โอน</label>
            </div>
            <div class="col-6 mb-3">
                <select name="transfer_time_h" id="transfer_time_h" class="form-control">
                    <?php for ($i = 0; $i <= 23; $i++) : ?>
                        <option value="<?php echo str_pad($i, 2, "0", STR_PAD_LEFT); ?>" <?php if (date('H') == $i) : ?> selected <?php endif; ?>>
                            <?php echo str_pad($i, 2, "0", STR_PAD_LEFT); ?>
                        </option>
                    <?php endfor; ?>
                </select>

</div>
            <div class="col-6 mb-3">
                <select name="transfer_time_m" id="transfer_time_m" class="form-control">
                    <?php for ($i = 0; $i <= 59; $i++) : ?>
                        <option value="<?php echo str_pad($i, 2, "0", STR_PAD_LEFT); ?>" <?php if (date('i') == $i) : ?> selected <?php endif; ?>>
                            <?php echo str_pad($i, 2, "0", STR_PAD_LEFT); ?>
                        </option>
                    <?php endfor; ?>
                </select>
            </div>

<div class="col-12">
                <button class="btn btn-block btn-primary" type="button" id="submitPayment">แจ้งชำระเงิน</button>
            </div>
        </div>
    </form>
</div>
<div id="showQr" style="display: none;" class="from-payment text-center p-3">
    <img src="<?php echo $urlQRCode; ?>" alt="" class="w-75">
</div>

});

var mem = $("#data_1 .input-group.date").datepicker({
        startView: 0,
        todayBtn: "linked",
        keyboardNavigation: false,
        forceParse: false,
        autoclose: true,
        format: "dd/mm/yyyy"
    })

function DiscountModal() {
        $("#myModal").modal("show");
        $("#showModal").load("ajax/payment/modal_discount.php", "data", function(response, status, request) {
            this; // dom element

});
    }

function SaveCoupon() {
        let coupon_code = $("#coupon_code").val();
        let payment_id = '<?php echo $payment_id; ?>';

$.ajax({
            type: "POST",
            url: "ajax/payment/update_coupon.php",
            data: {
                coupon_code: coupon_code,
                payment_id: payment_id
            },
            dataType: "json",
            success: function(data) {
                if (data.result == 1) {
                    $("#myModal").modal("hide");
                    getForm();
                }else if (data.result == 'no_coupon') {
                    swal({
                        title: 'ไม่พบโค้ดส่วนลด',
                        text: 'กรุณาตรวจสอบโค้ดส่วนลดของท่าน',
                        type: 'warning',
                        showConfirmButton: false,
                        timer: 1500
                    });
                }else if (data.result == 'expire_date') {
                    swal({
                        title: 'โค้ดส่วนลดหมดอายุ',
                        text: 'กรุณาตรวจสอบโค้ดส่วนลดของท่าน',
                        type: 'warning',
                        showConfirmButton: false,
                        timer: 1500
                    });
                }
            }
        });

}
    function DelCoupon(){