invisio v2.0

<?php

use function PHPSTORM_META\type;

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

$ref_member_id = mysqli_real_escape_string($connection, $_POST['ref_member_id']);
$temp_id = explode(".", $ref_member_id);
$ref_member_id = bigsara_decode($temp_id[0], $temp_id[1]);

$type = mysqli_real_escape_string($connection, $_POST['type']);
$level = mysqli_real_escape_string($connection, $_POST['level']);
$search = mysqli_real_escape_string($connection, $_POST['search']);
$payment_status = mysqli_real_escape_string($connection, $_POST['payment_status']);
$approve_status = mysqli_real_escape_string($connection, $_POST['approve_status']);

// $condition_type = "";
// if ($type == 'x') {
//     $condition_type .= "AND NOT mem.register_type = '0' ";
// } else {
//     $condition_type .= "AND mem.register_type = '$type'";
// }

// $condition_level = "";
// if ($level != 'x') {
//     $condition_level .= "AND mem.register_level = '$level'";
// }

// $condition_search = "";
// if ($search != "") {
//     $condition_search  .= "AND detail.citizen_no LIKE '%$search%'";
// }

// $condition_status = "";
// if ($payment_status != 'x') {
//     $condition_status  .= "AND payment.approve_result = '$payment_status'";
// }

// $condition_approve = "";
// if ($approve_status == 9) {
//     $condition_approve  .= "AND mem.approve_status IS NULL";
// } else if ($approve_status != 'x') {
//     $condition_approve  .= "AND mem.approve_status = '$approve_status'";
// }

$sql_member = "SELECT mem.*,
detail.*,
payment.transfer_date,
payment.approve_result,
payment.payment_id,
payment.slip_image
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.register_status = '1' AND mem.ref_member_id = '$ref_member_id' $condition_search 
ORDER BY register_no ASC";
$rs_member = mysqli_query($connection, $sql_member) or die($connection->error);

?>
<style>

</style>
<div class="table-responsive">
    <table class="table table-striped dataTables-example table-bordered">
        <thead>
            <tr>
                <th class="text-center">รูปภาพ</th>
                <th class="text-center">ใบสมัคร</th>
                <th class="w-auto text-center">รายละเอียด</th>
                <th class="w-auto text-center">บริษัท</th>
                <th class="w-auto text-center">จัดการ</th>
            </tr>
        </thead>
        <tbody>
            <?php $i = 1;
            while ($row_member = mysqli_fetch_assoc($rs_member)) {

$member_id = $row_member['member_id'];

// $register_type = $row_member['register_type'];

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

// $register_level = $row_member['register_level'];

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

$citizen_no = $row_member['citizen_no'];
                $work_permit = $row_member['work_permit'];

$date_now = date('Y-m-d');
                ///// วันที่หมดอายุบัตรประจำตัว
                if (!empty($row_member['card_expire_date'])) {
                    $card_exp_date = $row_member['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_member['visa_expire_date'])) {
                    $visa_exp_date = $row_member['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_member['work_expire_date'])) {
                    $work_exp_date = $row_member['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 = "";
                }

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

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

$sql = "SELECT * FROM tbl_register_document WHERE member_type = '{$row_member['register_type']}' ORDER BY list_order ASC";
                $rs = mysqli_query($connection, $sql);
                $num_list = mysqli_num_rows($rs);

?>
                <tr>
                    <td class="text-center"  style="width:10%;">
                        <img src="../main/upload/join/<?php echo ($row_member['profile_image']) ? $row_member['profile_image'] : "no-image.jpg" ?>" alt="" width="100px" height="120px">
                    </td>
                    <td style="width:20%;">
                        <?php if (empty($row_member['member_code'])) { ?>
                            <a href="worker_detail?id=<?php echo $member_id ?>&type=<?php echo $row_member['register_type'] ?>&level=<?php echo $row_member['register_level'] ?>" target="_blank"><?php echo $row_member['register_no'] ?></a>
                        <?php } else { ?>
                            <a href="worker_detail?id=<?php echo $member_id ?>&type=<?php echo $row_member['register_type'] ?>&level=<?php echo $row_member['register_level'] ?>" target="_blank"><?php echo $row_member['member_code'] ?></a>
                        <?php } ?>
                        <br>
                        <?php echo $title_th . " " . $row_member['member_name'] ?><br>
                        <?php echo $title_en . " " . $row_member['member_name_en'] ?>
                        <br>
                        
                        วันเกิด : <?php echo (!empty($row_member['birth_date'])) ? date('d M Y', strtotime($row_member['birth_date']+543)) . " ( " .( date("Y") - date("Y", strtotime($row_member['birth_date']))) . " ปี )" : "-"  ?>
                        <br>
                        <span class="badge badge-info p-2"><?php echo $row_race['ct_nameTHA']; ?></span>
                        
                    </td>
                    <td style="width:20%;">
                        ID / Pass : <?php echo $citizen_no ?><br>
                        Exp : <?php echo (!empty($row_member['card_expire_date'])) ? date('d M Y', strtotime($row_member['card_expire_date']+543)) : "-" ?>
                        <?php echo $card_exp_day; ?>
                        <br>
                        <?php if ($row_member['register_type'] == 4) { ?>
                            Visa :
                            <?php echo $row_member['visa_no'] ?><br>
                            Exp : <?php echo (!empty($row_member['visa_expire_date'])) ? date('d M Y', strtotime($row_member['visa_expire_date']+543)) : "-" ?>
                            <?php echo $visa_exp_day; ?>
                            <br>
                            WP :
                            <?php echo $work_permit ?><br>
                            Exp : <?php echo (!empty($row_member['work_expire_date'])) ? date('d M Y', strtotime($row_member['work_expire_date']+543)) : "-" ?>
                            <?php echo $work_exp_day; ?>
                        <?php } ?>
                    </td>
                    <td>
                        <?php echo $row_member['company_name'] ?> <br>
                        โทร : <?php echo $row_member['company_phone']; ?><br>
                        Email : <?php echo $row_member['company_email']; ?><br>

</td>
                    <td class="text-center" style="width: 15%;">

<?php if (empty($row_member['document_approve'])) { ?>
                            <div class="btn badge-warning btn-xs p-1 mb-2 w-75" onclick="UpdateDocStatus('<?php echo $row_member['member_id'] ?>','<?php echo $row_member['register_type'] ?>','<?php echo $row_member['register_level'] ?>')">รอตรวจเอกสาร</div>
                        <?php } else if ($row_member['document_approve'] == '1') { ?>
                            <div class="btn badge-primary btn-xs p-1 mb-2 w-75" onclick="UpdateDocStatus('<?php echo $row_member['member_id'] ?>','<?php echo $row_member['register_type'] ?>','<?php echo $row_member['register_level'] ?>')">ตรวจเอกสารแล้ว</div>
                        <?php } else if ($row_member['document_approve'] == '9') { ?>
                            <div class="btn badge-danger btn-xs p-1 mb-2 w-75" onclick="UpdateDocStatus('<?php echo $row_member['member_id'] ?>','<?php echo $row_member['register_type'] ?>','<?php echo $row_member['register_level'] ?>')">รอแก้ไข</div>
                        <?php } ?>

<a href="https://efa-member.com/main/print/print_all_doc?id=<?php echo $member_id ?>" class="btn btn-success btn-xs mb-2" target="_blank" id="btn_print"><i class="fa fa-file"></i></a>

<?php if (empty($row_member['transfer_date'])) { ?>
                            <button class="btn btn-warning btn-xs mb-2 w-75" onclick="GetModalEdit('<?php echo $row_member['payment_id'] ?>')">รอชำระเงิน</button>
                            <a class="btn btn-danger btn-xs mb-2 text-white" target="_blank" id="btn_slip"><i class="fa fa-close"></i></a>

<?php } else {
                            if ($row_member['approve_result'] == '1') {
                            ?>
                                <button class="btn btn-primary btn-xs mb-2 w-75" onclick="GetModalEdit('<?php echo $row_member['payment_id'] ?>')">อนุมัติแล้ว</button>
                                <a href="https://efa-member.com/backoffice/print/receipt_new?id=<?php echo $row_member['member_id'] ?>" class="btn btn-success btn-xs mb-2 " target="_blank" id="btn_slip"><i class="fa fa-file"></i></a>
                            <?php } else if ($row_member['approve_result'] == '0') { ?>
                                <button class="btn btn-danger btn-xs mb-2 w-75" onclick="GetModalEdit('<?php echo $row_member['payment_id'] ?>')">ปฏิเสธ</button>
                                <a href="../main/upload/slip/<?php echo ($row_member['slip_image']) ? $row_member['slip_image'] : "no-image.png" ?>" class="btn btn-success btn-xs mb-2 " target="_blank" id="btn_slip"><i class="fa fa-file"></i></a>
                            <?php } else { ?>
                                <button class="btn btn-info btn-xs mb-2 w-75" onclick="GetModalEdit('<?php echo $row_member['payment_id'] ?>')">รออนุมัติ</button>
                                <a href="../main/upload/slip/<?php echo ($row_member['slip_image']) ? $row_member['slip_image'] : "no-image.png" ?>" class="btn btn-success btn-xs mb-2 " target="_blank" id="btn_slip"><i class="fa fa-file"></i></a>
                            <?php } ?>

<?php } ?>

<?php if (empty($row_member['approve_status'])) { ?>
                            <button class="btn badge-warning btn-xs p-1 mb-2 w-75" onclick="certification('<?php echo $row_member['member_id'] ?>','<?php echo $row_member['approve_result']; ?>')">รอส่งกรรมการ</button>
                            <a class="btn btn-danger btn-xs mb-2 text-white" target="_blank" id="btn_slip"><i class="fa fa-close"></i></a>
                            <?php } else {
                            if ($row_member['approve_status'] == 1 && empty($row_member['member_code'])) { ?>
                                <button class="btn badge-info btn-xs p-1 mb-2 w-75">รอรับรอง</button>
                                <a class="btn btn-danger btn-xs mb-2 text-white" target="_blank" id="btn_slip"><i class="fa fa-close"></i></a>
                            <?php } else if ($row_member['approve_status'] == 1 && !empty($row_member['member_code'])) { ?>
                                <button class="btn badge-primary btn-xs p-1 mb-2 w-75">รับรองแล้ว</button>
                                <a href="print/member_card?id=<?php echo $row_member['member_id'] ?>" class="btn btn-success btn-xs mb-2" target="_blank" id="btn_slip"><i class="fa fa-id-card"></i></a>
                        <?php }
                        } ?>
                        <a class="btn btn-danger btn-xs text-white mb-2 w-100">ยกเลิกสมาชิก</a>
                    </td>
                </tr>
            <?php $i++;
            } ?>
        </tbody>
    </table>
</div>