UserAnalyticsTopicsCreated.php in Open Social 8.9

Namespace

Drupal\social_user_export\Plugin\UserExportPlugin

File

modules/social_features/social_user_export/src/Plugin/UserExportPlugin/UserAnalyticsTopicsCreated.php

<?php

namespace Drupal\social_user_export\Plugin\UserExportPlugin;

use Drupal\social_user_export\Plugin\UserExportPluginBase;
use Drupal\user\UserInterface;

/**
 * Provides a 'UserAnalyticsTopicsCreated' user export row.
 *
 * @UserExportPlugin(
 *  id = "user_topics_created",
 *  label = @Translation("Topics created"),
 *  weight = -230,
 * )
 */
class UserAnalyticsTopicsCreated extends UserExportPluginBase {

  /**
   * {@inheritdoc}
   */
  public function getHeader() {
    return $this
      ->t('Topics created');
  }

  /**
   * {@inheritdoc}
   */
  public function getValue(UserInterface $entity) {
    $query = $this->database
      ->select('node', 'n');
    $query
      ->join('node_field_data', 'nfd', 'nfd.nid = n.nid');
    $query
      ->condition('nfd.uid', $entity
      ->id())
      ->condition('nfd.type', 'topic');
    return (int) $query
      ->countQuery()
      ->execute()
      ->fetchField();
  }

}

Classes

Name	Description
UserAnalyticsTopicsCreated	Provides a 'UserAnalyticsTopicsCreated' user export row.