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
|
<?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$
*
*
* @package Piwik_VisitTime
*/
/**
*
* @package Piwik_VisitTime
*/
class Piwik_VisitTime extends Piwik_Plugin
{
public function __construct()
{
parent::__construct();
}
public function getInformation()
{
$info = array(
'name' => 'VisitTime',
'description' => 'Visit Local & Server Time',
'author' => 'Piwik',
'homepage' => 'http://piwik.org/',
'version' => '0.1',
);
return $info;
}
function getListHooksRegistered()
{
$hooks = array(
'ArchiveProcessing_Day.compute' => 'archiveDay',
'ArchiveProcessing_Period.compute' => 'archiveMonth',
);
return $hooks;
}
function archiveMonth( $notification )
{
$archiveProcessing = $notification->getNotificationObject();
$dataTableToSum = array(
'VisitTime_localTime',
'VisitTime_serverTime',
);
$archiveProcessing->archiveDataTable($dataTableToSum);
}
public function archiveDay( $notification )
{
$archiveProcessing = $notification->getNotificationObject();
$this->archiveProcessing = $archiveProcessing;
$recordName = 'VisitTime_localTime';
$labelSQL = "HOUR(visitor_localtime)";
$tableLocalTime = $archiveProcessing->getDataTableInterestForLabel($labelSQL);
$this->makeSureAllHoursAreSet($tableLocalTime);
$record = new Piwik_ArchiveProcessing_Record_BlobArray($recordName, $tableLocalTime->getSerialized());
// echo $tableLocalTime;
$recordName = 'VisitTime_serverTime';
$labelSQL = "HOUR(visit_first_action_time)";
$tableServerTime = $archiveProcessing->getDataTableInterestForLabel($labelSQL);
$this->makeSureAllHoursAreSet($tableServerTime);
$record = new Piwik_ArchiveProcessing_Record_BlobArray($recordName, $tableServerTime->getSerialized());
// echo $tableServerTime;
}
private function makeSureAllHoursAreSet($table)
{
for($i=0;$i<=23;$i++)
{
if($table->getRowFromLabel($i) === false)
{
$row = $this->archiveProcessing->getNewInterestRowLabeled($i);
$table->addRow( $row );
}
}
}
}
Piwik_AddWidget( 'VisitTime', 'getVisitInformationPerLocalTime', 'Visits by local time');
Piwik_AddWidget( 'VisitTime', 'getVisitInformationPerServerTime', 'Visits by server time');
Piwik_AddMenu('Visitors', 'Times', array('module' => 'VisitTime'));
|
