From 90869d75f496350fcb11587010fef20fba16157b Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期三, 08 四月 2026 14:52:59 +0800
Subject: [PATCH] fix: 新增主生成计划的申请单编号不能重复,报工查看详情数据重复问题
---
src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java | 31 ++++++++++++++++++++++++++-----
src/main/resources/mapper/production/ProductMaterialMapper.xml | 4 +---
2 files changed, 27 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java b/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java
index f5392c0..fcee832 100644
--- a/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java
+++ b/src/main/java/com/ruoyi/productionPlan/service/impl/ProductionPlanServiceImpl.java
@@ -225,6 +225,14 @@
@Override
@Transactional(rollbackFor = Exception.class)
public boolean add(ProductionPlanDto productionPlanDto) {
+ if (StringUtils.isEmpty(productionPlanDto.getApplyNo())) {
+ throw new ServiceException("鏂板澶辫触锛岀敵璇峰崟缂栧彿涓嶈兘涓虹┖");
+ }
+ Long count = productionPlanMapper.selectCount(Wrappers.<ProductionPlan>lambdaQuery()
+ .eq(ProductionPlan::getApplyNo, productionPlanDto.getApplyNo()));
+ if (count > 0) {
+ throw new ServiceException("鏂板澶辫触锛岀敵璇峰崟缂栧彿 " + productionPlanDto.getApplyNo() + " 宸插瓨鍦�");
+ }
productionPlanDto.setDataSourceType(DataSourceTypeEnum.MANUAL.getCode());
productionPlanDto.setStatus(0);
productionPlanMapper.insert(productionPlanDto);
@@ -234,7 +242,7 @@
@Override
@Transactional(rollbackFor = Exception.class)
public boolean update(ProductionPlanDto productionPlanDto) {
- if (productionPlanDto == null) {
+ if (productionPlanDto == null || productionPlanDto.getId() == null) {
throw new ServiceException("缂栬緫澶辫触,鏁版嵁涓嶈兘涓虹┖");
}
ProductionPlan productionPlan = getById(productionPlanDto.getId());
@@ -242,16 +250,29 @@
throw new ServiceException("缂栬緫澶辫触,涓荤敓浜ц鍒掍笉瀛樺湪");
}
+ if (StringUtils.isNotEmpty(productionPlanDto.getApplyNo())
+ && !productionPlanDto.getApplyNo().equals(productionPlan.getApplyNo())) {
+
+ Long count = productionPlanMapper.selectCount(Wrappers.<ProductionPlan>lambdaQuery()
+ .eq(ProductionPlan::getApplyNo, productionPlanDto.getApplyNo())
+ .ne(ProductionPlan::getId, productionPlanDto.getId())); // 鎺掗櫎鑷韩
+
+ if (count > 0) {
+ throw new ServiceException("缂栬緫澶辫触锛岀敵璇峰崟缂栧彿 " + productionPlanDto.getApplyNo() + " 宸茶鍗犵敤");
+ }
+ }
// 宸蹭笅鍙戠姸鎬侊紝涓嶈兘缂栬緫
if (productionPlan.getStatus() != 0) {
throw new BaseException("缂栬緫澶辫触,璇ョ敓浜ц鍒掑凡涓嬪彂鎴栭儴鍒嗕笅鍙戠姸鎬�,绂佹缂栬緫");
}
+
// 鏌ヨ鏄惁鏈夊叧鑱旇鍗�
- boolean hasProductOrderPlan = productOrderPlanMapper.selectList(Wrappers.<ProductOrderPlan>lambdaQuery().eq(ProductOrderPlan::getProductionPlanId, productionPlanDto.getId())).stream().anyMatch(p -> p.getProductOrderId() != null);
+ boolean hasProductOrderPlan = productOrderPlanMapper.selectList(Wrappers.<ProductOrderPlan>lambdaQuery()
+ .eq(ProductOrderPlan::getProductionPlanId, productionPlanDto.getId()))
+ .stream().anyMatch(p -> p.getProductOrderId() != null);
+
if (hasProductOrderPlan) {
- // 濡傛灉鍏宠仈锛屾柟鏁板彧鑳介�掑
- ProductionPlan currentPlan = productionPlanMapper.selectById(productionPlanDto.getId());
- if (productionPlanDto.getVolume().compareTo(currentPlan.getVolume()) < 0) {
+ if (productionPlanDto.getVolume().compareTo(productionPlan.getVolume()) < 0) {
throw new BaseException("鏂规暟涓嶈兘閫掑噺");
}
}
diff --git a/src/main/resources/mapper/production/ProductMaterialMapper.xml b/src/main/resources/mapper/production/ProductMaterialMapper.xml
index 6281790..93f4a8e 100644
--- a/src/main/resources/mapper/production/ProductMaterialMapper.xml
+++ b/src/main/resources/mapper/production/ProductMaterialMapper.xml
@@ -44,9 +44,7 @@
pms.material_code as materialCode,
pms.model
from product_order po
- left join product_order_plan pop on po.id = pop.product_order_id
- left join production_plan pp on pp.id = pop.production_plan_id
- left join product_material_sku pms on pms.id = pop.production_plan_id
+ left join product_material_sku pms on pms.id = po.product_material_sku_id
left join product_material pm on pm.id = pms.product_id
<where>
<choose>
--
Gitblit v1.9.3