| | |
|---|
| | | " </foreach> ) " + |
|---|
| | | " order by status desc, seq_num " + |
|---|
| | | "</script>") |
|---|
| | | @Results({ |
|---|
| | | @Result(property = "patDetails", column = "pat_details", typeHandler=com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler.class) |
|---|
| | | }) |
|---|
| | | List<QueueDO> getBedQueueByStatus(@Param("roomId")Long roomId, @Param("bedNo")String bedNo, @Param("statusList")List<Integer> statusList); |
|---|
| | | |
|---|
| | | @Select("SELECT * from lihu.queue where room_id = #{roomId} and bed_no = #{bedNo} and status = #{curStatus} order by seq_num, create_time limit 1") |
|---|
