<?php
namespace Medienreaktor\Career\Hooks;

use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Context\Context;
class GetSourceOptions
{
    public function getSources(&$config)
    {
        $items = [];
        $items[] = ['Alle', 'none'];
        $contentId = key($GLOBALS["_GET"]["edit"]["tt_content"]);
//
        $contentQuery = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tt_content');
        $contentResult = $contentQuery
            ->select('sys_language_uid')
            ->from('tt_content')->where($contentQuery->expr()->eq('uid', $contentQuery->createNamedParameter($contentId)))->executeQuery();

        while ($row = $contentResult->fetch()) {
           $langId = $row["sys_language_uid"];
        }


        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tx_career_domain_model_source');

        $result = $queryBuilder
            ->select('*')
            ->from('tx_career_domain_model_source')
            ->where(
                $queryBuilder->expr()->eq('hidden', $queryBuilder->createNamedParameter('0'))
            )
            ->andWhere(
                $queryBuilder->expr()->eq('deleted', $queryBuilder->createNamedParameter('0')),
            )->andWhere($queryBuilder->expr()->eq('sys_language_uid', $queryBuilder->createNamedParameter($langId)))->executeQuery();

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


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

        return '';
    }
}

?>