Chris@1296: module ActiveRecord
Chris@1296:   module Acts #:nodoc:
Chris@1296:     module List #:nodoc:
Chris@1296:       def self.included(base)
Chris@1296:         base.extend(ClassMethods)
Chris@1296:       end
Chris@1296: 
Chris@1296:       # This +acts_as+ extension provides the capabilities for sorting and reordering a number of objects in a list.
Chris@1296:       # The class that has this specified needs to have a +position+ column defined as an integer on
Chris@1296:       # the mapped database table.
Chris@1296:       #
Chris@1296:       # Todo list example:
Chris@1296:       #
Chris@1296:       #   class TodoList < ActiveRecord::Base
Chris@1296:       #     has_many :todo_items, :order => "position"
Chris@1296:       #   end
Chris@1296:       #
Chris@1296:       #   class TodoItem < ActiveRecord::Base
Chris@1296:       #     belongs_to :todo_list
Chris@1296:       #     acts_as_list :scope => :todo_list
Chris@1296:       #   end
Chris@1296:       #
Chris@1296:       #   todo_list.first.move_to_bottom
Chris@1296:       #   todo_list.last.move_higher
Chris@1296:       module ClassMethods
Chris@1296:         # Configuration options are:
Chris@1296:         #
Chris@1296:         # * +column+ - specifies the column name to use for keeping the position integer (default: +position+)
Chris@1296:         # * +scope+ - restricts what is to be considered a list. Given a symbol, it'll attach <tt>_id</tt> 
Chris@1296:         #   (if it hasn't already been added) and use that as the foreign key restriction. It's also possible 
Chris@1296:         #   to give it an entire string that is interpolated if you need a tighter scope than just a foreign key.
Chris@1296:         #   Example: <tt>acts_as_list :scope => 'todo_list_id = #{todo_list_id} AND completed = 0'</tt>
Chris@1296:         def acts_as_list(options = {})
Chris@1296:           configuration = { :column => "position", :scope => "1 = 1" }
Chris@1296:           configuration.update(options) if options.is_a?(Hash)
Chris@1296: 
Chris@1296:           configuration[:scope] = "#{configuration[:scope]}_id".intern if configuration[:scope].is_a?(Symbol) && configuration[:scope].to_s !~ /_id$/
Chris@1296: 
Chris@1296:           if configuration[:scope].is_a?(Symbol)
Chris@1296:             scope_condition_method = %(
Chris@1296:               def scope_condition
Chris@1296:                 if #{configuration[:scope].to_s}.nil?
Chris@1296:                   "#{configuration[:scope].to_s} IS NULL"
Chris@1296:                 else
Chris@1296:                   "#{configuration[:scope].to_s} = \#{#{configuration[:scope].to_s}}"
Chris@1296:                 end
Chris@1296:               end
Chris@1296:             )
Chris@1296:           else
Chris@1296:             scope_condition_method = "def scope_condition() \"#{configuration[:scope]}\" end"
Chris@1296:           end
Chris@1296: 
Chris@1296:           class_eval <<-EOV
Chris@1296:             include ActiveRecord::Acts::List::InstanceMethods
Chris@1296: 
Chris@1296:             def acts_as_list_class
Chris@1296:               ::#{self.name}
Chris@1296:             end
Chris@1296: 
Chris@1296:             def position_column
Chris@1296:               '#{configuration[:column]}'
Chris@1296:             end
Chris@1296: 
Chris@1296:             #{scope_condition_method}
Chris@1296: 
Chris@1296:             before_destroy :remove_from_list
Chris@1296:             before_create  :add_to_list_bottom
Chris@1296:           EOV
Chris@1296:         end
Chris@1296:       end
Chris@1296: 
Chris@1296:       # All the methods available to a record that has had <tt>acts_as_list</tt> specified. Each method works
Chris@1296:       # by assuming the object to be the item in the list, so <tt>chapter.move_lower</tt> would move that chapter
Chris@1296:       # lower in the list of all chapters. Likewise, <tt>chapter.first?</tt> would return +true+ if that chapter is
Chris@1296:       # the first in the list of all chapters.
Chris@1296:       module InstanceMethods
Chris@1296:         # Insert the item at the given position (defaults to the top position of 1).
Chris@1296:         def insert_at(position = 1)
Chris@1296:           insert_at_position(position)
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Swap positions with the next lower item, if one exists.
Chris@1296:         def move_lower
Chris@1296:           return unless lower_item
Chris@1296: 
Chris@1296:           acts_as_list_class.transaction do
Chris@1296:             lower_item.decrement_position
Chris@1296:             increment_position
Chris@1296:           end
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Swap positions with the next higher item, if one exists.
Chris@1296:         def move_higher
Chris@1296:           return unless higher_item
Chris@1296: 
Chris@1296:           acts_as_list_class.transaction do
Chris@1296:             higher_item.increment_position
Chris@1296:             decrement_position
Chris@1296:           end
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Move to the bottom of the list. If the item is already in the list, the items below it have their
Chris@1296:         # position adjusted accordingly.
Chris@1296:         def move_to_bottom
Chris@1296:           return unless in_list?
Chris@1296:           acts_as_list_class.transaction do
Chris@1296:             decrement_positions_on_lower_items
Chris@1296:             assume_bottom_position
Chris@1296:           end
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Move to the top of the list. If the item is already in the list, the items above it have their
Chris@1296:         # position adjusted accordingly.
Chris@1296:         def move_to_top
Chris@1296:           return unless in_list?
Chris@1296:           acts_as_list_class.transaction do
Chris@1296:             increment_positions_on_higher_items
Chris@1296:             assume_top_position
Chris@1296:           end
Chris@1296:         end
Chris@1296:         
Chris@1296:         # Move to the given position
Chris@1296:         def move_to=(pos)
Chris@1296:           case pos.to_s
Chris@1296:           when 'highest'
Chris@1296:             move_to_top
Chris@1296:           when 'higher'
Chris@1296:             move_higher
Chris@1296:           when 'lower'
Chris@1296:             move_lower
Chris@1296:           when 'lowest'
Chris@1296:             move_to_bottom
Chris@1296:           end
Chris@1296:           reset_positions_in_list
Chris@1296:         end
Chris@1296: 
Chris@1296:         def reset_positions_in_list
Chris@1296:           acts_as_list_class.where(scope_condition).reorder("#{position_column} ASC, id ASC").each_with_index do |item, i|
Chris@1296:             unless item.send(position_column) == (i + 1)
Chris@1296:               acts_as_list_class.update_all({position_column => (i + 1)}, {:id => item.id})
Chris@1296:             end
Chris@1296:           end
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Removes the item from the list.
Chris@1296:         def remove_from_list
Chris@1296:           if in_list?
Chris@1296:             decrement_positions_on_lower_items
Chris@1296:             update_attribute position_column, nil
Chris@1296:           end
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Increase the position of this item without adjusting the rest of the list.
Chris@1296:         def increment_position
Chris@1296:           return unless in_list?
Chris@1296:           update_attribute position_column, self.send(position_column).to_i + 1
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Decrease the position of this item without adjusting the rest of the list.
Chris@1296:         def decrement_position
Chris@1296:           return unless in_list?
Chris@1296:           update_attribute position_column, self.send(position_column).to_i - 1
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Return +true+ if this object is the first in the list.
Chris@1296:         def first?
Chris@1296:           return false unless in_list?
Chris@1296:           self.send(position_column) == 1
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Return +true+ if this object is the last in the list.
Chris@1296:         def last?
Chris@1296:           return false unless in_list?
Chris@1296:           self.send(position_column) == bottom_position_in_list
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Return the next higher item in the list.
Chris@1296:         def higher_item
Chris@1296:           return nil unless in_list?
Chris@1296:           acts_as_list_class.find(:first, :conditions =>
Chris@1296:             "#{scope_condition} AND #{position_column} = #{(send(position_column).to_i - 1).to_s}"
Chris@1296:           )
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Return the next lower item in the list.
Chris@1296:         def lower_item
Chris@1296:           return nil unless in_list?
Chris@1296:           acts_as_list_class.find(:first, :conditions =>
Chris@1296:             "#{scope_condition} AND #{position_column} = #{(send(position_column).to_i + 1).to_s}"
Chris@1296:           )
Chris@1296:         end
Chris@1296: 
Chris@1296:         # Test if this record is in a list
Chris@1296:         def in_list?
Chris@1296:           !send(position_column).nil?
Chris@1296:         end
Chris@1296: 
Chris@1296:         private
Chris@1296:           def add_to_list_top
Chris@1296:             increment_positions_on_all_items
Chris@1296:           end
Chris@1296: 
Chris@1296:           def add_to_list_bottom
Chris@1296:             self[position_column] = bottom_position_in_list.to_i + 1
Chris@1296:           end
Chris@1296: 
Chris@1296:           # Overwrite this method to define the scope of the list changes
Chris@1296:           def scope_condition() "1" end
Chris@1296: 
Chris@1296:           # Returns the bottom position number in the list.
Chris@1296:           #   bottom_position_in_list    # => 2
Chris@1296:           def bottom_position_in_list(except = nil)
Chris@1296:             item = bottom_item(except)
Chris@1296:             item ? item.send(position_column) : 0
Chris@1296:           end
Chris@1296: 
Chris@1296:           # Returns the bottom item
Chris@1296:           def bottom_item(except = nil)
Chris@1296:             conditions = scope_condition
Chris@1296:             conditions = "#{conditions} AND #{self.class.primary_key} != #{except.id}" if except
Chris@1296:             acts_as_list_class.where(conditions).reorder("#{position_column} DESC").first
Chris@1296:           end
Chris@1296: 
Chris@1296:           # Forces item to assume the bottom position in the list.
Chris@1296:           def assume_bottom_position
Chris@1296:             update_attribute(position_column, bottom_position_in_list(self).to_i + 1)
Chris@1296:           end
Chris@1296: 
Chris@1296:           # Forces item to assume the top position in the list.
Chris@1296:           def assume_top_position
Chris@1296:             update_attribute(position_column, 1)
Chris@1296:           end
Chris@1296: 
Chris@1296:           # This has the effect of moving all the higher items up one.
Chris@1296:           def decrement_positions_on_higher_items(position)
Chris@1296:             acts_as_list_class.update_all(
Chris@1296:               "#{position_column} = (#{position_column} - 1)", "#{scope_condition} AND #{position_column} <= #{position}"
Chris@1296:             )
Chris@1296:           end
Chris@1296: 
Chris@1296:           # This has the effect of moving all the lower items up one.
Chris@1296:           def decrement_positions_on_lower_items
Chris@1296:             return unless in_list?
Chris@1296:             acts_as_list_class.update_all(
Chris@1296:               "#{position_column} = (#{position_column} - 1)", "#{scope_condition} AND #{position_column} > #{send(position_column).to_i}"
Chris@1296:             )
Chris@1296:           end
Chris@1296: 
Chris@1296:           # This has the effect of moving all the higher items down one.
Chris@1296:           def increment_positions_on_higher_items
Chris@1296:             return unless in_list?
Chris@1296:             acts_as_list_class.update_all(
Chris@1296:               "#{position_column} = (#{position_column} + 1)", "#{scope_condition} AND #{position_column} < #{send(position_column).to_i}"
Chris@1296:             )
Chris@1296:           end
Chris@1296: 
Chris@1296:           # This has the effect of moving all the lower items down one.
Chris@1296:           def increment_positions_on_lower_items(position)
Chris@1296:             acts_as_list_class.update_all(
Chris@1296:               "#{position_column} = (#{position_column} + 1)", "#{scope_condition} AND #{position_column} >= #{position}"
Chris@1296:            )
Chris@1296:           end
Chris@1296: 
Chris@1296:           # Increments position (<tt>position_column</tt>) of all items in the list.
Chris@1296:           def increment_positions_on_all_items
Chris@1296:             acts_as_list_class.update_all(
Chris@1296:               "#{position_column} = (#{position_column} + 1)",  "#{scope_condition}"
Chris@1296:             )
Chris@1296:           end
Chris@1296: 
Chris@1296:           def insert_at_position(position)
Chris@1296:             remove_from_list
Chris@1296:             increment_positions_on_lower_items(position)
Chris@1296:             self.update_attribute(position_column, position)
Chris@1296:           end
Chris@1296:       end 
Chris@1296:     end
Chris@1296:   end
Chris@1296: end