Exakat\Reports\Ambassador::getFilesCount PHP Method

    public function getFilesCount($limit = null)
    {
        $list = Analyzer::getThemeAnalyzers($this->themesToShow);
        $list = '"' . join('", "', $list) . '"';
        $query = "SELECT file, count(*) AS number\n                    FROM results\n                    WHERE analyzer IN ({$list})\n                    GROUP BY file\n                    ORDER BY number DESC ";
        if ($limit !== null) {
            $query .= " LIMIT " . $limit;
        }
        $result = $this->sqlite->query($query);
        $data = array();
        while ($row = $result->fetchArray()) {
            $data[] = array('file' => $row['file'], 'value' => $row['number']);
        }
        return $data;
    }