package com.finance.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.finance.common.enums.AreaLevelEnum;
import com.finance.common.enums.DataScreenConfigEnum;
import com.finance.common.enums.SubTypeEnum;
import com.finance.system.domain.TbDataScreenScore;
import com.finance.system.vo.DataScreenScoreVO;
import com.finance.system.vo.RiskMapVO;
import com.finance.system.vo.RiskRankingVO;
import java.util.List;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * 大屏得分表 Mapper 接口
 * </p>
 *
 * @author mitao
 * @since 2024-04-15
 */
public interface TbDataScreenScoreMapper extends BaseMapper<TbDataScreenScore> {

    List<RiskMapVO> queryScore4Map(@Param("nowQuarter") String nowQuarter,
            @Param("dataScreenConfigId") Long dataScreenConfigId);

    List<RiskRankingVO> queryRiskRanking(@Param("dataScreenConfigId") Long dataScreenConfigId,
            @Param("nowQuarter") String nowQuarter,
            @Param("areaTypeEnum") AreaLevelEnum areaLevelEnum);

    List<TbDataScreenScore> selectRiskByQuarter(@Param("nowQuarter") String nowQuarter,
            @Param("dataScreenConfigId") Long dataScreenConfigId,
            @Param("areaCode") String areaCode);

    List<DataScreenScoreVO> queryScoreByAreaAndYear(@Param("areaCode") String areaCode,
            @Param("dataScreenConfigId") Long dataScreenConfigId,
            @Param("yearType") Integer yearType);

    List<DataScreenScoreVO> selectIndicators(@Param("areaCode") String areaCode,
            @Param("nowQuarter") String nowQuarter,
            @Param("dataScreenConfigEnum") DataScreenConfigEnum dataScreenConfigEnum,
            @Param("yearType") Integer yearType);

    Integer getRankByScore(@Param("score") Double score,
            @Param("subType") SubTypeEnum subType, @Param("areaCode") String areaCode,
            @Param("nowQuarter") String nowQuarter,
            @Param("dataScreenConfigEnum") DataScreenConfigEnum dataScreenConfigEnum);
}