Sha256: 7b6ee70faedec803cd0a2f21b6494409d4020abadcab8c735ffed1675d925107

Contents?: true

Size: 787 Bytes

Versions: 91

Compression:

Stored size: 787 Bytes

Contents

# frozen_string_literal: true

module Decidim
  # This query counts registered users from a collection of organizations
  # in an optional interval of time.
  class StatsUsersCount < Rectify::Query
    def self.for(organization, start_at = nil, end_at = nil)
      new(organization, start_at, end_at).query
    end

    def initialize(organization, start_at = nil, end_at = nil)
      @organization = organization
      @start_at = start_at
      @end_at = end_at
    end

    def query
      users = Decidim::User.where(organization: @organization)
      users = users.where("created_at >= ?", @start_at) if @start_at.present?
      users = users.where("created_at <= ?", @end_at) if @end_at.present?
      users = users.where.not(confirmed_at: nil)
      users.count
    end
  end
end

Version data entries

91 entries across 91 versions & 2 rubygems

Version Path
decidim-core-0.24.3 app/queries/decidim/stats_users_count.rb
decidim-core-0.23.6 app/queries/decidim/stats_users_count.rb
decidim-core-0.24.2 app/queries/decidim/stats_users_count.rb
decidim-core-0.23.5 app/queries/decidim/stats_users_count.rb
decidim-core-0.24.1 app/queries/decidim/stats_users_count.rb
decidim-core-0.24.0 app/queries/decidim/stats_users_count.rb
decidim-core-0.24.0.rc2 app/queries/decidim/stats_users_count.rb
decidim-core-0.23.4 app/queries/decidim/stats_users_count.rb
decidim-core-0.24.0.rc1 app/queries/decidim/stats_users_count.rb
decidim-core-0.23.3 app/queries/decidim/stats_users_count.rb
decidim-core-0.23.2 app/queries/decidim/stats_users_count.rb
decidim-core-0.23.1 app/queries/decidim/stats_users_count.rb
decidim-core-0.23.1.rc1 app/queries/decidim/stats_users_count.rb
decidim-core-0.23.0 app/queries/decidim/stats_users_count.rb
decidim-core-0.22.0 app/queries/decidim/stats_users_count.rb
decidim-core-0.21.0 app/queries/decidim/stats_users_count.rb
decidim-core-0.20.1 app/queries/decidim/stats_users_count.rb
decidim-core-0.20.0 app/queries/decidim/stats_users_count.rb
decidim-core-0.19.1 app/queries/decidim/stats_users_count.rb
decidim-core-0.18.1 app/queries/decidim/stats_users_count.rb