<?php

namespace Lu\LuSearch\Domain\Model;

use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Database\ConnectionPool;

/**
 * Class Results
 *
 * @package Lu\LuSearch\Domain\Model
 */
class Results
{
    /**
     * Fetch title by uid and field
     *
     * @param $field
     * @param $uid
     *
     * @return mixed|string
     */
    public function getTitleByFacet($field, $uid)
    {
        // Fetch titles
        switch ($field) {
            case 'category':
                // Fetch category name
                $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable('sys_category')->createQueryBuilder();
                $row          = $queryBuilder
                    ->select('title')
                    ->from('sys_category')->where(
                        $queryBuilder->expr()->eq('uid', (int)$uid)
                    )
                    ->execute()->fetch();
                break;
            case 'tag':
                // Fetch category name
                $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable('tx_news_domain_model_tag')->createQueryBuilder();
                $row          = $queryBuilder
                    ->select('title')
                    ->from('tx_news_domain_model_tag')->where(
                        $queryBuilder->expr()->eq('uid', (int)$uid)
                    )
                    ->execute()->fetch();
                break;
        }

        // Return
        return $row['title'] ?? $uid;
    }
}