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']);
$approve_status = mysqli_real_escape_string($connection, $_POST['approve_status']);

$condition_type = "";
if ($type == 'x') {
    $condition_type .= "NOT a.register_type = '0' ";
} else {
    $condition_type .= "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 ($approve_status != 'x') {
    $condition_status  .= "AND g.approve_result = '$approve_status'";
}

$sql_member = "SELECT a.member_id as member_id,

( 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,
( CASE 
 	WHEN a.register_type = '1' THEN c.document_file1 
    WHEN a.register_type = '2' THEN d.document_file1 
    WHEN a.register_type = '3' THEN e.document_file1 
    WHEN a.register_type = '4' THEN f.document_file1 
END ) AS document_file1,
( CASE 
 	WHEN a.register_type = '1' THEN c.document_file2 
    WHEN a.register_type = '2' THEN d.document_file2
    WHEN a.register_type = '3' THEN e.document_file2
    WHEN a.register_type = '4' THEN f.document_file2 
END ) AS document_file2,
( CASE 
 	WHEN a.register_type = '1' THEN c.document_file3 
    WHEN a.register_type = '2' THEN d.document_file3 
    WHEN a.register_type = '3' THEN e.document_file3 
    WHEN a.register_type = '4' THEN f.document_file3 
END ) AS document_file3,
( CASE 
 	WHEN a.register_type = '1' THEN c.document_file4 
    WHEN a.register_type = '2' THEN d.document_file4 
    WHEN a.register_type = '3' THEN e.document_file4 
END ) AS document_file4,
( CASE 
 	WHEN a.register_type = '1' THEN c.document_file5 
    WHEN a.register_type = '3' THEN e.document_file5 
END ) AS document_file5,
a.register_datetime,
a.register_level,
a.register_type,
a.member_code,
a.storage_no,
a.storage_date,
a.secure_text,
a.secure_pointer,
a.register_datetime,
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 NOT a.register_type = '0'  
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">เลขสมาชิก</th>
                <th class="text-center">เอกสารการสมัคร</th>
                <th class="text-center">ใบสมัคร</th>
                
                
                
                
                <th class="text-center">สถานะ</th>
                <th class="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 = registerType_title($row_member['register_type']);
                $register_level = registerLevel_title($row_member['register_level']);
                $citizen_no = bigsara_decode($row_member['citizen_no'], $key);

switch ($row_member['register_level']) {
                    case 'g9k1s':
                        $level = '1';
                        break;
                    case 'kki22':
                        $level = '3';
                        break;
                    case 'x9fkq':
                        $level = '2';
                        break;
                    default:
                        break;
                }

$sql_doc = "SELECT * FROM tbl_register_document WHERE register_type ='$level' AND member_type='{$row_member['register_type']}'";
                $res_doc = mysqli_query($connection, $sql_doc);

?>
                <tr>
                    <td  style="width: 15%;"><?php echo "********" . substr($citizen_no, -5); ?></td>
                    <td><?php echo date('d/m/Y H:i', strtotime($row_member['register_datetime'])) ?></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" style="width: 5%;">
                        <?php
                        $i = 1;
                        while ($row_doc = mysqli_fetch_assoc($res_doc)) {
                            if (!empty($row_member['document_file' . $i . ''])) {
                        ?>
                                <a href="https://efa-member.com/main/upload/join/file/<?php echo $row_member['document_file' . $i . ''] ?>" class="btn btn-info btn-sm w-100 mb-2" target="_blank" id="btn_print"><i class="fa fa-print"></i> <?php echo $row_doc['doc_name']; ?></a>
                                <br>
                        <?php
                            }

$i++;
                        } ?>
                    </td>
                    <td class="text-center">
                        <a href="https://efa-member.com/main/print/application_form?id=<?php echo $member_id ?>" class="btn btn-success btn-sm w-100 mb-2" target="_blank" id="btn_print"><i class="fa fa-print"></i> ใบสมัคร</a>
                        <a href="https://efa-member.com/main/print/print_all_doc?id=<?php echo  $member_id ?>" class="btn btn-success btn-sm w-100 mb-2" target="_blank" id="btn_print"><i class="fa fa-print"></i> เอกสารทั้งหมด</a>
                    </td>
                    
                    
                    
                    <td class="text-center">
                        <span class="badge badge-warning p-1 mb-2">รอตรวจเอกสาร</span>
                    </td>
                    <td class="text-center" style="width: 5%;">
                        <button class="btn btn-info btn-sm w-100 mb-2"><i class="fa fa-check"></i> ตรวจเอกสาร</button>
                        <button class="btn btn-primary btn-sm w-100 mb-2"><i class="fa fa-check"></i> อนุมัติ</button>
                        <button class="btn btn-danger btn-sm w-100 mb-2"><i class="fa fa-close"></i> ปฏิเสธ</button>
                    </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>