| | |
| | | .orderByDesc(RoomDO::getId)); |
| | | } |
| | | |
| | | @Select({ "SELECT room_id, count(1) as bed_num FROM lihu.clinic_room group by room_id;" }) |
| | | @Select({ "SELECT room_id, room_name, count(1) as bed_num FROM lihu.clinic_room group by room_id;" }) |
| | | List<RoomStatisticsDO> roomStatistic(); |
| | | |
| | | @Select({ "SELECT room_id, room_name FROM lihu.clinic_room where onstage=true group by room_id;" }) |
| | | @Select({ "SELECT id, room_id, room_name, bed_no, onstage FROM lihu.clinic_room where onstage=true;" }) |
| | | List<RoomDO> simpleRoomList(); |
| | | |
| | | } |