liquid_feedback_frontend

diff model/delegation.lua @ 558:18e8de7a2b6a
Show notifications on start page as ulli list with links instead of tabs
author: bsw
date: Tue Jun 19 21:20:46 2012 +0200 (2012-06-19)
parents: e3613831cd1e
children: 5dc5f923797b
     1.1 --- a/model/delegation.lua	Tue Jun 19 18:45:45 2012 +0200
     1.2 +++ b/model/delegation.lua	Tue Jun 19 21:20:46 2012 +0200
     1.3 @@ -53,3 +53,12 @@
     1.4    end
     1.5    return selector:exec()
     1.6  end
     1.7 +
     1.8 +function Delegation:selector_for_broken(member_id)
     1.9 +  return Delegation:new_selector()
    1.10 +    :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")
    1.11 +    :join("member", nil, "delegation.trustee_id = member.id")
    1.12 +    :add_where{"delegation.truster_id = ?", member_id}
    1.13 +    :add_where{"member.active = 'f' OR (member.last_activity IS NULL OR age(member.last_activity) > ?::interval)", config.delegation_warning_time }
    1.14 +end
    1.15 +  
    1.16 \ No newline at end of file