invisio v2.0

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

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

<body class="top-navigation">
    <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'); ?>

function load_table() {
            $('#show_table').hide();
            $('#Loading').show();

let approve_status = $("#approve_status").val();
            let type = $("#type").val();
            let level = $("#level").val();
            let search = $("#search").val();

$.ajax({
                type: 'POST',
                url: 'ajax/member_approve/get_table.php',
                data: {
                    type: type,
                    level: level,
                    search: search,
                    approve_status: approve_status
                },
                dataType: 'html',
                success: function(response) {
                    $('#show_table').html(response);
                    $('.dataTables-example').DataTable({
                        ordering: false,
                        pageLength: 100,
                        responsive: true,
                    });
                    $('#show_table').show();
                    $('#Loading').hide();
                }
            });
        }

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 GetMemberCount() {
            $("#member_count").load("ajax/setting_member/member_count", "data", function(response, status, request) {
                this; // dom element

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

</html>