Ojs\AnalyticsBundle\Command\StatsNormalizeCommand::normalizeIssueTotalArticleView PHP Метод

normalizeIssueTotalArticleView() публичный Метод

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