InboundItem.java 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332
  1. package com.dk.mdm.model.pojo.ivt;
  2. import cn.afterturn.easypoi.excel.annotation.Excel;
  3. import com.baomidou.mybatisplus.annotation.*;
  4. import java.io.Serializable;
  5. import com.dk.common.infrastructure.annotaiton.ExportTitle;
  6. import com.dk.common.infrastructure.handler.*;
  7. import com.dk.common.model.pojo.PageInfo;
  8. import com.fasterxml.jackson.annotation.JsonFormat;
  9. import lombok.Data;
  10. import lombok.AllArgsConstructor;
  11. import lombok.NoArgsConstructor;
  12. import lombok.EqualsAndHashCode;
  13. import lombok.experimental.Accessors;
  14. import io.swagger.annotations.ApiModel;
  15. import io.swagger.annotations.ApiModelProperty;
  16. import com.alibaba.fastjson.JSONObject;
  17. import java.math.BigDecimal;
  18. import java.util.List;
  19. import java.time.LocalDateTime;
  20. /**
  21. * 入库明细
  22. */
  23. @Data
  24. @AllArgsConstructor
  25. @NoArgsConstructor
  26. @EqualsAndHashCode(callSuper = true)
  27. @Accessors(chain = true)
  28. @ExportTitle("入库明细")
  29. @TableName(value = "t_psi_inbound_item", autoResultMap = true)
  30. @ApiModel(value="实体类:入库明细", description="表名:t_psi_inbound_item")
  31. public class InboundItem extends PageInfo<InboundItem> implements Serializable {
  32. /*
  33. * 数据库字段
  34. */
  35. /**
  36. * 明细ID
  37. */
  38. @TableId(value = "item_id", type = IdType.AUTO)
  39. @ApiModelProperty(value = "明细ID")
  40. @TableField(typeHandler = UuidTypeHandler.class)
  41. private String itemId;
  42. /**
  43. * 入库ID
  44. */
  45. @Excel(name = "入库ID")
  46. @ApiModelProperty(value = "入库ID")
  47. @TableField(typeHandler = UuidTypeHandler.class)
  48. private String intoId;
  49. /**
  50. * 入库类型 (【系统字典】采购入库、销退入库、其他入库)
  51. */
  52. @Excel(name = "入库类型 (【系统字典】采购入库、销退入库、其他入库)")
  53. @ApiModelProperty(value = "入库类型 (【系统字典】采购入库、销退入库、其他入库)")
  54. private String intoType;
  55. /**
  56. * 来源单ID (采购订单、出库退货)
  57. */
  58. @Excel(name = "来源单ID (采购订单、出库退货)")
  59. @ApiModelProperty(value = "来源单ID (采购订单、出库退货)")
  60. @TableField(typeHandler = UuidTypeHandler.class)
  61. private String fromId;
  62. /**
  63. * 来源单明细ID (采购订单、出库退货)
  64. */
  65. @Excel(name = "来源单明细ID (采购订单、出库退货)")
  66. @ApiModelProperty(value = "来源单明细ID (采购订单、出库退货)")
  67. @TableField(typeHandler = UuidTypeHandler.class)
  68. private String fromItemId;
  69. /**
  70. * 商品顺序
  71. */
  72. @Excel(name = "商品顺序")
  73. @ApiModelProperty(value = "商品顺序")
  74. private Integer itemIndex;
  75. /**
  76. * 商品ID
  77. */
  78. @Excel(name = "商品ID")
  79. @ApiModelProperty(value = "商品ID")
  80. @TableField(typeHandler = UuidTypeHandler.class)
  81. private String skuId;
  82. /**
  83. * 商品数量
  84. */
  85. @Excel(name = "商品数量")
  86. @ApiModelProperty(value = "商品数量")
  87. private BigDecimal itemQty;
  88. /**
  89. * 入库价
  90. */
  91. @Excel(name = "入库价")
  92. @ApiModelProperty(value = "入库价")
  93. private BigDecimal priceInto;
  94. /**
  95. * 入库金额 (商品数量*入库价)
  96. */
  97. @Excel(name = "入库金额 (商品数量*入库价)")
  98. @ApiModelProperty(value = "入库金额 (商品数量*入库价)")
  99. private BigDecimal itemAmt;
  100. /**
  101. * 非标号
  102. */
  103. @Excel(name = "非标号")
  104. @ApiModelProperty(value = "非标号")
  105. private String nonStdCode;
  106. /**
  107. * 入库状态 (【系统字典】)
  108. */
  109. @Excel(name = "入库状态 (【系统字典】)")
  110. @ApiModelProperty(value = "入库状态 (【系统字典】)")
  111. private String intoStatus;
  112. /**
  113. * 入库中数量
  114. */
  115. @Excel(name = "入库中数量")
  116. @ApiModelProperty(value = "入库中数量")
  117. private BigDecimal intoingQty;
  118. /**
  119. * 入库中金额
  120. */
  121. @Excel(name = "入库中金额")
  122. @ApiModelProperty(value = "入库中金额")
  123. private BigDecimal intoingAmt;
  124. /**
  125. * 已入库数量
  126. */
  127. @Excel(name = "已入库数量")
  128. @ApiModelProperty(value = "已入库数量")
  129. private BigDecimal intoQty;
  130. /**
  131. * 已入库金额
  132. */
  133. @Excel(name = "已入库金额")
  134. @ApiModelProperty(value = "已入库金额")
  135. private BigDecimal intoAmt;
  136. /**
  137. * 已入库退货数量
  138. */
  139. @Excel(name = "已入库退货数量")
  140. @ApiModelProperty(value = "已入库退货数量")
  141. private BigDecimal returnQty;
  142. /**
  143. * 已入库退货金额
  144. */
  145. @Excel(name = "已入库退货金额")
  146. @ApiModelProperty(value = "已入库退货金额")
  147. private BigDecimal returnAmt;
  148. /**
  149. * 备注
  150. */
  151. @Excel(name = "备注")
  152. @ApiModelProperty(value = "备注")
  153. private String remarks;
  154. /**
  155. * 库存ID
  156. */
  157. @Excel(name = "库存ID")
  158. @ApiModelProperty(value = "库存ID")
  159. @TableField(typeHandler = UuidTypeHandler.class)
  160. private String invId;
  161. /**
  162. * 成本单价
  163. */
  164. @Excel(name = "成本单价")
  165. @ApiModelProperty(value = "成本单价")
  166. private BigDecimal costPrice;
  167. /**
  168. * 成本金额
  169. */
  170. @Excel(name = "成本金额")
  171. @ApiModelProperty(value = "成本金额")
  172. private BigDecimal costAmt;
  173. /**
  174. * 出库数量
  175. */
  176. @Excel(name = "出库数量")
  177. @ApiModelProperty(value = "出库数量")
  178. private BigDecimal outQty;
  179. /**
  180. * 库存数量 (库存数量=商品数量-出库数量)
  181. */
  182. @Excel(name = "库存数量 (库存数量=商品数量-出库数量)")
  183. @ApiModelProperty(value = "库存数量 (库存数量=商品数量-出库数量)")
  184. private BigDecimal invQty;
  185. /**
  186. * 有效标识 (1:正常 0:停用)
  187. */
  188. @Excel(name = "有效标识 (1:正常 0:停用)")
  189. @ApiModelProperty(value = "有效标识 (1:正常 0:停用)")
  190. private Boolean flgValid;
  191. /**
  192. * 企业ID
  193. */
  194. @Excel(name = "企业ID")
  195. @ApiModelProperty(value = "企业ID")
  196. private Integer cpId;
  197. /**
  198. * 创建时间 (触发器自动处理)
  199. */
  200. @Excel(name = "创建时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  201. @ApiModelProperty(value = "创建时间 (触发器自动处理)")
  202. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  203. @TableField(typeHandler = TimestampTypeHandler.class)
  204. private LocalDateTime opCreateTime;
  205. /**
  206. * 创建用户 (触发器自动处理)
  207. */
  208. @Excel(name = "创建用户 (触发器自动处理)")
  209. @ApiModelProperty(value = "创建用户 (触发器自动处理)")
  210. @TableField(typeHandler = UuidTypeHandler.class)
  211. private String opCreateUserId;
  212. /**
  213. * 修改时间 (触发器自动处理)
  214. */
  215. @Excel(name = "修改时间 (触发器自动处理)", format = "yyyy-MM-dd HH:mm:ss", width = 20)
  216. @ApiModelProperty(value = "修改时间 (触发器自动处理)")
  217. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  218. @TableField(typeHandler = TimestampTypeHandler.class)
  219. private LocalDateTime opUpdateTime;
  220. /**
  221. * 修改用户 (触发器自动处理)
  222. */
  223. @Excel(name = "修改用户 (触发器自动处理)")
  224. @ApiModelProperty(value = "修改用户 (触发器自动处理)")
  225. @TableField(typeHandler = UuidTypeHandler.class)
  226. private String opUpdateUserId;
  227. /**
  228. * 数据操作应用 (触发器自动处理)
  229. */
  230. @Excel(name = "数据操作应用 (触发器自动处理)")
  231. @ApiModelProperty(value = "数据操作应用 (触发器自动处理)")
  232. private String opAppCode;
  233. /**
  234. * 数据时间戳 (触发器自动处理)
  235. */
  236. @Excel(name = "数据时间戳 (触发器自动处理)")
  237. @ApiModelProperty(value = "数据时间戳 (触发器自动处理)")
  238. @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
  239. @TableField(typeHandler = TimestampTypeHandler.class)
  240. private LocalDateTime opTimestamp;
  241. /**
  242. * 数据操作数据库用户 (触发器自动处理)
  243. */
  244. @Excel(name = "数据操作数据库用户 (触发器自动处理)")
  245. @ApiModelProperty(value = "数据操作数据库用户 (触发器自动处理)")
  246. private String opDbUser;
  247. /*
  248. * 相关属性
  249. * @TableField(exist = false)
  250. */
  251. /*
  252. * 关联属性 + 查询条件
  253. * @TableField(exist = false)
  254. */
  255. private static final long serialVersionUID = 1L;
  256. }