support-2.0.x-dev/modules/support_ticket/src/Plugin/views/filter/UidRevision.php

<?php

namespace Drupal\support_ticket\Plugin\views\filter;

use Drupal\user\Plugin\views\filter\Name;

/**
 * Filter handler to check for revisions a certain user has created.
 *
 * @ingroup views_filter_handlers
 *
 * @ViewsFilter("support_ticket_uid_revision")
 */
class UidRevision extends Name {

  /**
   * Query method.
   *
   * @todo what does the query method do.
   *
   * @param bool $group_by
   *   Boolean variable.
   */
  public function query($group_by = FALSE) {
    $this->ensureMyTable();

    $placeholder = $this->placeholder() . '[]';

    $args = array_values($this->value);

    $this->query->addWhereExpression($this->options['group'], "$this->tableAlias.uid IN($placeholder) OR
      ((SELECT COUNT(DISTINCT vid) FROM {support_ticket_revision} nr WHERE nr.revision_uid IN ($placeholder) AND nr.stid = $this->tableAlias.stid) > 0)", [$placeholder => $args],
      $args);
  }

}