Newscoop\Entity\Repository\ArticleRepository::getArticlesForSection PHP Метод

getArticlesForSection() публичный Метод

Get Articles for chosen section.
public getArticlesForSection ( integer $publication, integer $sectionNumber, Language | null $sectionLanguage = null ) : Doctrine\ORM\Query
$publication integer
$sectionNumber integer
$sectionLanguage Newscoop\Entity\Language | null
Результат Doctrine\ORM\Query
    public function getArticlesForSection($publication, $sectionNumber, $sectionLanguage = null)
    {
        $em = $this->getEntityManager();
        $queryBuilder = $em->getRepository('Newscoop\\Entity\\Article')->createQueryBuilder('a')->where('a.sectionId = :sectionNumber')->andWhere('a.language = :sectionLanguage')->andWhere('a.publication = :publicationId')->setParameters(array('sectionNumber' => $sectionNumber, 'sectionLanguage' => $sectionLanguage, 'publicationId' => $publication));
        $qbCount = clone $queryBuilder;
        $qbCount->select('count(a)');
        $articlesCount = $qbCount->getQuery()->getSingleScalarResult();
        $query = $queryBuilder->getQuery();
        $query->setHint('knp_paginator.count', $articlesCount);
        return $query;
    }