From eb41baf336689cce9344e95c1bf1b0c702fc77d5 Mon Sep 17 00:00:00 2001 From: wl <173@qq.com> Date: 星期三, 09 十一月 2022 17:21:42 +0800 Subject: [PATCH] 违规检索和对导出进行封装 --- ycl-common/src/main/java/com/ycl/controller/user/UmsAdminLogController.java | 14 +++----------- 1 files changed, 3 insertions(+), 11 deletions(-) diff --git a/ycl-common/src/main/java/com/ycl/controller/user/UmsAdminLogController.java b/ycl-common/src/main/java/com/ycl/controller/user/UmsAdminLogController.java index 973780c..5eb9cd7 100644 --- a/ycl-common/src/main/java/com/ycl/controller/user/UmsAdminLogController.java +++ b/ycl-common/src/main/java/com/ycl/controller/user/UmsAdminLogController.java @@ -1,8 +1,6 @@ package com.ycl.controller.user; -import com.alibaba.excel.EasyExcel; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; -import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ycl.annotation.LogSave; import com.ycl.api.CommonResult; import com.ycl.dto.log.LogQueryParams; @@ -10,6 +8,7 @@ import com.ycl.entity.user.vo.UmsAdminLogVO; import com.ycl.service.user.IAdminLoginLogService; import com.ycl.service.user.UmsAdminService; +import com.ycl.utils.EasyExcelUtils; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.SneakyThrows; @@ -17,8 +16,6 @@ import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; -import java.time.LocalDateTime; -import java.time.format.DateTimeFormatter; import java.util.List; @RestController @@ -62,12 +59,7 @@ @SneakyThrows @LogSave(operationType = "鏃ュ織绠$悊", contain = "瀵煎嚭鏃ュ織") public void export(HttpServletResponse response, LogQueryParams logQueryParams) { - response.setContentType("application/vnd.ms-excel"); - response.setCharacterEncoding("utf-8"); - response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + ".xlsx"); - EasyExcel - .write(response.getOutputStream(), UmsAdminLogVO.class) - .sheet("鏁版嵁") - .doWrite(iAdminLoginLogService.pageList(logQueryParams).getRecords()); + String sheet = "鏁版嵁"; + EasyExcelUtils.export(response, sheet, UmsAdminLogVO.class, iAdminLoginLogService.pageList(logQueryParams).getRecords()); } } -- Gitblit v1.8.0