QueryWhgenlegServiceImpl.java 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243
  1. package com.ruoyi.warehouseBusiness.component.impl;
  2. import com.ruoyi.common.utils.DateUtils;
  3. import com.ruoyi.reportManagement.domain.TWhgenleg;
  4. import com.ruoyi.reportManagement.mapper.TWhgenlegMapper;
  5. import com.ruoyi.warehouseBusiness.component.QueryWhgenlegService;
  6. import com.ruoyi.warehouseBusiness.domain.TWarehouseBills;
  7. import com.ruoyi.warehouseBusiness.domain.TWarehousebillsitems;
  8. import com.ruoyi.warehouseBusiness.domain.enums.WarehouseTypeEnum;
  9. import lombok.AllArgsConstructor;
  10. import lombok.extern.slf4j.Slf4j;
  11. import org.springframework.stereotype.Component;
  12. /**
  13. * @author caifc
  14. * @date 2021-11-11 9:15
  15. */
  16. @Slf4j
  17. @Component
  18. @AllArgsConstructor
  19. public class QueryWhgenlegServiceImpl implements QueryWhgenlegService {
  20. private final TWhgenlegMapper tWhgenlegMapper;
  21. private static final String FIRST = "one";
  22. private static final String SECOND = "two";
  23. /**
  24. * 仓库查询库存总帐
  25. *
  26. * @param warehouseBills 主表信息
  27. * @param item 明细表信息
  28. * @param ifCntrno 是否判断箱号
  29. * @param operate 操作(确认、撤回)
  30. * @return 库存总帐
  31. */
  32. @Override
  33. public TWhgenleg stockWhgenleg(TWarehouseBills warehouseBills, TWarehousebillsitems item, String ifCntrno, String operate) {
  34. TWhgenleg whgenleg = new TWhgenleg();
  35. // 提单号
  36. whgenleg.setfMblno(item.getfMblno());
  37. // 业务类型
  38. whgenleg.setfBusinessType(item.getfBusinessType());
  39. // 是否判断箱号
  40. if (WarehouseTypeEnum.JUDGE_BOX.getType().equals(ifCntrno)) {
  41. whgenleg.setfCntrno(item.getfCntrno());
  42. }
  43. // 货物品名
  44. whgenleg.setfGoodsid(item.getfGoodsid());
  45. if (WarehouseTypeEnum.SJRK.getType().equals(warehouseBills.getfBilltype())) {
  46. inStock(whgenleg, warehouseBills, item);
  47. }
  48. if (WarehouseTypeEnum.SJCK.getType().equals(warehouseBills.getfBilltype())) {
  49. outStock(whgenleg, warehouseBills, item);
  50. }
  51. if (WarehouseTypeEnum.HQZY.getType().equals(warehouseBills.getfBilltype())) {
  52. goodsTransfer(whgenleg, warehouseBills, item, operate, FIRST);
  53. }
  54. if (WarehouseTypeEnum.CKDB.getType().equals(warehouseBills.getfBilltype())) {
  55. stockTransfer(whgenleg, warehouseBills, item, operate, FIRST);
  56. }
  57. if (WarehouseTypeEnum.HWTG.getType().equals(warehouseBills.getfBilltype())) {
  58. cargoClearance(whgenleg, warehouseBills, item, operate, FIRST);
  59. }
  60. TWhgenleg tWhgenleg = tWhgenlegMapper.selectTWhgenleg(whgenleg);
  61. return tWhgenleg;
  62. }
  63. /**
  64. * 被货转查询库存总帐
  65. *
  66. * @param warehouseBills 主表信息
  67. * @param item 明细表信息
  68. * @param ifCntrno 是否判断箱号
  69. * @param operate 操作(确认、撤回)
  70. * @return 库存总帐
  71. */
  72. @Override
  73. public TWhgenleg secondStockWhgenleg(TWarehouseBills warehouseBills, TWarehousebillsitems item, String ifCntrno, String operate) {
  74. TWhgenleg whgenleg = new TWhgenleg();
  75. // 提单号
  76. whgenleg.setfMblno(item.getfMblno());
  77. // 业务类型
  78. whgenleg.setfBusinessType(item.getfBusinessType());
  79. // 是否判断箱号
  80. if (WarehouseTypeEnum.JUDGE_BOX.getType().equals(ifCntrno)) {
  81. whgenleg.setfCntrno(item.getfCntrno());
  82. }
  83. // 货物品名
  84. whgenleg.setfGoodsid(item.getfGoodsid());
  85. if (WarehouseTypeEnum.HQZY.getType().equals(warehouseBills.getfBilltype())) {
  86. goodsTransfer(whgenleg, warehouseBills, item, operate, SECOND);
  87. }
  88. if (WarehouseTypeEnum.CKDB.getType().equals(warehouseBills.getfBilltype())) {
  89. stockTransfer(whgenleg, warehouseBills, item, operate, SECOND);
  90. }
  91. if (WarehouseTypeEnum.HWTG.getType().equals(warehouseBills.getfBilltype())) {
  92. cargoClearance(whgenleg, warehouseBills, item, operate, SECOND);
  93. }
  94. TWhgenleg tWhgenleg = tWhgenlegMapper.selectTWhgenleg(whgenleg);
  95. return tWhgenleg;
  96. }
  97. /**
  98. * 入库查询库存总帐
  99. *
  100. * @param whgenleg 查询条件
  101. * @param warehouseBills 主表信息
  102. * @param item 明细表信息
  103. * @return 库存总帐
  104. */
  105. private void inStock(TWhgenleg whgenleg, TWarehouseBills warehouseBills, TWarehousebillsitems item) {
  106. // 客户
  107. whgenleg.setfCorpid(warehouseBills.getfCorpid());
  108. // 贸易方式
  109. whgenleg.setfTrademodeid(warehouseBills.getfTrademodeid());
  110. // 业务日期
  111. whgenleg.setfBsdate(DateUtils.dateConversionMin(item.getfOriginalbilldate()));
  112. // 业务类型详情
  113. whgenleg.setfMarks(item.getfMarks());
  114. // 库区
  115. whgenleg.setfWarehouseLocationid(item.getfWarehouselocid());
  116. }
  117. /**
  118. * 出库查询库存总帐
  119. *
  120. * @param whgenleg 查询条件
  121. * @param warehouseBills 主表信息
  122. * @param item 明细表信息
  123. * @return 库存总帐
  124. */
  125. private void outStock(TWhgenleg whgenleg, TWarehouseBills warehouseBills, TWarehousebillsitems item) {
  126. // 客户
  127. whgenleg.setfCorpid(warehouseBills.getfCorpid());
  128. // 贸易方式
  129. whgenleg.setfTrademodeid(warehouseBills.getfTrademodeid());
  130. // 业务日期
  131. whgenleg.setfBsdate(DateUtils.dateConversionMin(item.getfOriginalbilldate()));
  132. // 库区
  133. whgenleg.setfWarehouseLocationid(item.getfWarehouselocid());
  134. }
  135. /**
  136. * 货转查询库存总帐
  137. *
  138. * @param whgenleg 查询条件
  139. * @param warehouseBills 主表信息
  140. * @param item 明细表信息
  141. * @param operate 操作(确认、撤回)
  142. * @return 库存总帐
  143. */
  144. private void goodsTransfer(TWhgenleg whgenleg, TWarehouseBills warehouseBills, TWarehousebillsitems item, String operate, String frequency) {
  145. // 客户
  146. if (operate.equals(WarehouseTypeEnum.CONFIRM_OPERATION.getType()) && !frequency.equals(FIRST)) {
  147. whgenleg.setfCorpid(warehouseBills.getfTocorpid());
  148. } else {
  149. whgenleg.setfCorpid(warehouseBills.getfCorpid());
  150. }
  151. // 贸易方式
  152. whgenleg.setfTrademodeid(warehouseBills.getfTrademodeid());
  153. // 业务日期
  154. if (frequency.equals(FIRST)) {
  155. whgenleg.setfBsdate(DateUtils.dateConversionMin(item.getfOriginalbilldate()));
  156. } else {
  157. whgenleg.setfBsdate(DateUtils.dateConversionMin(item.getfBsdate()));
  158. }
  159. // 库区
  160. whgenleg.setfWarehouseLocationid(item.getfWarehouselocid());
  161. }
  162. /**
  163. * 调拨查询库存总帐
  164. *
  165. * @param whgenleg 查询条件
  166. * @param warehouseBills 主表信息
  167. * @param item 明细表信息
  168. * @param operate 操作(确认、撤回)
  169. * @return 库存总帐
  170. */
  171. private void stockTransfer(TWhgenleg whgenleg, TWarehouseBills warehouseBills, TWarehousebillsitems item, String operate, String frequency) {
  172. // 客户
  173. whgenleg.setfCorpid(warehouseBills.getfCorpid());
  174. // 贸易方式
  175. whgenleg.setfTrademodeid(warehouseBills.getfTrademodeid());
  176. // 提单号
  177. whgenleg.setfMblno(item.getfMblno());
  178. // 业务日期
  179. if (frequency.equals(FIRST)) {
  180. whgenleg.setfBsdate(DateUtils.dateConversionMin(item.getfOriginalbilldate()));
  181. } else {
  182. whgenleg.setfBsdate(DateUtils.dateConversionMin(item.getfBsdate()));
  183. }
  184. // 库区
  185. if (operate.equals(WarehouseTypeEnum.CONFIRM_OPERATION.getType()) && !frequency.equals(FIRST)) {
  186. whgenleg.setfWarehouseLocationid(item.getfTransferWarehouselocid());
  187. } else {
  188. whgenleg.setfWarehouseLocationid(item.getfWarehouselocid());
  189. }
  190. }
  191. /**
  192. * 货物通关查询库存总帐
  193. *
  194. * @param whgenleg 查询条件
  195. * @param warehouseBills 主表信息
  196. * @param item 明细表信息
  197. * @param operate 操作(确认、撤回)
  198. * @return 库存总帐
  199. */
  200. private void cargoClearance(TWhgenleg whgenleg, TWarehouseBills warehouseBills, TWarehousebillsitems item, String operate, String frequency) {
  201. // 客户
  202. whgenleg.setfCorpid(warehouseBills.getfCorpid());
  203. // 贸易方式
  204. if (operate.equals(WarehouseTypeEnum.CONFIRM_OPERATION.getType()) && !frequency.equals(FIRST)) {
  205. whgenleg.setfTrademodeid(warehouseBills.getfNewTrademodeid());
  206. } else {
  207. whgenleg.setfTrademodeid(warehouseBills.getfTrademodeid());
  208. }
  209. // 提单号
  210. whgenleg.setfMblno(item.getfMblno());
  211. // 业务日期
  212. if (frequency.equals(FIRST)) {
  213. whgenleg.setfBsdate(DateUtils.dateConversionMin(item.getfOriginalbilldate()));
  214. } else {
  215. whgenleg.setfBsdate(DateUtils.dateConversionMin(item.getfBsdate()));
  216. }
  217. // 库区
  218. if (operate.equals(WarehouseTypeEnum.CONFIRM_OPERATION.getType()) && !frequency.equals(FIRST)) {
  219. whgenleg.setfWarehouseLocationid(item.getfTransferWarehouselocid());
  220. } else {
  221. whgenleg.setfWarehouseLocationid(item.getfWarehouselocid());
  222. }
  223. }
  224. }