3 namespace Drupal\Tests\views\Kernel\Handler;
5 use Drupal\Tests\views\Kernel\ViewsKernelTestBase;
6 use Drupal\views\Views;
9 * Tests the numeric filter handler.
13 class FilterNumericTest extends ViewsKernelTestBase {
15 public static $modules = ['system'];
18 * Views used by this test.
22 public static $testViews = ['test_view'];
29 protected $columnMap = [
30 'views_test_data_name' => 'name',
31 'views_test_data_age' => 'age',
34 public function viewsData() {
35 $data = parent::viewsData();
36 $data['views_test_data']['age']['filter']['allow empty'] = TRUE;
37 $data['views_test_data']['id']['filter']['allow empty'] = FALSE;
42 public function testFilterNumericSimple() {
43 $view = Views::getView('test_view');
46 // Change the filtering
47 $view->displayHandlers->get('default')->overrideOption('filters', [
50 'table' => 'views_test_data',
52 'relationship' => 'none',
54 'value' => ['value' => 28],
58 $this->executeView($view);
65 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
68 public function testFilterNumericExposedGroupedSimple() {
69 $filters = $this->getGroupedExposedFilters();
70 $view = Views::getView('test_view');
71 $view->newDisplay('page', 'Page', 'page_1');
73 // Filter: Age, Operator: =, Value: 28
74 $filters['age']['group_info']['default_group'] = 1;
75 $view->setDisplay('page_1');
76 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
78 $this->container->get('router.builder')->rebuild();
80 $this->executeView($view);
87 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
90 public function testFilterNumericBetween() {
91 $view = Views::getView('test_view');
94 // Change the filtering
95 $view->displayHandlers->get('default')->overrideOption('filters', [
98 'table' => 'views_test_data',
100 'relationship' => 'none',
101 'operator' => 'between',
109 $this->executeView($view);
124 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
130 // Change the filtering
131 $view->displayHandlers->get('default')->overrideOption('filters', [
134 'table' => 'views_test_data',
136 'relationship' => 'none',
137 'operator' => 'not between',
145 $this->executeView($view);
152 'name' => 'Meredith',
156 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
159 public function testFilterNumericExposedGroupedBetween() {
160 $filters = $this->getGroupedExposedFilters();
161 $view = Views::getView('test_view');
162 $view->newDisplay('page', 'Page', 'page_1');
164 // Filter: Age, Operator: between, Value: 26 and 29
165 $filters['age']['group_info']['default_group'] = 2;
166 $view->setDisplay('page_1');
167 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
169 $this->container->get('router.builder')->rebuild();
171 $this->executeView($view);
186 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
189 public function testFilterNumericExposedGroupedNotBetween() {
190 $filters = $this->getGroupedExposedFilters();
191 $view = Views::getView('test_view');
192 $view->newDisplay('page', 'Page', 'page_1');
194 // Filter: Age, Operator: between, Value: 26 and 29
195 $filters['age']['group_info']['default_group'] = 3;
196 $view->setDisplay('page_1');
197 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
199 $this->container->get('router.builder')->rebuild();
201 $this->executeView($view);
208 'name' => 'Meredith',
212 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
216 * Tests the numeric filter handler with the 'regular_expression' operator.
218 public function testFilterNumericRegularExpression() {
219 $view = Views::getView('test_view');
222 // Filtering by regular expression pattern.
223 $view->displayHandlers->get('default')->overrideOption('filters', [
226 'table' => 'views_test_data',
228 'relationship' => 'none',
229 'operator' => 'regular_expression',
236 $this->executeView($view);
243 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
247 * Tests the numeric filter handler with the 'regular_expression' operator
248 * to grouped exposed filters.
250 public function testFilterNumericExposedGroupedRegularExpression() {
251 $filters = $this->getGroupedExposedFilters();
252 $view = Views::getView('test_view');
253 $view->newDisplay('page', 'Page', 'page_1');
255 // Filter: Age, Operator: regular_expression, Value: 2[7-8]
256 $filters['age']['group_info']['default_group'] = 6;
257 $view->setDisplay('page_1');
258 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
261 $this->executeView($view);
272 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
275 public function testFilterNumericEmpty() {
276 $view = Views::getView('test_view');
279 // Change the filtering
280 $view->displayHandlers->get('default')->overrideOption('filters', [
283 'table' => 'views_test_data',
285 'relationship' => 'none',
286 'operator' => 'empty',
290 $this->executeView($view);
293 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
298 // Change the filtering
299 $view->displayHandlers->get('default')->overrideOption('filters', [
302 'table' => 'views_test_data',
304 'relationship' => 'none',
305 'operator' => 'not empty',
309 $this->executeView($view);
328 'name' => 'Meredith',
332 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
335 public function testFilterNumericExposedGroupedEmpty() {
336 $filters = $this->getGroupedExposedFilters();
337 $view = Views::getView('test_view');
338 $view->newDisplay('page', 'Page', 'page_1');
340 // Filter: Age, Operator: empty, Value:
341 $filters['age']['group_info']['default_group'] = 4;
342 $view->setDisplay('page_1');
343 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
345 $this->container->get('router.builder')->rebuild();
347 $this->executeView($view);
350 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
353 public function testFilterNumericExposedGroupedNotEmpty() {
354 $filters = $this->getGroupedExposedFilters();
355 $view = Views::getView('test_view');
356 $view->newDisplay('page', 'Page', 'page_1');
358 // Filter: Age, Operator: empty, Value:
359 $filters['age']['group_info']['default_group'] = 5;
360 $view->setDisplay('page_1');
361 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
363 $this->container->get('router.builder')->rebuild();
365 $this->executeView($view);
384 'name' => 'Meredith',
388 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
391 public function testAllowEmpty() {
392 $view = Views::getView('test_view');
395 $view->displayHandlers->get('default')->overrideOption('filters', [
398 'table' => 'views_test_data',
400 'relationship' => 'none',
404 'table' => 'views_test_data',
406 'relationship' => 'none',
410 $view->initHandlers();
412 $id_operators = $view->filter['id']->operators();
413 $age_operators = $view->filter['age']->operators();
415 $this->assertFalse(isset($id_operators['empty']));
416 $this->assertFalse(isset($id_operators['not empty']));
417 $this->assertTrue(isset($age_operators['empty']));
418 $this->assertTrue(isset($age_operators['not empty']));
421 protected function getGroupedExposedFilters() {
425 'plugin_id' => 'numeric',
426 'table' => 'views_test_data',
428 'relationship' => 'none',
431 'operator' => 'age_op',
433 'identifier' => 'age',
435 'is_grouped' => TRUE,
438 'identifier' => 'age',
439 'default_group' => 'All',
442 'title' => 'Age is 28',
444 'value' => ['value' => 28],
447 'title' => 'Age is between 26 and 29',
448 'operator' => 'between',
455 'title' => 'Age is not between 26 and 29',
456 'operator' => 'not between',
463 'title' => 'Age is empty',
464 'operator' => 'empty',
467 'title' => 'Age is not empty',
468 'operator' => 'not empty',
471 'title' => 'Age is regexp 2[7-8]',
472 'operator' => 'regular_expression',