Code Duplication    Length = 6-6 lines in 4 locations

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/LabelMapper.php 1 location

@@ 83-88 (lines=6) @@
80
		$stmt->execute();
81
	}
82
83
	public function isOwner($userId, $labelId) {
84
		$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_labels` WHERE id = ?)';
85
		$stmt = $this->execute($sql, [$labelId]);
86
		$row = $stmt->fetch();
87
		return ($row['owner'] === $userId);
88
	}
89
90
	public function findBoardId($labelId) {
91
		$entity = $this->find($labelId);

lib/Db/CardMapper.php 1 location

@@ 181-186 (lines=6) @@
178
		$stmt->execute();
179
	}
180
181
	public function isOwner($userId, $cardId) {
182
		$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 = ?))';
183
		$stmt = $this->execute($sql, [$cardId]);
184
		$row = $stmt->fetch();
185
		return ($row['owner'] === $userId);
186
	}
187
188
	public function findBoardId($cardId) {
189
		$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/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);