liquid_feedback_frontend

changeset 889:6ba4ebe7b707

Respect non_voter for not voted issues notification
author bsw
date Mon Aug 20 02:59:05 2012 +0200 (2012-08-20)
parents 06e72cc93c64
children 941941955c0e
files app/main/index/_notifications.lua
line diff
     1.1 --- a/app/main/index/_notifications.lua	Mon Aug 20 02:58:34 2012 +0200
     1.2 +++ b/app/main/index/_notifications.lua	Mon Aug 20 02:59:05 2012 +0200
     1.3 @@ -28,8 +28,10 @@
     1.4    :join("area", nil, "area.id = issue.area_id")
     1.5    :join("privilege", nil, { "privilege.unit_id = area.unit_id AND privilege.member_id = ? AND privilege.voting_right", app.session.member_id })
     1.6    :left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", app.session.member.id })
     1.7 +  :left_join("non_voter", nil, { "non_voter.issue_id = issue.id AND non_voter.member_id = ?", app.session.member.id })
     1.8    :left_join("interest", nil, { "interest.issue_id = issue.id AND interest.member_id = ?", app.session.member.id })
     1.9    :add_where{ "direct_voter.member_id ISNULL" }
    1.10 +  :add_where{ "non_voter.member_id ISNULL" }
    1.11    :add_where{ "interest.member_id NOTNULL" }
    1.12    :add_where{ "issue.fully_frozen NOTNULL" }
    1.13    :add_where{ "issue.closed ISNULL" }

Impressum / About Us