| | |
| | | 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; |
| | | |
| | |
| | | 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("日志数据"); |
| | | String fileName ="日志数据"; |
| | | 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"); |
| | | response.setHeader("Content-disposition", "attachment;filename=" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + URLEncoder.encode(fileName + ".xlsx", "utf-8")); |
| | | EasyExcel |
| | | .write(response.getOutputStream(), UmsAdminLogVO.class) |
| | | .sheet("数据") |