9.5/_tables_8php_source.html

<?php

namespace ‪TYPO3\CMS\Recycler\Domain\Model;


/*

 * 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\Core\Database\ConnectionPool;

use ‪TYPO3\CMS\Core\Utility\GeneralUtility;

use ‪TYPO3\CMS\Recycler\Utility\RecyclerUtility;


class ‪Tables

{

    public function ‪getTables($startUid, $depth = 0)

    {

        $deletedRecordsTotal = 0;

        $lang = $this->‪getLanguageService();

        $tables = [];

        $connection = GeneralUtility::makeInstance(ConnectionPool::class);


        foreach (‪RecyclerUtility::getModifyableTables() as $tableName) {

            $deletedField = ‪RecyclerUtility::getDeletedField($tableName);

            if ($deletedField) {

                // Determine whether the table has deleted records:

                $queryBuilder = $connection->getQueryBuilderForTable($tableName);

                $queryBuilder->getRestrictions()->removeAll();


                $deletedCount = $queryBuilder->count('uid')

                    ->from($tableName)

                    ->where(

                        $queryBuilder->expr()->neq(

                            $deletedField,

                            $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT)

                        )

                    )

                    ->execute()

                    ->fetchColumn();


                if ($deletedCount) {

                    /* @var DeletedRecords $deletedDataObject */

                    $deletedDataObject = GeneralUtility::makeInstance(DeletedRecords::class);

                    $deletedData = $deletedDataObject->loadData($startUid, $tableName, $depth)->getDeletedRows();

                    if (isset($deletedData[$tableName])) {

                        if ($deletedRecordsInTable = count($deletedData[$tableName])) {

                            $deletedRecordsTotal += $deletedRecordsInTable;

                            $tables[] = [

                                $tableName,

                                $deletedRecordsInTable,

                                $lang->sL(‪$GLOBALS['TCA'][$tableName]['ctrl']['title'] ?? $tableName)

                            ];

                        }

                    }

                }

            }

        }

        $jsonArray = $tables;

        array_unshift($jsonArray, [

            '',

            $deletedRecordsTotal,

            $lang->sL('LLL:EXT:recycler/Resources/Private/Language/locallang.xlf:label_allrecordtypes')

        ]);

        return $jsonArray;

    }


    protected function ‪getLanguageService()

    {

        return ‪$GLOBALS['LANG'];

    }

}