9.5/_post_repository_8php_source.html

<?php

namespace ‪ExtbaseTeam\BlogExample\Domain\Repository;


/*

 * 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!

 */


use ‪ExtbaseTeam\BlogExample\Domain\Model\Post;

use ‪TYPO3\CMS\Extbase\Persistence\QueryInterface;

use ‪TYPO3\CMS\Extbase\Persistence\QueryResultInterface;


class ‪PostRepository extends ‪\TYPO3\CMS\Extbase\Persistence\Repository

{

    protected ‪$defaultOrderings = ['date' => ‪QueryInterface::ORDER_DESCENDING];


    public function ‪findAllByBlog(\‪ExtbaseTeam\BlogExample\Domain\Model\Blog $blog)

    {

        $query = $this->‪createQuery();

        return $query

            ->matching(

                $query->equals('blog', $blog)

            )

            ->execute();

    }


    public function ‪findByTagAndBlog($tag, \‪ExtbaseTeam\BlogExample\Domain\Model\Blog $blog)

    {

        $query = $this->‪createQuery();

        return $query

            ->matching(

                $query->logicalAnd(

                    $query->equals('blog', $blog),

                    $query->equals('tags.name', $tag)

                )

            )

            ->execute();

    }


    public function ‪findRemaining(‪Post $post)

    {

        $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)

    {

        $query = $this->‪createQuery();

        return $query

            ->matching(

                $query->lessThan('date', $post->‪getDate())

            )

            ->execute()

            ->getFirst();

    }


    public function ‪findNext(‪Post $post)

    {

        $query = $this->‪createQuery();

        return $query

            ->matching(

                $query->greaterThan('date', $post->‪getDate())

            )

            ->execute()

            ->getFirst();

    }


    public function ‪findRecentByBlog(\‪ExtbaseTeam\BlogExample\Domain\Model\Blog $blog, $limit = 5)

    {

        $query = $this->‪createQuery();

        return $query

            ->matching(

                $query->equals('blog', $blog)

            )

            ->setLimit((int)$limit)

            ->execute();

    }


    public function ‪findByCategory($categoryUid)

    {

        $query = $this->‪createQuery();

        return $query

            ->matching(

                $query->contains('categories', $categoryUid)

            )

            ->execute();

    }


    public function ‪findAllSortedByCategory(array $uids)

    {

        $q = $this->‪createQuery();

        $q->matching($q->in('uid', $uids));

        $q->setOrderings([

            'categories.title' => ‪QueryInterface::ORDER_ASCENDING,

            'uid' => ‪QueryInterface::ORDER_ASCENDING,

        ]);

        return $q->execute();

    }

}