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);
}
}
}
