View source  
  <?php
namespace Drupal\Tests\field\Kernel\EntityReference\Views;
use Drupal\entity_test\Entity\EntityTestMulChanged;
use Drupal\field\Entity\FieldStorageConfig;
use Drupal\entity_test\Entity\EntityTest;
use Drupal\entity_test\Entity\EntityTestMul;
use Drupal\Tests\field\Traits\EntityReferenceTestTrait;
use Drupal\Tests\views\Kernel\ViewsKernelTestBase;
use Drupal\views\Tests\ViewTestData;
use Drupal\views\Views;
class EntityReferenceRelationshipTest extends ViewsKernelTestBase {
  use EntityReferenceTestTrait;
  
  public static $testViews = [
    'test_entity_reference_entity_test_view',
    'test_entity_reference_entity_test_view_long',
    'test_entity_reference_reverse_entity_test_view',
    'test_entity_reference_entity_test_mul_view',
    'test_entity_reference_reverse_entity_test_mul_view',
    'test_entity_reference_group_by_empty_relationships',
  ];
  
  protected static $modules = [
    'user',
    'field',
    'entity_test',
    'views',
    'entity_reference_test_views',
  ];
  
  protected $entities = [];
  
  protected function setUp($import_test_views = TRUE) : void {
    parent::setUp();
    $this
      ->installEntitySchema('user');
    $this
      ->installEntitySchema('user_role');
    $this
      ->installEntitySchema('entity_test');
    $this
      ->installEntitySchema('entity_test_mul');
    $this
      ->installEntitySchema('entity_test_mul_changed');
    
    $this
      ->createEntityReferenceField('entity_test', 'entity_test', 'field_test_data', 'field_test_data', 'entity_test_mul');
    
    $this
      ->createEntityReferenceField('entity_test_mul', 'entity_test_mul', 'field_data_test', 'field_data_test', 'entity_test');
    
    $this
      ->createEntityReferenceField('entity_test_mul_changed', 'entity_test_mul_changed', 'field_test_data_with_a_long_name', 'field_test_data_with_a_long_name', 'entity_test');
    
    $this
      ->createEntityReferenceField('entity_test_mul', 'entity_test_mul', 'field_data_test_unlimited', 'field_data_test_unlimited', 'entity_test', 'default', [], FieldStorageConfig::CARDINALITY_UNLIMITED);
    ViewTestData::createTestViews(static::class, [
      'entity_reference_test_views',
    ]);
  }
  
  public function testNoDataTableRelationship() {
    
    $referenced_entity = EntityTestMul::create();
    $referenced_entity
      ->save();
    $entity = EntityTest::create();
    $entity->field_test_data->target_id = $referenced_entity
      ->id();
    $entity
      ->save();
    $this
      ->assertEquals($referenced_entity
      ->id(), $entity->field_test_data[0]->entity
      ->id());
    $this->entities[] = $entity;
    $entity = EntityTest::create();
    $entity->field_test_data->target_id = $referenced_entity
      ->id();
    $entity
      ->save();
    $this
      ->assertEquals($referenced_entity
      ->id(), $entity->field_test_data[0]->entity
      ->id());
    $this->entities[] = $entity;
    Views::viewsData()
      ->clear();
    
    $views_data = Views::viewsData()
      ->get('entity_test__field_test_data');
    $this
      ->assertEquals('standard', $views_data['field_test_data']['relationship']['id']);
    $this
      ->assertEquals('entity_test_mul_property_data', $views_data['field_test_data']['relationship']['base']);
    $this
      ->assertEquals('id', $views_data['field_test_data']['relationship']['base field']);
    $this
      ->assertEquals('field_test_data_target_id', $views_data['field_test_data']['relationship']['relationship field']);
    $this
      ->assertEquals('entity_test_mul', $views_data['field_test_data']['relationship']['entity type']);
    
    $views_data = Views::viewsData()
      ->get('entity_test_mul_property_data');
    $this
      ->assertEquals('entity_reverse', $views_data['reverse__entity_test__field_test_data']['relationship']['id']);
    $this
      ->assertEquals('entity_test', $views_data['reverse__entity_test__field_test_data']['relationship']['base']);
    $this
      ->assertEquals('id', $views_data['reverse__entity_test__field_test_data']['relationship']['base field']);
    $this
      ->assertEquals('entity_test__field_test_data', $views_data['reverse__entity_test__field_test_data']['relationship']['field table']);
    $this
      ->assertEquals('field_test_data_target_id', $views_data['reverse__entity_test__field_test_data']['relationship']['field field']);
    $this
      ->assertEquals('field_test_data', $views_data['reverse__entity_test__field_test_data']['relationship']['field_name']);
    $this
      ->assertEquals('entity_test', $views_data['reverse__entity_test__field_test_data']['relationship']['entity_type']);
    $this
      ->assertEquals([
      'field' => 'deleted',
      'value' => 0,
      'numeric' => TRUE,
    ], $views_data['reverse__entity_test__field_test_data']['relationship']['join_extra'][0]);
    
    $view = Views::getView('test_entity_reference_entity_test_view');
    $this
      ->executeView($view);
    
    foreach ($view->result as $index => $row) {
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->id);
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->_entity
        ->id());
      
      $this
        ->assertEquals(1, $row->entity_test_mul_property_data_entity_test__field_test_data_i);
      
      $this
        ->assertEquals(1, $row->_relationship_entities['field_test_data']
        ->id());
      $this
        ->assertEquals('entity_test_mul', $row->_relationship_entities['field_test_data']
        ->bundle());
    }
    
    $view = Views::getView('test_entity_reference_reverse_entity_test_view');
    $this
      ->executeView($view);
    
    foreach ($view->result as $index => $row) {
      $this
        ->assertEquals(1, $row->id);
      $this
        ->assertEquals(1, $row->_entity
        ->id());
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->field_test_data_entity_test_mul_property_data_id);
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->_relationship_entities['reverse__entity_test__field_test_data']
        ->id());
      $this
        ->assertEquals('entity_test', $row->_relationship_entities['reverse__entity_test__field_test_data']
        ->bundle());
    }
  }
  
  public function testDataTableRelationship() {
    
    $referenced_entity = EntityTest::create();
    $referenced_entity
      ->save();
    $entity = EntityTestMul::create();
    $entity->field_data_test->target_id = $referenced_entity
      ->id();
    $entity
      ->save();
    $this
      ->assertEquals($referenced_entity
      ->id(), $entity->field_data_test[0]->entity
      ->id());
    $this->entities[] = $entity;
    $entity = EntityTestMul::create();
    $entity->field_data_test->target_id = $referenced_entity
      ->id();
    $entity
      ->save();
    $this
      ->assertEquals($referenced_entity
      ->id(), $entity->field_data_test[0]->entity
      ->id());
    $this->entities[] = $entity;
    Views::viewsData()
      ->clear();
    
    $views_data = Views::viewsData()
      ->get('entity_test_mul__field_data_test');
    $this
      ->assertEquals('standard', $views_data['field_data_test']['relationship']['id']);
    $this
      ->assertEquals('entity_test', $views_data['field_data_test']['relationship']['base']);
    $this
      ->assertEquals('id', $views_data['field_data_test']['relationship']['base field']);
    $this
      ->assertEquals('field_data_test_target_id', $views_data['field_data_test']['relationship']['relationship field']);
    $this
      ->assertEquals('entity_test', $views_data['field_data_test']['relationship']['entity type']);
    
    $views_data = Views::viewsData()
      ->get('entity_test');
    $this
      ->assertEquals('entity_reverse', $views_data['reverse__entity_test_mul__field_data_test']['relationship']['id']);
    $this
      ->assertEquals('entity_test_mul_property_data', $views_data['reverse__entity_test_mul__field_data_test']['relationship']['base']);
    $this
      ->assertEquals('id', $views_data['reverse__entity_test_mul__field_data_test']['relationship']['base field']);
    $this
      ->assertEquals('entity_test_mul__field_data_test', $views_data['reverse__entity_test_mul__field_data_test']['relationship']['field table']);
    $this
      ->assertEquals('field_data_test_target_id', $views_data['reverse__entity_test_mul__field_data_test']['relationship']['field field']);
    $this
      ->assertEquals('field_data_test', $views_data['reverse__entity_test_mul__field_data_test']['relationship']['field_name']);
    $this
      ->assertEquals('entity_test_mul', $views_data['reverse__entity_test_mul__field_data_test']['relationship']['entity_type']);
    $this
      ->assertEquals([
      'field' => 'deleted',
      'value' => 0,
      'numeric' => TRUE,
    ], $views_data['reverse__entity_test_mul__field_data_test']['relationship']['join_extra'][0]);
    
    $view = Views::getView('test_entity_reference_entity_test_mul_view');
    $this
      ->executeView($view);
    
    foreach ($view->result as $index => $row) {
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->id);
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->_entity
        ->id());
      
      $this
        ->assertEquals(1, $row->entity_test_entity_test_mul__field_data_test_id);
      
      $this
        ->assertEquals(1, $row->_relationship_entities['field_data_test']
        ->id());
      $this
        ->assertEquals('entity_test', $row->_relationship_entities['field_data_test']
        ->bundle());
    }
    
    $view = Views::getView('test_entity_reference_reverse_entity_test_mul_view');
    $this
      ->executeView($view);
    
    foreach ($view->result as $index => $row) {
      $this
        ->assertEquals(1, $row->id);
      $this
        ->assertEquals(1, $row->_entity
        ->id());
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->field_data_test_entity_test_id);
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->_relationship_entities['reverse__entity_test_mul__field_data_test']
        ->id());
      $this
        ->assertEquals('entity_test_mul', $row->_relationship_entities['reverse__entity_test_mul__field_data_test']
        ->bundle());
    }
  }
  
  public function testDataTableRelationshipWithLongFieldName() {
    
    $referenced_entity = EntityTest::create();
    $referenced_entity
      ->save();
    $entity = EntityTestMulChanged::create();
    $entity->field_test_data_with_a_long_name->target_id = $referenced_entity
      ->id();
    $entity
      ->save();
    $this->entities[] = $entity;
    $entity = EntityTestMulChanged::create();
    $entity->field_test_data_with_a_long_name->target_id = $referenced_entity
      ->id();
    $entity
      ->save();
    $this->entities[] = $entity;
    Views::viewsData()
      ->clear();
    
    $view = Views::getView('test_entity_reference_entity_test_view_long');
    $this
      ->executeView($view);
    
    foreach ($view->result as $index => $row) {
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->id);
      
      $this
        ->assertEquals($this->entities[$index]
        ->id(), $row->_entity
        ->id());
      
      $this
        ->assertEquals(1, $row->_relationship_entities['field_test_data_with_a_long_name']
        ->id());
      $this
        ->assertEquals('entity_test', $row->_relationship_entities['field_test_data_with_a_long_name']
        ->bundle());
    }
  }
  
  public function testGroupByWithEmptyRelationships() {
    $entities = [];
    
    for ($i = 1; $i <= 4; $i++) {
      $entity = [
        'name' => 'name' . $i,
      ];
      $entity = EntityTest::create($entity);
      $entities[] = $entity;
      $entity
        ->save();
    }
    $entity = EntityTestMul::create([
      'name' => 'name1',
    ]);
    $entity->field_data_test_unlimited = [
      [
        'target_id' => $entities[0]
          ->id(),
      ],
      [
        'target_id' => $entities[1]
          ->id(),
      ],
      [
        'target_id' => $entities[2]
          ->id(),
      ],
    ];
    $entity
      ->save();
    $entity = EntityTestMul::create([
      'name' => 'name2',
    ]);
    $entity->field_data_test_unlimited = [
      [
        'target_id' => $entities[0]
          ->id(),
      ],
      [
        'target_id' => $entities[1]
          ->id(),
      ],
    ];
    $entity
      ->save();
    $entity = EntityTestMul::create([
      'name' => 'name3',
    ]);
    $entity->field_data_test_unlimited->target_id = $entities[0]
      ->id();
    $entity
      ->save();
    $view = Views::getView('test_entity_reference_group_by_empty_relationships');
    $this
      ->executeView($view);
    $this
      ->assertCount(4, $view->result);
    
    $this
      ->assertNotEmpty($view
      ->getStyle()
      ->getField(0, 'name_2'));
    $this
      ->assertNotEmpty($view
      ->getStyle()
      ->getField(1, 'name_2'));
    $this
      ->assertNotEmpty($view
      ->getStyle()
      ->getField(2, 'name_2'));
    
    $this
      ->assertEquals('', $view
      ->getStyle()
      ->getField(3, 'name_2'));
    $fields = $view->field;
    
    $this
      ->assertEquals('name1', $fields['name_2']
      ->getValue($view->result[0]));
    $this
      ->assertEquals('name1', $fields['name_2']
      ->getValue($view->result[1]));
    $this
      ->assertEquals('name1', $fields['name_2']
      ->getValue($view->result[2]));
    
    $this
      ->assertNull($fields['name_2']
      ->getValue($view->result[3]));
  }
  
  public function testEntityReferenceConfigEntity() {
    
    $this
      ->createEntityReferenceField('entity_test', 'entity_test', 'field_test_config_entity', 'field_test_config_entity', 'user_role');
    Views::viewsData()
      ->clear();
    $views_data = Views::viewsData()
      ->getAll();
    
    $this
      ->assertTrue(isset($views_data['entity_test__field_test_data']['field_test_data']['relationship']));
    $this
      ->assertFalse(isset($views_data['entity_test__field_test_config_entity']['field_test_config_entity']['relationship']));
  }
}