栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

日志导出-Excel

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

日志导出-Excel

用户导出日志
  • 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 Converter {

    @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")));
    }
}
mapper
public interface UserLogMapper extends BaseMapper {
}
service
public interface UserLogService extends IService {
     
     void exportUserLog(Long[] ids, String startTime , String endTime ,String username,
                        String type, HttpServletResponse response);
}
impl
@Slf4j
@Service
public class UserLogServiceImpl extends ServiceImpl implements 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;
    }

}
controller
@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;
转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/973562.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号