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
|
<?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*/
namespace Piwik\Plugins\UsersManager\Sql;
use Piwik\Common;
class SiteAccessFilter
{
/**
* @var string
*/
private $filterByRole;
/**
* @var int
*/
private $userLogin;
/**
* @var string
*/
private $filterSearch;
/**
* List of sites to limit the search to.
*
* @var int[]|null
*/
private $idSites;
public function __construct($userLogin, $filterSearch, $filterByRole, $idSites)
{
if (empty($userLogin)) {
throw new \InvalidArgumentException("filtering by role is only supported for a single site");
}
$this->userLogin = $userLogin;
$this->filterSearch = $filterSearch;
$this->filterByRole = $filterByRole;
$this->idSites = empty($idSites) ? null : array_map('intval', $idSites);
}
public function getJoins($accessTable)
{
$result = "RIGHT JOIN " . Common::prefixTable('site') . " s ON s.idsite = $accessTable.idsite AND a.login = ?";
$bind = [$this->userLogin];
return [$result, $bind];
}
public function getWhere()
{
$bind = [];
$result = [];
if ($this->filterSearch) {
$bind = array_merge($bind, \Piwik\Plugins\SitesManager\Model::getPatternMatchSqlBind($this->filterSearch));
$result[] = \Piwik\Plugins\SitesManager\Model::getPatternMatchSqlQuery('s');
}
if ($this->filterByRole) {
if ($this->filterByRole == 'noaccess') {
$result[] = 'a.access IS NULL';
} elseif ($this->filterByRole == 'some') {
$result[] = 'a.access IS NOT NULL';
} else {
$result[] = 'a.access = ?';
$bind[] = $this->filterByRole;
}
}
if (!empty($this->idSites)) {
$result[] = 's.idsite IN (' . implode(',', $this->idSites) . ')';
}
if (!empty($result)) {
$result = 'WHERE ' . implode(' AND ', $result);
} else {
$result = '';
}
return [$result, $bind];
}
}
|
