| public getTotalDownloads ( Ojs\JournalBundle\Entity\ArticleFile $articleFile, array $dates ) : array | ||
| $articleFile | Ojs\JournalBundle\Entity\ArticleFile | |
| $dates | array | |
| return | array | |
public function getTotalDownloads($articleFile, $dates)
{
$builder = $this->createQueryBuilder('stat');
$builder->join('OjsJournalBundle:ArticleFile', 'file', 'WHERE', 'stat.articleFile = file')->addSelect('SUM(stat.download)')->andWhere('stat.date IN (:dates)')->andWhere('file = :file')->groupBy('stat.id, file')->setParameters(['file' => $articleFile, 'dates' => $dates]);
return $builder->getQuery()->getResult();
}