| @@ -1194,13 +1194,13 class Issue < ActiveRecord::Base | |||||
| 1194 | end |
|
1194 | end | |
| 1195 |
|
1195 | |||
| 1196 | def self.by_subproject(project) |
|
1196 | def self.by_subproject(project) | |
| 1197 |
ActiveRecord::Base.connection.select_all("select s.id as status_id, |
|
1197 | ActiveRecord::Base.connection.select_all("select s.id as status_id, | |
| 1198 |
s.is_closed as closed, |
|
1198 | s.is_closed as closed, | |
| 1199 | #{Issue.table_name}.project_id as project_id, |
|
1199 | #{Issue.table_name}.project_id as project_id, | |
| 1200 |
count(#{Issue.table_name}.id) as total |
|
1200 | count(#{Issue.table_name}.id) as total | |
| 1201 |
from |
|
1201 | from | |
| 1202 | #{Issue.table_name}, #{Project.table_name}, #{IssueStatus.table_name} s |
|
1202 | #{Issue.table_name}, #{Project.table_name}, #{IssueStatus.table_name} s | |
| 1203 |
where |
|
1203 | where | |
| 1204 | #{Issue.table_name}.status_id=s.id |
|
1204 | #{Issue.table_name}.status_id=s.id | |
| 1205 | and #{Issue.table_name}.project_id = #{Project.table_name}.id |
|
1205 | and #{Issue.table_name}.project_id = #{Project.table_name}.id | |
| 1206 | and #{visible_condition(User.current, :project => project, :with_subprojects => true)} |
|
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