| | |
|---|
| | | List<RoomStatisticsDO> roomStatistic(); |
|---|
| | | |
|---|
| | | @Select("<script> " + |
|---|
| | | "SELECT id, room_id, room_name, bed_no, status, doc_id, doc_name FROM lihu.clinic_room " + |
|---|
| | | "SELECT * FROM lihu.clinic_room " + |
|---|
| | | "where status in ( " + |
|---|
| | | " <foreach collection='curStatusList' separator=',' item='curStatus'>" + |
|---|
| | | " #{curStatus.status} " + |
|---|
| | | " </foreach> )" + |
|---|
| | | " and deleted = 0;" + |
|---|
| | | "</script>") |
|---|
| | | @Results({ |
|---|
| | | @Result(property = "checkTypes", column = "check_types", typeHandler=com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler.class) |
|---|
| | | }) |
|---|
| | | List<RoomDO> simpleRoomList(@Param("curStatusList") List<BedStatusEnum> curStatusList); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM lihu.clinic_room where room_id=#{roomId} and bed_no=#{bedNo}") |
|---|
