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",

Impressum / About Us