SchedulerModuleController.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Scheduler\Controller;

use TYPO3\CMS\Core\Database\DatabaseConnection;
use TYPO3\CMS\Core\Messaging\FlashMessageQueue;
use TYPO3\CMS\Core\Messaging\FlashMessageService;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;
use TYPO3\CMS\Backend\Utility\BackendUtility;
use TYPO3\CMS\Backend\Utility\IconUtility;
use TYPO3\CMS\Core\Messaging\FlashMessage;
use TYPO3\CMS\Saltedpasswords\Salt\SaltFactory;
use TYPO3\CMS\Saltedpasswords\Utility\SaltedPasswordsUtility;
use TYPO3\CMS\Scheduler\Task\AbstractTask;

class SchedulerModuleController extends \TYPO3\CMS\Backend\Module\BaseScriptClass {

    public $backPath;

    protected $submittedData = array();

    protected $messages = array();

    protected $cshKey;

    protected $scheduler;

    protected $pageRenderer;

    public function __construct() {
        $GLOBALS['LANG']->includeLLFile('EXT:scheduler/mod1/locallang.xlf');
        $GLOBALS['BE_USER']->modAccess($GLOBALS['MCONF'], TRUE);
        $this->backPath = $GLOBALS['BACK_PATH'];
        // Set key for CSH
        $this->cshKey = '_MOD_' . $GLOBALS['MCONF']['name'];
    }

    public function init() {
        parent::init();
        // Initialize document
        $this->doc = GeneralUtility::makeInstance('TYPO3\\CMS\\Backend\\Template\\DocumentTemplate');
        $this->doc->setModuleTemplate(ExtensionManagementUtility::extPath('scheduler') . 'mod1/mod_template.html');
        $this->pageRenderer = $this->doc->getPageRenderer();
        $this->pageRenderer->addCssFile(ExtensionManagementUtility::extRelPath('scheduler') . 'res/tx_scheduler_be.css');
        $this->doc->backPath = $this->backPath;
        $this->doc->bodyTagId = 'typo3-mod-php';
        $this->doc->bodyTagAdditions = 'class="tx_scheduler_mod1"';
        // Create scheduler instance
        $this->scheduler = GeneralUtility::makeInstance('TYPO3\\CMS\\Scheduler\\Scheduler');
    }

    public function menuConfig() {
        $this->MOD_MENU = array(
            'function' => array(
                'scheduler' => $GLOBALS['LANG']->getLL('function.scheduler'),
                'check' => $GLOBALS['LANG']->getLL('function.check'),
                'info' => $GLOBALS['LANG']->getLL('function.info')
            )
        );
        parent::menuConfig();
    }

    public function main() {
        // Access check!
        // The page will show only if user has admin rights
        if ($GLOBALS['BE_USER']->user['admin']) {
            // Set the form
            $this->doc->form = '<form name="tx_scheduler_form" id="tx_scheduler_form" method="post" action="">';
            $this->pageRenderer->addInlineSetting('scheduler', 'runningIcon', ExtensionManagementUtility::extRelPath('scheduler') . 'res/gfx/status_running.png');
            // Prepare main content
            $this->content = $this->doc->header($GLOBALS['LANG']->getLL('function.' . $this->MOD_SETTINGS['function']));
            $this->content .= $this->getModuleContent();
        } else {
            // If no access, only display the module's title
            $this->content = $this->doc->header($GLOBALS['LANG']->getLL('title'));
            $this->content .= $this->doc->spacer(5);
        }
        // Place content inside template
        $content = $this->doc->moduleBody(array(), $this->getDocHeaderButtons(), $this->getTemplateMarkers());
        // Renders the module page
        $this->content = $this->doc->render($GLOBALS['LANG']->getLL('title'), $content);
    }

    protected function getModuleContent() {
        $content = '';
        $sectionTitle = '';
        // Get submitted data
        $this->submittedData = GeneralUtility::_GPmerged('tx_scheduler');
        $this->submittedData['uid'] = (int)$this->submittedData['uid'];
        // If a save command was submitted, handle saving now
        if ($this->CMD === 'save' || $this->CMD === 'saveclose' || $this->CMD === 'savenew') {
            $previousCMD = GeneralUtility::_GP('previousCMD');
            // First check the submitted data
            $result = $this->preprocessData();
            // If result is ok, proceed with saving
            if ($result) {
                $this->saveTask();
                if ($this->CMD == 'saveclose') {
                    // Unset command, so that default screen gets displayed
                    unset($this->CMD);
                } elseif ($this->CMD == 'save') {
                    // After saving a "add form", return to edit
                    $this->CMD = 'edit';
                } elseif ($this->CMD === 'savenew') {
                    // Unset submitted data, so that empty form gets displayed
                    unset($this->submittedData);
                    // After saving a "add/edit form", return to add
                    $this->CMD = 'add';
                } else {
                    // Return to edit form
                    $this->CMD = $previousCMD;
                }
            } else {
                $this->CMD = $previousCMD;
            }
        }
        // Handle chosen action
        switch ((string) $this->MOD_SETTINGS['function']) {
            case 'scheduler':
                // Scheduler's main screen
                $this->executeTasks();
                // Execute chosen action
                switch ($this->CMD) {
                    case 'add':

                    case 'edit':
                        try {
                            // Try adding or editing
                            $content .= $this->editTask();
                            $sectionTitle = $GLOBALS['LANG']->getLL('action.' . $this->CMD);
                        } catch (\Exception $e) {
                            if ($e->getCode() === 1305100019) {
                                // Invalid controller class name exception
                                $this->addMessage($e->getMessage(), FlashMessage::ERROR);
                            }
                            // An exception may also happen when the task to
                            // edit could not be found. In this case revert
                            // to displaying the list of tasks
                            // It can also happen when attempting to edit a running task
                            $content .= $this->listTasks();
                        }
                        break;
                    case 'delete':
                        $this->deleteTask();
                        $content .= $this->listTasks();
                        break;
                    case 'stop':
                        $this->stopTask();
                        $content .= $this->listTasks();
                        break;
                    case 'list':

                    default:
                        $content .= $this->listTasks();
                }
                break;
            case 'check':
                // Setup check screen
                // TODO: move check to the report module
                $content .= $this->displayCheckScreen();
                break;
            case 'info':
                // Information screen
                $content .= $this->displayInfoScreen();
                break;
        }
        // Wrap the content in a section
        return $this->doc->section($sectionTitle, '<div class="tx_scheduler_mod1">' . $content . '</div>', 0, 1);
    }

    public function render() {
        echo $this->content;
    }

    protected function checkSchedulerUser() {
        $schedulerUserStatus = -1;
        // Assemble base WHERE clause
        $where = 'username = \'_cli_scheduler\' AND admin = 0' . BackendUtility::deleteClause('be_users');
        // Check if user exists at all
        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('1', 'be_users', $where);
        if ($GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
            $schedulerUserStatus = 0;
            // Check if user exists and is enabled
            $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('1', 'be_users', $where . BackendUtility::BEenableFields('be_users'));
            if ($GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
                $schedulerUserStatus = 1;
            }
        }
        $GLOBALS['TYPO3_DB']->sql_free_result($res);
        return $schedulerUserStatus;
    }

    protected function createSchedulerUser() {
        // Check _cli_scheduler user status
        $checkUser = $this->checkSchedulerUser();
        // Prepare default message
        $message = $GLOBALS['LANG']->getLL('msg.userExists');
        $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::WARNING;
        // If the user does not exist, try creating it
        if ($checkUser == -1) {
            // Prepare necessary data for _cli_scheduler user creation
            $password = uniqid('scheduler', TRUE);
            if (SaltedPasswordsUtility::isUsageEnabled()) {
                $objInstanceSaltedPW = SaltFactory::getSaltingInstance();
                $password = $objInstanceSaltedPW->getHashedPassword($password);
            }
            $data = array('be_users' => array('NEW' => array('username' => '_cli_scheduler', 'password' => $password, 'pid' => 0)));
            $tcemain = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\DataHandling\\DataHandler');
            $tcemain->stripslashes_values = 0;
            $tcemain->start($data, array());
            $tcemain->process_datamap();
            // Check if a new uid was indeed generated (i.e. a new record was created)
            // (counting TCEmain errors doesn't work as some failures don't report errors)
            $numberOfNewIDs = count($tcemain->substNEWwithIDs);
            if ($numberOfNewIDs == 1) {
                $message = $GLOBALS['LANG']->getLL('msg.userCreated');
                $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::OK;
            } else {
                $message = $GLOBALS['LANG']->getLL('msg.userNotCreated');
                $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR;
            }
        }
        $this->addMessage($message, $severity);
    }

    protected function displayCheckScreen() {
        $message = '';
        $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::OK;
        // First, check if _cli_scheduler user creation was requested
        if ($this->CMD == 'user') {
            $this->createSchedulerUser();
        }

        // Start generating the content
        $content = '<p class="lead">' . $GLOBALS['LANG']->getLL('msg.schedulerSetupCheck') . '</p>';

        // Display information about last automated run, as stored in the system registry
        $registry = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Registry');
        $lastRun = $registry->get('tx_scheduler', 'lastRun');
        if (!is_array($lastRun)) {
            $message = $GLOBALS['LANG']->getLL('msg.noLastRun');
            $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::WARNING;
        } else {
            if (empty($lastRun['end']) || empty($lastRun['start']) || empty($lastRun['type'])) {
                $message = $GLOBALS['LANG']->getLL('msg.incompleteLastRun');
                $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::WARNING;
            } else {
                $startDate = date($GLOBALS['TYPO3_CONF_VARS']['SYS']['ddmmyy'], $lastRun['start']);
                $startTime = date($GLOBALS['TYPO3_CONF_VARS']['SYS']['hhmm'], $lastRun['start']);
                $endDate = date($GLOBALS['TYPO3_CONF_VARS']['SYS']['ddmmyy'], $lastRun['end']);
                $endTime = date($GLOBALS['TYPO3_CONF_VARS']['SYS']['hhmm'], $lastRun['end']);
                $label = 'automatically';
                if ($lastRun['type'] == 'manual') {
                    $label = 'manually';
                }
                $type = $GLOBALS['LANG']->getLL('label.' . $label);
                $message = sprintf($GLOBALS['LANG']->getLL('msg.lastRun'), $type, $startDate, $startTime, $endDate, $endTime);
                $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::INFO;
            }
        }
        $flashMessage = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessage', $message, '', $severity);

        $content .= '<div class="info-block">';
        $content .= '<h2>' . $GLOBALS['LANG']->getLL('hdg.lastRun') . '</h2>';
        $content .= $flashMessage->render();
        $content .= '</div>';

        // Check CLI user
        $content .= '<div class="info-block">';
        $content .= '<h2>' . $GLOBALS['LANG']->getLL('hdg.schedulerUser') . '</h2>';
        $content .= '<p>' . $GLOBALS['LANG']->getLL('msg.schedulerUser') . '</p>';
        $checkUser = $this->checkSchedulerUser();
        if ($checkUser == -1) {
            $link = $GLOBALS['MCONF']['_'] . '&SET[function]=check&CMD=user';
            $message = sprintf($GLOBALS['LANG']->getLL('msg.schedulerUserMissing'), htmlspecialchars($link));
            $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR;
        } elseif ($checkUser == 0) {
            $message = $GLOBALS['LANG']->getLL('msg.schedulerUserFoundButDisabled');
            $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::WARNING;
        } else {
            $message = $GLOBALS['LANG']->getLL('msg.schedulerUserFound');
            $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::OK;
        }
        $flashMessage = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessage', $message, '', $severity);
        $content .= $flashMessage->render() . '</div>';

        // Check if CLI script is executable or not
        $script = PATH_typo3 . 'cli_dispatch.phpsh';
        $isExecutable = FALSE;
        // Skip this check if running Windows, as rights do not work the same way on this platform
        // (i.e. the script will always appear as *not* executable)
        if (TYPO3_OS === 'WIN') {
            $isExecutable = TRUE;
        } else {
            $isExecutable = is_executable($script);
        }
        $content .= '<div class="info-block">';
        $content .= '<h2>' . $GLOBALS['LANG']->getLL('hdg.cliScript') . '</h2>';
        $content .= '<p>' . sprintf($GLOBALS['LANG']->getLL('msg.cliScript'), $script) . '</p>';
        if ($isExecutable) {
            $message = $GLOBALS['LANG']->getLL('msg.cliScriptExecutable');
            $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::OK;
        } else {
            $message = $GLOBALS['LANG']->getLL('msg.cliScriptNotExecutable');
            $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR;
        }
        $flashMessage = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessage', $message, '', $severity);
        $content .= $flashMessage->render() . '</div>';
        return $content;
    }

    protected function displayInfoScreen() {
        $content = '';
        $registeredClasses = self::getRegisteredClasses();
        // No classes available, display information message
        if (count($registeredClasses) == 0) {
            $flashMessage = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessage', $GLOBALS['LANG']->getLL('msg.noTasksDefined'), '', \TYPO3\CMS\Core\Messaging\FlashMessage::INFO);
            $content .= $flashMessage->render();
        } else {
            // Initialise table layout
            $tableLayout = array(
                'table' => array('<table class="t3-table">', '</table>'),
                '0' => array(
                    'tr' => array('<thead><tr>', '</tr></thead>'),
                    'defCol' => array('<td>', '</td>')
                ),
                'defRow' => array(
                    'tr' => array('<tr>', '</tr>'),
                    'defCol' => array('<td>', '</td>')
                )
            );
            $table = array();
            $tr = 0;
            // Header row
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.name');
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.extension');
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.description');
            $table[$tr][] = '';
            $tr++;
            // Display information about each service
            foreach ($registeredClasses as $class => $classInfo) {
                $table[$tr][] = htmlspecialchars($classInfo['title']);
                $table[$tr][] = htmlspecialchars($classInfo['extension']);
                $table[$tr][] = htmlspecialchars($classInfo['description']);
                $link = $GLOBALS['MCONF']['_'] . '&SET[function]=list&CMD=add&tx_scheduler[class]=' . $class;
                $table[$tr][] = '<a href="' . htmlspecialchars($link) . '" title="' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:new', TRUE) . '" class="icon">' . IconUtility::getSpriteIcon('actions-document-new') . '</a>';
                $tr++;
            }
            // Render the table and return it
            $content = '<p class="lead">' . $GLOBALS['LANG']->getLL('msg.infoScreenIntro') . '</p>';
            $content .= $this->doc->table($table, $tableLayout);
        }
        return $content;
    }

    protected function displayServerTime() {
        // Get the current time, formatted
        $dateFormat = $GLOBALS['TYPO3_CONF_VARS']['SYS']['ddmmyy'] . ' ' . $GLOBALS['TYPO3_CONF_VARS']['SYS']['hhmm'] . ' T (e';
        $now = date($dateFormat) . ', GMT ' . date('P') . ')';
        // Display the help text
        $serverTime = '<h3>' . $GLOBALS['LANG']->getLL('label.serverTime') . '</h3>';
        $serverTime .= '<p>' . $GLOBALS['LANG']->getLL('msg.serverTimeHelp') . '</p>';
        $serverTime .= '<p>' . sprintf($GLOBALS['LANG']->getLL('msg.serverTime'), $now) . '</p>';
        return $serverTime;
    }

    protected function renderTaskProgressBar($progress) {
        $progressText = $GLOBALS['LANG']->getLL('status.progress') . ':&nbsp;' . $progress . '%';
        $progressBar = '<div class="progress"> <div class="bar" style="width: ' . $progress . '%;">' . $progressText . '</div> </div>';
        return $progressBar;
    }

    protected function deleteTask() {
        try {
            // Try to fetch the task and delete it
            $task = $this->scheduler->fetchTask($this->submittedData['uid']);
            // If the task is currently running, it may not be deleted
            if ($task->isExecutionRunning()) {
                $this->addMessage($GLOBALS['LANG']->getLL('msg.maynotDeleteRunningTask'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
            } else {
                if ($this->scheduler->removeTask($task)) {
                    $GLOBALS['BE_USER']->writeLog(4, 0, 0, 0, 'Scheduler task "%s" (UID: %s, Class: "%s") was deleted', array($task->getTaskTitle(), $task->getTaskUid(), $task->getTaskClassName()));
                    $this->addMessage($GLOBALS['LANG']->getLL('msg.deleteSuccess'));
                } else {
                    $this->addMessage($GLOBALS['LANG']->getLL('msg.deleteError'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                }
            }
        } catch (\UnexpectedValueException $e) {
            // The task could not be unserialized properly, simply delete the database record
            $result = $GLOBALS['TYPO3_DB']->exec_DELETEquery('tx_scheduler_task', 'uid = ' . (int)$this->submittedData['uid']);
            if ($result) {
                $this->addMessage($GLOBALS['LANG']->getLL('msg.deleteSuccess'));
            } else {
                $this->addMessage($GLOBALS['LANG']->getLL('msg.deleteError'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
            }
        } catch (\OutOfBoundsException $e) {
            // The task was not found, for some reason
            $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.taskNotFound'), $this->submittedData['uid']), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
        }
    }

    protected function stopTask() {
        try {
            // Try to fetch the task and stop it
            $task = $this->scheduler->fetchTask($this->submittedData['uid']);
            if ($task->isExecutionRunning()) {
                // If the task is indeed currently running, clear marked executions
                $result = $task->unmarkAllExecutions();
                if ($result) {
                    $this->addMessage($GLOBALS['LANG']->getLL('msg.stopSuccess'));
                } else {
                    $this->addMessage($GLOBALS['LANG']->getLL('msg.stopError'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                }
            } else {
                // The task is not running, nothing to unmark
                $this->addMessage($GLOBALS['LANG']->getLL('msg.maynotStopNonRunningTask'), \TYPO3\CMS\Core\Messaging\FlashMessage::WARNING);
            }
        } catch (\Exception $e) {
            // The task was not found, for some reason
            $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.taskNotFound'), $this->submittedData['uid']), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
        }
    }

    protected function editTask() {
        $registeredClasses = self::getRegisteredClasses();
        $registeredTaskGroups = self::getRegisteredTaskGroups();
        $content = '';
        $taskInfo = array();
        $task = NULL;
        $process = 'edit';
        if ($this->submittedData['uid'] > 0) {
            // If editing, retrieve data for existing task
            try {
                $taskRecord = $this->scheduler->fetchTaskRecord($this->submittedData['uid']);
                // If there's a registered execution, the task should not be edited
                if (!empty($taskRecord['serialized_executions'])) {
                    $this->addMessage($GLOBALS['LANG']->getLL('msg.maynotEditRunningTask'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                    throw new \LogicException('Runnings tasks cannot not be edited', 1251232849);
                }
                // Get the task object
                $task = unserialize($taskRecord['serialized_task_object']);
                // Set some task information
                $taskInfo['disable'] = $taskRecord['disable'];
                $taskInfo['description'] = $taskRecord['description'];
                $taskInfo['task_group'] = $taskRecord['task_group'];
                // Check that the task object is valid
                if ($this->scheduler->isValidTaskObject($task)) {
                    // The task object is valid, process with fetching current data
                    $taskInfo['class'] = get_class($task);
                    // Get execution information
                    $taskInfo['start'] = $task->getExecution()->getStart();
                    $taskInfo['end'] = $task->getExecution()->getEnd();
                    $taskInfo['interval'] = $task->getExecution()->getInterval();
                    $taskInfo['croncmd'] = $task->getExecution()->getCronCmd();
                    $taskInfo['multiple'] = $task->getExecution()->getMultiple();
                    if (!empty($taskInfo['interval']) || !empty($taskInfo['croncmd'])) {
                        // Guess task type from the existing information
                        // If an interval or a cron command is defined, it's a recurring task
                        // FIXME: remove magic numbers for the type, use class constants instead
                        $taskInfo['type'] = 2;
                        $taskInfo['frequency'] = $taskInfo['interval'] ?: $taskInfo['croncmd'];
                    } else {
                        // It's not a recurring task
                        // Make sure interval and cron command are both empty
                        $taskInfo['type'] = 1;
                        $taskInfo['frequency'] = '';
                        $taskInfo['end'] = 0;
                    }
                } else {
                    // The task object is not valid
                    // Issue error message
                    $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.invalidTaskClassEdit'), get_class($task)), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                    // Initialize empty values
                    $taskInfo['start'] = 0;
                    $taskInfo['end'] = 0;
                    $taskInfo['frequency'] = '';
                    $taskInfo['multiple'] = FALSE;
                    $taskInfo['type'] = 1;
                }
            } catch (\OutOfBoundsException $e) {
                // Add a message and continue throwing the exception
                $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.taskNotFound'), $this->submittedData['uid']), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                throw $e;
            }
        } else {
            // If adding a new object, set some default values
            $taskInfo['class'] = key($registeredClasses);
            $taskInfo['type'] = 2;
            $taskInfo['start'] = $GLOBALS['EXEC_TIME'];
            $taskInfo['end'] = '';
            $taskInfo['frequency'] = '';
            $taskInfo['multiple'] = 0;
            $process = 'add';
        }
        if (count($this->submittedData) > 0) {
            // If some data was already submitted, use it to override
            // existing data
            \TYPO3\CMS\Core\Utility\ArrayUtility::mergeRecursiveWithOverrule($taskInfo, $this->submittedData);
        }
        // Get the extra fields to display for each task that needs some
        $allAdditionalFields = array();
        if ($process == 'add') {
            foreach ($registeredClasses as $class => $registrationInfo) {
                if (!empty($registrationInfo['provider'])) {
                    $providerObject = GeneralUtility::getUserObj($registrationInfo['provider']);
                    if ($providerObject instanceof \TYPO3\CMS\Scheduler\AdditionalFieldProviderInterface) {
                        $additionalFields = $providerObject->getAdditionalFields($taskInfo, NULL, $this);
                        $allAdditionalFields = array_merge($allAdditionalFields, array($class => $additionalFields));
                    }
                }
            }
        } else {
            if (!empty($registeredClasses[$taskInfo['class']]['provider'])) {
                $providerObject = GeneralUtility::getUserObj($registeredClasses[$taskInfo['class']]['provider']);
                if ($providerObject instanceof \TYPO3\CMS\Scheduler\AdditionalFieldProviderInterface) {
                    $allAdditionalFields[$taskInfo['class']] = $providerObject->getAdditionalFields($taskInfo, $task, $this);
                }
            }
        }
        // Load necessary JavaScript
        $this->pageRenderer->loadExtJS();
        $this->pageRenderer->addJsFile(ExtensionManagementUtility::extRelPath('scheduler') . 'res/tx_scheduler_be.js');
        $this->pageRenderer->addJsFile($this->backPath . 'sysext/backend/Resources/Public/JavaScript/tceforms.js');
        $this->pageRenderer->addJsFile($this->backPath . 'js/extjs/ux/Ext.ux.DateTimePicker.js');
        // Define settings for Date Picker
        $typo3Settings = array(
            'datePickerUSmode' => $GLOBALS['TYPO3_CONF_VARS']['SYS']['USdateFormat'] ? 1 : 0,
            'dateFormat' => array('j-n-Y', 'G:i j-n-Y'),
            'dateFormatUS' => array('n-j-Y', 'G:i n-j-Y')
        );
        $this->pageRenderer->addInlineSettingArray('', $typo3Settings);
        // Define table layout for add/edit form
        $tableLayout = array(
            'table' => array('<table border="0" cellspacing="0" cellpadding="0" id="edit_form" class="typo3-usersettings">', '</table>')
        );
        // Define a style for hiding
        // Some fields will be hidden when the task is not recurring
        $style = '';
        if ($taskInfo['type'] == 1) {
            $style = ' style="display: none"';
        }
        // Start rendering the add/edit form
        $content .= '<input type="hidden" name="tx_scheduler[uid]" value="' . htmlspecialchars($this->submittedData['uid']) . '" />';
        $content .= '<input type="hidden" name="previousCMD" value="' . htmlspecialchars($this->CMD) . '" />';
        $table = array();
        $tr = 0;
        $defaultCell = array('<td class="td-input">', '</td>');
        // Disable checkbox
        $label = '<label for="task_disable">' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:disable') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_disable', $label);
        $table[$tr][] = '<input type="hidden" name="tx_scheduler[disable]" value="0" />
             <input type="checkbox" name="tx_scheduler[disable]" value="1" id="task_disable"' . ($taskInfo['disable'] == 1 ? ' checked="checked"' : '') . ' />';
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_disable_row">', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // Task class selector
        $label = '<label for="task_class">' . $GLOBALS['LANG']->getLL('label.class') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_class', $label);
        // On editing, don't allow changing of the task class, unless it was not valid
        if ($this->submittedData['uid'] > 0 && !empty($taskInfo['class'])) {
            $cell = $registeredClasses[$taskInfo['class']]['title'] . ' (' . $registeredClasses[$taskInfo['class']]['extension'] . ')';
            $cell .= '<input type="hidden" name="tx_scheduler[class]" id="task_class" value="' . htmlspecialchars($taskInfo['class']) . '" />';
        } else {
            $cell = '<select name="tx_scheduler[class]" id="task_class" class="wide" onchange="actOnChangedTaskClass(this)">';
            // Group registered classes by classname
            $groupedClasses = array();
            foreach ($registeredClasses as $class => $classInfo) {
                $groupedClasses[$classInfo['extension']][$class] = $classInfo;
            }
            ksort($groupedClasses);
            // Loop on all grouped classes to display a selector
            foreach ($groupedClasses as $extension => $class) {
                $cell .= '<optgroup label="' . htmlspecialchars($extension) . '">';
                foreach ($groupedClasses[$extension] as $class => $classInfo) {
                    $selected = $class == $taskInfo['class'] ? ' selected="selected"' : '';
                    $cell .= '<option value="' . htmlspecialchars($class) . '"' . 'title="' . htmlspecialchars($classInfo['description']) . '"' . $selected . '>' . htmlspecialchars($classInfo['title']) . '</option>';
                }
                $cell .= '</optgroup>';
            }
            $cell .= '</select>';
        }
        $table[$tr][] = $cell;
        // Make sure each row has a unique id, for manipulation with JS
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_class_row">', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // Task type selector
        $label = '<label for="task_type">' . $GLOBALS['LANG']->getLL('label.type') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_type', $label);
        $table[$tr][] = '<select name="tx_scheduler[type]" id="task_type" onchange="actOnChangedTaskType(this)">' . '<option value="1"' . ($taskInfo['type'] == 1 ? ' selected="selected"' : '') . '>' . $GLOBALS['LANG']->getLL('label.type.single') . '</option>' . '<option value="2"' . ($taskInfo['type'] == 2 ? ' selected="selected"' : '') . '>' . $GLOBALS['LANG']->getLL('label.type.recurring') . '</option>' . '</select>';
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_type_row">', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // Task group selector
        $label = '<label for="task_group">' . $GLOBALS['LANG']->getLL('label.group') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_group', $label);
        $cell = '<select name="tx_scheduler[task_group]" id="task_class" class="wide">';
        // Loop on all groups to display a selector
        $cell .= '<option value="0" title=""></option>';
        foreach ($registeredTaskGroups as $taskGroup) {
            $selected = $taskGroup['uid'] == $taskInfo['task_group'] ? ' selected="selected"' : '';
            $cell .= '<option value="' . $taskGroup['uid'] . '"' . 'title="';
            $cell .= htmlspecialchars($taskGroup['groupName']) . '"' . $selected . '>';
            $cell .= htmlspecialchars($taskGroup['groupName']) . '</option>';
        }
        $cell .= '</select>';
        $table[$tr][] = $cell;
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_group_row">', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // Start date/time field
        // NOTE: datetime fields need a special id naming scheme
        $label = '<label for="tceforms-datetimefield-task_start">' . $GLOBALS['LANG']->getLL('label.start') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_start', $label);
        $table[$tr][] = '<input name="tx_scheduler[start]" type="text" id="tceforms-datetimefield-task_start" value="' . (empty($taskInfo['start']) ? '' : strftime('%H:%M %d-%m-%Y', $taskInfo['start'])) . '" />' . IconUtility::getSpriteIcon('actions-edit-pick-date', array(
            'style' => 'cursor:pointer;',
            'id' => 'picker-tceforms-datetimefield-task_start'
        ));
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_start_row">', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // End date/time field
        // NOTE: datetime fields need a special id naming scheme
        $label = '<label for="tceforms-datetimefield-task_end">' . $GLOBALS['LANG']->getLL('label.end') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_end', $label);
        $table[$tr][] = '<input name="tx_scheduler[end]" type="text" id="tceforms-datetimefield-task_end" value="' . (empty($taskInfo['end']) ? '' : strftime('%H:%M %d-%m-%Y', $taskInfo['end'])) . '" />' . IconUtility::getSpriteIcon('actions-edit-pick-date', array(
            'style' => 'cursor:pointer;',
            'id' => 'picker-tceforms-datetimefield-task_end'
        ));
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_end_row"' . $style . '>', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // Frequency input field
        $label = '<label for="task_frequency">' . $GLOBALS['LANG']->getLL('label.frequency.long') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_frequency', $label);
        $cell = '<input type="text" name="tx_scheduler[frequency]" id="task_frequency" value="' . htmlspecialchars($taskInfo['frequency']) . '" />';
        $table[$tr][] = $cell;
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_frequency_row"' . $style . '>', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // Multiple execution selector
        $label = '<label for="task_multiple">' . $GLOBALS['LANG']->getLL('label.parallel.long') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_multiple', $label);
        $table[$tr][] = '<input type="hidden"   name="tx_scheduler[multiple]" value="0" />
             <input type="checkbox" name="tx_scheduler[multiple]" value="1" id="task_multiple"' . ($taskInfo['multiple'] == 1 ? ' checked="checked"' : '') . ' />';
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_multiple_row"' . $style . '>', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // Description
        $label = '<label for="task_description">' . $GLOBALS['LANG']->getLL('label.description') . '</label>';
        $table[$tr][] = BackendUtility::wrapInHelp($this->cshKey, 'task_description', $label);
        $table[$tr][] = '<textarea name="tx_scheduler[description]">' . htmlspecialchars($taskInfo['description']) . '</textarea>';
        $tableLayout[$tr] = array(
            'tr' => array('<tr id="task_description_row">', '</tr>'),
            'defCol' => $defaultCell,
            '0' => array('<td class="td-label">', '</td>')
        );
        $tr++;
        // Display additional fields
        foreach ($allAdditionalFields as $class => $fields) {
            if ($class == $taskInfo['class']) {
                $additionalFieldsStyle = '';
            } else {
                $additionalFieldsStyle = ' style="display: none"';
            }
            // Add each field to the display, if there are indeed any
            if (isset($fields) && is_array($fields)) {
                foreach ($fields as $fieldID => $fieldInfo) {
                    $label = '<label for="' . $fieldID . '">' . $GLOBALS['LANG']->sL($fieldInfo['label']) . '</label>';
                    $table[$tr][] = BackendUtility::wrapInHelp($fieldInfo['cshKey'], $fieldInfo['cshLabel'], $label);
                    $table[$tr][] = $fieldInfo['code'];
                    $htmlClassName = strtolower(str_replace('\\', '-', $class));
                    $tableLayout[$tr] = array(
                        'tr' => array('<tr id="' . $fieldID . '_row"' . $additionalFieldsStyle . ' class="extraFields extra_fields_' . $htmlClassName . '">', '</tr>'),
                        'defCol' => $defaultCell,
                        '0' => array('<td class="td-label">', '</td>')
                    );
                    $tr++;
                }
            }
        }
        // Render the add/edit task form
        $content .= '<div style="float: left;"><div class="typo3-dyntabmenu-divs">';
        $content .= $this->doc->table($table, $tableLayout);
        $content .= '</div></div>';
        $content .= '<div style="padding-top: 20px; clear: both;"></div>';
        // Display information about server time usage
        $content .= $this->displayServerTime();
        return $content;
    }

    protected function executeTasks() {
        // Make sure next automatic scheduler-run is scheduled
        if (GeneralUtility::_POST('go') !== NULL) {
            $this->scheduler->scheduleNextSchedulerRunUsingAtDaemon();
        }
        // Continue if some elements have been chosen for execution
        if (isset($this->submittedData['execute']) && count($this->submittedData['execute']) > 0) {
            // Get list of registered classes
            $registeredClasses = self::getRegisteredClasses();
            // Loop on all selected tasks
            foreach ($this->submittedData['execute'] as $uid) {
                try {
                    // Try fetching the task
                    $task = $this->scheduler->fetchTask($uid);
                    $class = get_class($task);
                    $name = $registeredClasses[$class]['title'] . ' (' . $registeredClasses[$class]['extension'] . ')';
                    // Now try to execute it and report on outcome
                    try {
                        $result = $this->scheduler->executeTask($task);
                        if ($result) {
                            $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.executed'), $name));
                        } else {
                            $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.notExecuted'), $name), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                        }
                    } catch (\Exception $e) {
                        // An exception was thrown, display its message as an error
                        $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.executionFailed'), $name, $e->getMessage()), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                    }
                } catch (\OutOfBoundsException $e) {
                    $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.taskNotFound'), $uid), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                } catch (\UnexpectedValueException $e) {
                    $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.executionFailed'), $uid, $e->getMessage()), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                }
            }
            // Record the run in the system registry
            $this->scheduler->recordLastRun('manual');
            // Make sure to switch to list view after execution
            $this->CMD = 'list';
        }
    }

    protected function listTasks() {
        // Define display format for dates
        $dateFormat = $GLOBALS['TYPO3_CONF_VARS']['SYS']['ddmmyy'] . ' ' . $GLOBALS['TYPO3_CONF_VARS']['SYS']['hhmm'];
        $content = '';
        // Get list of registered classes
        $registeredClasses = self::getRegisteredClasses();
        // Get list of registered task groups
        $registeredTaskGroups = self::getRegisteredTaskGroups();

        // add an empty entry for non-grouped tasks
        // add in front of list
        array_unshift($registeredTaskGroups, array('uid' => 0, 'groupName' => ''));

        // Get all registered tasks
        // Just to get the number of entries
        $query = array(
            'SELECT' => '
                tx_scheduler_task.*,
                tx_scheduler_task_group.groupName as taskGroupName,
                tx_scheduler_task_group.description as taskGroupDescription,
                tx_scheduler_task_group.deleted as isTaskGroupDeleted
                ',
            'FROM' => '
                tx_scheduler_task
                LEFT JOIN tx_scheduler_task_group ON tx_scheduler_task_group.uid = tx_scheduler_task.task_group
                ',
            'WHERE' => '1=1',
            'ORDERBY' => 'tx_scheduler_task_group.sorting'
        );
        $res = $this->getDatabaseConnection()->exec_SELECT_queryArray($query);
        $numRows = $this->getDatabaseConnection()->sql_num_rows($res);

        // No tasks defined, display information message
        if ($numRows == 0) {
            $flashMessage = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessage', $GLOBALS['LANG']->getLL('msg.noTasks'), '', \TYPO3\CMS\Core\Messaging\FlashMessage::INFO);
            $content .= $flashMessage->render();
        } else {
            // Load ExtJS framework and specific JS library
            $this->pageRenderer->loadExtJS();
            $this->pageRenderer->addJsFile(ExtensionManagementUtility::extRelPath('scheduler') . 'res/tx_scheduler_be.js');
            // Initialise table layout
            $tableLayout = array(
                'table' => array(
                    '<table class="t3-table">',
                    '</table>'
                ),
                '0' => array(
                    'tr' => array('<thead><tr>', '</tr></thead>'),
                    'defCol' => array('<td>', '</td>'),
                    '1' => array('<td style="width: 56px;">', '</td>'),
                    '3' => array('<td colspan="2">', '</td>')
                ),
                'defRow' => array(
                    'tr' => array('<tr class="db_list_normal">', '</tr>'),
                    'defCol' => array('<td>', '</td>'),
                    '1' => array('<td class="right">', '</td>'),
                    '2' => array('<td class="right">', '</td>')
                )
            );
            $disabledTaskRow = array(
                'tr' => array('<tr class="db_list_normal disabled">', '</tr>'),
                'defCol' => array('<td>', '</td>'),
                '1' => array('<td class="right">', '</td>'),
                '2' => array('<td class="right">', '</td>')
            );
            $rowWithSpan = array(
                'tr' => array('<tr class="db_list_normal">', '</tr>'),
                'defCol' => array('<td>', '</td>'),
                '1' => array('<td class="right">', '</td>'),
                '2' => array('<td class="right">', '</td>'),
                '3' => array('<td colspan="6">', '</td>')
            );
            $taskGroupRow = array(
                'tr' => array('<tr class="db_list_normal">', '</tr>'),
                'defCol' => array('<td>', '</td>'),
                '0' => array('<td colspan="10">', '</td>')
            );
            $table = array();
            $tr = 0;
            // Header row
            $table[$tr][] = '<a href="#" onclick="toggleCheckboxes();" title="' . $GLOBALS['LANG']->getLL('label.checkAll', TRUE) . '" class="icon">' . IconUtility::getSpriteIcon('actions-document-select') . '</a>';
            $table[$tr][] = '&nbsp;';
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.id');
            $table[$tr][] = $GLOBALS['LANG']->getLL('task');
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.type');
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.frequency');
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.parallel');
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.lastExecution');
            $table[$tr][] = $GLOBALS['LANG']->getLL('label.nextExecution');
            $tr++;

            // Loop on all tasks
            $temporaryResult = array();
            while ($row = $this->getDatabaseConnection()->sql_fetch_assoc($res)) {
                if ($row['taskGroupName'] === NULL || $row['isTaskGroupDeleted'] === '1') {
                    $row['taskGroupName'] = '';
                    $row['taskGroupDescription'] = '';
                    $row['task_group'] = 0;
                }
                $temporaryResult[$row['task_group']]['groupName'] = $row['taskGroupName'];
                $temporaryResult[$row['task_group']]['groupDescription'] = $row['taskGroupDescription'];
                $temporaryResult[$row['task_group']]['tasks'][] = $row;
            }
            foreach ($temporaryResult as $taskGroup) {
                if (!empty($taskGroup['groupName'])) {
                    $groupText = '<strong>' . htmlspecialchars($taskGroup['groupName']) . ' </strong>';
                    if (!empty($taskGroup['groupDescription'])) {
                        $groupText .= '<br />' . nl2br(htmlspecialchars($taskGroup['groupDescription']));
                    }
                    $table[$tr++][] = '<tr><td colspan="10">' . $groupText . '</td></tr>';
                }



                foreach ($taskGroup['tasks'] as $schedulerRecord) {// Define action icons
                    $editAction = '<a href="' . $GLOBALS['MCONF']['_'] . '&CMD=edit&tx_scheduler[uid]=' . $schedulerRecord['uid'] . '" title="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:edit', TRUE) . '" class="icon">' .
                        IconUtility::getSpriteIcon('actions-document-open') . '</a>';
                    $deleteAction = '<a href="' . $GLOBALS['MCONF']['_'] . '&CMD=delete&tx_scheduler[uid]=' . $schedulerRecord['uid'] . '" onclick="return confirm(\'' . $this->getLanguageService()->getLL('msg.delete') . '\');" title="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:delete', TRUE) . '" class="icon">' .
                        IconUtility::getSpriteIcon('actions-edit-delete') . '</a>';
                    $stopAction = '<a href="' . $GLOBALS['MCONF']['_'] . '&CMD=stop&tx_scheduler[uid]=' . $schedulerRecord['uid'] . '" onclick="return confirm(\'' . $this->getLanguageService()->getLL('msg.stop') . '\');" title="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:stop', TRUE) . '" class="icon">' .
                        '<img ' . IconUtility::skinImg($this->backPath, (ExtensionManagementUtility::extRelPath('scheduler') . 'res/gfx/stop.png')) . ' alt="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:stop') . '" /></a>';
                    $runAction = '<a href="' . $GLOBALS['MCONF']['_'] . '&tx_scheduler[execute][]=' . $schedulerRecord['uid'] . '" title="' . $this->getLanguageService()->getLL('action.run_task') . '" class="icon">' .
                        IconUtility::getSpriteIcon('extensions-scheduler-run-task') . '</a>';

                    // Define some default values
                    $lastExecution = '-';
                    $isRunning = FALSE;
                    $executionStatus = 'scheduled';
                    $executionStatusOutput = '';
                    $name = '';
                    $nextDate = '-';
                    $execType = '-';
                    $frequency = '-';
                    $multiple = '-';
                    $startExecutionElement = '&nbsp;';
                    // Restore the serialized task and pass it a reference to the scheduler object
                    $task = unserialize($schedulerRecord['serialized_task_object']);
                    $class = get_class($task);
                    if ($class === '__PHP_Incomplete_Class' && preg_match('/^O:[0-9]+:"(?P<classname>.+?)"/', $schedulerRecord['serialized_task_object'], $matches) === 1) {
                        $class = $matches['classname'];
                    }
                    // Assemble information about last execution
                    $context = '';
                    if (!empty($schedulerRecord['lastexecution_time'])) {
                        $lastExecution = date($dateFormat, $schedulerRecord['lastexecution_time']);
                        if ($schedulerRecord['lastexecution_context'] == 'CLI') {
                            $context = $GLOBALS['LANG']->getLL('label.cron');
                        } else {
                            $context = $GLOBALS['LANG']->getLL('label.manual');
                        }
                        $lastExecution .= ' (' . $context . ')';
                    }

                    if ($this->scheduler->isValidTaskObject($task)) {
                        // The task object is valid
                        $name = htmlspecialchars($registeredClasses[$class]['title'] . ' (' . $registeredClasses[$class]['extension'] . ')');
                        $additionalInformation = $task->getAdditionalInformation();
                        if ($task instanceof \TYPO3\CMS\Scheduler\ProgressProviderInterface) {
                            $progress = round(floatval($task->getProgress()), 2);
                            $name .= '<br />' . $this->renderTaskProgressBar($progress);
                        }
                        if (!empty($additionalInformation)) {
                            $name .= '<br />[' . htmlspecialchars($additionalInformation) . ']';
                        }
                        // Check if task currently has a running execution
                        if (!empty($schedulerRecord['serialized_executions'])) {
                            $isRunning = TRUE;
                            $executionStatus = 'running';
                        }

                        // Prepare display of next execution date
                        // If task is currently running, date is not displayed (as next hasn't been calculated yet)
                        // Also hide the date if task is disabled (the information doesn't make sense, as it will not run anyway)
                        if ($isRunning || $schedulerRecord['disable'] == 1) {
                            $nextDate = '-';
                        } else {
                            $nextDate = date($dateFormat, $schedulerRecord['nextexecution']);
                            if (empty($schedulerRecord['nextexecution'])) {
                                $nextDate = $GLOBALS['LANG']->getLL('none');
                            } elseif ($schedulerRecord['nextexecution'] < $GLOBALS['EXEC_TIME']) {
                                // Next execution is overdue, highlight date
                                $nextDate = '<span class="late" title="' . $GLOBALS['LANG']->getLL('status.legend.scheduled') . '">' . $nextDate . '</span>';
                                $executionStatus = 'late';
                            }
                        }
                        // Get execution type
                        if ($task->getExecution()->getInterval() == 0 && $task->getExecution()->getCronCmd() == '') {
                            $execType = $GLOBALS['LANG']->getLL('label.type.single');
                            $frequency = '-';
                        } else {
                            $execType = $GLOBALS['LANG']->getLL('label.type.recurring');
                            if ($task->getExecution()->getCronCmd() == '') {
                                $frequency = $task->getExecution()->getInterval();
                            } else {
                                $frequency = $task->getExecution()->getCronCmd();
                            }
                        }
                        // Get multiple executions setting
                        if ($task->getExecution()->getMultiple()) {
                            $multiple = $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:yes');
                        } else {
                            $multiple = $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:no');
                        }
                        // Define checkbox
                        $startExecutionElement = '<input type="checkbox" name="tx_scheduler[execute][]" value="' . $schedulerRecord['uid'] . '" id="task_' . $schedulerRecord['uid'] . '" class="checkboxes" />';

                        $actions = $editAction . $deleteAction;

                        // Check the disable status
                        // Row is shown dimmed if task is disabled, unless it is still running
                        if ($schedulerRecord['disable'] == 1 && !$isRunning) {
                            $tableLayout[$tr] = $disabledTaskRow;
                            $executionStatus = 'disabled';
                        }

                        // Show no action links (edit, delete) if task is running
                        if ($isRunning) {
                            $actions = $stopAction;
                        } else {
                            $actions .= $runAction;
                        }

                        // Check if the last run failed
                        $failureOutput = '';
                        if (!empty($schedulerRecord['lastexecution_failure'])) {
                            // Try to get the stored exception array
                            $exceptionArray = @unserialize($schedulerRecord['lastexecution_failure']);
                            if (!is_array($exceptionArray) || empty($exceptionArray)) {
                                $failureDetail = $GLOBALS['LANG']->getLL('msg.executionFailureDefault');
                            } else {
                                $failureDetail = sprintf($GLOBALS['LANG']->getLL('msg.executionFailureReport'), $exceptionArray['code'], $exceptionArray['message']);
                            }
                            $failureOutput = ' <img ' . IconUtility::skinImg(ExtensionManagementUtility::extRelPath('scheduler'), 'res/gfx/status_failure.png') . ' alt="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.failure')) . '" title="' . htmlspecialchars($failureDetail) . '" />';
                        }
                        // Format the execution status,
                        // including failure feedback, if any
                        $executionStatusOutput = '<img ' . IconUtility::skinImg(ExtensionManagementUtility::extRelPath('scheduler'), ('res/gfx/status_' . $executionStatus . '.png')) . ' id="executionstatus_' . $schedulerRecord['uid'] . '" alt="' . htmlspecialchars($GLOBALS['LANG']->getLL(('status.' . $executionStatus))) . '" title="' . htmlspecialchars($GLOBALS['LANG']->getLL(('status.legend.' . $executionStatus))) . '" />' . $failureOutput;
                        $table[$tr][] = $startExecutionElement;
                        $table[$tr][] = $actions;
                        $table[$tr][] = $schedulerRecord['uid'];
                        $table[$tr][] = $executionStatusOutput;
                        if ($schedulerRecord['description'] !== '') {
                            if (!empty($this->scheduler->extConf['listShowTaskDescriptionAsHover'])) {
                                $table[$tr][] = '<span title="' . htmlspecialchars($schedulerRecord['description']) . '">' . $name . '</span>';
                            } else {
                                $table[$tr][] = $name . '<br />' . nl2br(htmlspecialchars($schedulerRecord['description'])) . '<br />';
                            }
                        } else {
                            $table[$tr][] = $name;
                        }
                        $table[$tr][] = $execType;
                        $table[$tr][] = $frequency;
                        $table[$tr][] = $multiple;
                        $table[$tr][] = $lastExecution;
                        $table[$tr][] = $nextDate;
                    } else {
                        // The task object is not valid
                        // Prepare to issue an error
                        $flashMessage = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessage', sprintf($GLOBALS['LANG']->getLL('msg.invalidTaskClass'), $class), '', \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                        $executionStatusOutput = $flashMessage->render();
                        $tableLayout[$tr] = $rowWithSpan;
                        $table[$tr][] = $startExecutionElement;
                        $table[$tr][] = $deleteAction;
                        $table[$tr][] = $schedulerRecord['uid'];
                        $table[$tr][] = $executionStatusOutput;
                    }
                    $tr++;
                }
            }
            $this->getDatabaseConnection()->sql_free_result($res);

            // Render table
            $content .= $this->doc->table($table, $tableLayout);

            $content .= '<button name="go" id="scheduler_executeselected">' .
                    IconUtility::getSpriteIcon('extensions-scheduler-run-task') . ' ' .
                    $GLOBALS['LANG']->getLL('label.executeSelected') . '</button>';
        }
        if (!count($registeredClasses) > 0) {
            $flashMessage = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessage', $GLOBALS['LANG']->getLL('msg.noTasksDefined'), '', \TYPO3\CMS\Core\Messaging\FlashMessage::INFO);
            $content .= $flashMessage->render();
        }
        // Display legend, if there's at least one registered task
        // Also display information about the usage of server time
        if ($numRows > 0) {
            $content .= $this->doc->spacer(20);
            $content .= '<h3>' . $GLOBALS['LANG']->getLL('status.legend') . '</h3>
            <ul>
                <li><img ' . IconUtility::skinImg(ExtensionManagementUtility::extRelPath('scheduler'), 'res/gfx/status_failure.png') . ' alt="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.failure')) . '" title="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.failure')) . '" /> ' . $GLOBALS['LANG']->getLL('status.legend.failure') . '</li>
                <li><img ' . IconUtility::skinImg(ExtensionManagementUtility::extRelPath('scheduler'), 'res/gfx/status_late.png') . ' alt="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.late')) . '" title="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.late')) . '" /> ' . $GLOBALS['LANG']->getLL('status.legend.late') . '</li>
                <li><img ' . IconUtility::skinImg(ExtensionManagementUtility::extRelPath('scheduler'), 'res/gfx/status_running.png') . ' alt="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.running')) . '" title="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.running')) . '" /> ' . $GLOBALS['LANG']->getLL('status.legend.running') . '</li>
                <li><img ' . IconUtility::skinImg(ExtensionManagementUtility::extRelPath('scheduler'), 'res/gfx/status_scheduled.png') . ' alt="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.scheduled')) . '" title="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.scheduled')) . '" /> ' . $GLOBALS['LANG']->getLL('status.legend.scheduled') . '</li>
                <li><img ' . IconUtility::skinImg(ExtensionManagementUtility::extRelPath('scheduler'), 'res/gfx/status_disabled.png') . ' alt="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.disabled')) . '" title="' . htmlspecialchars($GLOBALS['LANG']->getLL('status.disabled')) . '" /> ' . $GLOBALS['LANG']->getLL('status.legend.disabled') . '</li>
            </ul>';
            $content .= $this->displayServerTime();
        }
        return $content;
    }

    protected function saveTask() {
        // If a task is being edited fetch old task data
        if (!empty($this->submittedData['uid'])) {
            try {
                $taskRecord = $this->scheduler->fetchTaskRecord($this->submittedData['uid']);
                $task = unserialize($taskRecord['serialized_task_object']);
            } catch (\OutOfBoundsException $e) {
                // If the task could not be fetched, issue an error message
                // and exit early
                $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.taskNotFound'), $this->submittedData['uid']), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                return;
            }
            // Register single execution
            if ($this->submittedData['type'] == 1) {
                $task->registerSingleExecution($this->submittedData['start']);
            } else {
                if (!empty($this->submittedData['croncmd'])) {
                    // Definition by cron-like syntax
                    $interval = 0;
                    $cronCmd = $this->submittedData['croncmd'];
                } else {
                    // Definition by interval
                    $interval = $this->submittedData['interval'];
                    $cronCmd = '';
                }
                // Register recurring execution
                $task->registerRecurringExecution($this->submittedData['start'], $interval, $this->submittedData['end'], $this->submittedData['multiple'], $cronCmd);
            }
            // Set disable flag
            $task->setDisabled($this->submittedData['disable']);
            // Set description
            $task->setDescription($this->submittedData['description']);
            // Set task group
            $task->setTaskGroup($this->submittedData['task_group']);
            // Save additional input values
            if (!empty($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks'][$this->submittedData['class']]['additionalFields'])) {
                $providerObject = GeneralUtility::getUserObj($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks'][$this->submittedData['class']]['additionalFields']);
                if ($providerObject instanceof \TYPO3\CMS\Scheduler\AdditionalFieldProviderInterface) {
                    $providerObject->saveAdditionalFields($this->submittedData, $task);
                }
            }
            // Save to database
            $result = $this->scheduler->saveTask($task);
            if ($result) {
                $GLOBALS['BE_USER']->writeLog(4, 0, 0, 0, 'Scheduler task "%s" (UID: %s, Class: "%s") was updated', array($task->getTaskTitle(), $task->getTaskUid(), $task->getTaskClassName()));
                $this->addMessage($GLOBALS['LANG']->getLL('msg.updateSuccess'));
            } else {
                $this->addMessage($GLOBALS['LANG']->getLL('msg.updateError'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
            }
        } else {
            // A new task is being created
            // Create an instance of chosen class
            $task = GeneralUtility::makeInstance($this->submittedData['class']);
            if ($this->submittedData['type'] == 1) {
                // Set up single execution
                $task->registerSingleExecution($this->submittedData['start']);
            } else {
                // Set up recurring execution
                $task->registerRecurringExecution($this->submittedData['start'], $this->submittedData['interval'], $this->submittedData['end'], $this->submittedData['multiple'], $this->submittedData['croncmd']);
            }
            // Save additional input values
            if (!empty($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks'][$this->submittedData['class']]['additionalFields'])) {
                $providerObject = GeneralUtility::getUserObj($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks'][$this->submittedData['class']]['additionalFields']);
                if ($providerObject instanceof \TYPO3\CMS\Scheduler\AdditionalFieldProviderInterface) {
                    $providerObject->saveAdditionalFields($this->submittedData, $task);
                }
            }
            // Set disable flag
            $task->setDisabled($this->submittedData['disable']);
            // Set description
            $task->setDescription($this->submittedData['description']);
            // Set description
            $task->setTaskGroup($this->submittedData['task_group']);
            // Add to database
            $result = $this->scheduler->addTask($task);
            if ($result) {
                $GLOBALS['BE_USER']->writeLog(4, 0, 0, 0, 'Scheduler task "%s" (UID: %s, Class: "%s") was added', array($task->getTaskTitle(), $task->getTaskUid(), $task->getTaskClassName()));
                $this->addMessage($GLOBALS['LANG']->getLL('msg.addSuccess'));

                // set the uid of the just created task so that we
                // can continue editing after initial saving
                $this->submittedData['uid'] = $task->getTaskUid();
            } else {
                $this->addMessage($GLOBALS['LANG']->getLL('msg.addError'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
            }
        }
    }

    /*************************
     *
     * INPUT PROCESSING UTILITIES
     *
     *************************/
    protected function preprocessData() {
        $result = TRUE;
        // Validate id
        $this->submittedData['uid'] = empty($this->submittedData['uid']) ? 0 : (int)$this->submittedData['uid'];
        // Validate selected task class
        if (!class_exists($this->submittedData['class'])) {
            $this->addMessage($GLOBALS['LANG']->getLL('msg.noTaskClassFound'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
        }
        // Check start date
        if (empty($this->submittedData['start'])) {
            $this->addMessage($GLOBALS['LANG']->getLL('msg.noStartDate'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
            $result = FALSE;
        } else {
            try {
                $timestamp = $this->checkDate($this->submittedData['start']);
                $this->submittedData['start'] = $timestamp;
            } catch (\Exception $e) {
                $this->addMessage($GLOBALS['LANG']->getLL('msg.invalidStartDate'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                $result = FALSE;
            }
        }
        // Check end date, if recurring task
        if ($this->submittedData['type'] == 2 && !empty($this->submittedData['end'])) {
            try {
                $timestamp = $this->checkDate($this->submittedData['end']);
                $this->submittedData['end'] = $timestamp;
                if ($this->submittedData['end'] < $this->submittedData['start']) {
                    $this->addMessage($GLOBALS['LANG']->getLL('msg.endDateSmallerThanStartDate'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                    $result = FALSE;
                }
            } catch (\Exception $e) {
                $this->addMessage($GLOBALS['LANG']->getLL('msg.invalidEndDate'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                $result = FALSE;
            }
        }
        // Set default values for interval and cron command
        $this->submittedData['interval'] = 0;
        $this->submittedData['croncmd'] = '';
        // Check type and validity of frequency, if recurring
        if ($this->submittedData['type'] == 2) {
            $frequency = trim($this->submittedData['frequency']);
            if (empty($frequency)) {
                // Empty frequency, not valid
                $this->addMessage($GLOBALS['LANG']->getLL('msg.noFrequency'), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                $result = FALSE;
            } else {
                $cronErrorCode = 0;
                $cronErrorMessage = '';
                // Try interpreting the cron command
                try {
                    \TYPO3\CMS\Scheduler\CronCommand\NormalizeCommand::normalize($frequency);
                    $this->submittedData['croncmd'] = $frequency;
                } catch (\Exception $e) {
                    // Store the exception's result
                    $cronErrorMessage = $e->getMessage();
                    $cronErrorCode = $e->getCode();
                    // Check if the frequency is a valid number
                    // If yes, assume it is a frequency in seconds, and unset cron error code
                    if (is_numeric($frequency)) {
                        $this->submittedData['interval'] = (int)$frequency;
                        unset($cronErrorCode);
                    }
                }
                // If there's a cron error code, issue validation error message
                if (!empty($cronErrorCode)) {
                    $this->addMessage(sprintf($GLOBALS['LANG']->getLL('msg.frequencyError'), $cronErrorMessage, $cronErrorCode), \TYPO3\CMS\Core\Messaging\FlashMessage::ERROR);
                    $result = FALSE;
                }
            }
        }
        // Validate additional input fields
        if (!empty($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks'][$this->submittedData['class']]['additionalFields'])) {
            $providerObject = GeneralUtility::getUserObj($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks'][$this->submittedData['class']]['additionalFields']);
            if ($providerObject instanceof \TYPO3\CMS\Scheduler\AdditionalFieldProviderInterface) {
                // The validate method will return TRUE if all went well, but that must not
                // override previous FALSE values => AND the returned value with the existing one
                $result &= $providerObject->validateAdditionalFields($this->submittedData, $this);
            }
        }
        return $result;
    }

    public function checkDate($string) {
        // Try with strtotime
        $timestamp = strtotime($string);
        // That failed. Try TYPO3's standard date/time input format
        if ($timestamp === FALSE) {
            // Split time and date
            $dateParts = GeneralUtility::trimExplode(' ', $string, TRUE);
            // Proceed if there are indeed two parts
            // Extract each component of date and time
            if (count($dateParts) == 2) {
                list($time, $date) = $dateParts;
                list($hour, $minutes) = GeneralUtility::trimExplode(':', $time, TRUE);
                list($day, $month, $year) = GeneralUtility::trimExplode('-', $date, TRUE);
                // Get a timestamp from all these parts
                $timestamp = @mktime($hour, $minutes, 0, $month, $day, $year);
            }
            // If the timestamp is still FALSE, throw an exception
            if ($timestamp === FALSE) {
                throw new \InvalidArgumentException('"' . $string . '" seems not to be a correct date.', 1294587694);
            }
        }
        return $timestamp;
    }

    /*************************
     *
     * APPLICATION LOGIC UTILITIES
     *
     *************************/
    public function addMessage($message, $severity = \TYPO3\CMS\Core\Messaging\FlashMessage::OK) {
        $flashMessage = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessage', $message, '', $severity);
        $flashMessageService = GeneralUtility::makeInstance('TYPO3\\CMS\\Core\\Messaging\\FlashMessageService');
        $defaultFlashMessageQueue = $flashMessageService->getMessageQueueByIdentifier();
        $defaultFlashMessageQueue->enqueue($flashMessage);
    }

    static protected function getRegisteredClasses() {
        $list = array();
        if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks'])) {
            foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['scheduler']['tasks'] as $class => $registrationInformation) {
                $title = isset($registrationInformation['title']) ? $GLOBALS['LANG']->sL($registrationInformation['title']) : '';
                $description = isset($registrationInformation['description']) ? $GLOBALS['LANG']->sL($registrationInformation['description']) : '';
                $list[$class] = array(
                    'extension' => $registrationInformation['extension'],
                    'title' => $title,
                    'description' => $description,
                    'provider' => isset($registrationInformation['additionalFields']) ? $registrationInformation['additionalFields'] : ''
                );
            }
        }
        return $list;
    }

    static protected function getRegisteredTaskGroups() {
        $list = array();

        // Get all registered task groups
        $query = array(
            'SELECT' => '*',
            'FROM' => 'tx_scheduler_task_group',
            'WHERE' => '1=1'
                . BackendUtility::BEenableFields('tx_scheduler_task_group')
                . BackendUtility::deleteClause('tx_scheduler_task_group'),
            'ORDERBY' => 'sorting'
        );
        $res = $GLOBALS['TYPO3_DB']->exec_SELECT_queryArray($query);

        while (($groupRecord = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) !== FALSE) {
            $list[] = $groupRecord;
        }
        $GLOBALS['TYPO3_DB']->sql_free_result($res);

        return $list;
    }

    /*************************
     *
     * RENDERING UTILITIES
     *
     *************************/
    protected function getTemplateMarkers() {
        $markers = array(
            'CSH' => BackendUtility::wrapInHelp('_MOD_system_txschedulerM1', ''),
            'FUNC_MENU' => $this->getFunctionMenu(),
            'CONTENT' => $this->content,
            'TITLE' => $GLOBALS['LANG']->getLL('title')
        );
        return $markers;
    }

    protected function getFunctionMenu() {
        $functionMenu = BackendUtility::getFuncMenu(0, 'SET[function]', $this->MOD_SETTINGS['function'], $this->MOD_MENU['function']);
        return $functionMenu;
    }

    protected function getDocHeaderButtons() {
        $buttons = array(
            'addtask' => '',
            'close' => '',
            'save' => '',
            'saveclose' => '',
            'savenew' => '',
            'delete' => '',
            'reload' => '',
            'shortcut' => $this->getShortcutButton()
        );
        if (empty($this->CMD) || $this->CMD == 'list' || $this->CMD == 'delete' || $this->CMD == 'stop') {
            $buttons['reload'] = '<a href="' . $GLOBALS['MCONF']['_'] . '" title="' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.xlf:labels.reload', TRUE) . '">' . IconUtility::getSpriteIcon('actions-system-refresh') . '</a>';
            if ($this->MOD_SETTINGS['function'] === 'scheduler' && count(self::getRegisteredClasses())) {
                $link = $GLOBALS['MCONF']['_'] . '&CMD=add';
                $image = IconUtility::getSpriteIcon('actions-document-new', array('alt' => $GLOBALS['LANG']->getLL('action.add')));
                $buttons['addtask'] = '<a href="' . htmlspecialchars($link) . '" ' . 'title="' . $GLOBALS['LANG']->getLL('action.add') . '">' . $image . '</a>';
            }
        }
        if ($this->CMD === 'add' || $this->CMD === 'edit') {
            $buttons['close'] = '<a href="#" onclick="document.location=\'' . $GLOBALS['MCONF']['_'] . '\'" title="' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:cancel', TRUE) . '">' . IconUtility::getSpriteIcon('actions-document-close') . '</a>';
            $buttons['save'] = '<button style="padding: 0; margin: 0; cursor: pointer;" type="submit" name="CMD" value="save" class="c-inputButton" src="clear.gif" title="' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:save', TRUE) . '" />' . IconUtility::getSpriteIcon('actions-document-save') . '</button>';
            $buttons['saveclose'] = '<button style="padding: 0; margin: 0; cursor: pointer;" type="submit" name="CMD" value="saveclose" class="c-inputButton" src="clear.gif" title="' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:saveAndClose', TRUE) . '" />' . IconUtility::getSpriteIcon('actions-document-save-close') . '</button>';
            $buttons['savenew'] = '<button style="padding: 0; margin: 0; cursor: pointer;" type="submit" name="CMD" value="savenew" class="c-inputButton" src="clear.gif" title="' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:saveAndCreateNewDoc', TRUE) . '" />' . IconUtility::getSpriteIcon('actions-document-save-new') . '</button>';
        }
        if ($this->CMD === 'edit') {
            $buttons['delete'] = '<button style="padding: 0; margin: 0; cursor: pointer;" type="submit" name="CMD" value="delete" class="c-inputButton" src="clear.gif" title="' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xlf:delete', TRUE) . '" />' . IconUtility::getSpriteIcon('actions-edit-delete') . '</button>';
        }
        return $buttons;
    }

    protected function getShortcutButton() {
        $result = '';
        if ($GLOBALS['BE_USER']->mayMakeShortcut()) {
            $result = $this->doc->makeShortcutIcon('', 'function', $this->MCONF['name']);
        }
        return $result;
    }

    protected function getBackendUserAuthentication() {
        return $GLOBALS['BE_USER'];
    }

    protected function getDatabaseConnection() {
        return $GLOBALS['TYPO3_DB'];
    }

}