修正互联网流量（各个地域当前网络负载流量），使用传输层流量进行统计

2 files changed, 23 insertions, 1 deletions

diff --git a/src/main/resources/mybatis/mapper/MonitorMapper.xml b/src/main/resources/mybatis/mapper/MonitorMapper.xml
index 3c192b9..052a579 100644
--- a/src/main/resources/mybatis/mapper/MonitorMapper.xml
+++ b/src/main/resources/mybatis/mapper/MonitorMapper.xml
@@ -27,8 +27,11 @@
         </collection>
     </resultMap>
     <!--网络流量监控_5min-->
+
+
     <select id="getNetWaterMonitor" resultType="com.nis.galaxy.domain.NetWaterMonitor">
         <![CDATA[
+
         SELECT ifnull(d.entrance_id,0) AS area,'INOCTETS' AS type,SUM(tt.incount) AS count,time
         FROM
             (SELECT IF((b.INOCTETS - a.INOCTETS ) >0  ,b.INOCTETS - a.INOCTETS ,b.INOCTETS) AS incount,b.ip2 AS ip,#{push} AS time
@@ -77,6 +80,8 @@
 	 ) d
 	ON d.manager_ip = tt.ip
     GROUP BY area
+
+
         ]]>
     </select>
     <!--时间:网络流量监控_5min-->
diff --git a/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml b/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml
index f11be52..8ca90d2 100644
--- a/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml
+++ b/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml
@@ -14,8 +14,9 @@
        LIMIT 20;
         ]]>
     </select>
+
     <!--互联网流量TOP10-->
-    <select id="getNetFlowWaterTop10" resultType="com.nis.galaxy.domain.NetFlowWater">
+    <select id="getNetFlowWaterTop10_old" resultType="com.nis.galaxy.domain.NetFlowWater">
         <![CDATA[
         SELECT ifnull(dic.area,0) AS area,net.time AS time,sum(net.count)/1024/1024 AS count
         FROM (
@@ -30,6 +31,22 @@
         GROUP BY area,time
         ]]>
     </select>
+
+
+    <select id="getNetFlowWaterTop10" resultType="com.nis.galaxy.domain.NetFlowWater">
+        <![CDATA[
+
+        select entrance_id as area ,stat_time as time, IFNULL(SUM(c2s_byte_len+s2c_byte_len),0)/1024/1024 as count
+        from traffic_trans_statistic where STAT_TIME>= #{start} and STAT_TIME<#{end}
+        group by stat_time,entrance_id
+
+
+        ]]>
+    </select>
+
+
+
+
     <!--通过ip获取局点-->
     <select id="getIpEntranceRe" resultType="com.nis.galaxy.domain.Entrance">
         SELECT entrance_id AS entrance