mitao
2024-04-19 604d00f67ddcf25a9d079ceddd1c668b2a4e5288
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbDataScreenScoreMapper.java
@@ -1,7 +1,15 @@
package com.ruoyi.system.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.enums.AreaLevelEnum;
import com.ruoyi.common.enums.DataScreenConfigEnum;
import com.ruoyi.common.enums.SubTypeEnum;
import com.ruoyi.system.domain.TbDataScreenScore;
import com.ruoyi.system.vo.DataScreenScoreVO;
import com.ruoyi.system.vo.RiskMapVO;
import com.ruoyi.system.vo.RiskRankingVO;
import java.util.List;
import org.apache.ibatis.annotations.Param;
/**
 * <p>
@@ -13,4 +21,28 @@
 */
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);
}