diff options
author | Benjamin Brahmer <info@b-brahmer.de> | 2022-08-19 14:48:13 +0200 |
---|---|---|
committer | Benjamin Brahmer <info@b-brahmer.de> | 2022-08-21 16:39:07 +0200 |
commit | 4afd5a547d32ff377a497a2b311efc40a39c19a4 (patch) | |
tree | f5223d402b450b5d15f33141106ed98209178bff | |
parent | 49f79101c314f760f36d1e6ef49758069622812c (diff) |
change itemMapper readAll
Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
-rw-r--r-- | lib/Db/ItemMapperV2.php | 6 |
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( |