Newscoop\Tools\Console\Command\SubscriptionsNotifierCommand::getSectionCounts PHP Method

    private function getSectionCounts($subscription, $issueMaxNumber)
    {
        $sectionsCount = $this->em->getRepository('Newscoop\\Entity\\Section')->createQueryBuilder('s')->select('COUNT(s) AS numberOfSections')->where('s.publication = :publicationId')->andWhere('s.issue = :issueId')->andWhere('s.language = :language')->setParameters(array('publicationId' => $subscription->getPublication()->getId(), 'issueId' => $issueMaxNumber, 'language' => $subscription->getPublication()->getDefaultLanguage()->getId()))->getQuery()->getScalarResult();
        return $sectionsCount;
    }