liquid_feedback_core

changeset 317:09e2805decd3

Count non-fulfilled suggestions with positive opinion and fulfilled suggestions with negative opinion for "harmonic_weight" of suggestions
author jbe
date Sat Feb 02 20:37:03 2013 +0100 (2013-02-02)
parents 727926e290e7
children 89974afd890b
files core.sql update/core-update.v2.1.0-v2.1.1.sql
line diff
     1.1 --- a/core.sql	Sat Feb 02 20:21:16 2013 +0100
     1.2 +++ b/core.sql	Sat Feb 02 20:37:03 2013 +0100
     1.3 @@ -3184,7 +3184,10 @@
     1.4    JOIN "opinion"
     1.5      ON "direct_interest_snapshot"."member_id" = "opinion"."member_id"
     1.6      AND "initiative"."id" = "opinion"."initiative_id"
     1.7 -    AND "opinion"."degree" > 0
     1.8 +    AND (
     1.9 +      ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR
    1.10 +      ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE)
    1.11 +    )
    1.12    GROUP BY
    1.13      "initiative"."issue_id",
    1.14      "opinion"."initiative_id",
     2.1 --- a/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 20:21:16 2013 +0100
     2.2 +++ b/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 20:37:03 2013 +0100
     2.3 @@ -137,7 +137,10 @@
     2.4    JOIN "opinion"
     2.5      ON "direct_interest_snapshot"."member_id" = "opinion"."member_id"
     2.6      AND "initiative"."id" = "opinion"."initiative_id"
     2.7 -    AND "opinion"."degree" > 0
     2.8 +    AND (
     2.9 +      ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR
    2.10 +      ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE)
    2.11 +    )
    2.12    GROUP BY
    2.13      "initiative"."issue_id",
    2.14      "opinion"."initiative_id",

Impressum / About Us