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-order/src/main/java/com/ruoyi/order/controller/management/MgtOrderController.java | 63 +++++++++++++++++++++++++++++++
1 files changed, 63 insertions(+), 0 deletions(-)
diff --git a/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/controller/management/MgtOrderController.java b/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/controller/management/MgtOrderController.java
index 5f0f69c..421608b 100644
--- a/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/controller/management/MgtOrderController.java
+++ b/ruoyi-modules/ruoyi-order/src/main/java/com/ruoyi/order/controller/management/MgtOrderController.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.order.domain.dto.MgtMemberOrderPageDto;
import com.ruoyi.order.domain.dto.MgtMemberOrderTotalDto;
@@ -17,7 +18,9 @@
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
+import javax.servlet.http.HttpServletResponse;
import java.util.List;
+import java.util.stream.Collectors;
/**
* @author jqs34
@@ -55,6 +58,30 @@
return R.ok(page.setRecords(mgtMemberOrderPageVoList));
}
+ @RequestMapping(value = "/exportPageMgtMemberOrder", method = RequestMethod.POST)
+ @ApiOperation(value = "平台获取用户订单列表")
+ public void exportPageMgtMemberOrder(@RequestBody MgtMemberOrderPageDto mgtMemberOrderPageDto, HttpServletResponse response) {
+ Long userId = SecurityUtils.getUserId();
+ mgtMemberOrderPageDto.setUserId(userId);
+ Page<MgtMemberOrderPageVo> page = new Page<>();
+ page.setSize(2000);
+ page.setCurrent(1);
+ List<MgtMemberOrderPageVo> mgtMemberOrderPageVoList = orderService.pageMgtMemberOrder(page,mgtMemberOrderPageDto);
+ if(!mgtMemberOrderPageVoList.isEmpty()){
+ List<MgtOrderGoodsPageVo> mgtOrderGoodsVoList;
+ String goodsString;
+ for(MgtMemberOrderPageVo entity : mgtMemberOrderPageVoList){
+ mgtOrderGoodsVoList = entity.getMgtOrderGoodsVoList();
+ goodsString = mgtOrderGoodsVoList.stream()
+ .map(goods -> goods.getGoodsName() + "*" + goods.getBuyNum())
+ .collect(Collectors.joining(";"));
+ entity.setGoodsInfo(goodsString);
+ }
+ }
+ ExcelUtil<MgtMemberOrderPageVo> util = new ExcelUtil<MgtMemberOrderPageVo>(MgtMemberOrderPageVo.class);
+ util.exportExcel(response, mgtMemberOrderPageVoList, "用户订单列表");
+ }
+
@RequestMapping(value = "/getMgtOrderTotal", method = RequestMethod.POST)
@ApiOperation(value = "获取订单统计")
public R<MgtOrderTotal> getMgtOrderTotal(@RequestBody MgtShopOrderPageDto mgtShopOrderPageDto) {
@@ -76,6 +103,19 @@
return R.ok(page.setRecords(mgtActivityOrderPageVos));
}
+ @RequestMapping(value = "/exportPageMgtActivityOrder", method = RequestMethod.POST)
+ @ApiOperation(value = "导出秒杀订单列表")
+ public void exportPageMgtActivityOrder(@RequestBody MgtShopOrderPageDto mgtShopOrderPageDto, HttpServletResponse response) {
+ Long userId = SecurityUtils.getUserId();
+ mgtShopOrderPageDto.setUserId(userId);
+ Page<MgtActivityOrderPageVo> page = new Page<>();
+ page.setSize(2000);
+ page.setCurrent(1);
+ List<MgtActivityOrderPageVo> mgtActivityOrderPageVos = orderService.pageMgtActivityOrder(page,mgtShopOrderPageDto);
+ ExcelUtil<MgtActivityOrderPageVo> util = new ExcelUtil<MgtActivityOrderPageVo>(MgtActivityOrderPageVo.class);
+ util.exportExcel(response, mgtActivityOrderPageVos, "秒杀订单列表");
+ }
+
@RequestMapping(value = "/pageMgtShopOrder", method = RequestMethod.POST)
@ApiOperation(value = "平台获取门店订单列表")
public R<Page<MgtShopOrderPageVo>> pageMgtShopOrder(@RequestBody MgtShopOrderPageDto mgtShopOrderPageDto) {
@@ -88,6 +128,29 @@
return R.ok(page.setRecords(shopOrderPageVoList));
}
+ @RequestMapping(value = "/exportPageMgtShopOrder", method = RequestMethod.POST)
+ @ApiOperation(value = "导出门店订单列表")
+ public void exportPageMgtShopOrder(@RequestBody MgtShopOrderPageDto mgtShopOrderPageDto, HttpServletResponse response) {
+ Long userId = SecurityUtils.getUserId();
+ mgtShopOrderPageDto.setUserId(userId);
+ Page<MgtShopOrderPageVo> page = new Page<>();
+ page.setSize(2000);
+ page.setCurrent(1);
+ List<MgtShopOrderPageVo> shopOrderPageVoList = orderService.pageMgtShopOrder(page,mgtShopOrderPageDto);
+ if(!shopOrderPageVoList.isEmpty()){
+ List<MgtOrderGoodsPageVo> mgtOrderGoodsVoList;
+ String goodsString;
+ for(MgtShopOrderPageVo entity : shopOrderPageVoList){
+ mgtOrderGoodsVoList = entity.getMgtOrderGoodsPageVoList();
+ goodsString = mgtOrderGoodsVoList.stream()
+ .map(goods -> goods.getGoodsName() + "*" + goods.getBuyNum())
+ .collect(Collectors.joining(";"));
+ entity.setGoodsInfo(goodsString);
+ }
+ }
+ ExcelUtil<MgtShopOrderPageVo> util = new ExcelUtil<MgtShopOrderPageVo>(MgtShopOrderPageVo.class);
+ util.exportExcel(response, shopOrderPageVoList, "门店订单列表");
+ }
@RequestMapping(value = "/getMgtOrderDetail", method = RequestMethod.POST)
@ApiOperation(value = "获取订单详情")
--
Gitblit v1.7.1