代码提交

liusheng

2025-09-15 3d1344ca6f0613bf3726d2c40d35f3928f82a910

 jh-module-ecg/jh-module-ecg-biz/src/main/java/cn/lihu/jh/module/ecg/dal/mysql/room/RoomMapper.java

@@ -9,7 +9,6 @@
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;

/**
@@ -37,16 +36,14 @@
            "</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 " +
            "where status in ( " +
                    " <foreach collection='curStatusList' separator=',' item='curStatus'>" +
                    "  #{curStatus.status} " +
                    " </foreach> )" +
            " and deleted = 0;" +
            " and deleted = 0" +
            " order by room_id;" +
            "</script>")
    @Results({
            @Result(property = "checkTypes", column = "check_types", typeHandler=com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler.class)