function QueryGroupByTest::testGroupByFieldWithCardinality

Tests grouping a field with cardinality > 1.

File

core/modules/views/tests/src/Kernel/QueryGroupByTest.php, line 239

Class

QueryGroupByTest

Tests aggregate functionality of views, for example count.

Namespace

Code

public function testGroupByFieldWithCardinality() {
    $field_storage = FieldStorageConfig::create([
        'type' => 'integer',
        'field_name' => 'field_test',
        'cardinality' => 4,
        'entity_type' => 'entity_test_mul',
    ]);
    $field_storage->save();
    $field = FieldConfig::create([
        'field_name' => 'field_test',
        'entity_type' => 'entity_test_mul',
        'bundle' => 'entity_test_mul',
    ]);
    $field->save();
    $entities = [];
    $entity = EntityTestMul::create([
        'field_test' => [
            1,
            1,
            1,
        ],
    ]);
    $entity->save();
    $entities[] = $entity;
    $entity = EntityTestMul::create([
        'field_test' => [
            2,
            2,
            2,
        ],
    ]);
    $entity->save();
    $entities[] = $entity;
    $entity = EntityTestMul::create([
        'field_test' => [
            2,
            2,
            2,
        ],
    ]);
    $entity->save();
    $entities[] = $entity;
    $view = Views::getView('test_group_by_count_multicardinality');
    $this->executeView($view);
    $this->assertCount(2, $view->result);
    $this->assertEquals('3', $view->getStyle()
        ->getField(0, 'id'));
    $this->assertEquals('1', $view->getStyle()
        ->getField(0, 'field_test'));
    $this->assertEquals('6', $view->getStyle()
        ->getField(1, 'id'));
    $this->assertEquals('2', $view->getStyle()
        ->getField(1, 'field_test'));
    $entities[2]->field_test[0]->value = 3;
    $entities[2]->field_test[1]->value = 4;
    $entities[2]->field_test[2]->value = 5;
    $entities[2]->save();
    $view = Views::getView('test_group_by_count_multicardinality');
    $this->executeView($view);
    $this->assertCount(5, $view->result);
    $this->assertEquals('3', $view->getStyle()
        ->getField(0, 'id'));
    $this->assertEquals('1', $view->getStyle()
        ->getField(0, 'field_test'));
    $this->assertEquals('3', $view->getStyle()
        ->getField(1, 'id'));
    $this->assertEquals('2', $view->getStyle()
        ->getField(1, 'field_test'));
    $this->assertEquals('1', $view->getStyle()
        ->getField(2, 'id'));
    $this->assertEquals('3', $view->getStyle()
        ->getField(2, 'field_test'));
    $this->assertEquals('1', $view->getStyle()
        ->getField(3, 'id'));
    $this->assertEquals('4', $view->getStyle()
        ->getField(3, 'field_test'));
    $this->assertEquals('1', $view->getStyle()
        ->getField(4, 'id'));
    $this->assertEquals('5', $view->getStyle()
        ->getField(4, 'field_test'));
    // Check that translated values are correctly retrieved and are not grouped
    // into the original entity.
    $translation = $entity->addTranslation('it');
    $translation->field_test = [
        6,
        6,
        6,
    ];
    $translation->save();
    $view = Views::getView('test_group_by_count_multicardinality');
    $this->executeView($view);
    $this->assertCount(6, $view->result);
    $this->assertEquals('3', $view->getStyle()
        ->getField(5, 'id'));
    $this->assertEquals('6', $view->getStyle()
        ->getField(5, 'field_test'));
}