liquid_feedback_core
changeset 321:48a5036d5eb1
Require "satisfied" support for "admitted" initiatives when calculating "harmonic_weight"
author | jbe |
---|---|
date | Fri Feb 08 18:36:22 2013 +0100 (2013-02-08) |
parents | 3a7f06a88ecb |
children | fd58f487e1d0 |
files | core.sql update/core-update.v2.1.0-v2.1.1.sql |
line diff
1.1 --- a/core.sql Fri Feb 08 18:26:25 2013 +0100 1.2 +++ b/core.sql Fri Feb 08 18:36:22 2013 +0100 1.3 @@ -3071,6 +3071,10 @@ 1.4 AND "direct_interest_snapshot"."member_id" = "direct_supporter_snapshot"."member_id" 1.5 JOIN "initiative" 1.6 ON "direct_supporter_snapshot"."initiative_id" = "initiative"."id" 1.7 + AND ( 1.8 + "direct_supporter_snapshot"."satisfied" = TRUE OR 1.9 + coalesce("initiative"."admitted", FALSE) = FALSE 1.10 + ) 1.11 AND "initiative"."harmonic_weight" ISNULL 1.12 GROUP BY 1.13 "direct_interest_snapshot"."issue_id", 1.14 @@ -3095,6 +3099,10 @@ 1.15 AND "remaining_harmonic_supporter_weight"."member_id" = "direct_supporter_snapshot"."member_id" 1.16 JOIN "initiative" 1.17 ON "direct_supporter_snapshot"."initiative_id" = "initiative"."id" 1.18 + AND ( 1.19 + "direct_supporter_snapshot"."satisfied" = TRUE OR 1.20 + coalesce("initiative"."admitted", FALSE) = FALSE 1.21 + ) 1.22 AND "initiative"."harmonic_weight" ISNULL 1.23 GROUP BY 1.24 "initiative"."issue_id",
2.1 --- a/update/core-update.v2.1.0-v2.1.1.sql Fri Feb 08 18:26:25 2013 +0100 2.2 +++ b/update/core-update.v2.1.0-v2.1.1.sql Fri Feb 08 18:36:22 2013 +0100 2.3 @@ -27,6 +27,10 @@ 2.4 AND "direct_interest_snapshot"."member_id" = "direct_supporter_snapshot"."member_id" 2.5 JOIN "initiative" 2.6 ON "direct_supporter_snapshot"."initiative_id" = "initiative"."id" 2.7 + AND ( 2.8 + "direct_supporter_snapshot"."satisfied" = TRUE OR 2.9 + coalesce("initiative"."admitted", FALSE) = FALSE 2.10 + ) 2.11 AND "initiative"."harmonic_weight" ISNULL 2.12 GROUP BY 2.13 "direct_interest_snapshot"."issue_id", 2.14 @@ -50,6 +54,10 @@ 2.15 AND "remaining_harmonic_supporter_weight"."member_id" = "direct_supporter_snapshot"."member_id" 2.16 JOIN "initiative" 2.17 ON "direct_supporter_snapshot"."initiative_id" = "initiative"."id" 2.18 + AND ( 2.19 + "direct_supporter_snapshot"."satisfied" = TRUE OR 2.20 + coalesce("initiative"."admitted", FALSE) = FALSE 2.21 + ) 2.22 AND "initiative"."harmonic_weight" ISNULL 2.23 GROUP BY 2.24 "initiative"."issue_id",