. * * @param int $pageId Page id (used to get TSconfig configuration setting flag and label for default language) * @return array Array with languages */ public function getSystemLanguages(int $pageId = 0): array { $cacheKey = 'system-language-cache-page-uid-' . $pageId; if ($this->runtimeCache->has($cacheKey)) { return $this->runtimeCache->get($cacheKey); } $allSystemLanguages = []; if ($pageId === 0) { // Used for e.g. filelist, where there is no site selected // This also means that there is no "-1" (All Languages) selectable. $sites = $this->siteFinder->getAllSites(); foreach ($sites as $site) { $allSystemLanguages = $this->addSiteLanguagesToConsolidatedList( $allSystemLanguages, $site->getAvailableLanguages($this->getBackendUserAuthentication()), $site, true ); } } else { try { $site = $this->siteFinder->getSiteByPageId($pageId); } catch (SiteNotFoundException) { $site = new NullSite(); } $siteLanguages = $site->getAvailableLanguages($this->getBackendUserAuthentication(), true); if (!isset($siteLanguages[0])) { $siteLanguages[0] = $site->getDefaultLanguage(); } $allSystemLanguages = $this->addSiteLanguagesToConsolidatedList( $allSystemLanguages, $siteLanguages, $site, false ); } ksort($allSystemLanguages); $this->runtimeCache->set($cacheKey, $allSystemLanguages); return $allSystemLanguages; } protected function addSiteLanguagesToConsolidatedList(array $allSystemLanguages, array $languagesOfSpecificSite, SiteInterface $site, bool $includeSiteSuffix): array { foreach ($languagesOfSpecificSite as $language) { $languageId = $language->getLanguageId(); if (isset($allSystemLanguages[$languageId])) { // Language already provided by another site, just add the label separately $allSystemLanguages[$languageId]['title'] .= ', ' . $language->getTitle() . ' [Site: ' . $site->getIdentifier() . ']'; } else { $allSystemLanguages[$languageId] = [ 'uid' => $languageId, 'title' => $language->getTitle() . ($includeSiteSuffix ? ' [Site: ' . $site->getIdentifier() . ']' : ''), 'flagIcon' => $language->getFlagIdentifier(), ]; } } return $allSystemLanguages; } /** * Information about translation for an element * Will overlay workspace version of record too! * * @param string $table Table name * @param int $uid Record uid * @param int $languageUid Language uid. If 0, then all languages are selected. * @param array|null $row The record to be translated * @param array|string $selFieldList Select fields for the query which fetches the translations of the current record * @return array|string Array with information or error message as a string. */ public function translationInfo($table, $uid, $languageUid = 0, ?array $row = null, $selFieldList = ''): array|string { if (!$GLOBALS['TCA'][$table] || !$uid) { return 'No table "' . $table . '" or no UID value'; } if ($row === null) { $row = BackendUtility::getRecordWSOL($table, $uid); } if (!is_array($row)) { return 'Record "' . $table . '_' . $uid . '" was not found'; } if (!BackendUtility::isTableLocalizable($table)) { return 'Translation is not supported for this table!'; } if ($row[$GLOBALS['TCA'][$table]['ctrl']['languageField']] > 0) { return 'Record "' . $table . '_' . $uid . '" seems to be a translation already (has a language value "' . $row[$GLOBALS['TCA'][$table]['ctrl']['languageField']] . '", relation to record "' . $row[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']] . '")'; } if ($row[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']] != 0) { return 'Record "' . $table . '_' . $uid . '" seems to be a translation already (has a relation to record "' . $row[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']] . '")'; } // Look for translations of this record, index by language field value: if (!empty($selFieldList)) { if (is_array($selFieldList)) { $selectFields = $selFieldList; } else { $selectFields = GeneralUtility::trimExplode(',', $selFieldList); } } else { $selectFields = ['uid', $GLOBALS['TCA'][$table]['ctrl']['languageField']]; } $queryBuilder = $this->connectionPool->getQueryBuilderForTable($table); $queryBuilder->getRestrictions() ->removeAll() ->add(GeneralUtility::makeInstance(DeletedRestriction::class)) ->add(GeneralUtility::makeInstance(WorkspaceRestriction::class, $this->getBackendUserAuthentication()->workspace)); $queryBuilder ->select(...$selectFields) ->from($table) ->where( $queryBuilder->expr()->eq( $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'], $queryBuilder->createNamedParameter($uid, Connection::PARAM_INT) ), $queryBuilder->expr()->eq( 'pid', $queryBuilder->createNamedParameter( $row['pid'], Connection::PARAM_INT ) ) ); if (!$languageUid) { $queryBuilder->andWhere( $queryBuilder->expr()->gt( $GLOBALS['TCA'][$table]['ctrl']['languageField'], $queryBuilder->createNamedParameter(0, Connection::PARAM_INT) ) ); } else { $queryBuilder ->andWhere( $queryBuilder->expr()->eq( $GLOBALS['TCA'][$table]['ctrl']['languageField'], $queryBuilder->createNamedParameter($languageUid, Connection::PARAM_INT) ) ); } $translationRecords = $queryBuilder->executeQuery()->fetchAllAssociative(); $translations = []; $translationsErrors = []; foreach ($translationRecords as $translationRecord) { if (!isset($translations[$translationRecord[$GLOBALS['TCA'][$table]['ctrl']['languageField']]])) { $translations[$translationRecord[$GLOBALS['TCA'][$table]['ctrl']['languageField']]] = $translationRecord; } else { $translationsErrors[$translationRecord[$GLOBALS['TCA'][$table]['ctrl']['languageField']]][] = $translationRecord; } } return [ 'table' => $table, 'uid' => $uid, 'CType' => $row['CType'] ?? '', 'sys_language_uid' => $row[$GLOBALS['TCA'][$table]['ctrl']['languageField'] ?? null] ?? null, 'translations' => $translations, 'excessive_translations' => $translationsErrors, ]; } protected function getBackendUserAuthentication(): BackendUserAuthentication { return $GLOBALS['BE_USER']; } }