namespace Wallabag\CoreBundle\Repository;
use Doctrine\ORM\EntityRepository;
+use Doctrine\ORM\Query;
use Pagerfanta\Adapter\DoctrineORMAdapter;
use Pagerfanta\Pagerfanta;
use Wallabag\CoreBundle\Entity\Tag;
class EntryRepository extends EntityRepository
{
+ private $lifeTime;
+
/**
* Return a query builder to used by other getBuilderFor* method.
*
* @param bool $isStarred
* @param string $sort
* @param string $order
+ * @param int $since
+ * @param string $tags
*
* @return array
*/
- public function findEntries($userId, $isArchived = null, $isStarred = null, $sort = 'created', $order = 'ASC', $since = 0)
+ public function findEntries($userId, $isArchived = null, $isStarred = null, $sort = 'created', $order = 'ASC', $since = 0, $tags = '')
{
$qb = $this->createQueryBuilder('e')
+ ->leftJoin('e.tags', 't')
->where('e.user =:userId')->setParameter('userId', $userId);
if (null !== $isArchived) {
$qb->andWhere('e.updatedAt > :since')->setParameter('since', new \DateTime(date('Y-m-d H:i:s', $since)));
}
+ if ('' !== $tags) {
+ foreach (explode(',', $tags) as $tag) {
+ $qb->andWhere('t.label = :label')->setParameter('label', $tag);
+ }
+ }
+
if ('created' === $sort) {
$qb->orderBy('e.id', $order);
} elseif ('updated' === $sort) {
return $qb->getQuery()->getSingleScalarResult();
}
+
+ public function setLifeTime($lifeTime)
+ {
+ $this->lifeTime = $lifeTime;
+ }
+
+ /**
+ * Enable cache for a query.
+ *
+ * @param Query $query
+ *
+ * @return Query
+ */
+ public function enableCache(Query $query)
+ {
+ $query->useQueryCache(true);
+ $query->useResultCache(true);
+ $query->setResultCacheLifetime($this->lifeTime);
+
+ return $query;
+ }
}