typo3/sysext/recordlist/Classes/RecordList/DatabaseRecordList.php

   1 <?php
   2 namespace TYPO3\CMS\Recordlist\RecordList;
   3
   4 /*
   5  * This file is part of the TYPO3 CMS project.
   6  *
   7  * It is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU General Public License, either version 2
   9  * of the License, or any later version.
  10  *
  11  * For the full copyright and license information, please read the
  12  * LICENSE.txt file that was distributed with this source code.
  13  *
  14  * The TYPO3 project - inspiring people to share!
  15  */
  16
  17 use TYPO3\CMS\Backend\Module\BaseScriptClass;
  18 use TYPO3\CMS\Backend\RecordList\RecordListGetTableHookInterface;
  19 use TYPO3\CMS\Backend\Template\Components\ButtonBar;
  20 use TYPO3\CMS\Backend\Template\DocumentTemplate;
  21 use TYPO3\CMS\Backend\Template\ModuleTemplate;
  22 use TYPO3\CMS\Backend\Utility\BackendUtility;
  23 use TYPO3\CMS\Core\Database\DatabaseConnection;
  24 use TYPO3\CMS\Core\Imaging\Icon;
  25 use TYPO3\CMS\Core\Imaging\IconFactory;
  26 use TYPO3\CMS\Core\Messaging\FlashMessage;
  27 use TYPO3\CMS\Core\Messaging\FlashMessageService;
  28 use TYPO3\CMS\Core\Type\Bitmask\Permission;
  29 use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;
  30 use TYPO3\CMS\Core\Utility\GeneralUtility;
  31 use TYPO3\CMS\Frontend\Page\PageRepository;
  32
  33 /**
  34  * Class for rendering of Web>List module
  35  */
  36 class DatabaseRecordList extends AbstractDatabaseRecordList
  37 {
  38     // *********
  39     // External:
  40     // *********
  41
  42     /**
  43      * Used to indicate which tables (values in the array) that can have a
  44      * create-new-record link. If the array is empty, all tables are allowed.
  45      *
  46      * @var string[]
  47      */
  48     public $allowedNewTables = array();
  49
  50     /**
  51      * Used to indicate which tables (values in the array) that cannot have a
  52      * create-new-record link. If the array is empty, all tables are allowed.
  53      *
  54      * @var string[]
  55      */
  56     public $deniedNewTables = array();
  57
  58     /**
  59      * If TRUE, the control panel will contain links to the create-new wizards for
  60      * pages and tt_content elements (normally, the link goes to just creatinga new
  61      * element without the wizards!).
  62      *
  63      * @var bool
  64      */
  65     public $newWizards = false;
  66
  67     /**
  68      * If TRUE, will disable the rendering of clipboard + control panels.
  69      *
  70      * @var bool
  71      */
  72     public $dontShowClipControlPanels = false;
  73
  74     /**
  75      * If TRUE, will show the clipboard in the field list.
  76      *
  77      * @var bool
  78      */
  79     public $showClipboard = false;
  80
  81     /**
  82      * If TRUE, will DISABLE all control panels in lists. (Takes precedence)
  83      *
  84      * @var bool
  85      */
  86     public $noControlPanels = false;
  87
  88     /**
  89      * If TRUE, clickmenus will be rendered
  90      *
  91      * @var bool
  92      */
  93     public $clickMenuEnabled = true;
  94
  95     /**
  96      * Count of record rows in view
  97      *
  98      * @var int
  99      */
 100     public $totalRowCount;
 101
 102     /**
 103      * Space icon used for alignment
 104      *
 105      * @var string
 106      */
 107     public $spaceIcon;
 108
 109     /**
 110      * Disable single table view
 111      *
 112      * @var bool
 113      */
 114     public $disableSingleTableView = false;
 115
 116     // *********
 117     // Internal:
 118     // *********
 119
 120     /**
 121      * Set to the page record (see writeTop())
 122      *
 123      * @var string[]
 124      */
 125     public $pageRow = array();
 126
 127     /**
 128      * Used to accumulate CSV lines for CSV export.
 129      *
 130      * @var string[]
 131      */
 132     protected $csvLines = array();
 133
 134     /**
 135      * If set, the listing is returned as CSV instead.
 136      *
 137      * @var bool
 138      */
 139     public $csvOutput = false;
 140
 141     /**
 142      * Clipboard object
 143      *
 144      * @var \TYPO3\CMS\Backend\Clipboard\Clipboard
 145      */
 146     public $clipObj;
 147
 148     /**
 149      * Tracking names of elements (for clipboard use)
 150      *
 151      * @var string[]
 152      */
 153     public $CBnames = array();
 154
 155     /**
 156      * [$tablename][$uid] = number of references to this record
 157      *
 158      * @var int[][]
 159      */
 160     protected $referenceCount = array();
 161
 162     /**
 163      * Translations of the current record
 164      *
 165      * @var string[]
 166      */
 167     public $translations;
 168
 169     /**
 170      * select fields for the query which fetches the translations of the current
 171      * record
 172      *
 173      * @var string
 174      */
 175     public $selFieldList;
 176
 177     /**
 178      * @var mixed[]
 179      */
 180     public $pageinfo;
 181
 182     /**
 183      * Injected by RecordList
 184      *
 185      * @var string[]
 186      */
 187     public $MOD_MENU;
 188
 189     /**
 190      * If defined the records are editable
 191      *
 192      * @var bool
 193      */
 194     protected $editable = true;
 195
 196     /**
 197      * @var IconFactory
 198      */
 199     protected $iconFactory;
 200
 201     /**
 202      * Constructor
 203      */
 204     public function __construct()
 205     {
 206         parent::__construct();
 207         $this->iconFactory = GeneralUtility::makeInstance(IconFactory::class);
 208     }
 209
 210     /**
 211      * Create the panel of buttons for submitting the form or otherwise perform
 212      * operations.
 213      *
 214      * @return string[] All available buttons as an assoc. array
 215      */
 216     public function getButtons()
 217     {
 218         $module = $this->getModule();
 219         $backendUser = $this->getBackendUserAuthentication();
 220         $lang = $this->getLanguageService();
 221         $buttons = array(
 222             'csh' => '',
 223             'view' => '',
 224             'edit' => '',
 225             'hide_unhide' => '',
 226             'move' => '',
 227             'new_record' => '',
 228             'paste' => '',
 229             'level_up' => '',
 230             'cache' => '',
 231             'reload' => '',
 232             'shortcut' => '',
 233             'back' => '',
 234             'csv' => '',
 235             'export' => ''
 236         );
 237         // Get users permissions for this page record:
 238         $localCalcPerms = $backendUser->calcPerms($this->pageRow);
 239         // CSH
 240         if ((string)$this->id === '') {
 241             $buttons['csh'] = BackendUtility::cshItem('xMOD_csh_corebe', 'list_module_noId');
 242         } elseif (!$this->id) {
 243             $buttons['csh'] = BackendUtility::cshItem('xMOD_csh_corebe', 'list_module_root');
 244         } else {
 245             $buttons['csh'] = BackendUtility::cshItem('xMOD_csh_corebe', 'list_module');
 246         }
 247         if (isset($this->id)) {
 248             // View Exclude doktypes 254,255 Configuration:
 249             // mod.web_list.noViewWithDokTypes = 254,255
 250             if (isset($module->modTSconfig['properties']['noViewWithDokTypes'])) {
 251                 $noViewDokTypes = GeneralUtility::trimExplode(',', $module->modTSconfig['properties']['noViewWithDokTypes'], true);
 252             } else {
 253                 //default exclusion: doktype 254 (folder), 255 (recycler)
 254                 $noViewDokTypes = array(
 255                     PageRepository::DOKTYPE_SYSFOLDER,
 256                     PageRepository::DOKTYPE_RECYCLER
 257                 );
 258             }
 259             if (!in_array($this->pageRow['doktype'], $noViewDokTypes)) {
 260                 $onClick = htmlspecialchars(BackendUtility::viewOnClick($this->id, '', BackendUtility::BEgetRootLine($this->id)));
 261                 $buttons['view'] = '<a href="#" onclick="' . $onClick . '" title="'
 262                     . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.showPage', true) . '">'
 263                     . $this->iconFactory->getIcon('actions-document-view', Icon::SIZE_SMALL)->render() . '</a>';
 264             }
 265             // New record on pages that are not locked by editlock
 266             if (!$module->modTSconfig['properties']['noCreateRecordsLink'] && $this->editLockPermissions()) {
 267                 $onClick = htmlspecialchars('return jumpExt(' . GeneralUtility::quoteJSvalue(BackendUtility::getModuleUrl('db_new', ['id' => $this->id])) . ');');
 268                 $buttons['new_record'] = '<a href="#" onclick="' . $onClick . '" title="'
 269                     . $lang->getLL('newRecordGeneral', true) . '">'
 270                     . $this->iconFactory->getIcon('actions-add', Icon::SIZE_SMALL)->render() . '</a>';
 271             }
 272             // If edit permissions are set, see
 273             // \TYPO3\CMS\Core\Authentication\BackendUserAuthentication
 274             if ($localCalcPerms & Permission::PAGE_EDIT && !empty($this->id) && $this->editLockPermissions() && $this->getBackendUserAuthentication()->checkLanguageAccess(0)) {
 275                 // Edit
 276                 $params = '&edit[pages][' . $this->pageRow['uid'] . ']=edit';
 277                 $onClick = htmlspecialchars(BackendUtility::editOnClick($params, '', -1));
 278                 $buttons['edit'] = '<a href="#" onclick="' . $onClick . '" title="' . $lang->getLL('editPage', true) . '">'
 279                     . $this->iconFactory->getIcon('actions-page-open', Icon::SIZE_SMALL)->render()
 280                     . '</a>';
 281             }
 282             // Paste
 283             if (($localCalcPerms & Permission::PAGE_NEW || $localCalcPerms & Permission::CONTENT_EDIT) && $this->editLockPermissions()) {
 284                 $elFromTable = $this->clipObj->elFromTable('');
 285                 if (!empty($elFromTable)) {
 286                     $onClick = htmlspecialchars(('return ' . $this->clipObj->confirmMsg('pages', $this->pageRow, 'into', $elFromTable)));
 287                     $buttons['paste'] = '<a href="' . htmlspecialchars($this->clipObj->pasteUrl('', $this->id))
 288                         . '" onclick="' . $onClick . '" title="' . $lang->getLL('clip_paste', true) . '">'
 289                         . $this->iconFactory->getIcon('actions-document-paste-after', Icon::SIZE_SMALL)->render() . '</a>';
 290                 }
 291             }
 292             // Cache
 293             $buttons['cache'] = '<a href="' . htmlspecialchars(($this->listURL() . '&clear_cache=1')) . '" title="'
 294                 . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.clear_cache', true) . '">'
 295                 . $this->iconFactory->getIcon('actions-system-cache-clear', Icon::SIZE_SMALL)->render() . '</a>';
 296             if ($this->table && (!isset($module->modTSconfig['properties']['noExportRecordsLinks'])
 297                 || (isset($module->modTSconfig['properties']['noExportRecordsLinks'])
 298                     && !$module->modTSconfig['properties']['noExportRecordsLinks']))
 299             ) {
 300                 // CSV
 301                 $buttons['csv'] = '<a href="' . htmlspecialchars(($this->listURL() . '&csv=1')) . '" title="'
 302                     . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.csv', true) . '">'
 303                     . $this->iconFactory->getIcon('actions-document-export-csv', Icon::SIZE_SMALL)->render() . '</a>';
 304                 // Export
 305                 if (ExtensionManagementUtility::isLoaded('impexp')) {
 306                     $url = BackendUtility::getModuleUrl('xMOD_tximpexp', array('tx_impexp[action]' => 'export'));
 307                     $buttons['export'] = '<a href="' . htmlspecialchars($url . '&tx_impexp[list][]='
 308                             . rawurlencode($this->table . ':' . $this->id)) . '" title="'
 309                         . $lang->sL('LLL:EXT:lang/locallang_core.xlf:rm.export', true) . '">'
 310                         . $this->iconFactory->getIcon('actions-document-export-t3d', Icon::SIZE_SMALL)->render() . '</a>';
 311                 }
 312             }
 313             // Reload
 314             $buttons['reload'] = '<a href="' . htmlspecialchars($this->listURL()) . '" title="'
 315                 . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.reload', true) . '">'
 316                 . $this->iconFactory->getIcon('actions-refresh', Icon::SIZE_SMALL)->render() . '</a>';
 317             // Shortcut
 318             if ($backendUser->mayMakeShortcut()) {
 319                 $buttons['shortcut'] = $this->getDocumentTemplate()->makeShortcutIcon(
 320                     'id, M, imagemode, pointer, table, search_field, search_levels, showLimit, sortField, sortRev',
 321                     implode(',', array_keys($this->MOD_MENU)),
 322                     'web_list'
 323                 );
 324             }
 325             // Back
 326             if ($this->returnUrl) {
 327                 $href = htmlspecialchars(GeneralUtility::linkThisUrl($this->returnUrl, array('id' => $this->id)));
 328                 $buttons['back'] = '<a href="' . $href . '" class="typo3-goBack" title="'
 329                     . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.goBack', true) . '">'
 330                     . $this->iconFactory->getIcon('actions-view-go-back', Icon::SIZE_SMALL)->render() . '</a>';
 331             }
 332         }
 333         return $buttons;
 334     }
 335
 336     /**
 337      * Create the panel of buttons for submitting the form or otherwise perform
 338      * operations.
 339      *
 340      * @param ModuleTemplate $moduleTemplate
 341      */
 342     public function getDocHeaderButtons(ModuleTemplate $moduleTemplate)
 343     {
 344         $buttonBar = $moduleTemplate->getDocHeaderComponent()->getButtonBar();
 345         $module = $this->getModule();
 346         $backendUser = $this->getBackendUserAuthentication();
 347         $lang = $this->getLanguageService();
 348         // Get users permissions for this page record:
 349         $localCalcPerms = $backendUser->calcPerms($this->pageRow);
 350         // CSH
 351         if ((string)$this->id === '') {
 352             $fieldName = 'list_module_noId';
 353         } elseif (!$this->id) {
 354             $fieldName = 'list_module_root';
 355         } else {
 356             $fieldName = 'list_module';
 357         }
 358         $cshButton = $buttonBar->makeHelpButton()
 359             ->setModuleName('xMOD_csh_corebe')
 360             ->setFieldName($fieldName);
 361         $buttonBar->addButton($cshButton);
 362         if (isset($this->id)) {
 363             // View Exclude doktypes 254,255 Configuration:
 364             // mod.web_list.noViewWithDokTypes = 254,255
 365             if (isset($module->modTSconfig['properties']['noViewWithDokTypes'])) {
 366                 $noViewDokTypes = GeneralUtility::trimExplode(',', $module->modTSconfig['properties']['noViewWithDokTypes'], true);
 367             } else {
 368                 //default exclusion: doktype 254 (folder), 255 (recycler)
 369                 $noViewDokTypes = array(
 370                     PageRepository::DOKTYPE_SYSFOLDER,
 371                     PageRepository::DOKTYPE_RECYCLER
 372                 );
 373             }
 374             // New record on pages that are not locked by editlock
 375             if (!$module->modTSconfig['properties']['noCreateRecordsLink'] && $this->editLockPermissions()) {
 376                 $onClick = 'return jumpExt(' . GeneralUtility::quoteJSvalue(BackendUtility::getModuleUrl('db_new', ['id' => $this->id])) . ');';
 377                 $newRecordButton = $buttonBar->makeLinkButton()
 378                     ->setHref('#')
 379                     ->setOnClick($onClick)
 380                     ->setTitle($lang->getLL('newRecordGeneral'))
 381                     ->setIcon($this->iconFactory->getIcon('actions-document-new', Icon::SIZE_SMALL));
 382                 $buttonBar->addButton($newRecordButton, ButtonBar::BUTTON_POSITION_LEFT, 10);
 383             }
 384             if (!in_array($this->pageRow['doktype'], $noViewDokTypes)) {
 385                 $onClick = BackendUtility::viewOnClick($this->id, '', BackendUtility::BEgetRootLine($this->id));
 386                 $viewButton = $buttonBar->makeLinkButton()
 387                     ->setHref('#')
 388                     ->setOnClick($onClick)
 389                     ->setTitle($lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.showPage'))
 390                     ->setIcon($this->iconFactory->getIcon('actions-document-view', Icon::SIZE_SMALL));
 391                 $buttonBar->addButton($viewButton, ButtonBar::BUTTON_POSITION_LEFT, 20);
 392             }
 393             // If edit permissions are set, see
 394             // \TYPO3\CMS\Core\Authentication\BackendUserAuthentication
 395             if ($localCalcPerms & Permission::PAGE_EDIT && !empty($this->id) && $this->editLockPermissions()) {
 396                 // Edit
 397                 $params = '&edit[pages][' . $this->pageRow['uid'] . ']=edit';
 398                 $onClick = BackendUtility::editOnClick($params, '', -1);
 399                 $editButton = $buttonBar->makeLinkButton()
 400                     ->setHref('#')
 401                     ->setOnClick($onClick)
 402                     ->setTitle($lang->getLL('editPage'))
 403                     ->setIcon($this->iconFactory->getIcon('actions-page-open', Icon::SIZE_SMALL));
 404                 $buttonBar->addButton($editButton, ButtonBar::BUTTON_POSITION_LEFT, 20);
 405             }
 406             // Paste
 407             if (($localCalcPerms & Permission::PAGE_NEW || $localCalcPerms & Permission::CONTENT_EDIT) && $this->editLockPermissions()) {
 408                 $elFromTable = $this->clipObj->elFromTable('');
 409                 if (!empty($elFromTable)) {
 410                     $onClick = 'return ' . $this->clipObj->confirmMsg('pages', $this->pageRow, 'into', $elFromTable);
 411                     $pasteButton = $buttonBar->makeLinkButton()
 412                         ->setHref($this->clipObj->pasteUrl('', $this->id))
 413                         ->setOnClick($onClick)
 414                         ->setTitle($lang->getLL('clip_paste'))
 415                         ->setIcon($this->iconFactory->getIcon('actions-document-paste-after', Icon::SIZE_SMALL));
 416                     $buttonBar->addButton($pasteButton, ButtonBar::BUTTON_POSITION_LEFT, 40);
 417                 }
 418             }
 419             // Cache
 420             $clearCacheButton = $buttonBar->makeLinkButton()
 421                 ->setHref($this->listURL() . '&clear_cache=1')
 422                 ->setTitle($lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.clear_cache'))
 423                 ->setIcon($this->iconFactory->getIcon('actions-system-cache-clear', Icon::SIZE_SMALL));
 424             $buttonBar->addButton($clearCacheButton, ButtonBar::BUTTON_POSITION_RIGHT);
 425             if ($this->table && (!isset($module->modTSconfig['properties']['noExportRecordsLinks'])
 426                 || (isset($module->modTSconfig['properties']['noExportRecordsLinks'])
 427                     && !$module->modTSconfig['properties']['noExportRecordsLinks']))
 428             ) {
 429                 // CSV
 430                 $csvButton = $buttonBar->makeLinkButton()
 431                     ->setHref($this->listURL() . '&csv=1')
 432                     ->setTitle($lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.csv'))
 433                     ->setIcon($this->iconFactory->getIcon('actions-document-export-csv', Icon::SIZE_SMALL));
 434                 $buttonBar->addButton($csvButton, ButtonBar::BUTTON_POSITION_LEFT, 40);
 435                 // Export
 436                 if (ExtensionManagementUtility::isLoaded('impexp')) {
 437                     $url = BackendUtility::getModuleUrl('xMOD_tximpexp', array('tx_impexp[action]' => 'export'));
 438                     $exportButton = $buttonBar->makeLinkButton()
 439                         ->setHref($url . '&tx_impexp[list][]=' . rawurlencode($this->table . ':' . $this->id))
 440                         ->setTitle($lang->sL('LLL:EXT:lang/locallang_core.xlf:rm.export'))
 441                         ->setIcon($this->iconFactory->getIcon('actions-document-export-t3d', Icon::SIZE_SMALL));
 442                     $buttonBar->addButton($exportButton, ButtonBar::BUTTON_POSITION_LEFT, 40);
 443                 }
 444             }
 445             // Reload
 446             $reloadButton = $buttonBar->makeLinkButton()
 447                 ->setHref($this->listURL())
 448                 ->setTitle($lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.reload'))
 449                 ->setIcon($this->iconFactory->getIcon('actions-refresh', Icon::SIZE_SMALL));
 450             $buttonBar->addButton($reloadButton, ButtonBar::BUTTON_POSITION_RIGHT);
 451             // Shortcut
 452             if ($backendUser->mayMakeShortcut()) {
 453                 $shortCutButton = $buttonBar->makeShortcutButton()
 454                     ->setModuleName('web_list')
 455                     ->setGetVariables([
 456                         'id',
 457                         'M',
 458                         'imagemode',
 459                         'pointer',
 460                         'table',
 461                         'search_field',
 462                         'search_levels',
 463                         'showLimit',
 464                         'sortField',
 465                         'sortRev'
 466                     ])
 467                     ->setSetVariables(array_keys($this->MOD_MENU));
 468                 $buttonBar->addButton($shortCutButton, ButtonBar::BUTTON_POSITION_RIGHT);
 469             }
 470             // Back
 471             if ($this->returnUrl) {
 472                 $href = htmlspecialchars(GeneralUtility::linkThisUrl($this->returnUrl, array('id' => $this->id)));
 473                 $buttons['back'] = '<a href="' . $href . '" class="typo3-goBack" title="'
 474                     . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.goBack', true) . '">'
 475                     . $this->iconFactory->getIcon('actions-view-go-back', Icon::SIZE_SMALL) . '</a>';
 476             }
 477         }
 478     }
 479
 480     /**
 481      * Creates the listing of records from a single table
 482      *
 483      * @param string $table Table name
 484      * @param int $id Page id
 485      * @param string $rowList List of fields to show in the listing. Pseudo fields will be added including the record header.
 486      * @throws \UnexpectedValueException
 487      * @return string HTML table with the listing for the record.
 488      */
 489     public function getTable($table, $id, $rowList = '')
 490     {
 491         $rowListArray = GeneralUtility::trimExplode(',', $rowList, true);
 492         // if no columns have been specified, show description (if configured)
 493         if (!empty($GLOBALS['TCA'][$table]['ctrl']['descriptionColumn']) && empty($rowListArray)) {
 494             array_push($rowListArray, $GLOBALS['TCA'][$table]['ctrl']['descriptionColumn']);
 495         }
 496         $backendUser = $this->getBackendUserAuthentication();
 497         $lang = $this->getLanguageService();
 498         $db = $this->getDatabaseConnection();
 499         // Init
 500         $addWhere = '';
 501         $titleCol = $GLOBALS['TCA'][$table]['ctrl']['label'];
 502         $thumbsCol = $GLOBALS['TCA'][$table]['ctrl']['thumbnail'];
 503         $l10nEnabled = $GLOBALS['TCA'][$table]['ctrl']['languageField']
 504             && $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']
 505             && !$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerTable'];
 506         $tableCollapsed = (bool)$this->tablesCollapsed[$table];
 507         // prepare space icon
 508         $this->spaceIcon = '<span class="btn btn-default disabled">' . $this->iconFactory->getIcon('empty-empty', Icon::SIZE_SMALL)->render() . '</span>';
 509         // Cleaning rowlist for duplicates and place the $titleCol as the first column always!
 510         $this->fieldArray = array();
 511         // title Column
 512         // Add title column
 513         $this->fieldArray[] = $titleCol;
 514         // Control-Panel
 515         if (!GeneralUtility::inList($rowList, '_CONTROL_')) {
 516             $this->fieldArray[] = '_CONTROL_';
 517         }
 518         // Clipboard
 519         if ($this->showClipboard) {
 520             $this->fieldArray[] = '_CLIPBOARD_';
 521         }
 522         // Ref
 523         if (!$this->dontShowClipControlPanels) {
 524             $this->fieldArray[] = '_REF_';
 525         }
 526         // Path
 527         if ($this->searchLevels) {
 528             $this->fieldArray[] = '_PATH_';
 529         }
 530         // Localization
 531         if ($this->localizationView && $l10nEnabled) {
 532             $this->fieldArray[] = '_LOCALIZATION_';
 533             $this->fieldArray[] = '_LOCALIZATION_b';
 534             $addWhere .= ' AND (
 535                                 ' . $GLOBALS['TCA'][$table]['ctrl']['languageField'] . '<=0
 536                                 OR
 537                                 ' . $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'] . ' = 0
 538                         )';
 539         }
 540         // Cleaning up:
 541         $this->fieldArray = array_unique(array_merge($this->fieldArray, $rowListArray));
 542         if ($this->noControlPanels) {
 543             $tempArray = array_flip($this->fieldArray);
 544             unset($tempArray['_CONTROL_']);
 545             unset($tempArray['_CLIPBOARD_']);
 546             $this->fieldArray = array_keys($tempArray);
 547         }
 548         // Creating the list of fields to include in the SQL query:
 549         $selectFields = $this->fieldArray;
 550         $selectFields[] = 'uid';
 551         $selectFields[] = 'pid';
 552         // adding column for thumbnails
 553         if ($thumbsCol) {
 554             $selectFields[] = $thumbsCol;
 555         }
 556         if ($table == 'pages') {
 557             $selectFields[] = 'module';
 558             $selectFields[] = 'extendToSubpages';
 559             $selectFields[] = 'nav_hide';
 560             $selectFields[] = 'doktype';
 561             $selectFields[] = 'shortcut';
 562             $selectFields[] = 'shortcut_mode';
 563             $selectFields[] = 'mount_pid';
 564         }
 565         if (is_array($GLOBALS['TCA'][$table]['ctrl']['enablecolumns'])) {
 566             $selectFields = array_merge($selectFields, $GLOBALS['TCA'][$table]['ctrl']['enablecolumns']);
 567         }
 568         foreach (array('type', 'typeicon_column', 'editlock') as $field) {
 569             if ($GLOBALS['TCA'][$table]['ctrl'][$field]) {
 570                 $selectFields[] = $GLOBALS['TCA'][$table]['ctrl'][$field];
 571             }
 572         }
 573         if ($GLOBALS['TCA'][$table]['ctrl']['versioningWS']) {
 574             $selectFields[] = 't3ver_id';
 575             $selectFields[] = 't3ver_state';
 576             $selectFields[] = 't3ver_wsid';
 577         }
 578         if ($l10nEnabled) {
 579             $selectFields[] = $GLOBALS['TCA'][$table]['ctrl']['languageField'];
 580             $selectFields[] = $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'];
 581         }
 582         if ($GLOBALS['TCA'][$table]['ctrl']['label_alt']) {
 583             $selectFields = array_merge(
 584                 $selectFields,
 585                 GeneralUtility::trimExplode(',', $GLOBALS['TCA'][$table]['ctrl']['label_alt'], true)
 586             );
 587         }
 588         // Unique list!
 589         $selectFields = array_unique($selectFields);
 590         $fieldListFields = $this->makeFieldList($table, 1);
 591         if (empty($fieldListFields) && $GLOBALS['TYPO3_CONF_VARS']['BE']['debug']) {
 592             $message = sprintf($lang->sL('LLL:EXT:lang/locallang_mod_web_list.xlf:missingTcaColumnsMessage', true), $table, $table);
 593             $messageTitle = $lang->sL('LLL:EXT:lang/locallang_mod_web_list.xlf:missingTcaColumnsMessageTitle', true);
 594             /** @var FlashMessage $flashMessage */
 595             $flashMessage = GeneralUtility::makeInstance(
 596                 FlashMessage::class,
 597                 $message,
 598                 $messageTitle,
 599                 FlashMessage::WARNING,
 600                 true
 601             );
 602             /** @var $flashMessageService FlashMessageService */
 603             $flashMessageService = GeneralUtility::makeInstance(FlashMessageService::class);
 604             /** @var $defaultFlashMessageQueue \TYPO3\CMS\Core\Messaging\FlashMessageQueue */
 605             $defaultFlashMessageQueue = $flashMessageService->getMessageQueueByIdentifier();
 606             $defaultFlashMessageQueue->enqueue($flashMessage);
 607         }
 608         // Making sure that the fields in the field-list ARE in the field-list from TCA!
 609         $selectFields = array_intersect($selectFields, $fieldListFields);
 610         // Implode it into a list of fields for the SQL-statement.
 611         $selFieldList = implode(',', $selectFields);
 612         $this->selFieldList = $selFieldList;
 613         if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['getTable'])) {
 614             foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['getTable'] as $classData) {
 615                 $hookObject = GeneralUtility::getUserObj($classData);
 616                 if (!$hookObject instanceof RecordListGetTableHookInterface) {
 617                     throw new \UnexpectedValueException('$hookObject must implement interface ' . RecordListGetTableHookInterface::class, 1195114460);
 618                 }
 619                 $hookObject->getDBlistQuery($table, $id, $addWhere, $selFieldList, $this);
 620             }
 621         }
 622         // Create the SQL query for selecting the elements in the listing:
 623         // do not do paging when outputting as CSV
 624         if ($this->csvOutput) {
 625             $this->iLimit = 0;
 626         }
 627         if ($this->firstElementNumber > 2 && $this->iLimit > 0) {
 628             // Get the two previous rows for sorting if displaying page > 1
 629             $this->firstElementNumber = $this->firstElementNumber - 2;
 630             $this->iLimit = $this->iLimit + 2;
 631             // (API function from TYPO3\CMS\Recordlist\RecordList\AbstractDatabaseRecordList)
 632             $queryParts = $this->makeQueryArray($table, $id, $addWhere, $selFieldList);
 633             $this->firstElementNumber = $this->firstElementNumber + 2;
 634             $this->iLimit = $this->iLimit - 2;
 635         } else {
 636             // (API function from TYPO3\CMS\Recordlist\RecordList\AbstractDatabaseRecordList)
 637             $queryParts = $this->makeQueryArray($table, $id, $addWhere, $selFieldList);
 638         }
 639
 640         // Finding the total amount of records on the page
 641         // (API function from TYPO3\CMS\Recordlist\RecordList\AbstractDatabaseRecordList)
 642         $this->setTotalItems($queryParts);
 643
 644         // Init:
 645         $dbCount = 0;
 646         $out = '';
 647         $tableHeader = '';
 648         $result = null;
 649         $listOnlyInSingleTableMode = $this->listOnlyInSingleTableMode && !$this->table;
 650         // If the count query returned any number of records, we perform the real query,
 651         // selecting records.
 652         if ($this->totalItems) {
 653             // Fetch records only if not in single table mode
 654             if ($listOnlyInSingleTableMode) {
 655                 $dbCount = $this->totalItems;
 656             } else {
 657                 // Set the showLimit to the number of records when outputting as CSV
 658                 if ($this->csvOutput) {
 659                     $this->showLimit = $this->totalItems;
 660                     $this->iLimit = $this->totalItems;
 661                 }
 662                 $result = $db->exec_SELECT_queryArray($queryParts);
 663                 $dbCount = $db->sql_num_rows($result);
 664             }
 665         }
 666         // If any records was selected, render the list:
 667         if ($dbCount) {
 668             $tableTitle = $lang->sL($GLOBALS['TCA'][$table]['ctrl']['title'], true);
 669             if ($tableTitle === '') {
 670                 $tableTitle = $table;
 671             }
 672             // Header line is drawn
 673             $theData = array();
 674             if ($this->disableSingleTableView) {
 675                 $theData[$titleCol] = '<span class="c-table">' . BackendUtility::wrapInHelp($table, '', $tableTitle)
 676                     . '</span> (<span class="t3js-table-total-items">' . $this->totalItems . '</span>)';
 677             } else {
 678                 $icon = $this->table
 679                     ? '<span title="' . $lang->getLL('contractView', true) . '">' . $this->iconFactory->getIcon('actions-view-table-collapse', Icon::SIZE_SMALL)->render() . '</span>'
 680                     : '<span title="' . $lang->getLL('expandView', true) . '">' . $this->iconFactory->getIcon('actions-view-table-expand', Icon::SIZE_SMALL)->render() . '</span>';
 681                 $theData[$titleCol] = $this->linkWrapTable($table, $tableTitle . ' (<span class="t3js-table-total-items">' . $this->totalItems . '</span>) ' . $icon);
 682             }
 683             if ($listOnlyInSingleTableMode) {
 684                 $tableHeader .= BackendUtility::wrapInHelp($table, '', $theData[$titleCol]);
 685             } else {
 686                 // Render collapse button if in multi table mode
 687                 $collapseIcon = '';
 688                 if (!$this->table) {
 689                     $href = htmlspecialchars(($this->listURL() . '&collapse[' . $table . ']=' . ($tableCollapsed ? '0' : '1')));
 690                     $title = $tableCollapsed
 691                         ? $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.expandTable', true)
 692                         : $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.collapseTable', true);
 693                     $icon = '<span class="collapseIcon">' . $this->iconFactory->getIcon(($tableCollapsed ? 'actions-view-list-expand' : 'actions-view-list-collapse'), Icon::SIZE_SMALL)->render() . '</span>';
 694                     $collapseIcon = '<a href="' . $href . '" title="' . $title . '" class="pull-right t3js-toggle-recordlist" data-table="' . htmlspecialchars($table) . '" data-toggle="collapse" data-target="#recordlist-' . htmlspecialchars($table) . '">' . $icon . '</a>';
 695                 }
 696                 $tableHeader .= $theData[$titleCol] . $collapseIcon;
 697             }
 698             // Render table rows only if in multi table view or if in single table view
 699             $rowOutput = '';
 700             if (!$listOnlyInSingleTableMode || $this->table) {
 701                 // Fixing an order table for sortby tables
 702                 $this->currentTable = array();
 703                 $currentIdList = array();
 704                 $doSort = $GLOBALS['TCA'][$table]['ctrl']['sortby'] && !$this->sortField;
 705                 $prevUid = 0;
 706                 $prevPrevUid = 0;
 707                 // Get first two rows and initialize prevPrevUid and prevUid if on page > 1
 708                 if ($this->firstElementNumber > 2 && $this->iLimit > 0) {
 709                     $row = $db->sql_fetch_assoc($result);
 710                     $prevPrevUid = -((int)$row['uid']);
 711                     $row = $db->sql_fetch_assoc($result);
 712                     $prevUid = $row['uid'];
 713                 }
 714                 $accRows = array();
 715                 // Accumulate rows here
 716                 while ($row = $db->sql_fetch_assoc($result)) {
 717                     if (!$this->isRowListingConditionFulfilled($table, $row)) {
 718                         continue;
 719                     }
 720                     // In offline workspace, look for alternative record:
 721                     BackendUtility::workspaceOL($table, $row, $backendUser->workspace, true);
 722                     if (is_array($row)) {
 723                         $accRows[] = $row;
 724                         $currentIdList[] = $row['uid'];
 725                         if ($doSort) {
 726                             if ($prevUid) {
 727                                 $this->currentTable['prev'][$row['uid']] = $prevPrevUid;
 728                                 $this->currentTable['next'][$prevUid] = '-' . $row['uid'];
 729                                 $this->currentTable['prevUid'][$row['uid']] = $prevUid;
 730                             }
 731                             $prevPrevUid = isset($this->currentTable['prev'][$row['uid']]) ? -$prevUid : $row['pid'];
 732                             $prevUid = $row['uid'];
 733                         }
 734                     }
 735                 }
 736                 $db->sql_free_result($result);
 737                 $this->totalRowCount = count($accRows);
 738                 // CSV initiated
 739                 if ($this->csvOutput) {
 740                     $this->initCSV();
 741                 }
 742                 // Render items:
 743                 $this->CBnames = array();
 744                 $this->duplicateStack = array();
 745                 $this->eCounter = $this->firstElementNumber;
 746                 $cc = 0;
 747                 foreach ($accRows as $row) {
 748                     // Render item row if counter < limit
 749                     if ($cc < $this->iLimit) {
 750                         $cc++;
 751                         $this->translations = false;
 752                         $rowOutput .= $this->renderListRow($table, $row, $cc, $titleCol, $thumbsCol);
 753                         // If localization view is enabled it means that the selected records are
 754                         // either default or All language and here we will not select translations
 755                         // which point to the main record:
 756                         if ($this->localizationView && $l10nEnabled) {
 757                             // For each available translation, render the record:
 758                             if (is_array($this->translations)) {
 759                                 foreach ($this->translations as $lRow) {
 760                                     // $lRow isn't always what we want - if record was moved we've to work with the
 761                                     // placeholder records otherwise the list is messed up a bit
 762                                     if ($row['_MOVE_PLH_uid'] && $row['_MOVE_PLH_pid']) {
 763                                         $where = 't3ver_move_id="' . (int)$lRow['uid'] . '" AND pid="' . $row['_MOVE_PLH_pid']
 764                                             . '" AND t3ver_wsid=' . $row['t3ver_wsid'] . BackendUtility::deleteClause($table);
 765                                         $tmpRow = BackendUtility::getRecordRaw($table, $where, $selFieldList);
 766                                         $lRow = is_array($tmpRow) ? $tmpRow : $lRow;
 767                                     }
 768                                     // In offline workspace, look for alternative record:
 769                                     BackendUtility::workspaceOL($table, $lRow, $backendUser->workspace, true);
 770                                     if (is_array($lRow) && $backendUser->checkLanguageAccess($lRow[$GLOBALS['TCA'][$table]['ctrl']['languageField']])) {
 771                                         $currentIdList[] = $lRow['uid'];
 772                                         $rowOutput .= $this->renderListRow($table, $lRow, $cc, $titleCol, $thumbsCol, 18);
 773                                     }
 774                                 }
 775                             }
 776                         }
 777                     }
 778                     // Counter of total rows incremented:
 779                     $this->eCounter++;
 780                 }
 781                 // Record navigation is added to the beginning and end of the table if in single
 782                 // table mode
 783                 if ($this->table) {
 784                     $rowOutput = $this->renderListNavigation('top') . $rowOutput . $this->renderListNavigation('bottom');
 785                 } else {
 786                     // Show that there are more records than shown
 787                     if ($this->totalItems > $this->itemsLimitPerTable) {
 788                         $countOnFirstPage = $this->totalItems > $this->itemsLimitSingleTable ? $this->itemsLimitSingleTable : $this->totalItems;
 789                         $hasMore = $this->totalItems > $this->itemsLimitSingleTable;
 790                         $colspan = $this->showIcon ? count($this->fieldArray) + 1 : count($this->fieldArray);
 791                         $rowOutput .= '<tr><td colspan="' . $colspan . '">
 792                                                                 <a href="' . htmlspecialchars(($this->listURL() . '&table=' . rawurlencode($table))) . '" class="btn btn-default">'
 793                             . '<span class="t3-icon fa fa-chevron-down"></span> <i>[1 - ' . $countOnFirstPage . ($hasMore ? '+' : '') . ']</i></a>
 794                                                                 </td></tr>';
 795                     }
 796                 }
 797                 // The header row for the table is now created:
 798                 $out .= $this->renderListHeader($table, $currentIdList);
 799             }
 800
 801             $collapseClass = $tableCollapsed && !$this->table ? 'collapse' : 'collapse in';
 802             $dataState = $tableCollapsed && !$this->table ? 'collapsed' : 'expanded';
 803
 804             // The list of records is added after the header:
 805             $out .= $rowOutput;
 806             // ... and it is all wrapped in a table:
 807             $out = '
 808
 809
 810
 811                         <!--
 812                                 DB listing of elements: "' . htmlspecialchars($table) . '"
 813                         -->
 814                                 <div class="panel panel-space panel-default">
 815                                         <div class="panel-heading">
 816                                         ' . $tableHeader . '
 817                                         </div>
 818                                         <div class="table-fit ' . $collapseClass . '" id="recordlist-' . htmlspecialchars($table) . '" data-state="' . $dataState . '">
 819                                                 <table data-table="' . htmlspecialchars($table) . '" class="table table-striped table-hover' . ($listOnlyInSingleTableMode ? ' typo3-dblist-overview' : '') . '">
 820                                                         ' . $out . '
 821                                                 </table>
 822                                         </div>
 823                                 </div>
 824                         ';
 825             // Output csv if...
 826             // This ends the page with exit.
 827             if ($this->csvOutput) {
 828                 $this->outputCSV($table);
 829             }
 830         }
 831         // Return content:
 832         return $out;
 833     }
 834
 835     /**
 836      * Check if all row listing conditions are fulfilled.
 837      *
 838      * This function serves as a dummy method to be overriden in extending classes.
 839      *
 840      * @param string $table Table name
 841      * @param string[] $row Record
 842      * @return bool True, if all conditions are fulfilled.
 843      */
 844     protected function isRowListingConditionFulfilled($table, $row)
 845     {
 846         return true;
 847     }
 848
 849     /**
 850      * Rendering a single row for the list
 851      *
 852      * @param string $table Table name
 853      * @param mixed[] $row Current record
 854      * @param int $cc Counter, counting for each time an element is rendered (used for alternating colors)
 855      * @param string $titleCol Table field (column) where header value is found
 856      * @param string $thumbsCol Table field (column) where (possible) thumbnails can be found
 857      * @param int $indent Indent from left.
 858      * @return string Table row for the element
 859      * @access private
 860      * @see getTable()
 861      */
 862     public function renderListRow($table, $row, $cc, $titleCol, $thumbsCol, $indent = 0)
 863     {
 864         if (!is_array($row)) {
 865             return '';
 866         }
 867         $rowOutput = '';
 868         $id_orig = null;
 869         // If in search mode, make sure the preview will show the correct page
 870         if ((string)$this->searchString !== '') {
 871             $id_orig = $this->id;
 872             $this->id = $row['pid'];
 873         }
 874         // Add special classes for first and last row
 875         $rowSpecial = '';
 876         if ($cc == 1 && $indent == 0) {
 877             $rowSpecial .= ' firstcol';
 878         }
 879         if ($cc == $this->totalRowCount || $cc == $this->iLimit) {
 880             $rowSpecial .= ' lastcol';
 881         }
 882
 883         $row_bgColor = ' class="' . $rowSpecial . '"';
 884
 885         // Overriding with versions background color if any:
 886         $row_bgColor = $row['_CSSCLASS'] ? ' class="' . $row['_CSSCLASS'] . '"' : $row_bgColor;
 887         // Incr. counter.
 888         $this->counter++;
 889         // The icon with link
 890         $toolTip = BackendUtility::getRecordToolTip($row, $table);
 891         $additionalStyle = $indent ? ' style="margin-left: ' . $indent . 'px;"' : '';
 892         $iconImg = '<span ' . $toolTip . ' ' . $additionalStyle . '>'
 893             . $this->iconFactory->getIconForRecord($table, $row, Icon::SIZE_SMALL)->render()
 894             . '</span>';
 895         $theIcon = $this->clickMenuEnabled ? BackendUtility::wrapClickMenuOnIcon($iconImg, $table, $row['uid']) : $iconImg;
 896         // Preparing and getting the data-array
 897         $theData = array();
 898         $localizationMarkerClass = '';
 899         foreach ($this->fieldArray as $fCol) {
 900             if ($fCol == $titleCol) {
 901                 $recTitle = BackendUtility::getRecordTitle($table, $row, false, true);
 902                 $warning = '';
 903                 // If the record is edit-locked by another user, we will show a little warning sign:
 904                 $lockInfo = BackendUtility::isRecordLocked($table, $row['uid']);
 905                 if ($lockInfo) {
 906                     $warning = '<a href="#" onclick="alert('
 907                         . GeneralUtility::quoteJSvalue($lockInfo['msg']) . '); return false;" title="'
 908                         . htmlspecialchars($lockInfo['msg']) . '">'
 909                         . $this->iconFactory->getIcon('status-warning-in-use', Icon::SIZE_SMALL)->render() . '</a>';
 910                 }
 911                 $theData[$fCol] = $theData['__label'] = $warning . $this->linkWrapItems($table, $row['uid'], $recTitle, $row);
 912                 // Render thumbnails, if:
 913                 // - a thumbnail column exists
 914                 // - there is content in it
 915                 // - the thumbnail column is visible for the current type
 916                 $type = 0;
 917                 if (isset($GLOBALS['TCA'][$table]['ctrl']['type'])) {
 918                     $typeColumn = $GLOBALS['TCA'][$table]['ctrl']['type'];
 919                     $type = $row[$typeColumn];
 920                 }
 921                 // If current type doesn't exist, set it to 0 (or to 1 for historical reasons,
 922                 // if 0 doesn't exist)
 923                 if (!isset($GLOBALS['TCA'][$table]['types'][$type])) {
 924                     $type = isset($GLOBALS['TCA'][$table]['types'][0]) ? 0 : 1;
 925                 }
 926                 $visibleColumns = $GLOBALS['TCA'][$table]['types'][$type]['showitem'];
 927
 928                 if ($this->thumbs &&
 929                     trim($row[$thumbsCol]) &&
 930                     preg_match('/(^|(.*(;|,)?))' . $thumbsCol . '(((;|,).*)|$)/', $visibleColumns) === 1
 931                 ) {
 932                     $theData[$fCol] .= '<br />' . $this->thumbCode($row, $table, $thumbsCol);
 933                 }
 934                 if (isset($GLOBALS['TCA'][$table]['ctrl']['languageField'])
 935                     && $row[$GLOBALS['TCA'][$table]['ctrl']['languageField']] != 0
 936                     && $row[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']] != 0
 937                 ) {
 938                     // It's a translated record with a language parent
 939                     $localizationMarkerClass = ' localization';
 940                 }
 941             } elseif ($fCol == 'pid') {
 942                 $theData[$fCol] = $row[$fCol];
 943             } elseif ($fCol == '_PATH_') {
 944                 $theData[$fCol] = $this->recPath($row['pid']);
 945             } elseif ($fCol == '_REF_') {
 946                 $theData[$fCol] = $this->createReferenceHtml($table, $row['uid']);
 947             } elseif ($fCol == '_CONTROL_') {
 948                 $theData[$fCol] = $this->makeControl($table, $row);
 949             } elseif ($fCol == '_CLIPBOARD_') {
 950                 $theData[$fCol] = $this->makeClip($table, $row);
 951             } elseif ($fCol == '_LOCALIZATION_') {
 952                 list($lC1, $lC2) = $this->makeLocalizationPanel($table, $row);
 953                 $theData[$fCol] = $lC1;
 954                 $theData[$fCol . 'b'] = '<div class="btn-group">' . $lC2 . '</div>';
 955             } elseif ($fCol == '_LOCALIZATION_b') {
 956                 // deliberately empty
 957             } else {
 958                 $pageId = $table === 'pages' ? $row['uid'] : $row['pid'];
 959                 $tmpProc = BackendUtility::getProcessedValueExtra($table, $fCol, $row[$fCol], 100, $row['uid'], true, $pageId);
 960                 $theData[$fCol] = $this->linkUrlMail(htmlspecialchars($tmpProc), $row[$fCol]);
 961                 if ($this->csvOutput) {
 962                     $row[$fCol] = BackendUtility::getProcessedValueExtra($table, $fCol, $row[$fCol], 0, $row['uid']);
 963                 }
 964             }
 965         }
 966         // Reset the ID if it was overwritten
 967         if ((string)$this->searchString !== '') {
 968             $this->id = $id_orig;
 969         }
 970         // Add row to CSV list:
 971         if ($this->csvOutput) {
 972             $this->addToCSV($row);
 973         }
 974         // Add classes to table cells
 975         $this->addElement_tdCssClass[$titleCol] = 'col-title' . $localizationMarkerClass;
 976         $this->addElement_tdCssClass['_CONTROL_'] = 'col-control';
 977         if ($this->getModule()->MOD_SETTINGS['clipBoard']) {
 978             $this->addElement_tdCssClass['_CLIPBOARD_'] = 'col-clipboard';
 979         }
 980         $this->addElement_tdCssClass['_PATH_'] = 'col-path';
 981         $this->addElement_tdCssClass['_LOCALIZATION_'] = 'col-localizationa';
 982         $this->addElement_tdCssClass['_LOCALIZATION_b'] = 'col-localizationb';
 983         // Create element in table cells:
 984         $theData['uid'] = $row['uid'];
 985         if (isset($GLOBALS['TCA'][$table]['ctrl']['languageField'])
 986             && isset($GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'])
 987             && !isset($GLOBALS['TCA'][$table]['ctrl']['transOrigPointerTable'])
 988         ) {
 989             $theData['parent'] = $row[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']];
 990         }
 991         $rowOutput .= $this->addElement(1, $theIcon, $theData, $row_bgColor);
 992         // Finally, return table row element:
 993         return $rowOutput;
 994     }
 995
 996     /**
 997      * Gets the number of records referencing the record with the UID $uid in
 998      * the table $tableName.
 999      *
1000      * @param string $tableName
1001      * @param int $uid
1002      * @return int The number of references to record $uid in table
1003      */
1004     protected function getReferenceCount($tableName, $uid)
1005     {
1006         $db = $this->getDatabaseConnection();
1007         if (!isset($this->referenceCount[$tableName][$uid])) {
1008             $where = 'ref_table = ' . $db->fullQuoteStr($tableName, 'sys_refindex')
1009                 . ' AND ref_uid = ' . $uid . ' AND deleted = 0';
1010             $numberOfReferences = $db->exec_SELECTcountRows('*', 'sys_refindex', $where);
1011             $this->referenceCount[$tableName][$uid] = $numberOfReferences;
1012         }
1013         return $this->referenceCount[$tableName][$uid];
1014     }
1015
1016     /**
1017      * Rendering the header row for a table
1018      *
1019      * @param string $table Table name
1020      * @param int[] $currentIdList Array of the currently displayed uids of the table
1021      * @throws \UnexpectedValueException
1022      * @return string Header table row
1023      * @access private
1024      * @see getTable()
1025      */
1026     public function renderListHeader($table, $currentIdList)
1027     {
1028         $lang = $this->getLanguageService();
1029         // Init:
1030         $theData = array();
1031         $icon = '';
1032         // Traverse the fields:
1033         foreach ($this->fieldArray as $fCol) {
1034             // Calculate users permissions to edit records in the table:
1035             $permsEdit = $this->calcPerms & ($table == 'pages' ? 2 : 16) && $this->overlayEditLockPermissions($table);
1036             switch ((string)$fCol) {
1037                 case '_PATH_':
1038                     // Path
1039                     $theData[$fCol] = '<i>[' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels._PATH_', true) . ']</i>';
1040                     break;
1041                 case '_REF_':
1042                     // References
1043                     $theData[$fCol] = '<i>[' . $lang->sL('LLL:EXT:lang/locallang_mod_file_list.xlf:c__REF_', true) . ']</i>';
1044                     break;
1045                 case '_LOCALIZATION_':
1046                     // Path
1047                     $theData[$fCol] = '<i>[' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels._LOCALIZATION_', true) . ']</i>';
1048                     break;
1049                 case '_LOCALIZATION_b':
1050                     // Path
1051                     $theData[$fCol] = $lang->getLL('Localize', true);
1052                     break;
1053                 case '_CLIPBOARD_':
1054                     if (!$this->getModule()->MOD_SETTINGS['clipBoard']) {
1055                         break;
1056                     }
1057                     // Clipboard:
1058                     $cells = array();
1059                     // If there are elements on the clipboard for this table, and the parent page is not locked by editlock
1060                     // then display the "paste into" icon:
1061                     $elFromTable = $this->clipObj->elFromTable($table);
1062                     if (!empty($elFromTable) && $this->overlayEditLockPermissions($table)) {
1063                         $href = htmlspecialchars($this->clipObj->pasteUrl($table, $this->id));
1064                         $onClick = htmlspecialchars('return ' . $this->clipObj->confirmMsg('pages', $this->pageRow, 'into', $elFromTable));
1065                         $cells['pasteAfter'] = '<a class="btn btn-default" href="' . $href . '" onclick="' . $onClick
1066                             . '" title="' . $lang->getLL('clip_paste', true) . '">'
1067                             . $this->iconFactory->getIcon('actions-document-paste-after', Icon::SIZE_SMALL)->render() . '</a>';
1068                     }
1069                     // If the numeric clipboard pads are enabled, display the control icons for that:
1070                     if ($this->clipObj->current != 'normal') {
1071                         // The "select" link:
1072                         $spriteIcon = '<span title="' . $lang->getLL('clip_selectMarked', true) . '">'
1073                             . $this->iconFactory->getIcon('actions-edit-copy', Icon::SIZE_SMALL)->render()
1074                             . '</span>';
1075                         $cells['copyMarked'] = $this->linkClipboardHeaderIcon($spriteIcon, $table, 'setCB');
1076                         // The "edit marked" link:
1077                         $editIdList = implode(',', $currentIdList);
1078                         $editIdList = '\'+editList(' . GeneralUtility::quoteJSvalue($table) . ',' . GeneralUtility::quoteJSvalue($editIdList) . ')+\'';
1079                         $params = 'edit[' . $table . '][' . $editIdList . ']=edit';
1080                         $onClick = BackendUtility::editOnClick('', '', -1);
1081                         $onClickArray = explode('?', $onClick, 2);
1082                         $lastElement = array_pop($onClickArray);
1083                         array_push($onClickArray, $params . '&' . $lastElement);
1084                         $onClick = implode('?', $onClickArray);
1085                         $cells['edit'] = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick) . '" title="'
1086                             . $lang->getLL('clip_editMarked', true) . '">'
1087                             . $this->iconFactory->getIcon('actions-document-open', Icon::SIZE_SMALL)->render() . '</a>';
1088                         // The "Delete marked" link:
1089                         $cells['delete'] = $this->linkClipboardHeaderIcon(
1090                             '<span title="' . $lang->getLL('clip_deleteMarked', true) . '">' . $this->iconFactory->getIcon('actions-edit-delete', Icon::SIZE_SMALL)->render() . '</span>',
1091                             $table,
1092                             'delete',
1093                             sprintf($lang->getLL('clip_deleteMarkedWarning'), $lang->sL($GLOBALS['TCA'][$table]['ctrl']['title']))
1094                         );
1095                         // The "Select all" link:
1096                         $onClick = htmlspecialchars(('checkOffCB(' . GeneralUtility::quoteJSvalue(implode(',', $this->CBnames)) . ', this); return false;'));
1097                         $cells['markAll'] = '<a class="btn btn-default" rel="" href="#" onclick="' . $onClick . '" title="'
1098                             . $lang->getLL('clip_markRecords', true) . '">'
1099                             . $this->iconFactory->getIcon('actions-document-select', Icon::SIZE_SMALL)->render() . '</a>';
1100                     } else {
1101                         $cells['empty'] = '';
1102                     }
1103                     /**
1104                      * @hook renderListHeaderActions: Allows to change the clipboard icons of the Web>List table headers
1105                      * @usage Above each listed table in Web>List a header row is shown.
1106                      *        This hook allows to modify the icons responsible for the clipboard functions
1107                      *        (shown above the clipboard checkboxes when a clipboard other than "Normal" is selected),
1108                      *        or other "Action" functions which perform operations on the listed records.
1109                     */
1110                     if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'])) {
1111                         foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'] as $classData) {
1112                             $hookObject = GeneralUtility::getUserObj($classData);
1113                             if (!$hookObject instanceof RecordListHookInterface) {
1114                                 throw new \UnexpectedValueException('$hookObject must implement interface ' . RecordListHookInterface::class, 1195567850);
1115                             }
1116                             $cells = $hookObject->renderListHeaderActions($table, $currentIdList, $cells, $this);
1117                         }
1118                     }
1119                     $theData[$fCol] = '<div class="btn-group" role="group">' . implode('', $cells) . '</div>';
1120                     break;
1121                 case '_CONTROL_':
1122                     // Control panel:
1123                     if ($this->isEditable($table)) {
1124                         // If new records can be created on this page, add links:
1125                         $permsAdditional = ($table === 'pages' ? 8 : 16);
1126                         if ($this->calcPerms & $permsAdditional && $this->showNewRecLink($table)) {
1127                             $spriteIcon = $table === 'pages'
1128                                 ? $this->iconFactory->getIcon('actions-page-new', Icon::SIZE_SMALL)
1129                                 : $this->iconFactory->getIcon('actions-add', Icon::SIZE_SMALL);
1130                             if ($table === 'tt_content' && $this->newWizards) {
1131                                 // If mod.newContentElementWizard.override is set, use that extension's create new content wizard instead:
1132                                 $tmpTSc = BackendUtility::getModTSconfig($this->pageinfo['uid'], 'mod');
1133                                 $newContentElementWizard = $tmpTSc['properties']['newContentElementWizard.']['override'] ?: 'new_content_element';
1134                                 $newContentWizScriptPath = BackendUtility::getModuleUrl($newContentElementWizard, array('id' => $this->id));
1135
1136                                 $onClick = 'return jumpExt(' . GeneralUtility::quoteJSvalue($newContentWizScriptPath) . ');';
1137                                 $icon = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick) . '" title="'
1138                                     . $lang->getLL('new', true) . '">' . $spriteIcon->render() . '</a>';
1139                             } elseif ($table == 'pages' && $this->newWizards) {
1140                                 $parameters = ['id' => $this->id, 'pagesOnly' => 1, 'returnUrl' => GeneralUtility::getIndpEnv('REQUEST_URI')];
1141                                 $href = BackendUtility::getModuleUrl('db_new', $parameters);
1142                                 $icon = '<a class="btn btn-default" href="' . htmlspecialchars($href) . '" title="' . $lang->getLL('new', true) . '">'
1143                                     . $spriteIcon->render() . '</a>';
1144                             } else {
1145                                 $params = '&edit[' . $table . '][' . $this->id . ']=new';
1146                                 if ($table == 'pages_language_overlay') {
1147                                     $params .= '&overrideVals[pages_language_overlay][doktype]=' . (int)$this->pageRow['doktype'];
1148                                 }
1149                                 $icon = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars(BackendUtility::editOnClick($params, '', -1))
1150                                     . '" title="' . $lang->getLL('new', true) . '">' . $spriteIcon->render() . '</a>';
1151                             }
1152                         }
1153                         // If the table can be edited, add link for editing ALL SHOWN fields for all listed records:
1154                         if ($permsEdit && $this->table && is_array($currentIdList)) {
1155                             $editIdList = implode(',', $currentIdList);
1156                             if ($this->clipNumPane()) {
1157                                 $editIdList = '\'+editList(' . GeneralUtility::quoteJSvalue($table) . ',' . GeneralUtility::quoteJSvalue($editIdList) . ')+\'';
1158                             }
1159                             $params = 'edit[' . $table . '][' . $editIdList . ']=edit&columnsOnly=' . implode(',', $this->fieldArray);
1160                             // we need to build this uri differently, otherwise GeneralUtility::quoteJSvalue messes up the edit list function
1161                             $onClick = BackendUtility::editOnClick('', '', -1);
1162                             $onClickArray = explode('?', $onClick, 2);
1163                             $lastElement = array_pop($onClickArray);
1164                             array_push($onClickArray, $params . '&' . $lastElement);
1165                             $onClick = implode('?', $onClickArray);
1166                             $icon .= '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick)
1167                                 . '" title="' . $lang->getLL('editShownColumns', true) . '">'
1168                                 . $this->iconFactory->getIcon('actions-document-open', Icon::SIZE_SMALL)->render() . '</a>';
1169                             $icon = '<div class="btn-group" role="group">' . $icon . '</div>';
1170                         }
1171                         // Add an empty entry, so column count fits again after moving this into $icon
1172                         $theData[$fCol] = '&nbsp;';
1173                     }
1174                     break;
1175                 default:
1176                     // Regular fields header:
1177                     $theData[$fCol] = '';
1178
1179                     // Check if $fCol is really a field and get the label and remove the colons
1180                     // at the end
1181                     $sortLabel = BackendUtility::getItemLabel($table, $fCol);
1182                     if ($sortLabel !== null) {
1183                         $sortLabel = $lang->sL($sortLabel, true);
1184                         $sortLabel = rtrim(trim($sortLabel), ':');
1185                     } else {
1186                         // No TCA field, only output the $fCol variable with square brackets []
1187                         $sortLabel = htmlspecialchars($fCol);
1188                         $sortLabel = '<i>[' . rtrim(trim($sortLabel), ':') . ']</i>';
1189                     }
1190
1191                     if ($this->table && is_array($currentIdList)) {
1192                         // If the numeric clipboard pads are selected, show duplicate sorting link:
1193                         if ($this->clipNumPane()) {
1194                             $theData[$fCol] .= '<a class="btn btn-default" href="' . htmlspecialchars($this->listURL('', '-1') . '&duplicateField=' . $fCol)
1195                                 . '" title="' . $lang->getLL('clip_duplicates', true) . '">'
1196                                 . $this->iconFactory->getIcon('actions-document-duplicates-select', Icon::SIZE_SMALL)->render() . '</a>';
1197                         }
1198                         // If the table can be edited, add link for editing THIS field for all
1199                         // listed records:
1200                         if ($this->isEditable($table) && $permsEdit && $GLOBALS['TCA'][$table]['columns'][$fCol]) {
1201                             $editIdList = implode(',', $currentIdList);
1202                             if ($this->clipNumPane()) {
1203                                 $editIdList = '\'+editList(' . GeneralUtility::quoteJSvalue($table) . ',' . GeneralUtility::quoteJSvalue($editIdList) . ')+\'';
1204                             }
1205                             $params = 'edit[' . $table . '][' . $editIdList . ']=edit&columnsOnly=' . $fCol;
1206                             // we need to build this uri differently, otherwise GeneralUtility::quoteJSvalue messes up the edit list function
1207                             $onClick = BackendUtility::editOnClick('', '', -1);
1208                             $onClickArray = explode('?', $onClick, 2);
1209                             $lastElement = array_pop($onClickArray);
1210                             array_push($onClickArray, $params . '&' . $lastElement);
1211                             $onClick = implode('?', $onClickArray);
1212                             $iTitle = sprintf($lang->getLL('editThisColumn'), $sortLabel);
1213                             $theData[$fCol] .= '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick)
1214                                 . '" title="' . htmlspecialchars($iTitle) . '">'
1215                                 . $this->iconFactory->getIcon('actions-document-open', Icon::SIZE_SMALL)->render() . '</a>';
1216                         }
1217                         if (strlen($theData[$fCol]) > 0) {
1218                             $theData[$fCol] = '<div class="btn-group" role="group">' . $theData[$fCol] . '</div> ';
1219                         }
1220                     }
1221                     $theData[$fCol] .= $this->addSortLink($sortLabel, $fCol, $table);
1222             }
1223         }
1224         /**
1225          * @hook renderListHeader: Allows to change the contents of columns/cells of the Web>List table headers
1226          * @usage Above each listed table in Web>List a header row is shown.
1227          *        Containing the labels of all shown fields and additional icons to create new records for this
1228          *        table or perform special clipboard tasks like mark and copy all listed records to clipboard, etc.
1229          */
1230         if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'])) {
1231             foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'] as $classData) {
1232                 $hookObject = GeneralUtility::getUserObj($classData);
1233                 if (!$hookObject instanceof RecordListHookInterface) {
1234                     throw new \UnexpectedValueException('$hookObject must implement interface ' . RecordListHookInterface::class, 1195567855);
1235                 }
1236                 $theData = $hookObject->renderListHeader($table, $currentIdList, $theData, $this);
1237             }
1238         }
1239
1240         // Create and return header table row:
1241         return '<thead>' . $this->addElement(1, $icon, $theData, '', '', '', 'th') . '</thead>';
1242     }
1243
1244     /**
1245      * Get pointer for first element on the page
1246      *
1247      * @param int $page Page number starting with 1
1248      * @return int Pointer to first element on the page (starting with 0)
1249      */
1250     protected function getPointerForPage($page)
1251     {
1252         return ($page - 1) * $this->iLimit;
1253     }
1254
1255     /**
1256      * Creates a page browser for tables with many records
1257      *
1258      * @param string $renderPart Distinguish between 'top' and 'bottom' part of the navigation (above or below the records)
1259      * @return string Navigation HTML
1260      */
1261     protected function renderListNavigation($renderPart = 'top')
1262     {
1263         $totalPages = ceil($this->totalItems / $this->iLimit);
1264         // Show page selector if not all records fit into one page
1265         if ($totalPages <= 1) {
1266             return '';
1267         }
1268         $content = '';
1269         $listURL = $this->listURL('', $this->table);
1270         // 1 = first page
1271         // 0 = first element
1272         $currentPage = floor($this->firstElementNumber / $this->iLimit) + 1;
1273         // Compile first, previous, next, last and refresh buttons
1274         if ($currentPage > 1) {
1275             $labelFirst = $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:first', true);
1276             $labelPrevious = $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:previous', true);
1277             $first = '<li><a href="' . $listURL . '&pointer=' . $this->getPointerForPage(1) . '" title="' . $labelFirst . '">'
1278                 . $this->iconFactory->getIcon('actions-view-paging-first', Icon::SIZE_SMALL)->render() . '</a></li>';
1279             $previous = '<li><a href="' . $listURL . '&pointer=' . $this->getPointerForPage($currentPage - 1) . '" title="' . $labelPrevious . '">'
1280                 . $this->iconFactory->getIcon('actions-view-paging-previous', Icon::SIZE_SMALL)->render() . '</a></li>';
1281         } else {
1282             $first = '<li class="disabled"><span>' . $this->iconFactory->getIcon('actions-view-paging-first', Icon::SIZE_SMALL)->render() . '</span></li>';
1283             $previous = '<li class="disabled"><span>' . $this->iconFactory->getIcon('actions-view-paging-previous', Icon::SIZE_SMALL)->render() . '</span></li>';
1284         }
1285         if ($currentPage < $totalPages) {
1286             $labelNext = $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:next', true);
1287             $labelLast = $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:last', true);
1288             $next = '<li><a href="' . $listURL . '&pointer=' . $this->getPointerForPage($currentPage + 1) . '" title="' . $labelNext . '">'
1289                 . $this->iconFactory->getIcon('actions-view-paging-next', Icon::SIZE_SMALL)->render() . '</a></li>';
1290             $last = '<li><a href="' . $listURL . '&pointer=' . $this->getPointerForPage($totalPages) . '" title="' . $labelLast . '">'
1291                 . $this->iconFactory->getIcon('actions-view-paging-last', Icon::SIZE_SMALL)->render() . '</a></li>';
1292         } else {
1293             $next = '<li class="disabled"><span>' . $this->iconFactory->getIcon('actions-view-paging-next', Icon::SIZE_SMALL)->render() . '</span></li>';
1294             $last = '<li class="disabled"><span>' . $this->iconFactory->getIcon('actions-view-paging-last', Icon::SIZE_SMALL)->render() . '</span></li>';
1295         }
1296         $reload = '<li><a href="#" onclick="document.dblistForm.action=' . GeneralUtility::quoteJSvalue($listURL
1297             . '&pointer=') . '+calculatePointer(document.getElementById(' . GeneralUtility::quoteJSvalue('jumpPage-' . $renderPart)
1298             . ').value); document.dblistForm.submit(); return true;" title="'
1299             . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_common.xlf:reload', true) . '">'
1300             . $this->iconFactory->getIcon('actions-refresh', Icon::SIZE_SMALL)->render() . '</a></li>';
1301         if ($renderPart === 'top') {
1302             // Add js to traverse a page select input to a pointer value
1303             $content = '
1304 <script type="text/javascript">
1305 /*<![CDATA[*/
1306         function calculatePointer(page) {
1307                 if (page > ' . $totalPages . ') {
1308                         page = ' . $totalPages . ';
1309                 }
1310                 if (page < 1) {
1311                         page = 1;
1312                 }
1313                 return (page - 1) * ' . $this->iLimit . ';
1314         }
1315 /*]]>*/
1316 </script>
1317 ';
1318         }
1319         $pageNumberInput = '
1320                         <input type="text" value="' . $currentPage . '" size="3" class="form-control input-sm paginator-input" id="jumpPage-' . $renderPart . '" name="jumpPage-'
1321             . $renderPart . '" onkeyup="if (event.keyCode == 13) { document.dblistForm.action=' . GeneralUtility::quoteJSvalue($listURL
1322             . '&pointer=') . '+calculatePointer(this.value); document.dblistForm.submit(); } return true;" />
1323                         ';
1324         $pageIndicatorText = sprintf(
1325             $this->getLanguageService()->sL('LLL:EXT:lang/locallang_mod_web_list.xlf:pageIndicator'),
1326             $pageNumberInput,
1327             $totalPages
1328         );
1329         $pageIndicator = '<li><span>' . $pageIndicatorText . '</span></li>';
1330         if ($this->totalItems > $this->firstElementNumber + $this->iLimit) {
1331             $lastElementNumber = $this->firstElementNumber + $this->iLimit;
1332         } else {
1333             $lastElementNumber = $this->totalItems;
1334         }
1335         $rangeIndicator = '<li><span>' . sprintf($this->getLanguageService()->sL('LLL:EXT:lang/locallang_mod_web_list.xlf:rangeIndicator'), ($this->firstElementNumber + 1), $lastElementNumber) . '</span></li>';
1336
1337         $titleColumn = $this->fieldArray[0];
1338         $data = array(
1339             $titleColumn => $content . '
1340                                 <nav class="pagination-wrap">
1341                                         <ul class="pagination pagination-block">
1342                                                 ' . $first . '
1343                                                 ' . $previous . '
1344                                                 ' . $rangeIndicator . '
1345                                                 ' . $pageIndicator . '
1346                                                 ' . $next . '
1347                                                 ' . $last . '
1348                                                 ' . $reload . '
1349                                         </ul>
1350                                 </nav>
1351                         '
1352         );
1353         return $this->addElement(1, '', $data);
1354     }
1355
1356     /*********************************
1357      *
1358      * Rendering of various elements
1359      *
1360      *********************************/
1361
1362     /**
1363      * Creates the control panel for a single record in the listing.
1364      *
1365      * @param string $table The table
1366      * @param mixed[] $row The record for which to make the control panel.
1367      * @throws \UnexpectedValueException
1368      * @return string HTML table with the control panel (unless disabled)
1369      */
1370     public function makeControl($table, $row)
1371     {
1372         $module = $this->getModule();
1373         $rowUid = $row['uid'];
1374         if (ExtensionManagementUtility::isLoaded('version') && isset($row['_ORIG_uid'])) {
1375             $rowUid = $row['_ORIG_uid'];
1376         }
1377         $cells = array(
1378             'primary' => array(),
1379             'secondary' => array()
1380         );
1381         // If the listed table is 'pages' we have to request the permission settings for each page:
1382         $localCalcPerms = 0;
1383         if ($table == 'pages') {
1384             $localCalcPerms = $this->getBackendUserAuthentication()->calcPerms(BackendUtility::getRecord('pages', $row['uid']));
1385         }
1386         $permsEdit = $table === 'pages'
1387                      && $this->getBackendUserAuthentication()->checkLanguageAccess(0)
1388                      && $localCalcPerms & Permission::PAGE_EDIT
1389                      || $table !== 'pages'
1390                         && $this->calcPerms & Permission::CONTENT_EDIT;
1391         $permsEdit = $this->overlayEditLockPermissions($table, $row, $permsEdit);
1392         // "Show" link (only pages and tt_content elements)
1393         if ($table == 'pages' || $table == 'tt_content') {
1394             $viewAction = '<a class="btn btn-default" href="#" onclick="'
1395                 . htmlspecialchars(
1396                     BackendUtility::viewOnClick(
1397                         ($table === 'tt_content' ? $this->id : $row['uid']),
1398                         '',
1399                         '',
1400                         ($table === 'tt_content' ? '#' . $row['uid'] : '')
1401                     )
1402                 ) . '" title="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:labels.showPage', true) . '">'
1403                 . $this->iconFactory->getIcon('actions-view', Icon::SIZE_SMALL)->render() . '</a>';
1404             $this->addActionToCellGroup($cells, $viewAction, 'view');
1405         }
1406         // "Edit" link: ( Only if permissions to edit the page-record of the content of the parent page ($this->id)
1407         if ($permsEdit) {
1408             $params = '&edit[' . $table . '][' . $row['uid'] . ']=edit';
1409             $iconIdentifier = 'actions-open';
1410             $overlayIdentifier = !$this->isEditable($table) ? 'overlay-readonly' : null;
1411             $editAction = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars(BackendUtility::editOnClick($params, '', -1))
1412                 . '" title="' . $this->getLanguageService()->getLL('edit', true) . '">' . $this->iconFactory->getIcon($iconIdentifier, Icon::SIZE_SMALL, $overlayIdentifier)->render() . '</a>';
1413         } else {
1414             $editAction = $this->spaceIcon;
1415         }
1416         $this->addActionToCellGroup($cells, $editAction, 'edit');
1417         // "Info": (All records)
1418         $onClick = 'top.launchView(' . GeneralUtility::quoteJSvalue($table) . ', ' . (int)$row['uid'] . '); return false;';
1419         $viewBigAction = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick) . '" title="' . $this->getLanguageService()->getLL('showInfo', true) . '">'
1420             . $this->iconFactory->getIcon('actions-document-info', Icon::SIZE_SMALL)->render() . '</a>';
1421         $this->addActionToCellGroup($cells, $viewBigAction, 'viewBig');
1422         // "Move" wizard link for pages/tt_content elements:
1423         if ($permsEdit && ($table === 'tt_content' || $table === 'pages')) {
1424             $onClick = 'return jumpExt(' . GeneralUtility::quoteJSvalue(BackendUtility::getModuleUrl('move_element') . '&table=' . $table . '&uid=' . $row['uid']) . ');';
1425             $linkTitleLL = $this->getLanguageService()->getLL('move_' . ($table === 'tt_content' ? 'record' : 'page'), true);
1426             $icon = ($table == 'pages' ? $this->iconFactory->getIcon('actions-page-move', Icon::SIZE_SMALL) : $this->iconFactory->getIcon('actions-document-move', Icon::SIZE_SMALL));
1427             $moveAction = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick) . '" title="' . $linkTitleLL . '">' . $icon->render() . '</a>';
1428             $this->addActionToCellGroup($cells, $moveAction, 'move');
1429         }
1430         // If the table is NOT a read-only table, then show these links:
1431         if ($this->isEditable($table)) {
1432             // "Revert" link (history/undo)
1433             $moduleUrl = BackendUtility::getModuleUrl('record_history', array('element' => $table . ':' . $row['uid']));
1434             $onClick = 'return jumpExt(' . GeneralUtility::quoteJSvalue($moduleUrl) . ',\'#latest\');';
1435             $historyAction = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick) . '" title="'
1436                 . $this->getLanguageService()->getLL('history', true) . '">'
1437                 . $this->iconFactory->getIcon('actions-document-history-open', Icon::SIZE_SMALL)->render() . '</a>';
1438             $this->addActionToCellGroup($cells, $historyAction, 'history');
1439             // Versioning:
1440             if (ExtensionManagementUtility::isLoaded('version') && !ExtensionManagementUtility::isLoaded('workspaces')) {
1441                 $vers = BackendUtility::selectVersionsOfRecord($table, $row['uid'], 'uid', $this->getBackendUserAuthentication()->workspace, false, $row);
1442                 // If table can be versionized.
1443                 if (is_array($vers)) {
1444                     $href = BackendUtility::getModuleUrl('web_txversionM1', array(
1445                         'table' => $table, 'uid' => $row['uid']
1446                     ));
1447                     $versionAction = '<a class="btn btn-default" href="' . htmlspecialchars($href) . '" title="'
1448                         . $this->getLanguageService()->getLL('displayVersions', true) . '">'
1449                         . $this->iconFactory->getIcon('actions-version-page-open', Icon::SIZE_SMALL)->render() . '</a>';
1450                     $this->addActionToCellGroup($cells, $versionAction, 'version');
1451                 }
1452             }
1453             // "Edit Perms" link:
1454             if ($table === 'pages' && $this->getBackendUserAuthentication()->check('modules', 'system_BeuserTxPermission') && ExtensionManagementUtility::isLoaded('beuser')) {
1455                 $href = BackendUtility::getModuleUrl('system_BeuserTxPermission') . '&id=' . $row['uid'] . '&return_id=' . $row['uid'] . '&edit=1';
1456                 $permsAction = '<a class="btn btn-default" href="' . htmlspecialchars($href) . '" title="'
1457                     . $this->getLanguageService()->getLL('permissions', true) . '">'
1458                     . $this->iconFactory->getIcon('status-status-locked', Icon::SIZE_SMALL)->render() . '</a>';
1459                 $this->addActionToCellGroup($cells, $permsAction, 'perms');
1460             }
1461             // "New record after" link (ONLY if the records in the table are sorted by a "sortby"-row
1462             // or if default values can depend on previous record):
1463             if (($GLOBALS['TCA'][$table]['ctrl']['sortby'] || $GLOBALS['TCA'][$table]['ctrl']['useColumnsForDefaultValues']) && $permsEdit) {
1464                 if ($table !== 'pages' && $this->calcPerms & Permission::CONTENT_EDIT || $table === 'pages' && $this->calcPerms & Permission::PAGE_NEW) {
1465                     if ($this->showNewRecLink($table)) {
1466                         $params = '&edit[' . $table . '][' . -($row['_MOVE_PLH'] ? $row['_MOVE_PLH_uid'] : $row['uid']) . ']=new';
1467                         $icon = ($table == 'pages' ? $this->iconFactory->getIcon('actions-page-new', Icon::SIZE_SMALL) : $this->iconFactory->getIcon('actions-add', Icon::SIZE_SMALL));
1468                         $newAction = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars(BackendUtility::editOnClick($params, '', -1))
1469                             . '" title="' . $this->getLanguageService()->getLL('new' . ($table == 'pages ' ? 'Page' : 'Record'), true) . '">'
1470                             . $icon->render() . '</a>';
1471                         $this->addActionToCellGroup($cells, $newAction, 'new');
1472                     }
1473                 }
1474             }
1475             // "Up/Down" links
1476             if ($permsEdit && $GLOBALS['TCA'][$table]['ctrl']['sortby'] && !$this->sortField && !$this->searchLevels) {
1477                 if (isset($this->currentTable['prev'][$row['uid']])) {
1478                     // Up
1479                     $params = '&cmd[' . $table . '][' . $row['uid'] . '][move]=' . $this->currentTable['prev'][$row['uid']];
1480                     $moveUpAction = '<a class="btn btn-default" href="#" onclick="'
1481                         . htmlspecialchars('return jumpToUrl(' . BackendUtility::getLinkToDataHandlerAction($params, -1) . ');')
1482                         . '" title="' . $this->getLanguageService()->getLL('moveUp', true) . '">'
1483                         . $this->iconFactory->getIcon('actions-move-up', Icon::SIZE_SMALL)->render() . '</a>';
1484                 } else {
1485                     $moveUpAction = $this->spaceIcon;
1486                 }
1487                 $this->addActionToCellGroup($cells, $moveUpAction, 'moveUp');
1488
1489                 if ($this->currentTable['next'][$row['uid']]) {
1490                     // Down
1491                     $params = '&cmd[' . $table . '][' . $row['uid'] . '][move]=' . $this->currentTable['next'][$row['uid']];
1492                     $moveDownAction = '<a class="btn btn-default" href="#" onclick="'
1493                         . htmlspecialchars('return jumpToUrl(' . BackendUtility::getLinkToDataHandlerAction($params, -1) . ');')
1494                         . '" title="' . $this->getLanguageService()->getLL('moveDown', true) . '">'
1495                         . $this->iconFactory->getIcon('actions-move-down', Icon::SIZE_SMALL)->render() . '</a>';
1496                 } else {
1497                     $moveDownAction = $this->spaceIcon;
1498                 }
1499                 $this->addActionToCellGroup($cells, $moveDownAction, 'moveDown');
1500             }
1501             // "Hide/Unhide" links:
1502             $hiddenField = $GLOBALS['TCA'][$table]['ctrl']['enablecolumns']['disabled'];
1503
1504             if (
1505                 $permsEdit && $hiddenField && $GLOBALS['TCA'][$table]['columns'][$hiddenField]
1506                 && (!$GLOBALS['TCA'][$table]['columns'][$hiddenField]['exclude']
1507                     || $this->getBackendUserAuthentication()->check('non_exclude_fields', $table . ':' . $hiddenField))
1508             ) {
1509                 if ($this->isRecordCurrentBackendUser($table, $row)) {
1510                     $hideAction = $this->spaceIcon;
1511                 } else {
1512                     $hideTitle = $this->getLanguageService()->getLL('hide' . ($table == 'pages' ? 'Page' : ''), true);
1513                     $unhideTitle = $this->getLanguageService()->getLL('unHide' . ($table == 'pages' ? 'Page' : ''), true);
1514                     if ($row[$hiddenField]) {
1515                         $params = 'data[' . $table . '][' . $rowUid . '][' . $hiddenField . ']=0';
1516                         $hideAction = '<a class="btn btn-default t3js-record-hide" data-state="hidden" href="#"'
1517                                       . ' data-params="' . htmlspecialchars($params) . '"'
1518                                       . ' title="' . $unhideTitle . '"'
1519                                       . ' data-toggle-title="' . $hideTitle . '">'
1520                                       . $this->iconFactory->getIcon('actions-edit-unhide', Icon::SIZE_SMALL)->render() . '</a>';
1521                     } else {
1522                         $params = 'data[' . $table . '][' . $rowUid . '][' . $hiddenField . ']=1';
1523                         $hideAction = '<a class="btn btn-default t3js-record-hide" data-state="visible" href="#"'
1524                                       . ' data-params="' . htmlspecialchars($params) . '"'
1525                                       . ' title="' . $hideTitle . '"'
1526                                       . ' data-toggle-title="' . $unhideTitle . '">'
1527                                       . $this->iconFactory->getIcon('actions-edit-hide', Icon::SIZE_SMALL)->render() . '</a>';
1528                     }
1529                 }
1530                 $this->addActionToCellGroup($cells, $hideAction, 'hide');
1531             }
1532             // "Delete" link:
1533             if ($permsEdit && ($table === 'pages' && $localCalcPerms & Permission::PAGE_DELETE || $table !== 'pages' && $this->calcPerms & Permission::CONTENT_EDIT)) {
1534                 // Check if the record version is in "deleted" state, because that will switch the action to "restore"
1535                 if ($this->getBackendUserAuthentication()->workspace > 0 && isset($row['t3ver_state']) && (int)$row['t3ver_state'] === 2) {
1536                     $actionName = 'restore';
1537                     $refCountMsg = '';
1538                 } else {
1539                     $actionName = 'delete';
1540                     $refCountMsg = BackendUtility::referenceCount(
1541                         $table,
1542                         $row['uid'],
1543                         ' ' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:labels.referencesToRecord'),
1544                         $this->getReferenceCount($table, $row['uid'])) . BackendUtility::translationCount($table, $row['uid'],
1545                         ' ' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:labels.translationsOfRecord')
1546                     );
1547                 }
1548
1549                 if ($this->isRecordCurrentBackendUser($table, $row)) {
1550                     $deleteAction = $this->spaceIcon;
1551                 } else {
1552                     $titleOrig = BackendUtility::getRecordTitle($table, $row, false, true);
1553                     $title = GeneralUtility::slashJS(GeneralUtility::fixed_lgd_cs($titleOrig, $this->fixedL), true);
1554                     $warningText = $this->getLanguageService()->getLL($actionName . 'Warning') . ' "' . $title . '" ' . '[' . $table . ':' . $row['uid'] . ']' . $refCountMsg;
1555
1556                     $params = 'cmd[' . $table . '][' . $row['uid'] . '][delete]=1';
1557                     $icon = $this->iconFactory->getIcon('actions-edit-' . $actionName, Icon::SIZE_SMALL)->render();
1558                     $linkTitle = $this->getLanguageService()->getLL($actionName, true);
1559                     $deleteAction = '<a class="btn btn-default t3js-record-delete" href="#" '
1560                                     . ' data-l10parent="' . htmlspecialchars($row['l10n_parent']) . '"'
1561                                     . ' data-params="' . htmlspecialchars($params) . '" data-title="' . htmlspecialchars($titleOrig) . '"'
1562                                     . ' data-message="' . htmlspecialchars($warningText) . '" title="' . $linkTitle . '"'
1563                                     . '>' . $icon . '</a>';
1564                 }
1565             } else {
1566                 $deleteAction = $this->spaceIcon;
1567             }
1568             $this->addActionToCellGroup($cells, $deleteAction, 'delete');
1569             // "Levels" links: Moving pages into new levels...
1570             if ($permsEdit && $table == 'pages' && !$this->searchLevels) {
1571                 // Up (Paste as the page right after the current parent page)
1572                 if ($this->calcPerms & Permission::PAGE_NEW) {
1573                     $params = '&cmd[' . $table . '][' . $row['uid'] . '][move]=' . -$this->id;
1574                     $moveLeftAction = '<a class="btn btn-default" href="#" onclick="'
1575                         . htmlspecialchars('return jumpToUrl(' . BackendUtility::getLinkToDataHandlerAction($params, -1) . ');')
1576                         . '" title="' . $this->getLanguageService()->getLL('prevLevel', true) . '">'
1577                         . $this->iconFactory->getIcon('actions-move-left', Icon::SIZE_SMALL)->render() . '</a>';
1578                     $this->addActionToCellGroup($cells, $moveLeftAction, 'moveLeft');
1579                 }
1580                 // Down (Paste as subpage to the page right above)
1581                 if ($this->currentTable['prevUid'][$row['uid']]) {
1582                     $localCalcPerms = $this->getBackendUserAuthentication()->calcPerms(BackendUtility::getRecord('pages', $this->currentTable['prevUid'][$row['uid']]));
1583                     if ($localCalcPerms & Permission::PAGE_NEW) {
1584                         $params = '&cmd[' . $table . '][' . $row['uid'] . '][move]=' . $this->currentTable['prevUid'][$row['uid']];
1585                         $moveRightAction = '<a class="btn btn-default" href="#" onclick="'
1586                             . htmlspecialchars('return jumpToUrl(' . BackendUtility::getLinkToDataHandlerAction($params, -1) . ');')
1587                             . '" title="' . $this->getLanguageService()->getLL('nextLevel', true) . '">'
1588                             . $this->iconFactory->getIcon('actions-move-right', Icon::SIZE_SMALL)->render() . '</a>';
1589                     } else {
1590                         $moveRightAction = $this->spaceIcon;
1591                     }
1592                 } else {
1593                     $moveRightAction = $this->spaceIcon;
1594                 }
1595                 $this->addActionToCellGroup($cells, $moveRightAction, 'moveRight');
1596             }
1597         }
1598         /**
1599          * @hook recStatInfoHooks: Allows to insert HTML before record icons on various places
1600          */
1601         if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['GLOBAL']['recStatInfoHooks'])) {
1602             $stat = '';
1603             $_params = array($table, $row['uid']);
1604             foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['GLOBAL']['recStatInfoHooks'] as $_funcRef) {
1605                 $stat .= GeneralUtility::callUserFunction($_funcRef, $_params, $this);
1606             }
1607             $this->addActionToCellGroup($cells, $stat, 'stat');
1608         }
1609         /**
1610          * @hook makeControl: Allows to change control icons of records in list-module
1611          * @usage This hook method gets passed the current $cells array as third parameter.
1612          *        This array contains values for the icons/actions generated for each record in Web>List.
1613          *        Each array entry is accessible by an index-key.
1614          *        The order of the icons is depending on the order of those array entries.
1615          */
1616         if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'])) {
1617             // for compatibility reason, we move all icons to the rootlevel
1618             // before calling the hooks
1619             foreach ($cells as $section => $actions) {
1620                 foreach ($actions as $actionKey => $action) {
1621                     $cells[$actionKey] = $action;
1622                 }
1623             }
1624             foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'] as $classData) {
1625                 $hookObject = GeneralUtility::getUserObj($classData);
1626                 if (!$hookObject instanceof RecordListHookInterface) {
1627                     throw new \UnexpectedValueException('$hookObject must implement interface ' . RecordListHookInterface::class, 1195567840);
1628                 }
1629                 $cells = $hookObject->makeControl($table, $row, $cells, $this);
1630             }
1631             // now sort icons again into primary and secondary sections
1632             // after all hooks are processed
1633             $hookCells = $cells;
1634             foreach ($hookCells as $key => $value) {
1635                 if ($key === 'primary' || $key === 'secondary') {
1636                     continue;
1637                 }
1638                 $this->addActionToCellGroup($cells, $value, $key);
1639             }
1640         }
1641         $output = '<!-- CONTROL PANEL: ' . $table . ':' . $row['uid'] . ' -->';
1642         foreach ($cells as $classification => $actions) {
1643             $visibilityClass = ($classification !== 'primary' && !$module->MOD_SETTINGS['bigControlPanel'] ? 'collapsed' : 'expanded');
1644             if ($visibilityClass === 'collapsed') {
1645                 $cellOutput = '';
1646                 foreach ($actions as $action) {
1647                     $cellOutput .= $action;
1648                 }
1649                 $output .= ' <div class="btn-group">' .
1650                     '<span id="actions_' . $table . '_' . $row['uid'] . '" class="btn-group collapse collapse-horizontal width">' . $cellOutput . '</span>' .
1651                     '<a href="#actions_' . $table . '_' . $row['uid'] . '" class="btn btn-default collapsed" data-toggle="collapse" aria-expanded="false"><span class="t3-icon fa fa-ellipsis-h"></span></a>' .
1652                     '</div>';
1653             } else {
1654                 $output .= ' <div class="btn-group" role="group">' . implode('', $actions) . '</div>';
1655             }
1656         }
1657         return $output;
1658     }
1659
1660     /**
1661      * Creates the clipboard panel for a single record in the listing.
1662      *
1663      * @param string $table The table
1664      * @param mixed[] $row The record for which to make the clipboard panel.
1665      * @throws \UnexpectedValueException
1666      * @return string HTML table with the clipboard panel (unless disabled)
1667      */
1668     public function makeClip($table, $row)
1669     {
1670         // Return blank, if disabled:
1671         if (!$this->getModule()->MOD_SETTINGS['clipBoard']) {
1672             return '';
1673         }
1674         $cells = array();
1675         $cells['pasteAfter'] = ($cells['pasteInto'] = $this->spaceIcon);
1676         //enables to hide the copy, cut and paste icons for localized records - doesn't make much sense to perform these options for them
1677         $isL10nOverlay = $this->localizationView && $table != 'pages_language_overlay' && $row[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']] != 0;
1678         // Return blank, if disabled:
1679         // Whether a numeric clipboard pad is active or the normal pad we will see different content of the panel:
1680         // For the "Normal" pad:
1681         if ($this->clipObj->current === 'normal') {
1682             // Show copy/cut icons:
1683             $isSel = (string)$this->clipObj->isSelected($table, $row['uid']);
1684             if ($isL10nOverlay || !$this->overlayEditLockPermissions($table, $row)) {
1685                 $cells['copy'] = $this->spaceIcon;
1686                 $cells['cut'] = $this->spaceIcon;
1687             } else {
1688                 $copyIcon = $this->iconFactory->getIcon('actions-edit-copy', Icon::SIZE_SMALL);
1689                 $cutIcon = $this->iconFactory->getIcon('actions-edit-cut', Icon::SIZE_SMALL);
1690
1691                 if ($isSel === 'copy') {
1692                     $copyIcon = $this->iconFactory->getIcon('actions-edit-copy-release', Icon::SIZE_SMALL);
1693                 } elseif ($isSel === 'cut') {
1694                     $cutIcon = $this->iconFactory->getIcon('actions-edit-cut-release', Icon::SIZE_SMALL);
1695                 }
1696
1697                 $cells['copy'] = '<a class="btn btn-default" href="#" onclick="'
1698                     . htmlspecialchars('return jumpSelf(' . GeneralUtility::quoteJSvalue($this->clipObj->selUrlDB($table, $row['uid'], 1, ($isSel === 'copy'), array('returnUrl' => ''))) . ');')
1699                     . '" title="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:cm.copy', true) . '">'
1700                     . $copyIcon->render() . '</a>';
1701                 if (true) {
1702                     $cells['cut'] = '<a class="btn btn-default" href="#" onclick="'
1703                         . htmlspecialchars('return jumpSelf(' . GeneralUtility::quoteJSvalue($this->clipObj->selUrlDB($table, $row['uid'], 0, ($isSel === 'cut'), array('returnUrl' => ''))) . ');')
1704                         . '" title="' . $this->getLanguageService()->sL('LLL:EXT:lang/locallang_core.xlf:cm.cut', true) . '">'
1705                         . $cutIcon->render() . '</a>';
1706                 } else {
1707                     $cells['cut'] = $this->spaceIcon;
1708                 }
1709             }
1710         } else {
1711             // For the numeric clipboard pads (showing checkboxes where one can select elements on/off)
1712             // Setting name of the element in ->CBnames array:
1713             $n = $table . '|' . $row['uid'];
1714             $this->CBnames[] = $n;
1715             // Check if the current element is selected and if so, prepare to set the checkbox as selected:
1716             $checked = $this->clipObj->isSelected($table, $row['uid']) ? 'checked="checked" ' : '';
1717             // If the "duplicateField" value is set then select all elements which are duplicates...
1718             if ($this->duplicateField && isset($row[$this->duplicateField])) {
1719                 $checked = '';
1720                 if (in_array($row[$this->duplicateField], $this->duplicateStack)) {
1721                     $checked = 'checked="checked" ';
1722                 }
1723                 $this->duplicateStack[] = $row[$this->duplicateField];
1724             }
1725             // Adding the checkbox to the panel:
1726             $cells['select'] = $isL10nOverlay
1727                 ? $this->spaceIcon
1728                 : '<input type="hidden" name="CBH[' . $n . ']" value="0" /><label class="btn btn-default btn-checkbox"><input type="checkbox"'
1729                     . ' name="CBC[' . $n . ']" value="1" ' . $checked . '/><span class="t3-icon fa"></span></label>';
1730         }
1731         // Now, looking for selected elements from the current table:
1732         $elFromTable = $this->clipObj->elFromTable($table);
1733         if (!empty($elFromTable) && $GLOBALS['TCA'][$table]['ctrl']['sortby']) {
1734             // IF elements are found, they can be individually ordered and are not locked by editlock, then add a "paste after" icon:
1735             $cells['pasteAfter'] = $isL10nOverlay || !$this->overlayEditLockPermissions($table, $row)
1736                 ? $this->spaceIcon
1737                 : '<a class="btn btn-default" href="' . htmlspecialchars($this->clipObj->pasteUrl($table, -$row['uid'])) . '" onclick="'
1738                     . htmlspecialchars(('return ' . $this->clipObj->confirmMsg($table, $row, 'after', $elFromTable)))
1739                     . '" title="' . $this->getLanguageService()->getLL('clip_pasteAfter', true) . '">'
1740                     . $this->iconFactory->getIcon('actions-document-paste-after', Icon::SIZE_SMALL)->render() . '</a>';
1741         }
1742         // Now, looking for elements in general:
1743         $elFromTable = $this->clipObj->elFromTable('');
1744         if ($table == 'pages' && !empty($elFromTable)) {
1745             $cells['pasteInto'] = '<a class="btn btn-default" href="' . htmlspecialchars($this->clipObj->pasteUrl('', $row['uid']))
1746                 . '" onclick="' . htmlspecialchars('return ' . $this->clipObj->confirmMsg($table, $row, 'into', $elFromTable))
1747                 . '" title="' . $this->getLanguageService()->getLL('clip_pasteInto', true) . '">'
1748                 . $this->iconFactory->getIcon('actions-document-paste-into', Icon::SIZE_SMALL)->render() . '</a>';
1749         }
1750         /**
1751          * @hook makeClip: Allows to change clip-icons of records in list-module
1752          * @usage This hook method gets passed the current $cells array as third parameter.
1753          *        This array contains values for the clipboard icons generated for each record in Web>List.
1754          *        Each array entry is accessible by an index-key.
1755          *        The order of the icons is depending on the order of those array entries.
1756          */
1757         if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'])) {
1758             foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'] as $classData) {
1759                 $hookObject = GeneralUtility::getUserObj($classData);
1760                 if (!$hookObject instanceof RecordListHookInterface) {
1761                     throw new \UnexpectedValueException('$hookObject must implement interface ' . RecordListHookInterface::class, 1195567845);
1762                 }
1763                 $cells = $hookObject->makeClip($table, $row, $cells, $this);
1764             }
1765         }
1766         // Compile items into a DIV-element:
1767         return '<!-- CLIPBOARD PANEL: ' . $table . ':' . $row['uid'] . ' -->
1768                         <div class="btn-group" role="group">' . implode('', $cells) . '</div>';
1769     }
1770
1771     /**
1772      * Creates the HTML for a reference count for the record with the UID $uid
1773      * in the table $tableName.
1774      *
1775      * @param string $tableName
1776      * @param int $uid
1777      * @return string HTML of reference a link, will be empty if there are no
1778      */
1779     protected function createReferenceHtml($tableName, $uid)
1780     {
1781         $db = $this->getDatabaseConnection();
1782         $referenceCount = $db->exec_SELECTcountRows(
1783             '*',
1784             'sys_refindex',
1785             'ref_table = ' . $db->fullQuoteStr($tableName, 'sys_refindex') .
1786             ' AND ref_uid = ' . $uid . ' AND deleted = 0'
1787         );
1788         return $this->generateReferenceToolTip($referenceCount, GeneralUtility::quoteJSvalue($tableName) . ', ' . GeneralUtility::quoteJSvalue($uid));
1789     }
1790
1791     /**
1792      * Creates the localization panel
1793      *
1794      * @param string $table The table
1795      * @param mixed[] $row The record for which to make the localization panel.
1796      * @return string[] Array with key 0/1 with content for column 1 and 2
1797      */
1798     public function makeLocalizationPanel($table, $row)
1799     {
1800         $out = array(
1801             0 => '',
1802             1 => ''
1803         );
1804         // Reset translations
1805         $this->translations = array();
1806
1807         // Language title and icon:
1808         $out[0] = $this->languageFlag($row[$GLOBALS['TCA'][$table]['ctrl']['languageField']]);
1809         // Guard clause so we can quickly return if a record is localized to "all languages"
1810         // It should only be possible to localize a record off default (uid 0)
1811         // Reasoning: The Parent is for ALL languages... why overlay with a localization?
1812         if ((int)$row[$GLOBALS['TCA'][$table]['ctrl']['languageField']] === -1) {
1813             return $out;
1814         }
1815
1816         $translations = $this->translateTools->translationInfo($table, $row['uid'], 0, $row, $this->selFieldList);
1817         if (is_array($translations)) {
1818             $this->translations = $translations['translations'];
1819             // Traverse page translations and add icon for each language that does NOT yet exist:
1820             $lNew = '';
1821             foreach ($this->pageOverlays as $lUid_OnPage => $lsysRec) {
1822                 if ($this->isEditable($table) && !isset($translations['translations'][$lUid_OnPage]) && $this->getBackendUserAuthentication()->checkLanguageAccess($lUid_OnPage)) {
1823                     $url = $this->listURL();
1824                     $href = BackendUtility::getLinkToDataHandlerAction(
1825                         '&cmd[' . $table . '][' . $row['uid'] . '][localize]=' . $lUid_OnPage,
1826                         $url . '&justLocalized=' . rawurlencode($table . ':' . $row['uid'] . ':' . $lUid_OnPage)
1827                     );
1828                     $language = BackendUtility::getRecord('sys_language', $lUid_OnPage, 'title');
1829                     if ($this->languageIconTitles[$lUid_OnPage]['flagIcon']) {
1830                         $lC = $this->iconFactory->getIcon($this->languageIconTitles[$lUid_OnPage]['flagIcon'], Icon::SIZE_SMALL)->render();
1831                     } else {
1832                         $lC = $this->languageIconTitles[$lUid_OnPage]['title'];
1833                     }
1834                     $lC = '<a href="' . htmlspecialchars($href) . '" title="'
1835                         . htmlspecialchars($language['title']) . '" class="btn btn-default">' . $lC . '</a> ';
1836                     $lNew .= $lC;
1837                 }
1838             }
1839             if ($lNew) {
1840                 $out[1] .= $lNew;
1841             }
1842         } elseif ($row['l18n_parent']) {
1843             $out[0] = '&nbsp;&nbsp;&nbsp;&nbsp;' . $out[0];
1844         }
1845         return $out;
1846     }
1847
1848     /**
1849      * Creates a checkbox list for selecting fields to display from a table:
1850      *
1851      * @param string $table Table name
1852      * @param bool $formFields If TRUE, form-fields will be wrapped around the table.
1853      * @return string HTML table with the selector check box (name: displayFields['.$table.'][])
1854      */
1855     public function fieldSelectBox($table, $formFields = true)
1856     {
1857         $lang = $this->getLanguageService();
1858         // Init:
1859         $formElements = array('', '');
1860         if ($formFields) {
1861             $formElements = array('<form action="' . htmlspecialchars($this->listURL()) . '" method="post" name="fieldSelectBox">', '</form>');
1862         }
1863         // Load already selected fields, if any:
1864         $setFields = is_array($this->setFields[$table]) ? $this->setFields[$table] : array();
1865         // Request fields from table:
1866         $fields = $this->makeFieldList($table, false, true);
1867         // Add pseudo "control" fields
1868         $fields[] = '_PATH_';
1869         $fields[] = '_REF_';
1870         $fields[] = '_LOCALIZATION_';
1871         $fields[] = '_CONTROL_';
1872         $fields[] = '_CLIPBOARD_';
1873         // Create a checkbox for each field:
1874         $checkboxes = array();
1875         $checkAllChecked = true;
1876         foreach ($fields as $fieldName) {
1877             // Determine, if checkbox should be checked
1878             if (in_array($fieldName, $setFields, true) || $fieldName === $this->fieldArray[0]) {
1879                 $checked = ' checked="checked"';
1880             } else {
1881                 $checkAllChecked = false;
1882                 $checked = '';
1883             }
1884             // Field label
1885             $fieldLabel = is_array($GLOBALS['TCA'][$table]['columns'][$fieldName])
1886                 ? rtrim($lang->sL($GLOBALS['TCA'][$table]['columns'][$fieldName]['label']), ':')
1887                 : '';
1888             $checkboxes[] = '<tr><td class="col-checkbox"><input type="checkbox" id="check-' . $fieldName . '" name="displayFields['
1889                 . $table . '][]" value="' . $fieldName . '" ' . $checked
1890                 . ($fieldName === $this->fieldArray[0] ? ' disabled="disabled"' : '') . '></td><td class="col-title">'
1891                 . '<label class="label-block" for="check-' . $fieldName . '">' . htmlspecialchars($fieldLabel) . ' <span class="text-muted text-monospace">[' . htmlspecialchars($fieldName) . ']</span></label></td></tr>';
1892         }
1893         // Table with the field selector::
1894         $content = $formElements[0] . '
1895                         <input type="hidden" name="displayFields[' . $table . '][]" value="">
1896                         <div class="table-fit table-scrollable">
1897                                 <table border="0" cellpadding="0" cellspacing="0" class="table table-transparent table-hover">
1898                                         <thead>
1899                                                 <tr>
1900                                                         <th class="col-checkbox" colspan="2">
1901                                                                 <input type="checkbox" class="checkbox checkAll" ' . ($checkAllChecked ? ' checked="checked"' : '') . '>
1902                                                         </th>
1903                                                 </tr>
1904                                         </thead>
1905                                         <tbody>
1906                                         ' . implode('', $checkboxes) . '
1907                                         </tbody>
1908                                 </table>
1909                         </div>
1910                         <input type="submit" name="search" class="btn btn-default" value="'
1911             . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.setFields', true) . '"/>
1912                         ' . $formElements[1];
1913         return '<div class="fieldSelectBox">' . $content . '</div>';
1914     }
1915
1916     /*********************************
1917      *
1918      * Helper functions
1919      *
1920      *********************************/
1921     /**
1922      * Creates a link around $string. The link contains an onclick action
1923      * which submits the script with some clipboard action.
1924      * Currently, this is used for setting elements / delete elements.
1925      *
1926      * @param string $string The HTML content to link (image/text)
1927      * @param string $table Table name
1928      * @param string $cmd Clipboard command (eg. "setCB" or "delete")
1929      * @param string $warning Warning text, if any ("delete" uses this for confirmation)
1930      * @return string <a> tag wrapped link.
1931      */
1932     public function linkClipboardHeaderIcon($string, $table, $cmd, $warning = '')
1933     {
1934         $onClickEvent = 'document.dblistForm.cmd.value=' . GeneralUtility::quoteJSvalue($cmd) . ';document.dblistForm.cmd_table.value='
1935             . GeneralUtility::quoteJSvalue($table) . ';document.dblistForm.submit();';
1936         if ($warning) {
1937             $onClickEvent = 'if (confirm(' . GeneralUtility::quoteJSvalue($warning) . ')){' . $onClickEvent . '}';
1938         }
1939         return '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars(($onClickEvent . 'return false;')) . '">' . $string . '</a>';
1940     }
1941
1942     /**
1943      * Returns TRUE if a numeric clipboard pad is selected/active
1944      *
1945      * @return bool
1946      */
1947     public function clipNumPane()
1948     {
1949         return in_array('_CLIPBOARD_', $this->fieldArray) && $this->clipObj->current != 'normal';
1950     }
1951
1952     /**
1953      * Creates a sort-by link on the input string ($code).
1954      * It will automatically detect if sorting should be ascending or descending depending on $this->sortRev.
1955      * Also some fields will not be possible to sort (including if single-table-view is disabled).
1956      *
1957      * @param string $code The string to link (text)
1958      * @param string $field The fieldname represented by the title ($code)
1959      * @param string $table Table name
1960      * @return string Linked $code variable
1961      */
1962     public function addSortLink($code, $field, $table)
1963     {
1964         // Certain circumstances just return string right away (no links):
1965         if ($field == '_CONTROL_' || $field == '_LOCALIZATION_' || $field == '_CLIPBOARD_' || $field == '_REF_' || $this->disableSingleTableView) {
1966             return $code;
1967         }
1968         // If "_PATH_" (showing record path) is selected, force sorting by pid field (will at least group the records!)
1969         if ($field == '_PATH_') {
1970             $field = 'pid';
1971         }
1972         //       Create the sort link:
1973         $sortUrl = $this->listURL('', '-1', 'sortField,sortRev,table,firstElementNumber') . '&table=' . $table
1974             . '&sortField=' . $field . '&sortRev=' . ($this->sortRev || $this->sortField != $field ? 0 : 1);
1975         $sortArrow = $this->sortField === $field
1976             ? $this->iconFactory->getIcon('status-status-sorting-' . ($this->sortRev ? 'desc' : 'asc'), Icon::SIZE_SMALL)->render()
1977             : '';
1978         // Return linked field:
1979         return '<a href="' . htmlspecialchars($sortUrl) . '">' . $code . $sortArrow . '</a>';
1980     }
1981
1982     /**
1983      * Returns the path for a certain pid
1984      * The result is cached internally for the session, thus you can call
1985      * this function as much as you like without performance problems.
1986      *
1987      * @param int $pid The page id for which to get the path
1988      * @return mixed[] The path.
1989      */
1990     public function recPath($pid)
1991     {
1992         if (!isset($this->recPath_cache[$pid])) {
1993             $this->recPath_cache[$pid] = BackendUtility::getRecordPath($pid, $this->perms_clause, 20);
1994         }
1995         return $this->recPath_cache[$pid];
1996     }
1997
1998     /**
1999      * Returns TRUE if a link for creating new records should be displayed for $table
2000      *
2001      * @param string $table Table name
2002      * @return bool Returns TRUE if a link for creating new records should be displayed for $table
2003      * @see \TYPO3\CMS\Backend\Controller\NewRecordController::showNewRecLink
2004      */
2005     public function showNewRecLink($table)
2006     {
2007         // No deny/allow tables are set:
2008         if (empty($this->allowedNewTables) && empty($this->deniedNewTables)) {
2009             return true;
2010         }
2011         return !in_array($table, $this->deniedNewTables)
2012             && (empty($this->allowedNewTables) || in_array($table, $this->allowedNewTables));
2013     }
2014
2015     /**
2016      * Creates the "&returnUrl" parameter for links - this is used when the script links
2017      * to other scripts and passes its own URL with the link so other scripts can return to the listing again.
2018      * Uses REQUEST_URI as value.
2019      *
2020      * @return string
2021      */
2022     public function makeReturnUrl()
2023     {
2024         return '&returnUrl=' . rawurlencode(GeneralUtility::getIndpEnv('REQUEST_URI'));
2025     }
2026
2027     /************************************
2028      *
2029      * CSV related functions
2030      *
2031      ************************************/
2032     /**
2033      * Initializes internal csvLines array with the header of field names
2034      *
2035      * @return void
2036      */
2037     protected function initCSV()
2038     {
2039         $this->addHeaderRowToCSV();
2040     }
2041
2042     /**
2043      * Add header line with field names as CSV line
2044      *
2045      * @return void
2046      */
2047     protected function addHeaderRowToCSV()
2048     {
2049         // Add header row, control fields will be reduced inside addToCSV()
2050         $this->addToCSV(array_combine($this->fieldArray, $this->fieldArray));
2051     }
2052
2053     /**
2054      * Adds selected columns of one table row as CSV line.
2055      *
2056      * @param mixed[] $row Record array, from which the values of fields found in $this->fieldArray will be listed in the CSV output.
2057      * @return void
2058      */
2059     protected function addToCSV(array $row = array())
2060     {
2061         $rowReducedByControlFields = self::removeControlFieldsFromFieldRow($row);
2062         $rowReducedToSelectedColumns = array_intersect_key($rowReducedByControlFields, array_flip($this->fieldArray));
2063         $this->setCsvRow($rowReducedToSelectedColumns);
2064     }
2065
2066     /**
2067      * Remove control fields from row for CSV export
2068      *
2069      * @param mixed[] $row fieldNames => fieldValues
2070      * @return mixed[] Input array reduces by control fields
2071      */
2072     protected static function removeControlFieldsFromFieldRow(array $row = array())
2073     {
2074         // Possible control fields in a list row
2075         $controlFields = array(
2076             '_PATH_',
2077             '_REF_',
2078             '_CONTROL_',
2079             '_CLIPBOARD_',
2080             '_LOCALIZATION_',
2081             '_LOCALIZATION_b'
2082         );
2083         return array_diff_key($row, array_flip($controlFields));
2084     }
2085
2086     /**
2087      * Adds input row of values to the internal csvLines array as a CSV formatted line
2088      *
2089      * @param mixed[] $csvRow Array with values to be listed.
2090      * @return void
2091      */
2092     public function setCsvRow($csvRow)
2093     {
2094         $this->csvLines[] = GeneralUtility::csvValues($csvRow);
2095     }
2096
2097     /**
2098      * Compiles the internal csvLines array to a csv-string and outputs it to the browser.
2099      * This function exits!
2100      *
2101      * @param string $prefix Filename prefix:
2102      * @return void EXITS php execution!
2103      */
2104     public function outputCSV($prefix)
2105     {
2106         // Setting filename:
2107         $filename = $prefix . '_' . date('dmy-Hi') . '.csv';
2108         // Creating output header:
2109         header('Content-Type: application/octet-stream');
2110         header('Content-Disposition: attachment; filename=' . $filename);
2111         // Cache-Control header is needed here to solve an issue with browser IE and
2112         // versions lower than 9. See for more information: http://support.microsoft.com/kb/323308
2113         header("Cache-Control: ''");
2114         // Printing the content of the CSV lines:
2115         echo implode(CRLF, $this->csvLines);
2116         // Exits:
2117         die;
2118     }
2119
2120     /**
2121      * add action into correct section
2122      *
2123      * @param array $cells
2124      * @param string $action
2125      * @param string $actionKey
2126      */
2127     public function addActionToCellGroup(&$cells, $action, $actionKey)
2128     {
2129         $cellsMap = array(
2130             'primary' => array(
2131                 'view', 'edit', 'hide', 'delete', 'stat'
2132             ),
2133             'secondary' => array(
2134                 'viewBig', 'history', 'perms', 'new', 'move', 'moveUp', 'moveDown', 'moveLeft', 'moveRight', 'version'
2135             )
2136         );
2137         $classification = in_array($actionKey, $cellsMap['primary']) ? 'primary' : 'secondary';
2138         $cells[$classification][$actionKey] = $action;
2139         unset($cells[$actionKey]);
2140     }
2141
2142     /**
2143      * Check if the record represents the current backend user
2144      *
2145      * @param string $table
2146      * @param array $row
2147      * @return bool
2148      */
2149     protected function isRecordCurrentBackendUser($table, $row)
2150     {
2151         return $table === 'be_users' && (int)$row['uid'] === $this->getBackendUserAuthentication()->user['uid'];
2152     }
2153
2154     /**
2155      * @param bool $isEditable
2156      */
2157     public function setIsEditable($isEditable)
2158     {
2159         $this->editable = $isEditable;
2160     }
2161
2162     /**
2163      * Check if the table is readonly or editable
2164      * @param string $table
2165      * @return bool
2166      */
2167     public function isEditable($table)
2168     {
2169         return $GLOBALS['TCA'][$table]['ctrl']['readOnly'] || $this->editable;
2170     }
2171
2172     /**
2173      * Check if the current record is locked by editlock. Pages are locked if their editlock flag is set,
2174      * records are if they are locked themselves or if the page they are on is locked (a page’s editlock
2175      * is transitive for its content elements).
2176      *
2177      * @param string $table
2178      * @param array $row
2179      * @param bool $editPermission
2180      * @return bool
2181      */
2182     protected function overlayEditLockPermissions($table, $row = array(), $editPermission = true)
2183     {
2184         if ($editPermission && !$this->getBackendUserAuthentication()->isAdmin()) {
2185             // If no $row is submitted we only check for general edit lock of current page (except for table "pages")
2186             if (empty($row)) {
2187                 return $table === 'pages' ? true : !$this->pageRow['editlock'];
2188             }
2189             if (($table === 'pages' && $row['editlock']) || ($table !== 'pages' && $this->pageRow['editlock'])) {
2190                 $editPermission = false;
2191             } elseif (isset($GLOBALS['TCA'][$table]['ctrl']['editlock']) && $row[$GLOBALS['TCA'][$table]['ctrl']['editlock']]) {
2192                 $editPermission = false;
2193             }
2194         }
2195         return $editPermission;
2196     }
2197
2198     /**
2199      * Check whether or not the current backend user is an admin or the current page is
2200      * locked by editlock.
2201      *
2202      * @return bool
2203      */
2204     protected function editLockPermissions()
2205     {
2206         return $this->getBackendUserAuthentication()->isAdmin() || !$this->pageRow['editlock'];
2207     }
2208
2209     /**
2210      * @return DatabaseConnection
2211      */
2212     protected function getDatabaseConnection()
2213     {
2214         return $GLOBALS['TYPO3_DB'];
2215     }
2216
2217     /**
2218      * @return BaseScriptClass
2219      */
2220     protected function getModule()
2221     {
2222         return $GLOBALS['SOBE'];
2223     }
2224
2225     /**
2226      * @return DocumentTemplate
2227      */
2228     protected function getDocumentTemplate()
2229     {
2230         return $GLOBALS['TBE_TEMPLATE'];
2231     }
2232 }