invisio v2.0

<?php
session_start();
include('../../../config/main_function.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);

$status = mysqli_real_escape_string($connection, $_POST['status']);
$sdate = str_replace("/","-",$_POST['start_date']);
$start_date = date("Y-m-d 00:00:00",strtotime($sdate));

$edate = str_replace("/","-",$_POST['end_date']);
$end_date = date("Y-m-d 23:59:59",strtotime($edate));

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

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

$condition_status = "";
if ($status != 'x' && $status != '9') {
    $condition_status .= "AND a.approve_result = '$status'";
}elseif($status == '9'){
    $condition_status .= "AND a.approve_result IS NULL";
}

$condition_date = "";
if ($_POST['start_date'] != "" || $_POST['end_date'] != "") {
   $condition_date .= "AND a.create_datetime BETWEEN '$start_date' AND '$end_date'";
}

$condition_search = "";
if ($input_search != "") {
    
    $condition_date = "";
    $search = bigsara_encode($input_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%')";
}

$sql_member = "SELECT a.member_id as member_id,
( CASE 
 	WHEN b.register_type = '1' THEN c.citizen_no 
    WHEN b.register_type = '2' THEN d.citizen_no 
    WHEN b.register_type = '3' THEN e.citizen_no 
    WHEN b.register_type = '4' THEN f.citizen_no 
END ) AS citizen_no,
( CASE 
 	WHEN b.register_type = '1' THEN c.member_name 
    WHEN b.register_type = '2' THEN d.member_name 
    WHEN b.register_type = '3' THEN e.member_name 
    WHEN b.register_type = '4' THEN f.member_name 
END ) AS member_name,
b.register_level,
b.register_type,
( CASE 
 	WHEN b.register_type = '1' THEN c.company_name 
    WHEN b.register_type = '2' THEN d.company_name 
    WHEN b.register_type = '3' THEN e.company_name 
    WHEN b.register_type = '4' THEN f.company_name 
END ) AS company_name,
a.approve_result,
a.payment_amount,
a.payment_id,
a.create_datetime

FROM tbl_member_payment a 
LEFT JOIN tbl_member b ON b.member_id = a.member_id
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
WHERE a.payment_type = '2' $condition_status $condition_date $condition_search
ORDER BY b.register_datetime DESC";

$rs_member = mysqli_query($connection, $sql_member) or die($connection->error);

?>
<style>
  select.form-control{
    display: inline;
    width: 200px;
    margin-left: 25px;
  }
</style>

<div class="table-responsive">
    <table class="table table-striped dataTables-example table-bordered" id="filterTable">
        <thead>
            <tr>
                <th style="width: 1%;">#</th>
                <th style="width: 30%;">ชื่อ</th>
                <th>เลขบัตรประจำตัวประชาชน</th>
                <th>วันที่สมัคร</th>
                <th class="text-center">ระดับ</th>
                <th class="text-center">ประเภท</th>
                <th>ชื่อบริษัท</th>
                <th class="text-center">ค่าสมัคร</th>
                <th class="text-center" style="width: 10%;">สถานะ</th>
            </tr>
        </thead>
        <tbody>
            <?php $i = 1;
            while ($row_member = mysqli_fetch_assoc($rs_member)) {

$register_level = $row_member['register_level'];

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

$register_type = $row_member['register_type'];

if ($register_type == 1) {
                    $register_type = 'นายจ้าง';
                } elseif ($register_type == 2) {
                    $register_type = 'แรงงาน';
                } elseif ($register_type == 3) {
                    $register_type = 'บนจ.';
                } elseif ($register_type == 4) {
                    $register_type = 'Agency';
                } elseif ($register_type == 5) {
                    $register_type = 'ไม่ระบุ';
                }
            ?>
                <tr>
                    <td><?php echo $i; ?></td>
                    <td><?php echo bigsara_decode($row_member['member_name'], $key); ?></td>
                    <td><?php echo bigsara_decode($row_member['citizen_no'], $key); ?></td>
                    <td>
                        <?php echo date('d/m/Y',strtotime($row_member['create_datetime'])); ?>
                        <br>
                        <?php echo date('H:i',strtotime($row_member['create_datetime'])); ?>
                    </td>
                    <td class="text-center"><?php echo $register_level ?></td>
                    <td class="text-center"><?php echo $register_type ?></td>
                    <td class="text-center"><?php echo $row_member['company_name'] ?></td>
                    <td class="text-center"><?php echo $row_member['payment_amount'] ?></td>
                    <td class="text-center">
                        <?php if ($row_member['approve_result'] == '') { ?>
                            <strong style="color: orange;">รออนุมัติ</strong>
                            <button class="btn btn-info mt-2" style="width: 100%;" onclick="GetModal('<?php echo $row_member['payment_id'] ?>', '<?php echo $row_member['approve_result'] ?>')">ตรวจสอบ</button>
                        <?php } elseif ($row_member['approve_result'] == '1') { ?>
                            <strong style="color: green;">อนุมัติ</strong>
                            <button class="btn btn-info mt-2" style="width: 100%;" onclick="GetModal('<?php echo $row_member['payment_id'] ?>', '<?php echo $row_member['approve_result'] ?>')">ดูข้อมูล</button>
                        <?php } elseif ($row_member['approve_result'] == '0') { ?>
                            <strong style="color: red;">ปฎิเสธ</strong>
                            <button class="btn btn-info mt-2" style="width: 100%;" onclick="GetModal('<?php echo $row_member['payment_id'] ?>', '<?php echo $row_member['approve_result'] ?>')">ดูข้อมูล</button>
                        <?php } ?>
                    </td>
                </tr>
            <?php $i++;
            } ?>
        </tbody>
    </table>
</div>