Code Duplication    Length = 6-6 lines in 4 locations

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