PostRepository.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
/*
 * This file is part of the TYPO3 CMS project.
 *
 * It is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License, either version 2
 * of the License, or any later version.
 *
 * For the full copyright and license information, please read the
 * LICENSE.txt file that was distributed with this source code.
 *
 * The TYPO3 project - inspiring people to share!
 */
 
namespace ‪TYPO3Tests\BlogExample\Domain\Repository;
 
use ‪TYPO3\CMS\Extbase\Persistence\QueryInterface;
use ‪TYPO3\CMS\Extbase\Persistence\QueryResultInterface;
use ‪TYPO3\CMS\Extbase\Persistence\Repository;
use ‪TYPO3Tests\BlogExample\Domain\Model\Blog;
use ‪TYPO3Tests\BlogExample\Domain\Model\Post;
 
class ‪PostRepository extends ‪Repository
{
    protected ‪$defaultOrderings = ['date' => ‪QueryInterface::ORDER_DESCENDING];
 
    public function ‪findAllByBlog(‪Blog $blog): ‪QueryResultInterface
    {
        $query = $this->‪createQuery();
        return $query
            ->matching(
                $query->equals('blog', $blog)
            )
            ->execute();
    }
 
    public function ‪findByTagAndBlog(string $tag, ‪Blog $blog): ‪QueryResultInterface
    {
        $query = $this->‪createQuery();
        return $query
            ->matching(
                $query->logicalAnd(
                    $query->equals('blog', $blog),
                    $query->equals('tags.name', $tag)
                )
            )
            ->execute();
    }
 
    public function ‪findRemaining(‪Post $post): ‪QueryResultInterface
    {
        $blog = $post->‪getBlog();
        $query = $this->‪createQuery();
        return $query
            ->matching(
                $query->logicalAnd(
                    $query->equals('blog', $blog),
                    $query->logicalNot(
                        $query->equals('uid', $post->‪getUid())
                    )
                )
            )
            ->execute();
    }
 
    public function ‪findPrevious(‪Post $post): ‪Post
    {
        $query = $this->‪createQuery();
        return $query
            ->matching(
                $query->lessThan('date', $post->‪getDate())
            )
            ->execute()
            ->getFirst();
    }
 
    public function ‪findNext(‪Post $post): ‪Post
    {
        $query = $this->‪createQuery();
        return $query
            ->matching(
                $query->greaterThan('date', $post->‪getDate())
            )
            ->execute()
            ->getFirst();
    }
 
    public function ‪findRecentByBlog(‪Blog $blog, int $limit = 5): ‪QueryResultInterface
    {
        $query = $this->‪createQuery();
        return $query
            ->matching(
                $query->equals('blog', $blog)
            )
            ->setLimit((int)$limit)
            ->execute();
    }
 
    public function ‪findByCategory(int $categoryUid): ‪QueryResultInterface
    {
        $query = $this->‪createQuery();
        return $query
            ->matching(
                $query->contains('categories', $categoryUid)
            )
            ->execute();
    }
 
    public function ‪findAllSortedByCategory(array $uids): ‪QueryResultInterface
    {
        $q = $this->‪createQuery();
        $q->matching($q->in('uid', $uids));
        $q->setOrderings([
            'categories.title' => ‪QueryInterface::ORDER_ASCENDING,
            'uid' => ‪QueryInterface::ORDER_ASCENDING,
        ]);
        return $q->execute();
    }
}