20210321 后台数据查询修改

xiaoyong931011

2021-03-02 4348e057d9b2894a533ba116e21216610934eef0

 src/main/resources/templates/febs/views/modules/member/memberDataInfo.html

@@ -3,6 +3,58 @@
        <div class="layui-col-md12">

            <div class="layui-card">

                <div class="layui-card-body febs-table-full">

                    <form class="layui-form layui-table-form" lay-filter="user-table-form">

                        <div class="layui-row">

                            <div class="layui-col-md10">

                                <div class="layui-form-item">

                                    <div class="layui-inline">

                                        <div class="layui-input-inline">

                                            <input type="text" placeholder="手机号/邮箱/邀请码" name="account" autocomplete="off" class="layui-input">

                                        </div>

                                    </div>

                                    <div class="layui-inline">

                                        <label class="layui-form-label layui-form-label-sm">状态</label>

                                        <div class="layui-input-inline">

                                            <select name="statusOption">

                                                <option value="0"></option>

                                                <option value="1">等待审核</option>

                                                <option value="2">同意</option>

                                                <option value="3">拒绝</option>

                                            </select>

                                        </div>

                                    </div>

                                    <div class="layui-inline">

                                        <label class="layui-form-label layui-form-label-sm">账号类型</label>

                                        <div class="layui-input-inline">

                                            <select name="isTest">

                                                <option value=""></option>

                                                <option value="1">正常账号</option>

                                                <option value="2">测试账号</option>

                                            </select>

                                        </div>

                                    </div>

                                    <div class="layui-inline">

                                        <label class="layui-form-label layui-form-label-sm">内部转账</label>

                                        <div class="layui-input-inline">

                                            <select name="isInsideOption">

                                                <option value=""></option>

                                                <option value="Y">是</option>

                                                <option value="N">否</option>

                                            </select>

                                        </div>

                                    </div>

                                </div>

                            </div>

                            <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area">

                                <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-blue-plain table-action" id="query">

                                    <i class="layui-icon">&#xe848;</i>

                                </div>

                                <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" id="reset">

                                    <i class="layui-icon">&#xe79b;</i>

                                </div>

                            </div>

                        </div>

                    </form>

                     <table id=usersTable></table>

                </div>

            </div>

@@ -18,21 +70,45 @@
<!-- 表格操作栏 end -->

<script data-th-inline="none" type="text/javascript">

// 引入组件并初始化

layui.use([ 'jquery',  'form', 'table', 'febs'], function () {

    layui.use(['jquery', 'laydate', 'form', 'table', 'febs'], function () {

    var $ = layui.jquery,

        laydate = layui.laydate,

        febs = layui.febs,

        form = layui.form,

        table = layui.table,

        $view = $('#febs-user'),

            $query = $view.find('#query'),

            $reset = $view.find('#reset'),

            $searchForm = $view.find('form'),

            sortObject = {field: 'createTime', type: null},

        tableIns;



    form.render();

    // 表格初始化

    initTable();



    function initTable() {

        // 查询按钮

        $query.on('click', function () {

            var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type});

            tableIns.reload({where: params, page: {curr: 1}});

        });



        // 刷新按钮

        $reset.on('click', function () {

            $searchForm[0].reset();

            tableIns.reload({where: getQueryParams(), page: {curr: 1}});

        });



        // 获取查询参数

        function getQueryParams() {

            return {

                account: $searchForm.find('input[name="account"]').val().trim(),

                status: $searchForm.find("select[name='statusOption']").val(),

                isTest: $searchForm.find("select[name='isTest']").val(),

                isInside: $searchForm.find("select[name='isInsideOption']").val()

            };

        }



        function initTable() {

        tableInss = febs.table.init({

            elem: $('#usersTable'),

            url: ctx + 'member/memberDataInfo',