diff options
| author | renkaige <[email protected]> | 2019-01-11 14:21:47 +0600 |
|---|---|---|
| committer | renkaige <[email protected]> | 2019-01-11 14:21:47 +0600 |
| commit | 12e266358cde3682f2af4cc986cc961e135f8020 (patch) | |
| tree | a2e7995b68b0a677cc4a70abc95d2109416f99d2 | |
| parent | 3ca2c7f50217bfc242bcdf013c8db42519695a07 (diff) | |
修改App 趋势详情中计算sipNum,dipNum的max为sum
| -rw-r--r-- | src/main/java/com/nis/web/dao/dashboard/TrafficAppStatisticDao.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/java/com/nis/web/dao/dashboard/TrafficAppStatisticDao.xml b/src/main/java/com/nis/web/dao/dashboard/TrafficAppStatisticDao.xml index 3ba358c..0863917 100644 --- a/src/main/java/com/nis/web/dao/dashboard/TrafficAppStatisticDao.xml +++ b/src/main/java/com/nis/web/dao/dashboard/TrafficAppStatisticDao.xml @@ -47,7 +47,7 @@ </select>
<!-- App 趋势详情 -->
<select id="getAppTrend" parameterType="com.nis.domain.restful.dashboard.TrafficAppFocusStatistic" resultType="com.nis.domain.restful.dashboard.TrafficAppFocusStatistic">
- select stat_time time, max(unique_sip_num) sipNum,max(unique_dip_num) dipNum from traffic_app_focus_statistic t where
+ select stat_time time, sum(unique_sip_num) sipNum,sum(unique_dip_num) dipNum from traffic_app_focus_statistic t where
<![CDATA[ stat_time>= toDateTime(#{searchStartTime}) and stat_time< toDateTime(#{searchEndTime})
and app_id=toInt64(#{searchAppId}) ]]>
<if test="searchEntranceId !=null and searchEntranceId != ''">
|