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

remove trailing white-spaces from app/controllers/documents_controller.rb....

remove trailing white-spaces from app/controllers/documents_controller.rb. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6803 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r6077:93c2b92a4b5b


                r6683:c3a9d10e3b7f

Download file

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

        Jean-Philippe Lang
    
Makes custom queries available through the REST API (#5737)....

              r6066
            
      # Redmine - project management software

      # Copyright (C) 2006-2011  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
    
Makes custom queries available through the REST API (#5737)....

              r6066
            
        before_filter :find_query, :except => [:new, :index]

        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
            
        Jean-Philippe Lang
    
Separation of RSS/API auth actions....

              r6077
            
        accept_api_auth :index

        Jean-Philippe Lang
    
Makes custom queries available through the REST API (#5737)....

              r6066
            
        def index

          case params[:format]

          when 'xml', 'json'

            @offset, @limit = api_offset_and_limit

          else

            @limit = per_page_option

          end

          @query_count = Query.visible.count

          @query_pages = Paginator.new self, @query_count, @limit, params['page']

          @queries = Query.visible.all(:limit => @limit, :offset => @offset, :order => "#{Query.table_name}.name")

          respond_to do |format|

            format.html { render :nothing => true }

            format.api

          end

        end

        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 per user custom queries....

              r563
            
        Jean-Philippe Lang
    
Shortens filter param names....

              r5159
            
          @query.add_filters(params[:fields] || params[:f], params[:operators] || params[:op], params[:values] || params[:v]) if params[:fields] || params[:f]

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

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

        Jean-Philippe Lang
    
Shorten query[column_names] param name....

              r5184
            
          @query.column_names = params[:c] if params[:c]

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

        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 = {}

        Jean-Philippe Lang
    
Shortens filter param names....

              r5159
            
            @query.add_filters(params[:fields] || params[:f], params[:operators] || params[:op], params[:values] || params[:v]) if params[:fields] || params[:f]

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

              r92
            
            @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
    
Shorten query[column_names] param name....

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

            @query.column_names = params[:c] if params[:c]

        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]

        Jean-Philippe Lang
    
Fixes permission check in QueriesController (#5181)....

              r3497
            
          render_403 unless 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 Makes custom queries available through the REST API (#5737)....	r6066	# Redmine - project management software
		# Copyright (C) 2006-2011 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 Makes custom queries available through the REST API (#5737)....	r6066	before_filter :find_query, :except => [:new, :index]
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
Jean-Philippe Lang Separation of RSS/API auth actions....	r6077	accept_api_auth :index
Jean-Philippe Lang Makes custom queries available through the REST API (#5737)....	r6066
		def index
		case params[:format]
		when 'xml', 'json'
		@offset, @limit = api_offset_and_limit
		else
		@limit = per_page_option
		end

		@query_count = Query.visible.count
		@query_pages = Paginator.new self, @query_count, @limit, params['page']
		@queries = Query.visible.all(:limit => @limit, :offset => @offset, :order => "#{Query.table_name}.name")

		respond_to do \|format\|
		format.html { render :nothing => true }
		format.api
		end
		end

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 per user custom queries....	r563
Jean-Philippe Lang Shortens filter param names....	r5159	@query.add_filters(params[:fields] \|\| params[:f], params[:operators] \|\| params[:op], params[:values] \|\| params[:v]) if params[:fields] \|\| params[:f]
Jean-Philippe Lang Ticket grouping (#2679)....	r2604	@query.group_by \|\|= params[:group_by]
Jean-Philippe Lang Shorten query[column_names] param name....	r5184	@query.column_names = params[:c] if params[:c]
		@query.column_names = nil if params[:default_columns]
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 = {}
Jean-Philippe Lang Shortens filter param names....	r5159	@query.add_filters(params[:fields] \|\| params[:f], params[:operators] \|\| params[:op], params[:values] \|\| params[:v]) if params[:fields] \|\| params[:f]
Jean-Philippe Lang "queries" branch merged...	r92	@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 Shorten query[column_names] param name....	r5184	@query.group_by \|\|= params[:group_by]
		@query.column_names = params[:c] if params[:c]
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]
Jean-Philippe Lang Fixes permission check in QueriesController (#5181)....	r3497	render_403 unless 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