l10n_parent of workspace index points to the wrong index

[okmiim]

l10n_parent of workspace index points to the wrong index.

The l10n_parent of a translated record in the workspace points to the live index.
However, it should point to the workspace index with the default language.
This should only be the case when a workspace index with the default language exists, since the original index is "marked as deleted".

This seems to be more complicated...
Might only be relevant in some edge cases and needs more thinking about different combinations.

Notes

In the case of workspaces, the last query matches multiple entries. Returns

• LIVE version
• Entry with DELETED placeholder
• WS version

calendarize/Classes/Service/IndexPreparationService.php

Lines 105 to 131 in 4c78609

	protected function addLanguageInformation(array &$neededItems, string $tableName, array $record): void
	{
	$languageField = $GLOBALS['TCA'][$tableName]['ctrl']['languageField'] ?? false; // e.g. sys_language_uid
	$transPointer = $GLOBALS['TCA'][$tableName]['ctrl']['transOrigPointerField'] ?? false; // e.g. l10n_parent
	if ($transPointer && (int)$record[$transPointer] > 0) {
	foreach ($neededItems as $key => $value) {
	$originalRecord = BackendUtility::getRecord($value['foreign_table'], $value['foreign_uid'], $transPointer);
	$searchFor = $value;
	$searchFor['foreign_uid'] = (int)$originalRecord[$transPointer];
	$db = HelperUtility::getDatabaseConnection(IndexerService::TABLE_NAME);
	$q = $db->createQueryBuilder();
	$where = [];
	foreach ($searchFor as $field => $val) {
	if (\is_string($val)) {
	$where[] = $q->expr()->eq($field, $q->quote($val));
	} else {
	$where[] = $q->expr()->eq($field, (int)$val);
	}
	}
	$result = $q->select('uid')->from(IndexerService::TABLE_NAME)->andWhere(...$where)->execute()->fetch();
	if (isset($result['uid'])) {
	$neededItems[$key]['l10n_parent'] = (int)$result['uid'];
	}