文件名从 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/queue/queueMapper2.java 修改 |
| | |
| | | * @author 鑺嬮亾婧愮爜 |
| | | */ |
| | | @Mapper |
| | | public interface queueMapper2 extends BaseMapperX<QueueDO> { |
| | | public interface QueueMapper extends BaseMapperX<QueueDO> { |
| | | |
| | | default PageResult<QueueDO> selectPage(QueuePageReqVO reqVO) { |
| | | return selectPage(reqVO, new LambdaQueryWrapperX<QueueDO>() |
| | |
| | | " (select min(seq_num) as min_seq_num from lihu.queue where room_id = #{roomId} and bed_no = #{bedNo} and status = #{curStatus}) a )") |
| | | Integer updateQueueStatus(@Param("roomId")Long roomId, @Param("bedNo")String bedNo, @Param("curStatus")Byte curStatus, @Param("newStatus")Byte newStatus); |
| | | |
| | | @Update("update lihu.queue set status = #{newStatus} where pat_id = #{patId} and status = #{curStatus}") |
| | | Integer updatePatientQueueStatus(@Param("patId")String patId, @Param("curStatus")Byte curStatus, @Param("newStatus")Byte newStatus); |
| | | |
| | | @Update("update lihu.queue set status = #{newStatus}, room_id = #{roomId}, room_name = #{roomName}, \n" + |
| | | " bed_no = #{bedNo}, seq_num = #{seqNum} where id = \n" + |
| | | " (select a.id from \n" + |