Victoire / victoire

Bundle/BlogBundle/Repository/ArticleRepository.php

<?php

namespace Victoire\Bundle\BlogBundle\Repository;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query;
use Victoire\Bundle\BlogBundle\Entity\Blog;
use Victoire\Bundle\CoreBundle\Repository\StateFullRepositoryTrait;
use Victoire\Bundle\PageBundle\Entity\PageStatus;

/**
 * The Article repository.
 */
class ArticleRepository extends EntityRepository
{
    use StateFullRepositoryTrait;

    /**
     * Get all articles in the repository.
     *
     * @param bool $excludeUnpublished Should we get only the published BasePages ?
     *
     * @return ArticleRepository
     */
    public function getAll($excludeUnpublished = false)
    {
        $this->clearInstance();
        $this->qb = $this->getInstance();

        //If $excludeUnpublished === true, we exclude the non published results
        if ($excludeUnpublished) {
            $this->qb
                ->andWhere('article.status = :status')
                ->orWhere('article.status = :scheduled_status AND article.publishedAt > :publicationDate')
                ->setParameter('status', PageStatus::PUBLISHED)
                ->setParameter('scheduled_status', PageStatus::SCHEDULED)
                ->setParameter('publicationDate', new \DateTime());
        }

        return $this;
    }

    /**
     * Filter repositoy by Blog.
     *
     * @return ArticleRepository
     */
    public function filterByBlog(Blog $blog)
    {
        $this->getInstance()
            ->andWhere('article.blog = :blog')
            ->setParameter('blog', $blog);

        return $this;
    }

    /**
     * Get very next festivals query builder.
     *
     * @param method        $method        The method to run
     * @param hydrationMode $hydrationMode How the results will be (Object ? Array )
     *
     * @return array()
     */
    public function run($method = 'getResult', $hydrationMode = Query::HYDRATE_OBJECT)
    {
        return $this->getInstance()->getQuery()->$method($hydrationMode);
    }

    public function filterWithListingQuery($listingQuery = null)
    {
        if ($listingQuery) {
            $dql = $this->createQueryBuilder('a_article')
                ->leftJoin('a_article.blog', 'blog')
                ->getDql();
            $dql = $dql.' '.$listingQuery;
            $this->qb
                ->andWhere($this->qb->expr()->in('article', $dql));
        }

        return $this;
    }

    public function getPreviousRecord($id)

This method seems to be duplicated in your project.

    {
        $queryBuilder = $this->getAll(true)
            ->getInstance();

        return $queryBuilder->andWhere($queryBuilder->expr()->lt('article.id', ':id'))
            ->setParameter('id', $id)
            ->orderBy('article.id', 'DESC')
            ->setMaxResults(1)
            ->getQuery()
            ->getOneOrNullResult();
    }

    public function getNextRecord($id)

This method seems to be duplicated in your project.

    {
        $queryBuilder = $this->getAll(true)
            ->getInstance();

        return $queryBuilder->andWhere($queryBuilder->expr()->gt('article.id', ':id'))
            ->setParameter('id', $id)
            ->orderBy('article.id', 'ASC')
            ->setMaxResults(1)
            ->getQuery()
            ->getOneOrNullResult();
    }

    public function getVeryFirstRecord()

This method seems to be duplicated in your project.

    {
        $queryBuilder = $this->getAll(true)
            ->getInstance();

        return $queryBuilder
            ->orderBy('article.id', 'ASC')
            ->setMaxResults(1)
            ->getQuery()
            ->getOneOrNullResult();
    }

    public function getVeryLastRecord()

This method seems to be duplicated in your project.

    {
        $queryBuilder = $this->getAll(true)
            ->getInstance();

        return $queryBuilder
            ->orderBy('article.id', 'DESC')
            ->setMaxResults(1)
            ->getQuery()
            ->getOneOrNullResult();
    }
}