Exakat\Reports\Ambassador::getFilesResultsCounts PHP Method

    private function getFilesResultsCounts()
    {
        $list = Analyzer::getThemeAnalyzers($this->themesToShow);
        $list = '"' . join('", "', $list) . '"';
        $result = $this->sqlite->query(<<<SQL
SELECT file AS file, line AS loc, count(*) AS issues, count(distinct analyzer) AS analyzers FROM results
        GROUP BY file
SQL
);
        $return = array();
        while ($row = $result->fetchArray(\SQLITE3_ASSOC)) {
            $return[$row['file']] = $row;
        }
        return $return;
    }