mitao
2025-04-07 18891c60ab1c06a4acc85d0ec54dee50d1b1a19f
finance-system/src/main/java/com/finance/system/mapper/TbScoreMapper.java
@@ -8,6 +8,8 @@
import com.finance.system.query.ScoreCalculateDetailQuery;
import com.finance.system.query.ScoreQuery;
import com.finance.system.vo.DeptCalculateDetailVO;
import com.finance.system.vo.RiskMapVO;
import com.finance.system.vo.RiskRankingVO;
import com.finance.system.vo.ScoreDetailVO;
import com.finance.system.vo.ScoreRankVO;
import com.finance.system.vo.ScoreVO;
@@ -31,11 +33,40 @@
    List<ScoreRankVO> queryTotalScoreList();
    ScoreRankVO queryRankAndScoreByAreaCode(@Param("areaCode") String areaCode);
    List<ScoreRankVO> queryRankAndScoreByAreaCode(@Param("areaCode") String areaCode,
            @Param("previousQuarter") String previousQuarter);
    List<DeptCalculateDetailVO> deptCalculateDetail(@Param("query") DeptCalculateDetailQuery query,
            @Param("nowQuarter") String nowQuarter);
    Page<ScoreDetailVO> fieldsDetail(@Param("query") CalculateDetailQuery query,
            @Param("page") Page<ScoreDetailVO> page, @Param("countyList") List<String> countyList);
    List<RiskMapVO> getCurrentScoreList(@Param("nowQuarter") String nowQuarter,
            @Param("areaCode") String areaCode);
    List<RiskRankingVO> queryRiskRanking(@Param("nowQuarter") String nowQuarter);
    List<RiskMapVO> getScoreByYearType(@Param("areaCode") String areaCode,
            @Param("quarter") String quarter);
    /**
     * 查询市的平均得分
     *
     * @param areaCode
     * @param previousQuarter
     * @return
     */
    Double getCityAverageScore(@Param("areaCode") String areaCode,
            @Param("previousQuarter") String previousQuarter);
    /**
     * 根据区划代码前四位查询区县得分列表
     *
     * @param areaCode
     * @param previousQuarter
     * @return
     */
    List<Double> getCountyScoreList(@Param("areaCode") String areaCode,
            @Param("previousQuarter") String previousQuarter);
}