FilterCombineTest.php

<?php

namespace Drupal\Tests\views\Kernel\Handler;

use Drupal\Tests\views\Kernel\ViewsKernelTestBase;
use Drupal\views\Views;

/**
 * Tests the combine filter handler.
 *
 * @group views
 */
class FilterCombineTest extends ViewsKernelTestBase {
    
    /**
     * {@inheritdoc}
     */
    public static $modules = [
        'entity_test',
    ];
    
    /**
     * Views used by this test.
     *
     * @var array
     */
    public static $testViews = [
        'test_view',
        'entity_test_fields',
    ];
    
    /**
     * Map column names.
     *
     * @var array
     */
    protected $columnMap = [
        'views_test_data_name' => 'name',
        'views_test_data_job' => 'job',
    ];
    
    /**
     * {@inheritdoc}
     */
    protected function setUp($import_test_views = TRUE) {
        parent::setUp($import_test_views);
        $this->installEntitySchema('entity_test');
    }
    public function testFilterCombineContains() {
        $view = Views::getView('test_view');
        $view->setDisplay();
        $fields = $view->displayHandlers
            ->get('default')
            ->getOption('fields');
        $view->displayHandlers
            ->get('default')
            ->overrideOption('fields', $fields + [
            'job' => [
                'id' => 'job',
                'table' => 'views_test_data',
                'field' => 'job',
                'relationship' => 'none',
            ],
        ]);
        // Change the filtering.
        $view->displayHandlers
            ->get('default')
            ->overrideOption('filters', [
            'age' => [
                'id' => 'combine',
                'table' => 'views',
                'field' => 'combine',
                'relationship' => 'none',
                'operator' => 'contains',
                'fields' => [
                    'name',
                    'job',
                ],
                'value' => 'ing',
            ],
        ]);
        $this->executeView($view);
        $resultset = [
            [
                'name' => 'John',
                'job' => 'Singer',
            ],
            [
                'name' => 'George',
                'job' => 'Singer',
            ],
            [
                'name' => 'Ringo',
                'job' => 'Drummer',
            ],
            [
                'name' => 'Ginger',
                'job' => NULL,
            ],
        ];
        $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
    }
    
    /**
     * Tests the Combine field filter with the 'word' operator.
     */
    public function testFilterCombineWord() {
        $view = Views::getView('test_view');
        $view->setDisplay();
        $fields = $view->displayHandlers
            ->get('default')
            ->getOption('fields');
        $view->displayHandlers
            ->get('default')
            ->overrideOption('fields', $fields + [
            'job' => [
                'id' => 'job',
                'table' => 'views_test_data',
                'field' => 'job',
                'relationship' => 'none',
            ],
        ]);
        // Change the filtering.
        $view->displayHandlers
            ->get('default')
            ->overrideOption('filters', [
            'age' => [
                'id' => 'combine',
                'table' => 'views',
                'field' => 'combine',
                'relationship' => 'none',
                'operator' => 'word',
                'fields' => [
                    'name',
                    'job',
                ],
                'value' => 'singer ringo',
            ],
        ]);
        $this->executeView($view);
        $resultset = [
            [
                'name' => 'John',
                'job' => 'Singer',
            ],
            [
                'name' => 'George',
                'job' => 'Singer',
            ],
            [
                'name' => 'Ringo',
                'job' => 'Drummer',
            ],
        ];
        $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
    }
    
    /**
     * Tests the Combine field filter with the 'allwords' operator.
     */
    public function testFilterCombineAllWords() {
        $view = Views::getView('test_view');
        $view->setDisplay();
        $fields = $view->displayHandlers
            ->get('default')
            ->getOption('fields');
        $view->displayHandlers
            ->get('default')
            ->overrideOption('fields', $fields + [
            'job' => [
                'id' => 'job',
                'table' => 'views_test_data',
                'field' => 'job',
                'relationship' => 'none',
            ],
        ]);
        // Set the filtering to allwords and simulate searching for a phrase.
        $view->displayHandlers
            ->get('default')
            ->overrideOption('filters', [
            'age' => [
                'id' => 'combine',
                'table' => 'views',
                'field' => 'combine',
                'relationship' => 'none',
                'operator' => 'allwords',
                'fields' => [
                    'name',
                    'job',
                    'age',
                ],
                'value' => '25 "john   singer"',
            ],
        ]);
        $this->executeView($view);
        $resultset = [
            [
                'name' => 'John',
                'job' => 'Singer',
            ],
        ];
        $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
        // Confirm that the query with multiple filters used the "CONCAT_WS"
        // operator.
        $this->assertStringContainsString('CONCAT_WS(', $view->query
            ->query());
    }
    
    /**
     * Tests if the filter can handle removed fields.
     *
     * Tests the combined filter handler when a field overwrite is done
     * and fields set in the combine filter are removed from the display
     * but not from the combined filter settings.
     */
    public function testFilterCombineContainsFieldsOverwritten() {
        $view = Views::getView('test_view');
        $view->setDisplay();
        $fields = $view->displayHandlers
            ->get('default')
            ->getOption('fields');
        $view->displayHandlers
            ->get('default')
            ->overrideOption('fields', $fields + [
            'job' => [
                'id' => 'job',
                'table' => 'views_test_data',
                'field' => 'job',
                'relationship' => 'none',
            ],
        ]);
        // Change the filtering.
        $view->displayHandlers
            ->get('default')
            ->overrideOption('filters', [
            'age' => [
                'id' => 'combine',
                'table' => 'views',
                'field' => 'combine',
                'relationship' => 'none',
                'operator' => 'contains',
                'fields' => [
                    'name',
                    'job',
                    // Add a dummy field to the combined fields to simulate
                    // a removed or deleted field.
'dummy',
                ],
                'value' => 'ing',
            ],
        ]);
        $this->executeView($view);
        // Make sure this view will not get displayed.
        $this->assertTrue($view->build_info['fail'], "View build has been marked as failed.");
        // Make sure this view does not pass validation with the right error.
        $errors = $view->validate();
        $this->assertEquals(t('Field %field set in %filter is not set in display %display.', [
            '%field' => 'dummy',
            '%filter' => 'Global: Combine fields filter',
            '%display' => 'Master',
        ]), reset($errors['default']));
    }
    
    /**
     * Tests that the combine field filter is not valid on displays that don't use
     * fields.
     */
    public function testNonFieldsRow() {
        $view = Views::getView('entity_test_fields');
        $view->setDisplay();
        // Set the rows to a plugin type that doesn't support fields.
        $view->displayHandlers
            ->get('default')
            ->overrideOption('row', [
            'type' => 'entity:entity_test',
            'options' => [
                'view_mode' => 'teaser',
            ],
        ]);
        // Change the filtering.
        $view->displayHandlers
            ->get('default')
            ->overrideOption('filters', [
            'name' => [
                'id' => 'combine',
                'table' => 'views',
                'field' => 'combine',
                'relationship' => 'none',
                'operator' => 'contains',
                'fields' => [
                    'name',
                ],
                'value' => 'ing',
            ],
        ]);
        $this->executeView($view);
        $errors = $view->validate();
        // Check that the right error is shown.
        $this->assertEquals(t('%display: %filter can only be used on displays that use fields. Set the style or row format for that display to one using fields to use the combine field filter.', [
            '%filter' => 'Global: Combine fields filter',
            '%display' => 'Master',
        ]), reset($errors['default']));
        // Confirm that the query with single filter does not use the "CONCAT_WS"
        // operator.
        $this->assertStringNotContainsString('CONCAT_WS(', $view->query
            ->query());
    }
    
    /**
     * Additional data to test the NULL issue.
     */
    protected function dataSet() {
        $data_set = parent::dataSet();
        $data_set[] = [
            'name' => 'Ginger',
            'age' => 25,
            'job' => NULL,
            'created' => gmmktime(0, 0, 0, 1, 2, 2000),
            'status' => 1,
        ];
        return $data_set;
    }
    
    /**
     * Allow {views_test_data}.job to be NULL.
     *
     * @internal
     */
    protected function schemaDefinition() {
        $schema = parent::schemaDefinition();
        unset($schema['views_test_data']['fields']['job']['not null']);
        return $schema;
    }

}