package com.jeesite.modules.mes.entity;

import com.jeesite.common.entity.DataEntity;
import com.jeesite.common.mybatis.annotation.Column;
import com.jeesite.common.mybatis.annotation.Table;
import com.jeesite.common.mybatis.mapper.query.QueryType;
import com.jeesite.common.utils.excel.annotation.ExcelField;
import com.jeesite.common.utils.excel.annotation.ExcelFields;

import javax.validation.constraints.NotBlank;
import javax.validation.constraints.Size;
import java.util.Date;

/**
 * 设备报警记录Entity
 * @author hzd
 * @version 2023-06-25
 */
@Table(name="mes_device_alarm", alias="a", label="设备报警记录信息", columns={
		@Column(name="id", attrName="id", label="id", isPK=true),
		@Column(name="device_sn", attrName="deviceSn", label="设备编号"),
		@Column(name="type", attrName="type", label="报警类型"),
		@Column(name="content", attrName="content", label="报警额外参数", isQuery=false),
		@Column(name="state", attrName="state", label="状态"),
		@Column(name="remark", attrName="remark", label="备注"),
		@Column(name="create_by", attrName="createBy", label="create_by", isUpdate=false, isQuery=false),
		@Column(name="create_date", attrName="createDate", label="创建时间", isUpdate=false, isUpdateForce=true),
		@Column(name="update_by", attrName="updateBy", label="update_by", isQuery=false),
		@Column(name="update_date", attrName="updateDate", label="处理时间", isQuery=false, isUpdateForce=true),
	}, orderBy="a.update_date DESC"
)
public class MesDeviceAlarm extends DataEntity<MesDeviceAlarm> {
	
	private static final long serialVersionUID = 1L;
	private String deviceSn;		// 设备编号
	private String type;		// 报警类型
	private String content;		// 报警额外参数
	private String state;		// 状态
	private String remark;		// 备注
	@ExcelFields({
			@ExcelField(title="设备编号", attrName="deviceSn", align= ExcelField.Align.CENTER, sort=20),
			@ExcelField(title="报警类型", attrName="type", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="报警额外参数", attrName="content",align= ExcelField.Align.CENTER, sort=40),
			@ExcelField(title="状态", attrName="state",dictType = "mes_device_alarm_state",align= ExcelField.Align.CENTER, sort=40),
			@ExcelField(title="备注", attrName="remark",align= ExcelField.Align.CENTER, sort=40),
	})

	public MesDeviceAlarm() {
		this(null);
	}
	
	public MesDeviceAlarm(String id){
		super(id);
	}
	
	@NotBlank(message="设备编号不能为空")
	@Size(min=0, max=100, message="设备编号长度不能超过 100 个字符")
	public String getDeviceSn() {
		return deviceSn;
	}

	public void setDeviceSn(String deviceSn) {
		this.deviceSn = deviceSn;
	}
	
	@NotBlank(message="报警类型不能为空")
	@Size(min=0, max=100, message="报警类型长度不能超过 100 个字符")
	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}
	
	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}
	
	@Size(min=0, max=1, message="状态长度不能超过 1 个字符")
	public String getState() {
		return state;
	}

	public void setState(String state) {
		this.state = state;
	}
	
	@Size(min=0, max=255, message="备注长度不能超过 255 个字符")
	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}
	
	public Date getCreateDate_gte() {
		return sqlMap.getWhere().getValue("create_date", QueryType.GTE);
	}

	public void setCreateDate_gte(Date createDate) {
		sqlMap.getWhere().and("create_date", QueryType.GTE, createDate);
	}
	
	public Date getCreateDate_lte() {
		return sqlMap.getWhere().getValue("create_date", QueryType.LTE);
	}

	public void setCreateDate_lte(Date createDate) {
		sqlMap.getWhere().and("create_date", QueryType.LTE, createDate);
	}
	
}