getName()] = $metric; } return $mappedMetrics; } /** * @return \Piwik\Plugins\PagePerformance\Columns\Metrics\AveragePerformanceMetric[] */ public static function getAllPagePerformanceMetrics() { $metrics = [ new AverageTimeNetwork(), new AverageTimeServer(), new AverageTimeTransfer(), new AverageTimeDomProcessing(), new AverageTimeDomCompletion(), new AverageTimeOnLoad(), new AveragePageLoadTime() ]; $mappedMetrics = []; foreach ($metrics as $metric) { $mappedMetrics[$metric->getName()] = $metric; } return $mappedMetrics; } public static function getMetricTranslations() { $translations = array(); foreach (self::getAllPagePerformanceMetrics() as $metric) { $translations[$metric->getName()] = $metric->getTranslatedName(); } return $translations; } public static function attachActionMetrics(&$metricsConfig) { $table = 'log_link_visit_action'; /** * @var ActionDimension[] $performanceDimensions */ $performanceDimensions = [ new TimeNetwork(), new TimeServer(), new TimeTransfer(), new TimeDomProcessing(), new TimeDomCompletion(), new TimeOnLoad() ]; foreach($performanceDimensions as $dimension) { $id = $dimension->getColumnName(); $column = $table . '.' . $id; $metricsConfig['sum_'.$id] = [ 'aggregation' => 'sum', 'query' => "sum( case when " . $column . " is null then 0 else " . $column . " end ) / 1000" ]; $metricsConfig['nb_hits_with_'.$id] = [ 'aggregation' => 'sum', 'query' => "sum( case when " . $column . " is null then 0 else 1 end )" ]; $metricsConfig['min_'.$id] = [ 'aggregation' => 'min', 'query' => "min(" . $column . ") / 1000" ]; $metricsConfig['max_'.$id] = [ 'aggregation' => 'max', 'query' => "max(" . $column . ") / 1000" ]; } return $metricsConfig; } }