时间监测与阻断，将ssl 作为https统计结果

1 files changed, 4 insertions, 4 deletions

diff --git a/src/main/resources/mybatis/mapper/EventsMapper.xml b/src/main/resources/mybatis/mapper/EventsMapper.xml
index 1ee19e8..fe9a535 100644
--- a/src/main/resources/mybatis/mapper/EventsMapper.xml
+++ b/src/main/resources/mybatis/mapper/EventsMapper.xml
@@ -250,7 +250,7 @@
 			 sum(case t.service when 129 then t.sum else 0 end) as httpNum ,
 			 sum(case t.service when 132 then t.sum else 0 end) as mailNum ,
 			 sum(case t.service when  389  then t.sum else 0 end) + sum(case t.service when 390 then t.sum else 0 end) + sum(case t.service when 391 then t.sum else 0 end) + sum(case t.service when 392 then t.sum else 0 end)  as vedioNum ,
-			 sum(case t.service when 592 then t.sum else 0 end) as agentNum
+			  sum(case t.service when 131 then t.sum else 0 end)  + sum(case t.service when 592 then t.sum else 0 end) as agentNum
 			 from (
 		              SELECT  service, sum(sum) AS sum
                         FROM ntc_pz_report
@@ -258,7 +258,7 @@
                         AND report_time < #{end}
                         AND cfg_id in (
 											select compile_id from ui_cfg_num_statistics  where cfg_state=1 and
-												service_id in (128, 129, 132, 389, 390, 391, 392, 592)
+												service_id in (128, 129, 131, 132, 389, 390, 391, 392, 592)
 											)
 				      GROUP BY service	) t
 
@@ -309,7 +309,7 @@
 			 sum(case t.service when 17 then t.sum else 0 end) as httpNum ,
 			 sum(case t.service when 20 then t.sum else 0 end) as mailNum ,
 			 sum(case t.service when  261  then t.sum else 0 end) + sum(case t.service when 262 then t.sum else 0 end) + sum(case t.service when 263 then t.sum else 0 end) + sum(case t.service when 264 then t.sum else 0 end)  as vedioNum ,
-			 sum(case t.service when 576 then t.sum else 0 end) as agentNum
+			 sum(case t.service when 19 then t.sum else 0 end) + sum(case t.service when 576 then t.sum else 0 end) as agentNum
 			 from (
 		              SELECT  service, sum(sum) AS sum
                         FROM ntc_pz_report
@@ -317,7 +317,7 @@
                         AND report_time < #{end}
                         AND cfg_id in (
 											select compile_id from ui_cfg_num_statistics  where cfg_state=1 and
-												service_id in (16, 17, 20, 261, 262, 263, 264,576)
+												service_id in (16, 17,19,20, 261, 262, 263, 264,576)
 											)
 				      GROUP BY service	) t
 			 GROUP BY event;