@@ -1,123 +1,124 | |||
|
1 | 1 | # Redmine - project management software |
|
2 | 2 | # Copyright (C) 2006-2014 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 IssueStatus < ActiveRecord::Base |
|
19 | 19 | before_destroy :check_integrity |
|
20 | 20 | has_many :workflows, :class_name => 'WorkflowTransition', :foreign_key => "old_status_id" |
|
21 | 21 | acts_as_list |
|
22 | 22 | |
|
23 | 23 | after_update :handle_is_closed_change |
|
24 | 24 | before_destroy :delete_workflow_rules |
|
25 | 25 | after_save :update_default |
|
26 | 26 | |
|
27 | 27 | validates_presence_of :name |
|
28 | 28 | validates_uniqueness_of :name |
|
29 | 29 | validates_length_of :name, :maximum => 30 |
|
30 | 30 | validates_inclusion_of :default_done_ratio, :in => 0..100, :allow_nil => true |
|
31 | 31 | |
|
32 | 32 | scope :sorted, lambda { order("#{table_name}.position ASC") } |
|
33 | 33 | scope :named, lambda {|arg| where("LOWER(#{table_name}.name) = LOWER(?)", arg.to_s.strip)} |
|
34 | 34 | |
|
35 | 35 | def update_default |
|
36 | 36 | IssueStatus.where(['id <> ?', id]).update_all({:is_default => false}) if self.is_default? |
|
37 | 37 | end |
|
38 | 38 | |
|
39 | 39 | # Returns the default status for new issues |
|
40 | 40 | def self.default |
|
41 | 41 | where(:is_default => true).first |
|
42 | 42 | end |
|
43 | 43 | |
|
44 | 44 | # Update all the +Issues+ setting their done_ratio to the value of their +IssueStatus+ |
|
45 | 45 | def self.update_issue_done_ratios |
|
46 | 46 | if Issue.use_status_for_done_ratio? |
|
47 | 47 | IssueStatus.where("default_done_ratio >= 0").each do |status| |
|
48 | 48 | Issue.where({:status_id => status.id}).update_all({:done_ratio => status.default_done_ratio}) |
|
49 | 49 | end |
|
50 | 50 | end |
|
51 | 51 | |
|
52 | 52 | return Issue.use_status_for_done_ratio? |
|
53 | 53 | end |
|
54 | 54 | |
|
55 | 55 | # Returns an array of all statuses the given role can switch to |
|
56 | 56 | # Uses association cache when called more than one time |
|
57 | 57 | def new_statuses_allowed_to(roles, tracker, author=false, assignee=false) |
|
58 | 58 | if roles && tracker |
|
59 | 59 | role_ids = roles.collect(&:id) |
|
60 | 60 | transitions = workflows.select do |w| |
|
61 | 61 | role_ids.include?(w.role_id) && |
|
62 | 62 | w.tracker_id == tracker.id && |
|
63 | 63 | ((!w.author && !w.assignee) || (author && w.author) || (assignee && w.assignee)) |
|
64 | 64 | end |
|
65 | 65 | transitions.map(&:new_status).compact.sort |
|
66 | 66 | else |
|
67 | 67 | [] |
|
68 | 68 | end |
|
69 | 69 | end |
|
70 | 70 | |
|
71 | 71 | # Same thing as above but uses a database query |
|
72 | 72 | # More efficient than the previous method if called just once |
|
73 | 73 | def find_new_statuses_allowed_to(roles, tracker, author=false, assignee=false) |
|
74 | 74 | if roles.present? && tracker |
|
75 | 75 | conditions = "(author = :false AND assignee = :false)" |
|
76 | 76 | conditions << " OR author = :true" if author |
|
77 | 77 | conditions << " OR assignee = :true" if assignee |
|
78 | 78 | |
|
79 | 79 | workflows. |
|
80 | 80 | includes(:new_status). |
|
81 | 81 | where(["role_id IN (:role_ids) AND tracker_id = :tracker_id AND (#{conditions})", |
|
82 | 82 | {:role_ids => roles.collect(&:id), :tracker_id => tracker.id, :true => true, :false => false} |
|
83 | 83 | ]).all. |
|
84 | 84 | map(&:new_status).compact.sort |
|
85 | 85 | else |
|
86 | 86 | [] |
|
87 | 87 | end |
|
88 | 88 | end |
|
89 | 89 | |
|
90 | 90 | def <=>(status) |
|
91 | 91 | position <=> status.position |
|
92 | 92 | end |
|
93 | 93 | |
|
94 | 94 | def to_s; name end |
|
95 | 95 | |
|
96 | 96 | private |
|
97 | 97 | |
|
98 | 98 | # Updates issues closed_on attribute when an existing status is set as closed. |
|
99 | 99 | def handle_is_closed_change |
|
100 | 100 | if is_closed_changed? && is_closed == true |
|
101 | 101 | # First we update issues that have a journal for when the current status was set, |
|
102 | 102 | # a subselect is used to update all issues with a single query |
|
103 | 103 | subselect = "SELECT MAX(j.created_on) FROM #{Journal.table_name} j" + |
|
104 | 104 | " JOIN #{JournalDetail.table_name} d ON d.journal_id = j.id" + |
|
105 | 105 | " WHERE j.journalized_type = 'Issue' AND j.journalized_id = #{Issue.table_name}.id" + |
|
106 | 106 | " AND d.property = 'attr' AND d.prop_key = 'status_id' AND d.value = :status_id" |
|
107 |
Issue.where(:status_id => id, :closed_on => nil). |
|
|
107 | Issue.where(:status_id => id, :closed_on => nil). | |
|
108 | update_all(["closed_on = (#{subselect})", {:status_id => id.to_s}]) | |
|
108 | 109 | |
|
109 | 110 | # Then we update issues that don't have a journal which means the |
|
110 | 111 | # current status was set on creation |
|
111 | 112 | Issue.where(:status_id => id, :closed_on => nil).update_all("closed_on = created_on") |
|
112 | 113 | end |
|
113 | 114 | end |
|
114 | 115 | |
|
115 | 116 | def check_integrity |
|
116 | 117 | raise "Can't delete status" if Issue.where(:status_id => id).any? |
|
117 | 118 | end |
|
118 | 119 | |
|
119 | 120 | # Deletes associated workflows |
|
120 | 121 | def delete_workflow_rules |
|
121 | 122 | WorkflowRule.delete_all(["old_status_id = :id OR new_status_id = :id", {:id => id}]) |
|
122 | 123 | end |
|
123 | 124 | end |
General Comments 0
You need to be logged in to leave comments.
Login now