<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.docus.server.reportmanager.mapper.ScanAssortMapper">

    <update id="cancel">
        UPDATE `docus_archivefile`.`t_scan_assort`
        SET `is_del` = 1
        WHERE `id` in
        <foreach collection="ids" item="id" separator="," open="(" close=")">
            #{id}
        </foreach>
    </update>
    <select id="getIdByPatientTask" resultType="java.lang.Long">
        select id
        from `docus_archivefile`.`t_scan_assort`
        where patient_id = #{patientId}
          and task_id = #{taskId}
    </select>
</mapper>
