diff options
author | Marco Nassabain <marco.nassabain@hotmail.com> | 2021-02-24 23:33:36 +0100 |
---|---|---|
committer | Sean Molenaar <SMillerDev@users.noreply.github.com> | 2021-04-08 22:31:21 +0200 |
commit | 08982fc54088677cf4e9c5a0340a90e6eb406319 (patch) | |
tree | 0e19bda74681f2847162818c2a794a2215de55b1 /lib/Db | |
parent | 0f6ec7c99ca43da46766ca6126ae20d280e9b662 (diff) |
✨ Add findAllSharedAfter
- adapted Controller, Service and Mapper (newItems)
Signed-off-by: Marco Nassabain <marco.nassabain@hotmail.com>
Diffstat (limited to 'lib/Db')
-rw-r--r-- | lib/Db/ItemMapperV2.php | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/lib/Db/ItemMapperV2.php b/lib/Db/ItemMapperV2.php index 0e90fca40..5399272ce 100644 --- a/lib/Db/ItemMapperV2.php +++ b/lib/Db/ItemMapperV2.php @@ -392,6 +392,36 @@ class ItemMapperV2 extends NewsMapperV2 } /** + * @param string $userId + * @param int|null $folderId + * @param int $updatedSince + * @param bool $hideRead + * + * @return Item[] + */ + public function findAllSharedAfter( + string $userId, + int $updatedSince, + bool $hideRead + ): array { + $builder = $this->db->getQueryBuilder(); + + $builder->select('items.*') + ->from($this->tableName, 'items') + ->andWhere('items.last_modified >= :updatedSince') + ->andWhere('items.shared_with = :sharedWith') + ->setParameters(['updatedSince' => $updatedSince, 'sharedWith' => $userId]) + ->orderBy('items.last_modified', 'DESC') + ->addOrderBy('items.id', 'DESC'); + + if ($hideRead === true) { + $builder->andWhere('items.unread = 1'); + } + + return $this->findEntities($builder); + } + + /** * @param string $userId * @param int $updatedSince * @param int $feedType |