summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBenjamin Brahmer <info@b-brahmer.de>2022-08-19 14:48:13 +0200
committerBenjamin Brahmer <info@b-brahmer.de>2022-08-21 16:39:07 +0200
commit4afd5a547d32ff377a497a2b311efc40a39c19a4 (patch)
treef5223d402b450b5d15f33141106ed98209178bff
parent49f79101c314f760f36d1e6ef49758069622812c (diff)
change itemMapper readAll
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
-rw-r--r--lib/Db/ItemMapperV2.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/Db/ItemMapperV2.php b/lib/Db/ItemMapperV2.php
index 1e206f846..67b685625 100644
--- a/lib/Db/ItemMapperV2.php
+++ b/lib/Db/ItemMapperV2.php
@@ -276,8 +276,10 @@ class ItemMapperV2 extends NewsMapperV2
->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id')
->andWhere('feeds.user_id = :userId')
->andWhere('items.id <= :maxItemId')
+ ->andWhere('items.unread != :unread')
->setParameter('userId', $userId)
- ->setParameter('maxItemId', $maxItemId);
+ ->setParameter('maxItemId', $maxItemId)
+ ->setParameter('unread', false, IQueryBuilder::PARAM_BOOL);
$idList = array_map(function ($value): int {
return intval($value['id']);
@@ -287,8 +289,6 @@ class ItemMapperV2 extends NewsMapperV2
$builder->update(self::TABLE_NAME)
->set('unread', $builder->createParameter('unread'))
->andWhere('id IN (:idList)')
- ->andWhere('unread != :unread')
- ->setParameter('unread', false, IQueryBuilder::PARAM_BOOL)
->setParameter('idList', $idList, IQueryBuilder::PARAM_INT_ARRAY);
return $this->db->executeStatement(