invisio v2.0

<?php
session_start();
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]);

$member_type = mysqli_real_escape_string($connection, $_POST['member_type']);
$member_level = mysqli_real_escape_string($connection, $_POST['member_level']);

if ($member_type == '1') {
    $table = "tbl_member_detail_employer";
} else if ($member_type == '2') {
    $table = "tbl_member_detail_company";
} else if ($member_type == '3') {
    $table = "tbl_member_detail_agency";
} else if ($member_type == '4') {
    $table = "tbl_member_detail_worker";
}

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

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

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

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

if ($member_type == 1) {
    $register_type = 'นายจ้าง';
} elseif ($member_type == 2) {
    $register_type = 'บนจ.';
} elseif ($member_type == 3) {
    $register_type = 'Agency';
} elseif ($member_type == 4) {
    $register_type = 'แรงงาน';
}

if ($member_level == 'g9k1s') {
    $register_level = 'ทั่วไป';
} elseif ($member_level == 'kki22') {
    $register_level = 'วิสามัญ';
} elseif ($member_level == 'x9fkq') {
    $register_level = 'สามัญ.';
}

$temp_title = explode(" ",getTitle_name($row['title_name']));
$title_th = $temp_title[0];
$title_en = $temp_title[2];

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

$sqlPayment = "SELECT * FROM `tbl_member_payment` WHERE `member_id` = '$member_id' AND `approve_datetime` IS NOT NULL ";
$rsPayment = mysqli_query($connection, $sqlPayment);
$rowPayment = mysqli_fetch_array($rsPayment);
$payment = ($rowPayment['approve_datetime'] != "") ? "ชำระสำเร็จ เมื่อ " . date("d/m/Y", strtotime($rowPayment['approve_datetime'] + 543)) : "รอตรวจสอบ";

<div class="ibox">
    <div class="ibox-content pt-3">
        <label for=""><b>ข้อมูลสมาชิก</b></label><br>
        <hr>
        <div class="row">
            <div class="col-md-12 text-center mb-5">
                <img src="../main/upload/join/<?php echo ($row['profile_image'] != '' ? $row['profile_image'] : 'no-image.jpg') ?>" alt="" width="120px" height="150" class="border" id="profile_image">
            </div>

<div class="col-md-12 col-12 mb-3">
                <label for=""><b>1.ข้อมูลสมัครสมาชิก</b></label><br>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>ชื่อ - นามสกุล</strong><br>
                    <span id="member_name"><?php echo $title_th ." ".$row['member_name']; ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>ชื่อ - นามสกุล ภาษาอังกฤษ</strong><br>
                    <span id="member_name_en"><?php echo  $title_en ." ".$row['member_name_en']; ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>ประเภทการสมัคร</strong><br>
                    <span id="register_type_name"><?php echo $register_type ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>ระดับสมาชิก</strong><br>
                    <span id="member_level_name"><?php echo $register_level ?></span>
                </div>
            </div>

<div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>วันเดือนปี เกิด</strong><br>
                    <span id="birth_date"><?php echo  date("d/m/", strtotime($row['birth_date'] )).date("Y", strtotime($row['birth_date'] + 543)) ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>อายุ</strong><br>
                    <span id="age"><?php echo  date("Y") - date("Y", strtotime($row['birth_date'])) ?></span>
                </div>
            </div>

<div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>เลขบัตรประจำตัวประชาชน / หนังสือเดินทาง</strong><br>
                    <span id="citizen_no"><?PHP echo $row['citizen_no'] ?></span>
                </div>
            </div>

<div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>เบอร์โทรติดต่อ</strong><br>
                    <span id="phone"><?php echo $row['phone'] ?></span>
                </div>
            </div>

<div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>อีเมล</strong><br>
                    <span id="email"><?php echo $row['email'] ?></span>
                </div>
            </div>

<div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>วุฒิการศึกษาสูงสุด</strong><br>
                    <span id="education_level"><?php echo $education_level ?></span>
                </div>
            </div>

<div class="col-md-12 col-12 mb-3">
                <label for="" class="mt-3"><b>2.ข้อมูลการทำงาน</b></label>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>ชื่อสถานประกอบการ</strong><br>
                    <span id="company_name"><?php echo $row['company_name'] ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>เลขที่ประจำตัวผู้เสียภาษี</strong><br>
                    <span id="company_tax_no"><?php echo $row['company_tax_no'] ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>ตำแหน่งงาน</strong><br>
                    <span id="position"><?php echo $row['position'] ?></span>
                </div>
            </div>

<?php if ($member_type == '2' || $member_type == '3') { ?>
                <div class="col-md-4 col-12 mb-3">
                    <div class="form-group">
                        <strong>เลขที่ใบอนุญาตกรมจัดหางานเลขที่</strong><br>
                        <span id="license_no"><?php echo $row['license_no'] ?></span>
                    </div>
                </div>
                <div class="col-md-4 col-12 mb-3">
                    <div class="form-group">
                        <strong>อนุญาตถึงวันที่</strong><br>
                        <span id="license_expire_date"><?php echo date("d/m/Y", strtotime($row['license_expire_date'] + 543)) ?></span>
                    </div>
                </div>
            <?php } ?>

<div class="col-12  mb-3">
                <div class="form-group">
                    <strong>ที่อยู่สถานประกอบการ</strong><br>
                    <span id="company_address"><?php echo $companyAddress ?></span>
                </div>
            </div>

<div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>เบอร์โทรติดต่อ</strong><br>
                    <span id="company_phone"><?php echo $row['company_phone'] ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>อีเมล</strong><br>
                    <span id="company_email"><?php echo $row['company_email'] ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>line</strong><br>
                    <span id="company_phone"><?php echo $row['company_phone'] ?></span>
                </div>
            </div>
            <div class="col-md-4 col-12 mb-3">
                <div class="form-group">
                    <strong>เว็บไซต์</strong><br>
                    <span id="company_email"><?php echo $row['company_email'] ?></span>
                </div>
            </div>
        </div>
    </div>
</div>