summary |
shortlog |
log |
commit | commitdiff |
tree
raw |
patch |
inline | side by side (from parent 1:
0a02d48)
Resolves: #75770
Releases: master
Change-Id: I8b4eb42763ca30b2c099371b7a8206d8098c2f79
Reviewed-on: https://review.typo3.org/47774
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Reviewed-by: Michiel Roos <michiel@maxserv.com>
Tested-by: Michiel Roos <michiel@maxserv.com>
Reviewed-by: Morton Jonuschat <m.jonuschat@mojocode.de>
Tested-by: Morton Jonuschat <m.jonuschat@mojocode.de>
*/
use TYPO3\CMS\Backend\Utility\BackendUtility;
*/
use TYPO3\CMS\Backend\Utility\BackendUtility;
+use TYPO3\CMS\Core\Database\ConnectionPool;
+use TYPO3\CMS\Core\Database\Query\QueryContextType;
use TYPO3\CMS\Core\Imaging\Icon;
use TYPO3\CMS\Core\Imaging\IconFactory;
use TYPO3\CMS\Core\Imaging\IconProvider\SvgIconProvider;
use TYPO3\CMS\Core\Imaging\Icon;
use TYPO3\CMS\Core\Imaging\IconFactory;
use TYPO3\CMS\Core\Imaging\IconProvider\SvgIconProvider;
$lines = array();
$tcaCtrl = $GLOBALS['TCA'][$table]['ctrl'];
if ($table != 'pages' && BackendUtility::isTableLocalizable($table) && !$tcaCtrl['transOrigPointerTable']) {
$lines = array();
$tcaCtrl = $GLOBALS['TCA'][$table]['ctrl'];
if ($table != 'pages' && BackendUtility::isTableLocalizable($table) && !$tcaCtrl['transOrigPointerTable']) {
- $where = array();
- $where[] = $tcaCtrl['transOrigPointerField'] . '=' . (int)$parentRec['uid'];
- $where[] = $tcaCtrl['languageField'] . '<>0';
+ $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($table);
+ $queryBuilder->getQueryContext()->setContext(QueryContextType::UNRESTRICTED);
+ $queryBuilder
+ ->select('*')
+ ->from($table)
+ ->where($queryBuilder->expr()->eq($tcaCtrl['transOrigPointerField'], (int)$parentRec['uid']))
+ ->andWhere($queryBuilder->expr()->neq($tcaCtrl['languageField'], 0));
if (isset($tcaCtrl['delete']) && $tcaCtrl['delete']) {
if (isset($tcaCtrl['delete']) && $tcaCtrl['delete']) {
- $where[] = $tcaCtrl['delete'] . '=0';
+ $queryBuilder->andWhere($queryBuilder->expr()->eq($tcaCtrl['delete'], 0));
}
if (isset($tcaCtrl['versioningWS']) && $tcaCtrl['versioningWS']) {
}
if (isset($tcaCtrl['versioningWS']) && $tcaCtrl['versioningWS']) {
- $where[] = 't3ver_wsid=' . $parentRec['t3ver_wsid'];
+ $queryBuilder->andWhere($queryBuilder->expr()->eq('t3ver_wsid', $parentRec['t3ver_wsid']));
- $rows = $this->getDatabaseConnection()->exec_SELECTgetRows('*', $table, implode(' AND ', $where));
+ $rows = $queryBuilder
+ ->execute()
+ ->fetchAll();
if (is_array($rows)) {
$modeData = '';
if ($pad == 'normal') {
if (is_array($rows)) {
$modeData = '';
if ($pad == 'normal') {
return $GLOBALS['BE_USER'];
}
return $GLOBALS['BE_USER'];
}
- /**
- * Return DatabaseConnection
- *
- * @return \TYPO3\CMS\Core\Database\DatabaseConnection
- */
- protected function getDatabaseConnection()
- {
- return $GLOBALS['TYPO3_DB'];
- }