9.5/_upload_content_element_update_8php_source.html

<?php

namespace ‪TYPO3\CMS\Install\Updates;


/*

 * 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\Utility\GeneralUtility;


class ‪UploadContentElementUpdate implements ‪UpgradeWizardInterface

{

    public function ‪getIdentifier(): string

    {

        return 'uploadContentElementUpdate';

    }


    public function ‪getTitle(): string

    {

        return 'Migrate upload content element rendering from layout to uploads_type';

    }


    public function ‪getDescription(): string

    {

        return 'Rendering type field has been streamlined with fluid_styled_content.';

    }


    public function ‪updateNecessary(): bool

    {

        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');

        $queryBuilder->getRestrictions()->removeAll();

        $elementCount = $queryBuilder->count('uid')

            ->from('tt_content')

            ->where(

                $queryBuilder->expr()->eq('CType', $queryBuilder->createNamedParameter('uploads', \PDO::PARAM_STR)),

                $queryBuilder->expr()->in('layout', [1, 2])

            )

            ->execute()

            ->fetchColumn(0);

        return (bool)$elementCount;

    }


    public function ‪getPrerequisites(): array

    {

        return [

            DatabaseUpdatedPrerequisite::class

        ];

    }


    public function ‪executeUpdate(): bool

    {

        $connection = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable('tt_content');

        $queryBuilder = $connection->createQueryBuilder();

        $queryBuilder->getRestrictions()->removeAll();

        $statement = $queryBuilder->select('uid', 'layout')

            ->from('tt_content')

            ->where(

                $queryBuilder->expr()->eq('CType', $queryBuilder->createNamedParameter('uploads', \PDO::PARAM_STR)),

                $queryBuilder->expr()->in('layout', [1, 2])

            )

            ->execute();

        while ($record = $statement->fetch()) {

            $queryBuilder = $connection->createQueryBuilder();

            $queryBuilder->update('tt_content')

                ->where(

                    $queryBuilder->expr()->eq(

                        'uid',

                        $queryBuilder->createNamedParameter($record['uid'], \PDO::PARAM_INT)

                    )

                )

                ->set('layout', 0, false)

                ->set('uploads_type', $record['layout'])

                ->execute();

        }

        return true;

    }

}