CleanerTask.php

Go to the documentation of this file.

<?php
 
/*
 * This file is part of the TYPO3 CMS project.
 *
 * It is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License, either version 2
 * of the License, or any later version.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 * The TYPO3 project - inspiring people to share!
 */
 
namespace ‪TYPO3\CMS\Recycler\Task;
 
use Doctrine\DBAL\DBALException;
use ‪TYPO3\CMS\Core\Database\ConnectionPool;
use ‪TYPO3\CMS\Core\Utility\GeneralUtility;
use ‪TYPO3\CMS\Scheduler\Task\AbstractTask;
 
class ‪CleanerTask extends ‪AbstractTask
{
    protected ‪$period = 0;
 
    protected ‪$tcaTables = [];
 
    public function ‪execute()
    {
        $success = true;
        $tables = $this->‪getTcaTables();
        foreach ($tables as $table) {
            if (!$this->‪cleanTable($table)) {
                $success = false;
            }
        }
 
        return $success;
    }
 
    protected function ‪cleanTable($tableName)
    {
        if (isset(‪$GLOBALS['TCA'][$tableName]['ctrl']['delete'])) {
            $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($tableName);
            $queryBuilder->getRestrictions()->removeAll();
 
            $constraints = [
                $queryBuilder->expr()->eq(
                    ‪$GLOBALS['TCA'][$tableName]['ctrl']['delete'],
                    $queryBuilder->createNamedParameter(1, \PDO::PARAM_INT)
                )
                ,
            ];
 
            if (‪$GLOBALS['TCA'][$tableName]['ctrl']['tstamp']) {
                $dateBefore = $this->‪getPeriodAsTimestamp();
                $constraints[] = $queryBuilder->expr()->lt(
                    ‪$GLOBALS['TCA'][$tableName]['ctrl']['tstamp'],
                    $queryBuilder->createNamedParameter($dateBefore, \PDO::PARAM_INT)
                );
            }
            try {
                $queryBuilder->delete($tableName)
                    ->where(...$constraints)
                    ->execute();
            } catch (DBALException $e) {
                return false;
            }
        }
        return true;
    }
 
    public function ‪getAdditionalInformation()
    {
        $message = '';
 
        $message .= sprintf(
            $this->‪getLanguageService()->sL('LLL:EXT:recycler/Resources/Private/Language/locallang_tasks.xlf:cleanerTaskDescriptionTables'),
            implode(', ', $this->‪getTcaTables())
        );
 
        $message .= '; ';
 
        $message .= sprintf(
            $this->‪getLanguageService()->sL('LLL:EXT:recycler/Resources/Private/Language/locallang_tasks.xlf:cleanerTaskDescriptionDays'),
            $this->‪getPeriod()
        );
 
        return $message;
    }
 
    public function ‪setPeriod(‪$period)
    {
        $this->period = (int)‪$period;
    }
 
    public function ‪getPeriod()
    {
        return ‪$this->period;
    }
 
    public function ‪getPeriodAsTimestamp()
    {
        return strtotime('-' . $this->‪getPeriod() . ' days');
    }
 
    public function ‪setTcaTables(‪$tcaTables = [])
    {
        $this->tcaTables = ‪$tcaTables;
    }
 
    public function ‪getTcaTables()
    {
        return ‪$this->tcaTables;
    }
}