From 8585b431e9257333413358eb37c30ae58f74db76 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Thu, 13 Aug 2026 15:46:10 +0800
Subject: [PATCH] refactor(database): 优化数据库查询中的字段映射
---
drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/vo/GdFlyerVO.java | 20 +++++++++++++++++++-
1 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/vo/GdFlyerVO.java b/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/vo/GdFlyerVO.java
index 4bef260..4f02821 100644
--- a/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/vo/GdFlyerVO.java
+++ b/drone-service/drone-gd/src/main/java/org/sxkj/gd/flyer/vo/GdFlyerVO.java
@@ -16,6 +16,7 @@
*/
package org.sxkj.gd.flyer.vo;
+import com.baomidou.mybatisplus.annotation.TableField;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
@@ -24,6 +25,7 @@
import java.io.Serializable;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
+import org.sxkj.common.handler.GenericListTypeHandler;
/**
* 飞手表 视图实体类
@@ -38,6 +40,9 @@
@ApiModelProperty("主键id")
@JsonSerialize(using = ToStringSerializer.class)
private Long id;
+
+ @ApiModelProperty(value = "飞手Id（星图）")
+ private String flyerId;
/**
* 飞手姓名
*/
@@ -72,7 +77,8 @@
* 擅长任务类型（0:巡查类 1:安保类 2:文旅类 3:采集数据类）
*/
@ApiModelProperty(value = "擅长任务类型（0:巡查类 1:安保类 2:文旅类 3:采集数据类）")
- private String skilledTaskType;
+ @TableField(typeHandler = GenericListTypeHandler.class)
+ private List<List<String>> skilledTaskType;
/**
* 区域编码
*/
@@ -88,4 +94,16 @@
*/
@ApiModelProperty(value = "飞手资质证书地址列表")
private List<String> certification;
+
+ /**
+ * 区域匹配标识（0:未匹配 1:匹配）
+ */
+ @ApiModelProperty(value = "区域匹配标识（0:未匹配 1:匹配）")
+ private Integer areaMatchFlag;
+
+ /**
+ * 任务类型匹配标识（0:未匹配 1:匹配）
+ */
+ @ApiModelProperty(value = "任务类型匹配标识（0:未匹配 1:匹配）")
+ private Integer taskTypeMatchFlag;
}
--
Gitblit v1.9.3