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 | 629 +++++++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 584 insertions(+), 45 deletions(-)
diff --git a/src/main/java/com/whyc/service/WorksheetLinkService.java b/src/main/java/com/whyc/service/WorksheetLinkService.java
index c6ac309..a93f1d8 100644
--- a/src/main/java/com/whyc/service/WorksheetLinkService.java
+++ b/src/main/java/com/whyc/service/WorksheetLinkService.java
@@ -2,20 +2,25 @@
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.ProductBomApproving;
-import com.whyc.pojo.WorksheetLink;
+import com.whyc.pojo.*;
import com.whyc.util.CommonUtil;
-import org.aspectj.util.FileUtil;
+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;
+import org.springframework.util.FileCopyUtils;
import javax.annotation.Resource;
-import javax.naming.CommunicationException;
-import java.util.Date;
-import java.util.List;
+import java.io.File;
+import java.io.FilenameFilter;
+import java.io.IOException;
+import java.util.*;
+import java.util.stream.Collectors;
@Service
public class WorksheetLinkService {
@@ -25,10 +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) {
@@ -36,20 +82,24 @@
//鏇存柊鑺傜偣淇℃伅
linkMapper.updateById(link);
if(link.getLinkStatus() == 2){ //椹冲洖
- //椹冲洖鍒板憳宸ヨ繘琛屽鐞�
- //鏌ヨ宸ュ崟鐨勫憳宸�
- Long createUserId = mainService.getInfoById(link.getMainId()).getCreateUserId();
- WorksheetLink link2 = new WorksheetLink();
- link2.setMainId(link.getMainId());
- link2.setParentId(link.getId());
- link2.setDealUserId(createUserId);
- link2.setDealType(0);
- link2.setDealDesc("宸ュ崟琚粡鐞嗛┏鍥�,椹冲洖淇℃伅:"+link.getDealReason());
- link2.setLinkStatus(0);
- link2.setEnableArchive(0);
- linkMapper.insert(link2);
- //鏇存柊涓昏〃鐘舵��
- mainService.updateStatusById(link.getMainId(),0);
+ //鏌ョ湅鏄惁涓虹墿鏂欏鎵�,鏄垯闇�瑕佹洿鏂扮墿鏂欏鎵硅〃涓殑鐘舵�佷负瀹岀粨
+ if(mainService.getInfoById(link.getMainId()).getType().equals(EnumWorksheetType.Material.getType())){
+ mAService.endStatus(link.getMainId());
+ }
+ //椤圭洰缁忕悊椹冲洖,椹冲洖鍗崇粓姝�
+ 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();
@@ -68,37 +118,445 @@
@Transactional
public void approve(WorksheetLink link) {
+ //鏍规嵁鑺傜偣,鏌ヨ涓昏〃绫诲瀷
+ Integer type = mainService.getInfoById(link.getMainId()).getType();
link.setDealTime(new Date());
//鏇存柊鑺傜偣淇℃伅
linkMapper.updateById(link);
if(link.getLinkStatus() == 2){ //椹冲洖
- //椹冲洖鍒板憳宸ヨ繘琛屽鐞�
- //鏌ヨ宸ュ崟鐨勫憳宸�
- Long createUserId = mainService.getInfoById(link.getMainId()).getCreateUserId();
- WorksheetLink link2 = new WorksheetLink();
- link2.setMainId(link.getMainId());
- link2.setParentId(link.getId());
- link2.setDealUserId(createUserId);
- link2.setDealType(0);
- link2.setDealDesc("宸ュ崟琚粡鐞嗛┏鍥�,椹冲洖淇℃伅:"+link.getDealReason());
- link2.setLinkStatus(0);
- link2.setEnableArchive(0);
- linkMapper.insert(link2);
- //鏇存柊涓昏〃鐘舵��
- mainService.updateStatusById(link.getMainId(),0);
- }else{
+ if(link.getParentId()!=0) {
+ //鏌ヨ瀵瑰簲鐨勯」鐩粡鐞�
+ Long createUserId = linkMapper.selectById(link.getParentId()).getDealUserId();
+ WorksheetLink link2 = new WorksheetLink();
+ link2.setMainId(link.getMainId());
+ link2.setParentId(link.getId());
+ link2.setDealUserId(createUserId);
+ link2.setDealType(0);
+ link2.setDealDesc("宸ュ崟琚�荤粡鐞嗛┏鍥�,椹冲洖淇℃伅:" + link.getDealReason());
+ link2.setLinkStatus(0);
+ link2.setEnableArchive(0);
+ linkMapper.insert(link2);
+ //鏇存柊涓昏〃鐘舵��
+ mainService.updateStatusById(link.getMainId(), 1);
+ }else{
+ //璇存槑鏄」鐩粡鐞嗘彁浜ょ殑,椹冲洖鍗崇粓姝�
+ mainService.updateEndStatusById(link.getMainId(),"鎬荤粡鐞嗛┏鍥�,椹冲洖鍘熷洜:"+link.getDealReason(),0);
+ }
+ }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()) { //浜у搧瀹℃壒
- /*String projectDir = CommonUtil.getProjectDir();
- FileUtil.copyDir()*/
+ 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);
+ }
+ }
+
+ //灏嗕骇鍝佹枃浠跺鍒惰嚦姝ｅ紡璺緞
+ //鏂囦欢杞Щ,鏈窡瀛愪欢鎸傞挬鐨勬墍鏈夊浘绾稿浘鐗囪浆绉诲埌浜у搧鐗堟湰涓�: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<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{
+ customCodeString = "standard";
+ }
+ 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);
+
+ try {
+ FileCopyUtils.copy(new File(productUrl),new File(productDir+File.separator+dwgName+".dwg"));
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ });
+
+ 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();
+ }
+ });
- //灏嗕骇鍝乥om琛ㄧ殑url淇,鏇存柊鍒版寮忚〃
+ //杞Щ瀹℃壒琛ㄦ暟鎹埌鍘嗗彶琛�/鏈�鏂扮増鏈〃 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);*/
+ }
+ 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);
+
+ 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);
+
+ 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();
+ }
+
+ 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();
+ }
+ });
+ //灏嗙墿鏂欎粠瀹℃壒琛ㄤ腑杞Щ鍒版寮忚〃
+ 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);
+ }
+ //鏇存柊鐗╂枡瀹℃壒瀛愯〃涓璽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);
+ }
}
}
@@ -110,4 +568,85 @@
public List<WorksheetLink> getInfoList(Long id) {
return linkMapper.getInfoList(id);
}
+
+ /**
+ *
+ * @param userId 鎬荤粡鐞嗗搴旂殑userId
+ * @param statusExp 0:鏈鎵�,1:宸插鎵�(鍖呭惈鐘舵�佸��1,2)
+ * @return
+ */
+ public List<WorksheetMain> getInfoList2(Long userId, int statusExp) {
+ return linkMapper.getInfoList2(userId,statusExp);
+ }
+
+ /**
+ *
+ * @param userId 鎬荤粡鐞嗗搴旂殑userId
+ * @param statusExp 0:鏈鎵�,1:宸插鎵�(鍖呭惈鐘舵�佸��1,2)
+ * @return
+ */
+ public List<WorksheetMain> getInfoList3(Long userId, int statusExp) {
+ return linkMapper.getInfoList3(userId,statusExp);
+ }
+
+ 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