dormitory_manage/src/main/java/space/anyi/mapper/BedMapper.java

package space.anyi.mapper;

import space.anyi.entity.Bed;
import org.apache.ibatis.annotations.Param;
import java.util.List;

public interface BedMapper {
    List<Bed> selectAll();
    List<Bed> selectByCondition(@Param("buildingId") Long buildingId,
                                @Param("roomNumber") String roomNumber);
    List<Bed> selectByRoomId(Long roomId);
    List<Bed> selectAvailableByRoomId(Long roomId);
    Bed selectById(Long id);
    int insert(Bed bed);
    int update(Bed bed);
    int updateStatus(@Param("id") Long id, @Param("status") Integer status);
    int deleteById(Long id);
    int countActiveAssignmentsByBedId(Long bedId);
}