| | |
| | | .orderByDesc(RoomDO::getId)); |
| | | } |
| | | |
| | | @Update(" update lihu.clinic_room set status=#{newStatus.status}, doc_id=null, doc_name=null") |
| | | Integer resetRoom(@Param("newStatus") BedStatusEnum newStatus); |
| | | @Update("<script> " + |
| | | "update lihu.clinic_room set status=#{newStatus}, doc_id=null, doc_name=null " + |
| | | " where 1 = 1 " + |
| | | "</script>") |
| | | Integer resetRoom(@Param("newStatus") Integer newStatus); |
| | | |
| | | @Select({ "SELECT room_id, room_name, count(1) as bed_num FROM lihu.clinic_room group by room_id;" }) |
| | | List<RoomStatisticsDO> roomStatistic(); |