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

    public function generateIssuePublishCountData($year)
    {
        $connectionParams = $this->manager->getConnection()->getParams();
        if ($connectionParams['driver'] == 'pdo_sqlite') {
            $sql = "SELECT COUNT(id) as count, journal_id FROM issue GROUP BY journal_id";
        } else {
            $sql = "SELECT count(id) as count, journal_id FROM issue WHERE EXTRACT(YEAR FROM year) = " . $year . " GROUP BY journal_id";
        }
        $rsm = new ResultSetMapping();
        $rsm->addScalarResult('count', 'count');
        $rsm->addScalarResult('journal_id', 'journal');
        $query = $this->manager->createNativeQuery($sql, $rsm);
        $results = $query->getResult();
        return $results;
    }