From ec09e9f2c72ff37654076c327008ac89ed32a8c3 Mon Sep 17 00:00:00 2001
From: jiangqs <343695869@qq.com>
Date: 星期六, 24 六月 2023 17:44:11 +0800
Subject: [PATCH] 导入导出
---
ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/controller/management/MgtMemberController.java | 56 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 55 insertions(+), 1 deletions(-)
diff --git a/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/controller/management/MgtMemberController.java b/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/controller/management/MgtMemberController.java
index dfb24b3..45f7f60 100644
--- a/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/controller/management/MgtMemberController.java
+++ b/ruoyi-modules/ruoyi-member/src/main/java/com/ruoyi/member/controller/management/MgtMemberController.java
@@ -2,6 +2,7 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.common.core.domain.R;
+import com.ruoyi.common.core.utils.poi.ExcelUtil;
import com.ruoyi.common.security.utils.SecurityUtils;
import com.ruoyi.member.domain.dto.*;
import com.ruoyi.member.domain.vo.*;
@@ -15,6 +16,7 @@
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
+import javax.servlet.http.HttpServletResponse;
import java.util.List;
/**
@@ -54,6 +56,17 @@
page.setCurrent(mgtMemberPageDto.getPageNum());
List<MgtMemberPageVo> mgtShopPageVoList = memberService.pageMgtMember(page,mgtMemberPageDto);
return R.ok(page.setRecords(mgtShopPageVoList));
+ }
+
+ @RequestMapping(value = "/exportPageMgtMember", method = RequestMethod.POST)
+ @ApiOperation(value = "导出会员列表")
+ public void exportPageMgtMember(@RequestBody MgtMemberPageDto mgtMemberPageDto, HttpServletResponse response) {
+ Page<MgtMemberPageVo> page = new Page<>();
+ page.setSize(2000);
+ page.setCurrent(1);
+ List<MgtMemberPageVo> mgtShopPageVoList = memberService.pageMgtMember(page,mgtMemberPageDto);
+ ExcelUtil<MgtMemberPageVo> util = new ExcelUtil<MgtMemberPageVo>(MgtMemberPageVo.class);
+ util.exportExcel(response, mgtShopPageVoList, "用户管理");
}
@RequestMapping(value = "/editMemberRelationShop", method = RequestMethod.POST)
@@ -100,10 +113,23 @@
Long userId = SecurityUtils.getUserId();
mgtMemberIntegralPageDto.setUserId(userId);
Page<MgtMemberIntegralPageVo> page = new Page<>();
+ page.setSize(2000);
+ page.setCurrent(1);
+ List<MgtMemberIntegralPageVo> mgtMemberIntegralPageVoList = integralRecordService.pageMgtMemberIntegral(page,mgtMemberIntegralPageDto);
+ return R.ok(page.setRecords(mgtMemberIntegralPageVoList));
+ }
+
+ @RequestMapping(value = "/exportPageMgtMemberIntegral", method = RequestMethod.POST)
+ @ApiOperation(value = "导出用户积分列表")
+ public void exportPageMgtMemberIntegral(@RequestBody MgtMemberIntegralPageDto mgtMemberIntegralPageDto, HttpServletResponse response) {
+ Long userId = SecurityUtils.getUserId();
+ mgtMemberIntegralPageDto.setUserId(userId);
+ Page<MgtMemberIntegralPageVo> page = new Page<>();
page.setSize(mgtMemberIntegralPageDto.getPageSize());
page.setCurrent(mgtMemberIntegralPageDto.getPageNum());
List<MgtMemberIntegralPageVo> mgtMemberIntegralPageVoList = integralRecordService.pageMgtMemberIntegral(page,mgtMemberIntegralPageDto);
- return R.ok(page.setRecords(mgtMemberIntegralPageVoList));
+ ExcelUtil<MgtMemberIntegralPageVo> util = new ExcelUtil<MgtMemberIntegralPageVo>(MgtMemberIntegralPageVo.class);
+ util.exportExcel(response, mgtMemberIntegralPageVoList, "用户积分列表");
}
@RequestMapping(value = "/pageMgtMemberBrowse", method = RequestMethod.POST)
@@ -116,6 +142,19 @@
page.setCurrent(mgtMemberBrowsePageDto.getPageNum());
List<MgtMemberBrowsePageVo> mgtMemberBrowsePageVoList = browseRecordService.pageMgtMemberBrowse(page,mgtMemberBrowsePageDto);
return R.ok(page.setRecords(mgtMemberBrowsePageVoList));
+ }
+
+ @RequestMapping(value = "/exportPageMgtMemberBrowse", method = RequestMethod.POST)
+ @ApiOperation(value = "导出用户浏览记录")
+ public void exportPageMgtMemberBrowse(@RequestBody MgtMemberBrowsePageDto mgtMemberBrowsePageDto, HttpServletResponse response) {
+ Long userId = SecurityUtils.getUserId();
+ mgtMemberBrowsePageDto.setUserId(userId);
+ Page<MgtMemberBrowsePageVo> page = new Page<>();
+ page.setSize(2000);
+ page.setCurrent(1);
+ List<MgtMemberBrowsePageVo> mgtMemberBrowsePageVoList = browseRecordService.pageMgtMemberBrowse(page,mgtMemberBrowsePageDto);
+ ExcelUtil<MgtMemberBrowsePageVo> util = new ExcelUtil<MgtMemberBrowsePageVo>(MgtMemberBrowsePageVo.class);
+ util.exportExcel(response, mgtMemberBrowsePageVoList, "用户浏览记录");
}
@RequestMapping(value = "/editMemberArchiveFields", method = RequestMethod.POST)
@@ -138,6 +177,19 @@
page.setCurrent(memberSuggestPageDto.getPageNum());
List<MgtMemberSuggestPageVo> mgtMemberSuggestPageVoList = memberSuggestService.pageMgtMemberSuggest(page,memberSuggestPageDto);
return R.ok(page.setRecords(mgtMemberSuggestPageVoList));
+ }
+
+ @RequestMapping(value = "/exportPageMgtMemberSuggest", method = RequestMethod.POST)
+ @ApiOperation(value = "导出用户建议列表")
+ public void exportPageMgtMemberSuggest(@RequestBody MgtMemberSuggestPageDto memberSuggestPageDto, HttpServletResponse response) {
+ Long userId = SecurityUtils.getUserId();
+ memberSuggestPageDto.setUserId(userId);
+ Page<MgtMemberSuggestPageVo> page = new Page<>();
+ page.setSize(2000);
+ page.setCurrent(1);
+ List<MgtMemberSuggestPageVo> mgtMemberSuggestPageVoList = memberSuggestService.pageMgtMemberSuggest(page,memberSuggestPageDto);
+ ExcelUtil<MgtMemberSuggestPageVo> util = new ExcelUtil<MgtMemberSuggestPageVo>(MgtMemberSuggestPageVo.class);
+ util.exportExcel(response, mgtMemberSuggestPageVoList, "用户建议列表");
}
@RequestMapping(value = "/mgtReplayMemberSuggest", method = RequestMethod.POST)
@@ -165,4 +217,6 @@
memberSuggestService.mgtEditMemberSuggestTag(mgtTagMemberSuggestDto);
return R.ok();
}
+
+
}
--
Gitblit v1.7.1