function views_plugin_query::set_where_group

1 views_plugin_query.inc views_plugin_query::set_where_group($type = 'AND', $group = NULL, $where = 'where')

Create a new grouping for the WHERE or HAVING clause.

Parameters

$type: Either 'AND' or 'OR'. All items within this group will be added to the WHERE clause with this logical operator.

$group: An ID to use for this group. If unspecified, an ID will be generated.

$where: 'where' or 'having'.

Return value

$group: The group ID generated.

8 calls to views_plugin_query::set_where_group()

views_plugin_query_default::add_having in core/modules/views/plugins/views_plugin_query_default.inc: Add a simple HAVING clause to the query.
views_plugin_query_default::add_having in core/modules/views/plugins/views_plugin_query_default.inc: Add a simple HAVING clause to the query.
views_plugin_query_default::add_having_expression in core/modules/views/plugins/views_plugin_query_default.inc: Add a complex HAVING clause to the query. The caller is responsible for ensuring that all fields are fully qualified (TABLE.FIELD) and that the table and an appropriate GROUP BY already exist in the query. Internally the dbtng method…
views_plugin_query_default::add_having_expression in core/modules/views/plugins/views_plugin_query_default.inc: Add a complex HAVING clause to the query. The caller is responsible for ensuring that all fields are fully qualified (TABLE.FIELD) and that the table and an appropriate GROUP BY already exist in the query. Internally the dbtng method…
views_plugin_query_default::add_where in core/modules/views/plugins/views_plugin_query_default.inc: Add a simple WHERE clause to the query. The caller is responsible for ensuring that all fields are fully qualified (TABLE.FIELD) and that the table already exists in the query.

... See full list

File

core/modules/views/plugins/views_plugin_query.inc, line 147: Defines the base query class, which is the underlying layer in a View.

Class

views_plugin_query: Object used to create a SELECT query.

Code

function set_where_group($type = 'AND', $group = NULL, $where = 'where') {
  // Set an alias.
  $groups = &$this->$where;

  if (!isset($group)) {
    $group = empty($groups) ? 1 : max(array_keys($groups)) + 1;
  }

  // Create an empty group
  if (empty($groups[$group])) {
    $groups[$group] = array('conditions' => array(), 'args' => array());
  }

  $groups[$group]['type'] = strtoupper($type);
  return $group;
}