| | |
|---|
| | | " <foreach collection='statusList' separator=',' item='status'>" + |
|---|
| | | " #{status} " + |
|---|
| | | " </foreach> )" + |
|---|
| | | " order by seq_num" + |
|---|
| | | " order by status desc, seq_num" + |
|---|
| | | "</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" + |
|---|
