<?php
namespace Medienreaktor\Courses\Hooks;

use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Context\Context;
class GetSubjectTypes
{
    public function getTypes(&$config)
    {
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tx_courses_domain_model_course');
        $result = $queryBuilder
            ->select('*')
            ->from('tx_courses_domain_model_subject')
            ->where(
                $queryBuilder->expr()->eq('hidden', $queryBuilder->createNamedParameter('0'))
            )->andWhere($queryBuilder->expr()->eq('deleted', $queryBuilder->createNamedParameter('0')))->executeQuery();

        while ($row = $result->fetch()) {
            $items[] = [$row['title'], $row['title']];
        }

        $config['items'] = array_merge($config['items'], $items);

        return '';
    }
}

?>