public function CommentStorage::getUnapprovedCount in Drupal 9

Same name and namespace in other branches

1. 8 core/modules/comment/src/CommentStorage.php \Drupal\comment\CommentStorage::getUnapprovedCount()
2. 10 core/modules/comment/src/CommentStorage.php \Drupal\comment\CommentStorage::getUnapprovedCount()

Returns the number of unapproved comments.

Return value

int The number of unapproved comments.

Overrides CommentStorageInterface::getUnapprovedCount

File

core/modules/comment/src/CommentStorage.php, line 342

Class

CommentStorage

Defines the storage handler class for comments.

Namespace

Drupal\comment

Code

public function getUnapprovedCount() {
  return $this->database
    ->select($this
    ->getDataTable(), 'c')
    ->condition('status', CommentInterface::NOT_PUBLISHED, '=')
    ->condition('default_langcode', 1)
    ->countQuery()
    ->execute()
    ->fetchField();
}