ot_typo3/ot_templating/Classes/Controller/OtCustomizerController.php

<?php

namespace Opentalent\OtTemplating\Controller;

use Opentalent\OtCore\Controller\SelectedSiteController;
use Opentalent\OtCore\Cache\OtCacheManager;
use Opentalent\OtCore\Website\OtWebsiteRepository;
use Opentalent\OtTemplating\Templating\TemplateRepository;
use PDO;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Extbase\Object\ObjectManager;

/**
 * Controller for the OtCustomizer backend submodule
 *
 * @author olivier.massot
 */
class OtCustomizerController extends SelectedSiteController {

    /**
     * @var \TYPO3\CMS\Core\Database\ConnectionPool
     */
    private $connectionPool;

    public function injectConnectionPool(\TYPO3\CMS\Core\Database\ConnectionPool $connectionPool)
    {
        $this->connectionPool = $connectionPool;
    }

    /**
     * Index action (default action)
     * Displays the customizer page on the backend
     */
    public function indexAction() {
        $this->view->assign('rootPage', $this->currentRootUid);
        $this->view->assign('templates', TemplateRepository::templates);

        $templateRepository = GeneralUtility::makeInstance(ObjectManager::class)->get(TemplateRepository::class);
        $this->view->assign('currentTemplate', $templateRepository->getTemplate($this->currentRootUid));
        $this->view->assign('preferences', $templateRepository->getTemplatePreferences($this->currentRootUid));
    }

    /**
     * A template has been selected, apply the change
     */
    public function selectTemplateAction() {
        $templateKey = $this->request->getArgument('template_key');

        $otWebsiteRepository = GeneralUtility::makeInstance(ObjectManager::class)->get(OtWebsiteRepository::class);
        $website = $otWebsiteRepository->getWebsiteByPageUid($this->currentRootUid);

        // applies the change in the database
        $queryBuilder = $this->connectionPool->getQueryBuilderForTable('pages');
        $queryBuilder->update('ot_websites')
            ->where($queryBuilder->expr()->eq('uid', $website['uid']))
            ->set('template', $templateKey)
            ->execute();

        // Clear the site's cache
        OtCacheManager::clearSiteCache($this->currentRootUid);

        $this->addFlashMessage($this->getLanguageService()->sL(
            'LLL:EXT:ot_templating/Resources/Private/Language/locallang.xlf:theme_updated'
        ));

        $this->forward('index');
    }

    /**
     * Update the site's preferences
     */
    public function updatePreferencesAction() {
        $args = $this->request->getArguments();

        $prefs = TemplateRepository::defaultPreferences;

        if (isset($args['themeColor'])) {
            $prefs['themeColor'] = $args['themeColor'];
        }
        if (isset($args['displayCarousel'])) {
            $prefs['displayCarousel'] = $args['displayCarousel'] ? 1 : 0;
        }
        if (isset($args['displayBreadcrumb'])) {
            $prefs['displayBreadcrumb'] = $args['displayBreadcrumb'] ? 1 : 0;
        }

        // applies the change in the database
        $otWebsiteRepository = GeneralUtility::makeInstance(ObjectManager::class)->get(OtWebsiteRepository::class);
        $website = $otWebsiteRepository->getWebsiteByPageUid($this->currentRootUid);

        $queryBuilder = $this->connectionPool->getQueryBuilderForTable('ot_websites');
        $queryBuilder->update('ot_websites')
            ->where($queryBuilder->expr()->eq('uid', $website['uid']))
            ->set('template_preferences', json_encode($prefs))
            ->execute();

        // Clear the site's cache
        OtCacheManager::clearSiteCache($this->currentRootUid);

        $this->addFlashMessage($this->getLanguageService()->sL(
            'LLL:EXT:ot_templating/Resources/Private/Language/locallang.xlf:settings_updated'
        ));

        $this->forward(
            'index',
            'OtCustomizer',
            'OtTemplating'
        );
    }
}