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

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