Module: QueriesHelper
- Included in:
- CalendarsController, GanttsController, IssuesController, JournalsController, ProjectsController
- Defined in:
- app/helpers/queries_helper.rb
Overview
redMine - project management software Copyright © 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.
Instance Method Summary collapse
- #column_content(column, issue) ⇒ Object
- #column_header(column) ⇒ Object
- #operators_for_select(filter_type) ⇒ Object
-
#retrieve_query ⇒ Object
Retrieve query from session or build a new query.
Instance Method Details
#column_content(column, issue) ⇒ Object
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 |
# File 'app/helpers/queries_helper.rb', line 30 def column_content(column, issue) 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 (value, :width => '80px') else value.to_s end when 'User' link_to_user value when 'Project' link_to_project value when 'Version' link_to(h(value), :controller => 'versions', :action => 'show', :id => value) when 'TrueClass' l(:general_text_Yes) when 'FalseClass' l(:general_text_No) when 'Issue' link_to_issue(value, :subject => false) else h(value) end end |
#column_header(column) ⇒ Object
24 25 26 27 28 |
# File 'app/helpers/queries_helper.rb', line 24 def column_header(column) column.sortable ? sort_header_tag(column.name.to_s, :caption => column., :default_order => column.default_order) : content_tag('th', column.) end |
#operators_for_select(filter_type) ⇒ Object
20 21 22 |
# File 'app/helpers/queries_helper.rb', line 20 def operators_for_select(filter_type) Query.operators_by_filter_type[filter_type].collect {|o| [l(Query.operators[o]), o]} end |
#retrieve_query ⇒ Object
Retrieve query from session or build a new query
68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 |
# File 'app/helpers/queries_helper.rb', line 68 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 if params[:fields] @query.filters = {} @query.add_filters(params[:fields], params[:operators], params[:values]) 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 |