From 18891c60ab1c06a4acc85d0ec54dee50d1b1a19f Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期一, 07 四月 2025 17:20:07 +0800
Subject: [PATCH] bug修改

---
 finance-system/src/main/java/com/finance/system/mapper/TbScoreMapper.java |   33 ++++++++++++++++++++++++++++++++-
 1 files changed, 32 insertions(+), 1 deletions(-)

diff --git a/finance-system/src/main/java/com/finance/system/mapper/TbScoreMapper.java b/finance-system/src/main/java/com/finance/system/mapper/TbScoreMapper.java
index 069d754..c5fb45f 100644
--- a/finance-system/src/main/java/com/finance/system/mapper/TbScoreMapper.java
+++ b/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);
 }

--
Gitblit v1.7.1