class views_handler_sort_views_raw_sql in Views Raw SQL 7
Same name and namespace in other branches
- 6 views_handler_sort_views_raw_sql.inc \views_handler_sort_views_raw_sql
A handler to provide a field that is completely custom SQL by the administrator.
Hierarchy
- class \views_object
- class \views_handler
- class \views_handler_sort
- class \views_handler
Expanded class hierarchy of views_handler_sort_views_raw_sql
1 string reference to 'views_handler_sort_views_raw_sql'
- views_raw_sql_views_data in ./
views_raw_sql.module - Implements hook_views_data().
File
- ./
views_handler_sort_views_raw_sql.inc, line 8
View source
class views_handler_sort_views_raw_sql extends views_handler_sort {
function query() {
$raw_sql = $this->options['raw_sql'];
// Get replacement tokens.
$tokens = views_raw_sql_get_query_tokens($this->view);
// And replace.
$raw_sql = str_replace(array_keys($tokens), $tokens, $raw_sql);
$this->query
->add_orderby(NULL, $raw_sql, $this->options['order'], 'raw_sql_order');
}
// query
function option_definition() {
$options = parent::option_definition();
$options['raw_sql'] = array(
'default' => '',
);
return $options;
}
// option_definition
function options_form(&$form, &$form_state) {
parent::options_form($form, $form_state);
$form['raw_sql'] = array(
'#type' => 'textarea',
'#title' => 'SQL',
'#description' => t('This SQL will be added to the query as a sort expression.') . ' ' . views_raw_sql_tokens_help(),
'#default_value' => $this->options['raw_sql'],
'#required' => TRUE,
);
if (!user_access('edit views raw sql')) {
$form['raw_sql']['#disabled'] = TRUE;
$form['raw_sql']['#description'] = t('You lack %permission permission to edit this sort.', array(
'%permission' => 'edit views raw sql',
));
}
// if
}
// options_form
/**
* Simple submit handler
*/
function options_submit(&$form, &$form_state) {
$this->options['raw_sql'] = $form_state['values']['options']['raw_sql'];
}
}
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 | Provides the handler some groupby. | 2 |
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 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_handler_sort_views_raw_sql:: |
function |
Basic options for all sort criteria Overrides views_handler_sort:: |
||
views_handler_sort_views_raw_sql:: |
function |
Simple submit handler Overrides views_handler_sort:: |
||
views_handler_sort_views_raw_sql:: |
function |
Information about options for all kinds of purposes will be held here. Overrides views_handler_sort:: |
||
views_handler_sort_views_raw_sql:: |
function |
Called to add the sort to a query. Overrides views_handler_sort:: |
||
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 |