diff options
Diffstat (limited to 'src/Wallabag/CoreBundle/Repository/EntriesRepository.php')
-rw-r--r-- | src/Wallabag/CoreBundle/Repository/EntriesRepository.php | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/Wallabag/CoreBundle/Repository/EntriesRepository.php b/src/Wallabag/CoreBundle/Repository/EntriesRepository.php index d87eb373..c76b4215 100644 --- a/src/Wallabag/CoreBundle/Repository/EntriesRepository.php +++ b/src/Wallabag/CoreBundle/Repository/EntriesRepository.php | |||
@@ -25,6 +25,7 @@ class EntriesRepository extends EntityRepository | |||
25 | ->setMaxResults($maxResults) | 25 | ->setMaxResults($maxResults) |
26 | ->where('e.isRead = 0') | 26 | ->where('e.isRead = 0') |
27 | ->andWhere('e.userId =:userId')->setParameter('userId', $userId) | 27 | ->andWhere('e.userId =:userId')->setParameter('userId', $userId) |
28 | ->andWhere('e.isDeleted=0') | ||
28 | ->getQuery(); | 29 | ->getQuery(); |
29 | 30 | ||
30 | $paginator = new Paginator($qb); | 31 | $paginator = new Paginator($qb); |
@@ -48,6 +49,7 @@ class EntriesRepository extends EntityRepository | |||
48 | ->setMaxResults($maxResults) | 49 | ->setMaxResults($maxResults) |
49 | ->where('e.isRead = 1') | 50 | ->where('e.isRead = 1') |
50 | ->andWhere('e.userId =:userId')->setParameter('userId', $userId) | 51 | ->andWhere('e.userId =:userId')->setParameter('userId', $userId) |
52 | ->andWhere('e.isDeleted=0') | ||
51 | ->getQuery(); | 53 | ->getQuery(); |
52 | 54 | ||
53 | $paginator = new Paginator($qb); | 55 | $paginator = new Paginator($qb); |
@@ -71,6 +73,7 @@ class EntriesRepository extends EntityRepository | |||
71 | ->setMaxResults($maxResults) | 73 | ->setMaxResults($maxResults) |
72 | ->where('e.isFav = 1') | 74 | ->where('e.isFav = 1') |
73 | ->andWhere('e.userId =:userId')->setParameter('userId', $userId) | 75 | ->andWhere('e.userId =:userId')->setParameter('userId', $userId) |
76 | ->andWhere('e.isDeleted=0') | ||
74 | ->getQuery(); | 77 | ->getQuery(); |
75 | 78 | ||
76 | $paginator = new Paginator($qb); | 79 | $paginator = new Paginator($qb); |
@@ -86,6 +89,7 @@ class EntriesRepository extends EntityRepository | |||
86 | ->where('e.isFav =:isStarred')->setParameter('isStarred', $isStarred) | 89 | ->where('e.isFav =:isStarred')->setParameter('isStarred', $isStarred) |
87 | ->andWhere('e.isRead =:isArchived')->setParameter('isArchived', $isArchived) | 90 | ->andWhere('e.isRead =:isArchived')->setParameter('isArchived', $isArchived) |
88 | ->andWhere('e.userId =:userId')->setParameter('userId', $userId) | 91 | ->andWhere('e.userId =:userId')->setParameter('userId', $userId) |
92 | ->andWhere('e.isDeleted=0') | ||
89 | ->getQuery() | 93 | ->getQuery() |
90 | ->getResult(Query::HYDRATE_ARRAY); | 94 | ->getResult(Query::HYDRATE_ARRAY); |
91 | 95 | ||