mirror of
https://gh.wpcy.net/https://github.com/discourse/discourse.git
synced 2026-05-23 11:23:27 +08:00
2536768a43
Introduction of system themes. System themes are local themes which: - Cannot be deleted; - Cannot have “custom code” added, components only; - Cannot have uploads; - Cannot edit color palettes; - Are updated on deploy, like core plugins. This PR added the Foundation system theme, which is an empty theme like Default. The Foundation theme will be added in the next PR. In a development environment, when system theme files are changed/added/deleted, the theme is reuploaded and the page is reloaded to make it a good experience for the engineer working on improvements. System themes are not visible until `SiteSetting.experimental_system_theme` is enabled.
86 lines
2.5 KiB
Ruby
Vendored
86 lines
2.5 KiB
Ruby
Vendored
# frozen_string_literal: true
|
|
|
|
module Reports::TopUploads
|
|
extend ActiveSupport::Concern
|
|
|
|
class_methods do
|
|
def report_top_uploads(report)
|
|
report.modes = [Report::MODES[:table]]
|
|
|
|
extension_filter = report.filters.dig(:file_extension)
|
|
report.add_filter(
|
|
"file_extension",
|
|
type: "list",
|
|
default: extension_filter || "any",
|
|
choices: (SiteSetting.authorized_extensions.split("|") + Array(extension_filter)).uniq,
|
|
)
|
|
|
|
report.labels = [
|
|
{
|
|
type: :link,
|
|
properties: %i[file_url file_name],
|
|
title: I18n.t("reports.top_uploads.labels.filename"),
|
|
},
|
|
{
|
|
type: :user,
|
|
properties: {
|
|
username: :author_username,
|
|
id: :author_id,
|
|
avatar: :author_avatar_template,
|
|
},
|
|
title: I18n.t("reports.top_uploads.labels.author"),
|
|
},
|
|
{
|
|
type: :text,
|
|
property: :extension,
|
|
title: I18n.t("reports.top_uploads.labels.extension"),
|
|
},
|
|
{ type: :bytes, property: :filesize, title: I18n.t("reports.top_uploads.labels.filesize") },
|
|
]
|
|
|
|
report.data = []
|
|
|
|
sql = <<~SQL
|
|
SELECT
|
|
u.id as user_id,
|
|
u.username,
|
|
u.uploaded_avatar_id,
|
|
up.filesize,
|
|
up.original_filename,
|
|
up.extension,
|
|
up.url
|
|
FROM uploads up
|
|
JOIN users u
|
|
ON u.id = up.user_id
|
|
/*where*/
|
|
ORDER BY up.filesize DESC
|
|
LIMIT #{report.limit || 250}
|
|
SQL
|
|
|
|
builder = DB.build(sql)
|
|
builder.where(
|
|
"up.id > :seeded_id_threshold",
|
|
seeded_id_threshold: Upload::SEEDED_ID_THRESHOLD,
|
|
)
|
|
builder.where("up.created_at >= :start_date", start_date: report.start_date)
|
|
builder.where("up.created_at < :end_date", end_date: report.end_date)
|
|
builder.where("username != '#{Discourse.system_user.username}'")
|
|
|
|
if extension_filter
|
|
builder.where("up.extension = :extension", extension: extension_filter.sub(/\A\./, ""))
|
|
end
|
|
|
|
builder.query.each do |row|
|
|
data = {}
|
|
data[:author_id] = row.user_id
|
|
data[:author_username] = row.username
|
|
data[:author_avatar_template] = User.avatar_template(row.username, row.uploaded_avatar_id)
|
|
data[:filesize] = row.filesize
|
|
data[:extension] = row.extension
|
|
data[:file_url] = Discourse.store.cdn_url(row.url)
|
|
data[:file_name] = row.original_filename.truncate(25)
|
|
report.data << data
|
|
end
|
|
end
|
|
end
|
|
end
|
