From 047bb771200a233eff32141b963cfdc5b362b4a1 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期四, 14 八月 2025 11:57:44 +0800
Subject: [PATCH] 流程查询按时间搜索错误问题修改

---
 blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/controller/FlowMgrController.java |  114 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 111 insertions(+), 3 deletions(-)

diff --git a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/controller/FlowMgrController.java b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/controller/FlowMgrController.java
index f742e48..13a1b71 100644
--- a/blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/controller/FlowMgrController.java
+++ b/blade-service/blade-mdm/src/main/java/org/springblade/mdm/flow/controller/FlowMgrController.java
@@ -7,22 +7,39 @@
 import io.swagger.v3.oas.annotations.tags.Tag;
 import jakarta.servlet.http.HttpServletResponse;
 import lombok.extern.slf4j.Slf4j;
+import org.flowable.engine.HistoryService;
+import org.flowable.engine.RuntimeService;
 import org.flowable.engine.TaskService;
+import org.flowable.engine.task.Comment;
+import org.flowable.task.api.history.HistoricTaskInstance;
 import org.springblade.core.excel.util.ExcelUtil;
+import org.springblade.core.log.exception.ServiceException;
 import org.springblade.core.mp.support.Condition;
 import org.springblade.core.mp.support.Query;
 import org.springblade.core.tool.api.R;
 import org.springblade.core.tool.utils.DateUtil;
+import org.springblade.core.tool.utils.Func;
 import org.springblade.mdm.basesetting.machine.vo.MachineExcelVO;
+import org.springblade.mdm.commons.vo.IdsVO;
+import org.springblade.mdm.flow.entity.ApproveRecord;
+import org.springblade.mdm.flow.service.ApproveRecordService;
+import org.springblade.mdm.flow.service.ApproveTableService;
 import org.springblade.mdm.flow.service.FlowBusinessService;
 import org.springblade.mdm.flow.vo.FlowVO;
 import org.springblade.mdm.flow.vo.OvertimeTaskExcelVO;
 import org.springblade.mdm.flow.vo.TaskTraceVO;
+import org.springblade.system.feign.IUserClient;
+import org.springblade.system.pojo.entity.User;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.format.annotation.DateTimeFormat;
 import org.springframework.web.bind.annotation.*;
 
+import java.io.IOException;
+import java.net.URLEncoder;
+import java.nio.charset.StandardCharsets;
 import java.time.LocalDate;
+import java.time.LocalDateTime;
 import java.util.ArrayList;
 import java.util.Collections;
 import java.util.List;
@@ -37,6 +54,16 @@
 	@Autowired
 	private FlowBusinessService businessService;
 
+	@Autowired
+	private HistoryService historyService;
+	@Autowired
+	private RuntimeService runtimeService;
+	@Autowired
+	private ApproveTableService approveTableService;
+	@Autowired
+	private ApproveRecordService approveRecordService;
+	@Autowired
+	private IUserClient userClient;
 	@GetMapping("overtime-list")
 	@ApiOperationSupport(order = 3)
 	@Operation(summary = "瓒呮椂鏌ヨ", description = "鏌ヨ鎵�鏈夎秴鏃朵换鍔�")
@@ -65,11 +92,92 @@
 	}
 
 
-
+	@Operation(summary = "娴佺▼鎵ц杞ㄨ抗", description = "娴佺▼鎵ц杞ㄨ抗/瀹℃壒璁板綍")
 	@GetMapping("process-trace")
-	public R<List<TaskTraceVO>> processTrace(long processInstanceId){
-		return R.data(Collections.emptyList());
+	public R<List<TaskTraceVO>> processTrace(String processInstanceId){
+		/*
+		List<ApproveRecord> records = approveRecordService.lambdaQuery().eq(ApproveRecord::getProcessInstanceId,processInstanceId).orderByAsc(ApproveRecord::getCreateTime).list();
+		List<TaskTraceVO> result = new ArrayList<>();
+
+		for (ApproveRecord record : records) {
+			TaskTraceVO vo = new TaskTraceVO();
+			vo.setComment(record.getComment());
+			vo.setCreateTime(record.getCreateTime());
+			vo.setAssigneeName(record.getUserNickname());
+
+			//vo.setEndTime();
+		}*/
+
+		List<TaskTraceVO> result = new ArrayList<>();
+		List<HistoricTaskInstance> hisTasks = historyService.createHistoricTaskInstanceQuery()
+			.processInstanceId(processInstanceId).orderByTaskCreateTime().desc().list();
+// 鎵规敞淇℃伅
+		List<Comment> comments;
+		for (HistoricTaskInstance hisTask : hisTasks) {
+			TaskTraceVO vo = new TaskTraceVO();
+			BeanUtils.copyProperties(hisTask, vo);
+			comments = taskService.getTaskComments(hisTask.getId());
+			if(!comments.isEmpty()) {
+				vo.setComment(comments.get(0).getFullMessage());
+			}
+
+			vo.setTaskName(hisTask.getName());
+
+			R<User> assigneeObj = userClient.userInfoById(Func.toLong(hisTask.getAssignee()));
+			if(assigneeObj.isSuccess()) {
+				vo.setAssigneeName(assigneeObj.getData().getName());
+			}
+
+			result.add(vo);
+		}
+
+		return R.data(result);
 	}
 
+	@GetMapping("search-list")
+	@ApiOperationSupport(order = 3)
+	@Operation(summary = "娴佺▼鏌ヨ", description = "鏌ヨ杩涜涓殑鎵�鏈夋祦绋�")
+	public R<IPage<FlowVO>> searchList(@Parameter(description = "娴佺▼绫诲瀷")String processDefinitionKey, @Parameter(description = "娴佺▼鏃堕棿寮�濮�") @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")LocalDate createTimeBegin, @Parameter(description = "娴佺▼鍒涘缓鏃堕棿鎴")@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")LocalDate createTimeEnd, @Parameter(description = "鍏抽敭瀛�") String keyword, Query query) {
+		IPage<FlowVO> pages = businessService.selectSearchPage(Condition.getPage(query), createTimeBegin,createTimeEnd,processDefinitionKey,keyword);
+		return R.data(pages);
+	}
 
+	@GetMapping("finished-list")
+	@ApiOperationSupport(order = 3)
+	@Operation(summary = "鍘嗗彶娴佺▼鏌ヨ", description = "鏌ヨ宸插畬缁撶殑鎵�鏈夋祦绋�")
+	public R<IPage<FlowVO>> finishedList(@Parameter(description = "娴佺▼绫诲瀷")String processDefinitionKey, @Parameter(description = "浠诲姟鍒拌揪鏃堕棿寮�濮�") LocalDateTime createTimeBegin, @Parameter(description = "浠诲姟鍒拌揪鏃堕棿鎴") LocalDateTime createTimeEnd, @Parameter(description = "鍏抽敭瀛�") String keyword, Query query) {
+		IPage<FlowVO> pages = businessService.selectFinishedPage(Condition.getPage(query), processDefinitionKey,createTimeBegin,createTimeEnd,keyword);
+		return R.data(pages);
+	}
+
+	@PostMapping("delete-instance")
+	@Operation(summary = "娴佺▼鍒犻櫎", description = "鍒犻櫎id鎸囧畾鐨勬祦绋嬪疄渚�")
+	public R<Void> deleteInstance(@Parameter(description = "浠诲姟鍒拌揪鏃堕棿寮�濮�") String processInstanceId) {
+		try {
+			businessService.deleteProcessInstance(processInstanceId);
+
+		} catch (Exception e) {
+			log.error("鍒犻櫎娴佺▼澶辫触",e);
+			return R.fail(e.getMessage());
+		}
+		return R.success();
+	}
+
+	@PostMapping("/export-approve-table")
+	@Operation(summary = "瀵煎嚭瀹℃壒琛�", description = "瀵煎嚭瀹℃壒琛╡xcel")
+	public void exportApproveTable(String processInstanceId, HttpServletResponse response) {
+
+		try {
+
+			String filename = URLEncoder.encode("鏁版帶绋嬪簭缂栧埗瀹℃壒鍗�", StandardCharsets.UTF_8)+ DateUtil.format(DateUtil.now(), "yyyyMMddHHmm")+".pdf";
+
+			response.setHeader("Content-Disposition", "attachment; filename="+filename);
+			response.setContentType("application/octet-stream");
+			approveTableService.exportApproveTable(processInstanceId,response.getOutputStream());
+		} catch (Exception e) {
+			log.error("瀵煎嚭瀹℃壒琛ㄥ紓甯�", e);
+			throw new RuntimeException(e);
+		}
+
+	}
 }

--
Gitblit v1.9.3