invisio v2.0

<?php

include('../../../config/main_function.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 = 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]);
$arr['member_id'] = $member_id;

$register_type = mysqli_real_escape_string($connection, $_POST["register_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);

$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' ;

$arr['member_name'] = bigsara_decode($row['member_name'] , $key , $pointer);

$member_name_en = bigsara_decode($row['member_name_en'] , $key , $pointer); 
$arr['member_name_en'] = $member_name_en;

$arr['birth_date'] = ($row['birth_date'] != "")? date("d/m/Y",strtotime($row['birth_date'])) : "-" ;
$arr['race'] = $row['race'];
$arr['nationality'] = $row['nationality'];
$arr['religion'] = $row['religion'];
$arr['citizen_no'] = bigsara_decode($row['citizen_no'] , $key , $pointer);

$cardAddress = "";
if ($row['card_district_id'] != "") {
    $card_district_id = $row['card_district_id'];
    $sqlAddressCard = "SELECT `tbl_district`.`district_name_th` , `tbl_amphoe`.`amphoe_name_th` , `tbl_province`.`province_name_th` , `tbl_district`.`district_zipcode` FROM `tbl_district` 
    JOIN `tbl_amphoe` ON `tbl_amphoe`.`amphoe_id` = `tbl_district`.`ref_amphoe`
    JOIN `tbl_province` ON `tbl_province`.`province_id` = `tbl_amphoe`.`ref_province`
    WHERE `tbl_district`.`district_id` = '$card_district_id'";
    $rsAddressCard = mysqli_query($connection, $sqlAddressCard);
    $rowAddressCard = mysqli_fetch_array($rsAddressCard);
    $cardAddress = " ".$rowAddressCard['district_name_th']." ".$rowAddressCard['amphoe_name_th']." ".$rowAddressCard['province_name_th']." ".$rowAddressCard['district_zipcode'];
}

$arr['card_address'] = $row['card_address'].$cardAddress.$row['foreign_address'];
$arr['card_register_date'] = ($row['card_register_date'] != "")? date("d/m/Y",strtotime($row['card_register_date'])) : "-" ;
$arr['card_expire_date'] = ($row['card_expire_date'] != "")? date("d/m/Y",strtotime($row['card_expire_date'])) : "-" ;

$education_level = "-";

switch ($row['education_level']) {
    case '1': $education_level = "ปริญญาเอก"; break;
    case '2': $education_level = "ปริญญาโท"; break;
    case '3': $education_level = "ปริญญาตรี หรือ เทียบเท่า"; break;
    case '4': $education_level = "ต่ำกว่า ปริญญาตรี"; break;
}

$arr['education_level'] = $education_level;
$arr['license_no'] = $row['license_no'];
$arr['company_name'] = $row['company_name'];

$company_type = "-";
switch ($row['company_type']) {
    case '1': $company_type = "บุคคลธรรมดา"; break;
    case '2': $company_type = "นิติบุคคล"; break;
}
$arr['company_type'] = $company_type;
$arr['company_tax_no'] = $row['company_tax_no'];

$companyAddress = "";
if ($row['company_district_id'] != "") {
    $company_district_id = $row['company_district_id'];
    $sqlAddressCompany = "SELECT `tbl_district`.`district_name_th` , `tbl_amphoe`.`amphoe_name_th` , `tbl_province`.`province_name_th` , `tbl_district`.`district_zipcode` FROM `tbl_district` 
    JOIN `tbl_amphoe` ON `tbl_amphoe`.`amphoe_id` = `tbl_district`.`ref_amphoe`
    JOIN `tbl_province` ON `tbl_province`.`province_id` = `tbl_amphoe`.`ref_province`
    WHERE `tbl_district`.`district_id` = '$company_district_id'";
    $rsAddressCompany = mysqli_query($connection, $sqlAddressCompany);
    $rowAddressCompany = mysqli_fetch_array($rsAddressCompany);
    $companyAddress = " ".$rowAddressCompany['district_name_th']." ".$rowAddressCompany['amphoe_name_th']." ".$rowAddressCompany['province_name_th']." ".$rowAddressCompany['district_zipcode'];
}

$arr['company_address'] = $row['company_address'].$companyAddress;

$arr['phone'] = bigsara_decode($row['phone'] , $key , $pointer);
$arr['fax'] = bigsara_decode($row['fax'] , $key , $pointer);
$arr['email'] = bigsara_decode($row['email'] , $key , $pointer);

$arr['company_address'] = $row['company_address'].$companyAddress;
$arr['company_phone'] = bigsara_decode($row['company_phone'] , $key , $pointer);
$arr['company_fax'] = bigsara_decode($row['company_fax'] , $key , $pointer);
$arr['company_email'] = bigsara_decode($row['company_email'] , $key , $pointer);
$arr['company_line'] = bigsara_decode($row['company_line'] , $key , $pointer);
$arr['company_web'] = bigsara_decode($row['company_web'] , $key , $pointer);
$arr['license_register_date'] = ($row['license_register_date'] != "")? date("d/m/Y",strtotime($row['license_register_date'])) : "x" ;
$arr['license_expire_date'] = ($row['license_expire_date'] != "")? date("d/m/Y",strtotime($row['license_expire_date'])) : "x" ;
$arr['department'] = $row['department'];
$arr['position'] = $row['position'];

$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 = ($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'] = $transfer;
$arr['approve_result'] = $rowPayment['approve_result'];

for ($i=1; $i <= 4 ; $i++) { 
    $arr['document_file1'] = $rowPayment['document_file1'];
}

$arr['age'] = date("Y")-date("Y",strtotime($row['birth_date']));

echo json_encode($arr);