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

New setting added to specify how many objects should be displayed on most paginated lists....

New setting added to specify how many objects should be displayed on most paginated lists. Default is: 25, 50, 100 (users can choose one of these values). If one value only is entered in this setting (eg. 25), the 'per page' links are not displayed (prior behaviour). git-svn-id: http://redmine.rubyforge.org/svn/trunk@1026 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r906:987a5aa22114


                r1013:9a1b46fe4287

Download file

             queries_controller.rb
        
                    81 lines
            
             | 2.8 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'

        before_filter :find_project, :authorize

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

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

              r563
            
        def index

          @queries = @project.queries.find(:all, 

                                           :order => "name ASC",

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

              r906
            
                                           :conditions => ["is_public = ? or user_id = ?", true, (User.current.logged? ? User.current.id : 0)])

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

              r563
            
        end

        def new

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

          @query.project = @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
    
Fixed: Manage pu(b)lic queries typo (Thomas Lecavelier)....

              r767
            
          @query.is_public = false unless current_role.allowed_to?(:manage_public_queries)

        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
    
Fixed: Manage pu(b)lic queries typo (Thomas Lecavelier)....

              r767
            
            @query.is_public = false unless current_role.allowed_to?(:manage_public_queries)

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

              r563
            
          redirect_to :controller => 'queries', :project_id => @project

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

              r92
            
        end

      private

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

              r563
            
        def find_project

          if params[:id]

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

            @project = @query.project

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

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

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

              r563
            
          else

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

          end

        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'
		before_filter :find_project, :authorize
Jean-Philippe Lang "queries" branch merged...	r92
Jean-Philippe Lang Added per user custom queries....	r563	def index
		@queries = @project.queries.find(:all,
		:order => "name ASC",
Jean-Philippe Lang Anonymous users can now be allowed to create, edit, comment issues, comment news and post messages in the forums....	r906	:conditions => ["is_public = ? or user_id = ?", true, (User.current.logged? ? User.current.id : 0)])
Jean-Philippe Lang Added per user custom queries....	r563	end

		def new
		@query = Query.new(params[:query])
		@query.project = @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 Fixed: Manage pu(b)lic queries typo (Thomas Lecavelier)....	r767	@query.is_public = false unless current_role.allowed_to?(:manage_public_queries)
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 Fixed: Manage pu(b)lic queries typo (Thomas Lecavelier)....	r767	@query.is_public = false unless current_role.allowed_to?(:manage_public_queries)
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 Added per user custom queries....	r563	redirect_to :controller => 'queries', :project_id => @project
Jean-Philippe Lang "queries" branch merged...	r92	end

		private
Jean-Philippe Lang Added per user custom queries....	r563	def find_project
		if params[:id]
		@query = Query.find(params[:id])
		@project = @query.project
Jean-Philippe Lang Anonymous users can now be allowed to create, edit, comment issues, comment news and post messages in the forums....	r906	render_403 unless @query.editable_by?(User.current)
Jean-Philippe Lang Added per user custom queries....	r563	else
		@project = Project.find(params[:project_id])
		end
Jean-Philippe Lang ActiveRecord::RecordNotFound exceptions handled more gracefully...	r130	rescue ActiveRecord::RecordNotFound
		render_404
Jean-Philippe Lang "queries" branch merged...	r92	end
		end