invisio v2.0

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

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

$admin_id = mysqli_real_escape_string($connection, $_POST['admin_id']);
$temp_id = explode(".", $admin_id);
$name = $temp_id[0];
$key = $temp_id[1];
$admin_id = bigsara_decode($name, $key);

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

if (!empty($row['coupon_id'])) {
    $sql_coupon = "SELECT * FROM tbl_discount_coupon WHERE coupon_id = '{$row['coupon_id']}'";
    $res_coupon = mysqli_query($connection, $sql_coupon);
    $row_coupon = mysqli_fetch_assoc($res_coupon);
}

$sql_pay_account = "SELECT * FROM tbl_bank WHERE active_status = '1' ";
$res_pay_account = mysqli_query($connection, $sql_pay_account);
$row_pay_account = mysqli_fetch_assoc($res_pay_account);

.select2-dropdown {
        z-index: 3051;
    }
</style>

<div class="modal-header">
    <h4 class="modal-title">รายละเอียด</h4>
    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
</div>
<div class="modal-body">
    <div class="row">
        <div class="col-lg-12">
            <form action="" id="edit_payment" enctype="multipart/form-data">
                <input type="hidden" id="payment_id" name="payment_id" value="<?php echo $payment_id; ?>">
                <div class="form-group">
                    <div class="row">
                        <div class="col-12">
                            <label class="form-label float-start">สลิป :</label>
                            <div style="text-align: center;">
                                <?php
                                $file_type = explode('.', $row['slip_image']);
                                if (strtolower($file_type[1]) == 'pdf') {
                                ?>
                                    <a href="../../main/upload/slip/<?php echo $row['slip_image']; ?>" target="_blank">
                                        <img src="../../../main/upload/join/file/pdf_icon.jpg" alt="" width="200px">
                                    </a>
                                <?php } else { ?>
                                    <a href="../../main/upload/slip/<?php echo $row['slip_image']; ?>" target="_blank">
                                        <img id="slip" src="../../main/upload/slip/<?php echo  $row['slip_image'] ?>" width="200px" />

</a>
                                <?php } ?>
                                
                                
                            </div>
                        </div>
                        <div class="col-12 mb-2">
                            <label for="" class="mb-2">แนบหลักฐานการชำระเงิน</label>
                            <input type="file" class="form-control" name="slip_image" id="slip_image">
                        </div>
                        <div class="col-12">
                            <label for="">วันที่โอน</label>
                            <div class="form-group" id="data_1">
                                <div class="input-group date">
                                    <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                                    <input type="text" class="form-control bg-white datepicker" id="transfer_date" name="transfer_date" value="<?php echo date("d/m/Y") ?>" readonly>
                                </div>
                            </div>
                        </div>

<div class="col-12">
                            <label for="">เวลาที่โอน</label>
                        </div>
                        <div class="col-6 mb-2">
                            <select name="transfer_time_h" id="transfer_time_h" class="form-control">
                                <?php for ($i = 0; $i <= 23; $i++) : ?>
                                    <option value="<?php echo str_pad($i, 2, "0", STR_PAD_LEFT); ?>" <?php if (date('H') == $i) : ?> selected <?php endif; ?>>
                                        <?php echo str_pad($i, 2, "0", STR_PAD_LEFT); ?>
                                    </option>
                                <?php endfor; ?>
                            </select>
                        </div>

<div class="col-6 mb-2">
                            <select name="transfer_time_m" id="transfer_time_m" class="form-control">
                                <?php for ($i = 0; $i <= 59; $i++) : ?>
                                    <option value="<?php echo str_pad($i, 2, "0", STR_PAD_LEFT); ?>" <?php if (date('i') == $i) : ?> selected <?php endif; ?>>
                                        <?php echo str_pad($i, 2, "0", STR_PAD_LEFT); ?>
                                    </option>
                                <?php endfor; ?>
                            </select>
                        </div>

<div class="col-12">
                            <label class="form-label float-start">วันที่อัพเดทสถานะ :</label>
                            <?php echo  date('d/m/Y', strtotime($row['approve_datetime'])); ?>
                        </div>
                        <div class="col-12">
                            <label class="form-label float-start">สถานะปัจจุบัน :</label>
                            
                            <select name="ch_payment_status" id="ch_payment_status" class="form-select" style="width: 60%;">
                                <option value="" <?php echo ($status == '') ? "selected": ""?> >รออนุมัติ</option>
                                <option value="1" <?php echo ($status == 1) ? "selected": ""?> >อนุมัติ</option>
                                <option value="0" <?php echo ($status == 0) ? "selected": ""?> >ปฎิเสธ</option>
                            </select>
                        </div>

<div class="col-12">
                            <label class="form-label float-start">หมายเหตุ :</label>
                            <textarea name="payment_remark" id="payment_remark" cols="30" rows="3" class="form-control mb-2">
                                <?php echo trim($row['approve_remark']); ?>
                                </textarea>
                            <div class="col-12 d-flex justify-content-center mt-3">
                                <div>
                                    <button type="button" class="btn btn-primary" onclick="UpdatePayment('2')">บันทึก</button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </form>
        </div>
    </div>
</div>
<div class="modal-footer">
    <button type="button" class="btn btn-white" data-dismiss="modal">ปิด</button>
</div>
<script>
    $(document).ready(function() {
        $(".form-select").select2();
    });

$(".datepicker").datepicker({
        todayBtn: "linked",
        keyboardNavigation: false,
        forceParse: false,
        autoclose: true,
        format: "dd/mm/yyyy"
    });
</script>