TYPO3 /
TYPO3.CMS
| @@ 575-599 (lines=25) @@ | ||
| 572 | * @param array $referenceRecord |
|
| 573 | * @return array |
|
| 574 | */ |
|
| 575 | protected function transformFileReferenceToRecordReference(array $referenceRecord) |
|
| 576 | { |
|
| 577 | $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('sys_refindex'); |
|
| 578 | $queryBuilder->getRestrictions()->removeAll(); |
|
| 579 | $fileReference = $queryBuilder |
|
| 580 | ->select('uid_foreign', 'tablenames', 'fieldname', 'sorting_foreign') |
|
| 581 | ->from('sys_file_reference') |
|
| 582 | ->where( |
|
| 583 | $queryBuilder->expr()->eq( |
|
| 584 | 'uid', |
|
| 585 | $queryBuilder->createNamedParameter($referenceRecord['recuid'], \PDO::PARAM_INT) |
|
| 586 | ) |
|
| 587 | ) |
|
| 588 | ->execute() |
|
| 589 | ->fetch(); |
|
| 590 | ||
| 591 | return [ |
|
| 592 | 'recuid' => $fileReference['uid_foreign'], |
|
| 593 | 'tablename' => $fileReference['tablenames'], |
|
| 594 | 'field' => $fileReference['fieldname'], |
|
| 595 | 'flexpointer' => '', |
|
| 596 | 'softref_key' => '', |
|
| 597 | 'sorting' => $fileReference['sorting_foreign'] |
|
| 598 | ]; |
|
| 599 | } |
|
| 600 | ||
| 601 | /** |
|
| 602 | * Gets a File or a Folder object from an identifier [storage]:[fileId] |
|
| @@ 680-705 (lines=26) @@ | ||
| 677 | * @param array $referenceRecord |
|
| 678 | * @return array |
|
| 679 | */ |
|
| 680 | protected function transformFileReferenceToRecordReference(array $referenceRecord) |
|
| 681 | { |
|
| 682 | /** @var $queryBuilder \TYPO3\CMS\Core\Database\Query\QueryBuilder */ |
|
| 683 | $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class) |
|
| 684 | ->getQueryBuilderForTable('sys_file_reference'); |
|
| 685 | $queryBuilder->getRestrictions()->removeAll(); |
|
| 686 | $fileReference = $queryBuilder |
|
| 687 | ->select('*') |
|
| 688 | ->from('sys_file_reference') |
|
| 689 | ->where( |
|
| 690 | $queryBuilder->expr()->eq( |
|
| 691 | 'uid', |
|
| 692 | $queryBuilder->createNamedParameter($referenceRecord['recuid'], \PDO::PARAM_INT) |
|
| 693 | ) |
|
| 694 | ) |
|
| 695 | ->execute() |
|
| 696 | ->fetch(); |
|
| 697 | ||
| 698 | return [ |
|
| 699 | 'recuid' => $fileReference['uid_foreign'], |
|
| 700 | 'tablename' => $fileReference['tablenames'], |
|
| 701 | 'field' => $fileReference['fieldname'], |
|
| 702 | 'flexpointer' => '', |
|
| 703 | 'softref_key' => '', |
|
| 704 | 'sorting' => $fileReference['sorting_foreign'] |
|
| 705 | ]; |
|
| 706 | } |
|
| 707 | ||
| 708 | /** |
|
