9.5/_language_sorting_update_8php_source.html

<?php

declare(strict_types = 1);

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 ‪LanguageSortingUpdate implements ‪UpgradeWizardInterface

{

    public function ‪getIdentifier(): string

    {

        return 'sysLanguageSorting';

    }


    public function ‪getTitle(): string

    {

        return 'Update sorting of sys_language records';

    }


    public function ‪getDescription(): string

    {

        return 'The sys_language records have unsorted rows. '

            . ' This upgrade wizard adds values depending on the language title';

    }


    public function ‪updateNecessary(): bool

    {

        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)

            ->getQueryBuilderForTable('sys_language');

        return (bool)$queryBuilder->count('uid')

            ->from('sys_language')

            ->where(

                $queryBuilder->expr()->eq('sorting', $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT)),

                $queryBuilder->expr()->isNotNull('sorting')

            )

            ->execute()

            ->fetchColumn(0);

    }


    public function ‪getPrerequisites(): array

    {

        return [

            DatabaseUpdatedPrerequisite::class

        ];

    }


    public function ‪executeUpdate(): bool

    {

        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)

            ->getQueryBuilderForTable('sys_language');

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

            ->from('sys_language')

            ->where(

                $queryBuilder->expr()->eq('sorting', $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT))

            )

            ->orderBy('title')

            ->execute();

        $sortCounter = 10;

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

            $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)

                ->getQueryBuilderForTable('sys_language');

            $queryBuilder->update('sys_language')

                ->where(

                    $queryBuilder->expr()->eq(

                        'uid',

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

                    )

                )

                ->set('sorting', $sortCounter)

                ->execute();

            $sortCounter += 5;

        }

        return true;

    }

}