1  # Redmine - project management software
   2  # Copyright (C) 2006-2011  Jean-Philippe Lang
   3  #
   4  # This program is free software; you can redistribute it and/or
   5  # modify it under the terms of the GNU General Public License
   6  # as published by the Free Software Foundation; either version 2
   7  # of the License, or (at your option) any later version.
   8  #
   9  # This program is distributed in the hope that it will be useful,
  10  # but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  # GNU General Public License for more details.
  13  #
  14  # You should have received a copy of the GNU General Public License
  15  # along with this program; if not, write to the Free Software
  16  # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
  17 
  18  class Board < ActiveRecord::Base
  19    include Redmine::SafeAttributes
  20    belongs_to :project
  21    has_many :topics, :class_name => 'Message', :conditions => "#{Message.table_name}.parent_id IS NULL", :order => "#{Message.table_name}.created_on DESC"
  22    has_many :messages, :dependent => :destroy, :order => "#{Message.table_name}.created_on DESC"
  23    belongs_to :last_message, :class_name => 'Message', :foreign_key => :last_message_id
  24    acts_as_list :scope => :project_id
  25    acts_as_watchable
  26 
  27    validates_presence_of :name, :description
  28    validates_length_of :name, :maximum => 30
  29    validates_length_of :description, :maximum => 255
  30 
  31    named_scope :visible, lambda {|*args| { :include => :project,
  32                                            :conditions => Project.allowed_to_condition(args.shift || User.current, :view_messages, *args) } }
  33 
  34    safe_attributes 'name', 'description', 'move_to'
  35 
  36    def visible?(user=User.current)
  37      !user.nil? && user.allowed_to?(:view_messages, project)
  38    end
  39 
  40    def to_s
  41      name
  42    end
  43 
  44    def reset_counters!
  45      self.class.reset_counters!(id)
  46    end
  47 
  48    # Updates topics_count, messages_count and last_message_id attributes for +board_id+
  49    def self.reset_counters!(board_id)
  50      board_id = board_id.to_i
  51      update_all("topics_count = (SELECT COUNT(*) FROM #{Message.table_name} WHERE board_id=#{board_id} AND parent_id IS NULL)," +
  52                 " messages_count = (SELECT COUNT(*) FROM #{Message.table_name} WHERE board_id=#{board_id})," +
  53                 " last_message_id = (SELECT MAX(id) FROM #{Message.table_name} WHERE board_id=#{board_id})",
  54                 ["id = ?", board_id])
  55    end
  56  end