jro_apps/redmine Commit - r10546:d62ef6b9b1dc

Changes how relative date filters work and adds specific filters for filtering dates in past/next n days (#11426)....

Jean-Philippe Lang -

r10546:d62ef6b9b1dc

parent child

Context file:

r10546:d62ef6b9b1dc

Collapse all files

app/models/query.rb +21 -5

              # Redmine - project management software
              # Copyright (C) 2006-2012  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 QueryColumn
                attr_accessor :name, :sortable, :groupable, :default_order
                include Redmine::I18n
                def initialize(name, options={})
                  self.name = name
                  self.sortable = options[:sortable]
                  self.groupable = options[:groupable] || false
                  if groupable == true
                    self.groupable = name.to_s
                  end
                  self.default_order = options[:default_order]
                  @caption_key = options[:caption] || "field_#{name}"
                end
                def caption
                  l(@caption_key)
                end
                # Returns true if the column is sortable, otherwise false
                def sortable?
                  !@sortable.nil?
                end
                def sortable
                  @sortable.is_a?(Proc) ? @sortable.call : @sortable
                end
                def value(issue)
                  issue.send name
                end
                def css_classes
                  name
                end
              end
              class QueryCustomFieldColumn < QueryColumn
                def initialize(custom_field)
                  self.name = "cf_#{custom_field.id}".to_sym
                  self.sortable = custom_field.order_statement || false
                  self.groupable = custom_field.group_statement || false
                  @cf = custom_field
                end
                def caption
                  @cf.name
                end
                def custom_field
                  @cf
                end
                def value(issue)
                  cv = issue.custom_values.select {|v| v.custom_field_id == @cf.id}.collect {|v| @cf.cast_value(v.value)}
                  cv.size > 1 ? cv.sort {|a,b| a.to_s <=> b.to_s} : cv.first
                end
                def css_classes
                  @css_classes ||= "#{name} #{@cf.field_format}"
                end
              end
              class Query < ActiveRecord::Base
                class StatementInvalid < ::ActiveRecord::StatementInvalid
                end
                belongs_to :project
                belongs_to :user
                serialize :filters
                serialize :column_names
                serialize :sort_criteria, Array
                attr_protected :project_id, :user_id
                validates_presence_of :name
                validates_length_of :name, :maximum => 255
                validate :validate_query_filters
                @@operators = { "="   => :label_equals,
                                "!"   => :label_not_equals,
                                "o"   => :label_open_issues,
                                "c"   => :label_closed_issues,
                                "!*"  => :label_none,
                                "*"   => :label_any,
                                ">="  => :label_greater_or_equal,
                                "<="  => :label_less_or_equal,
                                "><"  => :label_between,
                                "<t+" => :label_in_less_than,
                                ">t+" => :label_in_more_than,
+                               "><t+"=> :label_in_the_next_days,
                                "t+"  => :label_in,
                                "t"   => :label_today,
                                "w"   => :label_this_week,
                                ">t-" => :label_less_than_ago,
                                "<t-" => :label_more_than_ago,
+                               "><t-"=> :label_in_the_past_days,
                                "t-"  => :label_ago,
                                "~"   => :label_contains,
                                "!~"  => :label_not_contains,
                                "=p"  => :label_any_issues_in_project,
                                "=!p" => :label_any_issues_not_in_project,
                                "!p"  => :label_no_issues_in_project}
                cattr_reader :operators
                @@operators_by_filter_type = { :list => [ "=", "!" ],
                                               :list_status => [ "o", "=", "!", "c", "*" ],
                                               :list_optional => [ "=", "!", "!*", "*" ],
                                               :list_subprojects => [ "*", "!*", "=" ],
-                                              :date => [ "=", ">=", "<=", "><", "<t+", ">t+", "t+", "t", "w", ">t-", "<t-", "t-", "!*", "*" ],
-                                              :date_past => [ "=", ">=", "<=", "><", ">t-", "<t-", "t-", "t", "w", "!*", "*" ],
+                                              :date => [ "=", ">=", "<=", "><", "<t+", ">t+", "><t+", "t+", "t", "w", ">t-", "<t-", "><t-", "t-", "!*", "*" ],
+                                              :date_past => [ "=", ">=", "<=", "><", ">t-", "<t-", "><t-", "t-", "t", "w", "!*", "*" ],
                                               :string => [ "=", "~", "!", "!~", "!*", "*" ],
                                               :text => [  "~", "!~", "!*", "*" ],
                                               :integer => [ "=", ">=", "<=", "><", "!*", "*" ],
                                               :float => [ "=", ">=", "<=", "><", "!*", "*" ],
                                               :relation => ["=", "=p", "=!p", "!p", "!*", "*"]}
                cattr_reader :operators_by_filter_type
                @@available_columns = [
                  QueryColumn.new(:project, :sortable => "#{Project.table_name}.name", :groupable => true),
                  QueryColumn.new(:tracker, :sortable => "#{Tracker.table_name}.position", :groupable => true),
                  QueryColumn.new(:parent, :sortable => ["#{Issue.table_name}.root_id", "#{Issue.table_name}.lft ASC"], :default_order => 'desc', :caption => :field_parent_issue),
                  QueryColumn.new(:status, :sortable => "#{IssueStatus.table_name}.position", :groupable => true),
                  QueryColumn.new(:priority, :sortable => "#{IssuePriority.table_name}.position", :default_order => 'desc', :groupable => true),
                  QueryColumn.new(:subject, :sortable => "#{Issue.table_name}.subject"),
                  QueryColumn.new(:author, :sortable => lambda {User.fields_for_order_statement("authors")}, :groupable => true),
                  QueryColumn.new(:assigned_to, :sortable => lambda {User.fields_for_order_statement}, :groupable => true),
                  QueryColumn.new(:updated_on, :sortable => "#{Issue.table_name}.updated_on", :default_order => 'desc'),
                  QueryColumn.new(:category, :sortable => "#{IssueCategory.table_name}.name", :groupable => true),
                  QueryColumn.new(:fixed_version, :sortable => lambda {Version.fields_for_order_statement}, :groupable => true),
                  QueryColumn.new(:start_date, :sortable => "#{Issue.table_name}.start_date"),
                  QueryColumn.new(:due_date, :sortable => "#{Issue.table_name}.due_date"),
                  QueryColumn.new(:estimated_hours, :sortable => "#{Issue.table_name}.estimated_hours"),
                  QueryColumn.new(:done_ratio, :sortable => "#{Issue.table_name}.done_ratio", :groupable => true),
                  QueryColumn.new(:created_on, :sortable => "#{Issue.table_name}.created_on", :default_order => 'desc'),
                  QueryColumn.new(:relations, :caption => :label_related_issues)
                ]
                cattr_reader :available_columns
                scope :visible, lambda {|*args|
                  user = args.shift || User.current
                  base = Project.allowed_to_condition(user, :view_issues, *args)
                  user_id = user.logged? ? user.id : 0
                  {
                    :conditions => ["(#{table_name}.project_id IS NULL OR (#{base})) AND (#{table_name}.is_public = ? OR #{table_name}.user_id = ?)", true, user_id],
                    :include => :project
                  }
                }
                def initialize(attributes=nil, *args)
                  super attributes
                  self.filters ||= { 'status_id' => {:operator => "o", :values => [""]} }
                  @is_for_all = project.nil?
                end
                def validate_query_filters
                  filters.each_key do |field|
                    if values_for(field)
                      case type_for(field)
                      when :integer
                        add_filter_error(field, :invalid) if values_for(field).detect {|v| v.present? && !v.match(/^[+-]?\d+$/) }
                      when :float
                        add_filter_error(field, :invalid) if values_for(field).detect {|v| v.present? && !v.match(/^[+-]?\d+(\.\d*)?$/) }
                      when :date, :date_past
                        case operator_for(field)
                        when "=", ">=", "<=", "><"
                          add_filter_error(field, :invalid) if values_for(field).detect {|v| v.present? && (!v.match(/^\d{4}-\d{2}-\d{2}$/) || (Date.parse(v) rescue nil).nil?) }
-                       when ">t-", "<t-", "t-", ">t+", "<t+", "t+"
+                       when ">t-", "<t-", "t-", ">t+", "<t+", "t+", "><t+", "><t-"
                          add_filter_error(field, :invalid) if values_for(field).detect {|v| v.present? && !v.match(/^\d+$/) }
                        end
                      end
                    end
                    add_filter_error(field, :blank) unless
                        # filter requires one or more values
                        (values_for(field) and !values_for(field).first.blank?) or
                        # filter doesn't require any value
                        ["o", "c", "!*", "*", "t", "w"].include? operator_for(field)
                  end if filters
                end
                def add_filter_error(field, message)
                  m = label_for(field) + " " + l(message, :scope => 'activerecord.errors.messages')
                  errors.add(:base, m)
                end
                # Returns true if the query is visible to +user+ or the current user.
                def visible?(user=User.current)
                  (project.nil? || user.allowed_to?(:view_issues, project)) && (self.is_public? || self.user_id == user.id)
                end
                def editable_by?(user)
                  return false unless user
                  # Admin can edit them all and regular users can edit their private queries
                  return true if user.admin? || (!is_public && self.user_id == user.id)
                  # Members can not edit public queries that are for all project (only admin is allowed to)
                  is_public && !@is_for_all && user.allowed_to?(:manage_public_queries, project)
                end
                def trackers
                  @trackers ||= project.nil? ? Tracker.find(:all, :order => 'position') : project.rolled_up_trackers
                end
                # Returns a hash of localized labels for all filter operators
                def self.operators_labels
                  operators.inject({}) {|h, operator| h[operator.first] = l(operator.last); h}
                end
                def available_filters
                  return @available_filters if @available_filters
                  @available_filters = {
                    "status_id" => {
                      :type => :list_status, :order => 0,
                      :values => IssueStatus.find(:all, :order => 'position').collect{|s| [s.name, s.id.to_s] }
                     },
                    "tracker_id" => {
                      :type => :list, :order => 2, :values => trackers.collect{|s| [s.name, s.id.to_s] }
                     },
                    "priority_id" => {
                      :type => :list, :order => 3, :values => IssuePriority.all.collect{|s| [s.name, s.id.to_s] }
                     },
                    "subject" => { :type => :text, :order => 8 },
                    "created_on" => { :type => :date_past, :order => 9 },
                    "updated_on" => { :type => :date_past, :order => 10 },
                    "start_date" => { :type => :date, :order => 11 },
                    "due_date" => { :type => :date, :order => 12 },
                    "estimated_hours" => { :type => :float, :order => 13 },
                    "done_ratio" =>  { :type => :integer, :order => 14 }
                  }
                  IssueRelation::TYPES.each do |relation_type, options|
                    @available_filters[relation_type] = {
                      :type => :relation, :order => @available_filters.size + 100,
                      :label => options[:name]
                    }
                  end
                  principals = []
                  if project
                    principals += project.principals.sort
                    unless project.leaf?
                      subprojects = project.descendants.visible.all
                      if subprojects.any?
                        @available_filters["subproject_id"] = {
                          :type => :list_subprojects, :order => 13,
                          :values => subprojects.collect{|s| [s.name, s.id.to_s] }
                        }
                        principals += Principal.member_of(subprojects)
                      end
                    end
                  else
                    if all_projects.any?
                      # members of visible projects
                      principals += Principal.member_of(all_projects)
                      # project filter
                      project_values = []
                      if User.current.logged? && User.current.memberships.any?
                        project_values << ["<< #{l(:label_my_projects).downcase} >>", "mine"]
                      end
                      project_values += all_projects_values
                      @available_filters["project_id"] = {
                        :type => :list, :order => 1, :values => project_values
                      } unless project_values.empty?
                    end
                  end
                  principals.uniq!
                  principals.sort!
                  users = principals.select {|p| p.is_a?(User)}
                  assigned_to_values = []
                  assigned_to_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
                  assigned_to_values += (Setting.issue_group_assignment? ?
                                            principals : users).collect{|s| [s.name, s.id.to_s] }
                  @available_filters["assigned_to_id"] = {
                    :type => :list_optional, :order => 4, :values => assigned_to_values
                  } unless assigned_to_values.empty?
                  author_values = []
                  author_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
                  author_values += users.collect{|s| [s.name, s.id.to_s] }
                  @available_filters["author_id"] = {
                    :type => :list, :order => 5, :values => author_values
                  } unless author_values.empty?
                  group_values = Group.all.collect {|g| [g.name, g.id.to_s] }
                  @available_filters["member_of_group"] = {
                    :type => :list_optional, :order => 6, :values => group_values
                  } unless group_values.empty?
                  role_values = Role.givable.collect {|r| [r.name, r.id.to_s] }
                  @available_filters["assigned_to_role"] = {
                    :type => :list_optional, :order => 7, :values => role_values
                  } unless role_values.empty?
                  if User.current.logged?
                    @available_filters["watcher_id"] = {
                      :type => :list, :order => 15, :values => [["<< #{l(:label_me)} >>", "me"]]
                    }
                  end
                  if project
                    # project specific filters
                    categories = project.issue_categories.all
                    unless categories.empty?
                      @available_filters["category_id"] = {
                        :type => :list_optional, :order => 6,
                        :values => categories.collect{|s| [s.name, s.id.to_s] }
                      }
                    end
                    versions = project.shared_versions.all
                    unless versions.empty?
                      @available_filters["fixed_version_id"] = {
                        :type => :list_optional, :order => 7,
                        :values => versions.sort.collect{|s| ["#{s.project.name} - #{s.name}", s.id.to_s] }
                      }
                    end
                    add_custom_fields_filters(project.all_issue_custom_fields)
                  else
                    # global filters for cross project issue list
                    system_shared_versions = Version.visible.find_all_by_sharing('system')
                    unless system_shared_versions.empty?
                      @available_filters["fixed_version_id"] = {
                        :type => :list_optional, :order => 7,
                        :values => system_shared_versions.sort.collect{|s|
                                                     ["#{s.project.name} - #{s.name}", s.id.to_s]
                                                   }
                      }
                    end
                    add_custom_fields_filters(
                                 IssueCustomField.find(:all,
                                                       :conditions => {
                                                          :is_filter => true,
                                                          :is_for_all => true
                                                       }))
                  end
                  add_associations_custom_fields_filters :project, :author, :assigned_to, :fixed_version
                  if User.current.allowed_to?(:set_issues_private, nil, :global => true) ||
                    User.current.allowed_to?(:set_own_issues_private, nil, :global => true)
                    @available_filters["is_private"] = {
                      :type => :list, :order => 16,
                      :values => [[l(:general_text_yes), "1"], [l(:general_text_no), "0"]]
                    }
                  end
                  Tracker.disabled_core_fields(trackers).each {|field|
                    @available_filters.delete field
                  }
                  @available_filters.each do |field, options|
                    options[:name] ||= l(options[:label] || "field_#{field}".gsub(/_id$/, ''))
                  end
                  @available_filters
                end
                # Returns a representation of the available filters for JSON serialization
                def available_filters_as_json
                  json = {}
                  available_filters.each do |field, options|
                    json[field] = options.slice(:type, :name, :values).stringify_keys
                  end
                  json
                end
                def all_projects
                  @all_projects ||= Project.visible.all
                end
                def all_projects_values
                  return @all_projects_values if @all_projects_values
                  values = []
                  Project.project_tree(all_projects) do |p, level|
                    prefix = (level > 0 ? ('--' * level + ' ') : '')
                    values << ["#{prefix}#{p.name}", p.id.to_s]
                  end
                  @all_projects_values = values
                end
                def add_filter(field, operator, values)
                  # values must be an array
                  return unless values.nil? || values.is_a?(Array)
                  # check if field is defined as an available filter
                  if available_filters.has_key? field
                    filter_options = available_filters[field]
                    # check if operator is allowed for that filter
                    #if @@operators_by_filter_type[filter_options[:type]].include? operator
                    #  allowed_values = values & ([""] + (filter_options[:values] || []).collect {|val| val[1]})
                    #  filters[field] = {:operator => operator, :values => allowed_values } if (allowed_values.first and !allowed_values.first.empty?) or ["o", "c", "!*", "*", "t"].include? operator
                    #end
                    filters[field] = {:operator => operator, :values => (values || [''])}
                  end
                end
                def add_short_filter(field, expression)
                  return unless expression && available_filters.has_key?(field)
                  field_type = available_filters[field][:type]
                  @@operators_by_filter_type[field_type].sort.reverse.detect do |operator|
                    next unless expression =~ /^#{Regexp.escape(operator)}(.*)$/
                    add_filter field, operator, $1.present? ? $1.split('|') : ['']
                  end || add_filter(field, '=', expression.split('|'))
                end
                # Add multiple filters using +add_filter+
                def add_filters(fields, operators, values)
                  if fields.is_a?(Array) && operators.is_a?(Hash) && (values.nil? || values.is_a?(Hash))
                    fields.each do |field|
                      add_filter(field, operators[field], values && values[field])
                    end
                  end
                end
                def has_filter?(field)
                  filters and filters[field]
                end
                def type_for(field)
                  available_filters[field][:type] if available_filters.has_key?(field)
                end
                def operator_for(field)
                  has_filter?(field) ? filters[field][:operator] : nil
                end
                def values_for(field)
                  has_filter?(field) ? filters[field][:values] : nil
                end
                def value_for(field, index=0)
                  (values_for(field) || [])[index]
                end
                def label_for(field)
                  label = available_filters[field][:name] if available_filters.has_key?(field)
                  label ||= l("field_#{field.to_s.gsub(/_id$/, '')}", :default => field)
                end
                def available_columns
                  return @available_columns if @available_columns
                  @available_columns = ::Query.available_columns.dup
                  @available_columns += (project ?
                                          project.all_issue_custom_fields :
                                          IssueCustomField.find(:all)
                                         ).collect {|cf| QueryCustomFieldColumn.new(cf) }
                  if User.current.allowed_to?(:view_time_entries, project, :global => true)
                    index = nil
                    @available_columns.each_with_index {|column, i| index = i if column.name == :estimated_hours}
                    index = (index ? index + 1 : -1)
                    # insert the column after estimated_hours or at the end
                    @available_columns.insert index, QueryColumn.new(:spent_hours,
                      :sortable => "(SELECT COALESCE(SUM(hours), 0) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id)",
                      :default_order => 'desc',
                      :caption => :label_spent_time
                    )
                  end
                  if User.current.allowed_to?(:set_issues_private, nil, :global => true) ||
                    User.current.allowed_to?(:set_own_issues_private, nil, :global => true)
                    @available_columns << QueryColumn.new(:is_private, :sortable => "#{Issue.table_name}.is_private")
                  end
                  disabled_fields = Tracker.disabled_core_fields(trackers).map {|field| field.sub(/_id$/, '')}
                  @available_columns.reject! {|column|
                    disabled_fields.include?(column.name.to_s)
                  }
                  @available_columns
                end
                def self.available_columns=(v)
                  self.available_columns = (v)
                end
                def self.add_available_column(column)
                  self.available_columns << (column) if column.is_a?(QueryColumn)
                end
                # Returns an array of columns that can be used to group the results
                def groupable_columns
                  available_columns.select {|c| c.groupable}
                end
                # Returns a Hash of columns and the key for sorting
                def sortable_columns
                  {'id' => "#{Issue.table_name}.id"}.merge(available_columns.inject({}) {|h, column|
                                                             h[column.name.to_s] = column.sortable
                                                             h
                                                           })
                end
                def columns
                  # preserve the column_names order
                  (has_default_columns? ? default_columns_names : column_names).collect do |name|
                     available_columns.find { |col| col.name == name }
                  end.compact
                end
                def default_columns_names
                  @default_columns_names ||= begin
                    default_columns = Setting.issue_list_default_columns.map(&:to_sym)
                    project.present? ? default_columns : [:project] | default_columns
                  end
                end
                def column_names=(names)
                  if names
                    names = names.select {|n| n.is_a?(Symbol) || !n.blank? }
                    names = names.collect {|n| n.is_a?(Symbol) ? n : n.to_sym }
                    # Set column_names to nil if default columns
                    if names == default_columns_names
                      names = nil
                    end
                  end
                  write_attribute(:column_names, names)
                end
                def has_column?(column)
                  column_names && column_names.include?(column.is_a?(QueryColumn) ? column.name : column)
                end
                def has_default_columns?
                  column_names.nil? || column_names.empty?
                end
                def sort_criteria=(arg)
                  c = []
                  if arg.is_a?(Hash)
                    arg = arg.keys.sort.collect {|k| arg[k]}
                  end
                  c = arg.select {|k,o| !k.to_s.blank?}.slice(0,3).collect {|k,o| [k.to_s, (o == 'desc' || o == false) ? 'desc' : 'asc']}
                  write_attribute(:sort_criteria, c)
                end
                def sort_criteria
                  read_attribute(:sort_criteria) || []
                end
                def sort_criteria_key(arg)
                  sort_criteria && sort_criteria[arg] && sort_criteria[arg].first
                end
                def sort_criteria_order(arg)
                  sort_criteria && sort_criteria[arg] && sort_criteria[arg].last
                end
                def sort_criteria_order_for(key)
                  sort_criteria.detect {|k, order| key.to_s == k}.try(:last)
                end
                # Returns the SQL sort order that should be prepended for grouping
                def group_by_sort_order
                  if grouped? && (column = group_by_column)
                    order = sort_criteria_order_for(column.name) || column.default_order
                    column.sortable.is_a?(Array) ?
                      column.sortable.collect {|s| "#{s} #{order}"}.join(',') :
                      "#{column.sortable} #{order}"
                  end
                end
                # Returns true if the query is a grouped query
                def grouped?
                  !group_by_column.nil?
                end
                def group_by_column
                  groupable_columns.detect {|c| c.groupable && c.name.to_s == group_by}
                end
                def group_by_statement
                  group_by_column.try(:groupable)
                end
                def project_statement
                  project_clauses = []
                  if project && !project.descendants.active.empty?
                    ids = [project.id]
                    if has_filter?("subproject_id")
                      case operator_for("subproject_id")
                      when '='
                        # include the selected subprojects
                        ids += values_for("subproject_id").each(&:to_i)
                      when '!*'
                        # main project only
                      else
                        # all subprojects
                        ids += project.descendants.collect(&:id)
                      end
                    elsif Setting.display_subprojects_issues?
                      ids += project.descendants.collect(&:id)
                    end
                    project_clauses << "#{Project.table_name}.id IN (%s)" % ids.join(',')
                  elsif project
                    project_clauses << "#{Project.table_name}.id = %d" % project.id
                  end
                  project_clauses.any? ? project_clauses.join(' AND ') : nil
                end
                def statement
                  # filters clauses
                  filters_clauses = []
                  filters.each_key do |field|
                    next if field == "subproject_id"
                    v = values_for(field).clone
                    next unless v and !v.empty?
                    operator = operator_for(field)
                    # "me" value subsitution
                    if %w(assigned_to_id author_id watcher_id).include?(field)
                      if v.delete("me")
                        if User.current.logged?
                          v.push(User.current.id.to_s)
                          v += User.current.group_ids.map(&:to_s) if field == 'assigned_to_id'
                        else
                          v.push("0")
                        end
                      end
                    end
                    if field == 'project_id'
                      if v.delete('mine')
                        v += User.current.memberships.map(&:project_id).map(&:to_s)
                      end
                    end
                    if field =~ /cf_(\d+)$/
                      # custom field
                      filters_clauses << sql_for_custom_field(field, operator, v, $1)
                    elsif respond_to?("sql_for_#{field}_field")
                      # specific statement
                      filters_clauses << send("sql_for_#{field}_field", field, operator, v)
                    else
                      # regular field
                      filters_clauses << '(' + sql_for_field(field, operator, v, Issue.table_name, field) + ')'
                    end
                  end if filters and valid?
                  filters_clauses << project_statement
                  filters_clauses.reject!(&:blank?)
                  filters_clauses.any? ? filters_clauses.join(' AND ') : nil
                end
                # Returns the issue count
                def issue_count
                  Issue.visible.count(:include => [:status, :project], :conditions => statement)
                rescue ::ActiveRecord::StatementInvalid => e
                  raise StatementInvalid.new(e.message)
                end
                # Returns the issue count by group or nil if query is not grouped
                def issue_count_by_group
                  r = nil
                  if grouped?
                    begin
                      # Rails3 will raise an (unexpected) RecordNotFound if there's only a nil group value
                      r = Issue.visible.count(:group => group_by_statement, :include => [:status, :project], :conditions => statement)
                    rescue ActiveRecord::RecordNotFound
                      r = {nil => issue_count}
                    end
                    c = group_by_column
                    if c.is_a?(QueryCustomFieldColumn)
                      r = r.keys.inject({}) {|h, k| h[c.custom_field.cast_value(k)] = r[k]; h}
                    end
                  end
                  r
                rescue ::ActiveRecord::StatementInvalid => e
                  raise StatementInvalid.new(e.message)
                end
                # Returns the issues
                # Valid options are :order, :offset, :limit, :include, :conditions
                def issues(options={})
                  order_option = [group_by_sort_order, options[:order]].reject {|s| s.blank?}.join(',')
                  order_option = nil if order_option.blank?
                  issues = Issue.visible.scoped(:conditions => options[:conditions]).find :all, :include => ([:status, :project] + (options[:include] || [])).uniq,
                                   :conditions => statement,
                                   :order => order_option,
                                   :joins => joins_for_order_statement(order_option),
                                   :limit  => options[:limit],
                                   :offset => options[:offset]
                  if has_column?(:spent_hours)
                    Issue.load_visible_spent_hours(issues)
                  end
                  if has_column?(:relations)
                    Issue.load_visible_relations(issues)
                  end
                  issues
                rescue ::ActiveRecord::StatementInvalid => e
                  raise StatementInvalid.new(e.message)
                end
                # Returns the issues ids
                def issue_ids(options={})
                  order_option = [group_by_sort_order, options[:order]].reject {|s| s.blank?}.join(',')
                  order_option = nil if order_option.blank?
                  Issue.visible.scoped(:conditions => options[:conditions]).scoped(:include => ([:status, :project] + (options[:include] || [])).uniq,
                                   :conditions => statement,
                                   :order => order_option,
                                   :joins => joins_for_order_statement(order_option),
                                   :limit  => options[:limit],
                                   :offset => options[:offset]).find_ids
                rescue ::ActiveRecord::StatementInvalid => e
                  raise StatementInvalid.new(e.message)
                end
                # Returns the journals
                # Valid options are :order, :offset, :limit
                def journals(options={})
                  Journal.visible.find :all, :include => [:details, :user, {:issue => [:project, :author, :tracker, :status]}],
                                     :conditions => statement,
                                     :order => options[:order],
                                     :limit => options[:limit],
                                     :offset => options[:offset]
                rescue ::ActiveRecord::StatementInvalid => e
                  raise StatementInvalid.new(e.message)
                end
                # Returns the versions
                # Valid options are :conditions
                def versions(options={})
                  Version.visible.scoped(:conditions => options[:conditions]).find :all, :include => :project, :conditions => project_statement
                rescue ::ActiveRecord::StatementInvalid => e
                  raise StatementInvalid.new(e.message)
                end
                def sql_for_watcher_id_field(field, operator, value)
                  db_table = Watcher.table_name
                  "#{Issue.table_name}.id #{ operator == '=' ? 'IN' : 'NOT IN' } (SELECT #{db_table}.watchable_id FROM #{db_table} WHERE #{db_table}.watchable_type='Issue' AND " +
                    sql_for_field(field, '=', value, db_table, 'user_id') + ')'
                end
                def sql_for_member_of_group_field(field, operator, value)
                  if operator == '*' # Any group
                    groups = Group.all
                    operator = '=' # Override the operator since we want to find by assigned_to
                  elsif operator == "!*"
                    groups = Group.all
                    operator = '!' # Override the operator since we want to find by assigned_to
                  else
                    groups = Group.find_all_by_id(value)
                  end
                  groups ||= []
                  members_of_groups = groups.inject([]) {|user_ids, group|
                    if group && group.user_ids.present?
                      user_ids << group.user_ids
                    end
                    user_ids.flatten.uniq.compact
                  }.sort.collect(&:to_s)
                  '(' + sql_for_field("assigned_to_id", operator, members_of_groups, Issue.table_name, "assigned_to_id", false) + ')'
                end
                def sql_for_assigned_to_role_field(field, operator, value)
                  case operator
                  when "*", "!*" # Member / Not member
                    sw = operator == "!*" ? 'NOT' : ''
                    nl = operator == "!*" ? "#{Issue.table_name}.assigned_to_id IS NULL OR" : ''
                    "(#{nl} #{Issue.table_name}.assigned_to_id #{sw} IN (SELECT DISTINCT #{Member.table_name}.user_id FROM #{Member.table_name}" +
                      " WHERE #{Member.table_name}.project_id = #{Issue.table_name}.project_id))"
                  when "=", "!"
                    role_cond = value.any? ?
                      "#{MemberRole.table_name}.role_id IN (" + value.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + ")" :
                      "1=0"
                    sw = operator == "!" ? 'NOT' : ''
                    nl = operator == "!" ? "#{Issue.table_name}.assigned_to_id IS NULL OR" : ''
                    "(#{nl} #{Issue.table_name}.assigned_to_id #{sw} IN (SELECT DISTINCT #{Member.table_name}.user_id FROM #{Member.table_name}, #{MemberRole.table_name}" +
                      " WHERE #{Member.table_name}.project_id = #{Issue.table_name}.project_id AND #{Member.table_name}.id = #{MemberRole.table_name}.member_id AND #{role_cond}))"
                  end
                end
                def sql_for_is_private_field(field, operator, value)
                  op = (operator == "=" ? 'IN' : 'NOT IN')
                  va = value.map {|v| v == '0' ? connection.quoted_false : connection.quoted_true}.uniq.join(',')
                  "#{Issue.table_name}.is_private #{op} (#{va})"
                end
                def sql_for_relations(field, operator, value, options={})
                  relation_options = IssueRelation::TYPES[field]
                  return relation_options unless relation_options
                  relation_type = field
                  join_column, target_join_column = "issue_from_id", "issue_to_id"
                  if relation_options[:reverse] || options[:reverse]
                    relation_type = relation_options[:reverse] || relation_type
                    join_column, target_join_column = target_join_column, join_column
                  end
                  sql = case operator
                    when "*", "!*"
                      op = (operator == "*" ? 'IN' : 'NOT IN')
                      "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name} WHERE #{IssueRelation.table_name}.relation_type = '#{connection.quote_string(relation_type)}')"
                    when "=", "!"
                      op = (operator == "=" ? 'IN' : 'NOT IN')
                      "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name} WHERE #{IssueRelation.table_name}.relation_type = '#{connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = #{value.first.to_i})"
                    when "=p", "=!p", "!p"
                      op = (operator == "!p" ? 'NOT IN' : 'IN')
                      comp = (operator == "=!p" ? '<>' : '=')
                      "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name}, #{Issue.table_name} relissues WHERE #{IssueRelation.table_name}.relation_type = '#{connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = relissues.id AND relissues.project_id #{comp} #{value.first.to_i})"
                    end
                  if relation_options[:sym] == field && !options[:reverse]
                    sqls = [sql, sql_for_relations(field, operator, value, :reverse => true)]
                    sqls.join(["!", "!*", "!p"].include?(operator) ? " AND " : " OR ")
                  else
                    sql
                  end
                end
                IssueRelation::TYPES.keys.each do |relation_type|
                  alias_method "sql_for_#{relation_type}_field".to_sym, :sql_for_relations
                end
                private
                def sql_for_custom_field(field, operator, value, custom_field_id)
                  db_table = CustomValue.table_name
                  db_field = 'value'
                  filter = @available_filters[field]
                  return nil unless filter
                  if filter[:format] == 'user'
                    if value.delete('me')
                      value.push User.current.id.to_s
                    end
                  end
                  not_in = nil
                  if operator == '!'
                    # Makes ! operator work for custom fields with multiple values
                    operator = '='
                    not_in = 'NOT'
                  end
                  customized_key = "id"
                  customized_class = Issue
                  if field =~ /^(.+)\.cf_/
                    assoc = $1
                    customized_key = "#{assoc}_id"
                    customized_class = Issue.reflect_on_association(assoc.to_sym).klass.base_class rescue nil
                    raise "Unknown Issue association #{assoc}" unless customized_class
                  end
                  "#{Issue.table_name}.#{customized_key} #{not_in} IN (SELECT #{customized_class.table_name}.id FROM #{customized_class.table_name} LEFT OUTER JOIN #{db_table} ON #{db_table}.customized_type='#{customized_class}' AND #{db_table}.customized_id=#{customized_class.table_name}.id AND #{db_table}.custom_field_id=#{custom_field_id} WHERE " +
                    sql_for_field(field, operator, value, db_table, db_field, true) + ')'
                end
                # Helper method to generate the WHERE sql for a +field+, +operator+ and a +value+
                def sql_for_field(field, operator, value, db_table, db_field, is_custom_filter=false)
                  sql = ''
                  case operator
                  when "="
                    if value.any?
                      case type_for(field)
                      when :date, :date_past
                        sql = date_clause(db_table, db_field, (Date.parse(value.first) rescue nil), (Date.parse(value.first) rescue nil))
                      when :integer
                        if is_custom_filter
                          sql = "(#{db_table}.#{db_field} <> '' AND CAST(#{db_table}.#{db_field} AS decimal(60,3)) = #{value.first.to_i})"
                        else
                          sql = "#{db_table}.#{db_field} = #{value.first.to_i}"
                        end
                      when :float
                        if is_custom_filter
                          sql = "(#{db_table}.#{db_field} <> '' AND CAST(#{db_table}.#{db_field} AS decimal(60,3)) BETWEEN #{value.first.to_f - 1e-5} AND #{value.first.to_f + 1e-5})"
                        else
                          sql = "#{db_table}.#{db_field} BETWEEN #{value.first.to_f - 1e-5} AND #{value.first.to_f + 1e-5}"
                        end
                      else
                        sql = "#{db_table}.#{db_field} IN (" + value.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + ")"
                      end
                    else
                      # IN an empty set
                      sql = "1=0"
                    end
                  when "!"
                    if value.any?
                      sql = "(#{db_table}.#{db_field} IS NULL OR #{db_table}.#{db_field} NOT IN (" + value.collect{|val| "'#{connection.quote_string(val)}'"}.join(",") + "))"
                    else
                      # NOT IN an empty set
                      sql = "1=1"
                    end
                  when "!*"
                    sql = "#{db_table}.#{db_field} IS NULL"
                    sql << " OR #{db_table}.#{db_field} = ''" if is_custom_filter
                  when "*"
                    sql = "#{db_table}.#{db_field} IS NOT NULL"
                    sql << " AND #{db_table}.#{db_field} <> ''" if is_custom_filter
                  when ">="
                    if [:date, :date_past].include?(type_for(field))
                      sql = date_clause(db_table, db_field, (Date.parse(value.first) rescue nil), nil)
                    else
                      if is_custom_filter
                        sql = "(#{db_table}.#{db_field} <> '' AND CAST(#{db_table}.#{db_field} AS decimal(60,3)) >= #{value.first.to_f})"
                      else
                        sql = "#{db_table}.#{db_field} >= #{value.first.to_f}"
                      end
                    end
                  when "<="
                    if [:date, :date_past].include?(type_for(field))
                      sql = date_clause(db_table, db_field, nil, (Date.parse(value.first) rescue nil))
                    else
                      if is_custom_filter
                        sql = "(#{db_table}.#{db_field} <> '' AND CAST(#{db_table}.#{db_field} AS decimal(60,3)) <= #{value.first.to_f})"
                      else
                        sql = "#{db_table}.#{db_field} <= #{value.first.to_f}"
                      end
                    end
                  when "><"
                    if [:date, :date_past].include?(type_for(field))
                      sql = date_clause(db_table, db_field, (Date.parse(value[0]) rescue nil), (Date.parse(value[1]) rescue nil))
                    else
                      if is_custom_filter
                        sql = "(#{db_table}.#{db_field} <> '' AND CAST(#{db_table}.#{db_field} AS decimal(60,3)) BETWEEN #{value[0].to_f} AND #{value[1].to_f})"
                      else
                        sql = "#{db_table}.#{db_field} BETWEEN #{value[0].to_f} AND #{value[1].to_f}"
                      end
                    end
                  when "o"
                    sql = "#{Issue.table_name}.status_id IN (SELECT id FROM #{IssueStatus.table_name} WHERE is_closed=#{connection.quoted_false})" if field == "status_id"
                  when "c"
                    sql = "#{Issue.table_name}.status_id IN (SELECT id FROM #{IssueStatus.table_name} WHERE is_closed=#{connection.quoted_true})" if field == "status_id"
-                 when ">t-"
+                 when "><t-"
+                   # between today - n days and today
                    sql = relative_date_clause(db_table, db_field, - value.first.to_i, 0)
+                 when ">t-"
+                   # >= today - n days
+                   sql = relative_date_clause(db_table, db_field, - value.first.to_i, nil)
                  when "<t-"
+                   # <= today - n days
                    sql = relative_date_clause(db_table, db_field, nil, - value.first.to_i)
                  when "t-"
+                   # = n days in past
                    sql = relative_date_clause(db_table, db_field, - value.first.to_i, - value.first.to_i)
+                 when "><t+"
+                   # between today and today + n days
+                   sql = relative_date_clause(db_table, db_field, 0, value.first.to_i)
                  when ">t+"
+                   # >= today + n days
                    sql = relative_date_clause(db_table, db_field, value.first.to_i, nil)
                  when "<t+"
-                   sql = relative_date_clause(db_table, db_field, 0, value.first.to_i)
+                   # <= today + n days
+                   sql = relative_date_clause(db_table, db_field, nil, value.first.to_i)
                  when "t+"
+                   # = today + n days
                    sql = relative_date_clause(db_table, db_field, value.first.to_i, value.first.to_i)
                  when "t"
+                   # = today
                    sql = relative_date_clause(db_table, db_field, 0, 0)
                  when "w"
+                   # = this week
                    first_day_of_week = l(:general_first_day_of_week).to_i
                    day_of_week = Date.today.cwday
                    days_ago = (day_of_week >= first_day_of_week ? day_of_week - first_day_of_week : day_of_week + 7 - first_day_of_week)
                    sql = relative_date_clause(db_table, db_field, - days_ago, - days_ago + 6)
                  when "~"
                    sql = "LOWER(#{db_table}.#{db_field}) LIKE '%#{connection.quote_string(value.first.to_s.downcase)}%'"
                  when "!~"
                    sql = "LOWER(#{db_table}.#{db_field}) NOT LIKE '%#{connection.quote_string(value.first.to_s.downcase)}%'"
                  else
                    raise "Unknown query operator #{operator}"
                  end
                  return sql
                end
                def add_custom_fields_filters(custom_fields, assoc=nil)
                  return unless custom_fields.present?
                  @available_filters ||= {}
                  custom_fields.select(&:is_filter?).each do |field|
                    case field.field_format
                    when "text"
                      options = { :type => :text, :order => 20 }
                    when "list"
                      options = { :type => :list_optional, :values => field.possible_values, :order => 20}
                    when "date"
                      options = { :type => :date, :order => 20 }
                    when "bool"
                      options = { :type => :list, :values => [[l(:general_text_yes), "1"], [l(:general_text_no), "0"]], :order => 20 }
                    when "int"
                      options = { :type => :integer, :order => 20 }
                    when "float"
                      options = { :type => :float, :order => 20 }
                    when "user", "version"
                      next unless project
                      values = field.possible_values_options(project)
                      if User.current.logged? && field.field_format == 'user'
                        values.unshift ["<< #{l(:label_me)} >>", "me"]
                      end
                      options = { :type => :list_optional, :values => values, :order => 20}
                    else
                      options = { :type => :string, :order => 20 }
                    end
                    filter_id = "cf_#{field.id}"
                    filter_name = field.name
                    if assoc.present?
                      filter_id = "#{assoc}.#{filter_id}"
                      filter_name = l("label_attribute_of_#{assoc}", :name => filter_name)
                    end
                    @available_filters[filter_id] = options.merge({
                             :name => filter_name,
                             :format => field.field_format,
                             :field => field
                           })
                  end
                end
                def add_associations_custom_fields_filters(*associations)
                  fields_by_class = CustomField.where(:is_filter => true).group_by(&:class)
                  associations.each do |assoc|
                    association_klass = Issue.reflect_on_association(assoc).klass
                    fields_by_class.each do |field_class, fields|
                      if field_class.customized_class <= association_klass
                        add_custom_fields_filters(fields, assoc)
                      end
                    end
                  end
                end
                # Returns a SQL clause for a date or datetime field.
                def date_clause(table, field, from, to)
                  s = []
                  if from
                    from_yesterday = from - 1
                    from_yesterday_time = Time.local(from_yesterday.year, from_yesterday.month, from_yesterday.day)
                    if self.class.default_timezone == :utc
                      from_yesterday_time = from_yesterday_time.utc
                    end
                    s << ("#{table}.#{field} > '%s'" % [connection.quoted_date(from_yesterday_time.end_of_day)])
                  end
                  if to
                    to_time = Time.local(to.year, to.month, to.day)
                    if self.class.default_timezone == :utc
                      to_time = to_time.utc
                    end
                    s << ("#{table}.#{field} <= '%s'" % [connection.quoted_date(to_time.end_of_day)])
                  end
                  s.join(' AND ')
                end
                # Returns a SQL clause for a date or datetime field using relative dates.
                def relative_date_clause(table, field, days_from, days_to)
                  date_clause(table, field, (days_from ? Date.today + days_from : nil), (days_to ? Date.today + days_to : nil))
                end
                # Additional joins required for the given sort options
                def joins_for_order_statement(order_options)
                  joins = []
                  if order_options
                    if order_options.include?('authors')
                      joins << "LEFT OUTER JOIN #{User.table_name} authors ON authors.id = #{Issue.table_name}.author_id"
                    end
                    order_options.scan(/cf_\d+/).uniq.each do |name|
                      column = available_columns.detect {|c| c.name.to_s == name}
                      join = column && column.custom_field.join_for_order_statement
                      if join
                        joins << join
                      end
                    end
                  end
                  joins.any? ? joins.join(' ') : nil
                end
              end

config/locales/en.yml +2 0

              en:
                # Text direction: Left-to-Right (ltr) or Right-to-Left (rtl)
                direction: ltr
                date:
                  formats:
                    # Use the strftime parameters for formats.
                    # When no format has been given, it uses default.
                    # You can provide other formats here if you like!
                    default: "%m/%d/%Y"
                    short: "%b %d"
                    long: "%B %d, %Y"
                  day_names: [Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday]
                  abbr_day_names: [Sun, Mon, Tue, Wed, Thu, Fri, Sat]
                  # Don't forget the nil at the beginning; there's no such thing as a 0th month
                  month_names: [~, January, February, March, April, May, June, July, August, September, October, November, December]
                  abbr_month_names: [~, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec]
                  # Used in date_select and datime_select.
                  order:
                    - :year
                    - :month
                    - :day
                time:
                  formats:
                    default: "%m/%d/%Y %I:%M %p"
                    time: "%I:%M %p"
                    short: "%d %b %H:%M"
                    long: "%B %d, %Y %H:%M"
                  am: "am"
                  pm: "pm"
                datetime:
                  distance_in_words:
                    half_a_minute: "half a minute"
                    less_than_x_seconds:
                      one:   "less than 1 second"
                      other: "less than %{count} seconds"
                    x_seconds:
                      one:   "1 second"
                      other: "%{count} seconds"
                    less_than_x_minutes:
                      one:   "less than a minute"
                      other: "less than %{count} minutes"
                    x_minutes:
                      one:   "1 minute"
                      other: "%{count} minutes"
                    about_x_hours:
                      one:   "about 1 hour"
                      other: "about %{count} hours"
                    x_hours:
                      one:   "1 hour"
                      other: "%{count} hours"
                    x_days:
                      one:   "1 day"
                      other: "%{count} days"
                    about_x_months:
                      one:   "about 1 month"
                      other: "about %{count} months"
                    x_months:
                      one:   "1 month"
                      other: "%{count} months"
                    about_x_years:
                      one:   "about 1 year"
                      other: "about %{count} years"
                    over_x_years:
                      one:   "over 1 year"
                      other: "over %{count} years"
                    almost_x_years:
                      one:   "almost 1 year"
                      other: "almost %{count} years"
                number:
                  format:
                    separator: "."
                    delimiter: ""
                    precision: 3
                  human:
                    format:
                      delimiter: ""
                      precision: 3
                    storage_units:
                      format: "%n %u"
                      units:
                        byte:
                          one: "Byte"
                          other: "Bytes"
                        kb: "KB"
                        mb: "MB"
                        gb: "GB"
                        tb: "TB"
              # Used in array.to_sentence.
                support:
                  array:
                    sentence_connector: "and"
                    skip_last_comma: false
                activerecord:
                  errors:
                    template:
                      header:
                        one:    "1 error prohibited this %{model} from being saved"
                        other:  "%{count} errors prohibited this %{model} from being saved"
                    messages:
                      inclusion: "is not included in the list"
                      exclusion: "is reserved"
                      invalid: "is invalid"
                      confirmation: "doesn't match confirmation"
                      accepted: "must be accepted"
                      empty: "can't be empty"
                      blank: "can't be blank"
                      too_long: "is too long (maximum is %{count} characters)"
                      too_short: "is too short (minimum is %{count} characters)"
                      wrong_length: "is the wrong length (should be %{count} characters)"
                      taken: "has already been taken"
                      not_a_number: "is not a number"
                      not_a_date: "is not a valid date"
                      greater_than: "must be greater than %{count}"
                      greater_than_or_equal_to: "must be greater than or equal to %{count}"
                      equal_to: "must be equal to %{count}"
                      less_than: "must be less than %{count}"
                      less_than_or_equal_to: "must be less than or equal to %{count}"
                      odd: "must be odd"
                      even: "must be even"
                      greater_than_start_date: "must be greater than start date"
                      not_same_project: "doesn't belong to the same project"
                      circular_dependency: "This relation would create a circular dependency"
                      cant_link_an_issue_with_a_descendant: "An issue cannot be linked to one of its subtasks"
                actionview_instancetag_blank_option: Please select
                general_text_No: 'No'
                general_text_Yes: 'Yes'
                general_text_no: 'no'
                general_text_yes: 'yes'
                general_lang_name: 'English'
                general_csv_separator: ','
                general_csv_decimal_separator: '.'
                general_csv_encoding: ISO-8859-1
                general_pdf_encoding: UTF-8
                general_first_day_of_week: '7'
                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. To activate your account, click on the link that was emailed to you.
                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: The page you were trying to access doesn't exist or has been removed.
                notice_locking_conflict: Data has been updated by another user.
                notice_not_authorized: You are not authorized to access this page.
                notice_not_authorized_archived_project: The project you're trying to access has been archived.
                notice_email_sent: "An email was sent to %{value}"
                notice_email_error: "An error occurred while sending mail (%{value})"
                notice_feeds_access_key_reseted: Your RSS access key was reset.
                notice_api_access_key_reseted: Your API access key was reset.
                notice_failed_to_save_issues: "Failed to save %{count} issue(s) on %{total} selected: %{ids}."
                notice_failed_to_save_time_entries: "Failed to save %{count} time entrie(s) on %{total} selected: %{ids}."
                notice_failed_to_save_members: "Failed to save member(s): %{errors}."
                notice_no_issue_selected: "No issue is selected! Please, check the issues you want to edit."
                notice_account_pending: "Your account was created and is now pending administrator approval."
                notice_default_data_loaded: Default configuration successfully loaded.
                notice_unable_delete_version: Unable to delete version.
                notice_unable_delete_time_entry: Unable to delete time log entry.
                notice_issue_done_ratios_updated: Issue done ratios updated.
                notice_gantt_chart_truncated: "The chart was truncated because it exceeds the maximum number of items that can be displayed (%{max})"
                notice_issue_successful_create: "Issue %{id} created."
                notice_issue_update_conflict: "The issue has been updated by an other user while you were editing it."
                notice_account_deleted: "Your account has been permanently deleted."
                notice_user_successful_create: "User %{id} created."
                error_can_t_load_default_data: "Default configuration could not be loaded: %{value}"
                error_scm_not_found: "The entry or revision was not found in the repository."
                error_scm_command_failed: "An error occurred when trying to access the repository: %{value}"
                error_scm_annotate: "The entry does not exist or cannot be annotated."
                error_scm_annotate_big_text_file: "The entry cannot be annotated, as it exceeds the maximum text file size."
                error_issue_not_found_in_project: 'The issue was not found or does not belong to this project'
                error_no_tracker_in_project: 'No tracker is associated to this project. Please check the Project settings.'
                error_no_default_issue_status: 'No default issue status is defined. Please check your configuration (Go to "Administration -> Issue statuses").'
                error_can_not_delete_custom_field: Unable to delete custom field
                error_can_not_delete_tracker: "This tracker contains issues and cannot be deleted."
                error_can_not_remove_role: "This role is in use and cannot be deleted."
                error_can_not_reopen_issue_on_closed_version: 'An issue assigned to a closed version cannot be reopened'
                error_can_not_archive_project: This project cannot be archived
                error_issue_done_ratios_not_updated: "Issue done ratios not updated."
                error_workflow_copy_source: 'Please select a source tracker or role'
                error_workflow_copy_target: 'Please select target tracker(s) and role(s)'
                error_unable_delete_issue_status: 'Unable to delete issue status'
                error_unable_to_connect: "Unable to connect (%{value})"
                error_attachment_too_big: "This file cannot be uploaded because it exceeds the maximum allowed file size (%{max_size})"
                error_session_expired: "Your session has expired. Please login again."
                warning_attachments_not_saved: "%{count} file(s) could not be saved."
                mail_subject_lost_password: "Your %{value} password"
                mail_body_lost_password: 'To change your password, click on the following link:'
                mail_subject_register: "Your %{value} account activation"
                mail_body_register: 'To activate your account, click on the following link:'
                mail_body_account_information_external: "You can use your %{value} account to log in."
                mail_body_account_information: Your account information
                mail_subject_account_activation_request: "%{value} account activation request"
                mail_body_account_activation_request: "A new user (%{value}) has registered. The account is pending your approval:"
                mail_subject_reminder: "%{count} issue(s) due in the next %{days} days"
                mail_body_reminder: "%{count} issue(s) that are assigned to you are due in the next %{days} days:"
                mail_subject_wiki_content_added: "'%{id}' wiki page has been added"
                mail_body_wiki_content_added: "The '%{id}' wiki page has been added by %{author}."
                mail_subject_wiki_content_updated: "'%{id}' wiki page has been updated"
                mail_body_wiki_content_updated: "The '%{id}' wiki page has been updated by %{author}."
                gui_validation_error: 1 error
                gui_validation_error_plural: "%{count} errors"
                field_name: Name
                field_description: Description
                field_summary: Summary
                field_is_required: Required
                field_firstname: First name
                field_lastname: Last name
                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 value
                field_tracker: Tracker
                field_subject: Subject
                field_due_date: Due date
                field_assigned_to: Assignee
                field_priority: Priority
                field_fixed_version: Target version
                field_user: User
                field_principal: Principal
                field_role: Role
                field_homepage: Homepage
                field_is_public: Public
                field_parent: Subproject of
                field_is_in_roadmap: Issues displayed in roadmap
                field_login: Login
                field_mail_notification: Email notifications
                field_admin: Administrator
                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 date
                field_done_ratio: "% Done"
                field_auth_source: Authentication mode
                field_hide_mail: Hide my email address
                field_comments: Comment
                field_url: URL
                field_start_page: Start page
                field_subproject: Subproject
                field_hours: Hours
                field_activity: Activity
                field_spent_on: Date
                field_identifier: Identifier
                field_is_filter: Used as a filter
                field_issue_to: Related issue
                field_delay: Delay
                field_assignable: Issues can be assigned to this role
                field_redirect_existing_links: Redirect existing links
                field_estimated_hours: Estimated time
                field_column_names: Columns
                field_time_entries: Log time
                field_time_zone: Time zone
                field_searchable: Searchable
                field_default_value: Default value
                field_comments_sorting: Display comments
                field_parent_title: Parent page
                field_editable: Editable
                field_watcher: Watcher
                field_identity_url: OpenID URL
                field_content: Content
                field_group_by: Group results by
                field_sharing: Sharing
                field_parent_issue: Parent task
                field_member_of_group: "Assignee's group"
                field_assigned_to_role: "Assignee's role"
                field_text: Text field
                field_visible: Visible
                field_warn_on_leaving_unsaved: "Warn me when leaving a page with unsaved text"
                field_issues_visibility: Issues visibility
                field_is_private: Private
                field_commit_logs_encoding: Commit messages encoding
                field_scm_path_encoding: Path encoding
                field_path_to_repository: Path to repository
                field_root_directory: Root directory
                field_cvsroot: CVSROOT
                field_cvs_module: Module
                field_repository_is_default: Main repository
                field_multiple: Multiple values
                field_auth_source_ldap_filter: LDAP filter
                field_core_fields: Standard fields
                field_timeout: "Timeout (in seconds)"
                field_board_parent: Parent forum
                field_private_notes: Private notes
                setting_app_title: Application title
                setting_app_subtitle: Application subtitle
                setting_welcome_text: Welcome text
                setting_default_language: Default language
                setting_login_required: Authentication required
                setting_self_registration: Self-registration
                setting_attachment_max_size: Maximum attachment size
                setting_issues_export_limit: Issues export limit
                setting_mail_from: Emission email address
                setting_bcc_recipients: Blind carbon copy recipients (bcc)
                setting_plain_text_mail: Plain text mail (no HTML)
                setting_host_name: Host name and path
                setting_text_formatting: Text formatting
                setting_wiki_compression: Wiki history compression
                setting_feeds_limit: Maximum number of items in Atom feeds
                setting_default_projects_public: New projects are public by default
                setting_autofetch_changesets: Fetch commits automatically
                setting_sys_api_enabled: Enable WS for repository management
                setting_commit_ref_keywords: Referencing keywords
                setting_commit_fix_keywords: Fixing keywords
                setting_autologin: Autologin
                setting_date_format: Date format
                setting_time_format: Time format
                setting_cross_project_issue_relations: Allow cross-project issue relations
                setting_cross_project_subtasks: Allow cross-project subtasks
                setting_issue_list_default_columns: Default columns displayed on the issue list
                setting_repositories_encodings: Attachments and repositories encodings
                setting_emails_header: Emails header
                setting_emails_footer: Emails footer
                setting_protocol: Protocol
                setting_per_page_options: Objects per page options
                setting_user_format: Users display format
                setting_activity_days_default: Days displayed on project activity
                setting_display_subprojects_issues: Display subprojects issues on main projects by default
                setting_enabled_scm: Enabled SCM
                setting_mail_handler_body_delimiters: "Truncate emails after one of these lines"
                setting_mail_handler_api_enabled: Enable WS for incoming emails
                setting_mail_handler_api_key: API key
                setting_sequential_project_identifiers: Generate sequential project identifiers
                setting_gravatar_enabled: Use Gravatar user icons
                setting_gravatar_default: Default Gravatar image
                setting_diff_max_lines_displayed: Maximum number of diff lines displayed
                setting_file_max_size_displayed: Maximum size of text files displayed inline
                setting_repository_log_display_limit: Maximum number of revisions displayed on file log
                setting_openid: Allow OpenID login and registration
                setting_password_min_length: Minimum password length
                setting_new_project_user_role_id: Role given to a non-admin user who creates a project
                setting_default_projects_modules: Default enabled modules for new projects
                setting_issue_done_ratio: Calculate the issue done ratio with
                setting_issue_done_ratio_issue_field: Use the issue field
                setting_issue_done_ratio_issue_status: Use the issue status
                setting_start_of_week: Start calendars on
                setting_rest_api_enabled: Enable REST web service
                setting_cache_formatted_text: Cache formatted text
                setting_default_notification_option: Default notification option
                setting_commit_logtime_enabled: Enable time logging
                setting_commit_logtime_activity_id: Activity for logged time
                setting_gantt_items_limit: Maximum number of items displayed on the gantt chart
                setting_issue_group_assignment: Allow issue assignment to groups
                setting_default_issue_start_date_to_creation_date: Use current date as start date for new issues
                setting_commit_cross_project_ref: Allow issues of all the other projects to be referenced and fixed
                setting_unsubscribe: Allow users to delete their own account
                setting_session_lifetime: Session maximum lifetime
                setting_session_timeout: Session inactivity timeout
                setting_thumbnails_enabled: Display attachment thumbnails
                setting_thumbnails_size: Thumbnails size (in pixels)
                setting_non_working_week_days: Non-working days
                permission_add_project: Create project
                permission_add_subprojects: Create subprojects
                permission_edit_project: Edit project
                permission_close_project: Close / reopen the project
                permission_select_project_modules: Select project modules
                permission_manage_members: Manage members
                permission_manage_project_activities: Manage project activities
                permission_manage_versions: Manage versions
                permission_manage_categories: Manage issue categories
                permission_view_issues: View Issues
                permission_add_issues: Add issues
                permission_edit_issues: Edit issues
                permission_manage_issue_relations: Manage issue relations
                permission_set_issues_private: Set issues public or private
                permission_set_own_issues_private: Set own issues public or private
                permission_add_issue_notes: Add notes
                permission_edit_issue_notes: Edit notes
                permission_edit_own_issue_notes: Edit own notes
                permission_view_private_notes: View private notes
                permission_set_notes_private: Set notes as private
                permission_move_issues: Move issues
                permission_delete_issues: Delete issues
                permission_manage_public_queries: Manage public queries
                permission_save_queries: Save queries
                permission_view_gantt: View gantt chart
                permission_view_calendar: View calendar
                permission_view_issue_watchers: View watchers list
                permission_add_issue_watchers: Add watchers
                permission_delete_issue_watchers: Delete watchers
                permission_log_time: Log spent time
                permission_view_time_entries: View spent time
                permission_edit_time_entries: Edit time logs
                permission_edit_own_time_entries: Edit own time logs
                permission_manage_news: Manage news
                permission_comment_news: Comment news
                permission_manage_documents: Manage documents
                permission_view_documents: View documents
                permission_manage_files: Manage files
                permission_view_files: View files
                permission_manage_wiki: Manage wiki
                permission_rename_wiki_pages: Rename wiki pages
                permission_delete_wiki_pages: Delete wiki pages
                permission_view_wiki_pages: View wiki
                permission_view_wiki_edits: View wiki history
                permission_edit_wiki_pages: Edit wiki pages
                permission_delete_wiki_pages_attachments: Delete attachments
                permission_protect_wiki_pages: Protect wiki pages
                permission_manage_repository: Manage repository
                permission_browse_repository: Browse repository
                permission_view_changesets: View changesets
                permission_commit_access: Commit access
                permission_manage_boards: Manage forums
                permission_view_messages: View messages
                permission_add_messages: Post messages
                permission_edit_messages: Edit messages
                permission_edit_own_messages: Edit own messages
                permission_delete_messages: Delete messages
                permission_delete_own_messages: Delete own messages
                permission_export_wiki_pages: Export wiki pages
                permission_manage_subtasks: Manage subtasks
                permission_manage_related_issues: Manage related issues
                project_module_issue_tracking: Issue tracking
                project_module_time_tracking: Time tracking
                project_module_news: News
                project_module_documents: Documents
                project_module_files: Files
                project_module_wiki: Wiki
                project_module_repository: Repository
                project_module_boards: Forums
                project_module_calendar: Calendar
                project_module_gantt: Gantt
                label_user: User
                label_user_plural: Users
                label_user_new: New user
                label_user_anonymous: Anonymous
                label_project: Project
                label_project_new: New project
                label_project_plural: Projects
                label_x_projects:
                  zero:  no projects
                  one:   1 project
                  other: "%{count} projects"
                label_project_all: All 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_issues_by: "Issues by %{value}"
                label_issue_added: Issue added
                label_issue_updated: Issue updated
                label_issue_note_added: Note added
                label_issue_status_updated: Status updated
                label_issue_priority_updated: Priority updated
                label_document: Document
                label_document_new: New document
                label_document_plural: Documents
                label_document_added: Document added
                label_role: Role
                label_role_plural: Roles
                label_role_new: New role
                label_role_and_permissions: Roles and permissions
                label_role_anonymous: Anonymous
                label_role_non_member: Non member
                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 log in
                label_register: Register
                label_login_with_open_id_option: or login with OpenID
                label_password_lost: Lost password
                label_home: Home
                label_my_page: My page
                label_my_account: My account
                label_my_projects: My projects
                label_my_page_block: My page block
                label_administration: Administration
                label_login: Sign in
                label_logout: Sign out
                label_help: Help
                label_reported_issues: Reported issues
                label_assigned_to_me_issues: Issues assigned to me
                label_last_login: Last connection
                label_registered_on: Registered on
                label_activity: Activity
                label_overall_activity: Overall activity
                label_user_activity: "%{value}'s activity"
                label_new: New
                label_logged_as: Logged in 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_plural: Subprojects
                label_subproject_new: New subproject
                label_and_its_subprojects: "%{value} and its subprojects"
                label_min_max_length: Min - Max length
                label_list: List
                label_date: Date
                label_integer: Integer
                label_float: Float
                label_boolean: Boolean
                label_string: Text
                label_text: Long text
                label_attribute: Attribute
                label_attribute_plural: Attributes
                label_download: "%{count} Download"
                label_download_plural: "%{count} 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_file_added: File added
                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_news_added: News added
                label_news_comment_added: Comment added to a news
                label_settings: Settings
                label_overview: Overview
                label_version: Version
                label_version_new: New version
                label_version_plural: Versions
                label_close_versions: Close completed versions
                label_confirmation: Confirmation
                label_export_to: 'Also available in:'
                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_x_open_issues_abbr_on_total:
                  zero:  0 open / %{total}
                  one:   1 open / %{total}
                  other: "%{count} open / %{total}"
                label_x_open_issues_abbr:
                  zero:  0 open
                  one:   1 open
                  other: "%{count} open"
                label_x_closed_issues_abbr:
                  zero:  0 closed
                  one:   1 closed
                  other: "%{count} closed"
                label_x_issues:
                  zero:  0 issues
                  one:   1 issue
                  other: "%{count} issues"
                label_total: Total
                label_permissions: Permissions
                label_current_status: Current status
                label_new_statuses_allowed: New statuses allowed
                label_all: all
                label_any: any
                label_none: none
                label_nobody: nobody
                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 %{count} changes"
                label_change_view_all: View all changes
                label_personalize_page: Personalize this page
                label_comment: Comment
                label_comment_plural: Comments
                label_x_comments:
                  zero: no comments
                  one: 1 comment
                  other: "%{count} 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_my_queries: My custom queries
                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_the_next_days: in the next
+               label_in_the_past_days: in the past
                label_greater_or_equal: '>='
                label_less_or_equal: '<='
                label_between: between
                label_in: in
                label_today: today
                label_all_time: all time
                label_yesterday: yesterday
                label_this_week: this week
                label_last_week: last week
                label_last_n_weeks: "last %{count} weeks"
                label_last_n_days: "last %{count} days"
                label_this_month: this month
                label_last_month: last month
                label_this_year: this year
                label_date_range: Date range
                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_any_issues_in_project: any issues in project
                label_any_issues_not_in_project: any issues not in project
                label_no_issues_in_project: no issues in project
                label_day_plural: days
                label_repository: Repository
                label_repository_new: New repository
                label_repository_plural: Repositories
                label_browse: Browse
                label_modification: "%{count} change"
                label_modification_plural: "%{count} changes"
                label_branch: Branch
                label_tag: Tag
                label_revision: Revision
                label_revision_plural: Revisions
                label_revision_id: "Revision %{value}"
                label_associated_revisions: Associated revisions
                label_added: added
                label_modified: modified
                label_copied: copied
                label_renamed: renamed
                label_deleted: deleted
                label_latest_revision: Latest revision
                label_latest_revision_plural: Latest revisions
                label_view_revisions: View revisions
                label_view_all_revisions: View all revisions
                label_max_size: Maximum size
                label_sort_highest: Move to top
                label_sort_higher: Move up
                label_sort_lower: Move down
                label_sort_lowest: Move to bottom
                label_roadmap: Roadmap
                label_roadmap_due_in: "Due in %{value}"
                label_roadmap_overdue: "%{value} late"
                label_roadmap_no_issues: No issues for this version
                label_search: Search
                label_result_plural: Results
                label_all_words: All words
                label_wiki: Wiki
                label_wiki_edit: Wiki edit
                label_wiki_edit_plural: Wiki edits
                label_wiki_page: Wiki page
                label_wiki_page_plural: Wiki pages
                label_index_by_title: Index by title
                label_index_by_date: Index by date
                label_current_version: Current version
                label_preview: Preview
                label_feed_plural: Feeds
                label_changes_details: Details of all changes
                label_issue_tracking: Issue tracking
                label_spent_time: Spent time
                label_overall_spent_time: Overall spent time
                label_f_hour: "%{value} hour"
                label_f_hour_plural: "%{value} hours"
                label_time_tracking: Time tracking
                label_change_plural: Changes
                label_statistics: Statistics
                label_commits_per_month: Commits per month
                label_commits_per_author: Commits per author
                label_diff: diff
                label_view_diff: View differences
                label_diff_inline: inline
                label_diff_side_by_side: side by side
                label_options: Options
                label_copy_workflow_from: Copy workflow from
                label_permissions_report: Permissions report
                label_watched_issues: Watched issues
                label_related_issues: Related issues
                label_applied_status: Applied status
                label_loading: Loading...
                label_relation_new: New relation
                label_relation_delete: Delete relation
                label_relates_to: Related to
                label_duplicates: Duplicates
                label_duplicated_by: Duplicated by
                label_blocks: Blocks
                label_blocked_by: Blocked by
                label_precedes: Precedes
                label_follows: Follows
                label_copied_to: Copied to
                label_copied_from: Copied from
                label_end_to_start: end to start
                label_end_to_end: end to end
                label_start_to_start: start to start
                label_start_to_end: start to end
                label_stay_logged_in: Stay logged in
                label_disabled: disabled
                label_show_completed_versions: Show completed versions
                label_me: me
                label_board: Forum
                label_board_new: New forum
                label_board_plural: Forums
                label_board_locked: Locked
                label_board_sticky: Sticky
                label_topic_plural: Topics
                label_message_plural: Messages
                label_message_last: Last message
                label_message_new: New message
                label_message_posted: Message added
                label_reply_plural: Replies
                label_send_information: Send account information to the user
                label_year: Year
                label_month: Month
                label_week: Week
                label_date_from: From
                label_date_to: To
                label_language_based: Based on user's language
                label_sort_by: "Sort by %{value}"
                label_send_test_email: Send a test email
                label_feeds_access_key: RSS access key
                label_missing_feeds_access_key: Missing a RSS access key
                label_feeds_access_key_created_on: "RSS access key created %{value} ago"
                label_module_plural: Modules
                label_added_time_by: "Added by %{author} %{age} ago"
                label_updated_time_by: "Updated by %{author} %{age} ago"
                label_updated_time: "Updated %{value} ago"
                label_jump_to_a_project: Jump to a project...
                label_file_plural: Files
                label_changeset_plural: Changesets
                label_default_columns: Default columns
                label_no_change_option: (No change)
                label_bulk_edit_selected_issues: Bulk edit selected issues
                label_bulk_edit_selected_time_entries: Bulk edit selected time entries
                label_theme: Theme
                label_default: Default
                label_search_titles_only: Search titles only
                label_user_mail_option_all: "For any event on all my projects"
                label_user_mail_option_selected: "For any event on the selected projects only..."
                label_user_mail_option_none: "No events"
                label_user_mail_option_only_my_events: "Only for things I watch or I'm involved in"
                label_user_mail_option_only_assigned: "Only for things I am assigned to"
                label_user_mail_option_only_owner: "Only for things I am the owner of"
                label_user_mail_no_self_notified: "I don't want to be notified of changes that I make myself"
                label_registration_activation_by_email: account activation by email
                label_registration_manual_activation: manual account activation
                label_registration_automatic_activation: automatic account activation
                label_display_per_page: "Per page: %{value}"
                label_age: Age
                label_change_properties: Change properties
                label_general: General
                label_more: More
                label_scm: SCM
                label_plugins: Plugins
                label_ldap_authentication: LDAP authentication
                label_downloads_abbr: D/L
                label_optional_description: Optional description
                label_add_another_file: Add another file
                label_preferences: Preferences
                label_chronological_order: In chronological order
                label_reverse_chronological_order: In reverse chronological order
                label_planning: Planning
                label_incoming_emails: Incoming emails
                label_generate_key: Generate a key
                label_issue_watchers: Watchers
                label_example: Example
                label_display: Display
                label_sort: Sort
                label_ascending: Ascending
                label_descending: Descending
                label_date_from_to: From %{start} to %{end}
                label_wiki_content_added: Wiki page added
                label_wiki_content_updated: Wiki page updated
                label_group: Group
                label_group_plural: Groups
                label_group_new: New group
                label_time_entry_plural: Spent time
                label_version_sharing_none: Not shared
                label_version_sharing_descendants: With subprojects
                label_version_sharing_hierarchy: With project hierarchy
                label_version_sharing_tree: With project tree
                label_version_sharing_system: With all projects
                label_update_issue_done_ratios: Update issue done ratios
                label_copy_source: Source
                label_copy_target: Target
                label_copy_same_as_target: Same as target
                label_display_used_statuses_only: Only display statuses that are used by this tracker
                label_api_access_key: API access key
                label_missing_api_access_key: Missing an API access key
                label_api_access_key_created_on: "API access key created %{value} ago"
                label_profile: Profile
                label_subtask_plural: Subtasks
                label_project_copy_notifications: Send email notifications during the project copy
                label_principal_search: "Search for user or group:"
                label_user_search: "Search for user:"
                label_additional_workflow_transitions_for_author: Additional transitions allowed when the user is the author
                label_additional_workflow_transitions_for_assignee: Additional transitions allowed when the user is the assignee
                label_issues_visibility_all: All issues
                label_issues_visibility_public: All non private issues
                label_issues_visibility_own: Issues created by or assigned to the user
                label_git_report_last_commit: Report last commit for files and directories
                label_parent_revision: Parent
                label_child_revision: Child
                label_export_options: "%{export_format} export options"
                label_copy_attachments: Copy attachments
                label_copy_subtasks: Copy subtasks
                label_item_position: "%{position} of %{count}"
                label_completed_versions: Completed versions
                label_search_for_watchers: Search for watchers to add
                label_session_expiration: Session expiration
                label_show_closed_projects: View closed projects
                label_status_transitions: Status transitions
                label_fields_permissions: Fields permissions
                label_readonly: Read-only
                label_required: Required
                label_attribute_of_project: "Project's %{name}"
                label_attribute_of_author: "Author's %{name}"
                label_attribute_of_assigned_to: "Assignee's %{name}"
                label_attribute_of_fixed_version: "Target version's %{name}"
                label_cross_project_descendants: With subprojects
                label_cross_project_tree: With project tree
                label_cross_project_hierarchy: With project hierarchy
                label_cross_project_system: With all projects
                button_login: Login
                button_submit: Submit
                button_save: Save
                button_check_all: Check all
                button_uncheck_all: Uncheck all
                button_collapse_all: Collapse all
                button_expand_all: Expand all
                button_delete: Delete
                button_create: Create
                button_create_and_continue: Create and continue
                button_test: Test
                button_edit: Edit
                button_edit_associated_wikipage: "Edit associated Wiki page: %{page_title}"
                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_move_and_follow: Move and follow
                button_back: Back
                button_cancel: Cancel
                button_activate: Activate
                button_sort: Sort
                button_log_time: Log time
                button_rollback: Rollback to this version
                button_watch: Watch
                button_unwatch: Unwatch
                button_reply: Reply
                button_archive: Archive
                button_unarchive: Unarchive
                button_reset: Reset
                button_rename: Rename
                button_change_password: Change password
                button_copy: Copy
                button_copy_and_follow: Copy and follow
                button_annotate: Annotate
                button_update: Update
                button_configure: Configure
                button_quote: Quote
                button_duplicate: Duplicate
                button_show: Show
                button_hide: Hide
                button_edit_section: Edit this section
                button_export: Export
                button_delete_my_account: Delete my account
                button_close: Close
                button_reopen: Reopen
                status_active: active
                status_registered: registered
                status_locked: locked
                project_status_active: active
                project_status_closed: closed
                project_status_archived: archived
                version_status_open: open
                version_status_locked: locked
                version_status_closed: closed
                field_active: Active
                text_select_mail_notifications: Select actions for which email notifications should be sent.
                text_regexp_info: eg. ^[A-Z0-9]+$
                text_min_max_length_info: 0 means no restriction
                text_project_destroy_confirmation: Are you sure you want to delete this project and related data?
                text_subprojects_destroy_warning: "Its subproject(s): %{value} will be also deleted."
                text_workflow_edit: Select a role and a tracker to edit the workflow
                text_are_you_sure: Are you sure?
                text_are_you_sure_with_children: "Delete issue and all child issues?"
                text_journal_changed: "%{label} changed from %{old} to %{new}"
                text_journal_changed_no_detail: "%{label} updated"
                text_journal_set_to: "%{label} set to %{value}"
                text_journal_deleted: "%{label} deleted (%{old})"
                text_journal_added: "%{label} %{value} added"
                text_tip_issue_begin_day: issue beginning this day
                text_tip_issue_end_day: issue ending this day
                text_tip_issue_begin_end_day: issue beginning and ending this day
                text_project_identifier_info: 'Only lower case letters (a-z), numbers, dashes and underscores are allowed.<br />Once saved, the identifier cannot be changed.'
                text_caracters_maximum: "%{count} characters maximum."
                text_caracters_minimum: "Must be at least %{count} characters long."
                text_length_between: "Length between %{min} and %{max} characters."
                text_tracker_no_workflow: No workflow defined for this tracker
                text_unallowed_characters: Unallowed characters
                text_comma_separated: Multiple values allowed (comma separated).
                text_line_separated: Multiple values allowed (one line for each value).
                text_issues_ref_in_commit_messages: Referencing and fixing issues in commit messages
                text_issue_added: "Issue %{id} has been reported by %{author}."
                text_issue_updated: "Issue %{id} has been updated by %{author}."
                text_wiki_destroy_confirmation: Are you sure you want to delete this wiki and all its content?
                text_issue_category_destroy_question: "Some issues (%{count}) are assigned to this category. What do you want to do?"
                text_issue_category_destroy_assignments: Remove category assignments
                text_issue_category_reassign_to: Reassign issues to this category
                text_user_mail_option: "For unselected projects, you will only receive notifications about things you watch or you're involved in (eg. issues you're the author or assignee)."
                text_no_configuration_data: "Roles, trackers, issue statuses and workflow have not been configured yet.\nIt is highly recommended to load the default configuration. You will be able to modify it once loaded."
                text_load_default_configuration: Load the default configuration
                text_status_changed_by_changeset: "Applied in changeset %{value}."
                text_time_logged_by_changeset: "Applied in changeset %{value}."
                text_issues_destroy_confirmation: 'Are you sure you want to delete the selected issue(s)?'
                text_issues_destroy_descendants_confirmation: "This will also delete %{count} subtask(s)."
                text_time_entries_destroy_confirmation: 'Are you sure you want to delete the selected time entr(y/ies)?'
                text_select_project_modules: 'Select modules to enable for this project:'
                text_default_administrator_account_changed: Default administrator account changed
                text_file_repository_writable: Attachments directory writable
                text_plugin_assets_writable: Plugin assets directory writable
                text_rmagick_available: RMagick available (optional)
                text_destroy_time_entries_question: "%{hours} hours were reported on the issues you are about to delete. What do you want to do?"
                text_destroy_time_entries: Delete reported hours
                text_assign_time_entries_to_project: Assign reported hours to the project
                text_reassign_time_entries: 'Reassign reported hours to this issue:'
                text_user_wrote: "%{value} wrote:"
                text_enumeration_destroy_question: "%{count} objects are assigned to this value."
                text_enumeration_category_reassign_to: 'Reassign them to this value:'
                text_email_delivery_not_configured: "Email delivery is not configured, and notifications are disabled.\nConfigure your SMTP server in config/configuration.yml and restart the application to enable them."
                text_repository_usernames_mapping: "Select or update the Redmine user mapped to each username found in the repository log.\nUsers with the same Redmine and repository username or email are automatically mapped."
                text_diff_truncated: '... This diff was truncated because it exceeds the maximum size that can be displayed.'
                text_custom_field_possible_values_info: 'One line for each value'
                text_wiki_page_destroy_question: "This page has %{descendants} child page(s) and descendant(s). What do you want to do?"
                text_wiki_page_nullify_children: "Keep child pages as root pages"
                text_wiki_page_destroy_children: "Delete child pages and all their descendants"
                text_wiki_page_reassign_children: "Reassign child pages to this parent page"
                text_own_membership_delete_confirmation: "You are about to remove some or all of your permissions and may no longer be able to edit this project after that.\nAre you sure you want to continue?"
                text_zoom_in: Zoom in
                text_zoom_out: Zoom out
                text_warn_on_leaving_unsaved: "The current page contains unsaved text that will be lost if you leave this page."
                text_scm_path_encoding_note: "Default: UTF-8"
                text_git_repository_note: Repository is bare and local (e.g. /gitrepo, c:\gitrepo)
                text_mercurial_repository_note: Local repository (e.g. /hgrepo, c:\hgrepo)
                text_scm_command: Command
                text_scm_command_version: Version
                text_scm_config: You can configure your scm commands in config/configuration.yml. Please restart the application after editing it.
                text_scm_command_not_available: Scm command is not available. Please check settings on the administration panel.
                text_issue_conflict_resolution_overwrite: "Apply my changes anyway (previous notes will be kept but some changes may be overwritten)"
                text_issue_conflict_resolution_add_notes: "Add my notes and discard my other changes"
                text_issue_conflict_resolution_cancel: "Discard all my changes and redisplay %{link}"
                text_account_destroy_confirmation: "Are you sure you want to proceed?\nYour account will be permanently deleted, with no way to reactivate it."
                text_session_expiration_settings: "Warning: changing these settings may expire the current sessions including yours."
                text_project_closed: This project is closed and read-only.
                default_role_manager: Manager
                default_role_developer: 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_in_progress: In Progress
                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
                default_activity_design: Design
                default_activity_development: Development
                enumeration_issue_priorities: Issue priorities
                enumeration_doc_categories: Document categories
                enumeration_activities: Activities (time tracking)
                enumeration_system_activity: System Activity
                description_filter: Filter
                description_search: Searchfield
                description_choose_project: Projects
                description_project_scope: Search scope
                description_notes: Notes
                description_message_content: Message content
                description_query_sort_criteria_attribute: Sort attribute
                description_query_sort_criteria_direction: Sort direction
                description_user_mail_notification: Mail notification settings
                description_available_columns: Available Columns
                description_selected_columns: Selected Columns
                description_all_columns: All Columns
                description_issue_category_reassign: Choose issue category
                description_wiki_subpages_reassign: Choose new parent page
                description_date_range_list: Choose range from list
                description_date_range_interval: Choose range by selecting start and end date
                description_date_from: Enter start date
                description_date_to: Enter end date
                text_repository_identifier_info: 'Only lower case letters (a-z), numbers, dashes and underscores are allowed.<br />Once saved, the identifier cannot be changed.'

config/locales/fr.yml +2 0

              # French translations for Ruby on Rails
              # by Christian Lescuyer (christian@flyingcoders.com)
              # contributor: Sebastien Grosjean - ZenCocoon.com
              # contributor: Thibaut Cuvelier - Developpez.com
              fr:
                direction: ltr
                date:
                  formats:
                    default: "%d/%m/%Y"
                    short: "%e %b"
                    long: "%e %B %Y"
                    long_ordinal: "%e %B %Y"
                    only_day: "%e"
                  day_names: [dimanche, lundi, mardi, mercredi, jeudi, vendredi, samedi]
                  abbr_day_names: [dim, lun, mar, mer, jeu, ven, sam]
                  month_names: [~, janvier, février, mars, avril, mai, juin, juillet, août, septembre, octobre, novembre, décembre]
                  abbr_month_names: [~, jan., fév., mar., avr., mai, juin, juil., août, sept., oct., nov., déc.]
                  order:
                    - :day
                    - :month
                    - :year
                time:
                  formats:
                    default: "%d/%m/%Y %H:%M"
                    time: "%H:%M"
                    short: "%d %b %H:%M"
                    long: "%A %d %B %Y %H:%M:%S %Z"
                    long_ordinal: "%A %d %B %Y %H:%M:%S %Z"
                    only_second: "%S"
                  am: 'am'
                  pm: 'pm'
                datetime:
                  distance_in_words:
                    half_a_minute: "30 secondes"
                    less_than_x_seconds:
                      zero:  "moins d'une seconde"
                      one:   "moins d'une seconde"
                      other: "moins de %{count} secondes"
                    x_seconds:
                      one:   "1 seconde"
                      other: "%{count} secondes"
                    less_than_x_minutes:
                      zero:  "moins d'une minute"
                      one:   "moins d'une minute"
                      other: "moins de %{count} minutes"
                    x_minutes:
                      one:   "1 minute"
                      other: "%{count} minutes"
                    about_x_hours:
                      one:   "environ une heure"
                      other: "environ %{count} heures"
                    x_hours:
                      one:   "une heure"
                      other: "%{count} heures"
                    x_days:
                      one:   "un jour"
                      other: "%{count} jours"
                    about_x_months:
                      one:   "environ un mois"
                      other: "environ %{count} mois"
                    x_months:
                      one:   "un mois"
                      other: "%{count} mois"
                    about_x_years:
                      one:   "environ un an"
                      other: "environ %{count} ans"
                    over_x_years:
                      one:   "plus d'un an"
                      other: "plus de %{count} ans"
                    almost_x_years:
                      one:   "presqu'un an"
                      other: "presque %{count} ans"
                  prompts:
                    year:   "Année"
                    month:  "Mois"
                    day:    "Jour"
                    hour:   "Heure"
                    minute: "Minute"
                    second: "Seconde"
                number:
                  format:
                    precision: 3
                    separator: ','
                    delimiter: ' '
                  currency:
                    format:
                      unit: '€'
                      precision: 2
                      format: '%n %u'
                  human:
                    format:
                      precision: 3
                    storage_units:
                      format: "%n %u"
                      units:
                        byte:
                          one: "octet"
                          other: "octet"
                        kb: "ko"
                        mb: "Mo"
                        gb: "Go"
                        tb: "To"
                support:
                  array:
                    sentence_connector: 'et'
                    skip_last_comma: true
                    word_connector: ", "
                    two_words_connector: " et "
                    last_word_connector: " et "
                activerecord:
                  errors:
                    template:
                      header:
                        one: "Impossible d'enregistrer %{model} : une erreur"
                        other: "Impossible d'enregistrer %{model} : %{count} erreurs."
                      body: "Veuillez vérifier les champs suivants :"
                    messages:
                      inclusion: "n'est pas inclus(e) dans la liste"
                      exclusion: "n'est pas disponible"
                      invalid: "n'est pas valide"
                      confirmation: "ne concorde pas avec la confirmation"
                      accepted: "doit être accepté(e)"
                      empty: "doit être renseigné(e)"
                      blank: "doit être renseigné(e)"
                      too_long: "est trop long (pas plus de %{count} caractères)"
                      too_short: "est trop court (au moins %{count} caractères)"
                      wrong_length: "ne fait pas la bonne longueur (doit comporter %{count} caractères)"
                      taken: "est déjà utilisé"
                      not_a_number: "n'est pas un nombre"
                      not_a_date: "n'est pas une date valide"
                      greater_than: "doit être supérieur à %{count}"
                      greater_than_or_equal_to: "doit être supérieur ou égal à %{count}"
                      equal_to: "doit être égal à %{count}"
                      less_than: "doit être inférieur à %{count}"
                      less_than_or_equal_to: "doit être inférieur ou égal à %{count}"
                      odd: "doit être impair"
                      even: "doit être pair"
                      greater_than_start_date: "doit être postérieure à la date de début"
                      not_same_project: "n'appartient pas au même projet"
                      circular_dependency: "Cette relation créerait une dépendance circulaire"
                      cant_link_an_issue_with_a_descendant: "Une demande ne peut pas être liée à l'une de ses sous-tâches"
                actionview_instancetag_blank_option: Choisir
                general_text_No: 'Non'
                general_text_Yes: 'Oui'
                general_text_no: 'non'
                general_text_yes: 'oui'
                general_lang_name: 'Français'
                general_csv_separator: ';'
                general_csv_decimal_separator: ','
                general_csv_encoding: ISO-8859-1
                general_pdf_encoding: UTF-8
                general_first_day_of_week: '1'
                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: Connexion réussie.
                notice_file_not_found: "La page à laquelle vous souhaitez accéder n'existe pas ou a été supprimée."
                notice_locking_conflict: Les données ont été mises à jour par un autre utilisateur. Mise à jour impossible.
                notice_not_authorized: "Vous n'êtes pas autorisé à accéder à cette page."
                notice_not_authorized_archived_project: Le projet auquel vous tentez d'accéder a été archivé.
                notice_email_sent: "Un email a été envoyé à %{value}"
                notice_email_error: "Erreur lors de l'envoi de l'email (%{value})"
                notice_feeds_access_key_reseted: "Votre clé d'accès aux flux RSS a été réinitialisée."
                notice_failed_to_save_issues: "%{count} demande(s) sur les %{total} sélectionnées n'ont pas pu être mise(s) à jour : %{ids}."
                notice_failed_to_save_time_entries: "%{count} temps passé(s) sur les %{total} sélectionnés n'ont pas pu être mis à jour: %{ids}."
                notice_no_issue_selected: "Aucune demande sélectionnée ! Cochez les demandes que vous voulez mettre à jour."
                notice_account_pending: "Votre compte a été créé et attend l'approbation de l'administrateur."
                notice_default_data_loaded: Paramétrage par défaut chargé avec succès.
                notice_unable_delete_version: Impossible de supprimer cette version.
                notice_issue_done_ratios_updated: L'avancement des demandes a été mis à jour.
                notice_api_access_key_reseted: Votre clé d'accès API a été réinitialisée.
                notice_gantt_chart_truncated: "Le diagramme a été tronqué car il excède le nombre maximal d'éléments pouvant être affichés (%{max})"
                notice_issue_successful_create: "Demande %{id} créée."
                notice_issue_update_conflict: "La demande a été mise à jour par un autre utilisateur pendant que vous la modifiez."
                notice_account_deleted: "Votre compte a été définitivement supprimé."
                notice_user_successful_create: "Utilisateur %{id} créé."
                error_can_t_load_default_data: "Une erreur s'est produite lors du chargement du paramétrage : %{value}"
                error_scm_not_found: "L'entrée et/ou la révision demandée n'existe pas dans le dépôt."
                error_scm_command_failed: "Une erreur s'est produite lors de l'accès au dépôt : %{value}"
                error_scm_annotate: "L'entrée n'existe pas ou ne peut pas être annotée."
                error_issue_not_found_in_project: "La demande n'existe pas ou n'appartient pas à ce projet"
                error_can_not_reopen_issue_on_closed_version: 'Une demande assignée à une version fermée ne peut pas être réouverte'
                error_can_not_archive_project: "Ce projet ne peut pas être archivé"
                error_workflow_copy_source: 'Veuillez sélectionner un tracker et/ou un rôle source'
                error_workflow_copy_target: 'Veuillez sélectionner les trackers et rôles cibles'
                error_issue_done_ratios_not_updated: L'avancement des demandes n'a pas pu être mis à jour.
                error_attachment_too_big: Ce fichier ne peut pas être attaché car il excède la taille maximale autorisée (%{max_size})
                error_session_expired: "Votre session a expiré. Veuillez vous reconnecter."
                warning_attachments_not_saved: "%{count} fichier(s) n'ont pas pu être sauvegardés."
                mail_subject_lost_password: "Votre mot de passe %{value}"
                mail_body_lost_password: 'Pour changer votre mot de passe, cliquez sur le lien suivant :'
                mail_subject_register: "Activation de votre compte %{value}"
                mail_body_register: 'Pour activer votre compte, cliquez sur le lien suivant :'
                mail_body_account_information_external: "Vous pouvez utiliser votre compte %{value} pour vous connecter."
                mail_body_account_information: Paramètres de connexion de votre compte
                mail_subject_account_activation_request: "Demande d'activation d'un compte %{value}"
                mail_body_account_activation_request: "Un nouvel utilisateur (%{value}) s'est inscrit. Son compte nécessite votre approbation :"
                mail_subject_reminder: "%{count} demande(s) arrivent à échéance (%{days})"
                mail_body_reminder: "%{count} demande(s) qui vous sont assignées arrivent à échéance dans les %{days} prochains jours :"
                mail_subject_wiki_content_added: "Page wiki '%{id}' ajoutée"
                mail_body_wiki_content_added: "La page wiki '%{id}' a été ajoutée par %{author}."
                mail_subject_wiki_content_updated: "Page wiki '%{id}' mise à jour"
                mail_body_wiki_content_updated: "La page wiki '%{id}' a été mise à jour par %{author}."
                gui_validation_error: 1 erreur
                gui_validation_error_plural: "%{count} 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: Valeur par défaut
                field_tracker: Tracker
                field_subject: Sujet
                field_due_date: Echéance
                field_assigned_to: Assigné à
                field_priority: Priorité
                field_fixed_version: Version cible
                field_user: Utilisateur
                field_role: Rôle
                field_homepage: "Site web "
                field_is_public: Public
                field_parent: Sous-projet de
                field_is_in_roadmap: Demandes affichées dans la roadmap
                field_login: "Identifiant "
                field_mail_notification: Notifications par mail
                field_admin: Administrateur
                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_comments: Commentaire
                field_url: URL
                field_start_page: Page de démarrage
                field_subproject: Sous-projet
                field_hours: Heures
                field_activity: Activité
                field_spent_on: Date
                field_identifier: Identifiant
                field_is_filter: Utilisé comme filtre
                field_issue_to: Demande liée
                field_delay: Retard
                field_assignable: Demandes assignables à ce rôle
                field_redirect_existing_links: Rediriger les liens existants
                field_estimated_hours: Temps estimé
                field_column_names: Colonnes
                field_time_zone: Fuseau horaire
                field_searchable: Utilisé pour les recherches
                field_default_value: Valeur par défaut
                field_comments_sorting: Afficher les commentaires
                field_parent_title: Page parent
                field_editable: Modifiable
                field_watcher: Observateur
                field_identity_url: URL OpenID
                field_content: Contenu
                field_group_by: Grouper par
                field_sharing: Partage
                field_active: Actif
                field_parent_issue: Tâche parente
                field_visible: Visible
                field_warn_on_leaving_unsaved: "M'avertir lorsque je quitte une page contenant du texte non sauvegardé"
                field_issues_visibility: Visibilité des demandes
                field_is_private: Privée
                field_commit_logs_encoding: Encodage des messages de commit
                field_repository_is_default: Dépôt principal
                field_multiple: Valeurs multiples
                field_auth_source_ldap_filter: Filtre LDAP
                field_core_fields: Champs standards
                field_timeout: "Timeout (en secondes)"
                field_board_parent: Forum parent
                field_private_notes: Notes privées
                setting_app_title: Titre de l'application
                setting_app_subtitle: Sous-titre de l'application
                setting_welcome_text: Texte d'accueil
                setting_default_language: Langue par défaut
                setting_login_required: Authentification obligatoire
                setting_self_registration: Inscription des nouveaux utilisateurs
                setting_attachment_max_size: Taille maximale des fichiers
                setting_issues_export_limit: Limite d'exportation des demandes
                setting_mail_from: Adresse d'émission
                setting_bcc_recipients: Destinataires en copie cachée (cci)
                setting_plain_text_mail: Mail en texte brut (non HTML)
                setting_host_name: Nom d'hôte et chemin
                setting_text_formatting: Formatage du texte
                setting_wiki_compression: Compression de l'historique des pages wiki
                setting_feeds_limit: Nombre maximal d'éléments dans les flux Atom
                setting_default_projects_public: Définir les nouveaux projets comme publics par défaut
                setting_autofetch_changesets: Récupération automatique des commits
                setting_sys_api_enabled: Activer les WS pour la gestion des dépôts
                setting_commit_ref_keywords: Mots-clés de référencement
                setting_commit_fix_keywords: Mots-clés de résolution
                setting_autologin: Durée maximale de connexion automatique
                setting_date_format: Format de date
                setting_time_format: Format d'heure
                setting_cross_project_issue_relations: Autoriser les relations entre demandes de différents projets
                setting_cross_project_subtasks: Autoriser les sous-tâches dans des projets différents
                setting_issue_list_default_columns: Colonnes affichées par défaut sur la liste des demandes
                setting_emails_footer: Pied-de-page des emails
                setting_protocol: Protocole
                setting_per_page_options: Options d'objets affichés par page
                setting_user_format: Format d'affichage des utilisateurs
                setting_activity_days_default: Nombre de jours affichés sur l'activité des projets
                setting_display_subprojects_issues: Afficher par défaut les demandes des sous-projets sur les projets principaux
                setting_enabled_scm: SCM activés
                setting_mail_handler_body_delimiters: "Tronquer les emails après l'une de ces lignes"
                setting_mail_handler_api_enabled: "Activer le WS pour la réception d'emails"
                setting_mail_handler_api_key: Clé de protection de l'API
                setting_sequential_project_identifiers: Générer des identifiants de projet séquentiels
                setting_gravatar_enabled: Afficher les Gravatar des utilisateurs
                setting_diff_max_lines_displayed: Nombre maximum de lignes de diff affichées
                setting_file_max_size_displayed: Taille maximum des fichiers texte affichés en ligne
                setting_repository_log_display_limit: "Nombre maximum de révisions affichées sur l'historique d'un fichier"
                setting_openid: "Autoriser l'authentification et l'enregistrement OpenID"
                setting_password_min_length: Longueur minimum des mots de passe
                setting_new_project_user_role_id: Rôle donné à un utilisateur non-administrateur qui crée un projet
                setting_default_projects_modules: Modules activés par défaut pour les nouveaux projets
                setting_issue_done_ratio: Calcul de l'avancement des demandes
                setting_issue_done_ratio_issue_status: Utiliser le statut
                setting_issue_done_ratio_issue_field: 'Utiliser le champ % effectué'
                setting_rest_api_enabled: Activer l'API REST
                setting_gravatar_default: Image Gravatar par défaut
                setting_start_of_week: Jour de début des calendriers
                setting_cache_formatted_text: Mettre en cache le texte formaté
                setting_commit_logtime_enabled: Permettre la saisie de temps
                setting_commit_logtime_activity_id: Activité pour le temps saisi
                setting_gantt_items_limit: Nombre maximum d'éléments affichés sur le gantt
                setting_issue_group_assignment: Permettre l'assignement des demandes aux groupes
                setting_default_issue_start_date_to_creation_date: Donner à la date de début d'une nouvelle demande la valeur de la date du jour
                setting_commit_cross_project_ref: Permettre le référencement et la résolution des demandes de tous les autres projets
                setting_unsubscribe: Permettre aux utilisateurs de supprimer leur propre compte
                setting_session_lifetime: Durée de vie maximale des sessions
                setting_session_timeout: Durée maximale d'inactivité
                setting_thumbnails_enabled: Afficher les vignettes des images
                setting_thumbnails_size: Taille des vignettes (en pixels)
                setting_non_working_week_days: Jours non travaillés
                permission_add_project: Créer un projet
                permission_add_subprojects: Créer des sous-projets
                permission_edit_project: Modifier le projet
                permission_close_project: Fermer / réouvrir le projet
                permission_select_project_modules: Choisir les modules
                permission_manage_members: Gérer les membres
                permission_manage_versions: Gérer les versions
                permission_manage_categories: Gérer les catégories de demandes
                permission_view_issues: Voir les demandes
                permission_add_issues: Créer des demandes
                permission_edit_issues: Modifier les demandes
                permission_manage_issue_relations: Gérer les relations
                permission_set_issues_private: Rendre les demandes publiques ou privées
                permission_set_own_issues_private: Rendre ses propres demandes publiques ou privées
                permission_add_issue_notes: Ajouter des notes
                permission_edit_issue_notes: Modifier les notes
                permission_edit_own_issue_notes: Modifier ses propres notes
                permission_view_private_notes: Voir les notes privées
                permission_set_notes_private: Rendre les notes privées
                permission_move_issues: Déplacer les demandes
                permission_delete_issues: Supprimer les demandes
                permission_manage_public_queries: Gérer les requêtes publiques
                permission_save_queries: Sauvegarder les requêtes
                permission_view_gantt: Voir le gantt
                permission_view_calendar: Voir le calendrier
                permission_view_issue_watchers: Voir la liste des observateurs
                permission_add_issue_watchers: Ajouter des observateurs
                permission_delete_issue_watchers: Supprimer des observateurs
                permission_log_time: Saisir le temps passé
                permission_view_time_entries: Voir le temps passé
                permission_edit_time_entries: Modifier les temps passés
                permission_edit_own_time_entries: Modifier son propre temps passé
                permission_manage_news: Gérer les annonces
                permission_comment_news: Commenter les annonces
                permission_manage_documents: Gérer les documents
                permission_view_documents: Voir les documents
                permission_manage_files: Gérer les fichiers
                permission_view_files: Voir les fichiers
                permission_manage_wiki: Gérer le wiki
                permission_rename_wiki_pages: Renommer les pages
                permission_delete_wiki_pages: Supprimer les pages
                permission_view_wiki_pages: Voir le wiki
                permission_view_wiki_edits: "Voir l'historique des modifications"
                permission_edit_wiki_pages: Modifier les pages
                permission_delete_wiki_pages_attachments: Supprimer les fichiers joints
                permission_protect_wiki_pages: Protéger les pages
                permission_manage_repository: Gérer le dépôt de sources
                permission_browse_repository: Parcourir les sources
                permission_view_changesets: Voir les révisions
                permission_commit_access: Droit de commit
                permission_manage_boards: Gérer les forums
                permission_view_messages: Voir les messages
                permission_add_messages: Poster un message
                permission_edit_messages: Modifier les messages
                permission_edit_own_messages: Modifier ses propres messages
                permission_delete_messages: Supprimer les messages
                permission_delete_own_messages: Supprimer ses propres messages
                permission_export_wiki_pages: Exporter les pages
                permission_manage_project_activities: Gérer les activités
                permission_manage_subtasks: Gérer les sous-tâches
                permission_manage_related_issues: Gérer les demandes associées
                project_module_issue_tracking: Suivi des demandes
                project_module_time_tracking: Suivi du temps passé
                project_module_news: Publication d'annonces
                project_module_documents: Publication de documents
                project_module_files: Publication de fichiers
                project_module_wiki: Wiki
                project_module_repository: Dépôt de sources
                project_module_boards: Forums de discussion
                label_user: Utilisateur
                label_user_plural: Utilisateurs
                label_user_new: Nouvel utilisateur
                label_user_anonymous: Anonyme
                label_project: Projet
                label_project_new: Nouveau projet
                label_project_plural: Projets
                label_x_projects:
                  zero:  aucun projet
                  one:   un projet
                  other: "%{count} projets"
                label_project_all: Tous les 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_issue_added: Demande ajoutée
                label_issue_updated: Demande mise à jour
                label_issue_note_added: Note ajoutée
                label_issue_status_updated: Statut changé
                label_issue_priority_updated: Priorité changée
                label_issues_by: "Demandes par %{value}"
                label_document: Document
                label_document_new: Nouveau document
                label_document_plural: Documents
                label_document_added: Document ajouté
                label_role: Rôle
                label_role_plural: Rôles
                label_role_new: Nouveau rôle
                label_role_and_permissions: Rôles et permissions
                label_role_anonymous: Anonyme
                label_role_non_member: Non membre
                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_login_with_open_id_option: S'authentifier avec OpenID
                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_my_page_block: Blocs disponibles
                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_registered_on: "Inscrit le "
                label_activity: Activité
                label_overall_activity: Activité globale
                label_user_activity: "Activité de %{value}"
                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_plural: Sous-projets
                label_subproject_new: Nouveau sous-projet
                label_and_its_subprojects: "%{value} et ses sous-projets"
                label_min_max_length: Longueurs mini - maxi
                label_list: Liste
                label_date: Date
                label_integer: Entier
                label_float: Nombre décimal
                label_boolean: Booléen
                label_string: Texte
                label_text: Texte long
                label_attribute: Attribut
                label_attribute_plural: Attributs
                label_download: "%{count} téléchargement"
                label_download_plural: "%{count} 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_file_added: Fichier ajouté
                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_news_added: Annonce ajoutée
                label_news_comment_added: Commentaire ajouté à une annonce
                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: 'Formats disponibles :'
                label_read: Lire...
                label_public_projects: Projets publics
                label_open_issues: ouvert
                label_open_issues_plural: ouverts
                label_closed_issues: fermé
                label_closed_issues_plural: fermés
                label_x_open_issues_abbr_on_total:
                  zero:  0 ouverte sur %{total}
                  one:   1 ouverte sur %{total}
                  other: "%{count} ouvertes sur %{total}"
                label_x_open_issues_abbr:
                  zero:  0 ouverte
                  one:   1 ouverte
                  other: "%{count} ouvertes"
                label_x_closed_issues_abbr:
                  zero:  0 fermée
                  one:   1 fermée
                  other: "%{count} fermées"
                label_x_issues:
                  zero:  0 demande
                  one:   1 demande
                  other: "%{count} demandes"
                label_total: Total
                label_permissions: Permissions
                label_current_status: Statut actuel
                label_new_statuses_allowed: Nouveaux statuts autorisés
                label_all: tous
                label_any: tous
                label_none: aucun
                label_nobody: personne
                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: "%{count} derniers changements"
                label_change_view_all: Voir tous les changements
                label_personalize_page: Personnaliser cette page
                label_comment: Commentaire
                label_comment_plural: Commentaires
                label_x_comments:
                  zero: aucun commentaire
                  one: un commentaire
                  other: "%{count} 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_my_queries: Mes rapports personnalisés
                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_the_next_days: dans les prochains jours
+               label_in_the_past_days: dans les derniers jours
                label_in: dans
                label_today: aujourd'hui
                label_all_time: toute la période
                label_yesterday: hier
                label_this_week: cette semaine
                label_last_week: la semaine dernière
                label_last_n_weeks: "les %{count} dernières semaines"
                label_last_n_days: "les %{count} derniers jours"
                label_this_month: ce mois-ci
                label_last_month: le mois dernier
                label_this_year: cette année
                label_date_range: Période
                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_any_issues_in_project: une demande du projet
                label_any_issues_not_in_project: une demande hors du projet
                label_no_issues_in_project: aucune demande du projet
                label_day_plural: jours
                label_repository: Dépôt
                label_repository_new: Nouveau dépôt
                label_repository_plural: Dépôts
                label_browse: Parcourir
                label_modification: "%{count} modification"
                label_modification_plural: "%{count} modifications"
                label_revision: "Révision "
                label_revision_plural: Révisions
                label_associated_revisions: Révisions associées
                label_added: ajouté
                label_modified: modifié
                label_copied: copié
                label_renamed: renommé
                label_deleted: supprimé
                label_latest_revision: Dernière révision
                label_latest_revision_plural: Dernières révisions
                label_view_revisions: Voir les révisions
                label_max_size: Taille maximale
                label_sort_highest: Remonter en premier
                label_sort_higher: Remonter
                label_sort_lower: Descendre
                label_sort_lowest: Descendre en dernier
                label_roadmap: Roadmap
                label_roadmap_due_in: "Échéance dans %{value}"
                label_roadmap_overdue: "En retard de %{value}"
                label_roadmap_no_issues: Aucune demande pour cette version
                label_search: "Recherche "
                label_result_plural: Résultats
                label_all_words: Tous les mots
                label_wiki: Wiki
                label_wiki_edit: Révision wiki
                label_wiki_edit_plural: Révisions wiki
                label_wiki_page: Page wiki
                label_wiki_page_plural: Pages wiki
                label_index_by_title: Index par titre
                label_index_by_date: Index par date
                label_current_version: Version actuelle
                label_preview: Prévisualisation
                label_feed_plural: Flux RSS
                label_changes_details: Détails de tous les changements
                label_issue_tracking: Suivi des demandes
                label_spent_time: Temps passé
                label_f_hour: "%{value} heure"
                label_f_hour_plural: "%{value} heures"
                label_time_tracking: Suivi du temps
                label_change_plural: Changements
                label_statistics: Statistiques
                label_commits_per_month: Commits par mois
                label_commits_per_author: Commits par auteur
                label_view_diff: Voir les différences
                label_diff_inline: en ligne
                label_diff_side_by_side: côte à côte
                label_options: Options
                label_copy_workflow_from: Copier le workflow de
                label_permissions_report: Synthèse des permissions
                label_watched_issues: Demandes surveillées
                label_related_issues: Demandes liées
                label_applied_status: Statut appliqué
                label_loading: Chargement...
                label_relation_new: Nouvelle relation
                label_relation_delete: Supprimer la relation
                label_relates_to: Lié à
                label_duplicates: Duplique
                label_duplicated_by: Dupliqué par
                label_blocks: Bloque
                label_blocked_by: Bloqué par
                label_precedes: Précède
                label_follows: Suit
                label_copied_to: Copié vers
                label_copied_from: Copié depuis
                label_end_to_start: fin à début
                label_end_to_end: fin à fin
                label_start_to_start: début à début
                label_start_to_end: début à fin
                label_stay_logged_in: Rester connecté
                label_disabled: désactivé
                label_show_completed_versions: Voir les versions passées
                label_me: moi
                label_board: Forum
                label_board_new: Nouveau forum
                label_board_plural: Forums
                label_topic_plural: Discussions
                label_message_plural: Messages
                label_message_last: Dernier message
                label_message_new: Nouveau message
                label_message_posted: Message ajouté
                label_reply_plural: Réponses
                label_send_information: Envoyer les informations à l'utilisateur
                label_year: Année
                label_month: Mois
                label_week: Semaine
                label_date_from: Du
                label_date_to: Au
                label_language_based: Basé sur la langue de l'utilisateur
                label_sort_by: "Trier par %{value}"
                label_send_test_email: Envoyer un email de test
                label_feeds_access_key_created_on: "Clé d'accès RSS créée il y a %{value}"
                label_module_plural: Modules
                label_added_time_by: "Ajouté par %{author} il y a %{age}"
                label_updated_time_by: "Mis à jour par %{author} il y a %{age}"
                label_updated_time: "Mis à jour il y a %{value}"
                label_jump_to_a_project: Aller à un projet...
                label_file_plural: Fichiers
                label_changeset_plural: Révisions
                label_default_columns: Colonnes par défaut
                label_no_change_option: (Pas de changement)
                label_bulk_edit_selected_issues: Modifier les demandes sélectionnées
                label_theme: Thème
                label_default: Défaut
                label_search_titles_only: Uniquement dans les titres
                label_user_mail_option_all: "Pour tous les événements de tous mes projets"
                label_user_mail_option_selected: "Pour tous les événements des projets sélectionnés..."
                label_user_mail_no_self_notified: "Je ne veux pas être notifié des changements que j'effectue"
                label_registration_activation_by_email: activation du compte par email
                label_registration_manual_activation: activation manuelle du compte
                label_registration_automatic_activation: activation automatique du compte
                label_display_per_page: "Par page : %{value}"
                label_age: Âge
                label_change_properties: Changer les propriétés
                label_general: Général
                label_more: Plus
                label_scm: SCM
                label_plugins: Plugins
                label_ldap_authentication: Authentification LDAP
                label_downloads_abbr: D/L
                label_optional_description: Description facultative
                label_add_another_file: Ajouter un autre fichier
                label_preferences: Préférences
                label_chronological_order: Dans l'ordre chronologique
                label_reverse_chronological_order: Dans l'ordre chronologique inverse
                label_planning: Planning
                label_incoming_emails: Emails entrants
                label_generate_key: Générer une clé
                label_issue_watchers: Observateurs
                label_example: Exemple
                label_display: Affichage
                label_sort: Tri
                label_ascending: Croissant
                label_descending: Décroissant
                label_date_from_to: Du %{start} au %{end}
                label_wiki_content_added: Page wiki ajoutée
                label_wiki_content_updated: Page wiki mise à jour
                label_group_plural: Groupes
                label_group: Groupe
                label_group_new: Nouveau groupe
                label_time_entry_plural: Temps passé
                label_version_sharing_none: Non partagé
                label_version_sharing_descendants: Avec les sous-projets
                label_version_sharing_hierarchy: Avec toute la hiérarchie
                label_version_sharing_tree: Avec tout l'arbre
                label_version_sharing_system: Avec tous les projets
                label_copy_source: Source
                label_copy_target: Cible
                label_copy_same_as_target: Comme la cible
                label_update_issue_done_ratios: Mettre à jour l'avancement des demandes
                label_display_used_statuses_only: N'afficher que les statuts utilisés dans ce tracker
                label_api_access_key: Clé d'accès API
                label_api_access_key_created_on: Clé d'accès API créée il y a %{value}
                label_feeds_access_key: Clé d'accès RSS
                label_missing_api_access_key: Clé d'accès API manquante
                label_missing_feeds_access_key: Clé d'accès RSS manquante
                label_close_versions: Fermer les versions terminées
                label_revision_id: Révision %{value}
                label_profile: Profil
                label_subtask_plural: Sous-tâches
                label_project_copy_notifications: Envoyer les notifications durant la copie du projet
                label_principal_search: "Rechercher un utilisateur ou un groupe :"
                label_user_search: "Rechercher un utilisateur :"
                label_additional_workflow_transitions_for_author: Autorisations supplémentaires lorsque l'utilisateur a créé la demande
                label_additional_workflow_transitions_for_assignee: Autorisations supplémentaires lorsque la demande est assignée à l'utilisateur
                label_issues_visibility_all: Toutes les demandes
                label_issues_visibility_public: Toutes les demandes non privées
                label_issues_visibility_own: Demandes créées par ou assignées à l'utilisateur
                label_export_options: Options d'exportation %{export_format}
                label_copy_attachments: Copier les fichiers
                label_copy_subtasks: Copier les sous-tâches
                label_item_position: "%{position} sur %{count}"
                label_completed_versions: Versions passées
                label_session_expiration: Expiration des sessions
                label_show_closed_projects: Voir les projets fermés
                label_status_transitions: Changements de statut
                label_fields_permissions: Permissions sur les champs
                label_readonly: Lecture
                label_required: Obligatoire
                label_attribute_of_project: "%{name} du projet"
                label_attribute_of_author: "%{name} de l'auteur"
                label_attribute_of_assigned_to: "%{name} de l'assigné"
                label_attribute_of_fixed_version: "%{name} de la version cible"
                label_cross_project_descendants: Avec les sous-projets
                label_cross_project_tree: Avec tout l'arbre
                label_cross_project_hierarchy: Avec toute la hiérarchie
                label_cross_project_system: Avec tous les projets
                button_login: Connexion
                button_submit: Soumettre
                button_save: Sauvegarder
                button_check_all: Tout cocher
                button_uncheck_all: Tout décocher
                button_collapse_all: Plier tout
                button_expand_all: Déplier tout
                button_delete: Supprimer
                button_create: Créer
                button_create_and_continue: Créer et continuer
                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_move_and_follow: Déplacer et suivre
                button_back: Retour
                button_cancel: Annuler
                button_activate: Activer
                button_sort: Trier
                button_log_time: Saisir temps
                button_rollback: Revenir à cette version
                button_watch: Surveiller
                button_unwatch: Ne plus surveiller
                button_reply: Répondre
                button_archive: Archiver
                button_unarchive: Désarchiver
                button_reset: Réinitialiser
                button_rename: Renommer
                button_change_password: Changer de mot de passe
                button_copy: Copier
                button_copy_and_follow: Copier et suivre
                button_annotate: Annoter
                button_update: Mettre à jour
                button_configure: Configurer
                button_quote: Citer
                button_duplicate: Dupliquer
                button_show: Afficher
                button_hide: Cacher
                button_edit_section: Modifier cette section
                button_export: Exporter
                button_delete_my_account: Supprimer mon compte
                button_close: Fermer
                button_reopen: Réouvrir
                status_active: actif
                status_registered: enregistré
                status_locked: verrouillé
                project_status_active: actif
                project_status_closed: fermé
                project_status_archived: archivé
                version_status_open: ouvert
                version_status_locked: verrouillé
                version_status_closed: fermé
                text_select_mail_notifications: Actions pour lesquelles une notification par e-mail est envoyée
                text_regexp_info: ex. ^[A-Z0-9]+$
                text_min_max_length_info: 0 pour aucune restriction
                text_project_destroy_confirmation: Êtes-vous sûr de vouloir supprimer ce projet et toutes ses données ?
                text_subprojects_destroy_warning: "Ses sous-projets : %{value} seront également supprimés."
                text_workflow_edit: Sélectionner un tracker et un rôle pour éditer le workflow
                text_are_you_sure: Êtes-vous sûr ?
                text_tip_issue_begin_day: tâche commençant ce jour
                text_tip_issue_end_day: tâche finissant ce jour
                text_tip_issue_begin_end_day: tâche commençant et finissant ce jour
                text_project_identifier_info: 'Seuls les lettres minuscules (a-z), chiffres, tirets et underscore sont autorisés.<br />Un fois sauvegardé, l''identifiant ne pourra plus être modifié.'
                text_caracters_maximum: "%{count} caractères maximum."
                text_caracters_minimum: "%{count} caractères minimum."
                text_length_between: "Longueur comprise entre %{min} et %{max} caractères."
                text_tracker_no_workflow: Aucun worflow n'est défini pour ce tracker
                text_unallowed_characters: Caractères non autorisés
                text_comma_separated: Plusieurs valeurs possibles (séparées par des virgules).
                text_line_separated: Plusieurs valeurs possibles (une valeur par ligne).
                text_issues_ref_in_commit_messages: Référencement et résolution des demandes dans les commentaires de commits
                text_issue_added: "La demande %{id} a été soumise par %{author}."
                text_issue_updated: "La demande %{id} a été mise à jour par %{author}."
                text_wiki_destroy_confirmation: Etes-vous sûr de vouloir supprimer ce wiki et tout son contenu ?
                text_issue_category_destroy_question: "%{count} demandes sont affectées à cette catégorie. Que voulez-vous faire ?"
                text_issue_category_destroy_assignments: N'affecter les demandes à aucune autre catégorie
                text_issue_category_reassign_to: Réaffecter les demandes à cette catégorie
                text_user_mail_option: "Pour les projets non sélectionnés, vous recevrez seulement des notifications pour ce que vous surveillez ou à quoi vous participez (exemple: demandes dont vous êtes l'auteur ou la personne assignée)."
                text_no_configuration_data: "Les rôles, trackers, statuts et le workflow ne sont pas encore paramétrés.\nIl est vivement recommandé de charger le paramétrage par defaut. Vous pourrez le modifier une fois chargé."
                text_load_default_configuration: Charger le paramétrage par défaut
                text_status_changed_by_changeset: "Appliqué par commit %{value}."
                text_time_logged_by_changeset: "Appliqué par commit %{value}"
                text_issues_destroy_confirmation: 'Êtes-vous sûr de vouloir supprimer la ou les demandes(s) selectionnée(s) ?'
                text_issues_destroy_descendants_confirmation: "Cela entrainera également la suppression de %{count} sous-tâche(s)."
                text_select_project_modules: 'Sélectionner les modules à activer pour ce projet :'
                text_default_administrator_account_changed: Compte administrateur par défaut changé
                text_file_repository_writable: Répertoire de stockage des fichiers accessible en écriture
                text_plugin_assets_writable: Répertoire public des plugins accessible en écriture
                text_rmagick_available: Bibliothèque RMagick présente (optionnelle)
                text_destroy_time_entries_question: "%{hours} heures ont été enregistrées sur les demandes à supprimer. Que voulez-vous faire ?"
                text_destroy_time_entries: Supprimer les heures
                text_assign_time_entries_to_project: Reporter les heures sur le projet
                text_reassign_time_entries: 'Reporter les heures sur cette demande:'
                text_user_wrote: "%{value} a écrit :"
                text_enumeration_destroy_question: "Cette valeur est affectée à %{count} objets."
                text_enumeration_category_reassign_to: 'Réaffecter les objets à cette valeur:'
                text_email_delivery_not_configured: "L'envoi de mail n'est pas configuré, les notifications sont désactivées.\nConfigurez votre serveur SMTP dans config/configuration.yml et redémarrez l'application pour les activer."
                text_repository_usernames_mapping: "Vous pouvez sélectionner ou modifier l'utilisateur Redmine associé à chaque nom d'utilisateur figurant dans l'historique du dépôt.\nLes utilisateurs avec le même identifiant ou la même adresse mail seront automatiquement associés."
                text_diff_truncated: '... Ce différentiel a été tronqué car il excède la taille maximale pouvant être affichée.'
                text_custom_field_possible_values_info: 'Une ligne par valeur'
                text_wiki_page_destroy_question: "Cette page possède %{descendants} sous-page(s) et descendante(s). Que voulez-vous faire ?"
                text_wiki_page_nullify_children: "Conserver les sous-pages en tant que pages racines"
                text_wiki_page_destroy_children: "Supprimer les sous-pages et toutes leurs descedantes"
                text_wiki_page_reassign_children: "Réaffecter les sous-pages à cette page"
                text_own_membership_delete_confirmation: "Vous allez supprimer tout ou partie de vos permissions sur ce projet et ne serez peut-être plus autorisé à modifier ce projet.\nEtes-vous sûr de vouloir continuer ?"
                text_warn_on_leaving_unsaved: "Cette page contient du texte non sauvegardé qui sera perdu si vous quittez la page."
                text_issue_conflict_resolution_overwrite: "Appliquer quand même ma mise à jour (les notes précédentes seront conservées mais des changements pourront être écrasés)"
                text_issue_conflict_resolution_add_notes: "Ajouter mes notes et ignorer mes autres changements"
                text_issue_conflict_resolution_cancel: "Annuler ma mise à jour et réafficher %{link}"
                text_account_destroy_confirmation: "Êtes-vous sûr de vouloir continuer ?\nVotre compte sera définitivement supprimé, sans aucune possibilité de le réactiver."
                text_session_expiration_settings: "Attention : le changement de ces paramètres peut entrainer l'expiration des sessions utilisateurs en cours, y compris la vôtre."
                text_project_closed: Ce projet est fermé et accessible en lecture seule.
                default_role_manager: "Manager "
                default_role_developer: "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_in_progress: En cours
                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
                default_activity_design: Conception
                default_activity_development: Développement
                enumeration_issue_priorities: Priorités des demandes
                enumeration_doc_categories: Catégories des documents
                enumeration_activities: Activités (suivi du temps)
                label_greater_or_equal: ">="
                label_less_or_equal: "<="
                label_between: entre
                label_view_all_revisions: Voir toutes les révisions
                label_tag: Tag
                label_branch: Branche
                error_no_tracker_in_project: "Aucun tracker n'est associé à ce projet. Vérifier la configuration du projet."
                error_no_default_issue_status: "Aucun statut de demande n'est défini par défaut. Vérifier votre configuration (Administration -> Statuts de demandes)."
                text_journal_changed: "%{label} changé de %{old} à %{new}"
                text_journal_changed_no_detail: "%{label} mis à jour"
                text_journal_set_to: "%{label} mis à %{value}"
                text_journal_deleted: "%{label} %{old} supprimé"
                text_journal_added: "%{label} %{value} ajouté"
                enumeration_system_activity: Activité système
                label_board_sticky: Sticky
                label_board_locked: Verrouillé
                error_unable_delete_issue_status: Impossible de supprimer le statut de demande
                error_can_not_delete_custom_field: Impossible de supprimer le champ personnalisé
                error_unable_to_connect: Connexion impossible (%{value})
                error_can_not_remove_role: Ce rôle est utilisé et ne peut pas être supprimé.
                error_can_not_delete_tracker: Ce tracker contient des demandes et ne peut pas être supprimé.
                field_principal: Principal
                notice_failed_to_save_members: "Erreur lors de la sauvegarde des membres: %{errors}."
                text_zoom_out: Zoom arrière
                text_zoom_in: Zoom avant
                notice_unable_delete_time_entry: Impossible de supprimer le temps passé.
                label_overall_spent_time: Temps passé global
                field_time_entries: Temps passé
                project_module_gantt: Gantt
                project_module_calendar: Calendrier
                button_edit_associated_wikipage: "Modifier la page wiki associée: %{page_title}"
                text_are_you_sure_with_children: Supprimer la demande et toutes ses sous-demandes ?
                field_text: Champ texte
                label_user_mail_option_only_owner: Seulement pour ce que j'ai créé
                setting_default_notification_option: Option de notification par défaut
                label_user_mail_option_only_my_events: Seulement pour ce que je surveille
                label_user_mail_option_only_assigned: Seulement pour ce qui m'est assigné
                label_user_mail_option_none: Aucune notification
                field_member_of_group: Groupe de l'assigné
                field_assigned_to_role: Rôle de l'assigné
                setting_emails_header: En-tête des emails
                label_bulk_edit_selected_time_entries: Modifier les temps passés sélectionnés
                text_time_entries_destroy_confirmation: "Etes-vous sûr de vouloir supprimer les temps passés sélectionnés ?"
                field_scm_path_encoding: Encodage des chemins
                text_scm_path_encoding_note: "Défaut : UTF-8"
                field_path_to_repository: Chemin du dépôt
                field_root_directory: Répertoire racine
                field_cvs_module: Module
                field_cvsroot: CVSROOT
                text_mercurial_repository_note: "Dépôt local (exemples : /hgrepo, c:\\hgrepo)"
                text_scm_command: Commande
                text_scm_command_version: Version
                label_git_report_last_commit: Afficher le dernier commit des fichiers et répertoires
                text_scm_config: Vous pouvez configurer les commandes des SCM dans config/configuration.yml. Redémarrer l'application après modification.
                text_scm_command_not_available: Ce SCM n'est pas disponible. Vérifier les paramètres dans la section administration.
                label_diff: diff
                text_git_repository_note: Repository is bare and local (e.g. /gitrepo, c:\gitrepo)
                description_query_sort_criteria_direction: Ordre de tri
                description_project_scope: Périmètre de recherche
                description_filter: Filtre
                description_user_mail_notification: Option de notification
                description_date_from: Date de début
                description_message_content: Contenu du message
                description_available_columns: Colonnes disponibles
                description_all_columns: Toutes les colonnes
                description_date_range_interval: Choisir une période
                description_issue_category_reassign: Choisir une catégorie
                description_search: Champ de recherche
                description_notes: Notes
                description_date_range_list: Choisir une période prédéfinie
                description_choose_project: Projets
                description_date_to: Date de fin
                description_query_sort_criteria_attribute: Critère de tri
                description_wiki_subpages_reassign: Choisir une nouvelle page parent
                description_selected_columns: Colonnes sélectionnées
                label_parent_revision: Parent
                label_child_revision: Enfant
                error_scm_annotate_big_text_file: Cette entrée ne peut pas être annotée car elle excède la taille maximale.
                setting_repositories_encodings: Encodages des fichiers et des dépôts
                label_search_for_watchers: Rechercher des observateurs
                text_repository_identifier_info: 'Seuls les lettres minuscules (a-z), chiffres, tirets et underscore sont autorisés.<br />Un fois sauvegardé, l''identifiant ne pourra plus être modifié.'

public/javascripts/application.js +2 0

              /* Redmine - project management software
                 Copyright (C) 2006-2012  Jean-Philippe Lang */
              function checkAll(id, checked) {
                if (checked) {
                  $('#'+id).find('input[type=checkbox]').attr('checked', true);
                } else {
                  $('#'+id).find('input[type=checkbox]').removeAttr('checked');
                }
              }
              function toggleCheckboxesBySelector(selector) {
                var all_checked = true;
                $(selector).each(function(index) {
                  if (!$(this).is(':checked')) { all_checked = false; }
                });
                $(selector).attr('checked', !all_checked)
              }
              function showAndScrollTo(id, focus) {
                $('#'+id).show();
                if (focus!=null) {
                  $('#'+focus).focus();
                }
                $('html, body').animate({scrollTop: $('#'+id).offset().top}, 100);
              }
              function toggleRowGroup(el) {
                var tr = $(el).parents('tr').first();
                var n = tr.next();
                tr.toggleClass('open');
                while (n.length && !n.hasClass('group')) {
                  n.toggle();
                  n = n.next('tr');
                }
              }
              function collapseAllRowGroups(el) {
                var tbody = $(el).parents('tbody').first();
                tbody.children('tr').each(function(index) {
                  if ($(this).hasClass('group')) {
                    $(this).removeClass('open');
                  } else {
                    $(this).hide();
                  }
                });
              }
              function expandAllRowGroups(el) {
                var tbody = $(el).parents('tbody').first();
                tbody.children('tr').each(function(index) {
                  if ($(this).hasClass('group')) {
                    $(this).addClass('open');
                  } else {
                    $(this).show();
                  }
                });
              }
              function toggleAllRowGroups(el) {
                var tr = $(el).parents('tr').first();
                if (tr.hasClass('open')) {
                  collapseAllRowGroups(el);
                } else {
                  expandAllRowGroups(el);
                }
              }
              function toggleFieldset(el) {
                var fieldset = $(el).parents('fieldset').first();
                fieldset.toggleClass('collapsed');
                fieldset.children('div').toggle();
              }
              function hideFieldset(el) {
                var fieldset = $(el).parents('fieldset').first();
                fieldset.toggleClass('collapsed');
                fieldset.children('div').hide();
              }
              function initFilters(){
                $('#add_filter_select').change(function(){
                  addFilter($(this).val(), '', []);
                });
                $('#filters-table td.field input[type=checkbox]').each(function(){
                  toggleFilter($(this).val());
                });
                $('#filters-table td.field input[type=checkbox]').live('click',function(){
                  toggleFilter($(this).val());
                });
                $('#filters-table .toggle-multiselect').live('click',function(){
                  toggleMultiSelect($(this).siblings('select'));
                });
                $('#filters-table input[type=text]').live('keypress', function(e){
                  if (e.keyCode == 13) submit_query_form("query_form");
                });
              }
              function addFilter(field, operator, values) {
                var fieldId = field.replace('.', '_');
                var tr = $('#tr_'+fieldId);
                if (tr.length > 0) {
                  tr.show();
                } else {
                  buildFilterRow(field, operator, values);
                }
                $('#cb_'+fieldId).attr('checked', true);
                toggleFilter(field);
                $('#add_filter_select').val('').children('option').each(function(){
                  if ($(this).attr('value') == field) {
                    $(this).attr('disabled', true);
                  }
                });
              }
              function buildFilterRow(field, operator, values) {
                var fieldId = field.replace('.', '_');
                var filterTable = $("#filters-table");
                var filterOptions = availableFilters[field];
                var operators = operatorByType[filterOptions['type']];
                var filterValues = filterOptions['values'];
                var i, select;
                var tr = $('<tr class="filter">').attr('id', 'tr_'+fieldId).html(
                  '<td class="field"><input checked="checked" id="cb_'+fieldId+'" name="f[]" value="'+field+'" type="checkbox"><label for="cb_'+fieldId+'"> '+filterOptions['name']+'</label></td>' +
                  '<td class="operator"><select id="operators_'+fieldId+'" name="op['+field+']"></td>' +
                  '<td class="values"></td>'
                );
                filterTable.append(tr);
                select = tr.find('td.operator select');
                for (i=0;i<operators.length;i++){
                  var option = $('<option>').val(operators[i]).text(operatorLabels[operators[i]]);
                  if (operators[i] == operator) {option.attr('selected', true)};
                  select.append(option);
                }
                select.change(function(){toggleOperator(field)});
                switch (filterOptions['type']){
                case "list":
                case "list_optional":
                case "list_status":
                case "list_subprojects":
                  tr.find('td.values').append(
                    '<span style="display:none;"><select class="value" id="values_'+fieldId+'_1" name="v['+field+'][]"></select>' +
                    ' <span class="toggle-multiselect">&nbsp;</span></span>'
                  );
                  select = tr.find('td.values select');
                  if (values.length > 1) {select.attr('multiple', true)};
                  for (i=0;i<filterValues.length;i++){
                    var filterValue = filterValues[i];
                    var option = $('<option>');
                    if ($.isArray(filterValue)) {
                      option.val(filterValue[1]).text(filterValue[0]);
                      if ($.inArray(filterValue[1], values) > -1) {option.attr('selected', true);}
                    } else {
                      option.val(filterValue).text(filterValue);
                      if ($.inArray(filterValue, values) > -1) {option.attr('selected', true);}
                    }
                    select.append(option);
                  }
                  break;
                case "date":
                case "date_past":
                  tr.find('td.values').append(
                    '<span style="display:none;"><input type="text" name="v['+field+'][]" id="values_'+fieldId+'_1" size="10" class="value date_value" /></span>' +
                    ' <span style="display:none;"><input type="text" name="v['+field+'][]" id="values_'+fieldId+'_2" size="10" class="value date_value" /></span>' +
                    ' <span style="display:none;"><input type="text" name="v['+field+'][]" id="values_'+fieldId+'" size="3" class="value" /> '+labelDayPlural+'</span>'
                  );
                  $('#values_'+fieldId+'_1').val(values[0]).datepicker(datepickerOptions);
                  $('#values_'+fieldId+'_2').val(values[1]).datepicker(datepickerOptions);
                  $('#values_'+fieldId).val(values[0]);
                  break;
                case "string":
                case "text":
                  tr.find('td.values').append(
                    '<span style="display:none;"><input type="text" name="v['+field+'][]" id="values_'+fieldId+'" size="30" class="value" /></span>'
                  );
                  $('#values_'+fieldId).val(values[0]);
                  break;
                case "relation":
                  tr.find('td.values').append(
                    '<span style="display:none;"><input type="text" name="v['+field+'][]" id="values_'+fieldId+'" size="6" class="value" /></span>' +
                    '<span style="display:none;"><select class="value" name="v['+field+'][]" id="values_'+fieldId+'_1"></select></span>'
                  );
                  $('#values_'+fieldId).val(values[0]);
                  select = tr.find('td.values select');
                  for (i=0;i<allProjects.length;i++){
                    var filterValue = allProjects[i];
                    var option = $('<option>');
                    option.val(filterValue[1]).text(filterValue[0]);
                    if (values[0] == filterValue[1]) {option.attr('selected', true)};
                    select.append(option);
                  }
                case "integer":
                case "float":
                  tr.find('td.values').append(
                    '<span style="display:none;"><input type="text" name="v['+field+'][]" id="values_'+fieldId+'_1" size="6" class="value" /></span>' +
                    ' <span style="display:none;"><input type="text" name="v['+field+'][]" id="values_'+fieldId+'_2" size="6" class="value" /></span>'
                  );
                  $('#values_'+fieldId+'_1').val(values[0]);
                  $('#values_'+fieldId+'_2').val(values[1]);
                  break;
                }
              }
              function toggleFilter(field) {
                var fieldId = field.replace('.', '_');
                if ($('#cb_' + fieldId).is(':checked')) {
                  $("#operators_" + fieldId).show().removeAttr('disabled');
                  toggleOperator(field);
                } else {
                  $("#operators_" + fieldId).hide().attr('disabled', true);
                  enableValues(field, []);
                }
              }
              function enableValues(field, indexes) {
                var fieldId = field.replace('.', '_');
                $('#tr_'+fieldId+' td.values .value').each(function(index) {
                  if ($.inArray(index, indexes) >= 0) {
                    $(this).removeAttr('disabled');
                    $(this).parents('span').first().show();
                  } else {
                    $(this).val('');
                    $(this).attr('disabled', true);
                    $(this).parents('span').first().hide();
                  }
                  if ($(this).hasClass('group')) {
                    $(this).addClass('open');
                  } else {
                    $(this).show();
                  }
                });
              }
              function toggleOperator(field) {
                var fieldId = field.replace('.', '_');
                var operator = $("#operators_" + fieldId);
                switch (operator.val()) {
                  case "!*":
                  case "*":
                  case "t":
                  case "w":
                  case "o":
                  case "c":
                    enableValues(field, []);
                    break;
                  case "><":
                    enableValues(field, [0,1]);
                    break;
                  case "<t+":
                  case ">t+":
+                 case "><t+":
                  case "t+":
                  case ">t-":
                  case "<t-":
+                 case "><t-":
                  case "t-":
                    enableValues(field, [2]);
                    break;
                  case "=p":
                  case "=!p":
                  case "!p":
                    enableValues(field, [1]);
                    break;
                  default:
                    enableValues(field, [0]);
                    break;
                }
              }
              function toggleMultiSelect(el) {
                if (el.attr('multiple')) {
                  el.removeAttr('multiple');
                } else {
                  el.attr('multiple', true);
                }
              }
              function submit_query_form(id) {
                selectAllOptions("selected_columns");
                $('#'+id).submit();
              }
              var fileFieldCount = 1;
              function addFileField() {
                var fields = $('#attachments_fields');
                if (fields.children().length >= 10) return false;
                fileFieldCount++;
                var s = fields.children('span').first().clone();
                s.children('input.file').attr('name', "attachments[" + fileFieldCount + "][file]").val('');
                s.children('input.description').attr('name', "attachments[" + fileFieldCount + "][description]").val('');
                fields.append(s);
              }
              function removeFileField(el) {
                var fields = $('#attachments_fields');
                var s = $(el).parents('span').first();
                if (fields.children().length > 1) {
                  s.remove();
                } else {
                  s.children('input.file').val('');
                  s.children('input.description').val('');
                }
              }
              function checkFileSize(el, maxSize, message) {
                var files = el.files;
                if (files) {
                  for (var i=0; i<files.length; i++) {
                    if (files[i].size > maxSize) {
                      alert(message);
                      el.value = "";
                    }
                  }
                }
              }
              function showTab(name) {
                $('div#content .tab-content').hide();
                $('div.tabs a').removeClass('selected');
                $('#tab-content-' + name).show();
                $('#tab-' + name).addClass('selected');
                return false;
              }
              function moveTabRight(el) {
                var lis = $(el).parents('div.tabs').first().find('ul').children();
                var tabsWidth = 0;
                var i = 0;
                lis.each(function(){
                  if ($(this).is(':visible')) {
                    tabsWidth += $(this).width() + 6;
                  }
                });
                if (tabsWidth < $(el).parents('div.tabs').first().width() - 60) { return; }
                while (i<lis.length && !lis.eq(i).is(':visible')) { i++; }
                lis.eq(i).hide();
              }
              function moveTabLeft(el) {
                var lis = $(el).parents('div.tabs').first().find('ul').children();
                var i = 0;
                while (i<lis.length && !lis.eq(i).is(':visible')) { i++; }
                if (i>0) {
                  lis.eq(i-1).show();
                }
              }
              function displayTabsButtons() {
                var lis;
                var tabsWidth = 0;
                var el;
                $('div.tabs').each(function() {
                  el = $(this);
                  lis = el.find('ul').children();
                  lis.each(function(){
                    if ($(this).is(':visible')) {
                      tabsWidth += $(this).width() + 6;
                    }
                  });
                  if ((tabsWidth < el.width() - 60) && (lis.first().is(':visible'))) {
                    el.find('div.tabs-buttons').hide();
                  } else {
                    el.find('div.tabs-buttons').show();
                  }
                });
              }
              function setPredecessorFieldsVisibility() {
                var relationType = $('#relation_relation_type');
                if (relationType.val() == "precedes" || relationType.val() == "follows") {
                  $('#predecessor_fields').show();
                } else {
                  $('#predecessor_fields').hide();
                }
              }
              function showModal(id, width) {
                var el = $('#'+id).first();
                if (el.length == 0 || el.is(':visible')) {return;}
                var title = el.find('h3.title').text();
                el.dialog({
                  width: width,
                  modal: true,
                  resizable: false,
                  dialogClass: 'modal',
                  title: title
                });
                el.find("input[type=text], input[type=submit]").first().focus();
              }
              function hideModal(el) {
                var modal;
                if (el) {
                  modal = $(el).parents('.ui-dialog-content');
                } else {
                  modal = $('#ajax-modal');
                }
                modal.dialog("close");
              }
              function submitPreview(url, form, target) {
                $.ajax({
                  url: url,
                  type: 'post',
                  data: $('#'+form).serialize(),
                  success: function(data){
                    $('#'+target).html(data);
                  }
                });
              }
              function collapseScmEntry(id) {
                $('.'+id).each(function() {
                  if ($(this).hasClass('open')) {
                    collapseScmEntry($(this).attr('id'));
                  }
                  $(this).hide();
                });
                $('#'+id).removeClass('open');
              }
              function expandScmEntry(id) {
                $('.'+id).each(function() {
                  $(this).show();
                  if ($(this).hasClass('loaded') && !$(this).hasClass('collapsed')) {
                    expandScmEntry($(this).attr('id'));
                  }
                });
                $('#'+id).addClass('open');
              }
              function scmEntryClick(id, url) {
                  el = $('#'+id);
                  if (el.hasClass('open')) {
                      collapseScmEntry(id);
                      el.addClass('collapsed');
                      return false;
                  } else if (el.hasClass('loaded')) {
                      expandScmEntry(id);
                      el.removeClass('collapsed');
                      return false;
                  }
                  if (el.hasClass('loading')) {
                      return false;
                  }
                  el.addClass('loading');
                  $.ajax({
                    url: url,
                    success: function(data){
                      el.after(data);
                      el.addClass('open').addClass('loaded').removeClass('loading');
                    }
                  });
                  return true;
              }
              function randomKey(size) {
                var chars = new Array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z');
                var key = '';
                for (i = 0; i < size; i++) {
                  key += chars[Math.floor(Math.random() * chars.length)];
                }
                return key;
              }
              // Can't use Rails' remote select because we need the form data
              function updateIssueFrom(url) {
                $.ajax({
                  url: url,
                  type: 'post',
                  data: $('#issue-form').serialize()
                });
              }
              function updateBulkEditFrom(url) {
                $.ajax({
                  url: url,
                  type: 'post',
                  data: $('#bulk_edit_form').serialize()
                });
              }
              function observeAutocompleteField(fieldId, url) {
                $('#'+fieldId).autocomplete({
                  source: url,
                  minLength: 2
                });
              }
              function observeSearchfield(fieldId, targetId, url) {
                $('#'+fieldId).each(function() {
                  var $this = $(this);
                  $this.attr('data-value-was', $this.val());
                  var check = function() {
                    var val = $this.val();
                    if ($this.attr('data-value-was') != val){
                      $this.attr('data-value-was', val);
                      $.ajax({
                        url: url,
                        type: 'get',
                        data: {q: $this.val()},
                        success: function(data){ $('#'+targetId).html(data); },
                        beforeSend: function(){ $this.addClass('ajax-loading'); },
                        complete: function(){ $this.removeClass('ajax-loading'); }
                      });
                    }
                  };
                  var reset = function() {
                    if (timer) {
                      clearInterval(timer);
                      timer = setInterval(check, 300);
                    }
                  };
                  var timer = setInterval(check, 300);
                  $this.bind('keyup click mousemove', reset);
                });
              }
              function observeProjectModules() {
                var f = function() {
                  /* Hides trackers and issues custom fields on the new project form when issue_tracking module is disabled */
                  if ($('#project_enabled_module_names_issue_tracking').attr('checked')) {
                    $('#project_trackers').show();
                  }else{
                    $('#project_trackers').hide();
                  }
                };
                $(window).load(f);
                $('#project_enabled_module_names_issue_tracking').change(f);
              }
              function initMyPageSortable(list, url) {
                $('#list-'+list).sortable({
                  connectWith: '.block-receiver',
                  tolerance: 'pointer',
                  update: function(){
                    $.ajax({
                      url: url,
                      type: 'post',
                      data: {'blocks': $.map($('#list-'+list).children(), function(el){return $(el).attr('id');})}
                    });
                  }
                });
                $("#list-top, #list-left, #list-right").disableSelection();
              }
              var warnLeavingUnsavedMessage;
              function warnLeavingUnsaved(message) {
                warnLeavingUnsavedMessage = message;
                $('form').submit(function(){
                  $('textarea').removeData('changed');
                });
                $('textarea').change(function(){
                  $(this).data('changed', 'changed');
                });
                window.onbeforeunload = function(){
                  var warn = false;
                  $('textarea').blur().each(function(){
                    if ($(this).data('changed')) {
                      warn = true;
                    }
                  });
                  if (warn) {return warnLeavingUnsavedMessage;}
                };
              };
              $(document).ready(function(){
                $('#ajax-indicator').bind('ajaxSend', function(){
                  if ($('.ajax-loading').length == 0) {
                    $('#ajax-indicator').show();
                  }
                });
                $('#ajax-indicator').bind('ajaxStop', function(){
                  $('#ajax-indicator').hide();
                });
              });
              function hideOnLoad() {
                $('.hol').hide();
              }
              function addFormObserversForDoubleSubmit() {
                $('form[method=post]').each(function() {
                  if (!$(this).hasClass('multiple-submit')) {
                    $(this).submit(function(form_submission) {
                      if ($(form_submission.target).attr('data-submitted')) {
                        form_submission.preventDefault();
                      } else {
                        $(form_submission.target).attr('data-submitted', true);
                      }
                    });
                  }
                });
              }
              $(document).ready(hideOnLoad);
              $(document).ready(addFormObserversForDoubleSubmit);

test/unit/query_test.rb +17 0

              # Redmine - project management software
              # Copyright (C) 2006-2012  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.
              require File.expand_path('../../test_helper', __FILE__)
              class QueryTest < ActiveSupport::TestCase
                include Redmine::I18n
                fixtures :projects, :enabled_modules, :users, :members,
                         :member_roles, :roles, :trackers, :issue_statuses,
                         :issue_categories, :enumerations, :issues,
                         :watchers, :custom_fields, :custom_values, :versions,
                         :queries,
                         :projects_trackers,
                         :custom_fields_trackers
                def test_custom_fields_for_all_projects_should_be_available_in_global_queries
                  query = Query.new(:project => nil, :name => '_')
                  assert query.available_filters.has_key?('cf_1')
                  assert !query.available_filters.has_key?('cf_3')
                end
                def test_system_shared_versions_should_be_available_in_global_queries
                  Version.find(2).update_attribute :sharing, 'system'
                  query = Query.new(:project => nil, :name => '_')
                  assert query.available_filters.has_key?('fixed_version_id')
                  assert query.available_filters['fixed_version_id'][:values].detect {|v| v.last == '2'}
                end
                def test_project_filter_in_global_queries
                  query = Query.new(:project => nil, :name => '_')
                  project_filter = query.available_filters["project_id"]
                  assert_not_nil project_filter
                  project_ids = project_filter[:values].map{|p| p[1]}
                  assert project_ids.include?("1")  #public project
                  assert !project_ids.include?("2") #private project user cannot see
                end
                def find_issues_with_query(query)
                  Issue.includes([:assigned_to, :status, :tracker, :project, :priority]).where(
                       query.statement
                     ).all
                end
                def assert_find_issues_with_query_is_successful(query)
                  assert_nothing_raised do
                    find_issues_with_query(query)
                  end
                end
                def assert_query_statement_includes(query, condition)
                  assert query.statement.include?(condition), "Query statement condition not found in: #{query.statement}"
                end
                def assert_query_result(expected, query)
                  assert_nothing_raised do
                    assert_equal expected.map(&:id).sort, query.issues.map(&:id).sort
                    assert_equal expected.size, query.issue_count
                  end
                end
                def test_query_should_allow_shared_versions_for_a_project_query
                  subproject_version = Version.find(4)
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('fixed_version_id', '=', [subproject_version.id.to_s])
                  assert query.statement.include?("#{Issue.table_name}.fixed_version_id IN ('4')")
                end
                def test_query_with_multiple_custom_fields
                  query = Query.find(1)
                  assert query.valid?
                  assert query.statement.include?("#{CustomValue.table_name}.value IN ('MySQL')")
                  issues = find_issues_with_query(query)
                  assert_equal 1, issues.length
                  assert_equal Issue.find(3), issues.first
                end
                def test_operator_none
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('fixed_version_id', '!*', [''])
                  query.add_filter('cf_1', '!*', [''])
                  assert query.statement.include?("#{Issue.table_name}.fixed_version_id IS NULL")
                  assert query.statement.include?("#{CustomValue.table_name}.value IS NULL OR #{CustomValue.table_name}.value = ''")
                  find_issues_with_query(query)
                end
                def test_operator_none_for_integer
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('estimated_hours', '!*', [''])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  assert issues.all? {|i| !i.estimated_hours}
                end
                def test_operator_none_for_date
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('start_date', '!*', [''])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  assert issues.all? {|i| i.start_date.nil?}
                end
                def test_operator_none_for_string_custom_field
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('cf_2', '!*', [''])
                  assert query.has_filter?('cf_2')
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  assert issues.all? {|i| i.custom_field_value(2).blank?}
                end
                def test_operator_all
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('fixed_version_id', '*', [''])
                  query.add_filter('cf_1', '*', [''])
                  assert query.statement.include?("#{Issue.table_name}.fixed_version_id IS NOT NULL")
                  assert query.statement.include?("#{CustomValue.table_name}.value IS NOT NULL AND #{CustomValue.table_name}.value <> ''")
                  find_issues_with_query(query)
                end
                def test_operator_all_for_date
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('start_date', '*', [''])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  assert issues.all? {|i| i.start_date.present?}
                end
                def test_operator_all_for_string_custom_field
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('cf_2', '*', [''])
                  assert query.has_filter?('cf_2')
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  assert issues.all? {|i| i.custom_field_value(2).present?}
                end
                def test_numeric_filter_should_not_accept_non_numeric_values
                  query = Query.new(:name => '_')
                  query.add_filter('estimated_hours', '=', ['a'])
                  assert query.has_filter?('estimated_hours')
                  assert !query.valid?
                end
                def test_operator_is_on_float
                  Issue.update_all("estimated_hours = 171.2", "id=2")
                  query = Query.new(:name => '_')
                  query.add_filter('estimated_hours', '=', ['171.20'])
                  issues = find_issues_with_query(query)
                  assert_equal 1, issues.size
                  assert_equal 2, issues.first.id
                end
                def test_operator_is_on_integer_custom_field
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'int', :is_for_all => true, :is_filter => true)
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => '7')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(2), :value => '12')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(3), :value => '')
                  query = Query.new(:name => '_')
                  query.add_filter("cf_#{f.id}", '=', ['12'])
                  issues = find_issues_with_query(query)
                  assert_equal 1, issues.size
                  assert_equal 2, issues.first.id
                end
                def test_operator_is_on_integer_custom_field_should_accept_negative_value
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'int', :is_for_all => true, :is_filter => true)
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => '7')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(2), :value => '-12')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(3), :value => '')
                  query = Query.new(:name => '_')
                  query.add_filter("cf_#{f.id}", '=', ['-12'])
                  assert query.valid?
                  issues = find_issues_with_query(query)
                  assert_equal 1, issues.size
                  assert_equal 2, issues.first.id
                end
                def test_operator_is_on_float_custom_field
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'float', :is_filter => true, :is_for_all => true)
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => '7.3')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(2), :value => '12.7')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(3), :value => '')
                  query = Query.new(:name => '_')
                  query.add_filter("cf_#{f.id}", '=', ['12.7'])
                  issues = find_issues_with_query(query)
                  assert_equal 1, issues.size
                  assert_equal 2, issues.first.id
                end
                def test_operator_is_on_float_custom_field_should_accept_negative_value
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'float', :is_filter => true, :is_for_all => true)
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => '7.3')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(2), :value => '-12.7')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(3), :value => '')
                  query = Query.new(:name => '_')
                  query.add_filter("cf_#{f.id}", '=', ['-12.7'])
                  assert query.valid?
                  issues = find_issues_with_query(query)
                  assert_equal 1, issues.size
                  assert_equal 2, issues.first.id
                end
                def test_operator_is_on_multi_list_custom_field
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'list', :is_filter => true, :is_for_all => true,
                    :possible_values => ['value1', 'value2', 'value3'], :multiple => true)
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => 'value1')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => 'value2')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(3), :value => 'value1')
                  query = Query.new(:name => '_')
                  query.add_filter("cf_#{f.id}", '=', ['value1'])
                  issues = find_issues_with_query(query)
                  assert_equal [1, 3], issues.map(&:id).sort
                  query = Query.new(:name => '_')
                  query.add_filter("cf_#{f.id}", '=', ['value2'])
                  issues = find_issues_with_query(query)
                  assert_equal [1], issues.map(&:id).sort
                end
                def test_operator_is_not_on_multi_list_custom_field
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'list', :is_filter => true, :is_for_all => true,
                    :possible_values => ['value1', 'value2', 'value3'], :multiple => true)
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => 'value1')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => 'value2')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(3), :value => 'value1')
                  query = Query.new(:name => '_')
                  query.add_filter("cf_#{f.id}", '!', ['value1'])
                  issues = find_issues_with_query(query)
                  assert !issues.map(&:id).include?(1)
                  assert !issues.map(&:id).include?(3)
                  query = Query.new(:name => '_')
                  query.add_filter("cf_#{f.id}", '!', ['value2'])
                  issues = find_issues_with_query(query)
                  assert !issues.map(&:id).include?(1)
                  assert issues.map(&:id).include?(3)
                end
                def test_operator_is_on_is_private_field
                  # is_private filter only available for those who can set issues private
                  User.current = User.find(2)
                  query = Query.new(:name => '_')
                  assert query.available_filters.key?('is_private')
                  query.add_filter("is_private", '=', ['1'])
                  issues = find_issues_with_query(query)
                  assert issues.any?
                  assert_nil issues.detect {|issue| !issue.is_private?}
                ensure
                  User.current = nil
                end
                def test_operator_is_not_on_is_private_field
                  # is_private filter only available for those who can set issues private
                  User.current = User.find(2)
                  query = Query.new(:name => '_')
                  assert query.available_filters.key?('is_private')
                  query.add_filter("is_private", '!', ['1'])
                  issues = find_issues_with_query(query)
                  assert issues.any?
                  assert_nil issues.detect {|issue| issue.is_private?}
                ensure
                  User.current = nil
                end
                def test_operator_greater_than
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('done_ratio', '>=', ['40'])
                  assert query.statement.include?("#{Issue.table_name}.done_ratio >= 40.0")
                  find_issues_with_query(query)
                end
                def test_operator_greater_than_a_float
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('estimated_hours', '>=', ['40.5'])
                  assert query.statement.include?("#{Issue.table_name}.estimated_hours >= 40.5")
                  find_issues_with_query(query)
                end
                def test_operator_greater_than_on_int_custom_field
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'int', :is_filter => true, :is_for_all => true)
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => '7')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(2), :value => '12')
                  CustomValue.create!(:custom_field => f, :customized => Issue.find(3), :value => '')
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter("cf_#{f.id}", '>=', ['8'])
                  issues = find_issues_with_query(query)
                  assert_equal 1, issues.size
                  assert_equal 2, issues.first.id
                end
                def test_operator_lesser_than
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('done_ratio', '<=', ['30'])
                  assert query.statement.include?("#{Issue.table_name}.done_ratio <= 30.0")
                  find_issues_with_query(query)
                end
                def test_operator_lesser_than_on_custom_field
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'int', :is_filter => true, :is_for_all => true)
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter("cf_#{f.id}", '<=', ['30'])
                  assert query.statement.include?("CAST(custom_values.value AS decimal(60,3)) <= 30.0")
                  find_issues_with_query(query)
                end
                def test_operator_between
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('done_ratio', '><', ['30', '40'])
                  assert_include "#{Issue.table_name}.done_ratio BETWEEN 30.0 AND 40.0", query.statement
                  find_issues_with_query(query)
                end
                def test_operator_between_on_custom_field
                  f = IssueCustomField.create!(:name => 'filter', :field_format => 'int', :is_filter => true, :is_for_all => true)
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter("cf_#{f.id}", '><', ['30', '40'])
                  assert_include "CAST(custom_values.value AS decimal(60,3)) BETWEEN 30.0 AND 40.0", query.statement
                  find_issues_with_query(query)
                end
                def test_date_filter_should_not_accept_non_date_values
                  query = Query.new(:name => '_')
                  query.add_filter('created_on', '=', ['a'])
                  assert query.has_filter?('created_on')
                  assert !query.valid?
                end
                def test_date_filter_should_not_accept_invalid_date_values
                  query = Query.new(:name => '_')
                  query.add_filter('created_on', '=', ['2011-01-34'])
                  assert query.has_filter?('created_on')
                  assert !query.valid?
                end
                def test_relative_date_filter_should_not_accept_non_integer_values
                  query = Query.new(:name => '_')
                  query.add_filter('created_on', '>t-', ['a'])
                  assert query.has_filter?('created_on')
                  assert !query.valid?
                end
                def test_operator_date_equals
                  query = Query.new(:name => '_')
                  query.add_filter('due_date', '=', ['2011-07-10'])
                  assert_match /issues\.due_date > '2011-07-09 23:59:59(\.9+)?' AND issues\.due_date <= '2011-07-10 23:59:59(\.9+)?/, query.statement
                  find_issues_with_query(query)
                end
                def test_operator_date_lesser_than
                  query = Query.new(:name => '_')
                  query.add_filter('due_date', '<=', ['2011-07-10'])
                  assert_match /issues\.due_date <= '2011-07-10 23:59:59(\.9+)?/, query.statement
                  find_issues_with_query(query)
                end
                def test_operator_date_greater_than
                  query = Query.new(:name => '_')
                  query.add_filter('due_date', '>=', ['2011-07-10'])
                  assert_match /issues\.due_date > '2011-07-09 23:59:59(\.9+)?'/, query.statement
                  find_issues_with_query(query)
                end
                def test_operator_date_between
                  query = Query.new(:name => '_')
                  query.add_filter('due_date', '><', ['2011-06-23', '2011-07-10'])
                  assert_match /issues\.due_date > '2011-06-22 23:59:59(\.9+)?' AND issues\.due_date <= '2011-07-10 23:59:59(\.9+)?/, query.statement
                  find_issues_with_query(query)
                end
                def test_operator_in_more_than
                  Issue.find(7).update_attribute(:due_date, (Date.today + 15))
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', '>t+', ['15'])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  issues.each {|issue| assert(issue.due_date >= (Date.today + 15))}
                end
                def test_operator_in_less_than
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', '<t+', ['15'])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
+                 issues.each {|issue| assert(issue.due_date <= (Date.today + 15))}
+               end
+               def test_operator_in_the_next_days
+                 query = Query.new(:project => Project.find(1), :name => '_')
+                 query.add_filter('due_date', '><t+', ['15'])
+                 issues = find_issues_with_query(query)
+                 assert !issues.empty?
                  issues.each {|issue| assert(issue.due_date >= Date.today && issue.due_date <= (Date.today + 15))}
                end
                def test_operator_less_than_ago
                  Issue.find(7).update_attribute(:due_date, (Date.today - 3))
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', '>t-', ['3'])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
+                 issues.each {|issue| assert(issue.due_date >= (Date.today - 3))}
+               end
+               def test_operator_in_the_past_days
+                 Issue.find(7).update_attribute(:due_date, (Date.today - 3))
+                 query = Query.new(:project => Project.find(1), :name => '_')
+                 query.add_filter('due_date', '><t-', ['3'])
+                 issues = find_issues_with_query(query)
+                 assert !issues.empty?
                  issues.each {|issue| assert(issue.due_date >= (Date.today - 3) && issue.due_date <= Date.today)}
                end
                def test_operator_more_than_ago
                  Issue.find(7).update_attribute(:due_date, (Date.today - 10))
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', '<t-', ['10'])
                  assert query.statement.include?("#{Issue.table_name}.due_date <=")
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  issues.each {|issue| assert(issue.due_date <= (Date.today - 10))}
                end
                def test_operator_in
                  Issue.find(7).update_attribute(:due_date, (Date.today + 2))
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', 't+', ['2'])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  issues.each {|issue| assert_equal((Date.today + 2), issue.due_date)}
                end
                def test_operator_ago
                  Issue.find(7).update_attribute(:due_date, (Date.today - 3))
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', 't-', ['3'])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  issues.each {|issue| assert_equal((Date.today - 3), issue.due_date)}
                end
                def test_operator_today
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', 't', [''])
                  issues = find_issues_with_query(query)
                  assert !issues.empty?
                  issues.each {|issue| assert_equal Date.today, issue.due_date}
                end
                def test_operator_this_week_on_date
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', 'w', [''])
                  find_issues_with_query(query)
                end
                def test_operator_this_week_on_datetime
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('created_on', 'w', [''])
                  find_issues_with_query(query)
                end
                def test_operator_contains
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('subject', '~', ['uNable'])
                  assert query.statement.include?("LOWER(#{Issue.table_name}.subject) LIKE '%unable%'")
                  result = find_issues_with_query(query)
                  assert result.empty?
                  result.each {|issue| assert issue.subject.downcase.include?('unable') }
                end
                def test_range_for_this_week_with_week_starting_on_monday
                  I18n.locale = :fr
                  assert_equal '1', I18n.t(:general_first_day_of_week)
                  Date.stubs(:today).returns(Date.parse('2011-04-29'))
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', 'w', [''])
                  assert query.statement.match(/issues\.due_date > '2011-04-24 23:59:59(\.9+)?' AND issues\.due_date <= '2011-05-01 23:59:59(\.9+)?/), "range not found in #{query.statement}"
                  I18n.locale = :en
                end
                def test_range_for_this_week_with_week_starting_on_sunday
                  I18n.locale = :en
                  assert_equal '7', I18n.t(:general_first_day_of_week)
                  Date.stubs(:today).returns(Date.parse('2011-04-29'))
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('due_date', 'w', [''])
                  assert query.statement.match(/issues\.due_date > '2011-04-23 23:59:59(\.9+)?' AND issues\.due_date <= '2011-04-30 23:59:59(\.9+)?/), "range not found in #{query.statement}"
                end
                def test_operator_does_not_contains
                  query = Query.new(:project => Project.find(1), :name => '_')
                  query.add_filter('subject', '!~', ['uNable'])
                  assert query.statement.include?("LOWER(#{Issue.table_name}.subject) NOT LIKE '%unable%'")
                  find_issues_with_query(query)
                end
                def test_filter_assigned_to_me
                  user = User.find(2)
                  group = Group.find(10)
                  User.current = user
                  i1 = Issue.generate!(:project_id => 1, :tracker_id => 1, :assigned_to => user)
                  i2 = Issue.generate!(:project_id => 1, :tracker_id => 1, :assigned_to => group)
                  i3 = Issue.generate!(:project_id => 1, :tracker_id => 1, :assigned_to => Group.find(11))
                  group.users << user
                  query = Query.new(:name => '_', :filters => { 'assigned_to_id' => {:operator => '=', :values => ['me']}})
                  result = query.issues
                  assert_equal Issue.visible.all(:conditions => {:assigned_to_id => ([2] + user.reload.group_ids)}).sort_by(&:id), result.sort_by(&:id)
                  assert result.include?(i1)
                  assert result.include?(i2)
                  assert !result.include?(i3)
                end
                def test_user_custom_field_filtered_on_me
                  User.current = User.find(2)
                  cf = IssueCustomField.create!(:field_format => 'user', :is_for_all => true, :is_filter => true, :name => 'User custom field', :tracker_ids => [1])
                  issue1 = Issue.create!(:project_id => 1, :tracker_id => 1, :custom_field_values => {cf.id.to_s => '2'}, :subject => 'Test', :author_id => 1)
                  issue2 = Issue.generate!(:project_id => 1, :tracker_id => 1, :custom_field_values => {cf.id.to_s => '3'})
                  query = Query.new(:name => '_', :project => Project.find(1))
                  filter = query.available_filters["cf_#{cf.id}"]
                  assert_not_nil filter
                  assert_include 'me', filter[:values].map{|v| v[1]}
                  query.filters = { "cf_#{cf.id}" => {:operator => '=', :values => ['me']}}
                  result = query.issues
                  assert_equal 1, result.size
                  assert_equal issue1, result.first
                end
                def test_filter_my_projects
                  User.current = User.find(2)
                  query = Query.new(:name => '_')
                  filter = query.available_filters['project_id']
                  assert_not_nil filter
                  assert_include 'mine', filter[:values].map{|v| v[1]}
                  query.filters = { 'project_id' => {:operator => '=', :values => ['mine']}}
                  result = query.issues
                  assert_nil result.detect {|issue| !User.current.member_of?(issue.project)}
                end
                def test_filter_watched_issues
                  User.current = User.find(1)
                  query = Query.new(:name => '_', :filters => { 'watcher_id' => {:operator => '=', :values => ['me']}})
                  result = find_issues_with_query(query)
                  assert_not_nil result
                  assert !result.empty?
                  assert_equal Issue.visible.watched_by(User.current).sort_by(&:id), result.sort_by(&:id)
                  User.current = nil
                end
                def test_filter_unwatched_issues
                  User.current = User.find(1)
                  query = Query.new(:name => '_', :filters => { 'watcher_id' => {:operator => '!', :values => ['me']}})
                  result = find_issues_with_query(query)
                  assert_not_nil result
                  assert !result.empty?
                  assert_equal((Issue.visible - Issue.watched_by(User.current)).sort_by(&:id).size, result.sort_by(&:id).size)
                  User.current = nil
                end
                def test_filter_on_project_custom_field
                  field = ProjectCustomField.create!(:name => 'Client', :is_filter => true, :field_format => 'string')
                  CustomValue.create!(:custom_field => field, :customized => Project.find(3), :value => 'Foo')
                  CustomValue.create!(:custom_field => field, :customized => Project.find(5), :value => 'Foo')
                  query = Query.new(:name => '_')
                  filter_name = "project.cf_#{field.id}"
                  assert_include filter_name, query.available_filters.keys
                  query.filters = {filter_name => {:operator => '=', :values => ['Foo']}}
                  assert_equal [3, 5], find_issues_with_query(query).map(&:project_id).uniq.sort
                end
                def test_filter_on_author_custom_field
                  field = UserCustomField.create!(:name => 'Client', :is_filter => true, :field_format => 'string')
                  CustomValue.create!(:custom_field => field, :customized => User.find(3), :value => 'Foo')
                  query = Query.new(:name => '_')
                  filter_name = "author.cf_#{field.id}"
                  assert_include filter_name, query.available_filters.keys
                  query.filters = {filter_name => {:operator => '=', :values => ['Foo']}}
                  assert_equal [3], find_issues_with_query(query).map(&:author_id).uniq.sort
                end
                def test_filter_on_assigned_to_custom_field
                  field = UserCustomField.create!(:name => 'Client', :is_filter => true, :field_format => 'string')
                  CustomValue.create!(:custom_field => field, :customized => User.find(3), :value => 'Foo')
                  query = Query.new(:name => '_')
                  filter_name = "assigned_to.cf_#{field.id}"
                  assert_include filter_name, query.available_filters.keys
                  query.filters = {filter_name => {:operator => '=', :values => ['Foo']}}
                  assert_equal [3], find_issues_with_query(query).map(&:assigned_to_id).uniq.sort
                end
                def test_filter_on_fixed_version_custom_field
                  field = VersionCustomField.create!(:name => 'Client', :is_filter => true, :field_format => 'string')
                  CustomValue.create!(:custom_field => field, :customized => Version.find(2), :value => 'Foo')
                  query = Query.new(:name => '_')
                  filter_name = "fixed_version.cf_#{field.id}"
                  assert_include filter_name, query.available_filters.keys
                  query.filters = {filter_name => {:operator => '=', :values => ['Foo']}}
                  assert_equal [2], find_issues_with_query(query).map(&:fixed_version_id).uniq.sort
                end
                def test_filter_on_relations_with_a_specific_issue
                  IssueRelation.delete_all
                  IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(1), :issue_to => Issue.find(2))
                  IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(3), :issue_to => Issue.find(1))
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '=', :values => ['1']}}
                  assert_equal [2, 3], find_issues_with_query(query).map(&:id).sort
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '=', :values => ['2']}}
                  assert_equal [1], find_issues_with_query(query).map(&:id).sort
                end
                def test_filter_on_relations_with_any_issues_in_a_project
                  IssueRelation.delete_all
                  with_settings :cross_project_issue_relations => '1' do
                    IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(1), :issue_to => Project.find(2).issues.first)
                    IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(2), :issue_to => Project.find(2).issues.first)
                    IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(1), :issue_to => Project.find(3).issues.first)
                  end
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '=p', :values => ['2']}}
                  assert_equal [1, 2], find_issues_with_query(query).map(&:id).sort
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '=p', :values => ['3']}}
                  assert_equal [1], find_issues_with_query(query).map(&:id).sort
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '=p', :values => ['4']}}
                  assert_equal [], find_issues_with_query(query).map(&:id).sort
                end
                def test_filter_on_relations_with_any_issues_not_in_a_project
                  IssueRelation.delete_all
                  with_settings :cross_project_issue_relations => '1' do
                    IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(1), :issue_to => Project.find(2).issues.first)
                    #IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(2), :issue_to => Project.find(1).issues.first)
                    IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(1), :issue_to => Project.find(3).issues.first)
                  end
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '=!p', :values => ['1']}}
                  assert_equal [1], find_issues_with_query(query).map(&:id).sort
                end
                def test_filter_on_relations_with_no_issues_in_a_project
                  IssueRelation.delete_all
                  with_settings :cross_project_issue_relations => '1' do
                    IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(1), :issue_to => Project.find(2).issues.first)
                    IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(2), :issue_to => Project.find(3).issues.first)
                    IssueRelation.create!(:relation_type => "relates", :issue_to => Project.find(2).issues.first, :issue_from => Issue.find(3))
                  end
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '!p', :values => ['2']}}
                  ids = find_issues_with_query(query).map(&:id).sort
                  assert_include 2, ids
                  assert_not_include 1, ids
                  assert_not_include 3, ids
                end
                def test_filter_on_relations_with_no_issues
                  IssueRelation.delete_all
                  IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(1), :issue_to => Issue.find(2))
                  IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(3), :issue_to => Issue.find(1))
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '!*', :values => ['']}}
                  ids = find_issues_with_query(query).map(&:id)
                  assert_equal [], ids & [1, 2, 3]
                  assert_include 4, ids
                end
                def test_filter_on_relations_with_any_issues
                  IssueRelation.delete_all
                  IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(1), :issue_to => Issue.find(2))
                  IssueRelation.create!(:relation_type => "relates", :issue_from => Issue.find(3), :issue_to => Issue.find(1))
                  query = Query.new(:name => '_')
                  query.filters = {"relates" => {:operator => '*', :values => ['']}}
                  assert_equal [1, 2, 3], find_issues_with_query(query).map(&:id).sort
                end
                def test_statement_should_be_nil_with_no_filters
                  q = Query.new(:name => '_')
                  q.filters = {}
                  assert q.valid?
                  assert_nil q.statement
                end
                def test_default_columns
                  q = Query.new
                  assert !q.columns.empty?
                end
                def test_set_column_names
                  q = Query.new
                  q.column_names = ['tracker', :subject, '', 'unknonw_column']
                  assert_equal [:tracker, :subject], q.columns.collect {|c| c.name}
                  c = q.columns.first
                  assert q.has_column?(c)
                end
                def test_query_should_preload_spent_hours
                  q = Query.new(:name => '_', :column_names => [:subject, :spent_hours])
                  assert q.has_column?(:spent_hours)
                  issues = q.issues
                  assert_not_nil issues.first.instance_variable_get("@spent_hours")
                end
                def test_groupable_columns_should_include_custom_fields
                  q = Query.new
                  column = q.groupable_columns.detect {|c| c.name == :cf_1}
                  assert_not_nil column
                  assert_kind_of QueryCustomFieldColumn, column
                end
                def test_groupable_columns_should_not_include_multi_custom_fields
                  field = CustomField.find(1)
                  field.update_attribute :multiple, true
                  q = Query.new
                  column = q.groupable_columns.detect {|c| c.name == :cf_1}
                  assert_nil column
                end
                def test_groupable_columns_should_include_user_custom_fields
                  cf = IssueCustomField.create!(:name => 'User', :is_for_all => true, :tracker_ids => [1], :field_format => 'user')
                  q = Query.new
                  assert q.groupable_columns.detect {|c| c.name == "cf_#{cf.id}".to_sym}
                end
                def test_groupable_columns_should_include_version_custom_fields
                  cf = IssueCustomField.create!(:name => 'User', :is_for_all => true, :tracker_ids => [1], :field_format => 'version')
                  q = Query.new
                  assert q.groupable_columns.detect {|c| c.name == "cf_#{cf.id}".to_sym}
                end
                def test_grouped_with_valid_column
                  q = Query.new(:group_by => 'status')
                  assert q.grouped?
                  assert_not_nil q.group_by_column
                  assert_equal :status, q.group_by_column.name
                  assert_not_nil q.group_by_statement
                  assert_equal 'status', q.group_by_statement
                end
                def test_grouped_with_invalid_column
                  q = Query.new(:group_by => 'foo')
                  assert !q.grouped?
                  assert_nil q.group_by_column
                  assert_nil q.group_by_statement
                end
                def test_sortable_columns_should_sort_assignees_according_to_user_format_setting
                  with_settings :user_format => 'lastname_coma_firstname' do
                    q = Query.new
                    assert q.sortable_columns.has_key?('assigned_to')
                    assert_equal %w(users.lastname users.firstname users.id), q.sortable_columns['assigned_to']
                  end
                end
                def test_sortable_columns_should_sort_authors_according_to_user_format_setting
                  with_settings :user_format => 'lastname_coma_firstname' do
                    q = Query.new
                    assert q.sortable_columns.has_key?('author')
                    assert_equal %w(authors.lastname authors.firstname authors.id), q.sortable_columns['author']
                  end
                end
                def test_sortable_columns_should_include_custom_field
                  q = Query.new
                  assert q.sortable_columns['cf_1']
                end
                def test_sortable_columns_should_not_include_multi_custom_field
                  field = CustomField.find(1)
                  field.update_attribute :multiple, true
                  q = Query.new
                  assert !q.sortable_columns['cf_1']
                end
                def test_default_sort
                  q = Query.new
                  assert_equal [], q.sort_criteria
                end
                def test_set_sort_criteria_with_hash
                  q = Query.new
                  q.sort_criteria = {'0' => ['priority', 'desc'], '2' => ['tracker']}
                  assert_equal [['priority', 'desc'], ['tracker', 'asc']], q.sort_criteria
                end
                def test_set_sort_criteria_with_array
                  q = Query.new
                  q.sort_criteria = [['priority', 'desc'], 'tracker']
                  assert_equal [['priority', 'desc'], ['tracker', 'asc']], q.sort_criteria
                end
                def test_create_query_with_sort
                  q = Query.new(:name => 'Sorted')
                  q.sort_criteria = [['priority', 'desc'], 'tracker']
                  assert q.save
                  q.reload
                  assert_equal [['priority', 'desc'], ['tracker', 'asc']], q.sort_criteria
                end
                def test_sort_by_string_custom_field_asc
                  q = Query.new
                  c = q.available_columns.find {|col| col.is_a?(QueryCustomFieldColumn) && col.custom_field.field_format == 'string' }
                  assert c
                  assert c.sortable
                  issues = Issue.includes([:assigned_to, :status, :tracker, :project, :priority]).where(
                       q.statement
                     ).order("#{c.sortable} ASC").all
                  values = issues.collect {|i| i.custom_value_for(c.custom_field).to_s}
                  assert !values.empty?
                  assert_equal values.sort, values
                end
                def test_sort_by_string_custom_field_desc
                  q = Query.new
                  c = q.available_columns.find {|col| col.is_a?(QueryCustomFieldColumn) && col.custom_field.field_format == 'string' }
                  assert c
                  assert c.sortable
                  issues = Issue.includes([:assigned_to, :status, :tracker, :project, :priority]).where(
                       q.statement
                     ).order("#{c.sortable} DESC").all
                  values = issues.collect {|i| i.custom_value_for(c.custom_field).to_s}
                  assert !values.empty?
                  assert_equal values.sort.reverse, values
                end
                def test_sort_by_float_custom_field_asc
                  q = Query.new
                  c = q.available_columns.find {|col| col.is_a?(QueryCustomFieldColumn) && col.custom_field.field_format == 'float' }
                  assert c
                  assert c.sortable
                  issues = Issue.includes([:assigned_to, :status, :tracker, :project, :priority]).where(
                       q.statement
                     ).order("#{c.sortable} ASC").all
                  values = issues.collect {|i| begin; Kernel.Float(i.custom_value_for(c.custom_field).to_s); rescue; nil; end}.compact
                  assert !values.empty?
                  assert_equal values.sort, values
                end
                def test_invalid_query_should_raise_query_statement_invalid_error
                  q = Query.new
                  assert_raise Query::StatementInvalid do
                    q.issues(:conditions => "foo = 1")
                  end
                end
                def test_issue_count
                  q = Query.new(:name => '_')
                  issue_count = q.issue_count
                  assert_equal q.issues.size, issue_count
                end
                def test_issue_count_with_archived_issues
                  p = Project.generate! do |project|
                    project.status = Project::STATUS_ARCHIVED
                  end
                  i = Issue.generate!( :project => p, :tracker => p.trackers.first )
                  assert !i.visible?
                  test_issue_count
                end
                def test_issue_count_by_association_group
                  q = Query.new(:name => '_', :group_by => 'assigned_to')
                  count_by_group = q.issue_count_by_group
                  assert_kind_of Hash, count_by_group
                  assert_equal %w(NilClass User), count_by_group.keys.collect {|k| k.class.name}.uniq.sort
                  assert_equal %w(Fixnum), count_by_group.values.collect {|k| k.class.name}.uniq
                  assert count_by_group.has_key?(User.find(3))
                end
                def test_issue_count_by_list_custom_field_group
                  q = Query.new(:name => '_', :group_by => 'cf_1')
                  count_by_group = q.issue_count_by_group
                  assert_kind_of Hash, count_by_group
                  assert_equal %w(NilClass String), count_by_group.keys.collect {|k| k.class.name}.uniq.sort
                  assert_equal %w(Fixnum), count_by_group.values.collect {|k| k.class.name}.uniq
                  assert count_by_group.has_key?('MySQL')
                end
                def test_issue_count_by_date_custom_field_group
                  q = Query.new(:name => '_', :group_by => 'cf_8')
                  count_by_group = q.issue_count_by_group
                  assert_kind_of Hash, count_by_group
                  assert_equal %w(Date NilClass), count_by_group.keys.collect {|k| k.class.name}.uniq.sort
                  assert_equal %w(Fixnum), count_by_group.values.collect {|k| k.class.name}.uniq
                end
                def test_issue_count_with_nil_group_only
                  Issue.update_all("assigned_to_id = NULL")
                  q = Query.new(:name => '_', :group_by => 'assigned_to')
                  count_by_group = q.issue_count_by_group
                  assert_kind_of Hash, count_by_group
                  assert_equal 1, count_by_group.keys.size
                  assert_nil count_by_group.keys.first
                end
                def test_issue_ids
                  q = Query.new(:name => '_')
                  order = "issues.subject, issues.id"
                  issues = q.issues(:order => order)
                  assert_equal issues.map(&:id), q.issue_ids(:order => order)
                end
                def test_label_for
                  set_language_if_valid 'en'
                  q = Query.new
                  assert_equal 'Assignee', q.label_for('assigned_to_id')
                end
                def test_label_for_fr
                  set_language_if_valid 'fr'
                  q = Query.new
                  s = "Assign\xc3\xa9 \xc3\xa0"
                  s.force_encoding('UTF-8') if s.respond_to?(:force_encoding)
                  assert_equal s, q.label_for('assigned_to_id')
                end
                def test_editable_by
                  admin = User.find(1)
                  manager = User.find(2)
                  developer = User.find(3)
                  # Public query on project 1
                  q = Query.find(1)
                  assert q.editable_by?(admin)
                  assert q.editable_by?(manager)
                  assert !q.editable_by?(developer)
                  # Private query on project 1
                  q = Query.find(2)
                  assert q.editable_by?(admin)
                  assert !q.editable_by?(manager)
                  assert q.editable_by?(developer)
                  # Private query for all projects
                  q = Query.find(3)
                  assert q.editable_by?(admin)
                  assert !q.editable_by?(manager)
                  assert q.editable_by?(developer)
                  # Public query for all projects
                  q = Query.find(4)
                  assert q.editable_by?(admin)
                  assert !q.editable_by?(manager)
                  assert !q.editable_by?(developer)
                end
                def test_visible_scope
                  query_ids = Query.visible(User.anonymous).map(&:id)
                  assert query_ids.include?(1), 'public query on public project was not visible'
                  assert query_ids.include?(4), 'public query for all projects was not visible'
                  assert !query_ids.include?(2), 'private query on public project was visible'
                  assert !query_ids.include?(3), 'private query for all projects was visible'
                  assert !query_ids.include?(7), 'public query on private project was visible'
                end
                context "#available_filters" do
                  setup do
                    @query = Query.new(:name => "_")
                  end
                  should "include users of visible projects in cross-project view" do
                    users = @query.available_filters["assigned_to_id"]
                    assert_not_nil users
                    assert users[:values].map{|u|u[1]}.include?("3")
                  end
                  should "include users of subprojects" do
                    user1 = User.generate!
                    user2 = User.generate!
                    project = Project.find(1)
                    Member.create!(:principal => user1, :project => project.children.visible.first, :role_ids => [1])
                    @query.project = project
                    users = @query.available_filters["assigned_to_id"]
                    assert_not_nil users
                    assert users[:values].map{|u|u[1]}.include?(user1.id.to_s)
                    assert !users[:values].map{|u|u[1]}.include?(user2.id.to_s)
                  end
                  should "include visible projects in cross-project view" do
                    projects = @query.available_filters["project_id"]
                    assert_not_nil projects
                    assert projects[:values].map{|u|u[1]}.include?("1")
                  end
                  context "'member_of_group' filter" do
                    should "be present" do
                      assert @query.available_filters.keys.include?("member_of_group")
                    end
                    should "be an optional list" do
                      assert_equal :list_optional, @query.available_filters["member_of_group"][:type]
                    end
                    should "have a list of the groups as values" do
                      Group.destroy_all # No fixtures
                      group1 = Group.generate!.reload
                      group2 = Group.generate!.reload
                      expected_group_list = [
                                             [group1.name, group1.id.to_s],
                                             [group2.name, group2.id.to_s]
                                            ]
                      assert_equal expected_group_list.sort, @query.available_filters["member_of_group"][:values].sort
                    end
                  end
                  context "'assigned_to_role' filter" do
                    should "be present" do
                      assert @query.available_filters.keys.include?("assigned_to_role")
                    end
                    should "be an optional list" do
                      assert_equal :list_optional, @query.available_filters["assigned_to_role"][:type]
                    end
                    should "have a list of the Roles as values" do
                      assert @query.available_filters["assigned_to_role"][:values].include?(['Manager','1'])
                      assert @query.available_filters["assigned_to_role"][:values].include?(['Developer','2'])
                      assert @query.available_filters["assigned_to_role"][:values].include?(['Reporter','3'])
                    end
                    should "not include the built in Roles as values" do
                      assert ! @query.available_filters["assigned_to_role"][:values].include?(['Non member','4'])
                      assert ! @query.available_filters["assigned_to_role"][:values].include?(['Anonymous','5'])
                    end
                  end
                end
                context "#statement" do
                  context "with 'member_of_group' filter" do
                    setup do
                      Group.destroy_all # No fixtures
                      @user_in_group = User.generate!
                      @second_user_in_group = User.generate!
                      @user_in_group2 = User.generate!
                      @user_not_in_group = User.generate!
                      @group = Group.generate!.reload
                      @group.users << @user_in_group
                      @group.users << @second_user_in_group
                      @group2 = Group.generate!.reload
                      @group2.users << @user_in_group2
                    end
                    should "search assigned to for users in the group" do
                      @query = Query.new(:name => '_')
                      @query.add_filter('member_of_group', '=', [@group.id.to_s])
                      assert_query_statement_includes @query, "#{Issue.table_name}.assigned_to_id IN ('#{@user_in_group.id}','#{@second_user_in_group.id}')"
                      assert_find_issues_with_query_is_successful @query
                    end
                    should "search not assigned to any group member (none)" do
                      @query = Query.new(:name => '_')
                      @query.add_filter('member_of_group', '!*', [''])
                      # Users not in a group
                      assert_query_statement_includes @query, "#{Issue.table_name}.assigned_to_id IS NULL OR #{Issue.table_name}.assigned_to_id NOT IN ('#{@user_in_group.id}','#{@second_user_in_group.id}','#{@user_in_group2.id}')"
                      assert_find_issues_with_query_is_successful @query
                    end
                    should "search assigned to any group member (all)" do
                      @query = Query.new(:name => '_')
                      @query.add_filter('member_of_group', '*', [''])
                      # Only users in a group
                      assert_query_statement_includes @query, "#{Issue.table_name}.assigned_to_id IN ('#{@user_in_group.id}','#{@second_user_in_group.id}','#{@user_in_group2.id}')"
                      assert_find_issues_with_query_is_successful @query
                    end
                    should "return an empty set with = empty group" do
                      @empty_group = Group.generate!
                      @query = Query.new(:name => '_')
                      @query.add_filter('member_of_group', '=', [@empty_group.id.to_s])
                      assert_equal [], find_issues_with_query(@query)
                    end
                    should "return issues with ! empty group" do
                      @empty_group = Group.generate!
                      @query = Query.new(:name => '_')
                      @query.add_filter('member_of_group', '!', [@empty_group.id.to_s])
                      assert_find_issues_with_query_is_successful @query
                    end
                  end
                  context "with 'assigned_to_role' filter" do
                    setup do
                      @manager_role = Role.find_by_name('Manager')
                      @developer_role = Role.find_by_name('Developer')
                      @project = Project.generate!
                      @manager = User.generate!
                      @developer = User.generate!
                      @boss = User.generate!
                      @guest = User.generate!
                      User.add_to_project(@manager, @project, @manager_role)
                      User.add_to_project(@developer, @project, @developer_role)
                      User.add_to_project(@boss, @project, [@manager_role, @developer_role])
                      @issue1 = Issue.generate!(:project => @project, :assigned_to_id => @manager.id)
                      @issue2 = Issue.generate!(:project => @project, :assigned_to_id => @developer.id)
                      @issue3 = Issue.generate!(:project => @project, :assigned_to_id => @boss.id)
                      @issue4 = Issue.generate!(:project => @project, :assigned_to_id => @guest.id)
                      @issue5 = Issue.generate!(:project => @project)
                    end
                    should "search assigned to for users with the Role" do
                      @query = Query.new(:name => '_', :project => @project)
                      @query.add_filter('assigned_to_role', '=', [@manager_role.id.to_s])
                      assert_query_result [@issue1, @issue3], @query
                    end
                    should "search assigned to for users with the Role on the issue project" do
                      other_project = Project.generate!
                      User.add_to_project(@developer, other_project, @manager_role)
                      @query = Query.new(:name => '_', :project => @project)
                      @query.add_filter('assigned_to_role', '=', [@manager_role.id.to_s])
                      assert_query_result [@issue1, @issue3], @query
                    end
                    should "return an empty set with empty role" do
                      @empty_role = Role.generate!
                      @query = Query.new(:name => '_', :project => @project)
                      @query.add_filter('assigned_to_role', '=', [@empty_role.id.to_s])
                      assert_query_result [], @query
                    end
                    should "search assigned to for users without the Role" do
                      @query = Query.new(:name => '_', :project => @project)
                      @query.add_filter('assigned_to_role', '!', [@manager_role.id.to_s])
                      assert_query_result [@issue2, @issue4, @issue5], @query
                    end
                    should "search assigned to for users not assigned to any Role (none)" do
                      @query = Query.new(:name => '_', :project => @project)
                      @query.add_filter('assigned_to_role', '!*', [''])
                      assert_query_result [@issue4, @issue5], @query
                    end
                    should "search assigned to for users assigned to any Role (all)" do
                      @query = Query.new(:name => '_', :project => @project)
                      @query.add_filter('assigned_to_role', '*', [''])
                      assert_query_result [@issue1, @issue2, @issue3], @query
                    end
                    should "return issues with ! empty role" do
                      @empty_role = Role.generate!
                      @query = Query.new(:name => '_', :project => @project)
                      @query.add_filter('assigned_to_role', '!', [@empty_role.id.to_s])
                      assert_query_result [@issue1, @issue2, @issue3, @issue4, @issue5], @query
                    end
                  end
                end
              end

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