namespace Wallabag\CoreBundle\Repository;
-use Doctrine\ORM\Query;
use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Tools\Pagination\Paginator;
/**
* Retrieves unread entries for a user
*
- * @param $userId
- * @param $firstResult
- * @param int $maxResults
+ * @param int $userId
+ * @param int $firstResult
+ * @param int $maxResults
+ *
* @return Paginator
*/
public function findUnreadByUser($userId, $firstResult, $maxResults = 12)
{
$qb = $this->createQueryBuilder('e')
- ->select('e')
->setFirstResult($firstResult)
->setMaxResults($maxResults)
+ ->leftJoin('e.user', 'u')
->where('e.isArchived = false')
- ->andWhere('e.userId =:userId')->setParameter('userId', $userId)
+ ->andWhere('u.id =:userId')->setParameter('userId', $userId)
->andWhere('e.isDeleted=false')
->orderBy('e.createdAt', 'desc')
->getQuery();
/**
* Retrieves read entries for a user
*
- * @param $userId
- * @param $firstResult
- * @param int $maxResults
+ * @param int $userId
+ * @param int $firstResult
+ * @param int $maxResults
+ *
* @return Paginator
*/
public function findArchiveByUser($userId, $firstResult, $maxResults = 12)
->select('e')
->setFirstResult($firstResult)
->setMaxResults($maxResults)
+ ->leftJoin('e.user', 'u')
->where('e.isArchived = true')
- ->andWhere('e.userId =:userId')->setParameter('userId', $userId)
+ ->andWhere('u.id =:userId')->setParameter('userId', $userId)
->andWhere('e.isDeleted=false')
->orderBy('e.createdAt', 'desc')
->getQuery();
/**
* Retrieves starred entries for a user
*
- * @param $userId
- * @param $firstResult
- * @param int $maxResults
+ * @param int $userId
+ * @param int $firstResult
+ * @param int $maxResults
+ *
* @return Paginator
*/
public function findStarredByUser($userId, $firstResult, $maxResults = 12)
->select('e')
->setFirstResult($firstResult)
->setMaxResults($maxResults)
+ ->leftJoin('e.user', 'u')
->where('e.isStarred = true')
- ->andWhere('e.userId =:userId')->setParameter('userId', $userId)
- ->andWhere('e.isDeleted=false')
+ ->andWhere('u.id =:userId')->setParameter('userId', $userId)
+ ->andWhere('e.isDeleted = false')
->orderBy('e.createdAt', 'desc')
->getQuery();
return $paginator;
}
- public function findEntries($userId, $isArchived, $isStarred, $isDeleted, $sort, $order)
+ /**
+ * Find Entries
+ *
+ * @param int $userId
+ * @param bool $isArchived
+ * @param bool $isStarred
+ * @param bool $isDeleted
+ * @param string $sort
+ * @param string $order
+ *
+ * @return array
+ */
+ public function findEntries($userId, $isArchived = null, $isStarred = null, $isDeleted = null, $sort = 'created', $order = 'ASC')
{
$qb = $this->createQueryBuilder('e')
- ->select('e')
- ->where('e.userId =:userId')->setParameter('userId', $userId);
+ ->leftJoin('e.user', 'u')
+ ->where('u.id =:userId')->setParameter('userId', $userId);
- if (!is_null($isArchived)) {
- $qb->andWhere('e.isArchived =:isArchived')->setParameter('isArchived', $isArchived);
+ if (null !== $isArchived) {
+ $qb->andWhere('e.isArchived =:isArchived')->setParameter('isArchived', (bool) $isArchived);
}
- if (!is_null($isStarred)) {
- $qb->andWhere('e.isStarred =:isStarred')->setParameter('isStarred', $isStarred);
+ if (null !== $isStarred) {
+ $qb->andWhere('e.isStarred =:isStarred')->setParameter('isStarred', (bool) $isStarred);
}
- if (!is_null($isDeleted)) {
- $qb->andWhere('e.isDeleted =:isDeleted')->setParameter('isDeleted', $isDeleted);
+ if (null !== $isDeleted) {
+ $qb->andWhere('e.isDeleted =:isDeleted')->setParameter('isDeleted', (bool) $isDeleted);
}
if ('created' === $sort) {
return $qb
->getQuery()
- ->getResult(Query::HYDRATE_ARRAY);
+ ->getResult();
}
}