lib/Db/AclMapper.php 1 location
|
@@ 39-44 (lines=6) @@
|
36 |
|
return $this->findEntities($sql, [$boardId], $limit, $offset); |
37 |
|
} |
38 |
|
|
39 |
|
public function isOwner($userId, $aclId) { |
40 |
|
$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_board_acl` WHERE id = ?)'; |
41 |
|
$stmt = $this->execute($sql, [$aclId]); |
42 |
|
$row = $stmt->fetch(); |
43 |
|
return ($row['owner'] === $userId); |
44 |
|
} |
45 |
|
|
46 |
|
public function findBoardId($aclId) { |
47 |
|
$entity = $this->find($aclId); |
lib/Db/StackMapper.php 1 location
|
@@ 72-77 (lines=6) @@
|
69 |
|
return parent::delete($entity); |
70 |
|
} |
71 |
|
|
72 |
|
public function isOwner($userId, $stackId) { |
73 |
|
$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_stacks` WHERE id = ?)'; |
74 |
|
$stmt = $this->execute($sql, [$stackId]); |
75 |
|
$row = $stmt->fetch(); |
76 |
|
return ($row['owner'] === $userId); |
77 |
|
} |
78 |
|
|
79 |
|
public function findBoardId($stackId) { |
80 |
|
$entity = $this->find($stackId); |
lib/Db/CardMapper.php 1 location
|
@@ 186-191 (lines=6) @@
|
183 |
|
$stmt->execute(); |
184 |
|
} |
185 |
|
|
186 |
|
public function isOwner($userId, $cardId) { |
187 |
|
$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_stacks` WHERE id IN (SELECT stack_id FROM `*PREFIX*deck_cards` WHERE id = ?))'; |
188 |
|
$stmt = $this->execute($sql, [$cardId]); |
189 |
|
$row = $stmt->fetch(); |
190 |
|
return ($row['owner'] === $userId); |
191 |
|
} |
192 |
|
|
193 |
|
public function findBoardId($cardId) { |
194 |
|
$sql = 'SELECT id FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_stacks` WHERE id IN (SELECT stack_id FROM `*PREFIX*deck_cards` WHERE id = ?))'; |
lib/Db/LabelMapper.php 1 location
|
@@ 97-102 (lines=6) @@
|
94 |
|
$stmt->execute(); |
95 |
|
} |
96 |
|
|
97 |
|
public function isOwner($userId, $labelId) { |
98 |
|
$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_labels` WHERE id = ?)'; |
99 |
|
$stmt = $this->execute($sql, [$labelId]); |
100 |
|
$row = $stmt->fetch(); |
101 |
|
return ($row['owner'] === $userId); |
102 |
|
} |
103 |
|
|
104 |
|
public function findBoardId($labelId) { |
105 |
|
$entity = $this->find($labelId); |