jro_apps/redmine Commit - r92:2b0142580f9c

"queries" branch merged...

Jean-Philippe Lang -

r92:2b0142580f9c

parent child

Context file:

r92:2b0142580f9c

Expand all files

app/controllers/queries_controller.rb created 644 +49 0

@@ -0,0 +1,49
	1	# redMine - project management software
	2	# Copyright (C) 2006 Jean-Philippe Lang
	3	#
	4	# This program is free software; you can redistribute it and/or
	5	# modify it under the terms of the GNU General Public License
	6	# as published by the Free Software Foundation; either version 2
	7	# of the License, or (at your option) any later version.
	8	#
	9	# This program is distributed in the hope that it will be useful,
	10	# but WITHOUT ANY WARRANTY; without even the implied warranty of
	11	# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
	12	# GNU General Public License for more details.
	13	#
	14	# You should have received a copy of the GNU General Public License
	15	# along with this program; if not, write to the Free Software
	16	# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
	17
	18	class QueriesController < ApplicationController
	19	layout 'base'
	20	before_filter :require_login, :find_query
	21
	22	def edit
	23	if request.post?
	24	@query.filters = {}
	25	params[:fields].each do \|field\|
	26	@query.add_filter(field, params[:operators][field], params[:values][field])
	27	end if params[:fields]
	28	@query.attributes = params[:query]
	29
	30	if @query.save
	31	flash[:notice] = l(:notice_successful_update)
	32	redirect_to :controller => 'projects', :action => 'list_issues', :id => @project, :query_id => @query
	33	end
	34	end
	35	end
	36
	37	def destroy
	38	@query.destroy if request.post?
	39	redirect_to :controller => 'reports', :action => 'issue_report', :id => @project
	40	end
	41
	42	private
	43	def find_query
	44	@query = Query.find(params[:id])
	45	@project = @query.project
	46	# check if user is allowed to manage queries (same permission as add_query)
	47	authorize('projects', 'add_query')
	48	end
	49	end

app/helpers/queries_helper.rb created 644 +6 0

@@ -0,0 +1,6
	1	module QueriesHelper
	2
	3	def operators_for_select(filter_type)
	4	Query.operators_by_filter_type[filter_type].collect {\|o\| [l(Query.operators[o]), o]}
	5	end
	6	end

app/models/query.rb created 644 +166 0

@@ -0,0 +1,166
	1	# redMine - project management software
	2	# Copyright (C) 2006 Jean-Philippe Lang
	3	#
	4	# This program is free software; you can redistribute it and/or
	5	# modify it under the terms of the GNU General Public License
	6	# as published by the Free Software Foundation; either version 2
	7	# of the License, or (at your option) any later version.
	8	#
	9	# This program is distributed in the hope that it will be useful,
	10	# but WITHOUT ANY WARRANTY; without even the implied warranty of
	11	# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
	12	# GNU General Public License for more details.
	13	#
	14	# You should have received a copy of the GNU General Public License
	15	# along with this program; if not, write to the Free Software
	16	# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
	17
	18	class Query < ActiveRecord::Base
	19	belongs_to :project
	20	belongs_to :user
	21	serialize :filters
	22
	23	attr_protected :project, :user
	24
	25	validates_presence_of :name, :on => :save
	26
	27	@@operators = { "=" => :label_equals,
	28	"!" => :label_not_equals,
	29	"o" => :label_open_issues,
	30	"c" => :label_closed_issues,
	31	"!*" => :label_none,
	32	"*" => :label_all,
	33	"<t+" => :label_in_less_than,
	34	">t+" => :label_in_more_than,
	35	"t+" => :label_in,
	36	"t" => :label_today,
	37	">t-" => :label_less_than_ago,
	38	"<t-" => :label_more_than_ago,
	39	"t-" => :label_ago,
	40	"~" => :label_contains,
	41	"!~" => :label_not_contains }
	42
	43	cattr_reader :operators
	44
	45	@@operators_by_filter_type = { :list => [ "=", "!" ],
	46	:list_status => [ "o", "=", "!", "c", "*" ],
	47	:list_optional => [ "=", "!", "!", "" ],
	48	:date => [ "<t+", ">t+", "t+", "t", ">t-", "<t-", "t-" ],
	49	:date_past => [ ">t-", "<t-", "t-", "t" ],
	50	:text => [ "~", "!~" ] }
	51
	52	cattr_reader :operators_by_filter_type
	53
	54	def initialize(attributes = nil)
	55	super attributes
	56	self.filters \|\|= { 'status_id' => {:operator => "o", :values => [""]} }
	57	self.is_public = true
	58	end
	59
	60	def validate
	61	filters.each_key do \|field\|
	62	errors.add field.gsub(/\_id$/, ""), :activerecord_error_blank unless
	63	# filter requires one or more values
	64	(values_for(field) and !values_for(field).first.empty?) or
	65	# filter doesn't require any value
	66	["o", "c", "!", "", "t"].include? operator_for(field)
	67	end if filters
	68	end
	69
	70	def available_filters
	71	return @available_filters if @available_filters
	72	@available_filters = { "status_id" => { :type => :list_status, :order => 1, :values => IssueStatus.find(:all).collect{\|s\| [s.name, s.id.to_s] } },
	73	"tracker_id" => { :type => :list, :order => 2, :values => Tracker.find(:all).collect{\|s\| [s.name, s.id.to_s] } },
	74	"priority_id" => { :type => :list, :order => 3, :values => Enumeration.find(:all, :conditions => ['opt=?','IPRI']).collect{\|s\| [s.name, s.id.to_s] } },
	75	"subject" => { :type => :text, :order => 7 },
	76	"created_on" => { :type => :date_past, :order => 8 },
	77	"updated_on" => { :type => :date_past, :order => 9 },
	78	"start_date" => { :type => :date, :order => 10 },
	79	"due_date" => { :type => :date, :order => 11 } }
	80	unless project.nil?
	81	# project specific filters
	82	@available_filters["assigned_to_id"] = { :type => :list_optional, :order => 4, :values => @project.users.collect{\|s\| [s.name, s.id.to_s] } }
	83	@available_filters["author_id"] = { :type => :list, :order => 5, :values => @project.users.collect{\|s\| [s.name, s.id.to_s] } }
	84	@available_filters["category_id"] = { :type => :list_optional, :order => 6, :values => @project.issue_categories.collect{\|s\| [s.name, s.id.to_s] } }
	85	# remove category filter if no category defined
	86	@available_filters.delete "category_id" if @available_filters["category_id"][:values].empty?
	87	end
	88	@available_filters
	89	end
	90
	91	def add_filter(field, operator, values)
	92	# values must be an array
	93	return unless values and values.is_a? Array # and !values.first.empty?
	94	# check if field is defined as an available filter
	95	if available_filters.has_key? field
	96	filter_options = available_filters[field]
	97	# check if operator is allowed for that filter
	98	#if @@operators_by_filter_type[filter_options[:type]].include? operator
	99	# allowed_values = values & ([""] + (filter_options[:values] \|\| []).collect {\|val\| val[1]})
	100	# filters[field] = {:operator => operator, :values => allowed_values } if (allowed_values.first and !allowed_values.first.empty?) or ["o", "c", "!", "", "t"].include? operator
	101	#end
	102	filters[field] = {:operator => operator, :values => values }
	103	end
	104	end
	105
	106	def add_short_filter(field, expression)
	107	return unless expression
	108	parms = expression.scan(/^(o\|c\|\!\|\)?(.)$/).first
	109	add_filter field, (parms[0] \|\| "="), [parms[1] \|\| ""]
	110	end
	111
	112	def has_filter?(field)
	113	filters and filters[field]
	114	end
	115
	116	def operator_for(field)
	117	has_filter?(field) ? filters[field][:operator] : nil
	118	end
	119
	120	def values_for(field)
	121	has_filter?(field) ? filters[field][:values] : nil
	122	end
	123
	124	def statement
	125	sql = "1=1"
	126	sql << " AND issues.project_id=%d" % project.id if project
	127	filters.each_key do \|field\|
	128	v = values_for field
	129	next unless v and !v.empty?
	130	sql = sql + " AND " unless sql.empty?
	131	case operator_for field
	132	when "="
	133	sql = sql + "issues.#{field} IN (" + v.each(&:to_i).join(",") + ")"
	134	when "!"
	135	sql = sql + "issues.#{field} NOT IN (" + v.each(&:to_i).join(",") + ")"
	136	when "!*"
	137	sql = sql + "issues.#{field} IS NULL"
	138	when "*"
	139	sql = sql + "issues.#{field} IS NOT NULL"
	140	when "o"
	141	sql = sql + "issue_statuses.is_closed=#{connection.quoted_false}" if field == "status_id"
	142	when "c"
	143	sql = sql + "issue_statuses.is_closed=#{connection.quoted_true}" if field == "status_id"
	144	when ">t-"
	145	sql = sql + "issues.#{field} >= '%s'" % connection.quoted_date(Date.today - v.first.to_i)
	146	when "<t-"
	147	sql = sql + "issues.#{field} <= '" + (Date.today - v.first.to_i).strftime("%Y-%m-%d") + "'"
	148	when "t-"
	149	sql = sql + "issues.#{field} = '" + (Date.today - v.first.to_i).strftime("%Y-%m-%d") + "'"
	150	when ">t+"
	151	sql = sql + "issues.#{field} >= '" + (Date.today + v.first.to_i).strftime("%Y-%m-%d") + "'"
	152	when "<t+"
	153	sql = sql + "issues.#{field} <= '" + (Date.today + v.first.to_i).strftime("%Y-%m-%d") + "'"
	154	when "t+"
	155	sql = sql + "issues.#{field} = '" + (Date.today + v.first.to_i).strftime("%Y-%m-%d") + "'"
	156	when "t"
	157	sql = sql + "issues.#{field} = '%s'" % connection.quoted_date(Date.today)
	158	when "~"
	159	sql = sql + "issues.#{field} LIKE '%#{connection.quote_string(v.first)}%'"
	160	when "!~"
	161	sql = sql + "issues.#{field} NOT LIKE '%#{connection.quote_string(v.first)}%'"
	162	end
	163	end if filters and valid?
	164	sql
	165	end
	166	end

app/views/projects/add_query.rhtml created 644 +6 0

@@ -0,0 +1,6
	1	<h2><%= l(:label_query_new) %></h2>
	2
	3	<%= start_form_tag :action => 'add_query', :id => @project %>
	4	<%= render :partial => 'queries/form', :locals => {:query => @query} %>
	5	<%= submit_tag l(:button_create) %>
	6	<%= end_form_tag %> No newline at end of file

app/views/queries/_filters.rhtml created 644 +100 0

@@ -0,0 +1,100
	1	<script>
	2
	3	function add_filter() {
	4	select = $('add_filter_select');
	5	field = select.value
	6	Element.show('tr_' + field);
	7	check_box = $('cb_' + field);
	8	check_box.checked = true;
	9	toggle_filter(field);
	10	select.selectedIndex = 0;
	11
	12	for (i=0; i<select.options.length; i++) {
	13	if (select.options[i].value == field) {
	14	select.options[i].disabled = true;
	15	}
	16	}
	17	}
	18
	19	function toggle_filter(field) {
	20	check_box = $('cb_' + field);
	21
	22	if (check_box.checked) {
	23	Element.show("operators[" + field + "]");
	24	toggle_operator(field);
	25	} else {
	26	Element.hide("operators[" + field + "]");
	27	Element.hide("values_div[" + field + "]");
	28	}
	29	}
	30
	31	function toggle_operator(field) {
	32	operator = $("operators[" + field + "]");
	33	switch (operator.value) {
	34	case "!*":
	35	case "*":
	36	case "t":
	37	case "o":
	38	case "c":
	39	Element.hide("values_div[" + field + "]");
	40	break;
	41	default:
	42	Element.show("values_div[" + field + "]");
	43	break;
	44	}
	45	}
	46
	47	function toggle_multi_select(field) {
	48	select = $('values[' + field + '][]');
	49	if (select.multiple == true) {
	50	select.multiple = false;
	51	} else {
	52	select.multiple = true;
	53	}
	54	}
	55
	56	</script>
	57
	58	<fieldset style="margin:0;"><legend><%= l(:label_filter_plural) %></legend>
	59	<table width="100%" cellpadding=0 cellspacing=0>
	60	<tr>
	61	<td>
	62	<table>
	63	<% query.available_filters.sort{\|a,b\| a[1][:order]<=>b[1][:order]}.each do \|filter\| %>
	64	<% field = filter[0]
	65	options = filter[1] %>
	66	<tr <%= 'style="display:none;"' unless query.has_filter?(field) %> id="tr_<%= field %>">
	67	<td valign="top" width="200">
	68	<%= check_box_tag 'fields[]', field, query.has_filter?(field), :onclick => "toggle_filter('#{field}');", :id => "cb_#{field}" %>
	69	<label for="cb_<%= field %>"><%= l(("field_"+field.to_s.gsub(/\_id$/, "")).to_sym) %></label>
	70	</td>
	71	<td valign="top" width="150">
	72	<%= select_tag "operators[#{field}]", options_for_select(operators_for_select(options[:type]), query.operator_for(field)), :onchange => "toggle_operator('#{field}');", :class => "select-small", :style => "vertical-align: top;" %>
	73	</td>
	74	<td valign="top">
	75	<div id="values_div[<%= field %>]">
	76	<% case options[:type]
	77	when :list, :list_optional, :list_status %>
	78	<select <%= "multiple=true" if query.values_for(field) and query.values_for(field).length > 1 %>" name="values[<%= field %>][]" id="values[<%= field %>][]" class="select-small" style="vertical-align: top;">
	79	<%= options_for_select options[:values], query.values_for(field) %>
	80	</select>
	81	<%= link_to_function image_tag('expand'), "toggle_multi_select('#{field}');" %>
	82	<% when :date, :date_past %>
	83	<%= text_field_tag "values[#{field}][]", query.values_for(field), :size => 3, :class => "select-small" %> <%= l(:label_day_plural) %>
	84	<% when :text %>
	85	<%= text_field_tag "values[#{field}][]", query.values_for(field), :size => 30, :class => "select-small" %>
	86	<% end %>
	87	</div>
	88	</td>
	89	</tr>
	90	<script>toggle_filter('<%= field %>');</script>
	91	<% end %>
	92	</table>
	93	</td>
	94	<td align="right" valign="top">
	95	<%= l(:label_filter_add) %>:
	96	<%= select_tag 'add_filter_select', options_for_select([["",""]] + query.available_filters.sort{\|a,b\| a[1][:order]<=>b[1][:order]}.collect{\|field\| [l(("field_"+field[0].to_s.gsub(/\_id$/, "")).to_sym), field[0]] unless query.has_filter?(field[0])}.compact), :onchange => "add_filter();", :class => "select-small" %>
	97	</td>
	98	</tr>
	99	</table>
	100	</fieldset> No newline at end of file

app/views/queries/_form.rhtml created 644 +12 0

@@ -0,0 +1,12
	1	<%= error_messages_for 'query' %>
	2
	3	<!--[form:query]-->
	4	<div class="box">
	5	<div class="tabular">
	6	<p><label for="query_name"><%=l(:field_name)%></label>
	7	<%= text_field 'query', 'name', :size => 80 %></p>
	8	</div>
	9
	10	<%= render :partial => 'queries/filters', :locals => {:query => query}%>
	11	</div>
	12	<!--[eoform:query]--> No newline at end of file

app/views/queries/edit.rhtml created 644 +6 0

@@ -0,0 +1,6
	1	<h2><%= l(:label_query) %></h2>
	2
	3	<%= start_form_tag :action => 'edit', :id => @query %>
	4	<%= render :partial => 'form', :locals => {:query => @query} %>
	5	<%= submit_tag l(:button_save) %>
	6	<%= end_form_tag %> No newline at end of file

db/migrate/013_create_queries.rb created 644 +15 0

@@ -0,0 +1,15
	1	class CreateQueries < ActiveRecord::Migration
	2	def self.up
	3	create_table :queries, :force => true do \|t\|
	4	t.column "project_id", :integer
	5	t.column "name", :string, :default => "", :null => false
	6	t.column "filters", :text
	7	t.column "user_id", :integer, :default => 0, :null => false
	8	t.column "is_public", :boolean, :default => false, :null => false
	9	end
	10	end
	11
	12	def self.down
	13	drop_table :queries
	14	end
	15	end

db/migrate/014_add_queries_permissions.rb created 644 +9 0

@@ -0,0 +1,9
	1	class AddQueriesPermissions < ActiveRecord::Migration
	2	def self.up
	3	Permission.create :controller => "projects", :action => "add_query", :description => "button_create", :sort => 600, :is_public => false, :mail_option => 0, :mail_enabled => 0
	4	end
	5
	6	def self.down
	7	Permission.find(:first, :conditions => ["controller=? and action=?", 'projects', 'add_query']).destroy
	8	end
	9	end

public/images/check.png created 644 binary 0 0

NO CONTENT: new file 100644, binary diff hidden

public/images/expand.png created 644 binary 0 0

NO CONTENT: new file 100644, binary diff hidden

app/controllers/application.rb +3 -3

             # redMine - project management software
             # Copyright (C) 2006  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.
             class ApplicationController < ActionController::Base
               before_filter :check_if_login_required, :set_localization
               def logged_in_user=(user)
                 @logged_in_user = user
                 session[:user_id] = (user ? user.id : nil)
               end
               def logged_in_user
                 if session[:user_id]
                   @logged_in_user ||= User.find(session[:user_id], :include => :memberships)
                 else
                   nil
                 end
               end
               # check if login is globally required to access the application
               def check_if_login_required
                 require_login if $RDM_LOGIN_REQUIRED
               end
               def set_localization
                 lang = begin
                   if self.logged_in_user and self.logged_in_user.language and !self.logged_in_user.language.empty? and GLoc.valid_languages.include? self.logged_in_user.language.to_sym
                     self.logged_in_user.language
                   elsif request.env['HTTP_ACCEPT_LANGUAGE']
                     accept_lang = parse_qvalues(request.env['HTTP_ACCEPT_LANGUAGE']).first.split('-').first
                     if accept_lang and !accept_lang.empty? and GLoc.valid_languages.include? accept_lang.to_sym
                       accept_lang
                     end
                   end
                 rescue
                   nil
                 end || $RDM_DEFAULT_LANG
                 set_language_if_valid(lang)
               end
               def require_login
                 unless self.logged_in_user
                   store_location
                   redirect_to :controller => "account", :action => "login"
                   return false
                 end
                 true
               end
               def require_admin
                 return unless require_login
                 unless self.logged_in_user.admin?
                   render :nothing => true, :status => 403
                   return false
                 end
                 true
               end
               # authorizes the user for the requested action.
-              def authorize
+              def authorize(ctrl = @params[:controller], action = @params[:action])
                 # check if action is allowed on public projects
-                if @project.is_public? and Permission.allowed_to_public "%s/%s" % [ @params[:controller], @params[:action] ]
+                if @project.is_public? and Permission.allowed_to_public "%s/%s" % [ ctrl, action ]
                   return true
                 end
                 # if action is not public, force login
                 return unless require_login
                 # admin is always authorized
                 return true if self.logged_in_user.admin?
                 # if not admin, check membership permission
                 @user_membership ||= Member.find(:first, :conditions => ["user_id=? and project_id=?", self.logged_in_user.id, @project.id])
-                if @user_membership and Permission.allowed_to_role( "%s/%s" % [ @params[:controller], @params[:action] ], @user_membership.role_id )
+                if @user_membership and Permission.allowed_to_role( "%s/%s" % [ ctrl, action ], @user_membership.role_id )
                   return true
                 end
                 render :nothing => true, :status => 403
                 false
               end
               # store current uri in session.
               # return to this location by calling redirect_back_or_default
               def store_location
                 session[:return_to] = @request.request_uri
               end
               # move to the last store_location call or to the passed default one
               def redirect_back_or_default(default)
                 if session[:return_to].nil?
                   redirect_to default
                 else
                   redirect_to_url session[:return_to]
                   session[:return_to] = nil
                 end
               end
               # qvalues http header parser
               # code taken from webrick
               def parse_qvalues(value)
                 tmp = []
                 if value
                   parts = value.split(/,\s*/)
                   parts.each {|part|
                     if m = %r{^([^\s,]+?)(?:;\s*q=(\d+(?:\.\d+)?))?$}.match(part)
                       val = m[1]
                       q = (m[2] or 1).to_f
                       tmp.push([val, q])
                     end
                   }
                   tmp = tmp.sort_by{|val, q| -q}
                   tmp.collect!{|val, q| val}
                 end
                 return tmp
               end
             end

app/controllers/projects_controller.rb +56 -12

             # redMine - project management software
             # Copyright (C) 2006  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.
             class ProjectsController < ApplicationController
-              layout 'base', :except => :export_issues_pdf
+              layout 'base'
               before_filter :find_project, :authorize, :except => [ :index, :list, :add ]
               before_filter :require_admin, :only => [ :add, :destroy ]
               helper :sort
               include SortHelper
-              helper :search_filter
-              include SearchFilterHelper
               helper :custom_fields
               include CustomFieldsHelper
               helper :ifpdf
               include IfpdfHelper
               helper IssuesHelper
+              helper :queries
+              include QueriesHelper
               def index
                 list
                 render :action => 'list' unless request.xhr?
               end
               # Lists public projects
               def list
                 sort_init 'name', 'asc'
                 sort_update
                 @project_count = Project.count(["is_public=?", true])
                 @project_pages = Paginator.new self, @project_count,
 ,
             								@params['page']
                 @projects = Project.find :all, :order => sort_clause,
             						:conditions => ["is_public=?", true],
             						:limit  =>  @project_pages.items_per_page,
             						:offset =>  @project_pages.current.offset
                 render :action => "list", :layout => false if request.xhr?
               end
               # Add a new project
               def add
                 @custom_fields = IssueCustomField.find(:all)
                 @root_projects = Project.find(:all, :conditions => "parent_id is null")
                 @project = Project.new(params[:project])
                 if request.get?
                   @custom_values = ProjectCustomField.find(:all).collect { |x| CustomValue.new(:custom_field => x, :customized => @project) }
                 else
                   @project.custom_fields = CustomField.find(@params[:custom_field_ids]) if @params[:custom_field_ids]
                   @custom_values = ProjectCustomField.find(:all).collect { |x| CustomValue.new(:custom_field => x, :customized => @project, :value => params["custom_fields"][x.id.to_s]) }
                   @project.custom_values = @custom_values
                   if @project.save
                     flash[:notice] = l(:notice_successful_create)
                     redirect_to :controller => 'admin', :action => 'projects'
             	  end
                 end
               end
               # Show @project
               def show
                 @custom_values = @project.custom_values.find(:all, :include => :custom_field)
                 @members = @project.members.find(:all, :include => [:user, :role])
                 @subprojects = @project.children if @project.children_count > 0
                 @news = @project.news.find(:all, :limit => 5, :include => [ :author, :project ], :order => "news.created_on DESC")
                 @trackers = Tracker.find(:all)
               end
               def settings
                 @root_projects = Project::find(:all, :conditions => ["parent_id is null and id <> ?", @project.id])
                 @custom_fields = IssueCustomField::find_all
                 @issue_category ||= IssueCategory.new
                 @member ||= @project.members.new
                 @roles = Role.find_all
                 @users = User.find_all - @project.members.find(:all, :include => :user).collect{|m| m.user }
                 @custom_values ||= ProjectCustomField.find(:all).collect { |x| @project.custom_values.find_by_custom_field_id(x.id) || CustomValue.new(:custom_field => x) }
               end
               # Edit @project
               def edit
                 if request.post?
                   @project.custom_fields = IssueCustomField.find(@params[:custom_field_ids]) if @params[:custom_field_ids]
                   if params[:custom_fields]
                     @custom_values = ProjectCustomField.find(:all).collect { |x| CustomValue.new(:custom_field => x, :customized => @project, :value => params["custom_fields"][x.id.to_s]) }
                     @project.custom_values = @custom_values
                   end
                   if @project.update_attributes(params[:project])
                     flash[:notice] = l(:notice_successful_update)
                     redirect_to :action => 'settings', :id => @project
                   else
                     settings
                     render :action => 'settings'
                   end
                 end
               end
               # Delete @project
               def destroy
                 if request.post? and params[:confirm]
                   @project.destroy
                   redirect_to :controller => 'admin', :action => 'projects'
                 end
               end
               # Add a new issue category to @project
               def add_issue_category
                 if request.post?
                   @issue_category = @project.issue_categories.build(params[:issue_category])
                   if @issue_category.save
                     flash[:notice] = l(:notice_successful_create)
                     redirect_to :action => 'settings', :id => @project
                   else
                     settings
                     render :action => 'settings'
                   end
                 end
               end
               # Add a new version to @project
               def add_version
               	@version = @project.versions.build(params[:version])
               	if request.post? and @version.save
               	  flash[:notice] = l(:notice_successful_create)
                   redirect_to :action => 'settings', :id => @project
               	end
               end
               # Add a new member to @project
               def add_member
                 @member = @project.members.build(params[:member])
               	if request.post?
                   if @member.save
                     flash[:notice] = l(:notice_successful_create)
                     redirect_to :action => 'settings', :id => @project
                   else
                     settings
                     render :action => 'settings'
                   end
                 end
               end
               # Show members list of @project
               def list_members
                 @members = @project.members
               end
               # Add a new document to @project
               def add_document
                 @categories = Enumeration::get_values('DCAT')
                 @document = @project.documents.build(params[:document])
                 if request.post?
                   # Save the attachment
                   if params[:attachment][:file].size > 0
                     @attachment = @document.attachments.build(params[:attachment])
                     @attachment.author_id = self.logged_in_user.id if self.logged_in_user
                   end
                   if @document.save
                     flash[:notice] = l(:notice_successful_create)
                     redirect_to :action => 'list_documents', :id => @project
                   end
                 end
               end
               # Show documents list of @project
               def list_documents
                 @documents = @project.documents
               end
               # Add a new issue to @project
               def add_issue
                 @tracker = Tracker.find(params[:tracker_id])
                 @priorities = Enumeration::get_values('IPRI')
                 @issue = Issue.new(:project => @project, :tracker => @tracker)
                 if request.get?
                   @issue.start_date = Date.today
                   @custom_values = @project.custom_fields_for_issues(@tracker).collect { |x| CustomValue.new(:custom_field => x, :customized => @issue) }
                 else
                   @issue.attributes = params[:issue]
                   @issue.author_id = self.logged_in_user.id if self.logged_in_user
                   # Multiple file upload
                   params[:attachments].each { |a|
                     @attachment = @issue.attachments.build(:file => a, :author => self.logged_in_user) unless a.size == 0
                   } if params[:attachments] and params[:attachments].is_a? Array
                   @custom_values = @project.custom_fields_for_issues(@tracker).collect { |x| CustomValue.new(:custom_field => x, :customized => @issue, :value => params["custom_fields"][x.id.to_s]) }
                   @issue.custom_values = @custom_values
                   if @issue.save
                     flash[:notice] = l(:notice_successful_create)
                     Mailer.deliver_issue_add(@issue) if Permission.find_by_controller_and_action(@params[:controller], @params[:action]).mail_enabled?
                     redirect_to :action => 'list_issues', :id => @project
                   end
                 end
               end
               # Show filtered/sorted issues list of @project
               def list_issues
                 sort_init 'issues.id', 'desc'
                 sort_update
-                search_filter_init_list_issues
+                retrieve_query
-                search_filter_update if params[:set_filter]
                 @results_per_page_options = [ 15, 25, 50, 100 ]
                 if params[:per_page] and @results_per_page_options.include? params[:per_page].to_i
                   @results_per_page = params[:per_page].to_i
                   session[:results_per_page] = @results_per_page
                 else
                   @results_per_page = session[:results_per_page] || 25
                 end
-                @issue_count = Issue.count(:include => [:status, :project], :conditions => search_filter_clause)
+                if @query.valid?
+                  @issue_count = Issue.count(:include => [:status, :project], :conditions => @query.statement)
                   @issue_pages = Paginator.new self, @issue_count, @results_per_page, @params['page']
                   @issues = Issue.find :all, :order => sort_clause,
               						:include => [ :author, :status, :tracker, :project ],
-            						:conditions => search_filter_clause,
+              						:conditions => @query.statement,
               						:limit  =>  @issue_pages.items_per_page,
               						:offset =>  @issue_pages.current.offset
+                end
                 render :layout => false if request.xhr?
               end
               # Export filtered/sorted issues list to CSV
               def export_issues_csv
                 sort_init 'issues.id', 'desc'
                 sort_update
-                search_filter_init_list_issues
+                retrieve_query
+                render :action => 'list_issues' and return unless @query.valid?
                 @issues =  Issue.find :all, :order => sort_clause,
             						:include => [ :author, :status, :tracker, :project, :custom_values ],
-            						:conditions => search_filter_clause
+            						:conditions => @query.statement
                 ic = Iconv.new('ISO-8859-1', 'UTF-8')
                 export = StringIO.new
                 CSV::Writer.generate(export, l(:general_csv_separator)) do |csv|
                   # csv header fields
                   headers = [ "#", l(:field_status), l(:field_tracker), l(:field_subject), l(:field_author), l(:field_created_on), l(:field_updated_on) ]
                   for custom_field in @project.all_custom_fields
                     headers << custom_field.name
                   end
                   csv << headers.collect {|c| ic.iconv(c) }
                   # csv lines
                   @issues.each do |issue|
                     fields = [issue.id, issue.status.name, issue.tracker.name, issue.subject, issue.author.display_name, l_datetime(issue.created_on),  l_datetime(issue.updated_on)]
                     for custom_field in @project.all_custom_fields
                       fields << (show_value issue.custom_value_for(custom_field))
                     end
                     csv << fields.collect {|c| ic.iconv(c.to_s) }
                   end
                 end
                 export.rewind
                 send_data(export.read, :type => 'text/csv; header=present', :filename => 'export.csv')
               end
               # Export filtered/sorted issues to PDF
               def export_issues_pdf
                 sort_init 'issues.id', 'desc'
                 sort_update
-                search_filter_init_list_issues
+                retrieve_query
+                render :action => 'list_issues' and return unless @query.valid?
                 @issues =  Issue.find :all, :order => sort_clause,
             						:include => [ :author, :status, :tracker, :project, :custom_values ],
-            						:conditions => search_filter_clause
+            						:conditions => @query.statement
                 @options_for_rfpdf ||= {}
                 @options_for_rfpdf[:file_name] = "export.pdf"
+                render :layout => false
               end
               def move_issues
                 @issues = @project.issues.find(params[:issue_ids]) if params[:issue_ids]
                 redirect_to :action => 'list_issues', :id => @project and return unless @issues
                 @projects = []
                 # find projects to which the user is allowed to move the issue
                 @logged_in_user.memberships.each {|m| @projects << m.project if Permission.allowed_to_role("projects/move_issues", m.role_id)}
                 # issue can be moved to any tracker
                 @trackers = Tracker.find(:all)
                 if request.post? and params[:new_project_id] and params[:new_tracker_id]
                   new_project = Project.find(params[:new_project_id])
                   new_tracker = Tracker.find(params[:new_tracker_id])
                   @issues.each { |i|
                     # category is project dependent
                     i.category = nil unless i.project_id == new_project.id
                     # move the issue
                     i.project = new_project
                     i.tracker = new_tracker
                     i.save
                   }
                   flash[:notice] = l(:notice_successful_update)
                   redirect_to :action => 'list_issues', :id => @project
                 end
               end
+              def add_query
+                @query = Query.new(params[:query])
+                @query.project = @project
+                @query.user = logged_in_user
+                params[:fields].each do |field|
+                  @query.add_filter(field, params[:operators][field], params[:values][field])
+                end if params[:fields]
+                if request.post? and @query.save
+                  flash[:notice] = l(:notice_successful_create)
+                  redirect_to :controller => 'reports', :action => 'issue_report', :id => @project
+                end
+                render :layout => false if request.xhr?
+              end
               # Add a news to @project
               def add_news
                 @news = News.new(:project => @project)
                 if request.post?
                   @news.attributes = params[:news]
                   @news.author_id = self.logged_in_user.id if self.logged_in_user
                   if @news.save
                     flash[:notice] = l(:notice_successful_create)
                     redirect_to :action => 'list_news', :id => @project
                   end
                 end
               end
               # Show news list of @project
               def list_news
                 @news_pages, @news = paginate :news, :per_page => 10, :conditions => ["project_id=?", @project.id], :include => :author, :order => "news.created_on DESC"
                 render :action => "list_news", :layout => false if request.xhr?
               end
               def add_file
                 if request.post?
                   # Save the attachment
                   if params[:attachment][:file].size > 0
                     @attachment = @project.versions.find(params[:version_id]).attachments.build(params[:attachment])
                     @attachment.author_id = self.logged_in_user.id if self.logged_in_user
                     if @attachment.save
                       flash[:notice] = l(:notice_successful_create)
                       redirect_to :controller => 'projects', :action => 'list_files', :id => @project
                     end
                   end
                 end
                 @versions = @project.versions
               end
               def list_files
                 @versions = @project.versions
               end
               # Show changelog for @project
               def changelog
                 @trackers = Tracker.find(:all, :conditions => ["is_in_chlog=?", true])
                 if request.get?
                   @selected_tracker_ids = @trackers.collect {|t| t.id.to_s }
                 else
                   @selected_tracker_ids = params[:tracker_ids].collect { |id| id.to_i.to_s } if params[:tracker_ids] and params[:tracker_ids].is_a? Array
                 end
                 @selected_tracker_ids ||= []
                 @fixed_issues = @project.issues.find(:all,
                   :include => [ :fixed_version, :status, :tracker ],
                   :conditions => [ "issue_statuses.is_closed=? and issues.tracker_id in (#{@selected_tracker_ids.join(',')}) and issues.fixed_version_id is not null", true],
                   :order => "versions.effective_date DESC, issues.id DESC"
                 ) unless @selected_tracker_ids.empty?
                 @fixed_issues ||= []
               end
               def activity
                 if params[:year] and params[:year].to_i > 1900
                   @year = params[:year].to_i
                   if params[:month] and params[:month].to_i > 0 and params[:month].to_i < 13
                     @month = params[:month].to_i
                   end
                 end
                 @year ||= Date.today.year
                 @month ||= Date.today.month
                 @date_from = Date.civil(@year, @month, 1)
                 @date_to = (@date_from >> 1)-1
                 @events_by_day = {}
                 unless params[:show_issues] == "0"
                   @project.issues.find(:all, :include => [:author, :status], :conditions => ["issues.created_on>=? and issues.created_on<=?", @date_from, @date_to] ).each { |i|
                     @events_by_day[i.created_on.to_date] ||= []
                     @events_by_day[i.created_on.to_date] << i
                   }
                   @show_issues = 1
                 end
                 unless params[:show_news] == "0"
                   @project.news.find(:all, :conditions => ["news.created_on>=? and news.created_on<=?", @date_from, @date_to] ).each { |i|
                     @events_by_day[i.created_on.to_date] ||= []
                     @events_by_day[i.created_on.to_date] << i
                   }
                   @show_news = 1
                 end
                 unless params[:show_files] == "0"
                   Attachment.find(:all, :select => "attachments.*", :joins => "LEFT JOIN versions ON versions.id = attachments.container_id", :conditions => ["attachments.container_type='Version' and versions.project_id=? and attachments.created_on>=? and attachments.created_on<=?", @project.id, @date_from, @date_to] ).each { |i|
                     @events_by_day[i.created_on.to_date] ||= []
                     @events_by_day[i.created_on.to_date] << i
                   }
                   @show_files = 1
                 end
                 unless params[:show_documents] == "0"
                   @project.documents.find(:all, :conditions => ["documents.created_on>=? and documents.created_on<=?", @date_from, @date_to] ).each { |i|
                     @events_by_day[i.created_on.to_date] ||= []
                     @events_by_day[i.created_on.to_date] << i
                   }
                   Attachment.find(:all, :select => "attachments.*", :joins => "LEFT JOIN documents ON documents.id = attachments.container_id", :conditions => ["attachments.container_type='Document' and documents.project_id=? and attachments.created_on>=? and attachments.created_on<=?", @project.id, @date_from, @date_to] ).each { |i|
                     @events_by_day[i.created_on.to_date] ||= []
                     @events_by_day[i.created_on.to_date] << i
                   }
                   @show_documents = 1
                 end
                 render :layout => false if request.xhr?
               end
               def calendar
                 if params[:year] and params[:year].to_i > 1900
                   @year = params[:year].to_i
                   if params[:month] and params[:month].to_i > 0 and params[:month].to_i < 13
                     @month = params[:month].to_i
                   end
                 end
                 @year ||= Date.today.year
                 @month ||= Date.today.month
                 @date_from = Date.civil(@year, @month, 1)
                 @date_to = (@date_from >> 1)-1
                 # start on monday
                 @date_from = @date_from - (@date_from.cwday-1)
                 # finish on sunday
                 @date_to = @date_to + (7-@date_to.cwday)
                 @issues = @project.issues.find(:all, :include => :tracker, :conditions => ["((start_date>=? and start_date<=?) or (due_date>=? and due_date<=?))", @date_from, @date_to, @date_from, @date_to])
                 render :layout => false if request.xhr?
               end
               def gantt
                 if params[:year] and params[:year].to_i >0
                   @year_from = params[:year].to_i
                   if params[:month] and params[:month].to_i >=1 and params[:month].to_i <= 12
                     @month_from = params[:month].to_i
                   else
                     @month_from = 1
                   end
                 else
                   @month_from ||= (Date.today << 1).month
                   @year_from ||= (Date.today << 1).year
                 end
                 @zoom = (params[:zoom].to_i > 0 and params[:zoom].to_i < 5) ? params[:zoom].to_i : 2
                 @months = (params[:months].to_i > 0 and params[:months].to_i < 25) ? params[:months].to_i : 6
                 @date_from = Date.civil(@year_from, @month_from, 1)
                 @date_to = (@date_from >> @months) - 1
                 @issues = @project.issues.find(:all, :order => "start_date, due_date", :conditions => ["(((start_date>=? and start_date<=?) or (due_date>=? and due_date<=?) or (start_date<? and due_date>?)) and start_date is not null and due_date is not null)", @date_from, @date_to, @date_from, @date_to, @date_from, @date_to])
                 if params[:output]=='pdf'
                   @options_for_rfpdf ||= {}
                   @options_for_rfpdf[:file_name] = "gantt.pdf"
                   render :template => "projects/gantt.rfpdf", :layout => false
                 else
                   render :template => "projects/gantt.rhtml"
                 end
               end
             private
               # Find project of id params[:id]
               # if not found, redirect to project list
               # Used as a before_filter
               def find_project
                 @project = Project.find(params[:id])
                 @html_title = @project.name
               rescue
                 redirect_to :action => 'list'
               end
+              # Retrieve query from session or build a new query
+              def retrieve_query
+                if params[:query_id]
+                  @query = @project.queries.find(params[:query_id])
+                else
+                  if params[:set_filter] or !session[:query] or session[:query].project_id != @project.id
+                    # Give it a name, required to be valid
+                    @query = Query.new(:name => "_")
+                    @query.project = @project
+                    if params[:fields] and params[:fields].is_a? Array
+                      params[:fields].each do |field|
+                        @query.add_filter(field, params[:operators][field], params[:values][field])
+                      end
+                    else
+                      @query.available_filters.keys.each do |field|
+                        @query.add_short_filter(field, params[field]) if params[field]
+                      end
+                    end
+                    session[:query] = @query
+                  else
+                    @query = session[:query]
+                  end
+                end
+              end
             end

app/controllers/reports_controller.rb +1 0

             # redMine - project management software
             # Copyright (C) 2006  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.
             class ReportsController < ApplicationController
              	layout 'base'
             	before_filter :find_project, :authorize
               def issue_report
                 @statuses = IssueStatus.find_all
                 case params[:detail]
                 when "tracker"
                   @field = "tracker_id"
                   @rows = Tracker.find_all
                   @data = issues_by_tracker
                   @report_title = l(:field_tracker)
                   render :template => "reports/issue_report_details"
                 when "priority"
                   @field = "priority_id"
                   @rows = Enumeration::get_values('IPRI')
                   @data = issues_by_priority
                   @report_title = l(:field_priority)
                   render :template => "reports/issue_report_details"
                 when "category"
                   @field = "category_id"
                   @rows = @project.issue_categories
                   @data = issues_by_category
                   @report_title = l(:field_category)
                   render :template => "reports/issue_report_details"
                 when "author"
                   @field = "author_id"
                   @rows = @project.members.collect { |m| m.user }
                   @data = issues_by_author
                   @report_title = l(:field_author)
                   render :template => "reports/issue_report_details"
                 else
+                  @queries = @project.queries.find :all, :conditions => ["is_public=? or user_id=?", true, (logged_in_user ? logged_in_user.id : 0)]
                   @trackers = Tracker.find(:all)
                   @priorities = Enumeration::get_values('IPRI')
                   @categories = @project.issue_categories
                   @authors = @project.members.collect { |m| m.user }
                   issues_by_tracker
                   issues_by_priority
                   issues_by_category
                   issues_by_author
                   render :template => "reports/issue_report"
                 end
               end
               def delays
                 @trackers = Tracker.find(:all)
                 if request.get?
                   @selected_tracker_ids = @trackers.collect {|t| t.id.to_s }
                 else
                   @selected_tracker_ids = params[:tracker_ids].collect { |id| id.to_i.to_s } if params[:tracker_ids] and params[:tracker_ids].is_a? Array
                 end
                 @selected_tracker_ids ||= []
                 @raw =
                   ActiveRecord::Base.connection.select_all("SELECT datediff( a.created_on, b.created_on ) as delay, count(a.id) as total
                   FROM issue_histories a, issue_histories b, issues i
                   WHERE a.status_id =5
                   AND a.issue_id = b.issue_id
                   AND a.issue_id = i.id
                   AND i.tracker_id in (#{@selected_tracker_ids.join(',')})
                   AND b.id = (
                   SELECT min( c.id )
                   FROM issue_histories c
                   WHERE b.issue_id = c.issue_id )
                   GROUP BY delay") unless @selected_tracker_ids.empty?
                 @raw ||=[]
                 @x_from = 0
                 @x_to = 0
                 @y_from = 0
                 @y_to = 0
                 @sum_total = 0
                 @sum_delay = 0
                 @raw.each do |r|
                   @x_to = [r['delay'].to_i, @x_to].max
                   @y_to = [r['total'].to_i, @y_to].max
                   @sum_total = @sum_total + r['total'].to_i
                   @sum_delay = @sum_delay + r['total'].to_i * r['delay'].to_i
                 end
               end
             private
             	# Find project of id params[:id]
             	def find_project
             		@project = Project.find(params[:id])
             	end
             	def issues_by_tracker
                 @issues_by_tracker ||=
                     ActiveRecord::Base.connection.select_all("select    s.id as status_id,
                                                               s.is_closed as closed,
                                                               t.id as tracker_id,
                                                               count(i.id) as total
                                                             from
                                                               issues i, issue_statuses s, trackers t
                                                             where
                                                               i.status_id=s.id
                                                               and i.tracker_id=t.id
                                                               and i.project_id=#{@project.id}
                                                             group by s.id, s.is_closed, t.id")
             	end
             	def issues_by_priority
                 @issues_by_priority ||=
                   ActiveRecord::Base.connection.select_all("select    s.id as status_id,
                                                               s.is_closed as closed,
                                                               p.id as priority_id,
                                                               count(i.id) as total
                                                             from
                                                               issues i, issue_statuses s, enumerations p
                                                             where
                                                               i.status_id=s.id
                                                               and i.priority_id=p.id
                                                               and i.project_id=#{@project.id}
                                                             group by s.id, s.is_closed, p.id")
             	end
             	def issues_by_category
                 @issues_by_category ||=
                   ActiveRecord::Base.connection.select_all("select    s.id as status_id,
                                                               s.is_closed as closed,
                                                               c.id as category_id,
                                                               count(i.id) as total
                                                             from
                                                               issues i, issue_statuses s, issue_categories c
                                                             where
                                                               i.status_id=s.id
                                                               and i.category_id=c.id
                                                               and i.project_id=#{@project.id}
                                                             group by s.id, s.is_closed, c.id")
             	end
             	def issues_by_author
                 @issues_by_author ||=
                   ActiveRecord::Base.connection.select_all("select    s.id as status_id,
                                                               s.is_closed as closed,
                                                               a.id as author_id,
                                                               count(i.id) as total
                                                             from
                                                               issues i, issue_statuses s, users a
                                                             where
                                                               i.status_id=s.id
                                                               and i.author_id=a.id
                                                               and i.project_id=#{@project.id}
                                                             group by s.id, s.is_closed, a.id")
             	end
             end

app/models/permission.rb +1 0

             # redMine - project management software
             # Copyright (C) 2006  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.
             class Permission < ActiveRecord::Base
               has_and_belongs_to_many :roles
               validates_presence_of :controller, :action, :description
               GROUPS = {
 => :label_project,
 => :label_member_plural,
 => :label_version_plural,
 => :label_issue_category_plural,
+=> :label_query_plural,
 => :label_issue_plural,
 => :label_news_plural,
 => :label_document_plural,
 => :label_attachment_plural,
               }.freeze
               @@cached_perms_for_public = nil
               @@cached_perms_for_roles = nil
               def name
                 self.controller + "/" + self.action
               end
               def group_id
                 (self.sort / 100)*100
               end
               def self.allowed_to_public(action)
                 @@cached_perms_for_public ||= find(:all, :conditions => ["is_public=?", true]).collect {|p| "#{p.controller}/#{p.action}"}
                 @@cached_perms_for_public.include? action
               end
               def self.allowed_to_role(action, role)
                 @@cached_perms_for_roles ||=
                   begin
                     perms = {}
                     find(:all, :include => :roles).each {|p| perms.store "#{p.controller}/#{p.action}", p.roles.collect {|r| r.id } }
                     perms
                   end
                 @@cached_perms_for_roles[action] and @@cached_perms_for_roles[action].include? role
               end
               def self.allowed_to_role_expired
                 @@cached_perms_for_roles = nil
               end
             end

app/models/project.rb +1 0

             # redMine - project management software
             # Copyright (C) 2006  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.
             class Project < ActiveRecord::Base
               has_many :versions, :dependent => true, :order => "versions.effective_date DESC, versions.name DESC"
               has_many :members, :dependent => true
               has_many :users, :through => :members
               has_many :custom_values, :dependent => true, :as => :customized
               has_many :issues, :dependent => true, :order => "issues.created_on DESC", :include => :status
+              has_many :queries, :dependent => true
               has_many :documents, :dependent => true
               has_many :news, :dependent => true, :include => :author
               has_many :issue_categories, :dependent => true, :order => "issue_categories.name"
               has_and_belongs_to_many :custom_fields, :class_name => 'IssueCustomField', :join_table => 'custom_fields_projects', :association_foreign_key => 'custom_field_id'
               acts_as_tree :order => "name", :counter_cache => true
               validates_presence_of :name, :description
               validates_uniqueness_of :name
               validates_associated :custom_values, :on => :update
               # returns 5 last created projects
               def self.latest
                 find(:all, :limit => 5, :order => "created_on DESC")
               end
               # Returns an array of all custom fields enabled for project issues
               # (explictly associated custom fields and custom fields enabled for all projects)
               def custom_fields_for_issues(tracker)
                 tracker.custom_fields.find(:all, :include => :projects,
                                            :conditions => ["is_for_all=? or project_id=?", true, self.id])
                 #(CustomField.for_all + custom_fields).uniq
               end
               def all_custom_fields
                 @all_custom_fields ||= IssueCustomField.find(:all, :include => :projects,
                                            :conditions => ["is_for_all=? or project_id=?", true, self.id])
               end
             protected
               def validate
                 errors.add(parent_id, " must be a root project") if parent and parent.parent
                 errors.add_to_base("A project with subprojects can't be a subproject") if parent and projects_count > 0
               end
             end

app/views/projects/list_issues.rhtml +38 -26

-            <div class="contextual">
+            <% if @query.new_record? %>
-            <%= l(:label_export_to) %>
-            <%= link_to 'CSV', {:action => 'export_issues_csv', :id => @project}, :class => 'pic picCsv' %>,
-            <%= link_to 'PDF', {:action => 'export_issues_pdf', :id => @project}, :class => 'pic picPdf' %>
-            </div>
                 <h2><%=l(:label_issue_plural)%></h2>
-            <%= start_form_tag :action => 'list_issues' %>
+                <%= start_form_tag({:action => 'list_issues'}, :id => 'query_form') %>
-            <table cellpadding=2>
+                <%= render :partial => 'queries/filters', :locals => {:query => @query} %>
-              <tr>
-                <td valign="bottom"><small><%=l(:field_status)%>:</small><br /><%= search_filter_tag 'status_id', :class => 'select-small' %></td>
-                <td valign="bottom"><small><%=l(:field_tracker)%>:</small><br /><%= search_filter_tag 'tracker_id', :class => 'select-small' %></td>
-                <td valign="bottom"><small><%=l(:field_priority)%>:</small><br /><%= search_filter_tag 'priority_id', :class => 'select-small' %></td>
-                <td valign="bottom"><small><%=l(:field_category)%>:</small><br /><%= search_filter_tag 'category_id', :class => 'select-small' %></td>
-                <td valign="bottom"><small><%=l(:field_fixed_version)%>:</small><br /><%= search_filter_tag 'fixed_version_id', :class => 'select-small' %></td>
-                <td valign="bottom"><small><%=l(:field_author)%>:</small><br /><%= search_filter_tag 'author_id', :class => 'select-small' %></td>
-                <td valign="bottom"><small><%=l(:field_assigned_to)%>:</small><br /><%= search_filter_tag 'assigned_to_id', :class => 'select-small' %></td>
-                <td valign="bottom"><small><%=l(:label_subproject_plural)%>:</small><br /><%= search_filter_tag 'subproject_id', :class => 'select-small' %></td>
-                <td valign="bottom">
-                  <%= hidden_field_tag 'set_filter', 1 %>
-                  <%= submit_tag l(:button_apply), :class => 'button-small' %>
-                </td>
-                <td valign="bottom">
-                  <%= link_to l(:button_clear), :action => 'list_issues', :id => @project, :set_filter => 1 %>
-                </td>
-              </tr>
-            </table>
                 <%= end_form_tag %>
+                <div class="contextual">
+                <%= link_to_remote l(:button_apply),
+                                   { :url => { :controller => 'projects', :action => 'list_issues', :id => @project, :set_filter => 1 },
+                                     :update => "content",
+                                     :with => "Form.serialize('query_form')"
+                                   }, :class => 'pic picCheck' %>
+                <%= link_to l(:button_clear), {:controller => 'projects', :action => 'list_issues', :id => @project, :set_filter => 1}, :class => 'pic picDelete'  %>
+                <% if authorize_for('projects', 'add_query') %>
+                <%= link_to_remote l(:button_save),
+                                   { :url => { :controller => 'projects', :action => "add_query", :id => @project },
+                                     :method => 'get',
+                                     :update => "content",
+                                     :with => "Form.serialize('query_form')"
+                                   }, :class => 'pic picEdit' %>
+                <% end %>
+                </div>
+                <br />
+            <% else %>
+                <% if authorize_for('projects', 'add_query') %>
+                <div class="contextual">
+                    <%= link_to l(:button_edit), {:controller => 'queries', :action => 'edit', :id => @query}, :class => 'pic picEdit' %>
+                    <%= link_to l(:button_delete), {:controller => 'queries', :action => 'destroy', :id => @query}, :confirm => l(:text_are_you_sure), :post => true, :class => 'pic picDelete' %>
+                </div>
+                <% end %>
+                <h2><%= @query.name %></h2>
+            <% end %>
+            <%= error_messages_for 'query' %>
+            <% if @query.valid? %>
             &nbsp;
             <table class="listTableContent">
                 <tr>
                 <td colspan="6" align="left"><small><%= check_all_links 'issues_form' %></small></td>
                 <td colspan="2" align="right">
                     <small><%= l(:label_per_page) %>:</small>
                     <%= start_form_tag %>
                     <%= select_tag 'per_page', options_for_select(@results_per_page_options, @results_per_page), :class => 'select-small'%>
                     <%= submit_tag l(:button_apply), :class => 'button-small'%>
                     <%= end_form_tag %>
                 </td>
                 </tr>
             </table>
             <%= start_form_tag({:controller => 'projects', :action => 'move_issues', :id => @project}, :id => 'issues_form' ) %>
             <table class="listTableContent">
                 <tr class="ListHead">
                     <td></td>
             		<%= sort_header_tag('issues.id', :caption => '#') %>
             		<%= sort_header_tag('issue_statuses.name', :caption => l(:field_status)) %>
             		<%= sort_header_tag('issues.tracker_id', :caption => l(:field_tracker)) %>
             		<th><%=l(:field_subject)%></th>
             		<%= sort_header_tag('users.lastname', :caption => l(:field_author)) %>
             		<%= sort_header_tag('issues.created_on', :caption => l(:field_created_on)) %>
             		<%= sort_header_tag('issues.updated_on', :caption => l(:field_updated_on)) %>
             	</tr>
             	<% for issue in @issues %>
             	<tr class="<%= cycle("odd", "even") %>">
             	    <td width="15"><%= check_box_tag "issue_ids[]", issue.id %></td>
             		<td align="center"><%= link_to issue.long_id, :controller => 'issues', :action => 'show', :id => issue %></td>
             		<td align="center" style="font-weight:bold;color:#<%= issue.status.html_color %>;"><%= issue.status.name %></font></td>
             		<td align="center"><%= issue.tracker.name %></td>
             		<td><%= link_to issue.subject, :controller => 'issues', :action => 'show', :id => issue %></td>
             		<td align="center"><%= issue.author.display_name %></td>
             		<td align="center"><%= format_time(issue.created_on) %></td>
             		<td align="center"><%= format_time(issue.updated_on) %></td>
             	</tr>
             	<% end %>
             </table>
+            <div class="contextual">
+            <%= l(:label_export_to) %>
+            <%= link_to 'CSV', {:action => 'export_issues_csv', :id => @project}, :class => 'pic picCsv' %>,
+            <%= link_to 'PDF', {:action => 'export_issues_pdf', :id => @project}, :class => 'pic picPdf' %>
+            </div>
             <p>
             <%= pagination_links_full @issue_pages %>
             [ <%= @issue_pages.current.first_item %> - <%= @issue_pages.current.last_item %> / <%= @issue_count %> ]
             </p>
             <%= submit_tag l(:button_move) %>
             <%= end_form_tag %>
+            <% end %>
  No newline at end of file

app/views/reports/_details.rhtml +3 -3

             <% if @statuses.empty? or rows.empty? %>
                 <p><i><%=l(:label_no_data)%></i></p>
             <% else %>
             <% col_width = 70 / (@statuses.length+3) %>
             <table class="reportTableContent">
             <tr>
             <td width="25%"></td>
             <% for status in @statuses %>
               <td align="center" width="<%= col_width %>%" bgcolor="#<%= status.html_color %>"><small><%= status.name %></small></td>
             <% end %>
             <td align="center" width="<%= col_width %>%"><strong><%=l(:label_open_issues_plural)%></strong></td>
             <td align="center" width="<%= col_width %>%"><strong><%=l(:label_closed_issues_plural)%></strong></td>
             <td align="center" width="<%= col_width %>%"><strong><%=l(:label_total)%></strong></td>
             </tr>
             <% for row in rows %>
             <tr class="<%= cycle("odd", "even") %>">
               <td><%= link_to row.name, :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "#{field_name}" => row.id %></td>
               <% for status in @statuses %>
                 <td align="center"><%= link_to (aggregate data, { field_name => row.id, "status_id" => status.id }),
                                                             :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "status_id" => status.id,
                                                             "#{field_name}" => row.id %></td>
               <% end %>
               <td align="center"><%= link_to (aggregate data, { field_name => row.id, "closed" => 0 }),
                                                             :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "#{field_name}" => row.id,
-                                                            "status_id" => "O" %></td>
+                                                            "status_id" => "o" %></td>
               <td align="center"><%= link_to (aggregate data, { field_name => row.id, "closed" => 1 }),
                                                             :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "#{field_name}" => row.id,
-                                                            "status_id" => "C" %></td>
+                                                            "status_id" => "c" %></td>
               <td align="center"><%= link_to (aggregate data, { field_name => row.id }),
                                                             :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "#{field_name}" => row.id,
-                                                            "status_id" => "A" %></td>
+                                                            "status_id" => "*" %></td>
             <% end %>
             </tr>
             </table>
             <% end
               reset_cycle %>

app/views/reports/_simple.rhtml +3 -3

             <% if @statuses.empty? or rows.empty? %>
                 <p><i><%=l(:label_no_data)%></i></p>
             <% else %>
             <table class="reportTableContent">
             <tr>
             <td width="25%"></td>
             <td align="center" width="25%"><%=l(:label_open_issues_plural)%></td>
             <td align="center" width="25%"><%=l(:label_closed_issues_plural)%></td>
             <td align="center" width="25%"><%=l(:label_total)%></td>
             </tr>
             <% for row in rows %>
             <tr class="<%= cycle("odd", "even") %>">
               <td><%= link_to row.name, :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "#{field_name}" => row.id %></td>
               <td align="center"><%= link_to (aggregate data, { field_name => row.id, "closed" => 0 }),
                                                             :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "#{field_name}" => row.id,
-                                                            "status_id" => "O" %></td>
+                                                            "status_id" => "o" %></td>
               <td align="center"><%= link_to (aggregate data, { field_name => row.id, "closed" => 1 }),
                                                             :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "#{field_name}" => row.id,
-                                                            "status_id" => "C" %></td>
+                                                            "status_id" => "c" %></td>
               <td align="center"><%= link_to (aggregate data, { field_name => row.id }),
                                                             :controller => 'projects', :action => 'list_issues', :id => @project,
                                                             :set_filter => 1,
                                                             "#{field_name}" => row.id,
-                                                            "status_id" => "A" %></td>
+                                                            "status_id" => "*" %></td>
             <% end %>
             </tr>
             </table>
             <% end
               reset_cycle %>

app/views/reports/issue_report.rhtml +16 -4

             <h2><%=l(:label_report_plural)%></h2>
+            <h3><%= l(:label_query_plural) %></h3>
+            <div class="contextual">
+            <%= link_to_if_authorized l(:label_query_new), {:controller => 'projects', :action => 'add_query', :id => @project}, :class => 'pic picAdd' %>
+            </div>
+            <% if @queries.empty? %><p><i><%=l(:label_no_data)%></i></p><% end %>
+            <ul>
+            <% @queries.each do |query| %>
+                <li><%= link_to query.name, :controller => 'projects', :action => 'list_issues', :id => @project, :query_id => query %></li>
+            <% end %>
+            </ul>
             <div class="splitcontentleft">
-            <h3><%=l(:field_tracker)%>&nbsp;&nbsp;<%= link_to image_tag('details'), :detail => 'author' %></h3>
+            <h3><%=l(:field_tracker)%>&nbsp;&nbsp;<%= link_to image_tag('details'), :detail => 'tracker' %></h3>
             <%= render :partial => 'simple', :locals => { :data => @issues_by_tracker, :field_name => "tracker_id", :rows => @trackers } %>
             <br />
-            <h3><%=l(:field_priority)%>&nbsp;&nbsp;<%= link_to image_tag('details'), :detail => 'priority' %></h3>
-            <%= render :partial => 'simple', :locals => { :data => @issues_by_priority, :field_name => "priority_id", :rows => @priorities } %>
-            <br />
             <h3><%=l(:field_author)%>&nbsp;&nbsp;<%= link_to image_tag('details'), :detail => 'author' %></h3>
             <%= render :partial => 'simple', :locals => { :data => @issues_by_author, :field_name => "author_id", :rows => @authors } %>
             <br />
             </div>
             <div class="splitcontentright">
+            <h3><%=l(:field_priority)%>&nbsp;&nbsp;<%= link_to image_tag('details'), :detail => 'priority' %></h3>
+            <%= render :partial => 'simple', :locals => { :data => @issues_by_priority, :field_name => "priority_id", :rows => @priorities } %>
+            <br />
             <h3><%=l(:field_category)%>&nbsp;&nbsp;<%= link_to image_tag('details'), :detail => 'category' %></h3>
             <%= render :partial => 'simple', :locals => { :data => @issues_by_category, :field_name => "category_id", :rows => @categories } %>
             <br />
             </div>

lang/de.yml +17 0

             _gloc_rule_default: '|n| n==1 ? "" : "_plural" '
             actionview_datehelper_select_day_prefix:
             actionview_datehelper_select_month_names: January,February,March,April,May,June,July,August,September,October,November,December
             actionview_datehelper_select_month_names_abbr: Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec
             actionview_datehelper_select_month_prefix:
             actionview_datehelper_select_year_prefix:
             actionview_datehelper_time_in_words_day: 1 day
             actionview_datehelper_time_in_words_day_plural: %d days
             actionview_datehelper_time_in_words_hour_about: about an hour
             actionview_datehelper_time_in_words_hour_about_plural: about %d hours
             actionview_datehelper_time_in_words_hour_about_single: about an hour
             actionview_datehelper_time_in_words_minute: 1 minute
             actionview_datehelper_time_in_words_minute_half: half a minute
             actionview_datehelper_time_in_words_minute_less_than: less than a minute
             actionview_datehelper_time_in_words_minute_plural: %d minutes
             actionview_datehelper_time_in_words_minute_single: 1 minute
             actionview_datehelper_time_in_words_second_less_than: less than a second
             actionview_datehelper_time_in_words_second_less_than_plural: less than %d seconds
             actionview_instancetag_blank_option: Bitte auserwählt
             activerecord_error_inclusion: ist nicht in der Liste eingeschlossen
             activerecord_error_exclusion: ist reserviert
             activerecord_error_invalid: ist unzulässig
             activerecord_error_confirmation: bringt nicht Bestätigung zusammen
             activerecord_error_accepted: muß angenommen werden
             activerecord_error_empty: kann nicht leer sein
             activerecord_error_blank: kann nicht leer sein
             activerecord_error_too_long: ist zu lang
             activerecord_error_too_short: ist zu kurz
             activerecord_error_wrong_length: ist die falsche Länge
             activerecord_error_taken: ist bereits genommen worden
             activerecord_error_not_a_number: ist nicht eine Zahl
             activerecord_error_not_a_date: ist nicht ein gültiges Datum
             activerecord_error_greater_than_start_date: muß als grösser sein beginnen Datum
             general_fmt_age: %d yr
             general_fmt_age_plural: %d yrs
             general_fmt_date: %%b %%d, %%Y (%%a)
             general_fmt_datetime: %%b %%d, %%Y (%%a), %%I:%%M %%p
             general_fmt_datetime_short: %%b %%d, %%I:%%M %%p
             general_fmt_time: %%I:%%M %%p
             general_text_No: 'Nein'
             general_text_Yes: 'Ja'
             general_text_no: 'nein'
             general_text_yes: 'ja'
             general_lang_de: 'Deutsch'
             general_csv_separator: ';'
             general_day_names: Montag,Dienstag,Mittwoch,Donnerstag,Freitag,Samstag,Sonntag
             notice_account_updated: Konto wurde erfolgreich aktualisiert.
             notice_account_invalid_creditentials: Unzulässiger Benutzer oder Passwort
             notice_account_password_updated: Passwort wurde erfolgreich aktualisiert.
             notice_account_wrong_password: Falsches Passwort
             notice_account_register_done: Konto wurde erfolgreich verursacht.
             notice_account_unknown_email: Unbekannter Benutzer.
             notice_can_t_change_password: Dieses Konto verwendet eine externe Authentisierung Quelle. Unmöglich, das Kennwort zu ändern.
             notice_account_lost_email_sent: Ein email mit Anweisungen, ein neues Kennwort zu wählen ist dir geschickt worden.
             notice_account_activated: Dein Konto ist aktiviert worden. Du kannst jetzt einloggen.
             notice_successful_create: Erfolgreiche Kreation.
             notice_successful_update: Erfolgreiches Update.
             notice_successful_delete: Erfolgreiche Auslassung.
             notice_successful_connection: Erfolgreicher Anschluß.
             notice_file_not_found: Erbetene Akte besteht nicht oder ist gelöscht worden.
             notice_locking_conflict: Data have been updated by another user.
             mail_subject_lost_password: Dein redMine Kennwort
             mail_subject_register: redMine Kontoaktivierung
             gui_validation_error: 1 Störung
             gui_validation_error_plural: %d Störungen
             field_name: Name
             field_description: Beschreibung
             field_summary: Zusammenfassung
             field_is_required: Erforderlich
             field_firstname: Vorname
             field_lastname: Nachname
             field_mail: Email
             field_filename: Datei
             field_filesize: Grootte
             field_downloads: Downloads
             field_author: Autor
             field_created_on: Angelegt
             field_updated_on: aktualisiert
             field_field_format: Format
             field_is_for_all: Für alle Projekte
             field_possible_values: Mögliche Werte
             field_regexp: Regulärer Ausdruck
             field_min_length: Minimale Länge
             field_max_length: Maximale Länge
             field_value: Wert
             field_category: Kategorie
             field_title: Títel
             field_project: Projekt
             field_issue: Antrag
             field_status: Status
             field_notes: Anmerkungen
             field_is_closed: Problem erledigt
             field_is_default: Rückstellung status
             field_html_color: Farbe
             field_tracker: Tracker
             field_subject: Thema
             field_due_date: Abgabedatum
             field_assigned_to: Zugewiesen an
             field_priority: Priorität
             field_fixed_version: Erledigt in Version
             field_user: Benutzer
             field_role: Rolle
             field_homepage: Startseite
             field_is_public: Öffentlich
             field_parent: Subprojekt von
             field_is_in_chlog: Ansicht der Issues in der Historie
             field_login: Mitgliedsname
             field_mail_notification: Mailbenachrichtigung
             field_admin: Administrator
             field_locked: Gesperrt
             field_last_login_on: Letzte Anmeldung
             field_language: Sprache
             field_effective_date: Datum
             field_password: Passwort
             field_new_password: Neues Passwort
             field_password_confirmation: Bestätigung
             field_version: Version
             field_type: Typ
             field_host: Host
             field_port: Port
             field_account: Konto
             field_base_dn: Base DN
             field_attr_login: Mitgliedsnameattribut
             field_attr_firstname: Vornamensattribut
             field_attr_lastname: Namenattribut
             field_attr_mail: Emailattribut
             field_onthefly: On-the-fly Benutzerkreation
             field_start_date: Beginn
             field_done_ratio: %% Getan
             field_hide_mail: Mein email address verstecken
             field_comment: Anmerkung
             label_user: Benutzer
             label_user_plural: Benutzer
             label_user_new: Neuer Benutzer
             label_project: Projekt
             label_project_new: Neues Projekt
             label_project_plural: Projekte
             label_project_latest: Neueste Projekte
             label_issue: Antrag
             label_issue_new: Neue Antrag
             label_issue_plural: Anträge
             label_issue_view_all: Alle Anträge ansehen
             label_document: Dokument
             label_document_new: Neues Dokument
             label_document_plural: Dokumente
             label_role: Rolle
             label_role_plural: Rollen
             label_role_new: Neue Rolle
             label_role_and_permissions: Rollen und Rechte
             label_member: Mitglied
             label_member_new: Neues Mitglied
             label_member_plural: Mitglieder
             label_tracker: Tracker
             label_tracker_plural: Tracker
             label_tracker_new: Neuer Tracker
             label_workflow: Workflow
             label_issue_status: Antrag Status
             label_issue_status_plural: Antrag Stati
             label_issue_status_new: Neuer Status
             label_issue_category: Antrag Kategorie
             label_issue_category_plural: Antrag Kategorien
             label_issue_category_new: Neue Kategorie
             label_custom_field: Benutzerdefiniertes Feld
             label_custom_field_plural: Benutzerdefinierte Felder
             label_custom_field_new: Neues Feld
             label_enumerations: Enumerationen
             label_enumeration_new: Neuer Wert
             label_information: Information
             label_information_plural: Informationen
             label_please_login: Anmelden
             label_register: Anmelden
             label_password_lost: Passwort vergessen
             label_home: Hauptseite
             label_my_page: Meine Seite
             label_my_account: Mein Konto
             label_my_projects: Meine Projekte
             label_administration: Administration
             label_login: Einloggen
             label_logout: Abmelden
             label_help: Hilfe
             label_reported_issues: Gemeldete Issues
             label_assigned_to_me_issues: Mir zugewiesen
             label_last_login: Letzte Anmeldung
             label_last_updates: Letztes aktualisiertes
             label_last_updates_plural: %d Letztes aktualisiertes
             label_registered_on: Angemeldet am
             label_activity: Aktivität
             label_new: Neue
             label_logged_as: Angemeldet als
             label_environment: Environment
             label_authentication: Authentisierung
             label_auth_source: Authentisierung Modus
             label_auth_source_new: Neuer Authentisierung Modus
             label_auth_source_plural: Authentisierung Modi
             label_subproject: Vorprojekt von
             label_subproject_plural: Vorprojekte
             label_min_max_length: Min - Max Länge
             label_list: Liste
             label_date: Date
             label_integer: Zahl
             label_boolean: Boolesch
             label_string: Text
             label_text: Langer Text
             label_attribute: Attribut
             label_attribute_plural: Attribute
             label_download: %d Herunterlade
             label_download_plural: %d Herunterlade
             label_no_data: Nichts anzuzeigen
             label_change_status: Statuswechsel
             label_history: Historie
             label_attachment: Datei
             label_attachment_new: Neue Datei
             label_attachment_delete: Löschungakten
             label_attachment_plural: Dateien
             label_report: Bericht
             label_report_plural: Berichte
             label_news: Neuigkeit
             label_news_new: Neuigkeite addieren
             label_news_plural: Neuigkeiten
             label_news_latest: Letzte Neuigkeiten
             label_news_view_all: Alle Neuigkeiten anzeigen
             label_change_log: Change log
             label_settings: Konfiguration
             label_overview: Übersicht
             label_version: Version
             label_version_new: Neue Version
             label_version_plural: Versionen
             label_confirmation: Bestätigung
             label_export_to: Export zu
             label_read: Lesen...
             label_public_projects: Öffentliche Projekte
             label_open_issues: Geöffnet
             label_open_issues_plural: Geöffnet
             label_closed_issues: Geschlossen
             label_closed_issues_plural: Geschlossen
             label_total: Gesamtzahl
             label_permissions: Berechtigungen
             label_current_status: Gegenwärtiger Status
             label_new_statuses_allowed: Neue Status gewährten
             label_all: Alle
             label_none: Kein
             label_next: Weiter
             label_previous: Zurück
             label_used_by: Benutzt von
             label_details: Details...
             label_add_note: Eine Anmerkung addieren
             label_per_page: Pro Seite
             label_calendar: Kalender
             label_months_from: Monate von
             label_gantt: Gantt
             label_internal: Intern
             label_last_changes: %d änderungen des Letzten
             label_change_view_all: Alle änderungen ansehen
             label_personalize_page: Diese Seite personifizieren
             label_comment: Anmerkung
             label_comment_plural: Anmerkungen
             label_comment_add: Anmerkung addieren
             label_comment_added: Anmerkung fügte hinzu
             label_comment_delete: Anmerkungen löschen
+            label_query: Benutzerdefiniertes Frage
+            label_query_plural: Benutzerdefinierte Fragen
+            label_query_new: Neue Frage
+            label_filter_add: Filter addieren
+            label_filter_plural: Filter
+            label_equals: ist
+            label_not_equals: ist nicht
+            label_in_less_than: an weniger als
+            label_in_more_than: an mehr als
+            label_in: an
+            label_today: heute
+            label_less_than_ago: vor weniger als
+            label_more_than_ago: vor mehr als
+            label_ago: vor
+            label_contains: enthält
+            label_not_contains: enthält nicht
+            label_day_plural: Tage
             button_login: Einloggen
             button_submit: Einreichen
             button_save: Speichern
             button_check_all: Alles auswählen
             button_uncheck_all: Alles abwählen
             button_delete: Löschen
             button_create: Anlegen
             button_test: Testen
             button_edit: Bearbeiten
             button_add: Hinzufügen
             button_change: Wechseln
             button_apply: Anwenden
             button_clear: Zurücksetzen
             button_lock: Verriegeln
             button_unlock: Entriegeln
             button_download: Fernzuladen
             button_list: Aufzulisten
             button_view: Siehe
             button_move: Bewegen
             button_back: Rückkehr
             button_cancel: Annullieren
             text_select_mail_notifications: Aktionen für die Mailbenachrichtigung aktiviert werden soll.
             text_regexp_info: eg. ^[A-Z0-9]+$
             text_min_max_length_info: 0 heisst keine Beschränkung
             text_possible_values_info: Werte trennten sich mit |
             text_project_destroy_confirmation: Sind sie sicher, daß sie das Projekt löschen wollen ?
             text_workflow_edit: Auswahl Workflow zum Bearbeiten
             text_are_you_sure: Sind sie sicher ?
             text_journal_changed: geändert von %s zu %s
             text_journal_set_to: gestellt zu %s
             text_journal_deleted: gelöscht
             text_tip_task_begin_day: Aufgabe, die an diesem Tag beginnt
             text_tip_task_end_day: Aufgabe, die an diesem Tag beendet
             text_tip_task_begin_end_day: Aufgabe, die an diesem Tag beginnt und beendet
             default_role_manager: Manager
             default_role_developper: Developer
             default_role_reporter: Reporter
             default_tracker_bug: Fehler
             default_tracker_feature: Feature
             default_tracker_support: Support
             default_issue_status_new: Neu
             default_issue_status_assigned: Zugewiesen
             default_issue_status_resolved: Gelöst
             default_issue_status_feedback: Feedback
             default_issue_status_closed: Erledigt
             default_issue_status_rejected: Abgewiesen
             default_doc_category_user: Benutzerdokumentation
             default_doc_category_tech: Technische Dokumentation
             default_priority_low: Niedrig
             default_priority_normal: Normal
             default_priority_high: Hoch
             default_priority_urgent: Dringend
             default_priority_immediate: Sofort
             enumeration_issue_priorities: Issue-Prioritäten
             enumeration_doc_categories: Dokumentenkategorien

lang/en.yml +17 0

             _gloc_rule_default: '|n| n==1 ? "" : "_plural" '
             actionview_datehelper_select_day_prefix:
             actionview_datehelper_select_month_names: January,February,March,April,May,June,July,August,September,October,November,December
             actionview_datehelper_select_month_names_abbr: Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec
             actionview_datehelper_select_month_prefix:
             actionview_datehelper_select_year_prefix:
             actionview_datehelper_time_in_words_day: 1 day
             actionview_datehelper_time_in_words_day_plural: %d days
             actionview_datehelper_time_in_words_hour_about: about an hour
             actionview_datehelper_time_in_words_hour_about_plural: about %d hours
             actionview_datehelper_time_in_words_hour_about_single: about an hour
             actionview_datehelper_time_in_words_minute: 1 minute
             actionview_datehelper_time_in_words_minute_half: half a minute
             actionview_datehelper_time_in_words_minute_less_than: less than a minute
             actionview_datehelper_time_in_words_minute_plural: %d minutes
             actionview_datehelper_time_in_words_minute_single: 1 minute
             actionview_datehelper_time_in_words_second_less_than: less than a second
             actionview_datehelper_time_in_words_second_less_than_plural: less than %d seconds
             actionview_instancetag_blank_option: Please select
             activerecord_error_inclusion: is not included in the list
             activerecord_error_exclusion: is reserved
             activerecord_error_invalid: is invalid
             activerecord_error_confirmation: doesn't match confirmation
             activerecord_error_accepted: must be accepted
             activerecord_error_empty: can't be empty
             activerecord_error_blank: can't be blank
             activerecord_error_too_long: is too long
             activerecord_error_too_short: is too short
             activerecord_error_wrong_length: is the wrong length
             activerecord_error_taken: has already been taken
             activerecord_error_not_a_number: is not a number
             activerecord_error_not_a_date: is not a valid date
             activerecord_error_greater_than_start_date: must be greater than start date
             general_fmt_age: %d yr
             general_fmt_age_plural: %d yrs
             general_fmt_date: %%m/%%d/%%Y
             general_fmt_datetime: %%m/%%d/%%Y %%I:%%M %%p
             general_fmt_datetime_short: %%b %%d, %%I:%%M %%p
             general_fmt_time: %%I:%%M %%p
             general_text_No: 'No'
             general_text_Yes: 'Yes'
             general_text_no: 'no'
             general_text_yes: 'yes'
             general_lang_en: 'English'
             general_csv_separator: ','
             general_day_names: Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday
             notice_account_updated: Account was successfully updated.
             notice_account_invalid_creditentials: Invalid user or password
             notice_account_password_updated: Password was successfully updated.
             notice_account_wrong_password: Wrong password
             notice_account_register_done: Account was successfully created.
             notice_account_unknown_email: Unknown user.
             notice_can_t_change_password: This account uses an external authentication source. Impossible to change the password.
             notice_account_lost_email_sent: An email with instructions to choose a new password has been sent to you.
             notice_account_activated: Your account has been activated. You can now log in.
             notice_successful_create: Successful creation.
             notice_successful_update: Successful update.
             notice_successful_delete: Successful deletion.
             notice_successful_connection: Successful connection.
             notice_file_not_found: Requested file doesn't exist or has been deleted.
             notice_locking_conflict: Data have been updated by another user.
             mail_subject_lost_password: Your redMine password
             mail_subject_register: redMine account activation
             gui_validation_error: 1 error
             gui_validation_error_plural: %d errors
             field_name: Name
             field_description: Description
             field_summary: Summary
             field_is_required: Required
             field_firstname: Firstname
             field_lastname: Lastname
             field_mail: Email
             field_filename: File
             field_filesize: Size
             field_downloads: Downloads
             field_author: Author
             field_created_on: Created
             field_updated_on: Updated
             field_field_format: Format
             field_is_for_all: For all projects
             field_possible_values: Possible values
             field_regexp: Regular expression
             field_min_length: Minimum length
             field_max_length: Maximum length
             field_value: Value
             field_category: Category
             field_title: Title
             field_project: Project
             field_issue: Issue
             field_status: Status
             field_notes: Notes
             field_is_closed: Issue closed
             field_is_default: Default status
             field_html_color: Color
             field_tracker: Tracker
             field_subject: Subject
             field_due_date: Due date
             field_assigned_to: Assigned to
             field_priority: Priority
             field_fixed_version: Fixed version
             field_user: User
             field_role: Role
             field_homepage: Homepage
             field_is_public: Public
             field_parent: Subproject of
             field_is_in_chlog: Issues displayed in changelog
             field_login: Login
             field_mail_notification: Mail notifications
             field_admin: Administrator
             field_locked: Locked
             field_last_login_on: Last connection
             field_language: Language
             field_effective_date: Date
             field_password: Password
             field_new_password: New password
             field_password_confirmation: Confirmation
             field_version: Version
             field_type: Type
             field_host: Host
             field_port: Port
             field_account: Account
             field_base_dn: Base DN
             field_attr_login: Login attribute
             field_attr_firstname: Firstname attribute
             field_attr_lastname: Lastname attribute
             field_attr_mail: Email attribute
             field_onthefly: On-the-fly user creation
             field_start_date: Start
             field_done_ratio: %% Done
             field_hide_mail: Hide my email address
             field_comment: Comment
             label_user: User
             label_user_plural: Users
             label_user_new: New user
             label_project: Project
             label_project_new: New project
             label_project_plural: Projects
             label_project_latest: Latest projects
             label_issue: Issue
             label_issue_new: New issue
             label_issue_plural: Issues
             label_issue_view_all: View all issues
             label_document: Document
             label_document_new: New document
             label_document_plural: Documents
             label_role: Role
             label_role_plural: Roles
             label_role_new: New role
             label_role_and_permissions: Roles and permissions
             label_member: Member
             label_member_new: New member
             label_member_plural: Members
             label_tracker: Tracker
             label_tracker_plural: Trackers
             label_tracker_new: New tracker
             label_workflow: Workflow
             label_issue_status: Issue status
             label_issue_status_plural: Issue statuses
             label_issue_status_new: New status
             label_issue_category: Issue category
             label_issue_category_plural: Issue categories
             label_issue_category_new: New category
             label_custom_field: Custom field
             label_custom_field_plural: Custom fields
             label_custom_field_new: New custom field
             label_enumerations: Enumerations
             label_enumeration_new: New value
             label_information: Information
             label_information_plural: Information
             label_please_login: Please login
             label_register: Register
             label_password_lost: Lost password
             label_home: Home
             label_my_page: My page
             label_my_account: My account
             label_my_projects: My projects
             label_administration: Administration
             label_login: Login
             label_logout: Logout
             label_help: Help
             label_reported_issues: Reported issues
             label_assigned_to_me_issues: Issues assigned to me
             label_last_login: Last connection
             label_last_updates: Last updated
             label_last_updates_plural: %d last updated
             label_registered_on: Registered on
             label_activity: Activity
             label_new: New
             label_logged_as: Logged as
             label_environment: Environment
             label_authentication: Authentication
             label_auth_source: Authentication mode
             label_auth_source_new: New authentication mode
             label_auth_source_plural: Authentication modes
             label_subproject: Subproject
             label_subproject_plural: Subprojects
             label_min_max_length: Min - Max length
             label_list: List
             label_date: Date
             label_integer: Integer
             label_boolean: Boolean
             label_string: Text
             label_text: Long text
             label_attribute: Attribute
             label_attribute_plural: Attributes
             label_download: %d Download
             label_download_plural: %d Downloads
             label_no_data: No data to display
             label_change_status: Change status
             label_history: History
             label_attachment: File
             label_attachment_new: New file
             label_attachment_delete: Delete file
             label_attachment_plural: Files
             label_report: Report
             label_report_plural: Reports
             label_news: News
             label_news_new: Add news
             label_news_plural: News
             label_news_latest: Latest news
             label_news_view_all: View all news
             label_change_log: Change log
             label_settings: Settings
             label_overview: Overview
             label_version: Version
             label_version_new: New version
             label_version_plural: Versions
             label_confirmation: Confirmation
             label_export_to: Export to
             label_read: Read...
             label_public_projects: Public projects
             label_open_issues: Open
             label_open_issues_plural: Open
             label_closed_issues: Closed
             label_closed_issues_plural: Closed
             label_total: Total
             label_permissions: Permissions
             label_current_status: Current status
             label_new_statuses_allowed: New statuses allowed
             label_all: All
             label_none: None
             label_next: Next
             label_previous: Previous
             label_used_by: Used by
             label_details: Details...
             label_add_note: Add a note
             label_per_page: Per page
             label_calendar: Calendar
             label_months_from: months from
             label_gantt: Gantt
             label_internal: Internal
             label_last_changes: last %d changes
             label_change_view_all: View all changes
             label_personalize_page: Personalize this page
             label_comment: Comment
             label_comment_plural: Comments
             label_comment_add: Add a comment
             label_comment_added: Comment added
             label_comment_delete: Delete comments
+            label_query: Custom query
+            label_query_plural: Custom queries
+            label_query_new: New query
+            label_filter_add: Add filter
+            label_filter_plural: Filters
+            label_equals: is
+            label_not_equals: is not
+            label_in_less_than: in less than
+            label_in_more_than: in more than
+            label_in: in
+            label_today: today
+            label_less_than_ago: less than days ago
+            label_more_than_ago: more than days ago
+            label_ago: days ago
+            label_contains: contains
+            label_not_contains: doesn't contain
+            label_day_plural: days
             button_login: Login
             button_submit: Submit
             button_save: Save
             button_check_all: Check all
             button_uncheck_all: Uncheck all
             button_delete: Delete
             button_create: Create
             button_test: Test
             button_edit: Edit
             button_add: Add
             button_change: Change
             button_apply: Apply
             button_clear: Clear
             button_lock: Lock
             button_unlock: Unlock
             button_download: Download
             button_list: List
             button_view: View
             button_move: Move
             button_back: Back
             button_cancel: Cancel
             text_select_mail_notifications: Select actions for which mail notifications should be sent.
             text_regexp_info: eg. ^[A-Z0-9]+$
             text_min_max_length_info: 0 means no restriction
             text_possible_values_info: values separated with |
             text_project_destroy_confirmation: Are you sure you want to delete this project and all related data ?
             text_workflow_edit: Select a role and a tracker to edit the workflow
             text_are_you_sure: Are you sure ?
             text_journal_changed: changed from %s to %s
             text_journal_set_to: set to %s
             text_journal_deleted: deleted
             text_tip_task_begin_day: task beginning this day
             text_tip_task_end_day: task ending this day
             text_tip_task_begin_end_day: task beginning and ending this day
             default_role_manager: Manager
             default_role_developper: Developer
             default_role_reporter: Reporter
             default_tracker_bug: Bug
             default_tracker_feature: Feature
             default_tracker_support: Support
             default_issue_status_new: New
             default_issue_status_assigned: Assigned
             default_issue_status_resolved: Resolved
             default_issue_status_feedback: Feedback
             default_issue_status_closed: Closed
             default_issue_status_rejected: Rejected
             default_doc_category_user: User documentation
             default_doc_category_tech: Technical documentation
             default_priority_low: Low
             default_priority_normal: Normal
             default_priority_high: High
             default_priority_urgent: Urgent
             default_priority_immediate: Immediate
             enumeration_issue_priorities: Issue priorities
             enumeration_doc_categories: Document categories

lang/es.yml +17 0

             _gloc_rule_default: '|n| n==1 ? "" : "_plural" '
             actionview_datehelper_select_day_prefix:
             actionview_datehelper_select_month_names: Enero,Febrero,Marzo,Abril,Mayo,Junio,Julio,Agosto,Septiembre,Octubre,Noviembre,Diciembre
             actionview_datehelper_select_month_names_abbr: Ene,Feb,Mar,Abr,Mayo,Jun,Jul,Ago,Sep,Oct,Nov,Dic
             actionview_datehelper_select_month_prefix:
             actionview_datehelper_select_year_prefix:
             actionview_datehelper_time_in_words_day: 1 day
             actionview_datehelper_time_in_words_day_plural: %d days
             actionview_datehelper_time_in_words_hour_about: about an hour
             actionview_datehelper_time_in_words_hour_about_plural: about %d hours
             actionview_datehelper_time_in_words_hour_about_single: about an hour
             actionview_datehelper_time_in_words_minute: 1 minute
             actionview_datehelper_time_in_words_minute_half: half a minute
             actionview_datehelper_time_in_words_minute_less_than: less than a minute
             actionview_datehelper_time_in_words_minute_plural: %d minutes
             actionview_datehelper_time_in_words_minute_single: 1 minute
             actionview_datehelper_time_in_words_second_less_than: less than a second
             actionview_datehelper_time_in_words_second_less_than_plural: less than %d seconds
             actionview_instancetag_blank_option: Please select
             activerecord_error_inclusion: is not included in the list
             activerecord_error_exclusion: is reserved
             activerecord_error_invalid: is invalid
             activerecord_error_confirmation: doesn't match confirmation
             activerecord_error_accepted: must be accepted
             activerecord_error_empty: can't be empty
             activerecord_error_blank: can't be blank
             activerecord_error_too_long: is too long
             activerecord_error_too_short: is too short
             activerecord_error_wrong_length: is the wrong length
             activerecord_error_taken: has already been taken
             activerecord_error_not_a_number: is not a number
             activerecord_error_not_a_date: no es una fecha válida
             activerecord_error_greater_than_start_date: debe ser la fecha mayor que del comienzo
             general_fmt_age: %d año
             general_fmt_age_plural: %d años
             general_fmt_date: %%d/%%m/%%Y
             general_fmt_datetime: %%d/%%m/%%Y %%H:%%M
             general_fmt_datetime_short: %%d/%%m %%H:%%M
             general_fmt_time: %%H:%%M
             general_text_No: 'No'
             general_text_Yes: 'Sí'
             general_text_no: 'no'
             general_text_yes: 'sí'
             general_lang_es: 'Español'
             general_csv_separator: ';'
             general_day_names: Lunes,Martes,Miércoles,Jueves,Viernes,Sábado,Domingo
             notice_account_updated: Account was successfully updated.
             notice_account_invalid_creditentials: Invalid user or password
             notice_account_password_updated: Password was successfully updated.
             notice_account_wrong_password: Wrong password
             notice_account_register_done: Account was successfully created.
             notice_account_unknown_email: Unknown user.
             notice_can_t_change_password: This account uses an external authentication source. Impossible to change the password.
             notice_account_lost_email_sent: An email with instructions to choose a new password has been sent to you.
             notice_account_activated: Your account has been activated. You can now log in.
             notice_successful_create: Successful creation.
             notice_successful_update: Successful update.
             notice_successful_delete: Successful deletion.
             notice_successful_connection: Successful connection.
             notice_file_not_found: Requested file doesn't exist or has been deleted.
             notice_locking_conflict: Data have been updated by another user.
             mail_subject_lost_password: Tu contraseña del redMine
             mail_subject_register: Activación de la cuenta del redMine
             gui_validation_error: 1 error
             gui_validation_error_plural: %d errores
             field_name: Nombre
             field_description: Descripción
             field_summary: Resumen
             field_is_required: Obligatorio
             field_firstname: Nombre
             field_lastname: Apellido
             field_mail: Email
             field_filename: Fichero
             field_filesize: Tamaño
             field_downloads: Telecargas
             field_author: Autor
             field_created_on: Creado
             field_updated_on: Actualizado
             field_field_format: Formato
             field_is_for_all: Para todos los proyectos
             field_possible_values: Valores posibles
             field_regexp: Expresión regular
             field_min_length: Longitud mínima
             field_max_length: Longitud máxima
             field_value: Valor
             field_category: Categoría
             field_title: Título
             field_project: Proyecto
             field_issue: Petición
             field_status: Estatuto
             field_notes: Notas
             field_is_closed: Petición resuelta
             field_is_default: Estatuto por defecto
             field_html_color: Color
             field_tracker: Tracker
             field_subject: Tema
             field_due_date: Fecha debida
             field_assigned_to: Asignado a
             field_priority: Prioridad
             field_fixed_version: Versión corregida
             field_user: Usuario
             field_role: Papel
             field_homepage: Sitio web
             field_is_public: Público
             field_parent: Proyecto secundario de
             field_is_in_chlog: Consultar las peticiones en el histórico
             field_login: Identificador
             field_mail_notification: Notificación por mail
             field_admin: Administrador
             field_locked: Cerrado
             field_last_login_on: Última conexión
             field_language: Lengua
             field_effective_date: Fecha
             field_password: Contraseña
             field_new_password: Nueva contraseña
             field_password_confirmation: Confirmación
             field_version: Versión
             field_type: Tipo
             field_host: Anfitrión
             field_port: Puerto
             field_account: Cuenta
             field_base_dn: Base DN
             field_attr_login: Cualidad del identificador
             field_attr_firstname: Cualidad del nombre
             field_attr_lastname: Cualidad del apellido
             field_attr_mail: Cualidad del Email
             field_onthefly: Creación del usuario On-the-fly
             field_start_date: Comienzo
             field_done_ratio: %% Realizado
             field_hide_mail: Ocultar mi email address
             field_comment: Comentario
             label_user: Usuario
             label_user_plural: Usuarios
             label_user_new: Nuevo usuario
             label_project: Proyecto
             label_project_new: Nuevo proyecto
             label_project_plural: Proyectos
             label_project_latest: Los proyectos más últimos
             label_issue: Petición
             label_issue_new: Nueva petición
             label_issue_plural: Peticiones
             label_issue_view_all: Ver todas las peticiones
             label_document: Documento
             label_document_new: Nuevo documento
             label_document_plural: Documentos
             label_role: Papel
             label_role_plural: Papeles
             label_role_new: Nuevo papel
             label_role_and_permissions: Papeles y permisos
             label_member: Miembro
             label_member_new: Nuevo miembro
             label_member_plural: Miembros
             label_tracker: Tracker
             label_tracker_plural: Trackers
             label_tracker_new: Nuevo tracker
             label_workflow: Workflow
             label_issue_status: Estatuto de petición
             label_issue_status_plural: Estatutos de las peticiones
             label_issue_status_new: Nuevo estatuto
             label_issue_category: Categoría de las peticiones
             label_issue_category_plural: Categorías de las peticiones
             label_issue_category_new: Nueva categoría
             label_custom_field: Campo personalizado
             label_custom_field_plural: Campos personalizados
             label_custom_field_new: Nuevo campo personalizado
             label_enumerations: Listas de valores
             label_enumeration_new: Nuevo valor
             label_information: Informacion
             label_information_plural: Informaciones
             label_please_login: Conexión
             label_register: Registrar
             label_password_lost: ¿Olvidaste la contraseña?
             label_home: Acogida
             label_my_page: Mi página
             label_my_account: Mi cuenta
             label_my_projects: Mis proyectos
             label_administration: Administración
             label_login: Conexión
             label_logout: Desconexión
             label_help: Ayuda
             label_reported_issues: Peticiones registradas
             label_assigned_to_me_issues: Peticiones que me están asignadas
             label_last_login: Última conexión
             label_last_updates: Actualizado
             label_last_updates_plural: %d Actualizados
             label_registered_on: Inscrito el
             label_activity: Actividad
             label_new: Nuevo
             label_logged_as: Conectado como
             label_environment: Environment
             label_authentication: Autentificación
             label_auth_source: Modo de la autentificación
             label_auth_source_new: Nuevo modo de la autentificación
             label_auth_source_plural: Modos de la autentificación
             label_subproject: Proyecto secundario
             label_subproject_plural: Proyectos secundarios
             label_min_max_length: Longitud mín - máx
             label_list: Lista
             label_date: Fecha
             label_integer: Número
             label_boolean: Boleano
             label_string: Texto
             label_text: Texto largo
             label_attribute: Cualidad
             label_attribute_plural: Cualidades
             label_download: %d Telecarga
             label_download_plural: %d Telecargas
             label_no_data: Ningunos datos a exhibir
             label_change_status: Cambiar el estatuto
             label_history: Histórico
             label_attachment: Fichero
             label_attachment_new: Nuevo fichero
             label_attachment_delete: Suprimir el fichero
             label_attachment_plural: Ficheros
             label_report: Informe
             label_report_plural: Informes
             label_news: Noticia
             label_news_new: Nueva noticia
             label_news_plural: Noticias
             label_news_latest: Últimas noticias
             label_news_view_all: Ver todas las noticias
             label_change_log: Cambios
             label_settings: Configuración
             label_overview: Vistazo
             label_version: Versión
             label_version_new: Nueva versión
             label_version_plural: Versiónes
             label_confirmation: Confirmación
             label_export_to: Exportar a
             label_read: Leer...
             label_public_projects: Proyectos publicos
             label_open_issues: Abierta
             label_open_issues_plural: Abiertas
             label_closed_issues: Cerrada
             label_closed_issues_plural: Cerradas
             label_total: Total
             label_permissions: Permisos
             label_current_status: Estado actual
             label_new_statuses_allowed: Nuevos estatutos autorizados
             label_all: Todos
             label_none: Ninguno
             label_next: Próximo
             label_previous: Precedente
             label_used_by: Utilizado por
             label_details: Detalles...
             label_add_note: Agregar una nota
             label_per_page: Por la página
             label_calendar: Calendario
             label_months_from: meses de
             label_gantt: Gantt
             label_internal: Interno
             label_last_changes: %d cambios del último
             label_change_view_all: Ver todos los cambios
             label_personalize_page: Personalizar esta página
             label_comment: Comentario
             label_comment_plural: Comentarios
             label_comment_add: Agregar un comentario
             label_comment_added: Comentario agregó
             label_comment_delete: Suprimir comentarios
+            label_query: Pregunta personalizada
+            label_query_plural: Preguntas personalizadas
+            label_query_new: Nueva preguntas
+            label_filter_add: Agregar el filtro
+            label_filter_plural: Filtros
+            label_equals: igual
+            label_not_equals: no igual
+            label_in_less_than: en menos que
+            label_in_more_than: en más que
+            label_in: en
+            label_today: hoy
+            label_less_than_ago: hace menos de
+            label_more_than_ago: hace más de
+            label_ago: hace
+            label_contains: contiene
+            label_not_contains: no contiene
+            label_day_plural: días
             button_login: Conexión
             button_submit: Someter
             button_save: Validar
             button_check_all: Seleccionar todo
             button_uncheck_all: No seleccionar nada
             button_delete: Suprimir
             button_create: Crear
             button_test: Testar
             button_edit: Modificar
             button_add: Añadir
             button_change: Cambiar
             button_apply: Aplicar
             button_clear: Anular
             button_lock: Bloquear
             button_unlock: Desbloquear
             button_download: Telecargar
             button_list: Listar
             button_view: Ver
             button_move: Mover
             button_back: Atrás
             button_cancel: Cancelar
             text_select_mail_notifications: Seleccionar las actividades que necesitan la activación de la notificación por mail.
             text_regexp_info: eg. ^[A-Z0-9]+$
             text_min_max_length_info: 0 para ninguna restricción
             text_possible_values_info: Los valores se separaron con |
             text_project_destroy_confirmation: ¿ Estás seguro de querer eliminar el proyecto ?
             text_workflow_edit: Seleccionar un workflow para actualizar
             text_are_you_sure: ¿ Estás seguro ?
             text_journal_changed: cambiado de %s a %s
             text_journal_set_to: fijado a %s
             text_journal_deleted: suprimido
             text_tip_task_begin_day: tarea que comienza este día
             text_tip_task_end_day: tarea que termina este día
             text_tip_task_begin_end_day: tarea que comienza y termina este día
             default_role_manager: Manager
             default_role_developper: Desarrollador
             default_role_reporter: Informador
             default_tracker_bug: Anomalía
             default_tracker_feature: Evolución
             default_tracker_support: Asistencia
             default_issue_status_new: Nuevo
             default_issue_status_assigned: Asignada
             default_issue_status_resolved: Resuelta
             default_issue_status_feedback: Comentario
             default_issue_status_closed: Cerrada
             default_issue_status_rejected: Rechazada
             default_doc_category_user: Documentación del usuario
             default_doc_category_tech: Documentación tecnica
             default_priority_low: Bajo
             default_priority_normal: Normal
             default_priority_high: Alto
             default_priority_urgent: Urgente
             default_priority_immediate: Ahora
             enumeration_issue_priorities: Prioridad de las peticiones
             enumeration_doc_categories: Categorías del documento

lang/fr.yml +23 -6

             _gloc_rule_default: '|n| n<=1 ? "" : "_plural" '
             actionview_datehelper_select_day_prefix:
             actionview_datehelper_select_month_names: Janvier,Février,Mars,Avril,Mai,Juin,Juillet,Août,Septembre,Octobre,Novembre,Décembre
             actionview_datehelper_select_month_names_abbr: Jan,Fév,Mars,Avril,Mai,Juin,Juil,Août,Sept,Oct,Nov,Déc
             actionview_datehelper_select_month_prefix:
             actionview_datehelper_select_year_prefix:
             actionview_datehelper_time_in_words_day: 1 jour
             actionview_datehelper_time_in_words_day_plural: %d jours
             actionview_datehelper_time_in_words_hour_about: about an hour
             actionview_datehelper_time_in_words_hour_about_plural: about %d hours
             actionview_datehelper_time_in_words_hour_about_single: about an hour
             actionview_datehelper_time_in_words_minute: 1 minute
             actionview_datehelper_time_in_words_minute_half: 30 secondes
             actionview_datehelper_time_in_words_minute_less_than: moins d'une minute
             actionview_datehelper_time_in_words_minute_plural: %d minutes
             actionview_datehelper_time_in_words_minute_single: 1 minute
             actionview_datehelper_time_in_words_second_less_than: moins d'une seconde
             actionview_datehelper_time_in_words_second_less_than_plural: moins de %d secondes
             actionview_instancetag_blank_option: Choisir
             activerecord_error_inclusion: n'est pas inclus dans la liste
             activerecord_error_exclusion: est reservé
             activerecord_error_invalid: est invalide
             activerecord_error_confirmation: ne correspond pas à la confirmation
             activerecord_error_accepted: doit être accepté
             activerecord_error_empty: doit être renseigné
             activerecord_error_blank: doit être renseigné
             activerecord_error_too_long: est trop long
             activerecord_error_too_short: est trop court
             activerecord_error_wrong_length: n'est pas de la bonne longueur
             activerecord_error_taken: est déjà utilisé
             activerecord_error_not_a_number: n'est pas un nombre
             activerecord_error_not_a_date: n'est pas une date valide
             activerecord_error_greater_than_start_date: doit être postérieur à la date de début
             general_fmt_age: %d an
             general_fmt_age_plural: %d ans
             general_fmt_date: %%d/%%m/%%Y
             general_fmt_datetime: %%d/%%m/%%Y %%H:%%M
             general_fmt_datetime_short: %%d/%%m %%H:%%M
             general_fmt_time: %%H:%%M
             general_text_No: 'Non'
             general_text_Yes: 'Oui'
             general_text_no: 'non'
             general_text_yes: 'oui'
             general_lang_fr: 'Français'
             general_csv_separator: ';'
             general_day_names: Lundi,Mardi,Mercredi,Jeudi,Vendredi,Samedi,Dimanche
             notice_account_updated: Le compte a été mis à jour avec succès.
             notice_account_invalid_creditentials: Identifiant ou mot de passe invalide.
             notice_account_password_updated: Mot de passe mis à jour avec succès.
             notice_account_wrong_password: Mot de passe incorrect
             notice_account_register_done: Un message contenant les instructions pour activer votre compte vous a été envoyé.
             notice_account_unknown_email: Aucun compte ne correspond à cette adresse.
             notice_can_t_change_password: Ce compte utilise une authentification externe. Impossible de changer le mot de passe.
             notice_account_lost_email_sent: Un message contenant les instructions pour choisir un nouveau mot de passe vous a été envoyé.
             notice_account_activated: Votre compte a été activé. Vous pouvez à présent vous connecter.
             notice_successful_create: Création effectuée avec succès.
             notice_successful_update: Mise à jour effectuée avec succès.
             notice_successful_delete: Suppression effectuée avec succès.
             notice_successful_connection: Connection réussie.
             notice_file_not_found: Le fichier demandé n'existe pas ou a été supprimé.
             notice_locking_conflict: Les données ont été mises à jour par un autre utilisateur. Mise à jour impossible.
             mail_subject_lost_password: Votre mot de passe redMine
             mail_subject_register: Activation de votre compte redMine
             gui_validation_error: 1 erreur
             gui_validation_error_plural: %d erreurs
             field_name: Nom
             field_description: Description
             field_summary: Résumé
             field_is_required: Obligatoire
             field_firstname: Prénom
             field_lastname: Nom
             field_mail: Email
             field_filename: Fichier
             field_filesize: Taille
             field_downloads: Téléchargements
             field_author: Auteur
             field_created_on: Créé
             field_updated_on: Mis à jour
             field_field_format: Format
             field_is_for_all: Pour tous les projets
             field_possible_values: Valeurs possibles
             field_regexp: Expression régulière
             field_min_length: Longueur minimum
             field_max_length: Longueur maximum
             field_value: Valeur
             field_category: Catégorie
             field_title: Titre
             field_project: Projet
             field_issue: Demande
             field_status: Statut
             field_notes: Notes
             field_is_closed: Demande fermée
             field_is_default: Statut par défaut
             field_html_color: Couleur
             field_tracker: Tracker
             field_subject: Sujet
             field_due_date: Date d'échéance
             field_assigned_to: Assigné à
             field_priority: Priorité
             field_fixed_version: Version corrigée
             field_user: Utilisateur
             field_role: Rôle
             field_homepage: Site web
             field_is_public: Public
             field_parent: Sous-projet de
             field_is_in_chlog: Demandes affichées dans l'historique
             field_login: Identifiant
             field_mail_notification: Notifications par mail
             field_admin: Administrateur
             field_locked: Verrouillé
             field_last_login_on: Dernière connexion
             field_language: Langue
             field_effective_date: Date
             field_password: Mot de passe
             field_new_password: Nouveau mot de passe
             field_password_confirmation: Confirmation
             field_version: Version
             field_type: Type
             field_host: Hôte
             field_port: Port
             field_account: Compte
             field_base_dn: Base DN
             field_attr_login: Attribut Identifiant
             field_attr_firstname: Attribut Prénom
             field_attr_lastname: Attribut Nom
             field_attr_mail: Attribut Email
             field_onthefly: Création des utilisateurs à la volée
             field_start_date: Début
             field_done_ratio: %% Réalisé
             field_auth_source: Mode d'authentification
             field_hide_mail: Cacher mon adresse mail
             field_comment: Commentaire
             label_user: Utilisateur
             label_user_plural: Utilisateurs
             label_user_new: Nouvel utilisateur
             label_project: Projet
             label_project_new: Nouveau projet
             label_project_plural: Projets
             label_project_latest: Derniers projets
             label_issue: Demande
             label_issue_new: Nouvelle demande
             label_issue_plural: Demandes
             label_issue_view_all: Voir toutes les demandes
             label_document: Document
             label_document_new: Nouveau document
             label_document_plural: Documents
             label_role: Rôle
             label_role_plural: Rôles
             label_role_new: Nouveau rôle
             label_role_and_permissions: Rôles et permissions
             label_member: Membre
             label_member_new: Nouveau membre
             label_member_plural: Membres
             label_tracker: Tracker
             label_tracker_plural: Trackers
             label_tracker_new: Nouveau tracker
             label_workflow: Workflow
             label_issue_status: Statut de demandes
             label_issue_status_plural: Statuts de demandes
             label_issue_status_new: Nouveau statut
             label_issue_category: Catégorie de demandes
             label_issue_category_plural: Catégories de demandes
             label_issue_category_new: Nouvelle catégorie
             label_custom_field: Champ personnalisé
             label_custom_field_plural: Champs personnalisés
             label_custom_field_new: Nouveau champ personnalisé
             label_enumerations: Listes de valeurs
             label_enumeration_new: Nouvelle valeur
             label_information: Information
             label_information_plural: Informations
             label_please_login: Identification
             label_register: S'enregistrer
             label_password_lost: Mot de passe perdu
             label_home: Accueil
             label_my_page: Ma page
             label_my_account: Mon compte
             label_my_projects: Mes projets
             label_administration: Administration
             label_login: Connexion
             label_logout: Déconnexion
             label_help: Aide
             label_reported_issues: Demandes soumises
             label_assigned_to_me_issues: Demandes qui me sont assignées
             label_last_login: Dernière connexion
             label_last_updates: Dernière mise à jour
             label_last_updates_plural: %d dernières mises à jour
             label_registered_on: Inscrit le
             label_activity: Activité
             label_new: Nouveau
             label_logged_as: Connecté en tant que
             label_environment: Environnement
             label_authentication: Authentification
             label_auth_source: Mode d'authentification
             label_auth_source_new: Nouveau mode d'authentification
             label_auth_source_plural: Modes d'authentification
             label_subproject: Sous-projet
             label_subproject_plural: Sous-projets
             label_min_max_length: Longueurs mini - maxi
             label_list: Liste
             label_date: Date
             label_integer: Entier
             label_boolean: Booléen
             label_string: Texte
             label_text: Texte long
             label_attribute: Attribut
             label_attribute_plural: Attributs
             label_download: %d Téléchargement
             label_download_plural: %d Téléchargements
             label_no_data: Aucune donnée à afficher
             label_change_status: Changer le statut
             label_history: Historique
             label_attachment: Fichier
             label_attachment_new: Nouveau fichier
             label_attachment_delete: Supprimer le fichier
             label_attachment_plural: Fichiers
             label_report: Rapport
             label_report_plural: Rapports
             label_news: Annonce
             label_news_new: Nouvelle annonce
             label_news_plural: Annonces
             label_news_latest: Dernières annonces
             label_news_view_all: Voir toutes les annonces
             label_change_log: Historique
             label_settings: Configuration
             label_overview: Aperçu
             label_version: Version
             label_version_new: Nouvelle version
             label_version_plural: Versions
             label_confirmation: Confirmation
             label_export_to: Exporter en
             label_read: Lire...
             label_public_projects: Projets publics
-            label_open_issues: Ouverte
+            label_open_issues: ouvert
-            label_open_issues_plural: Ouvertes
+            label_open_issues_plural: ouverts
-            label_closed_issues: Fermée
+            label_closed_issues: fermé
-            label_closed_issues_plural: Fermées
+            label_closed_issues_plural: fermés
             label_total: Total
             label_permissions: Permissions
             label_current_status: Statut actuel
             label_new_statuses_allowed: Nouveaux statuts autorisés
-            label_all: Tous
+            label_all: tous
-            label_none: Aucun
+            label_none: aucun
             label_next: Suivant
             label_previous: Précédent
             label_used_by: Utilisé par
             label_details: Détails...
             label_add_note: Ajouter une note
             label_per_page: Par page
             label_calendar: Calendrier
             label_months_from: mois depuis
             label_gantt: Gantt
             label_internal: Interne
             label_last_changes: %d derniers changements
             label_change_view_all: Voir tous les changements
             label_personalize_page: Personnaliser cette page
             label_comment: Commentaire
             label_comment_plural: Commentaires
             label_comment_add: Ajouter un commentaire
             label_comment_added: Commentaire ajouté
             label_comment_delete: Supprimer les commentaires
+            label_query: Rapport personnalisé
+            label_query_plural: Rapports personnalisés
+            label_query_new: Nouveau rapport
+            label_filter_add: Ajouter le filtre
+            label_filter_plural: Filtres
+            label_equals: égal
+            label_not_equals: différent
+            label_in_less_than: dans moins de
+            label_in_more_than: dans plus de
+            label_in: dans
+            label_today: aujourd'hui
+            label_less_than_ago: il y a moins de
+            label_more_than_ago: il y a plus de
+            label_ago: il y a
+            label_contains: contient
+            label_not_contains: ne contient pas
+            label_day_plural: jours
             button_login: Connexion
             button_submit: Soumettre
             button_save: Sauvegarder
             button_check_all: Tout cocher
             button_uncheck_all: Tout décocher
             button_delete: Supprimer
             button_create: Créer
             button_test: Tester
             button_edit: Modifier
             button_add: Ajouter
             button_change: Changer
             button_apply: Appliquer
             button_clear: Effacer
             button_lock: Verrouiller
             button_unlock: Déverrouiller
             button_download: Télécharger
             button_list: Lister
             button_view: Voir
             button_move: Déplacer
             button_back: Retour
             button_cancel: Annuler
             text_select_mail_notifications: Sélectionner les actions pour lesquelles la notification par mail doit être activée.
             text_regexp_info: ex. ^[A-Z0-9]+$
             text_min_max_length_info: 0 pour aucune restriction
             text_possible_values_info: valeurs séparées par |
             text_project_destroy_confirmation: Etes-vous sûr de vouloir supprimer ce projet et tout ce qui lui est rattaché ?
             text_workflow_edit: Sélectionner un tracker et un rôle pour éditer le workflow
             text_are_you_sure: Etes-vous sûr ?
             text_journal_changed: changé de %s à %s
             text_journal_set_to: mis à %s
             text_journal_deleted: supprimé
             text_tip_task_begin_day: tâche commençant ce jour
             text_tip_task_end_day: tâche finissant ce jour
             text_tip_task_begin_end_day: tâche commençant et finissant ce jour
             default_role_manager: Manager
             default_role_developper: Développeur
             default_role_reporter: Rapporteur
             default_tracker_bug: Anomalie
             default_tracker_feature: Evolution
             default_tracker_support: Assistance
             default_issue_status_new: Nouveau
             default_issue_status_assigned: Assigné
             default_issue_status_resolved: Résolu
             default_issue_status_feedback: Commentaire
             default_issue_status_closed: Fermé
             default_issue_status_rejected: Rejeté
             default_doc_category_user: Documentation utilisateur
             default_doc_category_tech: Documentation technique
             default_priority_low: Bas
             default_priority_normal: Normal
             default_priority_high: Haut
             default_priority_urgent: Urgent
             default_priority_immediate: Immédiat
             enumeration_issue_priorities: Priorités des demandes
             enumeration_doc_categories: Catégories des documents

public/images/edit.png ~~public/images/edit_small.png~~ renamed 0 0

NO CONTENT: file renamed from public/images/edit_small.png to public/images/edit.png

public/stylesheets/application.css +3 -2

             /* andreas08 - an open source xhtml/css website layout by Andreas Viklund - http://andreasviklund.com . Free to use in any way and for any purpose as long as the proper credits are given to the original designer. Version: 1.0, November 28, 2005 */
             /* Edited by Jean-Philippe Lang *>
             /**************** Body and tag styles ****************/
             #header * {margin:0; padding:0;}
             p, ul, ol, li {margin:0; padding:0;}
             body{
             font:76% Verdana,Tahoma,Arial,sans-serif;
             line-height:1.4em;
             text-align:center;
             color:#303030;
             background:#e8eaec;
             margin:0;
             }
             a{
             color:#467aa7;
             font-weight:bold;
             text-decoration:none;
             background-color:inherit;
             }
             a:hover{color:#2a5a8a; text-decoration:none; background-color:inherit;}
             a img{border:none;}
             p{padding:0 0 1em 0;}
             p form{margin-top:0; margin-bottom:20px;}
             img.left,img.center,img.right{padding:4px; border:1px solid #a0a0a0;}
             img.left{float:left; margin:0 12px 5px 0;}
             img.center{display:block; margin:0 auto 5px auto;}
             img.right{float:right; margin:0 0 5px 12px;}
             /**************** Header and navigation styles ****************/
             #container{
             width:100%;
             min-width: 800px;
             margin:0;
             padding:0;
             text-align:left;
             background:#ffffff;
             color:#303030;
             }
             #header{
             height:4.5em;
             /*width:758px;*/
             margin:0;
             background:#467aa7;
             color:#ffffff;
             margin-bottom:1px;
             }
             #header h1{
             padding:10px 0 0 20px;
             font-size:2em;
             background-color:inherit;
             color:#fff; /*rgb(152, 26, 33);*/
             letter-spacing:-1px;
             font-weight:bold;
             font-family: Trebuchet MS,Georgia,"Times New Roman",serif;
             }
             #header h2{
             margin:3px 0 0 40px;
             font-size:1.5em;
             background-color:inherit;
             color:#f0f2f4;
             letter-spacing:-1px;
             font-weight:normal;
             font-family: Trebuchet MS,Georgia,"Times New Roman",serif;
             }
             #navigation{
             height:2.2em;
             line-height:2.2em;
             /*width:758px;*/
             margin:0;
             background:#578bb8;
             color:#ffffff;
             }
             #navigation li{
             float:left;
             list-style-type:none;
             border-right:1px solid #ffffff;
             white-space:nowrap;
             }
             #navigation li.right {
              float:right;
             list-style-type:none;
             border-right:0;
             border-left:1px solid #ffffff;
             white-space:nowrap;
             }
             #navigation li a{
             display:block;
             padding:0px 10px 0px 22px;
             font-size:0.8em;
             font-weight:normal;
             /*text-transform:uppercase;*/
             text-decoration:none;
             background-color:inherit;
             color: #ffffff;
             }
             * html #navigation a {width:1%;}
             #navigation .selected,#navigation a:hover{
             color:#ffffff;
             text-decoration:none;
             background-color: #80b0da;
             }
             /**************** Icons links *******************/
             .picHome {	background: url(../images/home.png) no-repeat 4px 50%; }
             .picUser {	background: url(../images/user.png) no-repeat 4px 50%; }
             .picUserPage {	background: url(../images/user_page.png) no-repeat 4px 50%; }
             .picAdmin {	background: url(../images/admin.png) no-repeat 4px 50%; }
             .picProject { background: url(../images/projects.png) no-repeat 4px 50%; }
             .picLogout { background: url(../images/logout.png) no-repeat 4px 50%; }
             .picHelp { background: url(../images/help.png) no-repeat 4px 50%; }
-            .picEdit { background: url(../images/edit_small.png) no-repeat 4px 50%; }
+            .picEdit { background: url(../images/edit.png) no-repeat 4px 50%; }
             .picDelete { background: url(../images/delete.png) no-repeat 4px 50%; }
             .picAdd { background: url(../images/add.png) no-repeat 4px 50%; }
             .picMove { background: url(../images/move.png) no-repeat 4px 50%; }
+            .picCheck { background: url(../images/check.png) no-repeat 4px 70%; }
             .picPdf { background: url(../images/pdf.png) no-repeat 4px 50%;}
             .picCsv { background: url(../images/csv.png) no-repeat 4px 50%;}
             .pic { padding-left: 18px; margin-left: 3px; }
             /**************** Content styles ****************/
             html>body #content {
             height: auto;
             min-height: 500px;
             }
             #content{
             /*float:right;*/
             /*width:530px;*/
             width: auto;
             height:500px;
             font-size:0.9em;
             padding:20px 10px 10px 20px;
             /*position: absolute;*/
             margin-left: 120px;
             border-left: 1px dashed #c0c0c0;
             }
             #content h2{
             display:block;
             margin:0 0 16px 0;
             font-size:1.7em;
             font-weight:normal;
             letter-spacing:-1px;
             color:#606060;
             background-color:inherit;
             font-family: Trebuchet MS,Georgia,"Times New Roman",serif;
             }
             #content h2 a{font-weight:normal;}
             #content h3{margin:0 0 12px 0; font-size:1.4em;color:#707070;font-family: Trebuchet MS,Georgia,"Times New Roman",serif;}
             #content a:hover,#subcontent a:hover{text-decoration:underline;}
             #content ul,#content ol{margin:0 5px 16px 35px;}
             #content dl{margin:0 5px 10px 25px;}
             #content dt{font-weight:bold; margin-bottom:5px;}
             #content dd{margin:0 0 10px 15px;}
             /***********************************************/
             /*
             form{
             	padding:15px;
             	margin:0 0 20px 0;
             	border:1px solid #c0c0c0;
             	background-color:#CEE1ED;
             	width:600px;
             }
             */
             form {
             	display: inline;
             }
             .noborder {
             	border:0px;
             	background-color:#fff;
             	width:100%;
             }
             textarea {
                 padding:0;
                 margin:0;
             }
             blockquote {
                 padding-left: 6px;
                 border-left: 2px solid #ccc;
             }
             input {
             	vertical-align: middle;
             }
             input.button-small
             {
                 font-size: 0.8em;
             }
             select {
             	vertical-align: middle;
             }
-            select.select-small
+            .select-small
             {
                border: 1px solid #7F9DB9;
                padding: 1px;
                font-size: 0.8em;
             }
             .active-filter
             {
               background-color: #F9FA9E;
             }
             label {
             	font-weight: bold;
             	font-size: 1em;
             }
             fieldset {
                 border:1px solid #7F9DB9;
                 padding: 6px;
             }
             legend {
                 color: #505050;
             }
             .required {
             	color: #bb0000;
             }
             table.listTableContent {
             	border:1px solid #578bb8;
             	width:100%;
             	border-collapse: collapse;
             }
             table.listTableContent td {
             	padding:2px;
             }
             tr.ListHead {
             	background-color:#467aa7;
             	color:#FFFFFF;
             	text-align:center;
             }
             tr.ListHead a {
             	color:#FFFFFF;
             	text-decoration:underline;
             }
             .odd {
             	background-color:#f0f1f2;
             }
             .even {
             	background-color: #fff;
             }
             table.reportTableContent {
             	border:1px solid #c0c0c0;
             	width:99%;
             	border-collapse: collapse;
             }
             table.reportTableContent td {
             	padding:2px;
             }
             table.calenderTable {
             	border:1px solid #578bb8;
             	width:99%;
             	border-collapse: collapse;
             }
             table.calenderTable td {
             	border:1px solid #578bb8;
             }
             hr { border:none; border-bottom: dotted 1px #c0c0c0; }
             /**************** Sidebar styles ****************/
             #subcontent{
             position: absolute;
             left: 0px;
             width:110px;
             padding:20px 20px 10px 5px;
             }
             #subcontent h2{
             display:block;
             margin:0 0 5px 0;
             font-size:1.0em;
             font-weight:bold;
             text-align:left;
             color:#606060;
             background-color:inherit;
             font-family: Trebuchet MS,Georgia,"Times New Roman",serif;
             }
             #subcontent p{margin:0 0 16px 0; font-size:0.9em;}
             /**************** Menublock styles ****************/
             .menublock{margin:0 0 20px 8px; font-size:0.8em;}
             .menublock li{list-style:none; display:block; padding:1px; margin-bottom:0px;}
             .menublock li a{font-weight:bold; text-decoration:none;}
             .menublock li a:hover{text-decoration:none;}
             .menublock li ul{margin:0; font-size:1em; font-weight:normal;}
             .menublock li ul li{margin-bottom:0;}
             .menublock li ul a{font-weight:normal;}
             /**************** Searchbar styles ****************/
             #searchbar{margin:0 0 20px 0;}
             #searchbar form fieldset{margin-left:10px; border:0 solid;}
             #searchbar #s{
             height:1.2em;
             width:110px;
             margin:0 5px 0 0;
             border:1px solid #a0a0a0;
             }
             #searchbar #searchbutton{
             width:auto;
             padding:0 1px;
             border:1px solid #808080;
             font-size:0.9em;
             text-align:center;
             }
             /**************** Footer styles ****************/
             #footer{
             clear:both;
             /*width:758px;*/
             padding:5px 0;
             margin:0;
             font-size:0.9em;
             color:#f0f0f0;
             background:#467aa7;
             }
             #footer p{padding:0; margin:0; text-align:center;}
             #footer a{color:#f0f0f0; background-color:inherit; font-weight:bold;}
             #footer a:hover{color:#ffffff; background-color:inherit; text-decoration: underline;}
             /**************** Misc classes and styles ****************/
             .splitcontentleft{float:left; width:49%;}
             .splitcontentright{float:right; width:49%;}
             .clear{clear:both;}
             .small{font-size:0.8em;line-height:1.4em;padding:0 0 0 0;}
             .hide{display:none;}
             .textcenter{text-align:center;}
             .textright{text-align:right;}
             .important{color:#f02025; background-color:inherit; font-weight:bold;}
             .box{
             margin:0 0 20px 0;
             padding:10px;
             border:1px solid #c0c0c0;
             background-color:#fafbfc;
             color:#505050;
             line-height:1.5em;
             }
             a.close-icon {
             display:block;
             margin-top:3px;
             overflow:hidden;
             width:12px;
             height:12px;
             background-repeat: no-repeat;
             cursor:hand;
             cursor:pointer;
             background-image:url('../images/close.png');
             }
             a.close-icon:hover {
             background-image:url('../images/close_hl.png');
             }
             .rightbox{
             background: #fafbfc;
             border: 1px solid #c0c0c0;
             float: right;
             padding: 8px;
             position: relative;
             margin: 0 5px 5px;
             }
             .layout-active {
             background: #ECF3E1;
             }
             .block-receiver {
             border:1px dashed #c0c0c0;
             margin-bottom: 20px;
             padding: 15px 0 15px 0;
             }
             .mypage-box {
             margin:0 0 20px 0;
             color:#505050;
             line-height:1.5em;
             }
             .handle {
             cursor: move;
             }
             .topright{
             position: absolute;
             right: 25px;
             top: 100px;
             }
             .login {
             width: 50%;
             text-align: left;
             }
             img.calendar-trigger {
                 cursor: pointer;
                 vertical-align: middle;
                 margin-left: 4px;
             }
             #history h4, #comments h4 {
                 font-size: 1em;
                 margin-bottom: 12px;
                 margin-top: 20px;
                 font-weight: normal;
                 border-bottom: dotted 1px #c0c0c0;
             }
             #history p {
                 margin-left: 34px;
             }
             /***** Contextual links div *****/
             .contextual {
             float: right;
             font-size: 0.8em;
             }
             /***** CSS FORM ******/
             .tabular p{
             margin: 0;
             padding: 5px 0 8px 0;
             padding-left: 180px; /*width of left column containing the label elements*/
             height: 1%;
             }
             .tabular label{
             font-weight: bold;
             float: left;
             margin-left: -180px; /*width of left column*/
             width: 175px; /*width of labels. Should be smaller than left column to create some right
             margin*/
             }
             .error {
             color: #cc0000;
             }
             /*.threepxfix class below:
             Targets IE6- ONLY. Adds 3 pixel indent for multi-line form contents.
             to account for 3 pixel bug: http://www.positioniseverything.net/explorer/threepxtest.html
             */
             * html .threepxfix{
             margin-left: 3px;
             }

app/helpers/search_filter_helper.rb removed 0 -106

NO CONTENT: file was removed

General Comments 0

Write
Preview

You need to be logged in to leave comments. Login now

No TODOs yet

	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