From ca19af1898405b969d2d9e8a3d07f9b1ee7fc938 Mon Sep 17 00:00:00 2001 From: Hentua <wangdoubleone@gmail.com> Date: Sun, 02 Jul 2023 11:24:04 +0800 Subject: [PATCH] fix --- src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java | 17 ++++++++++++++++- 1 files changed, 16 insertions(+), 1 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..ae9efa6 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; @@ -496,7 +497,7 @@ public void exportMoneyFlow(MoneyFlowListDto moneyFlowListDto, HttpServletResponse response) throws IOException { QueryRequest request = new QueryRequest(); request.setPageNum(1); - request.setPageSize(999999999); + request.setPageSize(999999); List<AdminMoneyFlowListVo> list = this.mallMemberService.getMoneyFlowListInPage(moneyFlowListDto, request).getRecords(); @@ -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(999999); + 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