package com.dy.pipIrrGlobal.voPr; 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 com.dy.common.po.BaseEntity; import com.fasterxml.jackson.annotation.JsonFormat; import com.fasterxml.jackson.annotation.JsonPropertyOrder; import io.swagger.v3.oas.annotations.media.Schema; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.util.Date; /** * @author WuZeYu * @date 2023/12/26 10:40 * @LastEditTime 2023/12/26 10:40 * @Description */ @Data @JsonPropertyOrder({ "intakeId", "intakeName", "divideId", "divideName", "blockId", "blockName", "isBind", "address", "lng", "lat", "operator", "operateDt", "remarks", "controllerId", "rtuAddr", "protocol", "findDt", "isOnLine", "bindNumber"}) @HeadRowHeight(30) @ContentRowHeight(20) public class VoIntake implements BaseEntity { private static final long serialVersionUID = 202312261049001L; @Schema(title = "取水口ID") @ExcelIgnore private String intakeId; @Schema(title = "取水口名称") @ExcelProperty(value = {"${title}", "取水口编号"}) @ColumnWidth(15) private String intakeName; @Schema(title = "分水房ID") @ExcelIgnore private String divideId; @Schema(title = "所属分水房") @ExcelProperty(value = {"${title}", "所属分水房"}) @ColumnWidth(15) private String divideName; @Schema(title = "片区ID") @ExcelIgnore private String blockId; @Schema(title = "所属片区") @ExcelProperty(value = {"${title}", "所属片区"}) @ColumnWidth(15) private String blockName; @Schema(title = "是否绑定设备") @ExcelProperty(value = {"${title}", "是否绑定设备"}) @ColumnWidth(10) private String isBind; @Schema(title = "地址") @ExcelProperty(value = {"${title}", "地址"}) @ColumnWidth(30) private String address; @Schema(title = "经度") @ExcelProperty(value = {"${title}", "经度"}) @ColumnWidth(20) private String lng; @Schema(title = "纬度") @ExcelProperty(value = {"${title}", "纬度"}) @ColumnWidth(20) private String lat; @Schema(title = "操作人") @ExcelIgnore @ColumnWidth(25) private String operator; @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @Schema(title = "操作时间") @ExcelIgnore private Date operateDt; @Schema(title = "备注") @ExcelIgnore private String remarks; @Schema(title = "控制器ID") @ExcelIgnore private String controllerId; @Schema(title = "控制器地址") @ExcelProperty(value = {"${title}", "控制器地址"}) @ColumnWidth(15) private String rtuAddr; @Schema(title = "通讯协议") @ExcelIgnore private String protocol; @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @Schema(title = "发现日期时间") @ExcelProperty(value = {"${title}", "发现时间"}) @ColumnWidth(20) private Date findDt; /** * 是否在线 */ @ExcelIgnore private Boolean isOnLine; @Schema(title = "绑定次数") @ExcelProperty(value = {"${title}", "绑定次数"}) @ColumnWidth(10) private Integer bindNumber; }