Code Duplication    Length = 13-14 lines in 2 locations

lib/Db/CardMapper.php 2 locations

@@ 154-166 (lines=13) @@
151
		return $this->findEntities($qb);
152
	}
153
154
	public function findDeleted($boardId, $limit = null, $offset = null) {
155
		$qb = $this->db->getQueryBuilder();
156
		$qb->select('*')
157
			->from('deck_cards', 'c')
158
			->join('c', 'deck_stacks', 's', $qb->expr()->eq('s.id', 'c.stack_id'))
159
			->where($qb->expr()->eq('s.board_id', $qb->createNamedParameter($boardId)))
160
			->andWhere($qb->expr()->neq('c.archived', $qb->createNamedParameter(true)))
161
			->andWhere($qb->expr()->neq('c.deleted_at', $qb->createNamedParameter(0)))
162
			->orderBy('c.order')
163
			->setMaxResults($limit)
164
			->setFirstResult($offset);
165
		return $this->findEntities($qb);
166
	}
167
168
	public function findCalendarEntries($boardId, $limit = null, $offset = null) {
169
		$qb = $this->db->getQueryBuilder();
@@ 168-181 (lines=14) @@
165
		return $this->findEntities($qb);
166
	}
167
168
	public function findCalendarEntries($boardId, $limit = null, $offset = null) {
169
		$qb = $this->db->getQueryBuilder();
170
		$qb->select('c.*')
171
			->from('deck_cards', 'c')
172
			->join('c', 'deck_stacks', 's', 's.id = c.stack_id')
173
			->where($qb->expr()->eq('s.board_id', $qb->createNamedParameter($boardId)))
174
			->andWhere($qb->expr()->neq('c.archived', $qb->createNamedParameter(true)))
175
			->andWhere($qb->expr()->eq('c.deleted_at', $qb->createNamedParameter('0')))
176
			->andWhere($qb->expr()->isNotNull('c.duedate'))
177
			->orderBy('c.duedate')
178
			->setMaxResults($limit)
179
			->setFirstResult($offset);
180
		return $this->findEntities($qb);
181
	}
182
183
184
	public function findAllArchived($stackId, $limit = null, $offset = null) {