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/device/entity/FwDeviceEntity.java |   77 ++++++++++++++++++++++++++++++++++++--
 1 files changed, 73 insertions(+), 4 deletions(-)

diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/entity/FwDeviceEntity.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/entity/FwDeviceEntity.java
index 3c85c21..097d995 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/entity/FwDeviceEntity.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/entity/FwDeviceEntity.java
@@ -17,18 +17,20 @@
 package org.sxkj.fw.device.entity;
 
 import com.baomidou.mybatisplus.annotation.TableName;
-import lombok.Data;
+import com.fasterxml.jackson.annotation.JsonFormat;
 import io.swagger.annotations.ApiModel;
 import io.swagger.annotations.ApiModelProperty;
-import java.math.BigDecimal;
+import lombok.Data;
 import lombok.EqualsAndHashCode;
 import org.springblade.core.mp.base.BaseEntity;
-import org.springblade.core.tenant.mp.TenantEntity;
+
+import java.math.BigDecimal;
+import java.util.Date;
 
 /**
  * 设备表 实体类
  *
- * @author Aix
+ * @author aix
  * @since 2026-01-08
  */
 @Data
@@ -36,6 +38,18 @@
 @ApiModel(value = "FwDevice对象", description = "设备表")
 @EqualsAndHashCode(callSuper = true)
 public class FwDeviceEntity extends BaseEntity {
+
+	/**
+	 * 设备sn
+	 */
+	@ApiModelProperty(value = "设备sn")
+	private String deviceSn;
+
+	/**
+	 * 外部来源设备Id
+	 */
+	@ApiModelProperty(value = "外部来源设备Id")
+	private String airportId;
 
 	/**
 	 * 设备名称
@@ -73,6 +87,26 @@
 	@ApiModelProperty(value = "来源")
 	private String source;
 	/**
+	 * 用途
+	 */
+	@ApiModelProperty(value = "用途")
+	private String purpose;
+	/**
+	 * 所属部门
+	 */
+	@ApiModelProperty(value = "所属部门")
+	private Long belongDept;
+	/**
+	 * 负责人
+	 */
+	@ApiModelProperty(value = "负责人")
+	private String charger;
+	/**
+	 * 联系电话
+	 */
+	@ApiModelProperty(value = "联系电话")
+	private String contactPhone;
+	/**
 	 * 备注
 	 */
 	@ApiModelProperty(value = "备注")
@@ -108,9 +142,44 @@
 	@ApiModelProperty(value = "工作模式:侦测中/信号干扰中/诱导驱离中/待机")
 	private String workMode;
 	/**
+	 * 纬度
+	 */
+	@ApiModelProperty(value = "纬度")
+	private String latitude;
+	/**
+	 * 经度
+	 */
+	@ApiModelProperty(value = "经度")
+	private String longitude;
+	/**
 	 * 区域编码
 	 */
 	@ApiModelProperty(value = "区域编码")
 	private String areaCode;
 
+	/**
+	 * 设备出入库状态 0未出库1已出库
+	 */
+	@ApiModelProperty(value = "设备出入库状态 0未出库1已出库")
+	private Integer trackStatus;
+
+	@ApiModelProperty(value = "最终出库区域(设备出库后的部署区域名称/编码)")
+	private String finalOutboundArea;
+
+	@ApiModelProperty(value = "是否启用:1启用 0禁用")
+	private Integer isEnabled;
+
+	/**
+	 * 使用日期
+	 */
+	@ApiModelProperty(value = "使用日期")
+	// @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+	private Date useDate;
+
+	/**
+	 * 使用年限(单位:年)
+	 */
+	@ApiModelProperty(value = "使用年限(单位:年)")
+	private Integer serviceLife;
+
 }

--
Gitblit v1.9.3