吉安感知网项目-后端
linwei
8 hours ago ef66d1e81feb1290f00abd433271f66468284e25
feat(workorder): 添加线索事件缩略图URL字段支持

- 在GdClueEventListVO中新增thumbnailUrl字段用于存储缩略图URL
- 更新GdClueEventMapper.xml映射文件添加缩略图URL的数据库映射配置
- 修改查询语句以包含缩略图URL字段的数据获取逻辑
2 files modified
7 ■■■■■ changed files
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdClueEventMapper.xml 2 ●●●●● patch | view | raw | blame | history
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdClueEventListVO.java 5 ●●●●● patch | view | raw | blame | history
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdClueEventMapper.xml
@@ -73,6 +73,7 @@
        <result column="area_code" property="areaCode"/>
        <result column="event_num" property="eventNum"/>
        <result column="attach_url" property="attachUrl"/>
        <result column="thumbnail_url" property="thumbnailUrl"/>
    </resultMap>
    <resultMap id="gdClueEventCountVoResultMap" type="org.sxkj.gd.workorder.vo.GdClueEventCountVO">
@@ -118,6 +119,7 @@
            COALESCE(tr.attachment_type, ce.attachment_type) as attachment_type,
            ce.create_time as create_time,
            tr.shoot_time as shoot_time,
            tr.thumbnail_url as thumbnailUrl,
            COALESCE(bu.real_name, bu.name) as dispose_user_name,
            bd.dept_name as dispose_dept_name,
            ce.result_id,
drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdClueEventListVO.java
@@ -125,4 +125,9 @@
     */
    @ApiModelProperty(value = "附件URL")
    private String attachUrl;
    /**
     * 缩略图URL
     */
    @ApiModelProperty(value = "缩略图URL")
    private String thumbnailUrl;
}