From 7a6b24ebb7197821c71e9bb41ca31b196037022a Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期日, 10 八月 2025 12:57:08 +0800
Subject: [PATCH] 增加上一步审批用户查询接口

---
 blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/service/FlowBusinessService.java |  123 ++++++++++++++++++++++++++++++++++++++--
 1 files changed, 115 insertions(+), 8 deletions(-)

diff --git a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/service/FlowBusinessService.java b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/service/FlowBusinessService.java
index 180c7f8..35394e9 100644
--- a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/service/FlowBusinessService.java
+++ b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/service/FlowBusinessService.java
@@ -10,8 +10,10 @@
 import org.flowable.engine.history.HistoricProcessInstanceQuery;
 import org.flowable.engine.task.Comment;
 import org.flowable.task.api.Task;
+import org.flowable.task.api.TaskInfoQuery;
 import org.flowable.task.api.TaskQuery;
 import org.flowable.task.api.history.HistoricTaskInstance;
+import org.flowable.task.api.history.HistoricTaskInstanceQuery;
 import org.springblade.core.launch.constant.FlowConstant;
 import org.springblade.core.secure.utils.AuthUtil;
 import org.springblade.core.tool.api.R;
@@ -30,10 +32,7 @@
 
 import java.time.LocalDate;
 import java.time.LocalDateTime;
-import java.util.Collections;
-import java.util.Date;
-import java.util.LinkedList;
-import java.util.List;
+import java.util.*;
 
 /**
  * 娴佺▼涓氬姟瀹炵幇绫�
@@ -91,8 +90,9 @@
 		page.setRecords(flowList);
 		return page;
 	}
-
-	void addKeywordCondition(TaskQuery todoQuery,String keyword) {
+	//TaskInfoQuery
+	//void addKeywordCondition(TaskQuery todoQuery,String keyword) {
+	void addKeywordCondition(TaskInfoQuery todoQuery, String keyword) {
 		if(Func.isNotEmpty(keyword)) {
 			String likeVal = "%" + keyword + "%";
 			todoQuery.or();
@@ -478,8 +478,8 @@
 	 * @param keyword 鍏抽敭瀛�
 	 * @return
 	 */
-	public IPage<FlowVO> selectFinishedPage(IPage<FlowVO> page, String processDefinitionKey,LocalDate createTimeBegin, LocalDate createTimeEnd, String keyword) {
-		HistoricProcessInstanceQuery query = this.historyService.createHistoricProcessInstanceQuery().includeProcessVariables();
+	public IPage<FlowVO> selectFinishedPage(IPage<FlowVO> page, String processDefinitionKey,LocalDateTime createTimeBegin, LocalDateTime createTimeEnd, String keyword) {
+		HistoricProcessInstanceQuery query = this.historyService.createHistoricProcessInstanceQuery().finished().includeProcessVariables();
 			//.finished() // 鍙煡璇㈠凡瀹屾垚鐨勬祦绋�.unfinished() // 鏌ヨ鏈畬鎴愮殑娴佺▼
 		if(Func.isNotEmpty(processDefinitionKey)) {
 			query.processDefinitionKey(processDefinitionKey);
@@ -528,4 +528,111 @@
 
 		return result;
 	}
+
+	/**
+	 * 鏌ヨ宸插姙浠诲姟鍒嗛〉鏁版嵁
+	 * @param page
+	 * @param createTimeBegin
+	 * @param createTimeEnd
+	 * @param keyword
+	 * @return
+	 */
+	/*
+	public IPage<FlowVO> selectDonePage(IPage<FlowVO> page, LocalDateTime createTimeBegin, LocalDateTime createTimeEnd, String keyword) {
+		String userId = "" + AuthUtil.getUserId();
+		List<FlowVO> flowList = new LinkedList<>();
+
+		HistoricTaskInstanceQuery doneTaskQuery = historyService.createHistoricTaskInstanceQuery().taskAssignee(userId).finished().includeProcessVariables();
+		//TaskQuery todoQuery =  historyService.createHistoricTaskInstanceQuery().taskAssignee(userId).finished().includeProcessVariables()
+		if (Func.isNotEmpty(createTimeBegin)) {
+			doneTaskQuery.taskCreatedAfter(DateUtil.toDate(createTimeBegin));
+		}
+		if (Func.isNotEmpty(createTimeEnd)) {
+			doneTaskQuery.taskCreatedBefore(DateUtil.toDate(createTimeEnd));
+			//todoQuery.taskInProgressStartTimeBefore(DateUtil.toDate(createTimeEnd));
+		}
+		if (Func.isNotEmpty(keyword)) {
+			addKeywordCondition(doneTaskQuery, keyword);
+		}
+
+		todoQuery.orderByTaskCreateTime().desc();
+
+		// 鏋勫缓鍒楄〃鏁版嵁
+		FlowVO bladeFlow = new FlowVO();
+		buildFlowTaskList(bladeFlow, flowList, todoQuery,page.getCurrent(),page.getSize());
+
+		// 璁$畻鎬绘暟
+		long count = todoQuery.count();
+
+		// 璁剧疆鎬绘暟
+		page.setTotal(count);
+		// 璁剧疆鏁版嵁
+		page.setRecords(flowList);
+		return page;
+	}*/
+	public IPage<FlowVO> selectDonePage(IPage<FlowVO> page, String processDefinitionKey,LocalDateTime completeTimeBegin, LocalDateTime createTimeEnd, String keyword) {
+		String userId = "" + AuthUtil.getUserId();
+		HistoricTaskInstanceQuery doneTaskQuery = historyService.createHistoricTaskInstanceQuery().taskAssignee(userId).finished().includeProcessVariables();
+
+		//.finished() // 鍙煡璇㈠凡瀹屾垚鐨勬祦绋�.unfinished() // 鏌ヨ鏈畬鎴愮殑娴佺▼
+		if(Func.isNotEmpty(processDefinitionKey)) {
+			doneTaskQuery.processDefinitionKey(processDefinitionKey);
+		}
+		if(completeTimeBegin!=null) {
+			doneTaskQuery.taskCompletedAfter(DateUtil.toDate(completeTimeBegin));
+		}
+		if(createTimeEnd!=null) {
+			doneTaskQuery.taskCompletedBefore(DateUtil.toDate(createTimeEnd));
+		}
+		//QueryProperty
+		doneTaskQuery.orderByTaskCreateTime().desc(); // 鎸夌粨鏉熸椂闂撮檷搴忔帓鍒�
+		page.setTotal(doneTaskQuery.count());
+
+		long firstResult = (page.getCurrent()-1) * page.getSize();
+
+		List<HistoricTaskInstance> processes = doneTaskQuery
+			.listPage((int)firstResult, (int)page.getSize());
+
+		List<FlowVO> records = new LinkedList<>();
+		//Map<String,String> processDefKeyMap = new HashMap<>();//浣跨敤TaskDefinitionKey缂撳瓨ProcessDefinitionKey
+		//Map<String,String> processDefNameMap = new HashMap<>();//浣跨敤TaskDefinitionKey缂撳瓨ProcessDefinitionName
+		Map<String,String> startUserMap = new HashMap<>();//浣跨敤userId缂撳瓨鍏跺鍚�
+		for(HistoricTaskInstance hisTask : processes) {
+			FlowVO vo = new FlowVO();
+
+
+			HistoricProcessInstance processInstance = historyService
+				.createHistoricProcessInstanceQuery()
+				.processInstanceId(hisTask.getProcessInstanceId())
+				.singleResult();
+
+			if(startUserMap.containsKey(processInstance.getStartUserId())) {
+				vo.setStartUserName(startUserMap.get(processInstance.getStartUserId()));
+			}else {
+				R<User> ru = userClient.userInfoById(Long.valueOf(processInstance.getStartUserId()));
+				if (ru.isSuccess()) {
+					vo.setStartUserName(ru.getData().getName());
+					startUserMap.put(processInstance.getStartUserId(),ru.getData().getName());
+				}
+			}
+			vo.setProcessCreateTime(processInstance.getStartTime());
+
+			vo.setProcessInstanceId(hisTask.getProcessInstanceId());
+			vo.setTaskName(hisTask.getName());
+			vo.setCreateTime(hisTask.getCreateTime());
+			vo.setEndTime(hisTask.getEndTime());
+			vo.setVariables(hisTask.getProcessVariables());
+
+
+			vo.setProcessCreateTime(processInstance.getStartTime());
+			vo.setHistoryTaskEndTime(hisTask.getEndTime());
+
+			vo.setFile(getFileString(hisTask.getProcessInstanceId()));
+			records.add(vo);
+		}
+
+		page.setRecords(records);
+
+		return page;
+	}
 }

--
Gitblit v1.9.3