UidRevision.php in Support Ticketing System 8

Contains \Drupal\support_ticket\Plugin\views\filter\UidRevision.

Namespace

Drupal\support_ticket\Plugin\views\filter

File

modules/support_ticket/src/Plugin/views/filter/UidRevision.php

<?php

/**
 * @file
 * Contains \Drupal\support_ticket\Plugin\views\filter\UidRevision.
 */
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 {
  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\n      ((SELECT COUNT(DISTINCT vid) FROM {support_ticket_revision} nr WHERE nr.revision_uid IN ({$placeholder}) AND nr.stid = {$this->tableAlias}.stid) > 0)", array(
      $placeholder => $args,
    ), $args);
  }

}

Classes

Name	Description
UidRevision	Filter handler to check for revisions a certain user has created.