liquid_feedback_frontend

diff model/initiative.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: c1dc3b14a4f3
children: 701a5cf6b067
     1.1 --- a/model/initiative.lua	Tue Jun 19 18:45:45 2012 +0200
     1.2 +++ b/model/initiative.lua	Tue Jun 19 21:20:46 2012 +0200
     1.3 @@ -215,10 +215,13 @@
     1.4      :add_group_by("_direct_supporter_snapshot.member_id")
     1.5  end
     1.6  
     1.7 ---function Member:get_search_selector(search_string)
     1.8 ---  return self:new_selector()
     1.9 ---    :add_where("active")
    1.10 ---end
    1.11 +function Initiative:selector_for_updated_drafts(member_id)
    1.12 +  return Initiative:new_selector()
    1.13 +    :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")
    1.14 +    :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")
    1.15 +    :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", member_id })
    1.16 +    :add_where("initiative.revoked ISNULL")
    1.17 +end
    1.18  
    1.19  
    1.20  function Initiative.object_get:current_draft()