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.utils.excel.annotation.ExcelField;
import com.jeesite.common.utils.excel.annotation.ExcelField.Align;
import com.jeesite.common.utils.excel.annotation.ExcelFields;

/**
 * 生产领料单Entity
 * @author sxl
 * @version 2026-06-30
 */
@Table(name="mes_material_ll", alias="a", label="生产领料单信息", columns={
		@Column(name="id", attrName="id", label="id", isPK=true),
		@Column(name="other_id", attrName="otherId", label="第三方数据标识"),
		@Column(name="business_date", attrName="businessDate", label="单据日期", isUpdateForce=true),
		@Column(name="mo_doc_no", attrName="moDocNo", label="生产订单号"),
		@Column(name="dept_code", attrName="deptCode", label="领料部门"),
		@Column(name="employee_code", attrName="employeeCode", label="领料人员"),
		@Column(name="is_no_pick_line", attrName="isNoPickLine", label="是否无备料领料，如果有备料就为false，无备料就为true"),
		@Column(name="wh_code", attrName="whCode", label="存储地点"),
		@Column(name="bin_code", attrName="binCode", label="库位"),
		@Column(name="item_code", attrName="itemCode", label="料品编码"),
		@Column(name="lot_code", attrName="lotCode", label="批号编码"),
		@Column(name="project_code", attrName="projectCode", label="项目号"),
		@Column(name="issued_qty", attrName="issuedQty", label="领料数量", isUpdateForce=true),
		@Column(name="issue_doc_no", attrName="issueDocNo", label="生产领料单号"),
		@Column(name="mopick_list", attrName="mopickList", label="生产订单备料行"),
		@Column(name="state", attrName="state", label="状态"),
		@Column(name="create_by", attrName="createBy", label="创建人", isUpdate=false, isQuery=false),
		@Column(name="create_date", attrName="createDate", label="创建时间", isUpdate=false, isQuery=false, isUpdateForce=true),
		@Column(name="update_by", attrName="updateBy", label="更新人", isQuery=false),
		@Column(name="update_date", attrName="updateDate", label="更新时间", isQuery=false, isUpdateForce=true),
	}, orderBy="a.update_date DESC"
)
public class MesMaterialLl extends DataEntity<MesMaterialLl> {

	private static final long serialVersionUID = 1L;

	@ExcelFields({
		@ExcelField(title="第三方数据标识", attrName="otherId", align=Align.CENTER, sort=10),
		@ExcelField(title="单据日期", attrName="businessDate", align=Align.CENTER, sort=20, dataFormat="yyyy-MM-dd hh:mm"),
		@ExcelField(title="生产订单号", attrName="moDocNo", align=Align.CENTER, sort=30),
		@ExcelField(title="领料部门", attrName="deptCode", align=Align.CENTER, sort=40),
		@ExcelField(title="领料人员", attrName="employeeCode", align=Align.CENTER, sort=50),
		@ExcelField(title="是否无备料领料", attrName="isNoPickLine", align=Align.CENTER, sort=60),
		@ExcelField(title="存储地点", attrName="whCode", align=Align.CENTER, sort=70),
		@ExcelField(title="库位", attrName="binCode", align=Align.CENTER, sort=80),
		@ExcelField(title="料品编码", attrName="itemCode", align=Align.CENTER, sort=90),
		@ExcelField(title="批号编码", attrName="lotCode", align=Align.CENTER, sort=100),
		@ExcelField(title="项目号", attrName="projectCode", align=Align.CENTER, sort=110),
		@ExcelField(title="领料数量", attrName="issuedQty", align=Align.CENTER, sort=120),
		@ExcelField(title="生产领料单号", attrName="issueDocNo", align=Align.CENTER, sort=130),
		@ExcelField(title="生产订单备料行", attrName="mopickList", align=Align.CENTER, sort=140),
		@ExcelField(title="状态", attrName="state", align=Align.CENTER, sort=150),
		@ExcelField(title="更新时间", attrName="updateDate", align=Align.CENTER, sort=160, dataFormat="yyyy-MM-dd hh:mm"),
	})

	private String otherId;		// 第三方数据标识
	private Date businessDate;		// 单据日期
	private String moDocNo;		// 生产订单号
	private String deptCode;		// 领料部门
	private String employeeCode;		// 领料人员
	private String isNoPickLine;		// 是否无备料领料，如果有备料就为false，无备料就为true
	private String whCode;		// 存储地点
	private String binCode;		// 库位
	private String itemCode;		// 料品编码
	private String lotCode;		// 批号编码
	private String projectCode;		// 项目号
	private Double issuedQty;		// 领料数量
	private String issueDocNo;   //生产领料单号
	private String mopickList;		// 生产订单备料行

	private String state;       //状态0=草稿 1=下发 2=完成

	public String getState() {
		return state;
	}

	public void setState(String state) {
		this.state = state;
	}

	public String getIssueDocNo() {
		return issueDocNo;
	}

	public void setIssueDocNo(String issueDocNo) {
		this.issueDocNo = issueDocNo;
	}

	public MesMaterialLl() {
		this(null);
	}

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

	@Size(min=0, max=64, message="第三方数据标识长度不能超过 64 个字符")
	public String getOtherId() {
		return otherId;
	}

	public void setOtherId(String otherId) {
		this.otherId = otherId;
	}

	@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	public Date getBusinessDate() {
		return businessDate;
	}

	public void setBusinessDate(Date businessDate) {
		this.businessDate = businessDate;
	}

	@Size(min=0, max=64, message="生产订单号长度不能超过 64 个字符")
	public String getMoDocNo() {
		return moDocNo;
	}

	public void setMoDocNo(String moDocNo) {
		this.moDocNo = moDocNo;
	}

	@Size(min=0, max=64, message="领料部门长度不能超过 64 个字符")
	public String getDeptCode() {
		return deptCode;
	}

	public void setDeptCode(String deptCode) {
		this.deptCode = deptCode;
	}

	@Size(min=0, max=64, message="领料人员长度不能超过 64 个字符")
	public String getEmployeeCode() {
		return employeeCode;
	}

	public void setEmployeeCode(String employeeCode) {
		this.employeeCode = employeeCode;
	}

	@Size(min=0, max=1, message="是否无备料领料，如果有备料就为false，无备料就为true长度不能超过 1 个字符")
	public String getIsNoPickLine() {
		return isNoPickLine;
	}

	public void setIsNoPickLine(String isNoPickLine) {
		this.isNoPickLine = isNoPickLine;
	}

	@Size(min=0, max=64, message="存储地点长度不能超过 64 个字符")
	public String getWhCode() {
		return whCode;
	}

	public void setWhCode(String whCode) {
		this.whCode = whCode;
	}

	@Size(min=0, max=64, message="库位长度不能超过 64 个字符")
	public String getBinCode() {
		return binCode;
	}

	public void setBinCode(String binCode) {
		this.binCode = binCode;
	}

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

	public void setItemCode(String itemCode) {
		this.itemCode = itemCode;
	}

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

	public void setLotCode(String lotCode) {
		this.lotCode = lotCode;
	}

	@Size(min=0, max=64, message="项目号长度不能超过 64 个字符")
	public String getProjectCode() {
		return projectCode;
	}

	public void setProjectCode(String projectCode) {
		this.projectCode = projectCode;
	}

	public Double getIssuedQty() {
		return issuedQty;
	}

	public void setIssuedQty(Double issuedQty) {
		this.issuedQty = issuedQty;
	}

	@Size(min=0, max=64, message="生产订单备料行长度不能超过 64 个字符")
	public String getMopickList() {
		return mopickList;
	}

	public void setMopickList(String mopickList) {
		this.mopickList = mopickList;
	}

}