Module: Redmineup::ActsAsTaggable::Taggable::SingletonMethods

Defined in:
lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb

Instance Method Summary collapse

Instance Method Details

#available_tags(options = {}) ⇒ Object

Return all avalible tags for a project or global Example: Question.available_tags(:project => @project_id )



128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 128

def available_tags(options = {})
  projects = [[options[:project]], options[:projects]].flatten.compact
  limit = options[:limit].to_i.zero? ? 30 : options[:limit].to_i
  scope = Tag.where({})
  class_name = quote_string_value(base_class.name)
  join = []
  join << "JOIN #{Tagging.table_name} ON #{Tagging.table_name}.tag_id = #{Tag.table_name}.id "
  join << "JOIN #{table_name} ON #{table_name}.id = #{Tagging.table_name}.taggable_id
    AND #{Tagging.table_name}.taggable_type = #{class_name} "
  if attribute_names.include?('project_id') && projects.any?
    join << "JOIN #{Project.table_name} ON #{Project.table_name}.id = #{table_name}.project_id"
    scope = scope.where("#{table_name}.project_id IN (%s)", projects.map(&:id).join(','))
  end

  if options[:name_like]
    scope = scope.where("LOWER(#{Tag.table_name}.name) LIKE LOWER(?)", "%#{options[:name_like]}%")
  end

  group_fields = ''
  group_fields << ", #{Tag.table_name}.created_at" if Tag.respond_to?(:created_at)
  group_fields << ", #{Tag.table_name}.updated_at" if Tag.respond_to?(:updated_at)

  if base_class.respond_to?(:visible_condition)
    visible_condition = base_class.visible_condition(User.current)
    if visible_condition.include?('project_id') && join.all? { |jn| jn.exclude?('JOIN projects') }
      join << "JOIN #{Project.table_name} ON #{Project.table_name}.id = #{table_name}.project_id"
    end
    scope = scope.where(visible_condition)
  end
  scope = scope.joins(join.join(' '))
  scope = scope.select("#{Tag.table_name}.*, COUNT(DISTINCT #{Tagging.table_name}.taggable_id) AS count")
  scope = scope.group("#{Tag.table_name}.id, #{Tag.table_name}.name #{group_fields}")
  scope = scope.having('COUNT(*) > 0')
  scope = scope.order("#{Tag.table_name}.name")
  scope = scope.limit(limit)
  scope
end

#caching_tag_list? ⇒ Boolean

Returns:

  • (Boolean) 


295
296
297
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 295

def caching_tag_list?
  column_names.include?(cached_tag_list_column_name)
end

#find_options_for_find_tagged_with(tags, options = {}) ⇒ Object 



202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 202

def find_options_for_find_tagged_with(tags, options = {})
  tags = tags.is_a?(Array) ? TagList.new(tags.map(&:to_s)) : TagList.from(tags)
  options = options.dup

  return {} if tags.empty?

  conditions = []
  conditions << sanitize_sql(options.delete(:conditions)) if options[:conditions]

  taggings_alias, tags_alias = "#{table_name}_taggings", "#{table_name}_tags"

  joins = [
    "INNER JOIN #{Tagging.table_name} #{taggings_alias} ON #{taggings_alias}.taggable_id = #{table_name}.#{primary_key} AND #{taggings_alias}.taggable_type = #{quote_string_value(base_class.name)}",
    "INNER JOIN #{Tag.table_name} #{tags_alias} ON #{tags_alias}.id = #{taggings_alias}.tag_id"
  ]

  if options.delete(:exclude)
    conditions << <<-END
      #{table_name}.id NOT IN
        (SELECT #{Tagging.table_name}.taggable_id FROM #{Tagging.table_name}
         INNER JOIN #{Tag.table_name} ON #{Tagging.table_name}.tag_id = #{Tag.table_name}.id
         WHERE #{tags_condition(tags)} AND #{Tagging.table_name}.taggable_type = #{quote_string_value(base_class.name)})
    END
  else
    if options.delete(:match_all)
      joins << joins_for_match_all_tags(tags)
    else
      conditions << tags_condition(tags, tags_alias)
    end
  end

  { :select => "DISTINCT #{table_name}.* ",
    :joins => joins.join(" "),
    :conditions => conditions.join(" AND ")
  }.reverse_merge!(options)
end

#find_options_for_tag_counts(options = {}) ⇒ Object 



271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 271

def find_options_for_tag_counts(options = {})
  options = options.dup
  scope = scope_attributes
  # scope(:find)

  conditions = []
  conditions << send(:sanitize_sql_for_assignment, options.delete(:conditions)) if options[:conditions]
  conditions << send(:sanitize_sql_for_assignment, scope) if scope
  conditions << "#{Tagging.table_name}.taggable_type = #{quote_string_value(base_class.name)}"
  conditions << type_condition unless descends_from_active_record?
  conditions.delete('')
  conditions.compact!
  conditions = conditions.join(" AND ")

  joins = ["INNER JOIN #{table_name} ON #{table_name}.#{primary_key} = #{Tagging.table_name}.taggable_id"]
  joins << options.delete(:joins) if options[:joins].present?
  # joins << scope[:joins] if scope && scope[:joins].present?
  joins = joins.join(" ")

  options = { :conditions => conditions, :joins => joins }.update(options)

  Tag.options_for_counts(options)
end

#find_related_tags(tags, options = {}) ⇒ Object

Returns an array of related tags. Related tags are all the other tags that are found on the models tagged with the provided tags.

Pass either a tag, string, or an array of strings or tags.

Options:

:order - SQL Order how to order the tags. Defaults to "count DESC, tags.name".



172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 172

def find_related_tags(tags, options = {})
  tags = tags.is_a?(Array) ? TagList.new(tags.map(&:to_s)) : TagList.from(tags)

  related_models = find_tagged_with(tags)

  return [] if related_models.blank?

  related_ids = related_models.map{|c| c.id }.join(",")
  Tag.select(
    "#{Tag.table_name}.*, COUNT(#{Tag.table_name}.id) AS count").joins(
    "JOIN #{Tagging.table_name} ON #{Tagging.table_name}.taggable_type = '#{base_class.name}'
      AND  #{Tagging.table_name}.taggable_id IN (#{related_ids})
      AND  #{Tagging.table_name}.tag_id = #{Tag.table_name}.id").order(
    options[:order] || "count DESC, #{Tag.table_name}.name").group(
    "#{Tag.table_name}.id, #{Tag.table_name}.name HAVING #{Tag.table_name}.name NOT IN (#{tags.map { |n| quote_string_value(n) }.join(",")})")
end

#find_tagged_with(*args) ⇒ Object Also known as: tagged_with

Pass either a tag, string, or an array of strings or tags.

Options:

:exclude - Find models that are not tagged with the given tags
:match_all - Find models that match all of the given tags, not just one
:conditions - A piece of SQL conditions to add to the query



195
196
197
198
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 195

def find_tagged_with(*args)
  options = find_options_for_find_tagged_with(*args)
  options.blank? ? [] : select(options[:select]).where(options[:conditions]).joins(options[:joins]).order(options[:order]).to_a
end

#joins_for_match_all_tags(tags) ⇒ Object 



239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 239

def joins_for_match_all_tags(tags)
  joins = []

  tags.each_with_index do |tag, index|
    taggings_alias, tags_alias = "taggings_#{index}", "tags_#{index}"

    join = <<-END
      INNER JOIN #{Tagging.table_name} #{taggings_alias} ON
        #{taggings_alias}.taggable_id = #{table_name}.#{primary_key} AND
        #{taggings_alias}.taggable_type = #{quote_string_value(base_class.name)}

      INNER JOIN #{Tag.table_name} #{tags_alias} ON
        #{taggings_alias}.tag_id = #{tags_alias}.id AND
        #{tags_alias}.name = ?
    END

    joins << sanitize_sql([join, tag])
  end

  joins.join(' ')
end

#tag_counts(options = {}) ⇒ Object Also known as: all_tag_counts

Calculate the tag counts for all tags.

See Tag.counts for available options.



264
265
266
267
268
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 264

def tag_counts(options = {})
  # Tag.find(:all, find_options_for_tag_counts(options))
  opt = find_options_for_tag_counts(options)
  Tag.select(opt[:select]).where(opt[:conditions]).joins(opt[:joins]).group(opt[:group]).having(opt[:having]).order(opt[:order]).limit(options[:limit])
end