Newscoop\Entity\Repository\RatingRepository::totalRatingBy PHP Метод

    public function totalRatingBy(array $criteria)
    {
        $queryBuilder = $this->getEntityManager()->createQueryBuilder()->select('SUM(u.ratingScore)')->from($this->getEntityName(), 'u');
        foreach ($criteria as $property => $value) {
            if (!is_array($value)) {
                $queryBuilder->andWhere("u.{$property} = :{$property}");
            }
        }
        $query = $queryBuilder->getQuery();
        foreach ($criteria as $property => $value) {
            if (!is_array($value)) {
                $query->setParameter($property, $value);
            }
        }
        return (int) $query->getSingleScalarResult();
    }