package com.template.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.template.model.evaluate.teacher.SmartEvaluateTeacher;
import com.template.model.vo.EvaluateTeacherVo;
import com.template.model.vo.RankingVo;
import com.template.model.vo.ScoreRankVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

/**
 * <p>
 * 用户表 Mapper 接口
 * </p>
 *
 * @author ceshi
 * @since 2024-01-02
 */
@Repository
public interface SmartEvaluateTeacherMapper extends BaseMapper<SmartEvaluateTeacher> {

    Double getAvgLowingScore(@RequestParam("term") String term);

    List<EvaluateTeacherVo> smartTopTeacherList(@RequestParam("termId") Integer termId);

    List<RankingVo> getRankingList(@Param("term") String term);

    RankingVo getRanking(@Param("term") String term,@Param("cardNo") String cardNo);

    List<ScoreRankVo> getScoreRanks(@Param("term") String term);
}
