From 22c2dcfdcdd0e4eddbfe3429a75b69cf61a9d0ff Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期五, 09 九月 2022 10:04:27 +0800
Subject: [PATCH] 产品设定可行性
---
src/main/java/com/whyc/service/ProductHistoryService.java | 55 +++++++++++++++++++++++++++++++++++++++----------------
1 files changed, 39 insertions(+), 16 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductHistoryService.java b/src/main/java/com/whyc/service/ProductHistoryService.java
index 20af35b..33e16da 100644
--- a/src/main/java/com/whyc/service/ProductHistoryService.java
+++ b/src/main/java/com/whyc/service/ProductHistoryService.java
@@ -4,10 +4,15 @@
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.whyc.dto.Response;
+import com.whyc.mapper.ProductBomHistoryMapper;
+import com.whyc.mapper.ProductBomMapper;
import com.whyc.mapper.ProductHistoryMapper;
import com.whyc.mapper.ProductMapper;
import com.whyc.pojo.Product;
+import com.whyc.pojo.ProductBom;
+import com.whyc.pojo.ProductBomHistory;
import com.whyc.pojo.ProductHistory;
+import org.apache.poi.hssf.record.ProtectionRev4Record;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -18,11 +23,15 @@
public class ProductHistoryService {
@Autowired(required = false)
private ProductHistoryMapper mapper;
+
@Autowired(required = false)
private ProductMapper productMapper;
+ @Autowired(required = false)
+ private ProductBomMapper productBomMapper;
-
+ @Autowired(required = false)
+ private ProductBomHistoryMapper productBomHistoryMapper;
//浜у搧璇︽儏鏌ョ湅鐗堟湰淇℃伅
public Response getProductVersion(String parentCode,String customCode) {
@@ -74,7 +83,6 @@
UpdateWrapper wrapper=new UpdateWrapper();
wrapper.eq("parent_code",parentCode);
wrapper.eq("custom_code",customCode);
-
int flag=0;
if(enabled==1){
//鍏堝皢鎵�鏈夌殑閿佸畾
@@ -88,26 +96,27 @@
QueryWrapper qWrapper=new QueryWrapper();
qWrapper.eq("parent_code",parentCode);
qWrapper.eq("custom_code",customCode);
- //灏嗛�変腑鐨勭増鏈殑鍘嗗彶淇℃伅鏌ヨ鍑烘潵
+ //1.鏌ヨ褰撳墠product涓殑淇℃伅
+ Product product=productMapper.selectOne(qWrapper);
+ //2.灏嗛�変腑鐨勭増鏈殑鍘嗗彶淇℃伅鏌ヨ鍑烘潵
qWrapper.eq("version",version);
ProductHistory pHistory=mapper.selectOne(qWrapper);
- //prodcut涓垹闄ゆ棫鐨勪骇鍝佷俊鎭�
+ //3:prodcut涓垹闄ゆ棫鐨勪骇鍝佷俊鎭�
UpdateWrapper deleteWrapper=new UpdateWrapper();
deleteWrapper.eq("parent_code",parentCode);
deleteWrapper.eq("custom_code",customCode);
productMapper.delete(deleteWrapper);
- //鍐嶅湪product涓煡璇㈣瀹氬彲鐢ㄧ殑pHistory
+ //4.productBom涓垹闄ゆ棫鐨勪俊鎭�
+ if(product!=null){
+ UpdateWrapper bomWrapper=new UpdateWrapper();
+ bomWrapper.eq("product_id",product.getId());
+ productBomMapper.delete(bomWrapper);
+ }
if(pHistory!=null){
- Product product=new Product();
- product.setId(pHistory.getId());
- product.setParentCode(pHistory.getParentCode());
- product.setParentName(pHistory.getParentName());
- product.setParentModel(pHistory.getParentModel());
- product.setCustomCode(pHistory.getCustomCode());
- product.setCreateTime(pHistory.getCreateTime());
- product.setVersionTime(pHistory.getVersionTime());
- product.setVersion(pHistory.getVersion());
- productMapper.insert(product);
+ // 5.鍦╬roduct涓彃鍏ヨ瀹氬彲鐢ㄧ殑pHistory
+ productMapper.insertPselectPH(pHistory.getId());
+ //6.鍦╬roductBom涓彃鍏HsitoryBom鏌ヨ鍑虹殑鏁版嵁
+ productBomMapper.insertBomSelectBomH(pHistory.getId());
}
}
}else{
@@ -115,11 +124,25 @@
wrapper.set("enabled",0);
flag=mapper.update(null,wrapper);
if(flag>0){
- //prodcut涓垹闄ゆ棫鐨勪骇鍝佷俊鎭�
+ QueryWrapper qWrapper=new QueryWrapper();
+ qWrapper.eq("parent_code",parentCode);
+ qWrapper.eq("custom_code",customCode);
+ //1.鏌ヨ褰撳墠product涓殑淇℃伅
+ Product product=productMapper.selectOne(qWrapper);
+
+ //2.prodcut涓垹闄ゆ棫鐨勪骇鍝佷俊鎭�
UpdateWrapper deleteWrapper=new UpdateWrapper();
deleteWrapper.eq("parent_code",parentCode);
deleteWrapper.eq("custom_code",customCode);
productMapper.delete(deleteWrapper);
+
+ //3.鍒犻櫎productBom
+ if(product!=null){
+ UpdateWrapper bomWrapper=new UpdateWrapper();
+ bomWrapper.eq("product_id",product.getId());
+ productBomMapper.delete(bomWrapper);
+ }
+
}
}
--
Gitblit v1.9.1