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

Fix in AttachmentsController#show....

Fix in AttachmentsController#show. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2282 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r1726:2fdf4426cd8f


                r2280:dacddd989720

Download file

             queries_controller.rb
        
                    80 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
    
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 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