jro_apps/redmine Files · app/models/workflow_transition.rb

Merged r10733 from trunk (#12232, #12235)...

Merged r10733 from trunk (#12232, #12235) German translation for 2.1-stable updated by Daniel Felix. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/branches/2.1-stable@10738 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r9794:d7b669e50b1c


                r10523:6550343cb994

Download file

             workflow_transition.rb
        
                    39 lines
            
             | 1.5 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / app / models / workflow_transition.rb
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      # Redmine - project management software

      # Copyright (C) 2006-2012  Jean-Philippe Lang

      #

      # This program is free software; you can redistribute it and/or

      # modify it under the terms of the GNU General Public License

      # as published by the Free Software Foundation; either version 2

      # of the License, or (at your option) any later version.

      #

      # This program is distributed in the hope that it will be useful,

      # but WITHOUT ANY WARRANTY; without even the implied warranty of

      # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

      # GNU General Public License for more details.

      #

      # You should have received a copy of the GNU General Public License

      # along with this program; if not, write to the Free Software

      # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

      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.all

          trackers = Tracker.sorted.all

          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

      end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				# Redmine - project management software
				# Copyright (C) 2006-2012 Jean-Philippe Lang
				#
				# This program is free software; you can redistribute it and/or
				# modify it under the terms of the GNU General Public License
				# as published by the Free Software Foundation; either version 2
				# of the License, or (at your option) any later version.
				#
				# This program is distributed in the hope that it will be useful,
				# but WITHOUT ANY WARRANTY; without even the implied warranty of
				# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
				# GNU General Public License for more details.
				#
				# You should have received a copy of the GNU General Public License
				# along with this program; if not, write to the Free Software
				# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

				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.all
				trackers = Tracker.sorted.all

				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
				end