function Date::query

Called to add the sort to a query.

Overrides SortPluginBase::query

File

core/modules/views/src/Plugin/views/sort/Date.php, line 47

Class

Date

Basic sort handler for dates.

Namespace

Code

public function query() {
    $this->ensureMyTable();
    switch ($this->options['granularity']) {
        case 'second':
        default:
            $this->query
                ->addOrderBy($this->tableAlias, $this->realField, $this->options['order']);
            return;
        case 'minute':
            $formula = $this->getDateFormat('YmdHi');
            break;
        case 'hour':
            $formula = $this->getDateFormat('YmdH');
            break;
        case 'day':
            $formula = $this->getDateFormat('Ymd');
            break;
        case 'month':
            $formula = $this->getDateFormat('Ym');
            break;
        case 'year':
            $formula = $this->getDateFormat('Y');
            break;
    }
    // Add the field.
    $this->query
        ->addOrderBy(NULL, $formula, $this->options['order'], $this->tableAlias . '_' . $this->field . '_' . $this->options['granularity']);
}