[BUGFIX] Listview: Display parent field of categories
[Packages/TYPO3.CMS.git] / typo3 / sysext / backend / Classes / RecordList / AbstractRecordList.php
1 <?php
2 namespace TYPO3\CMS\Backend\RecordList;
3
4 /*
5 * This file is part of the TYPO3 CMS project.
6 *
7 * It is free software; you can redistribute it and/or modify it under
8 * the terms of the GNU General Public License, either version 2
9 * of the License, or any later version.
10 *
11 * For the full copyright and license information, please read the
12 * LICENSE.txt file that was distributed with this source code.
13 *
14 * The TYPO3 project - inspiring people to share!
15 */
16
17 use TYPO3\CMS\Backend\Configuration\TranslationConfigurationProvider;
18 use TYPO3\CMS\Backend\Routing\Router;
19 use TYPO3\CMS\Backend\Routing\UriBuilder;
20 use TYPO3\CMS\Backend\Utility\BackendUtility;
21 use TYPO3\CMS\Core\Database\DatabaseConnection;
22 use TYPO3\CMS\Core\Imaging\Icon;
23 use TYPO3\CMS\Core\Imaging\IconFactory;
24 use TYPO3\CMS\Core\Utility\GeneralUtility;
25 use TYPO3\CMS\Lang\LanguageService;
26
27 /**
28 * Library with a single function addElement that returns table
29 * rows based on some input.
30 *
31 * Base for class listing of database records and files in the
32 * modules Web>List and File>Filelist
33 * @see typo3/db_list.php
34 * @see typo3/sysext/filelist/mod1/index.php
35 */
36 abstract class AbstractRecordList
37 {
38 /**
39 * @var int
40 */
41 protected $id = 0;
42
43 /**
44 * default Max items shown
45 *
46 * @var int
47 */
48 public $iLimit = 10;
49
50 /**
51 * OBSOLETE - NOT USED ANYMORE. leftMargin
52 *
53 * @var int
54 */
55 public $leftMargin = 0;
56
57 /**
58 * @var int
59 */
60 public $showIcon = 1;
61
62 /**
63 * @var int
64 */
65 public $no_noWrap = 0;
66
67 /**
68 * If set this is <td> CSS-classname for odd columns in addElement. Used with db_layout / pages section
69 *
70 * @var string
71 */
72 public $oddColumnsCssClass = '';
73
74 /**
75 * Decides the columns shown. Filled with values that refers to the keys of the data-array. $this->fieldArray[0] is the title column.
76 *
77 * @var array
78 */
79 public $fieldArray = [];
80
81 /**
82 * Keys are fieldnames and values are td-parameters to add in addElement(), please use $addElement_tdCSSClass for CSS-classes;
83 *
84 * @var array
85 */
86 public $addElement_tdParams = [];
87
88 /**
89 * Keys are fieldnames and values are td-css-classes to add in addElement();
90 *
91 * @var array
92 */
93 public $addElement_tdCssClass = [];
94
95 /**
96 * Not used in this class - but maybe extension classes...
97 * Max length of strings
98 *
99 * @var int
100 */
101 public $fixedL = 30;
102
103 /**
104 * Script URL
105 *
106 * @var string
107 */
108 public $thisScript = '';
109
110 /**
111 * Set to zero, if you don't want a left-margin with addElement function
112 *
113 * @var int
114 */
115 public $setLMargin = 1;
116
117 /**
118 * Counter increased for each element. Used to index elements for the JavaScript-code that transfers to the clipboard
119 *
120 * @var int
121 */
122 public $counter = 0;
123
124 /**
125 * This could be set to the total number of items. Used by the fwd_rew_navigation...
126 *
127 * @var string
128 */
129 public $totalItems = '';
130
131 /**
132 * Internal (used in this class.)
133 *
134 * @var int
135 */
136 public $firstElementNumber = 0;
137
138 /**
139 * @var int
140 */
141 public $eCounter = 0;
142
143 /**
144 * String with accumulated HTML content
145 *
146 * @var string
147 */
148 public $HTMLcode = '';
149
150 /**
151 * Contains page translation languages
152 *
153 * @var array
154 */
155 public $pageOverlays = [];
156
157 /**
158 * Contains sys language icons and titles
159 *
160 * @var array
161 */
162 public $languageIconTitles = [];
163
164 /**
165 * @var TranslationConfigurationProvider
166 */
167 public $translateTools;
168
169 /**
170 * @var IconFactory
171 */
172 protected $iconFactory;
173
174 /**
175 * Constructor
176 */
177 public function __construct()
178 {
179 if (isset($GLOBALS['BE_USER']->uc['titleLen']) && $GLOBALS['BE_USER']->uc['titleLen'] > 0) {
180 $this->fixedL = $GLOBALS['BE_USER']->uc['titleLen'];
181 }
182 $this->iconFactory = GeneralUtility::makeInstance(IconFactory::class);
183 $this->getTranslateTools();
184 $this->determineScriptUrl();
185 }
186
187 /**
188 * Sets the script url depending on being a module or script request
189 */
190 protected function determineScriptUrl()
191 {
192 if ($routePath = GeneralUtility::_GP('route')) {
193 $router = GeneralUtility::makeInstance(Router::class);
194 $route = $router->match($routePath);
195 $uriBuilder = GeneralUtility::makeInstance(UriBuilder::class);
196 $this->thisScript = (string)$uriBuilder->buildUriFromRoute($route->getOption('_identifier'));
197 } elseif ($moduleName = GeneralUtility::_GP('M')) {
198 $this->thisScript = BackendUtility::getModuleUrl($moduleName);
199 } else {
200 $this->thisScript = GeneralUtility::getIndpEnv('SCRIPT_NAME');
201 }
202 }
203
204 /**
205 * @return string
206 */
207 protected function getThisScript()
208 {
209 return strpos($this->thisScript, '?') === false ? $this->thisScript . '?' : $this->thisScript . '&';
210 }
211
212 /**
213 * Returns a table-row with the content from the fields in the input data array.
214 * OBS: $this->fieldArray MUST be set! (represents the list of fields to display)
215 *
216 * @param int $h Is an integer >=0 and denotes how tall an element is. Set to '0' makes a halv line, -1 = full line, set to 1 makes a 'join' and above makes 'line'
217 * @param string $icon Is the <img>+<a> of the record. If not supplied the first 'join'-icon will be a 'line' instead
218 * @param array $data Is the dataarray, record with the fields. Notice: These fields are (currently) NOT htmlspecialchar'ed before being wrapped in <td>-tags
219 * @param string $rowParams Is insert in the <tr>-tags. Must carry a ' ' as first character
220 * @param string $_ OBSOLETE - NOT USED ANYMORE. $lMargin is the leftMargin (int)
221 * @param string $_ OBSOLETE - NOT USED ANYMORE. Is the HTML <img>-tag for an alternative 'gfx/ol/line.gif'-icon (used in the top)
222 * @param string $colType Defines the tag being used for the columns. Default is td.
223 * @return string HTML content for the table row
224 */
225 public function addElement($h, $icon, $data, $rowParams = '', $_ = '', $_2 = '', $colType = 'td')
226 {
227 $colType = ($colType === 'th') ? 'th' : 'td';
228 $noWrap = $this->no_noWrap ? '' : ' nowrap="nowrap"';
229 // Start up:
230 $l10nParent = isset($data['_l10nparent_']) ? (int)$data['_l10nparent_'] : 0;
231 $out = '
232 <!-- Element, begin: -->
233 <tr ' . $rowParams . ' data-uid="' . (int)$data['uid'] . '" data-l10nparent="' . $l10nParent . '">';
234 // Show icon and lines
235 if ($this->showIcon) {
236 $out .= '
237 <' . $colType . ' nowrap="nowrap" class="col-icon">';
238 if (!$h) {
239 $out .= '&nbsp;';
240 } else {
241 for ($a = 0; $a < $h; $a++) {
242 if (!$a) {
243 if ($icon) {
244 $out .= $icon;
245 }
246 } else {
247 }
248 }
249 }
250 $out .= '</' . $colType . '>
251 ';
252 }
253 // Init rendering.
254 $colsp = '';
255 $lastKey = '';
256 $c = 0;
257 $ccount = 0;
258 // __label is used as the label key to circumvent problems with uid used as label (see #67756)
259 // as it was introduced later on, check if it really exists before using it
260 $fields = $this->fieldArray;
261 if ($colType === 'td' && array_key_exists('__label', $data)) {
262 $fields[0] = '__label';
263 }
264 // Traverse field array which contains the data to present:
265 foreach ($fields as $vKey) {
266 if (isset($data[$vKey])) {
267 if ($lastKey) {
268 $cssClass = $this->addElement_tdCssClass[$lastKey];
269 if ($this->oddColumnsCssClass && $ccount % 2 == 0) {
270 $cssClass = implode(' ', [$this->addElement_tdCssClass[$lastKey], $this->oddColumnsCssClass]);
271 }
272 $out .= '
273 <' . $colType . $noWrap . ' class="' . $cssClass . '"' . $colsp . $this->addElement_tdParams[$lastKey] . '>' . $data[$lastKey] . '</' . $colType . '>';
274 }
275 $lastKey = $vKey;
276 $c = 1;
277 $ccount++;
278 } else {
279 if (!$lastKey) {
280 $lastKey = $vKey;
281 }
282 $c++;
283 }
284 if ($c > 1) {
285 $colsp = ' colspan="' . $c . '"';
286 } else {
287 $colsp = '';
288 }
289 }
290 if ($lastKey) {
291 $cssClass = $this->addElement_tdCssClass[$lastKey];
292 if ($this->oddColumnsCssClass) {
293 $cssClass = implode(' ', [$this->addElement_tdCssClass[$lastKey], $this->oddColumnsCssClass]);
294 }
295 $out .= '
296 <' . $colType . $noWrap . ' class="' . $cssClass . '"' . $colsp . $this->addElement_tdParams[$lastKey] . '>' . $data[$lastKey] . '</' . $colType . '>';
297 }
298 // End row
299 $out .= '
300 </tr>';
301 // Return row.
302 return $out;
303 }
304
305 /**
306 * Dummy function, used to write the top of a table listing.
307 *
308 * @return void
309 */
310 public function writeTop()
311 {
312 }
313
314 /**
315 * Creates a forward/reverse button based on the status of ->eCounter, ->firstElementNumber, ->iLimit
316 *
317 * @param string $table Table name
318 * @return array array([boolean], [HTML]) where [boolean] is 1 for reverse element, [HTML] is the table-row code for the element
319 */
320 public function fwd_rwd_nav($table = '')
321 {
322 $code = '';
323 if ($this->eCounter >= $this->firstElementNumber && $this->eCounter < $this->firstElementNumber + $this->iLimit) {
324 if ($this->firstElementNumber && $this->eCounter == $this->firstElementNumber) {
325 // Reverse
326 $theData = [];
327 $titleCol = $this->fieldArray[0];
328 $theData[$titleCol] = $this->fwd_rwd_HTML('fwd', $this->eCounter, $table);
329 $code = $this->addElement(1, '', $theData, 'class="fwd_rwd_nav"');
330 }
331 return [1, $code];
332 } else {
333 if ($this->eCounter == $this->firstElementNumber + $this->iLimit) {
334 // Forward
335 $theData = [];
336 $titleCol = $this->fieldArray[0];
337 $theData[$titleCol] = $this->fwd_rwd_HTML('rwd', $this->eCounter, $table);
338 $code = $this->addElement(1, '', $theData, 'class="fwd_rwd_nav"');
339 }
340 return [0, $code];
341 }
342 }
343
344 /**
345 * Creates the button with link to either forward or reverse
346 *
347 * @param string $type Type: "fwd" or "rwd
348 * @param int $pointer Pointer
349 * @param string $table Table name
350 * @return string
351 * @access private
352 */
353 public function fwd_rwd_HTML($type, $pointer, $table = '')
354 {
355 $content = '';
356 $tParam = $table ? '&table=' . rawurlencode($table) : '';
357 switch ($type) {
358 case 'fwd':
359 $href = $this->listURL() . '&pointer=' . ($pointer - $this->iLimit) . $tParam;
360 $content = '<a href="' . htmlspecialchars($href) . '">' . $this->iconFactory->getIcon('actions-move-up', Icon::SIZE_SMALL)->render() . '</a> <i>[1 - ' . $pointer . ']</i>';
361 break;
362 case 'rwd':
363 $href = $this->listURL() . '&pointer=' . $pointer . $tParam;
364 $content = '<a href="' . htmlspecialchars($href) . '">' . $this->iconFactory->getIcon('actions-move-down', Icon::SIZE_SMALL)->render() . '</a> <i>[' . ($pointer + 1) . ' - ' . $this->totalItems . ']</i>';
365 break;
366 }
367 return $content;
368 }
369
370 /**
371 * Creates the URL to this script, including all relevant GPvars
372 *
373 * @param string $altId Alternative id value. Enter blank string for the current id ($this->id)
374 * @param string $table Table name to display. Enter "-1" for the current table.
375 * @param string $exclList Comma separated list of fields NOT to include ("sortField", "sortRev" or "firstElementNumber")
376 * @return string URL
377 */
378 public function listURL($altId = '', $table = '-1', $exclList = '')
379 {
380 return $this->getThisScript() . 'id=' . ($altId !== '' ? $altId : $this->id);
381 }
382
383 /**
384 * Returning JavaScript for ClipBoard functionality.
385 *
386 * @return string
387 */
388 public function CBfunctions()
389 {
390 return '
391 // checkOffCB()
392 function checkOffCB(listOfCBnames, link) { //
393 var checkBoxes, flag, i;
394 var checkBoxes = listOfCBnames.split(",");
395 if (link.rel === "") {
396 link.rel = "allChecked";
397 flag = true;
398 } else {
399 link.rel = "";
400 flag = false;
401 }
402 for (i = 0; i < checkBoxes.length; i++) {
403 setcbValue(checkBoxes[i], flag);
404 }
405 }
406 // cbValue()
407 function cbValue(CBname) { //
408 var CBfullName = "CBC["+CBname+"]";
409 return (document.dblistForm[CBfullName] && document.dblistForm[CBfullName].checked ? 1 : 0);
410 }
411 // setcbValue()
412 function setcbValue(CBname,flag) { //
413 CBfullName = "CBC["+CBname+"]";
414 if(document.dblistForm[CBfullName]) {
415 document.dblistForm[CBfullName].checked = flag ? "on" : 0;
416 }
417 }
418
419 ';
420 }
421
422 /**
423 * Initializes page languages and icons
424 *
425 * @return void
426 */
427 public function initializeLanguages()
428 {
429 // Look up page overlays:
430 $this->pageOverlays = $this->getDatabaseConnection()->exec_SELECTgetRows('*', 'pages_language_overlay', 'pid=' . (int)$this->id . BackendUtility::deleteClause('pages_language_overlay') . BackendUtility::versioningPlaceholderClause('pages_language_overlay'), '', '', '', 'sys_language_uid');
431 $this->languageIconTitles = $this->getTranslateTools()->getSystemLanguages($this->id);
432 }
433
434 /**
435 * Return the icon for the language
436 *
437 * @param int $sys_language_uid Sys language uid
438 * @param bool $addAsAdditionalText If set to true, only the flag is returned
439 * @return string Language icon
440 */
441 public function languageFlag($sys_language_uid, $addAsAdditionalText = true)
442 {
443 $out = '';
444 $title = htmlspecialchars($this->languageIconTitles[$sys_language_uid]['title']);
445 if ($this->languageIconTitles[$sys_language_uid]['flagIcon']) {
446 $out .= '<span title="' . $title . '">' . $this->iconFactory->getIcon($this->languageIconTitles[$sys_language_uid]['flagIcon'], Icon::SIZE_SMALL)->render() . '</span>';
447 if (!$addAsAdditionalText) {
448 return $out;
449 }
450 $out .= '&nbsp;';
451 }
452 $out .= $title;
453 return $out;
454 }
455
456 /**
457 * Gets an instance of TranslationConfigurationProvider
458 *
459 * @return TranslationConfigurationProvider
460 */
461 protected function getTranslateTools()
462 {
463 if (!isset($this->translateTools)) {
464 $this->translateTools = GeneralUtility::makeInstance(TranslationConfigurationProvider::class);
465 }
466 return $this->translateTools;
467 }
468
469 /**
470 * Generates HTML code for a Reference tooltip out of
471 * sys_refindex records you hand over
472 *
473 * @param int $references number of records from sys_refindex table
474 * @param string $launchViewParameter JavaScript String, which will be passed as parameters to top.launchView
475 * @return string
476 */
477 protected function generateReferenceToolTip($references, $launchViewParameter = '')
478 {
479 if (!$references) {
480 $htmlCode = '-';
481 } else {
482 $htmlCode = '<a href="#"';
483 if ($launchViewParameter !== '') {
484 $htmlCode .= ' onclick="' . htmlspecialchars(('top.launchView(' . $launchViewParameter . '); return false;')) . '"';
485 }
486 $htmlCode .= ' title="' . htmlspecialchars($this->getLanguageService()->sl('LLL:EXT:backend/Resources/Private/Language/locallang.xlf:show_references') . ' (' . $references . ')') . '">';
487 $htmlCode .= $references;
488 $htmlCode .= '</a>';
489 }
490 return $htmlCode;
491 }
492
493 /**
494 * Returns the language service
495 * @return LanguageService
496 */
497 protected function getLanguageService()
498 {
499 return $GLOBALS['LANG'];
500 }
501
502 /**
503 * Returns the database connection
504 *
505 * @return DatabaseConnection
506 */
507 protected function getDatabaseConnection()
508 {
509 return $GLOBALS['TYPO3_DB'];
510 }
511 }