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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
<?php
/**
* Piwik - Open source web analytics
*
* @link http://piwik.org
* @license http://www.gnu.org/licenses/gpl-3.0.html Gpl v3 or later
* @version $Id$
*
* @category Piwik_Plugins
* @package Piwik_UserCountry
*/
/**
*
* @package Piwik_UserCountry
*/
class Piwik_UserCountry extends Piwik_Plugin
{
public function getInformation()
{
$info = array(
'description' => Piwik_Translate('UserCountry_PluginDescription'),
'author' => 'Piwik',
'author_homepage' => 'http://piwik.org/',
'version' => Piwik_Version::VERSION,
);
return $info;
}
function getListHooksRegistered()
{
$hooks = array(
'ArchiveProcessing_Day.compute' => 'archiveDay',
'ArchiveProcessing_Period.compute' => 'archivePeriod',
'WidgetsList.add' => 'addWidgets',
'Menu.add' => 'addMenu',
'Goals.getAvailableGoalSegments' => 'addGoalSegments',
);
return $hooks;
}
function addWidgets()
{
Piwik_AddWidget( 'General_Visitors', 'UserCountry_WidgetContinents', 'UserCountry', 'getContinent');
Piwik_AddWidget( 'General_Visitors', 'UserCountry_WidgetCountries', 'UserCountry', 'getCountry');
}
function addMenu()
{
Piwik_AddMenu('General_Visitors', 'UserCountry_SubmenuLocations', array('module' => 'UserCountry', 'action' => 'index'));
}
function addGoalSegments( $notification )
{
$segments =& $notification->getNotificationObject();
$segments = array_merge($segments, array(
array(
'group' => Piwik_Translate('UserCountry_Location'),
'name' => Piwik_Translate('UserCountry_Country'),
'module' => 'UserCountry',
'action' => 'getCountry',
),
array(
'group' => Piwik_Translate('UserCountry_Location'),
'name' => Piwik_Translate('UserCountry_Continent'),
'module' => 'UserCountry',
'action' => 'getContinent',
),
));
}
function archivePeriod( $notification )
{
$archiveProcessing = $notification->getNotificationObject();
$dataTableToSum = array(
'UserCountry_country',
'UserCountry_continent',
);
$nameToCount = $archiveProcessing->archiveDataTable($dataTableToSum);
$archiveProcessing->insertNumericRecord('UserCountry_distinctCountries',
$nameToCount['UserCountry_country']['level0']);
}
function archiveDay($notification)
{
$archiveProcessing = $notification->getNotificationObject();
$this->archiveDayAggregateVisits($archiveProcessing);
$this->archiveDayAggregateGoals($archiveProcessing);
$this->archiveDayRecordInDatabase($archiveProcessing);
}
protected function archiveDayAggregateVisits($archiveProcessing)
{
$labelSQL = "location_country";
$this->interestByCountry = $archiveProcessing->getArrayInterestForLabel($labelSQL);
$labelSQL = "location_continent";
$this->interestByContinent = $archiveProcessing->getArrayInterestForLabel($labelSQL);
}
protected function archiveDayAggregateGoals($archiveProcessing)
{
$query = $archiveProcessing->queryConversionsBySegment("location_continent,location_country");
while($row = $query->fetch() )
{
if(!isset($this->interestByCountry[$row['location_country']][Piwik_Archive::INDEX_GOALS][$row['idgoal']])) $this->interestByCountry[$row['location_country']][Piwik_Archive::INDEX_GOALS][$row['idgoal']] = $archiveProcessing->getNewGoalRow();
if(!isset($this->interestByContinent[$row['location_continent']][Piwik_Archive::INDEX_GOALS][$row['idgoal']])) $this->interestByContinent[$row['location_continent']][Piwik_Archive::INDEX_GOALS][$row['idgoal']] = $archiveProcessing->getNewGoalRow();
$archiveProcessing->updateGoalStats($row, $this->interestByCountry[$row['location_country']][Piwik_Archive::INDEX_GOALS][$row['idgoal']]);
$archiveProcessing->updateGoalStats($row, $this->interestByContinent[$row['location_continent']][Piwik_Archive::INDEX_GOALS][$row['idgoal']]);
}
$archiveProcessing->enrichConversionsByLabelArray($this->interestByCountry);
$archiveProcessing->enrichConversionsByLabelArray($this->interestByContinent);
}
protected function archiveDayRecordInDatabase($archiveProcessing)
{
$tableCountry = $archiveProcessing->getDataTableFromArray($this->interestByCountry);
$archiveProcessing->insertBlobRecord('UserCountry_country', $tableCountry->getSerialized());
$archiveProcessing->insertNumericRecord('UserCountry_distinctCountries', $tableCountry->getRowsCount());
destroy($tableCountry);
$tableContinent = $archiveProcessing->getDataTableFromArray($this->interestByContinent);
$archiveProcessing->insertBlobRecord('UserCountry_continent', $tableContinent->getSerialized());
destroy($tableContinent);
}
}
|
