From baf1ca8ec9e3964c97c6e11ca9c6a56e38b8fe48 Mon Sep 17 00:00:00 2001 From: Sean Molenaar Date: Tue, 23 Mar 2021 20:05:58 +0100 Subject: DB: Don't show deleted feed items Signed-off-by: Sean Molenaar --- lib/Db/ItemMapperV2.php | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'lib') diff --git a/lib/Db/ItemMapperV2.php b/lib/Db/ItemMapperV2.php index 33b4611f9..93457d4f9 100644 --- a/lib/Db/ItemMapperV2.php +++ b/lib/Db/ItemMapperV2.php @@ -316,6 +316,7 @@ class ItemMapperV2 extends NewsMapperV2 ->andWhere('items.last_modified >= :updatedSince') ->andWhere('feeds.user_id = :userId') ->andWhere('feeds.id = :feedId') + ->andWhere('feeds.deleted_at = 0') ->setParameters([ 'updatedSince' => $updatedSince, 'feedId' => $feedId, @@ -353,6 +354,7 @@ class ItemMapperV2 extends NewsMapperV2 ->innerJoin('feeds', FolderMapperV2::TABLE_NAME, 'folders', 'feeds.folder_id = folders.id') ->andWhere('items.last_modified >= :updatedSince') ->andWhere('feeds.user_id = :userId') + ->andWhere('feeds.deleted_at = 0') ->andWhere('folders.id = :folderId') ->setParameters(['updatedSince' => $updatedSince, 'folderId' => $folderId, 'userId' => $userId]) ->orderBy('items.last_modified', 'DESC') @@ -381,6 +383,7 @@ class ItemMapperV2 extends NewsMapperV2 ->from($this->tableName, 'items') ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id') ->andWhere('items.last_modified >= :updatedSince') + ->andWhere('feeds.deleted_at = 0') ->andWhere('feeds.user_id = :userId') ->setParameters(['updatedSince' => $updatedSince, 'userId' => $userId]) ->orderBy('items.last_modified', 'DESC') @@ -443,6 +446,7 @@ class ItemMapperV2 extends NewsMapperV2 $builder->select('items.*') ->from($this->tableName, 'items') ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id') + ->andWhere('feeds.deleted_at = 0') ->andWhere('feeds.user_id = :userId') ->andWhere('items.feed_id = :feedId') ->setParameter('userId', $userId) @@ -503,6 +507,7 @@ class ItemMapperV2 extends NewsMapperV2 ->from($this->tableName, 'items') ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id') ->andWhere('feeds.user_id = :userId') + ->andWhere('feeds.deleted_at = 0') ->andWhere($folderWhere) ->setParameter('userId', $userId) ->setMaxResults($limit) @@ -554,6 +559,7 @@ class ItemMapperV2 extends NewsMapperV2 ->from($this->tableName, 'items') ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id') ->andWhere('feeds.user_id = :userId') + ->andWhere('feeds.deleted_at = 0') ->setParameter('userId', $userId) ->setMaxResults($limit) ->orderBy('items.last_modified', ($oldestFirst ? 'ASC' : 'DESC')) -- cgit v1.2.3