Typo3DbQueryParser.php

Go to the documentation of this file.

<?php
namespace ‪TYPO3\CMS\Extbase\Persistence\Generic\Storage;
 
/*
 * 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!
 */
 
use ‪TYPO3\CMS\Backend\Utility\BackendUtility;
use ‪TYPO3\CMS\Core\Database\Connection;
use ‪TYPO3\CMS\Core\Database\ConnectionPool;
use ‪TYPO3\CMS\Core\Database\Query\Expression\CompositeExpression;
use ‪TYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilder;
use ‪TYPO3\CMS\Core\Database\Query\QueryBuilder;
use ‪TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction;
use ‪TYPO3\CMS\Core\Utility\GeneralUtility;
use ‪TYPO3\CMS\Extbase\Configuration\ConfigurationManagerInterface;
use ‪TYPO3\CMS\Extbase\DomainObject\AbstractDomainObject;
use ‪TYPO3\CMS\Extbase\Object\ObjectManagerInterface;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Exception;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Exception\InconsistentQuerySettingsException;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Exception\InvalidRelationConfigurationException;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Exception\MissingColumnMapException;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Exception\RepositoryException;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Exception\UnsupportedOrderException;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Mapper\ColumnMap;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Mapper\DataMapper;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Qom;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\QuerySettingsInterface;
use ‪TYPO3\CMS\Extbase\Persistence\Generic\Storage\Exception\BadConstraintException;
use ‪TYPO3\CMS\Extbase\Persistence\QueryInterface;
use ‪TYPO3\CMS\Extbase\Service\EnvironmentService;
use ‪TYPO3\CMS\Frontend\Page\PageRepository;
 
class ‪Typo3DbQueryParser
{
    protected ‪$dataMapper;
 
    protected ‪$pageRepository;
 
    protected ‪$environmentService;
 
    protected ‪$configurationManager;
 
    protected ‪$queryBuilder;
 
    protected ‪$tablePropertyMap = [];
 
    protected ‪$tableAliasMap = [];
 
    protected ‪$unionTableAliasCache = [];
 
    protected ‪$tableName = '';
 
    protected ‪$suggestDistinctQuery = false;
 
    protected ‪$objectManager;
 
    public function ‪injectObjectManager(‪ObjectManagerInterface ‪$objectManager)
    {
        $this->objectManager = ‪$objectManager;
    }
 
    public function ‪initializeObject()
    {
        $this->dataMapper = $this->objectManager->get(DataMapper::class);
    }
 
    public function ‪injectEnvironmentService(‪EnvironmentService ‪$environmentService)
    {
        $this->environmentService = ‪$environmentService;
    }
 
    public function ‪injectConfigurationManager(ConfigurationManagerInterface ‪$configurationManager)
    {
        $this->configurationManager = ‪$configurationManager;
    }
 
    public function ‪isDistinctQuerySuggested(): bool
    {
        return ‪$this->suggestDistinctQuery;
    }
 
    public function ‪convertQueryToDoctrineQueryBuilder(‪QueryInterface $query)
    {
        // Reset all properties
        $this->tablePropertyMap = [];
        $this->tableAliasMap = [];
        $this->unionTableAliasCache = [];
        $this->tableName = '';
 
        if ($query->‪getStatement() && $query->‪getStatement()->getStatement() instanceof ‪QueryBuilder) {
            $this->queryBuilder = clone $query->‪getStatement()->getStatement();
            return ‪$this->queryBuilder;
        }
        // Find the right table name
        $source = $query->‪getSource();
        $this->‪initializeQueryBuilder($source);
 
        $constraint = $query->‪getConstraint();
        if ($constraint instanceof Qom\‪ConstraintInterface) {
            $wherePredicates = $this->‪parseConstraint($constraint, $source);
            if (!empty($wherePredicates)) {
                $this->queryBuilder->andWhere($wherePredicates);
            }
        }
 
        $this->‪parseOrderings($query->‪getOrderings(), $source);
        $this->‪addTypo3Constraints($query);
 
        return ‪$this->queryBuilder;
    }
 
    protected function ‪initializeQueryBuilder(Qom\‪SourceInterface $source)
    {
        if ($source instanceof Qom\‪SelectorInterface) {
            $className = $source->getNodeTypeName();
            ‪$tableName = $this->dataMapper->getDataMap($className)->getTableName();
            $this->tableName = ‪$tableName;
 
            $this->queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
                ->getQueryBuilderForTable(‪$tableName);
 
            $this->queryBuilder
                ->getRestrictions()
                ->removeAll();
 
            $tableAlias = $this->‪getUniqueAlias(‪$tableName);
 
            $this->queryBuilder
                ->select($tableAlias . '.*')
                ->from(‪$tableName, $tableAlias);
 
            $this->‪addRecordTypeConstraint($className);
        } elseif ($source instanceof Qom\JoinInterface) {
            $leftSource = $source->getLeft();
            $leftTableName = $leftSource->getSelectorName();
 
            $this->queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
                ->getQueryBuilderForTable($leftTableName);
            $leftTableAlias = $this->‪getUniqueAlias($leftTableName);
            $this->queryBuilder
                ->select($leftTableAlias . '.*')
                ->from($leftTableName, $leftTableAlias);
            $this->‪parseJoin($source, $leftTableAlias);
        }
    }
 
    protected function ‪parseConstraint(Qom\‪ConstraintInterface $constraint, Qom\SourceInterface $source)
    {
        if ($constraint instanceof Qom\‪AndInterface) {
            $constraint1 = $constraint->getConstraint1();
            $constraint2 = $constraint->getConstraint2();
            if (($constraint1 instanceof Qom\‪ConstraintInterface)
                && ($constraint2 instanceof Qom\‪ConstraintInterface)
            ) {
                return $this->queryBuilder->expr()->andX(
                    $this->‪parseConstraint($constraint1, $source),
                    $this->‪parseConstraint($constraint2, $source)
                );
            }
            return '';
        }
        if ($constraint instanceof Qom\OrInterface) {
            $constraint1 = $constraint->getConstraint1();
            $constraint2 = $constraint->getConstraint2();
            if (($constraint1 instanceof Qom\ConstraintInterface)
                && ($constraint2 instanceof Qom\ConstraintInterface)
            ) {
                return $this->queryBuilder->expr()->orX(
                    $this->‪parseConstraint($constraint->getConstraint1(), $source),
                    $this->parseConstraint($constraint->getConstraint2(), $source)
                );
            }
            return '';
        }
        if ($constraint instanceof Qom\NotInterface) {
            return ' NOT(' . $this->‪parseConstraint($constraint->getConstraint(), $source) . ')';
        }
        if ($constraint instanceof Qom\ComparisonInterface) {
            return $this->‪parseComparison($constraint, $source);
        }
        throw new \RuntimeException('not implemented', 1476199898);
    }
 
    protected function ‪parseOrderings(array $orderings, Qom\SourceInterface $source)
    {
        foreach ($orderings as $propertyName => $order) {
            if ($order !== ‪QueryInterface::ORDER_ASCENDING && $order !== ‪QueryInterface::ORDER_DESCENDING) {
                throw new UnsupportedOrderException('Unsupported order encountered.', 1242816074);
            }
            $className = null;
            ‪$tableName = '';
            if ($source instanceof Qom\SelectorInterface) {
                $className = $source->getNodeTypeName();
                ‪$tableName = $this->dataMapper->convertClassNameToTableName($className);
                $fullPropertyPath = '';
                while (strpos($propertyName, '.') !== false) {
                    $this->‪addUnionStatement($className, ‪$tableName, $propertyName, $fullPropertyPath);
                }
            } elseif ($source instanceof Qom\JoinInterface) {
                ‪$tableName = $source->getLeft()->getSelectorName();
            }
            $columnName = $this->dataMapper->convertPropertyNameToColumnName($propertyName, $className);
            if (‪$tableName !== '') {
                $this->queryBuilder->addOrderBy(‪$tableName . '.' . $columnName, $order);
            } else {
                $this->queryBuilder->addOrderBy($columnName, $order);
            }
        }
    }
 
    protected function ‪addTypo3Constraints(QueryInterface $query)
    {
        $index = 0;
        foreach ($this->tableAliasMap as $tableAlias => ‪$tableName) {
            if ($index === 0 || !$this->configurationManager->isFeatureEnabled('consistentTranslationOverlayHandling')) {
                // With the new behaviour enabled, we only add the pid and language check for the first table (aggregate root).
                // We know the first table is always the main table for the current query run.
                $additionalWhereClauses = $this->‪getAdditionalWhereClause($query->getQuerySettings(), ‪$tableName, $tableAlias);
            } else {
                $additionalWhereClauses = [];
            }
            $index++;
            $statement = $this->‪getVisibilityConstraintStatement($query->getQuerySettings(), ‪$tableName, $tableAlias);
            if ($statement !== '') {
                $additionalWhereClauses[] = $statement;
            }
            if (!empty($additionalWhereClauses)) {
                if (in_array($tableAlias, $this->unionTableAliasCache, true)) {
                    $this->queryBuilder->andWhere(
                        $this->queryBuilder->expr()->orX(
                            $this->queryBuilder->expr()->andX(...$additionalWhereClauses),
                            $this->queryBuilder->expr()->isNull($tableAlias . '.uid')
                        )
                    );
                } else {
                    $this->queryBuilder->andWhere(...$additionalWhereClauses);
                }
            }
        }
    }
 
    protected function ‪parseComparison(Qom\‪ComparisonInterface $comparison, Qom\‪SourceInterface $source)
    {
        if ($comparison->getOperator() === ‪QueryInterface::OPERATOR_CONTAINS) {
            if ($comparison->getOperand2() === null) {
                throw new ‪BadConstraintException('The value for the CONTAINS operator must not be null.', 1484828468);
            }
            $value = $this->dataMapper->getPlainValue($comparison->getOperand2());
            if (!$source instanceof Qom\‪SelectorInterface) {
                throw new \RuntimeException('Source is not of type "SelectorInterface"', 1395362539);
            }
            $className = $source->getNodeTypeName();
            ‪$tableName = $this->dataMapper->convertClassNameToTableName($className);
            $operand1 = $comparison->getOperand1();
            $propertyName = $operand1->getPropertyName();
            $fullPropertyPath = '';
            while (strpos($propertyName, '.') !== false) {
                $this->‪addUnionStatement($className, ‪$tableName, $propertyName, $fullPropertyPath);
            }
            $columnName = $this->dataMapper->convertPropertyNameToColumnName($propertyName, $className);
            $dataMap = $this->dataMapper->getDataMap($className);
            $columnMap = $dataMap->getColumnMap($propertyName);
            $typeOfRelation = $columnMap instanceof ‪ColumnMap ? $columnMap->‪getTypeOfRelation() : null;
            if ($typeOfRelation === ‪ColumnMap::RELATION_HAS_AND_BELONGS_TO_MANY) {
                $relationTableName = $columnMap->getRelationTableName();
                $queryBuilderForSubselect = $this->queryBuilder->getConnection()->createQueryBuilder();
                $queryBuilderForSubselect
                        ->select($columnMap->getParentKeyFieldName())
                        ->from($relationTableName)
                        ->where(
                            $queryBuilderForSubselect->expr()->eq(
                                $columnMap->getChildKeyFieldName(),
                                $this->queryBuilder->createNamedParameter($value)
                            )
                        );
                $additionalWhereForMatchFields = $this->‪getAdditionalMatchFieldsStatement($queryBuilderForSubselect->expr(), $columnMap, $relationTableName, $relationTableName);
                if ($additionalWhereForMatchFields) {
                    $queryBuilderForSubselect->andWhere($additionalWhereForMatchFields);
                }
 
                return $this->queryBuilder->expr()->comparison(
                    $this->queryBuilder->quoteIdentifier(‪$tableName . '.uid'),
                    'IN',
                    '(' . $queryBuilderForSubselect->getSQL() . ')'
                );
            }
            if ($typeOfRelation === ‪ColumnMap::RELATION_HAS_MANY) {
                $parentKeyFieldName = $columnMap->getParentKeyFieldName();
                if (isset($parentKeyFieldName)) {
                    $childTableName = $columnMap->getChildTableName();
 
                    // Build the SQL statement of the subselect
                    $queryBuilderForSubselect = $this->queryBuilder->getConnection()->createQueryBuilder();
                    $queryBuilderForSubselect
                            ->select($parentKeyFieldName)
                            ->from($childTableName)
                            ->where(
                                $queryBuilderForSubselect->expr()->eq(
                                    'uid',
                                    (int)$value
                                )
                            );
 
                    // Add it to the main query
                    return $this->queryBuilder->expr()->eq(
                        ‪$tableName . '.uid',
                        '(' . $queryBuilderForSubselect->getSQL() . ')'
                    );
                }
                return $this->queryBuilder->expr()->inSet(
                    ‪$tableName . '.' . $columnName,
                    $this->queryBuilder->quote($value)
                );
            }
            throw new ‪RepositoryException('Unsupported or non-existing property name "' . $propertyName . '" used in relation matching.', 1327065745);
        }
        return $this->‪parseDynamicOperand($comparison, $source);
    }
 
    protected function ‪parseDynamicOperand(Qom\‪ComparisonInterface $comparison, Qom\‪SourceInterface $source)
    {
        $value = $comparison->getOperand2();
        $fieldName = $this->‪parseOperand($comparison->getOperand1(), $source);
        $expr = null;
        $exprBuilder = $this->queryBuilder->expr();
        switch ($comparison->getOperator()) {
            case ‪QueryInterface::OPERATOR_IN:
                $hasValue = false;
                $plainValues = [];
                foreach ($value as $singleValue) {
                    $plainValue = $this->dataMapper->getPlainValue($singleValue);
                    if ($plainValue !== null) {
                        $hasValue = true;
                        $plainValues[] = $this->‪createTypedNamedParameter($singleValue);
                    }
                }
                if (!$hasValue) {
                    throw new ‪BadConstraintException(
                        'The IN operator needs a non-empty value list to compare against. ' .
                        'The given value list is empty.',
                        1484828466
                    );
                }
                $expr = $exprBuilder->comparison($fieldName, 'IN', '(' . implode(', ', $plainValues) . ')');
                break;
            case ‪QueryInterface::OPERATOR_EQUAL_TO:
                if ($value === null) {
                    $expr = $fieldName . ' IS NULL';
                } else {
                    $placeHolder = $this->‪createTypedNamedParameter($value);
                    $expr = $exprBuilder->comparison($fieldName, $exprBuilder::EQ, $placeHolder);
                }
                break;
            case ‪QueryInterface::OPERATOR_EQUAL_TO_NULL:
                $expr = $fieldName . ' IS NULL';
                break;
            case ‪QueryInterface::OPERATOR_NOT_EQUAL_TO:
                if ($value === null) {
                    $expr = $fieldName . ' IS NOT NULL';
                } else {
                    $placeHolder = $this->‪createTypedNamedParameter($value);
                    $expr = $exprBuilder->comparison($fieldName, $exprBuilder::NEQ, $placeHolder);
                }
                break;
            case ‪QueryInterface::OPERATOR_NOT_EQUAL_TO_NULL:
                $expr = $fieldName . ' IS NOT NULL';
                break;
            case ‪QueryInterface::OPERATOR_LESS_THAN:
                $placeHolder = $this->‪createTypedNamedParameter($value);
                $expr = $exprBuilder->comparison($fieldName, $exprBuilder::LT, $placeHolder);
                break;
            case ‪QueryInterface::OPERATOR_LESS_THAN_OR_EQUAL_TO:
                $placeHolder = $this->‪createTypedNamedParameter($value);
                $expr = $exprBuilder->comparison($fieldName, $exprBuilder::LTE, $placeHolder);
                break;
            case ‪QueryInterface::OPERATOR_GREATER_THAN:
                $placeHolder = $this->‪createTypedNamedParameter($value);
                $expr = $exprBuilder->comparison($fieldName, $exprBuilder::GT, $placeHolder);
                break;
            case ‪QueryInterface::OPERATOR_GREATER_THAN_OR_EQUAL_TO:
                $placeHolder = $this->‪createTypedNamedParameter($value);
                $expr = $exprBuilder->comparison($fieldName, $exprBuilder::GTE, $placeHolder);
                break;
            case ‪QueryInterface::OPERATOR_LIKE:
                $placeHolder = $this->‪createTypedNamedParameter($value, \PDO::PARAM_STR);
                $expr = $exprBuilder->comparison($fieldName, 'LIKE', $placeHolder);
                break;
            default:
                throw new ‪Exception(
                    'Unsupported operator encountered.',
                    1242816073
                );
        }
        return $expr;
    }
 
    protected function ‪getParameterType($value): int
    {
        $parameterType = gettype($value);
        switch ($parameterType) {
            case 'integer':
                return \PDO::PARAM_INT;
            case 'string':
                return \PDO::PARAM_STR;
            default:
                throw new \InvalidArgumentException(
                    'Unsupported parameter type encountered. Expected integer or string, ' . $parameterType . ' given.',
                    1494878863
                );
        }
    }
 
    protected function ‪createTypedNamedParameter($value, int $forceType = null): string
    {
        $consistentHandlingEnabled = $this->configurationManager->isFeatureEnabled('consistentTranslationOverlayHandling');
        if ($consistentHandlingEnabled
            && $value instanceof ‪AbstractDomainObject
            && $value->‪_hasProperty('_localizedUid')
            && $value->_getProperty('_localizedUid') > 0
        ) {
            $plainValue = (int)$value->_getProperty('_localizedUid');
        } else {
            $plainValue = $this->dataMapper->getPlainValue($value);
        }
        $parameterType = $forceType ?? $this->‪getParameterType($plainValue);
        $placeholder = $this->queryBuilder->createNamedParameter($plainValue, $parameterType);
 
        return $placeholder;
    }
 
    protected function ‪parseOperand(Qom\‪DynamicOperandInterface $operand, Qom\‪SourceInterface $source)
    {
        if ($operand instanceof Qom\‪LowerCaseInterface) {
            $constraintSQL = 'LOWER(' . $this->‪parseOperand($operand->getOperand(), $source) . ')';
        } elseif ($operand instanceof Qom\UpperCaseInterface) {
            $constraintSQL = 'UPPER(' . $this->‪parseOperand($operand->getOperand(), $source) . ')';
        } elseif ($operand instanceof Qom\PropertyValueInterface) {
            $propertyName = $operand->getPropertyName();
            $className = '';
            if ($source instanceof Qom\SelectorInterface) {
                $className = $source->getNodeTypeName();
                ‪$tableName = $this->dataMapper->convertClassNameToTableName($className);
                $fullPropertyPath = '';
                while (strpos($propertyName, '.') !== false) {
                    $this->‪addUnionStatement($className, ‪$tableName, $propertyName, $fullPropertyPath);
                }
            } elseif ($source instanceof Qom\JoinInterface) {
                ‪$tableName = $source->getJoinCondition()->getSelector1Name();
            }
            $columnName = $this->dataMapper->convertPropertyNameToColumnName($propertyName, $className);
            $constraintSQL = (!empty(‪$tableName) ? ‪$tableName . '.' : '') . $columnName;
            $constraintSQL = $this->queryBuilder->getConnection()->quoteIdentifier($constraintSQL);
        } else {
            throw new \InvalidArgumentException('Given operand has invalid type "' . get_class($operand) . '".', 1395710211);
        }
        return $constraintSQL;
    }
 
    protected function ‪addRecordTypeConstraint($className)
    {
        if ($className !== null) {
            $dataMap = $this->dataMapper->getDataMap($className);
            if ($dataMap->getRecordTypeColumnName() !== null) {
                $recordTypes = [];
                if ($dataMap->getRecordType() !== null) {
                    $recordTypes[] = $dataMap->getRecordType();
                }
                foreach ($dataMap->getSubclasses() as $subclassName) {
                    $subclassDataMap = $this->dataMapper->getDataMap($subclassName);
                    if ($subclassDataMap->getRecordType() !== null) {
                        $recordTypes[] = $subclassDataMap->getRecordType();
                    }
                }
                if (!empty($recordTypes)) {
                    $recordTypeStatements = [];
                    foreach ($recordTypes as $recordType) {
                        ‪$tableName = $dataMap->getTableName();
                        $recordTypeStatements[] = $this->queryBuilder->expr()->eq(
                            ‪$tableName . '.' . $dataMap->getRecordTypeColumnName(),
                            $this->queryBuilder->createNamedParameter($recordType)
                        );
                    }
                    $this->queryBuilder->andWhere(
                        $this->queryBuilder->expr()->orX(...$recordTypeStatements)
                    );
                }
            }
        }
    }
 
    protected function ‪getAdditionalMatchFieldsStatement($exprBuilder, $columnMap, $childTableAlias, $parentTable = null)
    {
        $additionalWhereForMatchFields = [];
        $relationTableMatchFields = $columnMap->getRelationTableMatchFields();
        if (is_array($relationTableMatchFields) && !empty($relationTableMatchFields)) {
            foreach ($relationTableMatchFields as $fieldName => $value) {
                $additionalWhereForMatchFields[] = $exprBuilder->eq($childTableAlias . '.' . $fieldName, $this->queryBuilder->createNamedParameter($value));
            }
        }
 
        if (isset($parentTable)) {
            $parentTableFieldName = $columnMap->getParentTableFieldName();
            if (!empty($parentTableFieldName)) {
                $additionalWhereForMatchFields[] = $exprBuilder->eq($childTableAlias . '.' . $parentTableFieldName, $this->queryBuilder->createNamedParameter($parentTable));
            }
        }
 
        if (!empty($additionalWhereForMatchFields)) {
            return $exprBuilder->andX(...$additionalWhereForMatchFields);
        }
        return '';
    }
 
    protected function ‪getAdditionalWhereClause(‪QuerySettingsInterface $querySettings, ‪$tableName, $tableAlias = null)
    {
        $whereClause = [];
        if ($querySettings->‪getRespectSysLanguage()) {
            if ($this->configurationManager->isFeatureEnabled('consistentTranslationOverlayHandling')) {
                $systemLanguageStatement = $this->‪getLanguageStatement(‪$tableName, $tableAlias, $querySettings);
            } else {
                $systemLanguageStatement = $this->‪getSysLanguageStatement(‪$tableName, $tableAlias, $querySettings);
            }
 
            if (!empty($systemLanguageStatement)) {
                $whereClause[] = $systemLanguageStatement;
            }
        }
 
        if ($querySettings->‪getRespectStoragePage()) {
            $pageIdStatement = $this->‪getPageIdStatement(‪$tableName, $tableAlias, $querySettings->‪getStoragePageIds());
            if (!empty($pageIdStatement)) {
                $whereClause[] = $pageIdStatement;
            }
        }
 
        return $whereClause;
    }
 
    protected function ‪getVisibilityConstraintStatement(‪QuerySettingsInterface $querySettings, ‪$tableName, $tableAlias)
    {
        $statement = '';
        if (is_array(‪$GLOBALS['TCA'][‪$tableName]['ctrl'] ?? null)) {
            $ignoreEnableFields = $querySettings->‪getIgnoreEnableFields();
            $enableFieldsToBeIgnored = $querySettings->‪getEnableFieldsToBeIgnored();
            $includeDeleted = $querySettings->‪getIncludeDeleted();
            if ($this->environmentService->isEnvironmentInFrontendMode()) {
                $statement .= $this->‪getFrontendConstraintStatement($tableName, $ignoreEnableFields, $enableFieldsToBeIgnored, $includeDeleted);
            } else {
                // TYPO3_MODE === 'BE'
                $statement .= $this->‪getBackendConstraintStatement($tableName, $ignoreEnableFields, $includeDeleted);
            }
            if (!empty($statement)) {
                $statement = $this->‪replaceTableNameWithAlias($statement, ‪$tableName, $tableAlias);
                $statement = strtolower(substr($statement, 1, 3)) === 'and' ? substr($statement, 5) : $statement;
            }
        }
        return $statement;
    }
 
    protected function ‪getFrontendConstraintStatement(‪$tableName, $ignoreEnableFields, array $enableFieldsToBeIgnored = [], $includeDeleted)
    {
        $statement = '';
        if ($ignoreEnableFields && !$includeDeleted) {
            if (!empty($enableFieldsToBeIgnored)) {
                // array_combine() is necessary because of the way \TYPO3\CMS\Frontend\Page\PageRepository::enableFields() is implemented
                $statement .= $this->‪getPageRepository()->‪enableFields(‪$tableName, -1, array_combine($enableFieldsToBeIgnored, $enableFieldsToBeIgnored));
            } elseif (!empty(‪$GLOBALS['TCA'][‪$tableName]['ctrl']['delete'])) {
                $statement .= ' AND ' . ‪$tableName . '.' . ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['delete'] . '=0';
            }
        } elseif (!$ignoreEnableFields && !$includeDeleted) {
            $statement .= $this->‪getPageRepository()->‪enableFields(‪$tableName);
        } elseif (!$ignoreEnableFields && $includeDeleted) {
            throw new ‪InconsistentQuerySettingsException('Query setting "ignoreEnableFields=FALSE" can not be used together with "includeDeleted=TRUE" in frontend context.', 1460975922);
        }
        return $statement;
    }
 
    protected function ‪getBackendConstraintStatement(‪$tableName, $ignoreEnableFields, $includeDeleted)
    {
        $statement = '';
        if (!$ignoreEnableFields) {
            $statement .= ‪BackendUtility::BEenableFields(‪$tableName);
        }
        if (!$includeDeleted && !empty(‪$GLOBALS['TCA'][‪$tableName]['ctrl']['delete'])) {
            $statement .= ' AND ' . ‪$tableName . '.' . ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['delete'] . '=0';
        }
        return $statement;
    }
 
    protected function ‪getSysLanguageStatement(‪$tableName, $tableAlias, $querySettings)
    {
        if (is_array(‪$GLOBALS['TCA'][‪$tableName]['ctrl'])) {
            if (!empty(‪$GLOBALS['TCA'][‪$tableName]['ctrl']['languageField'])) {
                // Select all entries for the current language
                // If any language is set -> get those entries which are not translated yet
                // They will be removed by \TYPO3\CMS\Frontend\Page\PageRepository::getRecordOverlay if not matching overlay mode
                $languageField = ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['languageField'];
 
                if (isset(‪$GLOBALS['TCA'][‪$tableName]['ctrl']['transOrigPointerField'])
                    && $querySettings->‪getLanguageUid() > 0
                ) {
                    $mode = $querySettings->‪getLanguageMode();
 
                    if ($mode === 'strict') {
                        $queryBuilderForSubselect = $this->queryBuilder->getConnection()->createQueryBuilder();
                        $queryBuilderForSubselect->getRestrictions()->removeAll()->add(new ‪DeletedRestriction());
                        $queryBuilderForSubselect
                            ->select(‪$tableName . '.' . ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['transOrigPointerField'])
                            ->from(‪$tableName)
                            ->where(
                                $queryBuilderForSubselect->expr()->andX(
                                    $queryBuilderForSubselect->expr()->gt(‪$tableName . '.' . ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['transOrigPointerField'], 0),
                                    $queryBuilderForSubselect->expr()->eq(‪$tableName . '.' . $languageField, (int)$querySettings->‪getLanguageUid())
                                )
                            );
                        return $this->queryBuilder->expr()->orX(
                            $this->queryBuilder->expr()->eq($tableAlias . '.' . $languageField, -1),
                            $this->queryBuilder->expr()->andX(
                                $this->queryBuilder->expr()->eq($tableAlias . '.' . $languageField, (int)$querySettings->‪getLanguageUid()),
                                $this->queryBuilder->expr()->eq($tableAlias . '.' . ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['transOrigPointerField'], 0)
                            ),
                            $this->queryBuilder->expr()->andX(
                                $this->queryBuilder->expr()->eq($tableAlias . '.' . $languageField, 0),
                                $this->queryBuilder->expr()->in(
                                    $tableAlias . '.uid',
                                    $queryBuilderForSubselect->getSQL()
                                )
                            )
                        );
                    }
                    $queryBuilderForSubselect = $this->queryBuilder->getConnection()->createQueryBuilder();
                    $queryBuilderForSubselect->getRestrictions()->removeAll()->add(new ‪DeletedRestriction());
                    $queryBuilderForSubselect
                            ->select($tableAlias . '.' . ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['transOrigPointerField'])
                            ->from(‪$tableName)
                            ->where(
                                $queryBuilderForSubselect->expr()->andX(
                                    $queryBuilderForSubselect->expr()->gt(‪$tableName . '.' . ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['transOrigPointerField'], 0),
                                    $queryBuilderForSubselect->expr()->eq(‪$tableName . '.' . $languageField, (int)$querySettings->‪getLanguageUid())
                                )
                            );
                    return $this->queryBuilder->expr()->orX(
                        $this->queryBuilder->expr()->in($tableAlias . '.' . $languageField, [(int)$querySettings->‪getLanguageUid(), -1]),
                        $this->queryBuilder->expr()->andX(
                            $this->queryBuilder->expr()->eq($tableAlias . '.' . $languageField, 0),
                            $this->queryBuilder->expr()->notIn(
                                $tableAlias . '.uid',
                                $queryBuilderForSubselect->getSQL()
                            )
                        )
                    );
                }
                return $this->queryBuilder->expr()->in(
                    $tableAlias . '.' . $languageField,
                    [(int)$querySettings->‪getLanguageUid(), -1]
                );
            }
        }
        return '';
    }
 
    protected function ‪getLanguageStatement(‪$tableName, $tableAlias, ‪QuerySettingsInterface $querySettings)
    {
        if (empty(‪$GLOBALS['TCA'][‪$tableName]['ctrl']['languageField'])) {
            return '';
        }
 
        // Select all entries for the current language
        // If any language is set -> get those entries which are not translated yet
        // They will be removed by \TYPO3\CMS\Frontend\Page\PageRepository::getRecordOverlay if not matching overlay mode
        $languageField = ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['languageField'];
 
        $transOrigPointerField = ‪$GLOBALS['TCA'][‪$tableName]['ctrl']['transOrigPointerField'] ?? '';
        if (!$transOrigPointerField || !$querySettings->‪getLanguageUid()) {
            return $this->queryBuilder->expr()->in(
                $tableAlias . '.' . $languageField,
                [(int)$querySettings->‪getLanguageUid(), -1]
            );
        }
 
        $mode = $querySettings->‪getLanguageOverlayMode();
        if (!$mode) {
            return $this->queryBuilder->expr()->in(
                $tableAlias . '.' . $languageField,
                [(int)$querySettings->‪getLanguageUid(), -1]
            );
        }
 
        $defLangTableAlias = $tableAlias . '_dl';
        $defaultLanguageRecordsSubSelect = $this->queryBuilder->getConnection()->createQueryBuilder();
        $defaultLanguageRecordsSubSelect
            ->select($defLangTableAlias . '.uid')
            ->from(‪$tableName, $defLangTableAlias)
            ->where(
                $defaultLanguageRecordsSubSelect->expr()->andX(
                    $defaultLanguageRecordsSubSelect->expr()->eq($defLangTableAlias . '.' . $transOrigPointerField, 0),
                    $defaultLanguageRecordsSubSelect->expr()->eq($defLangTableAlias . '.' . $languageField, 0)
                )
            );
 
        $andConditions = [];
        // records in language 'all'
        $andConditions[] = $this->queryBuilder->expr()->eq($tableAlias . '.' . $languageField, -1);
        // translated records where a default language exists
        $andConditions[] = $this->queryBuilder->expr()->andX(
            $this->queryBuilder->expr()->eq($tableAlias . '.' . $languageField, (int)$querySettings->‪getLanguageUid()),
            $this->queryBuilder->expr()->in(
                $tableAlias . '.' . $transOrigPointerField,
                $defaultLanguageRecordsSubSelect->getSQL()
            )
        );
        if ($mode !== 'hideNonTranslated') {
            // $mode = TRUE
            // returns records from current language which have default language
            // together with not translated default language records
            $translatedOnlyTableAlias = $tableAlias . '_to';
            $queryBuilderForSubselect = $this->queryBuilder->getConnection()->createQueryBuilder();
            $queryBuilderForSubselect
                ->select($translatedOnlyTableAlias . '.' . $transOrigPointerField)
                ->from(‪$tableName, $translatedOnlyTableAlias)
                ->where(
                    $queryBuilderForSubselect->expr()->andX(
                        $queryBuilderForSubselect->expr()->gt($translatedOnlyTableAlias . '.' . $transOrigPointerField, 0),
                        $queryBuilderForSubselect->expr()->eq($translatedOnlyTableAlias . '.' . $languageField, (int)$querySettings->‪getLanguageUid())
                    )
                );
            // records in default language, which do not have a translation
            $andConditions[] = $this->queryBuilder->expr()->andX(
                $this->queryBuilder->expr()->eq($tableAlias . '.' . $languageField, 0),
                $this->queryBuilder->expr()->notIn(
                    $tableAlias . '.uid',
                    $queryBuilderForSubselect->getSQL()
                )
            );
        }
 
        return $this->queryBuilder->expr()->orX(...$andConditions);
    }
 
    protected function ‪getPageIdStatement(‪$tableName, $tableAlias, array $storagePageIds)
    {
        if (!is_array(‪$GLOBALS['TCA'][‪$tableName]['ctrl'])) {
            return '';
        }
 
        $rootLevel = (int)‪$GLOBALS['TCA'][‪$tableName]['ctrl']['rootLevel'];
        switch ($rootLevel) {
            // Only in pid 0
            case 1:
                $storagePageIds = [0];
                break;
            // Pid 0 and pagetree
            case -1:
                if (empty($storagePageIds)) {
                    $storagePageIds = [0];
                } else {
                    $storagePageIds[] = 0;
                }
                break;
            // Only pagetree or not set
            case 0:
                if (empty($storagePageIds)) {
                    throw new InconsistentQuerySettingsException('Missing storage page ids.', 1365779762);
                }
                break;
            // Invalid configuration
            default:
                return '';
        }
        $storagePageIds = array_map('intval', $storagePageIds);
        if (count($storagePageIds) === 1) {
            return $this->queryBuilder->expr()->eq($tableAlias . '.pid', reset($storagePageIds));
        }
        return $this->queryBuilder->expr()->in($tableAlias . '.pid', $storagePageIds);
    }
 
    protected function ‪parseJoin(Qom\JoinInterface $join, $leftTableAlias)
    {
        $leftSource = $join->getLeft();
        $leftClassName = $leftSource->getNodeTypeName();
        $this->‪addRecordTypeConstraint($leftClassName);
        $rightSource = $join->getRight();
        if ($rightSource instanceof Qom\JoinInterface) {
            $left = $rightSource->getLeft();
            $rightClassName = $left->getNodeTypeName();
            $rightTableName = $left->getSelectorName();
        } else {
            $rightClassName = $rightSource->getNodeTypeName();
            $rightTableName = $rightSource->getSelectorName();
            $this->queryBuilder->addSelect($rightTableName . '.*');
        }
        $this->‪addRecordTypeConstraint($rightClassName);
        $rightTableAlias = $this->‪getUniqueAlias($rightTableName);
        $joinCondition = $join->getJoinCondition();
        $joinConditionExpression = null;
        if ($joinCondition instanceof Qom\EquiJoinCondition) {
            $column1Name = $this->dataMapper->convertPropertyNameToColumnName($joinCondition->getProperty1Name(), $leftClassName);
            $column2Name = $this->dataMapper->convertPropertyNameToColumnName($joinCondition->getProperty2Name(), $rightClassName);
 
            $joinConditionExpression = $this->queryBuilder->expr()->eq(
                $leftTableAlias . '.' . $column1Name,
                $this->queryBuilder->quoteIdentifier($rightTableAlias . '.' . $column2Name)
            );
        }
        $this->queryBuilder->leftJoin($leftTableAlias, $rightTableName, $rightTableAlias, $joinConditionExpression);
        if ($rightSource instanceof Qom\JoinInterface) {
            $this->‪parseJoin($rightSource, $rightTableAlias);
        }
    }
 
    protected function ‪getUniqueAlias(‪$tableName, $fullPropertyPath = null)
    {
        if (isset($fullPropertyPath) && isset($this->tablePropertyMap[$fullPropertyPath])) {
            return $this->tablePropertyMap[$fullPropertyPath];
        }
 
        $alias = ‪$tableName;
        $i = 0;
        while (isset($this->tableAliasMap[$alias])) {
            $alias = ‪$tableName . $i;
            $i++;
        }
 
        $this->tableAliasMap[$alias] = ‪$tableName;
 
        if (isset($fullPropertyPath)) {
            $this->tablePropertyMap[$fullPropertyPath] = $alias;
        }
 
        return $alias;
    }
 
    protected function ‪addUnionStatement(&$className, &‪$tableName, &$propertyPath, &$fullPropertyPath)
    {
        $explodedPropertyPath = explode('.', $propertyPath, 2);
        $propertyName = $explodedPropertyPath[0];
        $columnName = $this->dataMapper->convertPropertyNameToColumnName($propertyName, $className);
        $realTableName = $this->dataMapper->convertClassNameToTableName($className);
        ‪$tableName = $this->tablePropertyMap[$fullPropertyPath] ?? $realTableName;
        $columnMap = $this->dataMapper->getDataMap($className)->getColumnMap($propertyName);
 
        if ($columnMap === null) {
            throw new MissingColumnMapException('The ColumnMap for property "' . $propertyName . '" of class "' . $className . '" is missing.', 1355142232);
        }
 
        $parentKeyFieldName = $columnMap->getParentKeyFieldName();
        $childTableName = $columnMap->getChildTableName();
 
        if ($childTableName === null) {
            throw new InvalidRelationConfigurationException('The relation information for property "' . $propertyName . '" of class "' . $className . '" is missing.', 1353170925);
        }
 
        $fullPropertyPath .= ($fullPropertyPath === '') ? $propertyName : '.' . $propertyName;
        $childTableAlias = $this->‪getUniqueAlias($childTableName, $fullPropertyPath);
 
        // If there is already a union with the current identifier we do not need to build it again and exit early.
        if (in_array($childTableAlias, $this->unionTableAliasCache, true)) {
            $propertyPath = $explodedPropertyPath[1];
            ‪$tableName = $childTableAlias;
            $className = $this->dataMapper->getType($className, $propertyName);
            return;
        }
 
        if ($columnMap->getTypeOfRelation() === ‪ColumnMap::RELATION_HAS_ONE) {
            if (isset($parentKeyFieldName)) {
                // @todo: no test for this part yet
                $joinConditionExpression = $this->queryBuilder->expr()->eq(
                    ‪$tableName . '.uid',
                    $this->queryBuilder->quoteIdentifier($childTableAlias . '.' . $parentKeyFieldName)
                );
            } else {
                $joinConditionExpression = $this->queryBuilder->expr()->eq(
                    ‪$tableName . '.' . $columnName,
                    $this->queryBuilder->quoteIdentifier($childTableAlias . '.uid')
                );
            }
            $this->queryBuilder->leftJoin(‪$tableName, $childTableName, $childTableAlias, $joinConditionExpression);
            $this->unionTableAliasCache[] = $childTableAlias;
            $this->queryBuilder->andWhere(
                $this->‪getAdditionalMatchFieldsStatement($this->queryBuilder->expr(), $columnMap, $childTableAlias, $realTableName)
            );
        } elseif ($columnMap->getTypeOfRelation() === ‪ColumnMap::RELATION_HAS_MANY) {
            // @todo: no tests for this part yet
            if (isset($parentKeyFieldName)) {
                $joinConditionExpression = $this->queryBuilder->expr()->eq(
                    ‪$tableName . '.uid',
                    $this->queryBuilder->quoteIdentifier($childTableAlias . '.' . $parentKeyFieldName)
                );
            } else {
                $joinConditionExpression = $this->queryBuilder->expr()->inSet(
                    ‪$tableName . '.' . $columnName,
                    $this->queryBuilder->quoteIdentifier($childTableAlias . '.uid'),
                    true
                );
            }
            $this->queryBuilder->leftJoin(‪$tableName, $childTableName, $childTableAlias, $joinConditionExpression);
            $this->unionTableAliasCache[] = $childTableAlias;
            $this->queryBuilder->andWhere(
                $this->‪getAdditionalMatchFieldsStatement($this->queryBuilder->expr(), $columnMap, $childTableAlias, $realTableName)
            );
            $this->suggestDistinctQuery = true;
        } elseif ($columnMap->getTypeOfRelation() === ‪ColumnMap::RELATION_HAS_AND_BELONGS_TO_MANY) {
            $relationTableName = $columnMap->getRelationTableName();
            $relationTableAlias = $this->‪getUniqueAlias($relationTableName, $fullPropertyPath . '_mm');
 
            $joinConditionExpression = $this->queryBuilder->expr()->andX(
                $this->queryBuilder->expr()->eq(
                    ‪$tableName . '.uid',
                    $this->queryBuilder->quoteIdentifier(
                        $relationTableAlias . '.' . $columnMap->getParentKeyFieldName()
                    )
                ),
                $this->getAdditionalMatchFieldsStatement($this->queryBuilder->expr(), $columnMap, $relationTableAlias, $realTableName)
            );
            $this->queryBuilder->leftJoin(‪$tableName, $relationTableName, $relationTableAlias, $joinConditionExpression);
            $joinConditionExpression = $this->queryBuilder->expr()->eq(
                $relationTableAlias . '.' . $columnMap->getChildKeyFieldName(),
                $this->queryBuilder->quoteIdentifier($childTableAlias . '.uid')
            );
            $this->queryBuilder->leftJoin($relationTableAlias, $childTableName, $childTableAlias, $joinConditionExpression);
            $this->unionTableAliasCache[] = $childTableAlias;
            $this->suggestDistinctQuery = true;
        } else {
            throw new Exception('Could not determine type of relation.', 1252502725);
        }
        $propertyPath = $explodedPropertyPath[1];
        ‪$tableName = $childTableAlias;
        $className = $this->dataMapper->getType($className, $propertyName);
    }
 
    protected function ‪replaceTableNameWithAlias($statement, ‪$tableName, $tableAlias)
    {
        if ($tableAlias !== ‪$tableName) {
            $connection = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable(‪$tableName);
            $quotedTableName = $connection->quoteIdentifier(‪$tableName);
            $quotedTableAlias = $connection->quoteIdentifier($tableAlias);
            $statement = str_replace(
                [‪$tableName . '.', $quotedTableName . '.'],
                [$tableAlias . '.', $quotedTableAlias . '.'],
                $statement
            );
        }
 
        return $statement;
    }
 
    protected function ‪getPageRepository()
    {
        if (!$this->pageRepository instanceof PageRepository) {
            $this->pageRepository = GeneralUtility::makeInstance(PageRepository::class);
        }
        return ‪$this->pageRepository;
    }
}