Redmine

  def remove_inherited_member_roles(not_deleted_ids_at_parent=[])

    member_ids = membership_ids

    member_roles = MemberRole.where(member_id: member_ids)

    not_delete_ids = member_roles.where(inherited_from: nil).ids

    not_delete_ids += member_roles.where(inherited_from: member_roles.ids + not_deleted_ids_at_parent).ids

    delete_member_roles = member_roles.where.not(id: not_delete_ids).delete_all

    # MemberRole#remove_member_if_empty

    delete_member_ids = Member.where(id: member_ids).left_outer_joins(:roles).where(roles: {id: nil}).ids

    delete_members = Member.where(id: delete_member_ids)

    delete_member_user_ids = delete_members.pluck(:user_id)

    delete_members.delete_all

    # Member#set_issue_category_nil

    IssueCategory.where(project_id: self.id, assigned_to_id: delete_member_user_ids).update_all("assigned_to_id = NULL")

    # Member#remove_from_project_default_assigned_to

    if self.default_assigned_to_id && delete_member_user_ids.include?(self.default_assigned_to_id)

      update_column(:default_assigned_to_id, nil)

    end

    # MemberRole#remove_inherited_roles

    children.where(inherit_members: true).map {|c| c.remove_inherited_member_roles(not_delete_ids) }

  end

  def test_moving_a_subproject_as_root_should_clear_issue_category_assigned_to

    Project.generate_with_parent!(@parent, :inherit_members => true)

    project = Project.order('id desc').first

    user = project.members.first.user

    category = IssueCategory.create!(:project => project, :assigned_to => user, :name => 'foo')

    assert_difference 'Member.count', -1 do

      project.set_parent!(nil)

      project.reload

      category.reload

      assert_equal 0, project.memberships.count

      assert_nil category.assigned_to

    end

  end

  def test_moving_a_subproject_as_root_should_clear_default_assigned_to

    Project.generate_with_parent!(@parent, :inherit_members => true)

    project = Project.order('id desc').first

    user = project.members.first.user

    project.update!(:default_assigned_to => user)

    assert_difference 'Member.count', -1 do

      project.set_parent!(nil)

      project.reload

      assert_equal 0, project.memberships.count

      assert_nil project.default_assigned_to

    end

  end