From 813f0f6d391b7f24682204c22c059ef69b124fa6 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期一, 30 六月 2025 23:59:15 +0800
Subject: [PATCH] 增加流程与程序关联查询

---
 blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/service/NcProgramService.java |  145 ++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 126 insertions(+), 19 deletions(-)

diff --git a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/service/NcProgramService.java b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/service/NcProgramService.java
index c089431..8250bc0 100644
--- a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/service/NcProgramService.java
+++ b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/program/service/NcProgramService.java
@@ -25,21 +25,37 @@
  */
 package org.springblade.mdm.program.service;
 
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.fasterxml.jackson.databind.ObjectMapper;
 import lombok.AllArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
+import org.apache.commons.io.IOUtils;
 import org.flowable.engine.*;
 import org.springblade.core.mp.base.BizServiceImpl;
+import org.springblade.core.mp.support.Condition;
+import org.springblade.core.oss.OssTemplate;
+import org.springblade.core.oss.model.BladeFile;
 import org.springblade.mdm.basesetting.machine.MachineService;
 import org.springblade.mdm.basesetting.machine.entity.Machine;
+import org.springblade.mdm.program.entity.NcNode;
+import org.springblade.mdm.program.entity.ProgramSeq;
 import org.springblade.mdm.program.mapper.NcProgramMapper;
 import org.springblade.mdm.program.entity.NcProgram;
+import org.springblade.mdm.program.mapper.ProgramSeqMapper;
 import org.springblade.mdm.program.vo.DncSendBackData;
+import org.springblade.mdm.program.vo.NcNodeProgramQueryVO;
+import org.springblade.mdm.program.vo.NcProgramUploadVO;
+import org.springblade.mdm.program.vo.NcProgramVO;
+import org.springblade.mdm.utils.FileContentUtil;
+import org.springframework.beans.BeanUtils;
 import org.springframework.stereotype.Service;
 import org.springframework.web.multipart.MultipartFile;
 
 import java.io.IOException;
 import java.io.InputStream;
+import java.nio.charset.StandardCharsets;
+import java.text.DecimalFormat;
 import java.util.ArrayList;
 import java.util.List;
 
@@ -53,39 +69,130 @@
 @AllArgsConstructor
 public class NcProgramService  extends BizServiceImpl<NcProgramMapper, NcProgram> {
 
-	private final ObjectMapper objectMapper;
-	private final RepositoryService repositoryService;
-	private final RuntimeService runtimeService;
-	private final HistoryService historyService;
-	private final TaskService taskService;
-	private final ProcessEngine processEngine;
 	private final MachineService machineService;
+
+	private final OssTemplate ossTemplate;
+	private final NcNodeService nodeService;
+
+	private final ProgramSeqMapper seqMapper;
 	/**
 	 * 鏌ヨ鐜版湁鍥哄寲鐨勭▼搴忥紝鏆傚畾鏉′欢锛氶浂缁勪欢鍙风浉鍚岋紝涓旀槸鍚屼竴鏈哄簥缁�
 	 * @param partNo
 	 * @param machineCode
 	 * @return
 	 */
-	public NcProgram getCuredNcProgram(String partNo,String machineCode) {
+	public List<NcProgram> getCuredNcProgram(String partNo,String machineCode) {
 		Machine machine = machineService.getByCode(machineCode);
 		return this.getBaseMapper().getCuredNcProgram(partNo,machine.getMachineGroupCode());
 	}
 
-	/**
-	 * 鏌ヨ鐜版湁鍥哄寲鐨勭▼搴忥紝鏆傚畾鏉′欢锛氶浂缁勪欢鍙风浉鍚岋紝涓旀槸鍚屼竴鏈哄簥缁�
-	 * @param name 绋嬪簭鍚嶇О
-	 * @return
-	 */
-	public NcProgram getLastNcProgram(String name) {
-		return this.getBaseMapper().getLastNcProgram(name);
-	}
 
 	/**
 	 * 涓婁紶绋嬪簭鏂囦欢鍒版寚瀹氳妭鐐�
-	 * @param file
-	 * @param nodeId
-	 * @param category
+	 * @param uploadVO 涓婁紶鏂囦欢琛ㄥ崟鏁版嵁
 	 */
-	public void uploadNcFile(MultipartFile file, Long nodeId, String category) {
+	public void uploadProgramFile(NcProgramUploadVO uploadVO) {
+
+
+		MultipartFile file = uploadVO.getFile();
+		BladeFile bfile = ossTemplate.putFile(uploadVO.getFile());
+		String link = bfile.getLink();
+		//淇濆瓨profame
+		NcProgram prog = new NcProgram();
+		prog.setCode(generageCode());
+		prog.setName(file.getOriginalFilename());
+		prog.setNcNodeId(uploadVO.getNodeId());
+		prog.setOssName(bfile.getName());
+		prog.setPartNo(uploadVO.getPartNo());
+		prog.setProcessEdition(uploadVO.getProcessEdition());
+		prog.setIsLastEdition(1);
+		boolean isTextFile = false;
+		try {
+			isTextFile = FileContentUtil.isTextFile(file.getInputStream());
+		} catch (IOException e) {
+			log.warn("鍒ゆ柇鏄惁鏂囨湰鏂囦欢寮傚父",e);
+		}
+		prog.setIsTextFile(isTextFile);
+		prog.setUrl(link);
+		prog.setCategory(uploadVO.getCategory());
+
+		this.save(prog);
+	}
+
+	String generageCode(){
+		ProgramSeq program = new ProgramSeq();
+		seqMapper.insert(program);
+
+		DecimalFormat df = new DecimalFormat("0000000000");
+		return df.format(program.getId());
+	}
+	/**
+	 * 鍒犻櫎涓�涓▼搴�
+	 * @param id
+	 */
+	public String getFileContent(Long id) {
+		String result  ="";
+
+		NcProgram prog = this.getById(id);
+		String fileName = prog.getOssName();
+		try (InputStream inputStream = ossTemplate.statFileStream(fileName)) {
+			result = IOUtils.toString(inputStream, StandardCharsets.UTF_8);
+		} catch (IOException e) {
+			throw new RuntimeException(e);
+		}
+		return result;
+	}
+	/**
+	 * 鍒犻櫎涓�涓▼搴�
+	 * @param id
+	 */
+	public void removeProgram(Long id) {
+		NcProgram prog = this.getById(id);
+		ossTemplate.removeFile(prog.getOssName());
+		this.getBaseMapper().deleteById(id);
+	}
+
+	public List<NcProgramVO> listByNode(Long nodeId) {
+		NcNode node = nodeService.getById(nodeId);
+		List<NcProgram> pList = this.list(Wrappers.lambdaQuery(NcProgram.class).eq(NcProgram::getNcNodeId, nodeId).eq(NcProgram::getIsLastEdition,1).orderByDesc(NcProgram::getCreateTime));
+
+		List<NcProgramVO> result = new ArrayList<>();
+
+		pList.forEach(prog -> {
+			NcProgramVO vo = new NcProgramVO();
+			BeanUtils.copyProperties(prog, vo);
+			vo.setMachineCode(node.getMachineCode());
+			result.add(vo);
+		});
+
+		return result;
+	}
+
+	/**
+	 * 鍗囩増(鍗囩骇宸ュ簭鐗堟),鍗囩骇宸ュ簭鐗堟湰锛堝寘鎷▼搴忓拰鍏朵粬闄勪欢锛�
+	 * @param id 绋嬪簭鏂囦欢id
+	 * @param newProcessEdition 鏂扮増娆�
+	 */
+	public void upgradeProcessEdition(long id,String newProcessEdition) {
+		NcProgram prog = this.getById(id);
+		//灏嗙幇鏈夌▼搴忔洿鏂颁负闈炴渶鏂扮増鏈�
+		this.update(Wrappers.lambdaUpdate(NcProgram.class).eq(NcProgram::getId,id).set(NcProgram::getIsLastEdition,0));
+
+		NcProgram newVerProg = new NcProgram();
+		BeanUtils.copyProperties(prog, newVerProg);
+		newVerProg.setId(null);
+		newVerProg.setIsLastEdition(1);
+		newVerProg.setProcessEdition(newProcessEdition);
+
+		this.save(newVerProg);
+	}
+
+	/**
+	 * 鍒嗛〉鏌ヨ锛岀敤浜庡鎵规椂閫夋嫨绋嬪簭
+	 * @param query
+	 * @return
+	 */
+	public IPage<NcProgramVO> pageQuery(NcNodeProgramQueryVO query) {
+		return this.getBaseMapper().pageQuery(Condition.getPage(query),query);
 	}
 }

--
Gitblit v1.9.3