diff options
author | Eugen Rochko <eugen@zeonfederated.com> | 2021-10-14 20:44:59 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2021-10-14 20:44:59 +0200 |
commit | 07341e7aa60fe7c7d4f298136af99276820940e7 (patch) | |
tree | 0244c21262573d6a94868f8ce7dfa934fabccf1e /app/lib/admin/metrics/dimension/sources_dimension.rb | |
parent | 959f7fc580050b37741c92b645b842e45017a010 (diff) |
Add graphs and retention metrics to admin dashboard (#16829)
Diffstat (limited to 'app/lib/admin/metrics/dimension/sources_dimension.rb')
-rw-r--r-- | app/lib/admin/metrics/dimension/sources_dimension.rb | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/app/lib/admin/metrics/dimension/sources_dimension.rb b/app/lib/admin/metrics/dimension/sources_dimension.rb new file mode 100644 index 000000000..a9f061809 --- /dev/null +++ b/app/lib/admin/metrics/dimension/sources_dimension.rb @@ -0,0 +1,23 @@ +# frozen_string_literal: true + +class Admin::Metrics::Dimension::SourcesDimension < Admin::Metrics::Dimension::BaseDimension + def key + 'sources' + end + + def data + sql = <<-SQL.squish + SELECT oauth_applications.name, count(*) AS value + FROM users + LEFT JOIN oauth_applications ON oauth_applications.id = users.created_by_application_id + WHERE users.created_at BETWEEN $1 AND $2 + GROUP BY oauth_applications.name + ORDER BY count(*) DESC + LIMIT $3 + SQL + + rows = ActiveRecord::Base.connection.select_all(sql, nil, [[nil, @start_at], [nil, @end_at], [nil, @limit]]) + + rows.map { |row| { key: row['name'] || 'web', human_key: row['name'] || I18n.t('admin.dashboard.website'), value: row['value'].to_s } } + end +end |