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/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java b/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java
index 6aeac21..f343339 100644
--- a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java
+++ b/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java
@@ -15,6 +15,7 @@
import cc.mrbird.febs.system.entity.Dept;
import com.alibaba.excel.EasyExcel;
+import com.baomidou.mybatisplus.core.metadata.IPage;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.annotations.Param;
@@ -507,4 +508,18 @@
EasyExcel.write(response.getOutputStream(),AdminMoneyFlowListVo.class).sheet("资金明细表").doWrite(list);
}
+ @GetMapping("exportMemberList")
+ public void exportMemberList(MallMember mallMember, HttpServletResponse response) throws IOException {
+ QueryRequest request = new QueryRequest();
+ request.setPageNum(1);
+ request.setPageSize(999999999);
+ List<MallMember> list = mallMemberService.getMallMemberList(mallMember, request).getRecords();
+
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setCharacterEncoding("utf-8");
+ String fileName= URLEncoder.encode("会员列表","UTF-8").replaceAll("\\+","%20");
+ response.setHeader("Content-disposition","attachment;filename*=utf-8''"+fileName+".xlsx");
+ EasyExcel.write(response.getOutputStream(),MallMember.class).sheet("会员列表").doWrite(list);
+ }
+
}
--
Gitblit v1.9.1