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