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/flyer/entity/GdFlyerEntity.java | 38 ++++++++++++++++++++++++++++++--------
1 files changed, 30 insertions(+), 8 deletions(-)
diff --git a/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/entity/GdFlyerEntity.java b/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/entity/GdFlyerEntity.java
index 209868c..cd6f942 100644
--- a/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/entity/GdFlyerEntity.java
+++ b/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/entity/GdFlyerEntity.java
@@ -16,14 +16,18 @@
*/
package org.sxkj.gd.flyer.entity;
+import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.springblade.core.mp.base.BaseEntity;
+import org.sxkj.common.handler.GenericListTypeHandler;
import java.math.BigDecimal;
+import java.util.List;
/**
* 飞手表 实体类
@@ -32,7 +36,7 @@
* @since 2026-01-14
*/
@Data
-@TableName("ja_gd_flyer")
+@TableName(value = "ja_gd_flyer", autoResultMap = true)
@ApiModel(value = "GdFlyer对象", description = "飞手表")
@EqualsAndHashCode(callSuper = true)
public class GdFlyerEntity extends BaseEntity {
@@ -42,11 +46,17 @@
*/
@ApiModelProperty(value = "飞手姓名")
private String flyerName;
+
+ @ApiModelProperty(value = "飞手Id（星图）")
+ private String flyerId;
/**
* 飞手电话（唯一）
*/
@ApiModelProperty(value = "飞手电话（唯一）")
private String flyerPhone;
+
+ @ApiModelProperty(value = "区域cod :1200,1201,120105")
+ private String regionCode;
/**
* 飞行时长（小时）
*/
@@ -58,24 +68,36 @@
@ApiModelProperty(value = "项目经验")
private String projectExperience;
/**
- * 技术专长（农业植保/电力巡检等）
+ * 技术专长（0:农业植保 1:电力巡检 2:航拍测绘）
*/
- @ApiModelProperty(value = "技术专长（农业植保/电力巡检等）")
+ @ApiModelProperty(value = "技术专长（0:农业植保 1:电力巡检 2:航拍测绘）")
private String technicalStrength;
/**
- * 擅长机型（微型无人机/轻型无人机等）
+ * 擅长机型（0:微型无人机 1:轻型无人机等 2:小型无人机 3:中型无人机等 4:大型无人机）
*/
- @ApiModelProperty(value = "擅长机型（微型无人机/轻型无人机等）")
+ @ApiModelProperty(value = "擅长机型（0:微型无人机 1:轻型无人机等 2:小型无人机 3:中型无人机等 4:大型无人机）")
private String skilledUavType;
/**
- * 擅长任务类型（巡查类/安保类等）
+ * 擅长任务类型（0:巡查类 1:安保类 2:文旅类 3:采集数据类）
*/
- @ApiModelProperty(value = "擅长任务类型（巡查类/安保类等）")
- private String skilledTaskType;
+ @ApiModelProperty(value = "擅长任务类型（0:巡查类 1:安保类 2:文旅类 3:采集数据类）")
+ @TableField(typeHandler = GenericListTypeHandler.class)
+ private List<List<String>> skilledTaskType;
/**
* 区域编码
*/
@ApiModelProperty(value = "区域编码")
private String areaCode;
+ /**
+ * 飞手地址
+ */
+ @ApiModelProperty(value = "飞手地址")
+ private String flyerAddress;
+ /**
+ * 飞手资质证书地址列表
+ */
+ @ApiModelProperty(value = "飞手资质证书地址列表")
+ @TableField(typeHandler = JacksonTypeHandler.class)
+ private List<String> certification;
}
--
Gitblit v1.9.3