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]);

$register_type = mysqli_real_escape_string($connection, $_POST["register_type"]);

$sql = "SELECT * FROM tbl_member_payment WHERE member_id = '$member_id'";
$res = mysqli_query($connection, $sql);
$row = mysqli_fetch_array($res);

$approve_result = $row['approve_result'];
$transfer_date = $row['transfer_date'];

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);

$arr['profile_image'] = ($row['profile_image'] != "") ? "https://efa-member.com/main/upload/join/" . $row['profile_image'] : 'https://efa-member.com/main/upload/join/no-image.jpg';

$sqlPayment = "SELECT * FROM `tbl_member_payment` WHERE `member_id` = '$member_id' ";
$rsPayment = mysqli_query($connection, $sqlPayment);
$rowPayment = mysqli_fetch_array($rsPayment);

$payment = ($rowPayment['transfer_date'] != "")? "ชำระสำเร็จ เมื่อ ".date("d/m/Y",strtotime($rowPayment['approve_datetime'])) : "รอตรวจสอบ";
$transfer_date = ($rowPayment['transfer_date'] != "")? "<div class='alert alert-success'>ชำระเงินแล้ว</div>" : "<a href=\"payment\" class=\"btn btn-info btn-sm w-75 mt-2 \">ชำระเงิน</a>";

$arr['payment'] = $payment;
$arr['transfer_date'] = $transfer_date;
$arr['remark'] = ($rowPayment['approve_remark'] != "" ? $rowPayment['approve_remark'] : "-");
$arr['approve'] = $rowPayment['approve_result'];
echo json_encode($arr);