package com.template.mapper;

import com.template.model.pojo.WelcomeBed;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.template.model.vo.*;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author ceshi
 * @since 2025-06-13
 */
@Repository
public interface WelcomeBedMapper extends BaseMapper<WelcomeBed> {

    List<BedDetailsVo> getBedList(@Param("schoolId") Integer schoolId, @Param("buildId") Integer buildId, @Param("dormitoryId") Integer dormitoryId, @Param("studentCard") String studentCard);

    BedDetailsVo getBedDetailsVo(@Param("schoolId") Integer schoolId, @Param("buildId") Integer buildId, @Param("dormitoryId") Integer dormitoryId, @Param("studentCard") String studentCard);

    WelcomeBedCheckVo isCheck(@Param("studentCard") String studentCard);

    List<BedSqlTotalVo> queryBedSqlList(@Param("collegeId") Integer collegeId,@Param("sex") String sex);

    List<SleepSqlTotalVo> queryTotalSqlList(@Param("collegeId") Integer collegeId,@Param("sex") String sex);

    void updateData(@Param("bedId") Integer bedId);

    List<BedInfosVo> queryBedList(@Param("studentCard") String studentCard);

    void updateBuild(@Param("schoolId") String schoolId,@Param("buildId") Integer buildId, @Param("build") String build);
}