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

Remove the limitation on characters that can be used in custom_field, issue_status, role, tracker, user names (#5152)....

Remove the limitation on characters that can be used in custom_field, issue_status, role, tracker, user names (#5152). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4599 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r4273:63866407f123


                r4479:44ffc5a3365f

Download file

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

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

              r771
            
      # redMine - project management software

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

      #

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

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

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

              r771
            
      module QueriesHelper

        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

        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,

                                                              :default_order => column.default_order) : 

        Jean-Philippe Lang
    
More appropriate default sort order on sortable columns....

              r1107
            
                            content_tag('th', column.caption)

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

              r771
            
        end

        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)

          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
    
Roadmap: more accurate completion percentage calculation (done ratio of open issues is now taken into account)....

              r895
            
            else

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

              r2998
            
              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)

            @query.project = @project

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

            sort_clear

          else

            if 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

        Jean-Philippe Lang
    
Fixed: unchecking status filter on the issue list has no effect (#6844)....

              r4273
            
              if params[:fields]

                @query.filters = {}

                @query.add_filters(params[:fields], params[:operators], params[:values])

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

              r3577
            
              else

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

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

                end

              end

              @query.group_by = params[:group_by]

              @query.column_names = params[:query] && params[:query][:column_names]

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

            else

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

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

              @query.project = @project

            end

          end

        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 the ability to customize columns of a saved query....	r771	# redMine - project management software
		# Copyright (C) 2006-2007 Jean-Philippe Lang
		#
		# 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.
Jean-Philippe Lang "queries" branch merged...	r92
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	module QueriesHelper

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
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,
		:default_order => column.default_order) :
Jean-Philippe Lang More appropriate default sort order on sortable columns....	r1107	content_tag('th', column.caption)
Jean-Philippe Lang Added the ability to customize columns of a saved query....	r771	end

		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)

		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 Roadmap: more accurate completion percentage calculation (done ratio of open issues is now taken into account)....	r895	else
Jean-Philippe Lang Fixed: "None" category issue count is empty while grouping by category (#4308)....	r2998	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)
		@query.project = @project
		session[:query] = {:id => @query.id, :project_id => @query.project_id}
		sort_clear
		else
		if 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
Jean-Philippe Lang Fixed: unchecking status filter on the issue list has no effect (#6844)....	r4273	if params[:fields]
		@query.filters = {}
		@query.add_filters(params[:fields], params[:operators], params[:values])
Eric Davis Refactor: move method to helper....	r3577	else
		@query.available_filters.keys.each do \|field\|
		@query.add_short_filter(field, params[field]) if params[field]
		end
		end
		@query.group_by = params[:group_by]
		@query.column_names = params[:query] && params[:query][:column_names]
		session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names}
		else
		@query = Query.find_by_id(session[:query][:id]) if session[:query][:id]
		@query \|\|= Query.new(:name => "_", :project => @project, :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
		@query.project = @project
		end
		end
		end
Jean-Philippe Lang "queries" branch merged...	r92	end