Hutool工具类导出数据为excel

利用hutool工具类导出excel

1、AlarmByDetour4AReport 对象中属性为待导出字段

/**
 * @Author zhangwb
 * @Date 2021/3/24 10:19
 **/
@Data
@ApiModel(description = "告警报表统计返参")
public class AlarmByDetour4AReport {

    @ApiModelProperty(value = "组织机构Name")
    private String organName;

    @ApiModelProperty(value = "绕行4a未处理")
    private Integer noTreatedAlarmByDetour4A;

    @ApiModelProperty(value = "绕行4a已处理")
    private Integer treatedAlarmByDetour4A;

    @ApiModelProperty(value = "暴力破解未处理")
    private Integer noTreatedBruteForceCount;

    @ApiModelProperty(value = "暴力破解已处理")
    private Integer treatedBruteForceCount;
}

2、service接口实现 进行数据查询逻辑处理

    @Override
    public List<AlarmByDetour4AReport>  alarmStatement(AlarmStatementRequest alarmStatementRequest) {
    	//系统模块接口调用
        Map<String, String> organIdAndNameMap = systemPermissionClient.getOrganIdAndNameMap();
        List<AlarmByDetour4AReport> result = new ArrayList<>();
        if (StringUtils.equals(alarmStatementRequest.getAuditTypes(), AUDIT_TYPE_OPERATION_EQUIPMENT)){
            //如果页面没有传平台id 则查询当前用户下所有平台id
//            if (alarmStatementRequest.getPlatformIds().size() == 0 || alarmStatementRequest.getPlatformIds() == null) {
//                alarmStatementRequest.setPla