From 08ddfad4530a014094c06fe68b8c2d9a0753403a Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Wed, 05 Aug 2026 14:09:29 +0800
Subject: [PATCH] fix(gd): 修复线索事件查询中的SQL语法错误
---
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/entity/GdWorkOrderEntity.java | 14 +++++++++++---
1 files changed, 11 insertions(+), 3 deletions(-)
diff --git a/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/entity/GdWorkOrderEntity.java b/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/entity/GdWorkOrderEntity.java
index 9ae916d..b1e56b5 100644
--- a/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/entity/GdWorkOrderEntity.java
+++ b/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/entity/GdWorkOrderEntity.java
@@ -24,9 +24,11 @@
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.springblade.core.mp.base.BaseEntity;
+import org.sxkj.common.handler.GenericListTypeHandler;
import org.sxkj.gd.config.GeometryTypeHandler;
import java.util.Date;
+import java.util.List;
/**
* 工单任务表 实体类
@@ -55,9 +57,15 @@
/**
* 工单类型（巡查类/安检类等）
*/
- @ApiModelProperty(value = "工单类型（巡查类/安检类等）")
- @TableField("work_order_type")
- private String workOrderType;
+ @ApiModelProperty(value = "工单类型（二维数组，如：[[\"road\",\"road1\"],[\"bridge\",\"bridge2\"]]）")
+ @TableField(value = "work_order_type", typeHandler = GenericListTypeHandler.class)
+ private List<List<String>> workOrderType;
+ /**
+ * 工单类型拼音首字母（用于排序，如：B、L、Z）
+ */
+ @ApiModelProperty(value = "工单类型拼音首字母（用于排序，如：B、L、Z）")
+ @TableField("type_pinyin_first")
+ private String typePinyinFirst;
/**
* 设备负载需求（红外、喊话器、探照灯）
*/
--
Gitblit v1.9.3