class availability_calendar_handler_sort_sql_date in Availability Calendars 7.5
Defines a sort handler for SQL date types.
Hierarchy
- class \views_object
- class \views_handler
- class \views_handler_sort
- class \views_handler
Expanded class hierarchy of availability_calendar_handler_sort_sql_date
1 string reference to 'availability_calendar_handler_sort_sql_date'
- AvailabilityCalendarViewsController::views_data in views/
availability_calendar_views_controller.inc - Overrides the result for hook_views_data().
File
- views/
availability_calendar_handler_sort_sql_date.inc, line 5
View source
class availability_calendar_handler_sort_sql_date extends views_handler_sort_date {
/**
* Override to change the default granularity.
*/
function option_definition() {
$options = parent::option_definition();
$options['granularity'] = array(
'default' => 'day',
);
return $options;
}
/**
* Override to reduce the granularity options.
*/
function options_form(&$form, &$form_state) {
parent::options_form($form, $form_state);
$form['granularity']['#options'] = array(
'day' => t('Day'),
'week' => t('Week'),
'month' => t('Month'),
'year' => t('Year'),
);
}
/**
* Override to handle the week granularity and handle the day granularity in a
* different way.
*/
function query() {
$this
->ensure_my_table();
switch ($this->options['granularity']) {
case 'day':
default:
$this->query
->add_orderby($this->table_alias, $this->real_field, $this->options['order']);
break;
case 'month':
case 'year':
parent::query();
break;
case 'week':
// Add the field.
$db_type = Database::getConnection()
->databaseType();
$field = "{$this->table_alias}.{$this->real_field}";
switch ($db_type) {
default:
case 'mysql':
// @todo: if first day of week is sunday we can use %X%V.
$formula = "DATE_FORMAT({$field}, '%x%v')";
break;
case 'pgsql':
$formula = "TO_CHAR({$field}, 'IYYYIW')";
break;
case 'sqlite':
// %V should be used instead, but I think that will not change the
// %Y modifier to return the year that belongs to the calculated
// week number (2013-01-01 will result in 201352 instead of 201252).
$formula = "strftime({$field}, %Y%W')";
break;
}
$this->query
->add_orderby(NULL, $formula, $this->options['order'], $this->table_alias . '_' . $this->field . '_' . $this->options['granularity']);
break;
}
}
}
Members
Name![]() |
Modifiers | Type | Description | Overrides |
---|---|---|---|---|
availability_calendar_handler_sort_sql_date:: |
function |
Override to reduce the granularity options. Overrides views_handler_sort_date:: |
||
availability_calendar_handler_sort_sql_date:: |
function |
Override to change the default granularity. Overrides views_handler_sort_date:: |
||
availability_calendar_handler_sort_sql_date:: |
function |
Override to handle the week granularity and handle the day granularity in a
different way. Overrides views_handler_sort_date:: |
||
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 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 |