fabarea / vidi

Classes/Grid/VisibilityRenderer.php

Indentation +78 added lines, -78 removed lines

@@ -21,83 +21,83 @@
 class VisibilityRenderer extends ColumnRendererAbstract
 {
 
-    /**
-     * Render visibility for the Grid.
-     *
-     * @return string
-     */
-    public function render()
-    {
-
-        $output = '';
-        $hiddenField = Tca::table()->getHiddenField();
-
-        if ($hiddenField) {
-
-            $spriteName = $this->object[$hiddenField] ? 'actions-edit-unhide' : 'actions-edit-hide';
-
-            $label = $this->object[$hiddenField] ? 'unHide' : 'hide';
-
-            $output = $this->makeLinkButton()
-                ->setHref($this->getEditUri($this->object))
-                ->setClasses('btn-visibility-toggle')
-                ->setDataAttributes([
-                    'toggle' => 'tooltip',
-                ])
-                ->setTitle($this->getLabelService()->sL('LLL:EXT:lang/Resources/Private/Language/locallang_mod_web_list.xlf:' . $label))
-                ->setIcon($this->getIconFactory()->getIcon($spriteName, Icon::SIZE_SMALL))
-                ->render();
-        }
-        return $output;
-    }
-
-    /**
-     * @param Content $object
-     * @return string
-     */
-    protected function getEditUri(Content $object)
-    {
-        $hiddenField = Tca::table()->getHiddenField();
-
-        $additionalParameters = array(
-            $this->getModuleLoader()->getParameterPrefix() => [
-                'controller' => 'Content',
-                'action' => 'update',
-                'format' => 'json',
-                'fieldNameAndPath' => Tca::table()->getHiddenField(),
-                'matches' => [
-                    'uid' => $object->getUid(),
-                ],
-                'content' => [$hiddenField => (int)!$this->object[$hiddenField]],
-            ],
-        );
-
-        return $this->getModuleLoader()->getModuleUrl($additionalParameters);
-    }
-
-    /**
-     * @return LinkButton
-     */
-    protected function makeLinkButton()
-    {
-        return GeneralUtility::makeInstance(LinkButton::class);
-    }
-
-
-    /**
-     * @return IconFactory
-     */
-    protected function getIconFactory()
-    {
-        return GeneralUtility::makeInstance(IconFactory::class);
-    }
-
-    /**
-     * @return LanguageService
-     */
-    protected function getLabelService()
-    {
-        return $GLOBALS['LANG'];
-    }
+	/**
+	 * Render visibility for the Grid.
+	 *
+	 * @return string
+	 */
+	public function render()
+	{
+
+		$output = '';
+		$hiddenField = Tca::table()->getHiddenField();
+
+		if ($hiddenField) {
+
+			$spriteName = $this->object[$hiddenField] ? 'actions-edit-unhide' : 'actions-edit-hide';
+
+			$label = $this->object[$hiddenField] ? 'unHide' : 'hide';
+
+			$output = $this->makeLinkButton()
+				->setHref($this->getEditUri($this->object))
+				->setClasses('btn-visibility-toggle')
+				->setDataAttributes([
+					'toggle' => 'tooltip',
+				])
+				->setTitle($this->getLabelService()->sL('LLL:EXT:lang/Resources/Private/Language/locallang_mod_web_list.xlf:' . $label))
+				->setIcon($this->getIconFactory()->getIcon($spriteName, Icon::SIZE_SMALL))
+				->render();
+		}
+		return $output;
+	}
+
+	/**
+	 * @param Content $object
+	 * @return string
+	 */
+	protected function getEditUri(Content $object)
+	{
+		$hiddenField = Tca::table()->getHiddenField();
+
+		$additionalParameters = array(
+			$this->getModuleLoader()->getParameterPrefix() => [
+				'controller' => 'Content',
+				'action' => 'update',
+				'format' => 'json',
+				'fieldNameAndPath' => Tca::table()->getHiddenField(),
+				'matches' => [
+					'uid' => $object->getUid(),
+				],
+				'content' => [$hiddenField => (int)!$this->object[$hiddenField]],
+			],
+		);
+
+		return $this->getModuleLoader()->getModuleUrl($additionalParameters);
+	}
+
+	/**
+	 * @return LinkButton
+	 */
+	protected function makeLinkButton()
+	{
+		return GeneralUtility::makeInstance(LinkButton::class);
+	}
+
+
+	/**
+	 * @return IconFactory
+	 */
+	protected function getIconFactory()
+	{
+		return GeneralUtility::makeInstance(IconFactory::class);
+	}
+
+	/**
+	 * @return LanguageService
+	 */
+	protected function getLabelService()
+	{
+		return $GLOBALS['LANG'];
+	}
 
 }

Spacing +1 added lines, -1 removed lines

@@ -44,7 +44,7 @@
                 ->setDataAttributes([
                     'toggle' => 'tooltip',
                 ])
-                ->setTitle($this->getLabelService()->sL('LLL:EXT:lang/Resources/Private/Language/locallang_mod_web_list.xlf:' . $label))
+                ->setTitle($this->getLabelService()->sL('LLL:EXT:lang/Resources/Private/Language/locallang_mod_web_list.xlf:'.$label))
                 ->setIcon($this->getIconFactory()->getIcon($spriteName, Icon::SIZE_SMALL))
                 ->render();
         }

Classes/Module/ModuleLoader.php

Indentation +999 added lines, -999 removed lines

@@ -37,1004 +37,1004 @@
 class ModuleLoader
 {
 
-    /**
-     * Define the default main module
-     */
-    const DEFAULT_MAIN_MODULE = 'content';
-
-    /**
-     * Define the default pid
-     */
-    const DEFAULT_PID = 0;
-
-    /**
-     * The type of data being listed (which corresponds to a table name in TCA)
-     *
-     * @var string
-     */
-    protected $dataType;
-
-    /**
-     * @var string
-     */
-    protected $defaultPid;
-
-    /**
-     * @var bool
-     */
-    protected $isPidIgnored = false;
-
-    /**
-     * @var bool
-     */
-    protected $showPageTree = false;
-
-    /**
-     * @var bool
-     */
-    protected $isShown = true;
-
-    /**
-     * @var string
-     */
-    protected $access;
-
-    /**
-     * @var string
-     */
-    protected $mainModule;
-
-    /**
-     * @var string
-     */
-    protected $position = '';
-
-    /**
-     * @var string
-     */
-    protected $icon;
-
-    /**
-     * @var string
-     */
-    protected $moduleLanguageFile;
-
-    /**
-     * The module key such as m1, m2.
-     *
-     * @var string
-     */
-    protected $moduleKey = 'm1';
-
-    /**
-     * @var string[]
-     */
-    protected $additionalJavaScriptFiles = [];
-
-    /**
-     * @var string[]
-     */
-    protected $additionalStyleSheetFiles = [];
-
-    /**
-     * @var array
-     */
-    protected $components = [];
-
-    /**
-     * @param string $dataType
-     */
-    public function __construct($dataType = null)
-    {
-        $this->dataType = $dataType;
-
-        // Initialize components
-        $this->components = [
-            ModulePosition::DOC_HEADER => [
-                ModulePosition::TOP => [
-                    ModulePosition::LEFT => [],
-                    ModulePosition::RIGHT => [
-                        ToolButton::class,
-                    ],
-                ],
-                ModulePosition::BOTTOM => [
-                    ModulePosition::LEFT => [
-                        NewButton::class,
-                        BackViewHelper::class,
-                    ],
-                    ModulePosition::RIGHT => [],
-                ],
-            ],
-            ModulePosition::GRID => [
-                ModulePosition::TOP => [
-                    RelationsCheck::class,
-                    #\Fab\Vidi\View\Tab\DataTypeTab::class,
-                ],
-                ModulePosition::BUTTONS => [
-                    EditButton::class,
-                    DeleteButton::class,
-                ],
-                ModulePosition::BOTTOM => [],
-            ],
-            ModulePosition::MENU_MASS_ACTION => [
-                ExportXlsMenuItem::class,
-                ExportXmlMenuItem::class,
-                ExportCsvMenuItem::class,
-                DividerMenuItem::class,
-                MassDeleteMenuItem::class,
-                #\Fab\Vidi\View\MenuItem\MassEditMenuItem::class,
-            ],
-        ];
-    }
-
-    /**
-     * Tell whether a module is already registered.
-     *
-     * @param string $dataType
-     * @return bool
-     */
-    public function isRegistered($dataType): bool
-    {
-        $internalModuleSignature = $this->getInternalModuleSignature($dataType);
-        return !empty($GLOBALS['TBE_MODULES_EXT']['vidi'][$internalModuleSignature]);
-    }
-
-    /**
-     * @return array
-     */
-    protected function getExistingInternalConfiguration(): array
-    {
-        $internalModuleSignature = $this->getInternalModuleSignature();
-        return $GLOBALS['TBE_MODULES_EXT']['vidi'][$internalModuleSignature] ?? [];
-    }
-
-    /**
-     * @return array
-     */
-    protected function getExistingMainConfiguration(): array
-    {
-        $moduleSignature = $this->computeMainModule() . '_' . $this->getInternalModuleSignature();
-        return $GLOBALS['TBE_MODULES']['_configuration'][$moduleSignature] ?? [];
-    }
-
-    /**
-     * @return string
-     */
-    protected function computeMainModule(): string
-    {
-        $existingConfiguration = $this->getExistingInternalConfiguration();
-
-        if ($this->mainModule !== null) {
-            $mainModule = $this->mainModule;
-        } elseif (!empty($existingConfiguration['mainModule'])) { // existing configuration may override.
-            $mainModule = $existingConfiguration['mainModule'];
-        } else {
-            $mainModule = self::DEFAULT_MAIN_MODULE; //default value.
-        }
-        return $mainModule;
-    }
-
-    /**
-     * @return string
-     */
-    protected function computeDefaultPid(): string
-    {
-        $existingConfiguration = $this->getExistingInternalConfiguration();
-
-        if ($this->defaultPid !== null) {
-            $defaultPid = $this->defaultPid;
-        } elseif (!empty($existingConfiguration['defaultPid'])) { // existing configuration may override.
-            $defaultPid = $existingConfiguration['defaultPid'];
-        } else {
-            $defaultPid = self::DEFAULT_PID; //default value.
-        }
-        return $defaultPid;
-    }
-
-    /**
-     * @return array
-     */
-    protected function computeAdditionalJavaScriptFiles(): array
-    {
-        $additionalJavaScriptFiles = $this->additionalJavaScriptFiles;
-
-        // Possible merge of existing javascript files.
-        $existingConfiguration = $this->getExistingInternalConfiguration();
-        if (!empty($existingConfiguration['additionalJavaScriptFiles'])) {
-            $additionalJavaScriptFiles = array_merge($additionalJavaScriptFiles, $existingConfiguration['additionalJavaScriptFiles']);
-        }
-
-        return $additionalJavaScriptFiles;
-    }
-
-    /**
-     * @return array
-     */
-    protected function computeAdditionalStyleSheetFiles(): array
-    {
-        $additionalStyleSheetFiles = $this->additionalStyleSheetFiles;
-
-        // Possible merge of existing style sheets.
-        $existingConfiguration = $this->getExistingInternalConfiguration();
-        if (!empty($existingConfiguration['additionalStyleSheetFiles'])) {
-            $additionalStyleSheetFiles = array_merge($additionalStyleSheetFiles, $existingConfiguration['additionalStyleSheetFiles']);
-        }
-
-        return $additionalStyleSheetFiles;
-    }
-
-    /**
-     * @return array
-     */
-    protected function computeComponents(): array
-    {
-        // We override the config in any case. See if we need more than that.
-        return $this->components;
-    }
-
-    /**
-     * Register the module in two places: core + vidi internal.
-     *
-     * @return $this
-     */
-    public function register(): self
-    {
-        // Internal Vidi module registration.
-        $configuration = [];
-        $configuration['dataType'] = $this->dataType;
-        $configuration['mainModule'] = $this->computeMainModule();
-        $configuration['defaultPid'] = $this->computeDefaultPid();
-        $configuration['additionalJavaScriptFiles'] = $this->computeAdditionalJavaScriptFiles();
-        $configuration['additionalStyleSheetFiles'] = $this->computeAdditionalStyleSheetFiles();
-        $configuration['components'] = $this->computeComponents();
-        $configuration['isPidIgnored'] = $this->isPidIgnored;
-
-        $internalModuleSignature = $this->getInternalModuleSignature();
-        $GLOBALS['TBE_MODULES_EXT']['vidi'][$internalModuleSignature] = $configuration;
-
-        // Core module registration.
-        // Register and displays module in the BE only if told, default is "true".
-        if ($this->isShown) {
-
-            $moduleConfiguration = [];
-            #$moduleConfiguration['routeTarget'] = \Fab\Vidi\Controller\ContentController::class . '::mainAction', // what to do here?
-            $moduleConfiguration['access'] = $this->getAccess();
-            $moduleConfiguration['labels'] = $this->getModuleLanguageFile();
-            $icon = $this->getIcon();
-            if ($icon) {
-                $moduleConfiguration['icon'] = $icon;
-            }
-
-            if ($this->showPageTree) {
-                $moduleConfiguration['navigationComponentId'] = 'TYPO3/CMS/Backend/PageTree/PageTreeElement';
-                $moduleConfiguration['inheritNavigationComponentFromMainModule'] = true;
-            } else {
-                $moduleConfiguration['inheritNavigationComponentFromMainModule'] = true;
-            }
-
-            ExtensionUtility::registerModule(
-                'Fab.vidi',
-                $this->computeMainModule(),
-                $this->dataType . '_' . $this->moduleKey,
-                $this->position,
-                [
-                    ContentController::class => 'index, list, delete, update, edit, copy, move, localize, sort, copyClipboard, moveClipboard',
-                    ToolController::class => 'welcome, work',
-                    FacetController::class => 'autoSuggest, autoSuggests',
-                    SelectionController::class => 'edit, update, create, delete, list, show',
-                    UserPreferencesController::class => 'save',
-                    ClipboardController::class => 'save, flush, show',
-                ],
-                $moduleConfiguration
-            );
-        }
-        return $this;
-    }
-
-    /**
-     * Return the module code for a BE module.
-     *
-     * @return string
-     */
-    public function getSignature(): string
-    {
-        $signature = GeneralUtility::_GP(Parameter::MODULE);
-        $trimmedSignature = trim($signature, '/');
-        return str_replace(['/', 'module_'], ['_', ''], $trimmedSignature);
-    }
-
-    /**
-     * Returns the current pid.
-     *
-     * @return int
-     */
-    public function getCurrentPid(): int
-    {
-        return GeneralUtility::_GET(Parameter::PID) > 0 ? (int)GeneralUtility::_GET(Parameter::PID) : 0;
-    }
-
-    /**
-     * Return the module URL.
-     *
-     * @param array $additionalParameters
-     * @return string
-     */
-    public function getModuleUrl(array $additionalParameters = []): string
-    {
-        $moduleCode = $this->getSignature();
-
-        // And don't forget the pid!
-        if (GeneralUtility::_GET(Parameter::PID)) {
-            $additionalParameters[Parameter::PID] = GeneralUtility::_GET(Parameter::PID);
-        }
-
-        return BackendUtility::getModuleUrl($moduleCode, $additionalParameters);
-    }
-
-    /**
-     * Return the parameter prefix for a BE module.
-     *
-     * @return string
-     */
-    public function getParameterPrefix(): string
-    {
-        return 'tx_vidi_' . strtolower($this->getSignature());
-    }
-
-    /**
-     * Return a configuration key or the entire module configuration array if not key is given.
-     *
-     * @param string $key
-     * @return mixed
-     */
-    public function getModuleConfiguration($key = '')
-    {
-
-        $vidiModuleCode = $this->getSignature();
-
-        // Module code must exist
-        if (empty($GLOBALS['TBE_MODULES_EXT']['vidi'][$vidiModuleCode])) {
-            $message = sprintf('Invalid or not existing module code "%s"', $vidiModuleCode);
-            throw new InvalidKeyInArrayException($message, 1375092053);
-        }
-
-        $result = $GLOBALS['TBE_MODULES_EXT']['vidi'][$vidiModuleCode];
-
-        if (!empty($key)) {
-            if (isset($result[$key])) {
-                $result = $result[$key];
-            } else {
-                // key must exist
-                $message = sprintf('Invalid key configuration "%s"', $key);
-                throw new InvalidKeyInArrayException($message, 1375092054);
-            }
-        }
-        return $result;
-    }
-
-    /**
-     * @param string $icon
-     * @return $this
-     */
-    public function setIcon($icon): self
-    {
-        $this->icon = $icon;
-        return $this;
-    }
-
-    /**
-     * @return string
-     */
-    protected function getIcon(): string
-    {
-        $moduleConfiguration = $this->getExistingMainConfiguration();
-
-
-        if ($this->icon) {
-            $icon = $this->icon;
-        } elseif ($moduleConfiguration['icon']) { // existing configuration may override.
-            $icon = $moduleConfiguration['icon'];
-        } else {
-            $icon = ''; //default value.
-        }
-
-        return $icon;
-    }
-
-    /**
-     * @param string $mainModule
-     * @return $this
-     */
-    public function setMainModule($mainModule): self
-    {
-        $this->mainModule = $mainModule;
-        return $this;
-    }
-
-    /**
-     * @return string
-     */
-    public function getMainModule(): string
-    {
-        if ($this->mainModule === null) {
-            $this->mainModule = $this->getModuleConfiguration('mainModule');
-        }
-        return $this->mainModule;
-    }
-
-    /**
-     * @param string $moduleLanguageFile
-     * @return $this
-     */
-    public function setModuleLanguageFile($moduleLanguageFile): self
-    {
-        $this->moduleLanguageFile = $moduleLanguageFile;
-        return $this;
-    }
-
-    /**
-     * @param string $component
-     * @return $this
-     */
-    public function removeComponentFromDocHeader(string $component): self
-    {
-        foreach ($this->components[ModulePosition::DOC_HEADER] as $verticalPosition => $docHeaders) {
-            foreach ($docHeaders as $horizontalPosition => $docHeader) {
-
-                $index = array_search($component, $docHeader, true);
-                if ($index !== false) {
-                    // $verticalPosition: top or bottom
-                    // $horizontalPosition: left or right
-                    unset($this->components[ModulePosition::DOC_HEADER][$verticalPosition][$horizontalPosition][$index]);
-                }
-            }
-        }
-        return $this;
-    }
-
-    /**
-     * @param bool $isPidIgnored
-     * @return $this
-     */
-    public function ignorePid(bool $isPidIgnored): self
-    {
-        $this->isPidIgnored = $isPidIgnored;
-        return $this;
-    }
-
-    /**
-     * @return bool
-     */
-    public function isPidIgnored(): bool
-    {
-        return $this->getModuleConfiguration('isPidIgnored');
-    }
-
-    /**
-     * @param string $component
-     * @return bool
-     */
-    public function hasComponentInDocHeader(string $component): bool
-    {
-        foreach ($this->getModuleConfiguration('components')[ModulePosition::DOC_HEADER] as $verticalPosition => $docHeaders) {
-            foreach ($docHeaders as $horizontalPosition => $docHeader) {
-
-                $index = array_search($component, $docHeader, true);
-                if ($index !== false) {
-                    return true;
-                }
-            }
-        }
-        return false;
-    }
-
-    /**
-     * @return string
-     */
-    protected function getModuleLanguageFile(): string
-    {
-        $moduleConfiguration = $this->getExistingMainConfiguration();
-
-        if ($this->moduleLanguageFile) {
-            $moduleLanguageFile = $this->moduleLanguageFile;
-        } elseif ($moduleConfiguration['labels']) { // existing configuration may override.
-            $moduleLanguageFile = $moduleConfiguration['labels'];
-        } else {
-            $moduleLanguageFile = ''; //default value.
-        }
-
-        return $moduleLanguageFile;
-    }
-
-    /**
-     * @param string $position
-     * @return $this
-     */
-    public function setPosition($position): self
-    {
-        $this->position = $position;
-        return $this;
-    }
-
-    /**
-     * @return string
-     */
-    public function getPosition(): string
-    {
-        return $this->position;
-    }
-
-    /**
-     * @param array $files
-     * @return $this
-     */
-    public function addJavaScriptFiles(array $files): self
-    {
-        foreach ($files as $file) {
-            $this->additionalJavaScriptFiles[] = $file;
-        }
-        return $this;
-    }
-
-    /**
-     * @param string $fileNameAndPath
-     * @return $this
-     */
-    public function addJavaScriptFile($fileNameAndPath): self
-    {
-        $this->additionalJavaScriptFiles[] = $fileNameAndPath;
-        return $this;
-    }
-
-    /**
-     * @param array $files
-     * @return $this
-     */
-    public function addStyleSheetFiles(array $files): self
-    {
-        foreach ($files as $file) {
-            $this->additionalStyleSheetFiles[] = $file;
-        }
-        return $this;
-    }
-
-    /**
-     * @param string $fileNameAndPath
-     * @return $this
-     */
-    public function addStyleSheetFile($fileNameAndPath): self
-    {
-        $this->additionalStyleSheetFiles[] = $fileNameAndPath;
-        return $this;
-    }
-
-    /**
-     * @return string
-     */
-    public function getDataType(): string
-    {
-        if ($this->dataType === null) {
-            $this->dataType = $this->getModuleConfiguration('dataType');
-        }
-        return $this->dataType;
-    }
-
-    /**
-     * @return array
-     */
-    public function getDataTypes(): array
-    {
-        $dataTypes = [];
-        foreach ($GLOBALS['TBE_MODULES_EXT']['vidi'] as $module) {
-            $dataTypes[] = $module['dataType'];
-        }
-        return $dataTypes;
-    }
-
-    /**
-     * @param string $dataType
-     * @return $this
-     */
-    public function setDataType($dataType): self
-    {
-        $this->dataType = $dataType;
-        return $this;
-    }
-
-    /**
-     * @return int
-     */
-    public function getDefaultPid(): int
-    {
-        if (empty($this->defaultPid)) {
-            $this->defaultPid = $this->getModuleConfiguration('defaultPid');
-        }
-        return (int)$this->defaultPid;
-    }
-
-    /**
-     * @param string $defaultPid
-     * @return $this
-     */
-    public function setDefaultPid($defaultPid): self
-    {
-        $this->defaultPid = $defaultPid;
-        return $this;
-    }
-
-    /**
-     * @param bool $isPageTreeShown
-     * @return $this
-     */
-    public function showPageTree($isPageTreeShown): self
-    {
-        $this->showPageTree = $isPageTreeShown;
-        return $this;
-    }
-
-    /**
-     * @param string $isShown
-     * @return $this
-     */
-    public function isShown($isShown): self
-    {
-        $this->isShown = $isShown;
-        return $this;
-    }
-
-    /**
-     * @return $array
-     */
-    public function getDocHeaderTopLeftComponents()
-    {
-        $configuration = $this->getModuleConfiguration();
-        return $configuration['components'][ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::LEFT];
-    }
-
-    /**
-     * @param array $components
-     * @return $this
-     */
-    public function setDocHeaderTopLeftComponents(array $components): self
-    {
-        $this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::LEFT] = $components;
-        return $this;
-    }
-
-    /**
-     * @param string|array $components
-     * @return $this
-     */
-    public function addDocHeaderTopLeftComponents($components): self
-    {
-        if (is_string($components)) {
-            $components = [$components];
-        }
-        $currentComponents = $this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::LEFT];
-        $this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::LEFT] = array_merge($currentComponents, $components);
-        return $this;
-    }
-
-    /**
-     * @return $array
-     */
-    public function getDocHeaderTopRightComponents()
-    {
-        $configuration = $this->getModuleConfiguration();
-        return $configuration['components'][ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::RIGHT];
-    }
-
-    /**
-     * @param array $components
-     * @return $this
-     */
-    public function setDocHeaderTopRightComponents(array $components): self
-    {
-        $this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::RIGHT] = $components;
-        return $this;
-    }
-
-    /**
-     * @param string|array $components
-     * @return $this
-     */
-    public function addDocHeaderTopRightComponents($components): self
-    {
-        if (is_string($components)) {
-            $components = [$components];
-        }
-        $currentComponents = $this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::RIGHT];
-        $this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::RIGHT] = array_merge($currentComponents, $components);
-        return $this;
-    }
-
-    /**
-     * @return $array
-     */
-    public function getDocHeaderBottomLeftComponents()
-    {
-        $configuration = $this->getModuleConfiguration();
-        return $configuration['components'][ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::LEFT];
-    }
-
-    /**
-     * @param array $components
-     * @return $this
-     */
-    public function setDocHeaderBottomLeftComponents(array $components): self
-    {
-        $this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::LEFT] = $components;
-        return $this;
-    }
-
-    /**
-     * @param string|array $components
-     * @return $this
-     */
-    public function addDocHeaderBottomLeftComponents($components): self
-    {
-        if (is_string($components)) {
-            $components = [$components];
-        }
-        $currentComponents = $this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::LEFT];
-        $this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::LEFT] = array_merge($currentComponents, $components);
-        return $this;
-    }
-
-    /**
-     * @return $array
-     */
-    public function getDocHeaderBottomRightComponents()
-    {
-        $configuration = $this->getModuleConfiguration();
-        return $configuration['components'][ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::RIGHT];
-    }
-
-    /**
-     * @param array $components
-     * @return $this
-     */
-    public function setDocHeaderBottomRightComponents(array $components): self
-    {
-        $this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::RIGHT] = $components;
-        return $this;
-    }
-
-    /**
-     * @param string|array $components
-     * @return $this
-     */
-    public function addDocHeaderBottomRightComponents($components): self
-    {
-        if (is_string($components)) {
-            $components = [$components];
-        }
-        $currentComponents = $this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::RIGHT];
-        $this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::RIGHT] = array_merge($currentComponents, $components);
-        return $this;
-    }
-
-    /**
-     * @return $array
-     */
-    public function getGridTopComponents()
-    {
-        $configuration = $this->getModuleConfiguration();
-        return $configuration['components'][ModulePosition::GRID][ModulePosition::TOP];
-    }
-
-    /**
-     * @param array $components
-     * @return $this
-     */
-    public function setGridTopComponents(array $components): self
-    {
-        $this->components[ModulePosition::GRID][ModulePosition::TOP] = $components;
-        return $this;
-    }
-
-    /**
-     * @param string|array $components
-     * @return $this
-     */
-    public function addGridTopComponents($components): self
-    {
-        if (is_string($components)) {
-            $components = [$components];
-        }
-        $currentComponents = $this->components[ModulePosition::GRID][ModulePosition::TOP];
-        $this->components[ModulePosition::GRID][ModulePosition::TOP] = array_merge($currentComponents, $components);
-        return $this;
-    }
-
-    /**
-     * @return mixed $array
-     */
-    public function getGridBottomComponents()
-    {
-        $configuration = $this->getModuleConfiguration();
-        return $configuration['components'][ModulePosition::GRID][ModulePosition::BOTTOM];
-    }
-
-    /**
-     * @param array $components
-     * @return $this
-     */
-    public function setGridBottomComponents(array $components): self
-    {
-        $this->components[ModulePosition::GRID][ModulePosition::BOTTOM] = $components;
-        return $this;
-    }
-
-    /**
-     * @param string|array $components
-     * @return $this
-     */
-    public function addGridBottomComponents($components): self
-    {
-        if (is_string($components)) {
-            $components = [$components];
-        }
-        $currentComponents = $this->components[ModulePosition::GRID][ModulePosition::BOTTOM];
-        $this->components[ModulePosition::GRID][ModulePosition::BOTTOM] = array_merge($currentComponents, $components);
-        return $this;
-    }
-
-    /**
-     * @return $array
-     */
-    public function getGridButtonsComponents()
-    {
-        $configuration = $this->getModuleConfiguration();
-        return $configuration['components'][ModulePosition::GRID][ModulePosition::BUTTONS];
-    }
-
-    /**
-     * @param array $components
-     * @return $this
-     */
-    public function setGridButtonsComponents(array $components): self
-    {
-        $this->components[ModulePosition::GRID][ModulePosition::BUTTONS] = $components;
-        return $this;
-    }
-
-    /**
-     * @param string|array $components
-     * @return $this
-     */
-    public function addGridButtonsComponents($components): self
-    {
-        if (is_string($components)) {
-            $components = [$components];
-        }
-        $currentComponents = $this->components[ModulePosition::GRID][ModulePosition::BUTTONS];
-        $this->components[ModulePosition::GRID][ModulePosition::BUTTONS] = array_merge($components, $currentComponents);
-        return $this;
-    }
-
-    /**
-     * @return $array
-     */
-    public function getMenuMassActionComponents()
-    {
-        $configuration = $this->getModuleConfiguration();
-        return $configuration['components'][ModulePosition::MENU_MASS_ACTION];
-    }
-
-    /**
-     * @param array $components
-     * @return $this
-     */
-    public function setMenuMassActionComponents(array $components): self
-    {
-        $this->components[ModulePosition::MENU_MASS_ACTION] = $components;
-        return $this;
-    }
-
-    /**
-     * @param string|array $components
-     * @return $this
-     */
-    public function addMenuMassActionComponents($components): self
-    {
-        if (is_string($components)) {
-            $components = [$components];
-        }
-        $currentComponents = $this->components[ModulePosition::MENU_MASS_ACTION];
-        $this->components[ModulePosition::MENU_MASS_ACTION] = array_merge($components, $currentComponents);
-        return $this;
-    }
-
-    /**
-     * @return string
-     */
-    protected function getAccess(): string
-    {
-        $moduleConfiguration = $this->getExistingMainConfiguration();
-
-        if ($this->access !== null) {
-            $access = $this->access;
-        } elseif (!empty($moduleConfiguration['access'])) { // existing configuration may override.
-            $access = $moduleConfiguration['access'];
-        } else {
-            $access = Access::USER; //default value.
-        }
-        return $access;
-    }
-
-    /**
-     * @param string $access
-     * @return $this
-     */
-    public function setAccess($access): self
-    {
-        $this->access = $access;
-        return $this;
-    }
-
-    /**
-     * @return \string[]
-     */
-    public function getAdditionalJavaScriptFiles(): array
-    {
-        if (empty($this->additionalJavaScriptFiles)) {
-            $this->additionalJavaScriptFiles = $this->getModuleConfiguration('additionalJavaScriptFiles');
-        }
-        return $this->additionalJavaScriptFiles;
-    }
-
-    /**
-     * @return \string[]
-     */
-    public function getAdditionalStyleSheetFiles(): array
-    {
-        if (empty($this->additionalStyleSheetFiles)) {
-            $this->additionalStyleSheetFiles = $this->getModuleConfiguration('additionalStyleSheetFiles');
-        }
-        return $this->additionalStyleSheetFiles;
-    }
-
-    /**
-     * @return array
-     */
-    public function getComponents(): array
-    {
-        return $this->components;
-    }
-
-    /**
-     * @param string $pluginName
-     * @return bool
-     */
-    public function hasPlugin($pluginName = ''): bool
-    {
-        $parameterPrefix = $this->getParameterPrefix();
-        $parameters = GeneralUtility::_GET($parameterPrefix);
-
-        $hasPlugin = !empty($parameters['plugins']) && is_array($parameters['plugins']);
-        if ($hasPlugin && $pluginName) {
-            $hasPlugin = in_array($pluginName, $parameters['plugins']);
-        }
-        return $hasPlugin;
-    }
-
-    /**
-     * Compute the internal module code
-     *
-     * @param null|string $dataType
-     * @return string
-     */
-    protected function getInternalModuleSignature($dataType = null): string
-    {
-        // Else we forge the module signature
-        if ($dataType === null) {
-            $dataType = $this->dataType;
-        }
-        $subModuleName = $dataType . '_' . $this->moduleKey;
-
-        $mainModule = $this->mainModule ?: self::DEFAULT_MAIN_MODULE;
-        return $mainModule . '_Vidi' . GeneralUtility::underscoredToUpperCamelCase($subModuleName);
-    }
+	/**
+	 * Define the default main module
+	 */
+	const DEFAULT_MAIN_MODULE = 'content';
+
+	/**
+	 * Define the default pid
+	 */
+	const DEFAULT_PID = 0;
+
+	/**
+	 * The type of data being listed (which corresponds to a table name in TCA)
+	 *
+	 * @var string
+	 */
+	protected $dataType;
+
+	/**
+	 * @var string
+	 */
+	protected $defaultPid;
+
+	/**
+	 * @var bool
+	 */
+	protected $isPidIgnored = false;
+
+	/**
+	 * @var bool
+	 */
+	protected $showPageTree = false;
+
+	/**
+	 * @var bool
+	 */
+	protected $isShown = true;
+
+	/**
+	 * @var string
+	 */
+	protected $access;
+
+	/**
+	 * @var string
+	 */
+	protected $mainModule;
+
+	/**
+	 * @var string
+	 */
+	protected $position = '';
+
+	/**
+	 * @var string
+	 */
+	protected $icon;
+
+	/**
+	 * @var string
+	 */
+	protected $moduleLanguageFile;
+
+	/**
+	 * The module key such as m1, m2.
+	 *
+	 * @var string
+	 */
+	protected $moduleKey = 'm1';
+
+	/**
+	 * @var string[]
+	 */
+	protected $additionalJavaScriptFiles = [];
+
+	/**
+	 * @var string[]
+	 */
+	protected $additionalStyleSheetFiles = [];
+
+	/**
+	 * @var array
+	 */
+	protected $components = [];
+
+	/**
+	 * @param string $dataType
+	 */
+	public function __construct($dataType = null)
+	{
+		$this->dataType = $dataType;
+
+		// Initialize components
+		$this->components = [
+			ModulePosition::DOC_HEADER => [
+				ModulePosition::TOP => [
+					ModulePosition::LEFT => [],
+					ModulePosition::RIGHT => [
+						ToolButton::class,
+					],
+				],
+				ModulePosition::BOTTOM => [
+					ModulePosition::LEFT => [
+						NewButton::class,
+						BackViewHelper::class,
+					],
+					ModulePosition::RIGHT => [],
+				],
+			],
+			ModulePosition::GRID => [
+				ModulePosition::TOP => [
+					RelationsCheck::class,
+					#\Fab\Vidi\View\Tab\DataTypeTab::class,
+				],
+				ModulePosition::BUTTONS => [
+					EditButton::class,
+					DeleteButton::class,
+				],
+				ModulePosition::BOTTOM => [],
+			],
+			ModulePosition::MENU_MASS_ACTION => [
+				ExportXlsMenuItem::class,
+				ExportXmlMenuItem::class,
+				ExportCsvMenuItem::class,
+				DividerMenuItem::class,
+				MassDeleteMenuItem::class,
+				#\Fab\Vidi\View\MenuItem\MassEditMenuItem::class,
+			],
+		];
+	}
+
+	/**
+	 * Tell whether a module is already registered.
+	 *
+	 * @param string $dataType
+	 * @return bool
+	 */
+	public function isRegistered($dataType): bool
+	{
+		$internalModuleSignature = $this->getInternalModuleSignature($dataType);
+		return !empty($GLOBALS['TBE_MODULES_EXT']['vidi'][$internalModuleSignature]);
+	}
+
+	/**
+	 * @return array
+	 */
+	protected function getExistingInternalConfiguration(): array
+	{
+		$internalModuleSignature = $this->getInternalModuleSignature();
+		return $GLOBALS['TBE_MODULES_EXT']['vidi'][$internalModuleSignature] ?? [];
+	}
+
+	/**
+	 * @return array
+	 */
+	protected function getExistingMainConfiguration(): array
+	{
+		$moduleSignature = $this->computeMainModule() . '_' . $this->getInternalModuleSignature();
+		return $GLOBALS['TBE_MODULES']['_configuration'][$moduleSignature] ?? [];
+	}
+
+	/**
+	 * @return string
+	 */
+	protected function computeMainModule(): string
+	{
+		$existingConfiguration = $this->getExistingInternalConfiguration();
+
+		if ($this->mainModule !== null) {
+			$mainModule = $this->mainModule;
+		} elseif (!empty($existingConfiguration['mainModule'])) { // existing configuration may override.
+			$mainModule = $existingConfiguration['mainModule'];
+		} else {
+			$mainModule = self::DEFAULT_MAIN_MODULE; //default value.
+		}
+		return $mainModule;
+	}
+
+	/**
+	 * @return string
+	 */
+	protected function computeDefaultPid(): string
+	{
+		$existingConfiguration = $this->getExistingInternalConfiguration();
+
+		if ($this->defaultPid !== null) {
+			$defaultPid = $this->defaultPid;
+		} elseif (!empty($existingConfiguration['defaultPid'])) { // existing configuration may override.
+			$defaultPid = $existingConfiguration['defaultPid'];
+		} else {
+			$defaultPid = self::DEFAULT_PID; //default value.
+		}
+		return $defaultPid;
+	}
+
+	/**
+	 * @return array
+	 */
+	protected function computeAdditionalJavaScriptFiles(): array
+	{
+		$additionalJavaScriptFiles = $this->additionalJavaScriptFiles;
+
+		// Possible merge of existing javascript files.
+		$existingConfiguration = $this->getExistingInternalConfiguration();
+		if (!empty($existingConfiguration['additionalJavaScriptFiles'])) {
+			$additionalJavaScriptFiles = array_merge($additionalJavaScriptFiles, $existingConfiguration['additionalJavaScriptFiles']);
+		}
+
+		return $additionalJavaScriptFiles;
+	}
+
+	/**
+	 * @return array
+	 */
+	protected function computeAdditionalStyleSheetFiles(): array
+	{
+		$additionalStyleSheetFiles = $this->additionalStyleSheetFiles;
+
+		// Possible merge of existing style sheets.
+		$existingConfiguration = $this->getExistingInternalConfiguration();
+		if (!empty($existingConfiguration['additionalStyleSheetFiles'])) {
+			$additionalStyleSheetFiles = array_merge($additionalStyleSheetFiles, $existingConfiguration['additionalStyleSheetFiles']);
+		}
+
+		return $additionalStyleSheetFiles;
+	}
+
+	/**
+	 * @return array
+	 */
+	protected function computeComponents(): array
+	{
+		// We override the config in any case. See if we need more than that.
+		return $this->components;
+	}
+
+	/**
+	 * Register the module in two places: core + vidi internal.
+	 *
+	 * @return $this
+	 */
+	public function register(): self
+	{
+		// Internal Vidi module registration.
+		$configuration = [];
+		$configuration['dataType'] = $this->dataType;
+		$configuration['mainModule'] = $this->computeMainModule();
+		$configuration['defaultPid'] = $this->computeDefaultPid();
+		$configuration['additionalJavaScriptFiles'] = $this->computeAdditionalJavaScriptFiles();
+		$configuration['additionalStyleSheetFiles'] = $this->computeAdditionalStyleSheetFiles();
+		$configuration['components'] = $this->computeComponents();
+		$configuration['isPidIgnored'] = $this->isPidIgnored;
+
+		$internalModuleSignature = $this->getInternalModuleSignature();
+		$GLOBALS['TBE_MODULES_EXT']['vidi'][$internalModuleSignature] = $configuration;
+
+		// Core module registration.
+		// Register and displays module in the BE only if told, default is "true".
+		if ($this->isShown) {
+
+			$moduleConfiguration = [];
+			#$moduleConfiguration['routeTarget'] = \Fab\Vidi\Controller\ContentController::class . '::mainAction', // what to do here?
+			$moduleConfiguration['access'] = $this->getAccess();
+			$moduleConfiguration['labels'] = $this->getModuleLanguageFile();
+			$icon = $this->getIcon();
+			if ($icon) {
+				$moduleConfiguration['icon'] = $icon;
+			}
+
+			if ($this->showPageTree) {
+				$moduleConfiguration['navigationComponentId'] = 'TYPO3/CMS/Backend/PageTree/PageTreeElement';
+				$moduleConfiguration['inheritNavigationComponentFromMainModule'] = true;
+			} else {
+				$moduleConfiguration['inheritNavigationComponentFromMainModule'] = true;
+			}
+
+			ExtensionUtility::registerModule(
+				'Fab.vidi',
+				$this->computeMainModule(),
+				$this->dataType . '_' . $this->moduleKey,
+				$this->position,
+				[
+					ContentController::class => 'index, list, delete, update, edit, copy, move, localize, sort, copyClipboard, moveClipboard',
+					ToolController::class => 'welcome, work',
+					FacetController::class => 'autoSuggest, autoSuggests',
+					SelectionController::class => 'edit, update, create, delete, list, show',
+					UserPreferencesController::class => 'save',
+					ClipboardController::class => 'save, flush, show',
+				],
+				$moduleConfiguration
+			);
+		}
+		return $this;
+	}
+
+	/**
+	 * Return the module code for a BE module.
+	 *
+	 * @return string
+	 */
+	public function getSignature(): string
+	{
+		$signature = GeneralUtility::_GP(Parameter::MODULE);
+		$trimmedSignature = trim($signature, '/');
+		return str_replace(['/', 'module_'], ['_', ''], $trimmedSignature);
+	}
+
+	/**
+	 * Returns the current pid.
+	 *
+	 * @return int
+	 */
+	public function getCurrentPid(): int
+	{
+		return GeneralUtility::_GET(Parameter::PID) > 0 ? (int)GeneralUtility::_GET(Parameter::PID) : 0;
+	}
+
+	/**
+	 * Return the module URL.
+	 *
+	 * @param array $additionalParameters
+	 * @return string
+	 */
+	public function getModuleUrl(array $additionalParameters = []): string
+	{
+		$moduleCode = $this->getSignature();
+
+		// And don't forget the pid!
+		if (GeneralUtility::_GET(Parameter::PID)) {
+			$additionalParameters[Parameter::PID] = GeneralUtility::_GET(Parameter::PID);
+		}
+
+		return BackendUtility::getModuleUrl($moduleCode, $additionalParameters);
+	}
+
+	/**
+	 * Return the parameter prefix for a BE module.
+	 *
+	 * @return string
+	 */
+	public function getParameterPrefix(): string
+	{
+		return 'tx_vidi_' . strtolower($this->getSignature());
+	}
+
+	/**
+	 * Return a configuration key or the entire module configuration array if not key is given.
+	 *
+	 * @param string $key
+	 * @return mixed
+	 */
+	public function getModuleConfiguration($key = '')
+	{
+
+		$vidiModuleCode = $this->getSignature();
+
+		// Module code must exist
+		if (empty($GLOBALS['TBE_MODULES_EXT']['vidi'][$vidiModuleCode])) {
+			$message = sprintf('Invalid or not existing module code "%s"', $vidiModuleCode);
+			throw new InvalidKeyInArrayException($message, 1375092053);
+		}
+
+		$result = $GLOBALS['TBE_MODULES_EXT']['vidi'][$vidiModuleCode];
+
+		if (!empty($key)) {
+			if (isset($result[$key])) {
+				$result = $result[$key];
+			} else {
+				// key must exist
+				$message = sprintf('Invalid key configuration "%s"', $key);
+				throw new InvalidKeyInArrayException($message, 1375092054);
+			}
+		}
+		return $result;
+	}
+
+	/**
+	 * @param string $icon
+	 * @return $this
+	 */
+	public function setIcon($icon): self
+	{
+		$this->icon = $icon;
+		return $this;
+	}
+
+	/**
+	 * @return string
+	 */
+	protected function getIcon(): string
+	{
+		$moduleConfiguration = $this->getExistingMainConfiguration();
+
+
+		if ($this->icon) {
+			$icon = $this->icon;
+		} elseif ($moduleConfiguration['icon']) { // existing configuration may override.
+			$icon = $moduleConfiguration['icon'];
+		} else {
+			$icon = ''; //default value.
+		}
+
+		return $icon;
+	}
+
+	/**
+	 * @param string $mainModule
+	 * @return $this
+	 */
+	public function setMainModule($mainModule): self
+	{
+		$this->mainModule = $mainModule;
+		return $this;
+	}
+
+	/**
+	 * @return string
+	 */
+	public function getMainModule(): string
+	{
+		if ($this->mainModule === null) {
+			$this->mainModule = $this->getModuleConfiguration('mainModule');
+		}
+		return $this->mainModule;
+	}
+
+	/**
+	 * @param string $moduleLanguageFile
+	 * @return $this
+	 */
+	public function setModuleLanguageFile($moduleLanguageFile): self
+	{
+		$this->moduleLanguageFile = $moduleLanguageFile;
+		return $this;
+	}
+
+	/**
+	 * @param string $component
+	 * @return $this
+	 */
+	public function removeComponentFromDocHeader(string $component): self
+	{
+		foreach ($this->components[ModulePosition::DOC_HEADER] as $verticalPosition => $docHeaders) {
+			foreach ($docHeaders as $horizontalPosition => $docHeader) {
+
+				$index = array_search($component, $docHeader, true);
+				if ($index !== false) {
+					// $verticalPosition: top or bottom
+					// $horizontalPosition: left or right
+					unset($this->components[ModulePosition::DOC_HEADER][$verticalPosition][$horizontalPosition][$index]);
+				}
+			}
+		}
+		return $this;
+	}
+
+	/**
+	 * @param bool $isPidIgnored
+	 * @return $this
+	 */
+	public function ignorePid(bool $isPidIgnored): self
+	{
+		$this->isPidIgnored = $isPidIgnored;
+		return $this;
+	}
+
+	/**
+	 * @return bool
+	 */
+	public function isPidIgnored(): bool
+	{
+		return $this->getModuleConfiguration('isPidIgnored');
+	}
+
+	/**
+	 * @param string $component
+	 * @return bool
+	 */
+	public function hasComponentInDocHeader(string $component): bool
+	{
+		foreach ($this->getModuleConfiguration('components')[ModulePosition::DOC_HEADER] as $verticalPosition => $docHeaders) {
+			foreach ($docHeaders as $horizontalPosition => $docHeader) {
+
+				$index = array_search($component, $docHeader, true);
+				if ($index !== false) {
+					return true;
+				}
+			}
+		}
+		return false;
+	}
+
+	/**
+	 * @return string
+	 */
+	protected function getModuleLanguageFile(): string
+	{
+		$moduleConfiguration = $this->getExistingMainConfiguration();
+
+		if ($this->moduleLanguageFile) {
+			$moduleLanguageFile = $this->moduleLanguageFile;
+		} elseif ($moduleConfiguration['labels']) { // existing configuration may override.
+			$moduleLanguageFile = $moduleConfiguration['labels'];
+		} else {
+			$moduleLanguageFile = ''; //default value.
+		}
+
+		return $moduleLanguageFile;
+	}
+
+	/**
+	 * @param string $position
+	 * @return $this
+	 */
+	public function setPosition($position): self
+	{
+		$this->position = $position;
+		return $this;
+	}
+
+	/**
+	 * @return string
+	 */
+	public function getPosition(): string
+	{
+		return $this->position;
+	}
+
+	/**
+	 * @param array $files
+	 * @return $this
+	 */
+	public function addJavaScriptFiles(array $files): self
+	{
+		foreach ($files as $file) {
+			$this->additionalJavaScriptFiles[] = $file;
+		}
+		return $this;
+	}
+
+	/**
+	 * @param string $fileNameAndPath
+	 * @return $this
+	 */
+	public function addJavaScriptFile($fileNameAndPath): self
+	{
+		$this->additionalJavaScriptFiles[] = $fileNameAndPath;
+		return $this;
+	}
+
+	/**
+	 * @param array $files
+	 * @return $this
+	 */
+	public function addStyleSheetFiles(array $files): self
+	{
+		foreach ($files as $file) {
+			$this->additionalStyleSheetFiles[] = $file;
+		}
+		return $this;
+	}
+
+	/**
+	 * @param string $fileNameAndPath
+	 * @return $this
+	 */
+	public function addStyleSheetFile($fileNameAndPath): self
+	{
+		$this->additionalStyleSheetFiles[] = $fileNameAndPath;
+		return $this;
+	}
+
+	/**
+	 * @return string
+	 */
+	public function getDataType(): string
+	{
+		if ($this->dataType === null) {
+			$this->dataType = $this->getModuleConfiguration('dataType');
+		}
+		return $this->dataType;
+	}
+
+	/**
+	 * @return array
+	 */
+	public function getDataTypes(): array
+	{
+		$dataTypes = [];
+		foreach ($GLOBALS['TBE_MODULES_EXT']['vidi'] as $module) {
+			$dataTypes[] = $module['dataType'];
+		}
+		return $dataTypes;
+	}
+
+	/**
+	 * @param string $dataType
+	 * @return $this
+	 */
+	public function setDataType($dataType): self
+	{
+		$this->dataType = $dataType;
+		return $this;
+	}
+
+	/**
+	 * @return int
+	 */
+	public function getDefaultPid(): int
+	{
+		if (empty($this->defaultPid)) {
+			$this->defaultPid = $this->getModuleConfiguration('defaultPid');
+		}
+		return (int)$this->defaultPid;
+	}
+
+	/**
+	 * @param string $defaultPid
+	 * @return $this
+	 */
+	public function setDefaultPid($defaultPid): self
+	{
+		$this->defaultPid = $defaultPid;
+		return $this;
+	}
+
+	/**
+	 * @param bool $isPageTreeShown
+	 * @return $this
+	 */
+	public function showPageTree($isPageTreeShown): self
+	{
+		$this->showPageTree = $isPageTreeShown;
+		return $this;
+	}
+
+	/**
+	 * @param string $isShown
+	 * @return $this
+	 */
+	public function isShown($isShown): self
+	{
+		$this->isShown = $isShown;
+		return $this;
+	}
+
+	/**
+	 * @return $array
+	 */
+	public function getDocHeaderTopLeftComponents()
+	{
+		$configuration = $this->getModuleConfiguration();
+		return $configuration['components'][ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::LEFT];
+	}
+
+	/**
+	 * @param array $components
+	 * @return $this
+	 */
+	public function setDocHeaderTopLeftComponents(array $components): self
+	{
+		$this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::LEFT] = $components;
+		return $this;
+	}
+
+	/**
+	 * @param string|array $components
+	 * @return $this
+	 */
+	public function addDocHeaderTopLeftComponents($components): self
+	{
+		if (is_string($components)) {
+			$components = [$components];
+		}
+		$currentComponents = $this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::LEFT];
+		$this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::LEFT] = array_merge($currentComponents, $components);
+		return $this;
+	}
+
+	/**
+	 * @return $array
+	 */
+	public function getDocHeaderTopRightComponents()
+	{
+		$configuration = $this->getModuleConfiguration();
+		return $configuration['components'][ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::RIGHT];
+	}
+
+	/**
+	 * @param array $components
+	 * @return $this
+	 */
+	public function setDocHeaderTopRightComponents(array $components): self
+	{
+		$this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::RIGHT] = $components;
+		return $this;
+	}
+
+	/**
+	 * @param string|array $components
+	 * @return $this
+	 */
+	public function addDocHeaderTopRightComponents($components): self
+	{
+		if (is_string($components)) {
+			$components = [$components];
+		}
+		$currentComponents = $this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::RIGHT];
+		$this->components[ModulePosition::DOC_HEADER][ModulePosition::TOP][ModulePosition::RIGHT] = array_merge($currentComponents, $components);
+		return $this;
+	}
+
+	/**
+	 * @return $array
+	 */
+	public function getDocHeaderBottomLeftComponents()
+	{
+		$configuration = $this->getModuleConfiguration();
+		return $configuration['components'][ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::LEFT];
+	}
+
+	/**
+	 * @param array $components
+	 * @return $this
+	 */
+	public function setDocHeaderBottomLeftComponents(array $components): self
+	{
+		$this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::LEFT] = $components;
+		return $this;
+	}
+
+	/**
+	 * @param string|array $components
+	 * @return $this
+	 */
+	public function addDocHeaderBottomLeftComponents($components): self
+	{
+		if (is_string($components)) {
+			$components = [$components];
+		}
+		$currentComponents = $this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::LEFT];
+		$this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::LEFT] = array_merge($currentComponents, $components);
+		return $this;
+	}
+
+	/**
+	 * @return $array
+	 */
+	public function getDocHeaderBottomRightComponents()
+	{
+		$configuration = $this->getModuleConfiguration();
+		return $configuration['components'][ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::RIGHT];
+	}
+
+	/**
+	 * @param array $components
+	 * @return $this
+	 */
+	public function setDocHeaderBottomRightComponents(array $components): self
+	{
+		$this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::RIGHT] = $components;
+		return $this;
+	}
+
+	/**
+	 * @param string|array $components
+	 * @return $this
+	 */
+	public function addDocHeaderBottomRightComponents($components): self
+	{
+		if (is_string($components)) {
+			$components = [$components];
+		}
+		$currentComponents = $this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::RIGHT];
+		$this->components[ModulePosition::DOC_HEADER][ModulePosition::BOTTOM][ModulePosition::RIGHT] = array_merge($currentComponents, $components);
+		return $this;
+	}
+
+	/**
+	 * @return $array
+	 */
+	public function getGridTopComponents()
+	{
+		$configuration = $this->getModuleConfiguration();
+		return $configuration['components'][ModulePosition::GRID][ModulePosition::TOP];
+	}
+
+	/**
+	 * @param array $components
+	 * @return $this
+	 */
+	public function setGridTopComponents(array $components): self
+	{
+		$this->components[ModulePosition::GRID][ModulePosition::TOP] = $components;
+		return $this;
+	}
+
+	/**
+	 * @param string|array $components
+	 * @return $this
+	 */
+	public function addGridTopComponents($components): self
+	{
+		if (is_string($components)) {
+			$components = [$components];
+		}
+		$currentComponents = $this->components[ModulePosition::GRID][ModulePosition::TOP];
+		$this->components[ModulePosition::GRID][ModulePosition::TOP] = array_merge($currentComponents, $components);
+		return $this;
+	}
+
+	/**
+	 * @return mixed $array
+	 */
+	public function getGridBottomComponents()
+	{
+		$configuration = $this->getModuleConfiguration();
+		return $configuration['components'][ModulePosition::GRID][ModulePosition::BOTTOM];
+	}
+
+	/**
+	 * @param array $components
+	 * @return $this
+	 */
+	public function setGridBottomComponents(array $components): self
+	{
+		$this->components[ModulePosition::GRID][ModulePosition::BOTTOM] = $components;
+		return $this;
+	}
+
+	/**
+	 * @param string|array $components
+	 * @return $this
+	 */
+	public function addGridBottomComponents($components): self
+	{
+		if (is_string($components)) {
+			$components = [$components];
+		}
+		$currentComponents = $this->components[ModulePosition::GRID][ModulePosition::BOTTOM];
+		$this->components[ModulePosition::GRID][ModulePosition::BOTTOM] = array_merge($currentComponents, $components);
+		return $this;
+	}
+
+	/**
+	 * @return $array
+	 */
+	public function getGridButtonsComponents()
+	{
+		$configuration = $this->getModuleConfiguration();
+		return $configuration['components'][ModulePosition::GRID][ModulePosition::BUTTONS];
+	}
+
+	/**
+	 * @param array $components
+	 * @return $this
+	 */
+	public function setGridButtonsComponents(array $components): self
+	{
+		$this->components[ModulePosition::GRID][ModulePosition::BUTTONS] = $components;
+		return $this;
+	}
+
+	/**
+	 * @param string|array $components
+	 * @return $this
+	 */
+	public function addGridButtonsComponents($components): self
+	{
+		if (is_string($components)) {
+			$components = [$components];
+		}
+		$currentComponents = $this->components[ModulePosition::GRID][ModulePosition::BUTTONS];
+		$this->components[ModulePosition::GRID][ModulePosition::BUTTONS] = array_merge($components, $currentComponents);
+		return $this;
+	}
+
+	/**
+	 * @return $array
+	 */
+	public function getMenuMassActionComponents()
+	{
+		$configuration = $this->getModuleConfiguration();
+		return $configuration['components'][ModulePosition::MENU_MASS_ACTION];
+	}
+
+	/**
+	 * @param array $components
+	 * @return $this
+	 */
+	public function setMenuMassActionComponents(array $components): self
+	{
+		$this->components[ModulePosition::MENU_MASS_ACTION] = $components;
+		return $this;
+	}
+
+	/**
+	 * @param string|array $components
+	 * @return $this
+	 */
+	public function addMenuMassActionComponents($components): self
+	{
+		if (is_string($components)) {
+			$components = [$components];
+		}
+		$currentComponents = $this->components[ModulePosition::MENU_MASS_ACTION];
+		$this->components[ModulePosition::MENU_MASS_ACTION] = array_merge($components, $currentComponents);
+		return $this;
+	}
+
+	/**
+	 * @return string
+	 */
+	protected function getAccess(): string
+	{
+		$moduleConfiguration = $this->getExistingMainConfiguration();
+
+		if ($this->access !== null) {
+			$access = $this->access;
+		} elseif (!empty($moduleConfiguration['access'])) { // existing configuration may override.
+			$access = $moduleConfiguration['access'];
+		} else {
+			$access = Access::USER; //default value.
+		}
+		return $access;
+	}
+
+	/**
+	 * @param string $access
+	 * @return $this
+	 */
+	public function setAccess($access): self
+	{
+		$this->access = $access;
+		return $this;
+	}
+
+	/**
+	 * @return \string[]
+	 */
+	public function getAdditionalJavaScriptFiles(): array
+	{
+		if (empty($this->additionalJavaScriptFiles)) {
+			$this->additionalJavaScriptFiles = $this->getModuleConfiguration('additionalJavaScriptFiles');
+		}
+		return $this->additionalJavaScriptFiles;
+	}
+
+	/**
+	 * @return \string[]
+	 */
+	public function getAdditionalStyleSheetFiles(): array
+	{
+		if (empty($this->additionalStyleSheetFiles)) {
+			$this->additionalStyleSheetFiles = $this->getModuleConfiguration('additionalStyleSheetFiles');
+		}
+		return $this->additionalStyleSheetFiles;
+	}
+
+	/**
+	 * @return array
+	 */
+	public function getComponents(): array
+	{
+		return $this->components;
+	}
+
+	/**
+	 * @param string $pluginName
+	 * @return bool
+	 */
+	public function hasPlugin($pluginName = ''): bool
+	{
+		$parameterPrefix = $this->getParameterPrefix();
+		$parameters = GeneralUtility::_GET($parameterPrefix);
+
+		$hasPlugin = !empty($parameters['plugins']) && is_array($parameters['plugins']);
+		if ($hasPlugin && $pluginName) {
+			$hasPlugin = in_array($pluginName, $parameters['plugins']);
+		}
+		return $hasPlugin;
+	}
+
+	/**
+	 * Compute the internal module code
+	 *
+	 * @param null|string $dataType
+	 * @return string
+	 */
+	protected function getInternalModuleSignature($dataType = null): string
+	{
+		// Else we forge the module signature
+		if ($dataType === null) {
+			$dataType = $this->dataType;
+		}
+		$subModuleName = $dataType . '_' . $this->moduleKey;
+
+		$mainModule = $this->mainModule ?: self::DEFAULT_MAIN_MODULE;
+		return $mainModule . '_Vidi' . GeneralUtility::underscoredToUpperCamelCase($subModuleName);
+	}
 
 }

Spacing +5 added lines, -5 removed lines

@@ -193,7 +193,7 @@ 
      */
     protected function getExistingMainConfiguration(): array
     {
-        $moduleSignature = $this->computeMainModule() . '_' . $this->getInternalModuleSignature();
+        $moduleSignature = $this->computeMainModule().'_'.$this->getInternalModuleSignature();
         return $GLOBALS['TBE_MODULES']['_configuration'][$moduleSignature] ?? [];
     }
 
@@ -315,7 +315,7 @@ 
             ExtensionUtility::registerModule(
                 'Fab.vidi',
                 $this->computeMainModule(),
-                $this->dataType . '_' . $this->moduleKey,
+                $this->dataType.'_'.$this->moduleKey,
                 $this->position,
                 [
                     ContentController::class => 'index, list, delete, update, edit, copy, move, localize, sort, copyClipboard, moveClipboard',
@@ -378,7 +378,7 @@ 
      */
     public function getParameterPrefix(): string
     {
-        return 'tx_vidi_' . strtolower($this->getSignature());
+        return 'tx_vidi_'.strtolower($this->getSignature());
     }
 
     /**
@@ -1031,10 +1031,10 @@ 
         if ($dataType === null) {
             $dataType = $this->dataType;
         }
-        $subModuleName = $dataType . '_' . $this->moduleKey;
+        $subModuleName = $dataType.'_'.$this->moduleKey;
 
         $mainModule = $this->mainModule ?: self::DEFAULT_MAIN_MODULE;
-        return $mainModule . '_Vidi' . GeneralUtility::underscoredToUpperCamelCase($subModuleName);
+        return $mainModule.'_Vidi'.GeneralUtility::underscoredToUpperCamelCase($subModuleName);
     }
 
 }

Classes/DataHandler/CoreDataHandler.php

Indentation +135 added lines, -135 removed lines

@@ -18,140 +18,140 @@
 class CoreDataHandler extends AbstractDataHandler
 {
 
-    /**
-     * @var array
-     */
-    protected $dataHandler;
-
-    /**
-     * Process Content with action "update".
-     *
-     * @param Content $content
-     * @throws \Exception
-     * @return bool
-     */
-    public function processUpdate(Content $content)
-    {
-
-        $values = [];
-
-        // Check the field to be updated exists
-        foreach ($content->toArray() as $fieldName => $value) {
-            if (!Tca::table($content->getDataType())->hasField($fieldName)) {
-                $message = sprintf('It looks field "%s" does not exist for data type "%s"', $fieldName, $content->getDataType());
-                throw new \Exception($message, 1390668497);
-            }
-
-            // Flatten value if array given which is required for the DataHandler.
-            if (is_array($value)) {
-                $value = implode(',', $value);
-            }
-            $values[$fieldName] = $value;
-        }
-
-        $data[$content->getDataType()][$content->getUid()] = $values;
-
-        $dataHandler = $this->getDataHandler();
-        $dataHandler->start($data, array());
-        $dataHandler->process_datamap();
-        $this->errorMessages = $dataHandler->errorLog;
-
-        // Returns true is log does not contain errors.
-        return empty($dataHandler->errorLog);
-    }
-
-    /**
-     * Process Content with action "remove".
-     *
-     * @param Content $content
-     * @return bool
-     */
-    public function processRemove(Content $content)
-    {
-
-        // Build command
-        $cmd[$content->getDataType()][$content->getUid()]['delete'] = 1;
-
-        /** @var $dataHandler \TYPO3\CMS\Core\DataHandling\DataHandler */
-        $dataHandler = $this->getDataHandler();
-        $dataHandler->start([], $cmd);
-        $dataHandler->process_datamap();
-        $dataHandler->process_cmdmap();
-        $this->errorMessages = $dataHandler->errorLog;
-
-        // Returns true is log does not contain errors.
-        return empty($dataHandler->errorLog);
-    }
-
-    /**
-     * Process Content with action "copy".
-     *
-     * @param Content $content
-     * @param string $target
-     * @return bool
-     */
-    public function processCopy(Content $content, $target)
-    {
-        // TODO: Implement processCopy() method.
-    }
-
-    /**
-     * Process Content with action "move".
-     * The $target corresponds to the pid to move the records to.
-     * It can also be a negative value in case of sorting. The negative value would be the uid of its predecessor.
-     *
-     * @param Content $content
-     * @param int $target corresponds
-     * @return bool
-     */
-    public function processMove(Content $content, $target)
-    {
-
-        // Build command
-        $cmd[$content->getDataType()][$content->getUid()]['move'] = $target;
-
-        /** @var $dataHandler \TYPO3\CMS\Core\DataHandling\DataHandler */
-        $dataHandler = $this->getDataHandler();
-        $dataHandler->start([], $cmd);
-        $dataHandler->process_datamap();
-        $dataHandler->process_cmdmap();
-        $this->errorMessages = $dataHandler->errorLog;
-
-        // Returns true is log does not contain errors.
-        return empty($dataHandler->errorLog);
-    }
-
-    /**
-     * Process Content with action "localize".
-     *
-     * @param Content $content
-     * @param int $language
-     * @return bool
-     */
-    public function processLocalize(Content $content, $language)
-    {
-
-        $command[$content->getDataType()][$content->getUid()]['localize'] = $language;
-
-        $dataHandler = $this->getDataHandler();
-        $dataHandler->start([], $command);
-        $dataHandler->process_datamap();
-        $dataHandler->process_cmdmap();
-        $this->errorMessages = $dataHandler->errorLog;
-
-        // Returns true is log does not contain errors.
-        return empty($dataHandler->errorLog);
-    }
-
-    /**
-     * @return DataHandler
-     */
-    protected function getDataHandler()
-    {
-        if (!$this->dataHandler) {
-            $this->dataHandler = GeneralUtility::makeInstance(DataHandler::class);
-        }
-        return $this->dataHandler;
-    }
+	/**
+	 * @var array
+	 */
+	protected $dataHandler;
+
+	/**
+	 * Process Content with action "update".
+	 *
+	 * @param Content $content
+	 * @throws \Exception
+	 * @return bool
+	 */
+	public function processUpdate(Content $content)
+	{
+
+		$values = [];
+
+		// Check the field to be updated exists
+		foreach ($content->toArray() as $fieldName => $value) {
+			if (!Tca::table($content->getDataType())->hasField($fieldName)) {
+				$message = sprintf('It looks field "%s" does not exist for data type "%s"', $fieldName, $content->getDataType());
+				throw new \Exception($message, 1390668497);
+			}
+
+			// Flatten value if array given which is required for the DataHandler.
+			if (is_array($value)) {
+				$value = implode(',', $value);
+			}
+			$values[$fieldName] = $value;
+		}
+
+		$data[$content->getDataType()][$content->getUid()] = $values;
+
+		$dataHandler = $this->getDataHandler();
+		$dataHandler->start($data, array());
+		$dataHandler->process_datamap();
+		$this->errorMessages = $dataHandler->errorLog;
+
+		// Returns true is log does not contain errors.
+		return empty($dataHandler->errorLog);
+	}
+
+	/**
+	 * Process Content with action "remove".
+	 *
+	 * @param Content $content
+	 * @return bool
+	 */
+	public function processRemove(Content $content)
+	{
+
+		// Build command
+		$cmd[$content->getDataType()][$content->getUid()]['delete'] = 1;
+
+		/** @var $dataHandler \TYPO3\CMS\Core\DataHandling\DataHandler */
+		$dataHandler = $this->getDataHandler();
+		$dataHandler->start([], $cmd);
+		$dataHandler->process_datamap();
+		$dataHandler->process_cmdmap();
+		$this->errorMessages = $dataHandler->errorLog;
+
+		// Returns true is log does not contain errors.
+		return empty($dataHandler->errorLog);
+	}
+
+	/**
+	 * Process Content with action "copy".
+	 *
+	 * @param Content $content
+	 * @param string $target
+	 * @return bool
+	 */
+	public function processCopy(Content $content, $target)
+	{
+		// TODO: Implement processCopy() method.
+	}
+
+	/**
+	 * Process Content with action "move".
+	 * The $target corresponds to the pid to move the records to.
+	 * It can also be a negative value in case of sorting. The negative value would be the uid of its predecessor.
+	 *
+	 * @param Content $content
+	 * @param int $target corresponds
+	 * @return bool
+	 */
+	public function processMove(Content $content, $target)
+	{
+
+		// Build command
+		$cmd[$content->getDataType()][$content->getUid()]['move'] = $target;
+
+		/** @var $dataHandler \TYPO3\CMS\Core\DataHandling\DataHandler */
+		$dataHandler = $this->getDataHandler();
+		$dataHandler->start([], $cmd);
+		$dataHandler->process_datamap();
+		$dataHandler->process_cmdmap();
+		$this->errorMessages = $dataHandler->errorLog;
+
+		// Returns true is log does not contain errors.
+		return empty($dataHandler->errorLog);
+	}
+
+	/**
+	 * Process Content with action "localize".
+	 *
+	 * @param Content $content
+	 * @param int $language
+	 * @return bool
+	 */
+	public function processLocalize(Content $content, $language)
+	{
+
+		$command[$content->getDataType()][$content->getUid()]['localize'] = $language;
+
+		$dataHandler = $this->getDataHandler();
+		$dataHandler->start([], $command);
+		$dataHandler->process_datamap();
+		$dataHandler->process_cmdmap();
+		$this->errorMessages = $dataHandler->errorLog;
+
+		// Returns true is log does not contain errors.
+		return empty($dataHandler->errorLog);
+	}
+
+	/**
+	 * @return DataHandler
+	 */
+	protected function getDataHandler()
+	{
+		if (!$this->dataHandler) {
+			$this->dataHandler = GeneralUtility::makeInstance(DataHandler::class);
+		}
+		return $this->dataHandler;
+	}
 
 }

Classes/Persistence/PagerObjectFactory.php

Indentation +37 added lines, -37 removed lines

@@ -17,48 +17,48 @@
 class PagerObjectFactory implements SingletonInterface
 {
 
-    /**
-     * Gets a singleton instance of this class.
-     *
-     * @return \Fab\Vidi\Persistence\PagerObjectFactory|object
-     */
-    static public function getInstance()
-    {
-        return GeneralUtility::makeInstance(\Fab\Vidi\Persistence\PagerObjectFactory::class);
-    }
+	/**
+	 * Gets a singleton instance of this class.
+	 *
+	 * @return \Fab\Vidi\Persistence\PagerObjectFactory|object
+	 */
+	static public function getInstance()
+	{
+		return GeneralUtility::makeInstance(\Fab\Vidi\Persistence\PagerObjectFactory::class);
+	}
 
-    /**
-     * Returns a pager object.
-     *
-     * @return Pager
-     */
-    public function getPager()
-    {
+	/**
+	 * Returns a pager object.
+	 *
+	 * @return Pager
+	 */
+	public function getPager()
+	{
 
-        /** @var $pager \Fab\Vidi\Persistence\Pager */
-        $pager = GeneralUtility::makeInstance(Pager::class);
+		/** @var $pager \Fab\Vidi\Persistence\Pager */
+		$pager = GeneralUtility::makeInstance(Pager::class);
 
-        // Set items per page
-        if (GeneralUtility::_GET('length') !== null) {
-            $limit = (int)GeneralUtility::_GET('length');
-            $pager->setLimit($limit);
-        }
+		// Set items per page
+		if (GeneralUtility::_GET('length') !== null) {
+			$limit = (int)GeneralUtility::_GET('length');
+			$pager->setLimit($limit);
+		}
 
-        // Set offset
-        $offset = 0;
-        if (GeneralUtility::_GET('start') !== null) {
-            $offset = (int)GeneralUtility::_GET('start');
-        }
-        $pager->setOffset($offset);
+		// Set offset
+		$offset = 0;
+		if (GeneralUtility::_GET('start') !== null) {
+			$offset = (int)GeneralUtility::_GET('start');
+		}
+		$pager->setOffset($offset);
 
-        // set page
-        $page = 1;
-        if ($pager->getLimit() > 0) {
-            $page = round($pager->getOffset() / $pager->getLimit());
-        }
-        $pager->setPage($page);
+		// set page
+		$page = 1;
+		if ($pager->getLimit() > 0) {
+			$page = round($pager->getOffset() / $pager->getLimit());
+		}
+		$pager->setPage($page);
 
-        return $pager;
-    }
+		return $pager;
+	}
 
 }

Classes/Persistence/OrderObjectFactory.php

Indentation +39 added lines, -39 removed lines

@@ -18,43 +18,43 @@
 class OrderObjectFactory implements SingletonInterface
 {
 
-    /**
-     * Gets a singleton instance of this class.
-     *
-     * @return \Fab\Vidi\Persistence\OrderObjectFactory|object
-     */
-    static public function getInstance()
-    {
-        return GeneralUtility::makeInstance(\Fab\Vidi\Persistence\OrderObjectFactory::class);
-    }
-
-    /**
-     * Returns an order object.
-     *
-     * @param string $dataType
-     * @return Order|object
-     */
-    public function getOrder($dataType = '')
-    {
-
-        // Default ordering
-        $order = Tca::table($dataType)->getDefaultOrderings();
-
-        // Retrieve a possible id of the column from the request
-        $orderings = GeneralUtility::_GP('order');
-
-        if (is_array($orderings) && isset($orderings[0])) {
-            $columnPosition = $orderings[0]['column'];
-            $direction = $orderings[0]['dir'];
-
-            if ($columnPosition > 0) {
-                $field = Tca::grid()->getFieldNameByPosition($columnPosition);
-
-                $order = array(
-                    $field => strtoupper($direction)
-                );
-            }
-        }
-        return GeneralUtility::makeInstance(Order::class, $order);
-    }
+	/**
+	 * Gets a singleton instance of this class.
+	 *
+	 * @return \Fab\Vidi\Persistence\OrderObjectFactory|object
+	 */
+	static public function getInstance()
+	{
+		return GeneralUtility::makeInstance(\Fab\Vidi\Persistence\OrderObjectFactory::class);
+	}
+
+	/**
+	 * Returns an order object.
+	 *
+	 * @param string $dataType
+	 * @return Order|object
+	 */
+	public function getOrder($dataType = '')
+	{
+
+		// Default ordering
+		$order = Tca::table($dataType)->getDefaultOrderings();
+
+		// Retrieve a possible id of the column from the request
+		$orderings = GeneralUtility::_GP('order');
+
+		if (is_array($orderings) && isset($orderings[0])) {
+			$columnPosition = $orderings[0]['column'];
+			$direction = $orderings[0]['dir'];
+
+			if ($columnPosition > 0) {
+				$field = Tca::grid()->getFieldNameByPosition($columnPosition);
+
+				$order = array(
+					$field => strtoupper($direction)
+				);
+			}
+		}
+		return GeneralUtility::makeInstance(Order::class, $order);
+	}
 }

Classes/Persistence/Storage/VidiDbBackend.php

Spacing +37 added lines, -37 removed lines

@@ -169,7 +169,7 @@ 
             if (isset($statementParts['keywords']['distinct'])) {
                 unset($statementParts['keywords']['distinct']);
                 $distinctField = $this->query->getDistinct() ? $this->query->getDistinct() : 'uid';
-                $statementParts['fields'] = array('COUNT(DISTINCT ' . $statementParts['mainTable'] . '.' . $distinctField . ')');
+                $statementParts['fields'] = array('COUNT(DISTINCT '.$statementParts['mainTable'].'.'.$distinctField.')');
             }
 
             $sql = $this->buildQuery($statementParts);
@@ -232,14 +232,14 @@ 
             // tx_domain_model_foo0 (the alias) <--> tx_domain_model_foo (the origin table name)
             $values = [];
             foreach ($statementParts['fields'] as $key => $value) {
-                $values[$key] = str_replace($tableName, $tableName . '0', $value);
+                $values[$key] = str_replace($tableName, $tableName.'0', $value);
             }
             $statementParts['fields'] = $values;
 
             // Same comment as above.
             $values = [];
             foreach ($statementParts['where'] as $key => $value) {
-                $values[$key] = str_replace($tableName . '0', $tableName, $value);
+                $values[$key] = str_replace($tableName.'0', $tableName, $value);
             }
             $statementParts['where'] = $values;
 
@@ -278,25 +278,25 @@ 
         if (!empty($statementParts['unions'])) {
             foreach ($statementParts['unions'] as $tableName => $unionPart) {
                 if (!empty($statementParts['additionalWhereClause'][$tableName])) {
-                    $statementParts['unions'][$tableName] .= ' AND ' . implode(' AND ', $statementParts['additionalWhereClause'][$tableName]);
+                    $statementParts['unions'][$tableName] .= ' AND '.implode(' AND ', $statementParts['additionalWhereClause'][$tableName]);
                 }
             }
         }
 
-        $statement = 'SELECT ' . implode(' ', $statementParts['keywords']) . ' ' . implode(',', $statementParts['fields']) . ' FROM ' . implode(' ', $statementParts['tables']) . ' ' . implode(' ', $statementParts['unions']);
+        $statement = 'SELECT '.implode(' ', $statementParts['keywords']).' '.implode(',', $statementParts['fields']).' FROM '.implode(' ', $statementParts['tables']).' '.implode(' ', $statementParts['unions']);
         if (!empty($statementParts['where'])) {
-            $statement .= ' WHERE ' . implode('', $statementParts['where']);
+            $statement .= ' WHERE '.implode('', $statementParts['where']);
             if (!empty($statementParts['additionalWhereClause'][$this->query->getType()])) {
-                $statement .= ' AND ' . implode(' AND ', $statementParts['additionalWhereClause'][$this->query->getType()]);
+                $statement .= ' AND '.implode(' AND ', $statementParts['additionalWhereClause'][$this->query->getType()]);
             }
         } elseif (!empty($statementParts['additionalWhereClause'])) {
-            $statement .= ' WHERE ' . implode(' AND ', $statementParts['additionalWhereClause'][$this->query->getType()]);
+            $statement .= ' WHERE '.implode(' AND ', $statementParts['additionalWhereClause'][$this->query->getType()]);
         }
         if (!empty($statementParts['orderings'])) {
-            $statement .= ' ORDER BY ' . implode(', ', $statementParts['orderings']);
+            $statement .= ' ORDER BY '.implode(', ', $statementParts['orderings']);
         }
         if (!empty($statementParts['limit'])) {
-            $statement .= ' LIMIT ' . $statementParts['limit'];
+            $statement .= ' LIMIT '.$statementParts['limit'];
         }
 
         return $statement;
@@ -312,9 +312,9 @@ 
     protected function parseSource(SourceInterface $source, array &$sql)
     {
         $tableName = $this->getTableName();
-        $sql['fields'][$tableName] = $tableName . '.*';
+        $sql['fields'][$tableName] = $tableName.'.*';
         if ($this->query->getDistinct()) {
-            $sql['fields'][$tableName] = $tableName . '.' . $this->query->getDistinct();
+            $sql['fields'][$tableName] = $tableName.'.'.$this->query->getDistinct();
             $sql['keywords']['distinct'] = 'DISTINCT';
         }
         $sql['tables'][$tableName] = $tableName;
@@ -452,7 +452,7 @@ 
             if ($realInput instanceof DomainObjectInterface) {
                 return $realInput->getUid();
             } else {
-                throw new UnexpectedTypeException('An object of class "' . get_class($realInput) . '" could not be converted to a plain value.', 1274799934);
+                throw new UnexpectedTypeException('An object of class "'.get_class($realInput).'" could not be converted to a plain value.', 1274799934);
             }
         } elseif (is_bool($input)) {
             return $input === true ? 1 : 0;
@@ -502,9 +502,9 @@ 
                 : '?';
 
             if ($valueFunction === null) {
-                $constraintSQL .= (!empty($tableName) ? $tableName . '.' : '') . $columnName . ' ' . $resolvedOperator . ' ' . $marker;
+                $constraintSQL .= (!empty($tableName) ? $tableName.'.' : '').$columnName.' '.$resolvedOperator.' '.$marker;
             } else {
-                $constraintSQL .= $valueFunction . '(' . (!empty($tableName) ? $tableName . '.' : '') . $columnName . ') ' . $resolvedOperator . ' ' . $marker;
+                $constraintSQL .= $valueFunction.'('.(!empty($tableName) ? $tableName.'.' : '').$columnName.') '.$resolvedOperator.' '.$marker;
             }
 
             if (isset($tableName) && !empty($this->currentChildTableNameAlias)) {
@@ -531,7 +531,7 @@ 
         // to determine the relation type. Example for sys_category, property path will look like "items.sys_file"
         $parts = explode('.', $propertyPath, 3);
         if ($table->field($fieldName)->isGroup() && count($parts) > 2) {
-            $explodedPropertyPath[0] = $parts[0] . '.' . $parts[1];
+            $explodedPropertyPath[0] = $parts[0].'.'.$parts[1];
             $explodedPropertyPath[1] = $parts[2];
             $fieldName = $explodedPropertyPath[0];
         }
@@ -540,16 +540,16 @@ 
         $childTableName = $table->field($fieldName)->getForeignTable();
 
         if ($childTableName === null) {
-            throw new InvalidRelationConfigurationException('The relation information for property "' . $fieldName . '" of class "' . $tableName . '" is missing.', 1353170925);
+            throw new InvalidRelationConfigurationException('The relation information for property "'.$fieldName.'" of class "'.$tableName.'" is missing.', 1353170925);
         }
 
         if ($table->field($fieldName)->hasOne()) { // includes relation "one-to-one" and "many-to-one"
             // sometimes the opposite relation is not defined. We don't want to force this config for backward compatibility reasons.
             // $parentKeyFieldName === null does the trick somehow. Before condition was if (isset($parentKeyFieldName))
             if ($table->field($fieldName)->hasRelationManyToOne() || $parentKeyFieldName === null) {
-                $statementParts['unions'][$childTableName] = 'LEFT JOIN ' . $childTableName . ' ON ' . $tableName . '.' . $fieldName . '=' . $childTableName . '.uid';
+                $statementParts['unions'][$childTableName] = 'LEFT JOIN '.$childTableName.' ON '.$tableName.'.'.$fieldName.'='.$childTableName.'.uid';
             } else {
-                $statementParts['unions'][$childTableName] = 'LEFT JOIN ' . $childTableName . ' ON ' . $tableName . '.uid=' . $childTableName . '.' . $parentKeyFieldName;
+                $statementParts['unions'][$childTableName] = 'LEFT JOIN '.$childTableName.' ON '.$tableName.'.uid='.$childTableName.'.'.$parentKeyFieldName;
             }
         } elseif ($table->field($fieldName)->hasRelationManyToMany()) {
             $relationTableName = $table->field($fieldName)->getManyToManyTable();
@@ -779,18 +779,18 @@ 
         // If the table is found to have "workspace" support, add the corresponding fields in the statement.
         if (Tca::table($tableName)->hasWorkspaceSupport()) {
             if ($this->getBackendUser()->workspace === 0) {
-                $statement .= ' AND ' . $tableName . '.t3ver_state<=' . new VersionState(VersionState::DEFAULT_STATE);
+                $statement .= ' AND '.$tableName.'.t3ver_state<='.new VersionState(VersionState::DEFAULT_STATE);
             } else {
                 // Show only records of live and of the current workspace
                 // In case we are in a Versioning preview
-                $statement .= ' AND (' .
-                    $tableName . '.t3ver_wsid=0 OR ' .
-                    $tableName . '.t3ver_wsid=' . (int)$this->getBackendUser()->workspace .
+                $statement .= ' AND ('.
+                    $tableName.'.t3ver_wsid=0 OR '.
+                    $tableName.'.t3ver_wsid='.(int)$this->getBackendUser()->workspace.
                     ')';
             }
 
             // Check if this segment make sense here or whether it should be in the "if" part when we have workspace = 0
-            $statement .= ' AND ' . $tableName . '.pid<>-1';
+            $statement .= ' AND '.$tableName.'.pid<>-1';
         }
 
         if (!$includeDeleted) {
@@ -815,25 +815,25 @@ 
         if (is_array($GLOBALS['TCA'][$tableName]['ctrl'])) {
             if (!empty($GLOBALS['TCA'][$tableName]['ctrl']['languageField'])) {
                 // Select all entries for the current language
-                $additionalWhereClause = $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . ' IN (' . intval($querySettings->getLanguageUid()) . ',-1)';
+                $additionalWhereClause = $tableNameOrAlias.'.'.$GLOBALS['TCA'][$tableName]['ctrl']['languageField'].' IN ('.intval($querySettings->getLanguageUid()).',-1)';
                 // If any language is set -> get those entries which are not translated yet
                 // They will be removed by t3lib_page::getRecordOverlay if not matching overlay mode
                 if (isset($GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'])
                     && $querySettings->getLanguageUid() > 0
                 ) {
-                    $additionalWhereClause .= ' OR (' . $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . '=0' .
-                        ' AND ' . $tableNameOrAlias . '.uid NOT IN (SELECT ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'] .
-                        ' FROM ' . $tableName .
-                        ' WHERE ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'] . '>0' .
-                        ' AND ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . '>0';
+                    $additionalWhereClause .= ' OR ('.$tableNameOrAlias.'.'.$GLOBALS['TCA'][$tableName]['ctrl']['languageField'].'=0'.
+                        ' AND '.$tableNameOrAlias.'.uid NOT IN (SELECT '.$tableName.'.'.$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'].
+                        ' FROM '.$tableName.
+                        ' WHERE '.$tableName.'.'.$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'].'>0'.
+                        ' AND '.$tableName.'.'.$GLOBALS['TCA'][$tableName]['ctrl']['languageField'].'>0';
 
                     // Add delete clause to ensure all entries are loaded
                     if (isset($GLOBALS['TCA'][$tableName]['ctrl']['delete'])) {
-                        $additionalWhereClause .= ' AND ' . $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['delete'] . '=0';
+                        $additionalWhereClause .= ' AND '.$tableNameOrAlias.'.'.$GLOBALS['TCA'][$tableName]['ctrl']['delete'].'=0';
                     }
                     $additionalWhereClause .= '))';
                 }
-                $statementParts['additionalWhereClause'][$tableNameOrAlias][] = '(' . $additionalWhereClause . ')';
+                $statementParts['additionalWhereClause'][$tableNameOrAlias][] = '('.$additionalWhereClause.')';
             }
         }
     }
@@ -878,7 +878,7 @@ 
     protected function parseLimitAndOffset($limit, $offset, array &$statementParts)
     {
         if ($limit !== null && $offset !== null) {
-            $statementParts['limit'] = intval($offset) . ', ' . intval($limit);
+            $statementParts['limit'] = intval($offset).', '.intval($limit);
         } elseif ($limit !== null) {
             $statementParts['limit'] = intval($limit);
         }
@@ -946,11 +946,11 @@ 
             ) {
                 $queryBuilder = $this->getQueryBuilder();
                 $row = $queryBuilder
-                    ->select($tableName . '.*')
+                    ->select($tableName.'.*')
                     ->from($tableName)
                     ->andWhere(
-                        $tableName . '.uid=' . (int)$row[$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField']],
-                        $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . ' = 0'
+                        $tableName.'.uid='.(int)$row[$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField']],
+                        $tableName.'.'.$GLOBALS['TCA'][$tableName]['ctrl']['languageField'].' = 0'
                     )
                     ->execute()
                     ->fetch();
@@ -1011,7 +1011,7 @@ 
         }
 
         $numberOfAliases = $this->tableNameAliases['aliasIncrement'][$tableName];
-        $tableNameAlias = $tableName . $numberOfAliases;
+        $tableNameAlias = $tableName.$numberOfAliases;
 
         $this->tableNameAliases['aliasIncrement'][$tableName]++;
         $this->tableNameAliases['aliases'][$tableNameAlias] = $tableName;

Indentation +1047 added lines, -1047 removed lines

@@ -51,1052 +51,1052 @@
 class VidiDbBackend
 {
 
-    const OPERATOR_EQUAL_TO_NULL = 'operatorEqualToNull';
-    const OPERATOR_NOT_EQUAL_TO_NULL = 'operatorNotEqualToNull';
-
-    /**
-     * The TYPO3 page repository. Used for language and workspace overlay
-     *
-     * @var PageRepository
-     */
-    protected $pageRepository;
-
-    /**
-     * @var Query
-     */
-    protected $query;
-
-    /**
-     * Store some info related to table name and its aliases.
-     *
-     * @var array
-     */
-    protected $tableNameAliases = array(
-        'aliases' => [],
-        'aliasIncrement' => [],
-    );
-
-    /**
-     * Use to store the current foreign table name alias.
-     *
-     * @var string
-     */
-    protected $currentChildTableNameAlias = '';
-
-    /**
-     * @param Query $query
-     */
-    public function __construct(Query $query)
-    {
-        $this->query = $query;
-    }
-
-    /**
-     * @param $parameters
-     * @return array
-     */
-    protected static function getTypes($parameters)
-    {
-        $types = [];
-        foreach ($parameters as $parameter) {
-            if (is_array($parameter)) {
-                if (MathUtility::canBeInterpretedAsInteger($parameter[0])) {
-                    $types[] = \Doctrine\DBAL\Connection::PARAM_INT_ARRAY;
-                } else {
-                    $types[] = \Doctrine\DBAL\Connection::PARAM_STR_ARRAY;
-                }
-            } else {
-                if (MathUtility::canBeInterpretedAsInteger($parameter)) {
-                    $types[] = ParameterType::INTEGER;
-                } else {
-                    $types[] = ParameterType::STRING;
-                }
-            }
-        }
-        return $types;
-    }
-
-    /**
-     * Returns the result of the query
-     */
-    public function fetchResult()
-    {
-        $parameters = [];
-        $statementParts = $this->parseQuery($parameters);
-        $statementParts = $this->processStatementStructureForRecursiveMMRelation($statementParts);
-        $sql = $this->buildQuery($statementParts);
-        //print $sql; exit();
-
-        $rows = $this->getConnection()
-            ->executeQuery($sql, $parameters, self::getTypes($parameters))
-            ->fetchAll();
-
-        return $this->getContentObjects($rows);
-    }
-
-    /**
-     * Returns the number of tuples matching the query.
-     *
-     * @return int The number of matching tuples
-     */
-    public function countResult()
-    {
-        $parameters = [];
-        $statementParts = $this->parseQuery($parameters);
-        $statementParts = $this->processStatementStructureForRecursiveMMRelation($statementParts);
-        $types = self::getTypes($parameters);
-
-        // if limit is set, we need to count the rows "manually" as COUNT(*) ignores LIMIT constraints
-        if (!empty($statementParts['limit'])) {
-            $sql = $this->buildQuery($statementParts);
-
-            $count = $this
-                ->getConnection()
-                ->executeQuery($sql, $parameters, $types)
-                ->rowCount();
-        } else {
-            $statementParts['fields'] = array('COUNT(*)');
-            // having orderings without grouping is not compatible with non-MySQL DBMS
-            $statementParts['orderings'] = [];
-            if (isset($statementParts['keywords']['distinct'])) {
-                unset($statementParts['keywords']['distinct']);
-                $distinctField = $this->query->getDistinct() ? $this->query->getDistinct() : 'uid';
-                $statementParts['fields'] = array('COUNT(DISTINCT ' . $statementParts['mainTable'] . '.' . $distinctField . ')');
-            }
-
-            $sql = $this->buildQuery($statementParts);
-            $count = $this
-                ->getConnection()
-                ->executeQuery($sql, $parameters, $types)
-                ->fetchColumn(0);
-        }
-        return (int)$count;
-    }
-
-    /**
-     * Parses the query and returns the SQL statement parts.
-     *
-     * @param array &$parameters
-     * @return array
-     */
-    public function parseQuery(array &$parameters)
-    {
-        $statementParts = [];
-        $statementParts['keywords'] = [];
-        $statementParts['tables'] = [];
-        $statementParts['unions'] = [];
-        $statementParts['fields'] = [];
-        $statementParts['where'] = [];
-        $statementParts['additionalWhereClause'] = [];
-        $statementParts['orderings'] = [];
-        $statementParts['limit'] = [];
-        $query = $this->query;
-        $source = $query->getSource();
-        $this->parseSource($source, $statementParts);
-        $this->parseConstraint($query->getConstraint(), $source, $statementParts, $parameters);
-        $this->parseOrderings($query->getOrderings(), $source, $statementParts);
-        $this->parseLimitAndOffset($query->getLimit(), $query->getOffset(), $statementParts);
-        $tableNames = array_unique(array_keys($statementParts['tables'] + $statementParts['unions']));
-        foreach ($tableNames as $tableNameOrAlias) {
-            if (is_string($tableNameOrAlias) && strlen($tableNameOrAlias) > 0) {
-                $this->addAdditionalWhereClause($query->getTypo3QuerySettings(), $tableNameOrAlias, $statementParts);
-            }
-        }
-
-        return $statementParts;
-    }
-
-    /**
-     * Fiddle with the statement structure to handle recursive MM relations.
-     * For the recursive MM query to work, we must invert some values.
-     * Let see if that is the best way of doing that...
-     *
-     * @param array $statementParts
-     * @return array
-     */
-    public function processStatementStructureForRecursiveMMRelation(array $statementParts)
-    {
-
-        if ($this->hasRecursiveMMRelation()) {
-            $tableName = $this->query->getType();
-
-            // In order the MM query to work for a recursive MM query, we must invert some values.
-            // tx_domain_model_foo0 (the alias) <--> tx_domain_model_foo (the origin table name)
-            $values = [];
-            foreach ($statementParts['fields'] as $key => $value) {
-                $values[$key] = str_replace($tableName, $tableName . '0', $value);
-            }
-            $statementParts['fields'] = $values;
-
-            // Same comment as above.
-            $values = [];
-            foreach ($statementParts['where'] as $key => $value) {
-                $values[$key] = str_replace($tableName . '0', $tableName, $value);
-            }
-            $statementParts['where'] = $values;
-
-            // We must be more restrictive by transforming the "left" union by "inner"
-            $values = [];
-            foreach ($statementParts['unions'] as $key => $value) {
-                $values[$key] = str_replace('LEFT JOIN', 'INNER JOIN', $value);
-            }
-            $statementParts['unions'] = $values;
-        }
-
-        return $statementParts;
-    }
-
-    /**
-     * Tell whether there is a recursive MM relation.
-     *
-     * @return bool
-     */
-    public function hasRecursiveMMRelation()
-    {
-        return isset($this->tableNameAliases['aliasIncrement'][$this->query->getType()]);
-
-    }
-
-    /**
-     * Returns the statement, ready to be executed.
-     *
-     * @param array $statementParts The SQL statement parts
-     * @return string The SQL statement
-     */
-    public function buildQuery(array $statementParts)
-    {
-
-        // Add more statement to the UNION part.
-        if (!empty($statementParts['unions'])) {
-            foreach ($statementParts['unions'] as $tableName => $unionPart) {
-                if (!empty($statementParts['additionalWhereClause'][$tableName])) {
-                    $statementParts['unions'][$tableName] .= ' AND ' . implode(' AND ', $statementParts['additionalWhereClause'][$tableName]);
-                }
-            }
-        }
-
-        $statement = 'SELECT ' . implode(' ', $statementParts['keywords']) . ' ' . implode(',', $statementParts['fields']) . ' FROM ' . implode(' ', $statementParts['tables']) . ' ' . implode(' ', $statementParts['unions']);
-        if (!empty($statementParts['where'])) {
-            $statement .= ' WHERE ' . implode('', $statementParts['where']);
-            if (!empty($statementParts['additionalWhereClause'][$this->query->getType()])) {
-                $statement .= ' AND ' . implode(' AND ', $statementParts['additionalWhereClause'][$this->query->getType()]);
-            }
-        } elseif (!empty($statementParts['additionalWhereClause'])) {
-            $statement .= ' WHERE ' . implode(' AND ', $statementParts['additionalWhereClause'][$this->query->getType()]);
-        }
-        if (!empty($statementParts['orderings'])) {
-            $statement .= ' ORDER BY ' . implode(', ', $statementParts['orderings']);
-        }
-        if (!empty($statementParts['limit'])) {
-            $statement .= ' LIMIT ' . $statementParts['limit'];
-        }
-
-        return $statement;
-    }
-
-    /**
-     * Transforms a Query Source into SQL and parameter arrays
-     *
-     * @param SourceInterface $source The source
-     * @param array &$sql
-     * @return void
-     */
-    protected function parseSource(SourceInterface $source, array &$sql)
-    {
-        $tableName = $this->getTableName();
-        $sql['fields'][$tableName] = $tableName . '.*';
-        if ($this->query->getDistinct()) {
-            $sql['fields'][$tableName] = $tableName . '.' . $this->query->getDistinct();
-            $sql['keywords']['distinct'] = 'DISTINCT';
-        }
-        $sql['tables'][$tableName] = $tableName;
-        $sql['mainTable'] = $tableName;
-    }
-
-    /**
-     * Transforms a constraint into SQL and parameter arrays
-     *
-     * @param ConstraintInterface $constraint The constraint
-     * @param SourceInterface $source The source
-     * @param array &$statementParts The query parts
-     * @param array &$parameters The parameters that will replace the markers
-     * @return void
-     */
-    protected function parseConstraint(ConstraintInterface $constraint = null, SourceInterface $source, array &$statementParts, array &$parameters)
-    {
-        if ($constraint instanceof AndInterface) {
-            $statementParts['where'][] = '(';
-            $this->parseConstraint($constraint->getConstraint1(), $source, $statementParts, $parameters);
-            $statementParts['where'][] = ' AND ';
-            $this->parseConstraint($constraint->getConstraint2(), $source, $statementParts, $parameters);
-            $statementParts['where'][] = ')';
-        } elseif ($constraint instanceof OrInterface) {
-            $statementParts['where'][] = '(';
-            $this->parseConstraint($constraint->getConstraint1(), $source, $statementParts, $parameters);
-            $statementParts['where'][] = ' OR ';
-            $this->parseConstraint($constraint->getConstraint2(), $source, $statementParts, $parameters);
-            $statementParts['where'][] = ')';
-        } elseif ($constraint instanceof NotInterface) {
-            $statementParts['where'][] = 'NOT (';
-            $this->parseConstraint($constraint->getConstraint(), $source, $statementParts, $parameters);
-            $statementParts['where'][] = ')';
-        } elseif ($constraint instanceof ComparisonInterface) {
-            $this->parseComparison($constraint, $source, $statementParts, $parameters);
-        }
-    }
-
-    /**
-     * Parse a Comparison into SQL and parameter arrays.
-     *
-     * @param ComparisonInterface $comparison The comparison to parse
-     * @param SourceInterface $source The source
-     * @param array &$statementParts SQL query parts to add to
-     * @param array &$parameters Parameters to bind to the SQL
-     * @return void
-     * @throws Exception\RepositoryException
-     */
-    protected function parseComparison(ComparisonInterface $comparison, SourceInterface $source, array &$statementParts, array &$parameters)
-    {
-        $operand1 = $comparison->getOperand1();
-        $operator = $comparison->getOperator();
-        $operand2 = $comparison->getOperand2();
-        if ($operator === QueryInterface::OPERATOR_IN) {
-            $items = [];
-            $hasValue = false;
-            foreach ($operand2 as $value) {
-                $value = $this->getPlainValue($value);
-                if ($value !== null) {
-                    $items[] = $value;
-                    $hasValue = true;
-                }
-            }
-            if ($hasValue === false) {
-                $statementParts['where'][] = '1<>1';
-            } else {
-                $this->parseDynamicOperand($operand1, $operator, $source, $statementParts, $parameters, null);
-                $parameters[] = $items;
-            }
-        } elseif ($operator === QueryInterface::OPERATOR_CONTAINS) {
-            if ($operand2 === null) {
-                $statementParts['where'][] = '1<>1';
-            } else {
-                throw new \Exception('Not implemented! Contact extension author.', 1412931227);
-                # @todo re-implement me if necessary.
-                #$tableName = $this->query->getType();
-                #$propertyName = $operand1->getPropertyName();
-                #while (strpos($propertyName, '.') !== false) {
-                #	$this->addUnionStatement($tableName, $propertyName, $statementParts);
-                #}
-                #$columnName = $propertyName;
-                #$columnMap = $propertyName;
-                #$typeOfRelation = $columnMap instanceof ColumnMap ? $columnMap->getTypeOfRelation() : null;
-                #if ($typeOfRelation === ColumnMap::RELATION_HAS_AND_BELONGS_TO_MANY) {
-                #	$relationTableName = $columnMap->getRelationTableName();
-                #	$statementParts['where'][] = $tableName . '.uid IN (SELECT ' . $columnMap->getParentKeyFieldName() . ' FROM ' . $relationTableName . ' WHERE ' . $columnMap->getChildKeyFieldName() . '=?)';
-                #	$parameters[] = intval($this->getPlainValue($operand2));
-                #} elseif ($typeOfRelation === ColumnMap::RELATION_HAS_MANY) {
-                #	$parentKeyFieldName = $columnMap->getParentKeyFieldName();
-                #	if (isset($parentKeyFieldName)) {
-                #		$childTableName = $columnMap->getChildTableName();
-                #		$statementParts['where'][] = $tableName . '.uid=(SELECT ' . $childTableName . '.' . $parentKeyFieldName . ' FROM ' . $childTableName . ' WHERE ' . $childTableName . '.uid=?)';
-                #		$parameters[] = intval($this->getPlainValue($operand2));
-                #	} else {
-                #		$statementParts['where'][] = 'FIND_IN_SET(?,' . $tableName . '.' . $columnName . ')';
-                #		$parameters[] = intval($this->getPlainValue($operand2));
-                #	}
-                #} else {
-                #	throw new Exception\RepositoryException('Unsupported or non-existing property name "' . $propertyName . '" used in relation matching.', 1327065745);
-                #}
-            }
-        } else {
-            if ($operand2 === null) {
-                if ($operator === QueryInterface::OPERATOR_EQUAL_TO) {
-                    $operator = self::OPERATOR_EQUAL_TO_NULL;
-                } elseif ($operator === QueryInterface::OPERATOR_NOT_EQUAL_TO) {
-                    $operator = self::OPERATOR_NOT_EQUAL_TO_NULL;
-                }
-            }
-            $this->parseDynamicOperand($operand1, $operator, $source, $statementParts, $parameters);
-            $parameters[] = $this->getPlainValue($operand2);
-        }
-    }
-
-    /**
-     * Returns a plain value, i.e. objects are flattened if possible.
-     *
-     * @param mixed $input
-     * @return mixed
-     * @throws UnexpectedTypeException
-     */
-    protected function getPlainValue($input)
-    {
-        if (is_array($input)) {
-            throw new UnexpectedTypeException('An array could not be converted to a plain value.', 1274799932);
-        }
-        if ($input instanceof \DateTime) {
-            return $input->format('U');
-        } elseif (is_object($input)) {
-            if ($input instanceof LazyLoadingProxy) {
-                $realInput = $input->_loadRealInstance();
-            } else {
-                $realInput = $input;
-            }
-            if ($realInput instanceof DomainObjectInterface) {
-                return $realInput->getUid();
-            } else {
-                throw new UnexpectedTypeException('An object of class "' . get_class($realInput) . '" could not be converted to a plain value.', 1274799934);
-            }
-        } elseif (is_bool($input)) {
-            return $input === true ? 1 : 0;
-        } else {
-            return $input;
-        }
-    }
-
-    /**
-     * Parse a DynamicOperand into SQL and parameter arrays.
-     *
-     * @param DynamicOperandInterface $operand
-     * @param string $operator One of the JCR_OPERATOR_* constants
-     * @param SourceInterface $source The source
-     * @param array &$statementParts The query parts
-     * @param array &$parameters The parameters that will replace the markers
-     * @param string $valueFunction an optional SQL function to apply to the operand value
-     * @return void
-     */
-    protected function parseDynamicOperand(DynamicOperandInterface $operand, $operator, SourceInterface $source, array &$statementParts, array &$parameters, $valueFunction = null)
-    {
-        if ($operand instanceof LowerCaseInterface) {
-            $this->parseDynamicOperand($operand->getOperand(), $operator, $source, $statementParts, $parameters, 'LOWER');
-        } elseif ($operand instanceof UpperCaseInterface) {
-            $this->parseDynamicOperand($operand->getOperand(), $operator, $source, $statementParts, $parameters, 'UPPER');
-        } elseif ($operand instanceof PropertyValueInterface) {
-            $propertyName = $operand->getPropertyName();
-
-            // Reset value.
-            $this->currentChildTableNameAlias = '';
-
-            if ($source instanceof SelectorInterface) {
-                $tableName = $this->query->getType();
-                while (strpos($propertyName, '.') !== false) {
-                    $this->addUnionStatement($tableName, $propertyName, $statementParts);
-                }
-            } elseif ($source instanceof JoinInterface) {
-                $tableName = $source->getJoinCondition()->getSelector1Name();
-            }
-
-            $columnName = $propertyName;
-            $resolvedOperator = $this->resolveOperator($operator);
-            $constraintSQL = '';
-
-            $marker = $operator === QueryInterface::OPERATOR_IN
-                ? '(?)'
-                : '?';
-
-            if ($valueFunction === null) {
-                $constraintSQL .= (!empty($tableName) ? $tableName . '.' : '') . $columnName . ' ' . $resolvedOperator . ' ' . $marker;
-            } else {
-                $constraintSQL .= $valueFunction . '(' . (!empty($tableName) ? $tableName . '.' : '') . $columnName . ') ' . $resolvedOperator . ' ' . $marker;
-            }
-
-            if (isset($tableName) && !empty($this->currentChildTableNameAlias)) {
-                $constraintSQL = $this->replaceTableNameByAlias($tableName, $this->currentChildTableNameAlias, $constraintSQL);
-            }
-            $statementParts['where'][] = $constraintSQL;
-        }
-    }
-
-    /**
-     * @param string &$tableName
-     * @param string &$propertyPath
-     * @param array &$statementParts
-     */
-    protected function addUnionStatement(&$tableName, &$propertyPath, array &$statementParts)
-    {
-
-        $table = Tca::table($tableName);
-
-        $explodedPropertyPath = explode('.', $propertyPath, 2);
-        $fieldName = $explodedPropertyPath[0];
-
-        // Field of type "group" are special because property path must contain the table name
-        // to determine the relation type. Example for sys_category, property path will look like "items.sys_file"
-        $parts = explode('.', $propertyPath, 3);
-        if ($table->field($fieldName)->isGroup() && count($parts) > 2) {
-            $explodedPropertyPath[0] = $parts[0] . '.' . $parts[1];
-            $explodedPropertyPath[1] = $parts[2];
-            $fieldName = $explodedPropertyPath[0];
-        }
-
-        $parentKeyFieldName = $table->field($fieldName)->getForeignField();
-        $childTableName = $table->field($fieldName)->getForeignTable();
-
-        if ($childTableName === null) {
-            throw new InvalidRelationConfigurationException('The relation information for property "' . $fieldName . '" of class "' . $tableName . '" is missing.', 1353170925);
-        }
-
-        if ($table->field($fieldName)->hasOne()) { // includes relation "one-to-one" and "many-to-one"
-            // sometimes the opposite relation is not defined. We don't want to force this config for backward compatibility reasons.
-            // $parentKeyFieldName === null does the trick somehow. Before condition was if (isset($parentKeyFieldName))
-            if ($table->field($fieldName)->hasRelationManyToOne() || $parentKeyFieldName === null) {
-                $statementParts['unions'][$childTableName] = 'LEFT JOIN ' . $childTableName . ' ON ' . $tableName . '.' . $fieldName . '=' . $childTableName . '.uid';
-            } else {
-                $statementParts['unions'][$childTableName] = 'LEFT JOIN ' . $childTableName . ' ON ' . $tableName . '.uid=' . $childTableName . '.' . $parentKeyFieldName;
-            }
-        } elseif ($table->field($fieldName)->hasRelationManyToMany()) {
-            $relationTableName = $table->field($fieldName)->getManyToManyTable();
-
-            $parentKeyFieldName = $table->field($fieldName)->isOppositeRelation() ? 'uid_foreign' : 'uid_local';
-            $childKeyFieldName = !$table->field($fieldName)->isOppositeRelation() ? 'uid_foreign' : 'uid_local';
-
-            // MM table e.g sys_category_record_mm
-            $relationTableNameAlias = $this->generateAlias($relationTableName);
-            $join = sprintf(
-                'LEFT JOIN %s AS %s ON %s.uid=%s.%s', $relationTableName,
-                $relationTableNameAlias,
-                $tableName,
-                $relationTableNameAlias,
-                $parentKeyFieldName
-            );
-            $statementParts['unions'][$relationTableNameAlias] = $join;
-
-            // Foreign table e.g sys_category
-            $childTableNameAlias = $this->generateAlias($childTableName);
-            $this->currentChildTableNameAlias = $childTableNameAlias;
-            $join = sprintf(
-                'LEFT JOIN %s AS %s ON %s.%s=%s.uid',
-                $childTableName,
-                $childTableNameAlias,
-                $relationTableNameAlias,
-                $childKeyFieldName,
-                $childTableNameAlias
-            );
-            $statementParts['unions'][$childTableNameAlias] = $join;
-
-            // Find a possible table name for a MM condition.
-            $tableNameCondition = $table->field($fieldName)->getAdditionalTableNameCondition();
-            if ($tableNameCondition) {
-
-                // If we can find a source file name,  we can then retrieve more MM conditions from the TCA such as a field name.
-                $sourceFileName = $this->query->getSourceFieldName();
-                if (empty($sourceFileName)) {
-                    $additionalMMConditions = array(
-                        'tablenames' => $tableNameCondition,
-                    );
-                } else {
-                    $additionalMMConditions = Tca::table($tableNameCondition)->field($sourceFileName)->getAdditionalMMCondition();
-                }
-
-                foreach ($additionalMMConditions as $additionalFieldName => $additionalMMCondition) {
-                    $additionalJoin = sprintf(' AND %s.%s = "%s"', $relationTableNameAlias, $additionalFieldName, $additionalMMCondition);
-                    $statementParts['unions'][$relationTableNameAlias] .= $additionalJoin;
-
-                    $additionalJoin = sprintf(' AND %s.%s = "%s"', $relationTableNameAlias, $additionalFieldName, $additionalMMCondition);
-                    $statementParts['unions'][$childTableNameAlias] .= $additionalJoin;
-                }
-            }
-
-        } elseif ($table->field($fieldName)->hasMany()) { // includes relations "many-to-one" and "csv" relations
-            $childTableNameAlias = $this->generateAlias($childTableName);
-            $this->currentChildTableNameAlias = $childTableNameAlias;
-
-            if (isset($parentKeyFieldName)) {
-                $join = sprintf(
-                    'LEFT JOIN %s AS %s ON %s.uid=%s.%s',
-                    $childTableName,
-                    $childTableNameAlias,
-                    $tableName,
-                    $childTableNameAlias,
-                    $parentKeyFieldName
-                );
-                $statementParts['unions'][$childTableNameAlias] = $join;
-            } else {
-                $join = sprintf(
-                    'LEFT JOIN %s AS %s ON (FIND_IN_SET(%s.uid, %s.%s))',
-                    $childTableName,
-                    $childTableNameAlias,
-                    $childTableNameAlias,
-                    $tableName,
-                    $fieldName
-                );
-                $statementParts['unions'][$childTableNameAlias] = $join;
-            }
-        } else {
-            throw new Exception('Could not determine type of relation.', 1252502725);
-        }
-
-        $statementParts['keywords']['distinct'] = 'DISTINCT';
-        $propertyPath = $explodedPropertyPath[1];
-        $tableName = $childTableName;
-    }
-
-    /**
-     * Returns the SQL operator for the given JCR operator type.
-     *
-     * @param string $operator One of the JCR_OPERATOR_* constants
-     * @return string an SQL operator
-     * @throws Exception
-     */
-    protected function resolveOperator($operator)
-    {
-        switch ($operator) {
-            case self::OPERATOR_EQUAL_TO_NULL:
-                $operator = 'IS';
-                break;
-            case self::OPERATOR_NOT_EQUAL_TO_NULL:
-                $operator = 'IS NOT';
-                break;
-            case QueryInterface::OPERATOR_IN:
-                $operator = 'IN';
-                break;
-            case QueryInterface::OPERATOR_EQUAL_TO:
-                $operator = '=';
-                break;
-            case QueryInterface::OPERATOR_NOT_EQUAL_TO:
-                $operator = '!=';
-                break;
-            case QueryInterface::OPERATOR_LESS_THAN:
-                $operator = '<';
-                break;
-            case QueryInterface::OPERATOR_LESS_THAN_OR_EQUAL_TO:
-                $operator = '<=';
-                break;
-            case QueryInterface::OPERATOR_GREATER_THAN:
-                $operator = '>';
-                break;
-            case QueryInterface::OPERATOR_GREATER_THAN_OR_EQUAL_TO:
-                $operator = '>=';
-                break;
-            case QueryInterface::OPERATOR_LIKE:
-                $operator = 'LIKE';
-                break;
-            default:
-                throw new Exception('Unsupported operator encountered.', 1242816073);
-        }
-        return $operator;
-    }
-
-    /**
-     * Adds additional WHERE statements according to the query settings.
-     *
-     * @param QuerySettingsInterface $querySettings The TYPO3 CMS specific query settings
-     * @param string $tableNameOrAlias The table name to add the additional where clause for
-     * @param array &$statementParts
-     * @return void
-     */
-    protected function addAdditionalWhereClause(QuerySettingsInterface $querySettings, $tableNameOrAlias, &$statementParts)
-    {
-        $this->addVisibilityConstraintStatement($querySettings, $tableNameOrAlias, $statementParts);
-        if ($querySettings->getRespectSysLanguage()) {
-            $this->addSysLanguageStatement($tableNameOrAlias, $statementParts, $querySettings);
-        }
-    }
-
-    /**
-     * Adds enableFields and deletedClause to the query if necessary
-     *
-     * @param QuerySettingsInterface $querySettings
-     * @param string $tableNameOrAlias The database table name
-     * @param array &$statementParts The query parts
-     * @return void
-     */
-    protected function addVisibilityConstraintStatement(QuerySettingsInterface $querySettings, $tableNameOrAlias, array &$statementParts)
-    {
-        $statement = '';
-        $tableName = $this->resolveTableNameAlias($tableNameOrAlias);
-        if (is_array($GLOBALS['TCA'][$tableName]['ctrl'])) {
-            $ignoreEnableFields = $querySettings->getIgnoreEnableFields();
-            $enableFieldsToBeIgnored = $querySettings->getEnableFieldsToBeIgnored();
-            $includeDeleted = $querySettings->getIncludeDeleted();
-            if (ApplicationType::fromRequest($GLOBALS['TYPO3_REQUEST'])->isFrontend()) {
-                $statement .= $this->getFrontendConstraintStatement($tableNameOrAlias, $ignoreEnableFields, $enableFieldsToBeIgnored, $includeDeleted);
-            } else {
-                // 'BE' case
-                $statement .= $this->getBackendConstraintStatement($tableNameOrAlias, $ignoreEnableFields, $includeDeleted);
-            }
-
-            // Remove the prefixing "AND" if any.
-            if (!empty($statement)) {
-                $statement = strtolower(substr($statement, 1, 3)) === 'and' ? substr($statement, 5) : $statement;
-                $statementParts['additionalWhereClause'][$tableNameOrAlias][] = $statement;
-            }
-        }
-    }
-
-    /**
-     * Returns constraint statement for frontend context
-     *
-     * @param string $tableNameOrAlias
-     * @param boolean $ignoreEnableFields A flag indicating whether the enable fields should be ignored
-     * @param array $enableFieldsToBeIgnored If $ignoreEnableFields is true, this array specifies enable fields to be ignored. If it is null or an empty array (default) all enable fields are ignored.
-     * @param boolean $includeDeleted A flag indicating whether deleted records should be included
-     * @return string
-     * @throws Exception\InconsistentQuerySettingsException
-     */
-    protected function getFrontendConstraintStatement($tableNameOrAlias, $ignoreEnableFields, $enableFieldsToBeIgnored, $includeDeleted)
-    {
-        $statement = '';
-        $tableName = $this->resolveTableNameAlias($tableNameOrAlias);
-        if ($ignoreEnableFields && !$includeDeleted) {
-            if (count($enableFieldsToBeIgnored)) {
-                // array_combine() is necessary because of the way \TYPO3\CMS\Frontend\Page\PageRepository::enableFields() is implemented
-                $statement .= $this->getPageRepository()->enableFields($tableName, -1, array_combine($enableFieldsToBeIgnored, $enableFieldsToBeIgnored));
-            } else {
-                $statement .= $this->getPageRepository()->deleteClause($tableName);
-            }
-        } elseif (!$ignoreEnableFields && !$includeDeleted) {
-            $statement .= $this->getPageRepository()->enableFields($tableName);
-        } elseif (!$ignoreEnableFields && $includeDeleted) {
-            throw new InconsistentQuerySettingsException('Query setting "ignoreEnableFields=false" can not be used together with "includeDeleted=true" in frontend context.', 1327678173);
-        }
-        return $this->replaceTableNameByAlias($tableName, $tableNameOrAlias, $statement);
-    }
-
-    /**
-     * Returns constraint statement for backend context
-     *
-     * @param string $tableNameOrAlias
-     * @param boolean $ignoreEnableFields A flag indicating whether the enable fields should be ignored
-     * @param boolean $includeDeleted A flag indicating whether deleted records should be included
-     * @return string
-     */
-    protected function getBackendConstraintStatement($tableNameOrAlias, $ignoreEnableFields, $includeDeleted)
-    {
-        $tableName = $this->resolveTableNameAlias($tableNameOrAlias);
-        $statement = '';
-        if (!$ignoreEnableFields) {
-            $statement .= BackendUtility::BEenableFields($tableName);
-        }
-
-        // If the table is found to have "workspace" support, add the corresponding fields in the statement.
-        if (Tca::table($tableName)->hasWorkspaceSupport()) {
-            if ($this->getBackendUser()->workspace === 0) {
-                $statement .= ' AND ' . $tableName . '.t3ver_state<=' . new VersionState(VersionState::DEFAULT_STATE);
-            } else {
-                // Show only records of live and of the current workspace
-                // In case we are in a Versioning preview
-                $statement .= ' AND (' .
-                    $tableName . '.t3ver_wsid=0 OR ' .
-                    $tableName . '.t3ver_wsid=' . (int)$this->getBackendUser()->workspace .
-                    ')';
-            }
-
-            // Check if this segment make sense here or whether it should be in the "if" part when we have workspace = 0
-            $statement .= ' AND ' . $tableName . '.pid<>-1';
-        }
-
-        if (!$includeDeleted) {
-            $statement .= BackendUtility::deleteClause($tableName);
-        }
-
-        return $this->replaceTableNameByAlias($tableName, $tableNameOrAlias, $statement);
-    }
-
-    /**
-     * Builds the language field statement
-     *
-     * @param string $tableNameOrAlias The database table name
-     * @param array &$statementParts The query parts
-     * @param QuerySettingsInterface $querySettings The TYPO3 CMS specific query settings
-     * @return void
-     * @throws Exception
-     */
-    protected function addSysLanguageStatement($tableNameOrAlias, array &$statementParts, $querySettings)
-    {
-        $tableName = $this->resolveTableNameAlias($tableNameOrAlias);
-        if (is_array($GLOBALS['TCA'][$tableName]['ctrl'])) {
-            if (!empty($GLOBALS['TCA'][$tableName]['ctrl']['languageField'])) {
-                // Select all entries for the current language
-                $additionalWhereClause = $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . ' IN (' . intval($querySettings->getLanguageUid()) . ',-1)';
-                // If any language is set -> get those entries which are not translated yet
-                // They will be removed by t3lib_page::getRecordOverlay if not matching overlay mode
-                if (isset($GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'])
-                    && $querySettings->getLanguageUid() > 0
-                ) {
-                    $additionalWhereClause .= ' OR (' . $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . '=0' .
-                        ' AND ' . $tableNameOrAlias . '.uid NOT IN (SELECT ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'] .
-                        ' FROM ' . $tableName .
-                        ' WHERE ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'] . '>0' .
-                        ' AND ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . '>0';
-
-                    // Add delete clause to ensure all entries are loaded
-                    if (isset($GLOBALS['TCA'][$tableName]['ctrl']['delete'])) {
-                        $additionalWhereClause .= ' AND ' . $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['delete'] . '=0';
-                    }
-                    $additionalWhereClause .= '))';
-                }
-                $statementParts['additionalWhereClause'][$tableNameOrAlias][] = '(' . $additionalWhereClause . ')';
-            }
-        }
-    }
-
-    /**
-     * Transforms orderings into SQL.
-     *
-     * @param array $orderings An array of orderings (Tx_Extbase_Persistence_QOM_Ordering)
-     * @param SourceInterface $source The source
-     * @param array &$statementParts The query parts
-     * @return void
-     * @throws Exception\UnsupportedOrderException
-     */
-    protected function parseOrderings(array $orderings, SourceInterface $source, array &$statementParts)
-    {
-        foreach ($orderings as $fieldNameAndPath => $order) {
-            switch ($order) {
-                case QueryInterface::ORDER_ASCENDING:
-                    $order = 'ASC';
-                    break;
-                case QueryInterface::ORDER_DESCENDING:
-                    $order = 'DESC';
-                    break;
-                default:
-                    throw new UnsupportedOrderException('Unsupported order encountered.', 1456845126);
-            }
-
-            $tableName = $this->getFieldPathResolver()->getDataType($fieldNameAndPath, $this->query->getType());
-            $fieldName = $this->getFieldPathResolver()->stripFieldPath($fieldNameAndPath, $tableName);
-            $statementParts['orderings'][] = sprintf('%s.%s %s', $tableName, $fieldName, $order);
-        }
-    }
-
-    /**
-     * Transforms limit and offset into SQL
-     *
-     * @param int $limit
-     * @param int $offset
-     * @param array &$statementParts
-     * @return void
-     */
-    protected function parseLimitAndOffset($limit, $offset, array &$statementParts)
-    {
-        if ($limit !== null && $offset !== null) {
-            $statementParts['limit'] = intval($offset) . ', ' . intval($limit);
-        } elseif ($limit !== null) {
-            $statementParts['limit'] = intval($limit);
-        }
-    }
-
-    /**
-     * @param array $rows
-     * @return array
-     */
-    protected function getContentObjects(array $rows): array
-    {
-        $contentObjects = [];
-        foreach ($rows as $row) {
-
-            // Get language uid from querySettings.
-            // Ensure the backend handling is not broken (fallback to Get parameter 'L' if needed)
-            $overlaidRow = $this->doLanguageAndWorkspaceOverlay(
-                $row,
-                $this->query->getTypo3QuerySettings()
-            );
-
-            $contentObjects[] = GeneralUtility::makeInstance(
-                Content::class,
-                $this->query->getType(),
-                $overlaidRow
-            );
-        }
-
-        return $contentObjects;
-    }
-
-    /**
-     * Performs workspace and language overlay on the given row array. The language and workspace id is automatically
-     * detected (depending on FE or BE context). You can also explicitly set the language/workspace id.
-     *
-     * @param array $row
-     * @param QuerySettingsInterface $querySettings The TYPO3 CMS specific query settings
-     * @return array
-     */
-    protected function doLanguageAndWorkspaceOverlay(array $row, $querySettings)
-    {
-        $tableName = $this->getTableName();
-
-        $pageRepository = $this->getPageRepository();
-        if (is_object($GLOBALS['TSFE'])) {
-            $languageMode = $GLOBALS['TSFE']->sys_language_mode;
-            #if ($this->isBackendUserLogged() && $this->getBackendUser()->workspace !== 0) {
-            #    $pageRepository->versioningWorkspaceId = $this->getBackendUser()->workspace;
-            #}
-        } else {
-            $languageMode = '';
-            $workspaceUid = $this->getBackendUser()->workspace;
-            #$pageRepository->versioningWorkspaceId = $workspaceUid;
-            #if ($this->getBackendUser()->workspace !== 0) {
-            #    $pageRepository->versioningPreview = 1;
-            #}
-        }
-
-        // If current row is a translation select its parent
-        if (isset($GLOBALS['TCA'][$tableName]['ctrl']['languageField'])
-            && isset($GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'])
-        ) {
-            if (isset($row[$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField']])
-                && $row[$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField']] > 0
-            ) {
-                $queryBuilder = $this->getQueryBuilder();
-                $row = $queryBuilder
-                    ->select($tableName . '.*')
-                    ->from($tableName)
-                    ->andWhere(
-                        $tableName . '.uid=' . (int)$row[$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField']],
-                        $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . ' = 0'
-                    )
-                    ->execute()
-                    ->fetch();
-            }
-        }
-
-        // Retrieve the original uid; Used for Workspaces!
-        if (ApplicationType::fromRequest($GLOBALS['TYPO3_REQUEST'])->isBackend()) {
-            $pageRepository->versionOL($tableName, $row, true, true);
-        } else {
-            \TYPO3\CMS\Backend\Utility\BackendUtility::workspaceOL($tableName, $row);
-        }
-        if ($pageRepository->versioningPreview && isset($row['_ORIG_uid'])) {
-            $row['uid'] = $row['_ORIG_uid'];
-        }
-
-        // Special case for table "pages"
-        if ($tableName == 'pages') {
-            $row = $pageRepository->getPageOverlay($row, $querySettings->getLanguageUid());
-        } elseif (isset($GLOBALS['TCA'][$tableName]['ctrl']['languageField'])
-            && $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] !== ''
-        ) {
-            if (in_array($row[$GLOBALS['TCA'][$tableName]['ctrl']['languageField']], array(-1, 0))) {
-                $overlayMode = $languageMode === 'strict' ? 'hideNonTranslated' : '';
-                $row = $pageRepository->getRecordOverlay($tableName, $row, $querySettings->getLanguageUid(), $overlayMode);
-            }
-        }
-
-        return $row;
-    }
-
-    /**
-     * Return a resolved table name given a possible table name alias.
-     *
-     * @param string $tableNameOrAlias
-     * @return string
-     */
-    protected function resolveTableNameAlias($tableNameOrAlias)
-    {
-        $resolvedTableName = $tableNameOrAlias;
-        if (!empty($this->tableNameAliases['aliases'][$tableNameOrAlias])) {
-            $resolvedTableName = $this->tableNameAliases['aliases'][$tableNameOrAlias];
-        }
-        return $resolvedTableName;
-    }
-
-    /**
-     * Generate a unique table name alias for the given table name.
-     *
-     * @param string $tableName
-     * @return string
-     */
-    protected function generateAlias($tableName)
-    {
-
-        if (!isset($this->tableNameAliases['aliasIncrement'][$tableName])) {
-            $this->tableNameAliases['aliasIncrement'][$tableName] = 0;
-        }
-
-        $numberOfAliases = $this->tableNameAliases['aliasIncrement'][$tableName];
-        $tableNameAlias = $tableName . $numberOfAliases;
-
-        $this->tableNameAliases['aliasIncrement'][$tableName]++;
-        $this->tableNameAliases['aliases'][$tableNameAlias] = $tableName;
-
-        return $tableNameAlias;
-    }
-
-    /**
-     * Replace the table names by its table name alias within the given statement.
-     *
-     * @param string $tableName
-     * @param string $tableNameAlias
-     * @param string $statement
-     * @return string
-     */
-    protected function replaceTableNameByAlias($tableName, $tableNameAlias, $statement)
-    {
-        if ($statement && $tableName !== $tableNameAlias) {
-            $statement = str_replace($tableName, $tableNameAlias, $statement);
-        }
-        return $statement;
-    }
-
-    /**
-     * Returns an instance of the current Backend User.
-     *
-     * @return BackendUserAuthentication
-     */
-    protected function getBackendUser()
-    {
-        return $GLOBALS['BE_USER'];
-    }
-
-    /**
-     * Tell whether a Backend User is logged in.
-     *
-     * @return bool
-     */
-    protected function isBackendUserLogged()
-    {
-        return is_object($GLOBALS['BE_USER']);
-    }
-
-    /**
-     * @return PageRepository|object
-     */
-    protected function getPageRepository()
-    {
-        if (!$this->pageRepository instanceof PageRepository) {
-            if (ApplicationType::fromRequest($GLOBALS['TYPO3_REQUEST'])->isFrontend() && is_object($GLOBALS['TSFE'])) {
-                $this->pageRepository = $GLOBALS['TSFE']->sys_page;
-            } else {
-                $this->pageRepository = GeneralUtility::makeInstance(PageRepository::class);
-            }
-        }
-
-        return $this->pageRepository;
-    }
-
-    /**
-     * @return FieldPathResolver|object
-     */
-    protected function getFieldPathResolver()
-    {
-        return GeneralUtility::makeInstance(FieldPathResolver::class);
-    }
-
-    /**
-     * @return object|Connection
-     */
-    protected function getConnection(): Connection
-    {
-        /** @var ConnectionPool $connectionPool */
-        return GeneralUtility::makeInstance(ConnectionPool::class)
-            ->getConnectionForTable($this->getTableName());
-    }
-
-    /**
-     * @return object|QueryBuilder
-     */
-    protected function getQueryBuilder(): QueryBuilder
-    {
-        /** @var ConnectionPool $connectionPool */
-        $connectionPool = GeneralUtility::makeInstance(ConnectionPool::class);
-        return $connectionPool->getQueryBuilderForTable($this->getTableName());
-    }
-
-    /**
-     * @return string
-     */
-    public function getTableName(): string
-    {
-        return $this->query->getSource()->getNodeTypeName(); // getSelectorName()
-    }
+	const OPERATOR_EQUAL_TO_NULL = 'operatorEqualToNull';
+	const OPERATOR_NOT_EQUAL_TO_NULL = 'operatorNotEqualToNull';
+
+	/**
+	 * The TYPO3 page repository. Used for language and workspace overlay
+	 *
+	 * @var PageRepository
+	 */
+	protected $pageRepository;
+
+	/**
+	 * @var Query
+	 */
+	protected $query;
+
+	/**
+	 * Store some info related to table name and its aliases.
+	 *
+	 * @var array
+	 */
+	protected $tableNameAliases = array(
+		'aliases' => [],
+		'aliasIncrement' => [],
+	);
+
+	/**
+	 * Use to store the current foreign table name alias.
+	 *
+	 * @var string
+	 */
+	protected $currentChildTableNameAlias = '';
+
+	/**
+	 * @param Query $query
+	 */
+	public function __construct(Query $query)
+	{
+		$this->query = $query;
+	}
+
+	/**
+	 * @param $parameters
+	 * @return array
+	 */
+	protected static function getTypes($parameters)
+	{
+		$types = [];
+		foreach ($parameters as $parameter) {
+			if (is_array($parameter)) {
+				if (MathUtility::canBeInterpretedAsInteger($parameter[0])) {
+					$types[] = \Doctrine\DBAL\Connection::PARAM_INT_ARRAY;
+				} else {
+					$types[] = \Doctrine\DBAL\Connection::PARAM_STR_ARRAY;
+				}
+			} else {
+				if (MathUtility::canBeInterpretedAsInteger($parameter)) {
+					$types[] = ParameterType::INTEGER;
+				} else {
+					$types[] = ParameterType::STRING;
+				}
+			}
+		}
+		return $types;
+	}
+
+	/**
+	 * Returns the result of the query
+	 */
+	public function fetchResult()
+	{
+		$parameters = [];
+		$statementParts = $this->parseQuery($parameters);
+		$statementParts = $this->processStatementStructureForRecursiveMMRelation($statementParts);
+		$sql = $this->buildQuery($statementParts);
+		//print $sql; exit();
+
+		$rows = $this->getConnection()
+			->executeQuery($sql, $parameters, self::getTypes($parameters))
+			->fetchAll();
+
+		return $this->getContentObjects($rows);
+	}
+
+	/**
+	 * Returns the number of tuples matching the query.
+	 *
+	 * @return int The number of matching tuples
+	 */
+	public function countResult()
+	{
+		$parameters = [];
+		$statementParts = $this->parseQuery($parameters);
+		$statementParts = $this->processStatementStructureForRecursiveMMRelation($statementParts);
+		$types = self::getTypes($parameters);
+
+		// if limit is set, we need to count the rows "manually" as COUNT(*) ignores LIMIT constraints
+		if (!empty($statementParts['limit'])) {
+			$sql = $this->buildQuery($statementParts);
+
+			$count = $this
+				->getConnection()
+				->executeQuery($sql, $parameters, $types)
+				->rowCount();
+		} else {
+			$statementParts['fields'] = array('COUNT(*)');
+			// having orderings without grouping is not compatible with non-MySQL DBMS
+			$statementParts['orderings'] = [];
+			if (isset($statementParts['keywords']['distinct'])) {
+				unset($statementParts['keywords']['distinct']);
+				$distinctField = $this->query->getDistinct() ? $this->query->getDistinct() : 'uid';
+				$statementParts['fields'] = array('COUNT(DISTINCT ' . $statementParts['mainTable'] . '.' . $distinctField . ')');
+			}
+
+			$sql = $this->buildQuery($statementParts);
+			$count = $this
+				->getConnection()
+				->executeQuery($sql, $parameters, $types)
+				->fetchColumn(0);
+		}
+		return (int)$count;
+	}
+
+	/**
+	 * Parses the query and returns the SQL statement parts.
+	 *
+	 * @param array &$parameters
+	 * @return array
+	 */
+	public function parseQuery(array &$parameters)
+	{
+		$statementParts = [];
+		$statementParts['keywords'] = [];
+		$statementParts['tables'] = [];
+		$statementParts['unions'] = [];
+		$statementParts['fields'] = [];
+		$statementParts['where'] = [];
+		$statementParts['additionalWhereClause'] = [];
+		$statementParts['orderings'] = [];
+		$statementParts['limit'] = [];
+		$query = $this->query;
+		$source = $query->getSource();
+		$this->parseSource($source, $statementParts);
+		$this->parseConstraint($query->getConstraint(), $source, $statementParts, $parameters);
+		$this->parseOrderings($query->getOrderings(), $source, $statementParts);
+		$this->parseLimitAndOffset($query->getLimit(), $query->getOffset(), $statementParts);
+		$tableNames = array_unique(array_keys($statementParts['tables'] + $statementParts['unions']));
+		foreach ($tableNames as $tableNameOrAlias) {
+			if (is_string($tableNameOrAlias) && strlen($tableNameOrAlias) > 0) {
+				$this->addAdditionalWhereClause($query->getTypo3QuerySettings(), $tableNameOrAlias, $statementParts);
+			}
+		}
+
+		return $statementParts;
+	}
+
+	/**
+	 * Fiddle with the statement structure to handle recursive MM relations.
+	 * For the recursive MM query to work, we must invert some values.
+	 * Let see if that is the best way of doing that...
+	 *
+	 * @param array $statementParts
+	 * @return array
+	 */
+	public function processStatementStructureForRecursiveMMRelation(array $statementParts)
+	{
+
+		if ($this->hasRecursiveMMRelation()) {
+			$tableName = $this->query->getType();
+
+			// In order the MM query to work for a recursive MM query, we must invert some values.
+			// tx_domain_model_foo0 (the alias) <--> tx_domain_model_foo (the origin table name)
+			$values = [];
+			foreach ($statementParts['fields'] as $key => $value) {
+				$values[$key] = str_replace($tableName, $tableName . '0', $value);
+			}
+			$statementParts['fields'] = $values;
+
+			// Same comment as above.
+			$values = [];
+			foreach ($statementParts['where'] as $key => $value) {
+				$values[$key] = str_replace($tableName . '0', $tableName, $value);
+			}
+			$statementParts['where'] = $values;
+
+			// We must be more restrictive by transforming the "left" union by "inner"
+			$values = [];
+			foreach ($statementParts['unions'] as $key => $value) {
+				$values[$key] = str_replace('LEFT JOIN', 'INNER JOIN', $value);
+			}
+			$statementParts['unions'] = $values;
+		}
+
+		return $statementParts;
+	}
+
+	/**
+	 * Tell whether there is a recursive MM relation.
+	 *
+	 * @return bool
+	 */
+	public function hasRecursiveMMRelation()
+	{
+		return isset($this->tableNameAliases['aliasIncrement'][$this->query->getType()]);
+
+	}
+
+	/**
+	 * Returns the statement, ready to be executed.
+	 *
+	 * @param array $statementParts The SQL statement parts
+	 * @return string The SQL statement
+	 */
+	public function buildQuery(array $statementParts)
+	{
+
+		// Add more statement to the UNION part.
+		if (!empty($statementParts['unions'])) {
+			foreach ($statementParts['unions'] as $tableName => $unionPart) {
+				if (!empty($statementParts['additionalWhereClause'][$tableName])) {
+					$statementParts['unions'][$tableName] .= ' AND ' . implode(' AND ', $statementParts['additionalWhereClause'][$tableName]);
+				}
+			}
+		}
+
+		$statement = 'SELECT ' . implode(' ', $statementParts['keywords']) . ' ' . implode(',', $statementParts['fields']) . ' FROM ' . implode(' ', $statementParts['tables']) . ' ' . implode(' ', $statementParts['unions']);
+		if (!empty($statementParts['where'])) {
+			$statement .= ' WHERE ' . implode('', $statementParts['where']);
+			if (!empty($statementParts['additionalWhereClause'][$this->query->getType()])) {
+				$statement .= ' AND ' . implode(' AND ', $statementParts['additionalWhereClause'][$this->query->getType()]);
+			}
+		} elseif (!empty($statementParts['additionalWhereClause'])) {
+			$statement .= ' WHERE ' . implode(' AND ', $statementParts['additionalWhereClause'][$this->query->getType()]);
+		}
+		if (!empty($statementParts['orderings'])) {
+			$statement .= ' ORDER BY ' . implode(', ', $statementParts['orderings']);
+		}
+		if (!empty($statementParts['limit'])) {
+			$statement .= ' LIMIT ' . $statementParts['limit'];
+		}
+
+		return $statement;
+	}
+
+	/**
+	 * Transforms a Query Source into SQL and parameter arrays
+	 *
+	 * @param SourceInterface $source The source
+	 * @param array &$sql
+	 * @return void
+	 */
+	protected function parseSource(SourceInterface $source, array &$sql)
+	{
+		$tableName = $this->getTableName();
+		$sql['fields'][$tableName] = $tableName . '.*';
+		if ($this->query->getDistinct()) {
+			$sql['fields'][$tableName] = $tableName . '.' . $this->query->getDistinct();
+			$sql['keywords']['distinct'] = 'DISTINCT';
+		}
+		$sql['tables'][$tableName] = $tableName;
+		$sql['mainTable'] = $tableName;
+	}
+
+	/**
+	 * Transforms a constraint into SQL and parameter arrays
+	 *
+	 * @param ConstraintInterface $constraint The constraint
+	 * @param SourceInterface $source The source
+	 * @param array &$statementParts The query parts
+	 * @param array &$parameters The parameters that will replace the markers
+	 * @return void
+	 */
+	protected function parseConstraint(ConstraintInterface $constraint = null, SourceInterface $source, array &$statementParts, array &$parameters)
+	{
+		if ($constraint instanceof AndInterface) {
+			$statementParts['where'][] = '(';
+			$this->parseConstraint($constraint->getConstraint1(), $source, $statementParts, $parameters);
+			$statementParts['where'][] = ' AND ';
+			$this->parseConstraint($constraint->getConstraint2(), $source, $statementParts, $parameters);
+			$statementParts['where'][] = ')';
+		} elseif ($constraint instanceof OrInterface) {
+			$statementParts['where'][] = '(';
+			$this->parseConstraint($constraint->getConstraint1(), $source, $statementParts, $parameters);
+			$statementParts['where'][] = ' OR ';
+			$this->parseConstraint($constraint->getConstraint2(), $source, $statementParts, $parameters);
+			$statementParts['where'][] = ')';
+		} elseif ($constraint instanceof NotInterface) {
+			$statementParts['where'][] = 'NOT (';
+			$this->parseConstraint($constraint->getConstraint(), $source, $statementParts, $parameters);
+			$statementParts['where'][] = ')';
+		} elseif ($constraint instanceof ComparisonInterface) {
+			$this->parseComparison($constraint, $source, $statementParts, $parameters);
+		}
+	}
+
+	/**
+	 * Parse a Comparison into SQL and parameter arrays.
+	 *
+	 * @param ComparisonInterface $comparison The comparison to parse
+	 * @param SourceInterface $source The source
+	 * @param array &$statementParts SQL query parts to add to
+	 * @param array &$parameters Parameters to bind to the SQL
+	 * @return void
+	 * @throws Exception\RepositoryException
+	 */
+	protected function parseComparison(ComparisonInterface $comparison, SourceInterface $source, array &$statementParts, array &$parameters)
+	{
+		$operand1 = $comparison->getOperand1();
+		$operator = $comparison->getOperator();
+		$operand2 = $comparison->getOperand2();
+		if ($operator === QueryInterface::OPERATOR_IN) {
+			$items = [];
+			$hasValue = false;
+			foreach ($operand2 as $value) {
+				$value = $this->getPlainValue($value);
+				if ($value !== null) {
+					$items[] = $value;
+					$hasValue = true;
+				}
+			}
+			if ($hasValue === false) {
+				$statementParts['where'][] = '1<>1';
+			} else {
+				$this->parseDynamicOperand($operand1, $operator, $source, $statementParts, $parameters, null);
+				$parameters[] = $items;
+			}
+		} elseif ($operator === QueryInterface::OPERATOR_CONTAINS) {
+			if ($operand2 === null) {
+				$statementParts['where'][] = '1<>1';
+			} else {
+				throw new \Exception('Not implemented! Contact extension author.', 1412931227);
+				# @todo re-implement me if necessary.
+				#$tableName = $this->query->getType();
+				#$propertyName = $operand1->getPropertyName();
+				#while (strpos($propertyName, '.') !== false) {
+				#	$this->addUnionStatement($tableName, $propertyName, $statementParts);
+				#}
+				#$columnName = $propertyName;
+				#$columnMap = $propertyName;
+				#$typeOfRelation = $columnMap instanceof ColumnMap ? $columnMap->getTypeOfRelation() : null;
+				#if ($typeOfRelation === ColumnMap::RELATION_HAS_AND_BELONGS_TO_MANY) {
+				#	$relationTableName = $columnMap->getRelationTableName();
+				#	$statementParts['where'][] = $tableName . '.uid IN (SELECT ' . $columnMap->getParentKeyFieldName() . ' FROM ' . $relationTableName . ' WHERE ' . $columnMap->getChildKeyFieldName() . '=?)';
+				#	$parameters[] = intval($this->getPlainValue($operand2));
+				#} elseif ($typeOfRelation === ColumnMap::RELATION_HAS_MANY) {
+				#	$parentKeyFieldName = $columnMap->getParentKeyFieldName();
+				#	if (isset($parentKeyFieldName)) {
+				#		$childTableName = $columnMap->getChildTableName();
+				#		$statementParts['where'][] = $tableName . '.uid=(SELECT ' . $childTableName . '.' . $parentKeyFieldName . ' FROM ' . $childTableName . ' WHERE ' . $childTableName . '.uid=?)';
+				#		$parameters[] = intval($this->getPlainValue($operand2));
+				#	} else {
+				#		$statementParts['where'][] = 'FIND_IN_SET(?,' . $tableName . '.' . $columnName . ')';
+				#		$parameters[] = intval($this->getPlainValue($operand2));
+				#	}
+				#} else {
+				#	throw new Exception\RepositoryException('Unsupported or non-existing property name "' . $propertyName . '" used in relation matching.', 1327065745);
+				#}
+			}
+		} else {
+			if ($operand2 === null) {
+				if ($operator === QueryInterface::OPERATOR_EQUAL_TO) {
+					$operator = self::OPERATOR_EQUAL_TO_NULL;
+				} elseif ($operator === QueryInterface::OPERATOR_NOT_EQUAL_TO) {
+					$operator = self::OPERATOR_NOT_EQUAL_TO_NULL;
+				}
+			}
+			$this->parseDynamicOperand($operand1, $operator, $source, $statementParts, $parameters);
+			$parameters[] = $this->getPlainValue($operand2);
+		}
+	}
+
+	/**
+	 * Returns a plain value, i.e. objects are flattened if possible.
+	 *
+	 * @param mixed $input
+	 * @return mixed
+	 * @throws UnexpectedTypeException
+	 */
+	protected function getPlainValue($input)
+	{
+		if (is_array($input)) {
+			throw new UnexpectedTypeException('An array could not be converted to a plain value.', 1274799932);
+		}
+		if ($input instanceof \DateTime) {
+			return $input->format('U');
+		} elseif (is_object($input)) {
+			if ($input instanceof LazyLoadingProxy) {
+				$realInput = $input->_loadRealInstance();
+			} else {
+				$realInput = $input;
+			}
+			if ($realInput instanceof DomainObjectInterface) {
+				return $realInput->getUid();
+			} else {
+				throw new UnexpectedTypeException('An object of class "' . get_class($realInput) . '" could not be converted to a plain value.', 1274799934);
+			}
+		} elseif (is_bool($input)) {
+			return $input === true ? 1 : 0;
+		} else {
+			return $input;
+		}
+	}
+
+	/**
+	 * Parse a DynamicOperand into SQL and parameter arrays.
+	 *
+	 * @param DynamicOperandInterface $operand
+	 * @param string $operator One of the JCR_OPERATOR_* constants
+	 * @param SourceInterface $source The source
+	 * @param array &$statementParts The query parts
+	 * @param array &$parameters The parameters that will replace the markers
+	 * @param string $valueFunction an optional SQL function to apply to the operand value
+	 * @return void
+	 */
+	protected function parseDynamicOperand(DynamicOperandInterface $operand, $operator, SourceInterface $source, array &$statementParts, array &$parameters, $valueFunction = null)
+	{
+		if ($operand instanceof LowerCaseInterface) {
+			$this->parseDynamicOperand($operand->getOperand(), $operator, $source, $statementParts, $parameters, 'LOWER');
+		} elseif ($operand instanceof UpperCaseInterface) {
+			$this->parseDynamicOperand($operand->getOperand(), $operator, $source, $statementParts, $parameters, 'UPPER');
+		} elseif ($operand instanceof PropertyValueInterface) {
+			$propertyName = $operand->getPropertyName();
+
+			// Reset value.
+			$this->currentChildTableNameAlias = '';
+
+			if ($source instanceof SelectorInterface) {
+				$tableName = $this->query->getType();
+				while (strpos($propertyName, '.') !== false) {
+					$this->addUnionStatement($tableName, $propertyName, $statementParts);
+				}
+			} elseif ($source instanceof JoinInterface) {
+				$tableName = $source->getJoinCondition()->getSelector1Name();
+			}
+
+			$columnName = $propertyName;
+			$resolvedOperator = $this->resolveOperator($operator);
+			$constraintSQL = '';
+
+			$marker = $operator === QueryInterface::OPERATOR_IN
+				? '(?)'
+				: '?';
+
+			if ($valueFunction === null) {
+				$constraintSQL .= (!empty($tableName) ? $tableName . '.' : '') . $columnName . ' ' . $resolvedOperator . ' ' . $marker;
+			} else {
+				$constraintSQL .= $valueFunction . '(' . (!empty($tableName) ? $tableName . '.' : '') . $columnName . ') ' . $resolvedOperator . ' ' . $marker;
+			}
+
+			if (isset($tableName) && !empty($this->currentChildTableNameAlias)) {
+				$constraintSQL = $this->replaceTableNameByAlias($tableName, $this->currentChildTableNameAlias, $constraintSQL);
+			}
+			$statementParts['where'][] = $constraintSQL;
+		}
+	}
+
+	/**
+	 * @param string &$tableName
+	 * @param string &$propertyPath
+	 * @param array &$statementParts
+	 */
+	protected function addUnionStatement(&$tableName, &$propertyPath, array &$statementParts)
+	{
+
+		$table = Tca::table($tableName);
+
+		$explodedPropertyPath = explode('.', $propertyPath, 2);
+		$fieldName = $explodedPropertyPath[0];
+
+		// Field of type "group" are special because property path must contain the table name
+		// to determine the relation type. Example for sys_category, property path will look like "items.sys_file"
+		$parts = explode('.', $propertyPath, 3);
+		if ($table->field($fieldName)->isGroup() && count($parts) > 2) {
+			$explodedPropertyPath[0] = $parts[0] . '.' . $parts[1];
+			$explodedPropertyPath[1] = $parts[2];
+			$fieldName = $explodedPropertyPath[0];
+		}
+
+		$parentKeyFieldName = $table->field($fieldName)->getForeignField();
+		$childTableName = $table->field($fieldName)->getForeignTable();
+
+		if ($childTableName === null) {
+			throw new InvalidRelationConfigurationException('The relation information for property "' . $fieldName . '" of class "' . $tableName . '" is missing.', 1353170925);
+		}
+
+		if ($table->field($fieldName)->hasOne()) { // includes relation "one-to-one" and "many-to-one"
+			// sometimes the opposite relation is not defined. We don't want to force this config for backward compatibility reasons.
+			// $parentKeyFieldName === null does the trick somehow. Before condition was if (isset($parentKeyFieldName))
+			if ($table->field($fieldName)->hasRelationManyToOne() || $parentKeyFieldName === null) {
+				$statementParts['unions'][$childTableName] = 'LEFT JOIN ' . $childTableName . ' ON ' . $tableName . '.' . $fieldName . '=' . $childTableName . '.uid';
+			} else {
+				$statementParts['unions'][$childTableName] = 'LEFT JOIN ' . $childTableName . ' ON ' . $tableName . '.uid=' . $childTableName . '.' . $parentKeyFieldName;
+			}
+		} elseif ($table->field($fieldName)->hasRelationManyToMany()) {
+			$relationTableName = $table->field($fieldName)->getManyToManyTable();
+
+			$parentKeyFieldName = $table->field($fieldName)->isOppositeRelation() ? 'uid_foreign' : 'uid_local';
+			$childKeyFieldName = !$table->field($fieldName)->isOppositeRelation() ? 'uid_foreign' : 'uid_local';
+
+			// MM table e.g sys_category_record_mm
+			$relationTableNameAlias = $this->generateAlias($relationTableName);
+			$join = sprintf(
+				'LEFT JOIN %s AS %s ON %s.uid=%s.%s', $relationTableName,
+				$relationTableNameAlias,
+				$tableName,
+				$relationTableNameAlias,
+				$parentKeyFieldName
+			);
+			$statementParts['unions'][$relationTableNameAlias] = $join;
+
+			// Foreign table e.g sys_category
+			$childTableNameAlias = $this->generateAlias($childTableName);
+			$this->currentChildTableNameAlias = $childTableNameAlias;
+			$join = sprintf(
+				'LEFT JOIN %s AS %s ON %s.%s=%s.uid',
+				$childTableName,
+				$childTableNameAlias,
+				$relationTableNameAlias,
+				$childKeyFieldName,
+				$childTableNameAlias
+			);
+			$statementParts['unions'][$childTableNameAlias] = $join;
+
+			// Find a possible table name for a MM condition.
+			$tableNameCondition = $table->field($fieldName)->getAdditionalTableNameCondition();
+			if ($tableNameCondition) {
+
+				// If we can find a source file name,  we can then retrieve more MM conditions from the TCA such as a field name.
+				$sourceFileName = $this->query->getSourceFieldName();
+				if (empty($sourceFileName)) {
+					$additionalMMConditions = array(
+						'tablenames' => $tableNameCondition,
+					);
+				} else {
+					$additionalMMConditions = Tca::table($tableNameCondition)->field($sourceFileName)->getAdditionalMMCondition();
+				}
+
+				foreach ($additionalMMConditions as $additionalFieldName => $additionalMMCondition) {
+					$additionalJoin = sprintf(' AND %s.%s = "%s"', $relationTableNameAlias, $additionalFieldName, $additionalMMCondition);
+					$statementParts['unions'][$relationTableNameAlias] .= $additionalJoin;
+
+					$additionalJoin = sprintf(' AND %s.%s = "%s"', $relationTableNameAlias, $additionalFieldName, $additionalMMCondition);
+					$statementParts['unions'][$childTableNameAlias] .= $additionalJoin;
+				}
+			}
+
+		} elseif ($table->field($fieldName)->hasMany()) { // includes relations "many-to-one" and "csv" relations
+			$childTableNameAlias = $this->generateAlias($childTableName);
+			$this->currentChildTableNameAlias = $childTableNameAlias;
+
+			if (isset($parentKeyFieldName)) {
+				$join = sprintf(
+					'LEFT JOIN %s AS %s ON %s.uid=%s.%s',
+					$childTableName,
+					$childTableNameAlias,
+					$tableName,
+					$childTableNameAlias,
+					$parentKeyFieldName
+				);
+				$statementParts['unions'][$childTableNameAlias] = $join;
+			} else {
+				$join = sprintf(
+					'LEFT JOIN %s AS %s ON (FIND_IN_SET(%s.uid, %s.%s))',
+					$childTableName,
+					$childTableNameAlias,
+					$childTableNameAlias,
+					$tableName,
+					$fieldName
+				);
+				$statementParts['unions'][$childTableNameAlias] = $join;
+			}
+		} else {
+			throw new Exception('Could not determine type of relation.', 1252502725);
+		}
+
+		$statementParts['keywords']['distinct'] = 'DISTINCT';
+		$propertyPath = $explodedPropertyPath[1];
+		$tableName = $childTableName;
+	}
+
+	/**
+	 * Returns the SQL operator for the given JCR operator type.
+	 *
+	 * @param string $operator One of the JCR_OPERATOR_* constants
+	 * @return string an SQL operator
+	 * @throws Exception
+	 */
+	protected function resolveOperator($operator)
+	{
+		switch ($operator) {
+			case self::OPERATOR_EQUAL_TO_NULL:
+				$operator = 'IS';
+				break;
+			case self::OPERATOR_NOT_EQUAL_TO_NULL:
+				$operator = 'IS NOT';
+				break;
+			case QueryInterface::OPERATOR_IN:
+				$operator = 'IN';
+				break;
+			case QueryInterface::OPERATOR_EQUAL_TO:
+				$operator = '=';
+				break;
+			case QueryInterface::OPERATOR_NOT_EQUAL_TO:
+				$operator = '!=';
+				break;
+			case QueryInterface::OPERATOR_LESS_THAN:
+				$operator = '<';
+				break;
+			case QueryInterface::OPERATOR_LESS_THAN_OR_EQUAL_TO:
+				$operator = '<=';
+				break;
+			case QueryInterface::OPERATOR_GREATER_THAN:
+				$operator = '>';
+				break;
+			case QueryInterface::OPERATOR_GREATER_THAN_OR_EQUAL_TO:
+				$operator = '>=';
+				break;
+			case QueryInterface::OPERATOR_LIKE:
+				$operator = 'LIKE';
+				break;
+			default:
+				throw new Exception('Unsupported operator encountered.', 1242816073);
+		}
+		return $operator;
+	}
+
+	/**
+	 * Adds additional WHERE statements according to the query settings.
+	 *
+	 * @param QuerySettingsInterface $querySettings The TYPO3 CMS specific query settings
+	 * @param string $tableNameOrAlias The table name to add the additional where clause for
+	 * @param array &$statementParts
+	 * @return void
+	 */
+	protected function addAdditionalWhereClause(QuerySettingsInterface $querySettings, $tableNameOrAlias, &$statementParts)
+	{
+		$this->addVisibilityConstraintStatement($querySettings, $tableNameOrAlias, $statementParts);
+		if ($querySettings->getRespectSysLanguage()) {
+			$this->addSysLanguageStatement($tableNameOrAlias, $statementParts, $querySettings);
+		}
+	}
+
+	/**
+	 * Adds enableFields and deletedClause to the query if necessary
+	 *
+	 * @param QuerySettingsInterface $querySettings
+	 * @param string $tableNameOrAlias The database table name
+	 * @param array &$statementParts The query parts
+	 * @return void
+	 */
+	protected function addVisibilityConstraintStatement(QuerySettingsInterface $querySettings, $tableNameOrAlias, array &$statementParts)
+	{
+		$statement = '';
+		$tableName = $this->resolveTableNameAlias($tableNameOrAlias);
+		if (is_array($GLOBALS['TCA'][$tableName]['ctrl'])) {
+			$ignoreEnableFields = $querySettings->getIgnoreEnableFields();
+			$enableFieldsToBeIgnored = $querySettings->getEnableFieldsToBeIgnored();
+			$includeDeleted = $querySettings->getIncludeDeleted();
+			if (ApplicationType::fromRequest($GLOBALS['TYPO3_REQUEST'])->isFrontend()) {
+				$statement .= $this->getFrontendConstraintStatement($tableNameOrAlias, $ignoreEnableFields, $enableFieldsToBeIgnored, $includeDeleted);
+			} else {
+				// 'BE' case
+				$statement .= $this->getBackendConstraintStatement($tableNameOrAlias, $ignoreEnableFields, $includeDeleted);
+			}
+
+			// Remove the prefixing "AND" if any.
+			if (!empty($statement)) {
+				$statement = strtolower(substr($statement, 1, 3)) === 'and' ? substr($statement, 5) : $statement;
+				$statementParts['additionalWhereClause'][$tableNameOrAlias][] = $statement;
+			}
+		}
+	}
+
+	/**
+	 * Returns constraint statement for frontend context
+	 *
+	 * @param string $tableNameOrAlias
+	 * @param boolean $ignoreEnableFields A flag indicating whether the enable fields should be ignored
+	 * @param array $enableFieldsToBeIgnored If $ignoreEnableFields is true, this array specifies enable fields to be ignored. If it is null or an empty array (default) all enable fields are ignored.
+	 * @param boolean $includeDeleted A flag indicating whether deleted records should be included
+	 * @return string
+	 * @throws Exception\InconsistentQuerySettingsException
+	 */
+	protected function getFrontendConstraintStatement($tableNameOrAlias, $ignoreEnableFields, $enableFieldsToBeIgnored, $includeDeleted)
+	{
+		$statement = '';
+		$tableName = $this->resolveTableNameAlias($tableNameOrAlias);
+		if ($ignoreEnableFields && !$includeDeleted) {
+			if (count($enableFieldsToBeIgnored)) {
+				// array_combine() is necessary because of the way \TYPO3\CMS\Frontend\Page\PageRepository::enableFields() is implemented
+				$statement .= $this->getPageRepository()->enableFields($tableName, -1, array_combine($enableFieldsToBeIgnored, $enableFieldsToBeIgnored));
+			} else {
+				$statement .= $this->getPageRepository()->deleteClause($tableName);
+			}
+		} elseif (!$ignoreEnableFields && !$includeDeleted) {
+			$statement .= $this->getPageRepository()->enableFields($tableName);
+		} elseif (!$ignoreEnableFields && $includeDeleted) {
+			throw new InconsistentQuerySettingsException('Query setting "ignoreEnableFields=false" can not be used together with "includeDeleted=true" in frontend context.', 1327678173);
+		}
+		return $this->replaceTableNameByAlias($tableName, $tableNameOrAlias, $statement);
+	}
+
+	/**
+	 * Returns constraint statement for backend context
+	 *
+	 * @param string $tableNameOrAlias
+	 * @param boolean $ignoreEnableFields A flag indicating whether the enable fields should be ignored
+	 * @param boolean $includeDeleted A flag indicating whether deleted records should be included
+	 * @return string
+	 */
+	protected function getBackendConstraintStatement($tableNameOrAlias, $ignoreEnableFields, $includeDeleted)
+	{
+		$tableName = $this->resolveTableNameAlias($tableNameOrAlias);
+		$statement = '';
+		if (!$ignoreEnableFields) {
+			$statement .= BackendUtility::BEenableFields($tableName);
+		}
+
+		// If the table is found to have "workspace" support, add the corresponding fields in the statement.
+		if (Tca::table($tableName)->hasWorkspaceSupport()) {
+			if ($this->getBackendUser()->workspace === 0) {
+				$statement .= ' AND ' . $tableName . '.t3ver_state<=' . new VersionState(VersionState::DEFAULT_STATE);
+			} else {
+				// Show only records of live and of the current workspace
+				// In case we are in a Versioning preview
+				$statement .= ' AND (' .
+					$tableName . '.t3ver_wsid=0 OR ' .
+					$tableName . '.t3ver_wsid=' . (int)$this->getBackendUser()->workspace .
+					')';
+			}
+
+			// Check if this segment make sense here or whether it should be in the "if" part when we have workspace = 0
+			$statement .= ' AND ' . $tableName . '.pid<>-1';
+		}
+
+		if (!$includeDeleted) {
+			$statement .= BackendUtility::deleteClause($tableName);
+		}
+
+		return $this->replaceTableNameByAlias($tableName, $tableNameOrAlias, $statement);
+	}
+
+	/**
+	 * Builds the language field statement
+	 *
+	 * @param string $tableNameOrAlias The database table name
+	 * @param array &$statementParts The query parts
+	 * @param QuerySettingsInterface $querySettings The TYPO3 CMS specific query settings
+	 * @return void
+	 * @throws Exception
+	 */
+	protected function addSysLanguageStatement($tableNameOrAlias, array &$statementParts, $querySettings)
+	{
+		$tableName = $this->resolveTableNameAlias($tableNameOrAlias);
+		if (is_array($GLOBALS['TCA'][$tableName]['ctrl'])) {
+			if (!empty($GLOBALS['TCA'][$tableName]['ctrl']['languageField'])) {
+				// Select all entries for the current language
+				$additionalWhereClause = $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . ' IN (' . intval($querySettings->getLanguageUid()) . ',-1)';
+				// If any language is set -> get those entries which are not translated yet
+				// They will be removed by t3lib_page::getRecordOverlay if not matching overlay mode
+				if (isset($GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'])
+					&& $querySettings->getLanguageUid() > 0
+				) {
+					$additionalWhereClause .= ' OR (' . $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . '=0' .
+						' AND ' . $tableNameOrAlias . '.uid NOT IN (SELECT ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'] .
+						' FROM ' . $tableName .
+						' WHERE ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'] . '>0' .
+						' AND ' . $tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . '>0';
+
+					// Add delete clause to ensure all entries are loaded
+					if (isset($GLOBALS['TCA'][$tableName]['ctrl']['delete'])) {
+						$additionalWhereClause .= ' AND ' . $tableNameOrAlias . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['delete'] . '=0';
+					}
+					$additionalWhereClause .= '))';
+				}
+				$statementParts['additionalWhereClause'][$tableNameOrAlias][] = '(' . $additionalWhereClause . ')';
+			}
+		}
+	}
+
+	/**
+	 * Transforms orderings into SQL.
+	 *
+	 * @param array $orderings An array of orderings (Tx_Extbase_Persistence_QOM_Ordering)
+	 * @param SourceInterface $source The source
+	 * @param array &$statementParts The query parts
+	 * @return void
+	 * @throws Exception\UnsupportedOrderException
+	 */
+	protected function parseOrderings(array $orderings, SourceInterface $source, array &$statementParts)
+	{
+		foreach ($orderings as $fieldNameAndPath => $order) {
+			switch ($order) {
+				case QueryInterface::ORDER_ASCENDING:
+					$order = 'ASC';
+					break;
+				case QueryInterface::ORDER_DESCENDING:
+					$order = 'DESC';
+					break;
+				default:
+					throw new UnsupportedOrderException('Unsupported order encountered.', 1456845126);
+			}
+
+			$tableName = $this->getFieldPathResolver()->getDataType($fieldNameAndPath, $this->query->getType());
+			$fieldName = $this->getFieldPathResolver()->stripFieldPath($fieldNameAndPath, $tableName);
+			$statementParts['orderings'][] = sprintf('%s.%s %s', $tableName, $fieldName, $order);
+		}
+	}
+
+	/**
+	 * Transforms limit and offset into SQL
+	 *
+	 * @param int $limit
+	 * @param int $offset
+	 * @param array &$statementParts
+	 * @return void
+	 */
+	protected function parseLimitAndOffset($limit, $offset, array &$statementParts)
+	{
+		if ($limit !== null && $offset !== null) {
+			$statementParts['limit'] = intval($offset) . ', ' . intval($limit);
+		} elseif ($limit !== null) {
+			$statementParts['limit'] = intval($limit);
+		}
+	}
+
+	/**
+	 * @param array $rows
+	 * @return array
+	 */
+	protected function getContentObjects(array $rows): array
+	{
+		$contentObjects = [];
+		foreach ($rows as $row) {
+
+			// Get language uid from querySettings.
+			// Ensure the backend handling is not broken (fallback to Get parameter 'L' if needed)
+			$overlaidRow = $this->doLanguageAndWorkspaceOverlay(
+				$row,
+				$this->query->getTypo3QuerySettings()
+			);
+
+			$contentObjects[] = GeneralUtility::makeInstance(
+				Content::class,
+				$this->query->getType(),
+				$overlaidRow
+			);
+		}
+
+		return $contentObjects;
+	}
+
+	/**
+	 * Performs workspace and language overlay on the given row array. The language and workspace id is automatically
+	 * detected (depending on FE or BE context). You can also explicitly set the language/workspace id.
+	 *
+	 * @param array $row
+	 * @param QuerySettingsInterface $querySettings The TYPO3 CMS specific query settings
+	 * @return array
+	 */
+	protected function doLanguageAndWorkspaceOverlay(array $row, $querySettings)
+	{
+		$tableName = $this->getTableName();
+
+		$pageRepository = $this->getPageRepository();
+		if (is_object($GLOBALS['TSFE'])) {
+			$languageMode = $GLOBALS['TSFE']->sys_language_mode;
+			#if ($this->isBackendUserLogged() && $this->getBackendUser()->workspace !== 0) {
+			#    $pageRepository->versioningWorkspaceId = $this->getBackendUser()->workspace;
+			#}
+		} else {
+			$languageMode = '';
+			$workspaceUid = $this->getBackendUser()->workspace;
+			#$pageRepository->versioningWorkspaceId = $workspaceUid;
+			#if ($this->getBackendUser()->workspace !== 0) {
+			#    $pageRepository->versioningPreview = 1;
+			#}
+		}
+
+		// If current row is a translation select its parent
+		if (isset($GLOBALS['TCA'][$tableName]['ctrl']['languageField'])
+			&& isset($GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'])
+		) {
+			if (isset($row[$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField']])
+				&& $row[$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField']] > 0
+			) {
+				$queryBuilder = $this->getQueryBuilder();
+				$row = $queryBuilder
+					->select($tableName . '.*')
+					->from($tableName)
+					->andWhere(
+						$tableName . '.uid=' . (int)$row[$GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField']],
+						$tableName . '.' . $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] . ' = 0'
+					)
+					->execute()
+					->fetch();
+			}
+		}
+
+		// Retrieve the original uid; Used for Workspaces!
+		if (ApplicationType::fromRequest($GLOBALS['TYPO3_REQUEST'])->isBackend()) {
+			$pageRepository->versionOL($tableName, $row, true, true);
+		} else {
+			\TYPO3\CMS\Backend\Utility\BackendUtility::workspaceOL($tableName, $row);
+		}
+		if ($pageRepository->versioningPreview && isset($row['_ORIG_uid'])) {
+			$row['uid'] = $row['_ORIG_uid'];
+		}
+
+		// Special case for table "pages"
+		if ($tableName == 'pages') {
+			$row = $pageRepository->getPageOverlay($row, $querySettings->getLanguageUid());
+		} elseif (isset($GLOBALS['TCA'][$tableName]['ctrl']['languageField'])
+			&& $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] !== ''
+		) {
+			if (in_array($row[$GLOBALS['TCA'][$tableName]['ctrl']['languageField']], array(-1, 0))) {
+				$overlayMode = $languageMode === 'strict' ? 'hideNonTranslated' : '';
+				$row = $pageRepository->getRecordOverlay($tableName, $row, $querySettings->getLanguageUid(), $overlayMode);
+			}
+		}
+
+		return $row;
+	}
+
+	/**
+	 * Return a resolved table name given a possible table name alias.
+	 *
+	 * @param string $tableNameOrAlias
+	 * @return string
+	 */
+	protected function resolveTableNameAlias($tableNameOrAlias)
+	{
+		$resolvedTableName = $tableNameOrAlias;
+		if (!empty($this->tableNameAliases['aliases'][$tableNameOrAlias])) {
+			$resolvedTableName = $this->tableNameAliases['aliases'][$tableNameOrAlias];
+		}
+		return $resolvedTableName;
+	}
+
+	/**
+	 * Generate a unique table name alias for the given table name.
+	 *
+	 * @param string $tableName
+	 * @return string
+	 */
+	protected function generateAlias($tableName)
+	{
+
+		if (!isset($this->tableNameAliases['aliasIncrement'][$tableName])) {
+			$this->tableNameAliases['aliasIncrement'][$tableName] = 0;
+		}
+
+		$numberOfAliases = $this->tableNameAliases['aliasIncrement'][$tableName];
+		$tableNameAlias = $tableName . $numberOfAliases;
+
+		$this->tableNameAliases['aliasIncrement'][$tableName]++;
+		$this->tableNameAliases['aliases'][$tableNameAlias] = $tableName;
+
+		return $tableNameAlias;
+	}
+
+	/**
+	 * Replace the table names by its table name alias within the given statement.
+	 *
+	 * @param string $tableName
+	 * @param string $tableNameAlias
+	 * @param string $statement
+	 * @return string
+	 */
+	protected function replaceTableNameByAlias($tableName, $tableNameAlias, $statement)
+	{
+		if ($statement && $tableName !== $tableNameAlias) {
+			$statement = str_replace($tableName, $tableNameAlias, $statement);
+		}
+		return $statement;
+	}
+
+	/**
+	 * Returns an instance of the current Backend User.
+	 *
+	 * @return BackendUserAuthentication
+	 */
+	protected function getBackendUser()
+	{
+		return $GLOBALS['BE_USER'];
+	}
+
+	/**
+	 * Tell whether a Backend User is logged in.
+	 *
+	 * @return bool
+	 */
+	protected function isBackendUserLogged()
+	{
+		return is_object($GLOBALS['BE_USER']);
+	}
+
+	/**
+	 * @return PageRepository|object
+	 */
+	protected function getPageRepository()
+	{
+		if (!$this->pageRepository instanceof PageRepository) {
+			if (ApplicationType::fromRequest($GLOBALS['TYPO3_REQUEST'])->isFrontend() && is_object($GLOBALS['TSFE'])) {
+				$this->pageRepository = $GLOBALS['TSFE']->sys_page;
+			} else {
+				$this->pageRepository = GeneralUtility::makeInstance(PageRepository::class);
+			}
+		}
+
+		return $this->pageRepository;
+	}
+
+	/**
+	 * @return FieldPathResolver|object
+	 */
+	protected function getFieldPathResolver()
+	{
+		return GeneralUtility::makeInstance(FieldPathResolver::class);
+	}
+
+	/**
+	 * @return object|Connection
+	 */
+	protected function getConnection(): Connection
+	{
+		/** @var ConnectionPool $connectionPool */
+		return GeneralUtility::makeInstance(ConnectionPool::class)
+			->getConnectionForTable($this->getTableName());
+	}
+
+	/**
+	 * @return object|QueryBuilder
+	 */
+	protected function getQueryBuilder(): QueryBuilder
+	{
+		/** @var ConnectionPool $connectionPool */
+		$connectionPool = GeneralUtility::makeInstance(ConnectionPool::class);
+		return $connectionPool->getQueryBuilderForTable($this->getTableName());
+	}
+
+	/**
+	 * @return string
+	 */
+	public function getTableName(): string
+	{
+		return $this->query->getSource()->getNodeTypeName(); // getSelectorName()
+	}
 
 }

Classes/Service/BackendUserPreferenceService.php

Indentation +46 added lines, -46 removed lines

@@ -16,54 +16,54 @@
 class BackendUserPreferenceService
 {
 
-    /**
-     * Returns a class instance
-     *
-     * @return \Fab\Vidi\Service\BackendUserPreferenceService|object
-     */
-    static public function getInstance()
-    {
-        return GeneralUtility::makeInstance(\Fab\Vidi\Service\BackendUserPreferenceService::class);
-    }
+	/**
+	 * Returns a class instance
+	 *
+	 * @return \Fab\Vidi\Service\BackendUserPreferenceService|object
+	 */
+	static public function getInstance()
+	{
+		return GeneralUtility::makeInstance(\Fab\Vidi\Service\BackendUserPreferenceService::class);
+	}
 
-    /**
-     * Returns a configuration key for the current BE User.
-     *
-     * @param string $key
-     * @return mixed
-     */
-    public function get($key)
-    {
-        $result = '';
-        if ($this->getBackendUser() && !empty($this->getBackendUser()->uc[$key])) {
-            $result = $this->getBackendUser()->uc[$key];
+	/**
+	 * Returns a configuration key for the current BE User.
+	 *
+	 * @param string $key
+	 * @return mixed
+	 */
+	public function get($key)
+	{
+		$result = '';
+		if ($this->getBackendUser() && !empty($this->getBackendUser()->uc[$key])) {
+			$result = $this->getBackendUser()->uc[$key];
 
-        }
-        return $result;
-    }
+		}
+		return $result;
+	}
 
-    /**
-     * Set a configuration for the current BE User.
-     *
-     * @param string $key
-     * @param mixed $value
-     * @return void
-     */
-    public function set($key, $value)
-    {
-        if ($this->getBackendUser()) {
-            $this->getBackendUser()->uc[$key] = $value;
-            $this->getBackendUser()->writeUC();
-        }
-    }
+	/**
+	 * Set a configuration for the current BE User.
+	 *
+	 * @param string $key
+	 * @param mixed $value
+	 * @return void
+	 */
+	public function set($key, $value)
+	{
+		if ($this->getBackendUser()) {
+			$this->getBackendUser()->uc[$key] = $value;
+			$this->getBackendUser()->writeUC();
+		}
+	}
 
-    /**
-     * Returns an instance of the current Backend User.
-     *
-     * @return BackendUserAuthentication
-     */
-    protected function getBackendUser()
-    {
-        return $GLOBALS['BE_USER'];
-    }
+	/**
+	 * Returns an instance of the current Backend User.
+	 *
+	 * @return BackendUserAuthentication
+	 */
+	protected function getBackendUser()
+	{
+		return $GLOBALS['BE_USER'];
+	}
 }

ext_emconf.php

Indentation +23 added lines, -23 removed lines

@@ -1,27 +1,27 @@
 <?php
 
 $EM_CONF[$_EXTKEY] = [
-    'title' => 'Versatile and Interactive Display - List Component',
-    'description' => 'Generic listing of records with versatile ways of interacting with the data, e.g. advanced filter, inline editing, mass editing, ... Veni, vidi, vici!',
-    'category' => 'module',
-    'author' => 'Fabien Udriot',
-    'author_email' => 'fabien@ecodev.ch',
-    'state' => 'stable',
-    'version' => '6.0.0-dev',
-    'autoload' => [
-        'psr-4' => ['Fab\\Vidi\\' => 'Classes']
-    ],
-    'constraints' =>
-        [
-            'depends' =>
-                [
-                    'typo3' => '10.5.0-10.5.99',
-                ],
-            'conflicts' =>
-                [
-                ],
-            'suggests' =>
-                [
-                ],
-        ]
+	'title' => 'Versatile and Interactive Display - List Component',
+	'description' => 'Generic listing of records with versatile ways of interacting with the data, e.g. advanced filter, inline editing, mass editing, ... Veni, vidi, vici!',
+	'category' => 'module',
+	'author' => 'Fabien Udriot',
+	'author_email' => 'fabien@ecodev.ch',
+	'state' => 'stable',
+	'version' => '6.0.0-dev',
+	'autoload' => [
+		'psr-4' => ['Fab\\Vidi\\' => 'Classes']
+	],
+	'constraints' =>
+		[
+			'depends' =>
+				[
+					'typo3' => '10.5.0-10.5.99',
+				],
+			'conflicts' =>
+				[
+				],
+			'suggests' =>
+				[
+				],
+		]
 ];
\ No newline at end of file

Classes/Controller/ContentController.php

Indentation +745 added lines, -745 removed lines

@@ -44,750 +44,750 @@
  */
 class ContentController extends ActionController
 {
-    /**
-     * Initialize every action.
-     */
-    public function initializeAction()
-    {
-        $pageRenderer = GeneralUtility::makeInstance(PageRenderer::class);
-        $pageRenderer->addInlineLanguageLabelFile('EXT:vidi/Resources/Private/Language/locallang.xlf');
-
-        // Configure property mapping to retrieve the file object.
-        if ($this->arguments->hasArgument('columns')) {
-
-            /** @var CsvToArrayConverter $typeConverter */
-            $typeConverter = GeneralUtility::makeInstance(CsvToArrayConverter::class);
-
-            $propertyMappingConfiguration = $this->arguments->getArgument('columns')->getPropertyMappingConfiguration();
-            $propertyMappingConfiguration->setTypeConverter($typeConverter);
-        }
-    }
-
-    /**
-     * List action for this controller.
-     *
-     * @return void
-     */
-    public function indexAction(): ResponseInterface
-    {
-        $dataType = $this->getModuleLoader()->getDataType();
-        $selections = $this->selectionRepository->findByDataTypeForCurrentBackendUser($dataType);
-        $this->view->assign('selections', $selections);
-
-        $columns = Tca::grid()->getFields();
-        $this->view->assign('columns', $columns);
-        $this->view->assign('numberOfColumns', count($columns));
-        return $this->htmlResponse();
-    }
-
-    /**
-     * List Row action for this controller. Output a json list of contents
-     *
-     * @param array $columns corresponds to columns to be rendered.
-     * @param array $matches
-     * @Validate("Fab\Vidi\Domain\Validator\ColumnsValidator", param="columns")
-     * @Validate("Fab\Vidi\Domain\Validator\MatchesValidator", param="matches")
-     * @return void
-     */
-    public function listAction(array $columns = [], $matches = []): ResponseInterface
-    {
-        // Initialize some objects related to the query.
-        $matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
-        $order = OrderObjectFactory::getInstance()->getOrder();
-        $pager = PagerObjectFactory::getInstance()->getPager();
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher, $order, $pager->getLimit(), $pager->getOffset());
-        $pager->setCount($contentService->getNumberOfObjects());
-
-        // Assign values.
-        $this->view->assign('columns', $columns);
-        $this->view->assign('objects', $contentService->getObjects());
-        $this->view->assign('numberOfObjects', $contentService->getNumberOfObjects());
-        $this->view->assign('pager', $pager);
-
-        $this->view->assign('response', $this->responseFactory->createResponse());
-        return $this->htmlResponse();
-    }
-
-    /**
-     * Retrieve Content objects first according to matching criteria and then "update" them.
-     * Important to notice the field name can contains a path, e.g. metadata.title and therefore must be analysed.
-     *
-     * Possible values for $matches:
-     * -----------------------------
-     *
-     * $matches = array(uid => 1), will be taken as $query->equals
-     * $matches = array(uid => 1,2,3), will be taken as $query->in
-     * $matches = array(field_name1 => bar, field_name2 => bax), will be separated by AND.
-     *
-     * Possible values for $content:
-     * -----------------------------
-     *
-     * $content = array(field_name => bar)
-     * $content = array(field_name => array(value1, value2)) <-- will be CSV converted by "value1,value2"
-     *
-     * @param string $fieldNameAndPath
-     * @param array $content
-     * @param array $matches
-     * @param string $savingBehavior
-     * @param int $language
-     * @param array $columns
-     * @throws InvalidKeyInArrayException
-     */
-    public function updateAction($fieldNameAndPath, array $content, array $matches = [], $savingBehavior = SavingBehavior::REPLACE, $language = 0, $columns = [])
-    {
-
-        // Instantiate the Matcher object according different rules.
-        $matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
-        $order = OrderObjectFactory::getInstance()->getOrder();
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher, $order);
-
-        // Get the real field that is going to be updated.
-        $updatedFieldName = $this->getFieldPathResolver()->stripFieldPath($fieldNameAndPath);
-
-        // Get result object for storing data along the processing.
-        $result = $this->getJsonResult();
-        $result->setNumberOfObjects($contentService->getNumberOfObjects());
-
-        foreach ($contentService->getObjects() as $index => $object) {
-
-            $identifier = $this->getContentObjectResolver()->getValue($object, $fieldNameAndPath, 'uid', $language);
-
-            // It could be the identifier is not found because the translation
-            // of the record does not yet exist when mass-editing
-            if ((int)$identifier <= 0) {
-                continue;
-            }
-
-            $dataType = $this->getContentObjectResolver()->getDataType($object, $fieldNameAndPath);
-
-            $signalResult = $this->emitProcessContentDataSignal($object, $fieldNameAndPath, $content, $index + 1, $savingBehavior, $language);
-            $contentData = $signalResult->getContentData();
-
-            // Add identifier to content data, required by TCEMain.
-            $contentData['uid'] = $identifier;
-
-            /** @var Content $dataObject */
-            $dataObject = GeneralUtility::makeInstance(Content::class, $dataType, $contentData);
-
-            // Properly update object.
-            ContentRepositoryFactory::getInstance($dataType)->update($dataObject);
-
-            // Get the possible error messages and store them.
-            $errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
-            $result->addErrorMessages($errorMessages);
-
-            // We only want to see the detail result if there is one object updated.
-            // Required for inline editing + it will display some useful info on the GUI in the flash messages.
-            if ($contentService->getNumberOfObjects() === 1) {
-
-                // Fetch the updated object from repository.
-                $updatedObject = ContentRepositoryFactory::getInstance()->findByUid($object->getUid());
-
-                // Re-fetch the updated result.
-                $updatedResult = $this->getContentObjectResolver()->getValue($updatedObject, $fieldNameAndPath, $updatedFieldName, $language);
-                if (is_array($updatedResult)) {
-                    $_updatedResult = []; // reset result set.
-
-                    /** @var Content $contentObject */
-                    foreach ($updatedResult as $contentObject) {
-                        $labelField = Tca::table($contentObject)->getLabelField();
-                        $values = array(
-                            'uid' => $contentObject->getUid(),
-                            'name' => $contentObject[$labelField],
-                        );
-                        $_updatedResult[] = $values;
-                    }
-
-                    $updatedResult = $_updatedResult;
-                }
-
-                $labelField = Tca::table($object)->getLabelField();
-
-                $processedObjectData = array(
-                    'uid' => $object->getUid(),
-                    'name' => $object[$labelField],
-                    'updatedField' => $fieldNameAndPath,
-                    'updatedValue' => $updatedResult,
-                );
-                $result->setProcessedObject($processedObjectData);
-
-                if (!empty($columns)) {
-                    /** @var Row $row */
-                    $row = GeneralUtility::makeInstance(Row::class, $columns);
-                    $result->setRow($row->render($updatedObject));
-                }
-            }
-        }
-
-        $response = $this->responseFactory->createResponse()
-            ->withHeader('Content-Type', 'application/json; charset=utf-8');
-        $response->getBody()->write(json_encode($result));
-        return $response;
-    }
-
-    /**
-     * Set the sorting of a record giving the previous object.
-     *
-     * @param array $matches
-     * @param int $previousIdentifier
-     */
-    public function sortAction(array $matches = [], $previousIdentifier = null)
-    {
-
-        $matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher);
-
-        // Compute the label field name of the table.
-        $tableTitleField = Tca::table()->getLabelField();
-
-        // Get result object for storing data along the processing.
-        $result = $this->getJsonResult();
-        $result->setNumberOfObjects($contentService->getNumberOfObjects());
-
-        foreach ($contentService->getObjects() as $object) {
-
-            // Store the first object, so that the "action" message can be more explicit when deleting only one record.
-            if ($contentService->getNumberOfObjects() === 1) {
-                $tableTitleValue = $object[$tableTitleField];
-                $processedObjectData = array(
-                    'uid' => $object->getUid(),
-                    'name' => $tableTitleValue,
-                );
-                $result->setProcessedObject($processedObjectData);
-            }
-
-            // The $target corresponds to the pid to move the records to.
-            // It can also be a negative value in case of sorting. The negative value would be the uid of its predecessor.
-            $target = is_null($previousIdentifier) ? $object->getPid() : (-(int)$previousIdentifier);
-
-            // Work out the object.
-            ContentRepositoryFactory::getInstance()->move($object, $target);
-
-            // Get the possible error messages and store them.
-            $errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
-            $result->addErrorMessages($errorMessages);
-        }
-
-        $response = $this->responseFactory->createResponse()
-            ->withHeader('Content-Type', 'application/json; charset=utf-8');
-        $response->getBody()->write(json_encode($result));
-        return $response;
-    }
-
-    /**
-     * Returns an editing form for a given field name of a Content object.
-     * Argument $fieldNameAndPath corresponds to the field name to be edited.
-     * Important to notice it can contains a path, e.g. metadata.title and therefore must be analysed.
-     *
-     * Possible values for $matches, refer to method "updateAction".
-     *
-     * @param string $fieldNameAndPath
-     * @param array $matches
-     * @param bool $hasRecursiveSelection
-     * @throws \Exception
-     */
-    public function editAction($fieldNameAndPath, array $matches = [], $hasRecursiveSelection = false): ResponseInterface
-    {
-
-        // Instantiate the Matcher object according different rules.
-        $matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher);
-
-        $dataType = $this->getFieldPathResolver()->getDataType($fieldNameAndPath);
-        $fieldName = $this->getFieldPathResolver()->stripFieldPath($fieldNameAndPath);
-
-        $fieldType = Tca::table($dataType)->field($fieldName)->getType();
-        $this->view->assign('fieldType', ucfirst($fieldType));
-        $this->view->assign('dataType', $dataType);
-        $this->view->assign('fieldName', $fieldName);
-        $this->view->assign('matches', $matches);
-        $this->view->assign('fieldNameAndPath', $fieldNameAndPath);
-        $this->view->assign('numberOfObjects', $contentService->getNumberOfObjects());
-        $this->view->assign('hasRecursiveSelection', $hasRecursiveSelection);
-        $this->view->assign('editWholeSelection', empty($matches['uid'])); // necessary??
-
-        // Fetch content and its relations.
-        if ($fieldType === FieldType::MULTISELECT) {
-
-            $object = ContentRepositoryFactory::getInstance()->findOneBy($matcher);
-            $identifier = $this->getContentObjectResolver()->getValue($object, $fieldNameAndPath, 'uid');
-            $dataType = $this->getContentObjectResolver()->getDataType($object, $fieldNameAndPath);
-
-            $content = ContentRepositoryFactory::getInstance($dataType)->findByUid($identifier);
-
-            // Makes sure the object was retrieved. Security!
-            if (!$content) {
-                $message = sprintf('I could not retrieved content object of type "%s" with identifier %s.', $dataType, $identifier);
-                throw new \Exception($message, 1402350182);
-            }
-
-            $relatedDataType = Tca::table($dataType)->field($fieldName)->getForeignTable();
-
-            // Initialize the matcher object.
-            /** @var Matcher $matcher */
-            $matcher = GeneralUtility::makeInstance(Matcher::class, [], $relatedDataType);
-
-            // Default ordering for related data type.
-            $defaultOrderings = Tca::table($relatedDataType)->getDefaultOrderings();
-            /** @var Order $order */
-            $defaultOrder = GeneralUtility::makeInstance(Order::class, $defaultOrderings);
-
-            // Fetch related contents
-            $relatedContents = ContentRepositoryFactory::getInstance($relatedDataType)->findBy($matcher, $defaultOrder);
-
-            if (Tca::table($dataType)->field($fieldName)->isRenderModeTree()) {
-
-                $fieldConfiguration = Tca::table($dataType)->field($fieldName)->getConfiguration();
-                $parentField = $fieldConfiguration['treeConfig']['parentField'];
-
-                $flatTree = [];
-                foreach ($relatedContents as $node) {
-                    $flatTree[$node->getUid()] = array(
-                        'item' => $node,
-                        'parent' => $node[$parentField] ? $node[$parentField]['uid'] : null,
-                    );
-                }
-
-                $tree = [];
-
-                // If leaves are selected without its parents selected, those are shown as parent
-                foreach ($flatTree as $id => &$flatNode) {
-                    if (!isset($flatTree[$flatNode['parent']])) {
-                        $flatNode['parent'] = null;
-                    }
-                }
-
-                foreach ($flatTree as $id => &$node) {
-                    if ($node['parent'] === null) {
-                        $tree[$id] = &$node;
-                    } else {
-                        $flatTree[$node['parent']]['children'][$id] = &$node;
-                    }
-                }
-
-                $relatedContents = $tree;
-            }
-
-            $this->view->assign('content', $content);
-            $this->view->assign('relatedContents', $relatedContents);
-            $this->view->assign('relatedDataType', $relatedDataType);
-            $this->view->assign('relatedContentTitle', Tca::table($relatedDataType)->getTitle());
-            $this->view->assign(
-                'renderMode',
-                Tca::table($dataType)->field($fieldName)->isRenderModeTree() ? FieldType::TREE : null
-            );
-        }
-        return $this->htmlResponse();
-    }
-
-    /**
-     * Retrieve Content objects first according to matching criteria and then "delete" them.
-     *
-     * Possible values for $matches, refer to method "updateAction".
-     *
-     * @param array $matches
-     */
-    public function deleteAction(array $matches = [])
-    {
-
-        $matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher);
-
-        // Compute the label field name of the table.
-        $tableTitleField = Tca::table()->getLabelField();
-
-        // Get result object for storing data along the processing.
-        $result = $this->getJsonResult();
-        $result->setNumberOfObjects($contentService->getNumberOfObjects());
-
-        foreach ($contentService->getObjects() as $object) {
-
-            // Store the first object, so that the delete message can be more explicit when deleting only one record.
-            if ($contentService->getNumberOfObjects() === 1) {
-                $tableTitleValue = $object[$tableTitleField];
-                $processedObjectData = array(
-                    'uid' => $object->getUid(),
-                    'name' => $tableTitleValue,
-                );
-                $result->setProcessedObject($processedObjectData);
-            }
-
-            // Properly delete object.
-            ContentRepositoryFactory::getInstance()->remove($object);
-
-            // Get the possible error messages and store them.
-            $errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
-            $result->addErrorMessages($errorMessages);
-        }
-
-        $response = $this->responseFactory->createResponse()
-            ->withHeader('Content-Type', 'application/json; charset=utf-8');
-        $response->getBody()->write(json_encode($result));
-        return $response;
-    }
-
-    /**
-     * Retrieve Content objects first according to matching criteria and then "copy" them.
-     *
-     * Possible values for $matches, refer to method "updateAction".
-     *
-     * @param string $target
-     * @param array $matches
-     * @throws \Exception
-     * @return string
-     */
-    public function copyAction($target, array $matches = [])
-    {
-        // @todo
-        throw new \Exception('Not yet implemented', 1410192546);
-    }
-
-    /**
-     * Retrieve Content objects from the Clipboard then "copy" them according to the target.
-     *
-     * @param string $target
-     * @throws \Exception
-     */
-    public function copyClipboardAction($target)
-    {
-
-        // Retrieve matcher object from clipboard.
-        $matcher = $this->getClipboardService()->getMatcher();
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher);
-
-        // Compute the label field name of the table.
-        $tableTitleField = Tca::table()->getLabelField();
-
-        // Get result object for storing data along the processing.
-        $result = $this->getJsonResult();
-        $result->setNumberOfObjects($contentService->getNumberOfObjects());
-
-        foreach ($contentService->getObjects() as $object) {
-
-            // Store the first object, so that the "action" message can be more explicit when deleting only one record.
-            if ($contentService->getNumberOfObjects() === 1) {
-                $tableTitleValue = $object[$tableTitleField];
-                $processedObjectData = array(
-                    'uid' => $object->getUid(),
-                    'name' => $tableTitleValue,
-                );
-                $result->setProcessedObject($processedObjectData);
-            }
-
-            // Work out the object.
-            ContentRepositoryFactory::getInstance()->copy($object, $target);
-
-            // Get the possible error messages and store them.
-            $errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
-            $result->addErrorMessages($errorMessages);
-        }
-
-        // Flush Clipboard if told so.
-        if (GeneralUtility::_GP('flushClipboard')) {
-            $this->getClipboardService()->flush();
-        }
-
-        $response = $this->responseFactory->createResponse()
-            ->withHeader('Content-Type', 'application/json; charset=utf-8');
-        $response->getBody()->write(json_encode($result));
-        return $response;
-    }
-
-    /**
-     * Retrieve Content objects first according to matching criteria and then "move" them.
-     *
-     * Possible values for $matches, refer to method "updateAction".
-     *
-     * @param string $target
-     * @param array $matches
-     */
-    public function moveAction($target, array $matches = [])
-    {
-
-        $matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher);
-
-        // Compute the label field name of the table.
-        $tableTitleField = Tca::table()->getLabelField();
-
-        // Get result object for storing data along the processing.
-        $result = $this->getJsonResult();
-        $result->setNumberOfObjects($contentService->getNumberOfObjects());
-
-        foreach ($contentService->getObjects() as $object) {
-
-            // Store the first object, so that the "action" message can be more explicit when deleting only one record.
-            if ($contentService->getNumberOfObjects() === 1) {
-                $tableTitleValue = $object[$tableTitleField];
-                $processedObjectData = array(
-                    'uid' => $object->getUid(),
-                    'name' => $tableTitleValue,
-                );
-                $result->setProcessedObject($processedObjectData);
-            }
-
-            // Work out the object.
-            ContentRepositoryFactory::getInstance()->move($object, $target);
-
-            // Get the possible error messages and store them.
-            $errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
-            $result->addErrorMessages($errorMessages);
-        }
-
-        $response = $this->responseFactory->createResponse()
-            ->withHeader('Content-Type', 'application/json; charset=utf-8');
-        $response->getBody()->write(json_encode($result));
-        return $response;
-    }
-
-    /**
-     * Retrieve Content objects from the Clipboard then "move" them according to the target.
-     *
-     * @param string $target
-     */
-    public function moveClipboardAction($target)
-    {
-
-        // Retrieve matcher object from clipboard.
-        $matcher = $this->getClipboardService()->getMatcher();
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher);
-
-        // Compute the label field name of the table.
-        $tableTitleField = Tca::table()->getLabelField();
-
-        // Get result object for storing data along the processing.
-        $result = $this->getJsonResult();
-        $result->setNumberOfObjects($contentService->getNumberOfObjects());
-
-        foreach ($contentService->getObjects() as $object) {
-
-            // Store the first object, so that the "action" message can be more explicit when deleting only one record.
-            if ($contentService->getNumberOfObjects() === 1) {
-                $tableTitleValue = $object[$tableTitleField];
-                $processedObjectData = array(
-                    'uid' => $object->getUid(),
-                    'name' => $tableTitleValue,
-                );
-                $result->setProcessedObject($processedObjectData);
-            }
-
-            // Work out the object.
-            ContentRepositoryFactory::getInstance()->move($object, $target);
-
-            // Get the possible error messages and store them.
-            $errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
-            $result->addErrorMessages($errorMessages);
-        }
-
-        // Flush Clipboard if told so.
-        if (GeneralUtility::_GP('flushClipboard')) {
-            $this->getClipboardService()->flush();
-        }
-
-        $response = $this->responseFactory->createResponse()
-            ->withHeader('Content-Type', 'application/json; charset=utf-8');
-        $response->getBody()->write(json_encode($result));
-        return $response;
-    }
-
-    /**
-     * Retrieve Content objects first according to matching criteria and then "localize" them.
-     *
-     * Possible values for $matches, refer to method "updateAction".
-     *
-     * @param string $fieldNameAndPath
-     * @param array $matches
-     * @param int $language
-     * @throws \Exception
-     */
-    public function localizeAction($fieldNameAndPath, array $matches = [], $language = 0)
-    {
-
-        $matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
-
-        // Fetch objects via the Content Service.
-        $contentService = $this->getContentService()->findBy($matcher);
-
-        // Get result object for storing data along the processing.
-        $result = $this->getJsonResult();
-        $result->setNumberOfObjects($contentService->getNumberOfObjects());
-
-        foreach ($contentService->getObjects() as $object) {
-
-            $identifier = $this->getContentObjectResolver()->getValue($object, $fieldNameAndPath, 'uid');
-            $dataType = $this->getContentObjectResolver()->getDataType($object, $fieldNameAndPath);
-
-            // Fetch the source object to be localized.
-            /** @var Content $content */
-            $content = ContentRepositoryFactory::getInstance($dataType)->findByIdentifier($identifier);
-
-            // Makes sure the object was retrieved. Security!
-            if (!$content) {
-                $message = sprintf('Something went wrong when retrieving content "%s" with identifier "%s".', $dataType, $identifier);
-                throw new \Exception($message, 1412343097);
-            }
-
-            // Handover the localization to the Repository.
-            ContentRepositoryFactory::getInstance($dataType)->localize($content, $language);
-
-            // Get the possible error messages and store them.
-            $errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
-
-            // Redirect to TCEForm so that the BE User can do its job!
-            if ($contentService->getNumberOfObjects() === 1) {
-
-                if (!empty($errorMessages)) {
-                    $message = sprintf('Something went wrong when localizing content "%s" with identifier "%s". <br/>%s',
-                        $dataType,
-                        $identifier,
-                        implode('<br/>', $errorMessages)
-                    );
-                    throw new \Exception($message, 1412343098);
-                }
-
-                $localizedContent = $this->getLanguageService()->getLocalizedContent($content, $language);
-                if (empty($localizedContent)) {
-                    $message = sprintf('Oups! I could not retrieve localized content of type "%s" with identifier "%s"',
-                        $content->getDataType(),
-                        $content->getUid()
-                    );
-                    throw new \Exception($message, 1412343099);
-                }
-
-                /** @var EditUri $uri */
-                $uriRenderer = GeneralUtility::makeInstance(EditUri::class);
-                $uri = $uriRenderer->render($localizedContent);
-                HttpUtility::redirect($uri);
-                break; // no need to further continue
-            }
-
-            $result->addErrorMessages($errorMessages);
-        }
-
-        $response = $this->responseFactory->createResponse()
-            ->withHeader('Content-Type', 'application/json; charset=utf-8');
-        $response->getBody()->write(json_encode($result));
-        return $response;
-    }
-
-    /**
-     * Get the Vidi Module Loader.
-     *
-     * @return ContentService
-     */
-    protected function getContentService()
-    {
-        return GeneralUtility::makeInstance(ContentService::class);
-    }
-
-    /**
-     * @return ContentObjectResolver
-     */
-    protected function getContentObjectResolver()
-    {
-        return GeneralUtility::makeInstance(ContentObjectResolver::class);
-    }
-
-    /**
-     * @return FieldPathResolver
-     */
-    protected function getFieldPathResolver()
-    {
-        return GeneralUtility::makeInstance(FieldPathResolver::class);
-    }
-
-    /**
-     * @return JsonResult|object
-     */
-    protected function getJsonResult()
-    {
-        return GeneralUtility::makeInstance(JsonResult::class);
-    }
-
-    /**
-     * Signal that is called for post-processing content data send to the server for update.
-     *
-     * @param Content $contentObject
-     * @param $fieldNameAndPath
-     * @param $contentData
-     * @param $counter
-     * @param $savingBehavior
-     * @param $language
-     * @return ProcessContentDataSignalArguments
-     */
-    protected function emitProcessContentDataSignal(Content $contentObject, $fieldNameAndPath, $contentData, $counter, $savingBehavior, $language)
-    {
-
-        /** @var ProcessContentDataSignalArguments $signalArguments */
-        $signalArguments = GeneralUtility::makeInstance(ProcessContentDataSignalArguments::class);
-        $signalArguments->setContentObject($contentObject)
-            ->setFieldNameAndPath($fieldNameAndPath)
-            ->setContentData($contentData)
-            ->setCounter($counter)
-            ->setSavingBehavior($savingBehavior)
-            ->setLanguage($language);
-
-        $signalResult = $this->getSignalSlotDispatcher()->dispatch('Fab\Vidi\Controller\Backend\ContentController', 'processContentData', array($signalArguments));
-        return $signalResult[0];
-    }
-
-    /**
-     * Get the SignalSlot dispatcher.
-     *
-     * @return Dispatcher
-     */
-    protected function getSignalSlotDispatcher()
-    {
-        return GeneralUtility::makeInstance(Dispatcher::class);
-    }
-
-    /**
-     * Get the Clipboard service.
-     *
-     * @return ClipboardService
-     */
-    protected function getClipboardService()
-    {
-        return GeneralUtility::makeInstance(ClipboardService::class);
-    }
-
-    /**
-     * @return LanguageService
-     */
-    protected function getLanguageService()
-    {
-        return GeneralUtility::makeInstance(LanguageService::class);
-    }
-
-    /**
-     * Get the Vidi Module Loader.
-     *
-     * @return ModuleLoader
-     */
-    protected function getModuleLoader()
-    {
-        return GeneralUtility::makeInstance(ModuleLoader::class);
-    }
-
-    public function injectSelectionRepository(SelectionRepository $selectionRepository): void
-    {
-        $this->selectionRepository = $selectionRepository;
-    }
+	/**
+	 * Initialize every action.
+	 */
+	public function initializeAction()
+	{
+		$pageRenderer = GeneralUtility::makeInstance(PageRenderer::class);
+		$pageRenderer->addInlineLanguageLabelFile('EXT:vidi/Resources/Private/Language/locallang.xlf');
+
+		// Configure property mapping to retrieve the file object.
+		if ($this->arguments->hasArgument('columns')) {
+
+			/** @var CsvToArrayConverter $typeConverter */
+			$typeConverter = GeneralUtility::makeInstance(CsvToArrayConverter::class);
+
+			$propertyMappingConfiguration = $this->arguments->getArgument('columns')->getPropertyMappingConfiguration();
+			$propertyMappingConfiguration->setTypeConverter($typeConverter);
+		}
+	}
+
+	/**
+	 * List action for this controller.
+	 *
+	 * @return void
+	 */
+	public function indexAction(): ResponseInterface
+	{
+		$dataType = $this->getModuleLoader()->getDataType();
+		$selections = $this->selectionRepository->findByDataTypeForCurrentBackendUser($dataType);
+		$this->view->assign('selections', $selections);
+
+		$columns = Tca::grid()->getFields();
+		$this->view->assign('columns', $columns);
+		$this->view->assign('numberOfColumns', count($columns));
+		return $this->htmlResponse();
+	}
+
+	/**
+	 * List Row action for this controller. Output a json list of contents
+	 *
+	 * @param array $columns corresponds to columns to be rendered.
+	 * @param array $matches
+	 * @Validate("Fab\Vidi\Domain\Validator\ColumnsValidator", param="columns")
+	 * @Validate("Fab\Vidi\Domain\Validator\MatchesValidator", param="matches")
+	 * @return void
+	 */
+	public function listAction(array $columns = [], $matches = []): ResponseInterface
+	{
+		// Initialize some objects related to the query.
+		$matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
+		$order = OrderObjectFactory::getInstance()->getOrder();
+		$pager = PagerObjectFactory::getInstance()->getPager();
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher, $order, $pager->getLimit(), $pager->getOffset());
+		$pager->setCount($contentService->getNumberOfObjects());
+
+		// Assign values.
+		$this->view->assign('columns', $columns);
+		$this->view->assign('objects', $contentService->getObjects());
+		$this->view->assign('numberOfObjects', $contentService->getNumberOfObjects());
+		$this->view->assign('pager', $pager);
+
+		$this->view->assign('response', $this->responseFactory->createResponse());
+		return $this->htmlResponse();
+	}
+
+	/**
+	 * Retrieve Content objects first according to matching criteria and then "update" them.
+	 * Important to notice the field name can contains a path, e.g. metadata.title and therefore must be analysed.
+	 *
+	 * Possible values for $matches:
+	 * -----------------------------
+	 *
+	 * $matches = array(uid => 1), will be taken as $query->equals
+	 * $matches = array(uid => 1,2,3), will be taken as $query->in
+	 * $matches = array(field_name1 => bar, field_name2 => bax), will be separated by AND.
+	 *
+	 * Possible values for $content:
+	 * -----------------------------
+	 *
+	 * $content = array(field_name => bar)
+	 * $content = array(field_name => array(value1, value2)) <-- will be CSV converted by "value1,value2"
+	 *
+	 * @param string $fieldNameAndPath
+	 * @param array $content
+	 * @param array $matches
+	 * @param string $savingBehavior
+	 * @param int $language
+	 * @param array $columns
+	 * @throws InvalidKeyInArrayException
+	 */
+	public function updateAction($fieldNameAndPath, array $content, array $matches = [], $savingBehavior = SavingBehavior::REPLACE, $language = 0, $columns = [])
+	{
+
+		// Instantiate the Matcher object according different rules.
+		$matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
+		$order = OrderObjectFactory::getInstance()->getOrder();
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher, $order);
+
+		// Get the real field that is going to be updated.
+		$updatedFieldName = $this->getFieldPathResolver()->stripFieldPath($fieldNameAndPath);
+
+		// Get result object for storing data along the processing.
+		$result = $this->getJsonResult();
+		$result->setNumberOfObjects($contentService->getNumberOfObjects());
+
+		foreach ($contentService->getObjects() as $index => $object) {
+
+			$identifier = $this->getContentObjectResolver()->getValue($object, $fieldNameAndPath, 'uid', $language);
+
+			// It could be the identifier is not found because the translation
+			// of the record does not yet exist when mass-editing
+			if ((int)$identifier <= 0) {
+				continue;
+			}
+
+			$dataType = $this->getContentObjectResolver()->getDataType($object, $fieldNameAndPath);
+
+			$signalResult = $this->emitProcessContentDataSignal($object, $fieldNameAndPath, $content, $index + 1, $savingBehavior, $language);
+			$contentData = $signalResult->getContentData();
+
+			// Add identifier to content data, required by TCEMain.
+			$contentData['uid'] = $identifier;
+
+			/** @var Content $dataObject */
+			$dataObject = GeneralUtility::makeInstance(Content::class, $dataType, $contentData);
+
+			// Properly update object.
+			ContentRepositoryFactory::getInstance($dataType)->update($dataObject);
+
+			// Get the possible error messages and store them.
+			$errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
+			$result->addErrorMessages($errorMessages);
+
+			// We only want to see the detail result if there is one object updated.
+			// Required for inline editing + it will display some useful info on the GUI in the flash messages.
+			if ($contentService->getNumberOfObjects() === 1) {
+
+				// Fetch the updated object from repository.
+				$updatedObject = ContentRepositoryFactory::getInstance()->findByUid($object->getUid());
+
+				// Re-fetch the updated result.
+				$updatedResult = $this->getContentObjectResolver()->getValue($updatedObject, $fieldNameAndPath, $updatedFieldName, $language);
+				if (is_array($updatedResult)) {
+					$_updatedResult = []; // reset result set.
+
+					/** @var Content $contentObject */
+					foreach ($updatedResult as $contentObject) {
+						$labelField = Tca::table($contentObject)->getLabelField();
+						$values = array(
+							'uid' => $contentObject->getUid(),
+							'name' => $contentObject[$labelField],
+						);
+						$_updatedResult[] = $values;
+					}
+
+					$updatedResult = $_updatedResult;
+				}
+
+				$labelField = Tca::table($object)->getLabelField();
+
+				$processedObjectData = array(
+					'uid' => $object->getUid(),
+					'name' => $object[$labelField],
+					'updatedField' => $fieldNameAndPath,
+					'updatedValue' => $updatedResult,
+				);
+				$result->setProcessedObject($processedObjectData);
+
+				if (!empty($columns)) {
+					/** @var Row $row */
+					$row = GeneralUtility::makeInstance(Row::class, $columns);
+					$result->setRow($row->render($updatedObject));
+				}
+			}
+		}
+
+		$response = $this->responseFactory->createResponse()
+			->withHeader('Content-Type', 'application/json; charset=utf-8');
+		$response->getBody()->write(json_encode($result));
+		return $response;
+	}
+
+	/**
+	 * Set the sorting of a record giving the previous object.
+	 *
+	 * @param array $matches
+	 * @param int $previousIdentifier
+	 */
+	public function sortAction(array $matches = [], $previousIdentifier = null)
+	{
+
+		$matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher);
+
+		// Compute the label field name of the table.
+		$tableTitleField = Tca::table()->getLabelField();
+
+		// Get result object for storing data along the processing.
+		$result = $this->getJsonResult();
+		$result->setNumberOfObjects($contentService->getNumberOfObjects());
+
+		foreach ($contentService->getObjects() as $object) {
+
+			// Store the first object, so that the "action" message can be more explicit when deleting only one record.
+			if ($contentService->getNumberOfObjects() === 1) {
+				$tableTitleValue = $object[$tableTitleField];
+				$processedObjectData = array(
+					'uid' => $object->getUid(),
+					'name' => $tableTitleValue,
+				);
+				$result->setProcessedObject($processedObjectData);
+			}
+
+			// The $target corresponds to the pid to move the records to.
+			// It can also be a negative value in case of sorting. The negative value would be the uid of its predecessor.
+			$target = is_null($previousIdentifier) ? $object->getPid() : (-(int)$previousIdentifier);
+
+			// Work out the object.
+			ContentRepositoryFactory::getInstance()->move($object, $target);
+
+			// Get the possible error messages and store them.
+			$errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
+			$result->addErrorMessages($errorMessages);
+		}
+
+		$response = $this->responseFactory->createResponse()
+			->withHeader('Content-Type', 'application/json; charset=utf-8');
+		$response->getBody()->write(json_encode($result));
+		return $response;
+	}
+
+	/**
+	 * Returns an editing form for a given field name of a Content object.
+	 * Argument $fieldNameAndPath corresponds to the field name to be edited.
+	 * Important to notice it can contains a path, e.g. metadata.title and therefore must be analysed.
+	 *
+	 * Possible values for $matches, refer to method "updateAction".
+	 *
+	 * @param string $fieldNameAndPath
+	 * @param array $matches
+	 * @param bool $hasRecursiveSelection
+	 * @throws \Exception
+	 */
+	public function editAction($fieldNameAndPath, array $matches = [], $hasRecursiveSelection = false): ResponseInterface
+	{
+
+		// Instantiate the Matcher object according different rules.
+		$matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher);
+
+		$dataType = $this->getFieldPathResolver()->getDataType($fieldNameAndPath);
+		$fieldName = $this->getFieldPathResolver()->stripFieldPath($fieldNameAndPath);
+
+		$fieldType = Tca::table($dataType)->field($fieldName)->getType();
+		$this->view->assign('fieldType', ucfirst($fieldType));
+		$this->view->assign('dataType', $dataType);
+		$this->view->assign('fieldName', $fieldName);
+		$this->view->assign('matches', $matches);
+		$this->view->assign('fieldNameAndPath', $fieldNameAndPath);
+		$this->view->assign('numberOfObjects', $contentService->getNumberOfObjects());
+		$this->view->assign('hasRecursiveSelection', $hasRecursiveSelection);
+		$this->view->assign('editWholeSelection', empty($matches['uid'])); // necessary??
+
+		// Fetch content and its relations.
+		if ($fieldType === FieldType::MULTISELECT) {
+
+			$object = ContentRepositoryFactory::getInstance()->findOneBy($matcher);
+			$identifier = $this->getContentObjectResolver()->getValue($object, $fieldNameAndPath, 'uid');
+			$dataType = $this->getContentObjectResolver()->getDataType($object, $fieldNameAndPath);
+
+			$content = ContentRepositoryFactory::getInstance($dataType)->findByUid($identifier);
+
+			// Makes sure the object was retrieved. Security!
+			if (!$content) {
+				$message = sprintf('I could not retrieved content object of type "%s" with identifier %s.', $dataType, $identifier);
+				throw new \Exception($message, 1402350182);
+			}
+
+			$relatedDataType = Tca::table($dataType)->field($fieldName)->getForeignTable();
+
+			// Initialize the matcher object.
+			/** @var Matcher $matcher */
+			$matcher = GeneralUtility::makeInstance(Matcher::class, [], $relatedDataType);
+
+			// Default ordering for related data type.
+			$defaultOrderings = Tca::table($relatedDataType)->getDefaultOrderings();
+			/** @var Order $order */
+			$defaultOrder = GeneralUtility::makeInstance(Order::class, $defaultOrderings);
+
+			// Fetch related contents
+			$relatedContents = ContentRepositoryFactory::getInstance($relatedDataType)->findBy($matcher, $defaultOrder);
+
+			if (Tca::table($dataType)->field($fieldName)->isRenderModeTree()) {
+
+				$fieldConfiguration = Tca::table($dataType)->field($fieldName)->getConfiguration();
+				$parentField = $fieldConfiguration['treeConfig']['parentField'];
+
+				$flatTree = [];
+				foreach ($relatedContents as $node) {
+					$flatTree[$node->getUid()] = array(
+						'item' => $node,
+						'parent' => $node[$parentField] ? $node[$parentField]['uid'] : null,
+					);
+				}
+
+				$tree = [];
+
+				// If leaves are selected without its parents selected, those are shown as parent
+				foreach ($flatTree as $id => &$flatNode) {
+					if (!isset($flatTree[$flatNode['parent']])) {
+						$flatNode['parent'] = null;
+					}
+				}
+
+				foreach ($flatTree as $id => &$node) {
+					if ($node['parent'] === null) {
+						$tree[$id] = &$node;
+					} else {
+						$flatTree[$node['parent']]['children'][$id] = &$node;
+					}
+				}
+
+				$relatedContents = $tree;
+			}
+
+			$this->view->assign('content', $content);
+			$this->view->assign('relatedContents', $relatedContents);
+			$this->view->assign('relatedDataType', $relatedDataType);
+			$this->view->assign('relatedContentTitle', Tca::table($relatedDataType)->getTitle());
+			$this->view->assign(
+				'renderMode',
+				Tca::table($dataType)->field($fieldName)->isRenderModeTree() ? FieldType::TREE : null
+			);
+		}
+		return $this->htmlResponse();
+	}
+
+	/**
+	 * Retrieve Content objects first according to matching criteria and then "delete" them.
+	 *
+	 * Possible values for $matches, refer to method "updateAction".
+	 *
+	 * @param array $matches
+	 */
+	public function deleteAction(array $matches = [])
+	{
+
+		$matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher);
+
+		// Compute the label field name of the table.
+		$tableTitleField = Tca::table()->getLabelField();
+
+		// Get result object for storing data along the processing.
+		$result = $this->getJsonResult();
+		$result->setNumberOfObjects($contentService->getNumberOfObjects());
+
+		foreach ($contentService->getObjects() as $object) {
+
+			// Store the first object, so that the delete message can be more explicit when deleting only one record.
+			if ($contentService->getNumberOfObjects() === 1) {
+				$tableTitleValue = $object[$tableTitleField];
+				$processedObjectData = array(
+					'uid' => $object->getUid(),
+					'name' => $tableTitleValue,
+				);
+				$result->setProcessedObject($processedObjectData);
+			}
+
+			// Properly delete object.
+			ContentRepositoryFactory::getInstance()->remove($object);
+
+			// Get the possible error messages and store them.
+			$errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
+			$result->addErrorMessages($errorMessages);
+		}
+
+		$response = $this->responseFactory->createResponse()
+			->withHeader('Content-Type', 'application/json; charset=utf-8');
+		$response->getBody()->write(json_encode($result));
+		return $response;
+	}
+
+	/**
+	 * Retrieve Content objects first according to matching criteria and then "copy" them.
+	 *
+	 * Possible values for $matches, refer to method "updateAction".
+	 *
+	 * @param string $target
+	 * @param array $matches
+	 * @throws \Exception
+	 * @return string
+	 */
+	public function copyAction($target, array $matches = [])
+	{
+		// @todo
+		throw new \Exception('Not yet implemented', 1410192546);
+	}
+
+	/**
+	 * Retrieve Content objects from the Clipboard then "copy" them according to the target.
+	 *
+	 * @param string $target
+	 * @throws \Exception
+	 */
+	public function copyClipboardAction($target)
+	{
+
+		// Retrieve matcher object from clipboard.
+		$matcher = $this->getClipboardService()->getMatcher();
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher);
+
+		// Compute the label field name of the table.
+		$tableTitleField = Tca::table()->getLabelField();
+
+		// Get result object for storing data along the processing.
+		$result = $this->getJsonResult();
+		$result->setNumberOfObjects($contentService->getNumberOfObjects());
+
+		foreach ($contentService->getObjects() as $object) {
+
+			// Store the first object, so that the "action" message can be more explicit when deleting only one record.
+			if ($contentService->getNumberOfObjects() === 1) {
+				$tableTitleValue = $object[$tableTitleField];
+				$processedObjectData = array(
+					'uid' => $object->getUid(),
+					'name' => $tableTitleValue,
+				);
+				$result->setProcessedObject($processedObjectData);
+			}
+
+			// Work out the object.
+			ContentRepositoryFactory::getInstance()->copy($object, $target);
+
+			// Get the possible error messages and store them.
+			$errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
+			$result->addErrorMessages($errorMessages);
+		}
+
+		// Flush Clipboard if told so.
+		if (GeneralUtility::_GP('flushClipboard')) {
+			$this->getClipboardService()->flush();
+		}
+
+		$response = $this->responseFactory->createResponse()
+			->withHeader('Content-Type', 'application/json; charset=utf-8');
+		$response->getBody()->write(json_encode($result));
+		return $response;
+	}
+
+	/**
+	 * Retrieve Content objects first according to matching criteria and then "move" them.
+	 *
+	 * Possible values for $matches, refer to method "updateAction".
+	 *
+	 * @param string $target
+	 * @param array $matches
+	 */
+	public function moveAction($target, array $matches = [])
+	{
+
+		$matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher);
+
+		// Compute the label field name of the table.
+		$tableTitleField = Tca::table()->getLabelField();
+
+		// Get result object for storing data along the processing.
+		$result = $this->getJsonResult();
+		$result->setNumberOfObjects($contentService->getNumberOfObjects());
+
+		foreach ($contentService->getObjects() as $object) {
+
+			// Store the first object, so that the "action" message can be more explicit when deleting only one record.
+			if ($contentService->getNumberOfObjects() === 1) {
+				$tableTitleValue = $object[$tableTitleField];
+				$processedObjectData = array(
+					'uid' => $object->getUid(),
+					'name' => $tableTitleValue,
+				);
+				$result->setProcessedObject($processedObjectData);
+			}
+
+			// Work out the object.
+			ContentRepositoryFactory::getInstance()->move($object, $target);
+
+			// Get the possible error messages and store them.
+			$errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
+			$result->addErrorMessages($errorMessages);
+		}
+
+		$response = $this->responseFactory->createResponse()
+			->withHeader('Content-Type', 'application/json; charset=utf-8');
+		$response->getBody()->write(json_encode($result));
+		return $response;
+	}
+
+	/**
+	 * Retrieve Content objects from the Clipboard then "move" them according to the target.
+	 *
+	 * @param string $target
+	 */
+	public function moveClipboardAction($target)
+	{
+
+		// Retrieve matcher object from clipboard.
+		$matcher = $this->getClipboardService()->getMatcher();
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher);
+
+		// Compute the label field name of the table.
+		$tableTitleField = Tca::table()->getLabelField();
+
+		// Get result object for storing data along the processing.
+		$result = $this->getJsonResult();
+		$result->setNumberOfObjects($contentService->getNumberOfObjects());
+
+		foreach ($contentService->getObjects() as $object) {
+
+			// Store the first object, so that the "action" message can be more explicit when deleting only one record.
+			if ($contentService->getNumberOfObjects() === 1) {
+				$tableTitleValue = $object[$tableTitleField];
+				$processedObjectData = array(
+					'uid' => $object->getUid(),
+					'name' => $tableTitleValue,
+				);
+				$result->setProcessedObject($processedObjectData);
+			}
+
+			// Work out the object.
+			ContentRepositoryFactory::getInstance()->move($object, $target);
+
+			// Get the possible error messages and store them.
+			$errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
+			$result->addErrorMessages($errorMessages);
+		}
+
+		// Flush Clipboard if told so.
+		if (GeneralUtility::_GP('flushClipboard')) {
+			$this->getClipboardService()->flush();
+		}
+
+		$response = $this->responseFactory->createResponse()
+			->withHeader('Content-Type', 'application/json; charset=utf-8');
+		$response->getBody()->write(json_encode($result));
+		return $response;
+	}
+
+	/**
+	 * Retrieve Content objects first according to matching criteria and then "localize" them.
+	 *
+	 * Possible values for $matches, refer to method "updateAction".
+	 *
+	 * @param string $fieldNameAndPath
+	 * @param array $matches
+	 * @param int $language
+	 * @throws \Exception
+	 */
+	public function localizeAction($fieldNameAndPath, array $matches = [], $language = 0)
+	{
+
+		$matcher = MatcherObjectFactory::getInstance()->getMatcher($matches);
+
+		// Fetch objects via the Content Service.
+		$contentService = $this->getContentService()->findBy($matcher);
+
+		// Get result object for storing data along the processing.
+		$result = $this->getJsonResult();
+		$result->setNumberOfObjects($contentService->getNumberOfObjects());
+
+		foreach ($contentService->getObjects() as $object) {
+
+			$identifier = $this->getContentObjectResolver()->getValue($object, $fieldNameAndPath, 'uid');
+			$dataType = $this->getContentObjectResolver()->getDataType($object, $fieldNameAndPath);
+
+			// Fetch the source object to be localized.
+			/** @var Content $content */
+			$content = ContentRepositoryFactory::getInstance($dataType)->findByIdentifier($identifier);
+
+			// Makes sure the object was retrieved. Security!
+			if (!$content) {
+				$message = sprintf('Something went wrong when retrieving content "%s" with identifier "%s".', $dataType, $identifier);
+				throw new \Exception($message, 1412343097);
+			}
+
+			// Handover the localization to the Repository.
+			ContentRepositoryFactory::getInstance($dataType)->localize($content, $language);
+
+			// Get the possible error messages and store them.
+			$errorMessages = ContentRepositoryFactory::getInstance()->getErrorMessages();
+
+			// Redirect to TCEForm so that the BE User can do its job!
+			if ($contentService->getNumberOfObjects() === 1) {
+
+				if (!empty($errorMessages)) {
+					$message = sprintf('Something went wrong when localizing content "%s" with identifier "%s". <br/>%s',
+						$dataType,
+						$identifier,
+						implode('<br/>', $errorMessages)
+					);
+					throw new \Exception($message, 1412343098);
+				}
+
+				$localizedContent = $this->getLanguageService()->getLocalizedContent($content, $language);
+				if (empty($localizedContent)) {
+					$message = sprintf('Oups! I could not retrieve localized content of type "%s" with identifier "%s"',
+						$content->getDataType(),
+						$content->getUid()
+					);
+					throw new \Exception($message, 1412343099);
+				}
+
+				/** @var EditUri $uri */
+				$uriRenderer = GeneralUtility::makeInstance(EditUri::class);
+				$uri = $uriRenderer->render($localizedContent);
+				HttpUtility::redirect($uri);
+				break; // no need to further continue
+			}
+
+			$result->addErrorMessages($errorMessages);
+		}
+
+		$response = $this->responseFactory->createResponse()
+			->withHeader('Content-Type', 'application/json; charset=utf-8');
+		$response->getBody()->write(json_encode($result));
+		return $response;
+	}
+
+	/**
+	 * Get the Vidi Module Loader.
+	 *
+	 * @return ContentService
+	 */
+	protected function getContentService()
+	{
+		return GeneralUtility::makeInstance(ContentService::class);
+	}
+
+	/**
+	 * @return ContentObjectResolver
+	 */
+	protected function getContentObjectResolver()
+	{
+		return GeneralUtility::makeInstance(ContentObjectResolver::class);
+	}
+
+	/**
+	 * @return FieldPathResolver
+	 */
+	protected function getFieldPathResolver()
+	{
+		return GeneralUtility::makeInstance(FieldPathResolver::class);
+	}
+
+	/**
+	 * @return JsonResult|object
+	 */
+	protected function getJsonResult()
+	{
+		return GeneralUtility::makeInstance(JsonResult::class);
+	}
+
+	/**
+	 * Signal that is called for post-processing content data send to the server for update.
+	 *
+	 * @param Content $contentObject
+	 * @param $fieldNameAndPath
+	 * @param $contentData
+	 * @param $counter
+	 * @param $savingBehavior
+	 * @param $language
+	 * @return ProcessContentDataSignalArguments
+	 */
+	protected function emitProcessContentDataSignal(Content $contentObject, $fieldNameAndPath, $contentData, $counter, $savingBehavior, $language)
+	{
+
+		/** @var ProcessContentDataSignalArguments $signalArguments */
+		$signalArguments = GeneralUtility::makeInstance(ProcessContentDataSignalArguments::class);
+		$signalArguments->setContentObject($contentObject)
+			->setFieldNameAndPath($fieldNameAndPath)
+			->setContentData($contentData)
+			->setCounter($counter)
+			->setSavingBehavior($savingBehavior)
+			->setLanguage($language);
+
+		$signalResult = $this->getSignalSlotDispatcher()->dispatch('Fab\Vidi\Controller\Backend\ContentController', 'processContentData', array($signalArguments));
+		return $signalResult[0];
+	}
+
+	/**
+	 * Get the SignalSlot dispatcher.
+	 *
+	 * @return Dispatcher
+	 */
+	protected function getSignalSlotDispatcher()
+	{
+		return GeneralUtility::makeInstance(Dispatcher::class);
+	}
+
+	/**
+	 * Get the Clipboard service.
+	 *
+	 * @return ClipboardService
+	 */
+	protected function getClipboardService()
+	{
+		return GeneralUtility::makeInstance(ClipboardService::class);
+	}
+
+	/**
+	 * @return LanguageService
+	 */
+	protected function getLanguageService()
+	{
+		return GeneralUtility::makeInstance(LanguageService::class);
+	}
+
+	/**
+	 * Get the Vidi Module Loader.
+	 *
+	 * @return ModuleLoader
+	 */
+	protected function getModuleLoader()
+	{
+		return GeneralUtility::makeInstance(ModuleLoader::class);
+	}
+
+	public function injectSelectionRepository(SelectionRepository $selectionRepository): void
+	{
+		$this->selectionRepository = $selectionRepository;
+	}
 
 }