public function PrivateMessageMapper::getFirstThreadIdForUser in Private Message 8

Same name and namespace in other branches

1. 8.2 src/Mapper/PrivateMessageMapper.php \Drupal\private_message\Mapper\PrivateMessageMapper::getFirstThreadIdForUser()

Retrieve the ID of the most recently updated thread for the given user.

Parameters

\Drupal\user\UserInterface $user: The user whose most recently updated thread should be retrieved.

Return value

int|bool The ID of the most recently updated thread the user is a member of if one exists, or FALSE if one doesn't.

Overrides PrivateMessageMapperInterface::getFirstThreadIdForUser

File

src/Mapper/PrivateMessageMapper.php, line 75

Class

PrivateMessageMapper

Interface for the Private Message Mapper class.

Namespace

Drupal\private_message\Mapper

Code

public function getFirstThreadIdForUser(UserInterface $user) {
  return $this->database
    ->queryRange('SELECT thread.id ' . 'FROM {private_message_threads} AS thread ' . 'JOIN {private_message_thread__members} AS member ' . 'ON member.entity_id = thread.id AND member.members_target_id = :uid ' . 'JOIN {private_message_thread__private_messages} AS thread_messages ' . 'ON thread_messages.entity_id = thread.id ' . 'JOIN {private_messages} AS messages ' . 'ON messages.id = thread_messages.private_messages_target_id ' . 'JOIN {private_message_thread__last_delete_time} AS thread_delete_time ' . 'ON thread_delete_time.entity_id = thread.id ' . 'JOIN {pm_thread_delete_time} as owner_delete_time ' . 'ON owner_delete_time.id = thread_delete_time.last_delete_time_target_id AND owner_delete_time.owner = :uid ' . 'WHERE owner_delete_time.delete_time <= messages.created ' . 'ORDER BY thread.updated DESC', 0, 1, [
    ':uid' => $user
      ->id(),
  ])
    ->fetchField();
}