/
NotifyInNotificationCenterNotificationAccess.php
94 lines (85 loc) · 4.95 KB
/
NotifyInNotificationCenterNotificationAccess.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
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
<?php
namespace Concrete\Core\Permission\Access;
use Concrete\Core\Permission\Duration as PermissionDuration;
use Concrete\Core\Permission\Key\PageKey as PagePermissionKey;
use Database;
class NotifyInNotificationCenterNotificationAccess extends NotificationAccess
{
public function duplicate($newPA = false)
{
$newPA = parent::duplicate($newPA);
$db = Database::connection();
$r = $db->executeQuery('select * from NotificationPermissionSubscriptionList where paID = ?', [$this->getPermissionAccessID()]);
while ($row = $r->fetch()) {
$v = [$row['peID'], $newPA->getPermissionAccessID(), $row['permission']];
$db->executeQuery('insert into NotificationPermissionSubscriptionList (peID, paID, permission) values (?, ?, ?)', $v);
}
$r = $db->executeQuery('select * from NotificationPermissionSubscriptionListCustom where paID = ?', [$this->getPermissionAccessID()]);
while ($row = $r->fetch()) {
$v = [$row['peID'], $newPA->getPermissionAccessID(), $row['nSubscriptionIdentifier']];
$db->executeQuery('insert into NotificationPermissionSubscriptionListCustom (peID, paID, nSubscriptionIdentifier) values (?, ?, ?)', $v);
}
return $newPA;
}
public function save($args = [])
{
parent::save();
$db = Database::connection();
$db->executeQuery('delete from NotificationPermissionSubscriptionList where paID = ?', [$this->getPermissionAccessID()]);
$db->executeQuery('delete from NotificationPermissionSubscriptionListCustom where paID = ?', [$this->getPermissionAccessID()]);
if (isset($args['subscriptionsIncluded']) && is_array($args['subscriptionsIncluded'])) {
foreach ($args['subscriptionsIncluded'] as $peID => $permission) {
$v = [$this->getPermissionAccessID(), $peID, $permission];
$db->executeQuery('insert into NotificationPermissionSubscriptionList (paID, peID, permission) values (?, ?, ?)', $v);
}
}
if (isset($args['subscriptionsExcluded']) && is_array($args['subscriptionsExcluded'])) {
foreach ($args['subscriptionsExcluded'] as $peID => $permission) {
$v = [$this->getPermissionAccessID(), $peID, $permission];
$db->executeQuery('insert into NotificationPermissionSubscriptionList (paID, peID, permission) values (?, ?, ?)', $v);
}
}
if (isset($args['subscriptionIdentifierInclude']) && is_array($args['subscriptionIdentifierInclude'])) {
foreach ($args['subscriptionIdentifierInclude'] as $peID => $pThemeIDs) {
foreach ($pThemeIDs as $pThemeID) {
$v = [$this->getPermissionAccessID(), $peID, $pThemeID];
$db->executeQuery('insert into NotificationPermissionSubscriptionListCustom (paID, peID, nSubscriptionIdentifier) values (?, ?, ?)', $v);
}
}
}
if (isset($args['subscriptionIdentifierExclude']) && is_array($args['subscriptionIdentifierExclude'])) {
foreach ($args['subscriptionIdentifierExclude'] as $peID => $pThemeIDs) {
foreach ($pThemeIDs as $pThemeID) {
$v = [$this->getPermissionAccessID(), $peID, $pThemeID];
$db->executeQuery('insert into NotificationPermissionSubscriptionListCustom (paID, peID, nSubscriptionIdentifier) values (?, ?, ?)', $v);
}
}
}
}
public function getAccessListItems($accessType = PagePermissionKey::ACCESS_TYPE_INCLUDE, $filterEntities = [], $checkCache = true)
{
$db = Database::connection();
$list = parent::getAccessListItems($accessType, $filterEntities);
$list = PermissionDuration::filterByActive($list);
foreach ($list as $l) {
/**
* @var \Concrete\Core\Permission\Access\ListItem\NotifyInNotificationCenterNotificationListItem
*/
$pe = $l->getAccessEntityObject();
$prow = $db->fetchAssoc('select permission from NotificationPermissionSubscriptionList where peID = ? and paID = ?', [$pe->getAccessEntityID(), $l->getPermissionAccessID()]);
if (is_array($prow) && $prow['permission']) {
$l->setSubscriptionsAllowedPermission($prow['permission']);
$permission = $prow['permission'];
if ($permission == 'C') {
$subscriptions = $db->GetCol('select nSubscriptionIdentifier from NotificationPermissionSubscriptionListCustom where peID = ? and paID = ?', [$pe->getAccessEntityID(), $l->getPermissionAccessID()]);
$l->setSubscriptionsAllowedArray($subscriptions);
}
} elseif ($l->getAccessType() == PagePermissionKey::ACCESS_TYPE_INCLUDE) {
$l->setSubscriptionsAllowedPermission('A');
} else {
$l->setSubscriptionsAllowedPermission('N');
}
}
return $list;
}
}