public function revisioning_handler_filter_node_revision_moderation::query in Revisioning 7

Same name and namespace in other branches

1. 8 views/revisioning_handler_filter_node_revision_moderation.inc \revisioning_handler_filter_node_revision_moderation::query()
2. 6.4 views/revisioning_handler_filter_node_revision_moderation.inc \revisioning_handler_filter_node_revision_moderation::query()
3. 6.3 views/revisioning_handler_filter_node_revision_moderation.inc \revisioning_handler_filter_node_revision_moderation::query()

Add a where clause to the query.

Overrides views_handler_filter_in_operator::query

File

views/revisioning_handler_filter_node_revision_moderation.inc, line 16

Views filter override to filter on whether node is subject to moderation.

Class

revisioning_handler_filter_node_revision_moderation

Code

public function query() {
  if (empty($this->value) || isset($this->value[0]) && isset($this->value[1])) {

    // Don't filter if none or both options are set.
    return;
  }
  $moderated_content_types = array();
  foreach (revisioning_moderated_content_types() as $moderated_content_type) {
    $moderated_content_types[] = "'{$moderated_content_type}'";
  }
  $this
    ->ensure_my_table();
  if (empty($moderated_content_types)) {
    if (reset($this->value) == REVISIONING_MODERATED) {

      // None of the content types are moderated, so return nothing.
      $this->query
        ->add_where($this->options['group'], '1 = 0');
    }
  }
  else {
    $moderated = reset($this->value) == REVISIONING_MODERATED;
    if ($this->operator == 'not in') {
      $moderated = !$moderated;
    }
    $where_operator = $moderated ? 'IN' : 'NOT IN';
    $where_expression = $this->table_alias . '.type ' . $where_operator . ' (' . implode(',', $moderated_content_types) . ')';
    $this->query
      ->add_where_expression($this->options['group'], $where_expression);
  }
}