9.5/_tca_preparation_8php_source.html

<?php

declare(strict_types = 1);

namespace ‪TYPO3\CMS\Core\Preparations;


/*

 * 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\Core\Database\ConnectionPool;

use ‪TYPO3\CMS\Core\Database\Query\QueryHelper;

use ‪TYPO3\CMS\Core\Utility\GeneralUtility;


class ‪TcaPreparation

{


    public function ‪prepare(array ‪$tca): array

    {

        ‪$tca = $this->‪prepareQuotingOfTableNamesAndColumnNames($tca);

        return ‪$tca;

    }


    protected function ‪prepareQuotingOfTableNamesAndColumnNames(array ‪$tca): array

    {

        $connectionPool = GeneralUtility::makeInstance(ConnectionPool::class);


        $newTca = ‪$tca;

        $configToPrepareQuoting = [

            'foreign_table_where',

            'MM_table_where',

            'search' => 'andWhere'

        ];

        foreach (‪$tca as $table => $tableDefinition) {

            if (!isset($tableDefinition['columns']) || !is_array($tableDefinition['columns'])) {

                continue;

            }


            foreach ($tableDefinition['columns'] as $columnName => $columnConfig) {

                foreach ($configToPrepareQuoting as $level => $value) {

                    if (is_string($level)) {

                        $sqlQueryPartToPrepareQuotingIn = $columnConfig['config'][$level][$value] ?? '';

                    } else {

                        $sqlQueryPartToPrepareQuotingIn = $columnConfig['config'][$value] ?? '';

                    }

                    if (mb_strpos($sqlQueryPartToPrepareQuotingIn, '{#') !== false) {

                        $quoted = ‪QueryHelper::quoteDatabaseIdentifiers(

                            $connectionPool->getConnectionForTable($table),

                            $sqlQueryPartToPrepareQuotingIn

                        );

                        if (is_string($level)) {

                            $newTca[$table]['columns'][$columnName]['config'][$level][$value] = $quoted;

                        } else {

                            $newTca[$table]['columns'][$columnName]['config'][$value] = $quoted;

                        }

                    }

                }

            }

        }


        return $newTca;

    }

}