function views_handler_filter_comment_user_uid::query in Views (for Drupal 7) 6.3

Same name and namespace in other branches

1. 6.2 modules/comment/views_handler_filter_comment_user_uid.inc \views_handler_filter_comment_user_uid::query()
2. 7.3 modules/comment/views_handler_filter_comment_user_uid.inc \views_handler_filter_comment_user_uid::query()

Add this filter to the query.

Due to the nature of fapi, the value and the operator have an unintended level of indirection. You will find them in $this->operator and $this->value respectively.

Overrides views_handler_filter_in_operator::query

File

modules/comment/views_handler_filter_comment_user_uid.inc, line 10

Class

views_handler_filter_comment_user_uid

Filter handler to accept a user id to check for nodes that user posted or commented on.

Code

function query() {
  $this
    ->ensure_my_table();
  $replace = array_fill(0, sizeof($this->value), '%d');
  $condition = $this->operator . ' (' . implode(", ", $replace) . ')';

  // We include the WHERE condition twice in the query, so we need two
  // copies of these argument values.
  $args = array_values($this->value);
  $args = array_merge($args, $args);
  $this->query
    ->add_where($this->options['group'], "{$this->table_alias}.uid " . $condition . " OR\n      ((SELECT COUNT(*) FROM {comments} c WHERE c.uid " . $condition . " AND c.nid = {$this->table_alias}.nid) > 0)", $args);
}