protected function AnalyzersResultsCounts()
{
$css = new \Stdclass();
$css->displayTitles = true;
$css->titles = array('Label', 'Count', 'Severity');
$css->readOrder = $css->titles;
$themes = array('CompatibilityPHP53', 'CompatibilityPHP54', 'CompatibilityPHP55', 'CompatibilityPHP56', 'CompatibilityPHP70', 'CompatibilityPHP71', '"Dead code"', 'Security', 'Analyze');
$analyzers = Analyzer::getThemeAnalyzers($themes);
$themesList = '("' . implode('", "', $analyzers) . '")';
$res = $this->dump->query(<<<SQL
SELECT analyzer, count(*) AS count, severity FROM results
WHERE analyzer IN {$themesList}
GROUP BY analyzer
HAVING count > 0
SQL
);
$data = array();
while ($row = $res->fetchArray(\SQLITE3_NUM)) {
$analyzer = Analyzer::getInstance($row[0]);
$row[0] = $analyzer->getDescription()->getName();
$data[] = $row;
}
return $this->formatSimpleTableResultsCount($data, $css);
}