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);
|
}
|
