invisio v2.0

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

$member_id = mysqli_real_escape_string($connection, $_POST["member_id"]);
$temp_member_id = explode(".", $member_id);
$member_id = bigsara_decode($temp_member_id[0], $temp_member_id[1]);

$sql = "SELECT a.member_code,
b.*
FROM tbl_member a
LEFT JOIN  tbl_member_payment b ON b.member_id = a.member_id
WHERE a.member_id ='$member_id'  ORDER BY create_datetime DESC";
$res = mysqli_query($connection, $sql);

$sql_payment = "SELECT * FROM tbl_member_payment WHERE member_id = '$member_id' ";
$rs_payment = mysqli_query($connection, $sql_payment) or die($connection->error);
$row_payment = mysqli_fetch_assoc($rs_payment);
$payment_status = $row_payment['approve_result'];

?>
<div class="ibox">
    <div class="ibox-content pt-3">
        <div class="table-responsive">
            <label for=""><b>รายละเอียด</b></label><br>
            <hr>
            <table class="table ">
                <thead>
                    
                    <tr>
                        <th class="text-center" style="width: 20%;">วันที่สมัคร</th>
                        <th class="text-center">ใบสมัคร</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 = mysqli_fetch_assoc($res)) {

?>
                        <tr>
                            <td class="text-center">
                                <?php echo date('d/m', strtotime($row['create_datetime'])) . '/' . date('Y', strtotime($row['create_datetime'] + 543)) ?>
                            </td>
                            <td class="text-center">
                                <a href="https://efa-member.com/main/print/print_all_doc?id=<?php echo $_POST["member_id"] ?>" class="btn btn-success btn-sm btn-block" target="_blank" id="btn_print"><i class="fa fa-print"></i> ใบสมัคร</a>
                            </td>
                            <td class="text-center">
                                <?php if (empty($row['transfer_date'])) { ?>
                                    <button class="btn btn-warning btn-sm  w-100" onclick="GetModalEdit('<?php echo $row['payment_id'] ?>')">รอชำระเงิน</button>
                                    <?php } else {
                                    if ($row['approve_result'] == '1') {
                                    ?>
                                        <button class="btn btn-primary btn-sm  w-100" onclick="GetModalEdit('<?php echo $row['payment_id'] ?>')">อนุมัติแล้ว</button>
                                    <?php } else if ($row['approve_result'] == '0') { ?>
                                        <button class="btn btn-danger btn-sm w-100" onclick="GetModalEdit('<?php echo $row['payment_id'] ?>')">ปฏิเสธ</button>
                                    <?php } else { ?>
                                        <button class="btn btn-info btn-sm w-100" onclick="GetModalEdit('<?php echo $row['payment_id'] ?>')">รออนุมัติ</button>
                                <?php
                                    }
                                } ?>
                            </td>
                            
                            <td class="text-center">
                                <a href="print/receipt?id=<?php echo $member_id ?>" target="_blank" class="btn btn-info btn-sm mb-2" style="width: 100%;">ใบเสร็จ</a>
                            </td>
                            <td class="text-center">
                                <?php if (empty($row['member_code'])) { ?>
                                    <div class="badge badge-warning p-1 w-100  mb-2">รออนุมัติ</div>
                                    
                                <?php } else { ?>
                                    <div class="badge badge-info p-1 w-100 mb-2">อนุมัติแล้ว</div>
                                    
                                <?php } ?>
                            </td>
                            <td class="text-center">
                                <img src="img/Noaccess.png" alt="" width="15%">
                            </td>
                        </tr>

<?php $i++;
                    } ?>
                </tbody>
            </table>
        </div>
    </div>
</div>