PageRenderTime 1543ms CodeModel.GetById 72ms RepoModel.GetById 11ms app.codeStats 0ms

/typo3/class.db_list_extra.inc

https://bitbucket.org/linxpinx/mercurial
PHP | 1878 lines | 1127 code | 263 blank | 488 comment | 264 complexity | eab6c910d7f7936dde0dd9ea1c52e184 MD5 | raw file
Possible License(s): BSD-3-Clause, GPL-2.0, Unlicense, LGPL-2.1, Apache-2.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. /*************************************************************
    3. 

  3. *  Copyright notice
    4. 

  4. *
    5. 

  5. *  (c) 1999-2009 Kasper Skaarhoj (kasperYYYY@typo3.com)
    6. 

  6. *  All rights reserved
    7. 

  7. *
    8. 

  8. *  This script is part of the TYPO3 project. The TYPO3 project is
    9. 

  9. *  free software; you can redistribute it and/or modify
    10. 

  10. *  it under the terms of the GNU General Public License as published by
    11. 

  11. *  the Free Software Foundation; either version 2 of the License, or
    12. 

  12. *  (at your option) any later version.
    13. 

  13. *
    14. 

  14. *  The GNU General Public License can be found at
    15. 

  15. *  http://www.gnu.org/copyleft/gpl.html.
    16. 

  16. *  A copy is found in the textfile GPL.txt and important notices to the license
    17. 

  17. *  from the author is found in LICENSE.txt distributed with these scripts.
    18. 

  18. *
    19. 

  19. *
    20. 

  20. *  This script is distributed in the hope that it will be useful,
    21. 

  21. *  but WITHOUT ANY WARRANTY; without even the implied warranty of
    22. 

  22. *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    23. 

  23. *  GNU General Public License for more details.
    24. 

  24. *
    25. 

  25. *  This copyright notice MUST APPEAR in all copies of the script!
    26. 

  26. ***************************************************************/
    27. 

  27. /**
    28. 

  28.  * Include file extending recordList which extended t3lib_recordList
    29. 

  29.  * Used specifically for the Web>List module (db_list.php)
    30. 

  30.  *
    31. 

  31.  * $Id: class.db_list_extra.inc 8289 2010-07-27 19:08:35Z psychomieze $
    32. 

  32.  * Revised for TYPO3 3.6 December/2003 by Kasper Skaarhoj
    33. 

  33.  * XHTML compliant
    34. 

  34.  *
    35. 

  35.  * @author	Kasper Skaarhoj <kasperYYYY@typo3.com>
    36. 

  36.  */
    37. 

  37. /**
    38. 

  38.  * [CLASS/FUNCTION INDEX of SCRIPT]
    39. 

  39.  *
    40. 

  40.  *
    41. 

  41.  *
    42. 

  42.  *   91: class localRecordList extends recordList
    43. 

  43.  *  123:     function writeTop($row)
    44. 

  44.  *  304:     function getTable($table,$id,$rowlist)
    45. 

  45.  *  559:     function renderListRow($table,$row,$cc,$titleCol,$thumbsCol,$indent=0)
    46. 

  46.  *  648:     function renderListHeader($table,$currentIdList)
    47. 

  47.  *
    48. 

  48.  *              SECTION: Rendering of various elements
    49. 

  49.  *  796:     function makeControl($table,$row)
    50. 

  50.  *  986:     function makeClip($table,$row)
    51. 

  51.  * 1057:     function makeRef($table,$uid)
    52. 

  52.  * 1086:     function makeLocalizationPanel($table,$row)
    53. 

  53.  * 1148:     function fieldSelectBox($table,$formFields=1)
    54. 

  54.  *
    55. 

  55.  *              SECTION: Helper functions
    56. 

  56.  * 1231:     function linkClipboardHeaderIcon($string,$table,$cmd,$warning='')
    57. 

  57.  * 1242:     function clipNumPane()
    58. 

  58.  * 1256:     function addSortLink($code,$field,$table)
    59. 

  59.  * 1281:     function recPath($pid)
    60. 

  60.  * 1294:     function showNewRecLink($table)
    61. 

  61.  * 1304:     function makeReturnUrl()
    62. 

  62.  *
    63. 

  63.  *              SECTION: CSV related functions
    64. 

  64.  * 1329:     function initCSV()
    65. 

  65.  * 1352:     function addToCSV($row,$table)
    66. 

  66.  * 1376:     function setCsvRow($csvRow)
    67. 

  67.  * 1387:     function outputCSV($prefix)
    68. 

  68.  *
    69. 

  69.  * TOTAL FUNCTIONS: 19
    70. 

  70.  * (This index is automatically created/updated by the extension "extdeveval")
    71. 

  71.  *
    72. 

  72.  */
    73. 

  73. 

  74. 

  75. 

  76. 

  77. 

  78. 

  79. 

  80. 

  81. 

  82. 

  83. /**
    84. 

  84.  * Class for rendering of Web>List module
    85. 

  85.  *
    86. 

  86.  * @author	Kasper Skaarhoj <kasperYYYY@typo3.com>
    87. 

  87.  * @package TYPO3
    88. 

  88.  * @subpackage core
    89. 

  89.  */
    90. 

  90. class localRecordList extends recordList {
    91. 

  91. 

  92. 		// External:
    93. 

  93. 	var $alternateBgColors=FALSE;			// If true, table rows in the list will alternate in background colors (and have background colors at all!)
    94. 

  94. 	var $allowedNewTables=array();			// Used to indicate which tables (values in the array) that can have a create-new-record link. If the array is empty, all tables are allowed.
    95. 

  95. 	var $deniedNewTables=array();			// Used to indicate which tables (values in the array) that cannot have a create-new-record link. If the array is empty, all tables are allowed.
    96. 

  96. 	var $newWizards=FALSE;					// If true, the control panel will contain links to the create-new wizards for pages and tt_content elements (normally, the link goes to just creating a new element without the wizards!).
    97. 

  97. 

  98. 	var $dontShowClipControlPanels=FALSE;	// If true, will disable the rendering of clipboard + control panels.
    99. 

  99. 	var $showClipboard=FALSE;				// If true, will show the clipboard in the field list.
    100. 

  100.  	var $noControlPanels = FALSE;			// If true, will DISABLE all control panels in lists. (Takes precedence)
    101. 

  101. 	var $clickMenuEnabled = TRUE;			// If true, clickmenus will be rendered
    102. 

  102. 

  103. 	var $totalRowCount;						// count of record rows in view
    104. 

  104. 

  105. 	var $spaceIcon;							// space icon used for alignment
    106. 

  106. 

  107. 		// Internal:
    108. 

  108. 	var $pageRow=array();					// Set to the page record (see writeTop())
    109. 

  109. 

  110. 		// Used to accumulate CSV lines for CSV export.
    111. 

  111. 	protected $csvLines = array();
    112. 

  112. 

  113. 	var $csvOutput=FALSE;					// If set, the listing is returned as CSV instead.
    114. 

  114. 

  115. 	/**
    116. 

  116. 	 * Clipboard object
    117. 

  117. 	 *
    118. 

  118. 	 * @var t3lib_clipboard
    119. 

  119. 	 */
    120. 

  120. 	var $clipObj;
    121. 

  121. 	var $CBnames=array();					// Tracking names of elements (for clipboard use)
    122. 

  122. 	var $duplicateStack=array();			// Used to track which elements has duplicates and how many
    123. 

  123. 

  124. 	/**
    125. 

  125. 	 * references of the current record
    126. 

  126. 	 *
    127. 

  127. 	 * @var array
    128. 

  128. 	 *
    129. 

  129. 	 * @deprecated since 4.4: Use getReferenceCount instead
    130. 

  130. 	 */
    131. 

  131. 	public $references;
    132. 

  132. 

  133. 	/**
    134. 

  134. 	 * [$tablename][$uid] = number of references to this record
    135. 

  135. 	 *
    136. 

  136. 	 * @var array
    137. 

  137. 	 */
    138. 

  138. 	protected $referenceCount = array();
    139. 

  139. 

  140. 	var $translations;						// Translations of the current record
    141. 

  141. 	var $selFieldList;						// select fields for the query which fetches the translations of the current record
    142. 

  142. 

  143. 	public function __construct() {
    144. 

  144. 		parent::__construct();
    145. 

  145. 	}
    146. 

  146. 

  147. 	/**
    148. 

  148. 	 * Create the panel of buttons for submitting the form or otherwise perform operations.
    149. 

  149. 	 *
    150. 

  150. 	 * @return	array	all available buttons as an assoc. array
    151. 

  151. 	 */
    152. 

  152. 	public function getButtons()	{
    153. 

  153. 		global $LANG;
    154. 

  154. 

  155. 		$buttons = array(
    156. 

  156. 			'csh' => '',
    157. 

  157. 			'view' => '',
    158. 

  158. 			'edit' => '',
    159. 

  159. 			'hide_unhide' => '',
    160. 

  160. 			'move' => '',
    161. 

  161. 			'new_record' => '',
    162. 

  162. 			'paste' => '',
    163. 

  163. 			'level_up' => '',
    164. 

  164. 			'cache' => '',
    165. 

  165. 			'reload' => '',
    166. 

  166. 			'shortcut' => '',
    167. 

  167. 			'back' => '',
    168. 

  168. 			'csv' => '',
    169. 

  169. 			'export' => ''
    170. 

  170. 		);
    171. 

  171. 

  172. 			// Get users permissions for this page record:
    173. 

  173. 		$localCalcPerms = $GLOBALS['BE_USER']->calcPerms($this->pageRow);
    174. 

  174. 

  175. 			// CSH
    176. 

  176. 		if (!strlen($this->id))	{
    177. 

  177. 			$buttons['csh'] = t3lib_BEfunc::cshItem('xMOD_csh_corebe', 'list_module_noId', $GLOBALS['BACK_PATH'], '', TRUE);
    178. 

  178. 		} elseif(!$this->id) {
    179. 

  179. 			$buttons['csh'] = t3lib_BEfunc::cshItem('xMOD_csh_corebe', 'list_module_root', $GLOBALS['BACK_PATH'], '', TRUE);
    180. 

  180. 		} else {
    181. 

  181. 			$buttons['csh'] = t3lib_BEfunc::cshItem('xMOD_csh_corebe', 'list_module', $GLOBALS['BACK_PATH'], '', TRUE);
    182. 

  182. 		}
    183. 

  183. 

  184. 		if (isset($this->id)) {
    185. 

  185. 				// View  Exclude doktypes 254,255 Configuration: mod.web_list.noViewWithDokTypes = 254,255
    186. 

  186. 			if (isset($GLOBALS['SOBE']->modTSconfig['properties']['noViewWithDokTypes'])) {
    187. 

  187. 				$noViewDokTypes = t3lib_div::trimExplode(',', $GLOBALS['SOBE']->modTSconfig['properties']['noViewWithDokTypes'], true);
    188. 

  188. 			} else {
    189. 

  189. 					//default exclusion: doktype 254, 255
    190. 

  190. 				$noViewDokTypes = array('254', '255');
    191. 

  191. 			}
    192. 

  192. 

  193. 			if (!in_array($this->pageRow['doktype'], $noViewDokTypes)) {
    194. 

  194. 				$buttons['view'] = '<a href="#" onclick="' . htmlspecialchars(t3lib_BEfunc::viewOnClick($this->id, $this->backPath, t3lib_BEfunc::BEgetRootLine($this->id))) . '" title="' . $LANG->sL('LLL:EXT:lang/locallang_core.php:labels.showPage', TRUE) . '">' .
    195. 

  195. 								t3lib_iconWorks::getSpriteIcon('actions-document-view') .
    196. 

  196. 							'</a>';
    197. 

  197. 			}
    198. 

  198. 

  199. 				// New record
    200. 

  200. 			if (!$GLOBALS['SOBE']->modTSconfig['properties']['noCreateRecordsLink']) {
    201. 

  201. 				$buttons['new_record'] = '<a href="#" onclick="' . htmlspecialchars('return jumpExt(\'' . $this->backPath . 'db_new.php?id=' . $this->id . '\');') . '" title="' . $LANG->getLL('newRecordGeneral', TRUE) . '">' .
    202. 

  202. 									t3lib_iconWorks::getSpriteIcon('actions-document-new') .
    203. 

  203. 								'</a>';
    204. 

  204. 			}
    205. 

  205. 

  206. 				// If edit permissions are set (see class.t3lib_userauthgroup.php)
    207. 

  207. 			if ($localCalcPerms&2 && !empty($this->id))	{
    208. 

  208. 

  209. 					// Edit
    210. 

  210. 				$params = '&edit[pages][' . $this->pageRow['uid'] . ']=edit';
    211. 

  211. 				$buttons['edit'] = '<a href="#" onclick="' . htmlspecialchars(t3lib_BEfunc::editOnClick($params, $this->backPath, -1)) . '" title="' . $LANG->getLL('editPage', TRUE) . '">' .
    212. 

  212. 									t3lib_iconWorks::getSpriteIcon('actions-page-open') .
    213. 

  213. 								'</a>';
    214. 

  214. 					// Unhide
    215. 

  215. 				if ($this->pageRow['hidden'])	{
    216. 

  216. 					$params = '&data[pages][' . $this->pageRow['uid'] . '][hidden]=0';
    217. 

  217. 					$buttons['hide_unhide'] = '<a href="#" onclick="' . htmlspecialchars('return jumpToUrl(\'' . $GLOBALS['SOBE']->doc->issueCommand($params, -1) . '\');') . '" title="' . $LANG->getLL('unHidePage', TRUE) . '">' .
    218. 

  218. 										t3lib_iconWorks::getSpriteIcon('actions-edit-unhide') .
    219. 

  219. 									'</a>';
    220. 

  220. 					// Hide
    221. 

  221. 				} else {
    222. 

  222. 					$params = '&data[pages][' . $this->pageRow['uid'] . '][hidden]=1';
    223. 

  223. 					$buttons['hide_unhide'] = '<a href="#" onclick="' . htmlspecialchars('return jumpToUrl(\'' . $GLOBALS['SOBE']->doc->issueCommand($params, -1) . '\');') . '" title="' . $LANG->getLL('hidePage', TRUE) . '">'.
    224. 

  224. 										t3lib_iconWorks::getSpriteIcon('actions-edit-hide') .
    225. 

  225. 									'</a>';
    226. 

  226. 				}
    227. 

  227. 

  228. 					// Move
    229. 

  229. 				$buttons['move'] = '<a href="#" onclick="' . htmlspecialchars('return jumpExt(\'' . $this->backPath . 'move_el.php?table=pages&uid=' . $this->pageRow['uid'] . '\');') . '" title="' . $LANG->getLL('move_page', TRUE) . '">' .
    230. 

  230. 									(($this->table == 'tt_content') ? t3lib_iconWorks::getSpriteIcon('actions-document-move') : t3lib_iconWorks::getSpriteIcon('actions-page-move')) .
    231. 

  231. 								'</a>';
    232. 

  232. 

  233. 					// Up one level
    234. 

  234. 				$buttons['level_up'] = '<a href="' . htmlspecialchars($this->listURL($this->pageRow['pid'])) . '" onclick="setHighlight(' . $this->pageRow['pid'] . ')" title="' . $LANG->sL('LLL:EXT:lang/locallang_core.php:labels.upOneLevel', TRUE) . '">' .
    235. 

  235. 								t3lib_iconWorks::getSpriteIcon('actions-view-go-up') .
    236. 

  236. 							'</a>';
    237. 

  237. 

  238. 			}
    239. 

  239. 

  240. 

  241. 				// Paste
    242. 

  242. 			if (($localCalcPerms&8) || ($localCalcPerms&16)) {
    243. 

  243. 				$elFromTable = $this->clipObj->elFromTable('');
    244. 

  244. 				if (count($elFromTable)) {
    245. 

  245. 					$buttons['paste'] = '<a href="' . htmlspecialchars($this->clipObj->pasteUrl('', $this->id)) . '" onclick="' . htmlspecialchars('return ' . $this->clipObj->confirmMsg('pages', $this->pageRow, 'into', $elFromTable)) . '" title="' . $LANG->getLL('clip_paste', TRUE) . '">' .
    246. 

  246. 										t3lib_iconWorks::getSpriteIcon('actions-document-paste-after') .
    247. 

  247. 									'</a>';
    248. 

  248. 				}
    249. 

  249. 			}
    250. 

  250. 

  251. 				// Cache
    252. 

  252. 			$buttons['cache'] = '<a href="' . htmlspecialchars($this->listURL() . '&clear_cache=1') . '" title="' . $LANG->sL('LLL:EXT:lang/locallang_core.php:labels.clear_cache', TRUE) . '">' .
    253. 

  253. 								t3lib_iconWorks::getSpriteIcon('actions-system-cache-clear') .
    254. 

  254. 							'</a>';
    255. 

  255. 

  256. 			if ($this->table) {
    257. 

  257. 

  258. 					// CSV
    259. 

  259. 				$buttons['csv'] = '<a href="' . htmlspecialchars($this->listURL() . '&csv=1') . '" title="' . $LANG->sL('LLL:EXT:lang/locallang_core.php:labels.csv', TRUE) . '">' .
    260. 

  260. 									t3lib_iconWorks::getSpriteIcon('mimetypes-text-csv') .
    261. 

  261. 								'</a>';
    262. 

  262. 

  263. 					// Export
    264. 

  264. 				if (t3lib_extMgm::isLoaded('impexp')) {
    265. 

  265. 					$url = $this->backPath . t3lib_extMgm::extRelPath('impexp') . 'app/index.php?tx_impexp[action]=export';
    266. 

  266. 					$buttons['export'] = '<a href="' . htmlspecialchars($url . '&tx_impexp[list][]=' . rawurlencode($this->table . ':' . $this->id)) . '" title="' . $LANG->sL('LLL:EXT:lang/locallang_core.php:rm.export', TRUE) . '">' .
    267. 

  267. 								t3lib_iconWorks::getSpriteIcon('actions-document-export-t3d') .
    268. 

  268. 							'</a>';
    269. 

  269. 				}
    270. 

  270. 

  271. 			}
    272. 

  272. 

  273. 				// Reload
    274. 

  274. 			$buttons['reload'] = '<a href="' . htmlspecialchars($this->listURL()) . '" title="' . $LANG->sL('LLL:EXT:lang/locallang_core.php:labels.reload', TRUE) . '">' .
    275. 

  275. 								t3lib_iconWorks::getSpriteIcon('actions-system-refresh') .
    276. 

  276. 							'</a>';
    277. 

  277. 

  278. 				// Shortcut
    279. 

  279. 			if ($GLOBALS['BE_USER']->mayMakeShortcut()) {
    280. 

  280. 				$buttons['shortcut'] = $GLOBALS['TBE_TEMPLATE']->makeShortcutIcon('id, imagemode, pointer, table, search_field, search_levels, showLimit, sortField, sortRev', implode(',', array_keys($this->MOD_MENU)), 'web_list');
    281. 

  281. 			}
    282. 

  282. 

  283. 				// Back
    284. 

  284. 			if ($this->returnUrl) {
    285. 

  285. 				$buttons['back'] = '<a href="' . htmlspecialchars(t3lib_div::linkThisUrl($this->returnUrl, array('id' => $this->id))) . '" class="typo3-goBack" title="' . $LANG->sL('LLL:EXT:lang/locallang_core.php:labels.goBack', TRUE) . '">' .
    286. 

  286. 									t3lib_iconWorks::getSpriteIcon('actions-view-go-back') .
    287. 

  287. 								'</a>';
    288. 

  288. 			}
    289. 

  289. 		}
    290. 

  290. 

  291. 		return $buttons;
    292. 

  292. 	}
    293. 

  293. 

  294. 	/**
    295. 

  295. 	 * Creates the listing of records from a single table
    296. 

  296. 	 *
    297. 

  297. 	 * @param	string		Table name
    298. 

  298. 	 * @param	integer		Page id
    299. 

  299. 	 * @param	string		List of fields to show in the listing. Pseudo fields will be added including the record header.
    300. 

  300. 	 * @return	string		HTML table with the listing for the record.
    301. 

  301. 	 */
    302. 

  302. 	function getTable($table,$id,$rowlist)	{
    303. 

  303. 		global $TCA, $TYPO3_CONF_VARS;
    304. 

  304. 

  305. 			// Loading all TCA details for this table:
    306. 

  306. 		t3lib_div::loadTCA($table);
    307. 

  307. 

  308. 			// Init
    309. 

  309. 		$addWhere = '';
    310. 

  310. 		$titleCol = $TCA[$table]['ctrl']['label'];
    311. 

  311. 		$thumbsCol = $TCA[$table]['ctrl']['thumbnail'];
    312. 

  312. 		$l10nEnabled = $TCA[$table]['ctrl']['languageField'] && $TCA[$table]['ctrl']['transOrigPointerField'] && !$TCA[$table]['ctrl']['transOrigPointerTable'];
    313. 

  313. 		$tableCollapsed = (!$this->tablesCollapsed[$table]) ? false : true;
    314. 

  314. 

  315. 		// prepare space icon
    316. 

  316. 		$this->spaceIcon = t3lib_iconWorks::getSpriteIcon('empty-empty', array('style' => 'background-position: 0 10px;'));
    317. 

  317. 

  318. 			// Cleaning rowlist for duplicates and place the $titleCol as the first column always!
    319. 

  319. 		$this->fieldArray=array();
    320. 

  320. 			// title Column
    321. 

  321. 		$this->fieldArray[] = $titleCol;	// Add title column
    322. 

  322. 			// Control-Panel
    323. 

  323. 		if (!t3lib_div::inList($rowlist,'_CONTROL_'))	{
    324. 

  324. 			$this->fieldArray[] = '_CONTROL_';
    325. 

  325. 			$this->fieldArray[] = '_AFTERCONTROL_';
    326. 

  326. 		}
    327. 

  327. 			// Clipboard
    328. 

  328. 		if ($this->showClipboard)	{
    329. 

  329. 			$this->fieldArray[] = '_CLIPBOARD_';
    330. 

  330. 		}
    331. 

  331. 			// Ref
    332. 

  332. 		if (!$this->dontShowClipControlPanels)	{
    333. 

  333. 			$this->fieldArray[]='_REF_';
    334. 

  334. 			$this->fieldArray[]='_AFTERREF_';
    335. 

  335. 		}
    336. 

  336. 			// Path
    337. 

  337. 		if ($this->searchLevels)	{
    338. 

  338. 			$this->fieldArray[]='_PATH_';
    339. 

  339. 		}
    340. 

  340. 			// Localization
    341. 

  341. 		if ($this->localizationView && $l10nEnabled)	{
    342. 

  342. 			$this->fieldArray[] = '_LOCALIZATION_';
    343. 

  343. 			$this->fieldArray[] = '_LOCALIZATION_b';
    344. 

  344. 			$addWhere.=' AND (
    345. 

  345. 				'.$TCA[$table]['ctrl']['languageField'].'<=0
    346. 

  346. 				OR
    347. 

  347. 				'.$TCA[$table]['ctrl']['transOrigPointerField'].' = 0
    348. 

  348. 			)';
    349. 

  349. 		}
    350. 

  350. 			// Cleaning up:
    351. 

  351. 		$this->fieldArray=array_unique(array_merge($this->fieldArray,t3lib_div::trimExplode(',',$rowlist,1)));
    352. 

  352. 		if ($this->noControlPanels)	{
    353. 

  353. 			$tempArray = array_flip($this->fieldArray);
    354. 

  354. 			unset($tempArray['_CONTROL_']);
    355. 

  355. 			unset($tempArray['_CLIPBOARD_']);
    356. 

  356. 			$this->fieldArray = array_keys($tempArray);
    357. 

  357. 		}
    358. 

  358. 

  359. 			// Creating the list of fields to include in the SQL query:
    360. 

  360. 		$selectFields = $this->fieldArray;
    361. 

  361. 		$selectFields[] = 'uid';
    362. 

  362. 		$selectFields[] = 'pid';
    363. 

  363. 		if ($thumbsCol)	$selectFields[] = $thumbsCol;	// adding column for thumbnails
    364. 

  364. 		if ($table=='pages')	{
    365. 

  365. 			if (t3lib_extMgm::isLoaded('cms'))	{
    366. 

  366. 				$selectFields[] = 'module';
    367. 

  367. 				$selectFields[] = 'extendToSubpages';
    368. 

  368. 				$selectFields[] = 'nav_hide';
    369. 

  369. 			}
    370. 

  370. 			$selectFields[] = 'doktype';
    371. 

  371. 		}
    372. 

  372. 		if (is_array($TCA[$table]['ctrl']['enablecolumns']))	{
    373. 

  373. 			$selectFields = array_merge($selectFields,$TCA[$table]['ctrl']['enablecolumns']);
    374. 

  374. 		}
    375. 

  375. 		if ($TCA[$table]['ctrl']['type'])	{
    376. 

  376. 			$selectFields[] = $TCA[$table]['ctrl']['type'];
    377. 

  377. 		}
    378. 

  378. 		if ($TCA[$table]['ctrl']['typeicon_column'])	{
    379. 

  379. 			$selectFields[] = $TCA[$table]['ctrl']['typeicon_column'];
    380. 

  380. 		}
    381. 

  381. 		if ($TCA[$table]['ctrl']['versioningWS'])	{
    382. 

  382. 			$selectFields[] = 't3ver_id';
    383. 

  383. 			$selectFields[] = 't3ver_state';
    384. 

  384. 			$selectFields[] = 't3ver_wsid';
    385. 

  385. 			$selectFields[] = 't3ver_swapmode';		// Filtered out when pages in makeFieldList()
    386. 

  386. 		}
    387. 

  387. 		if ($l10nEnabled)	{
    388. 

  388. 			$selectFields[] = $TCA[$table]['ctrl']['languageField'];
    389. 

  389. 			$selectFields[] = $TCA[$table]['ctrl']['transOrigPointerField'];
    390. 

  390. 		}
    391. 

  391. 		if ($TCA[$table]['ctrl']['label_alt'])	{
    392. 

  392. 			$selectFields = array_merge($selectFields,t3lib_div::trimExplode(',',$TCA[$table]['ctrl']['label_alt'],1));
    393. 

  393. 		}
    394. 

  394. 		$selectFields = array_unique($selectFields);		// Unique list!
    395. 

  395. 		$selectFields = array_intersect($selectFields,$this->makeFieldList($table,1));		// Making sure that the fields in the field-list ARE in the field-list from TCA!
    396. 

  396. 		$selFieldList = implode(',',$selectFields);		// implode it into a list of fields for the SQL-statement.
    397. 

  397. 		$this->selFieldList = $selFieldList;
    398. 

  398. 

  399. 		/**
    400. 

  400. 		 * @hook			DB-List getTable
    401. 

  401. 		 * @date			2007-11-16
    402. 

  402. 		 * @request		Malte Jansen  <mail@maltejansen.de>
    403. 

  403. 		 */
    404. 

  404. 		if(is_array($TYPO3_CONF_VARS['SC_OPTIONS']['typo3/class.db_list_extra.inc']['getTable'])) {
    405. 

  405. 			foreach($TYPO3_CONF_VARS['SC_OPTIONS']['typo3/class.db_list_extra.inc']['getTable'] as $classData) {
    406. 

  406. 				$hookObject = t3lib_div::getUserObj($classData);
    407. 

  407. 

  408. 				if(!($hookObject instanceof t3lib_localRecordListGetTableHook)) {
    409. 

  409. 					throw new UnexpectedValueException('$hookObject must implement interface t3lib_localRecordListGetTableHook', 1195114460);
    410. 

  410. 				}
    411. 

  411. 

  412. 				$hookObject->getDBlistQuery($table, $id, $addWhere, $selFieldList, $this);
    413. 

  413. 			}
    414. 

  414. 		}
    415. 

  415. 

  416. 			// Create the SQL query for selecting the elements in the listing:
    417. 

  417. 		if ($this->csvOutput) {	// do not do paging when outputting as CSV
    418. 

  418. 			$this->iLimit = 0;
    419. 

  419. 		}
    420. 

  420. 

  421. 		if ($this->firstElementNumber > 2 && $this->iLimit > 0) {
    422. 

  422. 				// Get the two previous rows for sorting if displaying page > 1
    423. 

  423. 			$this->firstElementNumber = $this->firstElementNumber - 2;
    424. 

  424. 			$this->iLimit = $this->iLimit + 2;
    425. 

  425. 			$queryParts = $this->makeQueryArray($table, $id,$addWhere,$selFieldList);	// (API function from class.db_list.inc)
    426. 

  426. 			$this->firstElementNumber = $this->firstElementNumber + 2;
    427. 

  427. 			$this->iLimit = $this->iLimit - 2;
    428. 

  428. 		} else {
    429. 

  429. 			$queryParts = $this->makeQueryArray($table, $id,$addWhere,$selFieldList);	// (API function from class.db_list.inc)
    430. 

  430. 		}
    431. 

  431. 

  432. 		$this->setTotalItems($queryParts);		// Finding the total amount of records on the page (API function from class.db_list.inc)
    433. 

  433. 

  434. 			// Init:
    435. 

  435. 		$dbCount = 0;
    436. 

  436. 		$out = '';
    437. 

  437. 		$listOnlyInSingleTableMode = $this->listOnlyInSingleTableMode && !$this->table;
    438. 

  438. 

  439. 			// If the count query returned any number of records, we perform the real query, selecting records.
    440. 

  440. 		if ($this->totalItems)	{
    441. 

  441. 			// Fetch records only if not in single table mode or if in multi table mode and not collapsed
    442. 

  442. 			if ($listOnlyInSingleTableMode || (!$this->table && $tableCollapsed)) {
    443. 

  443. 				$dbCount = $this->totalItems;
    444. 

  444. 			} else {
    445. 

  445. 					// set the showLimit to the number of records when outputting as CSV
    446. 

  446. 				if ($this->csvOutput) {
    447. 

  447. 					$this->showLimit = $this->totalItems;
    448. 

  448. 					$this->iLimit = $this->totalItems;
    449. 

  449. 				}
    450. 

  450. 				$result = $GLOBALS['TYPO3_DB']->exec_SELECT_queryArray($queryParts);
    451. 

  451. 				$dbCount = $GLOBALS['TYPO3_DB']->sql_num_rows($result);
    452. 

  452. 			}
    453. 

  453. 		}
    454. 

  454. 

  455. 			// If any records was selected, render the list:
    456. 

  456. 		if ($dbCount)	{
    457. 

  457. 

  458. 				// Half line is drawn between tables:
    459. 

  459. 			if (!$listOnlyInSingleTableMode)	{
    460. 

  460. 				$theData = Array();
    461. 

  461. 				if (!$this->table && !$rowlist)	{
    462. 

  462. 					$theData[$titleCol] = '<img src="clear.gif" width="'.($GLOBALS['SOBE']->MOD_SETTINGS['bigControlPanel']?'230':'350').'" height="1" alt="" />';
    463. 

  463. 					if (in_array('_CONTROL_',$this->fieldArray))	$theData['_CONTROL_']='';
    464. 

  464. 					if (in_array('_CLIPBOARD_',$this->fieldArray))	$theData['_CLIPBOARD_']='';
    465. 

  465. 				}
    466. 

  466. 				$out.=$this->addelement(0,'',$theData,'class="c-table-row-spacer"',$this->leftMargin);
    467. 

  467. 			}
    468. 

  468. 

  469. 				// Header line is drawn
    470. 

  470. 			$theData = Array();
    471. 

  471. 			if ($this->disableSingleTableView)	{
    472. 

  472. 				$theData[$titleCol] = '<span class="c-table">'.$GLOBALS['LANG']->sL($TCA[$table]['ctrl']['title'],1).'</span> ('.$this->totalItems.')';
    473. 

  473. 			} else {
    474. 

  474. 				$theData[$titleCol] = $this->linkWrapTable($table, '<span class="c-table">' . $GLOBALS['LANG']->sL($TCA[$table]['ctrl']['title'], TRUE) . '</span> (' . $this->totalItems . ') ' .
    475. 

  475. 						($this->table ? t3lib_iconWorks::getSpriteIcon('actions-view-table-collapse', array('title' => $GLOBALS['LANG']->getLL('contractView', TRUE))) : t3lib_iconWorks::getSpriteIcon('actions-view-table-expand', array('title' => $GLOBALS['LANG']->getLL('expandView', TRUE))))
    476. 

  476. 					);
    477. 

  477. 			}
    478. 

  478. 

  479. 				// CSH:
    480. 

  480. 			$theData[$titleCol].= t3lib_BEfunc::cshItem($table,'',$this->backPath,'',FALSE,'margin-bottom:0px; white-space: normal;');
    481. 

  481. 

  482. 			if ($listOnlyInSingleTableMode)	{
    483. 

  483. 				$out.='
    484. 

  484. 					<tr>
    485. 

  485. 						<td class="t3-row-header" style="width:95%;">' . $theData[$titleCol] . '</td>
    486. 

  486. 					</tr>';
    487. 

    488. 

  488. 				if ($GLOBALS['BE_USER']->uc["edit_showFieldHelp"])	{
    489. 

  489. 					$GLOBALS['LANG']->loadSingleTableDescription($table);
    490. 

  490. 					if (isset($GLOBALS['TCA_DESCR'][$table]['columns']['']))	{
    491. 

  491. 						$onClick = 'vHWin=window.open(\'view_help.php?tfID='.$table.'.\',\'viewFieldHelp\',\'height=400,width=600,status=0,menubar=0,scrollbars=1\');vHWin.focus();return false;';
    492. 

  492. 						$out.='
    493. 

  493. 					<tr>
    494. 

  494. 						<td class="c-tableDescription">'.t3lib_BEfunc::helpTextIcon($table,'',$this->backPath,TRUE).$GLOBALS['TCA_DESCR'][$table]['columns']['']['description'].'</td>
    495. 

  495. 					</tr>';
    496. 

  496. 					}
    497. 

  497. 				}
    498. 

  498. 			} else {
    499. 

  499. 				// Render collapse button if in multi table mode
    500. 

  500. 				$collapseIcon = '';
    501. 

  501. 				if (!$this->table) {
    502. 

  502. 					$collapseIcon = '<a href="' . htmlspecialchars($this->listURL() . '&collapse[' . $table . ']=' . ($tableCollapsed ? '0' : '1')) . '" title="' . ($tableCollapsed ? $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.expandTable', TRUE) : $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_core.php:labels.collapseTable', TRUE)) . '">' .
    503. 

  503. 							($tableCollapsed ? t3lib_iconWorks::getSpriteIcon('actions-view-list-expand', array('class' => 'collapseIcon')) : t3lib_iconWorks::getSpriteIcon('actions-view-list-collapse', array('class' => 'collapseIcon'))) .
    504. 

  504. 						'</a>';
    505. 

  505. 				}
    506. 

  506. 				$out .= $this->addElement(1, $collapseIcon, $theData, ' class="t3-row-header"', '');
    507. 

  507. 			}
    508. 

  508. 

  509. 			// Render table rows only if in multi table view and not collapsed or if in single table view
    510. 

  510. 			if (!$listOnlyInSingleTableMode && (!$tableCollapsed || $this->table)) {
    511. 

  511. 					// Fixing a order table for sortby tables
    512. 

  512. 				$this->currentTable = array();
    513. 

  513. 				$currentIdList = array();
    514. 

  514. 				$doSort = ($TCA[$table]['ctrl']['sortby'] && !$this->sortField);
    515. 

  515. 

  516. 				$prevUid = 0;
    517. 

  517. 				$prevPrevUid = 0;
    518. 

  518. 

  519. 					// Get first two rows and initialize prevPrevUid and prevUid if on page > 1
    520. 

  520. 				if ($this->firstElementNumber > 2 && $this->iLimit > 0) {
    521. 

  521. 					$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($result);
    522. 

  522. 					$prevPrevUid = -(int) $row['uid'];
    523. 

  523. 					$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($result);
    524. 

  524. 					$prevUid = $row['uid'];
    525. 

  525. 				}
    526. 

  526. 

  527. 				$accRows = array();	// Accumulate rows here
    528. 

  528. 				while($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($result))	{
    529. 

  529. 

  530. 						// In offline workspace, look for alternative record:
    531. 

  531. 					t3lib_BEfunc::workspaceOL($table, $row, $GLOBALS['BE_USER']->workspace, TRUE);
    532. 

  532. 

  533. 					if (is_array($row))	{
    534. 

  534. 						$accRows[] = $row;
    535. 

  535. 						$currentIdList[] = $row['uid'];
    536. 

  536. 						if ($doSort)	{
    537. 

  537. 							if ($prevUid)	{
    538. 

  538. 								$this->currentTable['prev'][$row['uid']] = $prevPrevUid;
    539. 

  539. 								$this->currentTable['next'][$prevUid] = '-'.$row['uid'];
    540. 

  540. 								$this->currentTable['prevUid'][$row['uid']] = $prevUid;
    541. 

  541. 							}
    542. 

  542. 							$prevPrevUid = isset($this->currentTable['prev'][$row['uid']]) ? -$prevUid : $row['pid'];
    543. 

  543. 							$prevUid=$row['uid'];
    544. 

  544. 						}
    545. 

  545. 					}
    546. 

  546. 				}
    547. 

  547. 				$GLOBALS['TYPO3_DB']->sql_free_result($result);
    548. 

  548. 

  549. 				$this->totalRowCount = count($accRows);
    550. 

  550. 

  551. 					// CSV initiated
    552. 

  552. 				if ($this->csvOutput) $this->initCSV();
    553. 

  553. 

  554. 					// Render items:
    555. 

  555. 				$this->CBnames=array();
    556. 

  556. 				$this->duplicateStack=array();
    557. 

  557. 				$this->eCounter=$this->firstElementNumber;
    558. 

  558. 

  559. 				$iOut = '';
    560. 

  560. 				$cc = 0;
    561. 

  561. 

  562. 				foreach($accRows as $row)	{
    563. 

  563. 					// Render item row if counter < limit
    564. 

  564. 					if ($cc < $this->iLimit) {
    565. 

  565. 						$cc++;
    566. 

  566. 						$this->translations = FALSE;
    567. 

  567. 						$iOut.= $this->renderListRow($table,$row,$cc,$titleCol,$thumbsCol);
    568. 

  568. 

  569. 							// If localization view is enabled it means that the selected records are either default or All language and here we will not select translations which point to the main record:
    570. 

  570. 						if ($this->localizationView && $l10nEnabled)	{
    571. 

  571. 								// For each available translation, render the record:
    572. 

  572. 							if (is_array($this->translations)) {
    573. 

  573. 								foreach ($this->translations as $lRow) {
    574. 

  574. 										// $lRow isn't always what we want - if record was moved we've to work with the placeholder records otherwise the list is messed up a bit
    575. 

  575. 									if ($row['_MOVE_PLH_uid'] && $row['_MOVE_PLH_pid']) {
    576. 

  576. 										$tmpRow = t3lib_BEfunc::getRecordRaw($table, 't3ver_move_id="'.intval($lRow['uid']) . '" AND pid="' . $row['_MOVE_PLH_pid'] . '" AND t3ver_wsid=' . $row['t3ver_wsid'] . t3lib_beFunc::deleteClause($table), $selFieldList);
    577. 

  577. 										$lRow = is_array($tmpRow)?$tmpRow:$lRow;
    578. 

  578. 									}
    579. 

  579. 										// In offline workspace, look for alternative record:
    580. 

  580. 									t3lib_BEfunc::workspaceOL($table, $lRow, $GLOBALS['BE_USER']->workspace, true);
    581. 

  581. 									if (is_array($lRow) && $GLOBALS['BE_USER']->checkLanguageAccess($lRow[$TCA[$table]['ctrl']['languageField']]))	{
    582. 

  582. 										$currentIdList[] = $lRow['uid'];
    583. 

  583. 										$iOut.=$this->renderListRow($table,$lRow,$cc,$titleCol,$thumbsCol,18);
    584. 

  584. 									}
    585. 

  585. 								}
    586. 

  586. 							}
    587. 

  587. 						}
    588. 

  588. 					}
    589. 

  589. 

  590. 						// Counter of total rows incremented:
    591. 

  591. 					$this->eCounter++;
    592. 

  592. 				}
    593. 

  593. 

  594. 					// Record navigation is added to the beginning and end of the table if in single table mode
    595. 

  595. 				if ($this->table) {
    596. 

  596. 					$pageNavigation = $this->renderListNavigation();
    597. 

  597. 					$iOut = $pageNavigation . $iOut . $pageNavigation;
    598. 

  598. 				} else {
    599. 

  599. 						// show that there are more records than shown
    600. 

  600. 					if ($this->totalItems > $this->itemsLimitPerTable) {
    601. 

  601. 						$countOnFirstPage = $this->totalItems > $this->itemsLimitSingleTable ? $this->itemsLimitSingleTable : $this->totalItems;
    602. 

  602. 						$hasMore = ($this->totalItems > $this->itemsLimitSingleTable);
    603. 

  603. 						$iOut .= '<tr><td colspan="' . count($this->fieldArray) . '" style="padding:5px;">
    604. 

  604. 								<a href="'.htmlspecialchars($this->listURL() . '&table=' . rawurlencode($table)) . '">' .
    605. 

  605. 								'<img' . t3lib_iconWorks::skinImg($this->backPath,'gfx/pildown.gif', 'width="14" height="14"') .' alt="" />'.
    606. 

  606. 								' <i>[1 - ' . $countOnFirstPage . ($hasMore ? '+' : '') . ']</i></a>
    607. 

  607. 								</td></tr>';
    608. 

  608. 						}
    609. 

  609. 

  610. 				}
    611. 

  611. 

  612. 					// The header row for the table is now created:
    613. 

  613. 				$out .= $this->renderListHeader($table,$currentIdList);
    614. 

  614. 			}
    615. 

  615. 

  616. 				// The list of records is added after the header:
    617. 

  617. 			$out .= $iOut;
    618. 

  618. 			unset($iOut);
    619. 

  619. 

  620. 				// ... and it is all wrapped in a table:
    621. 

  621. 			$out='
    622. 

    623. 

  623. 

  624. 

  625. 			<!--
    626. 

  626. 				DB listing of elements:	"'.htmlspecialchars($table).'"
    627. 

  627. 			-->
    628. 

  628. 				<table border="0" cellpadding="0" cellspacing="0" class="typo3-dblist'.($listOnlyInSingleTableMode?' typo3-dblist-overview':'').'">
    629. 

  629. 					'.$out.'
    630. 

  630. 				</table>';
    631. 

    632. 

  632. 				// Output csv if...
    633. 

  633. 			if ($this->csvOutput)	$this->outputCSV($table);	// This ends the page with exit.
    634. 

  634. 		}
    635. 

  635. 

  636. 			// Return content:
    637. 

  637. 		return $out;
    638. 

  638. 	}
    639. 

  639. 

  640. 	/**
    641. 

  641. 	 * Rendering a single row for the list
    642. 

  642. 	 *
    643. 

  643. 	 * @param	string		Table name
    644. 

  644. 	 * @param	array		Current record
    645. 

  645. 	 * @param	integer		Counter, counting for each time an element is rendered (used for alternating colors)
    646. 

  646. 	 * @param	string		Table field (column) where header value is found
    647. 

  647. 	 * @param	string		Table field (column) where (possible) thumbnails can be found
    648. 

  648. 	 * @param	integer		Indent from left.
    649. 

  649. 	 * @return	string		Table row for the element
    650. 

  650. 	 * @access private
    651. 

  651. 	 * @see getTable()
    652. 

  652. 	 */
    653. 

  653. 	function renderListRow($table,$row,$cc,$titleCol,$thumbsCol,$indent=0)	{
    654. 

  654. 		$iOut = '';
    655. 

  655. 

  656. 		if (strlen($this->searchString))	{	// If in search mode, make sure the preview will show the correct page
    657. 

  657. 			$id_orig = $this->id;
    658. 

  658. 			$this->id = $row['pid'];
    659. 

  659. 		}
    660. 

  660. 

  661. 		if (is_array($row))	{
    662. 

  662. 				// add special classes for first and last row
    663. 

  663. 			$rowSpecial = '';
    664. 

  664. 			if ($cc == 1 && $indent == 0) {
    665. 

  665. 				$rowSpecial .= ' firstcol';
    666. 

  666. 			}
    667. 

  667. 			if ($cc == $this->totalRowCount || $cc == $this->iLimit) {
    668. 

  668. 				$rowSpecial .= ' lastcol';
    669. 

  669. 			}
    670. 

  670. 

  671. 				// Background color, if any:
    672. 

  672. 			if ($this->alternateBgColors) {
    673. 

  673. 				$row_bgColor = ($cc%2) ? ' class="db_list_normal'.$rowSpecial.'"' : ' class="db_list_alt'.$rowSpecial.'"';
    674. 

  674. 			} else {
    675. 

  675. 				$row_bgColor = ' class="db_list_normal'.$rowSpecial.'"';
    676. 

  676. 			}
    677. 

  677. 				// Overriding with versions background color if any:
    678. 

  678. 			$row_bgColor = $row['_CSSCLASS'] ? ' class="'.$row['_CSSCLASS'].'"' : $row_bgColor;
    679. 

  679. 

  680. 				// Incr. counter.
    681. 

  681. 			$this->counter++;
    682. 

  682. 

  683. 				// The icon with link
    684. 

  684. 			$alttext = t3lib_BEfunc::getRecordIconAltText($row,$table);
    685. 

  685. 			$iconImg = t3lib_iconWorks::getSpriteIconForRecord($table, $row, array('title' => htmlspecialchars($alttext), 'style' => ($indent ? ' margin-left: ' . $indent . 'px;' : '')));
    686. 

  686. 

  687. 

  688. 			$theIcon = $this->clickMenuEnabled ? $GLOBALS['SOBE']->doc->wrapClickMenuOnIcon($iconImg,$table,$row['uid']) : $iconImg;
    689. 

  689. 

  690. 				// Preparing and getting the data-array
    691. 

  691. 			$theData = Array();
    692. 

  692. 			foreach($this->fieldArray as $fCol)	{
    693. 

  693. 				if ($fCol==$titleCol)	{
    694. 

  694. 					$recTitle = t3lib_BEfunc::getRecordTitle($table,$row,FALSE,TRUE);
    695. 

  695. 						// If the record is edit-locked	by another user, we will show a little warning sign:
    696. 

  696. 					if (($lockInfo = t3lib_BEfunc::isRecordLocked($table, $row['uid']))) {
    697. 

  697. 						$warning = '<a href="#" onclick="' . htmlspecialchars('alert(' . $GLOBALS['LANG']->JScharCode($lockInfo['msg']) . '); return false;') . '" title="' . htmlspecialchars($lockInfo['msg']) . '">' .
    698. 

  698. 								t3lib_iconWorks::getSpriteIcon('status-warning-in-use') .
    699. 

  699. 							'</a>';
    700. 

  700. 					}
    701. 

  701. 					$theData[$fCol] = $warning . $this->linkWrapItems($table, $row['uid'], $recTitle, $row);
    702. 

  702. 

  703. 						// Render thumbsnails if a thumbnail column exists and there is content in it:
    704. 

  704. 					if ($this->thumbs && trim($row[$thumbsCol])) {
    705. 

  705. 						$theData[$fCol] .= '<br />' . $this->thumbCode($row,$table,$thumbsCol);
    706. 

  706. 					}
    707. 

  707. 

  708. 					$localizationMarkerClass = '';
    709. 

  709. 					if (isset($GLOBALS['TCA'][$table]['ctrl']['languageField'])
    710. 

  710. 					&& $row[$GLOBALS['TCA'][$table]['ctrl']['languageField']] != 0) {
    711. 

  711. 							// it's a translated record
    712. 

  712. 						$localizationMarkerClass = ' localization';
    713. 

  713. 					}
    714. 

  714. 				} elseif ($fCol == 'pid') {
    715. 

  715. 					$theData[$fCol]=$row[$fCol];
    716. 

  716. 				} elseif ($fCol == '_PATH_') {
    717. 

  717. 					$theData[$fCol]=$this->recPath($row['pid']);
    718. 

  718. 				} elseif ($fCol == '_REF_') {
    719. 

  719. 					$theData[$fCol] = $this->createReferenceHtml($table, $row['uid']);
    720. 

  720. 				} elseif ($fCol == '_CONTROL_') {
    721. 

  721. 					$theData[$fCol]=$this->makeControl($table,$row);
    722. 

  722. 				} elseif ($fCol == '_AFTERCONTROL_' || $fCol == '_AFTERREF_') {
    723. 

  723. 					$theData[$fCol] = '&nbsp;';
    724. 

  724. 				} elseif ($fCol == '_CLIPBOARD_') {
    725. 

  725. 					$theData[$fCol]=$this->makeClip($table,$row);
    726. 

  726. 				} elseif ($fCol == '_LOCALIZATION_') {
    727. 

  727. 					list($lC1, $lC2) = $this->makeLocalizationPanel($table,$row);
    728. 

  728. 					$theData[$fCol] = $lC1;
    729. 

  729. 					$theData[$fCol.'b'] = $lC2;
    730. 

  730. 				} elseif ($fCol == '_LOCALIZATION_b') {
    731. 

  731. 					// Do nothing, has been done above.
    732. 

  732. 				} else {
    733. 

  733. 					$tmpProc = t3lib_BEfunc::getProcessedValueExtra($table, $fCol, $row[$fCol], 100, $row['uid']);
    734. 

  734. 					$theData[$fCol] = $this->linkUrlMail(htmlspecialchars($tmpProc), $row[$fCol]);
    735. 

  735. 					$row[$fCol] = $tmpProc;
    736. 

  736. 				}
    737. 

  737. 			}
    738. 

  738. 

  739. 			if (strlen($this->searchString))	{	// Reset the ID if it was overwritten
    740. 

  740. 				$this->id = $id_orig;
    741. 

  741. 			}
    742. 

  742. 

  743. 				// Add row to CSV list:
    744. 

  744. 			if ($this->csvOutput) {
    745. 

  745. 				$this->addToCSV($row,$table);
    746. 

  746. 			}
    747. 

  747. 

  748. 			// Add classes to table cells
    749. 

  749. 			$this->addElement_tdCssClass[$titleCol]         = 'col-title' . $localizationMarkerClass;
    750. 

  750. 			if (!$this->dontShowClipControlPanels) {
    751. 

  751. 				$this->addElement_tdCssClass['_CONTROL_']       = 'col-control';
    752. 

  752. 				$this->addElement_tdCssClass['_AFTERCONTROL_']  = 'col-control-space';
    753. 

  753. 				$this->addElement_tdCssClass['_CLIPBOARD_']     = 'col-clipboard';
    754. 

  754. 			}
    755. 

  755. 			$this->addElement_tdCssClass['_PATH_']          = 'col-path';
    756. 

  756. 			$this->addElement_tdCssClass['_LOCALIZATION_']  = 'col-localizationa';
    757. 

  757. 			$this->addElement_tdCssClass['_LOCALIZATION_b'] = 'col-localizationb';
    758. 

  758. 

  759. 				// Create element in table cells:
    760. 

  760. 			$iOut.=$this->addelement(1,$theIcon,$theData,$row_bgColor);
    761. 

  761. 

  762. 				// Finally, return table row element:
    763. 

  763. 			return $iOut;
    764. 

  764. 		}
    765. 

  765. 	}
    766. 

  766. 

  767. 	/**
    768. 

  768. 	 * Write sys_refindex entries for current record to $this->references
    769. 

  769. 	 *
    770. 

  770. 	 * @param	string		Table name
    771. 

  771. 	 * @param	integer		Uid of current record
    772. 

  772. 	 * @return	void
    773. 

  773. 	 *
    774. 

  774. 	 * @deprecated since 4.4: Use getReferenceCount instead
    775. 

  775. 	 */
    776. 

  776. 	function setReferences($table, $uid) {
    777. 

  777. 		t3lib_div::logDeprecatedFunction();
    778. 

  778. 

  779. 		$rows = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows(
    780. 

  780. 			'tablename, recuid, field',
    781. 

  781. 			'sys_refindex',
    782. 

  782. 			'ref_table='.$GLOBALS['TYPO3_DB']->fullQuoteStr($table,'sys_refindex').
    783. 

  783. 				' AND ref_uid='.intval($uid).
    784. 

  784. 				' AND deleted=0'
    785. 

  785. 		);
    786. 

  786. 		$this->references = $rows;
    787. 

  787. 	}
    788. 

  788. 

  789. 	/**
    790. 

  790. 	 * Gets the number of records referencing the record with the UID $uid in
    791. 

  791. 	 * the table $tableName.
    792. 

  792. 	 *
    793. 

  793. 	 * @param string $tableName
    794. 

  794. 	 *        table name of the referenced record, must not be empty
    795. 

  795. 	 * @param integer $uid
    796. 

  796. 	 *        UID of the referenced record, must be > 0
    797. 

  797. 	 *
    798. 

  798. 	 * @return integer the number of references to record $uid in table
    799. 

  799. 	 *                 $tableName, will be >= 0
    800. 

  800. 	 */
    801. 

  801. 	protected function getReferenceCount($tableName, $uid) {
    802. 

  802. 		if (!isset($this->referenceCount[$tableName][$uid])) {
    803. 

  803. 			$numberOfReferences = $GLOBALS['TYPO3_DB']->exec_SELECTcountRows(
    804. 

  804. 				'*',
    805. 

  805. 				'sys_refindex',
    806. 

  806. 				'ref_table = ' . $GLOBALS['TYPO3_DB']->fullQuoteStr(
    807. 

  807. 					$tableName, 'sys_refindex'
    808. 

  808. 				) .
    809. 

  809. 					' AND ref_uid = ' . $uid .
    810. 

  810. 					' AND deleted = 0'
    811. 

  811. 			);
    812. 

  812. 

  813. 			$this->referenceCount[$tableName][$uid] = $numberOfReferences;
    814. 

  814. 		}
    815. 

  815. 

  816. 		return $this->referenceCount[$tableName][$uid];
    817. 

  817. 	}
    818. 

  818. 

  819. 	/**
    820. 

  820. 	 * Rendering the header row for a table
    821. 

  821. 	 *
    822. 

  822. 	 * @param	string		Table name
    823. 

  823. 	 * @param	array		Array of the currently displayed uids of the table
    824. 

  824. 	 * @return	string		Header table row
    825. 

  825. 	 * @access private
    826. 

  826. 	 * @see getTable()
    827. 

  827. 	 */
    828. 

  828. 	function renderListHeader($table, $currentIdList)	{
    829. 

  829. 		global $TCA, $LANG, $TYPO3_CONF_VARS;
    830. 

  830. 

  831. 			// Init:
    832. 

  832. 		$theData = Array();
    833. 

  833. 

  834. 			// Traverse the fields:
    835. 

  835. 		foreach($this->fieldArray as $fCol)	{
    836. 

  836. 

  837. 				// Calculate users permissions to edit records in the table:
    838. 

  838. 			$permsEdit = $this->calcPerms & ($table=='pages'?2:16);
    839. 

  839. 

  840. 			switch((string)$fCol)	{
    841. 

  841. 				case '_PATH_':			// Path
    842. 

  842. 					$theData[$fCol] = '<i>['.$LANG->sL('LLL:EXT:lang/locallang_core.php:labels._PATH_',1).']</i>';
    843. 

  843. 				break;
    844. 

  844. 				case '_REF_':			// References
    845. 

  845. 					$theData[$fCol] = '<i>['.$LANG->sL('LLL:EXT:lang/locallang_mod_file_list.xml:c__REF_',1).']</i>';
    846. 

  846. 				break;
    847. 

  847. 				case '_LOCALIZATION_':			// Path
    848. 

  848. 					$theData[$fCol] = '<i>['.$LANG->sL('LLL:EXT:lang/locallang_core.php:labels._LOCALIZATION_',1).']</i>';
    849. 

  849. 				break;
    850. 

  850. 				case '_LOCALIZATION_b':			// Path
    851. 

  851. 					$theData[$fCol] = $LANG->getLL('Localize',1);
    852. 

  852. 				break;
    853. 

  853. 				case '_CLIPBOARD_':		// Clipboard:
    854. 

  854. 					$cells=array();
    855. 

  855. 

  856. 						// If there are elements on the clipboard for this table, then display the "paste into" icon:
    857. 

  857. 					$elFromTable = $this->clipObj->elFromTable($table);
    858. 

  858. 					if (count($elFromTable))	{
    859. 

  859. 						$cells['pasteAfter']='<a href="'.htmlspecialchars($this->clipObj->pasteUrl($table,$this->id)).'" onclick="'.htmlspecialchars('return '.$this->clipObj->confirmMsg('pages',$this->pageRow,'into',$elFromTable)).'" title="' . $LANG->getLL('clip_paste', TRUE) . '">' .
    860. 

  860. 									t3lib_iconWorks::getSpriteIcon('actions-document-paste-after') .
    861. 

  861. 								'</a>';
    862. 

  862. 					}
    863. 

  863. 

  864. 						// If the numeric clipboard pads are enabled, display the control icons for that:
    865. 

  865. 					if ($this->clipObj->current!='normal')	{
    866. 

  866. 

  867. 							// The "select" link:
    868. 

  868. 						$cells['copyMarked']=$this->linkClipboardHeaderIcon(t3lib_iconWorks::getSpriteIcon('actions-edit-copy', array('title' => $LANG->getLL('clip_selectMarked', TRUE))), $table, 'setCB');
    869. 

  869. 

  870. 							// The "edit marked" link:
    871. 

  871. 						$editIdList = implode(',',$currentIdList);
    872. 

  872. 						$editIdList = "'+editList('".$table."','".$editIdList."')+'";
    873. 

  873. 						$params='&edit['.$table.']['.$editIdList.']=edit&disHelp=1';
    874. 

  874. 						$cells['edit']='<a href="#" onclick="'.htmlspecialchars(t3lib_BEfunc::editOnClick($params,$this->backPath,-1)).'" title="' . $LANG->getLL('clip_editMarked', TRUE) . '">' .
    875. 

  875. 								t3lib_iconWorks::getSpriteIcon('actions-document-open') .
    876. 

  876. 								'</a>';
    877. 

  877. 

  878. 							// The "Delete marked" link:
    879. 

  879. 						$cells['delete']=$this->linkClipboardHeaderIcon(t3lib_iconWorks::getSpriteIcon('actions-edit-delete', array('title' => $LANG->getLL('clip_deleteMarked', TRUE))), $table,'delete',sprintf($LANG->getLL('clip_deleteMarkedWarning'), $LANG->sL($TCA[$table]['ctrl']['title'])));
    880. 

  880. 

  881. 							// The "Select all" link:
    882. 

  882. 						$cells['markAll'] = '<a class="cbcCheckAll" rel="" href="#" onclick="' . htmlspecialchars('checkOffCB(\'' . implode(',', $this->CBnames) . '\', this); return false;') . '" title="' . $LANG->getLL('clip_markRecords', TRUE) . '">' .
    883. 

  883. 								t3lib_iconWorks::getSpriteIcon('actions-document-select') .
    884. 

  884. 								'</a>';
    885. 

  885. 					} else {
    886. 

  886. 						$cells['empty']='';
    887. 

  887. 					}
    888. 

  888. 					/**
    889. 

  889. 					 * @hook			renderListHeaderActions: Allows to change the clipboard icons of the Web>List table headers
    890. 

  890. 					 * @date			2007-11-20
    891. 

  891. 					 * @request		Bernhard Kraft  <krafbt@kraftb.at>
    892. 

  892. 					 * @usage		Above each listed table in Web>List a header row is shown. This hook allows to modify the icons responsible for the clipboard functions (shown above the clipboard checkboxes when a clipboard other than "Normal" is selected), or other "Action" functions which perform operations on the listed records.
    893. 

  893. 					 */
    894. 

  894. 					if(is_array($TYPO3_CONF_VARS['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions']))	{
    895. 

  895. 						foreach($TYPO3_CONF_VARS['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'] as $classData)	{
    896. 

  896. 							$hookObject = t3lib_div::getUserObj($classData);
    897. 

  897. 							if(!($hookObject instanceof localRecordList_actionsHook))	{
    898. 

  898. 								throw new UnexpectedValueException('$hookObject must implement interface localRecordList_actionsHook', 1195567850);
    899. 

  899. 							}
    900. 

  900. 							$cells = $hookObject->renderListHeaderActions($table, $currentIdList, $cells, $this);
    901. 

  901. 						}
    902. 

  902. 					}
    903. 

  903. 					$theData[$fCol]=implode('',$cells);
    904. 

  904. 				break;
    905. 

  905. 				case '_CONTROL_':		// Control panel:
    906. 

  906. 					if (!$TCA[$table]['ctrl']['readOnly'])	{
    907. 

  907. 

  908. 							// If new records can be created on this page, add links:
    909. 

  909. 						if ($this->calcPerms&($table=='pages'?8:16) && $this->showNewRecLink($table))	{
    910. 

  910. 							if ($table=="tt_content" && $this->newWizards)	{
    911. 

  911. 									//  If mod.web_list.newContentWiz.overrideWithExtension is set, use that extension's create new content wizard instead:
    912. 

  912. 								$tmpTSc = t3lib_BEfunc::getModTSconfig($this->pageinfo['uid'],'mod.web_list');
    913. 

  913. 								$tmpTSc = $tmpTSc ['properties']['newContentWiz.']['overrideWithExtension'];
    914. 

  914. 								$newContentWizScriptPath = $this->backPath.t3lib_extMgm::isLoaded($tmpTSc) ? (t3lib_extMgm::extRelPath($tmpTSc).'mod1/db_new_content_el.php') : 'sysext/cms/layout/db_new_content_el.php';
    915. 

  915. 

  916. 								$icon = '<a href="#" onclick="'.htmlspecialchars('return jumpExt(\''.$newContentWizScriptPath.'?id='.$this->id.'\');').'" title="' . $LANG->getLL('new', TRUE) . '">'.
    917. 

  917. 													($table == 'pages' ? t3lib_iconWorks::getSpriteIcon('actions-page-new') : t3lib_iconWorks::getSpriteIcon('actions-document-new')) .
    918. 

  918. 												'</a>';
    919. 

  919. 							} elseif ($table=='pages' && $this->newWizards)	{
    920. 

  920. 								$icon = '<a href="'.htmlspecialchars($this->backPath.'db_new.php?id='.$this->id.'&pagesOnly=1&returnUrl='.rawurlencode(t3lib_div::getIndpEnv('REQUEST_URI'))).'" title="'.$LANG->getLL('new', TRUE).'">'.
    921. 

  921. 													($table=='pages' ? t3lib_iconWorks::getSpriteIcon('actions-page-new') : t3lib_iconWorks::getSpriteIcon('actions-document-new')) .
    922. 

  922. 												'</a>';
    923. 

  923. 

  924. 							} else {
    925. 

  925. 								$params = '&edit['.$table.']['.$this->id.']=new';
    926. 

  926. 								if ($table == 'pages_language_overlay') {
    927. 

  927. 									$params .= '&overrideVals[pages_language_overlay][doktype]=' . (int) $this->pageRow['doktype'];
    928. 

  928. 								}
    929. 

  929. 								$icon   = '<a href="#" onclick="'.htmlspecialchars(t3lib_BEfunc::editOnClick($params,$this->backPath,-1)).'" title="'.$LANG->getLL('new', TRUE).'">'.
    930. 

  930. 													($table=='pages' ? t3lib_iconWorks::getSpriteIcon('actions-page-new') : t3lib_iconWorks::getSpriteIcon('actions-document-new')) .
    931. 

  931. 												'</a>';
    932. 

  932. 							}
    933. 

  933. 						}
    934. 

  934. 

  935. 							// If the table can be edited, add link for editing ALL SHOWN fields for all listed records:
    936. 

  936. 						if ($permsEdit && $this->table && is_array($currentIdList))	{
    937. 

  937. 							$editIdList = implode(',',$currentIdList);
    938. 

  938. 							if ($this->clipNumPane()) $editIdList = "'+editList('".$table."','".$editIdList."')+'";
    939. 

  939. 							$params = '&edit['.$table.']['.$editIdList.']=edit&columnsOnly='.implode(',',$this->fieldArray).'&disHelp=1';
    940. 

  940. 							$icon  .= '<a href="#" onclick="'.htmlspecialchars(t3lib_BEfunc::editOnClick($params,$this->backPath,-1)).'" title="'.$LANG->getLL('editShownColumns', TRUE) . '">'.
    941. 

  941. 												t3lib_iconWorks::getSpriteIcon('actions-document-open') .
    942. 

  942. 											'</a>';
    943. 

  943. 						}
    944. 

  944. 							// add an empty entry, so column count fits again after moving this into $icon
    945. 

  945. 						$theData[$fCol] = '&nbsp;';
    946. 

  946. 					}
    947. 

  947. 				break;
    948. 

  948. 				case '_AFTERCONTROL_':  // space column
    949. 

  949. 				case '_AFTERREF_':	// space column
    950. 

  950. 					$theData[$fCol] = '&nbsp;';
    951. 

  951. 				break;
    952. 

  952. 				default:			// Regular fields header:
    953. 

  953. 					$theData[$fCol]='';
    954. 

  954. 					if ($this->table && is_array($currentIdList))	{
    955. 

  955. 

  956. 							// If the numeric clipboard pads are selected, show duplicate sorting link:
    957. 

  957. 						if ($this->clipNumPane()) {
    958. 

  958. 							$theData[$fCol].='<a href="'.htmlspecialchars($this->listURL('',-1).'&duplicateField='.$fCol).'" title="'.$LANG->getLL('clip_duplicates', TRUE) . '">'.
    959. 

  959. 												t3lib_iconWorks::getSpriteIcon('actions-document-duplicates-select') .
    960. 

  960. 											'</a>';
    961. 

  961. 						}
    962. 

  962. 

  963. 							// If the table can be edited, add link for editing THIS field for all listed records:
    964. 

  964. 						if (!$TCA[$table]['ctrl']['readOnly'] && $permsEdit && $TCA[$table]['columns'][$fCol])	{
    965. 

  965. 							$editIdList = implode(',',$currentIdList);
    966. 

  966. 							if ($this->clipNumPane()) $editIdList = "'+editList('".$table."','".$editIdList."')+'";
    967. 

  967. 							$params='&edit['.$table.']['.$editIdList.']=edit&columnsOnly='.$fCol.'&disHelp=1';
    968. 

  968. 							$iTitle = sprintf($LANG->getLL('editThisColumn'),rtrim(trim($LANG->sL(t3lib_BEfunc::getItemLabel($table,$fCol))),':'));
    969. 

  969. 							$theData[$fCol].='<a href="#" onclick="'.htmlspecialchars(t3lib_BEfunc::editOnClick($params,$this->backPath,-1)).'" title="'.htmlspecialchars($iTitle).'">'.
    970. 

  970. 												t3lib_iconWorks::getSpriteIcon('actions-document-open') .
    971. 

  971. 											'</a>';
    972. 

  972. 						}
    973. 

  973. 					}
    974. 

  974. 					$theData[$fCol].=$this->addSortLink($LANG->sL(t3lib_BEfunc::getItemLabel($table,$fCol,'<i>[|]</i>')),$fCol,$table);
    975. 

  975. 				break;
    976. 

  976. 			}
    977. 

  977. 

  978. 		}
    979. 

  979. 

  980. 		/**
    981. 

  981. 		 * @hook			renderListHeader: Allows to change the contents of columns/cells of the Web>List table headers
    982. 

  982. 		 * @date			2007-11-20
    983. 

  983. 		 * @request		Bernhard Kraft  <krafbt@kraftb.at>
    984. 

  984. 		 * @usage		Above each listed table in Web>List a header row is shown. Containing the labels of all shown fields and additional icons to create new records for this table or perform special clipboard tasks like mark and copy all listed records to clipboard, etc.
    985. 

  985. 		 */
    986. 

  986. 		if(is_array($TYPO3_CONF_VARS['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions']))	{
    987. 

  987. 			foreach($TYPO3_CONF_VARS['SC_OPTIONS']['typo3/class.db_list_extra.inc']['actions'] as $classData)	{
    988. 

  988. 				$hookObject = t3lib_div::getUserObj($classData);
    989. 

  989. 				if(!($hookObject instanceof localRecordList_actionsHook))	{
    990. 

  990. 					throw new UnexpectedValueException('$hookObject must implement interface localRecordList_actionsHook', 1195567855);
    991. 

  991. 				}
    992. 

  992. 				$theData = $hookObject->renderListHeader($table, $currentIdList, $theData, $this);
    993. 

  993. 			}
    994. 

  994. 		}
    995. 

  995. 

  996. 			// Create and return header table row:
    997. 

  997. 		return $this->addelement(1, $icon, $theData, ' class="c-headLine"', '');
    998. 

  998. 	}
    999. 

  999. 

  1000. 	/**
    1001. 

  1001. 	 * Creates a page browser for tables with many records
    1002. 

  1002. 	 *
    1003. 

  1003. 	 * @return	string	Navigation HTML
    1004. 

  1004. 	 *
    1005. 

  1005. 	 */
    1006. 

  1006. 	protected function renderListNavigation() {
    1007. 

  1007. 		$totalPages = ceil($this->totalItems / $this->iLimit);
    1008. 

  1008. 

  1009. 		$content = '';
    1010. 

  1010. 		$returnContent = '';
    1011. 

  1011. 

  1012. 			// Show page selector if not all records fit into one page
    1013. 

  1013. 		if ($totalPages > 1) {
    1014. 

  1014. 			$first = $previous = $next = $last = $reload = '';
    1015. 

  1015. 			$listURL = $this->listURL('', $this->table);
    1016. 

  1016. 

  1017. 				// 1 = first page
    1018. 

  1018. 			$currentPage = floor(($this->firstElementNumber + 1) / $this->iLimit) + 1;
    1019. 

  1019. 

  1020. 				// Compile first, previous, next, last and refresh buttons
    1021. 

  1021. 			if ($currentPage > 1) {
    1022. 

  1022. 				$labelFirst = $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xml:first');
    1023. 

  1023. 

  1024. 				$first = '<a href="' . $listURL . '&pointer=0">' .
    1025. 

  1025. 					t3lib_iconWorks::getSpriteIcon('actions-view-paging-first', array('title'=> $labelFirst)) .
    1026. 

  1026. 				'</a>';
    1027. 

  1027. 			} else {
    1028. 

  1028. 				$first = t3lib_iconWorks::getSpriteIcon('actions-view-paging-first-disabled');
    1029. 

  1029. 			}
    1030. 

  1030. 

  1031. 			if (($currentPage - 1) > 0) {
    1032. 

  1032. 				$labelPrevious = $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xml:previous');
    1033. 

  1033. 

  1034. 				$previous = '<a href="' . $listURL . '&pointer=' . (($currentPage - 2) * $this->iLimit) . '">' .
    1035. 

  1035. 					t3lib_iconWorks::getSpriteIcon('actions-view-paging-previous', array('title' => $labelPrevious)) .
    1036. 

  1036. 					'</a>';
    1037. 

  1037. 			} else {
    1038. 

  1038. 				$previous = t3lib_iconWorks::getSpriteIcon('actions-view-paging-previous-disabled');
    1039. 

  1039. 			}
    1040. 

  1040. 

  1041. 			if (($currentPage + 1) <= $totalPages) {
    1042. 

  1042. 				$labelNext = $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xml:next');
    1043. 

  1043. 

  1044. 				$next = '<a href="' . $listURL . '&pointer=' . (($currentPage) * $this->iLimit) . '">' .
    1045. 

  1045. 					t3lib_iconWorks::getSpriteIcon('actions-view-paging-next', array('title' => $labelNext)) .
    1046. 

  1046. 					'</a>';
    1047. 

  1047. 			} else {
    1048. 

  1048. 				$next = t3lib_iconWorks::getSpriteIcon('actions-view-paging-next-disabled');
    1049. 

  1049. 			}
    1050. 

  1050. 

  1051. 			if ($currentPage != $totalPages) {
    1052. 

  1052. 				$labelLast = $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xml:last');
    1053. 

  1053. 

  1054. 				$last = '<a href="' . $listURL . '&pointer=' . (($totalPages - 1) * $this->iLimit) . '">' .
    1055. 

  1055. 					t3lib_iconWorks::getSpriteIcon('actions-view-paging-last', array('title' => $labelLast)) .
    1056. 

  1056. 					'</a>';
    1057. 

  1057. 			} else {
    1058. 

  1058. 				$last = t3lib_iconWorks::getSpriteIcon('actions-view-paging-last-disabled');
    1059. 

  1059. 			}
    1060. 

  1060. 

  1061. 			$reload = '<a href="#" onclick="document.dblistForm.action=\''
    1062. 

  1062. 				. $listURL . '&pointer=\'+calculatePointer(); document.dblistForm.submit(); return true;" title="' . $GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_common.xml:reload', TRUE) . '">' .
    1063. 

  1063. 					t3lib_iconWorks::getSpriteIcon('actions-system-refresh') .
    1064. 

  1064. 				'</a>';
    1065. 

  1065. 

  1066. 			// Add js to traverse a page select input to a pointer value
    1067. 

  1067. 			$content = '
    1068. 

  1068. <script type="text/JavaScript">
    1069. 

  1069. /*<![CDATA[*/
    1070. 

  1070. 

  1071. 	function calculatePointer(){
    1072. 

  1072. 		page = document.getElementById(\'jumpPage\').value;
    1073. 

    1074. 

  1074. 		if (page > ' . $totalPages . ') {
    1075. 

  1075. 			page = ' . $totalPages . ';
    1076. 

  1076. 		}
    1077. 

  1077. 

  1078. 		if (page < 1) {
    1079. 

  1079. 			page = 1;
    1080. 

  1080. 		}
    1081. 

  1081. 

  1082. 		pointer = (page - 1) * ' . $this->iLimit . ';
    1083. 

  1083. 

  1084. 		return pointer;
    1085. 

  1085. 	}
    1086. 

  1086. 

  1087. /*]]>*/
    1088. 

  1088. </script>
    1089. 

  1089. ';
    1090. 

    1091. 

  1091. 			$pageNumberInput = '<span>
    1092. 

  1092. 				<input type="text" value="' . $currentPage
    1093. 

  1093. 				. '" size="3" id="jumpPage" name="jumpPage" onkeyup="if (event.keyCode == Event.KEY_RETURN) { document.dblistForm.action=\'' . $listURL . '&pointer=\'+calculatePointer(); document.dblistForm.submit(); } return true;" />
    1094. 

  1094. 				</span>';
    1095. 

  1095. 			$pageIndicator = '<span class="pageIndicator">'
    1096. 

  1096. 				. sprintf($GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_mod_web_list.xml:pageIndicator'), $pageNumberInput, $totalPages)
    1097. 

  1097. 				. '</span>';
    1098. 

  1098. 

  1099. 			if ($this->totalItems > ($this->firstElementNumber + $this->iLimit)) {
    1100. 

  1100. 				$lastElementNumber = $this->firstElementNumber + $this->iLimit;
    1101. 

  1101. 			} else {
    1102. 

  1102. 				$lastElementNumber = $this->totalItems;
    1103. 

  1103. 			}
    1104. 

  1104. 			$rangeIndicator = '<span class="pageIndicator">'
    1105. 

  1105. 				. sprintf($GLOBALS['LANG']->sL('LLL:EXT:lang/locallang_mod_web_list.xml:rangeIndicator'), $this->firstElementNumber + 1, $lastElementNumber)
    1106. 

  1106. 				. '</span>';
    1107. 

  1107. 

  1108. 			$content .= '<div id="typo3-dblist-pagination">'
    1109. 

  1109. 				. $first . $previous
    1110. 

  1110. 				. '<span class="bar">&nbsp;</span>'
    1111. 

  1111. 				. $rangeIndicator . '<span class="bar">&nbsp;</span>'
    1112. 

  1112. 				. $pageIndicator . '<span class="bar">&nbsp;</span>'
    1113. 

  1113. 				. $next . $last . '<span class="bar">&nbsp;</span>'
    1114. 

  1114. 				. $reload
    1115. 

  1115. 				. '</div>';
    1116. 

  1116. 

  1117. 			$data = Array();
    1118. 

  1118. 			$titleColumn = $this->fieldArray[0];
    1119. 

  1119. 			$data[$titleColumn] = $content;
    1120. 

  1120. 

  1121. 			$returnContent = $this->addElement(1, '', $data);
    1122. 

  1122. 		} // end of if pages > 1
    1123. 

  1123. 

  1124. 		return $returnContent;
    1125. 

  1125. 	}
    1126. 

  1126. 

  1127. 

  1128. 

  1129. 

  1130. 

  1131. 

  1132. 	/*********************************
    1133. 

  1133. 	 *
    1134. 

  1134. 	 * Rendering of various elements
    1135. 

  1135. 	 *
    1136. 

  1136. 	 *********************************/
    1137. 

  1137. 

  1138. 	/**
    1139. 

  1139. 	 * Creates the control panel for a single record in the listing.
    1140. 

  1140. 	 *
    1141. 

  1141. 	 * @param	string		The table
    1142. 

  1142. 	 * @param	array		The record for which to make the control panel.
    1143. 

  1143. 	 * @return	string		HTML table with the control panel (unless disabled)
    1144. 

  1144. 	 */
    1145. 

  1145. 	function makeControl($table,$row)	{
    1146. 

  1146. 		global $TCA, $LANG, $SOBE, $TYPO3_CONF_VARS;
    1147. 

  1147. 

  1148. 		if ($this->dontShowClipControlPanels)	return '';
    1149. 

  1149. 

  1150. 			// Initialize:
    1151. 

  1151. 		t3lib_div::loadTCA($table);
    1152. 

  1152. 		$cells=array();
    1153. 

  1153. 

  1154. 			// If the listed table is 'pages' we have to request the permission settings for each page:
    1155. 

  1155. 		if ($table=='pages')	{
    1156. 

  1156. 			$localCalcPerms = $GLOBALS['BE_USER']->calcPerms(t3lib_BEfunc::getRecord('pages',$row['uid']));
    1157. 

  1157. 		}
    1158. 

  1158. 

  1159. 			// This expresses the edit permissions for this particular element:
    1160. 

  1160. 		$permsEdit = ($table=='pages' && ($localCalcPerms&2)) || ($table!='pages' && ($this->calcPerms&16));
    1161. 

  1161. 

  1162. 			// "Show" link (only pages and tt_content elements)
    1163. 

  1163. 		if ($table=='pages' || $table=='tt_content')	{
    1164. 

  1164. 			$params='&edit['.$table.']['.$row['uid'].']=edit';
    1165. 

  1165. 			$cells['view']='<a href="#" onclick="'.htmlspecialchars(t3lib_BEfunc::viewOnClick($table=='tt_content'?$this->id.'#'.$row['uid']:$row['uid'], $this->backPath)).'" title="'.$LANG->sL('LLL:EXT:lang/locallang_core.php:labels.showPage', TRUE).'">'.
    1166. 

  1166. 						t3lib_iconWorks::getSpriteIcon('actions-document-view') .
    1167. 

  1167. 					'</a>';
    1168. 

  1168. 		} elseif(!$this->table) {
    1169. 

  1169. 			$cells['view'] = $this->spaceIcon;
    1170. 

  1170. 		}
    1171. 

  1171. 

  1172. 			// "Edit" link: ( Only if permissions to edit the page-record of the content of the parent page ($this->id)
    1173. 

  1173. 		if ($permsEdit)	{
    1174. 

  1174. 			$params='&edit['.$table.']['.$row['uid'].']=edit';
    1175. 

  1175. 			$cells['edit']='<a href="#" onclick="'.htmlspecialchars(t3lib_BEfunc::editOnClick($params,$this->backPath,-1)).'" title="'.$LANG->getLL('edit', TRUE).'">'.
    1176. 

  1176. 						( $TCA[$table]['ctrl']['readOnly'] ? t3lib_iconWorks::getSpriteIcon('actions-document-open-read-only') : t3lib_iconWorks::getSpriteIcon('actions-document-open') ).
    1177. 

  1177. 					'</a>';
    1178. 

  1178. 		} elseif(!$this->table) {
    1179. 

  1179. 			$cells['edit'] = $this->spaceIcon;
    1180. 

  1180. 		}
    1181. 

  1181. 

  1182. 			// "Move" wizard link for pages/tt_content elements:
    1183. 

  1183. 		if (($table=="tt_content" && $permsEdit) || ($table=='pages'))	{
    1184. 

  1184. 			$cells['move']='<a href="#" onclick="'.htmlspecialchars('return jumpExt(\''.$this->backPath.'move_el.php?table='.$table.'&uid='.$row['uid'].'\');').'" title="'.$LANG->getLL('move_…
    1185.

Large files files are truncated, but you can click here to view the full file