-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathDataAccessor.php
59 lines (48 loc) · 1.4 KB
/
DataAccessor.php
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
<?php
/**
* @license GNU GPL v3+
*/
namespace Piwik\Plugins\CampaignVisitorsByTime;
use Piwik\Common;
use Piwik\DataAccess\LogAggregator;
/**
* Database access functionality for plugin CampaignVisitorsByTime
*/
class DataAccessor {
private $aggregator;
public function __construct( LogAggregator $aggregator ) {
$this->aggregator = $aggregator;
}
public function retrieveDataSets(): \Zend_Db_Statement {
$query = $this->aggregator->generateQuery(
$this->getSelect(),
$this->getFrom(),
$this->getWhere(),
$this->getGroupBy(),
$this->getOrderBy()
);
return $this->aggregator->getDb()->query( $query['sql'], $query['bind'] );
}
private function getSelect(): string {
return 'idsite, ' .
'referer_name, ' .
'referer_keyword, ' .
'FROM_UNIXTIME( FLOOR( UNIX_TIMESTAMP( visit_first_action_time ) / 900 ) * 900 ) AS timestamp_floored, ' .
'COUNT( DISTINCT HEX( idvisitor ) ) AS numVisitors';
}
private function getFrom(): array {
return [ 'log_visit' ];
}
private function getWhere(): string {
return 'visit_last_action_time >= ? ' .
'AND visit_last_action_time <= ? ' .
'AND idsite IN ( ? ) ' .
'AND referer_type = ' . Common::REFERRER_TYPE_CAMPAIGN;
}
private function getGroupBy(): string {
return 'referer_name, referer_keyword, timestamp_floored';
}
private function getOrderBy(): string {
return 'timestamp_floored, referer_name, referer_keyword';
}
}