DatabaseRecordList.php

<?php
namespace TYPO3\CMS\Recordlist\RecordList;

/*
 * This file is part of the TYPO3 CMS project.
 *
 * It is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License, either version 2
 * of the License, or any later version.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 * The TYPO3 project - inspiring people to share!
 */

use TYPO3\CMS\Backend\Module\BaseScriptClass;
use TYPO3\CMS\Backend\RecordList\RecordListGetTableHookInterface;
use TYPO3\CMS\Backend\Template\DocumentTemplate;
use TYPO3\CMS\Core\Database\DatabaseConnection;
use TYPO3\CMS\Core\Imaging\Icon;
use TYPO3\CMS\Core\Imaging\IconFactory;
use TYPO3\CMS\Core\Messaging\FlashMessage;
use TYPO3\CMS\Core\Messaging\FlashMessageService;
use TYPO3\CMS\Core\Type\Bitmask\Permission;
use TYPO3\CMS\Core\Utility\ExtensionManagementUtility;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Backend\Utility\BackendUtility;
use TYPO3\CMS\Backend\Utility\IconUtility;
use TYPO3\CMS\Frontend\Page\PageRepository;

/**
 * Class for rendering of Web>List module
 */
class DatabaseRecordList extends AbstractDatabaseRecordList {

	// *********
	// External:
	// *********

	/**
	 * Used to indicate which tables (values in the array) that can have a
	 * create-new-record link. If the array is empty, all tables are allowed.
	 *
	 * @var string[]
	 */
	public $allowedNewTables = array();

	/**
	 * Used to indicate which tables (values in the array) that cannot have a
	 * create-new-record link. If the array is empty, all tables are allowed.
	 *
	 * @var string[]
	 */
	public $deniedNewTables = array();

	/**
	 * If TRUE, the control panel will contain links to the create-new wizards for
	 * pages and tt_content elements (normally, the link goes to just creatinga new
	 * element without the wizards!).
	 *
	 * @var bool
	 */
	public $newWizards = FALSE;

	/**
	 * If TRUE, will disable the rendering of clipboard + control panels.
	 *
	 * @var bool
	 */
	public $dontShowClipControlPanels = FALSE;

	/**
	 * If TRUE, will show the clipboard in the field list.
	 *
	 * @var bool
	 */
	public $showClipboard = FALSE;

	/**
	 * If TRUE, will DISABLE all control panels in lists. (Takes precedence)
	 *
	 * @var bool
	 */
	public $noControlPanels = FALSE;

	/**
	 * If TRUE, clickmenus will be rendered
	 *
	 * @var bool
	 */
	public $clickMenuEnabled = TRUE;

	/**
	 * Count of record rows in view
	 *
	 * @var int
	 */
	public $totalRowCount;

	/**
	 * Space icon used for alignment
	 *
	 * @var string
	 */
	public $spaceIcon;

	/**
	 * Disable single table view
	 *
	 * @var bool
	 */
	public $disableSingleTableView = FALSE;

	// *********
	// Internal:
	// *********

	/**
	 * Set to the page record (see writeTop())
	 *
	 * @var string[]
	 */
	public $pageRow = array();

	/**
	 * Used to accumulate CSV lines for CSV export.
	 *
	 * @var string[]
	 */
	protected $csvLines = array();

	/**
	 * If set, the listing is returned as CSV instead.
	 *
	 * @var bool
	 */
	public $csvOutput = FALSE;

	/**
	 * Clipboard object
	 *
	 * @var \TYPO3\CMS\Backend\Clipboard\Clipboard
	 */
	public $clipObj;

	/**
	 * Tracking names of elements (for clipboard use)
	 *
	 * @var string[]
	 */
	public $CBnames = array();

	/**
	 * [$tablename][$uid] = number of references to this record
	 *
	 * @var int[][]
	 */
	protected $referenceCount = array();

	/**
	 * Translations of the current record
	 *
	 * @var string[]
	 */
	public $translations;

	/**
	 * select fields for the query which fetches the translations of the current
	 * record
	 *
	 * @var string
	 */
	public $selFieldList;

	/**
	 * @var mixed[]
	 */
	public $pageinfo;

	/**
	 * Injected by RecordList
	 *
	 * @var string[]
	 */
	public $MOD_MENU;

	/**
	 * If defined the records are editable
	 *
	 * @var bool
	 */
	protected $editable = TRUE;

	/**
	 * @var IconFactory
	 */
	protected $iconFactory;

	/**
	 * Constructor
	 */
	public function __construct() {
		parent::__construct();
		$this->iconFactory = GeneralUtility::makeInstance(IconFactory::class);
	}

	/**
	 * Create the panel of buttons for submitting the form or otherwise perform
	 * operations.
	 *
	 * @return string[] All available buttons as an assoc. array
	 */
	public function getButtons() {
		$module = $this->getModule();
		$backendUser = $this->getBackendUserAuthentication();
		$lang = $this->getLanguageService();
		$buttons = array(
			'csh' => '',
			'view' => '',
			'edit' => '',
			'hide_unhide' => '',
			'move' => '',
			'new_record' => '',
			'paste' => '',
			'level_up' => '',
			'cache' => '',
			'reload' => '',
			'shortcut' => '',
			'back' => '',
			'csv' => '',
			'export' => ''
		);
		// Get users permissions for this page record:
		$localCalcPerms = $backendUser->calcPerms($this->pageRow);
		// CSH
		if ((string)$this->id === '') {
			$buttons['csh'] = BackendUtility::cshItem('xMOD_csh_corebe', 'list_module_noId');
		} elseif (!$this->id) {
			$buttons['csh'] = BackendUtility::cshItem('xMOD_csh_corebe', 'list_module_root');
		} else {
			$buttons['csh'] = BackendUtility::cshItem('xMOD_csh_corebe', 'list_module');
		}
		if (isset($this->id)) {
			// View Exclude doktypes 254,255 Configuration:
			// mod.web_list.noViewWithDokTypes = 254,255
			if (isset($module->modTSconfig['properties']['noViewWithDokTypes'])) {
				$noViewDokTypes = GeneralUtility::trimExplode(',', $module->modTSconfig['properties']['noViewWithDokTypes'], TRUE);
			} else {
				//default exclusion: doktype 254 (folder), 255 (recycler)
				$noViewDokTypes = array(
					PageRepository::DOKTYPE_SYSFOLDER,
					PageRepository::DOKTYPE_RECYCLER
				);
			}
			if (!in_array($this->pageRow['doktype'], $noViewDokTypes)) {
				$onClick = htmlspecialchars(BackendUtility::viewOnClick($this->id, '', BackendUtility::BEgetRootLine($this->id)));
				$buttons['view'] = '<a href="#" onclick="' . $onClick . '" title="'
					. $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.showPage', TRUE) . '">'
					. $this->iconFactory->getIcon('actions-document-view', Icon::SIZE_SMALL) . '</a>';
			}
			// New record on pages that are not locked by editlock
			if (!$module->modTSconfig['properties']['noCreateRecordsLink'] && $this->editLockPermissions()) {
				$onClick = htmlspecialchars('return jumpExt(' . GeneralUtility::quoteJSvalue(BackendUtility::getModuleUrl('db_new', ['id' => $this->id])) . ');');
				$buttons['new_record'] = '<a href="#" onclick="' . $onClick . '" title="'
					. $lang->getLL('newRecordGeneral', TRUE) . '">'
					. $this->iconFactory->getIcon('actions-document-new', Icon::SIZE_SMALL) . '</a>';
			}
			// If edit permissions are set, see
			// \TYPO3\CMS\Core\Authentication\BackendUserAuthentication
			if ($localCalcPerms & Permission::PAGE_EDIT && !empty($this->id) && $this->editLockPermissions()) {
				// Edit
				$params = '&edit[pages][' . $this->pageRow['uid'] . ']=edit';
				$onClick = htmlspecialchars(BackendUtility::editOnClick($params, '', -1));
				$buttons['edit'] = '<a href="#" onclick="' . $onClick . '" title="'
					. $lang->getLL('editPage', TRUE) . '">'
					. IconUtility::getSpriteIcon('actions-page-open') . '</a>';
			}
			// Paste
			if (($localCalcPerms & Permission::PAGE_NEW || $localCalcPerms & Permission::CONTENT_EDIT) && $this->editLockPermissions()) {
				$elFromTable = $this->clipObj->elFromTable('');
				if (!empty($elFromTable)) {
					$onClick = htmlspecialchars(('return ' . $this->clipObj->confirmMsg('pages', $this->pageRow, 'into', $elFromTable)));
					$buttons['paste'] = '<a href="' . htmlspecialchars($this->clipObj->pasteUrl('', $this->id))
						. '" onclick="' . $onClick . '" title="' . $lang->getLL('clip_paste', TRUE) . '">'
						. $this->iconFactory->getIcon('actions-document-paste-after', Icon::SIZE_SMALL) . '</a>';
				}
			}
			// Cache
			$buttons['cache'] = '<a href="' . htmlspecialchars(($this->listURL() . '&clear_cache=1')) . '" title="'
				. $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.clear_cache', TRUE) . '">'
				. IconUtility::getSpriteIcon('actions-system-cache-clear') . '</a>';
			if (
				$this->table && (!isset($module->modTSconfig['properties']['noExportRecordsLinks'])
				|| (isset($module->modTSconfig['properties']['noExportRecordsLinks'])
					&& !$module->modTSconfig['properties']['noExportRecordsLinks']))
			) {
				// CSV
				$buttons['csv'] = '<a href="' . htmlspecialchars(($this->listURL() . '&csv=1')) . '" title="'
					. $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.csv', TRUE) . '">'
					. IconUtility::getSpriteIcon('mimetypes-text-csv') . '</a>';
				// Export
				if (ExtensionManagementUtility::isLoaded('impexp')) {
					$url = BackendUtility::getModuleUrl('xMOD_tximpexp', array('tx_impexp[action]' => 'export'));
					$buttons['export'] = '<a href="' . htmlspecialchars($url . '&tx_impexp[list][]='
							. rawurlencode($this->table . ':' . $this->id)) . '" title="'
						. $lang->sL('LLL:EXT:lang/locallang_core.xlf:rm.export', TRUE) . '">'
						. $this->iconFactory->getIcon('actions-document-export-t3d', Icon::SIZE_SMALL) . '</a>';
				}
			}
			// Reload
			$buttons['reload'] = '<a href="' . htmlspecialchars($this->listURL()) . '" title="'
				. $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.reload', TRUE) . '">'
				. IconUtility::getSpriteIcon('actions-system-refresh') . '</a>';
			// Shortcut
			if ($backendUser->mayMakeShortcut()) {
				$buttons['shortcut'] = $this->getDocumentTemplate()->makeShortcutIcon(
					'id, imagemode, pointer, table, search_field, search_levels, showLimit, sortField, sortRev',
					implode(',', array_keys($this->MOD_MENU)),
					'web_list'
				);
			}
			// Back
			if ($this->returnUrl) {
				$href = htmlspecialchars(GeneralUtility::linkThisUrl($this->returnUrl, array('id' => $this->id)));
				$buttons['back'] = '<a href="' . $href . '" class="typo3-goBack" title="'
					. $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.goBack', TRUE) . '">'
					. IconUtility::getSpriteIcon('actions-view-go-back') . '</a>';
			}
		}
		return $buttons;
	}

	/**
	 * Creates the listing of records from a single table
	 *
	 * @param string $table Table name
	 * @param int $id Page id
	 * @param string $rowList List of fields to show in the listing. Pseudo fields will be added including the record header.
	 * @throws \UnexpectedValueException
	 * @return string HTML table with the listing for the record.
	 */
	public function getTable($table, $id, $rowList = '') {
		$rowListArray = GeneralUtility::trimExplode(',', $rowList, TRUE);
		// if no columns have been specified, show description (if configured)
		if (!empty($GLOBALS['TCA'][$table]['ctrl']['descriptionColumn']) && empty($rowListArray)) {
			array_push($rowListArray, $GLOBALS['TCA'][$table]['ctrl']['descriptionColumn']);
		}
		$backendUser = $this->getBackendUserAuthentication();
		$lang = $this->getLanguageService();
		$db = $this->getDatabaseConnection();
		// Init
		$addWhere = '';
		$titleCol = $GLOBALS['TCA'][$table]['ctrl']['label'];
		$thumbsCol = $GLOBALS['TCA'][$table]['ctrl']['thumbnail'];
		$l10nEnabled = $GLOBALS['TCA'][$table]['ctrl']['languageField']
			&& $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']
			&& !$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerTable'];
		$tableCollapsed = (bool)$this->tablesCollapsed[$table];
		// prepare space icon
		$this->spaceIcon = '<span class="btn btn-default disabled">' . IconUtility::getSpriteIcon('empty-empty') . '</span>';
		// Cleaning rowlist for duplicates and place the $titleCol as the first column always!
		$this->fieldArray = array();
		// title Column
		// Add title column
		$this->fieldArray[] = $titleCol;
		// Control-Panel
		if (!GeneralUtility::inList($rowList, '_CONTROL_')) {
			$this->fieldArray[] = '_CONTROL_';
		}
		// Clipboard
		if ($this->showClipboard) {
			$this->fieldArray[] = '_CLIPBOARD_';
		}
		// Ref
		if (!$this->dontShowClipControlPanels) {
			$this->fieldArray[] = '_REF_';
		}
		// Path
		if ($this->searchLevels) {
			$this->fieldArray[] = '_PATH_';
		}
		// Localization
		if ($this->localizationView && $l10nEnabled) {
			$this->fieldArray[] = '_LOCALIZATION_';
			$this->fieldArray[] = '_LOCALIZATION_b';
			$addWhere .= ' AND (
				' . $GLOBALS['TCA'][$table]['ctrl']['languageField'] . '<=0
				OR
				' . $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'] . ' = 0
			)';
		}
		// Cleaning up:
		$this->fieldArray = array_unique(array_merge($this->fieldArray, $rowListArray));
		if ($this->noControlPanels) {
			$tempArray = array_flip($this->fieldArray);
			unset($tempArray['_CONTROL_']);
			unset($tempArray['_CLIPBOARD_']);
			$this->fieldArray = array_keys($tempArray);
		}
		// Creating the list of fields to include in the SQL query:
		$selectFields = $this->fieldArray;
		$selectFields[] = 'uid';
		$selectFields[] = 'pid';
		// adding column for thumbnails
		if ($thumbsCol) {
			$selectFields[] = $thumbsCol;
		}
		if ($table == 'pages') {
			$selectFields[] = 'module';
			$selectFields[] = 'extendToSubpages';
			$selectFields[] = 'nav_hide';
			$selectFields[] = 'doktype';
			$selectFields[] = 'shortcut';
			$selectFields[] = 'shortcut_mode';
			$selectFields[] = 'mount_pid';
		}
		if (is_array($GLOBALS['TCA'][$table]['ctrl']['enablecolumns'])) {
			$selectFields = array_merge($selectFields, $GLOBALS['TCA'][$table]['ctrl']['enablecolumns']);
		}
		foreach(array('type', 'typeicon_column', 'editlock') as $field) {
			if ($GLOBALS['TCA'][$table]['ctrl'][$field]) {
				$selectFields[] = $GLOBALS['TCA'][$table]['ctrl'][$field];
			}
		}
		if ($GLOBALS['TCA'][$table]['ctrl']['versioningWS']) {
			$selectFields[] = 't3ver_id';
			$selectFields[] = 't3ver_state';
			$selectFields[] = 't3ver_wsid';
		}
		if ($l10nEnabled) {
			$selectFields[] = $GLOBALS['TCA'][$table]['ctrl']['languageField'];
			$selectFields[] = $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'];
		}
		if ($GLOBALS['TCA'][$table]['ctrl']['label_alt']) {
			$selectFields = array_merge(
				$selectFields,
				GeneralUtility::trimExplode(',', $GLOBALS['TCA'][$table]['ctrl']['label_alt'], TRUE)
			);
		}
		// Unique list!
		$selectFields = array_unique($selectFields);
		$fieldListFields = $this->makeFieldList($table, 1);
		if (empty($fieldListFields) && $GLOBALS['TYPO3_CONF_VARS']['BE']['debug']) {
			$message = sprintf($lang->sL('LLL:EXT:lang/locallang_mod_web_list.xlf:missingTcaColumnsMessage', TRUE), $table, $table);
			$messageTitle = $lang->sL('LLL:EXT:lang/locallang_mod_web_list.xlf:missingTcaColumnsMessageTitle', TRUE);
			/** @var FlashMessage $flashMessage */
			$flashMessage = GeneralUtility::makeInstance(
				FlashMessage::class,
				$message,
				$messageTitle,
				FlashMessage::WARNING,
				TRUE
			);
			/** @var $flashMessageService FlashMessageService */
			$flashMessageService = GeneralUtility::makeInstance(FlashMessageService::class);
			/** @var $defaultFlashMessageQueue \TYPO3\CMS\Core\Messaging\FlashMessageQueue */
			$defaultFlashMessageQueue = $flashMessageService->getMessageQueueByIdentifier();
			$defaultFlashMessageQueue->enqueue($flashMessage);
		}
		// Making sure that the fields in the field-list ARE in the field-list from TCA!
		$selectFields = array_intersect($selectFields, $fieldListFields);
		// Implode it into a list of fields for the SQL-statement.
		$selFieldList = implode(',', $selectFields);
		$this->selFieldList = $selFieldList;
		if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['getTable'])) {
			foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['getTable'] as $classData) {
				$hookObject = GeneralUtility::getUserObj($classData);
				if (!$hookObject instanceof RecordListGetTableHookInterface) {
					throw new \UnexpectedValueException('$hookObject must implement interface ' . RecordListGetTableHookInterface::class, 1195114460);
				}
				$hookObject->getDBlistQuery($table, $id, $addWhere, $selFieldList, $this);
			}
		}
		// Create the SQL query for selecting the elements in the listing:
		// do not do paging when outputting as CSV
		if ($this->csvOutput) {
			$this->iLimit = 0;
		}
		if ($this->firstElementNumber > 2 && $this->iLimit > 0) {
			// Get the two previous rows for sorting if displaying page > 1
			$this->firstElementNumber = $this->firstElementNumber - 2;
			$this->iLimit = $this->iLimit + 2;
			// (API function from TYPO3\CMS\Recordlist\RecordList\AbstractDatabaseRecordList)
			$queryParts = $this->makeQueryArray($table, $id, $addWhere, $selFieldList);
			$this->firstElementNumber = $this->firstElementNumber + 2;
			$this->iLimit = $this->iLimit - 2;
		} else {
			// (API function from TYPO3\CMS\Recordlist\RecordList\AbstractDatabaseRecordList)
			$queryParts = $this->makeQueryArray($table, $id, $addWhere, $selFieldList);
		}

		// Finding the total amount of records on the page
		// (API function from TYPO3\CMS\Recordlist\RecordList\AbstractDatabaseRecordList)
		$this->setTotalItems($queryParts);

		// Init:
		$dbCount = 0;
		$out = '';
		$tableHeader = '';
		$result = NULL;
		$listOnlyInSingleTableMode = $this->listOnlyInSingleTableMode && !$this->table;
		// If the count query returned any number of records, we perform the real query,
		// selecting records.
		if ($this->totalItems) {
			// Fetch records only if not in single table mode
			if ($listOnlyInSingleTableMode) {
				$dbCount = $this->totalItems;
			} else {
				// Set the showLimit to the number of records when outputting as CSV
				if ($this->csvOutput) {
					$this->showLimit = $this->totalItems;
					$this->iLimit = $this->totalItems;
				}
				$result = $db->exec_SELECT_queryArray($queryParts);
				$dbCount = $db->sql_num_rows($result);
			}
		}
		// If any records was selected, render the list:
		if ($dbCount) {
			$tableTitle = $lang->sL($GLOBALS['TCA'][$table]['ctrl']['title'], TRUE);
			if ($tableTitle === '') {
				$tableTitle = $table;
			}
			// Header line is drawn
			$theData = array();
			if ($this->disableSingleTableView) {
				$theData[$titleCol] = '<span class="c-table">' . BackendUtility::wrapInHelp($table, '', $tableTitle)
					. '</span> (<span class="t3js-table-total-items">' . $this->totalItems . '</span>)';
			} else {
				$icon = $this->table
					? IconUtility::getSpriteIcon('actions-view-table-collapse', array('title' => $lang->getLL('contractView', TRUE)))
					: IconUtility::getSpriteIcon('actions-view-table-expand', array('title' => $lang->getLL('expandView', TRUE)));
				$theData[$titleCol] = $this->linkWrapTable($table, $tableTitle . ' (<span class="t3js-table-total-items">' . $this->totalItems . '</span>) ' . $icon);
			}
			if ($listOnlyInSingleTableMode) {
				$tableHeader .= BackendUtility::wrapInHelp($table, '', $theData[$titleCol]);
			} else {
				// Render collapse button if in multi table mode
				$collapseIcon = '';
				if (!$this->table) {
					$href = htmlspecialchars(($this->listURL() . '&collapse[' . $table . ']=' . ($tableCollapsed ? '0' : '1')));
					$title = $tableCollapsed
						? $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.expandTable', TRUE)
						: $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels.collapseTable', TRUE);
					$icon = $tableCollapsed
						? IconUtility::getSpriteIcon('actions-view-list-expand', array('class' => 'collapseIcon'))
						: IconUtility::getSpriteIcon('actions-view-list-collapse', array('class' => 'collapseIcon'));
					$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>';
				}
				$tableHeader .= $theData[$titleCol] . $collapseIcon;
			}
			// Render table rows only if in multi table view or if in single table view
			$rowOutput = '';
			if (!$listOnlyInSingleTableMode || $this->table) {
				// Fixing an order table for sortby tables
				$this->currentTable = array();
				$currentIdList = array();
				$doSort = $GLOBALS['TCA'][$table]['ctrl']['sortby'] && !$this->sortField;
				$prevUid = 0;
				$prevPrevUid = 0;
				// Get first two rows and initialize prevPrevUid and prevUid if on page > 1
				if ($this->firstElementNumber > 2 && $this->iLimit > 0) {
					$row = $db->sql_fetch_assoc($result);
					$prevPrevUid = -((int)$row['uid']);
					$row = $db->sql_fetch_assoc($result);
					$prevUid = $row['uid'];
				}
				$accRows = array();
				// Accumulate rows here
				while ($row = $db->sql_fetch_assoc($result)) {
					if (!$this->isRowListingConditionFulfilled($table, $row)) {
						continue;
					}
					// In offline workspace, look for alternative record:
					BackendUtility::workspaceOL($table, $row, $backendUser->workspace, TRUE);
					if (is_array($row)) {
						$accRows[] = $row;
						$currentIdList[] = $row['uid'];
						if ($doSort) {
							if ($prevUid) {
								$this->currentTable['prev'][$row['uid']] = $prevPrevUid;
								$this->currentTable['next'][$prevUid] = '-' . $row['uid'];
								$this->currentTable['prevUid'][$row['uid']] = $prevUid;
							}
							$prevPrevUid = isset($this->currentTable['prev'][$row['uid']]) ? -$prevUid : $row['pid'];
							$prevUid = $row['uid'];
						}
					}
				}
				$db->sql_free_result($result);
				$this->totalRowCount = count($accRows);
				// CSV initiated
				if ($this->csvOutput) {
					$this->initCSV();
				}
				// Render items:
				$this->CBnames = array();
				$this->duplicateStack = array();
				$this->eCounter = $this->firstElementNumber;
				$cc = 0;
				foreach ($accRows as $row) {
					// Render item row if counter < limit
					if ($cc < $this->iLimit) {
						$cc++;
						$this->translations = FALSE;
						$rowOutput .= $this->renderListRow($table, $row, $cc, $titleCol, $thumbsCol);
						// If localization view is enabled it means that the selected records are
						// either default or All language and here we will not select translations
						// which point to the main record:
						if ($this->localizationView && $l10nEnabled) {
							// For each available translation, render the record:
							if (is_array($this->translations)) {
								foreach ($this->translations as $lRow) {
									// $lRow isn't always what we want - if record was moved we've to work with the
									// placeholder records otherwise the list is messed up a bit
									if ($row['_MOVE_PLH_uid'] && $row['_MOVE_PLH_pid']) {
										$where = 't3ver_move_id="' . (int)$lRow['uid'] . '" AND pid="' . $row['_MOVE_PLH_pid']
											. '" AND t3ver_wsid=' . $row['t3ver_wsid'] . BackendUtility::deleteClause($table);
										$tmpRow = BackendUtility::getRecordRaw($table, $where, $selFieldList);
										$lRow = is_array($tmpRow) ? $tmpRow : $lRow;
									}
									// In offline workspace, look for alternative record:
									BackendUtility::workspaceOL($table, $lRow, $backendUser->workspace, TRUE);
									if (is_array($lRow) && $backendUser->checkLanguageAccess($lRow[$GLOBALS['TCA'][$table]['ctrl']['languageField']])) {
										$currentIdList[] = $lRow['uid'];
										$rowOutput .= $this->renderListRow($table, $lRow, $cc, $titleCol, $thumbsCol, 18);
									}
								}
							}
						}
					}
					// Counter of total rows incremented:
					$this->eCounter++;
				}
				// Record navigation is added to the beginning and end of the table if in single
				// table mode
				if ($this->table) {
					$rowOutput = $this->renderListNavigation('top') . $rowOutput . $this->renderListNavigation('bottom');
				} else {
					// Show that there are more records than shown
					if ($this->totalItems > $this->itemsLimitPerTable) {
						$countOnFirstPage = $this->totalItems > $this->itemsLimitSingleTable ? $this->itemsLimitSingleTable : $this->totalItems;
						$hasMore = $this->totalItems > $this->itemsLimitSingleTable;
						$colspan = $this->showIcon ? count($this->fieldArray) + 1 : count($this->fieldArray);
						$rowOutput .= '<tr><td colspan="' . $colspan . '">
								<a href="' . htmlspecialchars(($this->listURL() . '&table=' . rawurlencode($table))) . '" class="btn btn-default">'
							. '<span class="t3-icon fa fa-chevron-down"></span> <i>[1 - ' . $countOnFirstPage . ($hasMore ? '+' : '') . ']</i></a>
								</td></tr>';
					}
				}
				// The header row for the table is now created:
				$out .= $this->renderListHeader($table, $currentIdList);
			}

			$collapseClass = $tableCollapsed && !$this->table ? 'collapse' : 'collapse in';
			$dataState = $tableCollapsed && !$this->table ? 'collapsed' : 'expanded';

			// The list of records is added after the header:
			$out .= $rowOutput;
			// ... and it is all wrapped in a table:
			$out = '



			<!--
				DB listing of elements:	"' . htmlspecialchars($table) . '"
			-->
				<div class="panel panel-space panel-default">
					<div class="panel-heading">
					' . $tableHeader . '
					</div>
					<div class="table-fit ' . $collapseClass . '" id="recordlist-' . htmlspecialchars($table) . '" data-state="' . $dataState . '">
						<table data-table="' . htmlspecialchars($table) . '" class="table table-striped table-hover' . ($listOnlyInSingleTableMode ? ' typo3-dblist-overview' : '') . '">
							' . $out . '
						</table>
					</div>
				</div>
			';
			// Output csv if...
			// This ends the page with exit.
			if ($this->csvOutput) {
				$this->outputCSV($table);
			}
		}
		// Return content:
		return $out;
	}

	/**
	 * Check if all row listing conditions are fulfilled.
	 *
	 * This function serves as a dummy method to be overriden in extending classes.
	 *
	 * @param string $table Table name
	 * @param string[] $row Record
	 * @return bool True, if all conditions are fulfilled.
	 */
	protected function isRowListingConditionFulfilled($table, $row) {
		return TRUE;
	}

	/**
	 * Rendering a single row for the list
	 *
	 * @param string $table Table name
	 * @param mixed[] $row Current record
	 * @param int $cc Counter, counting for each time an element is rendered (used for alternating colors)
	 * @param string $titleCol Table field (column) where header value is found
	 * @param string $thumbsCol Table field (column) where (possible) thumbnails can be found
	 * @param int $indent Indent from left.
	 * @return string Table row for the element
	 * @access private
	 * @see getTable()
	 */
	public function renderListRow($table, $row, $cc, $titleCol, $thumbsCol, $indent = 0) {
		if (!is_array($row)) {
			return '';
		}
		$rowOutput = '';
		$id_orig = NULL;
		// If in search mode, make sure the preview will show the correct page
		if ((string)$this->searchString !== '') {
			$id_orig = $this->id;
			$this->id = $row['pid'];
		}
		// Add special classes for first and last row
		$rowSpecial = '';
		if ($cc == 1 && $indent == 0) {
			$rowSpecial .= ' firstcol';
		}
		if ($cc == $this->totalRowCount || $cc == $this->iLimit) {
			$rowSpecial .= ' lastcol';
		}

		$row_bgColor = ' class="' . $rowSpecial . '"';

		// Overriding with versions background color if any:
		$row_bgColor = $row['_CSSCLASS'] ? ' class="' . $row['_CSSCLASS'] . '"' : $row_bgColor;
		// Incr. counter.
		$this->counter++;
		// The icon with link
		$altText = htmlspecialchars(BackendUtility::getRecordIconAltText($row, $table));
		$iconImg = IconUtility::getSpriteIconForRecord(
			$table,
			$row,
			array('title' => $altText, 'style' => $indent ? ' margin-left: ' . $indent . 'px;' : '')
		);
		$theIcon = $this->clickMenuEnabled ? $this->getModule()->doc->wrapClickMenuOnIcon($iconImg, $table, $row['uid']) : $iconImg;
		// Preparing and getting the data-array
		$theData = array();
		$localizationMarkerClass = '';
		foreach ($this->fieldArray as $fCol) {
			if ($fCol == $titleCol) {
				$recTitle = BackendUtility::getRecordTitle($table, $row, FALSE, TRUE);
				$warning = '';
				// If the record is edit-locked	by another user, we will show a little warning sign:
				$lockInfo = BackendUtility::isRecordLocked($table, $row['uid']);
				if ($lockInfo) {
					$warning = '<a href="#" onclick="alert('
						. GeneralUtility::quoteJSvalue($lockInfo['msg']) . '); return false;" title="'
						. htmlspecialchars($lockInfo['msg']) . '">'
						. IconUtility::getSpriteIcon('status-warning-in-use') . '</a>';
				}
				$theData[$fCol] = $theData['__label'] = $warning . $this->linkWrapItems($table, $row['uid'], $recTitle, $row);
				// Render thumbnails, if:
				// - a thumbnail column exists
				// - there is content in it
				// - the thumbnail column is visible for the current type
				$type = 0;
				if (isset($GLOBALS['TCA'][$table]['ctrl']['type'])) {
					$typeColumn = $GLOBALS['TCA'][$table]['ctrl']['type'];
					$type = $row[$typeColumn];
				}
				// If current type doesn't exist, set it to 0 (or to 1 for historical reasons,
				// if 0 doesn't exist)
				if (!isset($GLOBALS['TCA'][$table]['types'][$type])) {
					$type = isset($GLOBALS['TCA'][$table]['types'][0]) ? 0 : 1;
				}
				$visibleColumns = $GLOBALS['TCA'][$table]['types'][$type]['showitem'];

				if ($this->thumbs &&
					trim($row[$thumbsCol]) &&
					preg_match('/(^|(.*(;|,)?))' . $thumbsCol . '(((;|,).*)|$)/', $visibleColumns) === 1
				) {
					$theData[$fCol] .= '<br />' . $this->thumbCode($row, $table, $thumbsCol);
				}
				if (
					isset($GLOBALS['TCA'][$table]['ctrl']['languageField'])
					&& $row[$GLOBALS['TCA'][$table]['ctrl']['languageField']] != 0
					&& $row[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']] != 0
				) {
					// It's a translated record with a language parent
					$localizationMarkerClass = ' localization';
				}
			} elseif ($fCol == 'pid') {
				$theData[$fCol] = $row[$fCol];
			} elseif ($fCol == '_PATH_') {
				$theData[$fCol] = $this->recPath($row['pid']);
			} elseif ($fCol == '_REF_') {
				$theData[$fCol] = $this->createReferenceHtml($table, $row['uid']);
			} elseif ($fCol == '_CONTROL_') {
				$theData[$fCol] = $this->makeControl($table, $row);
			} elseif ($fCol == '_CLIPBOARD_') {
				$theData[$fCol] = $this->makeClip($table, $row);
			} elseif ($fCol == '_LOCALIZATION_') {
				list($lC1, $lC2) = $this->makeLocalizationPanel($table, $row);
				$theData[$fCol] = $lC1;
				$theData[$fCol . 'b'] = $lC2;
			} elseif ($fCol == '_LOCALIZATION_b') {
				// deliberately empty
			} else {
				$pageId = $table === 'pages' ? $row['uid'] : $row['pid'];
				$tmpProc = BackendUtility::getProcessedValueExtra($table, $fCol, $row[$fCol], 100, $row['uid'], TRUE, $pageId);
				$theData[$fCol] = $this->linkUrlMail(htmlspecialchars($tmpProc), $row[$fCol]);
				if ($this->csvOutput) {
					$row[$fCol] = BackendUtility::getProcessedValueExtra($table, $fCol, $row[$fCol], 0, $row['uid']);
				}
			}
		}
		// Reset the ID if it was overwritten
		if ((string)$this->searchString !== '') {
			$this->id = $id_orig;
		}
		// Add row to CSV list:
		if ($this->csvOutput) {
			$this->addToCSV($row, $table);
		}
		// Add classes to table cells
		$this->addElement_tdCssClass[$titleCol] = 'col-title' . $localizationMarkerClass;
		$this->addElement_tdCssClass['_CONTROL_'] = 'col-control';
		if ($this->getModule()->MOD_SETTINGS['clipBoard']) {
			$this->addElement_tdCssClass['_CLIPBOARD_'] = 'col-clipboard';
		}
		$this->addElement_tdCssClass['_PATH_'] = 'col-path';
		$this->addElement_tdCssClass['_LOCALIZATION_'] = 'col-localizationa';
		$this->addElement_tdCssClass['_LOCALIZATION_b'] = 'col-localizationb';
		// Create element in table cells:
		$theData['uid'] = $row['uid'];
		if (
			isset($GLOBALS['TCA'][$table]['ctrl']['languageField'])
			&& isset($GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'])
			&& !isset($GLOBALS['TCA'][$table]['ctrl']['transOrigPointerTable'])
		) {
			$theData['parent'] = $row[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']];
		}
		$rowOutput .= $this->addelement(1, $theIcon, $theData, $row_bgColor);
		// Finally, return table row element:
		return $rowOutput;
	}

	/**
	 * Gets the number of records referencing the record with the UID $uid in
	 * the table $tableName.
	 *
	 * @param string $tableName
	 * @param int $uid
	 * @return int The number of references to record $uid in table
	 */
	protected function getReferenceCount($tableName, $uid) {
		$db = $this->getDatabaseConnection();
		if (!isset($this->referenceCount[$tableName][$uid])) {
			$where = 'ref_table = ' . $db->fullQuoteStr($tableName, 'sys_refindex')
				. ' AND ref_uid = ' . $uid . ' AND deleted = 0';
			$numberOfReferences = $db->exec_SELECTcountRows('*', 'sys_refindex', $where);
			$this->referenceCount[$tableName][$uid] = $numberOfReferences;
		}
		return $this->referenceCount[$tableName][$uid];
	}

	/**
	 * Rendering the header row for a table
	 *
	 * @param string $table Table name
	 * @param int[] $currentIdList Array of the currently displayed uids of the table
	 * @throws \UnexpectedValueException
	 * @return string Header table row
	 * @access private
	 * @see getTable()
	 */
	public function renderListHeader($table, $currentIdList) {
		$lang = $this->getLanguageService();
		// Init:
		$theData = array();
		$icon = '';
		// Traverse the fields:
		foreach ($this->fieldArray as $fCol) {
			// Calculate users permissions to edit records in the table:
			$permsEdit = $this->calcPerms & ($table == 'pages' ? 2 : 16) && $this->overlayEditLockPermissions($table);
			switch ((string)$fCol) {
				case '_PATH_':
					// Path
					$theData[$fCol] = '<i>[' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels._PATH_', TRUE) . ']</i>';
					break;
				case '_REF_':
					// References
					$theData[$fCol] = '<i>[' . $lang->sL('LLL:EXT:lang/locallang_mod_file_list.xlf:c__REF_', TRUE) . ']</i>';
					break;
				case '_LOCALIZATION_':
					// Path
					$theData[$fCol] = '<i>[' . $lang->sL('LLL:EXT:lang/locallang_core.xlf:labels._LOCALIZATION_', TRUE) . ']</i>';
					break;
				case '_LOCALIZATION_b':
					// Path
					$theData[$fCol] = $lang->getLL('Localize', TRUE);
					break;
				case '_CLIPBOARD_':
					if (!$this->getModule()->MOD_SETTINGS['clipBoard']) {
						break;
					}
					// Clipboard:
					$cells = array();
					// If there are elements on the clipboard for this table, and the parent page is not locked by editlock
					// then display the "paste into" icon:
					$elFromTable = $this->clipObj->elFromTable($table);
					if (!empty($elFromTable) && $this->overlayEditLockPermissions($table)) {
						$href = htmlspecialchars($this->clipObj->pasteUrl($table, $this->id));
						$onClick = htmlspecialchars('return ' . $this->clipObj->confirmMsg('pages', $this->pageRow, 'into', $elFromTable));
						$cells['pasteAfter'] = '<a class="btn btn-default" href="' . $href . '" onclick="' . $onClick
							. '" title="' . $lang->getLL('clip_paste', TRUE) . '">'
							. $this->iconFactory->getIcon('actions-document-paste-after', Icon::SIZE_SMALL) . '</a>';
					}
					// If the numeric clipboard pads are enabled, display the control icons for that:
					if ($this->clipObj->current != 'normal') {
						// The "select" link:
						$spriteIcon = IconUtility::getSpriteIcon('actions-edit-copy', array('title' => $lang->getLL('clip_selectMarked', TRUE)));
						$cells['copyMarked'] = $this->linkClipboardHeaderIcon($spriteIcon, $table, 'setCB');
						// The "edit marked" link:
						$editIdList = implode(',', $currentIdList);
						$editIdList = '\'+editList(\'' . $table . '\',\'' . $editIdList . '\')+\'';
						$params = 'edit[' . $table . '][' . $editIdList . ']=edit';
						$onClick = BackendUtility::editOnClick('', '', -1);
						$onClickArray = explode('?', $onClick, 2);
						$lastElement = array_pop($onClickArray);
						array_push($onClickArray, $params . '&' . $lastElement);
						$onClick = implode('?', $onClickArray);
						$cells['edit'] = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick) . '" title="'
							. $lang->getLL('clip_editMarked', TRUE) . '">'
							. IconUtility::getSpriteIcon('actions-document-open') . '</a>';
						// The "Delete marked" link:
						$cells['delete'] = $this->linkClipboardHeaderIcon(
							IconUtility::getSpriteIcon('actions-edit-delete', array('title' => $lang->getLL('clip_deleteMarked', TRUE))),
							$table,
							'delete',
							sprintf($lang->getLL('clip_deleteMarkedWarning'), $lang->sL($GLOBALS['TCA'][$table]['ctrl']['title']))
						);
						// The "Select all" link:
						$onClick = htmlspecialchars(('checkOffCB(\'' . implode(',', $this->CBnames) . '\', this); return false;'));
						$cells['markAll'] = '<a class="btn btn-default" rel="" href="#" onclick="' . $onClick . '" title="'
							. $lang->getLL('clip_markRecords', TRUE) . '">'
							. $this->iconFactory->getIcon('actions-document-select', Icon::SIZE_SMALL) . '</a>';
					} else {
						$cells['empty'] = '';
					}
					/**
					 * @hook renderListHeaderActions: Allows to change the clipboard icons of the Web>List table headers
					 * @usage Above each listed table in Web>List a header row is shown.
					 *        This hook allows to modify the icons responsible for the clipboard functions
					 *        (shown above the clipboard checkboxes when a clipboard other than "Normal" is selected),
					 *        or other "Action" functions which perform operations on the listed records.
					*/
					if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'])) {
						foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'] as $classData) {
							$hookObject = GeneralUtility::getUserObj($classData);
							if (!$hookObject instanceof RecordListHookInterface) {
								throw new \UnexpectedValueException('$hookObject must implement interface ' . RecordListHookInterface::class, 1195567850);
							}
							$cells = $hookObject->renderListHeaderActions($table, $currentIdList, $cells, $this);
						}
					}
					$theData[$fCol] = '<div class="btn-group" role="group">' . implode('', $cells) . '</div>';
					break;
				case '_CONTROL_':
					// Control panel:
					if ($this->isEditable($table)) {
						// If new records can be created on this page, add links:
						$permsAdditional = ($table === 'pages' ? 8 : 16);
						if ($this->calcPerms & $permsAdditional && $this->showNewRecLink($table)) {
							$spriteIcon = $table === 'pages'
								? IconUtility::getSpriteIcon('actions-page-new')
								: IconUtility::getSpriteIcon('actions-document-new');
							if ($table === 'tt_content' && $this->newWizards) {
								// If mod.web_list.newContentWiz.overrideWithExtension is set, use that extension's create new content wizard instead:
								$tmpTSc = BackendUtility::getModTSconfig($this->pageinfo['uid'], 'mod.web_list');
								$tmpTSc = $tmpTSc['properties']['newContentWiz.']['overrideWithExtension'];
								$newContentWizScriptPath = ExtensionManagementUtility::isLoaded($tmpTSc)
									? ExtensionManagementUtility::extRelPath($tmpTSc) . 'mod1/db_new_content_el.php?id=' . $this->id
									: BackendUtility::getModuleUrl('new_content_element', array('id' => $this->id));

								$onClick = 'return jumpExt(' . GeneralUtility::quoteJSvalue($newContentWizScriptPath) . ');';
								$icon = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars($onClick) . '" title="'
									. $lang->getLL('new', TRUE) . '">' . $spriteIcon . '</a>';
							} elseif ($table == 'pages' && $this->newWizards) {
								$parameters = ['id' => $this->id, 'pagesOnly' => 1, 'returnUrl' => GeneralUtility::getIndpEnv('REQUEST_URI')];
								$href = BackendUtility::getModuleUrl('db_new', $parameters);
								$icon = '<a class="btn btn-default" href="' . htmlspecialchars($href) . '" title="' . $lang->getLL('new', TRUE) . '">'
									. $spriteIcon . '</a>';
							} else {
								$params = '&edit[' . $table . '][' . $this->id . ']=new';
								if ($table == 'pages_language_overlay') {
									$params .= '&overrideVals[pages_language_overlay][doktype]=' . (int)$this->pageRow['doktype'];
								}
								$icon = '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars(BackendUtility::editOnClick($params, '', -1))
									. '" title="' . $lang->getLL('new', TRUE) . '">' . $spriteIcon . '</a>';
							}
						}
						// If the table can be edited, add link for editing ALL SHOWN fields for all listed records:
						if ($permsEdit && $this->table && is_array($currentIdList)) {
							$editIdList = implode(',', $currentIdList);
							if ($this->clipNumPane()) {
								$editIdList = '\'+editList(\'' . $table . '\',\'' . $editIdList . '\')+\'';
							}
							$params = '&edit[' . $table . '][' . $editIdList . ']=edit&columnsOnly=' . implode(',', $this->fieldArray);
							$icon .= '<a class="btn btn-default" href="#" onclick="' . htmlspecialchars(BackendUtility::editOnClick($params, '', -1))
								. '" title="' . $lang->getLL('editShownColumns', TRUE) . '">'
								. IconUtility::getSpriteIcon('actions-document-open') . '</a>';
							$icon = '<div class="btn-group" role="group">' . $icon . '</div>';
						}
						// Add an empty entry, so column count fits again after moving this into $icon
						$theData[$fCol] = '&nbsp;';