diff options
| -rw-r--r-- | src/main/resources/mybatis/mapper/MonitorMapper.xml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/main/resources/mybatis/mapper/MonitorMapper.xml b/src/main/resources/mybatis/mapper/MonitorMapper.xml index 0fe6b16..0335236 100644 --- a/src/main/resources/mybatis/mapper/MonitorMapper.xml +++ b/src/main/resources/mybatis/mapper/MonitorMapper.xml @@ -31,13 +31,13 @@ <select id="getNetWaterMonitor" resultType="com.nis.galaxy.domain.NetWaterMonitor"> <![CDATA[ - SELECT entrance_id AS area,'OUT' AS type,ifnull(s2c_byte_len,0) AS count,#{push} AS time + SELECT entrance_id AS area,'OUT' AS type,ifnull(sum(s2c_byte_len),0) AS count,#{push} AS time FROM traffic_trans_statistic where stat_time >= #{start} and stat_time < #{end} group by area UNION ALL - SELECT entrance_id AS area,'IN' AS type,ifnull(c2s_byte_len,0) AS count,#{push} AS time + SELECT entrance_id AS area,'IN' AS type,ifnull(sum(c2s_byte_len),0) AS count,#{push} AS time FROM traffic_trans_statistic where stat_time >= #{start} and stat_time < #{end} |