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; import org.springblade.common.converter.AnimalHeatTypeConverter; import java.util.Date; @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class AnimalHeatExcel { @ColumnWidth(12) @ExcelProperty("体温检测编号") private Integer id;// bigint(20) NOT NULL COMMENT '主键', @ColumnWidth(20) @ExcelProperty("设备序列号") private String serialno;//varchar(20) 序列号 @ColumnWidth(20) @ExcelProperty("设备IP") private String ip;// varchar(63) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备IP地址', @ColumnWidth(60) @ExcelProperty("图片URL") private String picture;// varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片url路径', /** * 忽略,不显示到excel */ @ExcelIgnore private String pictureRed;// varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '红外图片url路径', @ColumnWidth(15) @ExcelProperty("体温") private Float tempRed;// float(4,2) DEFAULT NULL COMMENT '当前人员的温度', @ColumnWidth(40) @ExcelProperty("人脸位置二位数组") private String personRect;// varchar(63) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '人脸位置二位数组,[left,top,right,bottom]', // @TableField("person_rect_red") // private String personRectRed;// varchar(63) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '红外人脸位置二位数组,[left,top,right,bottom]', @ColumnWidth(25) @ExcelProperty("创建时间") private Date createTime;// datetime DEFAULT NULL COMMENT '创建时间', @ColumnWidth(10) @ExcelProperty(value = "状态",converter = AnimalHeatTypeConverter.class) private Integer status;//状态 1为异常 0为正常 ,以37.3度为标准,大于37.3度为高温 }