/
EditPageThemePageAccess.php
91 lines (82 loc) · 4.44 KB
/
EditPageThemePageAccess.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
<?php
namespace Concrete\Core\Permission\Access;
use Concrete\Core\Permission\Duration as PermissionDuration;
use Database;
use Concrete\Core\Permission\Key\PageKey as PagePermissionKey;
class EditPageThemePageAccess extends PageAccess
{
public function duplicate($newPA = false)
{
$newPA = parent::duplicate($newPA);
$db = Database::connection();
$r = $db->executeQuery('select * from PagePermissionThemeAccessList where paID = ?', [$this->getPermissionAccessID()]);
while ($row = $r->fetch()) {
$v = [$row['peID'], $newPA->getPermissionAccessID(), $row['permission']];
$db->executeQuery('insert into PagePermissionThemeAccessList (peID, paID, permission) values (?, ?, ?)', $v);
}
$r = $db->executeQuery('select * from PagePermissionThemeAccessListCustom where paID = ?', [$this->getPermissionAccessID()]);
while ($row = $r->fetch()) {
$v = [$row['peID'], $newPA->getPermissionAccessID(), $row['pThemeID']];
$db->executeQuery('insert into PagePermissionThemeAccessListCustom (peID, paID, pThemeID) values (?, ?, ?)', $v);
}
return $newPA;
}
public function save($args = [])
{
parent::save();
$db = Database::connection();
$db->executeQuery('delete from PagePermissionThemeAccessList where paID = ?', [$this->getPermissionAccessID()]);
$db->executeQuery('delete from PagePermissionThemeAccessListCustom where paID = ?', [$this->getPermissionAccessID()]);
if (isset($args['themesIncluded']) && is_array($args['themesIncluded'])) {
foreach ($args['themesIncluded'] as $peID => $permission) {
$v = [$this->getPermissionAccessID(), $peID, $permission];
$db->executeQuery('insert into PagePermissionThemeAccessList (paID, peID, permission) values (?, ?, ?)', $v);
}
}
if (isset($args['themesExcluded']) && is_array($args['themesExcluded'])) {
foreach ($args['themesExcluded'] as $peID => $permission) {
$v = [$this->getPermissionAccessID(), $peID, $permission];
$db->executeQuery('insert into PagePermissionThemeAccessList (paID, peID, permission) values (?, ?, ?)', $v);
}
}
if (isset($args['pThemeIDInclude']) && is_array($args['pThemeIDInclude'])) {
foreach ($args['pThemeIDInclude'] as $peID => $pThemeIDs) {
foreach ($pThemeIDs as $pThemeID) {
$v = [$this->getPermissionAccessID(), $peID, $pThemeID];
$db->executeQuery('insert into PagePermissionThemeAccessListCustom (paID, peID, pThemeID) values (?, ?, ?)', $v);
}
}
}
if (isset($args['pThemeIDExclude']) && is_array($args['pThemeIDExclude'])) {
foreach ($args['pThemeIDExclude'] as $peID => $pThemeIDs) {
foreach ($pThemeIDs as $pThemeID) {
$v = [$this->getPermissionAccessID(), $peID, $pThemeID];
$db->executeQuery('insert into PagePermissionThemeAccessListCustom (paID, peID, pThemeID) 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) {
$pe = $l->getAccessEntityObject();
$prow = $db->fetchAssoc('select permission from PagePermissionThemeAccessList where peID = ? and paID = ?', [$pe->getAccessEntityID(), $l->getPermissionAccessID()]);
if ($prow && $prow['permission']) {
$l->setThemesAllowedPermission($prow['permission']);
$permission = $prow['permission'];
if ($permission == 'C') {
$pThemeIDs = $db->GetCol('select pThemeID from PagePermissionThemeAccessListCustom where peID = ? and paID = ?', [$pe->getAccessEntityID(), $l->getPermissionAccessID()]);
$l->setThemesAllowedArray($pThemeIDs);
}
} elseif ($l->getAccessType() == PagePermissionKey::ACCESS_TYPE_INCLUDE) {
$l->setThemesAllowedPermission('A');
} else {
$l->setThemesAllowedPermission('N');
}
}
return $list;
}
}