| | |
| | | "</script>") |
| | | List<QueueDO> getDoctorQueueByStatus(@Param("roomId")Long roomId, @Param("bedNo")String bedNo, @Param("statusList")List<Byte> statusList); |
| | | |
| | | @Update( "update lihu.queue set called = 1 where pat_id = #{patId}" ) |
| | | Integer markCalled(@Param("patId")String patId); |
| | | |
| | | @Update("update lihu.queue set status = #{newStatus} where seq_num = \n" + |
| | | "(select a.min_seq_num from \n" + |
| | | " (select min(seq_num) as min_seq_num from lihu.queue where room_id = #{roomId} and bed_no = #{bedNo} and status = #{curStatus}) a )") |