Project

General

Profile

Patch #9303 ยป issue-by_subproject.patch

Igor Zubkov, 2011-09-22 12:24

View differences:

app/models/issue.rb (working copy)
end
def self.by_subproject(project)
ActiveRecord::Base.connection.select_all("select s.id as status_id,
s.is_closed as closed,
#{Issue.table_name}.project_id as project_id,
count(#{Issue.table_name}.id) as total
from
ActiveRecord::Base.connection.select_all("SELECT s.id AS status_id,
s.is_closed AS closed,
#{Issue.table_name}.project_id AS project_id,
COUNT(#{Issue.table_name}.id) AS total
FROM
#{Issue.table_name}, #{Project.table_name}, #{IssueStatus.table_name} s
where
#{Issue.table_name}.status_id=s.id
and #{Issue.table_name}.project_id = #{Project.table_name}.id
and #{visible_condition(User.current, :project => project, :with_subprojects => true)}
and #{Issue.table_name}.project_id <> #{project.id}
group by s.id, s.is_closed, #{Issue.table_name}.project_id") if project.descendants.active.any?
WHERE
#{Issue.table_name}.status_id = s.id
AND #{Issue.table_name}.project_id = #{Project.table_name}.id
AND #{visible_condition(User.current, :project => project, :with_subprojects => true)}
AND #{Issue.table_name}.project_id <> #{project.id}
GROUP BY s.id, s.is_closed, #{Issue.table_name}.project_id") if project.descendants.active.any?
end
# End ReportsController extraction
    (1-1/1)