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;
}