Ojs\AnalyticsBundle\Utils\GraphDataGenerator::generateIssueFileDownloadsData PHP Method

    public function generateIssueFileDownloadsData($dates = null, Journal $journal = null)
    {
        $whereDate = '';
        if ($dates) {
            $today = $dates[0];
            $lastMonthToday = end($dates);
            $whereDate = "AND statistic.date BETWEEN '" . $lastMonthToday . "' AND '" . $today . "' ";
        }
        $journalWhereQuery = ' ';
        if ($journal) {
            $journalWhereQuery = 'AND issue.journal_id = ' . $journal->getId() . ' ';
        }
        $sql = "SELECT issue_file_translations.title, SUM(statistic.download) as sum_download, statistic.issue_file_id FROM statistic " . "join issue_file on statistic.issue_file_id = issue_file.id " . "join issue_file_translations on issue_file.id = issue_file_translations.translatable_id " . "join issue on issue_file.issue_id = issue.id " . "and issue_file_translations.locale = '" . $this->locale . "' " . "WHERE issue_file_id IS NOT NULL " . $whereDate . $journalWhereQuery . "group by issue_file_id,issue_file_translations.title,statistic.issue_file_id " . "ORDER BY sum_download DESC " . "LIMIT 20; ";
        $rsm = new ResultSetMapping();
        $rsm->addScalarResult('title', 'title');
        $rsm->addScalarResult('sum_download', 'download');
        $rsm->addScalarResult('issue_file_id', 'id');
        $query = $this->manager->createNativeQuery($sql, $rsm);
        $results = $query->getResult();
        return $results;
    }

 /**
  *  Arranges statistics
  *  @return array
  */
 private function createStats()
 {
     $generator = new GraphDataGenerator($this->getDoctrine()->getManager());
     $journal = $this->get('ojs.journal_service')->getSelectedJournal();
     $lastMonth = ['x'];
     for ($i = 0; $i < 30; $i++) {
         $lastMonth[] = date($this::DATE_FORMAT, strtotime('-' . $i . ' days'));
     }
     $slicedLastMonth = array_slice($lastMonth, 1);
     $articles = $this->getDoctrine()->getRepository('OjsJournalBundle:Article')->findAll();
     $issues = $this->getDoctrine()->getRepository('OjsJournalBundle:Issue')->findAll();
     $json = ['dates' => $lastMonth, 'articleViews' => $generator->generateArticleBarChartData($articles, $slicedLastMonth), 'issueFileDownloads' => $generator->generateIssueFilePieChartData($issues, $slicedLastMonth), 'articleFileDownloads' => $generator->generateArticleFilePieChartData($articles, $slicedLastMonth)];
     $data = ['stats' => json_encode($json), 'articles' => $generator->generateArticleViewsData($articles), 'issueFiles' => $generator->generateIssueFileDownloadsData($issues), 'articleFiles' => $generator->generateArticleFileDownloadsData($articles), 'articlesMonthly' => $generator->generateArticleViewsData($articles, $slicedLastMonth), 'issueFilesMonthly' => $generator->generateIssueFileDownloadsData($issues, $slicedLastMonth), 'articleFilesMonthly' => $generator->generateArticleFileDownloadsData($articles, $slicedLastMonth)];
     return $data;
 }