fix: 添加成果类型字段，视频或者图片

linwei

2026-04-24 8d9f3ff3c4913193bd78ae5565d8173d4dbce9ee

fix: 添加成果类型字段，视频或者图片

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdTaskResultMapper.xml

@@ -24,6 +24,7 @@
        <result column="distribute_user_name" property="distributeUserName"/>
        <result column="distribute_dept_name" property="distributeDeptName"/>
        <result column="patrol_task_name" property="patrolTaskName"/>
        <result column="attachment_type" property="attachmentType"/>
    </resultMap>

    <resultMap id="gdTaskResultExcelResultMap" type="org.sxkj.gd.workorder.excel.GdTaskResultExcel">
@@ -129,16 +130,16 @@
    <!-- 批量插入成果信息 -->
    <insert id="insertBatch" parameterType="java.util.List">
        INSERT INTO ja_gd_task_result (
            patrol_task_id, result_code, result_url, shoot_time, 
            photo_data, longitude, latitude, distribute_status, area_code, 
            create_user, create_dept, create_time, update_user, update_time, 
            patrol_task_id, result_code, result_url, shoot_time,
            photo_data, longitude, latitude, distribute_status, area_code,
            create_user, create_dept, create_time, update_user, update_time,
            status, is_deleted
        ) VALUES
        <foreach collection="list" item="item" separator=",">
            (
                #{item.patrolTaskId}, #{item.resultCode}, #{item.resultUrl}, #{item.shootTime}, 
                CASE WHEN #{item.photoData} IS NULL THEN NULL ELSE #{item.photoData}::jsonb END, #{item.longitude}, #{item.latitude}, #{item.distributeStatus}, #{item.areaCode}, 
                #{item.createUser}, #{item.createDept}, #{item.createTime}, #{item.updateUser}, #{item.updateTime}, 
                #{item.patrolTaskId}, #{item.resultCode}, #{item.resultUrl}, #{item.shootTime},
                CASE WHEN #{item.photoData} IS NULL THEN NULL ELSE #{item.photoData}::jsonb END, #{item.longitude}, #{item.latitude}, #{item.distributeStatus}, #{item.areaCode},
                #{item.createUser}, #{item.createDept}, #{item.createTime}, #{item.updateUser}, #{item.updateTime},
                #{item.status}, #{item.isDeleted}
            )
        </foreach>

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdTaskResultVO.java

@@ -127,4 +127,10 @@
    @ApiModelProperty(value = "关联巡查任务表IDs")
    private List<Long> patrolTaskIds;

    /**
     * 附件类型：0图片 1视频 2其他
     */
    @ApiModelProperty(value = "附件类型：0图片 1视频 2其他")
    private Integer attachmentType;

}