| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183 |
- 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;
- }
- }
|