class views_handler_filter_combine in Views (for Drupal 7) 7.3
Filter handler which allows to search on multiple fields.
Hierarchy
- class \views_object
- class \views_handler
- class \views_handler_filter
- class \views_handler_filter_string
- class \views_handler_filter_combine
- class \views_handler_filter_string
- class \views_handler_filter
- class \views_handler
Expanded class hierarchy of views_handler_filter_combine
Related topics
1 string reference to 'views_handler_filter_combine'
- views_views_data in modules/
views.views.inc - Implements hook_views_data().
File
- handlers/
views_handler_filter_combine.inc, line 13 - Definition of views_handler_filter_combine.
View source
class views_handler_filter_combine extends views_handler_filter_string {
/**
* @var views_plugin_query_default
*/
public $query;
/**
* {@inheritdoc}
*/
public function option_definition() {
$options = parent::option_definition();
$options['fields'] = array(
'default' => array(),
);
return $options;
}
/**
* {@inheritdoc}
*/
public function options_form(&$form, &$form_state) {
parent::options_form($form, $form_state);
$this->view
->init_style();
// Allow to choose all fields as possible.
if ($this->view->style_plugin
->uses_fields()) {
$options = array();
foreach ($this->view->display_handler
->get_handlers('field') as $name => $field) {
$options[$name] = $field
->ui_name(TRUE);
}
if ($options) {
$form['fields'] = array(
'#type' => 'select',
'#title' => t('Choose fields to combine for filtering'),
'#description' => t("This filter doesn't work for very special field handlers."),
'#multiple' => TRUE,
'#options' => $options,
'#default_value' => $this->options['fields'],
);
}
else {
form_set_error('', t('You have to add some fields to be able to use this filter.'));
}
}
}
/**
* {@inheritdoc}
*/
public function query() {
$this->view
->_build('field');
$fields = array();
// Only add the fields if they have a proper field and table alias.
foreach ($this->options['fields'] as $id) {
// Field access checks may have removed this handler.
if (!isset($this->view->field[$id])) {
continue;
}
$field = $this->view->field[$id];
// Always add the table of the selected fields to be sure a table alias
// exists.
$field
->ensure_my_table();
if (!empty($field->table_alias) && !empty($field->real_field)) {
$fields[] = "{$field->table_alias}.{$field->real_field}";
}
}
if ($fields) {
$count = count($fields);
$separated_fields = array();
foreach ($fields as $key => $field) {
$separated_fields[] = $field;
if ($key < $count - 1) {
$separated_fields[] = "' '";
}
}
$expression = implode(', ', $separated_fields);
$expression = "CONCAT_WS(' ', {$expression})";
$info = $this
->operators();
if (!empty($info[$this->operator]['method'])) {
$this
->{$info[$this->operator]['method']}($expression);
}
}
}
/**
* By default things like op_equal uses add_where, that doesn't support
* complex expressions, so override all operators.
*/
public function op_equal($field) {
$placeholder = $this
->placeholder();
$operator = $this
->operator();
$this->query
->add_where_expression($this->options['group'], "{$field} {$operator} {$placeholder}", array(
$placeholder => $this->value,
));
}
/**
*
*/
public function op_contains($field) {
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['group'], "{$field} LIKE {$placeholder}", array(
$placeholder => '%' . db_like($this->value) . '%',
));
}
/**
*
*/
public function op_word($field) {
$where = $this->operator == 'word' ? db_or() : db_and();
// Don't filter on empty strings.
if (empty($this->value)) {
return;
}
preg_match_all('/ (-?)("[^"]+"|[^" ]+)/i', ' ' . $this->value, $matches, PREG_SET_ORDER);
foreach ($matches as $match) {
$phrase = FALSE;
// Strip off phrase quotes.
if ($match[2][0] == '"') {
$match[2] = substr($match[2], 1, -1);
$phrase = TRUE;
}
$words = trim($match[2], ',?!();:-');
$words = $phrase ? array(
$words,
) : preg_split('/ /', $words, -1, PREG_SPLIT_NO_EMPTY);
$placeholder = $this
->placeholder();
foreach ($words as $word) {
$where
->where($field . " LIKE {$placeholder}", array(
$placeholder => '%' . db_like(trim($word, " ,!?")) . '%',
));
}
}
if (!$where) {
return;
}
// Previously this was a call_user_func_array() but that's unnecessary
// as views will unpack an array that is a single arg.
$this->query
->add_where($this->options['group'], $where);
}
/**
*
*/
public function op_starts($field) {
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['group'], "{$field} LIKE {$placeholder}", array(
$placeholder => db_like($this->value) . '%',
));
}
/**
*
*/
public function op_not_starts($field) {
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['group'], "{$field} NOT LIKE {$placeholder}", array(
$placeholder => db_like($this->value) . '%',
));
}
/**
*
*/
public function op_ends($field) {
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['group'], "{$field} LIKE {$placeholder}", array(
$placeholder => '%' . db_like($this->value),
));
}
/**
*
*/
public function op_not_ends($field) {
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['group'], "{$field} NOT LIKE {$placeholder}", array(
$placeholder => '%' . db_like($this->value),
));
}
/**
*
*/
public function op_not($field) {
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['group'], "{$field} NOT LIKE {$placeholder}", array(
$placeholder => '%' . db_like($this->value) . '%',
));
}
/**
*
*/
public function op_regex($field) {
if (empty($this->value)) {
return;
}
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['group'], "{$field} RLIKE {$placeholder}", array(
$placeholder => $this->value,
));
}
/**
*
*/
public function op_not_regex($field) {
$placeholder = $this
->placeholder();
$this->query
->add_where_expression($this->options['group'], "{$field} NOT RLIKE {$placeholder}", array(
$placeholder => $this->value,
));
}
/**
*
*/
public function op_empty($field) {
if ($this->operator == 'empty') {
$operator = "IS NULL";
}
else {
$operator = "IS NOT NULL";
}
$this->query
->add_where_expression($this->options['group'], "{$field} {$operator}");
}
}
Members
Name![]() |
Modifiers | Type | Description | Overrides |
---|---|---|---|---|
views_handler:: |
public | property | The type of the handler, for example filter/footer/field. | |
views_handler:: |
public | property | The actual field in the database table, maybe different on other kind of query plugins/special handlers. | |
views_handler:: |
public | property | The relationship used for this field. | |
views_handler:: |
public | property | The alias of the table of this handler which is used in the query. | |
views_handler:: |
public | property |
The top object of a view. Overrides views_object:: |
|
views_handler:: |
public | function | Check whether current user has access to this handler. | 10 |
views_handler:: |
public | function | Determine if the handler is considered 'broken'. | 6 |
views_handler:: |
public | function | Transform a string by a certain method. | |
views_handler:: |
public | function | Ensure the main table for this handler is in the query. This is used a lot. | 8 |
views_handler:: |
public | function | Submit the exposed handler form. | |
views_handler:: |
public | function | Validate the exposed handler form. | 4 |
views_handler:: |
public | function | Perform any necessary changes to the form exposes prior to storage. There is no need for this function to actually store the data. | |
views_handler:: |
public | function | Provide defaults for the handler. | |
views_handler:: |
public | function | Provide a form for setting options. | 1 |
views_handler:: |
public | function | Perform any necessary changes to the form values prior to storage. There is no need for this function to actually store the data. | |
views_handler:: |
public | function | Validate the options form. | |
views_handler:: |
public | function | Shortcut to get a handler's raw field value. | |
views_handler:: |
public | function | Get the join object that should be used for this handler. | |
views_handler:: |
public | function | Provide a form for aggregation settings. | 1 |
views_handler:: |
public | function | Perform any necessary changes to the form values prior to storage. There is no need for this function to actually store the data. | 1 |
views_handler:: |
public | function | If a handler has 'extra options' it will get a little settings widget and another form called extra_options. | 1 |
views_handler:: |
public | function | Determine if this item is 'exposed', meaning it provides form elements to let users modify the view. | |
views_handler:: |
public | function | Determine if the argument needs a style plugin. | 1 |
views_handler:: |
public | function | Provides a unique placeholders for handlers. | |
views_handler:: |
public | function | Run after the view is executed, before the result is cached. | 1 |
views_handler:: |
public | function | Run before the view is built. | 1 |
views_handler:: |
public | function | Sanitize the value for output. | |
views_handler:: |
public | function | Called just prior to query(), this lets a handler set up any relationship it needs. | |
views_handler:: |
public | function | Shortcut to display the exposed options form. | |
views_handler:: |
public | function | Return a string representing this handler's name in the UI. | 9 |
views_handler:: |
public | function | Provides the handler some groupby. | 2 |
views_handler:: |
public | function | Validates the handler against the complete View. | 1 |
views_handler_filter:: |
public | property | Disable the possibility to allow a exposed input to be optional. | |
views_handler_filter:: |
public | property | Contains the information of the selected item in a gruped filter. | |
views_handler_filter:: |
public | property | Disable the possibility to use operators. | 2 |
views_handler_filter:: |
public | property | Contains the operator which is used on the query. | |
views_handler_filter:: |
public | property | Contains the actual value of the field. | |
views_handler_filter:: |
public | function |
Check to see if input from the exposed filters should change the behavior. Overrides views_handler:: |
2 |
views_handler_filter:: |
public | function | Build the form to let users create the group of exposed filters. | |
views_handler_filter:: |
public | function | Provide default options for exposed filters. | |
views_handler_filter:: |
public | function | Save new group items, re-enumerates and remove groups marked to delete. | |
views_handler_filter:: |
public | function | Validate the build group options form. | 1 |
views_handler_filter:: |
public | function | Determine if a filter can be converted into a group. | |
views_handler_filter:: |
public | function |
Determine if a filter can be exposed. Overrides views_handler:: |
5 |
views_handler_filter:: |
public | function | Can this filter be used in OR groups? | 1 |
views_handler_filter:: |
public | function | Transform the input from a grouped filter into a standard filter. | |
views_handler_filter:: |
public | function |
Render our chunk of the exposed filter form when selecting. Overrides views_handler:: |
|
views_handler_filter:: |
public | function |
Tell the renderer about our exposed form. Overrides views_handler:: |
|
views_handler_filter:: |
public | function | Make some translations to a form item to make it more suitable to exposing. | |
views_handler_filter:: |
public | function |
Options form subform for exposed filter options. Overrides views_handler:: |
2 |
views_handler_filter:: |
public | function |
Provide default options for exposed filters. Overrides views_handler:: |
2 |
views_handler_filter:: |
public | function |
Validate the options form. Overrides views_handler:: |
|
views_handler_filter:: |
public | function | Build a form with a group of operator | values to apply as a single filter. | |
views_handler_filter:: |
public | function | Options available for a grouped filter which uses checkboxes. | |
views_handler_filter:: |
public | function |
Provide some extra help to get the operator/value easier to use. Overrides views_handler:: |
2 |
views_handler_filter:: |
public | function |
Returns TRUE if the exposed filter works like a grouped filter. Overrides views_handler:: |
|
views_handler_filter:: |
public | function |
Indicate whether users can select multiple group items. Overrides views_handler:: |
|
views_handler_filter:: |
public | function | Options form subform for setting the operator. | 6 |
views_handler_filter:: |
public | function | Perform any necessary changes to the form values prior to storage. | |
views_handler_filter:: |
public | function | Validate the operator form. | |
views_handler_filter:: |
public | function |
Simple submit handler. Overrides views_handler:: |
|
views_handler_filter:: |
public | function |
Simple validate handler. Overrides views_handler:: |
1 |
views_handler_filter:: |
public | function | Sanitizes the HTML select element's options. | |
views_handler_filter:: |
public | function | Shortcut to display the build_group/hide button. | |
views_handler_filter:: |
public | function | Shortcut to display the exposed options form. | |
views_handler_filter:: |
public | function |
Shortcut to display the expose/hide button. Overrides views_handler:: |
|
views_handler_filter:: |
public | function | Shortcut to display the operator form. | |
views_handler_filter:: |
public | function | Shortcut to display the value form. | |
views_handler_filter:: |
public | function |
Store the exposed input for processing later. Overrides views_handler:: |
|
views_handler_filter:: |
public | function | If set to remember exposed input in the session, store it there. | |
views_handler_filter:: |
public | function | Perform any necessary changes to the form values prior to storage. | 1 |
views_handler_filter:: |
public | function | Validate the options form. | 3 |
views_handler_filter_combine:: |
public | property |
Overrides views_handler:: |
|
views_handler_filter_combine:: |
public | function |
Provide the basic form which calls through to subforms. Overrides views_handler_filter:: |
|
views_handler_filter_combine:: |
public | function |
Information about options for all kinds of purposes will be held here. Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
By default things like op_equal uses add_where, that doesn't support
complex expressions, so override all operators. Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Overrides views_handler_filter_string:: |
|
views_handler_filter_combine:: |
public | function |
Add this filter to the query. Overrides views_handler_filter_string:: |
|
views_handler_filter_string:: |
public | property |
Exposed filter options. Overrides views_handler_filter:: |
|
views_handler_filter_string:: |
public | function |
Display the filter on the administrative summary. Overrides views_handler_filter:: |
|
views_handler_filter_string:: |
public | function | ||
views_handler_filter_string:: |
public | function | This kind of construct makes it relatively easy for a child class to add or remove functionality by overriding this function and adding/removing items from this array. | |
views_handler_filter_string:: |
public | function |
Build strings from the operators() for 'select' options. Overrides views_handler_filter:: |
|
views_handler_filter_string:: |
public | function | ||
views_handler_filter_string:: |
public | function | ||
views_handler_filter_string:: |
public | function | ||
views_handler_filter_string:: |
public | function |
Provide a simple textfield for equality. Overrides views_handler_filter:: |
|
views_object:: |
public | property | Handler's definition. | |
views_object:: |
public | property | Except for displays, options for the object will be held here. | 1 |
views_object:: |
function | Collect this handler's option definition and alter them, ready for use. | ||
views_object:: |
public | function | Views handlers use a special construct function. | 4 |
views_object:: |
public | function | Destructor. | 2 |
views_object:: |
public | function | 1 | |
views_object:: |
public | function | ||
views_object:: |
public | function | Always exports the option, regardless of the default value. | |
views_object:: |
public | function | Set default options on this object. | 1 |
views_object:: |
public | function | Set default options. | |
views_object:: |
public | function | Let the handler know what its full definition is. | |
views_object:: |
public | function | Unpack options over our existing defaults, drilling down into arrays so that defaults don't get totally blown away. | |
views_object:: |
public | function | Unpack a single option definition. | |
views_object:: |
public | function | Unpacks each handler to store translatable texts. | |
views_object:: |
public | function |