ProjectDAO.java

package com.zhongzhi.dao;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zhongzhi.model.ProjectDO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhongzhi.vo.project.*;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * 项目表 Mapper 接口
 * </p>
 *
 * @author DengMin
 * @since 2021-05-11
 */
@Repository
public interface ProjectDAO extends BaseMapper<ProjectDO> {

    IPage<ProjectPageVO> getListPage(Page page, Long matchId, Long proposerId);

    IPage<MainTrackProjectPageVO> getMainTrackProjectPage(Page page, Long matchId, String projectGroup, @Param("type") String type, @Param("projectType") String projectType,
    String projectSchedule,
    String projectStatus, String itemField, @Param("name") String name);

    IPage<SeedTrackProjectPageVO> getSeedTrackProjectPage(Page page, Long matchId, String projectGroup,String projectTrack, @Param("type") String type,
    @Param("school") String school, String projectSchedule,
    String projectStatus, String itemField, @Param("name") String name,@Param("projectProgress") String projectProgress,Long userId,String college,String projectType,String xueyuan);

    IPage<ReviewListVO> getReviewList(Page page, String projectName, String projectGroup, String projectReview, Long matchId, String projectSchedule,
                                      String projectAssigned,String projectProgress,String projectTrack,Long userId,String college,
                                      String xueyuan,String projectType);

    IPage<ProjectPageVO> getProjectReviewPage(Page page, Long judgeId, Long matchId, String projectName, String projectSchedule, String projectReview, String projectGroup,String projectProgress);

    List<ProjectDO> getProjectReviewList(Long id, Long matchId,String projectProgress);

    List<ProjectDO> getProjectByCollege(Long matchId, @Param("name") String name, String projectProgress);

    List<ProjectDO> getSeedTrackProjectList(Long matchId, String projectGroup, @Param("name") String name,@Param("projectProgress")String projectProgress,Long userId,String college);

    List<ProjectDO> selectListByCollege(String projectType, String projectGroup,  @Param("name") String name);

    List<ProjectDO> getList(Long matchId, @Param("name") String name, String projectGroup);

    List<SeedTrackProjectPageVO> getProjectList(Long matchId, String projectGroup, String projectSchedule, String projectStatus, @Param("name") String name);

    List<ProjectDO> getListByJudgeId(Long matchId, String projectGroup, @Param("judgeId") Long judgeId);

    List<ProjectDO> getProjectById(@Param("ids") Long[] ids);

    List<ProjectDO> projects(Long matchId,Long collegeId,String college);

    Integer collegeNum();

    List<ProjectDO> getVocationalReviewNum(Long userId,Long matchId,String college);

    List<ProjectDO> getVocationalAssignNum(Long userId,Long matchId,String college);

    List<ProjectDO> exportProjectReview(Long userId,Long matchId,String projectSchedule,String college);

    List<GetDataDListVO> getDateList(Long matchId);

    List<Long> collegeProjects(String xueyuan,String major,Long matchId);

    Integer projectMembers(Long project,String type);

    ProjectProgressCntVO projectProgressCnt(List<Long> projectIds);
}