update

eight

2024-11-12 d8c1b8408ca24f3e02427c7885da8c87c90f16a0

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/QueueMapper.java

@@ -165,11 +165,13 @@

    // 某个诊室范围内 [已领用] [已召回-安装] 人员 抢占, 会更新 [工位号]
    // 没有限定检查类型，不要使用时间槽
    @Select("select * from lihu.queue where room_id = #{roomId} and status in ( " +
    @Select("<script> " +
            "select * from lihu.queue where room_id = #{roomId} and status in ( " +
            "       <foreach collection='curStatusList' separator=',' item='status'>" +
            "           #{status} " +
            "       </foreach> )" +
            "       order by seq_num, create_time limit 1 " )
            "       order by seq_num, create_time limit 1 " +
            "</script>" )
    QueueDO getFirstItemByRoomAndStatus(@Param("roomId")Long roomId, @Param("curStatusList")List<Integer> curStatusList);

    @Update("update lihu.queue set status = #{newStatus} where status = #{curStatus} and seq_num = \n" +