<?php

namespace Fab\Formule\Loader;

/*

* This file is part of the Fab/Formule project under GPLv2 or later.

*

* For the full copyright and license information, please read the

* LICENSE.md file that was distributed with this source code.

*/

use Fab\Formule\Service\TemplateService;

use TYPO3\CMS\Core\Database\Query\QueryBuilder;

use TYPO3\CMS\Core\Utility\GeneralUtility;

/**

* Class UserDataLoader

* Only an example class to be copy / pasted and adjusted!!!

*/

class UserDataLoader extends AbstractLoader

{

/**

* @param array $values

* @return array

*/

public function load(array $values): array

{

$identifierField = $this->getTemplateService()->getIdentifierField();

$identifierValue = $GLOBALS['TYPO3_REQUEST']->getParsedBody()[$identifierField] ?? $GLOBALS['TYPO3_REQUEST']->getQueryParams()[$identifierField] ?? null;

$tableName = $this->getTemplateService()->getPersistingTableName();

/** @var QueryBuilder $query */

$query = $this->getQueryBuilder($tableName);

$query->select('*')

->from($tableName)

->where(

$query->expr()->eq(

$identifierField,

$query->expr()->literal($identifierValue)

)

);

$record = $query

->executeQuery()

->fetchAssociative();

$fields = $this->getTemplateService()->getFields();

// is mapping necessary here?

foreach ($fields as $field) {

if (isset($record[$field])) {

$values[$field] = $record[$field];

}

}

$values['uid'] = $record['uid'];

return $values;

}

/**

* @return TemplateService|object

*/

protected function getTemplateService()

{

return GeneralUtility::makeInstance(TemplateService::class);

}

}