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 javax.validation.constraints.NotBlank;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import java.math.BigDecimal;

/**
 * ERP排产计划Entity
 */
@Table(name = "mes_erp_schedule", alias = "a", label = "ERP排产计划信息", columns = {
		@Column(name = "id", attrName = "id", label = "编号", isPK = true),
		@Column(name = "erp_bill_no", attrName = "erpBillNo", label = "ERP生产订单号", queryType = QueryType.LIKE),
		@Column(name = "erp_entry_id", attrName = "erpEntryId", label = "ERP分录内码"),
		@Column(name = "erp_seq", attrName = "erpSeq", label = "ERP行号"),
		@Column(name = "material_number", attrName = "materialNumber", label = "物料编码", queryType = QueryType.LIKE),
		@Column(name = "material_name", attrName = "materialName", label = "物料名称", queryType = QueryType.LIKE),
		@Column(name = "inventory_category", attrName = "inventoryCategory", label = "存货类别", queryType = QueryType.EQ),
		@Column(name = "workshop_name", attrName = "workshopName", label = "生产车间", queryType = QueryType.LIKE),
		@Column(name = "order_qty", attrName = "orderQty", label = "ERP订单数量"),
		@Column(name = "erp_plan_start_date", attrName = "erpPlanStartDate", label = "ERP计划开工"),
		@Column(name = "erp_plan_finish_date", attrName = "erpPlanFinishDate", label = "ERP计划完工"),
		@Column(name = "line_id", attrName = "lineId", label = "产线"),
		@Column(name = "line_sn", attrName = "lineSn", label = "产线编号", queryType = QueryType.EQ),
		@Column(name = "line_title", attrName = "lineTitle", label = "产线名称", queryType = QueryType.LIKE),
		@Column(name = "schedule_start_date", attrName = "scheduleStartDate", label = "排产开始日期", queryType = QueryType.GTE),
		@Column(name = "schedule_end_date", attrName = "scheduleEndDate", label = "排产结束日期", queryType = QueryType.LTE),
		@Column(name = "schedule_qty", attrName = "scheduleQty", label = "排产工件数量"),
		@Column(name = "status", attrName = "status", label = "状态", comment = "状态（0正常 1删除 2停用）", isUpdate = false),
		@Column(name = "create_by", attrName = "createBy", label = "create_by", isUpdate = false, isQuery = false),
		@Column(name = "create_date", attrName = "createDate", label = "create_date", isUpdate = false, isQuery = false, isUpdateForce = true),
		@Column(name = "update_by", attrName = "updateBy", label = "update_by", isQuery = false),
		@Column(name = "update_date", attrName = "updateDate", label = "update_date", isQuery = false, isUpdateForce = true),
		@Column(name = "remarks", attrName = "remarks", label = "备注", queryType = QueryType.LIKE),
}, orderBy = "a.schedule_start_date DESC, a.update_date DESC")
public class MesErpSchedule extends DataEntity<MesErpSchedule> {

	private static final long serialVersionUID = 1L;

	private String erpBillNo;
	private String erpEntryId;
	private String erpSeq;
	private String materialNumber;
	private String materialName;
	private String inventoryCategory;
	private String workshopName;
	private BigDecimal orderQty;
	private String erpPlanStartDate;
	private String erpPlanFinishDate;
	private String lineId;
	private String lineSn;
	private String lineTitle;
	private String scheduleStartDate;
	private String scheduleEndDate;
	private Integer scheduleQty;
	/** 已排产数量（查询辅助，非表字段） */
	private Integer scheduledQtySum;
	/** 剩余可排产数量（查询辅助，非表字段） */
	private Integer remainQty;

	public MesErpSchedule() {
		this(null);
	}

	public MesErpSchedule(String id) {
		super(id);
	}

	@NotBlank(message = "ERP生产订单号不能为空")
	@Size(max = 100, message = "ERP生产订单号长度不能超过100个字符")
	public String getErpBillNo() {
		return erpBillNo;
	}

	public void setErpBillNo(String erpBillNo) {
		this.erpBillNo = erpBillNo;
	}

	@Size(max = 64, message = "ERP分录内码长度不能超过64个字符")
	public String getErpEntryId() {
		return erpEntryId;
	}

	public void setErpEntryId(String erpEntryId) {
		this.erpEntryId = erpEntryId;
	}

	public String getErpSeq() {
		return erpSeq;
	}

	public void setErpSeq(String erpSeq) {
		this.erpSeq = erpSeq;
	}

	public String getMaterialNumber() {
		return materialNumber;
	}

	public void setMaterialNumber(String materialNumber) {
		this.materialNumber = materialNumber;
	}

	public String getMaterialName() {
		return materialName;
	}

	public void setMaterialName(String materialName) {
		this.materialName = materialName;
	}

	public String getInventoryCategory() {
		return inventoryCategory;
	}

	public void setInventoryCategory(String inventoryCategory) {
		this.inventoryCategory = inventoryCategory;
	}

	public String getWorkshopName() {
		return workshopName;
	}

	public void setWorkshopName(String workshopName) {
		this.workshopName = workshopName;
	}

	public BigDecimal getOrderQty() {
		return orderQty;
	}

	public void setOrderQty(BigDecimal orderQty) {
		this.orderQty = orderQty;
	}

	public String getErpPlanStartDate() {
		return erpPlanStartDate;
	}

	public void setErpPlanStartDate(String erpPlanStartDate) {
		this.erpPlanStartDate = erpPlanStartDate;
	}

	public String getErpPlanFinishDate() {
		return erpPlanFinishDate;
	}

	public void setErpPlanFinishDate(String erpPlanFinishDate) {
		this.erpPlanFinishDate = erpPlanFinishDate;
	}

	@NotBlank(message = "产线不能为空")
	@Size(max = 64, message = "产线长度不能超过64个字符")
	public String getLineId() {
		return lineId;
	}

	public void setLineId(String lineId) {
		this.lineId = lineId;
	}

	public String getLineSn() {
		return lineSn;
	}

	public void setLineSn(String lineSn) {
		this.lineSn = lineSn;
	}

	public String getLineTitle() {
		return lineTitle;
	}

	public void setLineTitle(String lineTitle) {
		this.lineTitle = lineTitle;
	}

	@NotBlank(message = "排产开始日期不能为空")
	public String getScheduleStartDate() {
		return scheduleStartDate;
	}

	public void setScheduleStartDate(String scheduleStartDate) {
		this.scheduleStartDate = scheduleStartDate;
	}

	@NotBlank(message = "排产结束日期不能为空")
	public String getScheduleEndDate() {
		return scheduleEndDate;
	}

	public void setScheduleEndDate(String scheduleEndDate) {
		this.scheduleEndDate = scheduleEndDate;
	}

	@NotNull(message = "排产工件数量不能为空")
	public Integer getScheduleQty() {
		return scheduleQty;
	}

	public void setScheduleQty(Integer scheduleQty) {
		this.scheduleQty = scheduleQty;
	}

	public Integer getScheduledQtySum() {
		return scheduledQtySum;
	}

	public void setScheduledQtySum(Integer scheduledQtySum) {
		this.scheduledQtySum = scheduledQtySum;
	}

	public Integer getRemainQty() {
		return remainQty;
	}

	public void setRemainQty(Integer remainQty) {
		this.remainQty = remainQty;
	}
}