invisio v2.0

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

$datenow = date('Y-m-d');

<div class="ibox">
                    <div class="ibox-title">
                        <div class="row">
                            <div class="col-lg-3 mb-2 ml-4">
                                รายชื่อสมาชิกที่มีสถานะ
                            </div>
                            <div class="ibox-tools">
                                <button class="btn btn-sm btn-primary" onclick="ExportMember()"><i class="fa fa-file-excel-o"></i> Excel</button>
                            </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" id="level" style="width: 100%;">
                                            <option value="x">ทั้งหมด</option>
                                            <option value="g9k1s">ทั่วไป</option>
                                            <option value="kki22">วิสามัญ</option>
                                            <option value="x9fkq">สามัญ</option>
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-2">
                                <div class="form-group">
                                    <label class="font-">ประเภท</label>
                                    <div class="input-group">
                                        <select class="form-select" id="type" style="width: 100%;">
                                            <option value="x">ทั้งหมด</option>
                                            <option value="1">นายจ้าง</option>
                                            <option value="2">บนจ.</option>
                                            <option value="3">Agency</option>
                                            <option value="4">แรงงาน</option>
                                        </select>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-2">
                                <div class="form-group">
                                    <div class="input-group mt-4">
                                        <button type="button" class="btn btn-primary mt-1" onclick="load_table()"><i class="fa fa-search"></i> ค้นหา</button>
                                    </div>
                                </div>
                            </div>
                            <div class="col-lg-4">

</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 type = $("#type").val();
            let level = $("#level").val();
            let search = $("#search").val();
            let payment_status = $("#payment_status").val();
            let approve_status = $("#approve_status").val();

$.ajax({
                type: 'POST',
                url: 'ajax/member_certified/get_table.php',
                data: {
                    type: type,
                    level: level,
                    search: search,
                    payment_status: payment_status,
                    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 GetMemberCount() {
            $("#member_count").load("ajax/member_certified/member_count", "data", function(response, status, request) {
                this; // dom element
            });
        }

$.extend({
            redirectPost: function(location, args) {
                var form = '';
                $.each(args, function(key, value) {
                    form += '<input type="hidden" name="' + key + '" value="' + value + '">';
                });
                $('<form action="' + location + '" method="POST">' + form + '</form>').appendTo('body')
                    .submit();
            }
        });

function ExportMember() {
            let type = $("#type").val();
            let level = $("#level").val();
            var redirect = 'ajax/member_certified/export_member.php';
            $.redirectPost(redirect, {
                type: type,
                level: level
            });
        }
    </script>
</body>

</html>