class views_sort_expression_handler in Views Sort Expression 7
Generic views handler filter to add code to manipulate the query object.
Hierarchy
- class \views_object
- class \views_handler
- class \views_handler_sort
- class \views_handler
Expanded class hierarchy of views_sort_expression_handler
1 string reference to 'views_sort_expression_handler'
- views_sort_expression_views_data_alter in views/
views_sort_expression.views.inc - Alter the table and field information from hook_views_data().
File
- views/
views_sort_expression_handler.inc, line 13 - Filter classes.
View source
class views_sort_expression_handler extends views_handler_sort {
/**
* {@inheritdoc}
*/
public function option_definition() {
$options = parent::option_definition();
$options['expression'] = array(
'default' => NULL,
);
$options['aggregate'] = array(
'default' => NULL,
);
return $options;
}
/**
* {@inheritdoc}
*/
public function options_form(&$form, &$form_state) {
parent::options_form($form, $form_state);
$form['expression'] = array(
'#type' => 'textarea',
'#title' => t('Expression'),
'#default_value' => $this->options['expression'],
'#description' => t('<b>This is an advanced sort handler.</b> You can use whatever is available on the SQL. If what you need is not on the query, you could add other sort handlers in the end that will make some others to be available. You should probably want to enable "Show the SQL query" on the <a href="!url">settings</a> page.', array(
'!url' => url('admin/structure/views/settings'),
)),
);
$form['aggregate'] = array(
'#type' => 'checkbox',
'#title' => t('Expression has an aggregate function'),
'#default_value' => $this->options['aggregate'],
'#description' => t('This allows you to use an <a href="https://www.w3schools.com/sql/sql_groupby.asp">aggregate function</a> on the expression, instead of relying on the views aggregation plugins which doesn\'t otherwise work nicely with this sort handler.'),
);
}
/**
* {@inheritdoc}
*/
public function use_group_by() {
return FALSE;
}
/**
* {@inheritdoc}
*/
public function query() {
if (!empty($this->options['expression'])) {
$alias = $this->real_field . '_' . $this->position;
$this->query
->add_orderby(NULL, $this->options['expression'], $this->options['order'], $alias);
}
}
}
Members
Name![]() |
Modifiers | Type | Description | Overrides |
---|---|---|---|---|
views_handler:: |
public | property | The type of the handler, for example filter/footer/field. | |
views_handler:: |
public | property | Where the $query object will reside:. | 1 |
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 | Take input from exposed handlers and assign to this handler, if necessary. | 1 |
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 | Render our chunk of the exposed handler form when selecting. | 1 |
views_handler:: |
public | function | Get information about the exposed form for the form renderer. | 1 |
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 | Validate the options form. | 1 |
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 | Init the handler with necessary data. | 6 |
views_handler:: |
public | function | Returns TRUE if the exposed filter works like a grouped filter. | 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 | Define if the exposed input has to be submitted multiple times. This is TRUE when exposed filters grouped are using checkboxes as widgets. | 1 |
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 | If set to remember exposed input in the session, store it there. | 1 |
views_handler:: |
public | function | Return a string representing this handler's name in the UI. | 9 |
views_handler:: |
public | function | Validates the handler against the complete View. | 1 |
views_handler_sort:: |
public | function |
Display whether or not the sort order is ascending or descending Overrides views_handler:: |
1 |
views_handler_sort:: |
public | function |
Determine if a sort can be exposed. Overrides views_handler:: |
1 |
views_handler_sort:: |
public | function |
Form for exposed handler options. Overrides views_handler:: |
|
views_handler_sort:: |
public | function |
Provide default options for exposed sorts. Overrides views_handler:: |
|
views_handler_sort:: |
public | function |
Simple submit handler. Overrides views_handler:: |
|
views_handler_sort:: |
public | function |
Simple validate handler. Overrides views_handler:: |
|
views_handler_sort:: |
public | function |
Shortcut to display the expose/hide button. Overrides views_handler:: |
|
views_handler_sort:: |
public | function | Shortcut to display the value form. | 1 |
views_handler_sort:: |
public | function | Provide a list of options for the default sort form. | |
views_handler_sort:: |
public | function | ||
views_handler_sort:: |
public | function | ||
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 | ||
views_sort_expression_handler:: |
public | function |
Basic options for all sort criteria Overrides views_handler_sort:: |
|
views_sort_expression_handler:: |
public | function |
Information about options for all kinds of purposes will be held here. Overrides views_handler_sort:: |
|
views_sort_expression_handler:: |
public | function |
Called to add the sort to a query. Overrides views_handler_sort:: |
|
views_sort_expression_handler:: |
public | function |
Provides the handler some groupby. Overrides views_handler:: |