From 4afd5a547d32ff377a497a2b311efc40a39c19a4 Mon Sep 17 00:00:00 2001 From: Benjamin Brahmer Date: Fri, 19 Aug 2022 14:48:13 +0200 Subject: change itemMapper readAll Signed-off-by: Benjamin Brahmer --- lib/Db/ItemMapperV2.php | 6 +++--- 1 file 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( -- cgit v1.2.3