- $paginator = new Paginator($qb);
-
- return $paginator;
- }
-
- /**
- * Retrieves read entries for a user
- *
- * @param int $userId
- * @param int $firstResult
- * @param int $maxResults
- *
- * @return Paginator
- */
- public function findArchiveByUser($userId, $firstResult, $maxResults = 12)
- {
- $qb = $this->createQueryBuilder('e')
- ->select('e')
- ->setFirstResult($firstResult)
- ->setMaxResults($maxResults)
- ->leftJoin('e.user', 'u')
- ->where('e.isArchived = true')
- ->andWhere('u.id =:userId')->setParameter('userId', $userId)
- ->orderBy('e.createdAt', 'desc')
- ->getQuery();
-
- $paginator = new Paginator($qb);
+ if (null !== $cacheLifeTime) {
+ $query->useQueryCache(true);
+ $query->useResultCache(true);
+ $query->setResultCacheLifetime($cacheLifeTime);
+ }