[BUGFIX] Delete move placeholders upon record deletion
[Packages/TYPO3.CMS.git] / typo3 / sysext / core / Classes / DataHandling / DataHandler.php
1 <?php
2 namespace TYPO3\CMS\Core\DataHandling;
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\Utility\BackendUtility;
18 use TYPO3\CMS\Core\Authentication\BackendUserAuthentication;
19 use TYPO3\CMS\Core\Cache\CacheManager;
20 use TYPO3\CMS\Core\Cache\Frontend\VariableFrontend;
21 use TYPO3\CMS\Core\Configuration\FlexForm\FlexFormTools;
22 use TYPO3\CMS\Core\Database\DatabaseConnection;
23 use TYPO3\CMS\Core\Database\ReferenceIndex;
24 use TYPO3\CMS\Core\Database\RelationHandler;
25 use TYPO3\CMS\Core\Html\RteHtmlParser;
26 use TYPO3\CMS\Core\Messaging\FlashMessage;
27 use TYPO3\CMS\Core\Messaging\FlashMessageService;
28 use TYPO3\CMS\Core\Resource\ResourceFactory;
29 use TYPO3\CMS\Core\Type\Bitmask\Permission;
30 use TYPO3\CMS\Core\Utility\ArrayUtility;
31 use TYPO3\CMS\Core\Utility\File\BasicFileUtility;
32 use TYPO3\CMS\Core\Utility\GeneralUtility;
33 use TYPO3\CMS\Core\Utility\MathUtility;
34 use TYPO3\CMS\Core\Utility\PathUtility;
35 use TYPO3\CMS\Core\Utility\StringUtility;
36 use TYPO3\CMS\Core\Versioning\VersionState;
37
38 /**
39 * The main data handler class which takes care of correctly updating and inserting records.
40 * This class was formerly known as TCEmain.
41 *
42 * This is the TYPO3 Core Engine class for manipulation of the database
43 * This class is used by eg. the tce_db.php script which provides an the interface for POST forms to this class.
44 *
45 * Dependencies:
46 * - $GLOBALS['TCA'] must exist
47 * - $GLOBALS['LANG'] must exist
48 *
49 * tce_db.php for further comments and SYNTAX! Also see document 'TYPO3 Core API' for details.
50 */
51 class DataHandler {
52
53 // *********************
54 // Public variables you can configure before using the class:
55 // *********************
56 /**
57 * If TRUE, the default log-messages will be stored. This should not be necessary if the locallang-file for the
58 * log-display is properly configured. So disabling this will just save some database-space as the default messages are not saved.
59 *
60 * @var bool
61 */
62 public $storeLogMessages = TRUE;
63
64 /**
65 * If TRUE, actions are logged to sys_log.
66 *
67 * @var bool
68 */
69 public $enableLogging = TRUE;
70
71 /**
72 * If TRUE, the datamap array is reversed in the order, which is a nice thing if you're creating a whole new
73 * bunch of records.
74 *
75 * @var bool
76 */
77 public $reverseOrder = FALSE;
78
79 /**
80 * If TRUE, only fields which are different from the database values are saved! In fact, if a whole input array
81 * is similar, it's not saved then.
82 *
83 * @var bool
84 */
85 public $checkSimilar = TRUE;
86
87 /**
88 * If TRUE, incoming values in the data-array have their slashes stripped. ALWAYS SET THIS TO ZERO and supply an
89 * unescaped data array instead. This switch may totally disappear in future versions of this class!
90 *
91 * @var bool
92 * @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
93 */
94 public $stripslashes_values = TRUE;
95
96 /**
97 * This will read the record after having updated or inserted it. If anything is not properly submitted an error
98 * is written to the log. This feature consumes extra time by selecting records
99 *
100 * @var bool
101 */
102 public $checkStoredRecords = TRUE;
103
104 /**
105 * If set, values '' and 0 will equal each other when the stored records are checked.
106 *
107 * @var bool
108 */
109 public $checkStoredRecords_loose = TRUE;
110
111 /**
112 * If this is set, then a page is deleted by deleting the whole branch under it (user must have
113 * delete permissions to it all). If not set, then the page is deleted ONLY if it has no branch.
114 *
115 * @var bool
116 */
117 public $deleteTree = FALSE;
118
119 /**
120 * If set, then the 'hideAtCopy' flag for tables will be ignored.
121 *
122 * @var bool
123 */
124 public $neverHideAtCopy = FALSE;
125
126 /**
127 * If set, then the TCE class has been instantiated during an import action of a T3D
128 *
129 * @var bool
130 */
131 public $isImporting = FALSE;
132
133 /**
134 * If set, then transformations are NOT performed on the input.
135 *
136 * @var bool
137 */
138 public $dontProcessTransformations = FALSE;
139
140 /**
141 * If set, .vDEFbase values are unset in flexforms.
142 *
143 * @var bool
144 */
145 public $clear_flexFormData_vDEFbase = FALSE;
146
147 /**
148 * TRUE: (traditional) Updates when record is saved. For flexforms, updates if change is made to the localized value.
149 * FALSE: Will not update anything.
150 * "FORCE_FFUPD" (string): Like TRUE, but will force update to the FlexForm Field
151 *
152 * @var bool|string
153 */
154 public $updateModeL10NdiffData = TRUE;
155
156 /**
157 * If TRUE, the translation diff. fields will in fact be reset so that they indicate that all needs to change again!
158 * It's meant as the opposite of declaring the record translated.
159 *
160 * @var bool
161 */
162 public $updateModeL10NdiffDataClear = FALSE;
163
164 /**
165 * If TRUE, workspace restrictions are bypassed on edit an create actions (process_datamap()).
166 * YOU MUST KNOW what you do if you use this feature!
167 *
168 * @var bool
169 */
170 public $bypassWorkspaceRestrictions = FALSE;
171
172 /**
173 * If TRUE, file handling of attached files (addition, deletion etc) is bypassed - the value is saved straight away.
174 * YOU MUST KNOW what you are doing with this feature!
175 *
176 * @var bool
177 */
178 public $bypassFileHandling = FALSE;
179
180 /**
181 * If TRUE, access check, check for deleted etc. for records is bypassed.
182 * YOU MUST KNOW what you are doing if you use this feature!
183 *
184 * @var bool
185 */
186 public $bypassAccessCheckForRecords = FALSE;
187
188 /**
189 * Comma-separated list. This list of tables decides which tables will be copied. If empty then none will.
190 * If '*' then all will (that the user has permission to of course)
191 *
192 * @var string
193 */
194 public $copyWhichTables = '*';
195
196 /**
197 * If 0 then branch is NOT copied.
198 * If 1 then pages on the 1st level is copied.
199 * If 2 then pages on the second level is copied ... and so on
200 *
201 * @var int
202 */
203 public $copyTree = 0;
204
205 /**
206 * [table][fields]=value: New records are created with default values and you can set this array on the
207 * form $defaultValues[$table][$field] = $value to override the default values fetched from TCA.
208 * If ->setDefaultsFromUserTS is called UserTSconfig default values will overrule existing values in this array
209 * (thus UserTSconfig overrules externally set defaults which overrules TCA defaults)
210 *
211 * @var array
212 */
213 public $defaultValues = array();
214
215 /**
216 * [table][fields]=value: You can set this array on the form $overrideValues[$table][$field] = $value to
217 * override the incoming data. You must set this externally. You must make sure the fields in this array are also
218 * found in the table, because it's not checked. All columns can be set by this array!
219 *
220 * @var array
221 */
222 public $overrideValues = array();
223
224 /**
225 * [filename]=alternative_filename: Use this array to force another name onto a file.
226 * Eg. if you set ['/tmp/blablabal'] = 'my_file.txt' and '/tmp/blablabal' is set for a certain file-field,
227 * then 'my_file.txt' will be used as the name instead.
228 *
229 * @var array
230 */
231 public $alternativeFileName = array();
232
233 /**
234 * Array [filename]=alternative_filepath: Same as alternativeFileName but with relative path to the file
235 *
236 * @var array
237 */
238 public $alternativeFilePath = array();
239
240 /**
241 * If entries are set in this array corresponding to fields for update, they are ignored and thus NOT updated.
242 * You could set this array from a series of checkboxes with value=0 and hidden fields before the checkbox with 1.
243 * Then an empty checkbox will disable the field.
244 *
245 * @var array
246 */
247 public $data_disableFields = array();
248
249 /**
250 * Use this array to validate suggested uids for tables by setting [table]:[uid]. This is a dangerous option
251 * since it will force the inserted record to have a certain UID. The value just have to be TRUE, but if you set
252 * it to "DELETE" it will make sure any record with that UID will be deleted first (raw delete).
253 * The option is used for import of T3D files when synchronizing between two mirrored servers.
254 * As a security measure this feature is available only for Admin Users (for now)
255 *
256 * @var array
257 */
258 public $suggestedInsertUids = array();
259
260 /**
261 * Object. Call back object for FlexForm traversal. Useful when external classes wants to use the
262 * iteration functions inside DataHandler for traversing a FlexForm structure.
263 *
264 * @var object
265 */
266 public $callBackObj;
267
268 // *********************
269 // Internal variables (mapping arrays) which can be used (read-only) from outside
270 // *********************
271 /**
272 * Contains mapping of auto-versionized records.
273 *
274 * @var array
275 */
276 public $autoVersionIdMap = array();
277
278 /**
279 * When new elements are created, this array contains a map between their "NEW..." string IDs and the eventual UID they got when stored in database
280 *
281 * @var array
282 */
283 public $substNEWwithIDs = array();
284
285 /**
286 * Like $substNEWwithIDs, but where each old "NEW..." id is mapped to the table it was from.
287 *
288 * @var array
289 */
290 public $substNEWwithIDs_table = array();
291
292 /**
293 * Holds the tables and there the ids of newly created child records from IRRE
294 *
295 * @var array
296 */
297 public $newRelatedIDs = array();
298
299 /**
300 * This array is the sum of all copying operations in this class. May be READ from outside, thus partly public.
301 *
302 * @var array
303 */
304 public $copyMappingArray_merged = array();
305
306 /**
307 * A map between input file name and final destination for files being attached to records.
308 *
309 * @var array
310 */
311 public $copiedFileMap = array();
312
313 /**
314 * Contains [table][id][field] of fiels where RTEmagic images was copied. Holds old filename as key and new filename as value.
315 *
316 * @var array
317 */
318 public $RTEmagic_copyIndex = array();
319
320 /**
321 * Errors are collected in this variable.
322 *
323 * @var array
324 */
325 public $errorLog = array();
326
327 /**
328 * Fields from the pages-table for which changes will trigger a pagetree refresh
329 *
330 * @var array
331 */
332 public $pagetreeRefreshFieldsFromPages = array('pid', 'sorting', 'deleted', 'hidden', 'title', 'doktype', 'is_siteroot', 'fe_group', 'nav_hide', 'nav_title', 'module', 'starttime', 'endtime', 'content_from_pid');
333
334 /**
335 * Indicates whether the pagetree needs a refresh because of important changes
336 *
337 * @var bool
338 */
339 public $pagetreeNeedsRefresh = FALSE;
340
341
342 // *********************
343 // Internal Variables, do not touch.
344 // *********************
345
346 // Variables set in init() function:
347
348 /**
349 * The user-object the script uses. If not set from outside, this is set to the current global $BE_USER.
350 *
351 * @var BackendUserAuthentication
352 */
353 public $BE_USER;
354
355 /**
356 * Will be set to uid of be_user executing this script
357 *
358 * @var int
359 */
360 public $userid;
361
362 /**
363 * Will be set to username of be_user executing this script
364 *
365 * @var string
366 */
367 public $username;
368
369 /**
370 * Will be set if user is admin
371 *
372 * @var bool
373 */
374 public $admin;
375
376 /**
377 * Can be overridden from $GLOBALS['TYPO3_CONF_VARS']
378 *
379 * @var array
380 */
381 public $defaultPermissions = array(
382 'user' => 'show,edit,delete,new,editcontent',
383 'group' => 'show,edit,new,editcontent',
384 'everybody' => ''
385 );
386
387 /**
388 * The list of <table>-<fields> that cannot be edited by user. This is compiled from TCA/exclude-flag combined with non_exclude_fields for the user.
389 *
390 * @var array
391 */
392 protected $excludedTablesAndFields = array();
393
394 /**
395 * @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
396 * @var int
397 */
398 public $include_filefunctions;
399
400 /**
401 * Data submitted from the form view, used to control behaviours,
402 * e.g. this is used to activate/deactivate fields and thus store NULL values
403 *
404 * @var array
405 */
406 protected $control = array();
407
408 /**
409 * Set with incoming data array
410 *
411 * @var array
412 */
413 public $datamap = array();
414
415 /**
416 * Set with incoming cmd array
417 *
418 * @var array
419 */
420 public $cmdmap = array();
421
422 /**
423 * List of changed old record ids to new records ids
424 *
425 * @var array
426 */
427 protected $mmHistoryRecords = array();
428
429 /**
430 * List of changed old record ids to new records ids
431 *
432 * @var array
433 */
434 protected $historyRecords = array();
435
436 // Internal static:
437 /**
438 * Permission mapping
439 *
440 * @var array
441 */
442 public $pMap = array(
443 'show' => 1,
444 // 1st bit
445 'edit' => 2,
446 // 2nd bit
447 'delete' => 4,
448 // 3rd bit
449 'new' => 8,
450 // 4th bit
451 'editcontent' => 16
452 );
453
454 /**
455 * Integer: The interval between sorting numbers used with tables with a 'sorting' field defined. Min 1
456 *
457 * @var int
458 */
459 public $sortIntervals = 256;
460
461 // Internal caching arrays
462 /**
463 * Used by function checkRecordUpdateAccess() to store whether a record is updatable or not.
464 *
465 * @var array
466 */
467 public $recUpdateAccessCache = array();
468
469 /**
470 * User by function checkRecordInsertAccess() to store whether a record can be inserted on a page id
471 *
472 * @var array
473 */
474 public $recInsertAccessCache = array();
475
476 /**
477 * Caching array for check of whether records are in a webmount
478 *
479 * @var array
480 */
481 public $isRecordInWebMount_Cache = array();
482
483 /**
484 * Caching array for page ids in webmounts
485 *
486 * @var array
487 */
488 public $isInWebMount_Cache = array();
489
490 /**
491 * Caching for collecting TSconfig for page ids
492 *
493 * @var array
494 */
495 public $cachedTSconfig = array();
496
497 /**
498 * Used for caching page records in pageInfo()
499 *
500 * @var array
501 */
502 public $pageCache = array();
503
504 /**
505 * Array caching workspace access for BE_USER
506 *
507 * @var array
508 */
509 public $checkWorkspaceCache = array();
510
511 // Other arrays:
512 /**
513 * For accumulation of MM relations that must be written after new records are created.
514 *
515 * @var array
516 */
517 public $dbAnalysisStore = array();
518
519 /**
520 * For accumulation of files which must be deleted after processing of all input content
521 *
522 * @var array
523 */
524 public $removeFilesStore = array();
525
526 /**
527 * Uploaded files, set by process_uploads()
528 *
529 * @var array
530 */
531 public $uploadedFileArray = array();
532
533 /**
534 * Used for tracking references that might need correction after operations
535 *
536 * @var array
537 */
538 public $registerDBList = array();
539
540 /**
541 * Used for tracking references that might need correction in pid field after operations (e.g. IRRE)
542 *
543 * @var array
544 */
545 public $registerDBPids = array();
546
547 /**
548 * Used by the copy action to track the ids of new pages so subpages are correctly inserted!
549 * THIS is internally cleared for each executed copy operation! DO NOT USE THIS FROM OUTSIDE!
550 * Read from copyMappingArray_merged instead which is accumulating this information.
551 *
552 * NOTE: This is used by some outside scripts (e.g. hooks), as the results in $copyMappingArray_merged
553 * are only available after an action has been completed.
554 *
555 * @var array
556 */
557 public $copyMappingArray = array();
558
559 /**
560 * Array used for remapping uids and values at the end of process_datamap
561 *
562 * @var array
563 */
564 public $remapStack = array();
565
566 /**
567 * Array used for remapping uids and values at the end of process_datamap
568 * (e.g. $remapStackRecords[<table>][<uid>] = <index in $remapStack>)
569 *
570 * @var array
571 */
572 public $remapStackRecords = array();
573
574 /**
575 * Array used for checking whether new children need to be remapped
576 *
577 * @var array
578 */
579 protected $remapStackChildIds = array();
580
581 /**
582 * Array used for executing addition actions after remapping happened (set processRemapStack())
583 *
584 * @var array
585 */
586 protected $remapStackActions = array();
587
588 /**
589 * Array used for executing post-processing on the reference index
590 *
591 * @var array
592 */
593 protected $remapStackRefIndex = array();
594
595 /**
596 * Array used for additional calls to $this->updateRefIndex
597 *
598 * @var array
599 */
600 public $updateRefIndexStack = array();
601
602 /**
603 * Tells, that this DataHandler instance was called from \TYPO3\CMS\Impext\ImportExport.
604 * This variable is set by \TYPO3\CMS\Impext\ImportExport
605 *
606 * @var array
607 */
608 public $callFromImpExp = FALSE;
609
610 /**
611 * Array for new flexform index mapping
612 *
613 * @var array
614 */
615 public $newIndexMap = array();
616
617 // Various
618 /**
619 * basicFileFunctions object
620 * For "singleton" file-manipulation object
621 *
622 * @var BasicFileUtility
623 */
624 public $fileFunc;
625
626 /**
627 * Set to "currentRecord" during checking of values.
628 *
629 * @var array
630 */
631 public $checkValue_currentRecord = array();
632
633 /**
634 * A signal flag used to tell file processing that auto versioning has happened and hence certain action should be applied.
635 *
636 * @var bool
637 */
638 public $autoVersioningUpdate = FALSE;
639
640 /**
641 * Disable delete clause
642 *
643 * @var bool
644 */
645 protected $disableDeleteClause = FALSE;
646
647 /**
648 * @var array
649 */
650 protected $checkModifyAccessListHookObjects;
651
652 /**
653 * @var array
654 */
655 protected $version_remapMMForVersionSwap_reg;
656
657 /**
658 * The outer most instance of \TYPO3\CMS\Core\DataHandling\DataHandler:
659 * This object instantiates itself on versioning and localization ...
660 *
661 * @var \TYPO3\CMS\Core\DataHandling\DataHandler
662 */
663 protected $outerMostInstance = NULL;
664
665 /**
666 * Internal cache for collecting records that should trigger cache clearing
667 *
668 * @var array
669 */
670 static protected $recordsToClearCacheFor = array();
671
672 /**
673 * Database layer. Identical to $GLOBALS['TYPO3_DB']
674 *
675 * @var DatabaseConnection
676 */
677 protected $databaseConnection;
678
679 /**
680 * Runtime Cache to store and retrieve data computed for a single request
681 *
682 * @var \TYPO3\CMS\Core\Cache\Frontend\VariableFrontend
683 */
684 protected $runtimeCache = NULL;
685
686 /**
687 * Prefix for the cache entries of nested element calls since the runtimeCache has a global scope.
688 *
689 * @var string
690 */
691 protected $cachePrefixNestedElementCalls = 'core-datahandler-nestedElementCalls-';
692
693 /**
694 *
695 */
696 public function __construct() {
697 $this->databaseConnection = $GLOBALS['TYPO3_DB'];
698 $this->runtimeCache = $this->getRuntimeCache();
699 }
700
701 /**
702 * @param array $control
703 */
704 public function setControl(array $control) {
705 $this->control = $control;
706 }
707
708 /**
709 * Initializing.
710 * For details, see 'TYPO3 Core API' document.
711 * This function does not start the processing of data, but merely initializes the object
712 *
713 * @param array $data Data to be modified or inserted in the database
714 * @param array $cmd Commands to copy, move, delete, localize, versionize records.
715 * @param BackendUserAuthentication|NULL $altUserObject An alternative userobject you can set instead of the default, which is $GLOBALS['BE_USER']
716 * @return void
717 */
718 public function start($data, $cmd, $altUserObject = NULL) {
719 // Initializing BE_USER
720 $this->BE_USER = is_object($altUserObject) ? $altUserObject : $GLOBALS['BE_USER'];
721 $this->userid = $this->BE_USER->user['uid'];
722 $this->username = $this->BE_USER->user['username'];
723 $this->admin = $this->BE_USER->user['admin'];
724 if ($this->BE_USER->uc['recursiveDelete']) {
725 $this->deleteTree = 1;
726 }
727 if ($GLOBALS['TYPO3_CONF_VARS']['BE']['explicitConfirmationOfTranslation'] && $this->updateModeL10NdiffData === TRUE) {
728 $this->updateModeL10NdiffData = FALSE;
729 }
730 // Initializing default permissions for pages
731 $defaultPermissions = $GLOBALS['TYPO3_CONF_VARS']['BE']['defaultPermissions'];
732 if (isset($defaultPermissions['user'])) {
733 $this->defaultPermissions['user'] = $defaultPermissions['user'];
734 }
735 if (isset($defaultPermissions['group'])) {
736 $this->defaultPermissions['group'] = $defaultPermissions['group'];
737 }
738 if (isset($defaultPermissions['everybody'])) {
739 $this->defaultPermissions['everybody'] = $defaultPermissions['everybody'];
740 }
741 // generates the excludelist, based on TCA/exclude-flag and non_exclude_fields for the user:
742 if (!$this->admin) {
743 $this->excludedTablesAndFields = array_flip($this->getExcludeListArray());
744 }
745 // Setting the data and cmd arrays
746 if (is_array($data)) {
747 reset($data);
748 $this->datamap = $data;
749 }
750 if (is_array($cmd)) {
751 reset($cmd);
752 $this->cmdmap = $cmd;
753 }
754 }
755
756 /**
757 * Function that can mirror input values in datamap-array to other uid numbers.
758 * Example: $mirror[table][11] = '22,33' will look for content in $this->datamap[table][11] and copy it to $this->datamap[table][22] and $this->datamap[table][33]
759 *
760 * @param array $mirror This array has the syntax $mirror[table_name][uid] = [list of uids to copy data-value TO!]
761 * @return void
762 */
763 public function setMirror($mirror) {
764 if (!is_array($mirror)) {
765 return;
766 }
767
768 foreach ($mirror as $table => $uid_array) {
769 if (!isset($this->datamap[$table])) {
770 continue;
771 }
772
773 foreach ($uid_array as $id => $uidList) {
774 if (!isset($this->datamap[$table][$id])) {
775 continue;
776 }
777
778 $theIdsInArray = GeneralUtility::trimExplode(',', $uidList, TRUE);
779 foreach ($theIdsInArray as $copyToUid) {
780 $this->datamap[$table][$copyToUid] = $this->datamap[$table][$id];
781 }
782 }
783 }
784 }
785
786 /**
787 * Initializes default values coming from User TSconfig
788 *
789 * @param array $userTS User TSconfig array
790 * @return void
791 */
792 public function setDefaultsFromUserTS($userTS) {
793 if (!is_array($userTS)) {
794 return;
795 }
796
797 foreach ($userTS as $k => $v) {
798 $k = substr($k, 0, -1);
799 if (!$k || !is_array($v) || !isset($GLOBALS['TCA'][$k])) {
800 continue;
801 }
802
803 if (is_array($this->defaultValues[$k])) {
804 $this->defaultValues[$k] = array_merge($this->defaultValues[$k], $v);
805 } else {
806 $this->defaultValues[$k] = $v;
807 }
808 }
809 }
810
811 /**
812 * Processing of uploaded files.
813 * It turns out that some versions of PHP arranges submitted data for files different if sent in an array. This function will unify this so the internal array $this->uploadedFileArray will always contain files arranged in the same structure.
814 *
815 * @param array $postFiles $_FILES array
816 * @return void
817 */
818 public function process_uploads($postFiles) {
819 if (!is_array($postFiles)) {
820 return;
821 }
822
823 // Editing frozen:
824 if ($this->BE_USER->workspace !== 0 && $this->BE_USER->workspaceRec['freeze']) {
825 if ($this->enableLogging) {
826 $this->newlog('All editing in this workspace has been frozen!', 1);
827 }
828 return;
829 }
830 $subA = reset($postFiles);
831 if (is_array($subA)) {
832 if (is_array($subA['name']) && is_array($subA['type']) && is_array($subA['tmp_name']) && is_array($subA['size'])) {
833 // Initialize the uploadedFilesArray:
834 $this->uploadedFileArray = array();
835 // For each entry:
836 foreach ($subA as $key => $values) {
837 $this->process_uploads_traverseArray($this->uploadedFileArray, $values, $key);
838 }
839 } else {
840 $this->uploadedFileArray = $subA;
841 }
842 }
843 }
844
845 /**
846 * Traverse the upload array if needed to rearrange values.
847 *
848 * @param array $outputArr $this->uploadedFileArray passed by reference
849 * @param array $inputArr Input array ($_FILES parts)
850 * @param string $keyToSet The current $_FILES array key to set on the outermost level.
851 * @return void
852 * @access private
853 * @see process_uploads()
854 */
855 public function process_uploads_traverseArray(&$outputArr, $inputArr, $keyToSet) {
856 if (is_array($inputArr)) {
857 foreach ($inputArr as $key => $value) {
858 $this->process_uploads_traverseArray($outputArr[$key], $inputArr[$key], $keyToSet);
859 }
860 } else {
861 $outputArr[$keyToSet] = $inputArr;
862 }
863 }
864
865 /*********************************************
866 *
867 * HOOKS
868 *
869 *********************************************/
870 /**
871 * Hook: processDatamap_afterDatabaseOperations
872 * (calls $hookObj->processDatamap_afterDatabaseOperations($status, $table, $id, $fieldArray, $this);)
873 *
874 * Note: When using the hook after INSERT operations, you will only get the temporary NEW... id passed to your hook as $id,
875 * but you can easily translate it to the real uid of the inserted record using the $this->substNEWwithIDs array.
876 *
877 * @param array $hookObjectsArr (reference) Array with hook objects
878 * @param string $status (reference) Status of the current operation, 'new' or 'update
879 * @param string $table (reference) The table currently processing data for
880 * @param string $id (reference) The record uid currently processing data for, [integer] or [string] (like 'NEW...')
881 * @param array $fieldArray (reference) The field array of a record
882 * @return void
883 */
884 public function hook_processDatamap_afterDatabaseOperations(&$hookObjectsArr, &$status, &$table, &$id, &$fieldArray) {
885 // Process hook directly:
886 if (!isset($this->remapStackRecords[$table][$id])) {
887 foreach ($hookObjectsArr as $hookObj) {
888 if (method_exists($hookObj, 'processDatamap_afterDatabaseOperations')) {
889 $hookObj->processDatamap_afterDatabaseOperations($status, $table, $id, $fieldArray, $this);
890 }
891 }
892 } else {
893 $this->remapStackRecords[$table][$id]['processDatamap_afterDatabaseOperations'] = array(
894 'status' => $status,
895 'fieldArray' => $fieldArray,
896 'hookObjectsArr' => $hookObjectsArr
897 );
898 }
899 }
900
901 /**
902 * Gets the 'checkModifyAccessList' hook objects.
903 * The first call initializes the accordant objects.
904 *
905 * @return array The 'checkModifyAccessList' hook objects (if any)
906 * @throws \UnexpectedValueException
907 */
908 protected function getCheckModifyAccessListHookObjects() {
909 if (!isset($this->checkModifyAccessListHookObjects)) {
910 $this->checkModifyAccessListHookObjects = array();
911 if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tcemain.php']['checkModifyAccessList'])) {
912 foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tcemain.php']['checkModifyAccessList'] as $classData) {
913 $hookObject = GeneralUtility::getUserObj($classData);
914 if (!$hookObject instanceof DataHandlerCheckModifyAccessListHookInterface) {
915 throw new \UnexpectedValueException('$hookObject must implement interface \\TYPO3\\CMS\\Core\\DataHandling\\DataHandlerCheckModifyAccessListHookInterface', 1251892472);
916 }
917 $this->checkModifyAccessListHookObjects[] = $hookObject;
918 }
919 }
920 }
921 return $this->checkModifyAccessListHookObjects;
922 }
923
924 /*********************************************
925 *
926 * PROCESSING DATA
927 *
928 *********************************************/
929 /**
930 * Processing the data-array
931 * Call this function to process the data-array set by start()
932 *
933 * @return void|FALSE
934 */
935 public function process_datamap() {
936 $this->controlActiveElements();
937
938 // Keep versionized(!) relations here locally:
939 $registerDBList = array();
940 $this->registerElementsToBeDeleted();
941 $this->datamap = $this->unsetElementsToBeDeleted($this->datamap);
942 // Editing frozen:
943 if ($this->BE_USER->workspace !== 0 && $this->BE_USER->workspaceRec['freeze']) {
944 if ($this->enableLogging) {
945 $this->newlog('All editing in this workspace has been frozen!', 1);
946 }
947 return FALSE;
948 }
949 // First prepare user defined objects (if any) for hooks which extend this function:
950 $hookObjectsArr = array();
951 if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tcemain.php']['processDatamapClass'])) {
952 foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tcemain.php']['processDatamapClass'] as $classRef) {
953 $hookObject = GeneralUtility::getUserObj($classRef);
954 if (method_exists($hookObject, 'processDatamap_beforeStart')) {
955 $hookObject->processDatamap_beforeStart($this);
956 }
957 $hookObjectsArr[] = $hookObject;
958 }
959 }
960 // Organize tables so that the pages-table is always processed first. This is required if you want to make sure that content pointing to a new page will be created.
961 $orderOfTables = array();
962 // Set pages first.
963 if (isset($this->datamap['pages'])) {
964 $orderOfTables[] = 'pages';
965 }
966 $orderOfTables = array_unique(array_merge($orderOfTables, array_keys($this->datamap)));
967 // Process the tables...
968 foreach ($orderOfTables as $table) {
969 // Check if
970 // - table is set in $GLOBALS['TCA'],
971 // - table is NOT readOnly
972 // - the table is set with content in the data-array (if not, there's nothing to process...)
973 // - permissions for tableaccess OK
974 $modifyAccessList = $this->checkModifyAccessList($table);
975 if ($this->enableLogging && !$modifyAccessList) {
976 $this->log($table, 0, 2, 0, 1, 'Attempt to modify table \'%s\' without permission', 1, array($table));
977 }
978 if (!isset($GLOBALS['TCA'][$table]) || $this->tableReadOnly($table) || !is_array($this->datamap[$table]) || !$modifyAccessList) {
979 continue;
980 }
981
982 if ($this->reverseOrder) {
983 $this->datamap[$table] = array_reverse($this->datamap[$table], 1);
984 }
985 // For each record from the table, do:
986 // $id is the record uid, may be a string if new records...
987 // $incomingFieldArray is the array of fields
988 foreach ($this->datamap[$table] as $id => $incomingFieldArray) {
989 if (!is_array($incomingFieldArray)) {
990 continue;
991 }
992 $theRealPid = NULL;
993
994 // Handle native date/time fields
995 $dateTimeFormats = $this->databaseConnection->getDateTimeFormats($table);
996 foreach ($GLOBALS['TCA'][$table]['columns'] as $column => $config) {
997 if (isset($incomingFieldArray[$column])) {
998 if (isset($config['config']['dbType']) && ($config['config']['dbType'] === 'date' || $config['config']['dbType'] === 'datetime')) {
999 $emptyValue = $dateTimeFormats[$config['config']['dbType']]['empty'];
1000 $format = $dateTimeFormats[$config['config']['dbType']]['format'];
1001 $incomingFieldArray[$column] = $incomingFieldArray[$column] ? gmdate($format, $incomingFieldArray[$column]) : $emptyValue;
1002 }
1003 }
1004 }
1005 // Hook: processDatamap_preProcessFieldArray
1006 foreach ($hookObjectsArr as $hookObj) {
1007 if (method_exists($hookObj, 'processDatamap_preProcessFieldArray')) {
1008 $hookObj->processDatamap_preProcessFieldArray($incomingFieldArray, $table, $id, $this);
1009 }
1010 }
1011 // ******************************
1012 // Checking access to the record
1013 // ******************************
1014 $createNewVersion = FALSE;
1015 $recordAccess = FALSE;
1016 $old_pid_value = '';
1017 $this->autoVersioningUpdate = FALSE;
1018 // Is it a new record? (Then Id is a string)
1019 if (!MathUtility::canBeInterpretedAsInteger($id)) {
1020 // Get a fieldArray with default values
1021 $fieldArray = $this->newFieldArray($table);
1022 // A pid must be set for new records.
1023 if (isset($incomingFieldArray['pid'])) {
1024 // $value = the pid
1025 $pid_value = $incomingFieldArray['pid'];
1026 // Checking and finding numerical pid, it may be a string-reference to another value
1027 $OK = 1;
1028 // If a NEW... id
1029 if (strstr($pid_value, 'NEW')) {
1030 if ($pid_value[0] === '-') {
1031 $negFlag = -1;
1032 $pid_value = substr($pid_value, 1);
1033 } else {
1034 $negFlag = 1;
1035 }
1036 // Trying to find the correct numerical value as it should be mapped by earlier processing of another new record.
1037 if (isset($this->substNEWwithIDs[$pid_value])) {
1038 if ($negFlag === 1) {
1039 $old_pid_value = $this->substNEWwithIDs[$pid_value];
1040 }
1041 $pid_value = (int)($negFlag * $this->substNEWwithIDs[$pid_value]);
1042 } else {
1043 $OK = 0;
1044 }
1045 }
1046 $pid_value = (int)$pid_value;
1047 // The $pid_value is now the numerical pid at this point
1048 if ($OK) {
1049 $sortRow = $GLOBALS['TCA'][$table]['ctrl']['sortby'];
1050 // Points to a page on which to insert the element, possibly in the top of the page
1051 if ($pid_value >= 0) {
1052 // If this table is sorted we better find the top sorting number
1053 if ($sortRow) {
1054 $fieldArray[$sortRow] = $this->getSortNumber($table, 0, $pid_value);
1055 }
1056 // The numerical pid is inserted in the data array
1057 $fieldArray['pid'] = $pid_value;
1058 } else {
1059 // points to another record before ifself
1060 // If this table is sorted we better find the top sorting number
1061 if ($sortRow) {
1062 // Because $pid_value is < 0, getSortNumber returns an array
1063 $tempArray = $this->getSortNumber($table, 0, $pid_value);
1064 $fieldArray['pid'] = $tempArray['pid'];
1065 $fieldArray[$sortRow] = $tempArray['sortNumber'];
1066 } else {
1067 // Here we fetch the PID of the record that we point to...
1068 $tempdata = $this->recordInfo($table, abs($pid_value), 'pid');
1069 $fieldArray['pid'] = $tempdata['pid'];
1070 }
1071 }
1072 }
1073 }
1074 $theRealPid = $fieldArray['pid'];
1075 // Now, check if we may insert records on this pid.
1076 if ($theRealPid >= 0) {
1077 // Checks if records can be inserted on this $pid.
1078 $recordAccess = $this->checkRecordInsertAccess($table, $theRealPid);
1079 if ($recordAccess) {
1080 $this->addDefaultPermittedLanguageIfNotSet($table, $incomingFieldArray);
1081 $recordAccess = $this->BE_USER->recordEditAccessInternals($table, $incomingFieldArray, TRUE);
1082 if (!$recordAccess) {
1083 if ($this->enableLogging) {
1084 $this->newlog('recordEditAccessInternals() check failed. [' . $this->BE_USER->errorMsg . ']', 1);
1085 }
1086 } elseif (!$this->bypassWorkspaceRestrictions) {
1087 // Workspace related processing:
1088 // If LIVE records cannot be created in the current PID due to workspace restrictions, prepare creation of placeholder-record
1089 if ($res = $this->BE_USER->workspaceAllowLiveRecordsInPID($theRealPid, $table)) {
1090 if ($res < 0) {
1091 $recordAccess = FALSE;
1092 if ($this->enableLogging) {
1093 $this->newlog('Stage for versioning root point and users access level did not allow for editing', 1);
1094 }
1095 }
1096 } else {
1097 // So, if no live records were allowed, we have to create a new version of this record:
1098 if ($GLOBALS['TCA'][$table]['ctrl']['versioningWS']) {
1099 $createNewVersion = TRUE;
1100 } else {
1101 $recordAccess = FALSE;
1102 if ($this->enableLogging) {
1103 $this->newlog('Record could not be created in this workspace in this branch', 1);
1104 }
1105 }
1106 }
1107 }
1108 }
1109 } else {
1110 debug('Internal ERROR: pid should not be less than zero!');
1111 }
1112 // Yes new record, change $record_status to 'insert'
1113 $status = 'new';
1114 } else {
1115 // Nope... $id is a number
1116 $fieldArray = array();
1117 $recordAccess = $this->checkRecordUpdateAccess($table, $id, $incomingFieldArray, $hookObjectsArr);
1118 if (!$recordAccess) {
1119 if ($this->enableLogging) {
1120 $propArr = $this->getRecordProperties($table, $id);
1121 $this->log($table, $id, 2, 0, 1, 'Attempt to modify record \'%s\' (%s) without permission. Or non-existing page.', 2, array($propArr['header'], $table . ':' . $id), $propArr['event_pid']);
1122 }
1123 continue;
1124 }
1125 // Next check of the record permissions (internals)
1126 $recordAccess = $this->BE_USER->recordEditAccessInternals($table, $id);
1127 if (!$recordAccess) {
1128 if ($this->enableLogging) {
1129 $this->newlog('recordEditAccessInternals() check failed. [' . $this->BE_USER->errorMsg . ']', 1);
1130 }
1131 } else {
1132 // Here we fetch the PID of the record that we point to...
1133 $tempdata = $this->recordInfo($table, $id, 'pid' . ($GLOBALS['TCA'][$table]['ctrl']['versioningWS'] ? ',t3ver_wsid,t3ver_stage' : ''));
1134 $theRealPid = $tempdata['pid'];
1135 // Use the new id of the versionized record we're trying to write to:
1136 // (This record is a child record of a parent and has already been versionized.)
1137 if ($this->autoVersionIdMap[$table][$id]) {
1138 // For the reason that creating a new version of this record, automatically
1139 // created related child records (e.g. "IRRE"), update the accordant field:
1140 $this->getVersionizedIncomingFieldArray($table, $id, $incomingFieldArray, $registerDBList);
1141 // Use the new id of the copied/versionized record:
1142 $id = $this->autoVersionIdMap[$table][$id];
1143 $recordAccess = TRUE;
1144 $this->autoVersioningUpdate = TRUE;
1145 } elseif (!$this->bypassWorkspaceRestrictions && ($errorCode = $this->BE_USER->workspaceCannotEditRecord($table, $tempdata))) {
1146 $recordAccess = FALSE;
1147 // Versioning is required and it must be offline version!
1148 // Check if there already is a workspace version
1149 $WSversion = BackendUtility::getWorkspaceVersionOfRecord($this->BE_USER->workspace, $table, $id, 'uid,t3ver_oid');
1150 if ($WSversion) {
1151 $id = $WSversion['uid'];
1152 $recordAccess = TRUE;
1153 } elseif ($this->BE_USER->workspaceAllowAutoCreation($table, $id, $theRealPid)) {
1154 // new version of a record created in a workspace - so always refresh pagetree to indicate there is a change in the workspace
1155 $this->pagetreeNeedsRefresh = TRUE;
1156
1157 /** @var $tce DataHandler */
1158 $tce = GeneralUtility::makeInstance(__CLASS__);
1159 $tce->stripslashes_values = FALSE;
1160 // Setting up command for creating a new version of the record:
1161 $cmd = array();
1162 $cmd[$table][$id]['version'] = array(
1163 'action' => 'new',
1164 'treeLevels' => -1,
1165 // Default is to create a version of the individual records... element versioning that is.
1166 'label' => 'Auto-created for WS #' . $this->BE_USER->workspace
1167 );
1168 $tce->start(array(), $cmd);
1169 $tce->process_cmdmap();
1170 $this->errorLog = array_merge($this->errorLog, $tce->errorLog);
1171 // If copying was successful, share the new uids (also of related children):
1172 if ($tce->copyMappingArray[$table][$id]) {
1173 foreach ($tce->copyMappingArray as $origTable => $origIdArray) {
1174 foreach ($origIdArray as $origId => $newId) {
1175 $this->uploadedFileArray[$origTable][$newId] = $this->uploadedFileArray[$origTable][$origId];
1176 $this->autoVersionIdMap[$origTable][$origId] = $newId;
1177 }
1178 }
1179 ArrayUtility::mergeRecursiveWithOverrule($this->RTEmagic_copyIndex, $tce->RTEmagic_copyIndex);
1180 // See where RTEmagic_copyIndex is used inside fillInFieldArray() for more information...
1181 // Update registerDBList, that holds the copied relations to child records:
1182 $registerDBList = array_merge($registerDBList, $tce->registerDBList);
1183 // For the reason that creating a new version of this record, automatically
1184 // created related child records (e.g. "IRRE"), update the accordant field:
1185 $this->getVersionizedIncomingFieldArray($table, $id, $incomingFieldArray, $registerDBList);
1186 // Use the new id of the copied/versionized record:
1187 $id = $this->autoVersionIdMap[$table][$id];
1188 $recordAccess = TRUE;
1189 $this->autoVersioningUpdate = TRUE;
1190 } elseif ($this->enableLogging) {
1191 $this->newlog('Could not be edited in offline workspace in the branch where found (failure state: \'' . $errorCode . '\'). Auto-creation of version failed!', 1);
1192 }
1193 } elseif ($this->enableLogging) {
1194 $this->newlog('Could not be edited in offline workspace in the branch where found (failure state: \'' . $errorCode . '\'). Auto-creation of version not allowed in workspace!', 1);
1195 }
1196 }
1197 }
1198 // The default is 'update'
1199 $status = 'update';
1200 }
1201 // If access was granted above, proceed to create or update record:
1202 if (!$recordAccess) {
1203 continue;
1204 }
1205
1206 // Here the "pid" is set IF NOT the old pid was a string pointing to a place in the subst-id array.
1207 list($tscPID) = BackendUtility::getTSCpid($table, $id, $old_pid_value ? $old_pid_value : $fieldArray['pid']);
1208 if ($status === 'new' && $table === 'pages') {
1209 $TSConfig = $this->getTCEMAIN_TSconfig($tscPID);
1210 if (isset($TSConfig['permissions.']) && is_array($TSConfig['permissions.'])) {
1211 $fieldArray = $this->setTSconfigPermissions($fieldArray, $TSConfig['permissions.']);
1212 }
1213 }
1214 // Processing of all fields in incomingFieldArray and setting them in $fieldArray
1215 $fieldArray = $this->fillInFieldArray($table, $id, $fieldArray, $incomingFieldArray, $theRealPid, $status, $tscPID);
1216 $newVersion_placeholderFieldArray = array();
1217 if ($createNewVersion) {
1218 // create a placeholder array with already processed field content
1219 $newVersion_placeholderFieldArray = $fieldArray;
1220 }
1221 // NOTICE! All manipulation beyond this point bypasses both "excludeFields" AND possible "MM" relations / file uploads to field!
1222 // Forcing some values unto field array:
1223 // NOTICE: This overriding is potentially dangerous; permissions per field is not checked!!!
1224 $fieldArray = $this->overrideFieldArray($table, $fieldArray);
1225 if ($createNewVersion) {
1226 $newVersion_placeholderFieldArray = $this->overrideFieldArray($table, $newVersion_placeholderFieldArray);
1227 }
1228 // Setting system fields
1229 if ($status == 'new') {
1230 if ($GLOBALS['TCA'][$table]['ctrl']['crdate']) {
1231 $fieldArray[$GLOBALS['TCA'][$table]['ctrl']['crdate']] = $GLOBALS['EXEC_TIME'];
1232 if ($createNewVersion) {
1233 $newVersion_placeholderFieldArray[$GLOBALS['TCA'][$table]['ctrl']['crdate']] = $GLOBALS['EXEC_TIME'];
1234 }
1235 }
1236 if ($GLOBALS['TCA'][$table]['ctrl']['cruser_id']) {
1237 $fieldArray[$GLOBALS['TCA'][$table]['ctrl']['cruser_id']] = $this->userid;
1238 if ($createNewVersion) {
1239 $newVersion_placeholderFieldArray[$GLOBALS['TCA'][$table]['ctrl']['cruser_id']] = $this->userid;
1240 }
1241 }
1242 } elseif ($this->checkSimilar) {
1243 // Removing fields which are equal to the current value:
1244 $fieldArray = $this->compareFieldArrayWithCurrentAndUnset($table, $id, $fieldArray);
1245 }
1246 if ($GLOBALS['TCA'][$table]['ctrl']['tstamp'] && !empty($fieldArray)) {
1247 $fieldArray[$GLOBALS['TCA'][$table]['ctrl']['tstamp']] = $GLOBALS['EXEC_TIME'];
1248 if ($createNewVersion) {
1249 $newVersion_placeholderFieldArray[$GLOBALS['TCA'][$table]['ctrl']['tstamp']] = $GLOBALS['EXEC_TIME'];
1250 }
1251 }
1252 // Set stage to "Editing" to make sure we restart the workflow
1253 if ($GLOBALS['TCA'][$table]['ctrl']['versioningWS']) {
1254 $fieldArray['t3ver_stage'] = 0;
1255 }
1256 // Hook: processDatamap_postProcessFieldArray
1257 foreach ($hookObjectsArr as $hookObj) {
1258 if (method_exists($hookObj, 'processDatamap_postProcessFieldArray')) {
1259 $hookObj->processDatamap_postProcessFieldArray($status, $table, $id, $fieldArray, $this);
1260 }
1261 }
1262 // Performing insert/update. If fieldArray has been unset by some userfunction (see hook above), don't do anything
1263 // Kasper: Unsetting the fieldArray is dangerous; MM relations might be saved already and files could have been uploaded that are now "lost"
1264 if (is_array($fieldArray)) {
1265 if ($status == 'new') {
1266 if ($table === 'pages') {
1267 // for new pages always a refresh is needed
1268 $this->pagetreeNeedsRefresh = TRUE;
1269 }
1270
1271 // This creates a new version of the record with online placeholder and offline version
1272 if ($createNewVersion) {
1273 // new record created in a workspace - so always refresh pagetree to indicate there is a change in the workspace
1274 $this->pagetreeNeedsRefresh = TRUE;
1275
1276 $newVersion_placeholderFieldArray['t3ver_label'] = 'INITIAL PLACEHOLDER';
1277 // Setting placeholder state value for temporary record
1278 $newVersion_placeholderFieldArray['t3ver_state'] = (string)new VersionState(VersionState::NEW_PLACEHOLDER);
1279 // Setting workspace - only so display of place holders can filter out those from other workspaces.
1280 $newVersion_placeholderFieldArray['t3ver_wsid'] = $this->BE_USER->workspace;
1281 $newVersion_placeholderFieldArray[$GLOBALS['TCA'][$table]['ctrl']['label']] = $this->getPlaceholderTitleForTableLabel($table);
1282 // Saving placeholder as 'original'
1283 $this->insertDB($table, $id, $newVersion_placeholderFieldArray, FALSE);
1284 // For the actual new offline version, set versioning values to point to placeholder:
1285 $fieldArray['pid'] = -1;
1286 $fieldArray['t3ver_oid'] = $this->substNEWwithIDs[$id];
1287 $fieldArray['t3ver_id'] = 1;
1288 // Setting placeholder state value for version (so it can know it is currently a new version...)
1289 $fieldArray['t3ver_state'] = (string)new VersionState(VersionState::NEW_PLACEHOLDER_VERSION);
1290 $fieldArray['t3ver_label'] = 'First draft version';
1291 $fieldArray['t3ver_wsid'] = $this->BE_USER->workspace;
1292 // When inserted, $this->substNEWwithIDs[$id] will be changed to the uid of THIS version and so the interface will pick it up just nice!
1293 $phShadowId = $this->insertDB($table, $id, $fieldArray, TRUE, 0, TRUE);
1294 if ($phShadowId) {
1295 // Processes fields of the placeholder record:
1296 $this->triggerRemapAction($table, $id, array($this, 'placeholderShadowing'), array($table, $phShadowId));
1297 // Hold auto-versionized ids of placeholders:
1298 $this->autoVersionIdMap[$table][$this->substNEWwithIDs[$id]] = $phShadowId;
1299 }
1300 } else {
1301 $this->insertDB($table, $id, $fieldArray, FALSE, $incomingFieldArray['uid']);
1302 }
1303 } else {
1304 if ($table === 'pages') {
1305 // only a certain number of fields needs to be checked for updates
1306 // if $this->checkSimilar is TRUE, fields with unchanged values are already removed here
1307 $fieldsToCheck = array_intersect($this->pagetreeRefreshFieldsFromPages, array_keys($fieldArray));
1308 if (!empty($fieldsToCheck)) {
1309 $this->pagetreeNeedsRefresh = TRUE;
1310 }
1311 }
1312 $this->updateDB($table, $id, $fieldArray);
1313 $this->placeholderShadowing($table, $id);
1314 }
1315 }
1316 // Hook: processDatamap_afterDatabaseOperations
1317 // Note: When using the hook after INSERT operations, you will only get the temporary NEW... id passed to your hook as $id,
1318 // but you can easily translate it to the real uid of the inserted record using the $this->substNEWwithIDs array.
1319 $this->hook_processDatamap_afterDatabaseOperations($hookObjectsArr, $status, $table, $id, $fieldArray);
1320 }
1321 }
1322 // Process the stack of relations to remap/correct
1323 $this->processRemapStack();
1324 $this->dbAnalysisStoreExec();
1325 $this->removeRegisteredFiles();
1326 // Hook: processDatamap_afterAllOperations
1327 // Note: When this hook gets called, all operations on the submitted data have been finished.
1328 foreach ($hookObjectsArr as $hookObj) {
1329 if (method_exists($hookObj, 'processDatamap_afterAllOperations')) {
1330 $hookObj->processDatamap_afterAllOperations($this);
1331 }
1332 }
1333 if ($this->isOuterMostInstance()) {
1334 $this->processClearCacheQueue();
1335 $this->resetElementsToBeDeleted();
1336 }
1337 }
1338
1339 /**
1340 * Fix shadowing of data in case we are editing an offline version of a live "New" placeholder record:
1341 *
1342 * @param string $table Table name
1343 * @param int $id Record uid
1344 * @return void
1345 */
1346 public function placeholderShadowing($table, $id) {
1347 if ($liveRec = BackendUtility::getLiveVersionOfRecord($table, $id, '*')) {
1348 if (VersionState::cast($liveRec['t3ver_state'])->indicatesPlaceholder()) {
1349 $justStoredRecord = BackendUtility::getRecord($table, $id);
1350 $newRecord = array();
1351 $shadowCols = $GLOBALS['TCA'][$table]['ctrl']['shadowColumnsForNewPlaceholders'];
1352 $shadowCols .= ',' . $GLOBALS['TCA'][$table]['ctrl']['languageField'];
1353 $shadowCols .= ',' . $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'];
1354 $shadowCols .= ',' . $GLOBALS['TCA'][$table]['ctrl']['type'];
1355 $shadowCols .= ',' . $GLOBALS['TCA'][$table]['ctrl']['label'];
1356 $shadowColumns = array_unique(GeneralUtility::trimExplode(',', $shadowCols, TRUE));
1357 foreach ($shadowColumns as $fieldName) {
1358 if ((string)$justStoredRecord[$fieldName] !== (string)$liveRec[$fieldName] && isset($GLOBALS['TCA'][$table]['columns'][$fieldName]) && $fieldName !== 'uid' && $fieldName !== 'pid') {
1359 $newRecord[$fieldName] = $justStoredRecord[$fieldName];
1360 }
1361 }
1362 if (!empty($newRecord)) {
1363 if ($this->enableLogging) {
1364 $this->newlog2('Shadowing done on fields <i>' . implode(',', array_keys($newRecord)) . '</i> in placeholder record ' . $table . ':' . $liveRec['uid'] . ' (offline version UID=' . $id . ')', $table, $liveRec['uid'], $liveRec['pid']);
1365 }
1366 $this->updateDB($table, $liveRec['uid'], $newRecord);
1367 }
1368 }
1369 }
1370 }
1371
1372 /**
1373 * Create a placeholder title for the label field that does match the field requirements
1374 *
1375 * @param string $table The table name
1376 * @return string placeholder value
1377 */
1378 protected function getPlaceholderTitleForTableLabel($table) {
1379 $labelPlaceholder = '[PLACEHOLDER, WS#' . $this->BE_USER->workspace . ']';
1380 $labelField = $GLOBALS['TCA'][$table]['ctrl']['label'];
1381 if (!isset($GLOBALS['TCA'][$table]['columns'][$labelField]['config']['eval'])) {
1382 return $labelPlaceholder;
1383 }
1384 $evalCodesArray = GeneralUtility::trimExplode(',', $GLOBALS['TCA'][$table]['columns'][$labelField]['config']['eval'], TRUE);
1385 $transformedLabel = $this->checkValue_input_Eval($labelPlaceholder, $evalCodesArray, '');
1386 return isset($transformedLabel['value']) ? $transformedLabel['value'] : $labelPlaceholder;
1387 }
1388
1389 /**
1390 * Filling in the field array
1391 * $this->excludedTablesAndFields is used to filter fields if needed.
1392 *
1393 * @param string $table Table name
1394 * @param int $id Record ID
1395 * @param array $fieldArray Default values, Preset $fieldArray with 'pid' maybe (pid and uid will be not be overridden anyway)
1396 * @param array $incomingFieldArray Is which fields/values you want to set. There are processed and put into $fieldArray if OK
1397 * @param int $realPid The real PID value of the record. For updates, this is just the pid of the record. For new records this is the PID of the page where it is inserted.
1398 * @param string $status Is 'new' or 'update'
1399 * @param int $tscPID TSconfig PID
1400 * @return array Field Array
1401 */
1402 public function fillInFieldArray($table, $id, $fieldArray, $incomingFieldArray, $realPid, $status, $tscPID) {
1403 // Initialize:
1404 $originalLanguageRecord = NULL;
1405 $originalLanguage_diffStorage = NULL;
1406 $diffStorageFlag = FALSE;
1407 // Setting 'currentRecord' and 'checkValueRecord':
1408 if (strstr($id, 'NEW')) {
1409 // Must have the 'current' array - not the values after processing below...
1410 $currentRecord = ($checkValueRecord = $fieldArray);
1411 // IF $incomingFieldArray is an array, overlay it.
1412 // The point is that when new records are created as copies with flex type fields there might be a field containing information about which DataStructure to use and without that information the flexforms cannot be correctly processed.... This should be OK since the $checkValueRecord is used by the flexform evaluation only anyways...
1413 if (is_array($incomingFieldArray) && is_array($checkValueRecord)) {
1414 ArrayUtility::mergeRecursiveWithOverrule($checkValueRecord, $incomingFieldArray);
1415 }
1416 } else {
1417 // We must use the current values as basis for this!
1418 $currentRecord = ($checkValueRecord = $this->recordInfo($table, $id, '*'));
1419 // This is done to make the pid positive for offline versions; Necessary to have diff-view for pages_language_overlay in workspaces.
1420 BackendUtility::fixVersioningPid($table, $currentRecord);
1421 // Get original language record if available:
1422 if (is_array($currentRecord) && $GLOBALS['TCA'][$table]['ctrl']['transOrigDiffSourceField'] && $GLOBALS['TCA'][$table]['ctrl']['languageField'] && $currentRecord[$GLOBALS['TCA'][$table]['ctrl']['languageField']] > 0 && $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField'] && (int)$currentRecord[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']] > 0) {
1423 $lookUpTable = $GLOBALS['TCA'][$table]['ctrl']['transOrigPointerTable'] ?: $table;
1424 $originalLanguageRecord = $this->recordInfo($lookUpTable, $currentRecord[$GLOBALS['TCA'][$table]['ctrl']['transOrigPointerField']], '*');
1425 BackendUtility::workspaceOL($lookUpTable, $originalLanguageRecord);
1426 $originalLanguage_diffStorage = unserialize($currentRecord[$GLOBALS['TCA'][$table]['ctrl']['transOrigDiffSourceField']]);
1427 }
1428 }
1429 $this->checkValue_currentRecord = $checkValueRecord;
1430 // In the following all incoming value-fields are tested:
1431 // - Are the user allowed to change the field?
1432 // - Is the field uid/pid (which are already set)
1433 // - perms-fields for pages-table, then do special things...
1434 // - If the field is nothing of the above and the field is configured in TCA, the fieldvalues are evaluated by ->checkValue
1435 // If everything is OK, the field is entered into $fieldArray[]
1436 foreach ($incomingFieldArray as $field => $fieldValue) {
1437 if (isset($this->excludedTablesAndFields[$table . '-' . $field]) || $this->data_disableFields[$table][$id][$field]) {
1438 continue;
1439 }
1440
1441 // The field must be editable.
1442 // Checking if a value for language can be changed:
1443 $languageDeny = $GLOBALS['TCA'][$table]['ctrl']['languageField'] && (string)$GLOBALS['TCA'][$table]['ctrl']['languageField'] === (string)$field && !$this->BE_USER->checkLanguageAccess($fieldValue);
1444 if ($languageDeny) {
1445 continue;
1446 }
1447
1448 // Stripping slashes - will probably be removed the day $this->stripslashes_values is removed as an option...
1449 // @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
1450 if ($this->stripslashes_values) {
1451 GeneralUtility::deprecationLog(
1452 'The option stripslash_values is typically set to FALSE as data should be properly prepared before sending to DataHandler. Do not rely on DataHandler removing extra slashes. The option will be removed in TYPO3 CMS 8.'
1453 );
1454 if (is_array($fieldValue)) {
1455 GeneralUtility::stripSlashesOnArray($fieldValue);
1456 } else {
1457 $fieldValue = stripslashes($fieldValue);
1458 }
1459 }
1460 switch ($field) {
1461 case 'uid':
1462 case 'pid':
1463 // Nothing happens, already set
1464 break;
1465 case 'perms_userid':
1466 case 'perms_groupid':
1467 case 'perms_user':
1468 case 'perms_group':
1469 case 'perms_everybody':
1470 // Permissions can be edited by the owner or the administrator
1471 if ($table == 'pages' && ($this->admin || $status == 'new' || $this->pageInfo($id, 'perms_userid') == $this->userid)) {
1472 $value = (int)$fieldValue;
1473 switch ($field) {
1474 case 'perms_userid':
1475 $fieldArray[$field] = $value;
1476 break;
1477 case 'perms_groupid':
1478 $fieldArray[$field] = $value;
1479 break;
1480 default:
1481 if ($value >= 0 && $value < pow(2, 5)) {
1482 $fieldArray[$field] = $value;
1483 }
1484 }
1485 }
1486 break;
1487 case 't3ver_oid':
1488 case 't3ver_id':
1489 case 't3ver_wsid':
1490 case 't3ver_state':
1491 case 't3ver_count':
1492 case 't3ver_stage':
1493 case 't3ver_tstamp':
1494 // t3ver_label is not here because it CAN be edited as a regular field!
1495 break;
1496 default:
1497 if (isset($GLOBALS['TCA'][$table]['columns'][$field])) {
1498 // Evaluating the value
1499 $res = $this->checkValue($table, $field, $fieldValue, $id, $status, $realPid, $tscPID);
1500 if (array_key_exists('value', $res)) {
1501 $fieldArray[$field] = $res['value'];
1502 }
1503 // Add the value of the original record to the diff-storage content:
1504 if ($this->updateModeL10NdiffData && $GLOBALS['TCA'][$table]['ctrl']['transOrigDiffSourceField']) {
1505 $originalLanguage_diffStorage[$field] = $this->updateModeL10NdiffDataClear ? '' : $originalLanguageRecord[$field];
1506 $diffStorageFlag = TRUE;
1507 }
1508 // If autoversioning is happening we need to perform a nasty hack. The case is parallel to a similar hack inside checkValue_group_select_file().
1509 // When a copy or version is made of a record, a search is made for any RTEmagic* images in fields having the "images" soft reference parser applied.
1510 // That should be TRUE for RTE fields. If any are found they are duplicated to new names and the file reference in the bodytext is updated accordingly.
1511 // However, with auto-versioning the submitted content of the field will just overwrite the corrected values. This leaves a) lost RTEmagic files and b) creates a double reference to the old files.
1512 // The only solution I can come up with is detecting when auto versioning happens, then see if any RTEmagic images was copied and if so make a stupid string-replace of the content !
1513 if ($this->autoVersioningUpdate === TRUE) {
1514 if (is_array($this->RTEmagic_copyIndex[$table][$id][$field])) {
1515 foreach ($this->RTEmagic_copyIndex[$table][$id][$field] as $oldRTEmagicName => $newRTEmagicName) {
1516 $fieldArray[$field] = str_replace(' src="' . $oldRTEmagicName . '"', ' src="' . $newRTEmagicName . '"', $fieldArray[$field]);
1517 }
1518 }
1519 }
1520 } elseif ($GLOBALS['TCA'][$table]['ctrl']['origUid'] === $field) {
1521 // Allow value for original UID to pass by...
1522 $fieldArray[$field] = $fieldValue;
1523 }
1524 }
1525 }
1526 // Add diff-storage information:
1527 if ($diffStorageFlag && !isset($fieldArray[$GLOBALS['TCA'][$table]['ctrl']['transOrigDiffSourceField']])) {
1528 // If the field is set it would probably be because of an undo-operation - in which case we should not update the field of course...
1529 $fieldArray[$GLOBALS['TCA'][$table]['ctrl']['transOrigDiffSourceField']] = serialize($originalLanguage_diffStorage);
1530 }
1531 // Checking for RTE-transformations of fields:
1532 $types_fieldConfig = BackendUtility::getTCAtypes($table, $currentRecord);
1533 $theTypeString = NULL;
1534 if (is_array($types_fieldConfig)) {
1535 foreach ($types_fieldConfig as $vconf) {
1536 // RTE transformations:
1537 if ($this->dontProcessTransformations || !isset($fieldArray[$vconf['field']])) {
1538 continue;
1539 }
1540
1541 // Look for transformation flag:
1542 if ((string)$incomingFieldArray[('_TRANSFORM_' . $vconf['field'])] === 'RTE') {
1543 if ($theTypeString === NULL) {
1544 $theTypeString = BackendUtility::getTCAtypeValue($table, $currentRecord);
1545 }
1546 $RTEsetup = $this->BE_USER->getTSConfig('RTE', BackendUtility::getPagesTSconfig($tscPID));
1547 $thisConfig = BackendUtility::RTEsetup($RTEsetup['properties'], $table, $vconf['field'], $theTypeString);
1548 $fieldArray[$vconf['field']] = $this->transformRichtextContentToDatabase(
1549 $fieldArray[$vconf['field']], $table, $vconf['field'], $vconf['spec'], $thisConfig, $currentRecord['pid']
1550 );
1551 }
1552 }
1553 }
1554 // Return fieldArray
1555 return $fieldArray;
1556 }
1557
1558 /**
1559 * Performs transformation of content from richtext element to database.
1560 *
1561 * @param string $value Value to transform.
1562 * @param string $table The table name
1563 * @param string $field The field name
1564 * @param array $defaultExtras Default extras configuration of this field - typically "richtext:rte_transform[mode=ts_css]"
1565 * @param array $thisConfig Configuration for RTEs; A mix between TSconfig and others. Configuration for additional transformation information
1566 * @param int $pid PID value of record (true parent page id)
1567 * @return string Transformed content
1568 */
1569 protected function transformRichtextContentToDatabase($value, $table, $field, $defaultExtras, $thisConfig, $pid) {
1570 if ($defaultExtras['rte_transform']) {
1571 $parameters = BackendUtility::getSpecConfParametersFromArray($defaultExtras['rte_transform']['parameters']);
1572 // There must be a mode set for transformation, this is typically 'ts_css'
1573 if ($parameters['mode']) {
1574 // Initialize transformation:
1575 $parseHTML = GeneralUtility::makeInstance(RteHtmlParser::class);
1576 $parseHTML->init($table . ':' . $field, $pid);
1577 $parseHTML->setRelPath('');
1578 // Perform transformation:
1579 $value = $parseHTML->RTE_transform($value, $defaultExtras, 'db', $thisConfig);
1580 }
1581 }
1582 return $value;
1583 }
1584
1585
1586 /*********************************************
1587 *
1588 * Evaluation of input values
1589 *
1590 ********************************************/
1591 /**
1592 * Evaluates a value according to $table/$field settings.
1593 * This function is for real database fields - NOT FlexForm "pseudo" fields.
1594 * NOTICE: Calling this function expects this: 1) That the data is saved! (files are copied and so on) 2) That files registered for deletion IS deleted at the end (with ->removeRegisteredFiles() )
1595 *
1596 * @param string $table Table name
1597 * @param string $field Field name
1598 * @param string $value Value to be evaluated. Notice, this is the INPUT value from the form. The original value (from any existing record) must be manually looked up inside the function if needed - or taken from $currentRecord array.
1599 * @param string $id The record-uid, mainly - but not exclusively - used for logging
1600 * @param string $status 'update' or 'new' flag
1601 * @param int $realPid The real PID value of the record. For updates, this is just the pid of the record. For new records this is the PID of the page where it is inserted. If $realPid is -1 it means that a new version of the record is being inserted.
1602 * @param int $tscPID TSconfig PID
1603 * @return array Returns the evaluated $value as key "value" in this array. Can be checked with isset($res['value']) ...
1604 */
1605 public function checkValue($table, $field, $value, $id, $status, $realPid, $tscPID) {
1606 // Result array
1607 $res = array();
1608
1609 // Processing special case of field pages.doktype
1610 if (($table === 'pages' || $table === 'pages_language_overlay') && $field === 'doktype') {
1611 // If the user may not use this specific doktype, we issue a warning
1612 if (!($this->admin || GeneralUtility::inList($this->BE_USER->groupData['pagetypes_select'], $value))) {
1613 if ($this->enableLogging) {
1614 $propArr = $this->getRecordProperties($table, $id);
1615 $this->log($table, $id, 5, 0, 1, 'You cannot change the \'doktype\' of page \'%s\' to the desired value.', 1, array($propArr['header']), $propArr['event_pid']);
1616 }
1617 return $res;
1618 }
1619 if ($status == 'update') {
1620 // This checks 1) if we should check for disallowed tables and 2) if there are records from disallowed tables on the current page
1621 $onlyAllowedTables = isset($GLOBALS['PAGES_TYPES'][$value]['onlyAllowedTables']) ? $GLOBALS['PAGES_TYPES'][$value]['onlyAllowedTables'] : $GLOBALS['PAGES_TYPES']['default']['onlyAllowedTables'];
1622 if ($onlyAllowedTables) {
1623 $theWrongTables = $this->doesPageHaveUnallowedTables($id, $value);
1624 if ($theWrongTables) {
1625 if ($this->enableLogging) {
1626 $propArr = $this->getRecordProperties($table, $id);
1627 $this->log($table, $id, 5, 0, 1, '\'doktype\' of page \'%s\' could not be changed because the page contains records from disallowed tables; %s', 2, array($propArr['header'], $theWrongTables), $propArr['event_pid']);
1628 }
1629 return $res;
1630 }
1631 }
1632 }
1633 }
1634
1635 $curValue = NULL;
1636 if ((int)$id !== 0) {
1637 // Get current value:
1638 $curValueRec = $this->recordInfo($table, $id, $field);
1639 // isset() won't work here, since values can be NULL
1640 if ($curValueRec !== NULL && array_key_exists($field, $curValueRec)) {
1641 $curValue = $curValueRec[$field];
1642 }
1643 }
1644
1645 // Getting config for the field
1646 $tcaFieldConf = $GLOBALS['TCA'][$table]['columns'][$field]['config'];
1647
1648 // Create $recFID only for those types that need it
1649 if (
1650 $tcaFieldConf['type'] === 'flex'
1651 || $tcaFieldConf['type'] === 'group' && ($tcaFieldConf['internal_type'] === 'file' || $tcaFieldConf['internal_type'] === 'file_reference')
1652 ) {
1653 $recFID = $table . ':' . $id . ':' . $field;
1654 } else {
1655 $recFID = NULL;
1656 }
1657
1658 // Perform processing:
1659 $res = $this->checkValue_SW($res, $value, $tcaFieldConf, $table, $id, $curValue, $status, $realPid, $recFID, $field, $this->uploadedFileArray[$table][$id][$field], $tscPID);
1660 return $res;
1661 }
1662
1663 /**
1664 * Branches out evaluation of a field value based on its type as configured in $GLOBALS['TCA']
1665 * Can be called for FlexForm pseudo fields as well, BUT must not have $field set if so.
1666 *
1667 * @param array $res The result array. The processed value (if any!) is set in the "value" key.
1668 * @param string $value The value to set.
1669 * @param array $tcaFieldConf Field configuration from $GLOBALS['TCA']
1670 * @param string $table Table name
1671 * @param int $id UID of record
1672 * @param mixed $curValue Current value of the field
1673 * @param string $status 'update' or 'new' flag
1674 * @param int $realPid The real PID value of the record. For updates, this is just the pid of the record. For new records this is the PID of the page where it is inserted. If $realPid is -1 it means that a new version of the record is being inserted.
1675 * @param string $recFID Field identifier [table:uid:field] for flexforms
1676 * @param string $field Field name. Must NOT be set if the call is for a flexform field (since flexforms are not allowed within flexforms).
1677 * @param array $uploadedFiles
1678 * @param int $tscPID TSconfig PID
1679 * @param array $additionalData Additional data to be forwarded to sub-processors
1680 * @return array Returns the evaluated $value as key "value" in this array.
1681 */
1682 public function checkValue_SW($res, $value, $tcaFieldConf, $table, $id, $curValue, $status, $realPid, $recFID, $field, $uploadedFiles, $tscPID, array $additionalData = NULL) {
1683 // Convert to NULL value if defined in TCA
1684 if ($value === NULL && !empty($tcaFieldConf['eval']) && GeneralUtility::inList($tcaFieldConf['eval'], 'null')) {
1685 $res = array('value' => NULL);
1686 return $res;
1687 }
1688
1689 switch ($tcaFieldConf['type']) {
1690 case 'text':
1691 $res = $this->checkValueForText($value, $tcaFieldConf);
1692 break;
1693 case 'passthrough':
1694 case 'imageManipulation':
1695 case 'user':
1696 $res['value'] = $value;
1697 break;
1698 case 'input':
1699 $res = $this->checkValueForInput($value, $tcaFieldConf, $table, $id, $realPid, $field);
1700 break;
1701 case 'check':
1702 $res = $this->checkValueForCheck($res, $value, $tcaFieldConf, $table, $id, $realPid, $field);
1703 break;
1704 case 'radio':
1705 $res = $this->checkValueForRadio($res, $value, $tcaFieldConf, $table, $id, $realPid, $field);
1706 break;
1707 case 'group':
1708 case 'select':
1709 $res = $this->checkValueForGroupSelect($res, $value, $tcaFieldConf, $table, $id, $curValue, $status, $recFID, $uploadedFiles, $field);
1710 break;
1711 case 'inline':
1712 $res = $this->checkValueForInline($res, $value, $tcaFieldConf, $table, $id, $status, $field, $additionalData);
1713 break;
1714 case 'flex':
1715 // FlexForms are only allowed for real fields.
1716 if ($field) {
1717 $res = $this->checkValueForFlex($res, $value, $tcaFieldConf, $table, $id, $curValue, $status, $realPid, $recFID, $tscPID, $uploadedFiles, $field);
1718 }
1719 break;
1720 default:
1721 // Do nothing
1722 }
1723 return $res;
1724 }
1725
1726 /**
1727 * Evaluate "text" type values.
1728 *
1729 * @param array $res The result array. The processed value (if any!) is set in the "value" key.
1730 * @param string $value The value to set.
1731 * @param array $tcaFieldConf Field configuration from TCA
1732 * @param array $PP Additional parameters in a numeric array: $table,$id,$curValue,$status,$realPid,$recFID
1733 * @param string $field Field name
1734 * @return array Modified $res array
1735 * @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
1736 */
1737 public function checkValue_text($res, $value, $tcaFieldConf, $PP, $field = '') {
1738 GeneralUtility::logDeprecatedFunction();
1739 return $this->checkValueForText($value, $tcaFieldConf);
1740 }
1741
1742 /**
1743 * Evaluate "text" type values.
1744 *
1745 * @param string $value The value to set.
1746 * @param array $tcaFieldConf Field configuration from TCA
1747 * @return array $res The result array. The processed value (if any!) is set in the "value" key.
1748 */
1749 protected function checkValueForText($value, $tcaFieldConf) {
1750 if (!isset($tcaFieldConf['eval']) || $tcaFieldConf['eval'] === '') {
1751 return array('value' => $value);
1752 }
1753 $cacheId = $this->getFieldEvalCacheIdentifier($tcaFieldConf['eval']);
1754 if ($this->runtimeCache->has($cacheId)) {
1755 $evalCodesArray = $this->runtimeCache->get($cacheId);
1756 } else {
1757 $evalCodesArray = GeneralUtility::trimExplode(',', $tcaFieldConf['eval'], TRUE);
1758 $this->runtimeCache->set($cacheId, $evalCodesArray);
1759 }
1760 return $this->checkValue_text_Eval($value, $evalCodesArray, $tcaFieldConf['is_in']);
1761 }
1762
1763 /**
1764 * Evaluate "input" type values.
1765 *
1766 * @param array $res The result array. The processed value (if any!) is set in the "value" key.
1767 * @param string $value The value to set.
1768 * @param array $tcaFieldConf Field configuration from TCA
1769 * @param array $PP Additional parameters in a numeric array: $table,$id,$curValue,$status,$realPid,$recFID
1770 * @param string $field Field name
1771 * @return array Modified $res array
1772 * @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
1773 */
1774 public function checkValue_input($res, $value, $tcaFieldConf, $PP, $field = '') {
1775 GeneralUtility::logDeprecatedFunction();
1776 list($table, $id, , , $realPid) = $PP;
1777 return $this->checkValueForInput($value, $tcaFieldConf, $table, $id, $realPid, $field);
1778 }
1779
1780 /**
1781 * Evaluate "input" type values.
1782 *
1783 * @param string $value The value to set.
1784 * @param array $tcaFieldConf Field configuration from TCA
1785 * @param string $table Table name
1786 * @param int $id UID of record
1787 * @param int $realPid The real PID value of the record. For updates, this is just the pid of the record. For new records this is the PID of the page where it is inserted. If $realPid is -1 it means that a new version of the record is being inserted.
1788 * @param string $field Field name
1789 * @return array $res The result array. The processed value (if any!) is set in the "value" key.
1790 */
1791 protected function checkValueForInput($value, $tcaFieldConf, $table, $id, $realPid, $field) {
1792 // Handle native date/time fields
1793 $isDateOrDateTimeField = FALSE;
1794 $format = '';
1795 $emptyValue = '';
1796 if (isset($tcaFieldConf['dbType']) && ($tcaFieldConf['dbType'] === 'date' || $tcaFieldConf['dbType'] === 'datetime')) {
1797 $isDateOrDateTimeField = TRUE;
1798 $dateTimeFormats = $this->databaseConnection->getDateTimeFormats($table);
1799 // Convert the date/time into a timestamp for the sake of the checks
1800 $emptyValue = $dateTimeFormats[$tcaFieldConf['dbType']]['empty'];
1801 $format = $dateTimeFormats[$tcaFieldConf['dbType']]['format'];
1802 // At this point in the processing, the timestamps are still based on UTC
1803 $timeZone = new \DateTimeZone('UTC');
1804 $dateTime = \DateTime::createFromFormat('!' . $format, $value, $timeZone);
1805 $value = $value === $emptyValue ? 0 : $dateTime->getTimestamp();
1806 }
1807 // Secures the string-length to be less than max.
1808 if ((int)$tcaFieldConf['max'] > 0) {
1809 $value = $GLOBALS['LANG']->csConvObj->substr($GLOBALS['LANG']->charSet, (string)$value, 0, (int)$tcaFieldConf['max']);
1810 }
1811 // Checking range of value:
1812 if ($tcaFieldConf['range'] && $value != $tcaFieldConf['checkbox'] && (int)$value !== (int)$tcaFieldConf['default']) {
1813 if (isset($tcaFieldConf['range']['upper']) && (int)$value > (int)$tcaFieldConf['range']['upper']) {
1814 $value = $tcaFieldConf['range']['upper'];
1815 }
1816 if (isset($tcaFieldConf['range']['lower']) && (int)$value < (int)$tcaFieldConf['range']['lower']) {
1817 $value = $tcaFieldConf['range']['lower'];
1818 }
1819 }
1820
1821 if (empty($tcaFieldConf['eval'])) {
1822 $res = array('value' => $value);
1823 } else {
1824 // Process evaluation settings:
1825 $cacheId = $this->getFieldEvalCacheIdentifier($tcaFieldConf['eval']);
1826 if ($this->runtimeCache->has($cacheId)) {
1827 $evalCodesArray = $this->runtimeCache->get($cacheId);
1828 } else {
1829 $evalCodesArray = GeneralUtility::trimExplode(',', $tcaFieldConf['eval'], TRUE);
1830 $this->runtimeCache->set($cacheId, $evalCodesArray);
1831 }
1832
1833 $res = $this->checkValue_input_Eval($value, $evalCodesArray, $tcaFieldConf['is_in']);
1834
1835 // Process UNIQUE settings:
1836 // Field is NOT set for flexForms - which also means that uniqueInPid and unique is NOT available for flexForm fields! Also getUnique should not be done for versioning and if PID is -1 ($realPid<0) then versioning is happening...
1837 if ($field && $realPid >= 0 && !empty($res['value'])) {
1838 if (in_array('uniqueInPid', $evalCodesArray, TRUE)) {
1839 $res['value'] = $this->getUnique($table, $field, $res['value'], $id, $realPid);
1840 }
1841 if ($res['value'] && in_array('unique', $evalCodesArray, TRUE)) {
1842 $res['value'] = $this->getUnique($table, $field, $res['value'], $id);
1843 }
1844 }
1845 }
1846
1847 // Handle native date/time fields
1848 if ($isDateOrDateTimeField) {
1849 // Convert the timestamp back to a date/time
1850 $res['value'] = $res['value'] ? date($format, $res['value']) : $emptyValue;
1851 }
1852 return $res;
1853 }
1854
1855 /**
1856 * Evaluates 'check' type values.
1857 *
1858 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
1859 * @param string $value The value to set.
1860 * @param array $tcaFieldConf Field configuration from TCA
1861 * @param array $PP Additional parameters in a numeric array: $table,$id,$curValue,$status,$realPid,$recFID
1862 * @param string $field Field name
1863 * @return array Modified $res array
1864 * @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
1865 */
1866 public function checkValue_check($res, $value, $tcaFieldConf, $PP, $field = '') {
1867 GeneralUtility::logDeprecatedFunction();
1868 list($table, $id, , , $realPid) = $PP;
1869 return $this->checkValueForCheck($res, $value, $tcaFieldConf, $table, $id, $realPid, $field);
1870 }
1871
1872 /**
1873 * Evaluates 'check' type values.
1874 *
1875 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
1876 * @param string $value The value to set.
1877 * @param array $tcaFieldConf Field configuration from TCA
1878 * @param string $table Table name
1879 * @param int $id UID of record
1880 * @param int $realPid The real PID value of the record. For updates, this is just the pid of the record. For new records this is the PID of the page where it is inserted. If $realPid is -1 it means that a new version of the record is being inserted.
1881 * @param string $field Field name
1882 * @return array Modified $res array
1883 */
1884 protected function checkValueForCheck($res, $value, $tcaFieldConf, $table, $id, $realPid, $field) {
1885 $itemC = count($tcaFieldConf['items']);
1886 if (!$itemC) {
1887 $itemC = 1;
1888 }
1889 $maxV = pow(2, $itemC) - 1;
1890 if ($value < 0) {
1891 $value = 0;
1892 }
1893 if ($value > $maxV) {
1894 $value = $maxV;
1895 }
1896 if ($field && $realPid >= 0 && $value > 0 && !empty($tcaFieldConf['eval'])) {
1897 $evalCodesArray = GeneralUtility::trimExplode(',', $tcaFieldConf['eval'], TRUE);
1898 $otherRecordsWithSameValue = array();
1899 $maxCheckedRecords = 0;
1900 if (in_array('maximumRecordsCheckedInPid', $evalCodesArray, TRUE)) {
1901 $otherRecordsWithSameValue = $this->getRecordsWithSameValue($table, $id, $field, $value, $realPid);
1902 $maxCheckedRecords = (int)$tcaFieldConf['validation']['maximumRecordsCheckedInPid'];
1903 }
1904 if (in_array('maximumRecordsChecked', $evalCodesArray, TRUE)) {
1905 $otherRecordsWithSameValue = $this->getRecordsWithSameValue($table, $id, $field, $value);
1906 $maxCheckedRecords = (int)$tcaFieldConf['validation']['maximumRecordsChecked'];
1907 }
1908
1909 // there are more than enough records with value "1" in the DB
1910 // if so, set this value to "0" again
1911 if ($maxCheckedRecords && count($otherRecordsWithSameValue) >= $maxCheckedRecords) {
1912 $value = 0;
1913 if ($this->enableLogging) {
1914 $this->log($table, $id, 5, 0, 1, 'Could not activate checkbox for field "%s". A total of %s record(s) can have this checkbox activated. Uncheck other records first in order to activate the checkbox of this record.', -1, array($GLOBALS['LANG']->sL(BackendUtility::getItemLabel($table, $field)), $maxCheckedRecords));
1915 }
1916 }
1917 }
1918 $res['value'] = $value;
1919 return $res;
1920 }
1921
1922 /**
1923 * Evaluates 'radio' type values.
1924 *
1925 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
1926 * @param string $value The value to set.
1927 * @param array $tcaFieldConf Field configuration from TCA
1928 * @param array $PP Additional parameters in a numeric array: $table,$id,$curValue,$status,$realPid,$recFID
1929 * @return array Modified $res array
1930 * @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
1931 */
1932 public function checkValue_radio($res, $value, $tcaFieldConf, $PP) {
1933 GeneralUtility::logDeprecatedFunction();
1934 // TODO find a way to get the field name; it should not be set in $recFID as this is only created for some record types, see checkValue()
1935 return $this->checkValueForRadio($res, $value, $tcaFieldConf, $PP[0], $PP[1], $PP[4], '');
1936 }
1937
1938 /**
1939 * Evaluates 'radio' type values.
1940 *
1941 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
1942 * @param string $value The value to set.
1943 * @param array $tcaFieldConf Field configuration from TCA
1944 * @param array $table The table of the record
1945 * @param int $id The id of the record
1946 * @param int $pid The pid of the record
1947 * @param string $field The field to check
1948 * @return array Modified $res array
1949 */
1950 protected function checkValueForRadio($res, $value, $tcaFieldConf, $table, $id, $pid, $field) {
1951 if (is_array($tcaFieldConf['items'])) {
1952 foreach ($tcaFieldConf['items'] as $set) {
1953 if ((string)$set[1] === (string)$value) {
1954 $res['value'] = $value;
1955 break;
1956 }
1957 }
1958 }
1959
1960 // if no value was found and an itemsProcFunc is defined, check that for the value
1961 if ($tcaFieldConf['itemsProcFunc'] && empty($res['value'])) {
1962 $processingService = GeneralUtility::makeInstance(ItemProcessingService::class);
1963 $processedItems = $processingService->getProcessingItems($table, $pid, $field, $this->checkValue_currentRecord,
1964 $tcaFieldConf, $tcaFieldConf['items']);
1965
1966 foreach ($processedItems as $set) {
1967 if ((string)$set[1] === (string)$value) {
1968 $res['value'] = $value;
1969 break;
1970 }
1971 }
1972 }
1973
1974 return $res;
1975 }
1976
1977 /**
1978 * Evaluates 'group' or 'select' type values.
1979 *
1980 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
1981 * @param string $value The value to set.
1982 * @param array $tcaFieldConf Field configuration from TCA
1983 * @param array $PP Additional parameters in a numeric array: $table,$id,$curValue,$status,$realPid,$recFID
1984 * @param array $uploadedFiles
1985 * @param string $field Field name
1986 * @return array Modified $res array
1987 * @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
1988 */
1989 public function checkValue_group_select($res, $value, $tcaFieldConf, $PP, $uploadedFiles, $field) {
1990 GeneralUtility::logDeprecatedFunction();
1991 list($table, $id, $curValue, $status, , $recFID) = $PP;
1992 return $this->checkValueForGroupSelect($res, $value, $tcaFieldConf, $table, $id, $curValue, $status, $recFID, $uploadedFiles, $field);
1993 }
1994
1995 /**
1996 * Evaluates 'group' or 'select' type values.
1997 *
1998 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
1999 * @param string $value The value to set.
2000 * @param array $tcaFieldConf Field configuration from TCA
2001 * @param string $table Table name
2002 * @param int $id UID of record
2003 * @param mixed $curValue Current value of the field
2004 * @param string $status 'update' or 'new' flag
2005 * @param string $recFID Field identifier [table:uid:field] for flexforms
2006 * @param array $uploadedFiles
2007 * @param string $field Field name
2008 * @return array Modified $res array
2009 */
2010 protected function checkValueForGroupSelect($res, $value, $tcaFieldConf, $table, $id, $curValue, $status, $recFID, $uploadedFiles, $field) {
2011 // Detecting if value sent is an array and if so, implode it around a comma:
2012 if (is_array($value)) {
2013 $value = implode(',', $value);
2014 }
2015 // This converts all occurrences of '&#123;' to the byte 123 in the string - this is needed in very rare cases where file names with special characters (e.g. ???, umlaut) gets sent to the server as HTML entities instead of bytes. The error is done only by MSIE, not Mozilla and Opera.
2016 // Anyway, this should NOT disturb anything else:
2017 $value = $this->convNumEntityToByteValue($value);
2018 // When values are sent as group or select they come as comma-separated values which are exploded by this function:
2019 $valueArray = $this->checkValue_group_select_explodeSelectGroupValue($value);
2020 // If multiple is not set, remove duplicates:
2021 if (!$tcaFieldConf['multiple']) {
2022 $valueArray = array_unique($valueArray);
2023 }
2024 // If an exclusive key is found, discard all others:
2025 if ($tcaFieldConf['type'] == 'select' && $tcaFieldConf['exclusiveKeys']) {
2026 $exclusiveKeys = GeneralUtility::trimExplode(',', $tcaFieldConf['exclusiveKeys']);
2027 foreach ($valueArray as $index => $key) {
2028 if (in_array($key, $exclusiveKeys, TRUE)) {
2029 $valueArray = array($index => $key);
2030 break;
2031 }
2032 }
2033 }
2034 // This could be a good spot for parsing the array through a validation-function which checks if the values are correct (except that database references are not in their final form - but that is the point, isn't it?)
2035 // NOTE!!! Must check max-items of files before the later check because that check would just leave out file names if there are too many!!
2036 $valueArray = $this->applyFiltersToValues($tcaFieldConf, $valueArray);
2037 // Checking for select / authMode, removing elements from $valueArray if any of them is not allowed!
2038 if ($tcaFieldConf['type'] == 'select' && $tcaFieldConf['authMode']) {
2039 $preCount = count($valueArray);
2040 foreach ($valueArray as $index => $key) {
2041 if (!$this->BE_USER->checkAuthMode($table, $field, $key, $tcaFieldConf['authMode'])) {
2042 unset($valueArray[$index]);
2043 }
2044 }
2045 // During the check it turns out that the value / all values were removed - we respond by simply returning an empty array so nothing is written to DB for this field.
2046 if ($preCount && empty($valueArray)) {
2047 return array();
2048 }
2049 }
2050 // For group types:
2051 if ($tcaFieldConf['type'] == 'group') {
2052 switch ($tcaFieldConf['internal_type']) {
2053 case 'file_reference':
2054
2055 case 'file':
2056 $valueArray = $this->checkValue_group_select_file($valueArray, $tcaFieldConf, $curValue, $uploadedFiles, $status, $table, $id, $recFID);
2057 break;
2058 case 'db':
2059 $valueArray = $this->checkValue_group_select_processDBdata($valueArray, $tcaFieldConf, $id, $status, 'group', $table, $field);
2060 break;
2061 }
2062 }
2063 // For select types which has a foreign table attached:
2064 $unsetResult = FALSE;
2065 if ($tcaFieldConf['type'] == 'select' && $tcaFieldConf['foreign_table']) {
2066 // check, if there is a NEW... id in the value, that should be substituted later
2067 if (strpos($value, 'NEW') !== FALSE) {
2068 $this->remapStackRecords[$table][$id] = array('remapStackIndex' => count($this->remapStack));
2069 $this->addNewValuesToRemapStackChildIds($valueArray);
2070 $this->remapStack[] = array(
2071 'func' => 'checkValue_group_select_processDBdata',
2072 'args' => array($valueArray, $tcaFieldConf, $id, $status, 'select', $table, $field),
2073 'pos' => array('valueArray' => 0, 'tcaFieldConf' => 1, 'id' => 2, 'table' => 5),
2074 'field' => $field
2075 );
2076 $unsetResult = TRUE;
2077 } else {
2078 $valueArray = $this->checkValue_group_select_processDBdata($valueArray, $tcaFieldConf, $id, $status, 'select', $table, $field);
2079 }
2080 }
2081 if (!$unsetResult) {
2082 $newVal = $this->checkValue_checkMax($tcaFieldConf, $valueArray);
2083 $res['value'] = $this->castReferenceValue(implode(',', $newVal), $tcaFieldConf);
2084 } else {
2085 unset($res['value']);
2086 }
2087 return $res;
2088 }
2089
2090 /**
2091 * Applies the filter methods from a column's TCA configuration to a value array.
2092 *
2093 * @param array $tcaFieldConfiguration
2094 * @param array $values
2095 * @return array|mixed
2096 * @throws \RuntimeException
2097 */
2098 protected function applyFiltersToValues(array $tcaFieldConfiguration, array $values) {
2099 if (empty($tcaFieldConfiguration['filter']) || !is_array($tcaFieldConfiguration['filter'])) {
2100 return $values;
2101 }
2102 foreach ($tcaFieldConfiguration['filter'] as $filter) {
2103 if (empty($filter['userFunc'])) {
2104 continue;
2105 }
2106 $parameters = $filter['parameters'] ?: array();
2107 $parameters['values'] = $values;
2108 $parameters['tcaFieldConfig'] = $tcaFieldConfiguration;
2109 $values = GeneralUtility::callUserFunction($filter['userFunc'], $parameters, $this);
2110 if (!is_array($values)) {
2111 throw new \RuntimeException('Failed calling filter userFunc.', 1336051942);
2112 }
2113 }
2114 return $values;
2115 }
2116
2117 /**
2118 * Handling files for group/select function
2119 *
2120 * @param array $valueArray Array of incoming file references. Keys are numeric, values are files (basically, this is the exploded list of incoming files)
2121 * @param array $tcaFieldConf Configuration array from TCA of the field
2122 * @param string $curValue Current value of the field
2123 * @param array $uploadedFileArray Array of uploaded files, if any
2124 * @param string $status 'update' or 'new' flag
2125 * @param string $table tablename of record
2126 * @param int $id UID of record
2127 * @param string $recFID Field identifier [table:uid:field] for flexforms
2128 * @return array Modified value array
2129 *
2130 * @throws \RuntimeException
2131 * @see checkValue_group_select()
2132 */
2133 public function checkValue_group_select_file($valueArray, $tcaFieldConf, $curValue, $uploadedFileArray, $status, $table, $id, $recFID) {
2134 // If file handling should NOT be bypassed, do processing:
2135 if (!$this->bypassFileHandling) {
2136 // If any files are uploaded, add them to value array
2137 // Numeric index means that there are multiple files
2138 if (isset($uploadedFileArray[0])) {
2139 $uploadedFiles = $uploadedFileArray;
2140 } else {
2141 // There is only one file
2142 $uploadedFiles = array($uploadedFileArray);
2143 }
2144 foreach ($uploadedFiles as $uploadedFileArray) {
2145 if (!empty($uploadedFileArray['name']) && $uploadedFileArray['tmp_name'] !== 'none') {
2146 $valueArray[] = $uploadedFileArray['tmp_name'];
2147 $this->alternativeFileName[$uploadedFileArray['tmp_name']] = $uploadedFileArray['name'];
2148 }
2149 }
2150 // Creating fileFunc object.
2151 if (!$this->fileFunc) {
2152 $this->fileFunc = GeneralUtility::makeInstance(BasicFileUtility::class);
2153 $this->include_filefunctions = 1;
2154 }
2155 // Setting permitted extensions.
2156 $all_files = array();
2157 $all_files['webspace']['allow'] = $tcaFieldConf['allowed'];
2158 $all_files['webspace']['deny'] = $tcaFieldConf['disallowed'] ?: '*';
2159 $all_files['ftpspace'] = $all_files['webspace'];
2160 $this->fileFunc->init('', $all_files);
2161 }
2162 // If there is an upload folder defined:
2163 if ($tcaFieldConf['uploadfolder'] && $tcaFieldConf['internal_type'] == 'file') {
2164 $currentFilesForHistory = NULL;
2165 // If filehandling should NOT be bypassed, do processing:
2166 if (!$this->bypassFileHandling) {
2167 // For logging..
2168 $propArr = $this->getRecordProperties($table, $id);
2169 // Get destrination path:
2170 $dest = $this->destPathFromUploadFolder($tcaFieldConf['uploadfolder']);
2171 // If we are updating:
2172 if ($status == 'update') {
2173 // Traverse the input values and convert to absolute filenames in case the update happens to an autoVersionized record.
2174 // Background: This is a horrible workaround! The problem is that when a record is auto-versionized the files of the record get copied and therefore get new names which is overridden with the names from the original record in the incoming data meaning both lost files and double-references!
2175 // The only solution I could come up with (except removing support for managing files when autoversioning) was to convert all relative files to absolute names so they are copied again (and existing files deleted). This should keep references intact but means that some files are copied, then deleted after being copied _again_.
2176 // Actually, the same problem applies to database references in case auto-versioning would include sub-records since in such a case references are remapped - and they would be overridden due to the same principle then.
2177 // Illustration of the problem comes here:
2178 // We have a record 123 with a file logo.gif. We open and edit the files header in a workspace. So a new version is automatically made.
2179 // The versions uid is 456 and the file is copied to "logo_01.gif". But the form data that we sent was based on uid 123 and hence contains the filename "logo.gif" from the original.
2180 // The file management code below will do two things: First it will blindly accept "logo.gif" as a file attached to the record (thus creating a double reference) and secondly it will find that "logo_01.gif" was not in the incoming filelist and therefore should be deleted.
2181 // If we prefix the incoming file "logo.gif" with its absolute path it will be seen as a new file added. Thus it will be copied to "logo_02.gif". "logo_01.gif" will still be deleted but since the files are the same the difference is zero - only more processing and file copying for no reason. But it will work.
2182 if ($this->autoVersioningUpdate === TRUE) {
2183 foreach ($valueArray as $key => $theFile) {
2184 // If it is an already attached file...
2185 if ($theFile === basename($theFile)) {
2186 $valueArray[$key] = PATH_site . $tcaFieldConf['uploadfolder'] . '/' . $theFile;
2187 }
2188 }
2189 }
2190 // Finding the CURRENT files listed, either from MM or from the current record.
2191 $theFileValues = array();
2192 // If MM relations for the files also!
2193 if ($tcaFieldConf['MM']) {
2194 $dbAnalysis = $this->createRelationHandlerInstance();
2195 /** @var $dbAnalysis RelationHandler */
2196 $dbAnalysis->start('', 'files', $tcaFieldConf['MM'], $id);
2197 foreach ($dbAnalysis->itemArray as $item) {
2198 if ($item['id']) {
2199 $theFileValues[] = $item['id'];
2200 }
2201 }
2202 } else {
2203 $theFileValues = GeneralUtility::trimExplode(',', $curValue, TRUE);
2204 }
2205 $currentFilesForHistory = implode(',', $theFileValues);
2206 // DELETE files: If existing files were found, traverse those and register files for deletion which has been removed:
2207 if (!empty($theFileValues)) {
2208 // Traverse the input values and for all input values which match an EXISTING value, remove the existing from $theFileValues array (this will result in an array of all the existing files which should be deleted!)
2209 foreach ($valueArray as $key => $theFile) {
2210 if ($theFile && !strstr(GeneralUtility::fixWindowsFilePath($theFile), '/')) {
2211 $theFileValues = ArrayUtility::removeArrayEntryByValue($theFileValues, $theFile);
2212 }
2213 }
2214 // This array contains the filenames in the uploadfolder that should be deleted:
2215 foreach ($theFileValues as $key => $theFile) {
2216 $theFile = trim($theFile);
2217 if (@is_file(($dest . '/' . $theFile))) {
2218 $this->removeFilesStore[] = $dest . '/' . $theFile;
2219 } elseif ($this->enableLogging && $theFile) {
2220 $this->log($table, $id, 5, 0, 1, 'Could not delete file \'%s\' (does not exist). (%s)', 10, array($dest . '/' . $theFile, $recFID), $propArr['event_pid']);
2221 }
2222 }
2223 }
2224 }
2225 // Traverse the submitted values:
2226 foreach ($valueArray as $key => $theFile) {
2227 // Init:
2228 $maxSize = (int)$tcaFieldConf['max_size'];
2229 // Must be cleared. Else a faulty fileref may be inserted if the below code returns an error!
2230 $theDestFile = '';
2231 // a FAL file was added, now resolve the file object and get the absolute path
2232 // @todo in future versions this needs to be modified to handle FAL objects natively
2233 if (!empty($theFile) && MathUtility::canBeInterpretedAsInteger($theFile)) {
2234 $fileObject = ResourceFactory::getInstance()->getFileObject($theFile);
2235 $theFile = $fileObject->getForLocalProcessing(FALSE);
2236 }
2237 // NEW FILES? If the value contains '/' it indicates, that the file
2238 // is new and should be added to the uploadsdir (whether its absolute or relative does not matter here)
2239 if (strstr(GeneralUtility::fixWindowsFilePath($theFile), '/')) {
2240 // Check various things before copying file:
2241 // File and destination must exist
2242 if (@is_dir($dest) && (@is_file($theFile) || @is_uploaded_file($theFile))) {
2243 // Finding size.
2244 if (is_uploaded_file($theFile) && $theFile == $uploadedFileArray['tmp_name']) {
2245 $fileSize = $uploadedFileArray['size'];
2246 } else {
2247 $fileSize = filesize($theFile);
2248 }
2249 // Check file size:
2250 if (!$maxSize || $fileSize <= $maxSize * 1024) {
2251 // Prepare filename:
2252 $theEndFileName = isset($this->alternativeFileName[$theFile]) ? $this->alternativeFileName[$theFile] : $theFile;
2253 $fI = GeneralUtility::split_fileref($theEndFileName);
2254 // Check for allowed extension:
2255 if ($this->fileFunc->checkIfAllowed($fI['fileext'], $dest, $theEndFileName)) {
2256 $theDestFile = $this->fileFunc->getUniqueName($this->fileFunc->cleanFileName($fI['file']), $dest);
2257 // If we have a unique destination filename, then write the file:
2258 if ($theDestFile) {
2259 GeneralUtility::upload_copy_move($theFile, $theDestFile);
2260 // Hook for post-processing the upload action
2261 if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tcemain.php']['processUpload'])) {
2262 foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tcemain.php']['processUpload'] as $classRef) {
2263 $hookObject = GeneralUtility::getUserObj($classRef);
2264 if (!$hookObject instanceof DataHandlerProcessUploadHookInterface) {
2265 throw new \UnexpectedValueException('$hookObject must implement interface TYPO3\\CMS\\Core\\DataHandling\\DataHandlerProcessUploadHookInterface', 1279962349);
2266 }
2267 $hookObject->processUpload_postProcessAction($theDestFile, $this);
2268 }
2269 }
2270 $this->copiedFileMap[$theFile] = $theDestFile;
2271 clearstatcache();
2272 if ($this->enableLogging && !@is_file($theDestFile)) {
2273 $this->log($table, $id, 5, 0, 1, 'Copying file \'%s\' failed!: The destination path (%s) may be write protected. Please make it write enabled!. (%s)', 16, array($theFile, dirname($theDestFile), $recFID), $propArr['event_pid']);
2274 }
2275 } elseif ($this->enableLogging) {
2276 $this->log($table, $id, 5, 0, 1, 'Copying file \'%s\' failed!: No destination file (%s) possible!. (%s)', 11, array($theFile, $theDestFile, $recFID), $propArr['event_pid']);
2277 }
2278 } elseif ($this->enableLogging) {
2279 $this->log($table, $id, 5, 0, 1, 'File extension \'%s\' not allowed. (%s)', 12, array($fI['fileext'], $recFID), $propArr['event_pid']);
2280 }
2281 } elseif ($this->enableLogging) {
2282 $this->log($table, $id, 5, 0, 1, 'Filesize (%s) of file \'%s\' exceeds limit (%s). (%s)', 13, array(GeneralUtility::formatSize($fileSize), $theFile, GeneralUtility::formatSize($maxSize * 1024), $recFID), $propArr['event_pid']);
2283 }
2284 } elseif ($this->enableLogging) {
2285 $this->log($table, $id, 5, 0, 1, 'The destination (%s) or the source file (%s) does not exist. (%s)', 14, array($dest, $theFile, $recFID), $propArr['event_pid']);
2286 }
2287 // If the destination file was created, we will set the new filename in the value array, otherwise unset the entry in the value array!
2288 if (@is_file($theDestFile)) {
2289 $info = GeneralUtility::split_fileref($theDestFile);
2290 // The value is set to the new filename
2291 $valueArray[$key] = $info['file'];
2292 } else {
2293 // The value is set to the new filename
2294 unset($valueArray[$key]);
2295 }
2296 }
2297 }
2298 }
2299 // If MM relations for the files, we will set the relations as MM records and change the valuearray to contain a single entry with a count of the number of files!
2300 if ($tcaFieldConf['MM']) {
2301 /** @var $dbAnalysis RelationHandler */
2302 $dbAnalysis = $this->createRelationHandlerInstance();
2303 // Dummy
2304 $dbAnalysis->tableArray['files'] = array();
2305 foreach ($valueArray as $key => $theFile) {
2306 // Explode files
2307 $dbAnalysis->itemArray[]['id'] = $theFile;
2308 }
2309 if ($status == 'update') {
2310 $dbAnalysis->writeMM($tcaFieldConf['MM'], $id, 0);
2311 $newFiles = implode(',', $dbAnalysis->getValueArray());
2312 list(, , $recFieldName) = explode(':', $recFID);
2313 if ($currentFilesForHistory != $newFiles) {
2314 $this->mmHistoryRecords[$table . ':' . $id]['oldRecord'][$recFieldName] = $currentFilesForHistory;
2315 $this->mmHistoryRecords[$table . ':' . $id]['newRecord'][$recFieldName] = $newFiles;
2316 } else {
2317 $this->mmHistoryRecords[$table . ':' . $id]['oldRecord'][$recFieldName] = '';
2318 $this->mmHistoryRecords[$table . ':' . $id]['newRecord'][$recFieldName] = '';
2319 }
2320 } else {
2321 $this->dbAnalysisStore[] = array($dbAnalysis, $tcaFieldConf['MM'], $id, 0);
2322 }
2323 $valueArray = $dbAnalysis->countItems();
2324 }
2325 } else {
2326 if (!empty($valueArray)) {
2327 // If filehandling should NOT be bypassed, do processing:
2328 if (!$this->bypassFileHandling) {
2329 // For logging..
2330 $propArr = $this->getRecordProperties($table, $id);
2331 foreach ($valueArray as &$theFile) {
2332 // FAL handling: it's a UID, thus it is resolved to the absolute path
2333 if (!empty($theFile) && MathUtility::canBeInterpretedAsInteger($theFile)) {
2334 $fileObject = ResourceFactory::getInstance()->getFileObject($theFile);
2335 $theFile = $fileObject->getForLocalProcessing(FALSE);
2336 }
2337 if ($this->alternativeFilePath[$theFile]) {
2338 // If alternative File Path is set for the file, then it was an import
2339 // don't import the file if it already exists
2340 if (@is_file((PATH_site . $this->alternativeFilePath[$theFile]))) {
2341 $theFile = PATH_site . $this->alternativeFilePath[$theFile];
2342 } elseif (@is_file($theFile)) {
2343 $dest = dirname(PATH_site . $this->alternativeFilePath[$theFile]);
2344 if (!@is_dir($dest)) {
2345 GeneralUtility::mkdir_deep(PATH_site, dirname($this->alternativeFilePath[$theFile]) . '/');
2346 }
2347 // Init:
2348 $maxSize = (int)$tcaFieldConf['max_size'];
2349 // Must be cleared. Else a faulty fileref may be inserted if the below code returns an error!
2350 $theDestFile = '';
2351 $fileSize = filesize($theFile);
2352 // Check file size:
2353 if (!$maxSize || $fileSize <= $maxSize * 1024) {
2354 // Prepare filename:
2355 $theEndFileName = isset($this->alternativeFileName[$theFile]) ? $this->alternativeFileName[$theFile] : $theFile;
2356 $fI = GeneralUtility::split_fileref($theEndFileName);
2357 // Check for allowed extension:
2358 if ($this->fileFunc->checkIfAllowed($fI['fileext'], $dest, $theEndFileName)) {
2359 $theDestFile = PATH_site . $this->alternativeFilePath[$theFile];
2360 // Write the file:
2361 if ($theDestFile) {
2362 GeneralUtility::upload_copy_move($theFile, $theDestFile);
2363 $this->copiedFileMap[$theFile] = $theDestFile;
2364 clearstatcache();
2365 if ($this->enableLogging && !@is_file($theDestFile)) {
2366 $this->log($table, $id, 5, 0, 1, 'Copying file \'%s\' failed!: The destination path (%s) may be write protected. Please make it write enabled!. (%s)', 16, array($theFile, dirname($theDestFile), $recFID), $propArr['event_pid']);
2367 }
2368 } elseif ($this->enableLogging) {
2369 $this->log($table, $id, 5, 0, 1, 'Copying file \'%s\' failed!: No destination file (%s) possible!. (%s)', 11, array($theFile, $theDestFile, $recFID), $propArr['event_pid']);
2370 }
2371 } elseif ($this->enableLogging) {
2372 $this->log($table, $id, 5, 0, 1, 'File extension \'%s\' not allowed. (%s)', 12, array($fI['fileext'], $recFID), $propArr['event_pid']);
2373 }
2374 } elseif ($this->enableLogging) {
2375 $this->log($table, $id, 5, 0, 1, 'Filesize (%s) of file \'%s\' exceeds limit (%s). (%s)', 13, array(GeneralUtility::formatSize($fileSize), $theFile, GeneralUtility::formatSize($maxSize * 1024), $recFID), $propArr['event_pid']);
2376 }
2377 // If the destination file was created, we will set the new filename in the value array, otherwise unset the entry in the value array!
2378 if (@is_file($theDestFile)) {
2379 // The value is set to the new filename
2380 $theFile = $theDestFile;
2381 } else {
2382 // The value is set to the new filename
2383 unset($theFile);
2384 }
2385 }
2386 }
2387 if (!empty($theFile)) {
2388 $theFile = GeneralUtility::fixWindowsFilePath($theFile);
2389 if (GeneralUtility::isFirstPartOfStr($theFile, PATH_site)) {
2390 $theFile = PathUtility::stripPathSitePrefix($theFile);
2391 }
2392 }
2393 }
2394 unset($theFile);
2395 }
2396 }
2397 }
2398 return $valueArray;
2399 }
2400
2401 /**
2402 * Evaluates 'flex' type values.
2403 *
2404 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
2405 * @param string|array $value The value to set.
2406 * @param array $tcaFieldConf Field configuration from TCA
2407 * @param array $PP Additional parameters in a numeric array: $table,$id,$curValue,$status,$realPid,$recFID
2408 * @param array $uploadedFiles Uploaded files for the field
2409 * @param string $field Field name
2410 * @return array Modified $res array
2411 * @deprecated since TYPO3 CMS 7, will be removed in TYPO3 CMS 8
2412 */
2413 public function checkValue_flex($res, $value, $tcaFieldConf, $PP, $uploadedFiles, $field) {
2414 GeneralUtility::logDeprecatedFunction();
2415 list($table, $id, $curValue, $status, $realPid, $recFID, $tscPID) = $PP;
2416 $this->checkValueForFlex($res, $value, $tcaFieldConf, $table, $id, $curValue, $status, $realPid, $recFID, $tscPID, $uploadedFiles, $field);
2417 }
2418
2419 /**
2420 * Evaluates 'flex' type values.
2421 *
2422 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
2423 * @param string|array $value The value to set.
2424 * @param array $tcaFieldConf Field configuration from TCA
2425 * @param string $table Table name
2426 * @param int $id UID of record
2427 * @param mixed $curValue Current value of the field
2428 * @param string $status 'update' or 'new' flag
2429 * @param int $realPid The real PID value of the record. For updates, this is just the pid of the record. For new records this is the PID of the page where it is inserted. If $realPid is -1 it means that a new version of the record is being inserted.
2430 * @param string $recFID Field identifier [table:uid:field] for flexforms
2431 * @param int $tscPID TSconfig PID
2432 * @param array $uploadedFiles Uploaded files for the field
2433 * @param string $field Field name
2434 * @return array Modified $res array
2435 */
2436 protected function checkValueForFlex($res, $value, $tcaFieldConf, $table, $id, $curValue, $status, $realPid, $recFID, $tscPID, $uploadedFiles, $field) {
2437
2438 if (is_array($value)) {
2439 // This value is necessary for flex form processing to happen on flexform fields in page records when they are copied.
2440 // Problem: when copying a page, flexform XML comes along in the array for the new record - but since $this->checkValue_currentRecord does not have a uid or pid for that
2441 // sake, the BackendUtility::getFlexFormDS() function returns no good DS. For new records we do know the expected PID so therefore we send that with this special parameter.
2442 // Only active when larger than zero.
2443 $newRecordPidValue = $status == 'new' ? $realPid : 0;
2444 // Get current value array:
2445 $dataStructArray = BackendUtility::getFlexFormDS($tcaFieldConf, $this->checkValue_currentRecord, $table, $field, TRUE, $newRecordPidValue);
2446 $currentValueArray = (string)$curValue !== '' ? GeneralUtility::xml2array($curValue) : array();
2447 if (!is_array($currentValueArray)) {
2448 $currentValueArray = array();
2449 }
2450 if (isset($currentValueArray['meta']['currentLangId'])) {
2451 unset($currentValueArray['meta']['currentLangId']);
2452 }
2453 // Remove all old meta for languages...
2454 // Evaluation of input values:
2455 $value['data'] = $this->checkValue_flex_procInData($value['data'], $currentValueArray['data'], $uploadedFiles['data'], $dataStructArray, array($table, $id, $curValue, $status, $realPid, $recFID, $tscPID));
2456 // Create XML from input value:
2457 $xmlValue = $this->checkValue_flexArray2Xml($value, TRUE);
2458
2459 // Here we convert the currently submitted values BACK to an array, then merge the two and then BACK to XML again. This is needed to ensure the charsets are the same
2460 // (provided that the current value was already stored IN the charset that the new value is converted to).
2461 $arrValue = GeneralUtility::xml2array($xmlValue);
2462
2463 if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tcemain.php']['checkFlexFormValue'])) {
2464 foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['t3lib/class.t3lib_tcemain.php']['checkFlexFormValue'] as $classRef) {
2465 $hookObject = GeneralUtility::getUserObj($classRef);
2466 if (method_exists($hookObject, 'checkFlexFormValue_beforeMerge')) {
2467 $hookObject->checkFlexFormValue_beforeMerge($this, $currentValueArray, $arrValue);
2468 }
2469 }
2470 }
2471
2472 ArrayUtility::mergeRecursiveWithOverrule($currentValueArray, $arrValue);
2473 $xmlValue = $this->checkValue_flexArray2Xml($currentValueArray, TRUE);
2474
2475 // Action commands (sorting order and removals of elements) for flexform sections,
2476 // see FormEngine for the use of this GP parameter
2477 $actionCMDs = GeneralUtility::_GP('_ACTION_FLEX_FORMdata');
2478 if (is_array($actionCMDs[$table][$id][$field]['data'])) {
2479 $arrValue = GeneralUtility::xml2array($xmlValue);
2480 $this->_ACTION_FLEX_FORMdata($arrValue['data'], $actionCMDs[$table][$id][$field]['data']);
2481 $xmlValue = $this->checkValue_flexArray2Xml($arrValue, TRUE);
2482 }
2483 // Create the value XML:
2484 $res['value'] = '';
2485 $res['value'] .= $xmlValue;
2486 } else {
2487 // Passthrough...:
2488 $res['value'] = $value;
2489 }
2490
2491 return $res;
2492 }
2493
2494 /**
2495 * Converts an array to FlexForm XML
2496 *
2497 * @param array $array Array with FlexForm data
2498 * @param bool $addPrologue If set, the XML prologue is returned as well.
2499 * @return string Input array converted to XML
2500 */
2501 public function checkValue_flexArray2Xml($array, $addPrologue = FALSE) {
2502 /** @var $flexObj FlexFormTools */
2503 $flexObj = GeneralUtility::makeInstance(FlexFormTools::class);
2504 return $flexObj->flexArray2Xml($array, $addPrologue);
2505 }
2506
2507 /**
2508 * Actions for flex form element (move, delete)
2509 * allows to remove and move flexform sections
2510 *
2511 * @param array $valueArray by reference
2512 * @param array $actionCMDs
2513 */
2514 protected function _ACTION_FLEX_FORMdata(&$valueArray, $actionCMDs) {
2515 if (!is_array($valueArray) || !is_array($actionCMDs)) {
2516 return;
2517 }
2518
2519 foreach ($actionCMDs as $key => $value) {
2520 if ($key == '_ACTION') {
2521 // First, check if there are "commands":
2522 if (current($actionCMDs[$key]) === '') {
2523 continue;
2524 }
2525
2526 asort($actionCMDs[$key]);
2527 $newValueArray = array();
2528 foreach ($actionCMDs[$key] as $idx => $order) {
2529 if (substr($idx, 0, 3) == 'ID-') {
2530 $idx = $this->newIndexMap[$idx];
2531 }
2532 // Just one reflection here: It is clear that when removing elements from a flexform, then we will get lost files unless we act on this delete operation by traversing and deleting files that were referred to.
2533 if ($order != 'DELETE') {
2534 $newValueArray[$idx] = $valueArray[$idx];
2535 }
2536 unset($valueArray[$idx]);
2537 }
2538 $valueArray = $valueArray + $newValueArray;
2539 } elseif (is_array($actionCMDs[$key]) && isset($valueArray[$key])) {
2540 $this->_ACTION_FLEX_FORMdata($valueArray[$key], $actionCMDs[$key]);
2541 }
2542 }
2543 }
2544
2545 /**
2546 * Evaluates 'inline' type values.
2547 * (partly copied from the select_group function on this issue)
2548 *
2549 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
2550 * @param string $value The value to set.
2551 * @param array $tcaFieldConf Field configuration from TCA
2552 * @param array $PP Additional parameters in a numeric array: $table,$id,$curValue,$status,$realPid,$recFID
2553 * @param string $field Field name
2554 * @param array $additionalData Additional data to be forwarded to sub-processors
2555 * @return array Modified $res array
2556 */
2557 public function checkValue_inline($res, $value, $tcaFieldConf, $PP, $field, array $additionalData = NULL) {
2558 list($table, $id, , $status) = $PP;
2559 $this->checkValueForInline($res, $value, $tcaFieldConf, $table, $id, $status, $field, $additionalData);
2560 }
2561
2562 /**
2563 * Evaluates 'inline' type values.
2564 * (partly copied from the select_group function on this issue)
2565 *
2566 * @param array $res The result array. The processed value (if any!) is set in the 'value' key.
2567 * @param string $value The value to set.
2568 * @param array $tcaFieldConf Field configuration from TCA
2569 * @param string $table Table name
2570 * @param int $id UID of record
2571 * @param string $status 'update' or 'new' flag
2572 * @param string $field Field name
2573 * @param array $additionalData Additional data to be forwarded to sub-processors
2574 * @return array Modified $res array
2575 */
2576 public function checkValueForInline($res, $value, $tcaFieldConf, $table, $id, $status, $field, array $additionalData = NULL) {
2577 if (!$tcaFieldConf['foreign_table']) {
2578 // Fatal error, inline fields should always have a foreign_table defined
2579 return FALSE;
2580 }
2581 // When values are sent they come as comma-separated values which are exploded by this function:
2582 $valueArray = GeneralUtility::trimExplode(',', $value);
2583 // Remove duplicates: (should not be needed)
2584 $valueArray = array_unique($valueArray);
2585 // Example for received data:
2586 // $value = 45,NEW4555fdf59d154,12,123
2587 // We need to decide whether we use the stack or can save the relation directly.
2588 if (strpos($value, 'NEW') !== FALSE || !MathUtility::canBeInterpretedAsInteger($id)) {
2589 $this->remapStackRecords[$table][$id] = array('remapStackIndex' => count($this->remapStack));
2590 $this->addNewValuesToRemapStackChildIds($valueArray);
2591 $this->remapStack[] = array(
2592 'func' => 'checkValue_inline_processDBdata',
2593 'args' => array($valueArray, $tcaFieldConf, $id, $status, $table, $field, $additionalData),
2594 'pos' => array('valueArray' => 0, 'tcaFieldConf' => 1, 'id' => 2, 'table' => 4),
2595 'additionalData' => $additionalData,
2596 'field' => $field,
2597 );
2598 unset($res['value']);
2599 } elseif ($value || MathUtility::canBeInterpretedAsInteger($id)) {
2600 $res['value'] = $this->checkValue_inline_processDBdata($valueArray, $tcaFieldConf, $id, $status, $table, $field, $additionalData);
2601 }
2602 return $res;
2603 }
2604
2605 /**
2606 * Checks if a fields has more items than defined via TCA in maxitems.
2607 * If there are more items than allowd, the item list is truncated to the defined number.
2608 *
2609 * @param array $tcaFieldConf Field configuration from TCA
2610 * @param array $valueArray Current value array of items
2611 * @return array The truncated value array of items
2612 */
2613 public function checkValue_checkMax($tcaFieldConf, $valueArray) {
2614 // BTW, checking for min and max items here does NOT make any sense when MM is used because the above function calls will just return an array with a single item (the count) if MM is used... Why didn't I perform the check before? Probably because we could not evaluate the validity of record uids etc... Hmm...
2615 $valueArrayC = count($valueArray);
2616 // NOTE to the comment: It's not really possible to check for too few items, because you must then determine first, if the field is actual used regarding the CType.
2617 $maxI = isset($tcaFieldConf['maxitems']) ? (int)$tcaFieldConf['maxitems'] : 1;
2618 if ($valueArrayC > $maxI) {
2619 $valueArrayC = $maxI;
2620 }
2621 // Checking for not too many elements
2622 // Dumping array to list
2623 $newVal = array();
2624 foreach ($valueArray as $nextVal) {
2625 if ($valueArrayC == 0) {
2626 break;
2627 }
2628 $valueArrayC--;
2629 $newVal[] = $nextVal;
2630 }
2631 return $newVal;
2632 }
2633
2634 /*********************************************
2635 *
2636 * Helper functions for evaluation functions.
2637 *
2638 ********************************************/
2639 /**
2640 * Gets a unique value for $table/$id/$field based on $value
2641 *
2642 * @param string $table Table name
2643 * @param string $field Field name for which $value must be unique
2644 * @param string $value Value string.
2645 * @param int $id UID to filter out in the lookup (the record itself...)
2646 * @param int $newPid If set, the value will be unique for this PID
2647 * @return string Modified value (if not-unique). Will be the value appended with a number (until 100, then the function just breaks).
2648 */
2649 public function getUnique($table, $field, $value, $id, $newPid = 0) {
2650 // Initialize:
2651 $whereAdd = '';
2652 $newValue = '';
2653 if ((int)$newPid) {
2654 $whereAdd .= ' AND pid=' . (int)$newPid;
2655 } else {
2656 $whereAdd .= ' AND pid>=0';
2657 }
2658 // "AND pid>=0" for versioning
2659 $whereAdd .= $this->deleteClause($table);
2660 // If the field is configured in TCA, proceed:
2661 if (is_array($GLOBALS['TCA'][$table]) && is_array($GLOBALS['TCA'][$table]['columns'][$field])) {
2662 // Look for a record which might already have the value:
2663 $res = $this->databaseConnection->exec_SELECTquery('uid', $table, $field . '=' . $this->databaseConnection->fullQuoteStr($value, $table) . ' AND uid<>' . (int)$id . $whereAdd);
2664 $counter = 0;
2665 // For as long as records with the test-value existing, try again (with incremented numbers appended).
2666 while ($this->databaseConnection->sql_num_rows($res)) {
2667 $newValue = $value . $counter;
2668 $res = $this->databaseConnection->exec_SELECTquery('uid', $table, $field . '=' . $this->databaseConnection->fullQuoteStr($newValue, $table) . ' AND uid<>' . (int)$id . $whereAdd);
2669 $counter++;
2670 if ($counter > 100) {
2671 break;
2672 }
2673 }
2674 $this->databaseConnection->sql_free_result($res);
2675 // If the new value is there:
2676 $value = $newValue !== '' ? $newValue : $value;
2677 }
2678 return $value;
2679 }
2680
2681 /**
2682 * gets all records that have the same value in a field
2683 * excluding the given uid
2684 *
2685 * @param string $tableName Table name
2686 * @param int $uid UID to filter out in the lookup (the record itself...)
2687 * @param string $fieldName Field name for which $value must be unique
2688 * @param string $value Value string.
2689 * @param int $pageId If set, the value will be unique for this PID
2690 * @return array
2691 */
2692 public function getRecordsWithSameValue($tableName, $uid, $fieldName, $value, $pageId = 0) {
2693 $result = array();
2694 if (!empty($GLOBALS['TCA'][$tableName]['columns'][$fieldName])) {
2695
2696 $uid = (int)$uid;
2697 $pageId = (int)$pageId;
2698 $whereStatement = ' AND uid <> ' . $uid . ' AND ' . ($pageId ? 'pid = ' . $pageId : 'pid >= 0');
2699 $result = BackendUtility::getRecordsByField($tableName, $fieldName, $value, $whereStatement);
2700 }
2701 return $result;
2702 }
2703
2704 /**
2705 * @param string $value The field value to be evaluated
2706 * @param array $evalArray Array of evaluations to traverse.
2707 * @param string $is_in The "is_in" value of the field configuration from TCA
2708 * @return array
2709 */
2710 public function checkValue_text_Eval($value, $evalArray, $is_in) {
2711 $res = array();
2712 $set = TRUE;
2713 foreach ($evalArray as $func) {
2714 switch ($func) {
2715 case 'trim':
2716 $value = trim($value);
2717 break;
2718 case 'required':
2719 if (!$value) {
2720 $set = FALSE;
2721 }
2722 break;
2723 default:
2724 if (isset($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['tce']['formevals'][$func])) {
2725 if (class_exists($func)) {
2726 $evalObj = GeneralUtility::makeInstance($func);
2727 if (method_exists($evalObj, 'evaluateFieldValue')) {
2728 $value = $evalObj->evaluateFieldValue($value, $is_in, $set);
2729 }
2730 }
2731 }
2732 }
2733 }
2734 if ($set) {
2735 $res['value'] = $value;
2736 }
2737 return $res;
2738 }
2739
2740 /**
2741 * Evaluation of 'input'-type values based on 'eval' list
2742 *
2743 * @param string $value Value to evaluate
2744 * @param array $evalArray Array of evaluations to traverse.
2745 * @param string $is_in Is-in string for 'is_in' evaluation
2746 * @return array Modified $value in key 'value' or empty array
2747 */
2748 public function checkValue_input_Eval($value, $evalArray, $is_in) {
2749 $res = array();
2750 $set = TRUE;
2751 foreach ($evalArray as $func) {
2752 switch ($func) {
2753 case 'int':
2754 case 'year':
2755 case 'time':
2756 case 'timesec':
2757 $value = (int)$value;
2758 break;
2759 case 'date':
2760 case 'datetime':
2761 $value = (int)$value;
2762 if ($value > 0 && !$this->dontProcessTransformations) {
2763 $value -= date('Z', $value);
2764 }
2765 break;
2766 case 'double2':
2767 $value = preg_replace('/[^0-9,\\.-]/', '', $value);
2768 $negative = $value[0] === '-';
2769 $value = strtr($value, array(',' => '.', '-' => ''));
2770 if (strpos($value, '.') === FALSE) {
2771 $value .= '.0';
2772 }
2773 $valueArray = explode('.', $value);
2774 $dec = array_pop($valueArray);
2775 $value = join('', $valueArray) . '.' . $dec;
2776 if ($negative) {
2777 $value *= -1;
2778 }
2779 $value = number_format($value, 2, '.', '');
2780 break;
2781 case 'md5':
2782 if (strlen($value) != 32) {
2783 $set = FALSE;
2784 }
2785 break;
2786 case 'trim':
2787 $value = trim($value);
2788 break;
2789 case 'upper':
2790 $value = $GLOBALS['LANG']->csConvObj->conv_case($GLOBALS['LANG']->charSet, $value, 'toUpper');
2791 break;
2792 case 'lower':
2793 $value = $GLOBALS['LANG']->csConvObj->conv_case($GLOBALS['LANG']->charSet, $value, 'toLower');
2794 break;
2795 case 'required':
2796 if (!isset($value) || $value === '') {
2797 $set = FALSE;
2798 }
2799 break;
2800 case 'is_in':
2801 $c = strlen($value);
2802 if ($c) {
2803 $newVal = '';
2804 for ($a = 0; $a < $c; $a++) {