SoundSoftware Code Site

# 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 IssueRelationsControllerTest < ActionController::TestCase

  fixtures :projects,

           :users,

           :roles,

           :members,

           :member_roles,

           :issues,

           :issue_statuses,

           :issue_relations,

           :enabled_modules,

           :enumerations,

           :trackers

  def setup

    User.current = nil

    @request.session[:user_id] = 3

  end

  def test_create

    assert_difference 'IssueRelation.count' do

      post :create, :issue_id => 1,

                 :relation => {:issue_to_id => '2', :relation_type => 'relates', :delay => ''}

    end

    relation = IssueRelation.first(:order => 'id DESC')

    assert_equal 1, relation.issue_from_id

    assert_equal 2, relation.issue_to_id

    assert_equal 'relates', relation.relation_type

  end

  def test_create_xhr

    assert_difference 'IssueRelation.count' do

      xhr :post, :create, :issue_id => 3, :relation => {:issue_to_id => '1', :relation_type => 'relates', :delay => ''}

      assert_response :success

      assert_template 'create'

      assert_equal 'text/javascript', response.content_type

    end

    relation = IssueRelation.first(:order => 'id DESC')

    assert_equal 3, relation.issue_from_id

    assert_equal 1, relation.issue_to_id

    assert_match /Bug #1/, response.body

  end

  def test_create_should_accept_id_with_hash

    assert_difference 'IssueRelation.count' do

      post :create, :issue_id => 1,

                 :relation => {:issue_to_id => '#2', :relation_type => 'relates', :delay => ''}

    end

    relation = IssueRelation.first(:order => 'id DESC')

    assert_equal 2, relation.issue_to_id

  end

  def test_create_should_strip_id

    assert_difference 'IssueRelation.count' do

      post :create, :issue_id => 1,

                 :relation => {:issue_to_id => ' 2  ', :relation_type => 'relates', :delay => ''}

    end

    relation = IssueRelation.first(:order => 'id DESC')

    assert_equal 2, relation.issue_to_id

  end

  def test_create_should_not_break_with_non_numerical_id

    assert_no_difference 'IssueRelation.count' do

      assert_nothing_raised do

        post :create, :issue_id => 1,

                   :relation => {:issue_to_id => 'foo', :relation_type => 'relates', :delay => ''}

      end

    end

  end

  def test_should_create_relations_with_visible_issues_only

    Setting.cross_project_issue_relations = '1'

    assert_nil Issue.visible(User.find(3)).find_by_id(4)

    assert_no_difference 'IssueRelation.count' do

      post :create, :issue_id => 1,

                 :relation => {:issue_to_id => '4', :relation_type => 'relates', :delay => ''}

    end

  end

  should "prevent relation creation when there's a circular dependency"

  def test_create_xhr_with_failure

    assert_no_difference 'IssueRelation.count' do

      xhr :post, :create, :issue_id => 3, :relation => {:issue_to_id => '999', :relation_type => 'relates', :delay => ''}

      assert_response :success

      assert_template 'create'

      assert_equal 'text/javascript', response.content_type

    end

    assert_match /errorExplanation/, response.body

  end

  def test_destroy

    assert_difference 'IssueRelation.count', -1 do

      delete :destroy, :id => '2'

    end

  end

  def test_destroy_xhr

    IssueRelation.create!(:relation_type => IssueRelation::TYPE_RELATES) do |r|

      r.issue_from_id = 3

      r.issue_to_id = 1

    end

    assert_difference 'IssueRelation.count', -1 do

      xhr :delete, :destroy, :id => '2'

      assert_response :success

      assert_template 'destroy'

      assert_equal 'text/javascript', response.content_type

      assert_match /relation-2/, response.body

    end

  end

end

<div id="admin-menu">

  <%= render_menu :admin_menu %>

</div>

require File.expand_path('../../test_helper', __FILE__)

class ProjectEnumerationsControllerTest < ActionController::TestCase

  fixtures :projects, :trackers, :issue_statuses, :issues,

           :enumerations, :users, :issue_categories,

           :projects_trackers,

           :roles,

           :member_roles,

           :members,

           :enabled_modules,

           :workflows,

           :custom_fields, :custom_fields_projects,

           :custom_fields_trackers, :custom_values,

           :time_entries

  self.use_transactional_fixtures = false

  def setup

    @request.session[:user_id] = nil

    Setting.default_language = 'en'

  end

  def test_update_to_override_system_activities

    @request.session[:user_id] = 2 # manager

    billable_field = TimeEntryActivityCustomField.find_by_name("Billable")

    put :update, :project_id => 1, :enumerations => {

      "9"=> {"parent_id"=>"9", "custom_field_values"=>{"7" => "1"}, "active"=>"0"}, # Design, De-activate

      "10"=> {"parent_id"=>"10", "custom_field_values"=>{"7"=>"0"}, "active"=>"1"}, # Development, Change custom value

      "14"=>{"parent_id"=>"14", "custom_field_values"=>{"7"=>"1"}, "active"=>"1"}, # Inactive Activity, Activate with custom value

      "11"=>{"parent_id"=>"11", "custom_field_values"=>{"7"=>"1"}, "active"=>"1"} # QA, no changes

    }

    assert_response :redirect

    assert_redirected_to '/projects/ecookbook/settings/activities'

    # Created project specific activities...

    project = Project.find('ecookbook')

    # ... Design

    design = project.time_entry_activities.find_by_name("Design")

    assert design, "Project activity not found"

    assert_equal 9, design.parent_id # Relate to the system activity

    assert_not_equal design.parent.id, design.id # Different records

    assert_equal design.parent.name, design.name # Same name

    assert !design.active?

    # ... Development

    development = project.time_entry_activities.find_by_name("Development")

    assert development, "Project activity not found"

    assert_equal 10, development.parent_id # Relate to the system activity

    assert_not_equal development.parent.id, development.id # Different records

    assert_equal development.parent.name, development.name # Same name

    assert development.active?

    assert_equal "0", development.custom_value_for(billable_field).value

    # ... Inactive Activity

    previously_inactive = project.time_entry_activities.find_by_name("Inactive Activity")

    assert previously_inactive, "Project activity not found"

    assert_equal 14, previously_inactive.parent_id # Relate to the system activity

    assert_not_equal previously_inactive.parent.id, previously_inactive.id # Different records

    assert_equal previously_inactive.parent.name, previously_inactive.name # Same name

    assert previously_inactive.active?

    assert_equal "1", previously_inactive.custom_value_for(billable_field).value

    # ... QA

    assert_equal nil, project.time_entry_activities.find_by_name("QA"), "Custom QA activity created when it wasn't modified"

  end

  def test_update_will_update_project_specific_activities

    @request.session[:user_id] = 2 # manager

    project_activity = TimeEntryActivity.new({

                                               :name => 'Project Specific',

                                               :parent => TimeEntryActivity.find(:first),

                                               :project => Project.find(1),

                                               :active => true

                                             })

    assert project_activity.save

    project_activity_two = TimeEntryActivity.new({

                                                   :name => 'Project Specific Two',

                                                   :parent => TimeEntryActivity.find(:last),

                                                   :project => Project.find(1),

                                                   :active => true

                                                 })

    assert project_activity_two.save

    put :update, :project_id => 1, :enumerations => {

      project_activity.id => {"custom_field_values"=>{"7" => "1"}, "active"=>"0"}, # De-activate

      project_activity_two.id => {"custom_field_values"=>{"7" => "1"}, "active"=>"0"} # De-activate

    }

    assert_response :redirect

    assert_redirected_to '/projects/ecookbook/settings/activities'

    # Created project specific activities...

    project = Project.find('ecookbook')

    assert_equal 2, project.time_entry_activities.count

    activity_one = project.time_entry_activities.find_by_name(project_activity.name)

    assert activity_one, "Project activity not found"

    assert_equal project_activity.id, activity_one.id

    assert !activity_one.active?

    activity_two = project.time_entry_activities.find_by_name(project_activity_two.name)

    assert activity_two, "Project activity not found"

    assert_equal project_activity_two.id, activity_two.id

    assert !activity_two.active?

  end

  def test_update_when_creating_new_activities_will_convert_existing_data

    assert_equal 3, TimeEntry.find_all_by_activity_id_and_project_id(9, 1).size

    @request.session[:user_id] = 2 # manager

    put :update, :project_id => 1, :enumerations => {

      "9"=> {"parent_id"=>"9", "custom_field_values"=>{"7" => "1"}, "active"=>"0"} # Design, De-activate

    }

    assert_response :redirect

    # No more TimeEntries using the system activity

    assert_equal 0, TimeEntry.find_all_by_activity_id_and_project_id(9, 1).size, "Time Entries still assigned to system activities"

    # All TimeEntries using project activity

    project_specific_activity = TimeEntryActivity.find_by_parent_id_and_project_id(9, 1)

    assert_equal 3, TimeEntry.find_all_by_activity_id_and_project_id(project_specific_activity.id, 1).size, "No Time Entries assigned to the project activity"

  end

  def test_update_when_creating_new_activities_will_not_convert_existing_data_if_an_exception_is_raised

    # TODO: Need to cause an exception on create but these tests

    # aren't setup for mocking.  Just create a record now so the

    # second one is a dupicate

    parent = TimeEntryActivity.find(9)

    TimeEntryActivity.create!({:name => parent.name, :project_id => 1, :position => parent.position, :active => true})

    TimeEntry.create!({:project_id => 1, :hours => 1.0, :user => User.find(1), :issue_id => 3, :activity_id => 10, :spent_on => '2009-01-01'})

    assert_equal 3, TimeEntry.find_all_by_activity_id_and_project_id(9, 1).size

    assert_equal 1, TimeEntry.find_all_by_activity_id_and_project_id(10, 1).size

    @request.session[:user_id] = 2 # manager

    put :update, :project_id => 1, :enumerations => {

      "9"=> {"parent_id"=>"9", "custom_field_values"=>{"7" => "1"}, "active"=>"0"}, # Design

      "10"=> {"parent_id"=>"10", "custom_field_values"=>{"7"=>"0"}, "active"=>"1"} # Development, Change custom value

    }

    assert_response :redirect

    # TimeEntries shouldn't have been reassigned on the failed record

    assert_equal 3, TimeEntry.find_all_by_activity_id_and_project_id(9, 1).size, "Time Entries are not assigned to system activities"

    # TimeEntries shouldn't have been reassigned on the saved record either

    assert_equal 1, TimeEntry.find_all_by_activity_id_and_project_id(10, 1).size, "Time Entries are not assigned to system activities"

  end

  def test_destroy

    @request.session[:user_id] = 2 # manager

    project_activity = TimeEntryActivity.new({

                                               :name => 'Project Specific',

                                               :parent => TimeEntryActivity.find(:first),

                                               :project => Project.find(1),

                                               :active => true

                                             })

    assert project_activity.save

    project_activity_two = TimeEntryActivity.new({

                                                   :name => 'Project Specific Two',

                                                   :parent => TimeEntryActivity.find(:last),

                                                   :project => Project.find(1),

                                                   :active => true

                                                 })

    assert project_activity_two.save

    delete :destroy, :project_id => 1

    assert_response :redirect

    assert_redirected_to '/projects/ecookbook/settings/activities'

    assert_nil TimeEntryActivity.find_by_id(project_activity.id)

    assert_nil TimeEntryActivity.find_by_id(project_activity_two.id)

  end

  def test_destroy_should_reassign_time_entries_back_to_the_system_activity

    @request.session[:user_id] = 2 # manager

    project_activity = TimeEntryActivity.new({

                                               :name => 'Project Specific Design',

                                               :parent => TimeEntryActivity.find(9),

                                               :project => Project.find(1),

                                               :active => true

                                             })

    assert project_activity.save

    assert TimeEntry.update_all("activity_id = '#{project_activity.id}'", ["project_id = ? AND activity_id = ?", 1, 9])

    assert_equal 3, TimeEntry.find_all_by_activity_id_and_project_id(project_activity.id, 1).size

    delete :destroy, :project_id => 1

    assert_response :redirect

    assert_redirected_to '/projects/ecookbook/settings/activities'

    assert_nil TimeEntryActivity.find_by_id(project_activity.id)

    assert_equal 0, TimeEntry.find_all_by_activity_id_and_project_id(project_activity.id, 1).size, "TimeEntries still assigned to project specific activity"

    assert_equal 3, TimeEntry.find_all_by_activity_id_and_project_id(9, 1).size, "TimeEntries still assigned to project specific activity"

  end

end

# 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 'zlib'

class WikiContent < ActiveRecord::Base

  self.locking_column = 'version'

  belongs_to :page, :class_name => 'WikiPage', :foreign_key => 'page_id'

  belongs_to :author, :class_name => 'User', :foreign_key => 'author_id'

  validates_presence_of :text

  validates_length_of :comments, :maximum => 255, :allow_nil => true

  acts_as_versioned

  def visible?(user=User.current)

    page.visible?(user)

  end

  def project

    page.project

  end

  def attachments

    page.nil? ? [] : page.attachments

  end

  # Returns the mail adresses of users that should be notified

  def recipients

    notified = project.notified_users

    notified.reject! {|user| !visible?(user)}

    notified.collect(&:mail)

  end

  # Return true if the content is the current page content

  def current_version?

    true

  end

  class Version

    belongs_to :page, :class_name => '::WikiPage', :foreign_key => 'page_id'

    belongs_to :author, :class_name => '::User', :foreign_key => 'author_id'

    attr_protected :data

    acts_as_event :title => Proc.new {|o| "#{l(:label_wiki_edit)}: #{o.page.title} (##{o.version})"},

                  :description => :comments,

                  :datetime => :updated_on,

                  :type => 'wiki-page',

                  :url => Proc.new {|o| {:controller => 'wiki', :action => 'show', :project_id => o.page.wiki.project, :id => o.page.title, :version => o.version}}

    acts_as_activity_provider :type => 'wiki_edits',

                              :timestamp => "#{WikiContent.versioned_table_name}.updated_on",

                              :author_key => "#{WikiContent.versioned_table_name}.author_id",

                              :permission => :view_wiki_edits,

                              :find_options => {:select => "#{WikiContent.versioned_table_name}.updated_on, #{WikiContent.versioned_table_name}.comments, " +

                                                           "#{WikiContent.versioned_table_name}.#{WikiContent.version_column}, #{WikiPage.table_name}.title, " +

                                                           "#{WikiContent.versioned_table_name}.page_id, #{WikiContent.versioned_table_name}.author_id, " +

                                                           "#{WikiContent.versioned_table_name}.id",

                                                :joins => "LEFT JOIN #{WikiPage.table_name} ON #{WikiPage.table_name}.id = #{WikiContent.versioned_table_name}.page_id " +

                                                          "LEFT JOIN #{Wiki.table_name} ON #{Wiki.table_name}.id = #{WikiPage.table_name}.wiki_id " +

                                                          "LEFT JOIN #{Project.table_name} ON #{Project.table_name}.id = #{Wiki.table_name}.project_id"}

    after_destroy :page_update_after_destroy

    def text=(plain)

      case Setting.wiki_compression

      when 'gzip'

      begin

        self.data = Zlib::Deflate.deflate(plain, Zlib::BEST_COMPRESSION)

        self.compression = 'gzip'

      rescue

        self.data = plain

        self.compression = ''

      end

      else

        self.data = plain

        self.compression = ''

      end

      plain

    end

    def text

      @text ||= begin

        str = case compression

              when 'gzip'

                Zlib::Inflate.inflate(data)

              else

                # uncompressed data

                data

              end

        str.force_encoding("UTF-8") if str.respond_to?(:force_encoding)

        str

      end

    end

    def project

      page.project

    end

    # Return true if the content is the current page content

    def current_version?

      page.content.version == self.version

    end

    # Returns the previous version or nil

    def previous

      @previous ||= WikiContent::Version.

        reorder('version DESC').

        includes(:author).

        where("wiki_content_id = ? AND version < ?", wiki_content_id, version).first

    end

    # Returns the next version or nil

    def next

      @next ||= WikiContent::Version.

        reorder('version ASC').

        includes(:author).

        where("wiki_content_id = ? AND version > ?", wiki_content_id, version).first

    end

    private

    # Updates page's content if the latest version is removed

    # or destroys the page if it was the only version

    def page_update_after_destroy

      latest = page.content.versions.reorder("#{self.class.table_name}.version DESC").first

      if latest && page.content.version != latest.version

        raise ActiveRecord::Rollback unless page.content.revert_to!(latest)

      elsif latest.nil?

        raise ActiveRecord::Rollback unless page.destroy

      end

    end

  end

end