Chris@909: # encoding: utf-8 Chris@909: # Chris@909: # Redmine - project management software Chris@909: # Copyright (C) 2006-2011 Jean-Philippe Lang Chris@909: # Chris@909: # This program is free software; you can redistribute it and/or Chris@909: # modify it under the terms of the GNU General Public License Chris@909: # as published by the Free Software Foundation; either version 2 Chris@909: # of the License, or (at your option) any later version. Chris@909: # Chris@909: # This program is distributed in the hope that it will be useful, Chris@909: # but WITHOUT ANY WARRANTY; without even the implied warranty of Chris@909: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the Chris@909: # GNU General Public License for more details. Chris@909: # Chris@909: # You should have received a copy of the GNU General Public License Chris@909: # along with this program; if not, write to the Free Software Chris@909: # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. Chris@909: Chris@909: module QueriesHelper Chris@909: Chris@909: def operators_for_select(filter_type) Chris@909: Query.operators_by_filter_type[filter_type].collect {|o| [l(Query.operators[o]), o]} Chris@909: end Chris@909: Chris@909: def column_header(column) Chris@909: column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption, Chris@909: :default_order => column.default_order) : Chris@909: content_tag('th', h(column.caption)) Chris@909: end Chris@909: Chris@909: def column_content(column, issue) Chris@909: value = column.value(issue) Chris@909: Chris@909: case value.class.name Chris@909: when 'String' Chris@909: if column.name == :subject Chris@909: link_to(h(value), :controller => 'issues', :action => 'show', :id => issue) Chris@909: else Chris@909: h(value) Chris@909: end Chris@909: when 'Time' Chris@909: format_time(value) Chris@909: when 'Date' Chris@909: format_date(value) Chris@909: when 'Fixnum', 'Float' Chris@909: if column.name == :done_ratio Chris@909: progress_bar(value, :width => '80px') Chris@909: else Chris@909: h(value.to_s) Chris@909: end Chris@909: when 'User' Chris@909: link_to_user value Chris@909: when 'Project' Chris@909: link_to_project value Chris@909: when 'Version' Chris@909: link_to(h(value), :controller => 'versions', :action => 'show', :id => value) Chris@909: when 'TrueClass' Chris@909: l(:general_text_Yes) Chris@909: when 'FalseClass' Chris@909: l(:general_text_No) Chris@909: when 'Issue' Chris@909: link_to_issue(value, :subject => false) Chris@909: else Chris@909: h(value) Chris@909: end Chris@909: end Chris@909: Chris@909: # Retrieve query from session or build a new query Chris@909: def retrieve_query Chris@909: if !params[:query_id].blank? Chris@909: cond = "project_id IS NULL" Chris@909: cond << " OR project_id = #{@project.id}" if @project Chris@909: @query = Query.find(params[:query_id], :conditions => cond) Chris@909: raise ::Unauthorized unless @query.visible? Chris@909: @query.project = @project Chris@909: session[:query] = {:id => @query.id, :project_id => @query.project_id} Chris@909: sort_clear Chris@909: elsif api_request? || params[:set_filter] || session[:query].nil? || session[:query][:project_id] != (@project ? @project.id : nil) Chris@909: # Give it a name, required to be valid Chris@909: @query = Query.new(:name => "_") Chris@909: @query.project = @project Chris@909: build_query_from_params Chris@909: session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names} Chris@909: else Chris@909: # retrieve from session Chris@909: @query = Query.find_by_id(session[:query][:id]) if session[:query][:id] Chris@909: @query ||= Query.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names]) Chris@909: @query.project = @project Chris@909: end Chris@909: end Chris@909: Chris@909: def build_query_from_params Chris@909: if params[:fields] || params[:f] Chris@909: @query.filters = {} Chris@909: @query.add_filters(params[:fields] || params[:f], params[:operators] || params[:op], params[:values] || params[:v]) Chris@909: else Chris@909: @query.available_filters.keys.each do |field| Chris@909: @query.add_short_filter(field, params[field]) if params[field] Chris@909: end Chris@909: end Chris@909: @query.group_by = params[:group_by] || (params[:query] && params[:query][:group_by]) Chris@909: @query.column_names = params[:c] || (params[:query] && params[:query][:column_names]) Chris@909: end Chris@909: end