yangys
2025-09-18 a3048fa6fa72fa3cc5da2c43c59bd000e00c9599
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
95
96
 
package org.springblade.mdm.flow.service;
 
import com.baomidou.mybatisplus.core.metadata.IPage;
import lombok.AllArgsConstructor;
import org.flowable.engine.HistoryService;
import org.flowable.engine.history.HistoricProcessInstance;
import org.flowable.engine.history.HistoricProcessInstanceQuery;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.Func;
import org.springblade.mdm.basesetting.machine.service.MachineService;
import org.springblade.mdm.commons.service.ParamService;
import org.springblade.mdm.flow.constants.FlowConstant;
import org.springblade.mdm.flow.constants.FlowVariableConstant;
import org.springblade.mdm.flow.vo.FlowVO;
import org.springblade.mdm.flow.vo.ProgramOnMachineQueryVO;
import org.springframework.stereotype.Service;
 
import java.util.*;
 
/**
 * 流程业务实现类
 *
 * @author Chill
 */
@Service
@AllArgsConstructor
public class ProgramOnMachineExportService {
 
    private final HistoryService historyService;
    private final ParamService paramService;
    private final MachineService machineService;
    /**
     *
     * @param page 分页信息
     * @param queryVO 查询数据对象
     * @return
     */
    public IPage<FlowVO> finishedPage(IPage<FlowVO> page, ProgramOnMachineQueryVO queryVO) {
        //固化里路村官
        HistoricProcessInstanceQuery query = this.historyService.createHistoricProcessInstanceQuery().finished().processDefinitionKey(FlowConstant.TRY_PROCESS_KEY).includeProcessVariables();
            //.finished() // 只查询已完成的流程.unfinished() // 查询未完成的流程
        query.variableNotExists(FlowVariableConstant.EXCEPTION);//非异常流程
        query.variableValueEquals(FlowVariableConstant.PROGRAM_ON_MACHINE, FlowConstant.Y);//选择现场编制的
        /*
        //车床或者选择现场编制的程序
        String turnVal = paramService.turninngValue();
        List<Machine> machines = machineService.lambdaQuery().eq(Machine::getMachineSpec,turnVal).eq(Machine::getStatus,Machine.STATUS_ENABLE).list();
        List<String> turnMachineCodes = machines.stream().map(Machine::getCode).toList();
        query.or();
        for(String mCode : turnMachineCodes){
            query.variableValueEquals(FlowVariableContants.MACHINE_CODE, mCode);
        }
 
        query.endOr();
        */
        if(queryVO.getEndTimeBegin()!=null) {
            query.finishedAfter(DateUtil.toDate(queryVO.getEndTimeBegin()));
        }
        if(queryVO.getEndTimeEnd()!=null) {
            query.finishedBefore(DateUtil.toDate(queryVO.getEndTimeEnd()));
        }
        if(Func.isNotEmpty(queryVO.getDrawingNo())) {
            String likeVal = "%" + queryVO.getDrawingNo() + "%";
            query.variableValueLike(FlowVariableConstant.DRAWING_NO,likeVal);
        }
        query.orderByProcessInstanceEndTime().desc(); // 按结束时间降序排列
        page.setTotal(query.count());
 
        long firstResult = (page.getCurrent()-1) * page.getSize();
        List<HistoricProcessInstance> processes = query
            .listPage((int)firstResult, (int)page.getSize());
 
        List<FlowVO> records = new LinkedList<>();
 
        for(HistoricProcessInstance processInstance : processes) {
            FlowVO vo = new FlowVO();
            vo.setProcessDefinitionKey(processInstance.getProcessDefinitionKey());
            vo.setProcessInstanceId(processInstance.getId());
            vo.setProcessDefinitionName(processInstance.getProcessDefinitionName());
            vo.setVariables(processInstance.getProcessVariables());
 
            vo.setProcessCreateTime(processInstance.getStartTime());
            vo.setHistoryTaskEndTime(processInstance.getEndTime());
 
 
            //vo.setFile(getFileString(processInstance.getId()));
            records.add(vo);
        }
 
        page.setRecords(records);
 
        return page;
    }
 
}