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);
292 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
297 // Change the filtering
298 $view->displayHandlers->get('default')->overrideOption('filters', [
301 'table' => 'views_test_data',
303 'relationship' => 'none',
304 'operator' => 'not empty',
308 $this->executeView($view);
327 'name' => 'Meredith',
331 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
334 public function testFilterNumericExposedGroupedEmpty() {
335 $filters = $this->getGroupedExposedFilters();
336 $view = Views::getView('test_view');
337 $view->newDisplay('page', 'Page', 'page_1');
339 // Filter: Age, Operator: empty, Value:
340 $filters['age']['group_info']['default_group'] = 4;
341 $view->setDisplay('page_1');
342 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
344 $this->container->get('router.builder')->rebuild();
346 $this->executeView($view);
348 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
351 public function testFilterNumericExposedGroupedNotEmpty() {
352 $filters = $this->getGroupedExposedFilters();
353 $view = Views::getView('test_view');
354 $view->newDisplay('page', 'Page', 'page_1');
356 // Filter: Age, Operator: empty, Value:
357 $filters['age']['group_info']['default_group'] = 5;
358 $view->setDisplay('page_1');
359 $view->displayHandlers->get('page_1')->overrideOption('filters', $filters);
361 $this->container->get('router.builder')->rebuild();
363 $this->executeView($view);
382 'name' => 'Meredith',
386 $this->assertIdenticalResultset($view, $resultset, $this->columnMap);
389 public function testAllowEmpty() {
390 $view = Views::getView('test_view');
393 $view->displayHandlers->get('default')->overrideOption('filters', [
396 'table' => 'views_test_data',
398 'relationship' => 'none',
402 'table' => 'views_test_data',
404 'relationship' => 'none',
408 $view->initHandlers();
410 $id_operators = $view->filter['id']->operators();
411 $age_operators = $view->filter['age']->operators();
413 $this->assertFalse(isset($id_operators['empty']));
414 $this->assertFalse(isset($id_operators['not empty']));
415 $this->assertTrue(isset($age_operators['empty']));
416 $this->assertTrue(isset($age_operators['not empty']));
419 protected function getGroupedExposedFilters() {
423 'plugin_id' => 'numeric',
424 'table' => 'views_test_data',
426 'relationship' => 'none',
429 'operator' => 'age_op',
431 'identifier' => 'age',
433 'is_grouped' => TRUE,
436 'identifier' => 'age',
437 'default_group' => 'All',
440 'title' => 'Age is 28',
442 'value' => ['value' => 28],
445 'title' => 'Age is between 26 and 29',
446 'operator' => 'between',
453 'title' => 'Age is not between 26 and 29',
454 'operator' => 'not between',
461 'title' => 'Age is empty',
462 'operator' => 'empty',
465 'title' => 'Age is not empty',
466 'operator' => 'not empty',
469 'title' => 'Age is regexp 2[7-8]',
470 'operator' => 'regular_expression',