修改媒体图片排序

liusuyi

2025-12-09 960ef217957e46bd54e05e388ccb6fade8e02270

修改媒体图片排序

 ard-work/src/main/resources/mapper/ArdMediaMapper.xml

@@ -3,7 +3,7 @@
<mapper namespace="com.ard.work.mapper.ArdMediaMapper">

    <!-- 结果映射 -->
    <resultMap id="ArdMediaResult" type="com.ard.work.domain.entity.ArdMedia">
    <resultMap id="ArdMediaResult" type="ArdMedia">
        <result property="id" column="id"/>
        <result property="taskId" column="task_id"/>
        <result property="mediaType" column="media_type"/>
@@ -42,7 +42,11 @@
            <if test="captureTime != null">AND capture_time = #{captureTime}</if>
            <if test="createTime != null">AND create_time = #{createTime}</if>
        </where>
        ORDER BY create_time DESC
        ORDER BY
            CASE
                WHEN media_type = 0 THEN capture_time
                ELSE create_time
            END DESC
    </select>