package com.jeesite.modules.mes.entity;

import javax.validation.constraints.Size;

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 mes
 * @version 2024-03-29
 */
@Table(name="mes_material", alias="a", label="物料表信息", columns={
		@Column(name="id", attrName="id", label="id", isPK=true),
		@Column(name="title", attrName="title", label="部件名称", queryType=QueryType.LIKE),
		@Column(name="spec", attrName="spec", label="部件规格"),
		@Column(name="erp_sn", attrName="erpSn", label="ERP编码"),
		@Column(name="unit", attrName="unit", label="单位"),
		@Column(name="house", attrName="house", label="仓库"),
		@Column(name="location", attrName="location", label="库位"),
		@Column(name="img_sn", attrName="imgSn", label="内部图号"),
		@Column(name="nums", attrName="nums", label="数量/套", isQuery=false, isUpdateForce=true),
		@Column(name="attr", attrName="attr", label="加工属性"),
		@Column(name="supplier", attrName="supplier", label="供应商"),
		@Column(name="aging", attrName="aging", label="有效期", comment="有效期（单位：月） 0=无有效期", isUpdateForce=true),
		@Column(name="type", attrName="type", label="追溯类型"),
		@Column(name="remark", attrName="remark", label="备注", isQuery=false),
		@Column(name="status", attrName="status", label="状态", 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),
	}, orderBy="a.update_date DESC"
)
public class MesMaterial extends DataEntity<MesMaterial> {

	private static final long serialVersionUID = 1L;
	private String title;		// 部件名称
	private String spec;		// 部件规格
	private String erpSn;		// ERP编码
	private String unit;  //单位
	private String house;  //仓库
	private String location;  //库位
	private String imgSn;		// 内部图号
	private Integer nums;		// 数量/套
	private String num;
	private String attr;		// 加工属性
	private String supplier;		// 供应商
	private Integer aging;		// 有效期（单位：月） 0=无有效期
	private String type;		// 追溯类型
	private String remark;		// 备注


	@ExcelFields({
			@ExcelField(title="部件名称", attrName="title", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="部件规格", attrName="spec", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="ERP编码", attrName="erpSn", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="单位", attrName="unit", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="仓库", attrName="house", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="库位", attrName="location", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="内部图号", attrName="imgSn", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="数量/套", attrName="nums", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="加工属性", attrName="attr", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="供应商", attrName="supplier", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="有效期", attrName="aging", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="追溯类型", attrName="type",dictType="mes_material_type", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="备注", attrName="remark", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="创建人", attrName="createBy", align= ExcelField.Align.CENTER, sort=30),
			@ExcelField(title="创建时间", attrName="createDate", align= ExcelField.Align.CENTER, sort=30, dataFormat="yyyy-MM-dd hh:mm:ss"),
	})

	public MesMaterial() {
		this(null);
	}

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

	@Size(min=0, max=255, message="部件名称长度不能超过 255 个字符")
	public String getTitle() {
		return title;
	}

	public void setTitle(String title) {
		this.title = title;
	}

	@Size(min=0, max=255, message="部件规格长度不能超过 255 个字符")
	public String getSpec() {
		return spec;
	}

	public void setSpec(String spec) {
		this.spec = spec;
	}

	@Size(min=0, max=64, message="ERP编码长度不能超过 64 个字符")
	public String getErpSn() {
		return erpSn;
	}

	public void setErpSn(String erpSn) {
		this.erpSn = erpSn;
	}

	public String getUnit() {
		return unit;
	}

	public void setUnit(String unit) {
		this.unit = unit;
	}

	public String getHouse() {
		return house;
	}

	public void setHouse(String house) {
		this.house = house;
	}

	public String getLocation() {
		return location;
	}

	public void setLocation(String location) {
		this.location = location;
	}

	@Size(min=0, max=255, message="内部图号长度不能超过 255 个字符")
	public String getImgSn() {
		return imgSn;
	}

	public void setImgSn(String imgSn) {
		this.imgSn = imgSn;
	}

	public Integer getNums() {
		return nums;
	}

	public void setNums(Integer nums) {
		this.nums = nums;
	}

	@Size(min=0, max=255, message="加工属性长度不能超过 255 个字符")
	public String getAttr() {
		return attr;
	}

	public void setAttr(String attr) {
		this.attr = attr;
	}

	@Size(min=0, max=255, message="供应商长度不能超过 255 个字符")
	public String getSupplier() {
		return supplier;
	}

	public void setSupplier(String supplier) {
		this.supplier = supplier;
	}

	public Integer getAging() {
		return aging;
	}

	public void setAging(Integer aging) {
		this.aging = aging;
	}

	@Size(min=0, max=1, message="追溯类型长度不能超过 1 个字符")
	public String getType() {
		return type;
	}

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

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

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public String getNum() {
		return num;
	}

	public void setNum(String num) {
		this.num = num;
	}
}