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

Upgraded to Rails 2.3.4 (#3597)...

Upgraded to Rails 2.3.4 (#3597) * Ran the Rails upgrade * Upgraded to Rails Engines 2.3.2 * Added a plugin to let Engines override application views. * Converted tests to use the new classes: ** ActionController::TestCase for functional ** ActiveSupport::TestCase for units * Converted ActiveRecord::Error message to a string. * ActiveRecord grouping returns an ordered hash which doesn't have #sort! * Updated the I18n storage_units format. * Added some default initializers from a fresh rails app * Changed the order of check_box_tags and hidden_field_tags. The hidden tag needs to appear first in Rails 2.3, otherwise it will override any value in the check_box_tag. * Removed the custom handler for when the cookie store is tampered with. Rails 2.3 removed the TamperedWithCookie exception and instead Rails will not load the data from it when it's been tampered with (e.g. no user login). * Fixed mail layouts, 2.3 has problems with implicit multipart emails that use layouts. Also removed some custom Redmine mailer code. * Fixed a bug that occurred in tests where the "required" span tag would be added to the :field_status translation. This resulted in an email string of: <li>Status<span class="required"> *</span><span class="required"> *</span> Instead of: <li>Status: New</li> git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2887 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r2627:7dccf9fda6f3


                r2773:7b0cb6aba871

Download file

             queries_controller.rb
        
                    81 lines
            
             | 3.0 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / app / controllers / queries_controller.rb
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

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

              r92
            
      # redMine - project management software

        Jean-Philippe Lang
    
Added per user custom queries....

              r563
            
      # Copyright (C) 2006-2007  Jean-Philippe Lang

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

              r92
            
      #

      # 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 QueriesController < ApplicationController

        Jean-Philippe Lang
    
Highlight the current item of the main menu....

              r1062
            
        menu_item :issues

        Jean-Philippe Lang
    
Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....

              r1296
            
        before_filter :find_query, :except => :new

        Jean-Philippe Lang
    
Global queries can be saved from the global issue list (follows r1311 and closes #897)....

              r1297
            
        before_filter :find_optional_project, :only => :new

        Jean-Philippe Lang
    
Added per user custom queries....

              r563
            
        def new

          @query = Query.new(params[:query])

        Jean-Philippe Lang
    
Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....

              r1296
            
          @query.project = params[:query_is_for_all] ? nil : @project

        Jean-Philippe Lang
    
Anonymous users can now be allowed to create, edit, comment issues, comment news and post messages in the forums....

              r906
            
          @query.user = User.current

        Jean-Philippe Lang
    
Allows multiple roles on the same project (#706). Prerequisite for user groups feature....

              r2627
            
          @query.is_public = false unless User.current.allowed_to?(:manage_public_queries, @project) || User.current.admin?

        Jean-Philippe Lang
    
Added a checkbox on custom query form to explicitly say if the query uses default columns or not....

              r772
            
          @query.column_names = nil if params[:default_columns]

        Jean-Philippe Lang
    
Added per user custom queries....

              r563
            
          params[:fields].each do |field|

            @query.add_filter(field, params[:operators][field], params[:values][field])

          end if params[:fields]

        Jean-Philippe Lang
    
Ticket grouping (#2679)....

              r2604
            
          @query.group_by ||= params[:group_by]

        Jean-Philippe Lang
    
Added per user custom queries....

              r563
            
        Jean-Philippe Lang
    
Fixed: can't select columns when creating a new query....

              r784
            
          if request.post? && params[:confirm] && @query.save

        Jean-Philippe Lang
    
Added per user custom queries....

              r563
            
            flash[:notice] = l(:notice_successful_create)

        Jean-Philippe Lang
    
ProjectsController#list_issues, #export_issues_csv and #export_issues_pdf merged into IssuesController#index...

              r874
            
            redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :query_id => @query

        Jean-Philippe Lang
    
Added per user custom queries....

              r563
            
            return

          end

          render :layout => false if request.xhr?

        end

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

              r92
            
        def edit

          if request.post?

            @query.filters = {}

            params[:fields].each do |field|

              @query.add_filter(field, params[:operators][field], params[:values][field])

            end if params[:fields]

            @query.attributes = params[:query]

        Jean-Philippe Lang
    
Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....

              r1296
            
            @query.project = nil if params[:query_is_for_all]

        Jean-Philippe Lang
    
Allows multiple roles on the same project (#706). Prerequisite for user groups feature....

              r2627
            
            @query.is_public = false unless User.current.allowed_to?(:manage_public_queries, @project) || User.current.admin?

        Jean-Philippe Lang
    
Added a checkbox on custom query form to explicitly say if the query uses default columns or not....

              r772
            
            @query.column_names = nil if params[:default_columns]

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

              r92
            
            if @query.save

              flash[:notice] = l(:notice_successful_update)

        Jean-Philippe Lang
    
ProjectsController#list_issues, #export_issues_csv and #export_issues_pdf merged into IssuesController#index...

              r874
            
              redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :query_id => @query

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

              r92
            
            end

          end

        end

        def destroy

          @query.destroy if request.post?

        Jean-Philippe Lang
    
Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....

              r1296
            
          redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :set_filter => 1

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

              r92
            
        end

      private

        Jean-Philippe Lang
    
Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....

              r1296
            
        def find_query

          @query = Query.find(params[:id])

          @project = @query.project

          render_403 unless @query.editable_by?(User.current)

        rescue ActiveRecord::RecordNotFound

          render_404

        end

        Jean-Philippe Lang
    
Global queries can be saved from the global issue list (follows r1311 and closes #897)....

              r1297
            
        def find_optional_project

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

          User.current.allowed_to?(:save_queries, @project, :global => true)

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

              r130
            
        rescue ActiveRecord::RecordNotFound

          render_404

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

              r92
            
        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

Jean-Philippe Lang "queries" branch merged...	r92	# redMine - project management software
Jean-Philippe Lang Added per user custom queries....	r563	# Copyright (C) 2006-2007 Jean-Philippe Lang
Jean-Philippe Lang "queries" branch merged...	r92	#
		# 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 QueriesController < ApplicationController
Jean-Philippe Lang Highlight the current item of the main menu....	r1062	menu_item :issues
Jean-Philippe Lang Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....	r1296	before_filter :find_query, :except => :new
Jean-Philippe Lang Global queries can be saved from the global issue list (follows r1311 and closes #897)....	r1297	before_filter :find_optional_project, :only => :new
Jean-Philippe Lang Added per user custom queries....	r563
		def new
		@query = Query.new(params[:query])
Jean-Philippe Lang Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....	r1296	@query.project = params[:query_is_for_all] ? nil : @project
Jean-Philippe Lang Anonymous users can now be allowed to create, edit, comment issues, comment news and post messages in the forums....	r906	@query.user = User.current
Jean-Philippe Lang Allows multiple roles on the same project (#706). Prerequisite for user groups feature....	r2627	@query.is_public = false unless User.current.allowed_to?(:manage_public_queries, @project) \|\| User.current.admin?
Jean-Philippe Lang Added a checkbox on custom query form to explicitly say if the query uses default columns or not....	r772	@query.column_names = nil if params[:default_columns]
Jean-Philippe Lang Added per user custom queries....	r563
		params[:fields].each do \|field\|
		@query.add_filter(field, params[:operators][field], params[:values][field])
		end if params[:fields]
Jean-Philippe Lang Ticket grouping (#2679)....	r2604	@query.group_by \|\|= params[:group_by]
Jean-Philippe Lang Added per user custom queries....	r563
Jean-Philippe Lang Fixed: can't select columns when creating a new query....	r784	if request.post? && params[:confirm] && @query.save
Jean-Philippe Lang Added per user custom queries....	r563	flash[:notice] = l(:notice_successful_create)
Jean-Philippe Lang ProjectsController#list_issues, #export_issues_csv and #export_issues_pdf merged into IssuesController#index...	r874	redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :query_id => @query
Jean-Philippe Lang Added per user custom queries....	r563	return
		end
		render :layout => false if request.xhr?
		end

Jean-Philippe Lang "queries" branch merged...	r92	def edit
		if request.post?
		@query.filters = {}
		params[:fields].each do \|field\|
		@query.add_filter(field, params[:operators][field], params[:values][field])
		end if params[:fields]
		@query.attributes = params[:query]
Jean-Philippe Lang Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....	r1296	@query.project = nil if params[:query_is_for_all]
Jean-Philippe Lang Allows multiple roles on the same project (#706). Prerequisite for user groups feature....	r2627	@query.is_public = false unless User.current.allowed_to?(:manage_public_queries, @project) \|\| User.current.admin?
Jean-Philippe Lang Added a checkbox on custom query form to explicitly say if the query uses default columns or not....	r772	@query.column_names = nil if params[:default_columns]

Jean-Philippe Lang "queries" branch merged...	r92	if @query.save
		flash[:notice] = l(:notice_successful_update)
Jean-Philippe Lang ProjectsController#list_issues, #export_issues_csv and #export_issues_pdf merged into IssuesController#index...	r874	redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :query_id => @query
Jean-Philippe Lang "queries" branch merged...	r92	end
		end
		end

		def destroy
		@query.destroy if request.post?
Jean-Philippe Lang Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....	r1296	redirect_to :controller => 'issues', :action => 'index', :project_id => @project, :set_filter => 1
Jean-Philippe Lang "queries" branch merged...	r92	end

		private
Jean-Philippe Lang Queries can be marked as 'For all projects'. Such queries will be available on all projects and on the global issue list (#897, closes #671)....	r1296	def find_query
		@query = Query.find(params[:id])
		@project = @query.project
		render_403 unless @query.editable_by?(User.current)
		rescue ActiveRecord::RecordNotFound
		render_404
		end

Jean-Philippe Lang Global queries can be saved from the global issue list (follows r1311 and closes #897)....	r1297	def find_optional_project
		@project = Project.find(params[:project_id]) if params[:project_id]
		User.current.allowed_to?(:save_queries, @project, :global => true)
Jean-Philippe Lang ActiveRecord::RecordNotFound exceptions handled more gracefully...	r130	rescue ActiveRecord::RecordNotFound
		render_404
Jean-Philippe Lang "queries" branch merged...	r92	end
		end