| @@ -1,43 +1,43 | |||
|
|
1 | 1 | # redMine - project management software |
|
|
2 | 2 | # Copyright (C) 2006 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 Workflow < ActiveRecord::Base |
|
|
19 | 19 | belongs_to :role |
|
|
20 | 20 | belongs_to :old_status, :class_name => 'IssueStatus', :foreign_key => 'old_status_id' |
|
|
21 | 21 | belongs_to :new_status, :class_name => 'IssueStatus', :foreign_key => 'new_status_id' |
|
|
22 | 22 | |
|
|
23 | 23 | validates_presence_of :role, :old_status, :new_status |
|
|
24 | 24 | |
|
|
25 | 25 | # Returns workflow transitions count by tracker and role |
|
|
26 | 26 | def self.count_by_tracker_and_role |
|
|
27 | 27 | counts = connection.select_all("SELECT role_id, tracker_id, count(id) AS c FROM #{Workflow.table_name} GROUP BY role_id, tracker_id") |
|
|
28 | 28 | roles = Role.find(:all, :order => 'builtin, position') |
|
|
29 | 29 | trackers = Tracker.find(:all, :order => 'position') |
|
|
30 | 30 | |
|
|
31 | 31 | result = [] |
|
|
32 | 32 | trackers.each do |tracker| |
|
|
33 | 33 | t = [] |
|
|
34 | 34 | roles.each do |role| |
|
|
35 | row = counts.detect {|c| c['role_id'] == role.id.to_s && c['tracker_id'] = tracker.id.to_s} | |
|
|
35 | row = counts.detect {|c| c['role_id'] == role.id.to_s && c['tracker_id'] == tracker.id.to_s} | |
|
|
36 | 36 | t << [role, (row.nil? ? 0 : row['c'].to_i)] |
|
|
37 | 37 | end |
|
|
38 | 38 | result << [tracker, t] |
|
|
39 | 39 | end |
|
|
40 | 40 | |
|
|
41 | 41 | result |
|
|
42 | 42 | end |
|
|
43 | 43 | end |
General Comments 0
You need to be logged in to leave comments.
Login now