From c22b5eb143260a98b9aab8fc3281ffa2a5ca2eed Mon Sep 17 00:00:00 2001
From: mg <maokecheng@163.com>
Date: 星期五, 28 十月 2022 18:07:42 +0800
Subject: [PATCH] 修改

---
 ycl-common/src/main/java/com/ycl/controller/user/UmsAdminLogController.java |   57 +++------------------------------------------------------
 1 files changed, 3 insertions(+), 54 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 824f393..973780c 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
@@ -2,12 +2,10 @@
 
 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;
@@ -15,16 +13,13 @@
 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.time.format.DateTimeFormatter;
 import java.util.List;
-import java.util.stream.Collectors;
 
 @RestController
 @RequestMapping("/log_manage")
@@ -38,34 +33,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(StringUtils.isNotBlank(logQueryParams.getStartTime()) && StringUtils.isNotBlank(logQueryParams.getEndTime()), 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")
@@ -93,32 +62,12 @@
     @SneakyThrows
     @LogSave(operationType = "鏃ュ織绠$悊", contain = "瀵煎嚭鏃ュ織")
     public void export(HttpServletResponse response, LogQueryParams logQueryParams) {
-        Page<UmsAdminLoginLog> umsAdminLoginLogPage = new Page<>();
-        umsAdminLoginLogPage.setCurrent(logQueryParams.getCurrent());
-        umsAdminLoginLogPage.setSize(logQueryParams.getSize());
         response.setContentType("application/vnd.ms-excel");
         response.setCharacterEncoding("utf-8");
-        response.setHeader("Content-disposition", "attachment;filename=" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + URLEncoder.encode( ".xlsx", "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
-                        .page(umsAdminLoginLogPage, new LambdaQueryWrapper<UmsAdminLoginLog>()
-                                .like(StringUtils.isNotBlank(logQueryParams.getContent()), UmsAdminLoginLog::getContain, logQueryParams.getContent())
-                                .eq(StringUtils.isNotBlank(logQueryParams.getOperationType()), UmsAdminLoginLog::getOperationType, logQueryParams.getOperationType())
-                                .between(StringUtils.isNotBlank(logQueryParams.getStartTime()) && StringUtils.isNotBlank(logQueryParams.getEndTime()), 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()));
+                .doWrite(iAdminLoginLogService.pageList(logQueryParams).getRecords());
     }
 }

--
Gitblit v1.8.0