invisio v2.0

<?php
include('header.php');

$datenow = date('d/m/Y');
$sdate = date('d/m/Y', strtotime('-1 month'));

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

<div id="wrapper">
        <div id="page-wrapper" class="gray-bg">
            <div class="wrapper wrapper-content animated fadeInRight">
                <div class="ibox">
                    <div class="ibox-title">
                        <div class="row">
                            <div class="col-lg-3 mb-2 ml-4">
                                การชำระเงิน
                            </div>
                        </div>
                    </div>
                    <div class="ibox-title">
                        <div class="row px-3">
                            <div class="col-lg-2">
                                <div class="form-group">
                                    <label class="font-">สถานะ</label>
                                    <div class="input-group">
                                        <select class="form-select w-100" id="status" onchange="SelectStatus()">
                                            <option value="x">ทั้งหมด</option>
                                            <option value="9" selected>รออนุมัติ

<?php

$secure = "cAh3DrJACzw4RbU";
                                                $connection = connectDB($secure);

$sql_app = "SELECT COUNT(*) AS nonapprove FROM tbl_member_payment WHERE payment_type = '2' AND approve_result IS NULL";
                                                $res_app = mysqli_query($connection, $sql_app);
                                                $row_app = mysqli_fetch_assoc($res_app);
                                                if ($row_app['nonapprove'] > 0) {
                                                    echo "( " . $row_app['nonapprove'] . " )";
                                                } ?>

</option>
                                            <option value="1">อนุมัติ</option>
                                            <option value="0">ปฏิเสธ</option>
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-3" id="div_start_date" style="display: none;">

<div class="form-group" id="data_1">
                                    <label class="font-normal">วันที่ทำรายการ</label>
                                    <div class="input-group date">
                                        <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                                        <input type="input" class="form-control date" value="<?php echo $sdate ?>" id="start_date" autocomplete="off">
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-3" id="div_end_date" style="display: none;">
                                <div class="form-group" id="data_1">
                                    <label class="font-normal">ถึง</label>
                                    <div class="input-group date">
                                        <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                                        <input type="input" class="form-control date" value="<?php echo $datenow ?>" id="end_date" autocomplete="off">
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4">
                                <div class="form-group">
                                    <label class="font-normal">ค้นหา</label>
                                    <div class="input-group">
                                        <input type="text" class="form-control" id="input_search" placeholder="ค้นหาด้วยเลขบัตรประจำตัวประชาชน" autocomplete="off">
                                        <button type="button" class="btn btn-primary ml-2" onclick="load_table()">ค้นหา</button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="ibox-content">
                        
                        <div id="Loading">
                            <div class="spiner-example">
                                <div class="sk-spinner sk-spinner-wave">
                                    <div class="sk-rect1"></div>
                                    <div class="sk-rect2"></div>
                                    <div class="sk-rect3"></div>
                                    <div class="sk-rect4"></div>
                                    <div class="sk-rect5"></div>
                                </div>
                            </div>
                        </div>
                        <div id="show_table"></div>
                        
                    </div>
                </div>
            </div>
        </div>
    </div>

<?php include('footer.php'); ?>

load_table();
            $('.form-select').select2();
            $("#start_date").show('hide');

});

var mem = $("#data_1 .input-group.date").datepicker({
            startView: 0,
            todayBtn: "linked",
            keyboardNavigation: false,
            forceParse: false,
            autoclose: true,
            format: "dd/mm/yyyy"
        })

function SelectStatus() {
            let status = $("#status").val();
            if (status == 9) {
                document.getElementById("div_start_date").style.display = "none";
                document.getElementById("div_end_date").style.display = "none";
            } else {
                document.getElementById("div_start_date").style.display = "block";
                document.getElementById("div_end_date").style.display = "block";

}
        }

function load_table() {

let status = $("#status").val();
            let start_date = $("#start_date").val();
            let end_date = $("#end_date").val();
            let input_search = $("#input_search").val();

$('#show_table').hide();
            $('#Loading').show();

$('#show_table').load('ajax/member_payment/get_table.php', {
                    status: status,
                    start_date: start_date,
                    end_date: end_date,
                    input_search: input_search
                },
                function() {
                    $('.dataTables-example').DataTable({
                        ordering: false,
                        pageLength: 25,
                        responsive: true,
                    });
                    $('#show_table').show();
                    $('#Loading').hide();
                });
        }

function GetModal(payment_id, status) {
            let admin_id = localStorage.getItem("admin_id");

$('#myModal').modal('show');
            $('#showModal').load("ajax/member_payment/get_modal.php", {
                    payment_id: payment_id,
                    status: status,
                    admin_id: admin_id
                },
                function() {
                    $("select.form-control").select2();
                });
        }

function ApprovePayment(payment_id, status) {

let approve_remark = $("#approve_remark").val();
            let admin_id = localStorage.getItem("admin_id");
            swal({
                title: 'กรุณายืนยันเพื่อทำรายการ',
                type: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#3085d6',
                cancelButtonColor: '#d33',
                cancelButtonText: 'ยกเลิก',
                confirmButtonText: 'ยืนยัน',
                closeOnConfirm: false
            }, function() {

$.ajax({
                    type: "post",
                    url: "ajax/member_payment/update_status.php",
                    data: {
                        payment_id: payment_id,
                        status: status,
                        approve_remark: approve_remark,
                        admin_id: admin_id
                    },
                    dataType: "json",
                    success: function(data) {
                        if (data.result == 1) {
                            swal({
                                title: "แจ้งเตือน",
                                text: "บันทึกเรียบร้อยแล้ว",
                                type: "success"
                            }, function() {
                                $('#myModal').modal('hide');
                                load_table();
                                NonTicket()
                            })
                        } else if (data.result == 0) {
                            swal({
                                title: "แจ้งเตือน",
                                text: "ไม่สามารถบันทึกได้ กรุณาลองอีกครั้ง",
                                type: "error"
                            })
                        } else if (data.result == 9) {
                            swal({
                                title: "แจ้งเตือน",
                                text: "ติดต่อเซิฟเวอร์ไม่สำเร็จ กรุณาลองอีกครั้ง",
                                type: "error"
                            })
                        }
                    }
                });

});
        }
    </script>
</body>

</html>