- entrtiy(实体类)
- ExportUserLog (导出用户日志)
- 时间转换器
- mapper
- service
- impl
- controller
- 数据库
仅供参考(笔记记录) entrtiy(实体类)
@ApiModel(value = "用户日志对象")
@Data
@SuperBuilder
@AllArgsConstructor
@NoArgsConstructor
@TableName(value = "sys_user_log")
public class UserLog implements Serializable {
private static final long serialVersionUID = 1L;
@TableId(value = "id", type = IdType.AUTO)
@ApiModelProperty(value = "主键")
private Long id;
@TableField(value = "url")
@ApiModelProperty(value = "访问接口路径")
private String url;
@TableField(value = "username")
@ApiModelProperty(value = "用户名称")
private String username;
@TableField(value = "type")
@ApiModelProperty(value = "日志类型")
private String type;
@TableField(value = "method")
@ApiModelProperty(value = "方法")
private String method;
@TableField(value = "params")
@ApiModelProperty(value = "参数")
private String params;
@TableField(value = "ip")
@ApiModelProperty(value = "IP地址")
private String ip;
@TableField(value = "remark")
@ApiModelProperty(value = "备注")
private String remark;
@TableField(value = "speed_time")
@ApiModelProperty(value = "查询接口花费时间")
private Integer speedTime;
@TableField(value = "create_time")
@ApiModelProperty(value = "创建时间")
private LocalDateTime createTime;
}
ExportUserLog (导出用户日志)
@Data
@ContentRowHeight(20)
@HeadRowHeight(20)
@ColumnWidth(30)
public class ExportUserLog {
@ExcelProperty(value = "用户名", index = 0)
@ApiModelProperty(value = "用户名")
private String username;
@ExcelProperty(value = "日志类型", index = 1)
@ApiModelProperty(value = "日志类型")
private String type;
@ExcelProperty(value = "内容", index = 2)
@ApiModelProperty(value = "内容")
private String remark;
@ExcelProperty(value = "登录ip", index = 3)
@ApiModelProperty(value = "登录ip")
private String ip;
@ExcelProperty(value = "花费时间", index = 4)
@ApiModelProperty(value = "查询接口花费时间")
private Integer speedTime;
@ExcelProperty(value = "参数", index = 5)
@ApiModelProperty(value = "参数")
private String params;
@ExcelProperty(value = "路径", index = 6)
@ApiModelProperty(value = "路径")
private String url;
@ExcelProperty(value = "操作时间", index = 7, converter = LocalDateTimeConverter.class)
@ApiModelProperty(value = "操作时间")
private LocalDateTime createTime;
}
时间转换器
public class LocalDateTimeConverter implements Convertermapper{ @Override public Class supportJavaTypeKey() { return LocalDateTime.class; } @Override public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.STRING; } @Override public LocalDateTime convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception { return LocalDateTime.parse(cellData.getStringValue(), DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); } @Override public CellData convertToExcelData(LocalDateTime localDateTime, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception { return new CellData<>(localDateTime.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))); } }
public interface UserLogMapper extends BaseMapperservice{ }
public interface UserLogService extends IServiceimpl{ void exportUserLog(Long[] ids, String startTime , String endTime ,String username, String type, HttpServletResponse response); }
@Slf4j @Service public class UserLogServiceImpl extends ServiceImplcontrollerimplements UserLogService { @Override public void exportUserLog(Long[] ids, String startTime, String endTime, String username, String type, HttpServletResponse response) { //Lambda 查询链包装器 LambdaQueryChainWrapper lambda = this.lambdaQuery(); //判断ids是否存在 if (ids != null && ids.length > 0) { lambda.in(UserLog::getId, Arrays.asList(ids)); } else { //按时间区查询数据的数据 lambda.between(StringUtils.isNotBlank(startTime) && StringUtils.isNotBlank(endTime), UserLog::getCreateTime, startTime, endTime + " 23:59:59"); //根据用户名或者类型模糊查询数据 lambda.like(StringUtils.isNotBlank(username), UserLog::getUsername, username); lambda.eq(StringUtils.isNotBlank(type), UserLog::getType, type); } //系统当前时间 String dateStr = String.valueOf(System.currentTimeMillis()); //获取当前计算机名称,表格导到桌面 Map map = System.getenv(); String localName = map.get("USERNAME"); ExcelWriter excelWriter = EasyExcel.write("C:\Users\" + localName + "\Desktop\用户操作日志记录表.xlsx").head(ExportUserLog.class).build(); //表sheet名 WriteSheet writeSheet = EasyExcel.writerSheet("用户操作日志记录表").build(); int current = 1; while (true) { // 分页 Page page = new Page<>(current, 2000); page = lambda.page(page); //类型转换 List exportUserLogList = convert(page.getRecords()); log.info("获取数据:{}", JSON.toJSONString(exportUserLogList)); excelWriter.write(exportUserLogList, writeSheet); if (page.getRecords().size() < 2000) { break; } current++; EasyExcelUtil.writeExcel(response, exportUserLogList, dateStr, "用户操作日志记录表", ExportUserLog.class); } excelWriter.finish(); } public List convert(List records) { if (CollUtil.isEmpty(records)) { return Collections.emptyList(); } List exportUserLogList = new ArrayList<>(); for (UserLog userLog : records) { ExportUserLog exportUserLog = new ExportUserLog(); exportUserLog.setUsername(userLog.getUsername()); exportUserLog.setType(userLog.getType()); exportUserLog.setRemark(userLog.getRemark()); exportUserLog.setIp(userLog.getIp()); exportUserLog.setSpeedTime(userLog.getSpeedTime()); exportUserLog.setParams(StrUtil.isBlank( userLog.getParams()) ? userLog.getParams() : userLog.getParams().substring( 0, userLog.getParams().length() > 200 ? 200 : userLog.getParams().length()) ); exportUserLog.setUrl(userLog.getUrl()); exportUserLog.setCreateTime(userLog.getCreateTime()); exportUserLogList.add(exportUserLog); } return exportUserLogList; } }
@Api(tags = "日志管理")
@RequestMapping("/user/log")
@RestController
public class UserLogController {
@Resource
private UserLogService userLogService;
@ApiOperation(value = "用户日志导出")
@ApiImplicitParams({
@ApiImplicitParam(name = "ids", value = "需要导出id集合"),
@ApiImplicitParam(name = "current", value = "当前页", required = true),
@ApiImplicitParam(name = "size", value = "每页显示的大小", required = true),
@ApiImplicitParam(name = "type", value = "日志类型"),
@ApiImplicitParam(name = "startTime", value = "开始时间"),
@ApiImplicitParam(name = "endTime", value = "结束时间"),
@ApiImplicitParam(name = "username", value = "用户名称")
})
@ApiResponses({
@ApiResponse(code = 200, message = "OK", response = UserLog.class)
})
@GetMapping("/export")
public void exportUserLog(Long[] ids, String startTime, String endTime, String username, String type, HttpServletResponse response) {
userLogService.exportUserLog(ids, startTime, endTime, username, type, response);
}
数据库
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for sys_user_log -- ---------------------------- DROP TABLE IF EXISTS `sys_user_log`; CREATE TABLE `sys_user_log` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '访问接口地址', `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名称', `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志类型 1查询 2修改 3新增 4删除 5导出 6审核', `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '方法', `params` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '参数', `ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IP地址', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `speed_time` int NULL DEFAULT NULL COMMENT '请求接口花费时间', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 712391 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统日志' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user_log -- ---------------------------- INSERT INTO `sys_user_log` VALUES (620687, '/user/information', 'anonymousUser', '修改/新增', NULL, NULL, '192.168.1.1', '获取请求参数获取查询用户数据', 0, '2021-05-08 13:56:54'); INSERT INTO `sys_user_log` VALUES (620690, '/sys/platform', 'xuerge', '删除', NULL, NULL, '192.168.1.2', '获取当前用户登录的子系统', 0, '2021-05-08 13:56:55'); INSERT INTO `sys_user_log` VALUES (620691, '/button/byPath', 'wangml', '查询', NULL, NULL, '192.168.1.3', '根据路由地址获取当前用户分配的按钮', 0, '2021-05-08 13:57:18'); INSERT INTO `sys_user_log` VALUES (620706, '/button/byPath', 'zyh001', '查询', NULL, NULL, '192.168.1.4', '根据路由地址获取当前用户分配的按钮', 0, '2021-05-08 14:00:06'); SET FOREIGN_KEY_CHECKS = 1;



