From 1f3835b24d77a899a2e2e55c846a575dc4db825d Mon Sep 17 00:00:00 2001
From: zrj <646384940@qq.com>
Date: Wed, 30 Oct 2024 15:15:34 +0800
Subject: [PATCH] 新增风险源统计
---
src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.xml | 17 +++++++++++++++++
src/main/java/org/springblade/modules/yw/controller/RiskSourceController.java | 13 +++++++++++++
src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.java | 9 ++++++++-
src/main/java/org/springblade/modules/yw/service/IRiskSourceService.java | 8 ++++++++
src/main/java/org/springblade/modules/yw/service/impl/RiskSourceServiceImpl.java | 12 ++++++++++++
5 files changed, 58 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/yw/controller/RiskSourceController.java b/src/main/java/org/springblade/modules/yw/controller/RiskSourceController.java
index c76fc3a..a380c90 100644
--- a/src/main/java/org/springblade/modules/yw/controller/RiskSourceController.java
+++ b/src/main/java/org/springblade/modules/yw/controller/RiskSourceController.java
@@ -120,4 +120,17 @@
return R.data(200, data, data);
}
+
+ /**
+ * 风险源统计查询
+ * @param riskSource
+ * @return
+ */
+ @GetMapping("/getStatisticData")
+ @ApiOperationSupport(order = 9)
+ @ApiOperation(value = "风险源统计查询", notes = "")
+ public R getStatisticData(RiskSourceVO riskSource) {
+ return R.data(riskSourceService.getStatisticData(riskSource));
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.java b/src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.java
index 7c6eeb0..57eecb9 100644
--- a/src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.java
+++ b/src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.java
@@ -6,6 +6,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import java.util.List;
+import java.util.Map;
/**
* 风险源表 Mapper 接口
@@ -22,6 +23,12 @@
* @param riskSource
* @return
*/
- List<RiskSourceVO> selectRiskSourcePage(IPage page, RiskSourceVO riskSource);
+ List<RiskSourceVO> selectRiskSourcePage(IPage page,@Param("riskSource") RiskSourceVO riskSource);
+ /**
+ * 风险源统计查询
+ * @param riskSource
+ * @return
+ */
+ List<Map<String, Object>> getStatisticData(@Param("riskSource") RiskSourceVO riskSource);
}
diff --git a/src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.xml b/src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.xml
index b478cd5..ed4fc87 100644
--- a/src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.xml
+++ b/src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.xml
@@ -21,4 +21,21 @@
select * from yw_risk_source where is_deleted = 0
</select>
+ <!--风险源统计查询-->
+ <select id="getStatisticData" resultType="java.util.Map">
+ SELECT
+ CASE WHEN risk_level = 1 THEN '一般'
+ WHEN risk_level = 2 THEN '较大'
+ END AS riskLevel,
+ count(*) AS num
+ FROM
+ yw_risk_source
+ WHERE
+ is_deleted = 0
+ AND risk_level IS NOT NULL
+ AND firm_id IS NOT NULL
+ GROUP BY
+ risk_level
+ </select>
+
</mapper>
diff --git a/src/main/java/org/springblade/modules/yw/service/IRiskSourceService.java b/src/main/java/org/springblade/modules/yw/service/IRiskSourceService.java
index fc17830..c1bbc24 100644
--- a/src/main/java/org/springblade/modules/yw/service/IRiskSourceService.java
+++ b/src/main/java/org/springblade/modules/yw/service/IRiskSourceService.java
@@ -7,6 +7,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
+import java.util.Map;
/**
* 风险源表 服务类
@@ -31,4 +32,11 @@
* @return
*/
String importRiskSource(List<RiskSourceExcel> data, boolean isCovered);
+
+ /**
+ * 风险源统计查询
+ * @param riskSource
+ * @return
+ */
+ List<Map<String,Object>> getStatisticData(RiskSourceVO riskSource);
}
diff --git a/src/main/java/org/springblade/modules/yw/service/impl/RiskSourceServiceImpl.java b/src/main/java/org/springblade/modules/yw/service/impl/RiskSourceServiceImpl.java
index d9d1b3e..c926817 100644
--- a/src/main/java/org/springblade/modules/yw/service/impl/RiskSourceServiceImpl.java
+++ b/src/main/java/org/springblade/modules/yw/service/impl/RiskSourceServiceImpl.java
@@ -16,6 +16,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
+import java.util.Map;
import java.util.Objects;
/**
@@ -105,4 +106,15 @@
}
return null;
}
+
+ /**
+ * 风险源统计查询
+ * @param riskSource
+ * @return
+ */
+ @Override
+ public List<Map<String, Object>> getStatisticData(RiskSourceVO riskSource) {
+ // 风险源统计查询
+ return baseMapper.getStatisticData(riskSource);
+ }
}
--
Gitblit v1.9.3