DataMapper.php

Go to the documentation of this file.

<?php
 
/*
 * This file is part of the TYPO3 CMS project.
 *
 * It is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License, either version 2
 * of the License, or any later version.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 * The TYPO3 project - inspiring people to share!
 */
 
namespace ‪TYPO3\CMS\Extbase\Persistence\Generic\Mapper;
 
use Psr\EventDispatcher\EventDispatcherInterface;
use ‪TYPO3\CMS\Core\Context\Context;
use ‪TYPO3\CMS\Core\Database\Query\QueryHelper;
use ‪TYPO3\CMS\Core\Database\RelationHandler;
use ‪TYPO3\CMS\Core\Utility\GeneralUtility;
use ‪TYPO3\CMS\Extbase\DomainObject\DomainObjectInterface;
use ‪TYPO3\CMS\Extbase\Event\Persistence\AfterObjectThawedEvent;
use ‪TYPO3\CMS\Extbase\Object\Exception\CannotReconstituteObjectException;
use ‪TYPO3\CMS\Extbase\Object\ObjectManagerInterface;
use ‪TYPO3\CMS\Extbase\Persistence;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Exception;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Exception\UnexpectedTypeException;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\LazyLoadingProxy;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\LazyObjectStorage;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\LoadingStrategyInterface;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Mapper\Exception\NonExistentPropertyException;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Mapper\Exception\UnknownPropertyTypeException;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Qom\QueryObjectModelFactory;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Query;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\QueryFactoryInterface;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Session;
use ‪TYPO3\CMS\Extbase\Persistence\ObjectStorage;
use ‪TYPO3\CMS\Extbase\Persistence\QueryInterface;
use ‪TYPO3\CMS\Extbase\Persistence\QueryResultInterface;
use ‪TYPO3\CMS\Extbase\Reflection\ClassSchema;
use ‪TYPO3\CMS\Extbase\Reflection\ClassSchema\Exception\NoSuchPropertyException;
use ‪TYPO3\CMS\Extbase\Reflection\ReflectionService;
use ‪TYPO3\CMS\Extbase\Utility\TypeHandlingUtility;
 
class ‪DataMapper
{
    protected ‪$reflectionService;
 
    protected ‪$qomFactory;
 
    protected ‪$persistenceSession;
 
    protected ‪$dataMapFactory;
 
    protected ‪$queryFactory;
 
    protected ‪$objectManager;
 
    protected ‪$eventDispatcher;
 
    protected ‪$query;
 
    public function ‪__construct(
        ‪ReflectionService ‪$reflectionService,
        ‪QueryObjectModelFactory ‪$qomFactory,
        ‪Session ‪$persistenceSession,
        ‪DataMapFactory ‪$dataMapFactory,
        ‪QueryFactoryInterface ‪$queryFactory,
        ‪ObjectManagerInterface ‪$objectManager,
        EventDispatcherInterface ‪$eventDispatcher,
        ?‪QueryInterface ‪$query = null
    ) {
        $this->query = ‪$query;
        $this->reflectionService = ‪$reflectionService;
        $this->qomFactory = ‪$qomFactory;
        $this->persistenceSession = ‪$persistenceSession;
        $this->dataMapFactory = ‪$dataMapFactory;
        $this->queryFactory = ‪$queryFactory;
        $this->objectManager = ‪$objectManager;
        $this->eventDispatcher = ‪$eventDispatcher;
 
        if (‪$query !== null) {
            trigger_error(
                'Constructor argument $query will be removed in TYPO3 v11.0, use setQuery method instead.',
                E_USER_DEPRECATED
            );
            $this->query = ‪$query;
        }
    }
 
    public function ‪setQuery(‪QueryInterface ‪$query): void
    {
        $this->query = ‪$query;
    }
 
    public function ‪map($className, array $rows)
    {
        $objects = [];
        foreach ($rows as $row) {
            $objects[] = $this->‪mapSingleRow($this->‪getTargetType($className, $row), $row);
        }
        return $objects;
    }
 
    public function ‪getTargetType($className, array $row)
    {
        $dataMap = $this->‪getDataMap($className);
        $targetType = $className;
        if ($dataMap->getRecordTypeColumnName() !== null) {
            foreach ($dataMap->getSubclasses() as $subclassName) {
                $recordSubtype = $this->‪getDataMap($subclassName)->‪getRecordType();
                if ((string)$row[$dataMap->getRecordTypeColumnName()] === (string)$recordSubtype) {
                    $targetType = $subclassName;
                    break;
                }
            }
        }
        return $targetType;
    }
 
    protected function ‪mapSingleRow($className, array $row)
    {
        if ($this->persistenceSession->hasIdentifier($row['uid'], $className)) {
            $object = $this->persistenceSession->getObjectByIdentifier($row['uid'], $className);
        } else {
            $object = $this->‪createEmptyObject($className);
            $this->persistenceSession->registerObject($object, $row['uid']);
            $this->‪thawProperties($object, $row);
            $event = new ‪AfterObjectThawedEvent($object, $row);
            $this->eventDispatcher->dispatch($event);
            $object->_memorizeCleanState();
            $this->persistenceSession->registerReconstitutedEntity($object);
        }
        return $object;
    }
 
    protected function ‪createEmptyObject($className)
    {
        // Note: The class_implements() function also invokes autoload to assure that the interfaces
        // and the class are loaded. Would end up with __PHP_Incomplete_Class without it.
        if (!in_array(DomainObjectInterface::class, class_implements($className))) {
            throw new ‪CannotReconstituteObjectException('Cannot create empty instance of the class "' . $className
                . '" because it does not implement the TYPO3\\CMS\\Extbase\\DomainObject\\DomainObjectInterface.', 1234386924);
        }
        $object = $this->objectManager->getEmptyObject($className);
        return $object;
    }
 
    protected function ‪thawProperties(‪DomainObjectInterface $object, array $row)
    {
        $className = get_class($object);
        $classSchema = $this->reflectionService->getClassSchema($className);
        $dataMap = $this->‪getDataMap($className);
        $object->‪_setProperty('uid', (int)$row['uid']);
        $object->‪_setProperty('pid', (int)($row['pid'] ?? 0));
        $object->‪_setProperty('_localizedUid', (int)$row['uid']);
        $object->‪_setProperty('_versionedUid', (int)$row['uid']);
        if ($dataMap->getLanguageIdColumnName() !== null) {
            $object->‪_setProperty('_languageUid', (int)$row[$dataMap->getLanguageIdColumnName()]);
            if (isset($row['_LOCALIZED_UID'])) {
                $object->‪_setProperty('_localizedUid', (int)$row['_LOCALIZED_UID']);
            }
        }
        if (!empty($row['_ORIG_uid']) && !empty(‪$GLOBALS['TCA'][$dataMap->getTableName()]['ctrl']['versioningWS'])) {
            $object->‪_setProperty('_versionedUid', (int)$row['_ORIG_uid']);
        }
        $properties = $object->‪_getProperties();
        foreach ($properties as $propertyName => $propertyValue) {
            if (!$dataMap->isPersistableProperty($propertyName)) {
                continue;
            }
            $columnMap = $dataMap->getColumnMap($propertyName);
            $columnName = $columnMap->getColumnName();
 
            try {
                $property = $classSchema->getProperty($propertyName);
            } catch (NoSuchPropertyException $e) {
                throw new NonExistentPropertyException(
                    'The type of property ' . $className . '::' . $propertyName . ' could not be identified, ' .
                    'as property ' . $propertyName . ' is unknown to the ' . ClassSchema::class . ' instance of class ' .
                    $className . '. Please make sure said property exists and that you cleared all caches to trigger ' .
                    'a new build of said ' . ClassSchema::class . ' instance.',
                    1580056272
                );
            }
 
            $propertyType = $property->getType();
            if ($propertyType === null) {
                throw new UnknownPropertyTypeException(
                    'The type of property ' . $className . '::' . $propertyName . ' could not be identified, therefore the desired value (' .
                    var_export($propertyValue, true) . ') cannot be mapped onto it. The type of a class property is usually defined via php doc blocks. ' .
                    'Make sure the property has a valid @var tag set which defines the type.',
                    1579965021
                );
            }
            $propertyValue = null;
            if (isset($row[$columnName])) {
                switch ($propertyType) {
                    case 'int':
                    case 'integer':
                        $propertyValue = (int)$row[$columnName];
                        break;
                    case 'float':
                        $propertyValue = (double)$row[$columnName];
                        break;
                    case 'bool':
                    case 'boolean':
                        $propertyValue = (bool)$row[$columnName];
                        break;
                    case 'string':
                        $propertyValue = (string)$row[$columnName];
                        break;
                    case 'array':
                        // $propertyValue = $this->mapArray($row[$columnName]); // Not supported, yet!
                        break;
                    case \SplObjectStorage::class:
                    case ObjectStorage::class:
                        $propertyValue = $this->‪mapResultToPropertyValue(
                            $object,
                            $propertyName,
                            $this->‪fetchRelated($object, $propertyName, $row[$columnName])
                        );
                        break;
                    default:
                        if (is_subclass_of($propertyType, \DateTimeInterface::class)) {
                            $propertyValue = $this->‪mapDateTime(
                                $row[$columnName],
                                $columnMap->getDateTimeStorageFormat(),
                                $propertyType
                            );
                        } elseif (‪TypeHandlingUtility::isCoreType($propertyType)) {
                            $propertyValue = $this->‪mapCoreType($propertyType, $row[$columnName]);
                        } else {
                            $propertyValue = $this->‪mapObjectToClassProperty(
                                $object,
                                $propertyName,
                                $row[$columnName]
                            );
                        }
 
                }
            }
            if ($propertyValue !== null) {
                $object->‪_setProperty($propertyName, $propertyValue);
            }
        }
    }
 
    protected function ‪mapCoreType($type, $value)
    {
        return new $type($value);
    }
 
    protected function ‪mapDateTime($value, $storageFormat = null, $targetType = \DateTime::class)
    {
        $dateTimeTypes = ‪QueryHelper::getDateTimeTypes();
 
        if (empty($value) || $value === '0000-00-00' || $value === '0000-00-00 00:00:00' || $value === '00:00:00') {
            // 0 -> NULL !!!
            return null;
        }
        if (in_array($storageFormat, $dateTimeTypes, true)) {
            // native date/datetime/time values are stored in UTC
            $utcTimeZone = new \DateTimeZone('UTC');
            $utcDateTime = GeneralUtility::makeInstance($targetType, $value, $utcTimeZone);
            $currentTimeZone = new \DateTimeZone(date_default_timezone_get());
            return $utcDateTime->setTimezone($currentTimeZone);
        }
        // integer timestamps are local server time
        return GeneralUtility::makeInstance($targetType, date('c', (int)$value));
    }
 
    public function ‪fetchRelated(DomainObjectInterface $parentObject, $propertyName, $fieldValue = '', $enableLazyLoading = true)
    {
        $property = $this->reflectionService->getClassSchema(get_class($parentObject))->getProperty($propertyName);
        if ($enableLazyLoading === true && $property->isLazy()) {
            if ($property->getType() === ObjectStorage::class) {
                $result = $this->objectManager->get(LazyObjectStorage::class, $parentObject, $propertyName, $fieldValue, $this);
            } else {
                if (empty($fieldValue)) {
                    $result = null;
                } else {
                    $result = $this->objectManager->get(LazyLoadingProxy::class, $parentObject, $propertyName, $fieldValue, $this);
                }
            }
        } else {
            $result = $this->‪fetchRelatedEager($parentObject, $propertyName, $fieldValue);
        }
        return $result;
    }
 
    protected function ‪fetchRelatedEager(DomainObjectInterface $parentObject, $propertyName, $fieldValue = '')
    {
        return $fieldValue === '' ? $this->‪getEmptyRelationValue($parentObject, $propertyName) : $this->‪getNonEmptyRelationValue($parentObject, $propertyName, $fieldValue);
    }
 
    protected function ‪getEmptyRelationValue(‪DomainObjectInterface $parentObject, $propertyName)
    {
        $columnMap = $this->‪getDataMap(get_class($parentObject))->‪getColumnMap($propertyName);
        $relatesToOne = $columnMap->‪getTypeOfRelation() == ‪ColumnMap::RELATION_HAS_ONE;
        return $relatesToOne ? null : [];
    }
 
    protected function ‪getNonEmptyRelationValue(‪DomainObjectInterface $parentObject, $propertyName, $fieldValue)
    {
        ‪$query = $this->‪getPreparedQuery($parentObject, $propertyName, $fieldValue);
        return ‪$query->‪execute();
    }
 
    protected function ‪getPreparedQuery(‪DomainObjectInterface $parentObject, $propertyName, $fieldValue = '')
    {
        $dataMap = $this->‪getDataMap(get_class($parentObject));
        $columnMap = $dataMap->getColumnMap($propertyName);
        $type = $this->‪getType(get_class($parentObject), $propertyName);
        ‪$query = $this->queryFactory->create($type);
        if ($this->query && ‪$query instanceof ‪Query) {
            ‪$query->setParentQuery($this->query);
        }
        ‪$query->‪getQuerySettings()->‪setRespectStoragePage(false);
        ‪$query->‪getQuerySettings()->‪setRespectSysLanguage(false);
 
        // we always want to overlay relations as most of the time they are stored in db using default lang uids
        ‪$query->‪getQuerySettings()->‪setLanguageOverlayMode(true);
        if ($this->query) {
            ‪$query->‪getQuerySettings()->‪setLanguageUid($this->query->getQuerySettings()->getLanguageUid());
 
            if ($dataMap->getLanguageIdColumnName() !== null && !$this->query->getQuerySettings()->getRespectSysLanguage()) {
                //pass language of parent record to child objects, so they can be overlaid correctly in case
                //e.g. findByUid is used.
                //the languageUid is used for getRecordOverlay later on, despite RespectSysLanguage being false
                $languageUid = (int)$parentObject->‪_getProperty('_languageUid');
                ‪$query->‪getQuerySettings()->‪setLanguageUid($languageUid);
            }
        }
 
        if ($columnMap->getTypeOfRelation() === ‪ColumnMap::RELATION_HAS_MANY) {
            if ($columnMap->getChildSortByFieldName() !== null) {
                ‪$query->‪setOrderings([$columnMap->getChildSortByFieldName() => ‪QueryInterface::ORDER_ASCENDING]);
            }
        } elseif ($columnMap->getTypeOfRelation() === ‪ColumnMap::RELATION_HAS_AND_BELONGS_TO_MANY) {
            ‪$query->‪setSource($this->‪getSource($parentObject, $propertyName));
            if ($columnMap->getChildSortByFieldName() !== null) {
                ‪$query->‪setOrderings([$columnMap->getChildSortByFieldName() => ‪QueryInterface::ORDER_ASCENDING]);
            }
        }
        ‪$query->‪matching($this->‪getConstraint(‪$query, $parentObject, $propertyName, $fieldValue, (array)$columnMap->getRelationTableMatchFields()));
        return ‪$query;
    }
 
    protected function ‪getConstraint(QueryInterface ‪$query, DomainObjectInterface $parentObject, $propertyName, $fieldValue = '', $relationTableMatchFields = [])
    {
        $dataMap = $this->‪getDataMap(get_class($parentObject));
        $columnMap = $dataMap->getColumnMap($propertyName);
        $workspaceId = GeneralUtility::makeInstance(Context::class)->getPropertyFromAspect('workspace', 'id');
        if ($columnMap && $workspaceId > 0) {
            $resolvedRelationIds = $this->‪resolveRelationValuesOfField($dataMap, $columnMap, $parentObject, $fieldValue, $workspaceId);
        } else {
            $resolvedRelationIds = [];
        }
        // Work with the UIDs directly in a workspace
        if (!empty($resolvedRelationIds)) {
            if (‪$query->‪getSource() instanceof Persistence\Generic\Qom\JoinInterface) {
                $constraint = ‪$query->‪in(‪$query->‪getSource()->getJoinCondition()->getProperty1Name(), $resolvedRelationIds);
                // When querying MM relations directly, Typo3DbQueryParser uses enableFields and thus, filters
                // out versioned records by default. However, we directly query versioned UIDs here, so we want
                // to include the versioned records explicitly.
                if ($columnMap->getTypeOfRelation() === ‪ColumnMap::RELATION_HAS_AND_BELONGS_TO_MANY) {
                    ‪$query->‪getQuerySettings()->‪setEnableFieldsToBeIgnored(['pid']);
                    ‪$query->‪getQuerySettings()->‪setIgnoreEnableFields(true);
                }
            } else {
                $constraint = ‪$query->‪in('uid', $resolvedRelationIds);
            }
            if ($columnMap->getParentTableFieldName() !== null) {
                $constraint = ‪$query->‪logicalAnd(
                    $constraint,
                    ‪$query->‪equals($columnMap->getParentTableFieldName(), $dataMap->getTableName())
                );
            }
        } elseif ($columnMap->getParentKeyFieldName() !== null) {
            $value = $parentObject;
            // If this a MM relation, and MM relations do not know about workspaces, the MM relations always point to the
            // versioned record, so this must be taken into account here and the versioned record's UID must be used.
            if ($columnMap->getTypeOfRelation() === ‪ColumnMap::RELATION_HAS_AND_BELONGS_TO_MANY) {
                // The versioned UID is used ideally the version ID of a translated record, so this takes precedence over the localized UID
                if ($value->_hasProperty('_versionedUid') && $value->_getProperty('_versionedUid') > 0 && $value->_getProperty('_versionedUid') !== $value->getUid()) {
                    $value = (int)$value->_getProperty('_versionedUid');
                }
            }
            $constraint = ‪$query->‪equals($columnMap->getParentKeyFieldName(), $value);
            if ($columnMap->getParentTableFieldName() !== null) {
                $constraint = ‪$query->‪logicalAnd(
                    $constraint,
                    ‪$query->‪equals($columnMap->getParentTableFieldName(), $dataMap->getTableName())
                );
            }
        } else {
            $constraint = ‪$query->‪in('uid', ‪GeneralUtility::intExplode(',', $fieldValue));
        }
        if (!empty($relationTableMatchFields)) {
            foreach ($relationTableMatchFields as $relationTableMatchFieldName => $relationTableMatchFieldValue) {
                $constraint = ‪$query->‪logicalAnd($constraint, ‪$query->‪equals($relationTableMatchFieldName, $relationTableMatchFieldValue));
            }
        }
        return $constraint;
    }
 
    protected function ‪resolveRelationValuesOfField(DataMap $dataMap, ColumnMap $columnMap, DomainObjectInterface $parentObject, $fieldValue, int $workspaceId)
    {
        $parentId = $parentObject->getUid();
        // versionedUid in a multi-language setup is the overlaid versioned AND translated ID
        if ($parentObject->_hasProperty('_versionedUid') && $parentObject->_getProperty('_versionedUid') > 0 && $parentObject->_getProperty('_versionedUid') !== $parentId) {
            $parentId = $parentObject->_getProperty('_versionedUid');
        } elseif ($parentObject->_hasProperty('_languageUid') && $parentObject->_getProperty('_languageUid') > 0) {
            $parentId = $parentObject->_getProperty('_localizedUid');
        }
        $relationHandler = GeneralUtility::makeInstance(RelationHandler::class);
        $relationHandler->setWorkspaceId($workspaceId);
        $relationHandler->setUseLiveReferenceIds(true);
        $relationHandler->setUseLiveParentIds(true);
        $tableName = $dataMap->getTableName();
        $fieldName = $columnMap->getColumnName();
        $fieldConfiguration = ‪$GLOBALS['TCA'][$tableName]['columns'][$fieldName]['config'] ?? null;
        if (!is_array($fieldConfiguration)) {
            return [];
        }
        $relationHandler->start(
            $fieldValue,
            $fieldConfiguration['allowed'] ?? $fieldConfiguration['foreign_table'] ?? '',
            $fieldConfiguration['MM'] ?? '',
            $parentId,
            $tableName,
            $fieldConfiguration
        );
        $relationHandler->processDeletePlaceholder();
        $relatedUids = [];
        if (!empty($relationHandler->tableArray)) {
            $relatedUids = reset($relationHandler->tableArray);
        }
        return $relatedUids;
    }
 
    protected function ‪getSource(‪DomainObjectInterface $parentObject, $propertyName)
    {
        $columnMap = $this->‪getDataMap(get_class($parentObject))->‪getColumnMap($propertyName);
        $left = $this->qomFactory->selector(null, $columnMap->getRelationTableName());
        $childClassName = $this->‪getType(get_class($parentObject), $propertyName);
        $right = $this->qomFactory->selector($childClassName, $columnMap->getChildTableName());
        $joinCondition = $this->qomFactory->equiJoinCondition($columnMap->getRelationTableName(), $columnMap->getChildKeyFieldName(), $columnMap->getChildTableName(), 'uid');
        $source = $this->qomFactory->join($left, $right, ‪Query::JCR_JOIN_TYPE_INNER, $joinCondition);
        return $source;
    }
 
    protected function ‪mapObjectToClassProperty(‪DomainObjectInterface $parentObject, $propertyName, $fieldValue)
    {
        if ($this->‪propertyMapsByForeignKey($parentObject, $propertyName)) {
            $result = $this->‪fetchRelated($parentObject, $propertyName, $fieldValue);
            $propertyValue = $this->‪mapResultToPropertyValue($parentObject, $propertyName, $result);
        } else {
            if ($fieldValue === '') {
                $propertyValue = $this->‪getEmptyRelationValue($parentObject, $propertyName);
            } else {
                $property = $this->reflectionService->getClassSchema(get_class($parentObject))->getProperty($propertyName);
                if ($this->persistenceSession->hasIdentifier($fieldValue, $property->getType())) {
                    $propertyValue = $this->persistenceSession->getObjectByIdentifier($fieldValue, $property->getType());
                } else {
                    $result = $this->‪fetchRelated($parentObject, $propertyName, $fieldValue);
                    $propertyValue = $this->‪mapResultToPropertyValue($parentObject, $propertyName, $result);
                }
            }
        }
 
        return $propertyValue;
    }
 
    protected function ‪propertyMapsByForeignKey(‪DomainObjectInterface $parentObject, $propertyName)
    {
        $columnMap = $this->‪getDataMap(get_class($parentObject))->‪getColumnMap($propertyName);
        return $columnMap->‪getParentKeyFieldName() !== null;
    }
 
    public function ‪mapResultToPropertyValue(‪DomainObjectInterface $parentObject, $propertyName, $result)
    {
        $propertyValue = null;
        if ($result instanceof ‪LoadingStrategyInterface) {
            $propertyValue = $result;
        } else {
            $property = $this->reflectionService->getClassSchema(get_class($parentObject))->getProperty($propertyName);
            if (in_array($property->getType(), ['array', \ArrayObject::class, \SplObjectStorage::class, ObjectStorage::class], true)) {
                $objects = [];
                foreach ($result as $value) {
                    $objects[] = $value;
                }
                if ($property->getType() === \ArrayObject::class) {
                    $propertyValue = new \ArrayObject($objects);
                } elseif ($property->getType() === ObjectStorage::class) {
                    $propertyValue = new ObjectStorage();
                    foreach ($objects as $object) {
                        $propertyValue->attach($object);
                    }
                    $propertyValue->_memorizeCleanState();
                } else {
                    $propertyValue = $objects;
                }
            } elseif (strpbrk((string)$property->getType(), '_\\') !== false) {
                // @todo: check the strpbrk function call. Seems to be a check for Tx_Foo_Bar style class names
                if (is_object($result) && $result instanceof QueryResultInterface) {
                    $propertyValue = $result->getFirst();
                } else {
                    $propertyValue = $result;
                }
            }
        }
        return $propertyValue;
    }
 
    public function ‪countRelated(DomainObjectInterface $parentObject, $propertyName, $fieldValue = '')
    {
        ‪$query = $this->‪getPreparedQuery($parentObject, $propertyName, $fieldValue);
        return ‪$query->‪execute()->count();
    }
 
    public function ‪isPersistableProperty($className, $propertyName)
    {
        $dataMap = $this->‪getDataMap($className);
        return $dataMap->isPersistableProperty($propertyName);
    }
 
    public function ‪getDataMap($className)
    {
        if (!is_string($className) || $className === '') {
            throw new ‪Exception('No class name was given to retrieve the Data Map for.', 1251315965);
        }
        return $this->dataMapFactory->buildDataMap($className);
    }
 
    public function ‪convertClassNameToTableName($className)
    {
        return $this->‪getDataMap($className)->‪getTableName();
    }
 
    public function ‪convertPropertyNameToColumnName($propertyName, $className = null)
    {
        if (!empty($className)) {
            $dataMap = $this->‪getDataMap($className);
            if ($dataMap !== null) {
                $columnMap = $dataMap->getColumnMap($propertyName);
                if ($columnMap !== null) {
                    return $columnMap->getColumnName();
                }
            }
        }
        return ‪GeneralUtility::camelCaseToLowerCaseUnderscored($propertyName);
    }
 
    public function ‪getType($parentClassName, $propertyName)
    {
        try {
            $property = $this->reflectionService->getClassSchema($parentClassName)->getProperty($propertyName);
 
            if ($property->getElementType() !== null) {
                return $property->getElementType();
            }
 
            if ($property->getType() !== null) {
                return $property->getType();
            }
        } catch (NoSuchPropertyException $e) {
        }
 
        throw new UnexpectedTypeException('Could not determine the child object type.', 1251315967);
    }
 
    public function ‪getPlainValue($input, $columnMap = null)
    {
        if ($input === null) {
            return 'NULL';
        }
        if ($input instanceof LazyLoadingProxy) {
            $input = $input->_loadRealInstance();
        }
 
        if (is_bool($input)) {
            $parameter = (int)$input;
        } elseif (is_int($input)) {
            $parameter = $input;
        } elseif ($input instanceof \DateTimeInterface) {
            if ($columnMap !== null && $columnMap->getDateTimeStorageFormat() !== null) {
                $storageFormat = $columnMap->getDateTimeStorageFormat();
                $timeZoneToStore = clone $input;
                // set to UTC to store in database
                $timeZoneToStore->setTimezone(new \DateTimeZone('UTC'));
                switch ($storageFormat) {
                    case 'datetime':
                        $parameter = $timeZoneToStore->format('Y-m-d H:i:s');
                        break;
                    case 'date':
                        $parameter = $timeZoneToStore->format('Y-m-d');
                        break;
                    case 'time':
                        $parameter = $timeZoneToStore->format('H:i');
                        break;
                    default:
                        throw new \InvalidArgumentException('Column map DateTime format "' . $storageFormat . '" is unknown. Allowed values are date, datetime or time.', 1395353470);
                }
            } else {
                $parameter = $input->format('U');
            }
        } elseif ($input instanceof DomainObjectInterface) {
            $parameter = (int)$input->getUid();
        } elseif (‪TypeHandlingUtility::isValidTypeForMultiValueComparison($input)) {
            $plainValueArray = [];
            foreach ($input as $inputElement) {
                $plainValueArray[] = $this->‪getPlainValue($inputElement, $columnMap);
            }
            $parameter = implode(',', $plainValueArray);
        } elseif (is_object($input)) {
            if (‪TypeHandlingUtility::isCoreType($input)) {
                $parameter = (string)$input;
            } else {
                throw new UnexpectedTypeException('An object of class "' . get_class($input) . '" could not be converted to a plain value.', 1274799934);
            }
        } else {
            $parameter = (string)$input;
        }
        return $parameter;
    }
}