81 lines
3.2 KiB
Ruby
81 lines
3.2 KiB
Ruby
# frozen_string_literal: true
|
|
|
|
module Reports::SiteTraffic
|
|
extend ActiveSupport::Concern
|
|
|
|
class_methods do
|
|
def report_site_traffic(report)
|
|
report.modes = [:stacked_chart]
|
|
|
|
first_browser_pageview_date =
|
|
DB.query_single(
|
|
<<~SQL,
|
|
SELECT date FROM application_requests
|
|
WHERE req_type = :page_view_logged_in_browser OR req_type = :page_view_anon_browser ORDER BY date LIMIT 1
|
|
SQL
|
|
page_view_logged_in_browser: ApplicationRequest.req_types[:page_view_logged_in_browser],
|
|
page_view_anon_browser: ApplicationRequest.req_types[:page_view_anon_browser],
|
|
).first
|
|
|
|
data =
|
|
DB.query(
|
|
<<~SQL,
|
|
SELECT
|
|
date,
|
|
SUM(CASE WHEN req_type = :page_view_logged_in_browser THEN count ELSE 0 END) AS page_view_logged_in_browser,
|
|
SUM(CASE WHEN req_type = :page_view_anon_browser THEN count ELSE 0 END) AS page_view_anon_browser,
|
|
SUM(CASE WHEN req_type = :page_view_crawler THEN count ELSE 0 END) AS page_view_crawler,
|
|
SUM(
|
|
CASE WHEN req_type = :page_view_anon THEN count
|
|
WHEN req_type = :page_view_logged_in THEN count
|
|
WHEN req_type = :page_view_anon_browser THEN -count
|
|
WHEN req_type = :page_view_logged_in_browser THEN -count
|
|
ELSE 0
|
|
END
|
|
) AS page_view_other
|
|
FROM application_requests
|
|
WHERE date >= :start_date AND date <= :end_date AND date >= :first_browser_pageview_date
|
|
|
|
GROUP BY date
|
|
ORDER BY date ASC
|
|
SQL
|
|
start_date: report.start_date,
|
|
end_date: report.end_date,
|
|
page_view_anon: ApplicationRequest.req_types[:page_view_anon],
|
|
page_view_crawler: ApplicationRequest.req_types[:page_view_crawler],
|
|
page_view_logged_in: ApplicationRequest.req_types[:page_view_logged_in],
|
|
page_view_anon_browser: ApplicationRequest.req_types[:page_view_anon_browser],
|
|
page_view_logged_in_browser: ApplicationRequest.req_types[:page_view_logged_in_browser],
|
|
first_browser_pageview_date: first_browser_pageview_date,
|
|
)
|
|
|
|
report.data = [
|
|
{
|
|
req: "page_view_logged_in_browser",
|
|
label: I18n.t("reports.site_traffic.xaxis.page_view_logged_in_browser"),
|
|
color: report.colors[:turquoise],
|
|
data: data.map { |row| { x: row.date, y: row.page_view_logged_in_browser } },
|
|
},
|
|
{
|
|
req: "page_view_anon_browser",
|
|
label: I18n.t("reports.site_traffic.xaxis.page_view_anon_browser"),
|
|
color: report.colors[:lime],
|
|
data: data.map { |row| { x: row.date, y: row.page_view_anon_browser } },
|
|
},
|
|
{
|
|
req: "page_view_crawler",
|
|
label: I18n.t("reports.site_traffic.xaxis.page_view_crawler"),
|
|
color: report.colors[:purple],
|
|
data: data.map { |row| { x: row.date, y: row.page_view_crawler } },
|
|
},
|
|
{
|
|
req: "page_view_other",
|
|
label: I18n.t("reports.site_traffic.xaxis.page_view_other"),
|
|
color: report.colors[:magenta],
|
|
data: data.map { |row| { x: row.date, y: row.page_view_other } },
|
|
},
|
|
]
|
|
end
|
|
end
|
|
end
|