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
|
<?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik;
use Piwik\DataAccess\RawLogDao;
use Piwik\Plugin\LogTablesProvider;
use Piwik\Plugins\SitesManager\Model;
/**
* Service that deletes log entries. Methods in this class cascade, so deleting visits will delete visit actions,
* conversions and conversion items.
*/
class LogDeleter
{
/**
* @var RawLogDao
*/
private $rawLogDao;
/**
* @var LogTablesProvider
*/
private $logTablesProvider;
public function __construct(RawLogDao $rawLogDao, LogTablesProvider $logTablesProvider)
{
$this->rawLogDao = $rawLogDao;
$this->logTablesProvider = $logTablesProvider;
}
/**
* Deletes visits by ID. This method cascades, so conversions, conversion items and visit actions for
* the visits are also deleted.
*
* @param int[] $visitIds
* @return int The number of deleted visits.
*/
public function deleteVisits($visitIds)
{
$numDeletedVisits = 0;
foreach ($this->logTablesProvider->getAllLogTables() as $logTable) {
if ($logTable->getColumnToJoinOnIdVisit()) {
$numVisits = $this->rawLogDao->deleteFromLogTable($logTable->getName(), $visitIds);
if ($logTable->getName() === 'log_visit') {
$numDeletedVisits = $numVisits;
}
}
}
return $numDeletedVisits;
}
/**
* Deletes visits within the specified date range and belonging to the specified site (if any). Visits are
* deleted in chunks, so only `$iterationStep` visits are deleted at a time.
*
* @param string|null $startDatetime A datetime string. Visits that occur at this time or after are deleted. If not supplied,
* visits from the beginning of time are deleted.
* @param string|null $endDatetime A datetime string. Visits that occur before this time are deleted. If not supplied,
* visits from the end of time are deleted.
* @param int|null $idSite The site to delete visits from.
* @param int $iterationStep The number of visits to delete at a single time.
* @param callable $afterChunkDeleted Callback executed after every chunk of visits are deleted.
* @return int The number of visits deleted.
*/
public function deleteVisitsFor($startDatetime, $endDatetime, $idSite = null, $iterationStep = 2000, $afterChunkDeleted = null)
{
$fields = array('idvisit');
$conditions = array();
if (!empty($startDatetime)) {
$conditions[] = array('visit_last_action_time', '>=', $startDatetime);
}
if (!empty($endDatetime)) {
$conditions[] = array('visit_last_action_time', '<', $endDatetime);
}
if (!empty($idSite)) {
$conditions[] = array('idsite', '=', $idSite);
} elseif (!empty($startDatetime) || !empty($endDatetime)) {
// make sure to use index!
$sitesModel = new Model();
$allIdSites = $sitesModel->getSitesId();
$allIdSites = array_map('intval', $allIdSites);
$conditions[] = array('idsite', '', $allIdSites);
}
$logsDeleted = 0;
$logPurger = $this;
$this->rawLogDao->forAllLogs('log_visit', $fields, $conditions, $iterationStep, function ($logs) use ($logPurger, &$logsDeleted, $afterChunkDeleted) {
$ids = array_map(function ($row) { return reset($row); }, $logs);
$logsDeleted += $logPurger->deleteVisits($ids);
if (!empty($afterChunkDeleted)) {
$afterChunkDeleted($logsDeleted);
}
}, $willDelete = true);
return $logsDeleted;
}
}
|