package com.jeesite.modules.mes.entity;

import javax.validation.constraints.Size;
import java.util.Date;
import com.jeesite.common.mybatis.annotation.JoinTable;
import com.jeesite.common.mybatis.annotation.JoinTable.Type;
import com.fasterxml.jackson.annotation.JsonFormat;

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;

/**
 * 工位生产时间Entity
 * @author hzd
 * @version 2023-08-22
 */
@Table(name="mes_device_time", alias="a", label="工位生产时间信息", columns={
		@Column(name="id", attrName="id", label="id", isPK=true),
		@Column(name="oprno", attrName="oprno", label="工序号", queryType=QueryType.LIKE),
		@Column(name="sn", attrName="sn", label="产品二维码", queryType=QueryType.LIKE),
		@Column(name="start_date", attrName="startDate", label="开始时间", isUpdateForce=true),
		@Column(name="end_date", attrName="endDate", label="结束时间", isUpdateForce=true),
		@Column(name="interval", attrName="interval", label="生产时间", comment="生产时间（秒）", isQuery=false, isUpdateForce=true),
		@Column(name="create_date", attrName="createDate", label="create_date", isUpdate=false, isQuery=false, isUpdateForce=true),
		@Column(name="update_date", attrName="updateDate", label="update_date", isQuery=false, isUpdateForce=true),
		@Column(name="scheduled_date", attrName="scheduledDate", label="预计完成时间", queryType=QueryType.LIKE),
		@Column(name="transfer", attrName="transfer", label="转移状态", queryType=QueryType.LIKE),
		@Column(name="product_cate", attrName="productCate", label="产品类型", queryType=QueryType.LIKE),

	}, orderBy="a.update_date DESC"
)
public class MesDeviceTime extends DataEntity<MesDeviceTime> {
	
	private static final long serialVersionUID = 1L;
	private String oprno;		// 工序号
	private String sn;		// 产品二维码
	private Date startDate;		// 开始时间
	private Date endDate;		// 结束时间
	private Integer interval;		// 生产时间（秒）
	private Date scheduledDate;
	private Integer transfer;
	private String productCate;

	@ExcelFields({
			@ExcelField(title="产线编号", attrName="productCate", align= ExcelField.Align.CENTER, sort=10),
			@ExcelField(title="工序号", attrName="oprno", align= ExcelField.Align.CENTER, sort=20),
			@ExcelField(title="工件码", attrName="sn",align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="开始时间", attrName="startDate", align= ExcelField.Align.CENTER, sort=40, dataFormat="yyyy-MM-dd hh:mm:ss"),
			@ExcelField(title="结束时间", attrName="endDate", align= ExcelField.Align.CENTER, sort=50, dataFormat="yyyy-MM-dd hh:mm:ss"),
			@ExcelField(title="生产时长（秒）", attrName="interval", align= ExcelField.Align.CENTER, sort=60),
			@ExcelField(title="更新时间", attrName="updateDate", align= ExcelField.Align.CENTER, sort=150, dataFormat="yyyy-MM-dd hh:mm:ss"),
	})

	public MesDeviceTime() {
		this(null);
	}
	
	public MesDeviceTime(String id){
		super(id);
	}
	
	@Size(min=0, max=50, message="工序号长度不能超过 50 个字符")
	public String getOprno() {
		return oprno;
	}

	public void setOprno(String oprno) {
		this.oprno = oprno;
	}
	
	@Size(min=0, max=50, message="产品二维码长度不能超过 50 个字符")
	public String getSn() {
		return sn;
	}

	public void setSn(String sn) {
		this.sn = sn;
	}
	
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	public Date getStartDate() {
		return startDate;
	}

	public void setStartDate(Date startDate) {
		this.startDate = startDate;
	}
	
	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	public Date getEndDate() {
		return endDate;
	}

	public void setEndDate(Date endDate) {
		this.endDate = endDate;
	}
	
	public Integer getInterval() {
		return interval;
	}

	public void setInterval(Integer interval) {
		this.interval = interval;
	}
	
	public Date getStartDate_gte() {
		return sqlMap.getWhere().getValue("start_date", QueryType.GTE);
	}

	public void setStartDate_gte(Date startDate) {
		sqlMap.getWhere().and("start_date", QueryType.GTE, startDate);
	}
	
	public Date getStartDate_lte() {
		return sqlMap.getWhere().getValue("start_date", QueryType.LTE);
	}

	public void setStartDate_lte(Date startDate) {
		sqlMap.getWhere().and("start_date", QueryType.LTE, startDate);
	}
	
	public Date getEndDate_gte() {
		return sqlMap.getWhere().getValue("end_date", QueryType.GTE);
	}

	public void setEndDate_gte(Date endDate) {
		sqlMap.getWhere().and("end_date", QueryType.GTE, endDate);
	}
	
	public Date getEndDate_lte() {
		return sqlMap.getWhere().getValue("end_date", QueryType.LTE);
	}

	public void setEndDate_lte(Date endDate) {
		sqlMap.getWhere().and("end_date", QueryType.LTE, endDate);
	}

	public Date getScheduledDate() {
		return scheduledDate;
	}

	public void setScheduledDate(Date scheduledDate) {
		this.scheduledDate = scheduledDate;
	}

	public Integer getTransfer() {
		return transfer;
	}

	public void setTransfer(Integer transfer) {
		this.transfer = transfer;
	}

	public String getProductCate() {
		return productCate;
	}

	public void setProductCate(String productCate) {
		this.productCate = productCate;
	}
}