SoundSoftware Code Site

#

# 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 Attachment < ActiveRecord::Base

  belongs_to :container, :polymorphic => true

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

  validates_presence_of :container, :filename, :author

  validates_length_of :filename, :maximum => 255

  validates_length_of :disk_filename, :maximum => 255

  acts_as_activity_provider :type => 'files',

                            :permission => :view_files,

                            :author_key => :author_id,

                                              :joins => "LEFT JOIN #{Version.table_name} ON #{Attachment.table_name}.container_type='Version' AND #{Version.table_name}.id = #{Attachment.table_name}.container_id " +

                                                        "LEFT JOIN #{Project.table_name} ON #{Version.table_name}.project_id = #{Project.table_name}.id OR ( #{Attachment.table_name}.container_type='Project' AND #{Attachment.table_name}.container_id = #{Project.table_name}.id )"}

  acts_as_activity_provider :type => 'documents',

                            :permission => :view_documents,

                            :author_key => :author_id,

                                              :joins => "LEFT JOIN #{Document.table_name} ON #{Attachment.table_name}.container_type='Document' AND #{Document.table_name}.id = #{Attachment.table_name}.container_id " +

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

  cattr_accessor :storage_path

  @@storage_path = Redmine::Configuration['attachments_storage_path'] || "#{RAILS_ROOT}/files"

  def validate

    if self.filesize > Setting.attachment_max_size.to_i.kilobytes

      errors.add(:base, :too_long, :count => Setting.attachment_max_size.to_i.kilobytes)

    if @temp_file && (@temp_file.size > 0)

      logger.debug("saving '#{self.diskfile}'")

      md5 = Digest::MD5.new

        buffer = ""

        while (buffer = @temp_file.read(8192))

          f.write(buffer)

  def diskfile

    "#{@@storage_path}/#{self.disk_filename}"

  end

  def increment_download

    increment!(:downloads)

  end

  def project

    container.project

  end

  def visible?(user=User.current)

    container.attachments_visible?(user)

  end

  def deletable?(user=User.current)

    container.attachments_deletable?(user)

  end

  def image?

    self.filename =~ /\.(jpe?g|gif|png)$/i

  end

  def is_text?

    Redmine::MimeType.is_type?('text', filename)

  end

  def is_diff?

    self.filename =~ /\.(patch|diff)$/i

  end

  # Returns true if the file is readable

  def readable?

    File.readable?(diskfile)

      attachments.each_value do |attachment|

        file = attachment['file']

        next unless file && file.size > 0

                              :file => file,

                              :description => attachment['description'].to_s.strip,

                              :author => User.current)

    end

    {:files => attached, :unsaved => obj.unsaved_attachments}

  end

private

  def sanitize_filename(value)

    # get only the filename, not the whole path

    just_filename = value.gsub(/^.*(\\|\/)/, '')

    # NOTE: File.basename doesn't work right with Windows paths on Unix

    # Finally, replace all non alphanumeric, hyphens or periods with underscore

  end

  # Returns an ASCII or hashed filename

  def self.disk_filename(filename)

    timestamp = DateTime.now.strftime("%y%m%d%H%M%S")

#

# 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 Change < ActiveRecord::Base

  belongs_to :changeset

  validates_presence_of :changeset_id, :action, :path

  before_save :init_path

  def relative_path

    changeset.repository.relative_path(path)

  end

  def init_path

    self.path ||= ""

  end

# Redmine - project management software

#

# 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.

                :description => :long_comments,

                :datetime => :committed_on,

                :url => Proc.new {|o| {:controller => 'repositories', :action => 'revision', :id => o.repository.project, :rev => o.identifier}}

  acts_as_searchable :columns => 'comments',

                     :include => {:repository => :project},

                     :project_key => "#{Repository.table_name}.project_id",

                     :date_column => 'committed_on'

  acts_as_activity_provider :timestamp => "#{table_name}.committed_on",

                            :author_key => :user_id,

                            :find_options => {:include => [:user, {:repository => :project}]}

  validates_presence_of :repository_id, :revision, :committed_on, :commit_date

  validates_uniqueness_of :revision, :scope => :repository_id

  validates_uniqueness_of :scmid, :scope => :repository_id, :allow_nil => true

  named_scope :visible, lambda {|*args| { :include => {:repository => :project},

  def revision=(r)

    write_attribute :revision, (r.nil? ? nil : r.to_s)

  end

      identifier

    end

  end

  def project

    repository.project

  end

  def author

    user || committer.to_s.split('<').first

  end

  def before_create

    self.committer = self.class.to_utf8(self.committer, repository.repo_log_encoding)

    self.user = repository.find_committer_user(self.committer)

  end

  def after_create

    scan_comment_for_issue_ids

  end

  TIMELOG_RE = /

    (

    ((\d+)(h|hours?))((\d+)(m|min)?)?

    (\d+([\.,]\d+)?)h?

    )

    /x

  def scan_comment_for_issue_ids

    return if comments.blank?

    # keywords used to reference issues

    ref_keywords_any = ref_keywords.delete('*')

    # keywords used to fix issues

    fix_keywords = Setting.commit_fix_keywords.downcase.split(",").collect(&:strip)

    kw_regexp = (ref_keywords + fix_keywords).collect{|kw| Regexp.escape(kw)}.join("|")

    referenced_issues = []

    comments.scan(/([\s\(\[,-]|^)((#{kw_regexp})[\s:]+)?(#\d+(\s+@#{TIMELOG_RE})?([\s,;&]+#\d+(\s+@#{TIMELOG_RE})?)*)(?=[[:punct:]]|\s|<|$)/i) do |match|

      action, refs = match[2], match[3]

      next unless action.present? || ref_keywords_any

      refs.scan(/#(\d+)(\s+@#{TIMELOG_RE})?/).each do |m|

        issue, hours = find_referenced_issue_by_id(m[0].to_i), m[2]

        if issue

        end

      end

    end

    referenced_issues.uniq!

    self.issues = referenced_issues unless referenced_issues.empty?

  end

  def short_comments

    @short_comments || split_comments.first

  end

  def long_comments

    @long_comments || split_comments.last

  end

      "r#{revision}"

    end

  end

  # Returns the previous changeset

  def previous

  end

  # Returns the next changeset

  def next

  end

  # Creates a new Change from it's common parameters

  def create_change(change)

                  :from_revision => change[:from_revision])

  end

    return nil if id.blank?

    issue = Issue.find_by_id(id.to_i, :include => :project)

    if issue

        issue = nil

      end

    end

    issue

  end

  def fix_issue(issue)

    status = IssueStatus.find_by_id(Setting.commit_fix_status_id.to_i)

    if status.nil?

      logger.warn("No status macthes commit_fix_status_id setting (#{Setting.commit_fix_status_id})") if logger

      return issue

    end

    # the issue may have been updated by the closure of another one (eg. duplicate)

    issue.reload

    # don't change the status is the issue is closed

    return if issue.status && issue.status.is_closed?

    journal = issue.init_journal(user || User.anonymous, ll(Setting.default_language, :text_status_changed_by_changeset, text_tag))

    issue.status = status

    unless Setting.commit_fix_done_ratio.blank?

    end

    issue

  end

  def log_time(issue, hours)

    time_entry = TimeEntry.new(

      :user => user,

      :hours => hours,

      :issue => issue,

      :spent_on => commit_date,

      )

    time_entry.activity = log_time_activity unless log_time_activity.nil?

    unless time_entry.save

      logger.warn("TimeEntry could not be created by changeset #{id}: #{time_entry.errors.full_messages}") if logger

    end

    time_entry

  end

  def log_time_activity

    if Setting.commit_logtime_activity_id.to_i > 0

      TimeEntryActivity.find_by_id(Setting.commit_logtime_activity_id.to_i)

    end

  end

  def split_comments

    comments =~ /\A(.+?)\r?\n(.*)$/m

    @short_comments = $1 || comments

    Changeset.to_utf8(str.to_s.strip, encoding)

  end

  def self.to_utf8(str, encoding)

    end

    if str.respond_to?(:force_encoding)

      end

    else

      begin

      end

    end

    str

  end

#

# This program is free software; you can redistribute it and/or

# modify it under the terms of the GNU General Public License

    errors.add(:default_value, :invalid) unless v.valid?

  end

  # Makes possible_values accept a multiline string

  def possible_values=(arg)

    if arg.is_a?(Array)

        casted = value.to_i

      when 'float'

        casted = value.to_f

      end

    end

    casted

#

# 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.

                :author => Proc.new {|o| (a = o.attachments.find(:first, :order => "#{Attachment.table_name}.created_on ASC")) ? a.author : nil },

                :url => Proc.new {|o| {:controller => 'documents', :action => 'show', :id => o.id}}

  acts_as_activity_provider :find_options => {:include => :project}

  validates_presence_of :project, :title, :category

  validates_length_of :title, :maximum => 60

  named_scope :visible, lambda {|*args| { :include => :project,

  def visible?(user=User.current)

    !user.nil? && user.allowed_to?(:view_documents, project)

  end

  def after_initialize

    if new_record?

      self.category ||= DocumentCategory.default

    end

  end

  def updated_on

    unless @updated_on

      a = attachments.find(:first, :order => 'created_on DESC')

#

# 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.

#

# 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.

    :enumeration_doc_categories

  end

end

#

# 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.

# Redmine - project management software

#

# 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 EnabledModule < ActiveRecord::Base

  belongs_to :project

  validates_presence_of :name

  validates_uniqueness_of :name, :scope => :project_id

  after_create :module_enabled

  private

  # after_create callback used to do things when a module is enabled

  def module_enabled

    case name

# 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 Issue < ActiveRecord::Base

  include Redmine::SafeAttributes

  belongs_to :project

  belongs_to :tracker

  belongs_to :status, :class_name => 'IssueStatus', :foreign_key => 'status_id'

  has_many :journals, :as => :journalized, :dependent => :destroy

  has_many :time_entries, :dependent => :delete_all

  has_and_belongs_to_many :changesets, :order => "#{Changeset.table_name}.committed_on ASC, #{Changeset.table_name}.id ASC"

  has_many :relations_from, :class_name => 'IssueRelation', :foreign_key => 'issue_from_id', :dependent => :delete_all

  has_many :relations_to, :class_name => 'IssueRelation', :foreign_key => 'issue_to_id', :dependent => :delete_all

  acts_as_nested_set :scope => 'root_id', :dependent => :destroy

  acts_as_attachable :after_remove => :attachment_removed

  acts_as_customizable

  acts_as_event :title => Proc.new {|o| "#{o.tracker.name} ##{o.id} (#{o.status}): #{o.subject}"},

                :url => Proc.new {|o| {:controller => 'issues', :action => 'show', :id => o.id}},

                :type => Proc.new {|o| 'issue' + (o.closed? ? ' closed' : '') }

  acts_as_activity_provider :find_options => {:include => [:project, :author, :tracker]},

                            :author_key => :author_id

  validates_numericality_of :estimated_hours, :allow_nil => true

  named_scope :visible, lambda {|*args| { :include => :project,

  named_scope :open, :conditions => ["#{IssueStatus.table_name}.is_closed = ?", false], :include => :status

  named_scope :recently_updated, :order => "#{Issue.table_name}.updated_on DESC"

  named_scope :with_limit, lambda { |limit| { :limit => limit} }

  named_scope :on_active_project, :include => [:status, :project, :tracker],

                                  :conditions => ["#{Project.table_name}.status=#{Project::STATUS_ACTIVE}"]

  named_scope :without_version, lambda {

    {

  before_save :close_duplicates, :update_done_ratio_from_issue_status

  after_save :reschedule_following_issues, :update_nested_set_attributes, :update_parent_attributes, :create_journal

  after_destroy :update_parent_attributes

  # Returns true if usr or current user is allowed to view the issue

  def visible?(usr=nil)

  end

  def after_initialize

    if new_record?

      # set default values for new records only

      self.priority ||= IssuePriority.default

    end

  end

  # Overrides Redmine::Acts::Customizable::InstanceMethods#available_custom_fields

  def available_custom_fields

  end

  def copy_from(arg)

    issue = arg.is_a?(Issue) ? arg : Issue.visible.find(arg)

    self.attributes = issue.attributes.dup.except("id", "root_id", "parent_id", "lft", "rgt", "created_on", "updated_on")

    self.status = issue.status

    self

  end

  # Moves/copies an issue to a new project and tracker

  # Returns the moved/copied issue on success, false on failure

  def move_to_project(*args)

      move_to_project_without_transaction(*args) || raise(ActiveRecord::Rollback)

    end || false

  end

  def move_to_project_without_transaction(new_project, new_tracker = nil, options = {})

    options ||= {}

    issue = options[:copy] ? self.class.new.copy_from(self) : self

    if new_project && issue.project_id != new_project.id

      # delete issue relations

      unless Setting.cross_project_issue_relations?

      issue.reset_custom_values!

    end

    if options[:copy]

      issue.custom_field_values = self.custom_field_values.inject({}) {|h,v| h[v.custom_field_id] = v.value; h}

      issue.status = if options[:attributes] && options[:attributes][:status_id]

                       IssueStatus.find_by_id(options[:attributes][:status_id])

      issue.attributes = options[:attributes]

    end

    if issue.save

        # Manually update project_id on related time entries

        TimeEntry.update_all("project_id = #{new_project.id}", {:issue_id => id})

        issue.children.each do |child|

          unless child.move_to_project_without_transaction(new_project)

            # Move failed and transaction was rollback'd

    self.status = nil

    write_attribute(:status_id, sid)

  end

  def priority_id=(pid)

    self.priority = nil

    write_attribute(:priority_id, pid)

    @custom_field_values = nil

    result

  end

  # Overrides attributes= so that tracker_id gets assigned first

  def attributes_with_tracker_first=(new_attributes, *args)

    return if new_attributes.nil?

  end

  # Do not redefine alias chain on reload (see #4838)

  alias_method_chain(:attributes=, :tracker_first) unless method_defined?(:attributes_without_tracker_first=)

  def estimated_hours=(h)

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

  end

  safe_attributes 'tracker_id',

    'status_id',

    'parent_issue_id',

    'custom_fields',

    'lock_version',

    :if => lambda {|issue, user| issue.new_record? || user.allowed_to?(:edit_issues, issue.project) }

  safe_attributes 'status_id',

    'assigned_to_id',

    'fixed_version_id',

    'done_ratio',

    :if => lambda {|issue, user| issue.new_statuses_allowed_to(user).any? }

  # Safely sets attributes

  # Should be called from controllers instead of #attributes=

  # attr_accessible is too rough because we still want things like

  # TODO: move workflow/permission checks from controllers to here

  def safe_attributes=(attrs, user=User.current)

    return unless attrs.is_a?(Hash)

    # User can change issue attributes only if he has :edit permission or if a workflow transition is allowed

    attrs = delete_unsafe_attributes(attrs, user)

    # Tracker must be set before since new_statuses_allowed_to depends on it.

    if t = attrs.delete('tracker_id')

      self.tracker_id = t

    end

    if attrs['status_id']

      unless new_statuses_allowed_to(user).collect(&:id).include?(attrs['status_id'].to_i)

        attrs.delete('status_id')

      end

    end

    unless leaf?

      attrs.reject! {|k,v| %w(priority_id done_ratio start_date due_date estimated_hours).include?(k)}

    end

    if attrs.has_key?('parent_issue_id')

      if !user.allowed_to?(:manage_subtasks, project)

        attrs.delete('parent_issue_id')

        attrs.delete('parent_issue_id') unless Issue.visible(user).exists?(attrs['parent_issue_id'].to_i)

      end

    end

    self.attributes = attrs

  end

  def done_ratio

    if Issue.use_status_for_done_ratio? && status && status.default_done_ratio

      status.default_done_ratio

  def self.use_field_for_done_ratio?

    Setting.issue_done_ratio == 'issue_field'

  end

  def validate

    if self.due_date.nil? && @attributes['due_date'] && !@attributes['due_date'].empty?

      errors.add :due_date, :not_a_date

    end

    if self.due_date and self.start_date and self.due_date < self.start_date

      errors.add :due_date, :greater_than_start_date

    end

    if start_date && soonest_start && start_date < soonest_start

      errors.add :start_date, :invalid

    end

    if fixed_version

      if !assignable_versions.include?(fixed_version)

        errors.add :fixed_version_id, :inclusion

        errors.add_to_base I18n.t(:error_can_not_reopen_issue_on_closed_version)

      end

    end

    # Checks that the issue can not be added/moved to a disabled tracker

    if project && (tracker_id_changed? || project_id_changed?)

      unless project.trackers.include?(tracker)

        errors.add :tracker_id, :inclusion

      end

    end

    # Checks parent issue assignment

    if @parent_issue

      if @parent_issue.project_id != project_id

      end

    end

  end

  # Set the done_ratio using the status if that setting is set.  This will keep the done_ratios

  # even if the user turns off the setting later

  def update_done_ratio_from_issue_status

      self.done_ratio = status.default_done_ratio

    end

  end

  def init_journal(user, notes = "")

    @current_journal ||= Journal.new(:journalized => self, :user => user, :notes => notes)

    @issue_before_change = self.clone

    updated_on_will_change!

    @current_journal

  end

  # Return true if the issue is closed, otherwise false

  def closed?

    self.status.is_closed?

  end

  # Return true if the issue is being reopened

  def reopened?

    if !new_record? && status_id_changed?

    end

    false

  end

  # Returns true if the issue is overdue

  def overdue?

    !due_date.nil? && (due_date < Date.today) && !status.is_closed?

  def children?

    !leaf?

  end

  # Users the issue can be assigned to

  def assignable_users

    users = project.assignable_users

    users << author if author

    users.uniq.sort

  end

  # Versions that the issue can be assigned to

  def assignable_versions

    @assignable_versions ||= (project.shared_versions.open + [Version.find_by_id(fixed_version_id_was)]).compact.uniq.sort

  end

  # Returns true if this issue is blocked by another issue that is still open

  def blocked?

    !relations_to.detect {|ir| ir.relation_type == 'blocks' && !ir.issue_from.closed?}.nil?

  end

  # Returns an array of status that user is able to apply

  def new_statuses_allowed_to(user, include_default=false)

    statuses = status.find_new_statuses_allowed_to(

    statuses = statuses.uniq.sort

    blocked? ? statuses.reject {|s| s.is_closed?} : statuses

  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

  # Returns the total number of hours spent on this issue and its descendants

  #

  # Example:

  def spent_hours

    @spent_hours ||= self_and_descendants.sum("#{TimeEntry.table_name}.hours", :include => :time_entries).to_f || 0.0

  end

  def relations

    (relations_from + relations_to).sort

  end

    dependencies = []

    relations_from.each do |relation|

        dependencies << relation.issue_to

        dependencies += relation.issue_to.all_dependent_issues(except)

      end

    end

    dependencies

  end

  # Returns an array of issues that duplicate this one

  def duplicates

    relations_to.select {|r| r.relation_type == IssueRelation::TYPE_DUPLICATES}.collect {|r| r.issue_from}

  end

  # Returns the due date or the target due date if any

  # Used on gantt chart

  def due_before

    due_date || (fixed_version ? fixed_version.effective_date : nil)

  end

  # Returns the time scheduled for this issue.

  # Example:

  #   Start Date: 2/26/09, End Date: 3/04/09

  #   duration => 6

  def duration

    (start_date && due_date) ? due_date - start_date : 0

  end

  def soonest_start

    @soonest_start ||= (

        relations_to.collect{|relation| relation.successor_soonest_start} +

        ancestors.collect(&:soonest_start)

      ).compact.max

  end

  def reschedule_after(date)

    return if date.nil?

    if leaf?

      end

    end

  end

  def <=>(issue)

    if issue.nil?

      -1

      (lft || 0) <=> (issue.lft || 0)

    end

  end

  def to_s

    "#{tracker} ##{id}: #{subject}"

  end

  # Returns a string of css classes that apply to the issue

  def css_classes

    s = "issue status-#{status.position} priority-#{priority.position}"

    s << ' closed' if closed?

    s << ' overdue' if overdue?

    s << ' created-by-me' if User.current.logged? && author_id == User.current.id

    s << ' assigned-to-me' if User.current.logged? && assigned_to_id == User.current.id

    s

  # Returns false if save fails

  def save_issue_with_child_records(params, existing_time_entry=nil)

    Issue.transaction do

        @time_entry = existing_time_entry || TimeEntry.new

        @time_entry.project = project

        @time_entry.issue = self

        @time_entry.attributes = params[:time_entry]

        self.time_entries << @time_entry

      end

      if valid?

        attachments = Attachment.attach_files(self, params[:attachments])

        attachments[:files].each {|a| @current_journal.details << JournalDetail.new(:property => 'attachment', :prop_key => a.id, :value => a.filename)}

        # TODO: Rename hook

        Redmine::Hook.call_hook(:controller_issues_edit_before_save, { :params => params, :issue => self, :time_entry => @time_entry, :journal => @current_journal})

    # Update issues assigned to the version

    update_versions(["#{Issue.table_name}.fixed_version_id = ?", version.id])

  end

  # Unassigns issues from versions that are no longer shared

  # after +project+ was moved

  def self.update_versions_from_hierarchy_change(project)

      nil

    end

  end

  def parent_issue_id

    if instance_variable_defined? :@parent_issue

      @parent_issue.nil? ? nil : @parent_issue.id

  def self.by_subproject(project)

    ActiveRecord::Base.connection.select_all("select    s.id as status_id, 

                                                s.is_closed as closed, 

                                              from 

                                              where 

  end

  # End ReportsController extraction

  # Returns an array of projects that current user can move issues to

  def self.allowed_target_projects_on_move

    projects = []

    end

    projects

  end

  private

  def update_nested_set_attributes

    if root_id.nil?

      # issue was just created

    end

    remove_instance_variable(:@parent_issue) if instance_variable_defined?(:@parent_issue)

  end

  def update_parent_attributes

    recalculate_attributes_for(parent_id) if parent_id

  end

      if priority_position = p.children.maximum("#{IssuePriority.table_name}.position", :include => :priority)

        p.priority = IssuePriority.find_by_position(priority_position)

      end

      # start/due dates = lowest/highest dates of children

      p.start_date = p.children.minimum(:start_date)

      p.due_date = p.children.maximum(:due_date)

      if p.start_date && p.due_date && p.due_date < p.start_date

        p.start_date, p.due_date = p.due_date, p.start_date

      end

      # done ratio = weighted average ratio of leaves

      unless Issue.use_status_for_done_ratio? && p.status && p.status.default_done_ratio

        leaves_count = p.leaves.count

          p.done_ratio = progress.round

        end

      end

      # estimate = sum of leaves estimates

      p.estimated_hours = p.leaves.sum(:estimated_hours).to_f

      p.estimated_hours = nil if p.estimated_hours == 0.0

      # ancestors will be recursively updated

      p.save(false)

    end

  end

  # Update issues so their versions are not pointing to a

  # fixed_version that is not shared with the issue's project

  def self.update_versions(conditions=nil)

      end

    end

  end

  # Callback on attachment deletion

  def attachment_removed(obj)

    journal = init_journal(User.current)

                                         :old_value => obj.filename)

    journal.save

  end

  # Default assignment based on category

  def default_assign

    if assigned_to.nil? && category && category.assigned_to

      end

    end

  end

  # Saves the changes in a Journal

  # Called after_save

  def create_journal

      custom_values.each {|c|

        next if (@custom_values_before_change[c.custom_field_id]==c.value ||

                  (@custom_values_before_change[c.custom_field_id].blank? && c.value.blank?))

                                                      :prop_key => c.custom_field_id,

                                                      :old_value => @custom_values_before_change[c.custom_field_id],

                                                      :value => c.value)

      @current_journal.save

      # reset current journal

      init_journal @current_journal.user, @current_journal.notes

    select_field = options.delete(:field)

    joins = options.delete(:joins)

    ActiveRecord::Base.connection.select_all("select    s.id as status_id, 

                                                s.is_closed as closed, 

                                                j.id as #{select_field},

                                              from 

                                              where 

                                                and #{where}

                                              group by s.id, s.is_closed, j.id")

  end

end

#

# This program is free software; you can redistribute it and/or

# modify it under the terms of the GNU General Public License

                :url => Proc.new {|o| {:controller => 'issues', :action => 'show', :id => o.issue.id, :anchor => "change-#{o.id}"}}

  acts_as_activity_provider :type => 'issues',

                            :author_key => :user_id,

                            :find_options => {:include => [{:issue => :project}, :details, :user],

                                              :conditions => "#{Journal.table_name}.journalized_type = 'Issue' AND" +

                                                             " (#{JournalDetail.table_name}.prop_key = 'status_id' OR #{Journal.table_name}.notes <> '')"}

  def save(*args)

    # Do not save an empty journal

    (details.empty? && notes.blank?) ? false : super

    s << ' has-details' unless details.blank?

    s

  end

end

class JournalDetail < ActiveRecord::Base

  belongs_to :journal

end

#

# This program is free software; you can redistribute it and/or

# modify it under the terms of the GNU General Public License

class JournalObserver < ActiveRecord::Observer

  def after_create(journal)