会员列表导出

Hentua

2023-06-20 9bc60c39ec05aa8f88b0273c974a7442fb4d07d4

 src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html

@@ -3,7 +3,7 @@
        <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">
                    <form class="layui-form layui-table-form" lay-filter="member-table-form">
                        <div class="layui-row">
                            <div class="layui-col-md10">
                                <div class="layui-form-item">
@@ -29,6 +29,21 @@
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">会员类型：</label>
                                        <div class="layui-input-inline">
                                            <select name="level">
                                                <option value="">请选择</option>
                                                <option value="ZERO_LEVEL">迷梦素人</option>
                                                <option value="FIRST_LEVEL">觉醒须眉/觉醒丽人</option>
                                                <option value="SECOND_LEVEL">先知蓝颜/先知红颜</option>
                                                <option value="THIRD_LEVEL">追影才子/追影佳人</option>
                                                <option value="FOUR_LEVEL">赋权玉郎/赋权娇娘</option>
                                                <option value="FIFTH_LEVEL">位极尊上/位极女卿</option>
                                                <option value="SIX_LEVEL">权倾圣主/权倾女帝</option>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area">
@@ -38,10 +53,13 @@
                                <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 class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" id="exportExcel">
                                    导出
                                </div>
                            </div>
                        </div>
                    </form>
                    <table lay-filter="userTable" lay-data="{id: 'userTable'}"></table>
                    <table lay-filter="memberTable" lay-data="{id: 'memberTable'}"></table>
                </div>
            </div>
        </div>
@@ -106,6 +124,7 @@
            $query = $view.find('#query'),
            $reset = $view.find('#reset'),
            $searchForm = $view.find('form'),
            $exportExcel = $view.find('#exportExcel'),
            sortObject = {field: 'phone', type: null},
            tableIns;

@@ -121,7 +140,7 @@
        initTable();

        // 初始化表格操作栏各个按钮功能
        table.on('tool(userTable)', function (obj) {
        table.on('tool(memberTable)', function (obj) {
            var data = obj.data,
                layEvent = obj.event;

@@ -228,7 +247,7 @@
        function initTable() {
            tableIns = febs.table.init({
                elem: $view.find('table'),
                id: 'userTable',
                id: 'memberTable',
                url: ctx + 'admin/mallMember/getMallMemberList',
                toolbar:"#tableMemberBar",
                defaultToolbar:[],
@@ -271,7 +290,7 @@
            });
        }

        table.on('toolbar(userTable)', function(obj){
        table.on('toolbar(memberTable)', function(obj){
            var data = obj.data,
                layEvent = obj.event;

@@ -289,14 +308,14 @@
                return;
            }

            // var checkData = table.checkStatus('userTable').data;
            // var checkData = table.checkStatus('memberTable').data;
            // if (checkData.length <= 0) {
            //     febs.alert.warn('请选择需要的用户');
            //     return;
            // }

            if (layEvent === 'resetPwd') {
                var checkData = table.checkStatus('userTable').data;
                var checkData = table.checkStatus('memberTable').data;
                if (checkData.length <= 0) {
                    febs.alert.warn('请选择需要的用户');
                    return;
@@ -311,7 +330,7 @@
            }

            if (layEvent === 'resetPayPwd') {
                var checkData = table.checkStatus('userTable').data;
                var checkData = table.checkStatus('memberTable').data;
                if (checkData.length <= 0) {
                    febs.alert.warn('请选择需要的用户');
                    return;
@@ -327,7 +346,7 @@
            }

            if (layEvent === 'balance') {
                var checkData = table.checkStatus('userTable').data;
                var checkData = table.checkStatus('memberTable').data;
                if (checkData.length <= 0) {
                    febs.alert.warn('请选择需要的用户');
                    return;
@@ -340,7 +359,7 @@
            }

            if (layEvent === 'voucherUpdate') {
                var checkData = table.checkStatus('userTable').data;
                var checkData = table.checkStatus('memberTable').data;
                if (checkData.length <= 0) {
                    febs.alert.warn('请选择需要的用户');
                    return;
@@ -353,7 +372,7 @@
            }

            if (layEvent === 'score') {
                var checkData = table.checkStatus('userTable').data;
                var checkData = table.checkStatus('memberTable').data;
                if (checkData.length <= 0) {
                    febs.alert.warn('请选择需要的用户');
                    return;
@@ -366,7 +385,7 @@
            }

            if (layEvent === 'prizeScore') {
                var checkData = table.checkStatus('userTable').data;
                var checkData = table.checkStatus('memberTable').data;
                if (checkData.length <= 0) {
                    febs.alert.warn('请选择需要的用户');
                    return;
@@ -379,7 +398,7 @@
            }

            if (layEvent === 'agentLevel') {
                var checkData = table.checkStatus('userTable').data;
                var checkData = table.checkStatus('memberTable').data;
                if (checkData.length <= 0) {
                    febs.alert.warn('请选择需要的用户');
                    return;
@@ -481,5 +500,10 @@
                changeIdentityNo(4, data.value);
            }
        })


        $exportExcel.on('click', function() {
            febs.download(ctx + 'admin/mallMember/exportMemberList', getQueryParams(), '会员列表.xlsx');
        });
    })
</script>