From 6291e5799cf5165cd966a3923b1c70e2cd2621a8 Mon Sep 17 00:00:00 2001
From: cuilei <ray_tsu1@163.com>
Date: 星期五, 30 五月 2025 22:35:00 +0800
Subject: [PATCH] 工具管理-增加出库申请提交锁库、审批驳回释放锁库逻辑
---
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java | 166 +++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 141 insertions(+), 25 deletions(-)
diff --git a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java
index 42815df..221f064 100644
--- a/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java
+++ b/lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java
@@ -134,7 +134,8 @@
}
String[] outStatuses = parameterMap.get("outStatus");
if (outStatuses != null && outStatuses.length > 0) {
- queryWrapper.eq("t.out_status", outStatuses[0]);
+ String[] statusArr = outStatuses[0].split(",");
+ queryWrapper.in("t.out_status", statusArr);
}
String[] startTimes = parameterMap.get("startTime");
if (startTimes != null && startTimes.length > 0) {
@@ -165,6 +166,7 @@
}
@Override
+ @Transactional(rollbackFor = Exception.class)
public void submit(String id) {
OutboundOrder outboundOrder = getById(id);
if (outboundOrder == null) {
@@ -173,12 +175,79 @@
if (!Objects.equals(outboundOrder.getOrderStatus(), OutBillStatus.DRAFT.getValue())) {
throw new JeecgBootException("鏃犳硶鎻愪氦闈炶崏绋跨姸鎬佺殑鍑哄簱鐢宠鍗曪紒");
}
- //鍚姩娴佺▼
- if (triggerProcess(outboundOrder)) {
- outboundOrder.setOrderStatus(OutBillStatus.SUBMITTED.getValue());
+ //閿佸畾鐢宠鍗曟槑缁嗕腑宸ュ叿搴撳瓨
+ if (lockOutboundStock(id)) {
+ //鍚姩娴佺▼
+ if (triggerProcess(outboundOrder)) {
+ outboundOrder.setOrderStatus(OutBillStatus.SUBMITTED.getValue());
+ updateById(outboundOrder);
+ }
}
- updateById(outboundOrder);
}
+
+ private boolean lockOutboundStock(String id) {
+ List<OutboundDetail> outboundDetailList = outboundDetailService.list(new LambdaQueryWrapper<OutboundDetail>()
+ .eq(OutboundDetail::getOutStorehouseId, id));
+
+ LambdaQueryWrapper<ToolLedgerDetail> queryWrapper = new LambdaQueryWrapper<>();
+ for (int i = 0; i < outboundDetailList.size(); i++) {
+ if (i > 0) {
+ queryWrapper.or();
+ }
+ OutboundDetail detail = outboundDetailList.get(i);
+ queryWrapper.or(wrapper ->
+ wrapper.eq(StrUtil.isNotBlank(detail.getToolCode()), ToolLedgerDetail::getToolCode, detail.getToolCode())
+ .eq(StrUtil.isNotBlank(detail.getToolId()), ToolLedgerDetail::getToolId, detail.getToolId()) //濡傛灉涓嶇鍒版妸锛岃瀛楁涓虹┖
+ );
+ }
+ List<ToolLedgerDetail> toolLedgerDetailList = toolLedgerDetailService.list(queryWrapper);
+ List<ToolLedgerDetail> toolLedgerDetailUpdateList = CollectionUtil.newArrayList();
+ for (OutboundDetail detail : outboundDetailList) {
+ String toolCode = detail.getToolCode();
+ List<ToolLedgerDetail> ledgerDetailList = toolLedgerDetailList.stream().filter(item -> Objects.equals(item.getToolCode(), toolCode)
+ && Objects.equals(item.getToolId(), detail.getToolId())).collect(Collectors.toList());
+ if (CollectionUtil.isEmpty(ledgerDetailList)) {
+ BaseTools tools = baseToolsService.getById(toolCode);
+ throw new JeecgBootException("缂栫爜涓恒��" + tools.getToolCode() + "銆戠殑宸ュ叿锛屽簱瀛樹笉瓒筹紒");
+ } else {
+ ToolLedgerDetail toolLedgerDetail = ledgerDetailList.get(0);
+ if (toolLedgerDetail.getQuantity().compareTo(detail.getOutboundQuantity()) < 0) {
+ throw new JeecgBootException("缂栫爜涓恒��" + toolLedgerDetail.getToolCode() + "銆戠殑宸ュ叿锛屽簱瀛樹笉瓒筹紒");
+ } else {
+ //鎵ｅ噺鍙拌处鏄庣粏涓殑搴撳瓨锛屾墽琛岄攣搴�
+ if (StrUtil.isBlank(detail.getToolId())) {
+ //绠″埌绫荤殑鍒�鍏�
+ toolLedgerDetail.setQuantity(toolLedgerDetail.getQuantity().subtract(detail.getOutboundQuantity()));
+ } else {
+ //绠″埌鎶婄殑鍒�鍏凤紝鏁伴噺鍙湁 0鍜�1
+ toolLedgerDetail.setQuantity(BigDecimal.ZERO);
+ }
+ toolLedgerDetailUpdateList.add(toolLedgerDetail);
+ }
+ }
+ }
+
+ Map<String, BigDecimal> outToolCodeQuantityMap = outboundDetailList.stream().collect(Collectors.groupingBy(OutboundDetail::getToolCode,
+ Collectors.mapping(OutboundDetail::getOutboundQuantity, Collectors.reducing(BigDecimal.ZERO, BigDecimal::add))));
+ Map<String, ToolLedger> toolLedgerMap = toolLedgerService.list(new LambdaQueryWrapper<ToolLedger>().in(ToolLedger::getToolId, outToolCodeQuantityMap.keySet()))
+ .stream().collect(Collectors.toMap(ToolLedger::getToolId, toolLedger -> toolLedger, (k1, k2) -> k1));
+ List<ToolLedger> toolLedgerUpdateList = CollectionUtil.newArrayList();
+ for (String toolCode : outToolCodeQuantityMap.keySet()) {
+ BigDecimal outQuantity = outToolCodeQuantityMap.get(toolCode);
+ ToolLedger toolLedger = toolLedgerMap.get(toolCode);
+ BaseTools tools = baseToolsService.getById(toolCode);
+ if (Objects.isNull(toolLedger) || toolLedger.getAvailableCount().compareTo(outQuantity) < 0) {
+ throw new JeecgBootException("缂栫爜涓恒��" + tools.getToolCode() + "銆戠殑宸ュ叿锛屽簱瀛樹笉瓒筹紒");
+ } else {
+ //鎵ｅ噺鍙拌处涓昏〃涓殑鍙敤瀛樺簱锛屾墽琛岄攣搴�
+ toolLedger.setAvailableCount(toolLedger.getAvailableCount().subtract(outQuantity));
+ toolLedgerUpdateList.add(toolLedger);
+ }
+ }
+ toolLedgerDetailService.updateBatchById(toolLedgerDetailUpdateList);
+ toolLedgerService.updateBatchById(toolLedgerUpdateList);
+ return true;
+ }
@Transactional(rollbackFor = Exception.class)
@Override
@@ -235,11 +304,63 @@
if (OutBillStatus.REJECTED.getValue().equals(outBoundOrderFlowDto.getStatus())) {
//濡傛灉椹冲洖锛屽鎵瑰崟鐘舵�佸洖鍒拌崏绋�
outboundOrder.setOrderStatus(OutBillStatus.DRAFT.getValue());
+ //閲婃斁鐢宠鍗曚腑閿佸畾鐨勫簱瀛�
+ releaseStock(outboundOrder);
}
outboundOrder.setAuditDate(new Date());
outboundOrder.setApprovalOpinion(outBoundOrderFlowDto.getApprovalOpinion());
updateById(outboundOrder);
}
+ }
+
+ private void releaseStock(OutboundOrder outboundOrder) {
+ List<OutboundDetail> outboundDetailList = outboundDetailService.list(new LambdaQueryWrapper<OutboundDetail>()
+ .eq(OutboundDetail::getOutStorehouseId, outboundOrder.getId()));
+
+ LambdaQueryWrapper<ToolLedgerDetail> queryWrapper = new LambdaQueryWrapper<>();
+ for (int i = 0; i < outboundDetailList.size(); i++) {
+ if (i > 0) {
+ queryWrapper.or();
+ }
+ OutboundDetail detail = outboundDetailList.get(i);
+ queryWrapper.or(wrapper ->
+ wrapper.eq(StrUtil.isNotBlank(detail.getToolCode()), ToolLedgerDetail::getToolCode, detail.getToolCode())
+ .eq(StrUtil.isNotBlank(detail.getToolId()), ToolLedgerDetail::getToolId, detail.getToolId()) //濡傛灉涓嶇鍒版妸锛岃瀛楁涓虹┖
+ );
+ }
+ List<ToolLedgerDetail> toolLedgerDetailList = toolLedgerDetailService.list(queryWrapper);
+ List<ToolLedgerDetail> toolLedgerDetailUpdateList = CollectionUtil.newArrayList();
+ for (OutboundDetail detail : outboundDetailList) {
+ Optional<ToolLedgerDetail> optonal = toolLedgerDetailList.stream().filter(item -> Objects.equals(item.getToolCode(), detail.getToolCode())
+ && Objects.equals(item.getToolId(), detail.getToolId())).findFirst();
+ if (optonal.isPresent()) {
+ ToolLedgerDetail toolLedgerDetail = optonal.get();
+ if (StrUtil.isBlank(detail.getToolId())) {
+ //鍒扮被
+ toolLedgerDetail.setQuantity(toolLedgerDetail.getQuantity().add(detail.getOutboundQuantity()));
+ } else {
+ //鍒版妸
+ toolLedgerDetail.setQuantity(BigDecimal.ONE);
+ }
+ toolLedgerDetailUpdateList.add(toolLedgerDetail);
+ }
+ }
+
+ Map<String, BigDecimal> outToolCodeQuantityMap = outboundDetailList.stream().collect(Collectors.groupingBy(OutboundDetail::getToolCode,
+ Collectors.mapping(OutboundDetail::getOutboundQuantity, Collectors.reducing(BigDecimal.ZERO, BigDecimal::add))));
+ Map<String, ToolLedger> toolLedgerMap = toolLedgerService.list(new LambdaQueryWrapper<ToolLedger>().in(ToolLedger::getToolId, outToolCodeQuantityMap.keySet()))
+ .stream().collect(Collectors.toMap(ToolLedger::getToolId, toolLedger -> toolLedger, (k1, k2) -> k1));
+ List<ToolLedger> toolLedgerUpdateList = new ArrayList<>();
+ for (String baseToolId : outToolCodeQuantityMap.keySet()) {
+ BigDecimal outQuantity = outToolCodeQuantityMap.get(baseToolId);
+ ToolLedger toolLedger = toolLedgerMap.get(baseToolId);
+ if (Objects.nonNull(toolLedger)) {
+ toolLedger.setAvailableCount(toolLedger.getAvailableCount().add(outQuantity));
+ toolLedgerUpdateList.add(toolLedger);
+ }
+ }
+ toolLedgerDetailService.updateBatchById(toolLedgerDetailUpdateList);
+ toolLedgerService.updateBatchById(toolLedgerUpdateList);
}
@Override
@@ -308,26 +429,21 @@
//鏇存柊鍙拌处鏄庣粏
toolLedgerDetailList.stream().filter(item -> item.getToolCode().equals(detail.getToolCode()) && item.getToolId().equals(detail.getToolId()))
.findFirst().ifPresent(item -> {
- if (StrUtil.isNotBlank(item.getToolId())) {
- item.setQuantity(BigDecimal.ZERO);
- switch (outStorehouseType) {
- case TOOL_BORROW:
- item.setStatus(ToolCirculationStatus.BORROWED.getValue());
- break;
- case MAINTENANCE_OUTBOUND:
- item.setStatus(ToolCirculationStatus.REPAIRING.getValue());
- break;
- case CALIBRATION_OUTBOUND:
- item.setStatus(ToolCirculationStatus.INSPECTING.getValue());
- break;
- case GRINDING_OUTBOUND:
- item.setStatus(ToolCirculationStatus.GRINDING.getValue());
- break;
- default:
- throw new JeecgBootException("鏈煡鐨勫嚭搴撶被鍨嬶紒");
- }
- } else {
- item.setQuantity(item.getQuantity().subtract(outboundQuantity));
+ switch (outStorehouseType) {
+ case TOOL_BORROW:
+ item.setStatus(ToolCirculationStatus.BORROWED.getValue());
+ break;
+ case MAINTENANCE_OUTBOUND:
+ item.setStatus(ToolCirculationStatus.REPAIRING.getValue());
+ break;
+ case CALIBRATION_OUTBOUND:
+ item.setStatus(ToolCirculationStatus.INSPECTING.getValue());
+ break;
+ case GRINDING_OUTBOUND:
+ item.setStatus(ToolCirculationStatus.GRINDING.getValue());
+ break;
+ default:
+ throw new JeecgBootException("鏈煡鐨勫嚭搴撶被鍨嬶紒");
}
toolLedgerDetailUpdateList.add(item);
});
--
Gitblit v1.9.3