TranslationStatusController.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Frontend\Controller;

use TYPO3\CMS\Backend\Utility\BackendUtility;
use TYPO3\CMS\Backend\Utility\IconUtility;

class TranslationStatusController extends \TYPO3\CMS\Backend\Module\AbstractFunctionModule {

    public function modMenu() {
        global $LANG;
        $menuArray = array(
            'depth' => array(
                0 => $LANG->getLL('depth_0'),
                1 => $LANG->getLL('depth_1'),
                2 => $LANG->getLL('depth_2'),
                3 => $LANG->getLL('depth_3'),
                999 => $LANG->sL('LLL:EXT:lang/locallang_core.xlf:labels.depth_infi')
            )
        );
        // Languages:
        $lang = $this->getSystemLanguages();
        $menuArray['lang'] = array(
            0 => '[All]'
        );
        foreach ($lang as $langRec) {
            $menuArray['lang'][$langRec['uid']] = $langRec['title'];
        }
        return $menuArray;
    }

    public function main() {
        global $BACK_PATH, $LANG, $SOBE;
        $theOutput = $this->pObj->doc->header($LANG->sL('LLL:EXT:cms/web_info/locallang.xlf:lang_title'));
        if ($this->pObj->id) {
            // Depth selector:
            $h_func = BackendUtility::getFuncMenu($this->pObj->id, 'SET[depth]', $this->pObj->MOD_SETTINGS['depth'], $this->pObj->MOD_MENU['depth']);
            $h_func .= BackendUtility::getFuncMenu($this->pObj->id, 'SET[lang]', $this->pObj->MOD_SETTINGS['lang'], $this->pObj->MOD_MENU['lang']);
            $theOutput .= $h_func;
            // Add CSH:
            $theOutput .= BackendUtility::cshItem('_MOD_web_info', 'lang', $GLOBALS['BACK_PATH'], '|<br />');
            // Showing the tree:
            // Initialize starting point of page tree:
            $treeStartingPoint = (int)$this->pObj->id;
            $treeStartingRecord = BackendUtility::getRecordWSOL('pages', $treeStartingPoint);
            $depth = $this->pObj->MOD_SETTINGS['depth'];
            // Initialize tree object:
            $tree = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('TYPO3\\CMS\\Backend\\Tree\\View\\PageTreeView');
            $tree->init('AND ' . $GLOBALS['BE_USER']->getPagePermsClause(1));
            $tree->addField('l18n_cfg');
            // Creating top icon; the current page
            $HTML = IconUtility::getSpriteIconForRecord('pages', $treeStartingRecord);
            $tree->tree[] = array(
                'row' => $treeStartingRecord,
                'HTML' => $HTML
            );
            // Create the tree from starting point:
            if ($depth) {
                $tree->getTree($treeStartingPoint, $depth, '');
            }
            // Render information table:
            $theOutput .= $this->renderL10nTable($tree);
        }
        return $theOutput;
    }

    public function renderL10nTable(&$tree) {
        global $LANG;
        // System languages retrieved:
        $languages = $this->getSystemLanguages();
        // Title length:
        $titleLen = $GLOBALS['BE_USER']->uc['titleLen'];
        // Put together the TREE:
        $output = '';
        $newOL_js = array();
        $langRecUids = array();
        foreach ($tree->tree as $data) {
            $tCells = array();
            $langRecUids[0][] = $data['row']['uid'];
            // Page icons / titles etc.
            $tCells[] = '<td' . ($data['row']['_CSSCLASS'] ? ' class="' . $data['row']['_CSSCLASS'] . '"' : '') . '>' . $data['HTML'] . htmlspecialchars(\TYPO3\CMS\Core\Utility\GeneralUtility::fixed_lgd_cs($data['row']['title'], $titleLen)) . ((string)$data['row']['nav_title'] !== '' ? ' [Nav: <em>' . htmlspecialchars(\TYPO3\CMS\Core\Utility\GeneralUtility::fixed_lgd_cs($data['row']['nav_title'], $titleLen)) . '</em>]' : '') . '</td>';
            // DEFAULT language:
            // "View page" link is created:
            $viewPageLink = '<a href="#" onclick="' . htmlspecialchars(BackendUtility::viewOnClick(
                    $data['row']['uid'], $GLOBALS['BACK_PATH'], '', '', '', '&L=###LANG_UID###')
                ) . '" title="' . $LANG->sL('LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_viewPage') . '">' .
                IconUtility::getSpriteIcon('actions-document-view') . '</a>';
            $status = \TYPO3\CMS\Core\Utility\GeneralUtility::hideIfDefaultLanguage($data['row']['l18n_cfg']) ? 'c-blocked' : 'c-ok';
            // Create links:
            $info = '';
            $editUid = $data['row']['uid'];
            $params = '&edit[pages][' . $editUid . ']=edit';
            $info .= '<a href="#" onclick="' . htmlspecialchars(BackendUtility::editOnClick(
                    $params, $GLOBALS['BACK_PATH'])
                ) . '" title="' . $LANG->sL(
                    'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_editDefaultLanguagePage'
                ) . '">' . IconUtility::getSpriteIcon('actions-document-open') . '</a>';
            $info .= '<a href="#" onclick="' . htmlspecialchars(
                    'top.loadEditId(' . (int)$data['row']['uid'] . ',"&SET[language]=0"); return false;'
                ) . '" title="' . $LANG->sL('LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_editPage') . '">' .
                IconUtility::getSpriteIcon('actions-page-open') . '</a>';
            $info .= str_replace('###LANG_UID###', '0', $viewPageLink);
            $info .= '&nbsp;';
            $info .= \TYPO3\CMS\Core\Utility\GeneralUtility::hideIfDefaultLanguage($data['row']['l18n_cfg']) ? '<span title="' . $LANG->sL('LLL:EXT:cms/locallang_tca.xlf:pages.l18n_cfg.I.1', TRUE) . '">D</span>' : '&nbsp;';
            $info .= \TYPO3\CMS\Core\Utility\GeneralUtility::hideIfNotTranslated($data['row']['l18n_cfg']) ? '<span title="' . $LANG->sL('LLL:EXT:cms/locallang_tca.xlf:pages.l18n_cfg.I.2', TRUE) . '">N</span>' : '&nbsp;';
            // Put into cell:
            $tCells[] = '<td class="' . $status . ' c-leftLine">' . $info . '</td>';
            $tCells[] = '<td class="' . $status . '" title="' . $LANG->sL(
                    'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_CEcount'
                ) . '" align="center">' . $this->getContentElementCount($data['row']['uid'], 0) . '</td>';
            $modSharedTSconfig = BackendUtility::getModTSconfig($data['row']['uid'], 'mod.SHARED');
            $disableLanguages = isset($modSharedTSconfig['properties']['disableLanguages']) ? \TYPO3\CMS\Core\Utility\GeneralUtility::trimExplode(',', $modSharedTSconfig['properties']['disableLanguages'], TRUE) : array();
            // Traverse system languages:
            foreach ($languages as $langRow) {
                if ($this->pObj->MOD_SETTINGS['lang'] == 0 || (int)$this->pObj->MOD_SETTINGS['lang'] === (int)$langRow['uid']) {
                    $row = $this->getLangStatus($data['row']['uid'], $langRow['uid']);
                    $info = '';
                    if (is_array($row)) {
                        $langRecUids[$langRow['uid']][] = $row['uid'];
                        $status = $row['_HIDDEN'] ? (\TYPO3\CMS\Core\Utility\GeneralUtility::hideIfNotTranslated($data['row']['l18n_cfg']) || \TYPO3\CMS\Core\Utility\GeneralUtility::hideIfDefaultLanguage($data['row']['l18n_cfg']) ? 'c-blocked' : 'c-fallback') : 'c-ok';
                        $icon = IconUtility::getSpriteIconForRecord(
                            'pages_language_overlay',
                            $row,
                            array('class' => 'c-recIcon')
                        );
                        $info = $icon . htmlspecialchars(
                                \TYPO3\CMS\Core\Utility\GeneralUtility::fixed_lgd_cs($row['title'], $titleLen)
                            ) . ((string)$row['nav_title'] !== '' ? ' [Nav: <em>' . htmlspecialchars(
                                \TYPO3\CMS\Core\Utility\GeneralUtility::fixed_lgd_cs($row['nav_title'], $titleLen)
                            ) . '</em>]' : '') . ($row['_COUNT'] > 1 ? '<div>' . $LANG->sL(
                                'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_badThingThereAre'
                            ) . '</div>' : '');
                        $tCells[] = '<td class="' . $status . ' c-leftLine">' . $info . '</td>';
                        // Edit whole record:
                        $info = '';
                        $editUid = $row['uid'];
                        $params = '&edit[pages_language_overlay][' . $editUid . ']=edit';
                        $info .= '<a href="#" onclick="' . htmlspecialchars(
                                BackendUtility::editOnClick($params, $GLOBALS['BACK_PATH'])
                            ) . '" title="' . $LANG->sL(
                                'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_editLanguageOverlayRecord'
                            ) . '">' . IconUtility::getSpriteIcon('actions-document-open') . '</a>';
                        $info .= '<a href="#" onclick="' . htmlspecialchars(
                                'top.loadEditId(' . (int)$data['row']['uid'] . ',"&SET[language]=' . $langRow['uid'] . '"); return false;'
                            ) . '" title="' . $LANG->sL(
                                'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_editPageLang'
                            ) . '">' . IconUtility::getSpriteIcon('actions-page-open') . '</a>';
                        $info .= str_replace('###LANG_UID###', $langRow['uid'], $viewPageLink);
                        $tCells[] = '<td class="' . $status . '">' . $info . '</td>';
                        $tCells[] = '<td class="' . $status . '" title="' . $LANG->sL(
                                'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_CEcount'
                            ) . '" align="center">' . $this->getContentElementCount($data['row']['uid'], $langRow['uid']) . '</td>';
                    } else {
                        if (in_array($langRow['uid'], $disableLanguages)) {
                            // Language has been disabled for this page
                            $status = 'c-blocked';
                            $info = '';
                        } else {
                            $status = \TYPO3\CMS\Core\Utility\GeneralUtility::hideIfNotTranslated($data['row']['l18n_cfg']) || \TYPO3\CMS\Core\Utility\GeneralUtility::hideIfDefaultLanguage($data['row']['l18n_cfg']) ? 'c-blocked' : 'c-fallback';
                            $info = '<input type="checkbox" name="newOL[' . $langRow['uid'] . '][' . $data['row']['uid'] . ']" value="1" />';
                            $newOL_js[$langRow['uid']] .= '
                                +(document.webinfoForm[\'newOL[' . $langRow['uid'] . '][' . $data['row']['uid'] . ']\'].checked ? \'&edit[pages_language_overlay][' . $data['row']['uid'] . ']=new\' : \'\')
                            ';
                        }
                        $tCells[] = '<td class="' . $status . ' c-leftLine">&nbsp;</td>';
                        $tCells[] = '<td class="' . $status . '">&nbsp;</td>';
                        $tCells[] = '<td class="' . $status . '">' . $info . '</td>';
                    }
                }
            }
            $output .= '
                <tr class="bgColor4">
                    ' . implode('
                    ', $tCells) . '
                </tr>';
        }
        // Put together HEADER:
        $tCells = array();
        $tCells[] = '<td>' . $LANG->sL('LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_page') . ':</td>';
        if (is_array($langRecUids[0])) {
            $params = '&edit[pages][' . implode(',', $langRecUids[0]) . ']=edit&columnsOnly=title,nav_title,l18n_cfg,hidden';
            $editIco = '<a href="#" onclick="' . htmlspecialchars(
                    BackendUtility::editOnClick($params, $GLOBALS['BACK_PATH'])
                ) . '" title="' . $LANG->sL(
                    'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_editPageProperties'
                ) . '">' . IconUtility::getSpriteIcon('actions-document-new') . '</a>';
        } else {
            $editIco = '';
        }
        $tCells[] = '<td class="c-leftLine" colspan="2">' . $LANG->sL(
                'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_default'
            ) . ':' . $editIco . '</td>';
        foreach ($languages as $langRow) {
            if ($this->pObj->MOD_SETTINGS['lang'] == 0 || (int)$this->pObj->MOD_SETTINGS['lang'] === (int)$langRow['uid']) {
                // Title:
                $tCells[] = '<td class="c-leftLine">' . htmlspecialchars($langRow['title']) . '</td>';
                // Edit language overlay records:
                if (is_array($langRecUids[$langRow['uid']])) {
                    $params = '&edit[pages_language_overlay][' .
                        implode(',', $langRecUids[$langRow['uid']]) .
                        ']=edit&columnsOnly=title,nav_title,hidden';
                    $tCells[] = '<td><a href="#" onclick="' . htmlspecialchars(
                            BackendUtility::editOnClick($params, $GLOBALS['BACK_PATH'])
                        ) . '" title="' . $LANG->sL(
                            'LLL:EXT:cms/web_info/locallang.xlf:lang_renderl10n_editLangOverlays'
                        ) . '">' . IconUtility::getSpriteIcon('actions-document-open') . '</a></td>';
                } else {
                    $tCells[] = '<td>&nbsp;</td>';
                }
                // Create new overlay records:
                $params = '\'' .
                    $newOL_js[$langRow['uid']] .
                    '+\'&columnsOnly=title,hidden,sys_language_uid&defVals[pages_language_overlay][sys_language_uid]=' .
                    $langRow['uid'];
                $tCells[] = '<td><a href="#" onclick="' . htmlspecialchars(
                        BackendUtility::editOnClick($params, $GLOBALS['BACK_PATH'])
                    ) . '" title="' . $LANG->sL(
                        'LLL:EXT:cms/web_info/locallang.xlf:lang_getlangsta_createNewTranslationHeaders'
                    ) . '">' . IconUtility::getSpriteIcon('actions-document-new') . '</a></td>';
            }
        }
        $output = '
            <tr class="t3-row-header">
                ' . implode('
                ', $tCells) . '
            </tr>' . $output;
        $output = '

        <table border="0" cellspacing="0" cellpadding="0" id="langTable" class="typo3-dblist">' . $output . '
        </table>';
        return $output;
    }

    public function getSystemLanguages() {
        if (!$GLOBALS['BE_USER']->user['admin'] && strlen($GLOBALS['BE_USER']->groupData['allowed_languages'])) {
            $allowed_languages = array_flip(explode(',', $GLOBALS['BE_USER']->groupData['allowed_languages']));
        }
        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'sys_language', '1=1' . BackendUtility::deleteClause('sys_language'));
        $outputArray = array();
        while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
            if (is_array($allowed_languages) && count($allowed_languages)) {
                if (isset($allowed_languages[$row['uid']])) {
                    $outputArray[] = $row;
                }
            } else {
                $outputArray[] = $row;
            }
        }
        return $outputArray;
    }

    public function getLangStatus($pageId, $langId) {
        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
            '*',
            'pages_language_overlay',
            'pid=' . (int)$pageId .
                ' AND sys_language_uid=' . (int)$langId .
                BackendUtility::deleteClause('pages_language_overlay') .
                BackendUtility::versioningPlaceholderClause('pages_language_overlay')
        );
        $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
        BackendUtility::workspaceOL('pages_language_overlay', $row);
        if (is_array($row)) {
            $row['_COUNT'] = $GLOBALS['TYPO3_DB']->sql_num_rows($res);
            $row['_HIDDEN'] = $row['hidden'] || (int)$row['endtime'] > 0 && (int)$row['endtime'] < $GLOBALS['EXEC_TIME'] || $GLOBALS['EXEC_TIME'] < (int)$row['starttime'];
        }
        return $row;
    }

    public function getContentElementCount($pageId, $sysLang) {
        $count = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows('uid', 'tt_content', 'pid=' . (int)$pageId . ' AND sys_language_uid=' . (int)$sysLang . BackendUtility::deleteClause('tt_content') . BackendUtility::versioningPlaceholderClause('tt_content'));
        return $count ?: '-';
    }

}