blob: 8d17b34ad2b7591dee0cb31b9267f00e8038bbe7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
<?php
/**
* Piwik - Open source web analytics
*
* @link http://piwik.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*
* @category Piwik
* @package Piwik
*/
use Piwik\Metrics;
/**
* This class
* @package Piwik
* @subpackage Piwik_ArchiveProcessor
*/
class Piwik_ArchiveProcessor_Day extends Piwik_ArchiveProcessor
{
/**
* Converts the given array to a datatable
* @param Piwik_DataArray $array
* @return Piwik_DataTable
*/
static public function getDataTableFromDataArray(Piwik_DataArray $array)
{
$dataArray = $array->getDataArray();
$dataArrayTwoLevels = $array->getDataArrayWithTwoLevels();
$subtableByLabel = null;
if (!empty($dataArrayTwoLevels)) {
$subtableByLabel = array();
foreach ($dataArrayTwoLevels as $label => $subTable) {
$subtableByLabel[$label] = Piwik_DataTable::makeFromIndexedArray($subTable);
}
}
return Piwik_DataTable::makeFromIndexedArray($dataArray, $subtableByLabel);
}
/**
* Helper function that returns an array with common statistics for a given database field distinct values.
*
* The statistics returned are:
* - number of unique visitors
* - number of visits
* - number of actions
* - maximum number of action for a visit
* - sum of the visits' length in sec
* - count of bouncing visits (visits with one page view)
*
* For example if $dimension = 'config_os' it will return the statistics for every distinct Operating systems
* The returned array will have a row per distinct operating systems,
* and a column per stat (nb of visits, max actions, etc)
*
* 'label' Metrics::INDEX_NB_UNIQ_VISITORS Metrics::INDEX_NB_VISITS etc.
* Linux 27 66 ...
* Windows XP 12 ...
* Mac OS 15 36 ...
*
* @param string $dimension Table log_visit field name to be use to compute common stats
* @return Piwik_DataArray
*/
public function getMetricsForDimension($dimension)
{
if (!is_array($dimension)) {
$dimension = array($dimension);
}
if (count($dimension) == 1) {
$dimension = array("label" => reset($dimension));
}
$query = $this->getLogAggregator()->queryVisitsByDimension($dimension);
$metrics = new Piwik_DataArray();
while ($row = $query->fetch()) {
$metrics->sumMetricsVisits($row["label"], $row);
}
return $metrics;
}
protected function aggregateCoreVisitsMetrics()
{
$query = $this->getLogAggregator()->queryVisitsByDimension();
$data = $query->fetch();
$metrics = $this->convertMetricsIdToName($data);
$this->insertNumericRecords($metrics);
return $metrics;
}
protected function convertMetricsIdToName($data)
{
$metrics = array();
foreach ($data as $metricId => $value) {
$readableMetric = Metrics::$mappingFromIdToName[$metricId];
$metrics[$readableMetric] = $value;
}
return $metrics;
}
protected function compute()
{
Piwik_PostEvent('ArchiveProcessing_Day.compute', array(&$this));
}
}
|
