From cf9a5039e6db9d1d5963e3fe1a37d00169ec2ef7 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期三, 25 六月 2025 11:18:22 +0800
Subject: [PATCH] 验收报告修改
---
src/main/java/com/whyc/service/WorksheetLinkService.java | 633 +++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 521 insertions(+), 112 deletions(-)
diff --git a/src/main/java/com/whyc/service/WorksheetLinkService.java b/src/main/java/com/whyc/service/WorksheetLinkService.java
index dfcea9f..a93f1d8 100644
--- a/src/main/java/com/whyc/service/WorksheetLinkService.java
+++ b/src/main/java/com/whyc/service/WorksheetLinkService.java
@@ -2,10 +2,14 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.whyc.config.EnumWorksheetType;
+import com.whyc.dto.Response;
import com.whyc.mapper.ProductBomApprovingMapper;
import com.whyc.mapper.WorksheetLinkMapper;
import com.whyc.pojo.*;
import com.whyc.util.CommonUtil;
+import com.whyc.util.FileUtil;
+import com.whyc.util.WordUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -13,10 +17,9 @@
import javax.annotation.Resource;
import java.io.File;
+import java.io.FilenameFilter;
import java.io.IOException;
-import java.util.Date;
-import java.util.LinkedList;
-import java.util.List;
+import java.util.*;
import java.util.stream.Collectors;
@Service
@@ -27,15 +30,51 @@
@Resource
private WorksheetLinkMapper linkMapper;
-
- @Autowired
+ //lxw淇敼
+ @Autowired(required = false)
private ProductBomApprovingMapper approvingMapper;
@Autowired
private ProductBomService bomService;
@Autowired
+ private ProductApprovingService paService;
+
+ @Autowired
+ private ProductService productService;
+
+ @Autowired
private ProductBomHistoryService historyService;
+
+ @Autowired
+ private ProductBomApprovingService pbaService;
+
+ @Autowired
+ private MaterialProductHistoryService mphService;
+
+ @Autowired
+ private MaterialProductApprovingService cpAService;
+
+ @Autowired
+ private MaterialApprovingService mAService;
+
+ @Autowired
+ private MaterialService mService;
+
+ @Autowired
+ private ProductSoftwareApprovingService productSoftwareApprovingService;
+
+ @Autowired
+ private ProductSoftwareService productSoftwareService;
+
+ @Autowired
+ private ProductHistoryService phService;
+
+ @Autowired
+ private ProcedureDocApprovingService procedureDocApprovingService;
+
+ @Autowired
+ private ProcedureDocService procedureDocService;
@Transactional
public void audit(WorksheetLink link) {
@@ -43,8 +82,24 @@
//鏇存柊鑺傜偣淇℃伅
linkMapper.updateById(link);
if(link.getLinkStatus() == 2){ //椹冲洖
+ //鏌ョ湅鏄惁涓虹墿鏂欏鎵�,鏄垯闇�瑕佹洿鏂扮墿鏂欏鎵硅〃涓殑鐘舵�佷负瀹岀粨
+ if(mainService.getInfoById(link.getMainId()).getType().equals(EnumWorksheetType.Material.getType())){
+ mAService.endStatus(link.getMainId());
+ }
//椤圭洰缁忕悊椹冲洖,椹冲洖鍗崇粓姝�
- mainService.updateEndStatusById(link.getMainId(),"缁忕悊椹冲洖",0);
+ mainService.updateEndStatusById(link.getMainId(),"缁忕悊椹冲洖,椹冲洖鍘熷洜:"+link.getDealReason(),0);
+ //椤圭洰缁忕悊椹冲洖鍓�,杩樻浘缁忚繃鎬荤粡鐞�,鍒欓渶瑕佸鍔犳�荤粡鐞嗛┏鍥炲師鍥�
+ if(link.getParentId()!=0) {
+ QueryWrapper<WorksheetLink> query = Wrappers.query();
+ query.eq("id", link.getParentId());
+ WorksheetLink parentLink = linkMapper.selectOne(query);
+ //杩欎釜鏄棤鏁堢殑,鐢ㄦ埛璺熻鑹插姣�,涓嶇,涓嬮潰浠ｇ爜姘镐笉鐢熸晥
+ if (parentLink.getDealUserId() == 1003) {
+ mainService.updateEndStatusById(link.getMainId(),
+ "缁忕悊椹冲洖,椹冲洖鍘熷洜:" + link.getDealReason() + ";鎬荤粡鐞嗛┏鍥�,椹冲洖鍘熷洜:" + parentLink.getDealReason(),
+ 0);
+ }
+ }
}else{
//杩涘叆涓嬩竴鑺傜偣,鎬荤粡鐞嗗鎵�
WorksheetLink link2 = new WorksheetLink();
@@ -55,7 +110,6 @@
link2.setDealDesc("宸ュ崟琚粡鐞嗗鏍搁�氳繃,淇℃伅:"+link.getDealReason());
link2.setLinkStatus(0);
link2.setEnableArchive(1);
- link2.setRejectVersion(link.getRejectVersion());
linkMapper.insert(link2);
//鏇存柊涓昏〃鐘舵��
mainService.updateStatusById(link.getMainId(),2);
@@ -64,6 +118,8 @@
@Transactional
public void approve(WorksheetLink link) {
+ //鏍规嵁鑺傜偣,鏌ヨ涓昏〃绫诲瀷
+ Integer type = mainService.getInfoById(link.getMainId()).getType();
link.setDealTime(new Date());
//鏇存柊鑺傜偣淇℃伅
linkMapper.updateById(link);
@@ -79,132 +135,428 @@
link2.setDealDesc("宸ュ崟琚�荤粡鐞嗛┏鍥�,椹冲洖淇℃伅:" + link.getDealReason());
link2.setLinkStatus(0);
link2.setEnableArchive(0);
- link2.setRejectVersion(link.getRejectVersion());
linkMapper.insert(link2);
//鏇存柊涓昏〃鐘舵��
mainService.updateStatusById(link.getMainId(), 1);
}else{
//璇存槑鏄」鐩粡鐞嗘彁浜ょ殑,椹冲洖鍗崇粓姝�
- mainService.updateEndStatusById(link.getMainId(),"鎬荤粡鐞嗛┏鍥�",0);
+ mainService.updateEndStatusById(link.getMainId(),"鎬荤粡鐞嗛┏鍥�,椹冲洖鍘熷洜:"+link.getDealReason(),0);
}
- }else{
+ }else {
//瀹℃壒閫氳繃,鏇存柊涓昏〃鐘舵��
- mainService.updateEndStatusById(link.getMainId(),"瀹岀粨",5);
- //灏嗕骇鍝佹枃浠跺鍒惰嚦姝ｅ紡璺緞
- QueryWrapper<ProductBomApproving> query = Wrappers.query();
- query.eq("main_id",link.getMainId());
- List<ProductBomApproving> approvingList = approvingMapper.selectList(query);
+ mainService.updateEndStatusById(link.getMainId(), "瀹岀粨", 5);
+ if (type.intValue() == EnumWorksheetType.ProductBom.getType()) { //浜у搧瀹℃壒
- //澧炲姞->澧炲姞閮ㄤ欢(澧炲姞璁板綍,鍚屾椂鎵�鏈塭Version+1)
- //淇敼->淇敼閮ㄤ欢鍥剧焊,淇敼閮ㄤ欢闈炲浘绾�(澧炲姞璁板綍,鍚屾椂淇敼闈炲師閮ㄤ欢鐨勬墍鏈塭Version+1)
- //鍒犻櫎? TODO 闇�瑕佺害瀹氶�昏緫
+ ProductApproving productApproving = paService.getByMainId(link.getMainId());
+ List<ProductBomApproving> approvingList = pbaService.getList(productApproving.getId());
+ //鏌ヨ浜у搧鏈�鏂扮殑鐗堟湰鍙�
+ String parentModel = productApproving.getParentModel();
+ String parentCode = productApproving.getParentCode();
+ String customCode = productApproving.getCustomCode();
+ ProductHistory latestProduct = phService.getLatestVersion(parentCode, customCode);
+ ProductHistory enabledProduct = phService.getEnabledByParentCodeAndCustomCode(parentCode, customCode);
+ int currentVersion = 0;
+ if (latestProduct != null) {
+ currentVersion = latestProduct.getVersion();
+ }
+ Integer nextVersion = currentVersion + 1;
+ //浜у搧鐗╂枡鍏崇郴杩佺Щ
+ //鏌ヨ鐢熸晥鐗堟湰鐨勫叧鑱斿叧绯�
+ if(latestProduct!=null &&enabledProduct!=null) {
+ List<MaterialProductHistory> mpList = mphService.getListByParentCodeAndCustomCodeAndVersion(parentCode, customCode, enabledProduct.getVersion());
+ if (latestProduct.getVersion().intValue() == enabledProduct.getVersion()) {
+ //鏈�鏂扮増鏈敓鏁�,鍏宠仈鍏崇郴鐗堟湰杩炵潃鐨�
+ mphService.updateVersionBatch(mpList);
+ } else {
+ //鏃х増鏈敓鏁�,鍏宠仈鍏崇郴鐗堟湰涓嶈繛鐫�
+ mpList.forEach(mp -> {
+ mp.setSVersion(nextVersion);
+ mp.setEVersion(nextVersion);
+ });
+ mphService.insertBatch(mpList);
+ }
+ }
- //鏌ヨ閮ㄤ欢鏈�鏂扮殑鐗堟湰鍙�
- ProductBom product = bomService.getProduct(approvingList.get(0).getParentModel());
- int currentVersion = -1;
- if(product!=null){
- currentVersion = product.getVersion();
- }
- Integer nextVersion = currentVersion+1;
- //鏇存柊鍒皃roduct_bom_history,澧炲姞杩涘幓鐨勯渶瑕乻Version鍜宔Version涓�鑷�
- //澧炲姞鎵�鏈夐儴浠�,鎺掓煡鍑虹浉鍏崇殑鍘熼儴浠�,闈炰篃鏄洿鏂�
- List<ProductBomHistory> currentHistoryList = historyService.getListByParentModel(approvingList.get(0).getParentModel(),currentVersion);
- List<String> currentSubNameList = currentHistoryList.stream().map(ProductBomHistory::getSubName).collect(Collectors.toList());
+ //灏嗕骇鍝佹枃浠跺鍒惰嚦姝ｅ紡璺緞
+ //鏂囦欢杞Щ,鏈窡瀛愪欢鎸傞挬鐨勬墍鏈夊浘绾稿浘鐗囪浆绉诲埌浜у搧鐗堟湰涓�:doc_file/product/{浜у搧鍨嬪彿}/standard鎴栬�厈customCode}}/{version}/
+ //璺熷瓙浠舵寕閽╃殑杞Щ鍒板瓙浠跺浘绾镐笅:doc_file/material/
+ //瀛樺偍鏈瀹℃壒鏂囦欢澶圭粷瀵硅矾寰�
+ String fileUrl = productApproving.getFileUrl();
+ File file = new File(fileUrl);
+ List<String> fileUrlList = new LinkedList<>();
+ List<String> dwgUrlList = null;
+ List<String> picUrlList = null;
+ //瀛樹簬鐗╂枡涓�,bom鍐呮湁瀵瑰簲
+ List<String> materialUrlList = new LinkedList<>();
+ //瀛樹簬浜у搧涓�,bom鍐呮病瀵瑰簲
+ List<String> productUrlList = new LinkedList<>();
- List<ProductBomHistory> newHistoryList = new LinkedList<>();
- approvingList.forEach(approvingBom->{
- if(currentSubNameList.contains(approvingBom.getSubName())){
- approvingBom.setVersion(1);
+ List<Material> materialDwgUrlNameList = new LinkedList<>();
+
+ fileUrlList = FileUtil.getStaticFilePath(file,fileUrlList);
+ //鍥剧焊dwg 瀛愪欢/浜у搧
+ dwgUrlList = fileUrlList.stream().filter(url->url.contains(".dwg")).collect(Collectors.toList());
+ picUrlList = fileUrlList.stream().filter(url->url.contains(".png") || url.contains(".jpeg")).collect(Collectors.toList());
+
+ dwgUrlList.forEach(dwgUrl->{
+ boolean existFlag = false;
+ for (ProductBomApproving approving :approvingList){
+ String filename = dwgUrl.substring(dwgUrl.lastIndexOf(File.separator) + 1, dwgUrl.length() - 4);
+ String fileFullName = dwgUrl.substring(dwgUrl.lastIndexOf(File.separator) + 1);
+ if(approving.getSubModel().toUpperCase().equals(filename.toUpperCase())){
+ materialUrlList.add(dwgUrl);
+ existFlag = true;
+
+ Material temp = new Material();
+ temp.setSubModel(approving.getSubModel());
+ temp.setNotes("doc_file" + File.separator + "material"
+ + File.separator + fileFullName);
+ materialDwgUrlNameList.add(temp);
+ break;
+ }
+ }
+ if(!existFlag) {
+ productUrlList.add(dwgUrl);
+ }
+ });
+
+ //涓�瀹氭槸鏈夊搴旂墿鏂欑殑,浠巄om鍐呭墺绂荤殑
+ picUrlList.forEach(picUrl->{
+ for (ProductBomApproving approving :approvingList){
+ String filename = picUrl.substring(picUrl.lastIndexOf(File.separator) + 1, picUrl.length() - 4);
+ String fileFullName = picUrl.substring(picUrl.lastIndexOf(File.separator) + 1);
+ if(approving.getSubModel().toUpperCase().equals(filename.toUpperCase())){
+ approving.setPictureUrl("doc_file" + File.separator + "material"
+ + File.separator + fileFullName);
+ break;
+ }
+ }
+ });
+
+ //杞Щ璺緞
+ String projectDir = CommonUtil.getProjectDir();
+ //doc_file/product/{浜у搧鍨嬪彿}/standard鎴栬�厈customCode}}/{version}/
+ //璺熷瓙浠舵寕閽╃殑杞Щ鍒板瓙浠跺浘绾镐笅:doc_file/material/
+ String customCodeString = null;
+ if(customCode!=null && !customCode.equals("")) {
+ customCodeString = customCode;
}else{
- approvingBom.setVersion(0);
+ customCodeString = "standard";
}
- //杞寲涓簆roductBomHistory
- ProductBomHistory his = new ProductBomHistory();
- his.setCategory(approvingBom.getCategory());
- his.setCreateDate(approvingBom.getCreateDate());
- his.setDwgUrl(approvingBom.getDwgUrl());
- his.setEVersion(nextVersion);
- his.setFileUrl(approvingBom.getFileUrl());
- his.setMaterial(approvingBom.getMaterial());
- his.setNotes(approvingBom.getNotes());
- his.setParentCode(approvingBom.getParentCode());
- his.setParentModel(approvingBom.getParentModel());
- his.setParentName(approvingBom.getParentName());
- his.setParentVersion(approvingBom.getParentVersion());
- his.setPictureUrl(approvingBom.getPictureUrl());
- his.setProducer(approvingBom.getProducer());
- his.setQuantity(approvingBom.getQuantity());
- his.setSubCode(approvingBom.getSubCode());
- his.setSubModel(approvingBom.getSubModel());
- his.setSubName(approvingBom.getSubName());
- his.setSurfaceDetail(approvingBom.getSurfaceDetail());
- his.setSVersion(nextVersion);
- his.setThickness(approvingBom.getThickness());
- his.setType(approvingBom.getType());
- his.setUnit(approvingBom.getUnit());
- his.setUpUserId(approvingBom.getUpUserId());
+ String productDir = projectDir + File.separator + "doc_file" + File.separator + "product" + File.separator + parentModel
+ + File.separator + customCodeString + File.separator +nextVersion;
+ String materialDir = projectDir + File.separator + "doc_file" + File.separator + "material";
+ File productDirFile = new File(productDir);
+ File materialFile = new File(materialDir);
+ if(!productDirFile.exists()){
+ productDirFile.mkdirs();
+ }
+ if(!materialFile.exists()){
+ materialFile.mkdirs();
+ }
+ productUrlList.forEach(productUrl->{
+ String dwgName = productUrl.substring(productUrl.lastIndexOf(File.separator) + 1, productUrl.length() - 4);
- newHistoryList.add(his);
- });
- //鏈瀹℃牳涓瓙浠惰淇敼鐨勫瓙浠堕泦鍚�
- List<String> approvingUpdateSubNameList = approvingList.stream().filter(approvingBom -> approvingBom.getVersion() == 1).map(ProductBomApproving::getSubName).collect(Collectors.toList());
+ try {
+ FileCopyUtils.copy(new File(productUrl),new File(productDir+File.separator+dwgName+".dwg"));
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ });
- historyService.addBatch(newHistoryList);
- /*鏇存柊浜у搧鐨勫綋鍓嶇増鏈�,鏇存柊鍒版渶鏂扮殑鐗堟湰*/
- //褰撳墠鐗堟湰鐨勬墍鏈塨om鐨別Version鏇存柊,鎺掗櫎琚慨鏀圭殑瀛愪欢
- List<ProductBomHistory> newVersionCurrentHistoryList = currentHistoryList.stream()
- .filter(currentHistory -> !approvingUpdateSubNameList.contains(currentHistory.getSubName()))
- .collect(Collectors.toList());
- newVersionCurrentHistoryList.forEach(history->{history.setEVersion(nextVersion);});
- if(newVersionCurrentHistoryList.size()!=0) {
- historyService.updateVersionBatch(newVersionCurrentHistoryList);
+ materialUrlList.forEach(materialUrl->{
+ String dwgName = materialUrl.substring(materialUrl.lastIndexOf(File.separator) + 1, materialUrl.length() - 4);
+ try {
+ FileCopyUtils.copy(new File(materialUrl),new File(materialDir+File.separator+dwgName+".dwg"));
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ });
+
+ picUrlList.forEach(picUrl->{
+ String picFullName = picUrl.substring(picUrl.lastIndexOf(File.separator) + 1);
+ try {
+ FileCopyUtils.copy(new File(picUrl),new File(materialDir+File.separator+picFullName));
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ });
+
+
+ //杞Щ瀹℃壒琛ㄦ暟鎹埌鍘嗗彶琛�/鏈�鏂扮増鏈〃 product_history/product_bom_history/product/product_bom
+ ProductHistory productHistory = new ProductHistory();
+ productHistory.setParentCode(parentCode);
+ productHistory.setParentName(productApproving.getParentName());
+ productHistory.setParentModel(parentModel);
+ productHistory.setNotes(productApproving.getNotes());
+ productHistory.setCustomCode(customCode);
+ productHistory.setCreateTime(new Date());
+ productHistory.setVersion(nextVersion);
+ productHistory.setEnabled(1);
+
+ Product productNew = new Product();
+ productNew.setParentCode(parentCode);
+ productNew.setParentName(productApproving.getParentName());
+ productNew.setParentModel(parentModel);
+ productNew.setNotes(productApproving.getNotes());
+ productNew.setCustomCode(customCode);
+ productNew.setCreateTime(new Date());
+ productNew.setVersion(nextVersion);
+
+ //瀹為檯鐢熸晥鐨勫彧鏈塱nsert,鍥犱负鐘舵�佽缃负鏈惎鐢ㄥ凡缁忓湪鎻愪氦瀹℃壒鏃跺彉鏇翠簡
+ phService.insertAndUpdateEnabled(productHistory);
+
+ productService.insert(productNew);
+
+ List<ProductBomHistory> productBomHistoryList = new LinkedList<>();
+ List<ProductBom> productBomList = new LinkedList<>();
+ approvingList.forEach(approving->{
+ ProductBomHistory bomHistory = new ProductBomHistory();
+ ProductBom bom = new ProductBom();
+
+ bom.setProductId(productNew.getId());
+ bom.setCategory(approving.getCategory());
+ bom.setCreateDate(new Date());
+ bom.setDwgUrl(approving.getDwgUrl());
+ bom.setFileUrl(approving.getFileUrl());
+ bom.setMaterial(approving.getMaterial());
+ bom.setNotes(approving.getNotes());
+ bom.setPictureUrl(approving.getPictureUrl());
+ bom.setProducer(approving.getProducer());
+ bom.setQuantity(approving.getQuantity());
+ bom.setSubCode(approving.getSubCode());
+ bom.setSubModel(approving.getSubModel());
+ bom.setSubName(approving.getSubName());
+ bom.setSurfaceDetail(approving.getSurfaceDetail());
+ bom.setThickness(approving.getThickness());
+ bom.setType(approving.getType());
+ bom.setUnit(approving.getUnit());
+ //bom.setUpUserId(approving.getUpUserId());
+ bom.setVersion(nextVersion);
+
+ bomHistory.setProductId(productHistory.getId());
+ bomHistory.setCategory(approving.getCategory());
+ bomHistory.setCreateDate(new Date());
+ bomHistory.setDwgUrl(approving.getDwgUrl());
+ bomHistory.setFileUrl(approving.getFileUrl());
+ bomHistory.setMaterial(approving.getMaterial());
+ bomHistory.setNotes(approving.getNotes());
+ bomHistory.setPictureUrl(approving.getPictureUrl());
+ bomHistory.setProducer(approving.getProducer());
+ bomHistory.setQuantity(approving.getQuantity());
+ bomHistory.setSubCode(approving.getSubCode());
+ bomHistory.setSubModel(approving.getSubModel());
+ bomHistory.setSubName(approving.getSubName());
+ bomHistory.setSurfaceDetail(approving.getSurfaceDetail());
+ bomHistory.setThickness(approving.getThickness());
+ bomHistory.setType(approving.getType());
+ bomHistory.setUnit(approving.getUnit());
+ //bomHistory.setUpUserId(approving.getUpUserId());
+ bomHistory.setVersion(nextVersion);
+
+ productBomHistoryList.add(bomHistory);
+ productBomList.add(bom);
+ });
+ historyService.addBatch(productBomHistoryList);
+ bomService.insertBatch(productBomList);
+
+ //鐗╂枡琛ㄤ腑涓嶅瓨鍦ㄧ殑,鍒欐坊鍔犲埌鐗╂枡琛ㄤ腑鍘�
+ List<String> codeList = approvingList.stream().map(ProductBomApproving::getSubCode).collect(Collectors.toList());
+ List<String> existCodeList = mService.getListByCodeList(codeList);
+ List<Material> materialList = new LinkedList<>();
+ approvingList.forEach(approving->{
+ if(!existCodeList.contains(approving.getSubCode())){ //杩欎釜瀹℃壒bom涓殑鐗╂枡涓嶅湪鐗╂枡绠＄悊鍐�
+ Material temp = new Material();
+ //temp.setCategory(approving.getCategory());
+ temp.setCreateDate(new Date());
+ temp.setDwgUrl(approving.getDwgUrl());
+ temp.setFileUrl(approving.getFileUrl());
+ //temp.setMaterial(approving.getMaterial());
+ temp.setNotes(approving.getNotes());
+ temp.setPictureUrl(approving.getPictureUrl());
+ //temp.setProducer(approving.getProducer());
+ //TODO quantity
+ //temp.setQuantity(approving.getQuantity());
+ temp.setStatus(1);
+ temp.setSubCode(approving.getSubCode());
+ temp.setSubModel(approving.getSubModel());
+ temp.setSubName(approving.getSubName());
+ //temp.setSurfaceDetail(approving.getSurfaceDetail());
+ //temp.setThickness(approving.getThickness());
+ temp.setType(approving.getType());
+ temp.setUnit(approving.getUnit());
+ materialList.add(temp);
+ }
+ });
+ if(materialList.size()!=0) {
+ mService.insertBatch(materialList);
+ }
+ //灏哾wg鍥剧焊,鍏ㄩ儴鏇存柊鍒板搴旂殑璁板綍url涓�
+ if(materialDwgUrlNameList.size()!=0) {
+ mService.updateDwgUrl(materialDwgUrlNameList);
+ }
+ /*List<ProductBomApproving> fileBomApprovingList = approvingList.stream()
+ .filter(productBomApproving ->
+ productBomApproving.getPictureUrl() != null || productBomApproving.getDwgUrl() != null
+ ).collect(Collectors.toList());
+ String projectDir = CommonUtil.getProjectDir();
+ fileBomApprovingList.forEach(fileBom -> {
+ try {
+ String pictureUrl = fileBom.getPictureUrl();
+ String dwgUrl = fileBom.getDwgUrl();
+ if (pictureUrl != null) {
+ String newPictureUrl = "doc_file" + File.separator + "product" + File.separator + fileBom.getParentModel() + File.separator + pictureUrl.substring(pictureUrl.lastIndexOf(File.separator) + 1);
+ File newPictureDir = new File(projectDir + File.separator + "doc_file" + File.separator + "product" + File.separator + fileBom.getParentModel());
+ if (!newPictureDir.exists()) {
+ newPictureDir.mkdirs();
+ }
+ FileCopyUtils.copy(new File(projectDir + File.separator + pictureUrl),
+ new File(projectDir + File.separator + newPictureUrl));
+ fileBom.setPictureUrl(newPictureUrl);
+ }
+ if (dwgUrl != null) {
+ String newDwgUrl = "doc_file" + File.separator + "product" + File.separator + fileBom.getParentModel() + File.separator + dwgUrl.substring(dwgUrl.lastIndexOf(File.separator) + 1);
+ File newDwgDir = new File(projectDir + File.separator + "doc_file" + File.separator + "product" + File.separator + fileBom.getParentModel());
+ if (!newDwgDir.exists()) {
+ newDwgDir.mkdirs();
+ }
+ FileCopyUtils.copy(new File(projectDir + File.separator + dwgUrl),
+ new File(projectDir + File.separator + newDwgUrl));
+ fileBom.setDwgUrl(newDwgUrl);
+ }
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ });
+ //鏇存柊姝ｅ紡bom鐨勫搴攗rl
+ bomService.updateUrl(fileBomApprovingList);*/
}
- /*鏇存柊鍒皃roduct_bom*/
- //鏌ヨ鏂扮殑鐗堟湰
- List<ProductBomHistory> newBomList = historyService.getListByParentModel(approvingList.get(0).getParentModel(), nextVersion);
- bomService.updateNewBom(newBomList);
+ else if(type.intValue() == EnumWorksheetType.Material.getType()){ //鐗╂枡
+ List<MaterialApproving> approvingList = mAService.getListByMainId(link.getMainId());
+ List<Material> materialList = new LinkedList<>();
+ //鍖哄垎鏄柊澧炶繕鏄垹闄�
+ Integer materialId = approvingList.get(0).getMaterialId();
+ if(materialId==null) { //鏂板
+ String fileUrl = approvingList.get(0).getFileUrl();
+ File file = new File(fileUrl);
- /*String projectDir = CommonUtil.getProjectDir();
- FileUtil.copyDir()*/
+ List<String> fileUrlList = new LinkedList<>();
+ List<String> dwgUrlList = null;
+ List<String> materialUrlList = new LinkedList<>();
+ List<Material> materialDwgUrlNameList = new LinkedList<>();
+ fileUrlList = FileUtil.getStaticFilePath(file,fileUrlList);
+ dwgUrlList = fileUrlList.stream().filter(url->url.contains(".dwg")).collect(Collectors.toList());
+ //鍥剧焊涓庣墿鏂檓odel瀵瑰簲,鍒欏浘绾搁渶瑕佷繚鐣欏苟杞Щ鍒版寮忔枃浠跺す
+ //鍚屾椂,淇濈暀鍥剧焊瀵瑰簲鐨勭墿鏂檓odel鍜屾寮忔枃浠跺す涓殑http url
+ dwgUrlList.forEach(dwgUrl-> {
+ approvingList.forEach(approving -> {
+ String filename = dwgUrl.substring(dwgUrl.lastIndexOf(File.separator) + 1, dwgUrl.length() - 4);
+ String fileFullName = dwgUrl.substring(dwgUrl.lastIndexOf(File.separator) + 1);
+ if (approving.getSubModel().toUpperCase().equals(filename.toUpperCase())) {
+ materialUrlList.add(dwgUrl);
- /*灏嗕骇鍝乥om琛ㄧ殑url淇,鏇存柊鍒版寮忚〃*/
- //瀹℃壒瀹屽悗,灏嗘湰娆＄殑bom甯rl鐨勫叏閮ㄥ鍒跺埌姝ｅ紡鏂囦欢澶逛腑
- List<ProductBomApproving> fileBomApprovingList = approvingList.stream()
- .filter(productBomApproving ->
- productBomApproving.getPictureUrl() != null || productBomApproving.getDwgUrl() != null
- ).collect(Collectors.toList());
- String projectDir = CommonUtil.getProjectDir();
- fileBomApprovingList.forEach(fileBom->{
- try {
- String pictureUrl = fileBom.getPictureUrl();
- String dwgUrl = fileBom.getDwgUrl();
- if(pictureUrl !=null){
- String newPictureUrl ="doc_file"+File.separator+"product"+File.separator+fileBom.getParentModel()+File.separator+ pictureUrl.substring(pictureUrl.lastIndexOf(File.separator)+1);
- File newPictureDir = new File(projectDir + File.separator + "doc_file"+File.separator+"product"+File.separator+fileBom.getParentModel());
- if(!newPictureDir.exists()){
- newPictureDir.mkdirs();
- }
- FileCopyUtils.copy(new File(projectDir+File.separator+ pictureUrl),
- new File(projectDir+File.separator+newPictureUrl));
- fileBom.setPictureUrl(newPictureUrl);
+ Material temp = new Material();
+ temp.setSubModel(approving.getSubModel());
+ temp.setNotes("doc_file" + File.separator + "material"
+ + File.separator + fileFullName);
+ materialDwgUrlNameList.add(temp);
+ }
+ });
+ });
+ String projectDir = CommonUtil.getProjectDir();
+ String materialDir = projectDir + File.separator + "doc_file" + File.separator + "material";
+ File materialFile = new File(materialDir);
+ if(!materialFile.exists()){
+ materialFile.mkdirs();
}
- if(dwgUrl !=null){
- String newDwgUrl ="doc_file"+File.separator+"product"+File.separator+fileBom.getParentModel()+File.separator+ dwgUrl.substring(dwgUrl.lastIndexOf(File.separator)+1);
- File newDwgDir = new File(projectDir + File.separator + "doc_file"+File.separator+"product"+File.separator+fileBom.getParentModel());
- if(!newDwgDir.exists()){
- newDwgDir.mkdirs();
+
+ materialUrlList.forEach(materialUrl->{
+ String dwgName = materialUrl.substring(materialUrl.lastIndexOf(File.separator) + 1, materialUrl.length() - 4);
+ try {
+ FileCopyUtils.copy(new File(materialUrl),new File(materialDir+File.separator+dwgName+".dwg"));
+ } catch (IOException e) {
+ e.printStackTrace();
}
- FileCopyUtils.copy(new File(projectDir+File.separator+ dwgUrl),
- new File(projectDir + File.separator + newDwgUrl));
- fileBom.setDwgUrl(newDwgUrl);
- }
- } catch (IOException e) {
- e.printStackTrace();
+ });
+ //灏嗙墿鏂欎粠瀹℃壒琛ㄤ腑杞Щ鍒版寮忚〃
+ approvingList.forEach(approve -> {
+ Material material = new Material();
+ //material.setCategory(approve.getCategory());
+ material.setSubCode(approve.getSubCode());
+ material.setSubName(approve.getSubName());
+ material.setSubModel(approve.getSubModel());
+ material.setUnit(approve.getUnit());
+ //TODO quantity
+ //material.setQuantity(approve.getQuantity());
+ //material.setProducer(approve.getProducer());
+ material.setNotes(approve.getNotes());
+ material.setCreateDate(new Date());
+ material.setStatus(1);
+ materialDwgUrlNameList.forEach(materialDwgUrlName->{
+ if(materialDwgUrlName.getSubModel().equals(approve.getSubModel())){
+ material.setDwgUrl(materialDwgUrlName.getDwgUrl());
+ }
+ });
+ materialList.add(material);
+ });
+ mService.insertBatch(materialList);
+ }else{ //鍒犻櫎
+ List<Integer> materialIdList = approvingList.stream().map(MaterialApproving::getMaterialId).collect(Collectors.toList());
+ mService.deleteBatch(materialIdList);
}
- });
- //鏇存柊姝ｅ紡bom鐨勫搴攗rl
- bomService.updateUrl(fileBomApprovingList);
+ //鏇存柊鐗╂枡瀹℃壒瀛愯〃涓璽ype涓哄畬缁�
+ mAService.endStatus(link.getMainId());
+ }
+ else if(type.intValue() == EnumWorksheetType.MaterialProduct.getType()){ //鏇存柊鐗╂枡-浜у搧鍏崇郴
+ //鏌ユ壘鍒板搴旂殑鐗╂枡-浜у搧鍏崇郴鏁版嵁
+ List<MaterialProductApproving> cpAList = cpAService.getListByMainId(link.getMainId());
+ //褰撳墠鐗堟湰
+ int version = cpAList.get(0).getVersion();
+ //鏂板鍏宠仈/绉婚櫎鍏宠仈
+ Map<Integer, List<MaterialProductApproving>> linkTypeMap = cpAList.stream().collect(Collectors.groupingBy(MaterialProductApproving::getLinkType));
+ List<MaterialProductHistory> addedList = new LinkedList<>();
+ List<MaterialProductApproving> removedList = new LinkedList<>();
+ linkTypeMap.forEach((linkType,list)->{
+ if(linkType == 1){
+ list.forEach(approving->{
+ MaterialProductHistory his = new MaterialProductHistory();
+ his.setParentCode(approving.getParentCode());
+ his.setCustomCode(approving.getCustomCode());
+ his.setSVersion(approving.getVersion());
+ his.setEVersion(approving.getVersion());
+ his.setSubMaterialId(approving.getSubMaterialId());
+ his.setQuantity(approving.getQuantity());
+ his.setMaterialId(approving.getMaterialId());
+ his.setCreateTime(new Date());
+
+ addedList.add(his);
+ });
+ }else{
+ removedList.addAll(list);
+ }
+ });
+ //鏂板鍏宠仈
+ if(addedList.size()!=0) {
+ mphService.insertBatch(addedList);
+ }
+ //绉婚櫎鍏宠仈
+ if(removedList.size()!=0) {
+ mphService.updateVersionSubtractBatch(removedList);
+ }
+ }
+ else if(type.intValue() == EnumWorksheetType.ProductSoftware.getType()){ //杞欢涓嬭浇
+ //杞Щ璁板綍鍒版寮忚〃
+ ProductSoftwareApproving productSoftwareApproving = productSoftwareApprovingService.getByMainId(link.getMainId());
+ ProductSoftware productSoftware = new ProductSoftware();
+ productSoftware.setParentModel(productSoftwareApproving.getParentModel());
+ productSoftware.setSoftwareName(productSoftwareApproving.getSoftwareName());
+ productSoftware.setSoftwareUrl(productSoftwareApproving.getSoftwareUrl());
+ productSoftware.setSubmitTime(productSoftwareApproving.getCreateTime());
+ productSoftware.setCreateTime(new Date());
+
+ productSoftwareService.insert(productSoftware);
+ }
}
}
@@ -240,4 +592,61 @@
public DocUser getApprovingUser(Integer mainId) {
return linkMapper.getApprovingUser(mainId);
}
+
+ @Transactional
+ public Response confirmProductProcedureAndSOP(WorksheetLink link) throws IOException {
+ Integer mainId = linkMapper.selectById(link.getId()).getMainId();
+ //鏇存柊瀛愯〃
+ linkMapper.updateById(link);
+ if(link.getLinkStatus() ==1){
+ //鏌ヨ褰撳墠鍗曟嵁瀛愯〃鏄惁宸茬粡鍏ㄩ儴鍚屾剰
+ QueryWrapper<WorksheetLink> query = Wrappers.query();
+ query.eq("main_id",mainId);
+ List<WorksheetLink> linkList = linkMapper.selectList(query);
+ List<WorksheetLink> rejectList = linkList.stream().filter(linkFilter -> linkFilter.getLinkStatus() != 1).collect(Collectors.toList());
+ if(rejectList == null){
+ //閮戒负1,宸茬‘璁�
+ mainService.updateEndStatusById(mainId,"宸茬‘璁�",5);
+ //鏂囦欢杞Щ鍒板鎵瑰畬鎴愬悗鐨勬寮忚矾寰� 鏂囦欢淇濆瓨鍦�/doc_file/procedure/xxx.doc
+ ProcedureDocApproving approving = procedureDocApprovingService.getByMainId(mainId);
+ String fileRelativePath = approving.getFile();
+ String projectDir = CommonUtil.getProjectDir();
+ String inFilePath = projectDir + File.separator + fileRelativePath;
+ String outFilePath = (projectDir + File.separator + fileRelativePath).replace("_approving","");
+ WordUtil.fillValue(inFilePath,outFilePath,Arrays.asList(approving.getFzr(),approving.getBz(),approving.getZz(),approving.getPb()));
+ //鍒犻櫎涔嬪墠棰勮浜х敓鐨勪腑闂存枃浠�
+ String filename = fileRelativePath.substring(fileRelativePath.lastIndexOf(File.separator)+1,fileRelativePath.lastIndexOf("."));
+ File approvingDir = new File(projectDir + File.separator + "procedure_approving");
+ FilenameFilter filenameFilter = new FilenameFilter() {
+ @Override
+ public boolean accept(File dir, String name) {
+ name = name.substring(0,name.lastIndexOf("."));
+ if(name.contains(filename) && !name.equals(filename)){
+ return true;
+ }
+ return false;
+ }
+ };
+ File[] files = approvingDir.listFiles(filenameFilter);
+ for (File file : files) {
+ file.delete();
+ }
+
+ //娴佺▼鏂囦欢鏁版嵁杞Щ
+ ProcedureDoc procedureDoc = new ProcedureDoc();
+ procedureDoc.setName(approving.getName());
+ procedureDoc.setDescription(approving.getDescription());
+ procedureDoc.setVersion(approving.getVersion());
+ procedureDoc.setFzr(approving.getFzr());
+ procedureDoc.setBz(approving.getBz());
+ procedureDoc.setType(approving.getType());
+ procedureDoc.setCreateTime(new Date());
+ procedureDoc.setFile(fileRelativePath.replace("_approving",""));
+ procedureDocService.insert(procedureDoc);
+ }
+ }else{
+ mainService.updateEndStatusById(mainId,"宸查┏鍥�",0);
+ }
+ return new Response().set(1);
+ }
}
--
Gitblit v1.9.1