<?php
namespace Medienreaktor\Courses\Hooks;

use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Context\Context;
class GetCourseTypes
{
    public function getTypes(&$config)
    {

        $items = [];
        $items[] = ['Alle', 'none'];

        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tx_courses_domain_model_course');
        $result = $queryBuilder
            ->select('*')
            ->from('tx_courses_domain_model_course')
            ->where(
                $queryBuilder->expr()->eq('hidden', $queryBuilder->createNamedParameter('0'))
            )->andWhere($queryBuilder->expr()->eq('deleted', $queryBuilder->createNamedParameter('0')))->executeQuery();

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

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

        return '';
    }
}

?>