<?php

namespace Meramo\Begriffmgt\Domain\Repository;

use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Extbase\Persistence\QueryInterface;
use TYPO3\CMS\Extbase\Persistence\Repository;

class UrlRepository extends Repository {
    /**
     * Find one record by 'title'.
     *
     * @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface|array
     */
    public function findByTitle($title)
    {
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tx_begriffmgt_domain_model_url');
        $query = $queryBuilder
            ->select('*')
            ->from('tx_begriffmgt_domain_model_url')
            ->where(
                $queryBuilder->expr()->eq('title', $queryBuilder->createNamedParameter($title, \PDO::PARAM_STR))
            )
            ->setMaxResults(1)
            ->execute();

        return $result = $query->fetch();
    }

    /**
     * Find all records and order them by 'title' in ascending order.
     *
     * @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface|array
     */
    public function findAllOrderedByTitle()
    {
        $query = $this->createQuery();
        $query->setOrderings(['title' => QueryInterface::ORDER_ASCENDING]);

        return $query->execute();
    }

}