| | |
|---|
| | | import org.apache.ibatis.annotations.*; |
|---|
| | | |
|---|
| | | import cn.lihu.jh.module.ecg.controller.admin.room.vo.RoomPageReqVO; |
|---|
| | | import cn.lihu.jh.module.ecg.dal.dataobject.room.RoomStatisticsDO; |
|---|
| | | import cn.lihu.jh.module.ecg.enums.BedStatusEnum; |
|---|
| | | |
|---|
| | | /** |
|---|
| | |
|---|
| | | " where deleted = 0 " + |
|---|
| | | "</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(); |
|---|
| | | |
|---|
| | | @Select("<script> " + |
|---|
| | | "SELECT * FROM lihu.clinic_room " + |
|---|
| | |
|---|
| | | |
|---|
| | | @Update("<script> " + |
|---|
| | | "update lihu.clinic_room set status=#{newStatus.status}, doc_id=null, doc_name=null " + |
|---|
| | | "where room_id=#{roomId} and bed_no=#{bedNo} and doc_id=#{docId} " + |
|---|
| | | "where room_id=#{roomId} and bed_no=#{bedNo} " + |
|---|
| | | "and status in ( " + |
|---|
| | | " <foreach collection='curStatusList' separator=',' item='curStatus'>" + |
|---|
| | | " #{curStatus.status} " + |
|---|
