完善sql别名

1 files changed, 3 insertions, 3 deletions

diff --git a/src/main/resources/mybatis/mapper/EventsMapper.xml b/src/main/resources/mybatis/mapper/EventsMapper.xml
index ffab704..a73ee45 100644
--- a/src/main/resources/mybatis/mapper/EventsMapper.xml
+++ b/src/main/resources/mybatis/mapper/EventsMapper.xml
@@ -247,15 +247,15 @@
     <select id="getHttpsMonitor" resultType="com.nis.galaxy.domain.EventsNameNumTime">
         <![CDATA[
         SELECT b.name AS name ,a.num AS num,#{push} AS time FROM
-        (SELECT cfg_id AS name,SUM(sum) AS num
+        (SELECT cfg_id AS cfgId,SUM(sum) AS num
         FROM ntc_pz_report
         WHERE report_time > #{start}
             AND report_time < #{end}
             AND service = #{serviceId}
-        GROUP BY name) a
+        GROUP BY cfgId) a
         LEFT JOIN
 	    (SELECT compile_id as compileId,cfg_desc as name FROM ui_cfg_index_info) b
-	    on a.name = b.compileId
+	    on a.cfgId = b.compileId
         ]]>
     </select>
     <!--端口信息-->