Bug #22410 » 14050_cleaning_t3lib_loaddbgroup.patch
| t3lib/class.t3lib_loaddbgroup.php (revision ) | ||
|---|---|---|
|
<?php
|
||
|
/***************************************************************
|
||
|
* Copyright notice
|
||
|
*
|
||
|
* (c) 1999-2010 Kasper Sk?rh?j (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!
|
||
|
***************************************************************/
|
||
|
* Copyright notice
|
||
|
*
|
||
|
* (c) 1999-2010 Kasper Sk?rh?j (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!
|
||
|
***************************************************************/
|
||
|
/**
|
||
|
* Contains class for loading database groups
|
||
|
*
|
||
| ... | ... | |
|
*
|
||
|
*
|
||
|
* 76: class t3lib_loadDBGroup
|
||
|
* 111: function start($itemlist, $tablelist, $MMtable='', $MMuid=0, $currentTable='', $conf=array())
|
||
|
* 111: function start($itemlist, $tablelist, $MMtable='', $MMuid=0, $currentTable='', $conf=array())
|
||
|
* 179: function readList($itemlist)
|
||
|
* 179: function readList($itemlist)
|
||
|
* 225: function readMM($tableName,$uid)
|
||
|
* 225: function readMM($tableName,$uid)
|
||
|
* 276: function writeMM($tableName,$uid,$prependTableName=0)
|
||
|
* 276: function writeMM($tableName,$uid,$prependTableName=0)
|
||
|
* 352: function readForeignField($uid, $conf)
|
||
|
* 352: function readForeignField($uid, $conf)
|
||
|
* 435: function writeForeignField($conf, $parentUid, $updateToUid=0)
|
||
|
* 435: function writeForeignField($conf, $parentUid, $updateToUid=0)
|
||
|
* 510: function getValueArray($prependTableName='')
|
||
|
* 510: function getValueArray($prependTableName='')
|
||
|
* 538: function convertPosNeg($valueArray,$fTable,$nfTable)
|
||
|
* 538: function convertPosNeg($valueArray,$fTable,$nfTable)
|
||
|
* 560: function getFromDB()
|
||
|
* 560: function getFromDB()
|
||
|
* 595: function readyForInterface()
|
||
|
* 595: function readyForInterface()
|
||
|
* 621: function countItems($returnAsArray = true)
|
||
|
* 621: function countItems($returnAsArray = true)
|
||
|
* 636: function updateRefIndex($table,$id)
|
||
|
* 636: function updateRefIndex($table,$id)
|
||
|
*
|
||
|
* TOTAL FUNCTIONS: 12
|
||
|
* (This index is automatically created/updated by the extension "extdeveval")
|
||
| ... | ... | |
|
*/
|
||
|
/**
|
||
|
* Load database groups (relations)
|
||
|
* Used to process the relations created by the TCA element types "group" and "select" for database records. Manages MM-relations as well.
|
||
| ... | ... | |
|
* @package TYPO3
|
||
|
* @subpackage t3lib
|
||
|
*/
|
||
|
class t3lib_loadDBGroup {
|
||
|
class t3lib_loadDBGroup {
|
||
|
// External, static:
|
||
|
var $fromTC = 1; // Means that only uid and the label-field is returned
|
||
|
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.
|
||
|
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 $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 $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 $nonTableArray = array(); // Array for NON-table elements
|
||
|
var $additionalWhere=array();
|
||
|
var $additionalWhere = array();
|
||
|
var $checkIfDeleted = 1; // deleted-column is added to additionalWhere... if this is set...
|
||
|
var $checkIfDeleted = 1; // deleted-column is added to additionalWhere... if this is set...
|
||
|
var $dbPaths=Array();
|
||
|
var $dbPaths = Array();
|
||
|
var $firstTable = ''; // Will contain the first table name in the $tablelist (for positive ids)
|
||
|
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)
|
||
|
var $secondTable = ''; // Will contain the second table name in the $tablelist (for negative ids)
|
||
|
// private
|
||
|
var $MM_is_foreign = 0; // boolean - if 1, uid_local and uid_foreign are switched, and the current table is inserted as tablename - this means you display a foreign relation "from the opposite side"
|
||
|
var $MM_is_foreign = 0; // boolean - if 1, uid_local and uid_foreign are switched, and the current table is inserted as tablename - this means you display a foreign relation "from the opposite side"
|
||
|
var $MM_oppositeField = ''; // field name at the "local" side of the MM relation
|
||
|
var $MM_oppositeField = ''; // field name at the "local" side of the MM relation
|
||
|
var $MM_oppositeTable = ''; // only set if MM_is_foreign is set
|
||
|
var $MM_oppositeFieldConf = ''; // only set if MM_is_foreign is set
|
||
|
var $MM_isMultiTableRelationship = 0; // is empty by default; if MM_is_foreign is set and there is more than one table allowed (on the "local" side), then it contains the first table (as a fallback)
|
||
|
var $MM_isMultiTableRelationship = 0; // is empty by default; if MM_is_foreign is set and there is more than one table allowed (on the "local" side), then it contains the first table (as a fallback)
|
||
|
var $currentTable; // current table => Only needed for reverse relations
|
||
|
var $currentTable; // current table => Only needed for reverse relations
|
||
|
var $undeleteRecord; // if a record should be undeleted (so do not use the $useDeleteClause on t3lib_BEfunc)
|
||
|
var $undeleteRecord; // if a record should be undeleted (so do not use the $useDeleteClause on t3lib_BEfunc)
|
||
|
var $MM_match_fields = array(); // array of fields value pairs that should match while SELECT and will be written into MM table if $MM_insert_fields is not set
|
||
|
var $MM_match_fields = array(); // array of fields value pairs that should match while SELECT and will be written into MM table if $MM_insert_fields is not set
|
||
|
var $MM_insert_fields = array(); // array of fields and value pairs used for insert in MM table
|
||
|
var $MM_insert_fields = array(); // array of fields and value pairs used for insert in MM table
|
||
|
var $MM_table_where = ''; // extra MM table where
|
||
|
/**
|
||
| ... | ... | |
|
* @param integer TCA configuration for current field
|
||
|
* @return void
|
||
|
*/
|
||
|
function start($itemlist, $tablelist, $MMtable='', $MMuid=0, $currentTable='', $conf=array()) {
|
||
|
function start($itemlist, $tablelist, $MMtable = '', $MMuid = 0, $currentTable = '', $conf = array()) {
|
||
|
// SECTION: MM reverse relations
|
||
|
$this->MM_is_foreign = ($conf['MM_opposite_field']?1:0);
|
||
|
$this->MM_is_foreign = ($conf['MM_opposite_field'] ? 1 : 0);
|
||
|
$this->MM_oppositeField = $conf['MM_opposite_field'];
|
||
|
$this->MM_table_where = $conf['MM_table_where'];
|
||
|
$this->MM_hasUidField = $conf['MM_hasUidField'];
|
||
| ... | ... | |
|
$this->MM_insert_fields = is_array($conf['MM_insert_fields']) ? $conf['MM_insert_fields'] : $this->MM_match_fields;
|
||
|
$this->currentTable = $currentTable;
|
||
|
if ($this->MM_is_foreign) {
|
||
|
if ($this->MM_is_foreign) {
|
||
|
$tmp = ($conf['type']==='group'?$conf['allowed']:$conf['foreign_table']);
|
||
|
$tmp = ($conf['type'] === 'group' ? $conf['allowed'] : $conf['foreign_table']);
|
||
|
// normally, $conf['allowed'] can contain a list of tables, but as we are looking at a MM relation from the foreign side, it only makes sense to allow one one table in $conf['allowed']
|
||
|
$tmp = t3lib_div::trimExplode(',', $tmp);
|
||
|
$this->MM_oppositeTable = $tmp[0];
|
||
|
unset($tmp);
|
||
|
// only add the current table name if there is more than one allowed field
|
||
|
t3lib_div::loadTCA($this->MM_oppositeTable); // We must be sure this has been done at least once before accessing the "columns" part of TCA for a table.
|
||
|
t3lib_div::loadTCA($this->MM_oppositeTable); // We must be sure this has been done at least once before accessing the "columns" part of TCA for a table.
|
||
|
$this->MM_oppositeFieldConf = $GLOBALS['TCA'][$this->MM_oppositeTable]['columns'][$this->MM_oppositeField]['config'];
|
||
|
if ($this->MM_oppositeFieldConf['allowed']) {
|
||
|
if ($this->MM_oppositeFieldConf['allowed']) {
|
||
|
$oppositeFieldConf_allowed = explode(',', $this->MM_oppositeFieldConf['allowed']);
|
||
|
if (count($oppositeFieldConf_allowed) > 1) {
|
||
|
if (count($oppositeFieldConf_allowed) > 1) {
|
||
|
$this->MM_isMultiTableRelationship = $oppositeFieldConf_allowed[0];
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
// SECTION: normal MM relations
|
||
|
// If the table list is "*" then all tables are used in the list:
|
||
|
if (!strcmp(trim($tablelist),'*')) {
|
||
|
if (!strcmp(trim($tablelist), '*')) {
|
||
|
$tablelist = implode(',',array_keys($GLOBALS['TCA']));
|
||
|
$tablelist = implode(',', array_keys($GLOBALS['TCA']));
|
||
|
}
|
||
|
// The tables are traversed and internal arrays are initialized:
|
||
|
$tempTableArray = t3lib_div::trimExplode(',',$tablelist,1);
|
||
|
$tempTableArray = t3lib_div::trimExplode(',', $tablelist, 1);
|
||
|
foreach($tempTableArray as $key => $val) {
|
||
|
foreach ($tempTableArray as $key => $val) {
|
||
|
$tName = trim($val);
|
||
|
$this->tableArray[$tName] = Array();
|
||
|
if ($this->checkIfDeleted && $GLOBALS['TCA'][$tName]['ctrl']['delete']) {
|
||
|
if ($this->checkIfDeleted && $GLOBALS['TCA'][$tName]['ctrl']['delete']) {
|
||
|
$fieldN = $tName.'.'.$GLOBALS['TCA'][$tName]['ctrl']['delete'];
|
||
|
$fieldN = $tName . '.' . $GLOBALS['TCA'][$tName]['ctrl']['delete'];
|
||
|
$this->additionalWhere[$tName].=' AND '.$fieldN.'=0';
|
||
|
$this->additionalWhere[$tName] .= ' AND ' . $fieldN . '=0';
|
||
|
}
|
||
|
}
|
||
|
if (is_array($this->tableArray)) {
|
||
|
if (is_array($this->tableArray)) {
|
||
|
reset($this->tableArray);
|
||
|
} else {return 'No tables!';}
|
||
|
} else {
|
||
|
return 'No tables!';
|
||
|
}
|
||
|
// Set first and second tables:
|
||
|
$this->firstTable = key($this->tableArray); // Is the first table
|
||
|
$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...
|
||
|
$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:
|
||
|
if ($MMtable) { // If MM, then call this function to do that:
|
||
|
if ($MMuid) {
|
||
|
if ($MMuid) {
|
||
|
$this->readMM($MMtable, $MMuid);
|
||
|
} else { // Revert to readList() for new records in order to load possible default values from $itemlist
|
||
|
} else { // Revert to readList() for new records in order to load possible default values from $itemlist
|
||
|
$this->readList($itemlist);
|
||
|
}
|
||
|
} elseif ($MMuid && $conf['foreign_field']) {
|
||
| ... | ... | |
|
* @return void
|
||
|
*/
|
||
|
public function setUpdateReferenceIndex($updateReferenceIndex) {
|
||
|
$this->updateReferenceIndex = (bool)$updateReferenceIndex;
|
||
|
$this->updateReferenceIndex = (bool) $updateReferenceIndex;
|
||
|
}
|
||
|
/**
|
||
| ... | ... | |
|
* @param string Item list
|
||
|
* @return void
|
||
|
*/
|
||
|
function readList($itemlist) {
|
||
|
function readList($itemlist) {
|
||
|
if ((string)trim($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...
|
||
|
$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) {
|
||
|
foreach ($tempItemArray as $key => $val) {
|
||
|
$isSet = 0; // Will be set to "1" if the entry was a real table/id:
|
||
|
$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);
|
||
|
$parts = explode('_', $val, 2);
|
||
|
$theID = strrev($parts[0]);
|
||
|
// Check that the id IS an integer:
|
||
|
if (t3lib_div::testInt($theID)) {
|
||
|
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);
|
||
|
$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])) {
|
||
|
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]['table'] = $theTable;
|
||
|
$this->tableArray[$theTable][] = $theID;
|
||
|
// Set update-flag:
|
||
|
$isSet=1;
|
||
|
$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) {
|
||
|
if (!$isSet && $this->registerNonTableValues) {
|
||
|
$this->itemArray[$key]['id'] = $tempItemArray[$key];
|
||
|
$this->itemArray[$key]['table'] = '_NO_TABLE';
|
||
|
$this->nonTableArray[] = $tempItemArray[$key];
|
||
| ... | ... | |
|
// sort directly without fetching addional data
|
||
|
if ($sortby == 'uid') {
|
||
|
usort($this->itemArray, create_function('$a,$b', 'return $a["id"] < $b["id"] ? -1 : 1;'));
|
||
|
// only useful if working on the same table
|
||
|
// only useful if working on the same table
|
||
|
} elseif (count($this->tableArray) == 1) {
|
||
|
reset($this->tableArray);
|
||
|
$table = key($this->tableArray);
|
||
| ... | ... | |
|
$this->itemArray = array();
|
||
|
$this->tableArray = array();
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid', $table, 'uid IN ('.$uidList.')', '', $sortby);
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('uid', $table, 'uid IN (' . $uidList . ')', '', $sortby);
|
||
|
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
$this->itemArray[] = array('id' => $row['uid'], 'table' => $table);
|
||
|
$this->tableArray[$table][] = $row['uid'];
|
||
| ... | ... | |
|
* @param integer Local UID
|
||
|
* @return void
|
||
|
*/
|
||
|
function readMM($tableName,$uid) {
|
||
|
function readMM($tableName, $uid) {
|
||
|
$key=0;
|
||
|
$key = 0;
|
||
|
$additionalWhere = '';
|
||
|
if ($this->MM_is_foreign) { // in case of a reverse relation
|
||
|
if ($this->MM_is_foreign) { // in case of a reverse relation
|
||
|
$uidLocal_field = 'uid_foreign';
|
||
|
$uidForeign_field = 'uid_local';
|
||
|
$sorting_field = 'sorting_foreign';
|
||
|
if ($this->MM_isMultiTableRelationship) {
|
||
|
if ($this->MM_isMultiTableRelationship) {
|
||
|
$additionalWhere .= ' AND ( tablenames=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($this->currentTable, $tableName);
|
||
|
if ($this->currentTable == $this->MM_isMultiTableRelationship) { // be backwards compatible! When allowing more than one table after having previously allowed only one table, this case applies.
|
||
|
if ($this->currentTable == $this->MM_isMultiTableRelationship) { // be backwards compatible! When allowing more than one table after having previously allowed only one table, this case applies.
|
||
|
$additionalWhere .= ' OR tablenames=\'\'';
|
||
|
}
|
||
|
$additionalWhere .= ' ) ';
|
||
|
}
|
||
|
$theTable = $this->MM_oppositeTable;
|
||
|
} else { // default
|
||
|
} else { // default
|
||
|
$uidLocal_field = 'uid_local';
|
||
|
$uidForeign_field = 'uid_foreign';
|
||
|
$sorting_field = 'sorting';
|
||
| ... | ... | |
|
if ($this->MM_table_where) {
|
||
|
$additionalWhere.= LF.str_replace('###THIS_UID###', intval($uid), $this->MM_table_where);
|
||
|
$additionalWhere .= LF . str_replace('###THIS_UID###', intval($uid), $this->MM_table_where);
|
||
|
}
|
||
|
foreach ($this->MM_match_fields as $field => $value) {
|
||
|
$additionalWhere.= ' AND '.$field.'='.$GLOBALS['TYPO3_DB']->fullQuoteStr($value, $tableName);
|
||
|
$additionalWhere .= ' AND ' . $field . '=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($value, $tableName);
|
||
|
}
|
||
|
// Select all MM relations:
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', $tableName, $uidLocal_field.'='.intval($uid).$additionalWhere, '', $sorting_field);
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', $tableName, $uidLocal_field . '=' . intval($uid) . $additionalWhere, '', $sorting_field);
|
||
|
while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
if (!$this->MM_is_foreign) { // default
|
||
|
if (!$this->MM_is_foreign) { // default
|
||
|
$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...
|
||
|
$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[$uidForeign_field] || $theTable=='pages') && $theTable && isset($this->tableArray[$theTable])) {
|
||
|
if (($row[$uidForeign_field] || $theTable == 'pages') && $theTable && isset($this->tableArray[$theTable])) {
|
||
|
$this->itemArray[$key]['id'] = $row[$uidForeign_field];
|
||
|
$this->itemArray[$key]['table'] = $theTable;
|
||
|
$this->tableArray[$theTable][]= $row[$uidForeign_field];
|
||
|
$this->tableArray[$theTable][] = $row[$uidForeign_field];
|
||
|
} elseif ($this->registerNonTableValues) {
|
||
|
} elseif ($this->registerNonTableValues) {
|
||
|
$this->itemArray[$key]['id'] = $row[$uidForeign_field];
|
||
|
$this->itemArray[$key]['table'] = '_NO_TABLE';
|
||
|
$this->nonTableArray[] = $row[$uidForeign_field];
|
||
| ... | ... | |
|
* @param boolean If set, then table names will always be written.
|
||
|
* @return void
|
||
|
*/
|
||
|
function writeMM($MM_tableName,$uid,$prependTableName=0) {
|
||
|
function writeMM($MM_tableName, $uid, $prependTableName = 0) {
|
||
|
if ($this->MM_is_foreign) { // in case of a reverse relation
|
||
|
if ($this->MM_is_foreign) { // in case of a reverse relation
|
||
|
$uidLocal_field = 'uid_foreign';
|
||
|
$uidForeign_field = 'uid_local';
|
||
|
$sorting_field = 'sorting_foreign';
|
||
|
} else { // default
|
||
|
} else { // default
|
||
|
$uidLocal_field = 'uid_local';
|
||
|
$uidForeign_field = 'uid_foreign';
|
||
|
$sorting_field = 'sorting';
|
||
| ... | ... | |
|
// If there are tables...
|
||
|
$tableC = count($this->tableArray);
|
||
|
if ($tableC) {
|
||
|
if ($tableC) {
|
||
|
$prep = ($tableC>1||$prependTableName||$this->MM_isMultiTableRelationship) ? 1 : 0; // boolean: does the field "tablename" need to be filled?
|
||
|
$prep = ($tableC > 1 || $prependTableName || $this->MM_isMultiTableRelationship) ? 1 : 0; // boolean: does the field "tablename" need to be filled?
|
||
|
$c=0;
|
||
|
$c = 0;
|
||
|
$additionalWhere_tablenames = '';
|
||
|
if ($this->MM_is_foreign && $prep) {
|
||
|
if ($this->MM_is_foreign && $prep) {
|
||
|
$additionalWhere_tablenames = ' AND tablenames=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($this->currentTable, $MM_tableName);
|
||
|
}
|
||
|
$additionalWhere = '';
|
||
|
// add WHERE clause if configured
|
||
|
if ($this->MM_table_where) {
|
||
|
$additionalWhere.= LF.str_replace('###THIS_UID###', intval($uid), $this->MM_table_where);
|
||
|
$additionalWhere .= LF . str_replace('###THIS_UID###', intval($uid), $this->MM_table_where);
|
||
|
}
|
||
|
// Select, update or delete only those relations that match the configured fields
|
||
|
foreach ($this->MM_match_fields as $field => $value) {
|
||
|
$additionalWhere.= ' AND '.$field.'='.$GLOBALS['TYPO3_DB']->fullQuoteStr($value, $MM_tableName);
|
||
|
$additionalWhere .= ' AND ' . $field . '=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($value, $MM_tableName);
|
||
|
}
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
|
||
|
$uidForeign_field.($prep?', tablenames':'').($this->MM_hasUidField?', uid':''),
|
||
|
$uidForeign_field . ($prep ? ', tablenames' : '') . ($this->MM_hasUidField ? ', uid' : ''),
|
||
|
$MM_tableName,
|
||
|
$uidLocal_field.'='.$uid.$additionalWhere_tablenames.$additionalWhere,
|
||
|
$uidLocal_field . '=' . $uid . $additionalWhere_tablenames . $additionalWhere,
|
||
|
'',
|
||
|
$sorting_field
|
||
|
);
|
||
|
$oldMMs = array();
|
||
|
$oldMMs_inclUid = array(); // This array is similar to $oldMMs but also holds the uid of the MM-records, if any (configured by MM_hasUidField). If the UID is present it will be used to update sorting and delete MM-records. This is necessary if the "multiple" feature is used for the MM relations. $oldMMs is still needed for the in_array() search used to look if an item from $this->itemArray is in $oldMMs
|
||
|
$oldMMs_inclUid = array(); // This array is similar to $oldMMs but also holds the uid of the MM-records, if any (configured by MM_hasUidField). If the UID is present it will be used to update sorting and delete MM-records. This is necessary if the "multiple" feature is used for the MM relations. $oldMMs is still needed for the in_array() search used to look if an item from $this->itemArray is in $oldMMs
|
||
|
while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
if (!$this->MM_is_foreign && $prep) {
|
||
|
if (!$this->MM_is_foreign && $prep) {
|
||
|
$oldMMs[] = array($row['tablenames'], $row[$uidForeign_field]);
|
||
|
} else {
|
||
|
$oldMMs[] = $row[$uidForeign_field];
|
||
| ... | ... | |
|
}
|
||
|
// For each item, insert it:
|
||
|
foreach($this->itemArray as $val) {
|
||
|
foreach ($this->itemArray as $val) {
|
||
|
$c++;
|
||
|
if ($prep || $val['table']=='_NO_TABLE') {
|
||
|
if ($prep || $val['table'] == '_NO_TABLE') {
|
||
|
if ($this->MM_is_foreign) { // insert current table if needed
|
||
|
if ($this->MM_is_foreign) { // insert current table if needed
|
||
|
$tablename = $this->currentTable;
|
||
|
} else {
|
||
|
$tablename = $val['table'];
|
||
| ... | ... | |
|
$tablename = '';
|
||
|
}
|
||
|
if(!$this->MM_is_foreign && $prep) {
|
||
|
if (!$this->MM_is_foreign && $prep) {
|
||
|
$item = array($val['table'], $val['id']);
|
||
|
} else {
|
||
|
$item = $val['id'];
|
||
|
}
|
||
|
if (in_array($item, $oldMMs)) {
|
||
|
if (in_array($item, $oldMMs)) {
|
||
|
$oldMMs_index = array_search($item, $oldMMs);
|
||
|
$whereClause = $uidLocal_field.'='.$uid.' AND '.$uidForeign_field.'='.$val['id'].
|
||
|
$whereClause = $uidLocal_field . '=' . $uid . ' AND ' . $uidForeign_field . '=' . $val['id'] .
|
||
|
($this->MM_hasUidField ? ' AND uid='.intval($oldMMs_inclUid[$oldMMs_index][2]) : ''); // In principle, selecting on the UID is all we need to do if a uid field is available since that is unique! But as long as it "doesn't hurt" we just add it to the where clause. It should all match up.
|
||
|
($this->MM_hasUidField ? ' AND uid=' . intval($oldMMs_inclUid[$oldMMs_index][2]) : ''); // In principle, selecting on the UID is all we need to do if a uid field is available since that is unique! But as long as it "doesn't hurt" we just add it to the where clause. It should all match up.
|
||
|
if ($tablename) {
|
||
|
$whereClause .= ' AND tablenames=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($tablename, $MM_tableName);
|
||
|
}
|
||
|
$GLOBALS['TYPO3_DB']->exec_UPDATEquery($MM_tableName, $whereClause.$additionalWhere, array($sorting_field => $c));
|
||
|
$GLOBALS['TYPO3_DB']->exec_UPDATEquery($MM_tableName, $whereClause . $additionalWhere, array($sorting_field => $c));
|
||
|
unset($oldMMs[$oldMMs_index]); // remove the item from the $oldMMs array so after this foreach loop only the ones that need to be deleted are in there.
|
||
|
unset($oldMMs[$oldMMs_index]); // remove the item from the $oldMMs array so after this foreach loop only the ones that need to be deleted are in there.
|
||
|
unset($oldMMs_inclUid[$oldMMs_index]); // remove the item from the $oldMMs array so after this foreach loop only the ones that need to be deleted are in there.
|
||
|
unset($oldMMs_inclUid[$oldMMs_index]); // remove the item from the $oldMMs array so after this foreach loop only the ones that need to be deleted are in there.
|
||
|
} else {
|
||
|
$insertFields = $this->MM_insert_fields;
|
||
|
$insertFields[$uidLocal_field] = $uid;
|
||
|
$insertFields[$uidForeign_field] = $val['id'];
|
||
|
$insertFields[$sorting_field] = $c;
|
||
|
if($tablename) {
|
||
|
if ($tablename) {
|
||
|
$insertFields['tablenames'] = $tablename;
|
||
|
}
|
||
|
$GLOBALS['TYPO3_DB']->exec_INSERTquery($MM_tableName, $insertFields);
|
||
|
if ($this->MM_is_foreign) {
|
||
|
if ($this->MM_is_foreign) {
|
||
|
$this->updateRefIndex($val['table'], $val['id']);
|
||
|
}
|
||
|
}
|
||
|
}
|
||
|
// Delete all not-used relations:
|
||
|
if(is_array($oldMMs) && count($oldMMs) > 0) {
|
||
|
if (is_array($oldMMs) && count($oldMMs) > 0) {
|
||
|
$removeClauses = array();
|
||
|
$updateRefIndex_records = array();
|
||
|
foreach($oldMMs as $oldMM_key => $mmItem) {
|
||
|
foreach ($oldMMs as $oldMM_key => $mmItem) {
|
||
|
if ($this->MM_hasUidField) { // If UID field is present, of course we need only use that for deleting...:
|
||
|
if ($this->MM_hasUidField) { // If UID field is present, of course we need only use that for deleting...:
|
||
|
$removeClauses[] = 'uid='.intval($oldMMs_inclUid[$oldMM_key][2]);
|
||
|
$removeClauses[] = 'uid=' . intval($oldMMs_inclUid[$oldMM_key][2]);
|
||
|
$elDelete = $oldMMs_inclUid[$oldMM_key];
|
||
|
} else {
|
||
|
if(is_array($mmItem)) {
|
||
|
if (is_array($mmItem)) {
|
||
|
$removeClauses[] = 'tablenames=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($mmItem[0], $MM_tableName) . ' AND ' . $uidForeign_field . '=' . $mmItem[1];
|
||
|
} else {
|
||
|
$removeClauses[] = $uidForeign_field.'='.$mmItem;
|
||
|
$removeClauses[] = $uidForeign_field . '=' . $mmItem;
|
||
|
}
|
||
|
}
|
||
|
if ($this->MM_is_foreign) {
|
||
|
if ($this->MM_is_foreign) {
|
||
|
if(is_array($mmItem)) {
|
||
|
if (is_array($mmItem)) {
|
||
|
$updateRefIndex_records[] = array($mmItem[0],$mmItem[1]);
|
||
|
$updateRefIndex_records[] = array($mmItem[0], $mmItem[1]);
|
||
|
} else {
|
||
|
$updateRefIndex_records[] = array($this->firstTable,$mmItem);
|
||
|
$updateRefIndex_records[] = array($this->firstTable, $mmItem);
|
||
|
}
|
||
|
}
|
||
|
}
|
||
|
$deleteAddWhere = ' AND ('.implode(' OR ', $removeClauses).')';
|
||
|
$deleteAddWhere = ' AND (' . implode(' OR ', $removeClauses) . ')';
|
||
|
$GLOBALS['TYPO3_DB']->exec_DELETEquery($MM_tableName, $uidLocal_field.'='.intval($uid).$deleteAddWhere.$additionalWhere_tablenames.$additionalWhere);
|
||
|
$GLOBALS['TYPO3_DB']->exec_DELETEquery($MM_tableName, $uidLocal_field . '=' . intval($uid) . $deleteAddWhere . $additionalWhere_tablenames . $additionalWhere);
|
||
|
// Update ref index:
|
||
|
foreach($updateRefIndex_records as $pair) {
|
||
|
foreach ($updateRefIndex_records as $pair) {
|
||
|
$this->updateRefIndex($pair[0],$pair[1]);
|
||
|
$this->updateRefIndex($pair[0], $pair[1]);
|
||
|
}
|
||
|
}
|
||
|
// Update ref index; In tcemain it is not certain that this will happen because if only the MM field is changed the record itself is not updated and so the ref-index is not either. This could also have been fixed in updateDB in tcemain, however I decided to do it here ...
|
||
|
$this->updateRefIndex($this->currentTable,$uid);
|
||
|
$this->updateRefIndex($this->currentTable, $uid);
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
* @param boolean If set, then table names will always be written.
|
||
|
* @return void
|
||
|
*/
|
||
|
function remapMM($MM_tableName,$uid,$newUid,$prependTableName=0) {
|
||
|
function remapMM($MM_tableName, $uid, $newUid, $prependTableName = 0) {
|
||
|
if ($this->MM_is_foreign) { // in case of a reverse relation
|
||
|
if ($this->MM_is_foreign) { // in case of a reverse relation
|
||
|
$uidLocal_field = 'uid_foreign';
|
||
|
} else { // default
|
||
|
} else { // default
|
||
|
$uidLocal_field = 'uid_local';
|
||
|
}
|
||
|
// If there are tables...
|
||
|
$tableC = count($this->tableArray);
|
||
|
if ($tableC) {
|
||
|
if ($tableC) {
|
||
|
$prep = ($tableC>1||$prependTableName||$this->MM_isMultiTableRelationship) ? 1 : 0; // boolean: does the field "tablename" need to be filled?
|
||
|
$prep = ($tableC > 1 || $prependTableName || $this->MM_isMultiTableRelationship) ? 1 : 0; // boolean: does the field "tablename" need to be filled?
|
||
|
$c=0;
|
||
|
$c = 0;
|
||
|
$additionalWhere_tablenames = '';
|
||
|
if ($this->MM_is_foreign && $prep) {
|
||
|
if ($this->MM_is_foreign && $prep) {
|
||
|
$additionalWhere_tablenames = ' AND tablenames=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($this->currentTable, $MM_tableName);
|
||
|
}
|
||
|
$additionalWhere = '';
|
||
|
// add WHERE clause if configured
|
||
|
if ($this->MM_table_where) {
|
||
|
$additionalWhere.= LF.str_replace('###THIS_UID###', intval($uid), $this->MM_table_where);
|
||
|
$additionalWhere .= LF . str_replace('###THIS_UID###', intval($uid), $this->MM_table_where);
|
||
|
}
|
||
|
// Select, update or delete only those relations that match the configured fields
|
||
|
foreach ($this->MM_match_fields as $field => $value) {
|
||
|
$additionalWhere.= ' AND '.$field.'='.$GLOBALS['TYPO3_DB']->fullQuoteStr($value, $MM_tableName);
|
||
|
$additionalWhere .= ' AND ' . $field . '=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($value, $MM_tableName);
|
||
|
}
|
||
|
$GLOBALS['TYPO3_DB']->exec_UPDATEquery($MM_tableName, $uidLocal_field.'='.intval($uid).$additionalWhere_tablenames.$additionalWhere, array($uidLocal_field => $newUid));
|
||
|
$GLOBALS['TYPO3_DB']->exec_UPDATEquery($MM_tableName, $uidLocal_field . '=' . intval($uid) . $additionalWhere_tablenames . $additionalWhere, array($uidLocal_field => $newUid));
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
$whereClause = '';
|
||
|
$foreign_table = $conf['foreign_table'];
|
||
|
$foreign_table_field = $conf['foreign_table_field'];
|
||
|
$useDeleteClause = $this->undeleteRecord ? false : true;
|
||
|
$useDeleteClause = $this->undeleteRecord ? FALSE : TRUE;
|
||
|
// search for $uid in foreign_field, and if we have symmetric relations, do this also on symmetric_field
|
||
|
if ($conf['symmetric_field']) {
|
||
|
$whereClause = '('.$conf['foreign_field'].'='.$uid.' OR '.$conf['symmetric_field'].'='.$uid.')';
|
||
|
$whereClause = '(' . $conf['foreign_field'] . '=' . $uid . ' OR ' . $conf['symmetric_field'] . '=' . $uid . ')';
|
||
|
} else {
|
||
|
$whereClause = $conf['foreign_field'].'='.$uid;
|
||
|
$whereClause = $conf['foreign_field'] . '=' . $uid;
|
||
|
}
|
||
|
// use the deleteClause (e.g. "deleted=0") on this table
|
||
|
if ($useDeleteClause) {
|
||
| ... | ... | |
|
// if it's requested to look for the parent uid AND the parent table,
|
||
|
// add an additional SQL-WHERE clause
|
||
|
if ($foreign_table_field && $this->currentTable) {
|
||
|
$whereClause .= ' AND '.$foreign_table_field.'='.$GLOBALS['TYPO3_DB']->fullQuoteStr($this->currentTable, $foreign_table);
|
||
|
$whereClause .= ' AND ' . $foreign_table_field . '=' . $GLOBALS['TYPO3_DB']->fullQuoteStr($this->currentTable, $foreign_table);
|
||
|
}
|
||
|
// Select children in the same workspace:
|
||
| ... | ... | |
|
}
|
||
|
// get the correct sorting field
|
||
|
if ($conf['foreign_sortby']) { // specific manual sortby for data handled by this field
|
||
|
if ($conf['foreign_sortby']) { // specific manual sortby for data handled by this field
|
||
|
if ($conf['symmetric_sortby'] && $conf['symmetric_field']) {
|
||
|
// sorting depends on, from which side of the relation we're looking at it
|
||
|
$sortby = '
|
||
|
CASE
|
||
|
WHEN '.$conf['foreign_field'].'='.$uid.'
|
||
|
WHEN ' . $conf['foreign_field'] . '=' . $uid . '
|
||
|
THEN '.$conf['foreign_sortby'].'
|
||
|
THEN ' . $conf['foreign_sortby'] . '
|
||
|
ELSE '.$conf['symmetric_sortby'].'
|
||
|
ELSE ' . $conf['symmetric_sortby'] . '
|
||
|
END';
|
||
|
} else {
|
||
|
// regular single-side behaviour
|
||
|
$sortby = $conf['foreign_sortby'];
|
||
|
}
|
||
|
} elseif ($conf['foreign_default_sortby']) { // specific default sortby for data handled by this field
|
||
|
} elseif ($conf['foreign_default_sortby']) { // specific default sortby for data handled by this field
|
||
|
$sortby = $conf['foreign_default_sortby'];
|
||
|
} elseif ($GLOBALS['TCA'][$foreign_table]['ctrl']['sortby']) { // manual sortby for all table records
|
||
|
} elseif ($GLOBALS['TCA'][$foreign_table]['ctrl']['sortby']) { // manual sortby for all table records
|
||
|
$sortby = $GLOBALS['TCA'][$foreign_table]['ctrl']['sortby'];
|
||
|
} elseif ($GLOBALS['TCA'][$foreign_table]['ctrl']['default_sortby']) { // default sortby for all table records
|
||
|
} elseif ($GLOBALS['TCA'][$foreign_table]['ctrl']['default_sortby']) { // default sortby for all table records
|
||
|
$sortby = $GLOBALS['TCA'][$foreign_table]['ctrl']['default_sortby'];
|
||
|
}
|
||
| ... | ... | |
|
foreach ($rows as $row) {
|
||
|
$this->itemArray[$key]['id'] = $row['uid'];
|
||
|
$this->itemArray[$key]['table'] = $foreign_table;
|
||
|
$this->tableArray[$foreign_table][]= $row['uid'];
|
||
|
$this->tableArray[$foreign_table][] = $row['uid'];
|
||
|
$key++;
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
* @param array $conf: TCA configuration for current field
|
||
|
* @param integer $parentUid: The uid of the parent record
|
||
|
* @param boolean $updateToUid: Whether to update the foreign field with the $parentUid (on Copy)
|
||
|
* @param boolean $skipSorting: Do not update the sorting columns, this could happen for imported values
|
||
|
* @param boolean $skipSorting: Do not update the sorting columns, this could happen for imported values
|
||
|
* @return void
|
||
|
*/
|
||
|
function writeForeignField($conf, $parentUid, $updateToUid=0, $skipSorting=false) {
|
||
|
function writeForeignField($conf, $parentUid, $updateToUid = 0, $skipSorting = FALSE) {
|
||
|
$c = 0;
|
||
|
$foreign_table = $conf['foreign_table'];
|
||
|
$foreign_field = $conf['foreign_field'];
|
||
| ... | ... | |
|
if (!(t3lib_div::testInt($updateToUid) && $updateToUid > 0)) {
|
||
|
$updateToUid = 0;
|
||
|
}
|
||
|
$fields = 'uid,'.$foreign_field.($symmetric_field ? ','.$symmetric_field : '');
|
||
|
$fields = 'uid,' . $foreign_field . ($symmetric_field ? ',' . $symmetric_field : '');
|
||
|
// update all items
|
||
|
foreach ($this->itemArray as $val) {
|
||
| ... | ... | |
|
// fetch the current (not overwritten) relation record if we should handle symmetric relations
|
||
|
if ($conf['symmetric_field']) {
|
||
|
$row = t3lib_BEfunc::getRecord($table,$uid,$fields,'',false);
|
||
|
$row = t3lib_BEfunc::getRecord($table, $uid, $fields, '', FALSE);
|
||
|
$isOnSymmetricSide = t3lib_loadDBGroup::isOnSymmetricSide($parentUid, $conf, $row);
|
||
|
}
|
||
| ... | ... | |
|
// update sorting columns if not to be skipped
|
||
|
if (!$skipSorting) {
|
||
|
// get the correct sorting field
|
||
|
if ($conf['foreign_sortby']) { // specific manual sortby for data handled by this field
|
||
|
if ($conf['foreign_sortby']) { // specific manual sortby for data handled by this field
|
||
|
$sortby = $conf['foreign_sortby'];
|
||
|
} elseif ($GLOBALS['TCA'][$foreign_table]['ctrl']['sortby']) { // manual sortby for all table records
|
||
|
} elseif ($GLOBALS['TCA'][$foreign_table]['ctrl']['sortby']) { // manual sortby for all table records
|
||
|
$sortby = $GLOBALS['TCA'][$foreign_table]['ctrl']['sortby'];
|
||
|
}
|
||
|
// strip a possible "ORDER BY" in front of the $sortby value
|
||
| ... | ... | |
|
}
|
||
|
}
|
||
|
// update to a foreign_field/symmetric_field pointer is requested, normally used on record copies
|
||
|
// only update the fields, if the old uid is found somewhere - for select fields, TCEmain is doing this already!
|
||
|
// update to a foreign_field/symmetric_field pointer is requested, normally used on record copies
|
||
|
// only update the fields, if the old uid is found somewhere - for select fields, TCEmain is doing this already!
|
||
|
} else {
|
||
|
if ($isOnSymmetricSide) {
|
||
|
$updateValues[$symmetric_field] = $updateToUid;
|
||
| ... | ... | |
|
* @param boolean If set, then table names will ALWAYS be prepended (unless its a _NO_TABLE value)
|
||
|
* @return array A numeric array.
|
||
|
*/
|
||
|
function getValueArray($prependTableName='') {
|
||
|
function getValueArray($prependTableName = '') {
|
||
|
// INIT:
|
||
|
$valueArray=Array();
|
||
|
$valueArray = Array();
|
||
|
$tableC = count($this->tableArray);
|
||
|
// If there are tables in the table array:
|
||
|
if ($tableC) {
|
||
|
if ($tableC) {
|
||
|
// If there are more than ONE table in the table array, then always prepend table names:
|
||
|
$prep = ($tableC>1||$prependTableName) ? 1 : 0;
|
||
|
$prep = ($tableC > 1 || $prependTableName) ? 1 : 0;
|
||
|
// Traverse the array of items:
|
||
|
foreach($this->itemArray as $val) {
|
||
|
foreach ($this->itemArray as $val) {
|
||
|
$valueArray[]=(($prep && $val['table']!='_NO_TABLE') ? $val['table'].'_' : '').
|
||
|
$valueArray[] = (($prep && $val['table'] != '_NO_TABLE') ? $val['table'] . '_' : '') .
|
||
|
$val['id'];
|
||
|
$val['id'];
|
||
|
}
|
||
|
}
|
||
|
// Return the array
|
||
| ... | ... | |
|
* @param string NEGative foreign table
|
||
|
* @return 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.
|
||
|
*/
|
||
|
function convertPosNeg($valueArray,$fTable,$nfTable) {
|
||
|
function convertPosNeg($valueArray, $fTable, $nfTable) {
|
||
|
if (is_array($valueArray) && $fTable) {
|
||
|
if (is_array($valueArray) && $fTable) {
|
||
|
foreach($valueArray as $key => $val) {
|
||
|
foreach ($valueArray as $key => $val) {
|
||
|
$val = strrev($val);
|
||
|
$parts = explode('_',$val,2);
|
||
|
$parts = explode('_', $val, 2);
|
||
|
$theID = strrev($parts[0]);
|
||
|
$theTable = strrev($parts[1]);
|
||
|
if ( t3lib_div::testInt($theID) && (!$theTable || !strcmp($theTable,$fTable) || !strcmp($theTable,$nfTable)) ) {
|
||
|
if (t3lib_div::testInt($theID) && (!$theTable || !strcmp($theTable, $fTable) || !strcmp($theTable, $nfTable))) {
|
||
|
$valueArray[$key]= $theTable && strcmp($theTable,$fTable) ? $theID*-1 : $theID;
|
||
|
$valueArray[$key] = $theTable && strcmp($theTable, $fTable) ? $theID * -1 : $theID;
|
||
|
}
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
*
|
||
|
* @return void
|
||
|
*/
|
||
|
function getFromDB() {
|
||
|
function getFromDB() {
|
||
|
// Traverses the tables listed:
|
||
|
foreach($this->tableArray as $key => $val) {
|
||
|
foreach ($this->tableArray as $key => $val) {
|
||
|
if (is_array($val)) {
|
||
|
if (is_array($val)) {
|
||
|
$itemList = implode(',',$val);
|
||
|
$itemList = implode(',', $val);
|
||
|
if ($itemList) {
|
||
|
if ($itemList) {
|
||
|
$from = '*';
|
||
|
if ($this->fromTC) {
|
||
|
if ($this->fromTC) {
|
||
|
$from = 'uid,pid';
|
||
|
if ($GLOBALS['TCA'][$key]['ctrl']['label']) {
|
||
|
if ($GLOBALS['TCA'][$key]['ctrl']['label']) {
|
||
|
$from.= ','.$GLOBALS['TCA'][$key]['ctrl']['label']; // Titel
|
||
|
$from .= ',' . $GLOBALS['TCA'][$key]['ctrl']['label']; // Titel
|
||
|
}
|
||
|
if ($GLOBALS['TCA'][$key]['ctrl']['label_alt']) {
|
||
|
if ($GLOBALS['TCA'][$key]['ctrl']['label_alt']) {
|
||
|
$from.= ','.$GLOBALS['TCA'][$key]['ctrl']['label_alt']; // Alternative Title-Fields
|
||
|
$from .= ',' . $GLOBALS['TCA'][$key]['ctrl']['label_alt']; // Alternative Title-Fields
|
||
|
}
|
||
|
if ($GLOBALS['TCA'][$key]['ctrl']['thumbnail']) {
|
||
|
if ($GLOBALS['TCA'][$key]['ctrl']['thumbnail']) {
|
||
|
$from.= ','.$GLOBALS['TCA'][$key]['ctrl']['thumbnail']; // Thumbnail
|
||
|
$from .= ',' . $GLOBALS['TCA'][$key]['ctrl']['thumbnail']; // Thumbnail
|
||
|
}
|
||
|
}
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($from, $key, 'uid IN ('.$itemList.')'.$this->additionalWhere[$key]);
|
||
|
$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($from, $key, 'uid IN (' . $itemList . ')' . $this->additionalWhere[$key]);
|
||
|
while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
|
||
|
$this->results[$key][$row['uid']]=$row;
|
||
|
$this->results[$key][$row['uid']] = $row;
|
||
|
}
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
* @return string
|
||
|
* @see t3lib_transferdata::renderRecord()
|
||
|
*/
|
||
|
function readyForInterface() {
|
||
|
function readyForInterface() {
|
||
|
global $TCA;
|
||
|
if (!is_array($this->itemArray)) {return false;}
|
||
|
if (!is_array($this->itemArray)) {
|
||
|
return FALSE;
|
||
|
}
|
||
|
$output=array();
|
||
|
$output = array();
|
||
|
$perms_clause = $GLOBALS['BE_USER']->getPagePermsClause(1); // For use when getting the paths....
|
||
|
$perms_clause = $GLOBALS['BE_USER']->getPagePermsClause(1); // For use when getting the paths....
|
||
|
$titleLen=intval($GLOBALS['BE_USER']->uc['titleLen']);
|
||
|
$titleLen = intval($GLOBALS['BE_USER']->uc['titleLen']);
|
||
|
foreach($this->itemArray as $key => $val) {
|
||
|
foreach ($this->itemArray as $key => $val) {
|
||
|
$theRow = $this->results[$val['table']][$val['id']];
|
||
|
if ($theRow && is_array($TCA[$val['table']])) {
|
||
|
if ($theRow && is_array($TCA[$val['table']])) {
|
||
|
$label = t3lib_div::fixed_lgd_cs(strip_tags(t3lib_BEfunc::getRecordTitle($val['table'], $theRow)),$titleLen);
|
||
|
$label = t3lib_div::fixed_lgd_cs(strip_tags(t3lib_BEfunc::getRecordTitle($val['table'], $theRow)), $titleLen);
|
||
|
$label = ($label)?$label:'[...]';
|
||
|
$label = ($label) ? $label : '[...]';
|
||
|
$output[]=str_replace(',','',$val['table'].'_'.$val['id'].'|'.rawurlencode($label));
|
||
|
$output[] = str_replace(',', '', $val['table'] . '_' . $val['id'] . '|' . rawurlencode($label));
|
||
|
}
|
||
|
}
|
||
|
return implode(',',$output);
|
||
|
return implode(',', $output);
|
||
|
}
|
||
|
/**
|
||
| ... | ... | |
|
* @param boolean Whether to put the count value in an array
|
||
|
* @return mixed The plain count as integer or the same inside an array
|
||
|
*/
|
||
|
function countItems($returnAsArray = true) {
|
||
|
function countItems($returnAsArray = TRUE) {
|
||
|
$count = count($this->itemArray);
|
||
|
if ($returnAsArray) $count = array($count);
|
||
|
if ($returnAsArray) {
|
||
|
$count = array($count);
|
||
|
}
|
||
|
return $count;
|
||
|
}
|
||
| ... | ... | |
|
* @param integer Record UID
|
||
|
* @return array Information concerning modifications delivered by t3lib_refindex::updateRefIndexTable()
|
||
|
*/
|
||
|
function updateRefIndex($table,$id) {
|
||
|
function updateRefIndex($table, $id) {
|
||
|
if ($this->updateReferenceIndex === TRUE) {
|
||
|
/** @var $refIndexObj t3lib_refindex */
|
||
|
$refIndexObj = t3lib_div::makeInstance('t3lib_refindex');
|
||
|
return $refIndexObj->updateRefIndexTable($table,$id);
|
||
|
return $refIndexObj->updateRefIndexTable($table, $id);
|
||
|
}
|
||
|
}
|
||
| ... | ... | |
|
*/
|
||
|
function isOnSymmetricSide($parentUid, $parentConf, $childRec) {
|
||
|
return t3lib_div::testInt($childRec['uid']) && $parentConf['symmetric_field'] && $parentUid == $childRec[$parentConf['symmetric_field']]
|
||
|
? true
|
||
|
: false;
|
||
|
? TRUE
|
||
|
: FALSE;
|
||
|
}
|
||
|
}
|
||
|
if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_loaddbgroup.php']) {
|
||
|
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']);
|
||
|
}
|
||