<?php

namespace HermannTelser\Zuladungsliste\Einreichen;

use HermannTelser\Zuladungsliste\Utilities\Message;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction;
use TYPO3\CMS\Core\Utility\GeneralUtility;

/***
  *
  * This file is part of the "Zuladungsliste Steiermark" Extension for TYPO3 CMS.
  *
  * For the full copyright and license information, please read the
  * LICENSE.txt file that was distributed with this source code.
  *
  *
  *  Copyright notice
  *
  *  (c) 2017 - 2022 Hermann Telser <hermann.telser@gmail.com>
  *
  *  All rights reserved
  * ************************************************************* */

class EinreichungenUser
{
    public static function laden()
    {
        // lösche Einreichung
        $uid = GeneralUtility::_GP('uid');
        if (!is_numeric($uid)) {
            exit;
        }

        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tx_zuladungsliste_domain_model_wettbewerbe_einreichungen');
        $queryBuilder
         ->update('tx_zuladungsliste_domain_model_wettbewerbe_einreichungen')
         ->where(
             $queryBuilder->expr()->eq('uid', (int) $uid)
         )
         ->set('tstamp', time())
         ->set('deleted', (int) 1)
         ->execute();

         echo $queryBuilder->getSQL();
    }
}