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']);
// $approve_status = mysqli_real_escape_string($connection, $_POST['approve_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.approve_result = '$payment_status'";
}

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

$sql_member = "SELECT a.*,

( CASE 
 	WHEN a.register_type = '1' THEN c.citizen_no 
    WHEN a.register_type = '2' THEN d.citizen_no 
    WHEN a.register_type = '3' THEN e.citizen_no 
    WHEN a.register_type = '4' THEN f.citizen_no 
END ) AS citizen_no,
( CASE 
 	WHEN a.register_type = '1' THEN c.member_name 
    WHEN a.register_type = '2' THEN d.member_name 
    WHEN a.register_type = '3' THEN e.member_name 
    WHEN a.register_type = '4' THEN f.member_name 
END ) AS member_name,
( CASE 
 	WHEN a.register_type = '1' THEN c.company_name 
    WHEN a.register_type = '2' THEN d.company_name 
    WHEN a.register_type = '3' THEN e.company_name 
    WHEN a.register_type = '4' THEN f.company_name 
END ) AS company_name,
( CASE 
 	WHEN a.register_type = '1' THEN c.email 
    WHEN a.register_type = '2' THEN d.email 
    WHEN a.register_type = '3' THEN e.email 
    WHEN a.register_type = '4' THEN f.email 
END ) AS email,
( CASE 
 	WHEN a.register_type = '1' THEN c.phone 
    WHEN a.register_type = '2' THEN d.phone 
    WHEN a.register_type = '3' THEN e.phone 
    WHEN a.register_type = '4' THEN f.phone 
END ) AS phone,

g.transfer_date,
g.approve_result
FROM tbl_member a 
LEFT JOIN tbl_member_detail_employer c ON c.member_id = a.member_id
LEFT JOIN tbl_member_detail_company d ON  d.member_id = a.member_id
LEFT JOIN tbl_member_detail_agency e ON e.member_id = a.member_id
LEFT JOIN tbl_member_detail_worker f ON f.member_id = a.member_id
LEFT JOIN tbl_member_payment g ON g.member_id = a.member_id
WHERE a.reject_status = '1' $condition_type $condition_level $condition_search $condition_status
ORDER BY a.register_datetime 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="w-auto">เลขบัตรประจำตัวประชาชน</th>
                <th class="w-auto">เลขสมาชิก</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_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 = bigsara_decode($row_member['citizen_no'], $key);
            ?>
                <tr>
                    <td><?php echo "********" . substr($citizen_no, -5); ?></td>
                    <td>
                        <?php echo ($row_member['member_code'] ? $row_member['member_code'] : "<span class='text-danger'>รอรับรอง</span>") ?>
                        <br>
                        <?php echo bigsara_decode($row_member['member_name'], $key) ?>
                        <br>
                        <?php echo bigsara_decode($row_member['phone'], $key) ?>
                        <br>
                        <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 class="text-center">

<?php if (empty($row_member['approver'])) { ?>
                            <div class="badge badge-warning p-1 mb-2">รอตรวจเอกสาร</div><br>
                        <?php } else if ($row_member['approver'] == 1) { ?>
                            <div class="badge badge-primary p-1 mb-2">ตรวจเอกสารแล้ว</div><br>
                        <?php } else if ($row_member['approver'] == 0) { ?>
                            <div class="badge badge-danger p-1 mb-2">ขอข้อมูลเพิ่ม</div><br>
                        <?php } ?>

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

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

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

<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" class="btn btn-info btn-sm mb-2" style="width: 100%;">ดูข้อมูล</a>
                        <a class="btn btn-danger btn-sm text-white mb-2" style="width: 100%;">ยกเลิกสมาชิก</a>
                    </td>
                </tr>
            <?php $i++;
            } ?>
        </tbody>
    </table>
</div>

//     $.post('member_detail.php', {
    //         member_id: member_id,
    //         member_type: member_type,
    //         member_level: member_level
    //     }, function() {
    //         window.open('member_detail.php');
    //     });
    // }
</script>