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,
a.register_status,
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);

?>
<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 style="width: 1%;">#</th>
                        <th style="width: 10%;">วันที่สมัคร</th>
                        <th style="width: 10%;" class="text-center">ใบสมัคร</th>
                        <th style="width: 10%;" class="text-center" style="width: 20%;">การชำระเงิน</th>
                        <th style="width: 10%;" class="text-center">ใบเสร็จ</th>
                        <th style="width: 10%;" class="text-center">ความเป็นสมาชิก</th>
                        <th style="width: 10%;" class="text-center">บัตรสมาชิก</th>
                    </tr>
                </thead>
                <tbody>
                    <?php $i = 1;
                    while ($row = mysqli_fetch_assoc($res)) {

?>
                        <tr>
                            <td><?php echo $i; ?></td>
                            <td><?php echo date('d/m', strtotime($row['create_datetime'])) . '/' . date('Y', strtotime($row['create_datetime'] + 543)) ?></td>
                            <td>
                                <?php if ($row['register_status'] == '0') { ?>
                                    <a href="https://efa-member.com/main/print/application_form?id=<?php echo $_POST["member_id"] ?>" class="btn btn-info btn-sm btn-block" target="_blank" id="btn_print"><i class="fa fa-print"></i> ใบสมัคร</a>
                                <?php } else if ($row['register_status'] == '1') { ?>
                                    <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>
                                <?php } ?>

<?php if (empty($row['transfer_date'])) { ?>
                                    
                                    <a href="edit_join_us" class="btn btn-warning btn-sm btn-block" id="form_edit_form"> แก้ไขใบสมัคร</a>
                                <?php } ?>

</td>
                            <td>
                                <?php if (empty($row['transfer_date'])) { ?>
                                    <button class="btn btn-warning btn-sm " style="width: 100%;" onclick="GetModalEdit('<?php echo $row['payment_id'] ?>')">รอชำระเงิน</button>
                                <?php } else { ?>
                                    <button class="btn btn-info btn-sm" style="width: 100%;" onclick="GetModalEdit('<?php echo $row['payment_id'] ?>')">ชำระเงินแล้ว</button>
                                <?php } ?>
                            </td>

<td class="text-center">
                                <img src="img/Noaccess.png" alt="" width="15%">
                            </td>
                            <td>
                                <?php if (empty($row['member_code'])) { ?>
                                    <div class="alert alert-warning text-center">รออนุมัติ</div>
                                    
                                <?php } else { ?>
                                    <div class="alert alert-info text-center">รออนุมัติ</div>
                                    
                                <?php } ?>
                            </td>
                            <td class="text-center">
                                <img src="img/Noaccess.png" alt="" width="15%">
                            </td>
                        </tr>
                        <!-- <tr>
                     <td><?php echo $i; ?></td>
                     <td><?php echo date('d/m', strtotime($row['create_datetime'])) . '/' . date('Y', strtotime($row['create_datetime'] + 543)) ?></td>
                     <td><?php echo date('d/m', strtotime($row['transfer_date'])) . '/' . date('Y', strtotime($row['transfer_date'] + 543)) ?></td>

<td>
                         <?php if (empty($row['transfer_date'])) { ?>
                            
                             <button class="btn btn-warning btn-sm" style="width: 100%;" onclick="GetModalEdit('<?php echo $row['payment_id'] ?>')">รอชำระเงิน</button>

<?php } else { ?>
                             <button class="btn btn-info btn-sm" style="width: 100%;" onclick="GetModalEdit('<?php echo $row['payment_id'] ?>')">ชำระเงินแล้ว</button>

<?php } ?>
                     </td>
                     <td class="text-center">
                         <?php if (empty($row['transfer_date'])) { ?>
                            <div class='alert alert-warning'>รอชำระเงิน</div>
                             <div class="bg-warning  text-white p-1 rounded">รอชำระเงิน</div>
                             <?php } else {
                                if ($row['approve_result'] == '') { ?>
                                 <div class="bg-warning  text-white p-1 rounded">รออนุมัติ</div>
                             <?php } elseif ($row['approve_result'] == '1') { ?>
                                 <div class="bg-primary  text-white p-1 rounded">อนุมัติ</div>
                             <?php } elseif ($row['approve_result'] == '0') { ?>
                                 <div class="bg-danger  text-white p-1 rounded">ปฎิเสธ</div>
                         <?php }
                            } ?>
                     </td>
                 </tr> -->
                    <?php $i++;
                    } ?>
                </tbody>
            </table>
        </div>
    </div>
</div>