添加轨迹记录表添加字段

lin

2024-04-03 34a8dd8ad41d9c911a9d03398119eb065cf08fef

添加轨迹记录表添加字段

 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;
}

 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>