RootTemplateUpdate.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Install\Updates;

class RootTemplateUpdate extends AbstractUpdate implements InstallerProcessInterface {

    protected $title = 'Integrate TypoScript Root Template';

    public function checkForUpdate(&$description, &$showUpdate = 0) {
        $pages = $this->findRootLevelPages();

        if ($pages !== NULL && $this->findRootTemplates(array_keys($pages)) !== NULL) {
            $description = 'There is already at least one TypoScript root template available.';
            $showUpdate = 0;
        } else {
            $description = 'There is no TypoScript root template! However, one is required for Extbase to behave correctly.';
            $showUpdate = 1;
        }

        return $showUpdate > 0;
    }

    public function performUpdate(array &$dbQueries, &$customMessages) {
        $now = time();
        $result = FALSE;

        $status = $GLOBALS['TYPO3_DB']->exec_INSERTquery(
            'pages',
            array(
                'pid' => 0,
                'title' => 'Home',
                'is_siteroot' => 1,
                'crdate' => $now,
                'tstamp' => $now,
            )
        );

        $dbQueries[] = str_replace(chr(10), ' ', $GLOBALS['TYPO3_DB']->debug_lastBuiltQuery);

        if ($status) {
            $pageId = $GLOBALS['TYPO3_DB']->sql_insert_id();

            $status = $GLOBALS['TYPO3_DB']->exec_INSERTquery(
                'sys_template',
                array(
                    'pid' => $pageId,
                    'title' => 'Default Root Template',
                    'root' => 1,
                    'clear' => 1,
                    'crdate' => $now,
                    'tstamp' => $now,
                )
            );

            $dbQueries[] = str_replace(chr(10), ' ', $GLOBALS['TYPO3_DB']->debug_lastBuiltQuery);

            if ($status) {
                $result = TRUE;
            }
        }

        return $result;
    }

    protected function findRootLevelPages() {
        $pages = NULL;

        $rows = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows(
            'uid,pid',
            'pages',
            'pid=0 AND deleted=0',
            '',
            '',
            '',
            'uid'
        );

        if (is_array($rows) && !empty($rows)) {
            $pages = $rows;
        }

        return $pages;
    }

    protected function findRootTemplates(array $pageUids) {
        $templates = NULL;

        $pageUids = array_map('intval', $pageUids);
        $pageUidList = implode(', ', $pageUids);

        $rows = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows(
            'uid,pid',
            'sys_template',
            'deleted=0 AND root=1 AND pid IN (' . $pageUidList . ')',
            '',
            '',
            '',
            'uid'
        );

        if (is_array($rows)) {
            $templates = $rows;
        }

        return $templates;
    }
}