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">
            <?php if (empty($row['transfer_date'])) { ?>
                <div class="form-group">
                    <form action="" id="payment_slip" enctype="multipart/form-data">
                        <div class="row">
                            <div class="col-12 mb-2">
                                <div class="alert alert-warning">รอชำระเงิน</div>
                            </div>
                            <input type="hidden" name="payment_id" value="<?php echo $payment_id ?>">

<div class="col-12 mb-2">
                                <label for="" class="mb-2">หมายเลขบัญชีธนาคาร</label>
                                <br>
                                <div class="row">
                                    <div class="col-3">
                                        <img src="img/<?php echo $row_pay_account['logo']; ?>" alt="" class="mt-1" width="100px" height="100px">
                                    </div>
                                    <div class="col-9">
                                        <label for=""><b>ธนาคาร</b> : <?php echo $row_pay_account['bank_name']; ?></label>
                                        <br>
                                        <label for=""><b>เลขที่บัญชี</b> : <?php echo $row_pay_account['account_number']; ?></label>
                                        <br>
                                        <label for=""><b>ชื่อบัญชี</b> : <?php echo $row_pay_account['account_name']; ?></label>
                                    </div>
                                </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 for="" class="">หมายเหตุ</label>
                                <textarea name="payment_remark" id="payment_remark" cols="30" rows="3" class="form-control mb-2"></textarea>
                                <div class="col-12 d-flex justify-content-center mt-3">
                                    <div>
                                        <button type="button" class="btn btn-primary" onclick="UpdatePayment('1')">บันทึก</button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            <?php } else { ?>
                <?php if ($status == '1' || $status == '0') { ?>
                    <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="../../upload/slip/<?php echo $row['slip_image']; ?>" target="_blank">
                                            <img src="../../../upload/join/file/pdf_icon.jpg" alt="" width="200px">
                                        </a>
                                    <?php } else { ?>
                                        <a href="../../upload/slip/<?php echo $row['slip_image']; ?>" target="_blank">
                                            <img id="slip" src="../../upload/slip/<?php echo  $row['slip_image'] ?>" width="200px" />

</a>
                                    <?php } ?>
                                    
                                    
                                </div>
                            </div>
                        </div>
                        <div class="row mt-5">
                            <div class="col-12">
                                <label class="form-label float-start">วันที่โอน :</label>
                                <?php echo  date('d/m/Y', strtotime($row['transfer_date'])); ?>
                                <?php echo  date('H:i', strtotime($row['transfer_time'])); ?>
                            </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>
                                <?php if ($status == 1) { ?>
                                    <span style="color: green;">อนุมัติ</span>
                                <?php } else if ($status == 0) { ?>
                                    <span style="color: red;">ปฎิเสธ</span>
                                <?php } ?>
                            </div>
                            <div class="col-12">
                                <label class="form-label float-start">หมายเหตุ :</label>
                                <?php echo trim($row['approve_remark']); ?>
                                <div class="col-12 d-flex justify-content-center mt-3">
                                    <div>
                                        <button type="button" class="btn btn-warning" onclick="EditPayment('<?php echo $payment_id; ?>')">แก้ไขการชำระเงิน</button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                <?php } else if ($status == '') { ?>
                    <div class="form-group">
                        <div class="row">
                            <div class="col-12">
                                <label class="form-label float-start">สลิป :</label>
                                <div style="text-align: center;">
                                    <?php
                                    if ($row['payment_type'] == 2) {
                                        $file_type = explode('.', $row['slip_image']);
                                        if (strtolower($file_type[1]) == 'pdf') {

?>
                                            <a href="../../upload/slip/<?php echo $row['slip_image']; ?>" target="_blank">
                                                <img src="../../../upload/slip/pdf_icon.jpg" alt="" width="200px">
                                            </a>
                                        <?php } else { ?>
                                            <a href="../../upload/slip/<?php echo $row['slip_image']; ?>" target="_blank">
                                                <img id="slip" src="../../upload/slip/<?php echo  $row['slip_image'] ?>" width="200px" />
                                            </a>
                                        <?php }
                                    } elseif ($row['payment_type'] == 1) {
                                        ?>
                                        <h4>ชำระผ่าน QR code payment</h4>
                                    <?php
                                    }
                                    ?>

</div>
                            </div>
                        </div>
                        <div class="row mt-5">
                            <div class="col-12">
                                <label class="form-label float-start">วันที่โอน :</label>
                                <?php echo  date('d/m/Y', strtotime($row['transfer_date'])); ?>
                                <?php echo  date('H:i', strtotime($row['transfer_time'])); ?>
                            </div>
                            <div class="col-12">
                                <label class="form-label float-start">ค่าสมัคร :</label>
                                <?php echo  $row['payment_amount']; ?> บาท
                            </div>
                            <?php if (!empty($row['coupon_id'])) { ?>
                                <div class="col-12">
                                    <label class="form-label float-start">ส่วนลด :</label>
                                    <?php echo  $row_coupon['discount_amount']; ?> บาท
                                </div>
                                <div class="col-12">
                                    <label class="form-label float-start">ยอดชำระ :</label>
                                    <?php echo  $row['payment_amount'] - $row_coupon['discount_amount']; ?> บาท
                                </div>
                            <?php } ?>
                            <div class="col-12">
                                <div class="row">
                                    <div class="col-3">
                                        <label class="form-label">หมายเหตุ : </label>
                                    </div>
                                    <div class="col-9">
                                        <textarea name="approve_remark" id="approve_remark" cols="35" rows="2" class="form-control float-start"></textarea>
                                    </div>
                                </div>
                            </div>
                            <div class="col-12 d-flex justify-content-center mt-3">
                                <div>
                                    <button type="button" class="btn btn-success " onclick="ApprovePayment('<?php echo $payment_id ?>','1')">อนุมัติ</button>
                                </div>
                                <div class="px-2">
                                    <button type="button" class="btn btn-danger" onclick="ApprovePayment('<?php echo $payment_id ?>','0')">ปฏิเสธ</button>
                                </div>
                            </div>
                        </div>
                    </div>
                <?php } ?>
            <?php } ?>
        </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>