getQueryBuilder($table, ['*'], false, 0, 1);
// @todo Switch to `resetOrderBy()` as soon as the QueryBuilder facade has that method on board.
$queryBuilderTotalItems->resetQueryPart('orderBy');
$totalItems = (int)$queryBuilderTotalItems
->count('*')
->executeQuery()
->fetchOne();
if ($totalItems === 0) {
return '';
}
// Setting the limits for the amount of records to be displayed in the list and single table view.
// Using the default value and overwriting with page TSconfig and TCA config. The limit is forced
// to be in the range of 0 - 10000.
// default 100 for single table view
$itemsLimitSingleTable = MathUtility::forceIntegerInRange((int)(
$GLOBALS['TCA'][$table]['interface']['maxSingleDBListItems'] ??
$this->modTSconfig['itemsLimitSingleTable'] ??
100
), 0, 10000);
// default 20 for list view
$itemsLimitPerTable = MathUtility::forceIntegerInRange((int)(
$GLOBALS['TCA'][$table]['interface']['maxDBListItems'] ??
$this->modTSconfig['itemsLimitPerTable'] ??
20
), 0, 10000);
// Set limit depending on the view (single table vs. default)
$itemsPerPage = $this->table ? $itemsLimitSingleTable : $itemsLimitPerTable;
// Set limit defined by calling code
if ($this->showLimit) {
$itemsPerPage = $this->showLimit;
}
// Init
$titleCol = $GLOBALS['TCA'][$table]['ctrl']['label'];
$l10nEnabled = BackendUtility::isTableLocalizable($table);
$this->fieldArray = $this->getColumnsToRender($table, true);
// Creating the list of fields to include in the SQL query
$selectFields = $this->getFieldsToSelect($table, $this->fieldArray);
$firstElement = ($this->page - 1) * $itemsPerPage;
if ($firstElement > 2 && $itemsPerPage > 0) {
// Get the two previous rows for sorting if displaying page > 1
$firstElement -= 2;
$itemsPerPage += 2;
$queryBuilder = $this->getQueryBuilder($table, $selectFields, true, $firstElement, $itemsPerPage);
$firstElement += 2;
$itemsPerPage -= 2;
} else {
$queryBuilder = $this->getQueryBuilder($table, $selectFields, true, $firstElement, $itemsPerPage);
}
if($table == 'tx_news_domain_model_news' && !$GLOBALS['BE_USER']->isAdmin()){
$queryBuilder = $queryBuilder->andWhere(
$queryBuilder->expr()->eq('owner', $queryBuilder->createNamedParameter((int)$GLOBALS['BE_USER']->user['uid'],Connection::PARAM_INT ))
);
}
$queryResult = $queryBuilder->executeQuery();
$columnsOutput = '';
$onlyShowRecordsInSingleTableMode = $this->listOnlyInSingleTableMode && !$this->table;
// Fetch records only if not in single table mode
if ($onlyShowRecordsInSingleTableMode) {
$dbCount = $totalItems;
} elseif ($firstElement + $itemsPerPage <= $totalItems) {
$dbCount = $itemsPerPage + 2;
} else {
$dbCount = $totalItems - $firstElement + 2;
}
// If any records was selected, render the list:
if ($dbCount === 0) {
return '';
}
// Get configuration of collapsed tables from user uc
$lang = $this->getLanguageService();
$tableIdentifier = $table;
// Use a custom table title for translated pages
if ($table === 'pages' && $this->showOnlyTranslatedRecords) {
// pages records in list module are split into two own sections, one for pages with
// sys_language_uid = 0 "Page" and an own section for sys_language_uid > 0 "Page Translation".
// This if sets the different title for the page translation case and a unique table identifier
// which is used in DOM as id.
$tableTitle = htmlspecialchars($lang->sL('LLL:EXT:core/Resources/Private/Language/locallang_core.xlf:pageTranslation'));
$tableIdentifier = 'pages_translated';
} else {
$tableTitle = htmlspecialchars($lang->sL($GLOBALS['TCA'][$table]['ctrl']['title']));
if ($tableTitle === '') {
$tableTitle = $table;
}
}
$backendUser = $this->getBackendUserAuthentication();
$tableCollapsed = (bool)($this->moduleData?->get('collapsedTables')[$tableIdentifier] ?? false);
// Header line is drawn
$theData = [];
if ($this->disableSingleTableView) {
$theData[$titleCol] = $tableTitle . ' (' . $totalItems . ')';
} else {
$icon = $this->table // @todo separate table header from contract/expand link
? $this->iconFactory
->getIcon('actions-view-table-collapse', Icon::SIZE_SMALL)
->setTitle($lang->sL('LLL:EXT:core/Resources/Private/Language/locallang_mod_web_list.xlf:contractView'))
->render()
: $this->iconFactory
->getIcon('actions-view-table-expand', Icon::SIZE_SMALL)
->setTitle($lang->sL('LLL:EXT:core/Resources/Private/Language/locallang_mod_web_list.xlf:expandView'))
->render();
$theData[$titleCol] = $this->linkWrapTable($table, $tableTitle . ' (' . $totalItems . ') ' . $icon);
}
$tableActions = '';
$tableHeader = $theData[$titleCol];
if (!$onlyShowRecordsInSingleTableMode) {
// Add the "new record" button if user nave permissions
if(isset($this->pageRow['uid']) && BackendUserAccess::isUserHaveCreateContentPermissions($this->pageRow['uid'], $table)){
$tableActions .= $this->createActionButtonNewRecord($table) ?? '';
}
// Show the select box
$tableActions .= $this->createActionButtonColumnSelector($table) ?? '';
// Create the Download button
$tableActions .= $this->createActionButtonDownload($table, $totalItems) ?? '';
// Render collapse button if in multi table mode
$tableActions .= $this->createActionButtonCollapse($table) ?? '';
}
$currentIdList = [];
// Render table rows only if in multi table view or if in single table view
$rowOutput = '';
if (!$onlyShowRecordsInSingleTableMode || $this->table) {
// Fixing an order table for sortby tables
$this->currentTable = [];
$allowManualSorting = ($GLOBALS['TCA'][$table]['ctrl']['sortby'] ?? false) && !$this->sortField;
$prevUid = 0;
$prevPrevUid = 0;
// Get first two rows and initialize prevPrevUid and prevUid if on page > 1
if ($firstElement > 2 && $itemsPerPage > 0) {
$row = $queryResult->fetchAssociative();
$prevPrevUid = -((int)$row['uid']);
$row = $queryResult->fetchAssociative();
$prevUid = $row['uid'];
}
$accRows = [];
// Accumulate rows here
while ($row = $queryResult->fetchAssociative()) {
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 ($allowManualSorting) {
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'];
}
}
}
// Render items:
$this->CBnames = [];
$this->duplicateStack = [];
$cc = 0;
// If no search happened 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:
$listTranslatedRecords = $l10nEnabled && $this->searchString === '' && !($this->hideTranslations === '*' || GeneralUtility::inList($this->hideTranslations, $table));
foreach ($accRows as $row) {
// Render item row if counter < limit
if ($cc < $itemsPerPage) {
$cc++;
// Reset translations
$translations = [];
// Initialize with FALSE which causes the localization panel to not be displayed as
// the record is already localized, in free mode or has sys_language_uid -1 set.
// Only set to TRUE if TranslationConfigurationProvider::translationInfo() returns
// an array indicating the record can be translated.
$translationEnabled = false;
// Guard clause so we can quickly return if a record is localized to "all languages"
// It should only be possible to localize a record off default (uid 0)
if ($l10nEnabled && ($row[$GLOBALS['TCA'][$table]['ctrl']['languageField'] ?? null] ?? false) !== -1) {
$translationsRaw = $this->translateTools->translationInfo($table, $row['uid'], 0, $row, $selectFields);
if (is_array($translationsRaw)) {
$translationEnabled = true;
$translations = $translationsRaw['translations'] ?? [];
}
}
$rowOutput .= $this->renderListRow($table, $row, 0, $translations, $translationEnabled);
if ($listTranslatedRecords) {
foreach ($translations ?? [] as $lRow) {
if (!$this->isRowListingConditionFulfilled($table, $lRow)) {
continue;
}
// 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, 1, [], false);
}
}
}
}
}
// Record navigation is added to the beginning and end of the table if in single table mode
if ($this->table) {
$pagination = $this->renderListNavigation($this->table, $totalItems, $itemsPerPage);
$rowOutput = $pagination . $rowOutput . $pagination;
} elseif ($totalItems > $itemsLimitPerTable) {
// Show that there are more records than shown
$rowOutput .= '
';
}
// The header row for the table is now created
$columnsOutput = $this->renderListHeader($table, $currentIdList);
}
// Initialize multi record selection actions
$multiRecordSelectionActions = '';
if ($this->noControlPanels === false) {
$multiRecordSelectionActions = '