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

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

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

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

$condition_search = "";
if ($search != "") {
    $search = bigsara_encode($search, $key, $pointer);
    $condition_search  .= "AND c.citizen_no LIKE '%$search%' 
    OR d.citizen_no LIKE '%$search%' 
    OR e.citizen_no LIKE '%$search%' 
    OR f.citizen_no LIKE '%$search%'";
}

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

$sql_member = "SELECT a.*,
c.*,
g.transfer_date,
g.approve_result,
g.payment_id,
g.slip_image
FROM tbl_member_renew re
LEFT JOIN tbl_member a ON re.member_id = a.member_id
LEFT JOIN tbl_member_detail c ON c.member_id = a.member_id
LEFT JOIN tbl_member_payment g ON g.member_id = a.member_id
WHERE a.register_status = '1' $condition_type $condition_level $condition_search $condition_status
ORDER BY register_no ASC";
$rs_member = mysqli_query($connection, $sql_member) or die($connection->error);

// $sql_inv = "SELECT * FROM table WHERE column";
// $res_inv = mysqli_query($connection, $sql_inv);
// $row_inv = mysqli_fetch_assoc($res_inv);
?>
<style>

</style>
<div class="table-responsive">
    <table class="table table-striped dataTables-example table-bordered">
        <thead>
            <tr>
                <th>#</th>
                <th class="text-center w-auto">รูปภาพ</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
            while ($row_member = mysqli_fetch_assoc($rs_member)) {

$member_id_temp = bigsara_encode($row_member['member_id'], $row_member['secure_text'], $row_member['secure_pointer']);
                $member_id = $member_id_temp . "." . $row_member['secure_text'];

$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><?php echo $i += 1; ?></td>
                    <td class="text-center">
                        <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="member_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="member_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 ($row_member['member_name'] != "") ? $title_th . " " . $row_member['member_name'] . "<br>" : "" ?>
                        <?php echo ($row_member['member_name_en'] != "") ? $title_en . " " . $row_member['member_name_en'] . "<br>" : "" ?>

วันเกิด : <?php echo (!empty($row_member['birth_date'])) ? date('d M ', strtotime($row_member['birth_date'])).date('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>
                        <span class="badge badge-success p-2"><?php echo  $register_level ?></span>
                        <span class="badge badge-primary p-2"><?php echo  $register_type ?></span>
                    </td>
                    <td style="width:20%;">
                        ID / Pass : <?php echo $citizen_no ?><br>
                        Exp :
                        <?php echo date('d M', strtotime($row_member['card_expire_date'])).' '.date('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 date('d M', strtotime($row_member['visa_expire_date'])).' '.date('Y', strtotime($row_member['visa_expire_date'] + 543)) ?>
                            <?php echo $visa_exp_day; ?>
                            <br>
                            WP :
                            <?php echo $work_permit ?><br>
                            Exp : 
                            <?php echo date('d M', strtotime($row_member['work_expire_date'])).' '.date('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['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="../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="../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 } ?>

</td>
                    <!-- <td class="">
                        <?php if (empty($row_member['approve_result'])) { ?>
                            <div class="badge badge-warning p-1 mb-2 w-100">รอนุมัติการชำระเงิน</div><br>
                        <?php } else if ($row_member['approve_result'] == 1) { ?>
                            <div class="badge badge-primary p-1 mb-2 w-100">อนุมัติการชำระเงิน</div><br>
                        <?php } else if ($row_member['approve_result'] == 0) { ?>
                            <div class="badge badge-danger p-1 mb-2 w-100">ปฏิเสทการชำระเงิน</div><br>
                        <?php } ?>

<?php if (empty($row_member['member_code'])) { ?>
                            <div class="badge badge-warning p-1 mb-2 w-100">รอรับรอง</div><br>
                        <?php } else { ?>
                            <div class="badge badge-primary p-1 mb-2 w-100">รับรองแล้ว</div><br>
                        <?php } ?>
                    </td> -->
                </tr>
            <?php
            } ?>
        </tbody>
    </table>
</div>