From fefe259f19a251d90d17d8a42e04f6332a4cad3e Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Fri, 23 Jan 2026 15:37:30 +0800
Subject: [PATCH] sql 优化
---
drone-service/drone-fw/src/main/java/org/sxkj/fw/device/vo/FwDeviceVO.java | 52 +++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 51 insertions(+), 1 deletions(-)
diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/vo/FwDeviceVO.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/vo/FwDeviceVO.java
index 788e9eb..48b575c 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/vo/FwDeviceVO.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/device/vo/FwDeviceVO.java
@@ -16,6 +16,7 @@
*/
package org.sxkj.fw.device.vo;
+import java.util.Date;
import io.swagger.annotations.ApiModelProperty;
import lombok.Getter;
import org.sxkj.fw.device.entity.FwDeviceEntity;
@@ -23,9 +24,10 @@
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.sxkj.system.cache.SysCache;
-
import java.io.Serializable;
import java.math.BigDecimal;
+import com.fasterxml.jackson.databind.annotation.JsonSerialize;
+import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
/**
* 设备表 视图实体类
@@ -39,6 +41,7 @@
private static final long serialVersionUID = 1L;
@ApiModelProperty(value = "主键")
+ @JsonSerialize(using = ToStringSerializer.class)
private Long id;
/**
@@ -106,6 +109,9 @@
@ApiModelProperty("运行状态（0:在线/1:离线/2:故障/3:报废）")
private Integer status;
+ @ApiModelProperty("创建时间")
+ private Date createTime;
+
/**
* 电量百分比 0-100
*/
@@ -132,6 +138,30 @@
@ApiModelProperty(value = "有效范围 km")
private BigDecimal effectiveRangeKm;
+ /**
+ * 工作模式：侦测中/信号干扰中/诱导驱离中/待机
+ */
+ @ApiModelProperty(value = "工作模式：1.侦测中/2.信号干扰中/3.诱导驱离中/4.待机")
+ private String workMode;
+ /**
+ * 纬度
+ */
+ @ApiModelProperty(value = "纬度")
+ private String latitude;
+ /**
+ * 经度
+ */
+ @ApiModelProperty(value = "经度")
+ private String longitude;
+ /**
+ * 设备sn
+ */
+ @ApiModelProperty(value = "设备sn")
+ private String deviceSn;
+
+ @ApiModelProperty(value = "场景名称")
+ private String sceneName;
+
@ApiModelProperty(value = "所属部门名称")
public String getBelongDeptName() {
if (belongDept == null) {
@@ -140,4 +170,24 @@
return SysCache.getDeptName(belongDept);
}
+ /**
+ * 创建人
+ */
+ @ApiModelProperty(value = "创建人")
+ private Long createUser;
+ /**
+ * 创建部门
+ */
+ @ApiModelProperty(value = "创建部门")
+ private Long createDept;
+ /**
+ * 更新人
+ */
+ @ApiModelProperty(value = "更新人")
+ private Long updateUser;
+ /**
+ * 更新时间
+ */
+ @ApiModelProperty(value = "更新时间")
+ private Date updateTime;
}
--
Gitblit v1.9.3