From b401bdd488f59f13ea4ced707eeaeb8ad4150e08 Mon Sep 17 00:00:00 2001
From: puhanshu <a9236326>
Date: 星期四, 23 十二月 2021 14:28:35 +0800
Subject: [PATCH] 通用大屏修改

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ConvenientMerchantMapper.xml     |    2 +-
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml |    4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml
index 2d97e8a..6155d5d 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActNeighborCircleDOMapper.xml
@@ -127,8 +127,8 @@
     </select>
     <select id="getIndexNeighborBaseData"
             resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO">
-        SELECT filed, sum, ROUND(sum/total,2) AS percent FROM
-        (SELECT t2.`name` AS filed, COUNT(1) AS sum FROM com_act_neighbor_circle t1
+        SELECT filed, num, ROUND(num/total,2) AS percent FROM
+        (SELECT t2.`name` AS filed, COUNT(1) AS num FROM com_act_neighbor_circle t1
         LEFT JOIN com_act_neighbor_circle_topic t2 ON t1.topic_id = t2.id
         WHERE t1.community_id = #{communityId} AND t1.`status` IN (2,3) AND t1.is_del = 2 AND t2.`status` = 1 GROUP BY filed) temp1,
         (SELECT COUNT(t1.id) AS total FROM com_act_neighbor_circle t1
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ConvenientMerchantMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ConvenientMerchantMapper.xml
index 96c71b8..4d93c9e 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ConvenientMerchantMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ConvenientMerchantMapper.xml
@@ -241,7 +241,7 @@
     </select>
     <select id="getServiceTimesTotalPolylineDate"
             resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO">
-        SELECT SUM(t1.consultation_volume) AS num
+        SELECT IF(SUM(t1.consultation_volume) IS NULL,0,SUM(t1.consultation_volume)) AS num
         FROM com_convenient_consultation_statistics t1
         LEFT JOIN com_convenient_merchants t2 ON t1.merchant_id = t2.id
         WHERE t2.community_id = #{communityId} AND DATE_FORMAT( t1.statistic_date, '%Y%m' ) &lt;= #{date}

--
Gitblit v1.7.1