diff options
| author | Joas Schilling <coding@schilljs.com> | 2018-07-30 09:41:51 +0200 |
|---|---|---|
| committer | Joas Schilling <coding@schilljs.com> | 2018-07-30 09:41:51 +0200 |
| commit | 66945f95749adcb4670a82156edc376dc4aa5b93 (patch) | |
| tree | 3ebd440527c0984030c3b4f1c074673b989b1c43 /lib | |
| parent | 566800b29c3376ede04439a92545059146f99505 (diff) | |
| download | nextcloud-server-66945f95749adcb4670a82156edc376dc4aa5b93.tar.gz nextcloud-server-66945f95749adcb4670a82156edc376dc4aa5b93.zip | |
Allow to filter the unread count by verb
Signed-off-by: Joas Schilling <coding@schilljs.com>
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/private/Comments/Manager.php | 9 | ||||
| -rw-r--r-- | lib/public/Comments/ICommentsManager.php | 3 |
2 files changed, 9 insertions, 3 deletions
diff --git a/lib/private/Comments/Manager.php b/lib/private/Comments/Manager.php index 8f76d49b192..6d9e37ae94e 100644 --- a/lib/private/Comments/Manager.php +++ b/lib/private/Comments/Manager.php @@ -546,12 +546,13 @@ class Manager implements ICommentsManager { * @param $objectId string the id of the object * @param \DateTime $notOlderThan optional, timestamp of the oldest comments * that may be returned + * @param string $verb Limit the verb of the comment - Added in 14.0.0 * @return Int * @since 9.0.0 */ - public function getNumberOfCommentsForObject($objectType, $objectId, \DateTime $notOlderThan = null) { + public function getNumberOfCommentsForObject($objectType, $objectId, \DateTime $notOlderThan = null, $verb = '') { $qb = $this->dbConn->getQueryBuilder(); - $query = $qb->select($qb->createFunction('COUNT(`id`)')) + $query = $qb->select($qb->createFunction('COUNT(' . $qb->getColumnName('id') . ')')) ->from('comments') ->where($qb->expr()->eq('object_type', $qb->createParameter('type'))) ->andWhere($qb->expr()->eq('object_id', $qb->createParameter('id'))) @@ -564,6 +565,10 @@ class Manager implements ICommentsManager { ->setParameter('notOlderThan', $notOlderThan, 'datetime'); } + if ($verb !== '') { + $query->andWhere($qb->expr()->eq('verb', $qb->createNamedParameter($verb))); + } + $resultStatement = $query->execute(); $data = $resultStatement->fetch(\PDO::FETCH_NUM); $resultStatement->closeCursor(); diff --git a/lib/public/Comments/ICommentsManager.php b/lib/public/Comments/ICommentsManager.php index ca98214cd72..744263643ec 100644 --- a/lib/public/Comments/ICommentsManager.php +++ b/lib/public/Comments/ICommentsManager.php @@ -157,10 +157,11 @@ interface ICommentsManager { * @param $objectId string the id of the object * @param \DateTime|null $notOlderThan optional, timestamp of the oldest comments * that may be returned + * @param string $verb Limit the verb of the comment - Added in 14.0.0 * @return Int * @since 9.0.0 */ - public function getNumberOfCommentsForObject($objectType, $objectId, \DateTime $notOlderThan = null); + public function getNumberOfCommentsForObject($objectType, $objectId, \DateTime $notOlderThan = null, $verb = ''); /** * Get the number of unread comments for all files in a folder |