discourse/app/controllers/admin/screened_urls_controller.rb

# frozen_string_literal: true

class Admin::ScreenedUrlsController < Admin::StaffController
  def index
    screened_urls =
      ScreenedUrl
        .select(
          "domain, sum(match_count) as match_count, max(last_match_at) as last_match_at, min(created_at) as created_at",
        )
        .group(:domain)
        .order("last_match_at DESC")
        .to_a
    render_serialized(screened_urls, GroupedScreenedUrlSerializer)
  end
end
DEV: enable frozen string literal on all files This reduces chances of errors where consumers of strings mutate inputs and reduces memory usage of the app. Test suite passes now, but there may be some stuff left, so we will run a few sites on a branch prior to merging 2019-05-03 06:17:27 +08:00			`# frozen_string_literal: true`

Refactor admin base controller (#18453) * DEV: Add a dedicated Admin::StaffController base controller The current parent(Admin:AdminController) for all admin-related controllers uses a filter that allows only staff(admin, moderator) users. This refactor makes Admin::AdminController filter for only admins as the name suggests and introduces a base controller dedicated for staff-related endpoints. * DEV: Set staff-only controllers parent to Admin::StaffController Refactor staff-only controllers to inherit newly introduced Admin::StaffController abstract controller. This conveys the purpose of the parent controller better unlike the previously used parent controller. 2022-10-31 20:02:26 +08:00			`class Admin::ScreenedUrlsController < Admin::StaffController`
Screened URLs list in admin 2013-08-15 22:48:30 +08:00			`def index`
Should have put order on the screened urls results 2013-11-05 05:31:31 +08:00			`screened_urls =`
			`ScreenedUrl`
			`.select(`
			`"domain, sum(match_count) as match_count, max(last_match_at) as last_match_at, min(created_at) as created_at",`
DEV: Apply syntax_tree formatting to `app/*` 2023-01-09 20:20:10 +08:00			`)`
Should have put order on the screened urls results 2013-11-05 05:31:31 +08:00			`.group(:domain)`
			`.order("last_match_at DESC")`
			`.to_a`
Screened Urls page shows results for each domain instead of each url 2013-11-05 05:24:32 +08:00			`render_serialized(screened_urls, GroupedScreenedUrlSerializer)`
Screened URLs list in admin 2013-08-15 22:48:30 +08:00			`end`
			`end`