package com.template.mapper;

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

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author ceshi
 * @since 2024-11-20
 */
@Repository
public interface AlumniClubMapper extends BaseMapper<AlumniClub> {

    List<ClubExcelVo> queryClubDatas(@Param("name") String name, @Param("userName") String userName, @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("categoryId") Integer categoryId);

    IPage<AlumniClub> queryClubPages(IPage<AlumniClub> page, @Param("name") String name, @Param("userName") String userName, @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("categoryId") Integer categoryId);

    List<OtherClubVo> CategoryCountDatas();
}
