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

Improved on-the-fly account creation. If some attributes are missing (eg. not present in the LDAP) or are invalid, the registration form is displayed so that the user is able to fill or fix these attributes....

Jean-Philippe Lang - - Load All Authors

File last commit:

r1297:da641f4122f7


                r1661:eb1d969237a9

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
    
Merged 0.6 branch into trunk....

              r663
            
        layout 'base'

        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
    
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.is_public = false unless (@query.project && current_role.allowed_to?(:manage_public_queries)) || 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
    
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]

            @query.is_public = false unless (@query.project && current_role.allowed_to?(:manage_public_queries)) || 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 Merged 0.6 branch into trunk....	r663	layout 'base'
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 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.is_public = false unless (@query.project && current_role.allowed_to?(:manage_public_queries)) \|\| 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 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]
		@query.is_public = false unless (@query.project && current_role.allowed_to?(:manage_public_queries)) \|\| 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