"TYPO3 4.0.1: typo3_src-4.0.1/t3lib/class.t3lib_loaddbgroup.php Source File", "datetime" => "Sat Dec 2 19:22:18 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

class.t3lib_loaddbgroup.php

<?php
/***************************************************************
*  Copyright notice
*
*  (c) 1999-2006 Kasper Skaarhoj (kasperYYYY@typo3.com)
*  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.
*  A copy is found in the textfile GPL.txt and important notices to the license
*  from the author is found in LICENSE.txt distributed with these scripts.
*
*
*  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!
***************************************************************/
class t3lib_loadDBGroup {
                // External, static:
        var $fromTC = 1;                                        // Means that only uid and the label-field is returned
        var $registerNonTableValues=0;          // If set, values that are not ids in tables are normally discarded. By this options they will be preserved.

                // Internal, dynamic:
        var $tableArray=Array();                        // Contains the table names as keys. The values are the id-values for each table. Should ONLY contain proper table names.
        var $itemArray=Array();                         // Contains items in an numeric array (table/id for each). Tablenames here might be "_NO_TABLE"
        var $nonTableArray=array();                     // Array for NON-table elements
        var $additionalWhere=array();
        var $checkIfDeleted = 1;                        // deleted-column is added to additionalWhere... if this is set...
        var $dbPaths=Array();
        var $firstTable = '';                           // Will contain the first table name in the $tablelist (for positive ids)
        var $secondTable = '';                          // Will contain the second table name in the $tablelist (for negative ids)




        function start($itemlist,$tablelist, $MMtable='',$MMuid=0)      {
                        // If the table list is "*" then all tables are used in the list:
                if (!strcmp(trim($tablelist),'*'))      {
                        $tablelist = implode(',',array_keys($GLOBALS['TCA']));
                }

                        // The tables are traversed and internal arrays are initialized:
                $tempTableArray = t3lib_div::trimExplode(',',$tablelist,1);
                foreach($tempTableArray as $key => $val)        {
                        $tName = trim($val);
                        $this->tableArray[$tName] = Array();
                        if ($this->checkIfDeleted && $GLOBALS['TCA'][$tName]['ctrl']['delete']) {
                                $fieldN = $tName.'.'.$GLOBALS['TCA'][$tName]['ctrl']['delete'];
                                $this->additionalWhere[$tName].=' AND '.$fieldN.'=0';
                        }
                }

                if (is_array($this->tableArray))        {
                        reset($this->tableArray);
                } else {return 'No tables!';}

                        // Set first and second tables:
                $this->firstTable = key($this->tableArray);             // Is the first table
                next($this->tableArray);
                $this->secondTable = key($this->tableArray);    // If the second table is set and the ID number is less than zero (later) then the record is regarded to come from the second table...

                        // Now, populate the internal itemArray and tableArray arrays:
                if ($MMtable)   {       // If MM, then call this function to do that:
                        $this->readMM($MMtable,$MMuid);
                } else {
                                // If not MM, then explode the itemlist by "," and traverse the list:
                        $this->readList($itemlist);
                }
        }

        function readList($itemlist)    {
                if ((string)trim($itemlist)!='')        {
                        $tempItemArray = t3lib_div::trimExplode(',', $itemlist);        // Changed to trimExplode 31/3 04; HMENU special type "list" didn't work if there were spaces in the list... I suppose this is better overall...
                        foreach($tempItemArray as $key => $val) {
                                $isSet = 0;     // Will be set to "1" if the entry was a real table/id:

                                        // Extract table name and id. This is un the formular [tablename]_[id] where table name MIGHT contain "_", hence the reversion of the string!
                                $val = strrev($val);
                                $parts = explode('_',$val,2);
                                $theID = strrev($parts[0]);

                                        // Check that the id IS an integer:
                                if (t3lib_div::testInt($theID)) {
                                                // Get the table name: If a part of the exploded string, use that. Otherwise if the id number is LESS than zero, use the second table, otherwise the first table
                                        $theTable = trim($parts[1]) ? strrev(trim($parts[1])) : ($this->secondTable && $theID<0 ? $this->secondTable : $this->firstTable);
                                                // If the ID is not blank and the table name is among the names in the inputted tableList, then proceed:
                                        if ((string)$theID!='' && $theID && $theTable && isset($this->tableArray[$theTable]))   {
                                                        // Get ID as the right value:
                                                $theID = $this->secondTable ? abs(intval($theID)) : intval($theID);
                                                        // Register ID/table name in internal arrays:
                                                $this->itemArray[$key]['id'] = $theID;
                                                $this->itemArray[$key]['table'] = $theTable;
                                                $this->tableArray[$theTable][] = $theID;
                                                        // Set update-flag:
                                                $isSet=1;
                                        }
                                }

                                        // If it turns out that the value from the list was NOT a valid reference to a table-record, then we might still set it as a NO_TABLE value:
                                if (!$isSet && $this->registerNonTableValues)   {
                                        $this->itemArray[$key]['id'] = $tempItemArray[$key];
                                        $this->itemArray[$key]['table'] = '_NO_TABLE';
                                        $this->nonTableArray[] = $tempItemArray[$key];
                                }
                        }
                }
        }

        function readMM($tableName,$uid)        {
                $key=0;

                        // Select all MM relations:
                $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', $tableName, 'uid_local='.intval($uid), '', 'sorting');
                while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))       {
                        $theTable = $row['tablenames'] ? $row['tablenames'] : $this->firstTable;                // If tablesnames columns exists and contain a name, then this value is the table, else it's the firstTable...
                        if (($row['uid_foreign'] || $theTable=='pages') && $theTable && isset($this->tableArray[$theTable]))    {
                                $this->itemArray[$key]['id'] = $row['uid_foreign'];
                                $this->itemArray[$key]['table'] = $theTable;
                                $this->tableArray[$theTable][]= $row['uid_foreign'];
                        } elseif ($this->registerNonTableValues)        {
                                $this->itemArray[$key]['id'] = $row['uid_foreign'];
                                $this->itemArray[$key]['table'] = '_NO_TABLE';
                                $this->nonTableArray[] = $row['uid_foreign'];
                        }
                        $key++;
                }
                $GLOBALS['TYPO3_DB']->sql_free_result($res);
        }

        function writeMM($tableName,$uid,$prependTableName=0)   {

                        // Delete all relations:
                $GLOBALS['TYPO3_DB']->exec_DELETEquery($tableName, 'uid_local='.intval($uid));

                        // If there are tables...
                $tableC = count($this->tableArray);
                if ($tableC)    {
                        $prep = ($tableC>1||$prependTableName) ? 1 : 0;
                        $c=0;
                        $tName=array();

                                // For each item, insert it:
                        foreach($this->itemArray as $val)       {
                                $c++;

                                $insertFields = array(
                                        'uid_local' => $uid,
                                        'uid_foreign' => $val['id'],
                                        'sorting' => $c
                                );
                                if ($prep || $val['table']=='_NO_TABLE')        {
                                        $insertFields['tablenames'] = $val['table'];
                                }

                                $GLOBALS['TYPO3_DB']->exec_INSERTquery($tableName, $insertFields);
                        }
                }
        }

        function getValueArray($prependTableName='')    {
                        // INIT:
                $valueArray=Array();
                $tableC = count($this->tableArray);

                        // If there are tables in the table array:
                if ($tableC)    {
                                // If there are more than ONE table in the table array, then always prepend table names:
                        $prep = ($tableC>1||$prependTableName) ? 1 : 0;

                                // Traverse the array of items:
                        foreach($this->itemArray as $val)       {
                                $valueArray[]=(($prep && $val['table']!='_NO_TABLE') ? $val['table'].'_' : '').
                                                                        $val['id'];
                        }
                }
                        // Return the array
                return $valueArray;
        }

        function convertPosNeg($valueArray,$fTable,$nfTable)    {
                if (is_array($valueArray) && $fTable)   {
                        foreach($valueArray as $key => $val)    {
                                $val = strrev($val);
                                $parts = explode('_',$val,2);
                                $theID = strrev($parts[0]);
                                $theTable = strrev($parts[1]);

                                if ( t3lib_div::testInt($theID) && (!$theTable || !strcmp($theTable,$fTable) || !strcmp($theTable,$nfTable)) )  {
                                        $valueArray[$key]= $theTable && strcmp($theTable,$fTable) ? $theID*-1 : $theID;
                                }
                        }
                }
                return $valueArray;
        }

        function getFromDB()    {
                        // Traverses the tables listed:
                foreach($this->tableArray as $key => $val)      {
                        if (is_array($val))     {
                                $itemList = implode(',',$val);
                                if ($itemList)  {
                                        $from = '*';
                                        if ($this->fromTC)      {
                                                $from = 'uid,pid';
                                                if ($GLOBALS['TCA'][$key]['ctrl']['label'])     {
                                                        $from.= ','.$GLOBALS['TCA'][$key]['ctrl']['label'];     // Titel
                                                }
                                                if ($GLOBALS['TCA'][$key]['ctrl']['thumbnail']) {
                                                        $from.= ','.$GLOBALS['TCA'][$key]['ctrl']['thumbnail']; // Thumbnail
                                                }
                                        }
                                        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($from, $key, 'uid IN ('.$itemList.')'.$this->additionalWhere[$key]);
                                        while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))       {
                                                $this->results[$key][$row['uid']]=$row;
                                        }
                                }
                        }
                }
                return $this->results;
        }

        function readyForInterface()    {
                global $TCA;

                if (!is_array($this->itemArray))        {return false;}

                $output=array();
                $perms_clause = $GLOBALS['BE_USER']->getPagePermsClause(1);             // For use when getting the paths....
                $titleLen=intval($GLOBALS['BE_USER']->uc['titleLen']);

                foreach($this->itemArray as $key => $val)       {
                        $theRow = $this->results[$val['table']][$val['id']];
                        if ($theRow && is_array($TCA[$val['table']]))   {
                                $label = t3lib_div::fixed_lgd_cs(strip_tags($theRow[$TCA[$val['table']]['ctrl']['label']]),$titleLen);
                                $label = ($label)?$label:'[...]';
                                $output[]=str_replace(',','',$val['table'].'_'.$val['id'].'|'.rawurlencode($label));
                        }
                }
                return implode(',',$output);
        }
}


if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_loaddbgroup.php'])       {
        include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_loaddbgroup.php']);
}
?>