diff options
author | mattab <matthieu.aubry@gmail.com> | 2013-06-07 14:51:29 +0400 |
---|---|---|
committer | mattab <matthieu.aubry@gmail.com> | 2013-06-16 12:10:27 +0400 |
commit | ea4498a9ce68d621861fa7d8732e922b838ed12d (patch) | |
tree | 2707a141ea1bb571c0f2f8215cb75342b6122f47 /plugins/VisitorInterest/Archiver.php | |
parent | 16fb8c92cc1e0edf78799bcd412b0ef9c4b5a3df (diff) |
going deeper into the rabbit hole
Diffstat (limited to 'plugins/VisitorInterest/Archiver.php')
-rw-r--r-- | plugins/VisitorInterest/Archiver.php | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/plugins/VisitorInterest/Archiver.php b/plugins/VisitorInterest/Archiver.php index fc797e44f3..f90ea3d2a0 100644 --- a/plugins/VisitorInterest/Archiver.php +++ b/plugins/VisitorInterest/Archiver.php @@ -108,19 +108,20 @@ class Piwik_VisitorInterest_Archiver extends Piwik_PluginsArchiver $selectAs = $prefixes[self::DAYS_SINCE_LAST_RECORD_NAME] . 'General_NewVisits'; $newVisitCountSelect = "sum(case when log_visit.visitor_returning = 0 then 1 else 0 end) as `$selectAs`"; + $daysSinceLastVisitSelects = Piwik_DataAccess_LogAggregator::buildReduceByRangeSelect( + 'visitor_days_since_last', self::$daysSinceLastVisitGap, 'log_visit', $prefixes[self::DAYS_SINCE_LAST_RECORD_NAME], + $daysSinceLastExtraCondition); + // create the select expressions to use - $timeGapSelects = Piwik_ArchiveProcessing_Day::buildReduceByRangeSelect( + $timeGapSelects = Piwik_DataAccess_LogAggregator::buildReduceByRangeSelect( 'visit_total_time', self::getSecondsGap(), 'log_visit', $prefixes[self::TIME_SPENT_RECORD_NAME]); - $pageGapSelects = Piwik_ArchiveProcessing_Day::buildReduceByRangeSelect( + $pageGapSelects = Piwik_DataAccess_LogAggregator::buildReduceByRangeSelect( 'visit_total_actions', self::$pageGap, 'log_visit', $prefixes[self::PAGES_VIEWED_RECORD_NAME]); - $visitsByVisitNumSelects = Piwik_ArchiveProcessing_Day::buildReduceByRangeSelect( + $visitsByVisitNumSelects = Piwik_DataAccess_LogAggregator::buildReduceByRangeSelect( 'visitor_count_visits', self::$visitNumberGap, 'log_visit', $prefixes[self::VISITS_COUNT_RECORD_NAME]); - $daysSinceLastVisitSelects = Piwik_ArchiveProcessing_Day::buildReduceByRangeSelect( - 'visitor_days_since_last', self::$daysSinceLastVisitGap, 'log_visit', $prefixes[self::DAYS_SINCE_LAST_RECORD_NAME], - $daysSinceLastExtraCondition); array_unshift($daysSinceLastVisitSelects, $newVisitCountSelect); |