Ojs\AnalyticsBundle\Command\StatsNormalizeCommand::normalizeJournalTotalArticleDownload PHP Method

normalizeJournalTotalArticleDownload() public method

    public function normalizeJournalTotalArticleDownload()
    {
        $rsm = new ResultSetMapping();
        $sql = <<<SQL
UPDATE journal
SET total_article_download =
  (SELECT SUM(t2.download_count)
   FROM article t2
   WHERE t2.journal_id = journal.id)
SQL;
        $query = $this->em->createNativeQuery($sql, $rsm);
        $query->getResult();
    }