package com.jeesite.modules.wms.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.JoinTable;
import com.jeesite.common.mybatis.annotation.Table;
import com.jeesite.common.mybatis.mapper.query.QueryType;
import com.jeesite.modules.mes.entity.MesLine;
import com.jeesite.modules.mes.entity.MesShift;
import com.jeesite.modules.mes.entity.MesProductOrder;
import com.jeesite.modules.sys.entity.User;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * 物料领料单Entity
 * @author hzd
 * @version 2026-03-15
 */
@Table(name="wms_pick", alias="a", label="物料领料单信息", columns={
		@Column(name="id", attrName="id", label="id", isPK=true),
		@Column(name="sn", attrName="sn", label="领料单号", queryType=QueryType.LIKE),
		@Column(name="order_id", attrName="orderId", label="生产订单"),
		@Column(name="plan_id", attrName="planId", label="生产计划"),
		@Column(name="state", attrName="state", label="状态"),
		@Column(name="remark", attrName="remark", label="备注"),
		@Column(name="cate", attrName="cate", label="类型"),
		@Column(name="status", attrName="status", label="状态", comment="状态（0正常 1删除 2停用）", isUpdate=false, isQuery=false),
		@Column(name="create_by", attrName="createBy", label="创建者", isUpdate=false, isQuery=false),
		@Column(name="create_date", attrName="createDate", label="创建时间", isUpdate=false, isQuery=false),
		@Column(name="update_by", attrName="updateBy", label="更新者", isQuery=false),
		@Column(name="update_date", attrName="updateDate", label="更新时间"),
	}, joinTable={
		@JoinTable(type=JoinTable.Type.LEFT_JOIN, entity=User.class, attrName="creator", alias="u",
			on="u.user_code = a.create_by", columns={
				@Column(name="user_name", attrName="createByName", label="创建者", isQuery=false)
		})
	}, orderBy="a.update_date DESC"
)
public class WmsPick extends DataEntity<WmsPick> {
	
	private static final long serialVersionUID = 1L;
	private String sn;		// 领料单号
	private String planId;		// 生产计划
	private String orderId;		// 生产订单
	private String state;		// 状态
	private String remark;		// 备注
	private String cate;
	private String day;
	private String shiftTitle;
	private String orderSn;
	private Integer orderNums;
	private java.util.Date orderDeliveryDate;
	private String createByName;
	private List imgList = new ArrayList<>();
	private List<WmsPickMaterial> materialList = new ArrayList<>();

	public WmsPick() {
		this(null);
	}
	
	public WmsPick(String id){
		super(id);
	}
	
	@Size(min=0, max=255, message="领料单号长度不能超过 255 个字符")
	public String getSn() {
		return sn;
	}

	public void setSn(String sn) {
		this.sn = sn;
	}
	
	@Size(min=0, max=64, message="生产计划长度不能超过 64 个字符")
	public String getPlanId() {
		return planId;
	}

	public void setPlanId(String planId) {
		this.planId = planId;
	}
	public String getOrderId() { return orderId; }
	public void setOrderId(String orderId) { this.orderId = orderId; }
	
	@Size(min=0, max=255, message="状态长度不能超过 255 个字符")
	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 getUpdateDate_gte() {
		return sqlMap.getWhere().getValue("update_date", QueryType.GTE);
	}

	public void setUpdateDate_gte(Date updateDate) {
		sqlMap.getWhere().and("update_date", QueryType.GTE, updateDate);
	}
	
	public Date getUpdateDate_lte() {
		return sqlMap.getWhere().getValue("update_date", QueryType.LTE);
	}

	public void setUpdateDate_lte(Date updateDate) {
		sqlMap.getWhere().and("update_date", QueryType.LTE, updateDate);
	}

	public String getDay() {
		return day;
	}

	public void setDay(String day) {
		this.day = day;
	}

	public String getShiftTitle() {
		return shiftTitle;
	}

	public void setShiftTitle(String shiftTitle) {
		this.shiftTitle = shiftTitle;
	}
	public String getOrderSn() { return orderSn; }
	public void setOrderSn(String orderSn) { this.orderSn = orderSn; }
	public Integer getOrderNums() { return orderNums; }
	public void setOrderNums(Integer orderNums) { this.orderNums = orderNums; }
	public java.util.Date getOrderDeliveryDate() { return orderDeliveryDate; }
	public void setOrderDeliveryDate(java.util.Date value) { orderDeliveryDate = value; }
	public String getCreateByName() { return createByName; }
	public void setCreateByName(String value) { createByName = value; }

	public List getImgList() {
		return imgList;
	}

	public void setImgList(List imgList) {
		this.imgList = imgList;
	}

	public List<WmsPickMaterial> getMaterialList() {
		return materialList;
	}

	public void setMaterialList(List<WmsPickMaterial> materialList) {
		this.materialList = materialList;
	}

	public String getCate() {
		return cate;
	}

	public void setCate(String cate) {
		this.cate = cate;
	}
}