package com.template.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.template.model.pojo.WelcomeStudent;
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 WelcomeStudentMapper extends BaseMapper<WelcomeStudent> {
    IPage<StudentPageVo> queryStudentPageList(IPage<StudentPageVo> page, @Param("collegeIds") List<String> collegeIds,@Param("majorId") Integer majorId,@Param("classstrId") Integer classstrId,@Param("trafficMethod") String trafficMethod ,@Param("name") String name,@Param("fillStatus") String fillStatus,@Param("isRegistered") Integer isRegistered,@Param("isPay") Integer isPay);

    List<StudentPageVo> queryStudentPageList(@Param("collegeIds") List<String> collegeIds, @Param("majorId") Integer majorId, @Param("classstrId") Integer classstrId, @Param("trafficMethod") String trafficMethod , @Param("name") String name,@Param("fillStatus") String fillStatus,@Param("isRegistered") Integer isRegistered,@Param("isPay") Integer isPay);

    List<StudentRegisterVo> studentRegister();

    List<StudentTrafficVo> studentTraffic();

    List<StudentSexRatioVo> studentSexRatio();

    List<StudentTotalVo> queryStudentTotal();

    List<StudentRegisterVo> studentMajorRegister(@Param("collegeId") Integer collegeId);

    List<StudentRegisterVo> levelRegister();

}