liquid_feedback_core
changeset 145:0fa3c4739ca7 v1.4.0_rc3
Bugfix in function "close_voting": Create autoreject ballots only for members with "voting_right" in the unit
author | jbe |
---|---|
date | Thu Jun 02 01:22:41 2011 +0200 (2011-06-02) |
parents | 07cfc7c1ce3f |
children | 8422bca3a218 652be62683cb |
files | core.sql |
line diff
1.1 --- a/core.sql Tue May 24 23:13:06 2011 +0200 1.2 +++ b/core.sql Thu Jun 02 01:22:41 2011 +0200 1.3 @@ -3437,6 +3437,9 @@ 1.4 FROM "interest" 1.5 JOIN "member" 1.6 ON "interest"."member_id" = "member"."id" 1.7 + JOIN "privilege" 1.8 + ON "privilege"."unit_id" = "unit_id_v" 1.9 + AND "privilege"."member_id" = "member"."id" 1.10 LEFT JOIN "direct_voter" 1.11 ON "interest"."member_id" = "direct_voter"."member_id" 1.12 AND "interest"."issue_id" = "direct_voter"."issue_id" 1.13 @@ -3446,12 +3449,16 @@ 1.14 WHERE "interest"."issue_id" = "issue_id_p" 1.15 AND "interest"."autoreject" = TRUE 1.16 AND "member"."active" 1.17 + AND "privilege"."voting_right" 1.18 AND "direct_voter"."member_id" ISNULL 1.19 AND "delegating_voter"."member_id" ISNULL 1.20 UNION SELECT "membership"."member_id" 1.21 FROM "membership" 1.22 JOIN "member" 1.23 ON "membership"."member_id" = "member"."id" 1.24 + JOIN "privilege" 1.25 + ON "privilege"."unit_id" = "unit_id_v" 1.26 + AND "privilege"."member_id" = "member"."id" 1.27 LEFT JOIN "interest" 1.28 ON "membership"."member_id" = "interest"."member_id" 1.29 AND "interest"."issue_id" = "issue_id_p" 1.30 @@ -3464,6 +3471,7 @@ 1.31 WHERE "membership"."area_id" = "area_id_v" 1.32 AND "membership"."autoreject" = TRUE 1.33 AND "member"."active" 1.34 + AND "privilege"."voting_right" 1.35 AND "interest"."autoreject" ISNULL 1.36 AND "direct_voter"."member_id" ISNULL 1.37 AND "delegating_voter"."member_id" ISNULL