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/dto/FwDeviceDTO.java |   70 ++++++++++++++++++++++++++++++++++-
 1 files changed, 68 insertions(+), 2 deletions(-)

diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/dto/FwDeviceDTO.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/dto/FwDeviceDTO.java
index c02569d..906b257 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/dto/FwDeviceDTO.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/dto/FwDeviceDTO.java
@@ -16,13 +16,18 @@
  */
 package org.sxkj.fw.device.dto;
 
+import java.util.Date;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 
-import javax.validation.constraints.NotEmpty;
 import java.io.Serializable;
 import java.math.BigDecimal;
 import java.util.List;
+import com.fasterxml.jackson.databind.annotation.JsonSerialize;
+import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
+import org.sxkj.fw.common.FwBaseInfo;
 
 /**
  * 设备表 数据传输对象实体类
@@ -31,11 +36,12 @@
  * @since 2026-01-08
  */
 @Data
-public class FwDeviceDTO implements Serializable {
+public class FwDeviceDTO extends FwBaseInfo implements Serializable {
 
 	private static final long serialVersionUID = 1L;
 
 	@ApiModelProperty(value = "主键")
+	@JsonSerialize(using = ToStringSerializer.class)
 	private	Long id;
 
 	/**
@@ -113,6 +119,12 @@
 	private int effectiveRangeKmIsNotNull ;
 
 	/**
+	 * 是否出库
+	 */
+	@ApiModelProperty(value = "是否出库 0不过滤 1是 2否")
+	private int isTrack;
+
+	/**
 	 * 设备状态,多个状态用逗号隔
 	 */
 	@ApiModelProperty(value = "设备状态,多个状态用逗号隔开")
@@ -134,4 +146,58 @@
 	@ApiModelProperty(value = "经度")
 	private String longitude;
 
+	/**
+	 * 创建人
+	 */
+	@ApiModelProperty(value = "创建人")
+	private Long createUser;
+	/**
+	 * 创建部门
+	 */
+	@ApiModelProperty(value = "创建部门")
+	private Long createDept;
+	/**
+	 * 创建时间
+	 */
+	@ApiModelProperty(value = "创建时间")
+	private Date createTime;
+	/**
+	 * 更新人
+	 */
+	@ApiModelProperty(value = "更新人")
+	private Long updateUser;
+	/**
+	 * 更新时间
+	 */
+	@ApiModelProperty(value = "更新时间")
+	private Date updateTime;
+	/**
+	 * 删除标志(0存在 1删除)
+	 */
+	@ApiModelProperty(value = "删除标志(0存在 1删除)")
+	private Integer isDeleted;
+	// flyTime
+	@ApiModelProperty(value = " flyTime")
+	private Date flyTime;
+
+	/**
+	 * 使用日期
+	 */
+	@ApiModelProperty(value = "使用日期")
+	@JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
+	private Date useDate;
+
+	/**
+	 * 使用年限(单位:年)
+	 */
+	@ApiModelProperty(value = "使用年限(单位:年)")
+	private Integer serviceLife;
+	// isEnabled
+	@ApiModelProperty(value = "是否启用")
+	private Integer isEnabled;
+
+	// track_status
+	@ApiModelProperty(value = "出库状态")
+	private Integer trackStatus;
+
 }

--
Gitblit v1.9.3