t3lib_loadDBGroup Class Reference

Inherited by FE_loadDBGroup.

List of all members.

Public Member Functions
	start ($itemlist, $tablelist, $MMtable='', $MMuid=0)
	Initialization of the class.
	readList ($itemlist)
	Explodes the item list and stores the parts in the internal arrays itemArray and tableArray from MM records.
	readMM ($tableName, $uid)
	Reads the record tablename/id into the internal arrays itemArray and tableArray from MM records.
	writeMM ($tableName, $uid, $prependTableName=0)
	Writes the internal itemArray to MM table:.
	getValueArray ($prependTableName='')
	After initialization you can extract an array of the elements from the object.
	convertPosNeg ($valueArray, $fTable, $nfTable)
	Converts id numbers from negative to positive.
	getFromDB ()
	Reads all records from internal tableArray into the internal ->results array where keys are table names and for each table, records are stored with uids as their keys.
	readyForInterface ()
	Prepare items from itemArray to be transferred to the TCEforms interface (as a comma list).
Public Attributes
	$fromTC = 1
	$registerNonTableValues = 0
	$tableArray = Array()
	$itemArray = Array()
	$nonTableArray = array()
	$additionalWhere = array()
	$checkIfDeleted = 1
	$dbPaths = Array()
	$firstTable = ''
	$secondTable = ''

---

Member Function Documentation

t3lib_loadDBGroup::convertPosNeg (  $  valueArray, $  fTable, $  nfTable )

Converts id numbers from negative to positive. Parameters: array  Array of [table]_[id] pairs. string  Foreign table (the one used for positive numbers) string  NEGative foreign table Returns: array The array with ID integer values, converted to positive for those where the table name was set but did NOT match the positive foreign table. Definition at line 279 of file class.t3lib_loaddbgroup.php. References $val. { 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; }

t3lib_loadDBGroup::getFromDB (   )

Reads all records from internal tableArray into the internal ->results array where keys are table names and for each table, records are stored with uids as their keys. If $this->fromTC is set you can save a little memory since only uid,pid and a few other fields are selected. Returns: void Definition at line 301 of file class.t3lib_loaddbgroup.php. { // 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; }

t3lib_loadDBGroup::getValueArray (  $  prependTableName = ''  )

After initialization you can extract an array of the elements from the object. Use this function for that. Parameters: boolean  If set, then table names will ALWAYS be prepended (unless its a _NO_TABLE value) Returns: array A numeric array. Definition at line 251 of file class.t3lib_loaddbgroup.php. References $val, and table(). { // 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; }

t3lib_loadDBGroup::readList (  $  itemlist  )

Explodes the item list and stores the parts in the internal arrays itemArray and tableArray from MM records. Parameters: string  Item list Returns: void Definition at line 140 of file class.t3lib_loaddbgroup.php. References $val, and table(). Referenced by start(). { 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]; } } } }

t3lib_loadDBGroup::readMM (  $  tableName, $  uid )

Reads the record tablename/id into the internal arrays itemArray and tableArray from MM records. You can call this function after start if you supply no list to start() Parameters: string  MM Tablename integer  Local UID Returns: void Definition at line 186 of file class.t3lib_loaddbgroup.php. References $key, and table(). Referenced by start(). { $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 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); }

t3lib_loadDBGroup::readyForInterface (   )

Prepare items from itemArray to be transferred to the TCEforms interface (as a comma list). Returns: string See also: t3lib_transferdata::renderRecord() Definition at line 333 of file class.t3lib_loaddbgroup.php. References $val, and table(). { 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); }

t3lib_loadDBGroup::start (  $  itemlist, $  tablelist, $  MMtable = '', $  MMuid = 0 )

Initialization of the class. Parameters: string  List of group/select items string  Comma list of tables, first table takes priority if no table is set for an entry in the list. string  Name of a MM table. integer  Local UID for MM lookup Returns: void Definition at line 99 of file class.t3lib_loaddbgroup.php. References readList(), and readMM(). { // 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 NOT '.$fieldN; } } 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); } }

t3lib_loadDBGroup::writeMM (  $  tableName, $  uid, $  prependTableName = 0 )

Writes the internal itemArray to MM table:. Parameters: string  MM table name integer  Local UID boolean  If set, then table names will always be written. Returns: void Definition at line 215 of file class.t3lib_loaddbgroup.php. References $val, and table(). { // 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); } } }

---

Member Data Documentation

t3lib_loadDBGroup::$additionalWhere = array()

Definition at line 81 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$checkIfDeleted = 1

Definition at line 82 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$dbPaths = Array()

Definition at line 83 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$firstTable = ''

Definition at line 84 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$fromTC = 1

Reimplemented in FE_loadDBGroup. Definition at line 74 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$itemArray = Array()

Definition at line 79 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$nonTableArray = array()

Definition at line 80 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$registerNonTableValues = 0

Definition at line 75 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$secondTable = ''

Definition at line 85 of file class.t3lib_loaddbgroup.php.

t3lib_loadDBGroup::$tableArray = Array()

Definition at line 78 of file class.t3lib_loaddbgroup.php.

---

The documentation for this class was generated from the following file:

• t3lib/class.t3lib_loaddbgroup.php

---