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 $table 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 = $row['card_address'] . " " . $rowAddressCard['district_name_th'] . " " . $rowAddressCard['amphoe_name_th'] . " " . $rowAddressCard['province_name_th'] . " " . $rowAddressCard['district_zipcode'];
    $cardAddress = $row['card_address'];
}

$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 = $row['card_address']. " " . $rowAddressCompany['district_name_th'] . " " . $rowAddressCompany['amphoe_name_th'] . " " . $rowAddressCompany['province_name_th'] . " " . $rowAddressCompany['district_zipcode'];
    $companyAddress = $row['card_address'];
}

$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'";
$rsPayment = mysqli_query($connection, $sqlPayment);
$rowPayment = mysqli_fetch_array($rsPayment);
$payment = ($rowPayment['approve_datetime'] != "") ? "ชำระสำเร็จ เมื่อ " . date("d/m/Y", strtotime($rowPayment['approve_datetime'] + 543)) : "รอตรวจสอบ";

$sql_race = "SELECT * FROM tbl_country WHERE ct_code = '{$row['race']}'";
$res_race = mysqli_query($connection, $sql_race);
$row_race = mysqli_fetch_assoc($res_race);

$country = $row_race['ct_nameTHA'];

$date_now = date('Y-m-d');
///// วันที่หมดดอายุ passport

$pass_exp_date = $row['passport_expire_date'];
$cal_pass_date = strtotime($pass_exp_date) - strtotime($date_now);
$pass_exp_day = floor($cal_pass_date / 86400);
if ($pass_exp_day < 0) {
    $pass_exp_day = "<span style='color: #FF0000;'>[ขาด " . substr($pass_exp_day, 1) . "วัน]</span>";
} else {
    $pass_exp_day = "<span style='color: #5480FF;'>[อีก $pass_exp_day วัน]</span>";
}

///// วันที่หมดอายุ visa
$visa_exp_date = $row['visa_expire_date'];
$cal_visa_date = strtotime($visa_exp_date) - strtotime($date_now);
$visa_exp_day = floor($cal_visa_date / 86400);
if ($visa_exp_day < 0) {
    $visa_exp_day = "<span style='color: #FF0000;'>[ขาด " . substr($visa_exp_day, 1) . "วัน]</span>";
} else {
    $visa_exp_day = "<span style='color: #5480FF;'>[อีก $visa_exp_day วัน]</span>";
}

///// วันที่หมดอายุ visa
$card_exp_date = $row['card_expire_date'];
$cal_card_date = strtotime($card_exp_date) - strtotime($date_now);
$card_exp_day = floor($cal_card_date / 86400);
if ($card_exp_day < 0) {
    $card_exp_day = "<span style='color: #FF0000;'>[ขาด " . substr($card_exp_day, 1) . "วัน]</span>";
} else {
    $card_exp_day = "<span style='color: #5480FF;'>[อีก $card_exp_day วัน]</span>";
}
?>

<div class="ibox">
    <div class="ibox-content pt-3">
        <label for=""><b>ข้อมูลสมาชิก</b></label><br>
        <span id="member_name_en"><?php echo  $title_en . " " . bigsara_decode($row['member_name_en'], $key, $pointer); ?></span><br>
        หมายเลขใบสมัคร : <?php echo $row['register_no']; ?><br>
        หมายเลขสมาชิก : <?php echo $row['member_code'] ? $row['member_code'] : "รอรับรองการเป็นสาชิก"; ?><br>
        <hr>
        <div class="row">
            <div class="col-md-2 col-xs-12">
                <div class="text-center mb-2">
                    <img src="../main/upload/join/<?php echo ($row['profile_image'] != '' ? $row['profile_image'] : 'no-image.jpg') ?>" alt="" width="100%" class="border" id="profile_image">
                </div>
                <div>
                    <a href="edit_member?id=<?php echo $_POST['member_id'] ?>&type=<?php echo $member_type ?>&level=<?php echo $member_level ?>" class="btn btn-warning btn-sm w-100 mb-2">แก้ไขข้อมูล</a>
                    
                </div>
            </div>
            <div class="col-10">
                <div class="row">
                    
                    <div class="col-md-12 col-12">  
                        <label for=""><b>1.ข้อมูลสมัครสมาชิก</b></label><br>
                    </div>
                    <?php if ($member_type != 4) { ?>
                        <div class="col-md-4 col-12">
                            <div class="form-group">
                                <strong>ชื่อ - นามสกุล</strong><br>
                                <span id="member_name"><?php echo $title_th . " " . bigsara_decode($row['member_name'], $key, $pointer); ?></span>
                            </div>
                        </div>
                    <?php } ?>
                    <div class="col-md-3 col-12 ">
                        <div class="form-group">
                            <strong>ชื่อ - นามสกุล ภาษาอังกฤษ</strong><br>
                            <span id="member_name_en"><?php echo  $title_en . " " . bigsara_decode($row['member_name_en'], $key, $pointer); ?></span>
                        </div>
                    </div>

<div class="col-md-3 col-12 ">
                        <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-3 col-12 ">
                        <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-3 col-12 ">
                        <div class="form-group">
                            <strong>สัญชาติ</strong><br>
                            <span id="citizen_no"><?php echo $country ?></span>
                        </div>
                    </div>
                    <div class="col-md-3 col-12 ">
                        <div class="form-group">
                            <strong>ประเภทการสมัคร</strong><br>
                            <span id="register_type_name"><?php echo $register_type ?></span>
                        </div>
                    </div>
                    <div class="col-md-9 col-12 ">
                        <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 ">
                        <div class="form-group">
                            <strong>Passport : </strong>
                            <span id="passport_no"><?PHP echo bigsara_decode($row['passport_no'], $key, $pointer) ?></span>
                            <br>
                            <strong>Exp. : </strong>
                            <span id="passport_expire_date"><?php echo  date("d/m/", strtotime($row['passport_expire_date'])) . date("Y", strtotime($row['passport_expire_date'] + 543)) ?> </span> <?php echo $pass_exp_day; ?>
                        </div>
                    </div>
                    <div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <strong>Visa : </strong>
                            <span id="visa_no"><?php echo bigsara_decode($row['visa_no'], $key, $pointer) ?></span>
                            <br>
                            <strong>Exp. : </strong>
                            <span id="visa_expire_date"><?php echo  date("d/m/", strtotime($row['visa_expire_date'])) . date("Y", strtotime($row['visa_expire_date'] + 543)) ?> </span> <?php echo $visa_exp_day; ?>
                        </div>
                    </div>
                    <div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <strong>ใบอนุญาติทำงาน : </strong>
                            <span id="citizen_no"><?php echo bigsara_decode($row['citizen_no'], $key, $pointer) ?></span>
                            <br>
                            <strong>Exp. : </strong>
                            <span id="card_expire_date"><?php echo  date("d/m/", strtotime($row['card_expire_date'])) . date("Y", strtotime($row['card_expire_date'] + 543)) ?></span> <?php echo $card_exp_day; ?>
                        </div>
                    </div>

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

<div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <strong>อีเมล</strong><br>
                            <span id="email"><?php echo bigsara_decode($row['email'], $key, $pointer) ?></span>
                        </div>
                    </div>
                    <?php if ($member_type == '1' || $member_type == '2') { ?>
                        <div class="col-md-4 col-12 ">
                            <div class="form-group">
                                <strong>วุฒิการศึกษาสูงสุด</strong><br>
                                <span id="education_level"><?php echo $education_level ?></span>
                            </div>
                        </div>
                    <?php } ?>

<div class="col-md-12 col-12">
                        <hr>
                        <label for="" class="mt-3"><b>2.ข้อมูลการทำงาน</b></label>
                    </div>
                    <div class="col-md-4 col-12 ">
                        <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 ">
                        <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 ">
                        <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 ">
                            <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 ">
                            <div class="form-group">
                                <strong>อนุญาตถึงวันที่</strong><br>
                                <span id="license_expire_date">
                                    <?php echo date("d/m/", strtotime($row['license_expire_date'])) . date("Y", strtotime($row['license_expire_date'] + 543)) ?>
                                </span>
                            </div>
                        </div>
                    <?php } ?>

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

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

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

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

<div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <strong>เบอร์โทรติดต่อ</strong><br>
                            <span id="company_phone"><?php echo $rowPayment['invoice_phone'] ?></span>
                        </div>
                    </div>
                    <div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <strong>อีเมล</strong><br>
                            <span id="company_email"><?php echo $rowPayment['invoice_email'] ?></span>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>