Exakat\Reports\Ambassador::getSeveritiesNumberBy PHP Method

    private function getSeveritiesNumberBy($type = 'file')
    {
        $list = Analyzer::getThemeAnalyzers($this->themesToShow);
        $list = '"' . join('", "', $list) . '"';
        $query = <<<SQL
SELECT {$type}, severity, count(*) AS count
    FROM results
    WHERE analyzer IN ({$list})
    GROUP BY {$type}, severity
SQL;
        $stmt = $this->sqlite->query($query);
        $return = array();
        while ($row = $stmt->fetchArray(\SQLITE3_ASSOC)) {
            if (!isset($return[$row[$type]])) {
                $return[$row[$type]] = array($row['severity'] => $row['count']);
            } else {
                $return[$row[$type]][$row['severity']] = $row['count'];
            }
        }
        return $return;
    }