feat(workorder): 添加缩略图URL字段支持

linwei

19 hours ago 8f1f61e5cac940482f5b35cd4c61fba55a5fed23

feat(workorder): 添加缩略图URL字段支持

- 在GdTaskResultDTO中新增thumbnailUrl字段
- 在GdTaskResultEntity中新增thumbnailUrl字段
- 在GdTaskResultExcel中新增thumbnailUrl字段并配置Excel导出
- 在GdTaskResultMapper.xml中新增thumbnail_url数据库映射
- 在GdTaskResultVO中新增thumbnailUrl字段
- 更新数据库插入和批量插入操作以包含缩略图URL字段

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/dto/GdTaskResultDTO.java

@@ -54,6 +54,11 @@
    @ApiModelProperty(value = "成果URL")
    private String resultUrl;
    /**
     * 缩略图URL
     */
    @ApiModelProperty(value = "缩略图URL")
    private String thumbnailUrl;
    /**
     * 拍照时间
     */
    @ApiModelProperty(value = "拍照时间")

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/entity/GdTaskResultEntity.java

@@ -52,6 +52,11 @@
    @ApiModelProperty(value = "成果URL")
    private String resultUrl;
    /**
     * 缩略图URL
     */
    @ApiModelProperty(value = "缩略图URL")
    private String thumbnailUrl;
    /**
     * 拍照时间
     */
    @ApiModelProperty(value = "拍照时间")

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/excel/GdTaskResultExcel.java

@@ -60,6 +60,12 @@
    @ExcelProperty("成果URL")
    private String resultUrl;
    /**
     * 缩略图URL
     */
    @ColumnWidth(20)
    @ExcelProperty("缩略图URL")
    private String thumbnailUrl;
    /**
     * 拍照时间
     */
    @ColumnWidth(20)

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

@@ -8,6 +8,7 @@
        <result column="patrol_task_id" property="patrolTaskId"/>
        <result column="result_code" property="resultCode"/>
        <result column="result_url" property="resultUrl"/>
        <result column="thumbnail_url" property="thumbnailUrl"/>
        <result column="shoot_time" property="shootTime"/>
        <result column="photo_data" property="photoData"/>
        <result column="longitude" property="longitude"/>
@@ -32,6 +33,7 @@
        <result column="patrol_task_id" property="patrolTaskId"/>
        <result column="result_code" property="resultCode"/>
        <result column="result_url" property="resultUrl"/>
        <result column="thumbnail_url" property="thumbnailUrl"/>
        <result column="shoot_time" property="shootTime"/>
        <result column="photo_data" property="photoData"/>
        <result column="longitude" property="longitude"/>
@@ -125,6 +127,7 @@
        SET patrol_task_id = #{patrolTaskId},
            result_code = #{resultCode},
            result_url = #{resultUrl},
            thumbnail_url = #{thumbnailUrl},
            shoot_time = #{shootTime},
            photo_data = CAST(#{photoData} AS JSONB),
            longitude = #{longitude},
@@ -141,14 +144,14 @@
    <!-- 批量插入成果信息 -->
    <insert id="insertBatch" parameterType="java.util.List">
        INSERT INTO ja_gd_task_result (
            patrol_task_id, result_code, result_url, shoot_time,
            patrol_task_id, result_code, result_url, thumbnail_url, shoot_time,
            photo_data, longitude, latitude, distribute_status, area_code,
            create_user, create_dept, create_time, update_user, update_time,
            status, is_deleted, attachment_type, geojson
        ) VALUES
        <foreach collection="list" item="item" separator=",">
            (
                #{item.patrolTaskId}, #{item.resultCode}, #{item.resultUrl}, #{item.shootTime},
                #{item.patrolTaskId}, #{item.resultCode}, #{item.resultUrl}, #{item.thumbnailUrl}, #{item.shootTime},
                CASE WHEN #{item.photoData} IS NULL THEN NULL ELSE CAST(#{item.photoData} AS JSONB) END, #{item.longitude}, #{item.latitude}, #{item.distributeStatus}, #{item.areaCode},
                #{item.createUser}, #{item.createDept}, #{item.createTime}, #{item.updateUser}, #{item.updateTime},
                #{item.status}, #{item.isDeleted}, #{item.attachmentType}, #{item.geojson}

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

@@ -60,6 +60,11 @@
    @ApiModelProperty(value = "成果URL")
    private String resultUrl;
    /**
     * 缩略图URL
     */
    @ApiModelProperty(value = "缩略图URL")
    private String thumbnailUrl;
    /**
     * 拍照时间
     */
    @ApiModelProperty(value = "拍照时间")