From ebeb43ea497fafc448c827d1de6796bcaa4e0b52 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Tue, 23 Jun 2026 13:59:46 +0800
Subject: [PATCH] add : 吉安支持查询待验收的接口
---
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/controller/GdWorkOrderFlowController.java | 112 ++++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 85 insertions(+), 27 deletions(-)
diff --git a/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/controller/GdWorkOrderFlowController.java b/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/controller/GdWorkOrderFlowController.java
index c83abdb..b3fdba6 100644
--- a/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/controller/GdWorkOrderFlowController.java
+++ b/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/controller/GdWorkOrderFlowController.java
@@ -1,33 +1,30 @@
package org.sxkj.gd.workorder.controller;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
-import io.swagger.annotations.ApiParam;
-import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
import lombok.AllArgsConstructor;
-import javax.validation.Valid;
-
-import org.springblade.core.secure.BladeUser;
-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.Func;
-import org.springframework.web.bind.annotation.*;
-import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.baomidou.mybatisplus.core.metadata.IPage;
-import org.sxkj.gd.workorder.entity.GdWorkOrderFlowEntity;
-import org.sxkj.gd.workorder.vo.GdWorkOrderFlowVO;
-import org.sxkj.gd.workorder.excel.GdWorkOrderFlowExcel;
-import org.sxkj.gd.workorder.wrapper.GdWorkOrderFlowWrapper;
-import org.sxkj.gd.workorder.service.IGdWorkOrderFlowService;
import org.springblade.core.boot.ctrl.BladeController;
-import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.excel.util.ExcelUtil;
+import org.springblade.core.mp.support.Condition;
+import org.springblade.core.secure.BladeUser;
+import org.springblade.core.tool.api.R;
import org.springblade.core.tool.constant.BladeConstant;
+import org.springblade.core.tool.utils.DateUtil;
+import org.springframework.web.bind.annotation.*;
+import org.sxkj.gd.workorder.entity.GdWorkOrderFlowEntity;
+import org.sxkj.gd.workorder.excel.GdWorkOrderFlowExcel;
+import org.sxkj.gd.workorder.service.IGdWorkOrderFlowService;
+import org.sxkj.gd.workorder.vo.GdWorkOrderFlowVO;
+import org.sxkj.gd.workorder.vo.WorkOrderStageVO;
+import org.sxkj.gd.workorder.wrapper.GdWorkOrderFlowWrapper;
import springfox.documentation.annotations.ApiIgnore;
-import java.util.Map;
-import java.util.List;
+
import javax.servlet.http.HttpServletResponse;
+import javax.validation.Valid;
+import java.util.List;
+import java.util.Map;
/**
* 流程记录表 控制器
@@ -55,12 +52,62 @@
}
/**
* 流程记录表 列表
+ * 返回分层结构的流程数据，包含所有状态（已到达和未到达的）
+ *
+ * @param gdWorkOrderFlow 查询参数
+ * @return 分层结构的流程数据
*/
@GetMapping("/list")
@ApiOperationSupport(order = 2)
- @ApiOperation(value = "列表", notes = "传入gdWorkOrderFlow")
- public R<List<GdWorkOrderFlowVO>> list(@ApiIgnore @RequestParam Map<String, Object> gdWorkOrderFlow) {
- List<GdWorkOrderFlowEntity> list = gdWorkOrderFlowService.list(Condition.getQueryWrapper(gdWorkOrderFlow, GdWorkOrderFlowEntity.class));
+ @ApiOperation(value = "工单流程列表", notes = "传入gdWorkOrderFlow")
+ public R<List<WorkOrderStageVO>> list(@ApiIgnore @RequestParam Map<String, Object> gdWorkOrderFlow) {
+ // 手动构建查询条件,避免 Long 类型字段使用 LIKE 导致 Kingbase8 类型错误
+ QueryWrapper<GdWorkOrderFlowEntity> queryWrapper = new QueryWrapper<>();
+ queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getIsDeleted, BladeConstant.DB_NOT_DELETED);
+
+ // 处理 workOrderId (Long 类型,使用 EQ 而非 LIKE)
+ Object workOrderId = gdWorkOrderFlow.get("workOrderId");
+ if (workOrderId != null && !"".equals(workOrderId.toString())) {
+ queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getWorkOrderId, Long.parseLong(workOrderId.toString()));
+ }
+
+ // 处理 type 字段 (String 类型,可以使用 LIKE)
+ Object type = gdWorkOrderFlow.get("type");
+ if (type != null && !"".equals(type.toString())) {
+ queryWrapper.lambda().like(GdWorkOrderFlowEntity::getType, type.toString());
+ }
+ queryWrapper.lambda().orderByDesc(GdWorkOrderFlowEntity::getCreateTime);
+
+ // 调用服务层方法获取分层结构的流程数据
+ List<WorkOrderStageVO> stages = gdWorkOrderFlowService.getHierarchicalFlow(queryWrapper);
+
+ return R.data(stages);
+ }
+
+ /**
+ * 流程记录表 列表
+ */
+ @GetMapping("/patrolList")
+ @ApiOperationSupport(order = 2)
+ @ApiOperation(value = "巡查流程列表", notes = "传入gdWorkOrderFlow")
+ public R<List<GdWorkOrderFlowVO>> patrolList(@ApiIgnore @RequestParam Map<String, Object> gdWorkOrderFlow) {
+ // 手动构建查询条件,避免 Long 类型字段使用 LIKE 导致 Kingbase8 类型错误
+ QueryWrapper<GdWorkOrderFlowEntity> queryWrapper = new QueryWrapper<>();
+ queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getIsDeleted, BladeConstant.DB_NOT_DELETED);
+
+ // 处理 workOrderId (Long 类型,使用 EQ 而非 LIKE)
+ Object workOrderId = gdWorkOrderFlow.get("workOrderId");
+ if (workOrderId != null && !"".equals(workOrderId.toString())) {
+ queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getWorkOrderId, Long.parseLong(workOrderId.toString()));
+ }
+
+ // 处理 type 字段 (String 类型,可以使用 LIKE)
+ Object type = gdWorkOrderFlow.get("type");
+ if (type != null && !"".equals(type.toString())) {
+ queryWrapper.lambda().like(GdWorkOrderFlowEntity::getType, type.toString());
+ }
+ queryWrapper.lambda().orderByAsc(GdWorkOrderFlowEntity::getCreateTime);
+ List<GdWorkOrderFlowEntity> list = gdWorkOrderFlowService.list(queryWrapper);
return R.data(GdWorkOrderFlowWrapper.build().entityVOList(list));
}
@@ -124,11 +171,22 @@
@ApiOperation(value = "导出数据", notes = "传入gdWorkOrderFlow")
@ApiIgnore
public void exportGdWorkOrderFlow(@ApiIgnore @RequestParam Map<String, Object> gdWorkOrderFlow, BladeUser bladeUser, HttpServletResponse response) {
- QueryWrapper<GdWorkOrderFlowEntity> queryWrapper = Condition.getQueryWrapper(gdWorkOrderFlow, GdWorkOrderFlowEntity.class);
- //if (!AuthUtil.isAdministrator()) {
- // queryWrapper.lambda().eq(GdWorkOrderFlow::getTenantId, bladeUser.getTenantId());
- //}
+ // 手动构建查询条件,避免 Long 类型字段使用 LIKE 导致 Kingbase8 类型错误
+ QueryWrapper<GdWorkOrderFlowEntity> queryWrapper = new QueryWrapper<>();
queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getIsDeleted, BladeConstant.DB_NOT_DELETED);
+
+ // 处理 workOrderId (Long 类型,使用 EQ 而非 LIKE)
+ Object workOrderId = gdWorkOrderFlow.get("workOrderId");
+ if (workOrderId != null && !"".equals(workOrderId.toString())) {
+ queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getWorkOrderId, Long.parseLong(workOrderId.toString()));
+ }
+
+ // 处理 type 字段 (String 类型,可以使用 LIKE)
+ Object type = gdWorkOrderFlow.get("type");
+ if (type != null && !"".equals(type.toString())) {
+ queryWrapper.lambda().like(GdWorkOrderFlowEntity::getType, type.toString());
+ }
+
List<GdWorkOrderFlowExcel> list = gdWorkOrderFlowService.exportGdWorkOrderFlow(queryWrapper);
ExcelUtil.export(response, "流程记录表数据" + DateUtil.time(), "流程记录表数据表", list, GdWorkOrderFlowExcel.class);
}
--
Gitblit v1.9.3