DrawLotsGroupItemsMapper.java

package com.zhongzhi.dao;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.zhongzhi.dto.drawlots.CollegeProjectsDTO;
import com.zhongzhi.model.DrawLotGroupDictDO;
import com.zhongzhi.model.DrawLotsGroupItemsDO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhongzhi.vo.drawlots.AllGroupItemsVO;
import com.zhongzhi.vo.drawlots.CollegeProjectsVO;
import com.zhongzhi.vo.drawlots.GroupProjectInfoVO;
import com.zhongzhi.vo.drawlots.MatchProjectsVO;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author DengMin
 * @since 2025-06-19
 */
@Repository
public interface DrawLotsGroupItemsMapper extends BaseMapper<DrawLotsGroupItemsDO> {

    IPage<AllGroupItemsVO> allGroupItems(IPage page,Long sceneId, String projectName,String college);

    /**
     * 某赛道  没有被选的项目
     */
    List<MatchProjectsVO> matchProjects(Long matchId, String projectSchedule);

    /**
     * 还没有坑位的项目
     */
    IPage<CollegeProjectsVO> collegeProjects(IPage iPage,Long sceneId, String college, String projectSchedule, String projectProgress);

    /**
     * 还没有满的坑位
     */
    List<DrawLotGroupDictDO> noFullGroup(Long sceneId,String college,Integer count);

    /**
     * 查看该组别下的项目
     */
    List<GroupProjectInfoVO> groupProjectInfo(Long groupId);

    /**
     * 某组别已经存在的编码
     */
    List<Integer> existNum(Long groupId);

    /**
     * 某现场某院校组别最小的数量
     */
    Integer sceneCollege(Long sceneId,String college);
}