| | |
| | | " <foreach collection='statusList' separator=',' item='status'>" + |
| | | " #{status} " + |
| | | " </foreach> )" + |
| | | " order by seq_num" + |
| | | " order by status desc, seq_num" + |
| | | "</script>") |
| | | List<QueueDO> getQueueByStatus( @Param("statusList")List<Byte> statusList); |
| | | |
| | |
| | | " where status = #{curStatus} and pat_id = #{patId}") |
| | | Integer queueJump(@Param("patId")String patId, @Param("curStatus")Byte curStatus, @Param("jumped")Byte jumped ); |
| | | |
| | | @Delete("delete from lihu.queue where TO_DAYS(book_date) != TO_DAYS(NOW())") |
| | | Integer clearQueue(); |
| | | //@Delete("delete from lihu.queue where TO_DAYS(book_date) != TO_DAYS(NOW())") |
| | | @Update("TRUNCATE TABLE lihu.queue") |
| | | void clearQueue(); |
| | | } |
| | | |