46 lines
1.3 KiB
PHP
46 lines
1.3 KiB
PHP
<?php
|
|
|
|
namespace HermannTelser\Zuladungsliste\Backend;
|
|
|
|
use TYPO3\CMS\Core\Utility\GeneralUtility;
|
|
use TYPO3\CMS\Core\Database\ConnectionPool;
|
|
|
|
/**
|
|
* Generate additional label for category records
|
|
* including the title of the parent category
|
|
*
|
|
* @$parameters array $params
|
|
* @return void
|
|
*
|
|
*
|
|
* \TYPO3\CMS\Core\Utility\DebugUtility::debug($wettbewerbeid);
|
|
*
|
|
*/
|
|
class FixUser
|
|
{
|
|
public function set()
|
|
{
|
|
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('fe_users');
|
|
$statement = $queryBuilder
|
|
->select('*')
|
|
->from('fe_users')
|
|
->where(
|
|
$queryBuilder->expr()->neq('date_of_birth', (int) 0)
|
|
)->execute()
|
|
->fetchAll();
|
|
|
|
foreach ($statement as $key => $row) {
|
|
$queryBuilder
|
|
->update('fe_users')
|
|
->where(
|
|
$queryBuilder->expr()->eq('uid', (int) $row['uid'])
|
|
)
|
|
->set('tx_extbase_type', (string) 'Tx_Zuladungsliste_Architekten')
|
|
->set('vereidigung', (string) date("Y-m-d", $row['date_of_birth']))
|
|
->set('name', (string) $row['first_name'] . " " . $row['last_name'])
|
|
->set('date_of_birth', (int) 0)
|
|
->execute();
|
|
}
|
|
}
|
|
}
|