From 4109495b9c51a4bbd8b0a7c3c69093909d2e33e1 Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期一, 07 四月 2025 18:55:05 +0800 Subject: [PATCH] 修改接口bug --- ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/ComplainController.java | 36 ++++++++++++++++++++++++++++++++++++ 1 files changed, 36 insertions(+), 0 deletions(-) diff --git a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/ComplainController.java b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/ComplainController.java index 9069c79..4f02390 100644 --- a/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/ComplainController.java +++ b/ruoyi-modules/ruoyi-system/src/main/java/com/ruoyi/system/controller/ComplainController.java @@ -1,16 +1,23 @@ package com.ruoyi.system.controller; +import cn.afterturn.easypoi.excel.ExcelExportUtil; +import cn.afterturn.easypoi.excel.entity.ExportParams; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.web.page.PageInfo; import com.ruoyi.system.query.ComplainListReq; import com.ruoyi.system.query.ComplainListResp; import com.ruoyi.system.service.IComplainService; import io.swagger.annotations.ApiOperation; +import org.apache.poi.ss.usermodel.Workbook; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.annotation.Resource; +import javax.servlet.ServletOutputStream; +import javax.servlet.http.HttpServletResponse; +import java.io.IOException; +import java.net.URLEncoder; /** * @author zhibing.pu @@ -31,4 +38,33 @@ return R.ok(page); } + + @GetMapping("/exportComplainList") + @ApiOperation(value = "导出投诉记录列表", tags = {"投诉记录"}) + public void exportComplainList(ComplainListReq complainListReq, HttpServletResponse response) { + complainListReq.setPageSize(99999); + PageInfo<ComplainListResp> page = complainService.getComplainList(complainListReq); + Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), ComplainListResp.class, page.getRecords()); + response.setCharacterEncoding("utf-8"); + ServletOutputStream outputStream = null; + try { + String fileName = URLEncoder.encode("投诉记录.xls", "utf-8"); + response.setHeader("Content-Disposition", "attachment;filename=" + fileName); + response.setContentType("application/vnd.ms-excel;charset=UTF-8"); + response.setHeader("Pragma", "no-cache"); + response.setHeader("Cache-Control", "no-cache"); + outputStream = response.getOutputStream(); + workbook.write(outputStream); + } catch (IOException e) { + e.printStackTrace(); + } finally { + try { + workbook.close(); + outputStream.close(); + } catch (IOException e) { + e.printStackTrace(); + } + } + } + } -- Gitblit v1.7.1