| @@ -1194,13 +1194,13 class Issue < ActiveRecord::Base | |||
|
|
1194 | 1194 | end |
|
|
1195 | 1195 | |
|
|
1196 | 1196 | def self.by_subproject(project) |
|
|
1197 |
ActiveRecord::Base.connection.select_all("select s.id as status_id, |
|
|
|
1198 |
s.is_closed as closed, |
|
|
|
1197 | ActiveRecord::Base.connection.select_all("select s.id as status_id, | |
|
|
1198 | s.is_closed as closed, | |
|
|
1199 | 1199 | #{Issue.table_name}.project_id as project_id, |
|
|
1200 |
count(#{Issue.table_name}.id) as total |
|
|
|
1201 |
from |
|
|
|
1200 | count(#{Issue.table_name}.id) as total | |
|
|
1201 | from | |
|
|
1202 | 1202 | #{Issue.table_name}, #{Project.table_name}, #{IssueStatus.table_name} s |
|
|
1203 |
where |
|
|
|
1203 | where | |
|
|
1204 | 1204 | #{Issue.table_name}.status_id=s.id |
|
|
1205 | 1205 | and #{Issue.table_name}.project_id = #{Project.table_name}.id |
|
|
1206 | 1206 | and #{visible_condition(User.current, :project => project, :with_subprojects => true)} |
General Comments 0
You need to be logged in to leave comments.
Login now