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

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

// $sql = "SELECT * FROM $table WHERE member_id = '$member_id'";
$sql = "SELECT mem.* 
,detail.*
,payment.*
FROM tbl_member mem
LEFT JOIN tbl_member_detail detail ON detail.member_id = mem.member_id
LEFT JOIN tbl_member_payment payment ON payment.member_id = mem.member_id
WHERE mem.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['company_address'] . " " . $rowAddressCompany['district_name_th'] . " " . $rowAddressCompany['amphoe_name_th'] . " " . $rowAddressCompany['province_name_th'] . " " . $rowAddressCompany['district_zipcode'];
    // $companyAddress = $row['card_address'];
}

$invoiceAddress = "";
if ($row['invoice_district'] != "") {
    $invoice_district_id = $row['invoice_district'];
    $sqlAddressInvoice = "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` = '$invoice_district_id'";
    $rsAddressInvoice = mysqli_query($connection, $sqlAddressInvoice);
    $rowAddressInvoice = mysqli_fetch_array($rsAddressInvoice);
    $InvoiceAddress = $row['invoice_address'] . " " . $rowAddressInvoice['district_name_th'] . " " . $rowAddressInvoice['amphoe_name_th'] . " " . $rowAddressInvoice['province_name_th'] . " " . $rowAddressInvoice['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 ($row['register_level'] == 'g9k1s') {
    $register_level = 'ทั่วไป';
} elseif ($row['register_level'] == 'kki22') {
    $register_level = 'วิสามัญ';
} elseif ($row['register_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;
}

$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');
///// วันที่หมดอายุบัตรประจำตัว
if (!empty($row['card_expire_date'])) {
    $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>";
    }
} else {
    $card_exp_day = "";
}

///// วันที่หมดอายุ visa
if (!empty($row['visa_expire_date'])) {
    $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>";
    }
} else {
    $visa_exp_day = "";
}

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

<div class="ibox">
    <div class="ibox-content pt-3">
        <label for=""><b>ข้อมูลแรงงาน</b></label><br>
        <span id="member_name_en"><?php echo  $title_en . " " . $row['member_name_en']; ?></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="100px" height="120px" class="border" id="profile_image">
                </div>
                <div>
                    <a href="worker_edit?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>
                    <?php if ($row['approve_result'] == 1) { ?>
                        <a href="print/receipt?id=<?php echo $member_id ?>" target="_blank" class="btn btn-info btn-sm mb-2" style="width: 100%;">ใบเสร็จ</a>
                    <?php } ?>
                    <?php if (!empty($row['member_code'])) { ?>
                        <a href="print/member_card?id=<?php echo $member_id ?>" target="_blank" class="btn btn-primary btn-sm mb-2" style="width: 100%;">บัตรสมาชิก</a>
                    <?php } ?>
                    
                </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 . " " . $row['member_name']; ?></span>
                            </div>
                        </div>
                    <?php } ?>
                    <div class="col-md-4 col-12 ">
                        <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 ">
                        <div class="form-group">
                            <strong>สัญชาติ</strong><br>
                            <span id="citizen_no"><?php echo $country ?></span>
                        </div>
                    </div>

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

<div class="col-md-4 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-4 col-12 ">
                        <div class="form-group">
                            <strong>ระดับสมาชิก</strong><br>
                            <span id="member_level_name"><?php echo $register_level ?></span>
                        </div>
                    </div>
                </div>
                <div class="row">
                    <div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <?php if ($member_type == 3 || $member_type == 4) { ?>
                                <strong>หนังสือเดินทาง : </strong>
                            <?php } else { ?>
                                <strong>เลขบัตรประจำตัวประชาชน: </strong>
                            <?php } ?>

<?php if ($member_type == 3 || $member_type == 4) { ?>

<div class="col-md-4 col-12 ">
                            <div class="form-group">
                                <strong>ใบอนุญาติทำงาน : </strong>
                                <span id="work_permit"><?php echo $row['work_permit'] ?></span>
                                <br>
                                <strong>Exp. : </strong>
                                <span id="work_expire_date"><?php echo (!empty($row['work_expire_date'])) ? date('d M Y', strtotime($row['work_expire_date']+543)) : "-" ?></span> <?php echo $work_exp_day; ?>
                            </div>
                        </div>
                    <?php } ?>

<?php if ($member_type == 4) { ?>
                        <div class="col-md-4 col-12 ">
                            <div class="form-group">
                                <strong>Visa : </strong>
                                <span id="visa_no"><?php echo $row['visa_no'] ?></span>
                                <br>
                                <strong>Exp. : </strong>
                                <span id="visa_expire_date"><?php echo (!empty($row['visa_expire_date'])) ? date('d M Y', strtotime($row['visa_expire_date']+543)) : "-" ?> </span> <?php echo $visa_exp_day; ?>
                            </div>
                        </div>
                    <?php } ?>

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

<div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <strong>อีเมล</strong><br>
                            <span id="email"><?php echo $row['email'] ?></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 $row['company_phone'] ?></span>
                        </div>
                    </div>
                    <div class="col-md-4 col-12 ">
                        <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 ">
                        <div class="form-group">
                            <strong>line</strong><br>
                            <span id="company_line"><?php echo $row['company_line'] ?></span>
                        </div>
                    </div>
                    <div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <strong>เว็บไซต์</strong><br>
                            <span id="company_web"><?php echo $row['company_web'] ?></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 $row['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 $row['invoice_taxnumber'] ?></span>
                        </div>
                    </div>

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

<div class="col-md-4 col-12 ">
                        <div class="form-group">
                            <strong>เบอร์โทรติดต่อ</strong><br>
                            <span id="company_phone"><?php echo $row['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 $row['invoice_email'] ?></span>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>