From 34159df2cce79612bef8681bcfcfda238b52bcd4 Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Mon, 11 Jul 2022 11:17:14 +0800
Subject: [PATCH] 大屏接口对接
---
src/main/java/org/springblade/modules/farmplant/service/FarmProductStockService.java | 1 +
src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java | 4 ++++
src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.java | 1 +
src/main/java/org/springblade/modules/farmplant/controller/FarmProductStockController.java | 11 +++++++++++
src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml | 19 +++++++++++++++++++
5 files changed, 36 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/farmplant/controller/FarmProductStockController.java b/src/main/java/org/springblade/modules/farmplant/controller/FarmProductStockController.java
index 1c039c1..56c3aa5 100644
--- a/src/main/java/org/springblade/modules/farmplant/controller/FarmProductStockController.java
+++ b/src/main/java/org/springblade/modules/farmplant/controller/FarmProductStockController.java
@@ -199,4 +199,15 @@
return R.data(cssum);
}
+ /**
+ * 农产品监管
+ */
+ @GetMapping("/productsSupervise")
+ public R productsSupervise(String year,String deptId) {
+
+ Map<String, String> cssum = farmProductStockService.productsSupervise(year, deptId);
+
+ return R.data(cssum);
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.java b/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.java
index d42ea21..92fb4d2 100644
--- a/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.java
+++ b/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.java
@@ -36,6 +36,7 @@
Map<String, String> selctProductCount(String year);
Map<String, String> statisticsStock(String year,String deptId);
Map<String, String> statisticsStockMonth(String year,String deptId);
+ Map<String, String> productsSupervise(String year,String deptId);
List<Map<String, Double>> statisticsYield(String year,String deptId);
boolean stockCompare(double sale,String id);
boolean stockReduce(double sale,String id);
diff --git a/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml b/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml
index 0da03b4..b1738b1 100644
--- a/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml
+++ b/src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml
@@ -107,6 +107,25 @@
and dept_id = #{deptId}
</if>
</select>
+ <!--农产品监管-->
+ <select id="productsSupervise" resultType="java.util.HashMap">
+ SELECT
+ IFNULL( SUM( CASE WHEN LEAVES = 0 THEN weight END ), 0 ) AS '0',
+ IFNULL( SUM( CASE WHEN LEAVES = 1 THEN weight END ), 0 ) AS '1',
+ IFNULL( SUM( CASE WHEN LEAVES = 2 THEN weight END ), 0 ) AS '2',
+ IFNULL( SUM( CASE WHEN LEAVES = 3 THEN weight END ), 0 ) AS '3',
+ IFNULL( SUM( CASE WHEN LEAVES = 4 THEN weight END ), 0 ) AS '4'
+ FROM
+ sys_recovery
+ WHERE
+ 1 = 1
+ <if test="year!=null and year!=''">
+ and YEAR ( time ) = #{year}
+ </if>
+ <if test="deptId!=null and deptId!=''">
+ and dept_id = #{deptId}
+ </if>
+ </select>
<!--大屏经营概况年产量统计-->
<select id="statisticsYield" resultType="java.util.HashMap">
SELECT
diff --git a/src/main/java/org/springblade/modules/farmplant/service/FarmProductStockService.java b/src/main/java/org/springblade/modules/farmplant/service/FarmProductStockService.java
index 453fd78..1083cad 100644
--- a/src/main/java/org/springblade/modules/farmplant/service/FarmProductStockService.java
+++ b/src/main/java/org/springblade/modules/farmplant/service/FarmProductStockService.java
@@ -35,6 +35,7 @@
Map<String, String> selctProductCount(String year);
Map<String, String> statisticsStock(String year,String deptId);
Map<String, String> statisticsStockMonth(String year,String deptId);
+ Map<String, String> productsSupervise(String year,String deptId);
List<Map<String, Double>> statisticsYield(String year, String deptId);
//查看库存是否充足
boolean stockCompare(double sale,String id);
diff --git a/src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java b/src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java
index 5780103..dacf4c2 100644
--- a/src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java
+++ b/src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java
@@ -70,6 +70,10 @@
return baseMapper.statisticsStockMonth(year,deptId);
}
@Override
+ public Map<String, String> productsSupervise(String year,String deptId) {
+ return baseMapper.productsSupervise(year,deptId);
+ }
+ @Override
public List<Map<String, Double>> statisticsYield(String year,String deptId) {
return baseMapper.statisticsYield(year,deptId);
}
--
Gitblit v1.9.3