OutboundOtherService.java 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841
  1. package com.dk.mdm.service.ivt.outbound;
  2. import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
  3. import com.dk.common.exception.BaseBusinessException;
  4. import com.dk.common.infrastructure.annotaiton.Pagination;
  5. import com.dk.common.infrastructure.constant.Constant;
  6. import com.dk.common.infrastructure.enums.ErrorCodeEnum;
  7. import com.dk.common.mapper.BaseMapper;
  8. import com.dk.common.model.pojo.PageList;
  9. import com.dk.common.response.ResponseCodeEnum;
  10. import com.dk.common.response.ResponseResultUtil;
  11. import com.dk.common.response.ResponseResultVO;
  12. import com.dk.common.service.BaseService;
  13. import com.dk.mdm.infrastructure.convert.ivt.OutboundConvert;
  14. import com.dk.mdm.infrastructure.convert.ivt.OutboundItemConvert;
  15. import com.dk.mdm.mapper.common.CommonMapper;
  16. import com.dk.mdm.mapper.ivt.OutboundItemMapper;
  17. import com.dk.mdm.mapper.ivt.OutboundMapper;
  18. import com.dk.mdm.model.pojo.ivt.InboundItem;
  19. import com.dk.mdm.model.pojo.ivt.Outbound;
  20. import com.dk.mdm.model.pojo.ivt.OutboundItem;
  21. import com.dk.mdm.model.query.ivt.InboundItemQuery;
  22. import com.dk.mdm.model.query.ivt.InboundQuery;
  23. import com.dk.mdm.model.query.ivt.OutboundItemQuery;
  24. import com.dk.mdm.model.query.ivt.OutboundQuery;
  25. import com.dk.mdm.model.response.ivt.InboundItemResponse;
  26. import com.dk.mdm.model.response.ivt.InboundResponse;
  27. import com.dk.mdm.model.response.ivt.OutboundItemResponse;
  28. import com.dk.mdm.model.response.ivt.OutboundResponse;
  29. import com.dk.mdm.model.vo.ivt.InboundItemVO;
  30. import com.dk.mdm.model.vo.ivt.OutboundItemVO;
  31. import com.dk.mdm.model.vo.ivt.OutboundVO;
  32. import com.dk.mdm.service.common.CommonService;
  33. import com.dk.mdm.service.ivt.inventory.InventoryService;
  34. import org.springframework.beans.factory.annotation.Autowired;
  35. import org.springframework.stereotype.Service;
  36. import org.springframework.transaction.annotation.Transactional;
  37. import java.math.BigDecimal;
  38. import java.util.HashMap;
  39. import java.util.List;
  40. import java.util.Map;
  41. import java.util.UUID;
  42. /**
  43. * @author : 寇珊珊
  44. * @desc : 其他出库业务层
  45. * @date : 2024/3/18 15:33
  46. */
  47. @Service
  48. public class OutboundOtherService extends BaseService<Outbound> {
  49. @Override
  50. public BaseMapper<Outbound> getRepository() {
  51. return outboundMapper;
  52. }
  53. @Autowired
  54. private CommonService commonService;
  55. @Autowired
  56. private OutboundMapper outboundMapper;
  57. @Autowired
  58. private OutboundConvert outboundConvert;
  59. @Autowired
  60. private OutboundItemMapper outboundItemMapper;
  61. @Autowired
  62. private OutboundItemConvert outboundItemConvert;
  63. @Autowired
  64. private CommonMapper commonMapper;
  65. @Autowired
  66. private InventoryService inventoryService;
  67. /**
  68. * @desc : 条件查询
  69. * @date : 2024/3/18 11:20
  70. * @author : 寇珊珊
  71. */
  72. @Pagination
  73. public ResponseResultVO<PageList<InboundResponse>> selectByCond(OutboundQuery outboundQuery) {
  74. return super.mergeListWithCount(outboundQuery, outboundMapper.selectByCond(outboundQuery),
  75. outboundMapper.countByCond(outboundQuery));
  76. }
  77. /**
  78. * @desc : 查询明细
  79. * @date : 2024/3/15 16:43
  80. * @author : 寇珊珊
  81. */
  82. @Pagination
  83. public ResponseResultVO<Map<String, Object>> selectOutboundOtherItemInfoById(String id) {
  84. Map<String, Object> result = new HashMap<>();
  85. // 商品明细
  86. List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(id));
  87. result.put("itemList", outboundItemResponseList);
  88. // 收款
  89. // 附件
  90. return ResponseResultUtil.success(result);
  91. }
  92. /**
  93. * @desc : 其他出库新建
  94. * @date : 2024/3/7 14:13
  95. * @author : 寇珊珊
  96. */
  97. @Transactional(rollbackFor = {Exception.class})
  98. public ResponseResultVO<?> otherOutboundInsert(OutboundVO outboundVO) {
  99. //region 查询当前公司的系统参数 自动办理信息 并赋值
  100. Map<String, Object> map = new HashMap<>();
  101. map.put("cpId", outboundVO.getCpId());
  102. map.put("code", Constant.SystemConstant.IVT_001.getValue());
  103. //自动办理标识
  104. String flgHandleSetting = commonMapper.getSettingValue(map);
  105. //自动办理标识为1 自动办理出库
  106. if (Constant.FlgAutoHandleStringType.ONE.getValue().equals(flgHandleSetting)) {
  107. outboundVO.setFlgHandleSetting(Constant.FlgHandleSetting.TRUE.getValue());
  108. outboundVO.setFlgAutoHandle(Constant.FlgAutoHandle.TRUE.getValue());
  109. }
  110. //endregion
  111. //region 总单
  112. //获取 id/单号
  113. Map<String, Object> codeMap = commonService.getUniqueNoteCode(Constant.docNameConstant.OTHEROUTBOUND.getName(), false);
  114. outboundVO.setOutId(codeMap.get("outId").toString()).
  115. setOutNo(codeMap.get("outNote").toString());
  116. //出库类型
  117. outboundVO.setOutType(Constant.OutType.OTHER.getName());
  118. //自动出库标识
  119. if (outboundVO.getFlgAutoHandle()) {
  120. //已出库
  121. outboundVO.setOutStatus(Constant.OutStatus.YICHUKU.getName());
  122. } else {
  123. //出库中
  124. outboundVO.setOutStatus(Constant.OutStatus.CHUKUZHONG.getName());
  125. }
  126. //出库状态等于已出库 更新合计出库数量/金额 = 出库中数量/出库中金额
  127. if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
  128. outboundVO
  129. .setOutQty(outboundVO.getOutingQty())
  130. .setOutAmt(outboundVO.getOutingAmt())
  131. .setOutingQty(BigDecimal.ZERO)
  132. .setOutingAmt(BigDecimal.ZERO)
  133. ;
  134. } else {
  135. outboundVO
  136. .setOutQty(BigDecimal.ZERO)
  137. .setOutAmt(BigDecimal.ZERO)
  138. ;
  139. }
  140. //实体转换
  141. Outbound outbound = outboundConvert.convertToPo(outboundVO);
  142. outboundMapper.insert(outbound);
  143. //endregion
  144. //region 明细
  145. //校验明细
  146. if (outboundVO.getItemList().size() == 0) {
  147. throw new BaseBusinessException(ErrorCodeEnum.OUTBOUND_ITEM_NOT_EXIST.getCode(),
  148. ErrorCodeEnum.OUTBOUND_ITEM_NOT_EXIST.getMessage());
  149. }
  150. for (OutboundItemVO outboundItemVO : outboundVO.getItemList()) {
  151. //region 将库存需要的参数赋值
  152. outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  153. outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  154. outboundItemVO.setAddOrEditFlag(true);
  155. //endregion
  156. //总单id
  157. outboundItemVO.setOutId(outboundVO.getOutId());
  158. //出库类型
  159. outboundItemVO.setOutType(outboundVO.getOutType());
  160. //出库状态等于已出库 更新合计出库数量/金额 = 出库中数量/出库中金额
  161. if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
  162. outboundItemVO
  163. .setOutQty(outboundItemVO.getOutingQty())
  164. .setOutAmt(outboundItemVO.getOutingAmt())
  165. .setOutingQty(BigDecimal.ZERO)
  166. .setOutingAmt(BigDecimal.ZERO)
  167. .setCostPrice(outboundItemVO.getPriceOut())
  168. .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
  169. ;
  170. } else {
  171. outboundItemVO
  172. .setOutQty(BigDecimal.ZERO)
  173. .setOutAmt(BigDecimal.ZERO);
  174. }
  175. //出库状态
  176. outboundItemVO.setOutStatus(outboundVO.getOutStatus());
  177. //实体转换
  178. OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
  179. outboundItemMapper.insert(outboundItem);
  180. outboundItemVO.setItemId(outboundItem.getItemId());
  181. //endregion
  182. }
  183. //endregion
  184. //region 修改库存
  185. if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
  186. Map<String, Object> invMap = new HashMap<>();
  187. invMap.put("outDetail", outboundVO.getItemList());
  188. inventoryService.operatingInventoryInformation(invMap);
  189. }
  190. //endregion
  191. return ResponseResultUtil.success(outboundVO);
  192. }
  193. /**
  194. * @desc : 其他出库编辑
  195. * @date : 2024/3/25 16:25
  196. * @author : 寇珊珊
  197. */
  198. @Transactional(rollbackFor = {Exception.class})
  199. public ResponseResultVO<?> otherOutboundUpdate(OutboundVO outboundVO) {
  200. //region 小编辑
  201. if (!outboundVO.getLimitEdit()) {
  202. Outbound outbound = new Outbound();
  203. outbound.setOutId(outboundVO.getOutId());
  204. outbound.setRemarks(outboundVO.getRemarks());
  205. outbound.setAnnexPaths(outboundVO.getAnnexPaths());
  206. outboundMapper.update(outbound,
  207. new UpdateWrapper<Outbound>().lambda()
  208. .eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
  209. );
  210. for (OutboundItemVO outboundItemVO : outboundVO.getItemList()) {
  211. OutboundItem outboundItem = new OutboundItem();
  212. outboundItem.setItemId(outboundItemVO.getItemId());
  213. outboundItem.setRemarks(outboundItemVO.getRemarks());
  214. outboundItemMapper.update(outboundItem,
  215. new UpdateWrapper<OutboundItem>().lambda()
  216. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  217. );
  218. }
  219. }
  220. //endregion
  221. //region 大编辑
  222. else {
  223. //region 明细数量金额 求和
  224. BigDecimal sumQty = outboundVO.getItemList().stream().map(OutboundItemVO::getOutingQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(6, BigDecimal.ROUND_HALF_UP);
  225. BigDecimal sumAmt = outboundVO.getItemList().stream().map(OutboundItemVO::getOutingAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
  226. //endregion
  227. //region 自动办理参数为true 已出库编辑
  228. //自动办理参数为true
  229. if (Constant.FlgHandleSetting.TRUE.getValue().equals(outboundVO.getFlgHandleSetting())) {
  230. //region 修改明细
  231. List<OutboundItemVO> itemList = outboundVO.getItemList();
  232. for (OutboundItemVO outboundItemVO : itemList) {
  233. //根据id查询
  234. OutboundItemResponse outboundItemResponse = outboundItemMapper.selectById(outboundItemVO.getItemId());
  235. //region 编辑明细
  236. if (outboundItemVO.getItemId() != null) {
  237. //region 将库存需要的参数赋值
  238. outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  239. outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  240. //编辑之前的数
  241. outboundItemVO.setQtyBeforeUpdate(outboundItemResponse.getOutQty());
  242. outboundItemVO.setAmtBeforeUpdate(outboundItemResponse.getOutAmt());
  243. //编辑之后的数
  244. outboundItemVO.setOutQty(outboundItemVO.getOutingQty());
  245. outboundItemVO.setOutAmt(outboundItemVO.getOutingAmt());
  246. outboundItemVO.setAddOrEditFlag(false);
  247. //endregion
  248. OutboundItem outboundItem = new OutboundItem();
  249. outboundItem.setItemId(outboundItemVO.getItemId());
  250. outboundItem.setOutQty(outboundItemVO.getOutingQty());
  251. outboundItem.setOutAmt(outboundItemVO.getOutingAmt());
  252. outboundItem.setCostPrice(outboundItemVO.getPriceOut());
  253. outboundItem.setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(6, BigDecimal.ROUND_HALF_UP));
  254. //修改
  255. outboundItemMapper.update(outboundItem,
  256. new UpdateWrapper<OutboundItem>().lambda()
  257. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  258. );
  259. }
  260. //endregion
  261. //region 新建
  262. else {
  263. outboundItemVO
  264. .setOutQty(outboundItemVO.getOutingQty())
  265. .setOutAmt(outboundItemVO.getOutingAmt())
  266. .setOutingQty(BigDecimal.ZERO)
  267. .setOutingAmt(BigDecimal.ZERO)
  268. .setCostPrice(outboundItemVO.getPriceOut())
  269. .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
  270. ;
  271. outboundItemVO.setOutId(outboundVO.getOutId());
  272. //入库状态
  273. outboundItemVO.setOutStatus(outboundVO.getOutStatus());
  274. outboundItemVO.setOutType(Constant.OutType.OTHER.getName());
  275. //实体转换
  276. OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
  277. outboundItemMapper.insert(outboundItem);
  278. outboundItemVO.setItemId(outboundItem.getItemId());
  279. //region 将库存需要的参数赋值
  280. outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  281. outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  282. outboundItemVO.setOutQty(outboundItemVO.getOutQty());
  283. outboundItemVO.setOutAmt(outboundItemVO.getOutAmt());
  284. outboundItemVO.setAddOrEditFlag(true);
  285. //endregion
  286. }
  287. //endregion
  288. }
  289. //endregion
  290. //region 删除明细
  291. if (outboundVO.getDeleteItemList() != null && outboundVO.getDeleteItemList().size() > 0) {
  292. for (OutboundItemVO outboundItemVO : outboundVO.getDeleteItemList()) {
  293. if (outboundItemVO.getItemId() != null) {
  294. //region 将库存需要的参数赋值
  295. outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  296. outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  297. //endregion
  298. OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
  299. outboundItem.setFlgValid(false);
  300. //修改
  301. outboundItemMapper.update(outboundItem,
  302. new UpdateWrapper<OutboundItem>().lambda()
  303. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  304. );
  305. }
  306. }
  307. }
  308. //endregion
  309. //region 修改出库总单
  310. Outbound outbound = new Outbound();
  311. outbound.setOutId(outboundVO.getOutId());
  312. outbound.setOutQty(sumQty);
  313. outbound.setOutAmt(sumAmt);
  314. //修改
  315. outboundMapper.update(outbound,
  316. new UpdateWrapper<Outbound>().lambda().eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
  317. );
  318. //endregion
  319. //region 修改库存
  320. if (Constant.OutStatus.YICHUKU.getName().equals(outboundVO.getOutStatus())) {
  321. Map<String, Object> invMap = new HashMap<>();
  322. invMap.put("outDetail", outboundVO.getItemList());
  323. invMap.put("delOutDetail", outboundVO.getDeleteItemList());
  324. inventoryService.operatingInventoryInformation(invMap);
  325. }
  326. //endregion
  327. }
  328. else{
  329. throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.FLG_HANDLE_SETTING_NOT_ENABLED_OUT.getMessage());
  330. }
  331. //endregion
  332. //region 自动办理参数false 出库中编辑
  333. //自动办理标识为false 并且 自动办理参数为false 出库中
  334. if (!outboundVO.getFlgAutoHandle() && Constant.FlgHandleSetting.FALSE.getValue().equals(outboundVO.getFlgHandleSetting())) {
  335. //region 修改明细
  336. List<OutboundItemVO> itemList = outboundVO.getItemList();
  337. for (OutboundItemVO outboundItemVO : itemList) {
  338. //region 赋值明细
  339. if (outboundItemVO.getItemId() != null) {
  340. OutboundItem outboundItem = new OutboundItem();
  341. outboundItem.setItemId(outboundItemVO.getItemId());
  342. outboundItem.setOutingQty(outboundItemVO.getOutingQty());
  343. outboundItem.setOutingAmt(outboundItemVO.getOutingAmt());
  344. //修改
  345. outboundItemMapper.update(outboundItem,
  346. new UpdateWrapper<OutboundItem>().lambda()
  347. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  348. );
  349. }
  350. //endregion
  351. //region 新建
  352. else {
  353. outboundItemVO
  354. .setOutId(outboundItemVO.getOutId())
  355. .setOutQty(BigDecimal.ZERO)
  356. .setOutAmt(BigDecimal.ZERO)
  357. .setCostPrice(outboundItemVO.getPriceOut())
  358. .setCostAmt(outboundItemVO.getOutingQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
  359. .setOutType(Constant.OutType.OTHER.getName())
  360. ;
  361. //出库状态
  362. String outStatus = this.setOutStatus(outboundItemVO.getOutingQty(), outboundItemVO.getOutQty());
  363. outboundItemVO.setOutStatus(outStatus);
  364. //实体转换
  365. OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
  366. //新建
  367. outboundItemMapper.insert(outboundItem);
  368. outboundItemVO.setItemId(outboundItem.getItemId());
  369. }
  370. //endregion
  371. }
  372. //endregion
  373. //region 删除明细
  374. if (outboundVO.getDeleteItemList() != null && outboundVO.getDeleteItemList().size() > 0) {
  375. for (OutboundItemVO outboundItemVO : outboundVO.getDeleteItemList()) {
  376. if (outboundItemVO.getItemId() != null) {
  377. OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
  378. outboundItem.setFlgValid(false);
  379. //修改
  380. outboundItemMapper.update(outboundItem,
  381. new UpdateWrapper<OutboundItem>().lambda()
  382. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  383. );
  384. }
  385. }
  386. }
  387. //endregion
  388. //region 修改出库总单
  389. Outbound outbound = new Outbound();
  390. outbound.setOutId(outboundVO.getOutId());
  391. outbound.setOutingQty(sumQty);
  392. outbound.setOutingAmt(sumAmt);
  393. //修改
  394. outboundMapper.update(outbound,
  395. new UpdateWrapper<Outbound>().lambda().eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
  396. );
  397. //endregion
  398. }
  399. else{
  400. throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.FLG_HANDLE_SETTING_NOT_ENABLED_OUT.getMessage());
  401. }
  402. //endregion
  403. }
  404. //endregion
  405. return ResponseResultUtil.success(outboundVO);
  406. }
  407. /**
  408. * @desc : 其他出库作废
  409. * @date : 2024/3/25 16:25
  410. * @author : 寇珊珊
  411. */
  412. @Transactional(rollbackFor = {Exception.class})
  413. public ResponseResultVO<?> otherOutboundRepeal(String outId) {
  414. //region 查询总单 查询明细
  415. //根据id查询 此条出库单的数据还未更改前的数据
  416. OutboundResponse outboundResponse = outboundMapper.selectById(outId);
  417. //根据总单id查询
  418. List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(outboundResponse.getOutId()));
  419. //endregion
  420. //region 自动办理参数为true 已出库编辑
  421. //自动办理参数为true
  422. if (Constant.FlgHandleSetting.TRUE.getValue().equals(outboundResponse.getFlgHandleSetting())) {
  423. //region 修改明细
  424. for (OutboundItemResponse outboundItemResponse : outboundItemResponseList) {
  425. //region 将库存需要的参数赋值
  426. outboundItemResponse.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  427. outboundItemResponse.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  428. outboundItemResponse.setOutQty(outboundItemResponse.getOutQty().negate());
  429. outboundItemResponse.setOutAmt(outboundItemResponse.getOutAmt().negate());
  430. //endregion
  431. //赋值
  432. OutboundItem outboundItem = new OutboundItem();
  433. outboundItem.setItemId(outboundItemResponse.getItemId());
  434. outboundItem.setFlgValid(false);
  435. //修改
  436. outboundItemMapper.update(outboundItem,
  437. new UpdateWrapper<OutboundItem>().lambda()
  438. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  439. );
  440. }
  441. //endregion
  442. //region 修改出库总单
  443. Outbound outbound = new Outbound();
  444. outbound.setOutId(outboundResponse.getOutId());
  445. outbound.setFlgValid(false);
  446. //修改
  447. outboundMapper.update(outbound,
  448. new UpdateWrapper<Outbound>().lambda().eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
  449. );
  450. //endregion
  451. //region 修改库存
  452. Map<String, Object> map = new HashMap<>();
  453. map.put("delOutDetail", outboundItemResponseList);
  454. inventoryService.operatingInventoryInformation(map);
  455. //endregion
  456. }
  457. else{
  458. throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.FLG_HANDLE_SETTING_NOT_ENABLED_OUT.getMessage());
  459. }
  460. //endregion
  461. //region 自动办理参数false 出库中编辑
  462. //自动办理标识为false 并且 自动办理参数为false 出库中
  463. if (!outboundResponse.getFlgAutoHandle() && Constant.FlgHandleSetting.FALSE.getValue().equals(outboundResponse.getFlgHandleSetting())) {
  464. //region 修改明细
  465. for (OutboundItemResponse outboundItemResponse : outboundItemResponseList) {
  466. //赋值
  467. OutboundItem outboundItem = new OutboundItem();
  468. outboundItem.setItemId(outboundItemResponse.getItemId());
  469. outboundItem.setOutingQty(BigDecimal.ZERO);
  470. outboundItem.setOutingAmt(BigDecimal.ZERO);
  471. outboundItem.setFlgValid(false);
  472. //修改
  473. outboundItemMapper.update(outboundItem,
  474. new UpdateWrapper<OutboundItem>().lambda()
  475. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  476. );
  477. }
  478. //endregion
  479. //region 修改出库总单
  480. Outbound outbound = new Outbound();
  481. outbound.setOutId(outboundResponse.getOutId());
  482. outbound.setOutingQty(BigDecimal.ZERO);
  483. outbound.setOutingAmt(BigDecimal.ZERO);
  484. outbound.setFlgValid(false);
  485. //修改
  486. outboundMapper.update(outbound,
  487. new UpdateWrapper<Outbound>().lambda().eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
  488. );
  489. //endregion
  490. }
  491. else{
  492. throw new BaseBusinessException(ResponseCodeEnum.OPERATE_FAIL.getCode(), ErrorCodeEnum.FLG_HANDLE_SETTING_NOT_ENABLED_OUT.getMessage());
  493. }
  494. //endregion
  495. return ResponseResultUtil.success();
  496. }
  497. /**
  498. * @desc : 其他出库办理
  499. * @date : 2024/3/7 15:47
  500. * @author : 寇珊珊
  501. */
  502. @Transactional(rollbackFor = {Exception.class})
  503. public ResponseResultVO<?> otherHandleOutbound(OutboundVO outboundVO) {
  504. //region 编辑明细
  505. //校验明细
  506. if (outboundVO.getItemList().size() == 0) {
  507. throw new BaseBusinessException(ErrorCodeEnum.OUTBOUND_ITEM_NOT_EXIST.getCode(),
  508. ErrorCodeEnum.OUTBOUND_ITEM_NOT_EXIST.getMessage());
  509. }
  510. for (OutboundItemVO outboundItemVO : outboundVO.getItemList()) {
  511. //查询原单
  512. OutboundItemResponse outboundItemResponse = outboundItemMapper.selectById(outboundItemVO.getItemId());
  513. //region 校验数量是否超出
  514. if (outboundItemVO.getOutingQty().compareTo(outboundItemResponse.getOutingQty()) > 0) {
  515. throw new BaseBusinessException(ErrorCodeEnum.CANNOT_EXCEED_THE_QUANTITYIN_THE_WAREHOUSE.getCode(),
  516. ErrorCodeEnum.CANNOT_EXCEED_THE_QUANTITYIN_THE_WAREHOUSE.getMessage());
  517. }
  518. //endregion
  519. //region 编辑明细
  520. if (outboundItemVO.getItemId() != null) {
  521. outboundItemVO
  522. .setOutQty(outboundItemResponse.getOutQty().add(outboundItemVO.getOutingQty()))
  523. .setOutAmt(outboundItemResponse.getOutAmt().add(outboundItemVO.getOutingAmt()))
  524. .setOutingQty(outboundItemResponse.getOutingQty().subtract(outboundItemVO.getOutingQty()))
  525. .setOutAmt(outboundItemResponse.getOutingAmt().subtract(outboundItemVO.getOutingAmt()))
  526. .setCostPrice(outboundItemVO.getPriceOut())
  527. .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
  528. ;
  529. //出库状态
  530. String outStatus = this.setOutStatus(outboundItemVO.getOutingQty(), outboundItemVO.getOutQty());
  531. outboundItemVO.setOutStatus(outStatus);
  532. //实体转换
  533. OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
  534. //修改
  535. outboundItemMapper.update(outboundItem,
  536. new UpdateWrapper<OutboundItem>().lambda()
  537. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  538. );
  539. //region 将库存需要的参数赋值
  540. outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  541. outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  542. //编辑之前的数
  543. if(outboundItemResponse.getOutQty().compareTo(BigDecimal.ZERO)>0) {
  544. outboundItemVO.setQtyBeforeUpdate(outboundItemResponse.getOutQty());
  545. outboundItemVO.setAmtBeforeUpdate(outboundItemResponse.getOutAmt());
  546. }
  547. outboundItemVO.setAddOrEditFlag(true);
  548. //endregion
  549. }
  550. //endregion
  551. //region 新建明细
  552. else {
  553. outboundItemVO
  554. .setOutId(outboundItemVO.getOutId())
  555. .setOutQty(outboundItemVO.getOutingQty())
  556. .setOutAmt(outboundItemVO.getOutingAmt())
  557. .setCostPrice(outboundItemVO.getPriceOut())
  558. .setCostAmt(outboundItemVO.getOutQty().multiply(outboundItemVO.getPriceOut()).setScale(2, BigDecimal.ROUND_HALF_UP))
  559. .setOutType(Constant.OutType.OTHER.getName())
  560. .setOutingQty(BigDecimal.ZERO)
  561. .setOutingAmt(BigDecimal.ZERO)
  562. ;
  563. //出库状态
  564. String outStatus = this.setOutStatus(outboundItemVO.getOutingQty(), outboundItemVO.getOutQty());
  565. outboundItemVO.setOutStatus(outStatus);
  566. //实体转换
  567. OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
  568. //新建
  569. outboundItemMapper.insert(outboundItem);
  570. outboundItemVO.setItemId(outboundItem.getItemId());
  571. //region 将库存需要的参数赋值
  572. outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  573. outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  574. outboundItemVO.setAddOrEditFlag(true);
  575. //endregion
  576. }
  577. //endregion
  578. }
  579. //endregion
  580. //region 删除明细
  581. if (outboundVO.getDeleteItemList() != null && outboundVO.getDeleteItemList().size() > 0) {
  582. for (OutboundItemVO outboundItemVO : outboundVO.getDeleteItemList()) {
  583. if (outboundItemVO.getItemId() != null) {
  584. //region 将库存需要的参数赋值
  585. outboundItemVO.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  586. outboundItemVO.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  587. //endregion
  588. OutboundItem outboundItem = outboundItemConvert.convertToPo(outboundItemVO);
  589. outboundItem.setFlgValid(false);
  590. //修改
  591. outboundItemMapper.update(outboundItem,
  592. new UpdateWrapper<OutboundItem>().lambda()
  593. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  594. );
  595. }
  596. }
  597. }
  598. //endregion
  599. //region 编辑总单
  600. BigDecimal sumOutQty = outboundVO.getItemList().stream().map(OutboundItemVO::getOutQty).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(6, BigDecimal.ROUND_HALF_UP);
  601. BigDecimal sumOutAmt = outboundVO.getItemList().stream().map(OutboundItemVO::getOutAmt).reduce(BigDecimal.ZERO, BigDecimal::add).setScale(2, BigDecimal.ROUND_HALF_UP);
  602. outboundVO.setOutQty(sumOutQty);
  603. outboundVO.setOutAmt(sumOutAmt);
  604. outboundVO.setOutingQty(BigDecimal.ZERO);
  605. outboundVO.setOutingAmt(BigDecimal.ZERO);
  606. //出库状态
  607. String outStatus = this.setOutStatus(outboundVO.getOutingQty(), outboundVO.getOutQty());
  608. outboundVO.setOutStatus(outStatus);
  609. //实体转换
  610. Outbound outbound = outboundConvert.convertToPo(outboundVO);
  611. //修改
  612. outboundMapper.update(outbound,
  613. new UpdateWrapper<Outbound>().lambda()
  614. .eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
  615. );
  616. //endregion
  617. //region 修改库存
  618. Map<String, Object> map = new HashMap<>();
  619. map.put("outDetail", outboundVO.getItemList());
  620. map.put("delOutDetail", outboundVO.getDeleteItemList());
  621. inventoryService.operatingInventoryInformation(map);
  622. //endregion
  623. return ResponseResultUtil.success(outboundVO);
  624. }
  625. /**
  626. * @desc : 其他出库撤销
  627. * @date : 2024/3/7 17:06
  628. * @author : 寇珊珊
  629. */
  630. @Transactional(rollbackFor = {Exception.class})
  631. public ResponseResultVO<?> otherOutboundCancel(OutboundVO outboundVO) {
  632. //region 查询出库总单数据信息
  633. OutboundResponse outboundResponse = outboundMapper.selectById(outboundVO.getOutId());
  634. //endregion
  635. //region 修改总单数据信息
  636. Outbound outbound = new Outbound();
  637. outbound.setOutId(outboundVO.getOutId());
  638. outbound.setOutDate(null);
  639. outbound.setOutStatus(Constant.OutStatus.CHUKUZHONG.getName());
  640. outbound.setOutingQty(outboundResponse.getOutingQty().add(outboundResponse.getOutQty()));
  641. outbound.setOutingAmt(outboundResponse.getOutingAmt().add(outboundResponse.getOutAmt()));
  642. outbound.setOutQty(BigDecimal.ZERO);
  643. outbound.setOutAmt(BigDecimal.ZERO);
  644. //修改
  645. outboundMapper.update(outbound,
  646. new UpdateWrapper<Outbound>().lambda()
  647. .eq(Outbound::getOutId, UUID.fromString(outbound.getOutId()))
  648. );
  649. //endregion
  650. //region 明细数据
  651. //根据总单id查明细
  652. List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(outboundVO.getOutId()));
  653. for (OutboundItemResponse outboundItemResponse : outboundItemResponseList) {
  654. //region 将库存需要的参数赋值
  655. outboundItemResponse.setInventoryType(Constant.InventoryType.OUTBOUND.getName());
  656. outboundItemResponse.setInventoryDocCode(Constant.InventoryDocCode.OTHER_OUTBOUND.getValue());
  657. outboundItemResponse.setOutQty(outboundItemResponse.getOutQty().negate());
  658. outboundItemResponse.setOutAmt(outboundItemResponse.getOutAmt().negate());
  659. //endregion
  660. //region修改出库明细信息
  661. OutboundItem outboundItem = new OutboundItem();
  662. outboundItem
  663. .setOutId(outboundResponse.getOutId())
  664. .setOutStatus(Constant.OutStatus.CHUKUZHONG.getName())
  665. .setOutingQty(outboundItemResponse.getOutingQty().add(outboundItemResponse.getOutQty()))
  666. .setOutAmt(outboundItemResponse.getOutingAmt().add(outboundItemResponse.getOutAmt()))
  667. .setOutQty(BigDecimal.ZERO)
  668. .setOutAmt(BigDecimal.ZERO)
  669. .setItemId(outboundItemResponse.getItemId())
  670. .setCostPrice(BigDecimal.ZERO)
  671. .setCostAmt(BigDecimal.ZERO)
  672. ;
  673. //修改
  674. outboundItemMapper.update(outboundItem,
  675. new UpdateWrapper<OutboundItem>().lambda()
  676. .eq(OutboundItem::getItemId, UUID.fromString(outboundItem.getItemId()))
  677. );
  678. //endregion
  679. }
  680. //endregion
  681. //region 修改库存
  682. Map<String, Object> map = new HashMap<>();
  683. map.put("delOutDetail", outboundItemResponseList);
  684. inventoryService.operatingInventoryInformation(map);
  685. //endregion
  686. return ResponseResultUtil.success();
  687. }
  688. /**
  689. * @desc : 出库状态通用(目前本页面)
  690. * @date : 2024/3/9 8:59
  691. * @author : 寇珊珊
  692. */
  693. @Transactional(rollbackFor = {Exception.class})
  694. public String setOutStatus(BigDecimal outingQty, BigDecimal outQty) {
  695. //出库状态
  696. String outStatus = null;
  697. //已出库数量<0 出库中数量<0
  698. if (outQty.compareTo(BigDecimal.ZERO) >= 0 && outingQty.compareTo(BigDecimal.ZERO) < 0) {
  699. //出库中
  700. outStatus = Constant.OutStatus.CHUKUZHONG.getName();
  701. }
  702. //出出库数量=0 出库中数量=0
  703. else if (outQty.compareTo(BigDecimal.ZERO) == 0 && outingQty.compareTo(BigDecimal.ZERO) == 0) {
  704. //待出库
  705. outStatus = Constant.OutStatus.DAICHUKU.getName();
  706. }
  707. //已出库数量<0 出库中数量=0
  708. else if (outQty.compareTo(BigDecimal.ZERO) > 0 && outingQty.compareTo(BigDecimal.ZERO) == 0) {
  709. //已出库
  710. outStatus = Constant.OutStatus.YICHUKU.getName();
  711. }
  712. return outStatus;
  713. }
  714. /**
  715. * @desc : 获取单据信息(编辑用)
  716. * @date : 2024/3/16 16:28
  717. * @author : 寇珊珊
  718. */
  719. public ResponseResultVO<?> selectByUpdate(String id) {
  720. Map<String, Object> dataInfo = new HashMap<>();
  721. //总单
  722. OutboundResponse outboundResponse = outboundMapper.selectMessageByOtherQuery(new OutboundQuery().setOutId(id).setOutStatus(Constant.OutStatus.CHUKUZHONG.getName()));
  723. //单据不存在
  724. if (outboundResponse == null) {
  725. throw new BaseBusinessException(ErrorCodeEnum.THERE_ORDER_IS_NOT_CAN_OUTBOUND_QUANTITY.getCode(),
  726. ErrorCodeEnum.THERE_ORDER_IS_NOT_CAN_OUTBOUND_QUANTITY.getMessage());
  727. }
  728. dataInfo.put("data", outboundResponse);
  729. // 明细
  730. List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectByCond(new OutboundItemQuery().setOutId(outboundResponse.getOutId()));
  731. dataInfo.put("dataItem", outboundItemResponseList);
  732. return ResponseResultUtil.success(dataInfo);
  733. }
  734. /**
  735. * @desc : 条件查询 --- web端入库办理用
  736. * @date : 2024/3/23 9:24
  737. * @author : 寇珊珊
  738. */
  739. @Pagination
  740. public ResponseResultVO<PageList<InboundResponse>> selectOutbound(OutboundQuery outboundQuery) {
  741. return super.mergeListWithCount(outboundQuery, outboundMapper.selectOutbound(outboundQuery),
  742. outboundMapper.selectOutboundCond(outboundQuery));
  743. }
  744. /**
  745. * @desc : 查询明细查询 --- web端入库办理用
  746. * @date : 2024/3/9 15:43
  747. * @author : 寇珊珊
  748. */
  749. public ResponseResultVO<Map<String, Object>> selectOutboundItem(String id) {
  750. Map<String, Object> result = new HashMap<>();
  751. // 商品明细
  752. List<OutboundItemResponse> outboundItemResponseList = outboundItemMapper.selectOutboundItem(new OutboundItemQuery().setOutId(id));
  753. result.put("itemList", outboundItemResponseList);
  754. // 收款
  755. // 附件
  756. return ResponseResultUtil.success(result);
  757. }
  758. /**
  759. * @desc : 条件查询 --- web端入库办理用(小程序汇总条数)
  760. * @date : 2024/4/9 9:24
  761. * @author : 周兴
  762. */
  763. @Pagination
  764. public ResponseResultVO<?> selectWaitOutboundCount(OutboundQuery outboundQuery) {
  765. return ResponseResultUtil.success(outboundMapper.selectOutboundCond(outboundQuery));
  766. }
  767. }