From 2be9b7f9c675e6ffe64adfac0a3e37f30404af99 Mon Sep 17 00:00:00 2001
From: cuilei <ray_tsu1@163.com>
Date: 星期三, 11 六月 2025 10:35:58 +0800
Subject: [PATCH] 工具管理-刀具准备单功能接口开发
---
lxzn-module-tms/src/main/java/org/jeecg/modules/tms/service/impl/OutboundOrderServiceImpl.java | 256 +++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 225 insertions(+), 31 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..cc05fae 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
@@ -30,10 +30,8 @@
import org.jeecg.modules.tms.entity.dto.OutBoundOrderFlowDto;
import org.jeecg.modules.tms.entity.dto.OutBoundRequestDto;
import org.jeecg.modules.tms.entity.dto.OutboundOrderAndDetailDto;
-import org.jeecg.modules.tms.enums.OutBillStatus;
-import org.jeecg.modules.tms.enums.OutBoundStatusEnum;
-import org.jeecg.modules.tms.enums.OutStorehouseType;
-import org.jeecg.modules.tms.enums.ToolCirculationStatus;
+import org.jeecg.modules.tms.entity.vo.SelectOutboundToolVo;
+import org.jeecg.modules.tms.enums.*;
import org.jeecg.modules.tms.mapper.OutboundDetailMapper;
import org.jeecg.modules.tms.convert.OutboundOrderConvert;
import org.jeecg.modules.tms.mapper.OutboundOrderMapper;
@@ -67,6 +65,8 @@
private IOutStoreDetailService outStoreDetailService;
@Autowired
private IBaseToolsService baseToolsService;
+ @Autowired
+ private IToolsSharpeningService toolsSharpeningService;
@Autowired
private ISysBusinessCodeRuleService businessCodeRuleService;
@Autowired
@@ -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) {
@@ -154,7 +155,7 @@
//鍒犻櫎鎵�鏈夋槑缁�
outboundDetailService.remove(new LambdaQueryWrapper<OutboundDetail>()
.eq(OutboundDetail::getOutStorehouseId, outboundOrder.getId()));
- OutboundOrder outboundOrderUpdate = BeanUtil.copyProperties(outboundOrder, OutboundOrder.class);
+ OutboundOrder outboundOrderUpdate = OutboundOrderConvert.INSTANCE.convert(outboundOrder);
outboundOrderMapper.updateById(outboundOrderUpdate);
List<OutboundDetail> detailList = CollectionUtil.newArrayList();
outboundOrder.getOutboundDetailList().forEach(item->{
@@ -165,6 +166,7 @@
}
@Override
+ @Transactional(rollbackFor = Exception.class)
public void submit(String id) {
OutboundOrder outboundOrder = getById(id);
if (outboundOrder == null) {
@@ -173,12 +175,80 @@
if (!Objects.equals(outboundOrder.getOrderStatus(), OutBillStatus.DRAFT.getValue())) {
throw new JeecgBootException("鏃犳硶鎻愪氦闈炶崏绋跨姸鎬佺殑鍑哄簱鐢宠鍗曪紒");
}
+ if (!OutStorehouseType.PREPARATION_OUTBOUND.getValue().equals(outboundOrder.getOutStorehouseType())) {
+ //涓嶆槸浠庡噯澶囧崟杞叆鐨勫嚭搴撶敵璇凤紝鎵ц閿佸簱
+ 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());
+ BaseTools tools = baseToolsService.getById(toolCode);
+ if (CollectionUtil.isEmpty(ledgerDetailList)) {
+ throw new JeecgBootException("缂栫爜涓恒��" + tools.getToolCode() + "銆戠殑宸ュ叿锛屽簱瀛樹笉瓒筹紒");
+ } else {
+ ToolLedgerDetail toolLedgerDetail = ledgerDetailList.get(0);
+ if (toolLedgerDetail.getQuantity().compareTo(detail.getOutboundQuantity()) < 0) {
+ throw new JeecgBootException("缂栫爜涓恒��" + tools.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 +305,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
@@ -265,22 +387,32 @@
Map<String, ToolLedger> toolLedgerMap = toolLedgerService.list(new LambdaQueryWrapper<ToolLedger>().in(ToolLedger::getToolId, toolIdList)).stream()
.collect(Collectors.toMap(ToolLedger::getToolId, item -> item, (k1, k2) -> k1));
- LambdaQueryWrapper<ToolLedgerDetail> queryWrapper = new LambdaQueryWrapper<>();
+ LambdaQueryWrapper<ToolLedgerDetail> ledgerDetailQueryWrapper = new LambdaQueryWrapper<>();
+ LambdaQueryWrapper<ToolSharpening> toolSharpenQueryWrapper = new LambdaQueryWrapper<>();
for (int i = 0; i < outboundDetailList.size(); i++) {
if (i > 0) {
- queryWrapper.or();
+ ledgerDetailQueryWrapper.or();
+ toolSharpenQueryWrapper.or();
}
OutboundDetail detail = outboundDetailList.get(i);
- queryWrapper.or(wrapper ->
+ ledgerDetailQueryWrapper.or(wrapper ->
wrapper.eq(ToolLedgerDetail::getToolCode, detail.getToolCode())
.eq(ToolLedgerDetail::getToolId, detail.getToolId()) //濡傛灉涓嶇鍒版妸锛岃瀛楁涓虹┖
);
+ toolSharpenQueryWrapper.or(wrapper ->
+ wrapper.eq(ToolSharpening::getToolCode, detail.getToolCode())
+ .eq(ToolSharpening::getToolId, detail.getToolId())
+ .eq(ToolSharpening::getSharpeningStatus, SharpenStatus.PENDING.getValue())
+ );
}
- List<ToolLedgerDetail> toolLedgerDetailList = toolLedgerDetailService.list(queryWrapper);
+ List<ToolLedgerDetail> toolLedgerDetailList = toolLedgerDetailService.list(ledgerDetailQueryWrapper);
+ List<ToolSharpening> toolSharpeningList = toolsSharpeningService.list(toolSharpenQueryWrapper);
+
List<ToolLedger> toolLedgerUpdateList = CollectionUtil.newArrayList();
List<ToolLedgerDetail> toolLedgerDetailUpdateList = CollectionUtil.newArrayList();
List<OutStoreDetail> outStoreAddList = CollectionUtil.newArrayList();
List<OutboundDetail> outboundDetailUpdateList = CollectionUtil.newArrayList();
+ List<ToolSharpening> toolSharpeningUpdateList = CollectionUtil.newArrayList();
for (OutboundDetail detail : outboundDetailList) {
//鏇存柊搴撳瓨鍙拌处
@@ -308,29 +440,33 @@
//鏇存柊鍙拌处鏄庣粏
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);
});
+
+ if (outStorehouseType == OutStorehouseType.GRINDING_OUTBOUND) {
+ //鏇存柊鍒冪（鍗曠姸鎬�
+ toolSharpeningList.stream().filter(item -> item.getToolCode().equals(detail.getToolCode()) && item.getToolId().equals(detail.getToolId()))
+ .findFirst().ifPresent(item -> {
+ item.setSharpeningStatus(SharpenStatus.IN_PROGRESS.getValue());
+ toolSharpeningUpdateList.add(item);
+ });
+ }
//璁板綍鍑哄簱娴佹按
OutStoreDetail outStoreDetail = new OutStoreDetail()
@@ -357,6 +493,7 @@
toolLedgerDetailService.updateBatchById(toolLedgerDetailUpdateList);
outStoreDetailService.saveBatch(outStoreAddList);
outboundDetailService.updateBatchById(outboundDetailUpdateList);
+ toolsSharpeningService.updateBatchById(toolSharpeningUpdateList);
//鏇存柊鐢宠鍗�
boolean allMatch = outboundDetailService.list(new LambdaQueryWrapper<OutboundDetail>()
@@ -418,7 +555,10 @@
.toMap(OutBoundAddDto::getToolLedgerDetailId, item -> item, (k1, k2) -> k1));
Map<String, ToolLedgerDetail> toolLedgerDetailMap = toolLedgerDetailService.listByIds(boundAddDtoMap.keySet()).stream()
.collect(Collectors.toMap(ToolLedgerDetail::getId, item -> item, (k1, k2) -> k1));
+ List<ToolSharpening> toolSharpeningList = toolsSharpeningService.list(new LambdaQueryWrapper<ToolSharpening>()
+ .in(ToolSharpening::getToolCode, toolBoundQuantityMap.keySet()).eq(ToolSharpening::getSharpeningStatus, SharpenStatus.PENDING.getValue()));
List<ToolLedgerDetail> toolLedgerDetailUpdateList = CollectionUtil.newArrayList();
+ List<ToolSharpening> toolSharpeningUpdateList = CollectionUtil.newArrayList();
for (String toolLedgerDetailId : boundAddDtoMap.keySet()) {
OutBoundAddDto outBoundAddDto = boundAddDtoMap.get(toolLedgerDetailId);
BigDecimal outboundQuantity = outBoundAddDto.getOutboundQuantity();
@@ -447,6 +587,12 @@
break;
case GRINDING_OUTBOUND:
toolLedgerDetail.setStatus(ToolCirculationStatus.GRINDING.getValue());
+ //鍚屾椂鏇存柊鍒冪（鍗曠姸鎬�
+ toolSharpeningList.stream().filter(item -> item.getToolCode().equals(outBoundAddDto.getToolCode())
+ && item.getToolId().equals(outBoundAddDto.getToolId())).findFirst().ifPresent(item -> {
+ item.setSharpeningStatus(SharpenStatus.IN_PROGRESS.getValue());
+ toolSharpeningUpdateList.add(item);
+ });
break;
default:
throw new JeecgBootException("鏈煡鐨勫嚭搴撶被鍨嬶紒");
@@ -457,6 +603,7 @@
}
toolLedgerService.updateBatchById(toolLedgerUpdateList);
toolLedgerDetailService.updateBatchById(toolLedgerDetailUpdateList);
+ toolsSharpeningService.updateBatchById(toolSharpeningUpdateList);
//璁板綍鍑哄簱娴佹按
List<OutStoreDetail> outStoreAddList = CollectionUtil.newArrayList();
for (OutBoundAddDto outBoundAddDto : boundAddList) {
@@ -472,6 +619,53 @@
outStoreDetailService.saveBatch(outStoreAddList);
}
+ @Override
+ public IPage<SelectOutboundToolVo> querySharpenOutboundToolPageList(Page<SelectOutboundToolVo> page, Map<String, String[]> parameterMap) {
+ QueryWrapper<SelectOutboundToolVo> queryWrapper = Wrappers.query();
+ String[] toolCodes = parameterMap.get("toolCode");
+ if (toolCodes != null && toolCodes.length > 0) {
+ queryWrapper.like("t3.tool_code", toolCodes[0]);
+ }
+ String[] classifyIds = parameterMap.get("classifyId");
+ if (classifyIds != null && classifyIds.length > 0) {
+ queryWrapper.eq("t3.classify_id", classifyIds[0]);
+ }
+ String[] excludeIds = parameterMap.get("excludeIds");
+ if (excludeIds != null && excludeIds.length > 0) {
+ String[] idArray = excludeIds[0].split(",");
+ queryWrapper.notIn("t1.id", idArray);
+ }
+ queryWrapper.eq("t1.sharpening_status", SharpenStatus.PENDING.getValue());
+ return this.baseMapper.querySharpenOutboundToolPageList(page, queryWrapper);
+ }
+
+ @Override
+ public IPage<SelectOutboundToolVo> queryBorrowOutboundToolPageList(Page<SelectOutboundToolVo> page, Map<String, String[]> parameterMap) {
+ QueryWrapper<SelectOutboundToolVo> queryWrapper = Wrappers.query();
+ String[] toolCodes = parameterMap.get("toolCode");
+ if (toolCodes != null && toolCodes.length > 0) {
+ queryWrapper.like("p.tool_code", toolCodes[0]);
+ }
+ String[] statuses = parameterMap.get("status");
+ if (statuses != null && statuses.length > 0) {
+ queryWrapper.eq("t.status", statuses[0]);
+ }
+ String[] quantities = parameterMap.get("quantity");
+ if (quantities != null && quantities.length > 0) {
+ queryWrapper.gt("t.quantity", quantities[0]);
+ }
+ String[] classifyIds = parameterMap.get("classifyId");
+ if (classifyIds != null && classifyIds.length > 0) {
+ queryWrapper.eq("p.classify_id", classifyIds[0]);
+ }
+ String[] excludeIds = parameterMap.get("excludeIds");
+ if (excludeIds != null && excludeIds.length > 0) {
+ String[] idArray = excludeIds[0].split(",");
+ queryWrapper.notIn("t.id", idArray);
+ }
+ return this.baseMapper.queryBorrowOutboundToolPageList(page, queryWrapper);
+ }
+
private boolean fromOneApply(List<OutBoundRequestDto> outBoundRequestList) {
long count = outBoundRequestList.stream().map(OutBoundRequestDto::getOutBoundOrderId).distinct().count();
--
Gitblit v1.9.3