From 1cad14bca191807e18705c3a5526eda8151be439 Mon Sep 17 00:00:00 2001
From: zhanghua <314079846@qq.com>
Date: 星期一, 14 四月 2025 23:10:22 +0800
Subject: [PATCH] 批量审核和图片保存bug
---
ycl-common/src/main/java/com/ycl/controller/user/UmsAdminLogController.java | 74 ++-----------------------------------
1 files changed, 4 insertions(+), 70 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 2527140..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,29 +1,22 @@
package com.ycl.controller.user;
-import com.alibaba.excel.EasyExcel;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
-import com.baomidou.mybatisplus.core.toolkit.StringUtils;
-import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ycl.annotation.LogSave;
import com.ycl.api.CommonResult;
import com.ycl.dto.log.LogQueryParams;
-import com.ycl.entity.user.UmsAdmin;
import com.ycl.entity.user.UmsAdminLoginLog;
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;
-import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import javax.servlet.http.HttpServletResponse;
-import java.net.URLEncoder;
-import java.time.LocalDateTime;
import java.util.List;
-import java.util.stream.Collectors;
@RestController
@RequestMapping("/log_manage")
@@ -37,34 +30,8 @@
@GetMapping("/query")
@ApiOperation(value = "鏌ヨ")
- @LogSave(operationType = "鏃ュ織绠＄悊", contain = "鏌ヨ鏃ュ織淇℃伅")
public CommonResult searchLog(LogQueryParams logQueryParams) {
- Page<UmsAdminLoginLog> umsAdminLoginLogPage = new Page<>();
- umsAdminLoginLogPage.setCurrent(logQueryParams.getCurrent());
- umsAdminLoginLogPage.setSize(logQueryParams.getSize());
- Page<UmsAdminLoginLog> page = iAdminLoginLogService
- .page(umsAdminLoginLogPage, new LambdaQueryWrapper<UmsAdminLoginLog>()
- .like(StringUtils.isNotBlank(logQueryParams.getContent()), UmsAdminLoginLog::getContain, logQueryParams.getContent())
- .eq(StringUtils.isNotBlank(logQueryParams.getOperationType()), UmsAdminLoginLog::getOperationType, logQueryParams.getOperationType())
- .eq(StringUtils.isNotBlank(logQueryParams.getPortEquipment()), UmsAdminLoginLog::getUserAgent, logQueryParams.getPortEquipment())
- .eq(logQueryParams.getId() != null, UmsAdminLoginLog::getAdminId, logQueryParams.getId())
- .between(logQueryParams.getStartTime() != null && logQueryParams.getEndTime() != null, UmsAdminLoginLog::getCreateTime, logQueryParams.getStartTime(), logQueryParams.getEndTime())
- .orderBy(logQueryParams.getSort() != null && logQueryParams.getSort() == 0, true, UmsAdminLoginLog::getCreateTime)
- .orderBy(logQueryParams.getSort() != null && logQueryParams.getSort() == 1, false, UmsAdminLoginLog::getCreateTime));
- List<UmsAdminLogVO> umsAdminLogVOList = page.getRecords().stream()
- .map(item -> {
- UmsAdminLogVO umsAdminlogVO = new UmsAdminLogVO();
- BeanUtils.copyProperties(item, umsAdminlogVO);
- umsAdminlogVO.setAdminId(umsAdminService
- .getOne(new LambdaQueryWrapper<UmsAdmin>()
- .eq(UmsAdmin::getId, item.getAdminId()))
- .getUsername());
- return umsAdminlogVO;
- }).collect(Collectors.toList());
- Page<UmsAdminLogVO> umsAdminLogVOPage = new Page<>();
- BeanUtils.copyProperties(page, umsAdminLogVOPage);
- umsAdminLogVOPage.setRecords(umsAdminLogVOList);
- return CommonResult.success(umsAdminLogVOPage);
+ return CommonResult.success(iAdminLoginLogService.pageList(logQueryParams));
}
@DeleteMapping("/deletion_batch")
@@ -92,40 +59,7 @@
@SneakyThrows
@LogSave(operationType = "鏃ュ織绠＄悊", contain = "瀵煎嚭鏃ュ織")
public void export(HttpServletResponse response, LogQueryParams logQueryParams) {
- Page<UmsAdminLoginLog> umsAdminLoginLogPage = new Page<>();
- umsAdminLoginLogPage.setCurrent(logQueryParams.getCurrent());
- umsAdminLoginLogPage.setSize(logQueryParams.getSize());
- StringBuilder fileName = new StringBuilder();
- fileName.append(LocalDateTime.now().getYear())
- .append("-")
- .append(LocalDateTime.now().getMonthValue())
- .append("-")
- .append(LocalDateTime.now().getDayOfMonth())
- .append("鏃ュ織鏁版嵁");
- response.setContentType("application/vnd.ms-excel");
- response.setCharacterEncoding("utf-8");
- String file = URLEncoder.encode(fileName.toString(), "UTF-8").replaceAll("\\+", "%20");
- response.setHeader("Content-disposition", "attachment;filename=" + file + ".xlsx");
- EasyExcel
- .write(response.getOutputStream(), UmsAdminLogVO.class)
- .sheet("鏁版嵁")
- .doWrite(iAdminLoginLogService
- .page(umsAdminLoginLogPage, new LambdaQueryWrapper<UmsAdminLoginLog>()
- .like(StringUtils.isNotBlank(logQueryParams.getContent()), UmsAdminLoginLog::getContain, logQueryParams.getContent())
- .eq(StringUtils.isNotBlank(logQueryParams.getOperationType()), UmsAdminLoginLog::getOperationType, logQueryParams.getOperationType())
- .between(logQueryParams.getStartTime() != null && logQueryParams.getEndTime() != null, UmsAdminLoginLog::getCreateTime, logQueryParams.getStartTime(), logQueryParams.getEndTime())
- .orderBy(logQueryParams.getSort() != null && logQueryParams.getSort() == 0, true, UmsAdminLoginLog::getCreateTime)
- .orderBy(logQueryParams.getSort() != null && logQueryParams.getSort() == 1, false, UmsAdminLoginLog::getCreateTime))
- .getRecords()
- .stream()
- .map(item -> {
- UmsAdminLogVO umsAdminlogVO = new UmsAdminLogVO();
- BeanUtils.copyProperties(item, umsAdminlogVO);
- umsAdminlogVO.setAdminId(umsAdminService
- .getOne(new LambdaQueryWrapper<UmsAdmin>()
- .eq(UmsAdmin::getId, item.getAdminId()))
- .getUsername());
- return umsAdminlogVO;
- }).collect(Collectors.toList()));
+ String sheet = "鏁版嵁";
+ EasyExcelUtils.export(response, sheet, UmsAdminLogVO.class, iAdminLoginLogService.pageList(logQueryParams).getRecords());
}
}
--
Gitblit v1.8.0