Exakat\Analyzer\Docs::getThemesForAnalyzer PHP Метод

    public function getThemesForAnalyzer()
    {
        $list = array('CompatibilityPHP53', 'CompatibilityPHP54', 'CompatibilityPHP55', 'CompatibilityPHP56', 'CompatibilityPHP70', 'CompatibilityPHP71', 'Dead code', 'Security', 'Analyze', 'Preferences');
        $listSqlite3 = '"' . join('", "', $list) . '"';
        $query = <<<SQL
SELECT folder||'/'||a.name AS analyzer, GROUP_CONCAT(c.name) AS categories FROM categories AS c
    JOIN analyzers_categories AS ac
        ON ac.id_categories = c.id
    JOIN analyzers AS a
        ON a.id = ac.id_analyzer
    WHERE c.name IN ({$listSqlite3})
\tGROUP BY analyzer
SQL;
        $res = $this->sqlite->query($query);
        $return = array();
        while ($row = $res->fetchArray()) {
            $return[$row['analyzer']] = explode(',', $row['categories']);
        }
        return $return;
    }