From 34a8dd8ad41d9c911a9d03398119eb065cf08fef Mon Sep 17 00:00:00 2001
From: lin <sbla5888@163.com>
Date: Wed, 03 Apr 2024 10:40:53 +0800
Subject: [PATCH] 添加轨迹记录表添加字段
---
src/main/java/org/springblade/modules/policTrajectoryPoint/entity/PolicTrajectoryPointEntity.java | 30 ++++++++++++++++++++++++++++--
src/main/java/org/springblade/modules/policTrajectoryPoint/mapper/PolicTrajectoryPointMapper.xml | 17 ++++++++++++++++-
2 files changed, 44 insertions(+), 3 deletions(-)
diff --git a/src/main/java/org/springblade/modules/policTrajectoryPoint/entity/PolicTrajectoryPointEntity.java b/src/main/java/org/springblade/modules/policTrajectoryPoint/entity/PolicTrajectoryPointEntity.java
index a59d9a0..ca14e8b 100644
--- a/src/main/java/org/springblade/modules/policTrajectoryPoint/entity/PolicTrajectoryPointEntity.java
+++ b/src/main/java/org/springblade/modules/policTrajectoryPoint/entity/PolicTrajectoryPointEntity.java
@@ -41,9 +41,10 @@
public class PolicTrajectoryPointEntity {
+
/** id */
- @ApiModelProperty("主键id")
- @TableId(value = "id", type = IdType.ASSIGN_ID)
+ @ApiModelProperty(value = "主键ID", example = "")
+ @TableId(value = "id", type = IdType.AUTO)
private Long id;
/** 用户id */
@@ -66,4 +67,29 @@
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
@TableField(value = "create_time",fill = FieldFill.INSERT)
private Date createTime;
+
+ /** 速度，单位 m/s */
+ @ApiModelProperty(value = "速度，单位 m/s", example = "")
+ @TableField("speed")
+ private Double speed;
+
+ /** 位置的精确度 */
+ @ApiModelProperty(value = "位置的精确度", example = "")
+ @TableField("accuracy")
+ private Double accuracy;
+
+ /** 高度，单位 m */
+ @ApiModelProperty(value = "高度，单位 m", example = "")
+ @TableField("altitude")
+ private Double altitude;
+
+ /** 垂直精度，单位 m（Android 无法获取，返回 0） */
+ @ApiModelProperty(value = "垂直精度，单位 m（Android 无法获取，返回 0）", example = "")
+ @TableField("verticalAccuracy")
+ private Double verticalAccuracy;
+
+ /** 水平精度，单位 m */
+ @ApiModelProperty(value = "水平精度，单位 m", example = "")
+ @TableField("horizontalAccuracy")
+ private Double horizontalAccuracy;
}
diff --git a/src/main/java/org/springblade/modules/policTrajectoryPoint/mapper/PolicTrajectoryPointMapper.xml b/src/main/java/org/springblade/modules/policTrajectoryPoint/mapper/PolicTrajectoryPointMapper.xml
index e00e987..8c50d0f 100644
--- a/src/main/java/org/springblade/modules/policTrajectoryPoint/mapper/PolicTrajectoryPointMapper.xml
+++ b/src/main/java/org/springblade/modules/policTrajectoryPoint/mapper/PolicTrajectoryPointMapper.xml
@@ -16,6 +16,11 @@
<result property="latitude" column="latitude" />
<result property="longitude" column="longitude" />
<result property="createTime" column="create_time" />
+ <result property="speed" column="speed" />
+ <result property="accuracy" column="accuracy" />
+ <result property="altitude" column="altitude" />
+ <result property="verticalAccuracy" column="verticalAccuracy" />
+ <result property="horizontalAccuracy" column="horizontalAccuracy" />
</resultMap>
<sql id="selectPolicTrajectoryPoint">
@@ -24,7 +29,12 @@
user_id,
latitude,
longitude,
- create_time
+ create_time,
+ speed,
+ accuracy,
+ altitude,
+ verticalAccuracy,
+ horizontalAccuracy
from
jczz_polic_trajectory_point
</sql>
@@ -43,6 +53,11 @@
<if test="latitude != null "> and latitude = #{latitude}</if>
<if test="longitude != null "> and longitude = #{longitude}</if>
<if test="createTime != null "> and create_time = #{createTime}</if>
+ <if test="speed != null "> and speed = #{speed}</if>
+ <if test="accuracy != null "> and accuracy = #{accuracy}</if>
+ <if test="altitude != null "> and altitude = #{altitude}</if>
+ <if test="verticalAccuracy != null "> and verticalAccuracy = #{verticalAccuracy}</if>
+ <if test="horizontalAccuracy != null "> and horizontalAccuracy = #{horizontalAccuracy}</if>
</where>
</select>
--
Gitblit v1.9.3