jro_apps/redmine Files · app/controllers/reports_controller.rb

added the ability to set the sort order for issue statuses...

added the ability to set the sort order for issue statuses git-svn-id: http://redmine.rubyforge.org/svn/trunk@205 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r202:fe22797d6927


                r202:fe22797d6927

Download file

             reports_controller.rb
        
                    167 lines
            
             | 7.2 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / app / controllers / reports_controller.rb
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Jean-Philippe Lang
    
Initial commit...

              r2
            
      # redMine - project management software

      # Copyright (C) 2006  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 ReportsController < ApplicationController

        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        layout 'base'

        before_filter :find_project, :authorize

        Jean-Philippe Lang
    
Initial commit...

              r2
            
        def issue_report

        Jean-Philippe Lang
    
added the ability to set the sort order for issue statuses...

              r202
            
          @statuses = IssueStatus.find(:all, :order => 'position')

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
          case params[:detail]

          when "tracker"

            @field = "tracker_id"

        Jean-Philippe Lang
    
replaced deprecated find_all calls...

              r123
            
            @rows = Tracker.find :all

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
            @data = issues_by_tracker

            @report_title = l(:field_tracker)

            render :template => "reports/issue_report_details"

          when "priority"

            @field = "priority_id"

            @rows = Enumeration::get_values('IPRI')

            @data = issues_by_priority

            @report_title = l(:field_priority)

            render :template => "reports/issue_report_details"   

          when "category"

            @field = "category_id"

            @rows = @project.issue_categories

            @data = issues_by_category

            @report_title = l(:field_category)

            render :template => "reports/issue_report_details"   

        Jean-Philippe Lang
    
issues report by author...

              r33
            
          when "author"

            @field = "author_id"

            @rows = @project.members.collect { |m| m.user }

            @data = issues_by_author

            @report_title = l(:field_author)

            render :template => "reports/issue_report_details"  

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
          else

        Jean-Philippe Lang
    
"queries" branch merged...

              r92
            
            @queries = @project.queries.find :all, :conditions => ["is_public=? or user_id=?", true, (logged_in_user ? logged_in_user.id : 0)]

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
            @trackers = Tracker.find(:all)

            @priorities = Enumeration::get_values('IPRI')

            @categories = @project.issue_categories

        Jean-Philippe Lang
    
issues report by author...

              r33
            
            @authors = @project.members.collect { |m| m.user }

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
            issues_by_tracker

            issues_by_priority

            issues_by_category

        Jean-Philippe Lang
    
issues report by author...

              r33
            
            issues_by_author

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
            render :template => "reports/issue_report"

          end

        end  

        Jean-Philippe Lang
    
git-svn-id: http://redmine.rubyforge.org/svn/trunk@51 e93f8b46-1217-0410-a6f0-8f06a7374b81

              r49
            
        def delays

          @trackers = Tracker.find(:all)

          if request.get?

            @selected_tracker_ids = @trackers.collect {|t| t.id.to_s }

          else

            @selected_tracker_ids = params[:tracker_ids].collect { |id| id.to_i.to_s } if params[:tracker_ids] and params[:tracker_ids].is_a? Array

          end

          @selected_tracker_ids ||= []    

          @raw = 

            ActiveRecord::Base.connection.select_all("SELECT datediff( a.created_on, b.created_on ) as delay, count(a.id) as total

            FROM issue_histories a, issue_histories b, issues i

            WHERE a.status_id =5

            AND a.issue_id = b.issue_id

            AND a.issue_id = i.id

            AND i.tracker_id in (#{@selected_tracker_ids.join(',')})

            AND b.id = (

            SELECT min( c.id )

            FROM issue_histories c

            WHERE b.issue_id = c.issue_id ) 

            GROUP BY delay") unless @selected_tracker_ids.empty?    

          @raw ||=[]

          @x_from = 0

          @x_to = 0

          @y_from = 0

          @y_to = 0

          @sum_total = 0

          @sum_delay = 0

          @raw.each do |r|

            @x_to = [r['delay'].to_i, @x_to].max

            @y_to = [r['total'].to_i, @y_to].max

            @sum_total = @sum_total + r['total'].to_i

            @sum_delay = @sum_delay + r['total'].to_i * r['delay'].to_i

          end    

        end

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
      private

        Jean-Philippe Lang
    
ActiveRecord::RecordNotFound exceptions handled more gracefully...

              r130
            
        # Find project of id params[:id]

        def find_project

          @project = Project.find(params[:id])		

        rescue ActiveRecord::RecordNotFound

          render_404

        end

        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        def issues_by_tracker

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
          @issues_by_tracker ||= 

              ActiveRecord::Base.connection.select_all("select    s.id as status_id, 

        Jean-Philippe Lang
    
Initial commit...

              r2
            
                                                        s.is_closed as closed, 

                                                        t.id as tracker_id,

                                                        count(i.id) as total 

                                                      from 

                                                        issues i, issue_statuses s, trackers t

                                                      where 

                                                        i.status_id=s.id 

                                                        and i.tracker_id=t.id

                                                        and i.project_id=#{@project.id}

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
                                                      group by s.id, s.is_closed, t.id")	

        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        end

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        def issues_by_priority    

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
          @issues_by_priority ||= 

        Jean-Philippe Lang
    
Initial commit...

              r2
            
            ActiveRecord::Base.connection.select_all("select    s.id as status_id, 

                                                        s.is_closed as closed, 

                                                        p.id as priority_id,

                                                        count(i.id) as total 

                                                      from 

                                                        issues i, issue_statuses s, enumerations p

                                                      where 

                                                        i.status_id=s.id 

                                                        and i.priority_id=p.id

                                                        and i.project_id=#{@project.id}

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
                                                      group by s.id, s.is_closed, p.id")	

        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        end

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        def issues_by_category   

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
          @issues_by_category ||= 

        Jean-Philippe Lang
    
Initial commit...

              r2
            
            ActiveRecord::Base.connection.select_all("select    s.id as status_id, 

                                                        s.is_closed as closed, 

                                                        c.id as category_id,

                                                        count(i.id) as total 

                                                      from 

                                                        issues i, issue_statuses s, issue_categories c

                                                      where 

                                                        i.status_id=s.id 

                                                        and i.category_id=c.id

                                                        and i.project_id=#{@project.id}

        Jean-Philippe Lang
    
issues reports improvements...

              r32
            
                                                      group by s.id, s.is_closed, c.id")	

        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        end

        Jean-Philippe Lang
    
issues report by author...

              r33
            
        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        def issues_by_author

        Jean-Philippe Lang
    
issues report by author...

              r33
            
          @issues_by_author ||= 

            ActiveRecord::Base.connection.select_all("select    s.id as status_id, 

                                                        s.is_closed as closed, 

                                                        a.id as author_id,

                                                        count(i.id) as total 

                                                      from 

                                                        issues i, issue_statuses s, users a

                                                      where 

                                                        i.status_id=s.id 

                                                        and i.author_id=a.id

                                                        and i.project_id=#{@project.id}

                                                      group by s.id, s.is_closed, a.id")	

        Jean-Philippe Lang
    
indentation corrections...

              r198
            
        end

        Jean-Philippe Lang
    
Initial commit...

              r2
            
      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

Jean-Philippe Lang Initial commit...	r2	# redMine - project management software
		# Copyright (C) 2006 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 ReportsController < ApplicationController
Jean-Philippe Lang indentation corrections...	r198	layout 'base'
		before_filter :find_project, :authorize

Jean-Philippe Lang Initial commit...	r2	def issue_report
Jean-Philippe Lang added the ability to set the sort order for issue statuses...	r202	@statuses = IssueStatus.find(:all, :order => 'position')
Jean-Philippe Lang issues reports improvements...	r32
		case params[:detail]
		when "tracker"
		@field = "tracker_id"
Jean-Philippe Lang replaced deprecated find_all calls...	r123	@rows = Tracker.find :all
Jean-Philippe Lang issues reports improvements...	r32	@data = issues_by_tracker
		@report_title = l(:field_tracker)
		render :template => "reports/issue_report_details"
		when "priority"
		@field = "priority_id"
		@rows = Enumeration::get_values('IPRI')
		@data = issues_by_priority
		@report_title = l(:field_priority)
		render :template => "reports/issue_report_details"
		when "category"
		@field = "category_id"
		@rows = @project.issue_categories
		@data = issues_by_category
		@report_title = l(:field_category)
		render :template => "reports/issue_report_details"
Jean-Philippe Lang issues report by author...	r33	when "author"
		@field = "author_id"
		@rows = @project.members.collect { \|m\| m.user }
		@data = issues_by_author
		@report_title = l(:field_author)
		render :template => "reports/issue_report_details"
Jean-Philippe Lang issues reports improvements...	r32	else
Jean-Philippe Lang "queries" branch merged...	r92	@queries = @project.queries.find :all, :conditions => ["is_public=? or user_id=?", true, (logged_in_user ? logged_in_user.id : 0)]
Jean-Philippe Lang issues reports improvements...	r32	@trackers = Tracker.find(:all)
		@priorities = Enumeration::get_values('IPRI')
		@categories = @project.issue_categories
Jean-Philippe Lang issues report by author...	r33	@authors = @project.members.collect { \|m\| m.user }
Jean-Philippe Lang issues reports improvements...	r32	issues_by_tracker
		issues_by_priority
		issues_by_category
Jean-Philippe Lang issues report by author...	r33	issues_by_author
Jean-Philippe Lang issues reports improvements...	r32	render :template => "reports/issue_report"
		end
		end

Jean-Philippe Lang git-svn-id: http://redmine.rubyforge.org/svn/trunk@51 e93f8b46-1217-0410-a6f0-8f06a7374b81	r49	def delays
		@trackers = Tracker.find(:all)
		if request.get?
		@selected_tracker_ids = @trackers.collect {\|t\| t.id.to_s }
		else
		@selected_tracker_ids = params[:tracker_ids].collect { \|id\| id.to_i.to_s } if params[:tracker_ids] and params[:tracker_ids].is_a? Array
		end
		@selected_tracker_ids \|\|= []
		@raw =
		ActiveRecord::Base.connection.select_all("SELECT datediff( a.created_on, b.created_on ) as delay, count(a.id) as total
		FROM issue_histories a, issue_histories b, issues i
		WHERE a.status_id =5
		AND a.issue_id = b.issue_id
		AND a.issue_id = i.id
		AND i.tracker_id in (#{@selected_tracker_ids.join(',')})
		AND b.id = (
		SELECT min( c.id )
		FROM issue_histories c
		WHERE b.issue_id = c.issue_id )
		GROUP BY delay") unless @selected_tracker_ids.empty?
		@raw \|\|=[]

		@x_from = 0
		@x_to = 0
		@y_from = 0
		@y_to = 0
		@sum_total = 0
		@sum_delay = 0
		@raw.each do \|r\|
		@x_to = [r['delay'].to_i, @x_to].max
		@y_to = [r['total'].to_i, @y_to].max
		@sum_total = @sum_total + r['total'].to_i
		@sum_delay = @sum_delay + r['total'].to_i * r['delay'].to_i
		end
		end

Jean-Philippe Lang issues reports improvements...	r32	private
Jean-Philippe Lang ActiveRecord::RecordNotFound exceptions handled more gracefully...	r130	# Find project of id params[:id]
		def find_project
		@project = Project.find(params[:id])
		rescue ActiveRecord::RecordNotFound
		render_404
		end
Jean-Philippe Lang indentation corrections...	r198
		def issues_by_tracker
Jean-Philippe Lang issues reports improvements...	r32	@issues_by_tracker \|\|=
		ActiveRecord::Base.connection.select_all("select s.id as status_id,
Jean-Philippe Lang Initial commit...	r2	s.is_closed as closed,
		t.id as tracker_id,
		count(i.id) as total
		from
		issues i, issue_statuses s, trackers t
		where
		i.status_id=s.id
		and i.tracker_id=t.id
		and i.project_id=#{@project.id}
Jean-Philippe Lang issues reports improvements...	r32	group by s.id, s.is_closed, t.id")
Jean-Philippe Lang indentation corrections...	r198	end
Jean-Philippe Lang issues reports improvements...	r32
Jean-Philippe Lang indentation corrections...	r198	def issues_by_priority
Jean-Philippe Lang issues reports improvements...	r32	@issues_by_priority \|\|=
Jean-Philippe Lang Initial commit...	r2	ActiveRecord::Base.connection.select_all("select s.id as status_id,
		s.is_closed as closed,
		p.id as priority_id,
		count(i.id) as total
		from
		issues i, issue_statuses s, enumerations p
		where
		i.status_id=s.id
		and i.priority_id=p.id
		and i.project_id=#{@project.id}
Jean-Philippe Lang issues reports improvements...	r32	group by s.id, s.is_closed, p.id")
Jean-Philippe Lang indentation corrections...	r198	end
Jean-Philippe Lang issues reports improvements...	r32
Jean-Philippe Lang indentation corrections...	r198	def issues_by_category
Jean-Philippe Lang issues reports improvements...	r32	@issues_by_category \|\|=
Jean-Philippe Lang Initial commit...	r2	ActiveRecord::Base.connection.select_all("select s.id as status_id,
		s.is_closed as closed,
		c.id as category_id,
		count(i.id) as total
		from
		issues i, issue_statuses s, issue_categories c
		where
		i.status_id=s.id
		and i.category_id=c.id
		and i.project_id=#{@project.id}
Jean-Philippe Lang issues reports improvements...	r32	group by s.id, s.is_closed, c.id")
Jean-Philippe Lang indentation corrections...	r198	end
Jean-Philippe Lang issues report by author...	r33
Jean-Philippe Lang indentation corrections...	r198	def issues_by_author
Jean-Philippe Lang issues report by author...	r33	@issues_by_author \|\|=
		ActiveRecord::Base.connection.select_all("select s.id as status_id,
		s.is_closed as closed,
		a.id as author_id,
		count(i.id) as total
		from
		issues i, issue_statuses s, users a
		where
		i.status_id=s.id
		and i.author_id=a.id
		and i.project_id=#{@project.id}
		group by s.id, s.is_closed, a.id")
Jean-Philippe Lang indentation corrections...	r198	end
Jean-Philippe Lang Initial commit...	r2	end