package com.template.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.template.model.pojo.AlumniClubApply;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.template.model.vo.ApplyClubVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author ceshi
 * @since 2024-11-22
 */
@Repository
public interface AlumniClubApplyMapper extends BaseMapper<AlumniClubApply> {
    IPage<ApplyClubVo> queryClubApplys(IPage<ApplyClubVo> page, @Param("userId") Integer userId,@Param("name") String name, @Param("userName") String userName, @Param("isPass") Integer isPass, @Param("collegeId") Integer collegeId, @Param("periodId") Integer periodId, @Param("majorId") Integer majorId, @Param("classId") Integer classId, @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("categoryId") Integer categoryId);

    List<ApplyClubVo> queryClubExcelApplys(@Param("userId") Integer userId, @Param("name") String name, @Param("userName") String userName, @Param("isPass") Integer isPass, @Param("collegeId") Integer collegeId, @Param("periodId") Integer periodId, @Param("majorId") Integer majorId, @Param("classId") Integer classId, @Param("startTime") String startTime, @Param("endTime") String endTime);

    IPage<ApplyClubVo> queryMyClubApplys(IPage<ApplyClubVo> page, @Param("userId") Integer userId,@Param("name") String name);

    IPage<ApplyClubVo> queryApproveClubApplys(IPage<ApplyClubVo> page, @Param("userId") Integer userId,@Param("name") String name);
}
