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度为高温
|
}
|
