From 392b42c4891cf2e6beda57ab32c51598f290f4b7 Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期五, 14 三月 2025 20:56:27 +0800
Subject: [PATCH] bug修改
---
ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/controller/management/MgtCouponController.java | 34 ++++++++++++++++++++++------------
1 files changed, 22 insertions(+), 12 deletions(-)
diff --git a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/controller/management/MgtCouponController.java b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/controller/management/MgtCouponController.java
index d2da704..74b2292 100644
--- a/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/controller/management/MgtCouponController.java
+++ b/ruoyi-modules/ruoyi-promotion/src/main/java/com/ruoyi/promotion/controller/management/MgtCouponController.java
@@ -2,9 +2,7 @@
import com.alibaba.excel.EasyExcel;
-import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.util.DateUtils;
-import com.alibaba.excel.write.metadata.WriteSheet;
import com.ruoyi.common.core.domain.R;
import com.ruoyi.common.core.utils.page.PageDTO;
import com.ruoyi.promotion.controller.management.dto.MgtCouponDTO;
@@ -15,11 +13,14 @@
import com.ruoyi.promotion.controller.management.vo.MgtCouponVO;
import com.ruoyi.promotion.service.ICouponService;
import com.ruoyi.system.api.validate.InsertGroup;
-import com.ruoyi.system.api.validate.ModifyGroup;
+import com.ruoyi.system.api.validate.UpdateGroup;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
+import java.io.IOException;
+import java.net.URLEncoder;
import java.util.Date;
import java.util.List;
+import javax.servlet.http.HttpServletResponse;
import lombok.RequiredArgsConstructor;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.PostMapping;
@@ -43,6 +44,7 @@
public class MgtCouponController {
private final ICouponService couponService;
+ private final HttpServletResponse response;
/**
* 获取优惠券列表的分页数据
@@ -75,7 +77,7 @@
*/
@ApiOperation("编辑优惠券")
@PutMapping("/update")
- public R<?> updateCoupon(@Validated(ModifyGroup.class) @RequestBody MgtCouponDTO dto) {
+ public R<?> updateCoupon(@Validated(UpdateGroup.class) @RequestBody MgtCouponDTO dto) {
couponService.updateCoupon(dto);
return R.ok();
}
@@ -115,14 +117,22 @@
public void exportReceiveDetail(@RequestBody MgtCouponReceiveQuery query) {
List<CouponReceiveDetailVO> couponReceiveDetailVOList = couponService.getCouponReceiveDetailList(
query);
- String fileName =
- "优惠券领取明细" + DateUtils.format(new Date(), "yyyyMMddHHmmss") + ".xlsx";
-
- try (ExcelWriter excelWriter = EasyExcel.write(fileName, CouponReceiveDetailVO.class)
- .build()) {
- WriteSheet writeSheet = EasyExcel.writerSheet("优惠券领取详情").build();
- excelWriter.write(couponReceiveDetailVOList, writeSheet);
+ response.setContentType(
+ "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setCharacterEncoding("utf-8");
+ // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
+ try {
+ String fileName = URLEncoder.encode(
+ "优惠券领取明细" + DateUtils.format(new Date(), "yyyyMMddHHmmss"), "UTF-8")
+ .replaceAll("\\+", "%20");
+ response.setHeader("Content-disposition",
+ "attachment;filename*=utf-8''" + fileName + ".xlsx");
+ EasyExcel.write(response.getOutputStream(), CouponReceiveDetailVO.class)
+ .sheet("优惠券领取明细")
+ .doWrite(couponReceiveDetailVOList);
+ } catch (IOException e) {
+ throw new RuntimeException(e);
}
}
-
}
+
--
Gitblit v1.7.1