+ /**
+ * Retrieves entries filtered with a search term for a user.
+ *
+ * @param int $userId
+ * @param string $term
+ * @param strint $currentRoute
+ *
+ * @return QueryBuilder
+ */
+ public function getBuilderForSearchByUser($userId, $term, $currentRoute)
+ {
+ $qb = $this
+ ->getBuilderByUser($userId);
+
+ if ('starred' === $currentRoute) {
+ $qb->andWhere('e.isStarred = true');
+ } elseif ('unread' === $currentRoute) {
+ $qb->andWhere('e.isArchived = false');
+ } elseif ('archive' === $currentRoute) {
+ $qb->andWhere('e.isArchived = true');
+ }
+
+ // We lower() all parts here because PostgreSQL 'LIKE' verb is case-sensitive
+ $qb
+ ->andWhere('lower(e.content) LIKE lower(:term) OR lower(e.title) LIKE lower(:term) OR lower(e.url) LIKE lower(:term)')->setParameter('term', '%'.$term.'%')
+ ->leftJoin('e.tags', 't')
+ ->groupBy('e.id');
+
+ return $qb;
+ }
+
+ /**
+ * Retrieves untagged entries for a user.
+ *
+ * @param int $userId
+ *
+ * @return QueryBuilder
+ */
+ public function getBuilderForUntaggedByUser($userId)
+ {
+ return $this
+ ->getBuilderByUser($userId)
+ ->andWhere('size(e.tags) = 0');
+ }
+