blob: 61a04be882a0dcc39374e0b8926c3ffffe92b4b5 (
plain)
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
|
<?php
namespace UserFilterFields\MassMail;
use UserFilterField;
use MassMail\MassMailPermission;
use User;
use DBManager;
class MassMailStatusgroupFilter extends UserFilterField
{
public $valuesDbTable = 'statusgruppen';
public $valuesDbIdField = 'statusgruppe_id';
public $valuesDbNameField = 'name';
public $userDataDbTable = 'statusgruppe_user';
public $userDataDbField = 'statusgruppe_id';
public static $sortOrder = 10;
public static function getTargets()
{
return ['employees'];
}
public function __construct($fieldId = '')
{
parent::__construct($fieldId);
$this->validCompareOperators = [
'=' => _('ist'),
'!=' => _('ist nicht'),
];
$this->validValues = [];
if (MassMailPermission::has(User::findCurrent()->id, true)) {
$this->validValues = DBManager::get()->fetchFirst(
"SELECT DISTINCT `name` FROM `statusgruppen` ORDER BY `name` ASC"
);
} else if (MassMailPermission::has(User::findCurrent()->id)) {
$allowed = MassMailPermission::getForUser(User::findCurrent());
$this->validValues = DBManager::get()->fetchFirst(
"SELECT DISTINCT `name` FROM `statusgruppen` WHERE `range_id` IN (:institutes) ORDER BY `name` ASC",
['institutes' => $allowed['allowed_institutes']]
);
}
}
public function getName()
{
return _('Statusgruppe');
}
/**
* Gets all users belonging to a statusgroup with the given name. This is not done via statusgroup_id
* in ordner to enable several institutes as filter.
*
* @return array All users that are affected by the current condition
* field.
*/
public function getUsers($restrictions = [])
{
$users = [];
if (MassMailPermission::has(User::findCurrent()->id, true)) {
$users = DBManager::get()->fetchFirst("SELECT DISTINCT `user_id` " .
"FROM `" . $this->userDataDbTable . "` " .
"WHERE `" . $this->userDataDbField . "`" . $this->compareOperator .
"?", [$this->value]);
} else if (MassMailPermission::has(User::findCurrent()->id)) {
$allowed = MassMailPermission::getForUser(User::findCurrent());
$sql = "SELECT DISTINCT `" . $this->userDataDbTable . "`.`user_id` FROM `" . $this->userDataDbTable
. "`JOIN `user_inst` USING (`user_id`) ";
$where = "WHERE `" . $this->userDataDbTable . "`.`" . $this->userDataDbField . "`" . $this->compareOperator
. ":value AND `user_inst`.`Institut_id` IN (:institutes) AND `user_inst`.`inst_perms` IN (:perms)";
$parameters = [
'value' => $this->value,
'institutes' => $allowed['allowed_institutes'],
'perms' => ['autor', 'tutor', 'dozent', 'admin']
];
$users = DBManager::get()->fetchFirst($sql.$where, $parameters);
}
return $users;
}
}
|
