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

normalizeIssueTotalArticleDownload() public method

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