BackendUtilityTest.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Backend\Tests\Unit\Utility;

use TYPO3\CMS\Backend\Utility\BackendUtility;

class BackendUtilityTest extends \TYPO3\CMS\Core\Tests\UnitTestCase {

    // Tests concerning calcAge

    public function calcAgeDataProvider() {
        return array(
            'Single year' => array(
                'seconds' => 60 * 60 * 24 * 365,
                'expectedLabel' => '1 year'
            ),
            'Plural years' => array(
                'seconds' => 60 * 60 * 24 * 365 * 2,
                'expectedLabel' => '2 yrs'
            ),
            'Single negative year' => array(
                'seconds' => 60 * 60 * 24 * 365 * -1,
                'expectedLabel' => '-1 year'
            ),
            'Plural negative years' => array(
                'seconds' => 60 * 60 * 24 * 365 * 2 * -1,
                'expectedLabel' => '-2 yrs'
            ),
            'Single day' => array(
                'seconds' => 60 * 60 * 24,
                'expectedLabel' => '1 day'
            ),
            'Plural days' => array(
                'seconds' => 60 * 60 * 24 * 2,
                'expectedLabel' => '2 days'
            ),
            'Single negative day' => array(
                'seconds' => 60 * 60 * 24 * -1,
                'expectedLabel' => '-1 day'
            ),
            'Plural negative days' => array(
                'seconds' => 60 * 60 * 24 * 2 * -1,
                'expectedLabel' => '-2 days'
            ),
            'Single hour' => array(
                'seconds' => 60 * 60,
                'expectedLabel' => '1 hour'
            ),
            'Plural hours' => array(
                'seconds' => 60 * 60 * 2,
                'expectedLabel' => '2 hrs'
            ),
            'Single negative hour' => array(
                'seconds' => 60 * 60 * -1,
                'expectedLabel' => '-1 hour'
            ),
            'Plural negative hours' => array(
                'seconds' => 60 * 60 * 2 * -1,
                'expectedLabel' => '-2 hrs'
            ),
            'Single minute' => array(
                'seconds' => 60,
                'expectedLabel' => '1 min'
            ),
            'Plural minutes' => array(
                'seconds' => 60 * 2,
                'expectedLabel' => '2 min'
            ),
            'Single negative minute' => array(
                'seconds' => 60 * -1,
                'expectedLabel' => '-1 min'
            ),
            'Plural negative minutes' => array(
                'seconds' => 60 * 2 * -1,
                'expectedLabel' => '-2 min'
            ),
            'Zero seconds' => array(
                'seconds' => 0,
                'expectedLabel' => '0 min'
            )
        );
    }

    public function calcAgeReturnsExpectedValues($seconds, $expectedLabel) {
        $this->assertSame($expectedLabel, BackendUtility::calcAge($seconds));
    }

    // Tests concerning getProcessedValue

    public function getProcessedValueForZeroStringIsZero() {
        $GLOBALS['TCA'] = array(
            'tt_content' => array(
                'columns' => array(
                    'header' => array(
                        'config' => array(
                            'type' => 'input',
                        ),
                    ),
                ),
            ),
        );
        $this->assertEquals('0', BackendUtility::getProcessedValue('tt_content', 'header', '0'));
    }

    public function getProcessedValueForGroup() {
        $GLOBALS['TCA'] = array(
            'tt_content' => array(
                'columns' => array(
                    'multimedia' => array(
                        'config' => array(
                            'type' => 'group',
                        ),
                    ),
                ),
            ),
        );
        $this->assertSame('1, 2', BackendUtility::getProcessedValue('tt_content', 'multimedia', '1,2'));
    }

    public function getProcessedValueForGroupWithOneAllowedTable() {
        // Disable getRecordWSOL and getRecordTitle dependency by returning stable results
        $className = $this->getUniqueId('BackendUtility');
        $subject = __NAMESPACE__ . '\\' . $className;
        eval(
            'namespace ' . __NAMESPACE__ . ';' .
            'class ' . $className . ' extends \\TYPO3\\CMS\\Backend\\Utility\\BackendUtility {' .
            '  static public function getRecordWSOL() {' .
            '    static $called = 0;' .
            '    ++$called;' .
            '    if ($called === 1) {' .
            '      return array(\'title\' => \'Page 1\');' .
            '    }' .
            '    if ($called === 2) {' .
            '      return array(\'title\' => \'Page 2\');' .
            '    }' .
            '  }' .
            '  static public function getRecordTitle() {' .
            '    static $called = 0;' .
            '    ++$called;' .
            '    if ($called === 1) {' .
            '      return \'Page 1\';' .
            '    }' .
            '    if ($called === 2) {' .
            '      return \'Page 2\';' .
            '    }' .
            '  }' .
            '}'
        );

        $GLOBALS['TCA'] = array(
            'tt_content' => array(
                'columns' => array(
                    'pages' => array(
                        'config' => array(
                            'type' => 'group',
                            'allowed' => 'pages',
                            'internal_type' => 'db',
                            'maxitems' => 22,
                            'minitems' => 0,
                            'show_thumbs' => 1,
                            'size' => 3,
                        ),
                    ),
                ),
            ),
        );

        $this->assertSame('Page 1, Page 2', $subject::getProcessedValue('tt_content', 'pages', '1,2'));
    }

    public function getProcessedValueForGroupWithMultipleAllowedTables() {
        // Disable getRecordWSOL and getRecordTitle dependency by returning stable results
        $className = $this->getUniqueId('BackendUtility');
        $subject = __NAMESPACE__ . '\\' . $className;
        eval(
            'namespace ' . __NAMESPACE__ . ';' .
            'class ' . $className . ' extends \\TYPO3\\CMS\\Backend\\Utility\\BackendUtility {' .
            '  static public function getRecordWSOL() {' .
            '    static $called = 0;' .
            '    ++$called;' .
            '    if ($called === 1) {' .
            '      return array(\'title\' => \'Page 1\');' .
            '    }' .
            '    if ($called === 2) {' .
            '      return array(\'header\' => \'Configuration 2\');' .
            '    }' .
            '  }' .
            '  static public function getRecordTitle() {' .
            '    static $called = 0;' .
            '    ++$called;' .
            '    if ($called === 1) {' .
            '      return \'Page 1\';' .
            '    }' .
            '    if ($called === 2) {' .
            '      return \'Configuration 2\';' .
            '    }' .
            '  }' .
            '}'
        );

        $GLOBALS['TCA'] = array(
            'index_config' => array(
                'columns' => array(
                    'indexcfgs' => array(
                        'config' => array(
                            'type' => 'group',
                            'internal_type' => 'db',
                            'allowed' => 'index_config,pages',
                            'size' => 5,
                        ),
                    ),
                ),
            ),
        );

        $this->assertSame('Page 1, Configuration 2', $subject::getProcessedValue('index_config', 'indexcfgs', 'pages_1,index_config_2'));
    }

    public function getProcessedValueForSelectWithMMRelation() {
        $GLOBALS['TYPO3_DB'] = $this->getMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array(), array(), '', FALSE);
        $GLOBALS['TYPO3_DB']->expects($this->any())->method('fullQuoteStr')
            ->will($this->returnCallback(
                function($quoteStr, $table) {
                    return "'" . $quoteStr . "'";
                }
            ));
        $GLOBALS['TYPO3_DB']->expects($this->any())->method('exec_SELECTquery')->will($this->returnValue(0));
        $GLOBALS['TYPO3_DB']->expects($this->any())->method('sql_free_result');
        $GLOBALS['TYPO3_DB']->expects($this->any())->method('sql_fetch_assoc')
            ->will($this->returnCallback(
                function($res) {
                    static $called = 0;
                    ++$called;
                    switch ($called) {
                        // SELECT * FROM sys_category_record_mm
                        case 1:
                            return array(
                                'uid_local' => 1,   // uid of a sys_category record
                                'uid_foreign' => 1, // uid of a pages record
                            );
                        case 2:
                            return array(
                                'uid_local' => 2,   // uid of a sys_category record
                                'uid_foreign' => 1, // uid of a pages record
                            );
                        case 3:
                            return NULL;
                        // SELECT * FROM sys_catgory
                        case 4:
                            return array(
                                'uid' => 1,
                                'title' => 'Category 1',
                            );
                        case 5:
                            return array(
                                'uid' => 2,
                                'title' => 'Category 2',
                            );
                        case 6:
                            return NULL;
                    }
                }
            ));

        // Disable getRecordTitle dependency by returning stable results
        $className = $this->getUniqueId('BackendUtility');
        $subject = __NAMESPACE__ . '\\' . $className;
        eval(
            'namespace ' . __NAMESPACE__ . ';' .
            'class ' . $className . ' extends \\TYPO3\\CMS\\Backend\\Utility\\BackendUtility {' .
            '  static public function getRecordTitle($table, $row) {' .
            '    return $row["title"];' .
            '  }' .
            '}'
        );

        $GLOBALS['TCA'] = array(
            'pages' => array(
                'columns' => array(
                    'categories' => array(
                        'config' => array(
                            'type' => 'select',
                            'foreign_table' => 'sys_category',
                            'MM' => 'sys_category_record_mm',
                            'MM_match_fields' => array(
                                'fieldname' => 'categories',
                                'tablesnames' => 'pages',
                            ),
                            'MM_opposite_field' => 'items',
                        ),
                    ),
                ),
            ),
            'sys_category' => array(
                'columns' => array(
                    'items' => array(
                        'config' => array(
                            'type' => 'group',
                            'internal_type' => 'db',
                            'allowed' => '*',
                            'MM' => 'sys_category_record_mm',
                            'MM_oppositeUsage' => array(),
                        )
                    )
                ),
            ),
        );

        $this->assertSame('Category 1; Category 2', $subject::getProcessedValue('pages', 'categories', '2', 0, FALSE, FALSE, 1));
    }

    public function getCommonSelectFieldsReturnsCorrectFieldsDataProvider() {
        return array(
            'only uid' => array(
                'table' => 'test_table',
                'prefix' => '',
                'presetFields' => array(),
                'tca' => array(),
                'expectedFields' => 'uid'
            ),
            'label set' => array(
                'table' => 'test_table',
                'prefix' => '',
                'presetFields' => array(),
                'tca' => array(
                    'ctrl' => array(
                        'label' => 'label'
                    )
                ),
                'expectedFields' => 'uid,label'
            ),
            'label_alt set' => array(
                'table' => 'test_table',
                'prefix' => '',
                'presetFields' => array(),
                'tca' => array(
                    'ctrl' => array(
                        'label_alt' => 'label,label2'
                    )
                ),
                'expectedFields' => 'uid,label,label2'
            ),
            'versioningWS set' => array(
                'table' => 'test_table',
                'prefix' => '',
                'presetFields' => array(),
                'tca' => array(
                    'ctrl' => array(
                        'versioningWS' => '2'
                    )
                ),
                'expectedFields' => 'uid,t3ver_id,t3ver_state,t3ver_wsid,t3ver_count'
            ),
            'selicon_field set' => array(
                'table' => 'test_table',
                'prefix' => '',
                'presetFields' => array(),
                'tca' => array(
                    'ctrl' => array(
                        'selicon_field' => 'field'
                    )
                ),
                'expectedFields' => 'uid,field'
            ),
            'typeicon_column set' => array(
                'table' => 'test_table',
                'prefix' => '',
                'presetFields' => array(),
                'tca' => array(
                    'ctrl' => array(
                        'typeicon_column' => 'field'
                    )
                ),
                'expectedFields' => 'uid,field'
            ),
            'enablecolumns set' => array(
                'table' => 'test_table',
                'prefix' => '',
                'presetFields' => array(),
                'tca' => array(
                    'ctrl' => array(
                        'enablecolumns' => array(
                            'disabled' => 'hidden',
                            'starttime' => 'start',
                            'endtime' => 'stop',
                            'fe_group' => 'groups'
                        )
                    )
                ),
                'expectedFields' => 'uid,hidden,start,stop,groups'
            ),
            'label set to uid' => array(
                'table' => 'test_table',
                'prefix' => '',
                'presetFields' => array(),
                'tca' => array(
                    'ctrl' => array(
                        'label' => 'uid'
                    )
                ),
                'expectedFields' => 'uid'
            )
        );
    }

    public function getCommonSelectFieldsReturnsCorrectFields($table, $prefix = '', array $presetFields, array $tca, $expectedFields = '') {
        $GLOBALS['TCA'][$table] = $tca;
        $selectFields = BackendUtility::getCommonSelectFields($table, $prefix, $presetFields);
        $this->assertEquals($selectFields, $expectedFields);
    }

    public function getLabelFromItemlistReturnsCorrectFieldsDataProvider() {
        return array(
            'item set' => array(
                'table' => 'tt_content',
                'col' => 'menu_type',
                'key' => '1',
                'tca' => array(
                    'columns' => array(
                        'menu_type' => array(
                            'config' => array(
                                'items' => array(
                                    array('Item 1', '0'),
                                    array('Item 2', '1'),
                                    array('Item 3', '3')
                                )
                            )
                        )
                    )
                ),
                'expectedLabel' => 'Item 2'
            ),
            'item set twice' => array(
                'table' => 'tt_content',
                'col' => 'menu_type',
                'key' => '1',
                'tca' => array(
                    'columns' => array(
                        'menu_type' => array(
                            'config' => array(
                                'items' => array(
                                    array('Item 1', '0'),
                                    array('Item 2a', '1'),
                                    array('Item 2b', '1'),
                                    array('Item 3', '3')
                                )
                            )
                        )
                    )
                ),
                'expectedLabel' => 'Item 2a'
            ),
            'item not found' => array(
                'table' => 'tt_content',
                'col' => 'menu_type',
                'key' => '5',
                'tca' => array(
                    'columns' => array(
                        'menu_type' => array(
                            'config' => array(
                                'items' => array(
                                    array('Item 1', '0'),
                                    array('Item 2', '1'),
                                    array('Item 3', '2')
                                )
                            )
                        )
                    )
                ),
                'expectedLabel' => NULL
            )
        );
    }

    public function getLabelFromItemlistReturnsCorrectFields($table, $col = '', $key = '', array $tca, $expectedLabel = '') {
        $GLOBALS['TCA'][$table] = $tca;
        $label = BackendUtility::getLabelFromItemlist($table, $col, $key);
        $this->assertEquals($label, $expectedLabel);
    }

    public function getLabelFromItemListMergedReturnsCorrectFieldsDataProvider() {
        return array(
            'no field found' => array(
                'pageId' => '123',
                'table' => 'tt_content',
                'col' => 'menu_type',
                'key' => '10',
                'tca' => array(
                    'columns' => array(
                        'menu_type' => array(
                            'config' => array(
                                'items' => array(
                                    array('Item 1', '0'),
                                    array('Item 2', '1'),
                                    array('Item 3', '3')
                                )
                            )
                        )
                    )
                ),
                'expectedLabel' => ''
            ),
            'no tsconfig set' => array(
                'pageId' => '123',
                'table' => 'tt_content',
                'col' => 'menu_type',
                'key' => '1',
                'tca' => array(
                    'columns' => array(
                        'menu_type' => array(
                            'config' => array(
                                'items' => array(
                                    array('Item 1', '0'),
                                    array('Item 2', '1'),
                                    array('Item 3', '3')
                                )
                            )
                        )
                    )
                ),
                'expectedLabel' => 'Item 2'
            )
        );
    }

    public function getLabelFromItemListMergedReturnsCorrectFields($pageId, $table, $column = '', $key = '', array $tca, $expectedLabel = '') {
        // Disable getPagesTSconfig by returning stable result
        $className = $this->getUniqueId('BackendUtility');
        $subject = __NAMESPACE__ . '\\' . $className;
        eval(
            'namespace ' . __NAMESPACE__ . ';' .
            'class ' . $className . ' extends \\TYPO3\\CMS\\Backend\\Utility\\BackendUtility {' .
            '  static public function getPagesTSconfig() {' .
            '    return array();' .
            '  }' .
            '}'
        );

        $GLOBALS['TCA'][$table] = $tca;

        $this->assertEquals($expectedLabel, $subject::getLabelFromItemListMerged($pageId, $table, $column, $key));
    }

    public function getFuncCheckReturnsInputTagWithValueAttribute() {
        $this->assertStringMatchesFormat('<input %Svalue="1"%S/>', BackendUtility::getFuncCheck('params', 'test', TRUE));
    }

    public function getLabelsFromItemsListReturnsValueIfItemIsFound() {
        $table = 'foobar';
        $col = 'someColumn';
        $tca = array(
            'columns' => array(
                'someColumn' => array(
                    'config' => array(
                        'items' => array(
                            '0' => array('aFooLabel', 'foo'),
                            '1' => array('aBarLabel', 'bar')
                        )
                    )
                )
            )
        );
        // Stub LanguageService and let sL() return the same value that came in again
        $GLOBALS['LANG'] = $this->getMock('TYPO3\\CMS\\Lang\\LanguageService', array(), array(), '', FALSE);
        $GLOBALS['LANG']->expects($this->any())->method('sL')
            ->will($this->returnCallback(
                function($name) {
                    return $name;
                }
            ));

        $GLOBALS['TCA'][$table] = $tca;
        $label = BackendUtility::getLabelsFromItemsList($table, $col, 'foo,bar');
        $this->assertEquals('aFooLabel, aBarLabel', $label);
    }

    public function getProcessedValueReturnsLabelsForExistingValuesSolely() {
        $table = 'foobar';
        $col = 'someColumn';
        $tca = array(
            'columns' => array(
                'someColumn' => array(
                    'config' => array(
                        'type' => 'select',
                        'items' => array(
                            '0' => array('aFooLabel', 'foo'),
                            '1' => array('aBarLabel', 'bar')
                        )
                    )
                )
            )
        );
        // Stub LanguageService and let sL() return the same value that came in again
        $GLOBALS['LANG'] = $this->getMock('TYPO3\\CMS\\Lang\\LanguageService', array(), array(), '', FALSE);
        $GLOBALS['LANG']->charSet = 'utf-8';
        $GLOBALS['LANG']->csConvObj = $this->getMock('TYPO3\\CMS\\Core\\Charset\\CharsetConverter');
        $GLOBALS['LANG']->expects($this->any())->method('sL')
            ->will($this->returnCallback(
                function($name) {
                    return $name;
                }
            ));
        $GLOBALS['LANG']->csConvObj->expects($this->any())->method('crop')
            ->will($this->returnCallback(
                function($charset, $string, $len, $crop = '') {
                    return $string;
                }
            ));

        $GLOBALS['TCA'][$table] = $tca;
        $label = BackendUtility::getProcessedValue($table, $col, 'foo,invalidKey,bar');
        $this->assertEquals('aFooLabel, aBarLabel', $label);
    }

    public function getProcessedValueReturnsPlainValueIfItemIsNotFound() {
        $table = 'foobar';
        $col = 'someColumn';
        $tca = array(
            'columns' => array(
                'someColumn' => array(
                    'config' => array(
                        'type' => 'select',
                        'items' => array(
                            '0' => array('aFooLabel', 'foo')
                        )
                    )
                )
            )
        );
        // Stub LanguageService and let sL() return the same value that came in again
        $GLOBALS['LANG'] = $this->getMock('TYPO3\\CMS\\Lang\\LanguageService', array(), array(), '', FALSE);
        $GLOBALS['LANG']->charSet = 'utf-8';
        $GLOBALS['LANG']->csConvObj = $this->getMock('TYPO3\\CMS\\Core\\Charset\\CharsetConverter');
        $GLOBALS['LANG']->expects($this->any())->method('sL')
            ->will($this->returnCallback(
                function($name) {
                    return $name;
                }
            ));
        $GLOBALS['LANG']->csConvObj->expects($this->any())->method('crop')
            ->will($this->returnCallback(
                function($charset, $string, $len, $crop = '') {
                    return $string;
                }
            ));

        $GLOBALS['TCA'][$table] = $tca;
        $label = BackendUtility::getProcessedValue($table, $col, 'invalidKey');
        $this->assertEquals('invalidKey', $label);
    }

    public function getExcludeFieldsDataProvider() {
        return array(
            'getExcludeFields does not return fields not configured as exclude field' => array(
                array(
                    'tx_foo' => array(
                        'ctrl' => array(
                            'title' => 'foo',
                        ),
                        'columns' => array(
                            'bar' => array(
                                'label' => 'bar',
                                'exclude' => 1
                            ),
                            'baz' => array(
                                'label' => 'bar',
                            ),
                        )
                    )
                ),
                array(
                    array(
                        'foo: bar',
                        'tx_foo:bar',
                    ),
                )
            ),
            'getExcludeFields returns fields from root level tables if root level restriction should be ignored' => array(
                array(
                    'tx_foo' => array(
                        'ctrl' => array(
                            'title' => 'foo',
                            'rootLevel' => TRUE,
                            'security' => array(
                                'ignoreRootLevelRestriction' => TRUE,
                            ),
                        ),
                        'columns' => array(
                            'bar' => array(
                                'label' => 'bar',
                                'exclude' => 1
                            ),
                        )
                    )
                ),
                array(
                    array(
                        'foo: bar',
                        'tx_foo:bar',
                    ),
                )
            ),
            'getExcludeFields does not return fields from root level tables' => array(
                array(
                    'tx_foo' => array(
                        'ctrl' => array(
                            'title' => 'foo',
                            'rootLevel' => TRUE,
                        ),
                        'columns' => array(
                            'bar' => array(
                                'label' => 'bar',
                                'exclude' => 1
                            ),
                        )
                    )
                ),
                array()
            ),
            'getExcludeFields does not return fields from admin only level tables' => array(
                array(
                    'tx_foo' => array(
                        'ctrl' => array(
                            'title' => 'foo',
                            'adminOnly' => TRUE,
                        ),
                        'columns' => array(
                            'bar' => array(
                                'label' => 'bar',
                                'exclude' => 1
                            ),
                        )
                    )
                ),
                array()
            ),
        );
    }

    public function getExcludeFieldsReturnsCorrectFieldList($tca, $expected) {
        $className = $this->getUniqueId('BackendUtility');
        $subject = __NAMESPACE__ . '\\' . $className;
        eval(
            'namespace ' . __NAMESPACE__ . ';' .
            'class ' . $className . ' extends \\TYPO3\\CMS\\Backend\\Utility\\BackendUtility {' .
            '  static public function getRegisteredFlexForms() {' .
            '    return array();' .
            '  }' .
            '}'
        );

        $GLOBALS['TCA'] = $tca;

        // Stub LanguageService and let sL() return the same value that came in again
        $GLOBALS['LANG'] = $this->getMock('TYPO3\\CMS\\Lang\\LanguageService', array(), array(), '', FALSE);
        $GLOBALS['LANG']->expects($this->any())->method('sL')
            ->will($this->returnCallback(
                function($name) {
                    return $name;
                }
            ));

        $this->assertSame($expected, $subject::getExcludeFields());
    }

    public function getExcludeFieldsReturnsCorrectListWithFlexFormFields() {
        $GLOBALS['TCA'] = array(
            'tx_foo' => array(
                'ctrl' => array(
                    'title' => 'foo'
                ),
                'columns' => array(
                    'foo' => array(
                        'label' => 'foo',
                        'exclude' => 1
                    ),
                    'bar' => array(
                        'label' => 'bar',
                        'exclude' => 1
                    ),
                    'abarfoo' => array(
                        'label' => 'abarfoo',
                        'config' => array(
                            'type' => 'flex',
                            'ds' => array(
                                '*,dummy' => '',
                            )
                        )
                    )
                )
            ),
            'tx_foobar' => array(
                'ctrl' => array(
                    'title' => 'foobar'
                ),
                'columns' => array(
                    'foo' => array(
                        'label' => 'foo',
                        'exclude' => 1
                    ),
                    'bar' => array(
                        'label' => 'bar',
                        'exclude' => 1
                    )
                )
            ),
            'tx_bar' => array(
                'ctrl' => array(
                    'title' => 'bar'
                ),
                'columns' => array(
                    'foo' => array(
                        'label' => 'foo',
                        'exclude' => 1
                    ),
                    'bar' => array(
                        'label' => 'bar',
                        'exclude' => 1
                    )
                )
            )
        );

        $expectedResult = array(
            array(
                'bar: bar',
                'tx_bar:bar'
            ),
            array(
                'bar: foo',
                'tx_bar:foo'
            ),
            array(
                'abarfoo dummy: The Title:',
                'tx_foo:abarfoo;dummy;sGeneral;xmlTitle'
            ),
            array(
                'foo: bar',
                'tx_foo:bar'
            ),
            array(
                'foo: foo',
                'tx_foo:foo'
            ),
            array(
                'foobar: bar',
                'tx_foobar:bar'
            ),
            array(
                'foobar: foo',
                'tx_foobar:foo'
            ),
        );

        // Stub LanguageService and let sL() return the same value that came in again
        $GLOBALS['LANG'] = $this->getMock('TYPO3\\CMS\\Lang\\LanguageService', array(), array(), '', FALSE);
        $GLOBALS['LANG']->expects($this->any())->method('sL')
            ->will($this->returnCallback(
                function($name) {
                    return $name;
                }
            ));

        $className = $this->getUniqueId('BackendUtility');
        $subject = __NAMESPACE__ . '\\' . $className;
        eval(
            'namespace ' . __NAMESPACE__ . ';' .
            'class ' . $className . ' extends \\TYPO3\\CMS\\Backend\\Utility\\BackendUtility {' .
            '  static public function getRegisteredFlexForms($table) {' .
            '    static $called = 0;' .
            '    ++$called;' .
            '    if ($called === 1) {' .
            '      return array();' .
            '    }' .
            '    if ($called === 2) {' .
            '      if ($table !== \'tx_foo\') {' .
            '        throw new Exception(\'Expected tx_foo as argument on call 2\', 1399638572);' .
            '      }' .
            '      $parsedFlexForm = array(' .
            '        \'abarfoo\' => array(' .
            '          \'dummy\' => array(' .
            '            \'title\' => \'dummy\',' .
            '            \'ds\' => array(' .
            '              \'sheets\' => array(' .
            '                \'sGeneral\' => array(' .
            '                  \'ROOT\' => array(' .
            '                    \'type\' => \'array\',' .
            '                    \'el\' => array(' .
            '                      \'xmlTitle\' => array(' .
            '                        \'TCEforms\' => array(' .
            '                          \'exclude\' => 1,' .
            '                          \'label\' => \'The Title:\',' .
            '                          \'config\' => array(' .
            '                            \'type\' => \'input\',' .
            '                            \'size\' => 48,' .
            '                          ),' .
            '                        ),' .
            '                      ),' .
            '                    ),' .
            '                  ),' .
            '                ),' .
            '              ),' .
            '            ),' .
            '          ),' .
            '        ),' .
            '      );' .
            '      return $parsedFlexForm;' .
            '    }' .
            '    if ($called === 3) {' .
            '      return array();' .
            '    }' .
            '  }' .
            '}'
        );

        $this->assertSame($expectedResult, $subject::getExcludeFields());
    }

    public function viewOnClickReturnsOnClickCodeWithAlternativeUrl() {
        // Make sure the hook inside viewOnClick is not fired. This may be removed if unit tests
        // bootstrap does not initialize TYPO3_CONF_VARS anymore.
        unset($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_befunc.php']['viewOnClickClass']);

        $alternativeUrl = 'https://typo3.org/about/typo3-the-cms/the-history-of-typo3/#section';
        $onclickCode = 'var previewWin = window.open(\'' . $alternativeUrl . '\',\'newTYPO3frontendWindow\');';
        $this->assertStringMatchesFormat(
            $onclickCode,
            BackendUtility::viewOnClick(NULL, NULL, NULL, NULL, $alternativeUrl, NULL, FALSE)
        );
    }

    public function replaceMarkersInWhereClauseDataProvider() {
        return array(
            'replaceMarkersInWhereClause replaces record field marker with quoted string' => array(
                ' AND dummytable.title=\'###REC_FIELD_dummyfield###\'',
                array(
                    '_THIS_ROW' => array(
                        'dummyfield' => 'Hello World'
                    )
                ),
                ' AND dummytable.title=\'Hello World\''
            ),
            'replaceMarkersInWhereClause replaces record field marker with fullquoted string' => array(
                ' AND dummytable.title=###REC_FIELD_dummyfield###',
                array(
                    '_THIS_ROW' => array(
                        'dummyfield' => 'Hello World'
                    )
                ),
                ' AND dummytable.title=\'Hello World\''
            ),
            'replaceMarkersInWhereClause replaces multiple record field markers' => array(
                ' AND dummytable.title=\'###REC_FIELD_dummyfield###\' AND dummytable.pid=###REC_FIELD_pid###',
                array(
                    '_THIS_ROW' => array(
                        'dummyfield' => 'Hello World',
                        'pid' => 42
                    )
                ),
                ' AND dummytable.title=\'Hello World\' AND dummytable.pid=\'42\''
            ),
            'replaceMarkersInWhereClause replaces current pid with integer' => array(
                ' AND dummytable.uid=###CURRENT_PID###',
                array(
                    '_CURRENT_PID' => 42
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces current pid with string' => array(
                ' AND dummytable.uid=###CURRENT_PID###',
                array(
                    '_CURRENT_PID' => '42string'
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces current record uid with integer' => array(
                ' AND dummytable.uid=###THIS_UID###',
                array(
                    '_THIS_UID' => 42
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces current record uid with string' => array(
                ' AND dummytable.uid=###THIS_UID###',
                array(
                    '_THIS_UID' => '42string'
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces current record cid with integer' => array(
                ' AND dummytable.uid=###THIS_CID###',
                array(
                    '_THIS_CID' => 42
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces current record cid with string' => array(
                ' AND dummytable.uid=###THIS_CID###',
                array(
                    '_THIS_CID' => '42string'
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces storage pid with integer' => array(
                ' AND dummytable.uid=###STORAGE_PID###',
                array(
                    '_STORAGE_PID' => 42
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces storage pid with string' => array(
                ' AND dummytable.uid=###STORAGE_PID###',
                array(
                    '_STORAGE_PID' => '42string'
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces siteroot uid with integer' => array(
                ' AND dummytable.uid=###SITEROOT###',
                array(
                    '_SITEROOT' => 42
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces siteroot uid with string' => array(
                ' AND dummytable.uid=###SITEROOT###',
                array(
                    '_SITEROOT' => '42string'
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces page tsconfig id with integer' => array(
                ' AND dummytable.uid=###PAGE_TSCONFIG_ID###',
                array(
                    'dummyfield' => array(
                        'PAGE_TSCONFIG_ID' => 42
                    )
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces page tsconfig id with string' => array(
                ' AND dummytable.uid=###PAGE_TSCONFIG_ID###',
                array(
                    'dummyfield' => array(
                        'PAGE_TSCONFIG_ID' => '42string'
                    )
                ),
                ' AND dummytable.uid=42'
            ),
            'replaceMarkersInWhereClause replaces page tsconfig string' => array(
                ' AND dummytable.title=\'###PAGE_TSCONFIG_STR###\'',
                array(
                    'dummyfield' => array(
                        'PAGE_TSCONFIG_STR' => '42'
                    )
                ),
                ' AND dummytable.title=\'42\''
            ),
            'replaceMarkersInWhereClause replaces all markers' => array(
                ' AND dummytable.title=\'###REC_FIELD_dummyfield###\'' .
                ' AND dummytable.uid=###REC_FIELD_uid###' .
                ' AND dummytable.pid=###CURRENT_PID###' .
                ' AND dummytable.l18n_parent=###THIS_UID###' .
                ' AND dummytable.cid=###THIS_CID###' .
                ' AND dummytable.storage_pid=###STORAGE_PID###' .
                ' AND dummytable.siteroot=###SITEROOT###' .
                ' AND dummytable.config_uid=###PAGE_TSCONFIG_ID###' .
                ' AND dummytable.idlist IN (###PAGE_TSCONFIG_IDLIST###)' .
                ' AND dummytable.string=\'###PAGE_TSCONFIG_STR###\'',
                array(
                    '_THIS_ROW' => array(
                        'dummyfield' => 'Hello World',
                        'uid' => 42
                    ),
                    '_CURRENT_PID' => '1',
                    '_THIS_UID' => 2,
                    '_THIS_CID' => 3,
                    '_STORAGE_PID' => 4,
                    '_SITEROOT' => 5,
                    'dummyfield' => array(
                        'PAGE_TSCONFIG_ID' => 6,
                        'PAGE_TSCONFIG_IDLIST' => '1,2,3',
                        'PAGE_TSCONFIG_STR' => 'string'
                    )
                ),
                ' AND dummytable.title=\'Hello World\' AND dummytable.uid=\'42\' AND dummytable.pid=1' .
                ' AND dummytable.l18n_parent=2 AND dummytable.cid=3 AND dummytable.storage_pid=4' .
                ' AND dummytable.siteroot=5 AND dummytable.config_uid=6 AND dummytable.idlist IN (1,2,3)' .
                ' AND dummytable.string=\'string\'',
            ),
        );
    }

    public function replaceMarkersInWhereClauseReturnsValidWhereClause($whereClause, $tsConfig, $expected) {
        // Mock TYPO3_DB and let it return same values that came in
        $GLOBALS['TYPO3_DB'] = $this->getMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array(), array(), '', FALSE);
        $GLOBALS['TYPO3_DB']->expects($this->any())->method('quoteStr')
            ->will($this->returnCallback(
                function($quoteStr, $table) {
                    return $quoteStr;
                }
            ));
        $GLOBALS['TYPO3_DB']->expects($this->any())->method('fullQuoteStr')
            ->will($this->returnCallback(
                function($quoteStr, $table) {
                    return "'" . $quoteStr . "'";
                }
            ));
        $GLOBALS['TYPO3_DB']->expects($this->any())->method('cleanIntList')
            ->will($this->returnCallback(
                function($intList) {
                    return $intList;
                }
            ));
        $this->assertSame($expected, BackendUtility::replaceMarkersInWhereClause($whereClause, 'dummytable', 'dummyfield', $tsConfig));
    }

    public function replaceMarkersInWhereClauseCleansIdList() {
        $GLOBALS['TYPO3_DB'] = $this->getMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection', array(), array(), '', FALSE);
        $GLOBALS['TYPO3_DB']->expects($this->once())->method('cleanIntList')->with('1,a,2,b,3,c');
        $where = ' AND dummytable.uid IN (###PAGE_TSCONFIG_IDLIST###)';
        $tsConfig = array(
            'dummyfield' => array(
                'PAGE_TSCONFIG_IDLIST' => '1,a,2,b,3,c'
            ),
        );
        BackendUtility::replaceMarkersInWhereClause($where, 'dummytable', 'dummyfield', $tsConfig);
    }

    public function getModTSconfigIgnoresValuesFromUserTsConfigIfNoSet() {
        $completeConfiguration = array(
            'value' => 'bar',
            'properties' => array(
                'permissions.' => array(
                    'file.' => array(
                        'default.' => array('readAction' => '1'),
                        '1.' => array('writeAction' => '1'),
                        '0.' => array('readAction' => '0'),
                    ),
                )
            )
        );

        $GLOBALS['BE_USER'] = $this->getMock('TYPO3\\CMS\\Core\\Authentication\\BackendUserAuthentication', array(), array(), '', FALSE);
        $GLOBALS['BE_USER']->expects($this->at(0))->method('getTSConfig')->will($this->returnValue($completeConfiguration));
        $GLOBALS['BE_USER']->expects($this->at(1))->method('getTSConfig')->will($this->returnValue(array('value' => NULL, 'properties' => NULL)));

        $className = $this->getUniqueId('BackendUtility');
        $subject = __NAMESPACE__ . '\\' . $className;
        eval(
            'namespace ' . __NAMESPACE__ . ';' .
            'class ' . $className . ' extends \\TYPO3\\CMS\\Backend\\Utility\\BackendUtility {' .
            '  static public function getPagesTSconfig() {' .
            '    return array();' .
            '  }' .
            '}'
        );

        $this->assertSame($completeConfiguration, $subject::getModTSconfig(42, 'notrelevant'));
    }

    public function replaceL10nModeFieldsReplacesFieldsDataProvider() {
        return array(
            'same table: mergeIfNotBlank' => array(
                'foo',
                array(
                    'origUid' => 1,
                    'field2' => 'fdas',
                    'field3' => 'trans',
                ),
                array(
                    'foo' => array(
                        'ctrl' => array(
                            'transOrigPointerTable' => '',
                            'transOrigPointerField' => 'origUid'
                        ),
                        'columns' => array(
                            'field2' => array('l10n_mode' => 'mergeIfNotBlank'),
                            'field3' => array('l10n_mode' => 'mergeIfNotBlank')
                        )
                    )
                ),
                array(
                    'origUid' => 0,
                    'field2' => 'basic',
                    'field3' => '',
                ),
                array(
                    'origUid' => 1,
                    'field2' => 'fdas',
                    'field3' => 'trans',
                )
            ),
            'other table: mergeIfNotBlank' => array(
                'foo',
                array(
                    'origUid' => 1,
                    'field2' => '',
                    'field3' => 'trans',
                ),
                array(
                    'foo' => array(
                        'ctrl' => array(
                            'transOrigPointerTable' => 'bar',
                            'transOrigPointerField' => 'origUid'
                        )
                    ),
                    'bar' => array(
                        'columns' => array(
                            'field2' => array('l10n_mode' => 'mergeIfNotBlank'),
                            'field3' => array('l10n_mode' => 'mergeIfNotBlank')
                        )
                    )
                ),
                array(
                    'origUid' => 0,
                    'field2' => 'basic',
                    'field3' => '',
                ),
                array(
                    'origUid' => 1,
                    'field2' => 'basic',
                    'field3' => 'trans',
                )
            ),
            'same table: exclude' => array(
                'foo',
                array(
                    'origUid' => 1,
                    'field2' => 'fdas',
                    'field3' => 'trans',
                ),
                array(
                    'foo' => array(
                        'ctrl' => array(
                            'transOrigPointerTable' => '',
                            'transOrigPointerField' => 'origUid'
                        ),
                        'columns' => array(
                            'field2' => array('l10n_mode' => 'exclude'),
                            'field3' => array('l10n_mode' => 'exclude')
                        )
                    )
                ),
                array(
                    'origUid' => 0,
                    'field2' => 'basic',
                    'field3' => '',
                ),
                array(
                    'origUid' => 1,
                    'field2' => 'basic',
                    'field3' => '',
                )
            ),
            'other table: exclude' => array(
                'foo',
                array(
                    'origUid' => 1,
                    'field2' => 'fdas',
                    'field3' => 'trans',
                ),
                array(
                    'foo' => array(
                        'ctrl' => array(
                            'transOrigPointerTable' => 'bar',
                            'transOrigPointerField' => 'origUid'
                        )
                    ),
                    'bar' => array(
                        'columns' => array(
                            'field2' => array('l10n_mode' => 'exclude'),
                            'field3' => array('l10n_mode' => 'exclude')
                        )
                    )
                ),
                array(
                    'origUid' => 0,
                    'field2' => 'basic',
                    'field3' => '',
                ),
                array(
                    'origUid' => 1,
                    'field2' => 'basic',
                    'field3' => '',
                )
            ),
        );
    }

    public function replaceL10nModeFieldsReplacesFields($table, $row, $tca, $originalRow, $expected) {
        $GLOBALS['TCA'] = $tca;
        $GLOBALS['TYPO3_DB'] = $this->getMock('TYPO3\\CMS\\Core\\Database\\DatabaseConnection');
        $GLOBALS['TYPO3_DB']->expects($this->any())->method('exec_SELECTgetSingleRow')->will($this->returnValue($originalRow));

        $subject = $this->getAccessibleMock('TYPO3\\CMS\\Backend\\Utility\\BackendUtility', array('dummy'));
        $this->assertSame($expected, $subject->_call('replaceL10nModeFields', $table, $row));
    }
}