[TASK] Doctrine: migrate ext:backend/Clipboard/Clipboard

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>

diff --git a/typo3/sysext/backend/Classes/Clipboard/Clipboard.php b/typo3/sysext/backend/Classes/Clipboard/Clipboard.php
index f27dad4..2482526 100644 (file)
--- a/typo3/sysext/backend/Classes/Clipboard/Clipboard.php
+++ b/typo3/sysext/backend/Classes/Clipboard/Clipboard.php
@@ -15,6 +15,8 @@ namespace TYPO3\CMS\Backend\Clipboard;
  */
 
 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;


@@ -495,16 +497,22 @@ class Clipboard
         $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') {


@@ -1113,13 +1121,4 @@ class Clipboard
         return $GLOBALS['BE_USER'];
     }
 
         return $GLOBALS['BE_USER'];
     }
 

-    /**
-     * Return DatabaseConnection
-     *
-     * @return \TYPO3\CMS\Core\Database\DatabaseConnection
-     */
-    protected function getDatabaseConnection()
-    {
-        return $GLOBALS['TYPO3_DB'];
-    }

 }
 }