class.ext_update.php

<?php
/***************************************************************
 *  Copyright notice
 *
 *  (c) 2008 Dmitry Dulepov <dmitry@typo3.org>
 *  (c) 2009-2017 Leonie Philine Bitto (extensions@netcreators.nl)
 *  All rights reserved
 *
 *  This script is part of the TYPO3 project. The TYPO3 project is
 *  free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 *  The GNU General Public License can be found at
 *  http://www.gnu.org/copyleft/gpl.html.
 *
 *  This script is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  This copyright notice MUST APPEAR in all copies of the script!
 ***************************************************************/

use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Database\Query\QueryBuilder;
use TYPO3\CMS\Core\Database\Query\Restriction\EndTimeRestriction;
use TYPO3\CMS\Core\Database\Query\Restriction\StartTimeRestriction;
use TYPO3\CMS\Core\Utility\GeneralUtility;

/**
 * Updates the extension from older versions to this one.
 *
 * @author    Dmitry Dulepov <dmitry@typo3.org>
 */
class ext_update
{

    /** @var language Language support */
    protected $lang;

    /** Defines new sheets and fields inside them */
    protected $fieldSet = [
        'sCATEGORIES' => ['categoryMode', 'categorySelection'],
        'sSEARCH' => ['searchPid', 'emptySearchAtStart'],
    ];

    /**
     * Shows form and/or runs the update process.
     *
     * @return    string    Output
     */
    function main()
    {
        $this->lang = $this->getLanguageService();
        $this->lang->init($GLOBALS['BE_USER']->uc['lang']);
        $this->lang->includeLLFile('EXT:irfaq/Resources/Private/Language/locallang_update.xlf');
        return ($_POST['run'] ? $this->runConversion() : $this->showForm());
    }

    /**
     * Checks if "UPDATE!" should be shown at all. In out case it will be shown
     * only if there are irfaq records in the system.
     *
     * @return    boolean    true if script should be displayed
     */
    function access()
    {

        /** @var QueryBuilder $queryBuilder */
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
        $queryBuilder->getRestrictions()
            ->add(GeneralUtility::makeInstance(StartTimeRestriction::class))
            ->add(GeneralUtility::makeInstance(EndTimeRestriction::class));
        $queryBuilder
            ->select('*')
            ->from('tt_content')
            ->where(
                $queryBuilder->expr()->eq('list_type', $queryBuilder->createNamedParameter('irfaq_pi1'))
            );

        $statement = $queryBuilder->execute();
        return !empty($statement->fetchAll());
    }

    /**
     * Shows form to update irfaq
     *
     * @return    string    Generated form
     */
    function showForm()
    {
        $content = '<p>' . $this->lang->getLL('form_intro', true) . '</p>' .
            '<form action="' . htmlspecialchars(GeneralUtility::linkThisScript()) . '" method="post">' .
            '<input type="hidden" name="CMD[showExt]" value="irfaq" />' .
            '<input type="hidden" name="SET[singleDetails]" value="updateModule" />' .
            '<input type="checkbox" name="replaceEmpty" value="1" />' .
            $this->lang->getLL('replace_empty') . '<br />' .
            '<input type="submit" name="run" value="' .
            $this->lang->getLL('submit_button', true) . '" /></form>';
        return $content;
    }

    /**
     * Runs conversion procedure.
     *
     * @return    string    Generated content
     */
    function runConversion()
    {
        $content = '';


        // Select all instances
        /** @var QueryBuilder $queryBuilder */
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
        $queryBuilder
            ->select('uid','pid','pi_flexform')
            ->from('tt_content')
            ->where(
                $queryBuilder->expr()->eq('list_type', $queryBuilder->createNamedParameter('irfaq_pi1'))
            );

        $statement = $queryBuilder->execute();
        $allRows = $statement->fetchAll();

        $results = count($allRows);
        $converted = 0;
        $data = [];
        $pidList = [];
        $replaceEmpty = intval(GeneralUtility::_GP('replaceEmpty'));

        /** @var \TYPO3\CMS\Core\Configuration\FlexForm\FlexFormTools $flexformtools */
        $flexformtools = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Configuration\\FlexForm\\FlexFormTools');
        /* @var $flexformtools t3lib_flexformtools */
        $GLOBALS['TYPO3_CONF_VARS']['BE']['compactFlexFormXML'] = true;
        $GLOBALS['TYPO3_CONF_VARS']['BE']['niceFlexFormXMLtags'] = true;

        // Walk all rows
        foreach($allRows as $row) {
            $ffArray = GeneralUtility::xml2array($row['pi_flexform']);
            $modified = false;
            if (is_array($ffArray) && isset($ffArray['data']['sDEF'])) {
                foreach ($ffArray['data']['sDEF'] as $sLang => $sLdata) {
                    foreach ($this->fieldSet as $sheet => $fieldList) {
                        foreach ($fieldList as $field) {
                            if (isset($ffArray['data']['sDEF'][$sLang][$field]) &&
                                isset($ffArray['data']['sDEF'][$sLang][$field]['vDEF']) &&
                                strlen($ffArray['data']['sDEF'][$sLang][$field]['vDEF']) > 0 &&
                                (!isset($ffArray['data'][$sheet][$sLang][$field]) ||
                                    !isset($ffArray['data'][$sheet][$sLang][$field]['vDEF']) ||
                                    ($replaceEmpty && strlen($ffArray['data'][$sheet][$sLang][$field]['vDEF']) == 0))
                            ) {
                                $ffArray['data'][$sheet][$sLang][$field]['vDEF'] =
                                    $ffArray['data']['sDEF'][$sLang][$field]['vDEF'];
                                if ($row['pid'] > 0) {
                                    $pidList[$row['pid']] = $row['pid'];
                                }
                                $modified = true;
                            }
                        }
                    }
                }
            }
            if ($modified) {
                // Assemble data back
                $data['tt_content'][$row['uid']] = [
                    'pi_flexform' => $flexformtools->flexArray2Xml($ffArray),
                ];
                $converted++;
            }
        }

        if ($converted > 0) {
            // Update data
            /** @var \TYPO3\CMS\Core\DataHandling\DataHandler $tce */
            $tce = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\DataHandling\\DataHandler');
            /* @var $tce t3lib_TCEmain */
            $tce->start($data, null);
            $tce->process_datamap();
            if (count($tce->errorLog) > 0) {
                $content .= '<p>' . $this->lang->getLL('errors') . '</p><ul><li>' .
                    implode('</li><li>', $tce->errorLog) . '</li></ul>';
            }
            // Clear cache
            foreach ($pidList as $pid) {
                $tce->clear_cacheCmd($pid);
            }
        }
        $content .= '<p>' . sprintf($this->lang->getLL('result'), $results, $converted) .
            '</p>';
        return $content;
    }

    /**
     * @return \TYPO3\CMS\Lang\LanguageService
     */
    protected function getLanguageService()
    {
        return $GLOBALS['LANG'];
    }
}