package com.doumee.dao.business.model;
|
|
import com.baomidou.mybatisplus.annotation.TableField;
|
import com.doumee.core.annotation.excel.ExcelColumn;
|
import com.doumee.core.model.LoginUserModel;
|
import io.swagger.annotations.ApiModel;
|
import io.swagger.annotations.ApiModelProperty;
|
import com.baomidou.mybatisplus.annotation.IdType;
|
import com.baomidou.mybatisplus.annotation.TableId;
|
import com.baomidou.mybatisplus.annotation.TableName;
|
import lombok.Data;
|
import com.fasterxml.jackson.annotation.JsonFormat;
|
import java.util.Date;
|
import java.math.BigDecimal;
|
/**
|
* 电表设备信息Model定义
|
* @author doumee
|
* @date 2026-05-21 11:10:04
|
*/
|
@Data
|
@TableName("yw_electrical")
|
@ApiModel(value = "电表设备信息实体类")
|
public class YwElectrical extends LoginUserModel {
|
|
@ApiModelProperty("主键")
|
@ExcelColumn(name="主键",index=1 ,width=10)
|
@TableId(type = IdType.AUTO)
|
private Integer id;
|
@ApiModelProperty("创建人编码")
|
@ExcelColumn(name="创建人编码",index=2 ,width=10)
|
private Integer creator;
|
@ApiModelProperty("创建时间")
|
@ExcelColumn(name="创建时间",index=3 ,width=10)
|
private Date createDate;
|
@ApiModelProperty("更新人编码")
|
@ExcelColumn(name="更新人编码",index=4 ,width=10)
|
private Integer edirot;
|
@ApiModelProperty("更新时间")
|
@ExcelColumn(name="更新时间",index=5 ,width=10)
|
private Date editDate;
|
@ApiModelProperty("是否删除0否 1是")
|
@ExcelColumn(name="是否删除0否 1是",index=6 ,width=10)
|
private Integer isdeleted;
|
@ApiModelProperty("备注")
|
@ExcelColumn(name="备注",index=7 ,width=10)
|
private String remark;
|
@ApiModelProperty("采集器号")
|
@ExcelColumn(name="采集器号",index=8 ,width=10)
|
private String collectorId;
|
@ApiModelProperty("表号")
|
@ExcelColumn(name="表号",index=9 ,width=10)
|
private String code;
|
@ApiModelProperty("表地址(通讯地址)")
|
@ExcelColumn(name="表地址(通讯地址)",index=10 ,width=10)
|
private String address;
|
@ApiModelProperty("设备类型 0 表示电表 ， 1 表示水表")
|
@ExcelColumn(name="设备类型 0 表示电表 ， 1 表示水表",index=11 ,width=10)
|
private String deviceType;
|
@ApiModelProperty("倍率")
|
@ExcelColumn(name="倍率",index=12 ,width=10)
|
private BigDecimal rate;
|
@ApiModelProperty("付费类型")
|
@ExcelColumn(name="付费类型",index=13 ,width=10)
|
private Integer payType;
|
@ApiModelProperty("名称")
|
@ExcelColumn(name="名称",index=14 ,width=10)
|
private String name;
|
@ApiModelProperty("网关主键")
|
@ExcelColumn(name="网关主键",index=15 ,width=10)
|
private Integer gatewayId;
|
@ApiModelProperty("网关通信端口")
|
@ExcelColumn(name="网关通信端口",index=16 ,width=10)
|
private String gatewayPort;
|
@ApiModelProperty("上次心跳时间")
|
@ExcelColumn(name="上次心跳时间",index=17 ,width=10)
|
private Date lastHeartbeatDate;
|
@ApiModelProperty("电表余额（元）")
|
@ExcelColumn(name="电表余额（元）",index=18 ,width=10)
|
private BigDecimal balance;
|
@ApiModelProperty("继电器状态：0=拉闸；1=合闸；2=其他")
|
@ExcelColumn(name="继电器状态：0=拉闸；1=合闸；2=其他",index=19 ,width=10)
|
private String relayStatus;
|
@ApiModelProperty("上次开户时间")
|
@ExcelColumn(name="上次开户时间",index=20 ,width=10)
|
private Date lastOpenDate;
|
@ApiModelProperty("上次清零时间")
|
@ExcelColumn(name="上次清零时间",index=21 ,width=10)
|
private Date lastCleanDate;
|
@ApiModelProperty("在线状态：0=离线 1=在线")
|
@ExcelColumn(name="在线状态：0=离线 1=在线",index=22 ,width=10)
|
private Integer online;
|
@ApiModelProperty("是否开户：0=未开户；1=已开户")
|
@ExcelColumn(name="是否开户：0=未开户；1=已开户",index=23 ,width=10)
|
private Integer accountStatus;
|
@ApiModelProperty("状态：0=正常；1=禁用")
|
@ExcelColumn(name="状态：0=正常；1=禁用",index=24 ,width=10)
|
private Integer status;
|
@ApiModelProperty("预警状况编码")
|
@ExcelColumn(name="预警状况编码",index=25 ,width=10)
|
private String warnType;
|
@ApiModelProperty("设备型号")
|
@ExcelColumn(name="设备型号",index=26 ,width=10)
|
private String type;
|
@ApiModelProperty("设备档案ID")
|
@ExcelColumn(name="设备档案ID",index=27 ,width=10)
|
private String dId;
|
@ApiModelProperty("采集器档案ID")
|
@ExcelColumn(name="采集器档案ID",index=28 ,width=10)
|
private String cId;
|
@ApiModelProperty("备注")
|
@ExcelColumn(name="备注",index=29 ,width=10)
|
private String description;
|
@ApiModelProperty("信号值,1-31 。 20以上算信号稳定")
|
@ExcelColumn(name="信号值,1-31 。 20以上算信号稳定",index=30 ,width=10)
|
private BigDecimal csq;
|
@ApiModelProperty("上次掉线时间 online = false 时存在")
|
@ExcelColumn(name="上次掉线时间 online = false 时存在",index=31 ,width=10)
|
private Date disconnectTime;
|
@ApiModelProperty("上次上线时间 online = true 时存在")
|
@ExcelColumn(name="上次上线时间 online = true 时存在",index=32 ,width=10)
|
private Date connectTime;
|
@ApiModelProperty("当前剩余总电量（KW）")
|
@ExcelColumn(name="当前剩余总电量（KW）",index=33 ,width=10)
|
private String balanceBattery;
|
@ApiModelProperty("最近抄表时间")
|
@ExcelColumn(name="最近抄表时间",index=34 ,width=10)
|
private Date balanceTime;
|
@ApiModelProperty("户号 关联用户档案ID")
|
@ExcelColumn(name="户号 关联用户档案ID",index=35 ,width=10)
|
private String accountId;
|
@ApiModelProperty("关联价格档案ID priceid和param_id 每块表只会用其中一种")
|
@ExcelColumn(name="关联价格档案ID priceid和param_id 每块表只会用其中一种",index=37 ,width=10)
|
private String priceid;
|
@ApiModelProperty("关联参数档案ID priceid和param_id 每块表只会用其中一种")
|
@ExcelColumn(name="关联参数档案ID priceid和param_id 每块表只会用其中一种",index=36 ,width=10)
|
private String paramId;
|
@ApiModelProperty("电表参数ID（关联 yw_electrical_param.id）")
|
private Integer electricalParamId;
|
@ApiModelProperty("绑定房间名称（关联yw_electrical_room、yw_room）")
|
@TableField(exist = false)
|
private String roomNames;
|
|
@TableField(exist = false)
|
private String paramName;
|
|
@TableField(exist = false)
|
private String warnTypeName;
|
|
@TableField(exist = false)
|
private String meterKeyword;
|
}
|
