diff options
author | Claire <claire.github-309c@sitedethib.com> | 2021-10-14 20:55:16 +0200 |
---|---|---|
committer | Claire <claire.github-309c@sitedethib.com> | 2021-10-14 21:44:57 +0200 |
commit | 694c073d1f94a54a0ccf19299e06f1de849c6edb (patch) | |
tree | 77e9855f70000396b8a6b793ac8a8dbb61c82783 /app/lib/admin/metrics/dimension/languages_dimension.rb | |
parent | ebf2c3195615bb524f6908e84f99887c8775cbc3 (diff) | |
parent | 9b978872cc1a86c7d82afda4060c909dc7ca2536 (diff) |
Merge branch 'main' into glitch-soc/merge-upstream
Conflicts: - `app/controllers/admin/dashboard_controller.rb`: Upstream completely redesigned the admin dashboard. glitch-soc tracked extra features, but that list is gone. Followed upstram. - `app/views/admin/dashboard/index.html.haml` Upstream completely redesigned the admin dashboard. glitch-soc tracked extra features, but that list is gone. Followed upstram.
Diffstat (limited to 'app/lib/admin/metrics/dimension/languages_dimension.rb')
-rw-r--r-- | app/lib/admin/metrics/dimension/languages_dimension.rb | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/app/lib/admin/metrics/dimension/languages_dimension.rb b/app/lib/admin/metrics/dimension/languages_dimension.rb new file mode 100644 index 000000000..2d0ac124e --- /dev/null +++ b/app/lib/admin/metrics/dimension/languages_dimension.rb @@ -0,0 +1,23 @@ +# frozen_string_literal: true + +class Admin::Metrics::Dimension::LanguagesDimension < Admin::Metrics::Dimension::BaseDimension + def key + 'languages' + end + + def data + sql = <<-SQL.squish + SELECT locale, count(*) AS value + FROM users + WHERE current_sign_in_at BETWEEN $1 AND $2 + AND locale IS NOT NULL + GROUP BY locale + 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['locale'], human_key: SettingsHelper::HUMAN_LOCALES[row['locale'].to_sym], value: row['value'].to_s } } + end +end |