From 9bc60c39ec05aa8f88b0273c974a7442fb4d07d4 Mon Sep 17 00:00:00 2001
From: Hentua <wangdoubleone@gmail.com>
Date: Tue, 20 Jun 2023 22:12:03 +0800
Subject: [PATCH] 会员列表导出
---
src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html | 63 ++++++++++++++++++++++++-------
1 files changed, 48 insertions(+), 15 deletions(-)
diff --git a/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html b/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html
index 0698b6a..1118bb2 100644
--- a/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html
+++ b/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"></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>
@@ -51,7 +69,7 @@
<!-- 表格操作栏 start -->
<script type="text/html" id="mallmember-option">
<button class="layui-btn layui-btn-normal layui-btn-xs" type="button" shiro:hasPermission="moneyFlow:update" lay-event="moneyFlow">资金流水</button>
-<!-- <button class="layui-btn layui-btn-normal layui-btn-xs" type="button" shiro:hasPermission="updateReferer:update" lay-event="updateReferer">修改推荐人</button>-->
+ <button class="layui-btn layui-btn-normal layui-btn-xs" type="button" shiro:hasPermission="updateReferer:update" lay-event="updateReferer">修改推荐人</button>
</script>
<script type="text/html" id="switchAccountLevel">
{{# if(d.accountLevel == 1) { }}
@@ -69,6 +87,14 @@
<input type="checkbox" value={{d.id}} lay-text="正常|禁用" checked lay-skin="switch" lay-filter="switchStatus">
{{# } else { }}
<input type="checkbox" value={{d.id}} lay-text="正常|禁用" lay-skin="switch" lay-filter="switchStatus">
+ {{# } }}
+</script>
+
+<script type="text/html" id="switchInsideWith">
+ {{# if(d.insideWith === 1) { }}
+ <input type="checkbox" value={{d.id}} lay-text="正常|禁用" checked lay-skin="switch" lay-filter="switchInsideWith">
+ {{# } else { }}
+ <input type="checkbox" value={{d.id}} lay-text="正常|禁用" lay-skin="switch" lay-filter="switchInsideWith">
{{# } }}
</script>
<style>
@@ -98,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;
@@ -113,7 +140,7 @@
initTable();
// 初始化表格操作栏各个按钮功能
- table.on('tool(userTable)', function (obj) {
+ table.on('tool(memberTable)', function (obj) {
var data = obj.data,
layEvent = obj.event;
@@ -220,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:[],
@@ -231,8 +258,8 @@
{field: 'name', title: '名称', minWidth: 100,align:'left', totalRowText: '合计：'},
{field: 'inviteId', title: '邀请码', minWidth: 100,align:'left'},
{field: 'balance', title: '余额', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.balance) }}'},
+ {field: 'score', title: '赠送积分', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.score) }}'},
{field: 'prizeScore', title: '现金积分', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.prizeScore) }}'},
- {field: 'commission', title: '佣金', minWidth: 100,align:'left',totalRow: '{{= parseInt(d.commission) }}'},
{field: 'childNodeCnt', title: '粉丝数量', minWidth: 100,align:'left'},
{field: 'referrerName', title: '推荐人', minWidth: 100,align:'left'},
{field: 'levelName', title: '会员类型', minWidth: 100,align:'left'},
@@ -248,6 +275,7 @@
}
}, minWidth: 100,align:'left'},
{field: 'accountStatus', title: '账号状态', templet: '#switchStatus', minWidth: 100,align:'left'},
+ {field: 'insideWith', title: '余额转增', templet: '#switchInsideWith', minWidth: 100,align:'left'},
{field: 'createdTime', title: '注册时间', minWidth: 180,align:'left'},
// {title: '操作',
// templet: function (d) {
@@ -262,7 +290,7 @@
});
}
- table.on('toolbar(userTable)', function(obj){
+ table.on('toolbar(memberTable)', function(obj){
var data = obj.data,
layEvent = obj.event;
@@ -280,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;
@@ -302,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;
@@ -318,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;
@@ -331,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;
@@ -344,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;
@@ -357,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;
@@ -370,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;
@@ -472,5 +500,10 @@
changeIdentityNo(4, data.value);
}
})
+
+
+ $exportExcel.on('click', function() {
+ febs.download(ctx + 'admin/mallMember/exportMemberList', getQueryParams(), '会员列表.xlsx');
+ });
})
</script>
\ No newline at end of file
--
Gitblit v1.9.1