class CommentType

class CommentType extends DrupalSqlBase {
  
  /**
   * A map of D7 node types to their labels.
   *
   * @var string[]
   */
  protected $nodeTypes = [];
  
  /**
   * {@inheritdoc}
   */
  public function query() {
    return $this->select('field_config_instance', 'fci')
      ->distinct()
      ->fields('fci', [
      'bundle',
    ])
      ->condition('fci.entity_type', 'comment');
  }
  
  /**
   * {@inheritdoc}
   */
  protected function initializeIterator() {
    $this->nodeTypes = $this->select('node_type', 'nt')
      ->fields('nt', [
      'type',
      'name',
    ])
      ->execute()
      ->fetchAllKeyed();
    return parent::initializeIterator();
  }
  
  /**
   * {@inheritdoc}
   */
  public function prepareRow(Row $row) {
    $node_type = substr($row->getSourceProperty('bundle'), 13);
    $row->setSourceProperty('node_type', $node_type);
    $row->setSourceProperty('default_mode', $this->variableGet("comment_default_mode_{$node_type}", 1));
    $row->setSourceProperty('per_page', $this->variableGet("comment_default_per_page_{$node_type}", 50));
    $row->setSourceProperty('anonymous', $this->variableGet("comment_anonymous_{$node_type}", FALSE));
    $row->setSourceProperty('form_location', $this->variableGet("comment_form_location_{$node_type}", CommentItemInterface::FORM_BELOW));
    $row->setSourceProperty('preview', $this->variableGet("comment_preview_{$node_type}", TRUE));
    $row->setSourceProperty('subject', $this->variableGet("comment_subject_field_{$node_type}", TRUE));
    $label = $this->t('@node_type comment', [
      '@node_type' => $this->nodeTypes[$node_type],
    ]);
    $row->setSourceProperty('label', $label);
    return parent::prepareRow($row);
  }
  
  /**
   * {@inheritdoc}
   */
  public function fields() {
    return [
      'label' => $this->t('The label of the comment type.'),
      'bundle' => $this->t('Bundle ID of the comment type.'),
      'node_type' => $this->t('The node type to which this comment type is attached.'),
      'default_mode' => $this->t('Default comment mode.'),
      'per_page' => $this->t('Number of comments visible per page.'),
      'anonymous' => $this->t('Whether anonymous comments are allowed.'),
      'form_location' => $this->t('Location of the comment form.'),
      'preview' => $this->t('Whether previews are enabled for the comment type.'),
      'subject' => $this->t('Whether a subject field is enabled for the comment type.'),
    ];
  }
  
  /**
   * {@inheritdoc}
   */
  public function getIds() {
    return [
      'bundle' => [
        'type' => 'string',
      ],
    ];
  }

}