<?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();
        }
    }
}