liquid_feedback_frontend

changeset 605:42afe0765f86

Show broken area and unit delegations too
author bsw
date Sun Jun 24 23:08:24 2012 +0200 (2012-06-24)
parents c4144daf6906
children c4b878748205
files model/delegation.lua
line diff
     1.1 --- a/model/delegation.lua	Sun Jun 24 23:01:00 2012 +0200
     1.2 +++ b/model/delegation.lua	Sun Jun 24 23:08:24 2012 +0200
     1.3 @@ -64,7 +64,8 @@
     1.4  
     1.5  function Delegation:selector_for_broken(member_id)
     1.6    return Delegation:new_selector()
     1.7 -    :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")
     1.8 +    :left_join("issue", nil, "issue.id = delegation.issue_id")
     1.9 +    :add_where("issue.id ISNULL OR issue.closed ISNULL")
    1.10      :join("member", nil, "delegation.trustee_id = member.id")
    1.11      :add_where{"delegation.truster_id = ?", member_id}
    1.12      :add_where{"member.active = 'f' OR (member.last_activity IS NULL OR age(member.last_activity) > ?::interval)", config.delegation_warning_time }

Impressum / About Us