WmsHouseIn.java 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183
  1. package com.jeesite.modules.wms.entity;
  2. import javax.validation.constraints.Size;
  3. import com.jeesite.common.entity.DataEntity;
  4. import com.jeesite.common.mybatis.annotation.Column;
  5. import com.jeesite.common.mybatis.annotation.JoinTable;
  6. import com.jeesite.common.mybatis.annotation.Table;
  7. import com.jeesite.common.mybatis.mapper.query.QueryType;
  8. import java.util.ArrayList;
  9. import java.util.List;
  10. /**
  11. * 入库表Entity
  12. * @author hxf
  13. * @version 2026-03-14
  14. */
  15. @Table(name="wms_house_in", alias="a", label="入库表信息", columns={
  16. @Column(name="id", attrName="id", label="id", isPK=true),
  17. @Column(name="sn", attrName="sn", label="入库单号"),
  18. @Column(name="check_id", attrName="checkId", label="来料检查单"),
  19. @Column(name="batch_sn", attrName="batchSn", label="物料批次号"),
  20. @Column(name="nums", attrName="nums", label="入库数量"),
  21. @Column(name="house_id", attrName="houseId", label="仓库"),
  22. @Column(name="house_location_id", attrName="houseLocationId", label="库位"),
  23. @Column(name="remark", attrName="remark", label="备注"),
  24. @Column(name="status", attrName="status", label="状态", comment="状态(0正常 1删除 2停用)", isUpdate=false),
  25. @Column(name="create_by", attrName="createBy", label="入库人", isUpdate=false, isQuery=false),
  26. @Column(name="create_date", attrName="createDate", label="入库时间", isUpdate=false, isQuery=false),
  27. @Column(name="update_by", attrName="updateBy", label="更新者", isQuery=false),
  28. @Column(name="update_date", attrName="updateDate", label="更新时间", isQuery=false),
  29. },joinTable={
  30. @JoinTable(type= JoinTable.Type.LEFT_JOIN, entity= WmsHouse.class, attrName="this", alias="b",
  31. on="b.id = a.house_id",
  32. columns={
  33. @Column(name="title", attrName="houseName", label="仓库名称", queryType=QueryType.LIKE),
  34. }),
  35. @JoinTable(type= JoinTable.Type.LEFT_JOIN, entity= WmsHouseLocation.class, attrName="this", alias="c",
  36. on="c.id = a.house_location_id",
  37. columns={
  38. @Column(name="title", attrName="houseLocationName", label="库位名称", queryType=QueryType.LIKE),
  39. }),
  40. @JoinTable(type= JoinTable.Type.LEFT_JOIN, entity= WmsCheck.class, attrName="this", alias="d",
  41. on="d.id = a.check_id",
  42. columns={
  43. @Column(name="material_id", attrName="materialId", label="库位名称", queryType=QueryType.LIKE),
  44. }),
  45. @JoinTable(type= JoinTable.Type.LEFT_JOIN, entity= WmsMaterial.class, attrName="this", alias="e",
  46. on="e.id = d.material_id",
  47. columns={
  48. @Column(name="title", attrName="materialTitle", label="库位名称", queryType=QueryType.LIKE),
  49. }),
  50. }, orderBy="a.update_date DESC"
  51. )
  52. public class WmsHouseIn extends DataEntity<WmsHouseIn> {
  53. private static final long serialVersionUID = 1L;
  54. private String sn; // 入库单号
  55. private String checkId; // 来料检查单
  56. private String batchSn; // 物料批次号
  57. private String nums; // 入库数量
  58. private String houseId; // 仓库
  59. private String houseLocationId; // 库位
  60. private String remark; // 备注
  61. private List imgList = new ArrayList<>();
  62. private String houseName;
  63. private String houseLocationName;
  64. private String materialId;
  65. private String materialTitle;
  66. public WmsHouseIn() {
  67. this(null);
  68. }
  69. public WmsHouseIn(String id){
  70. super(id);
  71. }
  72. @Size(min=0, max=64, message="入库单号长度不能超过 64 个字符")
  73. public String getSn() {
  74. return sn;
  75. }
  76. public void setSn(String sn) {
  77. this.sn = sn;
  78. }
  79. @Size(min=0, max=64, message="来料检查单长度不能超过 64 个字符")
  80. public String getCheckId() {
  81. return checkId;
  82. }
  83. public void setCheckId(String checkId) {
  84. this.checkId = checkId;
  85. }
  86. @Size(min=0, max=64, message="物料批次号长度不能超过 64 个字符")
  87. public String getBatchSn() {
  88. return batchSn;
  89. }
  90. public void setBatchSn(String batchSn) {
  91. this.batchSn = batchSn;
  92. }
  93. @Size(min=0, max=255, message="入库数量长度不能超过 255 个字符")
  94. public String getNums() {
  95. return nums;
  96. }
  97. public void setNums(String nums) {
  98. this.nums = nums;
  99. }
  100. @Size(min=0, max=64, message="仓库长度不能超过 64 个字符")
  101. public String getHouseId() {
  102. return houseId;
  103. }
  104. public void setHouseId(String houseId) {
  105. this.houseId = houseId;
  106. }
  107. @Size(min=0, max=64, message="库位长度不能超过 64 个字符")
  108. public String getHouseLocationId() {
  109. return houseLocationId;
  110. }
  111. public void setHouseLocationId(String houseLocationId) {
  112. this.houseLocationId = houseLocationId;
  113. }
  114. @Size(min=0, max=255, message="备注长度不能超过 255 个字符")
  115. public String getRemark() {
  116. return remark;
  117. }
  118. public void setRemark(String remark) {
  119. this.remark = remark;
  120. }
  121. public List getImgList() {
  122. return imgList;
  123. }
  124. public void setImgList(List imgList) {
  125. this.imgList = imgList;
  126. }
  127. public String getHouseName() {
  128. return houseName;
  129. }
  130. public void setHouseName(String houseName) {
  131. this.houseName = houseName;
  132. }
  133. public String getHouseLocationName() {
  134. return houseLocationName;
  135. }
  136. public void setHouseLocationName(String houseLocationName) {
  137. this.houseLocationName = houseLocationName;
  138. }
  139. public String getMaterialId() {
  140. return materialId;
  141. }
  142. public void setMaterialId(String materialId) {
  143. this.materialId = materialId;
  144. }
  145. public String getMaterialTitle() {
  146. return materialTitle;
  147. }
  148. public void setMaterialTitle(String materialTitle) {
  149. this.materialTitle = materialTitle;
  150. }
  151. }