annotate .svn/pristine/2f/2fb6efca6ea9d063a58d2593af2f43422f15665e.svn-base @ 1295:622f24f53b42 redmine-2.3

Update to Redmine SVN revision 11972 on 2.3-stable branch
author Chris Cannam
date Fri, 14 Jun 2013 09:02:21 +0100
parents
children
rev   line source
Chris@1295 1 module ActiveRecord
Chris@1295 2 module Acts #:nodoc:
Chris@1295 3 module List #:nodoc:
Chris@1295 4 def self.included(base)
Chris@1295 5 base.extend(ClassMethods)
Chris@1295 6 end
Chris@1295 7
Chris@1295 8 # This +acts_as+ extension provides the capabilities for sorting and reordering a number of objects in a list.
Chris@1295 9 # The class that has this specified needs to have a +position+ column defined as an integer on
Chris@1295 10 # the mapped database table.
Chris@1295 11 #
Chris@1295 12 # Todo list example:
Chris@1295 13 #
Chris@1295 14 # class TodoList < ActiveRecord::Base
Chris@1295 15 # has_many :todo_items, :order => "position"
Chris@1295 16 # end
Chris@1295 17 #
Chris@1295 18 # class TodoItem < ActiveRecord::Base
Chris@1295 19 # belongs_to :todo_list
Chris@1295 20 # acts_as_list :scope => :todo_list
Chris@1295 21 # end
Chris@1295 22 #
Chris@1295 23 # todo_list.first.move_to_bottom
Chris@1295 24 # todo_list.last.move_higher
Chris@1295 25 module ClassMethods
Chris@1295 26 # Configuration options are:
Chris@1295 27 #
Chris@1295 28 # * +column+ - specifies the column name to use for keeping the position integer (default: +position+)
Chris@1295 29 # * +scope+ - restricts what is to be considered a list. Given a symbol, it'll attach <tt>_id</tt>
Chris@1295 30 # (if it hasn't already been added) and use that as the foreign key restriction. It's also possible
Chris@1295 31 # to give it an entire string that is interpolated if you need a tighter scope than just a foreign key.
Chris@1295 32 # Example: <tt>acts_as_list :scope => 'todo_list_id = #{todo_list_id} AND completed = 0'</tt>
Chris@1295 33 def acts_as_list(options = {})
Chris@1295 34 configuration = { :column => "position", :scope => "1 = 1" }
Chris@1295 35 configuration.update(options) if options.is_a?(Hash)
Chris@1295 36
Chris@1295 37 configuration[:scope] = "#{configuration[:scope]}_id".intern if configuration[:scope].is_a?(Symbol) && configuration[:scope].to_s !~ /_id$/
Chris@1295 38
Chris@1295 39 if configuration[:scope].is_a?(Symbol)
Chris@1295 40 scope_condition_method = %(
Chris@1295 41 def scope_condition
Chris@1295 42 if #{configuration[:scope].to_s}.nil?
Chris@1295 43 "#{configuration[:scope].to_s} IS NULL"
Chris@1295 44 else
Chris@1295 45 "#{configuration[:scope].to_s} = \#{#{configuration[:scope].to_s}}"
Chris@1295 46 end
Chris@1295 47 end
Chris@1295 48 )
Chris@1295 49 else
Chris@1295 50 scope_condition_method = "def scope_condition() \"#{configuration[:scope]}\" end"
Chris@1295 51 end
Chris@1295 52
Chris@1295 53 class_eval <<-EOV
Chris@1295 54 include ActiveRecord::Acts::List::InstanceMethods
Chris@1295 55
Chris@1295 56 def acts_as_list_class
Chris@1295 57 ::#{self.name}
Chris@1295 58 end
Chris@1295 59
Chris@1295 60 def position_column
Chris@1295 61 '#{configuration[:column]}'
Chris@1295 62 end
Chris@1295 63
Chris@1295 64 #{scope_condition_method}
Chris@1295 65
Chris@1295 66 before_destroy :remove_from_list
Chris@1295 67 before_create :add_to_list_bottom
Chris@1295 68 EOV
Chris@1295 69 end
Chris@1295 70 end
Chris@1295 71
Chris@1295 72 # All the methods available to a record that has had <tt>acts_as_list</tt> specified. Each method works
Chris@1295 73 # by assuming the object to be the item in the list, so <tt>chapter.move_lower</tt> would move that chapter
Chris@1295 74 # lower in the list of all chapters. Likewise, <tt>chapter.first?</tt> would return +true+ if that chapter is
Chris@1295 75 # the first in the list of all chapters.
Chris@1295 76 module InstanceMethods
Chris@1295 77 # Insert the item at the given position (defaults to the top position of 1).
Chris@1295 78 def insert_at(position = 1)
Chris@1295 79 insert_at_position(position)
Chris@1295 80 end
Chris@1295 81
Chris@1295 82 # Swap positions with the next lower item, if one exists.
Chris@1295 83 def move_lower
Chris@1295 84 return unless lower_item
Chris@1295 85
Chris@1295 86 acts_as_list_class.transaction do
Chris@1295 87 lower_item.decrement_position
Chris@1295 88 increment_position
Chris@1295 89 end
Chris@1295 90 end
Chris@1295 91
Chris@1295 92 # Swap positions with the next higher item, if one exists.
Chris@1295 93 def move_higher
Chris@1295 94 return unless higher_item
Chris@1295 95
Chris@1295 96 acts_as_list_class.transaction do
Chris@1295 97 higher_item.increment_position
Chris@1295 98 decrement_position
Chris@1295 99 end
Chris@1295 100 end
Chris@1295 101
Chris@1295 102 # Move to the bottom of the list. If the item is already in the list, the items below it have their
Chris@1295 103 # position adjusted accordingly.
Chris@1295 104 def move_to_bottom
Chris@1295 105 return unless in_list?
Chris@1295 106 acts_as_list_class.transaction do
Chris@1295 107 decrement_positions_on_lower_items
Chris@1295 108 assume_bottom_position
Chris@1295 109 end
Chris@1295 110 end
Chris@1295 111
Chris@1295 112 # Move to the top of the list. If the item is already in the list, the items above it have their
Chris@1295 113 # position adjusted accordingly.
Chris@1295 114 def move_to_top
Chris@1295 115 return unless in_list?
Chris@1295 116 acts_as_list_class.transaction do
Chris@1295 117 increment_positions_on_higher_items
Chris@1295 118 assume_top_position
Chris@1295 119 end
Chris@1295 120 end
Chris@1295 121
Chris@1295 122 # Move to the given position
Chris@1295 123 def move_to=(pos)
Chris@1295 124 case pos.to_s
Chris@1295 125 when 'highest'
Chris@1295 126 move_to_top
Chris@1295 127 when 'higher'
Chris@1295 128 move_higher
Chris@1295 129 when 'lower'
Chris@1295 130 move_lower
Chris@1295 131 when 'lowest'
Chris@1295 132 move_to_bottom
Chris@1295 133 end
Chris@1295 134 reset_positions_in_list
Chris@1295 135 end
Chris@1295 136
Chris@1295 137 def reset_positions_in_list
Chris@1295 138 acts_as_list_class.where(scope_condition).reorder("#{position_column} ASC, id ASC").each_with_index do |item, i|
Chris@1295 139 unless item.send(position_column) == (i + 1)
Chris@1295 140 acts_as_list_class.update_all({position_column => (i + 1)}, {:id => item.id})
Chris@1295 141 end
Chris@1295 142 end
Chris@1295 143 end
Chris@1295 144
Chris@1295 145 # Removes the item from the list.
Chris@1295 146 def remove_from_list
Chris@1295 147 if in_list?
Chris@1295 148 decrement_positions_on_lower_items
Chris@1295 149 update_attribute position_column, nil
Chris@1295 150 end
Chris@1295 151 end
Chris@1295 152
Chris@1295 153 # Increase the position of this item without adjusting the rest of the list.
Chris@1295 154 def increment_position
Chris@1295 155 return unless in_list?
Chris@1295 156 update_attribute position_column, self.send(position_column).to_i + 1
Chris@1295 157 end
Chris@1295 158
Chris@1295 159 # Decrease the position of this item without adjusting the rest of the list.
Chris@1295 160 def decrement_position
Chris@1295 161 return unless in_list?
Chris@1295 162 update_attribute position_column, self.send(position_column).to_i - 1
Chris@1295 163 end
Chris@1295 164
Chris@1295 165 # Return +true+ if this object is the first in the list.
Chris@1295 166 def first?
Chris@1295 167 return false unless in_list?
Chris@1295 168 self.send(position_column) == 1
Chris@1295 169 end
Chris@1295 170
Chris@1295 171 # Return +true+ if this object is the last in the list.
Chris@1295 172 def last?
Chris@1295 173 return false unless in_list?
Chris@1295 174 self.send(position_column) == bottom_position_in_list
Chris@1295 175 end
Chris@1295 176
Chris@1295 177 # Return the next higher item in the list.
Chris@1295 178 def higher_item
Chris@1295 179 return nil unless in_list?
Chris@1295 180 acts_as_list_class.find(:first, :conditions =>
Chris@1295 181 "#{scope_condition} AND #{position_column} = #{(send(position_column).to_i - 1).to_s}"
Chris@1295 182 )
Chris@1295 183 end
Chris@1295 184
Chris@1295 185 # Return the next lower item in the list.
Chris@1295 186 def lower_item
Chris@1295 187 return nil unless in_list?
Chris@1295 188 acts_as_list_class.find(:first, :conditions =>
Chris@1295 189 "#{scope_condition} AND #{position_column} = #{(send(position_column).to_i + 1).to_s}"
Chris@1295 190 )
Chris@1295 191 end
Chris@1295 192
Chris@1295 193 # Test if this record is in a list
Chris@1295 194 def in_list?
Chris@1295 195 !send(position_column).nil?
Chris@1295 196 end
Chris@1295 197
Chris@1295 198 private
Chris@1295 199 def add_to_list_top
Chris@1295 200 increment_positions_on_all_items
Chris@1295 201 end
Chris@1295 202
Chris@1295 203 def add_to_list_bottom
Chris@1295 204 self[position_column] = bottom_position_in_list.to_i + 1
Chris@1295 205 end
Chris@1295 206
Chris@1295 207 # Overwrite this method to define the scope of the list changes
Chris@1295 208 def scope_condition() "1" end
Chris@1295 209
Chris@1295 210 # Returns the bottom position number in the list.
Chris@1295 211 # bottom_position_in_list # => 2
Chris@1295 212 def bottom_position_in_list(except = nil)
Chris@1295 213 item = bottom_item(except)
Chris@1295 214 item ? item.send(position_column) : 0
Chris@1295 215 end
Chris@1295 216
Chris@1295 217 # Returns the bottom item
Chris@1295 218 def bottom_item(except = nil)
Chris@1295 219 conditions = scope_condition
Chris@1295 220 conditions = "#{conditions} AND #{self.class.primary_key} != #{except.id}" if except
Chris@1295 221 acts_as_list_class.where(conditions).reorder("#{position_column} DESC").first
Chris@1295 222 end
Chris@1295 223
Chris@1295 224 # Forces item to assume the bottom position in the list.
Chris@1295 225 def assume_bottom_position
Chris@1295 226 update_attribute(position_column, bottom_position_in_list(self).to_i + 1)
Chris@1295 227 end
Chris@1295 228
Chris@1295 229 # Forces item to assume the top position in the list.
Chris@1295 230 def assume_top_position
Chris@1295 231 update_attribute(position_column, 1)
Chris@1295 232 end
Chris@1295 233
Chris@1295 234 # This has the effect of moving all the higher items up one.
Chris@1295 235 def decrement_positions_on_higher_items(position)
Chris@1295 236 acts_as_list_class.update_all(
Chris@1295 237 "#{position_column} = (#{position_column} - 1)", "#{scope_condition} AND #{position_column} <= #{position}"
Chris@1295 238 )
Chris@1295 239 end
Chris@1295 240
Chris@1295 241 # This has the effect of moving all the lower items up one.
Chris@1295 242 def decrement_positions_on_lower_items
Chris@1295 243 return unless in_list?
Chris@1295 244 acts_as_list_class.update_all(
Chris@1295 245 "#{position_column} = (#{position_column} - 1)", "#{scope_condition} AND #{position_column} > #{send(position_column).to_i}"
Chris@1295 246 )
Chris@1295 247 end
Chris@1295 248
Chris@1295 249 # This has the effect of moving all the higher items down one.
Chris@1295 250 def increment_positions_on_higher_items
Chris@1295 251 return unless in_list?
Chris@1295 252 acts_as_list_class.update_all(
Chris@1295 253 "#{position_column} = (#{position_column} + 1)", "#{scope_condition} AND #{position_column} < #{send(position_column).to_i}"
Chris@1295 254 )
Chris@1295 255 end
Chris@1295 256
Chris@1295 257 # This has the effect of moving all the lower items down one.
Chris@1295 258 def increment_positions_on_lower_items(position)
Chris@1295 259 acts_as_list_class.update_all(
Chris@1295 260 "#{position_column} = (#{position_column} + 1)", "#{scope_condition} AND #{position_column} >= #{position}"
Chris@1295 261 )
Chris@1295 262 end
Chris@1295 263
Chris@1295 264 # Increments position (<tt>position_column</tt>) of all items in the list.
Chris@1295 265 def increment_positions_on_all_items
Chris@1295 266 acts_as_list_class.update_all(
Chris@1295 267 "#{position_column} = (#{position_column} + 1)", "#{scope_condition}"
Chris@1295 268 )
Chris@1295 269 end
Chris@1295 270
Chris@1295 271 def insert_at_position(position)
Chris@1295 272 remove_from_list
Chris@1295 273 increment_positions_on_lower_items(position)
Chris@1295 274 self.update_attribute(position_column, position)
Chris@1295 275 end
Chris@1295 276 end
Chris@1295 277 end
Chris@1295 278 end
Chris@1295 279 end