class.tx_recycler_model_tables.php

Go to the documentation of this file.

<?php
/***************************************************************
*  Copyright notice
*
*  (c) 2009-2011 Julian Kleinhans <typo3@kj187.de>
*  All rights reserved
*
*  This script is part of the TYPO3 project. The TYPO3 project is
*  free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
*  The GNU General Public License can be found at
*  http://www.gnu.org/copyleft/gpl.html.
*
*  This script is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU General Public License for more details.
*
*  This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/

require_once(t3lib_extMgm::extPath('recycler', 'classes/model/class.tx_recycler_model_deletedRecords.php'));

/**
 * Model class for the 'recycler' extension.
 *
 * @author  Julian Kleinhans <typo3@kj187.de>
 * @package TYPO3
 * @subpackage  tx_recycler
 * @version $Id: class.tx_recycler_model_tables.php 10120 2011-01-18 20:03:36Z ohader $
 */
class tx_recycler_model_tables {
    /**
     * Get tables for menu example
     *
     * @param   string      $format: Return format (example: json)
     * @param   boolean     $withAllOption: 0 no, 1 return tables with a "all" option
     * @param   integer     $id: UID from selected page
     * @param   integer     $depth: How many levels recursive
     * @return  string      The tables to be displayed
     */
    public function getTables($format, $withAllOption=0, $startUid, $depth=0) {
        $deletedRecordsTotal = 0;
        $tables = array();

        foreach (array_keys($GLOBALS['TCA']) as $tableName) {
            $deletedField = tx_recycler_helper::getDeletedField($tableName);
            if ($deletedField) {
                    // Determine whether the table has deleted records:
                $deletedCount = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows(
                    'uid',
                    $tableName,
                    $deletedField . '!=0'
                );
                if ($deletedCount) {
                    $deletedDataObject = t3lib_div::makeInstance('tx_recycler_model_deletedRecords');
                    $deletedData = $deletedDataObject->loadData($startUid, $tableName, $depth)->getDeletedRows();
                    if (isset($deletedData[$tableName])) {
                        if ($deletedRecordsInTable = count($deletedData[$tableName])) {
                            $deletedRecordsTotal += $deletedRecordsInTable;
                            $tables[] = array(
                                $tableName,
                                $deletedRecordsInTable,
                                $tableName,
                                tx_recycler_helper::getUtf8String(
                                    $GLOBALS['LANG']->sL($GLOBALS['TCA'][$tableName]['ctrl']['title'])
                                ),
                            );
                        }
                    }
                }
            }
        }

        $jsonArray = $tables;
        if ($withAllOption) {
            array_unshift(
                $jsonArray,
                array(
                    '',
                    $deletedRecordsTotal,
                    '',
                    $GLOBALS['LANG']->sL('LLL:EXT:recycler/mod1/locallang.xml:label_alltables'),
                )
            );
        }
        $output = json_encode($jsonArray);

        return $output;
    }
}

if (defined('TYPO3_MODE') && isset($GLOBALS['TYPO3_CONF_VARS'][TYPO3_MODE]['XCLASS']['ext/recycler/classes/model/class.tx_recycler_model_tables.php'])) {
    include_once($GLOBALS['TYPO3_CONF_VARS'][TYPO3_MODE]['XCLASS']['ext/recycler/classes/model/class.tx_recycler_model_tables.php']);
}

?>