From 386e4215819efd8dd5e0f60b363708871bb7686d Mon Sep 17 00:00:00 2001
From: xuefei <564615061@qq.com>
Date: 星期五, 11 十二月 2020 15:01:45 +0800
Subject: [PATCH] 首页页面相关接口
---
platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyLogMapper.java | 16 +++++++++-------
1 files changed, 9 insertions(+), 7 deletions(-)
diff --git a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyLogMapper.java b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyLogMapper.java
index 300dda8..3f0a3c9 100644
--- a/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyLogMapper.java
+++ b/platform-modules/platform-zhyl/src/main/java/cn/cetc54/platform/zhyl/mapper/SubsidyLogMapper.java
@@ -27,7 +27,7 @@
" </where>" +
" GROUP BY duixiang_id"+
" </script>")
- Integer getTotalNum(@Param(value = "areaId")String areaId, @Param(value = "type")Integer type);
+ List<Integer> getTotalNum(@Param(value = "areaId")String areaId, @Param(value = "type")Integer type);
/**
* 鑾峰彇鎬婚噾棰�
@@ -45,7 +45,6 @@
" and type = #{type}" +
" </if>" +
" </where>" +
- " GROUP BY duixiang_id"+
" </script>")
Double getTotalMoney(@Param(value = "areaId")String areaId, @Param(value = "type")Integer type);
@@ -96,6 +95,7 @@
" </script>")
List<Map<String,Object>> getYearTotal(@Param(value = "areaId")String areaId, @Param(value = "type")Integer type);
+
/**
*缁熻姣忕琛ヨ创鐨勯噾棰濇暟
* @param areaId
@@ -109,24 +109,26 @@
" and area_id = #{areaId}" +
" </if>" +
" </where>" +
- " GROUP BY type ORDER BY money desc"+
+ " GROUP BY type ORDER BY sum desc"+
" </script>")
List<Map<String,Object>> getTypeMoney(@Param(value = "areaId")String areaId);
/**
- * 姣忕琛ヨ创鐨勬鏁�
+ * 姣忕琛ヨ创鐨勪汉鏁�
* @param areaId
* @return
*/
@Select("<script>" +
- " select type," +
- "conunt(id) as num FROM t_yl_subsidy_log" +
+ "select type,count(duixiang_id) as num from (" +
+ " select type,duixiang_id" +
+ " FROM t_yl_subsidy_log" +
" <where> " +
" <if test='areaId!= null'>" +
" and area_id = #{areaId}" +
" </if>" +
" </where>" +
- " GROUP BY type ORDER BY num desc"+
+ " GROUP BY type,duixiang_id) t GROUP BY type" +
+ " ORDER BY num desc"+
" </script>")
List<Map<String,Object>> getTypeNum(@Param(value = "areaId")String areaId);
--
Gitblit v1.9.1