diff options
| author | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2014-12-13 16:55:28 +0000 |
|---|---|---|
| committer | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2014-12-13 16:55:28 +0000 |
| commit | f731545c619b6e6a641d40f944e45f99aff8185e (patch) | |
| tree | 5196cbe7aacebce0c87f3a5672733859d44f1765 /app/models/workflow_transition.rb | |
| parent | e52ecb494b00a3e3e98778ac967e71734e15d733 (diff) | |
| download | redmine-f731545c619b6e6a641d40f944e45f99aff8185e.tar.gz redmine-f731545c619b6e6a641d40f944e45f99aff8185e.zip | |
Use a simple count query.
git-svn-id: http://svn.redmine.org/redmine/trunk@13750 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'app/models/workflow_transition.rb')
| -rw-r--r-- | app/models/workflow_transition.rb | 17 |
1 files changed, 0 insertions, 17 deletions
diff --git a/app/models/workflow_transition.rb b/app/models/workflow_transition.rb index 99c399644..d76916092 100644 --- a/app/models/workflow_transition.rb +++ b/app/models/workflow_transition.rb @@ -18,23 +18,6 @@ class WorkflowTransition < WorkflowRule validates_presence_of :new_status - # Returns workflow transitions count by tracker and role - def self.count_by_tracker_and_role - counts = connection.select_all("SELECT role_id, tracker_id, count(id) AS c FROM #{table_name} WHERE type = 'WorkflowTransition' GROUP BY role_id, tracker_id") - roles = Role.sorted.to_a.select(&:consider_workflow?) - trackers = Tracker.sorted - result = [] - trackers.each do |tracker| - t = [] - roles.each do |role| - row = counts.detect {|c| c['role_id'].to_s == role.id.to_s && c['tracker_id'].to_s == tracker.id.to_s} - t << [role, (row.nil? ? 0 : row['c'].to_i)] - end - result << [tracker, t] - end - result - end - def self.replace_transitions(trackers, roles, transitions) trackers = Array.wrap trackers roles = Array.wrap roles |