function SortDateTimeTest::testDateTimeSort

Tests the datetime sort handler.

File

core/modules/datetime/tests/src/Kernel/Views/SortDateTimeTest.php, line 52

Class

SortDateTimeTest

Tests for core <a href="/api/drupal/core%21modules%21datetime%21src%21Plugin%21views%21sort%21Date.php/class/Date/8.9.x" title="Basic sort handler for datetime fields." class="local">Drupal\datetime\Plugin\views\sort\Date</a> handler.

Namespace

Code

public function testDateTimeSort() {
    $field = static::$field_name . '_value';
    $view = Views::getView('test_sort_datetime');
    // Set granularity to 'minute', and the secondary node ID order should
    // define the order of nodes with the same minute.
    $view->initHandlers();
    $view->sort[$field]->options['granularity'] = 'minute';
    $view->setDisplay('default');
    $this->executeView($view);
    $expected_result = [
        [
            'nid' => $this->nodes[0]
                ->id(),
        ],
        [
            'nid' => $this->nodes[3]
                ->id(),
        ],
        [
            'nid' => $this->nodes[4]
                ->id(),
        ],
        [
            'nid' => $this->nodes[5]
                ->id(),
        ],
        [
            'nid' => $this->nodes[6]
                ->id(),
        ],
        [
            'nid' => $this->nodes[2]
                ->id(),
        ],
        [
            'nid' => $this->nodes[1]
                ->id(),
        ],
    ];
    $this->assertIdenticalResultset($view, $expected_result, $this->map);
    $view->destroy();
    // Check ASC.
    $view->initHandlers();
    $field = static::$field_name . '_value';
    $view->sort[$field]->options['order'] = 'ASC';
    $view->setDisplay('default');
    $this->executeView($view);
    $expected_result = [
        [
            'nid' => $this->nodes[1]
                ->id(),
        ],
        [
            'nid' => $this->nodes[2]
                ->id(),
        ],
        [
            'nid' => $this->nodes[3]
                ->id(),
        ],
        [
            'nid' => $this->nodes[5]
                ->id(),
        ],
        [
            'nid' => $this->nodes[4]
                ->id(),
        ],
        [
            'nid' => $this->nodes[6]
                ->id(),
        ],
        [
            'nid' => $this->nodes[0]
                ->id(),
        ],
    ];
    $this->assertIdenticalResultset($view, $expected_result, $this->map);
    $view->destroy();
    // Change granularity to 'year', and the secondary node ID order should
    // define the order of nodes with the same year.
    $view->initHandlers();
    $view->sort[$field]->options['granularity'] = 'year';
    $view->sort[$field]->options['order'] = 'DESC';
    $view->setDisplay('default');
    $this->executeView($view);
    $expected_result = [
        [
            'nid' => $this->nodes[0]
                ->id(),
        ],
        [
            'nid' => $this->nodes[1]
                ->id(),
        ],
        [
            'nid' => $this->nodes[2]
                ->id(),
        ],
        [
            'nid' => $this->nodes[3]
                ->id(),
        ],
        [
            'nid' => $this->nodes[4]
                ->id(),
        ],
        [
            'nid' => $this->nodes[5]
                ->id(),
        ],
        [
            'nid' => $this->nodes[6]
                ->id(),
        ],
    ];
    $this->assertIdenticalResultset($view, $expected_result, $this->map);
    $view->destroy();
    // Change granularity to 'second'.
    $view->initHandlers();
    $view->sort[$field]->options['granularity'] = 'second';
    $view->sort[$field]->options['order'] = 'DESC';
    $view->setDisplay('default');
    $this->executeView($view);
    $expected_result = [
        [
            'nid' => $this->nodes[0]
                ->id(),
        ],
        [
            'nid' => $this->nodes[6]
                ->id(),
        ],
        [
            'nid' => $this->nodes[4]
                ->id(),
        ],
        [
            'nid' => $this->nodes[5]
                ->id(),
        ],
        [
            'nid' => $this->nodes[3]
                ->id(),
        ],
        [
            'nid' => $this->nodes[2]
                ->id(),
        ],
        [
            'nid' => $this->nodes[1]
                ->id(),
        ],
    ];
    $this->assertIdenticalResultset($view, $expected_result, $this->map);
    $view->destroy();
}