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-fw/src/main/java/org/sxkj/fw/record/entity/FwDroneFlightRecordEntity.java |   61 +++++++++++++++++++++++++++++-
 1 files changed, 58 insertions(+), 3 deletions(-)

diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/entity/FwDroneFlightRecordEntity.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/entity/FwDroneFlightRecordEntity.java
index e37f627..c687990 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/entity/FwDroneFlightRecordEntity.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/entity/FwDroneFlightRecordEntity.java
@@ -17,18 +17,21 @@
 package org.sxkj.fw.record.entity;
 
 import com.baomidou.mybatisplus.annotation.TableName;
-import lombok.Data;
+import com.baomidou.mybatisplus.annotation.TableField;
 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.springblade.core.tenant.mp.TenantEntity;
+
+import java.time.LocalTime;
+import java.util.Date;
 
 /**
  * 无人机飞行记录表 实体类
  *
  * @author lw
- * @since 2026-01-07
+ * @since 2026-01-08
  */
 @Data
 @TableName("ja_fw_drone_flight_record")
@@ -36,5 +39,57 @@
 @EqualsAndHashCode(callSuper = true)
 public class FwDroneFlightRecordEntity extends BaseEntity {
 
+	/**
+	 * 反无设备ID(关联ja_fw_device.id)
+	 */
+	@TableField("device_id")
+	@ApiModelProperty(value = "反无设备ID(关联ja_fw_device.id)")
+	private Long deviceId;
 
+	@TableField("area_divide_id")
+	@ApiModelProperty(value = "区域id ja_fw_area_divide")
+	private Long areaDivideId;
+	/**
+	 * 无人机名称
+	 */
+	@TableField("drone_name")
+	@ApiModelProperty(value = "无人机名称")
+	private String droneName;
+	/**
+	 * 序列号
+	 */
+	@TableField("serial_no")
+	@ApiModelProperty(value = "序列号")
+	private String serialNo;
+	/**
+	 * 首次告警时间
+	 */
+	@TableField("alarm_time")
+	@ApiModelProperty(value = "首次告警时间")
+	private Date alarmTime;
+	/**
+	 * 触发原因/类型
+	 */
+	@TableField("trigger_type")
+	@ApiModelProperty(value = "触发原因/类型")
+	private String triggerType;
+	/**
+	 * 停留时长(秒)
+	 */
+	@TableField("stay_duration")
+	@ApiModelProperty(value = "停留时长(秒)")
+	private String stayDuration;
+	/**
+	 * 区域编码
+	 */
+	@TableField("area_code")
+	@ApiModelProperty(value = "区域编码")
+	private String areaCode;
+
+	/**
+	 * 区域名称
+	 */
+	@TableField("area_name")
+	@ApiModelProperty(value = "区域名称")
+	private String areaName;
 }

--
Gitblit v1.9.3