package org.springblade.common.entity; import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.write.style.ColumnWidth; import com.alibaba.excel.annotation.write.style.ContentRowHeight; import com.alibaba.excel.annotation.write.style.HeadRowHeight; import lombok.Data; @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class AlarmExcel { @ColumnWidth(15) @ExcelProperty("警情编号") private Integer id; @ColumnWidth(20) @ExcelProperty("警情类型") private String alarmType; @ColumnWidth(20) @ExcelProperty("接警人姓名") private String alarmPeople; @ColumnWidth(30) @ExcelProperty("报警时间") private String alarmTime; @ColumnWidth(30) @ExcelProperty("接警时间") private String jjTime; @ColumnWidth(20) @ExcelProperty("报警人") private String galarmPeople; // @ColumnWidth(15) // @ExcelProperty("性别(0:男,1:女)") @ExcelIgnore private String sex; @ColumnWidth(20) @ExcelProperty("联系电话") private String phoneNumber; @ColumnWidth(40) @ExcelProperty("事发地址") private String place; @ColumnWidth(30) @ExcelProperty("报警内容") private String content; @ColumnWidth(15) @ExcelProperty("警情类别") private String waringType; @ColumnWidth(20) @ExcelProperty("设备编号") private String deviceNumber; @ColumnWidth(30) @ExcelProperty("AOI区域编码") private String region; @ColumnWidth(10) @ExcelProperty("行政区编码") private String district; // @ColumnWidth(10) // @ExcelProperty("省份") @ExcelIgnore private String province; // @ColumnWidth(10) // @ExcelProperty("地市") @ExcelIgnore private String city; @ColumnWidth(15) @ExcelProperty("接警人ID") private String alarmId; @ColumnWidth(15) @ExcelProperty("警情级别") private String level; /** * 空间坐标 */ // @ApiModelProperty(value = "空间坐标") // private String coordinate; @ColumnWidth(20) @ExcelProperty("经度") private String jd; @ColumnWidth(20) @ExcelProperty("纬度") private String wd; // @ColumnWidth(10) // @ExcelProperty("是否生成警单(0:否 1:是)") @ExcelIgnore private String jtype; @ColumnWidth(20) @ExcelProperty("接警名称") private String rname; @ColumnWidth(30) @ExcelProperty("处置时间") private String czTime; @ColumnWidth(30) @ExcelProperty("备注") private String bz; // @ColumnWidth(30) // @ExcelProperty("报警时间") // private String cid; @ColumnWidth(30) @ExcelProperty("历史视频地址") private String vaddress; @ColumnWidth(30) @ExcelProperty("音频地址") private String aaddress; }