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); |