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 java.util.ArrayList;
import java.util.List;

/**
 * 入库表Entity
 * @author hxf
 * @version 2026-03-14
 */
@Table(name="wms_house_in", alias="a", label="入库表信息", columns={
		@Column(name="id", attrName="id", label="id", isPK=true),
		@Column(name="sn", attrName="sn", label="入库单号"),
		@Column(name="check_id", attrName="checkId", label="来料检查单"),
		@Column(name="batch_sn", attrName="batchSn", label="物料批次号"),
		@Column(name="nums", attrName="nums", label="入库数量"),
		@Column(name="house_id", attrName="houseId", label="仓库"),
		@Column(name="house_location_id", attrName="houseLocationId", label="库位"),
		@Column(name="remark", attrName="remark", label="备注"),
		@Column(name="status", attrName="status", label="状态", comment="状态（0正常 1删除 2停用）", isUpdate=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="更新时间", isQuery=false),
	},joinTable={
		@JoinTable(type= JoinTable.Type.LEFT_JOIN, entity= WmsHouse.class, attrName="this", alias="b",
				on="b.id = a.house_id",
				columns={
						@Column(name="title", attrName="houseName", label="仓库名称", queryType=QueryType.LIKE),
				}),
		@JoinTable(type= JoinTable.Type.LEFT_JOIN, entity= WmsHouseLocation.class, attrName="this", alias="c",
				on="c.id = a.house_location_id",
				columns={
						@Column(name="title", attrName="houseLocationName", label="库位名称", queryType=QueryType.LIKE),
				}),
		@JoinTable(type= JoinTable.Type.LEFT_JOIN, entity= WmsCheck.class, attrName="this", alias="d",
				on="d.id = a.check_id",
				columns={
						@Column(name="material_id", attrName="materialId", label="库位名称", queryType=QueryType.LIKE),
				}),
		@JoinTable(type= JoinTable.Type.LEFT_JOIN, entity= WmsMaterial.class, attrName="this", alias="e",
				on="e.id = d.material_id",
				columns={
						@Column(name="title", attrName="materialTitle", label="库位名称", queryType=QueryType.LIKE),
				}),
	}, orderBy="a.update_date DESC"
)
public class WmsHouseIn extends DataEntity<WmsHouseIn> {
	
	private static final long serialVersionUID = 1L;
	private String sn;		// 入库单号
	private String checkId;		// 来料检查单
	private String batchSn;		// 物料批次号
	private String nums;		// 入库数量
	private String houseId;		// 仓库
	private String houseLocationId;		// 库位
	private String remark;		// 备注
	private List imgList = new ArrayList<>();
	private String houseName;
	private String houseLocationName;
	private String materialId;
	private String materialTitle;


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

	public void setSn(String sn) {
		this.sn = sn;
	}
	
	@Size(min=0, max=64, message="来料检查单长度不能超过 64 个字符")
	public String getCheckId() {
		return checkId;
	}

	public void setCheckId(String checkId) {
		this.checkId = checkId;
	}
	
	@Size(min=0, max=64, message="物料批次号长度不能超过 64 个字符")
	public String getBatchSn() {
		return batchSn;
	}

	public void setBatchSn(String batchSn) {
		this.batchSn = batchSn;
	}
	
	@Size(min=0, max=255, message="入库数量长度不能超过 255 个字符")
	public String getNums() {
		return nums;
	}

	public void setNums(String nums) {
		this.nums = nums;
	}
	
	@Size(min=0, max=64, message="仓库长度不能超过 64 个字符")
	public String getHouseId() {
		return houseId;
	}

	public void setHouseId(String houseId) {
		this.houseId = houseId;
	}
	
	@Size(min=0, max=64, message="库位长度不能超过 64 个字符")
	public String getHouseLocationId() {
		return houseLocationId;
	}

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

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

	public List getImgList() {
		return imgList;
	}

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

	public String getHouseName() {
		return houseName;
	}

	public void setHouseName(String houseName) {
		this.houseName = houseName;
	}

	public String getHouseLocationName() {
		return houseLocationName;
	}

	public void setHouseLocationName(String houseLocationName) {
		this.houseLocationName = houseLocationName;
	}

	public String getMaterialId() {
		return materialId;
	}

	public void setMaterialId(String materialId) {
		this.materialId = materialId;
	}

	public String getMaterialTitle() {
		return materialTitle;
	}

	public void setMaterialTitle(String materialTitle) {
		this.materialTitle = materialTitle;
	}
}