/** * Queries the database for the page record and returns it. * * @param int $uid Page id * @throws \RuntimeException * @return array */ protected function getRecordArray($uid) { $currentCacheIdentifier = $this->getCacheIdentifier($uid); if (!isset(self::$pageRecordCache[$currentCacheIdentifier])) { $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('pages'); $queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class)); $row = $queryBuilder->select(...self::$rootlineFields)->from('pages')->where($queryBuilder->expr()->eq('uid', $queryBuilder->createNamedParameter($uid, \PDO::PARAM_INT)), $queryBuilder->expr()->neq('doktype', $queryBuilder->createNamedParameter(PageRepository::DOKTYPE_RECYCLER, \PDO::PARAM_INT)))->execute()->fetch(); if (empty($row)) { throw new \RuntimeException('Could not fetch page data for uid ' . $uid . '.', 1343589451); } $this->pageContext->versionOL('pages', $row, false, true); $this->pageContext->fixVersioningPid('pages', $row); if (is_array($row)) { if ($this->languageUid > 0) { $row = $this->pageContext->getPageOverlay($row, $this->languageUid); } $row = $this->enrichWithRelationFields(isset($row['_PAGES_OVERLAY_UID']) ? $row['_PAGES_OVERLAY_UID'] : $uid, $row); self::$pageRecordCache[$currentCacheIdentifier] = $row; } } if (!is_array(self::$pageRecordCache[$currentCacheIdentifier])) { throw new \RuntimeException('Broken rootline. Could not resolve page with uid ' . $uid . '.', 1343464101); } return self::$pageRecordCache[$currentCacheIdentifier]; }
/** * Queries the database for the page record and returns it. * * @param integer $uid Page id * @throws \RuntimeException * @return array */ protected function getRecordArray($uid) { if (!isset(self::$pageRecordCache[$this->getCacheIdentifier($uid)])) { if (!is_array($GLOBALS['TCA']['pages']['columns'])) { if (isset($GLOBALS['TSFE'])) { $GLOBALS['TSFE']->includeTCA($GLOBALS['TSFE']->TCAloaded); } \TYPO3\CMS\Core\Utility\GeneralUtility::loadTCA('pages'); } $row = $GLOBALS['TYPO3_DB']->exec_SELECTgetSingleRow(implode(',', self::$rootlineFields), 'pages', 'uid = ' . intval($uid) . ' AND pages.deleted = 0 AND pages.doktype <> ' . \TYPO3\CMS\Frontend\Page\PageRepository::DOKTYPE_RECYCLER); if (empty($row)) { throw new \RuntimeException('Could not fetch page data for uid ' . $uid . '.', 1343589451); } $this->pageContext->versionOL('pages', $row, FALSE, TRUE); $this->pageContext->fixVersioningPid('pages', $row); if (is_array($row)) { $this->pageContext->getPageOverlay($row, $this->languageUid); $row = $this->enrichWithRelationFields($uid, $row); self::$pageRecordCache[$this->getCacheIdentifier($uid)] = $row; } } if (!is_array(self::$pageRecordCache[$this->getCacheIdentifier($uid)])) { throw new \RuntimeException('Broken rootline. Could not resolve page with uid ' . $uid . '.', 1343464101); } return self::$pageRecordCache[$this->getCacheIdentifier($uid)]; }
/** * Queries the database for the page record and returns it. * * @param int $uid Page id * @throws \RuntimeException * @return array */ protected function getRecordArray($uid) { $currentCacheIdentifier = $this->getCacheIdentifier($uid); if (!isset(self::$pageRecordCache[$currentCacheIdentifier])) { $row = $this->databaseConnection->exec_SELECTgetSingleRow(implode(',', self::$rootlineFields), 'pages', 'uid = ' . (int) $uid . ' AND pages.deleted = 0 AND pages.doktype <> ' . PageRepository::DOKTYPE_RECYCLER); if (empty($row)) { throw new \RuntimeException('Could not fetch page data for uid ' . $uid . '.', 1343589451); } $this->pageContext->versionOL('pages', $row, false, true); $this->pageContext->fixVersioningPid('pages', $row); if (is_array($row)) { if ($this->languageUid > 0) { $row = $this->pageContext->getPageOverlay($row, $this->languageUid); } $row = $this->enrichWithRelationFields(isset($row['_PAGES_OVERLAY_UID']) ? $row['_PAGES_OVERLAY_UID'] : $uid, $row); self::$pageRecordCache[$currentCacheIdentifier] = $row; } } if (!is_array(self::$pageRecordCache[$currentCacheIdentifier])) { throw new \RuntimeException('Broken rootline. Could not resolve page with uid ' . $uid . '.', 1343464101); } return self::$pageRecordCache[$currentCacheIdentifier]; }
/** * Generates a list of content objects with sectionIndex enabled * available on a specific page * * Used for menus with sectionIndex enabled * * @param string $altSortField Alternative sorting field * @param integer $pid The page id to search for sections * @throws UnexpectedValueException if the query to fetch the content elements unexpectedly fails * @return array */ protected function sectionIndex($altSortField, $pid = NULL) { $pid = (int) ($pid ?: $this->id); $basePageRow = $this->sys_page->getPage($pid); if (!is_array($basePageRow)) { return array(); } $configuration = $this->mconf['sectionIndex.']; $useColPos = 0; if (trim($configuration['useColPos']) !== '' || is_array($configuration['useColPos.'])) { $useColPos = $GLOBALS['TSFE']->cObj->stdWrap($configuration['useColPos'], $configuration['useColPos.']); $useColPos = (int) $useColPos; } $selectSetup = array('pidInList' => $pid, 'orderBy' => $altSortField, 'languageField' => 'sys_language_uid', 'where' => $useColPos >= 0 ? 'colPos=' . $useColPos : ''); if ($basePageRow['content_from_pid']) { // If the page is configured to show content from a referenced page the sectionIndex contains only contents of // the referenced page $selectSetup['pidInList'] = $basePageRow['content_from_pid']; } $resource = $this->parent_cObj->exec_getQuery('tt_content', $selectSetup); if (!$resource) { $message = 'SectionIndex: Query to fetch the content elements failed!'; throw new \UnexpectedValueException($message, 1337334849); } $result = array(); while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($resource)) { $this->sys_page->versionOL('tt_content', $row); if ($GLOBALS['TSFE']->sys_language_contentOL && $basePageRow['_PAGES_OVERLAY_LANGUAGE']) { $row = $this->sys_page->getRecordOverlay('tt_content', $row, $basePageRow['_PAGES_OVERLAY_LANGUAGE'], $GLOBALS['TSFE']->sys_language_contentOL); } if ($this->mconf['sectionIndex.']['type'] !== 'all') { $doIncludeInSectionIndex = $row['sectionIndex'] >= 1; $doHeaderCheck = $this->mconf['sectionIndex.']['type'] === 'header'; $isValidHeader = ((int) $row['header_layout'] !== 100 || !empty($this->mconf['sectionIndex.']['includeHiddenHeaders'])) && trim($row['header']) !== ''; if (!$doIncludeInSectionIndex || $doHeaderCheck && !$isValidHeader) { continue; } } if (is_array($row)) { $uid = $row['uid']; $result[$uid] = $basePageRow; $result[$uid]['title'] = $row['header']; $result[$uid]['nav_title'] = $row['header']; $result[$uid]['subtitle'] = $row['subheader']; $result[$uid]['starttime'] = $row['starttime']; $result[$uid]['endtime'] = $row['endtime']; $result[$uid]['fe_group'] = $row['fe_group']; $result[$uid]['media'] = $row['media']; $result[$uid]['header_layout'] = $row['header_layout']; $result[$uid]['bodytext'] = $row['bodytext']; $result[$uid]['image'] = $row['image']; $result[$uid]['sectionIndex_uid'] = $uid; } } $GLOBALS['TYPO3_DB']->sql_free_result($resource); return $result; }
/** * Generates a list of content objects with sectionIndex enabled * available on a specific page * * Used for menus with sectionIndex enabled * * @param string $altSortField Alternative sorting field * @param int $pid The page id to search for sections * @throws \UnexpectedValueException if the query to fetch the content elements unexpectedly fails * @return array */ protected function sectionIndex($altSortField, $pid = null) { $pid = (int) ($pid ?: $this->id); $basePageRow = $this->sys_page->getPage($pid); if (!is_array($basePageRow)) { return []; } $tsfe = $this->getTypoScriptFrontendController(); $configuration = $this->mconf['sectionIndex.']; $useColPos = 0; if (trim($configuration['useColPos']) !== '' || is_array($configuration['useColPos.'])) { $useColPos = $tsfe->cObj->stdWrap($configuration['useColPos'], $configuration['useColPos.']); $useColPos = (int) $useColPos; } $selectSetup = ['pidInList' => $pid, 'orderBy' => $altSortField, 'languageField' => 'sys_language_uid', 'where' => $useColPos >= 0 ? 'colPos=' . $useColPos : '']; if ($basePageRow['content_from_pid']) { // If the page is configured to show content from a referenced page the sectionIndex contains only contents of // the referenced page $selectSetup['pidInList'] = $basePageRow['content_from_pid']; } $statement = $this->parent_cObj->exec_getQuery('tt_content', $selectSetup); if (!$statement) { $message = 'SectionIndex: Query to fetch the content elements failed!'; throw new \UnexpectedValueException($message, 1337334849); } $result = []; while ($row = $statement->fetch()) { $this->sys_page->versionOL('tt_content', $row); if ($tsfe->sys_language_contentOL && $basePageRow['_PAGES_OVERLAY_LANGUAGE']) { $row = $this->sys_page->getRecordOverlay('tt_content', $row, $basePageRow['_PAGES_OVERLAY_LANGUAGE'], $tsfe->sys_language_contentOL); } if ($this->mconf['sectionIndex.']['type'] !== 'all') { $doIncludeInSectionIndex = $row['sectionIndex'] >= 1; $doHeaderCheck = $this->mconf['sectionIndex.']['type'] === 'header'; $isValidHeader = ((int) $row['header_layout'] !== 100 || !empty($this->mconf['sectionIndex.']['includeHiddenHeaders'])) && trim($row['header']) !== ''; if (!$doIncludeInSectionIndex || $doHeaderCheck && !$isValidHeader) { continue; } } if (is_array($row)) { $uid = $row['uid']; $result[$uid] = $basePageRow; $result[$uid]['title'] = $row['header']; $result[$uid]['nav_title'] = $row['header']; // Prevent false exclusion in filterMenuPages, thus: Always show tt_content records $result[$uid]['nav_hide'] = 0; $result[$uid]['subtitle'] = $row['subheader']; $result[$uid]['starttime'] = $row['starttime']; $result[$uid]['endtime'] = $row['endtime']; $result[$uid]['fe_group'] = $row['fe_group']; $result[$uid]['media'] = $row['media']; $result[$uid]['header_layout'] = $row['header_layout']; $result[$uid]['bodytext'] = $row['bodytext']; $result[$uid]['image'] = $row['image']; $result[$uid]['sectionIndex_uid'] = $uid; } } return $result; }