liquid_feedback_core
diff core.sql @ 87:e588fdf1676e
Bugfix: "autoreject" only taken into account, when member is "active"
author | jbe |
---|---|
date | Tue Oct 26 22:18:18 2010 +0200 (2010-10-26) |
parents | f77c0f3d443c |
children | d7eadecc7b05 |
line diff
1.1 --- a/core.sql Tue Sep 07 21:20:18 2010 +0200 1.2 +++ b/core.sql Tue Oct 26 22:18:18 2010 +0200 1.3 @@ -6,7 +6,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('1.2.8', 1, 2, 8)) 1.8 + SELECT * FROM (VALUES ('1.2.9', 1, 2, 9)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -2765,6 +2765,8 @@ 1.13 FOR "member_id_v" IN 1.14 SELECT "interest"."member_id" 1.15 FROM "interest" 1.16 + JOIN "member" 1.17 + ON "interest"."member_id" = "member"."id" 1.18 LEFT JOIN "direct_voter" 1.19 ON "interest"."member_id" = "direct_voter"."member_id" 1.20 AND "interest"."issue_id" = "direct_voter"."issue_id" 1.21 @@ -2773,10 +2775,13 @@ 1.22 AND "interest"."issue_id" = "delegating_voter"."issue_id" 1.23 WHERE "interest"."issue_id" = "issue_id_p" 1.24 AND "interest"."autoreject" = TRUE 1.25 + AND "member"."active" 1.26 AND "direct_voter"."member_id" ISNULL 1.27 AND "delegating_voter"."member_id" ISNULL 1.28 UNION SELECT "membership"."member_id" 1.29 FROM "membership" 1.30 + JOIN "member" 1.31 + ON "membership"."member_id" = "member"."id" 1.32 LEFT JOIN "interest" 1.33 ON "membership"."member_id" = "interest"."member_id" 1.34 AND "interest"."issue_id" = "issue_id_p" 1.35 @@ -2788,6 +2793,7 @@ 1.36 AND "delegating_voter"."issue_id" = "issue_id_p" 1.37 WHERE "membership"."area_id" = "issue_row"."area_id" 1.38 AND "membership"."autoreject" = TRUE 1.39 + AND "member"."active" 1.40 AND "interest"."autoreject" ISNULL 1.41 AND "direct_voter"."member_id" ISNULL 1.42 AND "delegating_voter"."member_id" ISNULL