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 }