data; $pageUid = $page['uid']; if ((int) $page['tx_eptheme_slides'] === 0) { $pageUid = $this->getParentPageWithSlides(); } if ($pageUid === null) { return $processedData; } $qb = $this->getDbConnection()->createQueryBuilder(); $query = $qb ->select('uid', 'headline', 'subline', 'button', 'page_uid', 'skipass') ->from('tx_eptheme_domain_model_slide') ->where('page = :pageUid') ->andWhere('deleted = 0') ->andWhere('hidden = 0') ->orderBy('sorting') ->setParameter('pageUid', $pageUid) ; $slides = $query->executeQuery()->fetchAllAssociative(); if ($slides) { $fileRepository = GeneralUtility::makeInstance(FileRepository::class); foreach ($slides as $slide) { $processedData['slides'][$slide['uid']] = $slide; $processedData['slides'][$slide['uid']]['image'] = $fileRepository->findByRelation( 'tx_eptheme_domain_model_slide', 'images', $slide['uid'] ); } } if (1 === count($slides)) { $processedData['slide'] = reset($processedData['slides']); } return $processedData; } private function getParentPageWithSlides(): ?int { $rootlineUtility = new RootlineUtility($GLOBALS['TYPO3_REQUEST']->getAttribute('frontend.page.information')->getId()); $rootline = $rootlineUtility->get(); foreach ($rootline as $parentPage) { if ((int) $parentPage['tx_eptheme_slides'] > 0) { return (int) $parentPage['uid']; } } return null; } }