|
|
# redMine - project management software
|
|
|
# Copyright (C) 2006 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.
|
|
|
|
|
|
class Version < ActiveRecord::Base
|
|
|
before_destroy :check_integrity
|
|
|
belongs_to :project
|
|
|
has_many :fixed_issues, :class_name => 'Issue', :foreign_key => 'fixed_version_id'
|
|
|
acts_as_attachable :view_permission => :view_files,
|
|
|
:delete_permission => :manage_files
|
|
|
|
|
|
validates_presence_of :name
|
|
|
validates_uniqueness_of :name, :scope => [:project_id]
|
|
|
validates_length_of :name, :maximum => 60
|
|
|
validates_format_of :effective_date, :with => /^\d{4}-\d{2}-\d{2}$/, :message => :not_a_date, :allow_nil => true
|
|
|
|
|
|
def start_date
|
|
|
effective_date
|
|
|
end
|
|
|
|
|
|
def due_date
|
|
|
effective_date
|
|
|
end
|
|
|
|
|
|
# Returns the total estimated time for this version
|
|
|
def estimated_hours
|
|
|
@estimated_hours ||= fixed_issues.sum(:estimated_hours).to_f
|
|
|
end
|
|
|
|
|
|
# Returns the total reported time for this version
|
|
|
def spent_hours
|
|
|
@spent_hours ||= TimeEntry.sum(:hours, :include => :issue, :conditions => ["#{Issue.table_name}.fixed_version_id = ?", id]).to_f
|
|
|
end
|
|
|
|
|
|
# Returns true if the version is completed: due date reached and no open issues
|
|
|
def completed?
|
|
|
effective_date && (effective_date <= Date.today) && (open_issues_count == 0)
|
|
|
end
|
|
|
|
|
|
# Returns the completion percentage of this version based on the amount of open/closed issues
|
|
|
# and the time spent on the open issues.
|
|
|
def completed_pourcent
|
|
|
if issues_count == 0
|
|
|
0
|
|
|
elsif open_issues_count == 0
|
|
|
100
|
|
|
else
|
|
|
issues_progress(false) + issues_progress(true)
|
|
|
end
|
|
|
end
|
|
|
|
|
|
# Returns the percentage of issues that have been marked as 'closed'.
|
|
|
def closed_pourcent
|
|
|
if issues_count == 0
|
|
|
0
|
|
|
else
|
|
|
issues_progress(false)
|
|
|
end
|
|
|
end
|
|
|
|
|
|
# Returns true if the version is overdue: due date reached and some open issues
|
|
|
def overdue?
|
|
|
effective_date && (effective_date < Date.today) && (open_issues_count > 0)
|
|
|
end
|
|
|
|
|
|
# Returns assigned issues count
|
|
|
def issues_count
|
|
|
@issue_count ||= fixed_issues.count
|
|
|
end
|
|
|
|
|
|
# Returns the total amount of open issues for this version.
|
|
|
def open_issues_count
|
|
|
@open_issues_count ||= Issue.count(:all, :conditions => ["fixed_version_id = ? AND is_closed = ?", self.id, false], :include => :status)
|
|
|
end
|
|
|
|
|
|
# Returns the total amount of closed issues for this version.
|
|
|
def closed_issues_count
|
|
|
@closed_issues_count ||= Issue.count(:all, :conditions => ["fixed_version_id = ? AND is_closed = ?", self.id, true], :include => :status)
|
|
|
end
|
|
|
|
|
|
def wiki_page
|
|
|
if project.wiki && !wiki_page_title.blank?
|
|
|
@wiki_page ||= project.wiki.find_page(wiki_page_title)
|
|
|
end
|
|
|
@wiki_page
|
|
|
end
|
|
|
|
|
|
def to_s; name end
|
|
|
|
|
|
# Versions are sorted by effective_date and name
|
|
|
# Those with no effective_date are at the end, sorted by name
|
|
|
def <=>(version)
|
|
|
if self.effective_date
|
|
|
version.effective_date ? (self.effective_date == version.effective_date ? self.name <=> version.name : self.effective_date <=> version.effective_date) : -1
|
|
|
else
|
|
|
version.effective_date ? 1 : (self.name <=> version.name)
|
|
|
end
|
|
|
end
|
|
|
|
|
|
private
|
|
|
def check_integrity
|
|
|
raise "Can't delete version" if self.fixed_issues.find(:first)
|
|
|
end
|
|
|
|
|
|
# Returns the average estimated time of assigned issues
|
|
|
# or 1 if no issue has an estimated time
|
|
|
# Used to weigth unestimated issues in progress calculation
|
|
|
def estimated_average
|
|
|
if @estimated_average.nil?
|
|
|
average = fixed_issues.average(:estimated_hours).to_f
|
|
|
if average == 0
|
|
|
average = 1
|
|
|
end
|
|
|
@estimated_average = average
|
|
|
end
|
|
|
@estimated_average
|
|
|
end
|
|
|
|
|
|
# Returns the total progress of open or closed issues. The returned percentage takes into account
|
|
|
# the amount of estimated time set for this version.
|
|
|
#
|
|
|
# Examples:
|
|
|
# issues_progress(true) => returns the progress percentage for open issues.
|
|
|
# issues_progress(false) => returns the progress percentage for closed issues.
|
|
|
def issues_progress(open)
|
|
|
@issues_progress ||= {}
|
|
|
@issues_progress[open] ||= begin
|
|
|
progress = 0
|
|
|
if issues_count > 0
|
|
|
ratio = open ? 'done_ratio' : 100
|
|
|
|
|
|
done = fixed_issues.sum("COALESCE(estimated_hours, #{estimated_average}) * #{ratio}",
|
|
|
:include => :status,
|
|
|
:conditions => ["is_closed = ?", !open]).to_f
|
|
|
progress = done / (estimated_average * issues_count)
|
|
|
end
|
|
|
progress
|
|
|
end
|
|
|
end
|
|
|
end
|
|
|
|
