public function testEventFilters() { $inputData = array('where' => array('field' => 1, 'field2' => 2, 'field3' => array('field3' => 3, 'field4' => 4), 'field3a' => array(3, 4), 'and' => array('field2' => 123, 'field3' => 321, 'Lt' => array('field5' => array('asd', 1, 2, 3), 'field6' => 1, 'field7' => 8), 'Gt' => array('field8' => array('asd', 1, 2, 3), 'field9' => 3, 'field10' => 'ololo')), 'or' => array('field2' => 00, 'field3' => 111, 'Gt' => array('field8' => array('asd', 1, 2, 3), 'field9' => 3, 'field10' => 'ololo'), 'nEq' => array('field11' => array('asd', 1, 2, 3), 'field12' => 'asd'), 'like' => array('field14' => 'OlOlo')), 'some_piece_of_shit' => array('field4' => 123)), 'limit' => 100520, 'skip' => 45, 'order' => array('field100' => 'AsC', 'field200' => 'DeSc', 'field300' => 'ololo'), 'some_crap' => array('asd' => array('dsfkjldflkjdf' => 1133), 'qwe' => 1133, 'zzzz' => 'dlcvlkj')); $eventDispatcher = new EventDispatcher(); $eventDispatcher->addListener(GroupEvent::EVENT_NAME, function (GroupEvent $event) { if ($event->getGroupName() === FilterCondition::CONDITION_AND) { throw new InvalidConditionException(); } }); $eventDispatcher->addListener(LimitEvent::EVENT_NAME, function (LimitEvent $event) { $event->getLimitBuilder()->setLimit(12345); }); $eventDispatcher->addListener(OffsetEvent::EVENT_NAME, function (OffsetEvent $event) { $event->getOffsetBuilder()->setOffset(54321); }); $eventDispatcher->addListener(OrderEvent::EVENT_NAME, function (OrderEvent $event) { if ($event->getField() === 'field100') { throw new InvalidConditionException(); } }); $eventDispatcher->addListener(FieldEvent::EVENT_NAME, function (FieldEvent $event) { if (!in_array($event->getField(), array('field200', 'field3', 'field15'))) { throw new InvalidConditionException(); } }); $eventDispatcher->addListener(ConditionEvent::EVENT_NAME, function (ConditionEvent $event) { $condition = $event->getCondition(); if ($condition->getOperator() === FilterCondition::CONDITION_LIKE) { $value = mb_strtolower($condition->getValue()); $condition->setValue($value); } }); $builder = new Builder($eventDispatcher); $builder->build($inputData); $this->assertCount(1, $builder->getFilters()); $filters = $builder->getFilters(); $this->assertEquals('or', $filters[0]->getGroup()); /* @var $expected ConditionInterface[] */ $expected = array(FilterConditionBuilder::create('eq', 'field3', 111, $eventDispatcher), FilterConditionBuilder::create('like', 'field15', 'ololo', $eventDispatcher)); foreach ($filters[0]->getConditions() as $key => $condition) { $this->assertEquals($expected[$key]->getValue(), $condition->getValue()); $this->assertEquals($expected[$key]->getField(), $condition->getField()); $this->assertEquals($expected[$key]->getOperator(), $condition->getOperator()); } $this->assertEquals(12345, $builder->getLimit()); $this->assertEquals(54321, $builder->getOffset()); $this->assertEquals(array(new Order('field200', 'desc')), $builder->getOrders()); }
public function testComplex() { $inputData = ['where' => ['field' => 1, 'field2' => 2, 'field3' => ['field3' => 3, 'field4' => 4], 'field3a' => [3, 4], 'and' => ['field2' => 123, 'field3' => 321, 'field5' => ['Lt' => ['asd', 1, 2, 3]], 'field6' => ['Lt' => 1], 'field7' => ['Lt' => 8], 'field8' => ['Gt' => ['asd', 1, 2, 3]], 'field9' => ['Gt' => 3], 'field10' => ['Gt' => 'ololo']], 'or' => ['field2' => 00, 'field3' => 111, 'field8' => ['Gt' => ['asd', 1, 2, 3]], 'field9' => ['Gt' => 3], 'field10' => ['Gt' => 'ololo'], 'field11' => ['nEq' => ['asd', 1, 2, 3]], 'field12' => ['nEq' => 'asd']], 'like' => ['field15' => 'ololo', 'field16' => 'pewpew'], 'some_piece_of_shit' => ['field4' => 123]], 'limit' => 100520, 'skip' => 45, 'order' => ['field100' => 'AsC', 'field200' => 'DeSc', 'field300' => 'ololo'], 'some_crap' => ['asd' => ['dsfkjldflkjdf' => 1133], 'qwe' => 1133, 'zzzz' => 'dlcvlkj']]; $builder = new Builder(); $builder->build($inputData); $this->assertEquals(45, $builder->getOffset()); $this->assertEquals(100520, $builder->getLimit()); $expectOrders = [new Order('field100', 'asc'), new Order('field200', 'desc')]; $this->assertEquals($expectOrders, $builder->getOrders()); /* @var $expectFilters FilterGroupConditionBuilder[] */ $expectFilters = [FilterGroupConditionBuilder::create('and', ['field' => 1]), FilterGroupConditionBuilder::create('and', ['field2' => 2]), FilterGroupConditionBuilder::create('and', ['field3a' => [3, 4]]), FilterGroupConditionBuilder::create('and', ['field2' => 123, 'field3' => 321, 'field6' => ['lt' => 1], 'field7' => ['lt' => 8], 'field9' => ['gt' => 3]]), FilterGroupConditionBuilder::create('or', ['field2' => 00, 'field3' => 111, 'field9' => ['gt' => 3], 'field11' => ['neq' => ['asd', 1, 2, 3]], 'field12' => ['neq' => 'asd']]), FilterGroupConditionBuilder::create('and', ['field15' => ['like' => 'ololo'], 'field16' => ['like' => 'pewpew']])]; foreach ($builder->getFilters() as $key => $builder) { $this->assertEquals($expectFilters[$key]->getGroup(), $builder->getGroup()); $this->assertEquals($expectFilters[$key]->getConditions(), $builder->getConditions()); } }