lib/Db/AclMapper.php 1 location
|
@@ 40-45 (lines=6) @@
|
| 37 |
|
return $this->findEntities($sql, [$boardId], $limit, $offset); |
| 38 |
|
} |
| 39 |
|
|
| 40 |
|
public function isOwner($userId, $aclId) { |
| 41 |
|
$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_board_acl` WHERE id = ?)'; |
| 42 |
|
$stmt = $this->execute($sql, [$aclId]); |
| 43 |
|
$row = $stmt->fetch(); |
| 44 |
|
return ($row['owner'] === $userId); |
| 45 |
|
} |
| 46 |
|
|
| 47 |
|
public function findBoardId($aclId) { |
| 48 |
|
$entity = $this->find($aclId); |
lib/Db/CardMapper.php 1 location
|
@@ 114-119 (lines=6) @@
|
| 111 |
|
$stmt->execute(); |
| 112 |
|
} |
| 113 |
|
|
| 114 |
|
public function isOwner($userId, $cardId) { |
| 115 |
|
$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 = ?))'; |
| 116 |
|
$stmt = $this->execute($sql, [$cardId]); |
| 117 |
|
$row = $stmt->fetch(); |
| 118 |
|
return ($row['owner'] === $userId); |
| 119 |
|
} |
| 120 |
|
|
| 121 |
|
public function findBoardId($cardId) { |
| 122 |
|
$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
|
@@ 84-89 (lines=6) @@
|
| 81 |
|
$stmt->execute(); |
| 82 |
|
} |
| 83 |
|
|
| 84 |
|
public function isOwner($userId, $labelId) { |
| 85 |
|
$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_labels` WHERE id = ?)'; |
| 86 |
|
$stmt = $this->execute($sql, [$labelId]); |
| 87 |
|
$row = $stmt->fetch(); |
| 88 |
|
return ($row['owner'] === $userId); |
| 89 |
|
} |
| 90 |
|
|
| 91 |
|
public function findBoardId($labelId) { |
| 92 |
|
$entity = $this->find($labelId); |
lib/Db/StackMapper.php 1 location
|
@@ 63-68 (lines=6) @@
|
| 60 |
|
return parent::delete($entity); |
| 61 |
|
} |
| 62 |
|
|
| 63 |
|
public function isOwner($userId, $stackId) { |
| 64 |
|
$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_stacks` WHERE id = ?)'; |
| 65 |
|
$stmt = $this->execute($sql, [$stackId]); |
| 66 |
|
$row = $stmt->fetch(); |
| 67 |
|
return ($row['owner'] === $userId); |
| 68 |
|
} |
| 69 |
|
|
| 70 |
|
public function findBoardId($stackId) { |
| 71 |
|
$entity = $this->find($stackId); |