mirror of
https://gh.wpcy.net/https://github.com/discourse/discourse.git
synced 2026-05-03 05:29:42 +08:00
15838aa756
This commit converts the `AdminReport` component, which is quite high complexity, to gjs. After this initial round, ideally this component would be broken up into smaller components because it is getting quite big now. Also in this commit: * Add an option to display the report description in a tooltip, which was the main way the description was shown until recently. We want to use this on the dashboard view mostly. * Move admin report "mode" definitions to the server-side Report model, inside a `Report::MODES` constant, collecting the modes defined in various places in the UI into one place * Refactor report code to refer to mode definitions * Add a `REPORT_MODES` constant in JS via javascript.rake and refactor JS to refer to the modes * Delete old admin report components that are no longer used (trust-level-counts, counts, per-day-counts) which were replaced by admin-report-counters a while ago * Add a new `registerReportModeComponent` plugin API, some plugins introduce their own modes (like AI's `emotion`) and components and we need a way to render them
75 lines
2.3 KiB
Ruby
75 lines
2.3 KiB
Ruby
# frozen_string_literal: true
|
|
|
|
module Reports::TopicViewStats
|
|
extend ActiveSupport::Concern
|
|
|
|
class_methods do
|
|
def report_topic_view_stats(report)
|
|
report.modes = [Report::MODES[:table]]
|
|
|
|
category_id, include_subcategories = report.add_category_filter
|
|
|
|
category_ids = include_subcategories ? Category.subcategory_ids(category_id) : [category_id]
|
|
sql = <<~SQL
|
|
SELECT
|
|
topic_view_stats.topic_id,
|
|
topics.title AS topic_title,
|
|
SUM(topic_view_stats.anonymous_views) AS total_anonymous_views,
|
|
SUM(topic_view_stats.logged_in_views) AS total_logged_in_views,
|
|
SUM(topic_view_stats.anonymous_views + topic_view_stats.logged_in_views) AS total_views
|
|
FROM topic_view_stats
|
|
INNER JOIN topics ON topics.id = topic_view_stats.topic_id
|
|
WHERE viewed_at BETWEEN :start_date AND :end_date
|
|
#{category_ids.any? ? "AND topics.category_id IN (:category_ids)" : ""}
|
|
GROUP BY topic_view_stats.topic_id, topics.title
|
|
ORDER BY total_views DESC
|
|
LIMIT 100
|
|
SQL
|
|
|
|
data =
|
|
DB.query(
|
|
sql,
|
|
start_date: report.start_date,
|
|
end_date: report.end_date,
|
|
category_ids: category_ids,
|
|
)
|
|
|
|
report.labels = [
|
|
{
|
|
type: :topic,
|
|
properties: {
|
|
title: :topic_title,
|
|
id: :topic_id,
|
|
},
|
|
title: I18n.t("reports.topic_view_stats.labels.topic"),
|
|
},
|
|
{
|
|
property: :total_anonymous_views,
|
|
type: :number,
|
|
title: I18n.t("reports.topic_view_stats.labels.anon_views"),
|
|
},
|
|
{
|
|
property: :total_logged_in_views,
|
|
type: :number,
|
|
title: I18n.t("reports.topic_view_stats.labels.logged_in_views"),
|
|
},
|
|
{
|
|
property: :total_views,
|
|
type: :number,
|
|
title: I18n.t("reports.topic_view_stats.labels.total_views"),
|
|
},
|
|
]
|
|
|
|
report.data =
|
|
data.map do |row|
|
|
{
|
|
topic_id: row.topic_id,
|
|
topic_title: row.topic_title,
|
|
total_anonymous_views: row.total_anonymous_views,
|
|
total_logged_in_views: row.total_logged_in_views,
|
|
total_views: row.total_views,
|
|
}
|
|
end
|
|
end
|
|
end
|
|
end
|
