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" }