/**
* @param int $calendarId
*
* @return array
*/
public function getItems($calendarId)
{
$selectItems = [];
$intCasts = [];
$metadata = $this->getMetadata();
$fields = $this->getFields();
foreach ($fields as $fieldName => $fieldType) {
$underlyingFieldType = $this->fieldTypeHelper->getUnderlyingType($fieldType);
if ($this->fieldTypeHelper->isRelation($underlyingFieldType)) {
$selectItems[] = sprintf('IDENTITY(o.%1$s) AS %1$s', $fieldName);
if ($metadata->hasAssociation($fieldName)) {
$assocType = $this->doctrineHelper->getSingleEntityIdentifierFieldType($metadata->getAssociationTargetClass($fieldName), false);
if ($assocType === 'integer') {
$intCasts[] = $fieldName;
}
}
} else {
$selectItems[] = 'o.' . $fieldName;
}
}
$repo = $this->doctrineHelper->getEntityRepository(self::CALENDAR_PROPERTY_CLASS);
$qb = $repo->createQueryBuilder('o')->select(implode(',', $selectItems))->where('o.targetCalendar = :calendar_id')->setParameter('calendar_id', $calendarId)->orderBy('o.id');
$result = $qb->getQuery()->getArrayResult();
// normalize integer foreign keys due Doctrine IDENTITY function always returns a string
if ($intCasts) {
foreach ($result as &$item) {
foreach ($intCasts as $fieldName) {
if (isset($item[$fieldName]) && is_string($item[$fieldName])) {
$item[$fieldName] = (int) $item[$fieldName];
}
}
}
}
return $result;
}
/**
* @expectedException \Oro\Bundle\EntityBundle\Exception\InvalidEntityException
* @expectedExceptionMessage Can't get single identifier field type for "ItemStubProxy" entity.
*/
public function testGetSingleEntityIdentifierFieldTypeEmptyIdentifier()
{
$identifiers = [];
$entity = new ItemStubProxy();
$class = 'ItemStubProxy';
$this->classMetadata->expects($this->once())->method('getIdentifierFieldNames')->will($this->returnValue(array_keys($identifiers)));
$this->em->expects($this->once())->method('getClassMetadata')->with($class)->will($this->returnValue($this->classMetadata));
$this->registry->expects($this->once())->method('getManagerForClass')->with($class)->will($this->returnValue($this->em));
$this->classMetadata->expects($this->never())->method('getTypeOfField');
$this->doctrineHelper->getSingleEntityIdentifierFieldType($entity);
}
