# HG changeset patch
# User jbe
# Date 1306970561 -7200
# Node ID 0fa3c4739ca75a0dd55c073903e274ec20fce137
# Parent  07cfc7c1ce3f9c7191a028d3fabf27881edcc8c7
Bugfix in function "close_voting": Create autoreject ballots only for members with "voting_right" in the unit

diff -r 07cfc7c1ce3f -r 0fa3c4739ca7 core.sql
--- a/core.sql	Tue May 24 23:13:06 2011 +0200
+++ b/core.sql	Thu Jun 02 01:22:41 2011 +0200
@@ -3437,6 +3437,9 @@
           FROM "interest"
           JOIN "member"
             ON "interest"."member_id" = "member"."id"
+          JOIN "privilege"
+            ON "privilege"."unit_id" = "unit_id_v"
+            AND "privilege"."member_id" = "member"."id"
           LEFT JOIN "direct_voter"
             ON "interest"."member_id" = "direct_voter"."member_id"
             AND "interest"."issue_id" = "direct_voter"."issue_id"
@@ -3446,12 +3449,16 @@
           WHERE "interest"."issue_id" = "issue_id_p"
           AND "interest"."autoreject" = TRUE
           AND "member"."active"
+          AND "privilege"."voting_right"
           AND "direct_voter"."member_id" ISNULL
           AND "delegating_voter"."member_id" ISNULL
         UNION SELECT "membership"."member_id"
           FROM "membership"
           JOIN "member"
             ON "membership"."member_id" = "member"."id"
+          JOIN "privilege"
+            ON "privilege"."unit_id" = "unit_id_v"
+            AND "privilege"."member_id" = "member"."id"
           LEFT JOIN "interest"
             ON "membership"."member_id" = "interest"."member_id"
             AND "interest"."issue_id" = "issue_id_p"
@@ -3464,6 +3471,7 @@
           WHERE "membership"."area_id" = "area_id_v"
           AND "membership"."autoreject" = TRUE
           AND "member"."active"
+          AND "privilege"."voting_right"
           AND "interest"."autoreject" ISNULL
           AND "direct_voter"."member_id" ISNULL
           AND "delegating_voter"."member_id" ISNULL