use Doctrine\ORM\Query;
use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Tools\Pagination\Paginator;
+use Wallabag\CoreBundle\Entity\Entries;
class EntriesRepository extends EntityRepository
{
*
* @param $userId
* @param $firstResult
- * @param int $maxResults
+ * @param int $maxResults
* @return Paginator
*/
public function findUnreadByUser($userId, $firstResult, $maxResults = 12)
*
* @param $userId
* @param $firstResult
- * @param int $maxResults
+ * @param int $maxResults
* @return Paginator
*/
public function findArchiveByUser($userId, $firstResult, $maxResults = 12)
*
* @param $userId
* @param $firstResult
- * @param int $maxResults
+ * @param int $maxResults
* @return Paginator
*/
public function findStarredByUser($userId, $firstResult, $maxResults = 12)
return $paginator;
}
+
+ public function findEntries($userId, $isArchived, $isStarred, $isDeleted, $sort, $order)
+ {
+ //TODO tous les paramètres ne sont pas utilisés, à corriger
+ $qb = $this->createQueryBuilder('e')
+ ->select('e')
+ ->where('e.isFav =:isStarred')->setParameter('isStarred', $isStarred)
+ ->andWhere('e.isRead =:isArchived')->setParameter('isArchived', $isArchived)
+ ->andWhere('e.userId =:userId')->setParameter('userId', $userId)
+ ->getQuery()
+ ->getResult(Query::HYDRATE_ARRAY);
+
+ return $qb;
+ }
}