1 # encoding: utf-8
2 #
3 # Redmine - project management software
4 # Copyright (C) 2006-2011 Jean-Philippe Lang
5 #
6 # This program is free software; you can redistribute it and/or
7 # modify it under the terms of the GNU General Public License
8 # as published by the Free Software Foundation; either version 2
9 # of the License, or (at your option) any later version.
10 #
11 # This program is distributed in the hope that it will be useful,
12 # but WITHOUT ANY WARRANTY; without even the implied warranty of
13 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 # GNU General Public License for more details.
15 #
16 # You should have received a copy of the GNU General Public License
17 # along with this program; if not, write to the Free Software
18 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
19
20 module QueriesHelper
21
22 def operators_for_select(filter_type)
23 Query.operators_by_filter_type[filter_type].collect {|o| [l(Query.operators[o]), o]}
24 end
25
26 def column_header(column)
27 column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,
28 :default_order => column.default_order) :
29 content_tag('th', h(column.caption))
30 end
31
32 def column_content(column, issue)
33 value = column.value(issue)
34 if value.is_a?(Array)
35 value.collect {|v| column_value(column, issue, v)}.compact.sort.join(', ').html_safe
36 else
37 column_value(column, issue, value)
38 end
39 end
40
41 def column_value(column, issue, value)
42 case value.class.name
43 when 'String'
44 if column.name == :subject
45 link_to(h(value), :controller => 'issues', :action => 'show', :id => issue)
46 else
47 h(value)
48 end
49 when 'Time'
50 format_time(value)
51 when 'Date'
52 format_date(value)
53 when 'Fixnum', 'Float'
54 if column.name == :done_ratio
55 progress_bar(value, :width => '80px')
56 elsif column.name == :spent_hours
57 sprintf "%.2f", value
58 else
59 h(value.to_s)
60 end
61 when 'User'
62 link_to_user value
63 when 'Project'
64 link_to_project value
65 when 'Version'
66 link_to(h(value), :controller => 'versions', :action => 'show', :id => value)
67 when 'TrueClass'
68 l(:general_text_Yes)
69 when 'FalseClass'
70 l(:general_text_No)
71 when 'Issue'
72 link_to_issue(value, :subject => false)
73 else
74 h(value)
75 end
76 end
77
78 # Retrieve query from session or build a new query
79 def retrieve_query
80 if !params[:query_id].blank?
81 cond = "project_id IS NULL"
82 cond << " OR project_id = #{@project.id}" if @project
83 @query = Query.find(params[:query_id], :conditions => cond)
84 raise ::Unauthorized unless @query.visible?
85 @query.project = @project
86 session[:query] = {:id => @query.id, :project_id => @query.project_id}
87 sort_clear
88 elsif api_request? || params[:set_filter] || session[:query].nil? || session[:query][:project_id] != (@project ? @project.id : nil)
89 # Give it a name, required to be valid
90 @query = Query.new(:name => "_")
91 @query.project = @project
92 build_query_from_params
93 session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names}
94 else
95 # retrieve from session
96 @query = Query.find_by_id(session[:query][:id]) if session[:query][:id]
97 @query ||= Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
98 @query.project = @project
99 end
100 end
101
102 def retrieve_query_from_session
103 if session[:query]
104 if session[:query][:id]
105 @query = Query.find_by_id(session[:query][:id])
106 return unless @query
107 else
108 @query = Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
109 end
110 if session[:query].has_key?(:project_id)
111 @query.project_id = session[:query][:project_id]
112 else
113 @query.project = @project
114 end
115 @query
116 end
117 end
118
119 def build_query_from_params
120 if params[:fields] || params[:f]
121 @query.filters = {}
122 @query.add_filters(params[:fields] || params[:f], params[:operators] || params[:op], params[:values] || params[:v])
123 else
124 @query.available_filters.keys.each do |field|
125 @query.add_short_filter(field, params[field]) if params[field]
126 end
127 end
128 @query.group_by = params[:group_by] || (params[:query] && params[:query][:group_by])
129 @query.column_names = params[:c] || (params[:query] && params[:query][:column_names])
130 end
131 end