Redmine

    end

  end

  def issue_spent_hours_details(issue)

    if issue.total_spent_hours > 0

      path = project_time_entries_path(issue.project, :issue_id => "~#{issue.id}")

        value = find_name_by_reflection(field, detail.value)

        old_value = find_name_by_reflection(field, detail.old_value)

        value = l_hours_short(detail.value.to_f) unless detail.value.blank?

        old_value = l_hours_short(detail.old_value.to_f) unless detail.old_value.blank?

  validates_length_of :subject, :maximum => 255

  validates_inclusion_of :done_ratio, :in => 0..100

  validates :estimated_hours, :numericality => {:greater_than_or_equal_to => 0, :allow_nil => true, :message => :invalid}

  validates :start_date, :date => true

  validates :due_date, :date => true

  validate :validate_issue, :validate_required_fields, :validate_permissions

  before_validation :default_assign, on: :create

  before_validation :clear_disabled_fields

  before_save :close_duplicates, :update_done_ratio_from_issue_status,

  after_save do |issue|

    if !issue.saved_change_to_id? && issue.saved_change_to_project_id?

      issue.send :after_project_change

    @spent_hours = nil

    @total_spent_hours = nil

    @total_estimated_hours = nil

    @last_updated_by = nil

    @last_notes = nil

    base_reload(*args)

    write_attribute :estimated_hours, (h.is_a?(String) ? (h.to_hours || h) : h)

  end

  safe_attributes(

    'project_id',

    'tracker_id',

    'due_date',

    'done_ratio',

    'estimated_hours',

    'custom_field_values',

    'custom_fields',

    'lock_version',

    end

  end

  def relations

    @relations ||= IssueRelation::Relations.new(self, (relations_from + relations_to).sort)

  end

    end

  end

  # Saves the changes in a Journal

  # Called after_save

  def create_journal

    roles = user.admin ? Role.all.to_a : user.roles_for_project(project)

    roles.select(&:consider_workflow?)

  end

end

    if estimated_hours = row_value(row, 'estimated_hours')

      attributes['estimated_hours'] = estimated_hours

    end

    if done_ratio = row_value(row, 'done_ratio')

      attributes['done_ratio'] = done_ratio

    end

    QueryColumn.new(:due_date, :sortable => "#{Issue.table_name}.due_date", :groupable => true),

    QueryColumn.new(:estimated_hours, :sortable => "#{Issue.table_name}.estimated_hours",

                    :totalable => true),

    EstimatedRemainingHoursColumn.new,

    QueryColumn.new(

      :total_estimated_hours,

          " AND subtasks.rgt <= #{Issue.table_name}.rgt), 0)"

        end,

      :default_order => 'desc'),

    QueryColumn.new(:done_ratio, :sortable => "#{Issue.table_name}.done_ratio", :groupable => true),

    TimestampQueryColumn.new(:created_on, :sortable => "#{Issue.table_name}.created_on",

                             :default_order => 'desc', :groupable => true),

    add_available_filter "start_date", :type => :date

    add_available_filter "due_date", :type => :date

    add_available_filter "estimated_hours", :type => :float

    if User.current.allowed_to?(:view_time_entries, project, :global => true)

      add_available_filter "spent_time", :type => :float, :label => :label_spent_time

    map_total(scope.sum(EstimatedRemainingHoursColumn::COLUMN_SQL)) {|t| t.to_f.round(2)}

  end

  # Returns sum of all the issue's time entries hours

  def total_for_spent_hours(scope)

    total = scope.joins(:time_entries).

      'start_date' => get_keyword(:start_date, :format => '\d{4}-\d{2}-\d{2}'),

      'due_date' => get_keyword(:due_date, :format => '\d{4}-\d{2}-\d{2}'),

      'estimated_hours' => get_keyword(:estimated_hours),

      'done_ratio' => get_keyword(:done_ratio, :format => '(\d|10)?0'),

      'is_private' => get_keyword_bool(:is_private),

      'parent_issue_id' => get_keyword(:parent_issue)

  CORE_FIELDS_UNDISABLABLE = %w(project_id tracker_id subject is_private).freeze

  # Fields that can be disabled

  # Other (future) fields should be appended, not inserted!

  CORE_FIELDS_ALL = (CORE_FIELDS_UNDISABLABLE + CORE_FIELDS).freeze

  before_destroy :check_integrity

  <label for="import_mapping_estimated_hours"><%= l(:field_estimated_hours) %></label>

  <%= mapping_select_tag @import, 'estimated_hours' %>

</p>

<p>

  <label for="import_mapping_done_ratio"><%= l(:field_done_ratio) %></label>

  <%= mapping_select_tag @import, 'done_ratio' %>

</p>

<% end %>

<% if @issue.safe_attribute? 'estimated_hours' %>

<p><%= f.hours_field :estimated_hours, :size => 3, :required => @issue.required_attribute?('estimated_hours') %> <%= l(:field_hours) %></p>

<% end %>

<% end %>

</div>

</div>

</p>

<% end %>

<% if @safe_attributes.include?('done_ratio') && Issue.use_field_for_done_ratio? %>

<p>

  <label for='issue_done_ratio'><%= l(:field_done_ratio) %></label>

      api.done_ratio  issue.done_ratio

      api.is_private  issue.is_private

      api.estimated_hours issue.estimated_hours

      api.total_estimated_hours issue.total_estimated_hours

      if User.current.allowed_to?(:view_time_entries, issue.project)

        api.spent_hours(issue.spent_hours)

  api.done_ratio @issue.done_ratio

  api.is_private @issue.is_private

  api.estimated_hours @issue.estimated_hours

  api.total_estimated_hours @issue.total_estimated_hours

  if User.current.allowed_to?(:view_time_entries, @project)

    api.spent_hours(@issue.spent_hours)

    api.total_spent_hours(@issue.total_spent_hours)

  unless @issue.disabled_core_fields.include?('estimated_hours')

    rows.right l(:field_estimated_hours), issue_estimated_hours_details(@issue), :class => 'estimated-hours'

  end

  if User.current.allowed_to?(:view_time_entries, @project) && @issue.total_spent_hours > 0

    rows.right l(:label_spent_time), issue_spent_hours_details(@issue), :class => 'spent-time'

  end

  field_full_width_layout: Full width layout

  field_digest: Checksum

  field_default_assigned_to: Default assignee

  field_recently_used_projects: Number of recently used projects in jump box

  field_history_default_tab: Issue's history default tab

  field_unique_id: Unique ID

X-Mailer: Microsoft Outlook Express 6.00.2900.2869

X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869

platea dictumst.

Project: onlinestore

Assigned to: John Smith

fixed version: alpha

estimated hours: 2.5

done ratio: 30

parent issue: 4

This paragraph is after the delimiter so it shouldn't appear.

pulvinar dui, a gravida orci mi eget odio. Nunc a lacus.

    assert_equal hours.sort.reverse, hours

  end

  def test_index_sort_by_user_custom_field

    cf = IssueCustomField.

           create!(

    assert_select 'table.issues td.total_estimated_hours'

  end

  def test_index_should_not_show_spent_hours_column_without_permission

    Role.anonymous.remove_permission! :view_time_entries

    get(

    assert_select 'input[type=checkbox][name=?][value=estimated_hours][checked=checked]', 't[]'

  end

  def test_index_with_grouped_query_and_estimated_hours_total

    Issue.delete_all

    Issue.generate!(:estimated_hours => '5:30', :category_id => 1)

              :priority_id => 5,

              :start_date => '2010-11-07',

              :estimated_hours => '',

              :custom_field_values => {

                '2' => 'Value for field 2'

              }

    assert_equal 2, issue.status_id

    assert_equal Date.parse('2010-11-07'), issue.start_date

    assert_nil issue.estimated_hours

    v = issue.custom_values.where(:custom_field_id => 2).first

    assert_not_nil v

    assert_equal 'Value for field 2', v.value

    assert_equal 4.25, Issue.find(2).estimated_hours

  end

  def test_bulk_update_custom_field

    @request.session[:user_id] = 2

    # update issues priority

    assert_match '6:18', show_detail(detail, true)

  end

  test 'show_detail should not show values with a description attribute' do

    detail = JournalDetail.new(:property => 'attr', :prop_key => 'description',

                               :old_value => 'Foo', :value => 'Bar')

    end

  end

    parent = Issue.find(3)

    parent.update_columns :estimated_hours => 2.0

    TimeEntry.create!(:project => child.project, :issue => child, :user => child.author, :spent_on => child.author.today,

                      :hours => '2.5', :comments => '', :activity_id => TimeEntryActivity.first.id)

    get '/issues/3.xml'

    assert_select 'issue' do

      assert_select 'estimated_hours',       parent.estimated_hours.to_s

      assert_select 'total_estimated_hours', (parent.estimated_hours.to_f + 3.0).to_s

      assert_select 'spent_hours',           parent.spent_hours.to_s

      assert_select 'total_spent_hours',     (parent.spent_hours.to_f + 2.5).to_s

    end

  end

    parent = Issue.find(3)

    parent.update_columns :estimated_hours => 2.0

    Role.anonymous.remove_permission! :view_time_entries

    get '/issues/3.xml'

    assert_select 'issue' do

      assert_select 'estimated_hours',       parent.estimated_hours.to_s

      assert_select 'total_estimated_hours', (parent.estimated_hours.to_f + 3.0).to_s

      assert_select 'spent_hours',           false

      assert_select 'total_spent_hours',     false

    end

    end

  end

    parent = Issue.find(3)

    parent.update_columns :estimated_hours => 2.0

    TimeEntry.create!(:project => child.project, :issue => child, :user => child.author, :spent_on => child.author.today,

                      :hours => '2.5', :comments => '', :activity_id => TimeEntryActivity.first.id)

    get '/issues/3.json'

    json = ActiveSupport::JSON.decode(response.body)

    assert_equal parent.estimated_hours, json['issue']['estimated_hours']

    assert_equal (parent.estimated_hours.to_f + 3.0), json['issue']['total_estimated_hours']

    assert_equal parent.spent_hours, json['issue']['spent_hours']

    assert_equal (parent.spent_hours.to_f + 2.5), json['issue']['total_spent_hours']

  end

    parent = Issue.find(3)

    parent.update_columns :estimated_hours => 2.0

    Role.anonymous.remove_permission! :view_time_entries

    get '/issues/3.json'

    json = ActiveSupport::JSON.decode(response.body)

    assert_equal parent.estimated_hours, json['issue']['estimated_hours']

    assert_equal (parent.estimated_hours.to_f + 3.0), json['issue']['total_estimated_hours']

    assert_nil json['issue']['spent_hours']

    assert_nil json['issue']['total_spent_hours']

  end

  def test_leaf_planning_fields_should_be_editable

    issue = Issue.generate!

    user = User.find(1)

      assert issue.safe_attribute?(attribute, user)

    end

  end

    assert !child.save

    assert_include I18n.t("activerecord.errors.messages.open_issue_with_closed_parent"), child.errors.full_messages

  end

end

    issue = Issue.new(:project_id => 1, :tracker_id => 1, :author_id => 3,

                      :status_id => 1, :priority => IssuePriority.first,

                      :subject => 'test_create',

    assert issue.save

    issue.reload

    assert_equal 1.5, issue.estimated_hours

  end

  def test_create_minimal

    assert_equal issue.tracker.default_status, issue.status

    assert issue.description.nil?

    assert_nil issue.estimated_hours

  end

  def test_create_with_all_fields_disabled

    end

  end

  def test_create_with_required_custom_field

    set_language_if_valid 'en'

    field = IssueCustomField.find_by_name('Database')

    user = User.find(3)

    user.members.update_all ["mail_notification = ?", false]

    user.update! :mail_notification => 'only_assigned'

    with_settings :notified_events => %w(issue_updated) do

      issue = Issue.find(2)

    assert_equal false, issue.closing?

  end

  def test_reopening_should_return_true_when_reopening_an_issue

    issue = Issue.find(8)

    issue.status = IssueStatus.find(6)

        'ticket_on_given_project.eml',

        :allow_override =>

          ['status', 'start_date', 'due_date', 'assigned_to',

           'parent_issue']

      )

    assert issue.is_a?(Issue)

    assert_equal User.find_by_login('jsmith'), issue.assigned_to

    assert_equal Version.find_by_name('Alpha'), issue.fixed_version

    assert_equal 2.5, issue.estimated_hours

    assert_equal 30, issue.done_ratio

    assert_equal Issue.find(4), issue.parent

    # keywords should be removed from the email body

    assert !issue.description.match(/^Project:/i)

    assert !issue.description.match(/^Status:/i)

    assert !issue.description.match(/^Start Date:/i)

  end

  def test_add_issue_with_all_overrides

    assert_equal User.find_by_login('jsmith'), issue.assigned_to

    assert_equal Version.find_by_name('Alpha'), issue.fixed_version

    assert_equal 2.5, issue.estimated_hours

    assert_equal 30, issue.done_ratio

    assert_equal Issue.find(4), issue.parent

  end

    assert_nil issue.assigned_to

    assert_nil issue.fixed_version

    assert_nil issue.estimated_hours

    assert_equal 0, issue.done_ratio

    assert_nil issue.parent

  end

  def test_set_totalable_names

    q = IssueQuery.new

  end

  def test_totalable_columns_should_default_to_settings

    assert_include :estimated_remaining_hours, q.available_totalable_columns.map(&:name)

  end

  def test_available_totalable_columns_should_include_spent_hours

    User.current = User.find(1)

    )

  end

  def test_total_for_spent_hours

    TimeEntry.delete_all

    TimeEntry.generate!(:hours => 5.5)