yangys
2025-09-17 1e2b04fabbbc4b1ae37d7951068d7ab235f5b5f9
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
 
package org.springblade.mdm.program.service;
 
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springblade.core.mp.base.BizServiceImpl;
import org.springblade.core.tool.utils.Func;
import org.springblade.mdm.basesetting.machine.entity.Machine;
import org.springblade.mdm.basesetting.machine.service.MachineService;
import org.springblade.mdm.program.entity.NcNode;
import org.springblade.mdm.program.entity.NcNodeHis;
import org.springblade.mdm.program.mapper.NcNodeHisMapper;
import org.springblade.mdm.program.vo.NcNodeQueryVO;
import org.springblade.mdm.program.vo.NcNodeVO;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
 
import java.time.LocalDateTime;
import java.util.*;
 
/**
 * 程序节点
 *
 * @author yangys
 */
@Slf4j
@Service
@AllArgsConstructor
public class NcNodeHisService extends BizServiceImpl<NcNodeHisMapper, NcNodeHis> {
    public final NcNodeService ncNodeService;
    /**
     * 将指定时间时候的节点合并到历史节点数据中,其他数据从node表中删除(只包含不程序包名和程序节点)
     * @param time
     */
    public void mergeNodeToHisGeTime(Date time) {
        List<NcNode> nodes = ncNodeService.lambdaQuery().ge(NcNode::getUpdateTime,time)
            .in(NcNode::getNodeType,NcNode.TYPE_PROGRAM_PACKAGE,NcNode.TYPE_PROGRAM_FILE).list();
 
        for(NcNode node : nodes){
            NcNodeHis nodeHis = new NcNodeHis();
            BeanUtils.copyProperties(node,nodeHis);
 
            if(baseMapper.countById(nodeHis.getId())>0){
                this.updateById(nodeHis);
            }else{
                this.save(nodeHis);
            }
        }
        ncNodeService.deleteOldEditionNodeData();
    }
 
    /**
     * 查询偏离单的序号
     * @param programPkgNode 偏离单的程序包名节点
     * @return 序号
     */
    public long getDeviationSerialForNode(NcNodeHis programPkgNode) {
        return lambdaQuery().eq(NcNodeHis::getNodeType,NcNode.TYPE_PROGRAM_PACKAGE)
            .eq(NcNodeHis::getName,programPkgNode.getName())
 
            .eq(NcNodeHis::getDrawingNo,programPkgNode.getDrawingNo())
            .eq(NcNodeHis::getProcessNo,programPkgNode.getProcessNo())
            .eq(NcNodeHis::getProcessEdition,programPkgNode.getProcessEdition())
 
            .isNotNull(NcNodeHis::getDeviation)
            .le(NcNodeHis::getCreateTime,programPkgNode.getCreateTime())  //时间小于等于当前节点
            .count();
    }
 
    /**
     * 查询节点的历史列表(节点的上级节点”程序包名“因为存在多个版本,所以历史记录也需要根据不同版本程序包名进行查询)
     * @param id
     * @return
     */
    @Transactional(readOnly = true)
    public List<NcNodeVO> historyByNodeId(Long id) {
        NcNodeHis node = this.getById(id);
        /*
        List<NcNodeHis> nodes = lambdaQuery().eq(NcNodeHis::getNodeType,NcNode.TYPE_PROGRAM_PACKAGE)
            .eq(NcNodeHis::getHisSerial, node.getHisSerial()).orderByDesc(NcNodeHis::getCreateTime).list();
        List<NcNodeVO> voList = new ArrayList<>();
        nodes.forEach(ncNode -> {
            NcNodeVO vo = new NcNodeVO();
            BeanUtils.copyProperties(ncNode, vo);
            vo.setCreateUserName();
            voList.add(vo);
        });*/
        return this.baseMapper.packageHistoryBySerial(node.getHisSerial());
        //return voList;
    }
}