Project

General

Profile

Download (2.47 KB)

RE: Graphs plugin ยป changes-0.8-b.diff

new diff with working conditions - Uwe Koloska, 2009-05-26 01:20

View differences:

app/controllers/graphs_controller.rb
104 104 
        sql << " WHERE (%s)" % Project.allowed_to_condition(User.current, :view_issues)
105 105 
        unless @project.nil?
106 106 
            sql << " AND (project_id = #{@project.id}"
107 
            sql << "    OR project_id IN (%s)" % @project.descendants.active.visible.collect { |p| p.id }.join(',') unless @project.descendants.active.visible.empty?
107 
            sql << "    OR project_id IN (%s)" % @project.active_children.collect { |p| p.id }.join(',') unless @project.active_children.empty?
108 108 
            sql << " )"
109 109 
        end
110 110 
        sql << " GROUP BY project_id"
......
262 262 
        find_optional_project
263 263 
        if !@project.nil?
264 264 
            ids = [@project.id]
265 
            ids += @project.descendants.active.visible.collect(&:id)
266 
            @issues = Issue.visible.find(:first, :conditions => ["#{Project.table_name}.id IN (?)", ids])
265 
            ids += @project.active_children.collect(&:id)
266 
            @issues = Issue.find(:first, :include => [:project], :conditions => ["#{Project.table_name}.id IN (?)", ids])
267 267 
        else
268 
            @issues = Issue.visible.find(:first)
268 
            @issues = Issue.find(:first)
269 269 
        end
270 270 
    rescue ActiveRecord::RecordNotFound
271 271 
        render_404
......
275 275 
        find_optional_project
276 276 
        if !@project.nil?
277 277 
            ids = [@project.id]
278 
            ids += @project.descendants.active.visible.collect(&:id)
279 
            @issues = Issue.visible.find(:all, :include => [:status], :conditions => ["#{IssueStatus.table_name}.is_closed=? AND #{Project.table_name}.id IN (?)", false, ids])
278 
            ids += @project.active_children.collect(&:id)
279 
            @issues = Issue.find(:all, :include => [:status,:project], :conditions => ["#{IssueStatus.table_name}.is_closed=? AND #{Project.table_name}.id IN (?)", false, ids])
280 280 
        else
281 
            @issues = Issue.visible.find(:all, :include => [:status], :conditions => ["#{IssueStatus.table_name}.is_closed=?", false])
281 
            @issues = Issue.find(:all, :include => [:status], :conditions => ["#{IssueStatus.table_name}.is_closed=?", false])
282 282 
        end
283 283 
    rescue ActiveRecord::RecordNotFound
284 284 
        render_404
    (1-1/1)