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

    public function generateApplicationYearlyData()
    {
        $connectionParams = $this->manager->getConnection()->getParams();
        if ($connectionParams['driver'] == 'pdo_sqlite') {
            $sql = 'SELECT count(id) as result_count , strftime("%Y", created) as year  FROM journal GROUP BY year';
        } else {
            $sql = 'SELECT count(id) as result_count , date_trunc(\'year\', created) as year FROM journal GROUP BY year';
        }
        $rsm = new ResultSetMapping();
        $rsm->addScalarResult('result_count', 'result_count');
        $rsm->addScalarResult('year', 'year');
        $query = $this->manager->createNativeQuery($sql, $rsm);
        $results = $query->getResult();
        return $results;
    }