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

Impressum / About Us