Exakat\Reports\Ambassador::getTopAnalyzers PHP Метод

    private function getTopAnalyzers()
    {
        $list = Analyzer::getThemeAnalyzers($this->themesToShow);
        $list = '"' . join('", "', $list) . '"';
        $query = "SELECT analyzer, count(*) AS number\n                    FROM results\n                    WHERE analyzer IN ({$list})\n                    GROUP BY analyzer\n                    ORDER BY number DESC\n                    LIMIT " . self::TOPLIMIT;
        $result = $this->sqlite->query($query);
        $data = array();
        while ($row = $result->fetchArray()) {
            $analyzer = Analyzer::getInstance($row['analyzer']);
            $data[] = array('label' => $analyzer->getDescription()->getName(), 'value' => $row['number']);
        }
        $html = '';
        foreach ($data as $value) {
            $html .= '<div class="clearfix">
                    <a href="#" title="' . $value['label'] . '">
                      <div class="block-cell-name">' . $value['label'] . '</div>
                      <div class="block-cell-issue text-center">' . $value['value'] . '</div>
                    </a>
                  </div>';
        }
        return $html;
    }