Patch #9303 ยป issue-by_subproject.patch
| 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
|
||