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 )



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
165
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 129

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) 


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

def caching_tag_list?
  column_names.include?(cached_tag_list_column_name)
end

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



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
238
 
# File 'lib/redmineup/acts_as_taggable/up_acts_as_taggable.rb', line 203

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 



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

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".



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

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



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

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 



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

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.



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

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