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 {|issue| issue.send :after_project_change if !issue.id_changed? && issue.project_id_changed?}

  after_save :reschedule_following_issues, :update_nested_set_attributes,

             :update_parent_attributes, :delete_selected_attachments, :create_journal

    @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)

  end

  safe_attributes 'project_id',

    'tracker_id',

    'status_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

      self.done_ratio ||= 0

    end

  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(: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", :totalable => true),

    QueryColumn.new(:total_estimated_hours,

      :sortable => "COALESCE((SELECT SUM(estimated_hours) FROM #{Issue.table_name} subtasks" +

        " WHERE subtasks.root_id = #{Issue.table_name}.root_id AND subtasks.lft >= #{Issue.table_name}.lft AND subtasks.rgt <= #{Issue.table_name}.rgt), 0)",

      :default_order => 'desc'),

    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(:closed_on, :sortable => "#{Issue.table_name}.closed_on", :default_order => 'desc'),

    add_available_filter "start_date", :type => :date

    add_available_filter "due_date", :type => :date

    add_available_filter "estimated_hours", :type => :float

    add_available_filter "done_ratio", :type => :integer

    if User.current.allowed_to?(:set_issues_private, nil, :global => true) ||

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

  end

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

  def total_for_spent_hours(scope)

    total = if group_by_column.try(:name) == :project

      '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')

    }.delete_if {|k, v| v.blank? }

  CORE_FIELDS_UNDISABLABLE = %w(project_id tracker_id subject priority_id 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

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

</p>

<p>

  <label><%= l(:field_done_ratio) %></label>

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

</p>

</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

      render_api_custom_values issue.visible_custom_field_values, api

  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

  setting_app_title: Application title

  setting_app_subtitle: Application subtitle

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

--- This line starts with a delimiter and should not be stripped

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

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

        :f => ['tracker_id'],

        :op => {

          'tracker_id' => '='

        :v => {

          'tracker_id' => ['1']

        }

        :f => [filter_name],

        :op => {

          filter_name => '='

        :v => {

          filter_name => ['Foo']

        :c => ['project']

      }

    assert_response :success

    assert_equal hours.sort.reverse, hours

  end

  def test_index_sort_by_user_custom_field

    cf = IssueCustomField.create!(:name => 'User', :is_for_all => true, :tracker_ids => [1,2,3], :field_format => 'user')

    CustomValue.create!(:custom_field => cf, :customized => Issue.find(1), :value => '2')

    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 :index, :params => {

    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.5, :category_id => 1)

        :f => ['start_date'],

        :op => {

          :start_date => '='

        :format => 'csv'

      }

    assert_equal 'text/csv', @response.content_type

          :tracker_id => 3,

          :description => 'Prefilled',

          :custom_field_values => {

        }

      }

    assert !t.disabled_core_fields.include?('parent_issue_id')

    get :new, :params => {

      }

      }

    assert_response :success

    t.save!

    assert t.disabled_core_fields.include?('parent_issue_id')

    get :new, :params => {

      }

      }

    assert_response :success

        :issue => {

          :tracker_id => 2,

          :status_id => 1

        :was_default_status => 1

      }

    assert_response :success

        :issue => {

          :project_id => 1,

          :fixed_version_id => ''

        :form_update_triggered_by => 'issue_project_id'

      }

    assert_response :success

              :priority_id => 5,

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

              :estimated_hours => '',

              :custom_field_values => {

            }

          }

      end

    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

              :priority_id => 5,

              :estimated_hours => '',

              :custom_field_values => {

            }

          }

      end

              :priority_id => 5,

              :estimated_hours => '',

              :custom_field_values => {

            }

          }

      end

            :tracker_id => 3,

            :subject => 'This is first issue',

            :priority_id => 5

          :continue => ''

        }

    end

            :description => 'This is the description',

            :priority_id => 5,

            :custom_field_values => {

          }

        }

    end

            :description => 'This is the description',

            :priority_id => 5,

            :custom_field_values => {

          }

        }

    end

            :description => 'This is the description',

            :priority_id => 5,

            :custom_field_values => {

          }

        }

    end

            :due_date => '',

            :custom_field_values => {

              cf1.id.to_s => '', cf2.id.to_s => ''

          }

        }

      assert_response :success

            :due_date => '',

            :custom_field_values => {

              cf1.id.to_s => '', cf2.id.to_s => ['']

          }

        }

      assert_response :success

            :due_date => '2012-07-16',

            :custom_field_values => {

              cf1.id.to_s => 'value1', cf2.id.to_s => 'value2'

          }

        }

      assert_response 302

            :tracker_id => 1,

            :status_id => 1,

            :subject => 'Test'

          }

        }

      assert_response 302

            :project_id => 3,

            :tracker_id => 2,

            :subject => 'Foo'

          :continue => '1'

        }

      assert_redirected_to '/issues/new?issue%5Bproject_id%5D=3&issue%5Btracker_id%5D=2'

              :priority_id => 5,

              :estimated_hours => '',

              :custom_field_values => {

            }

          }

      end

      post :create, :params => {

          :project_id => 1,

          :issue => {

          }

        }

    end

              :project_id => 1,

              :issue => {

                :tracker_id => '1',

              :attachments => {

                '1' => {

              }

            }

        end

            :project_id => 1,

            :issue => {

              :tracker_id => '1',

            :attachments => {

              '1' => {

            }

          }

      end

            :project_id => 1,

            :issue => {

              :tracker_id => '1',

            :attachments => {

              '1' => {

            }

          }

        assert_response :success

            :project_id => 1,

            :issue => {

              :tracker_id => '1',

            :attachments => {

              'p0' => {

            }

          }

        assert_response :success

            :project_id => 1,

            :issue => {

              :tracker_id => '1',

            :attachments => {

              'p0' => {

            }

          }

        assert_response 302

            :project_id => '1',

            :tracker_id => '1',

            :status_id => '1'

          :was_default_status => '1'

        }

    end

              :tracker_id => '3',

              :status_id => '1',

              :subject => 'Copy with attachments'

            :copy_attachments => '1'

          }

      end

              :tracker_id => '3',

              :status_id => '1',

              :subject => 'Copy with attachments'

            :copy_attachments => '1',

            :attachments => {

              '1' => {

            :tracker_id => '3',

            :status_id => '1',

            :subject => 'Copy with subtasks'

          :copy_subtasks => '1'

        }

    end

            :status_id => '1',

            :subject => 'Copy with subtasks',

            :custom_field_values => {

          :copy_subtasks => '1'

        }

    end

        :id => 1,

        :issue => {

          :status_id => 5,

        :time_entry => {

          :hours => '2.5',

          :comments => 'test_get_edit_with_params',

        }

      }

    assert_response :success

                :project_id => '1',

                :tracker_id => '2',

                :priority_id => '6'

              }

            }

        end

            :issue => {

              :subject => 'Custom field change',

              :custom_field_values => {

            }

          }

      end

            :issue => {

              :status_id => 2,

              :assigned_to_id => 3,

            :time_entry => {

              :hours => '',

              :comments => '',

            }

          }

      end

      put :update, :params => {

          :id => 1,

          :issue => {

          }

        }

    end

      put :update, :params => {

          :id => 1,

          :issue => {

          :time_entry => {

            :hours => '2.5',

            :comments => 'test_put_update_with_note_and_spent_time',

          }

        }

    end

            :id => 1,

            :issue => {

              :notes => ''

            :attachments => {

              '1' => {

            }

          }

      end

        put :update, :params => {

            :id => 1,

            :issue => {

            :attachments => {

              '1' => {

            }

          }

        assert_response :success

        put :update, :params => {

            :id => 1,

            :issue => {

            :attachments => {

              'p0' => {

            }

          }

        assert_response :success

              :id => 1,

              :issue => {

                :notes => 'Attachment added'

              :attachments => {

                'p0' => {

              }

            }

          assert_redirected_to '/issues/1'

          :id => 1,

          :issue => {

            :notes => ''

          :attachments => {

            '1' => {

          }

        }

      assert_redirected_to :action => 'show', :id => '1'

            :issue => {

              :notes => 'Removing attachments',

              :deleted_attachment_ids => ['1', '5']

            }

          }

      end

              :subject => '',

              :notes => 'Removing attachments',

              :deleted_attachment_ids => ['1', '5']

            }

          }

      end

            :subject => new_subject,

            :priority_id => '6',

            :category_id => '1' # no change

          }

        }

      assert_equal 1, ActionMailer::Base.deliveries.size

          :id => 1,

          :issue => {

            :notes => notes

          :time_entry => {

            "comments"=>"", "activity_id"=>"", "hours"=>"2z"

          }

          :id => 1,

          :issue => {

            :notes => notes

          :time_entry => {

            "comments"=>"this is my comment", "activity_id"=>"", "hours"=>""

          }

        :id => issue.id,

        :issue => {

          :fixed_version_id => 4

        }

      }

        :id => issue.id,

        :issue => {

          :fixed_version_id => 4

        :back_url => '/issues'

      }

        :id => issue.id,

        :issue => {

          :fixed_version_id => 4

        :back_url => 'http://google.com'

      }

        :issue => {

          :status_id => 6,

          :notes => 'Notes'

        :prev_issue_id => 8,

        :next_issue_id => 12,

        :issue_position => 2,

          :priority_id => 7,

          :assigned_to_id => '',

          :custom_field_values => {

        }

      }

            :priority_id => '',

            :assigned_to_id => group.id,

            :custom_field_values => {

          }

        }

          :priority_id => 7,

          :assigned_to_id => '',

          :custom_field_values => {

        }

      }

          :priority_id => 7,

          :assigned_to_id => '',

          :custom_field_values => {

        }

      }

    assert_response 403

        :id => 1,

        :issue => {

          :project_id => '2'

        :follow => '1'

      }

    assert_redirected_to '/issues/1'

        :id => [1, 2],

        :issue => {

          :project_id => '2'

        :follow => '1'

      }

    assert_redirected_to '/projects/onlinestore/issues'

    assert_equal 4.25, Issue.find(2).estimated_hours

  end

  def test_bulk_update_custom_field

    @request.session[:user_id] = 2

    # update issues priority

          :priority_id => '',

          :assigned_to_id => '',

          :custom_field_values => {

        }

      }

          :priority_id => '',

          :assigned_to_id => '',

          :custom_field_values => {

        }

      }

    assert_response 302

          :priority_id => '',

          :assigned_to_id => '',

          :custom_field_values => {

        }

      }

          :priority_id => '',

          :assigned_to_id => '',

          :custom_field_values => {

        }

      }

    assert_response 302

            :ids => [1, 2],

            :issue => {

              :project_id => '2'

            :copy => '1'

          }

      end

          :ids => [1, 2, 3],

          :issue => {

            :project_id => '2'

          :copy => '1'

        }

      assert_response 302

        :ids => [1, 2, 3],

        :issue => {

          :project_id => ''

        :copy => '1'

      }

    assert_response 403

        :ids => [1, 2, 3],

        :issue => {

          :project_id => '1'

        :copy => '1'

      }

    assert_response 403

            :status_id => '',

            :start_date => '',

            :due_date => ''

          }

        }

    end

              :status_id => '1',

              :start_date => '2009-12-01',

              :due_date => '2009-12-31'

            }

          }

      end

            :status_id => '3',

            :start_date => '2009-12-01',

            :due_date => '2009-12-31'

          }

        }

    end

            :copy_attachments => '0',

            :issue => {

              :project_id => ''

            }

          }

      end

            :copy_attachments => '1',

            :issue => {

              :project_id => ''

            }

          }

      end

            :link_copy => '1',

            :issue => {

              :project_id => '1'

            }

          }

      end

          :copy_subtasks => '0',

          :issue => {

            :project_id => ''

          }

        }

    end

          :copy_subtasks => '1',

          :issue => {

            :project_id => ''

          }

        }

    end

          :copy_watchers => '1',

          :issue => {

            :project_id => ''

          }

        }

    end

          :copy_subtasks => '1',

          :issue => {

            :project_id => ''

          }

        }

    end

        :copy => '1',

        :issue => {

          :project_id => 2

        :follow => '1'

      }

    issue = Issue.order('id DESC').first

    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

    # remove permission!

    Role.anonymous.remove_permission! :view_time_entries

    #Role.all.each { |role| role.remove_permission! :view_time_entries }

    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

    # remove permission!

    Role.anonymous.remove_permission! :view_time_entries

    #Role.all.each { |role| role.remove_permission! :view_time_entries }

    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

    assert_match '6.30', 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')

  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.all.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)

  def test_add_issue_with_specific_overrides

    issue = submit_email('ticket_on_given_project.eml',

      :allow_override => ['status', 'start_date', 'due_date', 'assigned_to',

    )

    assert issue.is_a?(Issue)

    assert !issue.new_record?

    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