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 | 44 ++++++++++++++++++++++++++++++++++++++++---- 1 files changed, 40 insertions(+), 4 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 af8bba0..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 @@ -1,6 +1,8 @@ package com.ruoyi.promotion.controller.management; +import com.alibaba.excel.EasyExcel; +import com.alibaba.excel.util.DateUtils; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.utils.page.PageDTO; import com.ruoyi.promotion.controller.management.dto.MgtCouponDTO; @@ -11,9 +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; @@ -37,6 +44,7 @@ public class MgtCouponController { private final ICouponService couponService; + private final HttpServletResponse response; /** * 获取优惠券列表的分页数据 @@ -69,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(); } @@ -77,8 +85,7 @@ /** * 上架/下架 * - * @param dto - * @return + * @param dto 管理后台-优惠券上架下架数据传输对象 */ @ApiOperation("上架/下架") @PutMapping("/upd-status") @@ -99,4 +106,33 @@ @Validated @RequestBody MgtCouponReceiveQuery query) { return R.ok(couponService.getReceiveDetail(query)); } + + /** + * 导出优惠券领取详情 + * + * @param query 管理后台-优惠券领取详情查询对象 + */ + @ApiOperation("领取详情-导出") + @PostMapping("/receive-detail/export") + public void exportReceiveDetail(@RequestBody MgtCouponReceiveQuery query) { + List<CouponReceiveDetailVO> couponReceiveDetailVOList = couponService.getCouponReceiveDetailList( + query); + 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