CommentStorage::getDisplayOrdinal

public CommentStorage::getDisplayOrdinal(CommentInterface $comment, $comment_mode, $divisor = 1)

Gets the display ordinal or page number for a comment.

Parameters

\Drupal\comment\CommentInterface $comment: The comment to use as a reference point.

int $comment_mode: The comment display mode: CommentManagerInterface::COMMENT_MODE_FLAT or CommentManagerInterface::COMMENT_MODE_THREADED.

int $divisor: Defaults to 1, which returns the display ordinal for a comment. If the number of comments per page is provided, the returned value will be the page number. (The return value will be divided by $divisor.)

Return value

int The display ordinal or page number for the comment. It is 0-based, so will represent the number of items before the given comment/page.

Overrides CommentStorageInterface::getDisplayOrdinal

File

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

Class

CommentStorage
Defines the storage handler class for comments.

Namespace

Drupal\comment

Code

public function getDisplayOrdinal(CommentInterface $comment, $comment_mode, $divisor = 1) {
  // Count how many comments (c1) are before $comment (c2) in display order.
  // This is the 0-based display ordinal.
  $query = $this->database->select('comment_field_data', 'c1');
  $query->innerJoin('comment_field_data', 'c2', 'c2.entity_id = c1.entity_id AND c2.entity_type = c1.entity_type AND c2.field_name = c1.field_name');
  $query->addExpression('COUNT(*)', 'count');
  $query->condition('c2.cid', $comment->id());
  if (!$this->currentUser->hasPermission('administer comments')) {
    $query->condition('c1.status', CommentInterface::PUBLISHED);
  }

  if ($comment_mode == CommentManagerInterface::COMMENT_MODE_FLAT) {
    // For rendering flat comments, cid is used for ordering comments due to
    // unpredictable behavior with timestamp, so we make the same assumption
    // here.
    $query->condition('c1.cid', $comment->id(), '<');
  }
  else {
    // For threaded comments, the c.thread column is used for ordering. We can
    // use the sorting code for comparison, but must remove the trailing
    // slash.
    $query->where('SUBSTRING(c1.thread, 1, (LENGTH(c1.thread) - 1)) < SUBSTRING(c2.thread, 1, (LENGTH(c2.thread) - 1))');
  }

  $query->condition('c1.default_langcode', 1);
  $query->condition('c2.default_langcode', 1);

  $ordinal = $query->execute()->fetchField();

  return ($divisor > 1) ? floor($ordinal / $divisor) : $ordinal;
}
doc_Drupal
2016-10-29 08:51:00
Comments
Leave a Comment

Please login to continue.