class.t3lib_loaddbgroup.php

Go to the documentation of this file.

<?php
/***************************************************************
*  Copyright notice
*
*  (c) 1999-2004 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 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);
      }
   }

   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 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']);
}
?>

---