jro_apps/redmine Files · app/helpers/queries_helper.rb

Copy issues via bulk update action....

Copy issues via bulk update action. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@8538 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r8368:b1504ceb434c


                r8418:065376c160b0

Download file

             queries_helper.rb
        
                    119 lines
            
             | 4.3 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / app / helpers / queries_helper.rb
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Jean-Philippe Lang
    
Added encoding comment to helpers (#9792)....

              r8090
            
      # encoding: utf-8

      #

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

              r5159
            
      # Redmine - project management software

      # Copyright (C) 2006-2011  Jean-Philippe Lang

        Jean-Philippe Lang
    
Added the ability to customize columns of a saved query....

              r771
            
      #

      # 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.

        Toshi MARUYAMA
    
remove trailing white-spaces from app/helpers/queries_helper.rb....

              r6767
            
      #

        Jean-Philippe Lang
    
Added the ability to customize columns of a saved query....

              r771
            
      # 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.

        Toshi MARUYAMA
    
remove trailing white-spaces from app/helpers/queries_helper.rb....

              r6767
            
      #

        Jean-Philippe Lang
    
Added the ability to customize columns of a saved query....

              r771
            
      # 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.

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

              r92
            
        Jean-Philippe Lang
    
Added the ability to customize columns of a saved query....

              r771
            
      module QueriesHelper

        Toshi MARUYAMA
    
remove trailing white-spaces from app/helpers/queries_helper.rb....

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

              r92
            
        def operators_for_select(filter_type)

          Query.operators_by_filter_type[filter_type].collect {|o| [l(Query.operators[o]), o]}

        end

        Toshi MARUYAMA
    
remove trailing white-spaces from app/helpers/queries_helper.rb....

              r6767
            
        Jean-Philippe Lang
    
Added the ability to customize columns of a saved query....

              r771
            
        def column_header(column)

        Jean-Philippe Lang
    
Validates sort_key and sort_order params (#2378)....

              r2169
            
          column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,

        Toshi MARUYAMA
    
remove trailing white-spaces from app/helpers/queries_helper.rb....

              r6767
            
                                                              :default_order => column.default_order) :

        Jean-Philippe Lang
    
Additional escaping....

              r6207
            
                            content_tag('th', h(column.caption))

        Jean-Philippe Lang
    
Added the ability to customize columns of a saved query....

              r771
            
        end

        Toshi MARUYAMA
    
remove trailing white-spaces from app/helpers/queries_helper.rb....

              r6767
            
        Jean-Philippe Lang
    
Added the ability to customize columns of a saved query....

              r771
            
        def column_content(column, issue)

        Jean-Philippe Lang
    
Fixed: "None" category issue count is empty while grouping by category (#4308)....

              r2998
            
          value = column.value(issue)

        Toshi MARUYAMA
    
remove trailing white-spaces from app/helpers/queries_helper.rb....

              r6767
            
        Jean-Philippe Lang
    
Fixed: "None" category issue count is empty while grouping by category (#4308)....

              r2998
            
          case value.class.name

          when 'String'

            if column.name == :subject

              link_to(h(value), :controller => 'issues', :action => 'show', :id => issue)

            else

              h(value)

            end

          when 'Time'

            format_time(value)

          when 'Date'

            format_date(value)

          when 'Fixnum', 'Float'

            if column.name == :done_ratio

              progress_bar(value, :width => '80px')

        Jean-Philippe Lang
    
Makes spent time column available on the issue list (#971)....

              r7953
            
            elsif  column.name == :spent_hours

              sprintf "%.2f", value

        Jean-Philippe Lang
    
Roadmap: more accurate completion percentage calculation (done ratio of open issues is now taken into account)....

              r895
            
            else

        Toshi MARUYAMA
    
HTML escape at app/helpers/queries_helper.rb....

              r6233
            
              h(value.to_s)

        Jean-Philippe Lang
    
Custom fields can now be displayed as columns on the issue list....

              r876
            
            end

        Jean-Philippe Lang
    
Fixed: "None" category issue count is empty while grouping by category (#4308)....

              r2998
            
          when 'User'

            link_to_user value

          when 'Project'

        Jean-Baptiste Barth
    
Refactor: added link_to_project helper to handle links to projects...

              r3810
            
            link_to_project value

        Jean-Philippe Lang
    
Fixed: "None" category issue count is empty while grouping by category (#4308)....

              r2998
            
          when 'Version'

            link_to(h(value), :controller => 'versions', :action => 'show', :id => value)

          when 'TrueClass'

            l(:general_text_Yes)

          when 'FalseClass'

            l(:general_text_No)

        Jean-Philippe Lang
    
Issue list improvements for subtasking (#5196):...

              r3504
            
          when 'Issue'

            link_to_issue(value, :subject => false)

        Jean-Philippe Lang
    
Fixed: "None" category issue count is empty while grouping by category (#4308)....

              r2998
            
          else

            h(value)

        Jean-Philippe Lang
    
Added the ability to customize columns of a saved query....

              r771
            
          end

        end

        Eric Davis
    
Refactor: move method to helper....

              r3577
            
        # Retrieve query from session or build a new query

        def retrieve_query

          if !params[:query_id].blank?

            cond = "project_id IS NULL"

            cond << " OR project_id = #{@project.id}" if @project

            @query = Query.find(params[:query_id], :conditions => cond)

        Jean-Philippe Lang
    
Fixed: private queries should not be accessible to other users (#8729)....

              r6043
            
            raise ::Unauthorized unless @query.visible?

        Etienne Massip
    
Reverted removal of project assignment to query (#9108)....

              r7536
            
            @query.project = @project

        Eric Davis
    
Refactor: move method to helper....

              r3577
            
            session[:query] = {:id => @query.id, :project_id => @query.project_id}

            sort_clear

        Etienne Massip
    
Refactor : convert queries to REST resources (also fixes #9108)....

              r7529
            
          elsif api_request? || params[:set_filter] || session[:query].nil? || session[:query][:project_id] != (@project ? @project.id : nil)

            # Give it a name, required to be valid

            @query = Query.new(:name => "_")

            @query.project = @project

            build_query_from_params

            session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names}

        Eric Davis
    
Refactor: move method to helper....

              r3577
            
          else

        Etienne Massip
    
Refactor : convert queries to REST resources (also fixes #9108)....

              r7529
            
            # retrieve from session

            @query = Query.find_by_id(session[:query][:id]) if session[:query][:id]

        Jean-Philippe Lang
    
Fixed that a cross-project custom query is not remembered inside project (#9738)....

              r7993
            
            @query ||= Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])

            @query.project = @project

        Etienne Massip
    
Refactor : convert queries to REST resources (also fixes #9108)....

              r7529
            
          end

        end

        Etienne Massip
    
Reverted removal of project assignment to query (#9108)....

              r7536
            
        Jean-Philippe Lang
    
Adds previous/next links to issue (#2850)....

              r8368
            
        def retrieve_query_from_session

          if session[:query]

            @query = Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])

            if session[:query].has_key?(:project_id)

              @query.project_id = session[:query][:project_id]

            else

              @query.project = @project

            end

            @query

          end

        end

        Etienne Massip
    
Refactor : convert queries to REST resources (also fixes #9108)....

              r7529
            
        def build_query_from_params

          if params[:fields] || params[:f]

            @query.filters = {}

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

          else

            @query.available_filters.keys.each do |field|

              @query.add_short_filter(field, params[field]) if params[field]

        Eric Davis
    
Refactor: move method to helper....

              r3577
            
            end

          end

        Etienne Massip
    
Refactor : convert queries to REST resources (also fixes #9108)....

              r7529
            
          @query.group_by = params[:group_by] || (params[:query] && params[:query][:group_by])

          @query.column_names = params[:c] || (params[:query] && params[:query][:column_names])

        Eric Davis
    
Refactor: move method to helper....

              r3577
            
        end

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

              r92
            
      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 Added encoding comment to helpers (#9792)....	r8090	# encoding: utf-8
		#
Jean-Philippe Lang Shortens filter param names....	r5159	# Redmine - project management software
		# Copyright (C) 2006-2011 Jean-Philippe Lang
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	#
		# 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.
Toshi MARUYAMA remove trailing white-spaces from app/helpers/queries_helper.rb....	r6767	#
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	# 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.
Toshi MARUYAMA remove trailing white-spaces from app/helpers/queries_helper.rb....	r6767	#
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	# 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.
Jean-Philippe Lang "queries" branch merged...	r92
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	module QueriesHelper
Toshi MARUYAMA remove trailing white-spaces from app/helpers/queries_helper.rb....	r6767
Jean-Philippe Lang "queries" branch merged...	r92	def operators_for_select(filter_type)
		Query.operators_by_filter_type[filter_type].collect {\|o\| [l(Query.operators[o]), o]}
		end
Toshi MARUYAMA remove trailing white-spaces from app/helpers/queries_helper.rb....	r6767
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	def column_header(column)
Jean-Philippe Lang Validates sort_key and sort_order params (#2378)....	r2169	column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,
Toshi MARUYAMA remove trailing white-spaces from app/helpers/queries_helper.rb....	r6767	:default_order => column.default_order) :
Jean-Philippe Lang Additional escaping....	r6207	content_tag('th', h(column.caption))
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	end
Toshi MARUYAMA remove trailing white-spaces from app/helpers/queries_helper.rb....	r6767
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	def column_content(column, issue)
Jean-Philippe Lang Fixed: "None" category issue count is empty while grouping by category (#4308)....	r2998	value = column.value(issue)
Toshi MARUYAMA remove trailing white-spaces from app/helpers/queries_helper.rb....	r6767
Jean-Philippe Lang Fixed: "None" category issue count is empty while grouping by category (#4308)....	r2998	case value.class.name
		when 'String'
		if column.name == :subject
		link_to(h(value), :controller => 'issues', :action => 'show', :id => issue)
		else
		h(value)
		end
		when 'Time'
		format_time(value)
		when 'Date'
		format_date(value)
		when 'Fixnum', 'Float'
		if column.name == :done_ratio
		progress_bar(value, :width => '80px')
Jean-Philippe Lang Makes spent time column available on the issue list (#971)....	r7953	elsif column.name == :spent_hours
		sprintf "%.2f", value
Jean-Philippe Lang Roadmap: more accurate completion percentage calculation (done ratio of open issues is now taken into account)....	r895	else
Toshi MARUYAMA HTML escape at app/helpers/queries_helper.rb....	r6233	h(value.to_s)
Jean-Philippe Lang Custom fields can now be displayed as columns on the issue list....	r876	end
Jean-Philippe Lang Fixed: "None" category issue count is empty while grouping by category (#4308)....	r2998	when 'User'
		link_to_user value
		when 'Project'
Jean-Baptiste Barth Refactor: added link_to_project helper to handle links to projects...	r3810	link_to_project value
Jean-Philippe Lang Fixed: "None" category issue count is empty while grouping by category (#4308)....	r2998	when 'Version'
		link_to(h(value), :controller => 'versions', :action => 'show', :id => value)
		when 'TrueClass'
		l(:general_text_Yes)
		when 'FalseClass'
		l(:general_text_No)
Jean-Philippe Lang Issue list improvements for subtasking (#5196):...	r3504	when 'Issue'
		link_to_issue(value, :subject => false)
Jean-Philippe Lang Fixed: "None" category issue count is empty while grouping by category (#4308)....	r2998	else
		h(value)
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	end
		end
Eric Davis Refactor: move method to helper....	r3577
		# Retrieve query from session or build a new query
		def retrieve_query
		if !params[:query_id].blank?
		cond = "project_id IS NULL"
		cond << " OR project_id = #{@project.id}" if @project
		@query = Query.find(params[:query_id], :conditions => cond)
Jean-Philippe Lang Fixed: private queries should not be accessible to other users (#8729)....	r6043	raise ::Unauthorized unless @query.visible?
Etienne Massip Reverted removal of project assignment to query (#9108)....	r7536	@query.project = @project
Eric Davis Refactor: move method to helper....	r3577	session[:query] = {:id => @query.id, :project_id => @query.project_id}
		sort_clear
Etienne Massip Refactor : convert queries to REST resources (also fixes #9108)....	r7529	elsif api_request? \|\| params[:set_filter] \|\| session[:query].nil? \|\| session[:query][:project_id] != (@project ? @project.id : nil)
		# Give it a name, required to be valid
		@query = Query.new(:name => "_")
		@query.project = @project
		build_query_from_params
		session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names}
Eric Davis Refactor: move method to helper....	r3577	else
Etienne Massip Refactor : convert queries to REST resources (also fixes #9108)....	r7529	# retrieve from session
		@query = Query.find_by_id(session[:query][:id]) if session[:query][:id]
Jean-Philippe Lang Fixed that a cross-project custom query is not remembered inside project (#9738)....	r7993	@query \|\|= Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
		@query.project = @project
Etienne Massip Refactor : convert queries to REST resources (also fixes #9108)....	r7529	end
		end
Etienne Massip Reverted removal of project assignment to query (#9108)....	r7536
Jean-Philippe Lang Adds previous/next links to issue (#2850)....	r8368	def retrieve_query_from_session
		if session[:query]
		@query = Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
		if session[:query].has_key?(:project_id)
		@query.project_id = session[:query][:project_id]
		else
		@query.project = @project
		end
		@query
		end
		end

Etienne Massip Refactor : convert queries to REST resources (also fixes #9108)....	r7529	def build_query_from_params
		if params[:fields] \|\| params[:f]
		@query.filters = {}
		@query.add_filters(params[:fields] \|\| params[:f], params[:operators] \|\| params[:op], params[:values] \|\| params[:v])
		else
		@query.available_filters.keys.each do \|field\|
		@query.add_short_filter(field, params[field]) if params[field]
Eric Davis Refactor: move method to helper....	r3577	end
		end
Etienne Massip Refactor : convert queries to REST resources (also fixes #9108)....	r7529	@query.group_by = params[:group_by] \|\| (params[:query] && params[:query][:group_by])
		@query.column_names = params[:c] \|\| (params[:query] && params[:query][:column_names])
Eric Davis Refactor: move method to helper....	r3577	end
Jean-Philippe Lang "queries" branch merged...	r92	end