public function testSetWhereNot() { $fieldDescriptors = ['title_id' => new DoctrineFieldDescriptor('id', 'title_id', self::$entityName), 'desc_id' => new DoctrineFieldDescriptor('id', 'desc_id', self::$entityName)]; $filter = ['title_id' => 3, 'desc_id' => 1]; foreach ($filter as $key => $value) { $this->doctrineListBuilder->addField($fieldDescriptors[$key]); $this->doctrineListBuilder->whereNot($fieldDescriptors[$key], $value); } $this->assertCount(2, PHPUnit_Framework_Assert::readAttribute($this->doctrineListBuilder, 'whereNotValues')); $whereNotValues = PHPUnit_Framework_Assert::readAttribute($this->doctrineListBuilder, 'whereNotValues'); $this->assertEquals(3, $whereNotValues['title_id']); $this->assertEquals(1, $whereNotValues['desc_id']); $this->assertCount(2, PHPUnit_Framework_Assert::readAttribute($this->doctrineListBuilder, 'whereNotFields')); $whereNotFields = PHPUnit_Framework_Assert::readAttribute($this->doctrineListBuilder, 'whereNotFields'); $this->assertEquals($fieldDescriptors['title_id'], $whereNotFields['title_id']); $this->assertEquals($fieldDescriptors['desc_id'], $whereNotFields['desc_id']); $this->doctrineListBuilder->execute(); }
/** * Applies the filter parameter and hasNoparent parameter for listbuilder. * * @param Request $request * @param array $filter * @param DoctrineListBuilder $listBuilder */ protected function applyRequestParameters(Request $request, $filter, $listBuilder) { if (json_decode($request->get('hasNoParent', null))) { $listBuilder->where($this->getFieldDescriptorForNoParent(), null); } if (json_decode($request->get('hasEmail', null))) { $listBuilder->whereNot($this->getFieldDescriptors()['mainEmail'], null); } foreach ($filter as $key => $value) { if (is_array($value)) { $listBuilder->in($this->getFieldDescriptors()[$key], $value); } else { $listBuilder->where($this->getFieldDescriptors()[$key], $value); } } }