吉安感知网项目-后端
linwei
2026-06-09 f6579c4adfa07e9d9c74a21e87e65aebe6830822
feat(workorder): 添加线索事件的geojson和附件类型字段

- 在GdClueEventMapper.xml中添加geojson和attachment_type的结果映射
- 在查询语句中增加tr.geojson和tr.attachment_type字段
- 在GdClueEventVO中添加geojson属性用于存储事件geojson数据
- 在GdClueEventVO中添加attachmentType属性用于存储事件附件类型
- 更新结果映射配置以支持新增字段的数据映射
2 files modified
13 ■■■■■ changed files
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdClueEventMapper.xml 6 ●●●● patch | view | raw | blame | history
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdClueEventVO.java 7 ●●●●● patch | view | raw | blame | history
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdClueEventMapper.xml
@@ -49,6 +49,8 @@
        <result column="update_time" property="updateTime"/>
        <result column="status" property="status"/>
        <result column="is_deleted" property="isDeleted"/>
        <result column="geojson" property="geojson"/>
        <result column="attachment_type" property="attachmentType"/>
    </resultMap>
    <resultMap id="gdClueEventListVoResultMap" type="org.sxkj.gd.workorder.vo.GdClueEventListVO">
@@ -123,7 +125,9 @@
        concat(ce.longitude, ',', ce.latitude) as event_location,
        ce.event_num as event_num,
        tr.shoot_time as shoot_time,
        tr.result_url as event_image_url
        tr.result_url as event_image_url,
        tr.geojson as geojson,
        tr.attachment_type
        from ja_gd_clue_event ce
        left join blade_user bu on bu.id::VARCHAR = ce.dispose_user::VARCHAR and bu.is_deleted = 0
        left join blade_dept bd on bd.id::VARCHAR = ce.dispose_dept::VARCHAR and bd.is_deleted = 0
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdClueEventVO.java
@@ -168,4 +168,11 @@
    @ApiModelProperty(value = "删除标志(0存在 1删除)")
    private Integer isDeleted;
    @ApiModelProperty(value = "事件geojson")
    private String geojson;
    @ApiModelProperty(value = "事件附件类型")
    private Integer attachmentType;
}