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/vo/GdPatrolTaskVO.java |   47 ++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 44 insertions(+), 3 deletions(-)

diff --git a/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdPatrolTaskVO.java b/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdPatrolTaskVO.java
index 73a97b2..2e7925c 100644
--- a/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdPatrolTaskVO.java
+++ b/drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdPatrolTaskVO.java
@@ -19,6 +19,11 @@
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 import java.util.Date;
+import java.io.Serializable;
+import java.util.List;
+
+import com.fasterxml.jackson.databind.annotation.JsonSerialize;
+import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
 
 /**
  * 巡查任务表 视图实体类
@@ -27,7 +32,7 @@
  * @since 2026-01-14
  */
 @Data
-public class GdPatrolTaskVO {
+public class GdPatrolTaskVO implements Serializable {
 	private static final long serialVersionUID = 1L;
 
 	@ApiModelProperty(value = "成果数量")
@@ -38,6 +43,9 @@
 
 	@ApiModelProperty(value = "工单名称")
 	private String workOrderName;
+
+	@ApiModelProperty(value = "工单状态")
+	private String workOrderStatus;
 
 	/**
 	 * 关联工单任务表ID
@@ -58,13 +66,17 @@
 	/**
 	 * 巡查任务类型(巡查类/安检类等)
 	 */
-	@ApiModelProperty(value = "巡查任务类型 1.巡查类 2.巡检类 3.安保类 4.文旅类 5.采集数据类 ")
-	private String patrolTaskType;
+	@ApiModelProperty(value = "巡查任务类型(二维数组,如:[[\"road\",\"road1\"],[\"bridge\",\"bridge2\"]])")
+	private List<List<String>> patrolTaskType;
 	/**
 	 * 执行时间
 	 */
 	@ApiModelProperty(value = "执行时间")
 	private Date executeTime;
+
+	@ApiModelProperty(value = "巡查任务航线ID")
+	private String airlineId;
+
 	/**
 	 * 巡查任务航线URL
 	 */
@@ -75,11 +87,17 @@
 	 */
 	@ApiModelProperty(value = "推荐飞手名称")
 	private String recommendFlyerName;
+
+	@ApiModelProperty(value = "设备飞手ID")
+	private String deviceFlyerId;
 	/**
 	 * 关联设备ID
 	 */
 	@ApiModelProperty(value = "关联设备ID")
 	private Long deviceId;
+
+	@ApiModelProperty(value = "设备名称")
+	private String deviceName;
 	/**
 	 * 任务描述
 	 */
@@ -90,6 +108,13 @@
 	 */
 	@ApiModelProperty(value = "状态:0待签收、1拒绝签收、2已撤回、3待审核、4审核驳回、5审核通过、6待验收、7拒绝验收、8验收通过")
 	private String taskStatus;
+
+	/**
+	 * 拒绝原因(审核拒绝时必填)
+	 */
+	@ApiModelProperty(value = "拒绝原因(审核拒绝时必填)")
+	private String rejectReason;
+
 	/**
 	 * 区域编码
 	 */
@@ -97,6 +122,7 @@
 	private String areaCode;
 
 	@ApiModelProperty("主键id")
+	@JsonSerialize(using = ToStringSerializer.class)
 	private Long id;
 
 	@ApiModelProperty(value = "创建人")
@@ -120,4 +146,19 @@
 	@ApiModelProperty(value = "逻辑删除")
 	private Integer isDeleted;
 
+	@ApiModelProperty(value = "机场id")
+	private String airportId;
+
+	@ApiModelProperty(value = "高度")
+	private String height;
+
+	@ApiModelProperty(value = "经度")
+	private String longitude;
+
+	@ApiModelProperty(value = "纬度")
+	private String latitude;
+
+	@ApiModelProperty("算法ids")
+	private List<String> algorithmIds;
+
 }

--
Gitblit v1.9.3