68 lines
2.4 KiB
PHP
68 lines
2.4 KiB
PHP
<?php
|
|
|
|
namespace HermannTelser\Zuladungsliste\Berechnung;
|
|
|
|
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.
|
|
*
|
|
* (c) 2019 Hermann Telser <hermann.telser@gmail.com>, NUH-Odds GmbH
|
|
*
|
|
***/
|
|
|
|
class Architekten
|
|
{
|
|
/**
|
|
* @param mixed $uid
|
|
*
|
|
* @return void
|
|
*/
|
|
public static function load($uid = 0)
|
|
{
|
|
|
|
// _Berechnung::$debug = 1;
|
|
|
|
if (_Berechnung::$debug) {
|
|
Message::debug(__FILE__, __LINE__, 'Load Architekten');
|
|
}
|
|
|
|
// 2 usergroup => Ordentliche Registrierung zur Zuladungsliste
|
|
|
|
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('fe_users');
|
|
$queryBuilder->getRestrictions()->removeAll()->add(GeneralUtility::makeInstance(DeletedRestriction::class));
|
|
$queryBuilder
|
|
->select('uid', 'disable', 'email', 'name', 'last_name', 'company', 'vereidigung', 'frauenfoerderpunkt', 'solidaritaetserklaerung', 'extrasperrung', 'kontoaufloesung', 'kontoaufloesung_active', 'wettbewerbe', 'kammernid', 'kammermitgliedsnummer', 'gender', 'date_of_birth')
|
|
->from('fe_users')
|
|
->where(
|
|
$queryBuilder->expr()->eq('kammernid', (int) _Berechnung::$_config['kammernid']),
|
|
$queryBuilder->expr()->eq('pid', (int) _Berechnung::$_config['pid']),
|
|
$queryBuilder->expr()->eq('usergroup', (int) _Berechnung::$_config['usergroup'])
|
|
);
|
|
if (0 != $uid) {
|
|
$queryBuilder->andWhere($queryBuilder->expr()->eq('uid', (int) $uid));
|
|
}
|
|
if (0 != _Berechnung::$_config['berechne_bis']) {
|
|
$date = date('Y-m-d', _Berechnung::$_config['berechne_bis']);
|
|
$queryBuilder->andWhere("vereidigung < '".$date."'");
|
|
}
|
|
|
|
$statement = $queryBuilder->execute()->fetchAll();
|
|
if (_Berechnung::$debug) {
|
|
Message::note($queryBuilder->getSQL());
|
|
}
|
|
|
|
// print_r($statement);
|
|
// exit;
|
|
|
|
_Berechnung::$_data['architekten'] = $statement;
|
|
}
|
|
}
|