志愿者活动增加经纬度字段

lidongdong

2023-08-18 d6b81d600ab6671e532ed77ed6fb00678e5b864b

志愿者活动增加经纬度字段

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/VolunteerActivityVO.java

@@ -123,4 +123,10 @@
    @ApiModelProperty(value = "社区id")
    private String communityId;

    @ApiModelProperty(value = "纬度")
    private String lat;

    @ApiModelProperty(value = "经度")
    private String lng;

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/VolunteerActivity.java

@@ -139,8 +139,11 @@
    @ApiModelProperty(value = "社区id")
    private String communityId;

    @ApiModelProperty(value = "纬度")
    private String lat;


    @ApiModelProperty(value = "经度")
    private String lng;




 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerActivityMapper.xml

@@ -25,6 +25,8 @@
        <result property="activityContent" column="activity_content" />
        <result property="creationTime" column="creation_time" />
        <result property="updateTime" column="update_time" />
        <result property="lat" column="lat" />
        <result property="lng" column="lng" />

    </resultMap>

@@ -52,7 +54,9 @@
            activity_cover_url,
            activity_content,
            creation_time,
            update_time
            update_time,
            lng,
            lat
        from volunteer_activity
        where id= #{id}
    </select>
@@ -81,7 +85,9 @@
            activity_cover_url,
            activity_content,
            creation_time,
            update_time
            update_time,
            lng,
            lat
        from volunteer_activity
        <where>
            1=1
@@ -168,6 +174,12 @@
            <if test="volunteerActivityVO.activityContent != null">
                activity_content,
            </if>
            <if test="volunteerActivityVO.lng != null">
                lng,
            </if>
            <if test="volunteerActivityVO.lat != null">
                lat,
            </if>
            creation_time
        </trim>
        values
@@ -227,10 +239,16 @@
                #{volunteerActivityVO.contactPhone},
            </if>
            <if test="volunteerActivityVO.activitCoverUrl != null">
                #{volunteerActivityVO.activitCoverUrl,
                #{volunteerActivityVO.activitCoverUrl},
            </if>
            <if test="volunteerActivityVO.activityContent != null">
                #{volunteerActivityVO.activityContent,
                #{volunteerActivityVO.activityContent},
            </if>
            <if test="volunteerActivityVO.lng != null">
                #{volunteerActivityVO.lng},
            </if>
            <if test="volunteerActivityVO.lat != null">
                #{volunteerActivityVO.lat},
            </if>
            sysdate()
        </trim>
@@ -299,6 +317,12 @@
            <if test="volunteerActivityVO.activityContent != null">
                activity_content=#{volunteerActivityVO.activityContent},
            </if>
            <if test="volunteerActivityVO.lng != null">
                lng=#{volunteerActivityVO.lng},
            </if>
            <if test="volunteerActivityVO.lat != null">
                lat=#{volunteerActivityVO.lat},
            </if>
            update_time=sysdate()
        </set>
        where id = #{volunteerActivityVO.id}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerTypeMapper.xml

@@ -16,6 +16,7 @@
        id,
        name,
        creation_time,
        community_id,
        update_time
        from volunteer_type
        order by creation_time desc