Class: UserQuery

Inherits:
Query
  • Object
show all
Defined in:
app/models/user_query.rb

Overview

Redmine - project management software Copyright © 2006-2023 Jean-Philippe Lang

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software

Constant Summary

Constants inherited from Query

Query::VISIBILITY_PRIVATE, Query::VISIBILITY_PUBLIC, Query::VISIBILITY_ROLES

Instance Method Summary collapse

Methods inherited from Query

add_available_column, #add_available_filter, #add_filter, #add_filter_error, #add_filters, #add_short_filter, #all_projects, #all_projects_values, #as_params, #assigned_to_values, #author_values, #available_block_columns, #available_display_types, #available_filters, #available_filters_as_json, #available_inline_columns, #available_totalable_columns, #block_columns, #build_from_params, build_from_params, #column_names=, #columns, #css_classes, default, #default_display_type, #default_totalable_names, #delete_available_filter, #display_type, #display_type=, #editable_by?, #fixed_version_values, #group_by_column, #group_by_sort_order, #group_by_statement, #groupable_columns, #grouped?, #has_column?, #has_custom_field_column?, #has_default_columns?, #has_filter?, #inline_columns, #is_global?, #is_private?, #is_public?, #issue_custom_fields, #issue_statuses_values, #label_for, #operator_for, operators_labels, #principals, #project_custom_fields, #project_statement, #project_statuses_values, #project_values, #queried_table_name, #result_count_by_group, #sort_clause, #sort_criteria, #sort_criteria=, #sort_criteria_key, #sort_criteria_order, #sortable_columns, #statement, #subproject_values, #time_entry_custom_fields, #total_by_group_for, #total_for, #totalable_columns, #totalable_names, #totalable_names=, #totals, #totals_by_group, #trackers, #type_for, #users, #validate_query_filters, #value_for, #values_for, visible, #visible?, #watcher_values

Methods included from Redmine::SubclassFactory

included

Constructor Details

#initialize(attributes = nil, *args) ⇒ UserQuery

Returns a new instance of UserQuery.



36
37
38
39
 
# File 'app/models/user_query.rb', line 36

def initialize(attributes=nil, *args)
  super attributes
  self.filters ||= { 'status' => {operator: "=", values: [User::STATUS_ACTIVE]} }
end

Instance Method Details

#auth_sources_values ⇒ Object 



66
67
68
69
70
 
# File 'app/models/user_query.rb', line 66

def auth_sources_values
  AuthSource.order(name: :asc).to_a.map do |auth_source|
    [auth_source.name, auth_source.id]
  end
end

#available_columns ⇒ Object 



80
81
82
83
84
85
86
87
88
89
90
91
 
# File 'app/models/user_query.rb', line 80

def available_columns
  return @available_columns if @available_columns

  @available_columns = self.class.available_columns.dup
  if Setting.twofa?
    @available_columns << QueryColumn.new(:twofa_scheme, sortable: "#{User.table_name}.twofa_scheme")
  end
  @available_columns += user_custom_fields.visible.
                          map {|cf| QueryCustomFieldColumn.new(cf)}

  @available_columns
end

#base_scope ⇒ Object 



106
107
108
 
# File 'app/models/user_query.rb', line 106

def base_scope
  User.logged.where(statement).includes(:email_address)
end

#default_columns_names ⇒ Object 



98
99
100
 
# File 'app/models/user_query.rb', line 98

def default_columns_names
  @default_columns_names ||= [:login, :firstname, :lastname, :mail, :admin, :created_on, :last_login_on]
end

#default_sort_criteria ⇒ Object 



102
103
104
 
# File 'app/models/user_query.rb', line 102

def default_sort_criteria
  [['login', 'asc']]
end

#initialize_available_filters ⇒ Object 



41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
 
# File 'app/models/user_query.rb', line 41

def initialize_available_filters
  add_available_filter "status",
    type: :list, values: ->{ user_statuses_values }
  add_available_filter "auth_source_id",
    type: :list_optional, values: ->{ auth_sources_values }
  add_available_filter "is_member_of_group",
    type: :list_optional,
    values: ->{ Group.givable.visible.map {|g| [g.name, g.id.to_s] } }
  if Setting.twofa?
    add_available_filter "twofa_scheme",
      type: :list_optional,
      values: ->{ Redmine::Twofa.available_schemes.map {|s| [I18n.t("twofa__#{s}__name"), s] } }
  end
  add_available_filter "login", type: :string
  add_available_filter "firstname", type: :string
  add_available_filter "lastname", type: :string
  add_available_filter "mail", type: :string
  add_available_filter "created_on", type: :date_past
  add_available_filter "last_login_on", type: :date_past
  add_available_filter "admin",
    type: :list,
    values: [[l(:general_text_yes), '1'], [l(:general_text_no), '0']]
  add_custom_fields_filters(user_custom_fields)
end

#joins_for_order_statement(order_options) ⇒ Object 



157
158
159
160
161
162
163
164
165
166
167
 
# File 'app/models/user_query.rb', line 157

def joins_for_order_statement(order_options)
  joins = [super]

  if order_options
    if order_options.include?('auth_source')
      joins << "LEFT OUTER JOIN #{AuthSource.table_name} auth_sources ON auth_sources.id = #{queried_table_name}.auth_source_id"
    end
  end

  joins.any? ? joins.join(' ') : nil
end

#results_scope(options = {}) ⇒ Object 



110
111
112
113
114
115
116
 
# File 'app/models/user_query.rb', line 110

def results_scope(options={})
  order_option = [group_by_sort_order, (options[:order] || sort_clause)].flatten.reject(&:blank?)

  base_scope.
    order(order_option).
    joins(joins_for_order_statement(order_option.join(',')))
end

#sql_for_admin_field(field, operator, value) ⇒ Object 



118
119
120
121
122
123
124
125
126
127
128
129
 
# File 'app/models/user_query.rb', line 118

def sql_for_admin_field(field, operator, value)
  return unless value = value.first

  true_value = operator == '=' ? '1' : '0'
  val =
    if value.to_s == true_value
      self.class.connection.quoted_true
    else
      self.class.connection.quoted_false
    end
  "(#{User.table_name}.admin = #{val})"
end

#sql_for_is_member_of_group_field(field, operator, value) ⇒ Object 



131
132
133
134
135
136
137
138
139
 
# File 'app/models/user_query.rb', line 131

def sql_for_is_member_of_group_field(field, operator, value)
  if ["*", "!*"].include? operator
    value = Group.givable.map(&:id)
  end

  e = operator.start_with?("!") ? "NOT EXISTS" : "EXISTS"

  "(#{e} (SELECT 1 FROM groups_users WHERE #{User.table_name}.id = groups_users.user_id AND #{sql_for_field(field, '=', value, 'groups_users', 'group_id')}))"
end

#sql_for_mail_field(field, operator, value) ⇒ Object 



141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
 
# File 'app/models/user_query.rb', line 141

def sql_for_mail_field(field, operator, value)
  if operator == '!*'
    match = false
    operator = '*'
  else
    match = true
  end
  emails = EmailAddress.table_name
  <<-SQL
    #{match ? 'EXISTS' : 'NOT EXISTS'}
    (SELECT 1 FROM #{emails} WHERE
      #{emails}.user_id = #{User.table_name}.id AND
      #{sql_for_field(:mail, operator, value, emails, 'address')})
  SQL
end

#user_custom_fields ⇒ Object

Returns a scope of user custom fields that are available as columns or filters



94
95
96
 
# File 'app/models/user_query.rb', line 94

def user_custom_fields
  UserCustomField.sorted
end

#user_statuses_values ⇒ Object 



72
73
74
75
76
77
78
 
# File 'app/models/user_query.rb', line 72

def user_statuses_values
  [
    [l(:status_active), User::STATUS_ACTIVE.to_s],
    [l(:status_registered), User::STATUS_REGISTERED.to_s],
    [l(:status_locked), User::STATUS_LOCKED.to_s]
  ]
end