liquid_feedback_core

changeset 503:986d8f3a6895

Exclude revoked initiatives from updated/featured/leading initiatives in notification system
author jbe
date Tue Apr 05 00:19:33 2016 +0200 (2016-04-05)
parents f39c673420cb
children d07e6a046d41
files core.sql update/core-update.v3.1.0-v3.2.0.sql
line diff
     1.1 --- a/core.sql	Mon Apr 04 23:55:22 2016 +0200
     1.2 +++ b/core.sql	Tue Apr 05 00:19:33 2016 +0200
     1.3 @@ -2381,6 +2381,7 @@
     1.4      "ignored_initiative"."member_id" = "supporter"."member_id" AND
     1.5      "ignored_initiative"."initiative_id" = "supporter"."initiative_id"
     1.6    WHERE "issue"."state" IN ('admission', 'discussion')
     1.7 +  AND "initiative"."revoked" ISNULL
     1.8    AND "ignored_initiative"."member_id" ISNULL
     1.9    AND (
    1.10      EXISTS (
    1.11 @@ -2466,6 +2467,7 @@
    1.12              WHERE "supporter"."member_id" = "member_id_v"
    1.13              AND "issue"."area_id" = "area_id_p"
    1.14              AND "issue"."state" IN ('admission', 'discussion', 'verification')
    1.15 +            AND "initiative"."revoked" ISNULL
    1.16              AND "self_support"."member_id" ISNULL
    1.17              AND NOT "initiative_id_ary" @> ARRAY["initiative"."id"]
    1.18              AND (
    1.19 @@ -2534,6 +2536,7 @@
    1.20        "uf_initiative_full"."id" = "uf_initiative"."initiative_id"
    1.21      JOIN "initiative" ON
    1.22        "initiative"."issue_id" = "uf_initiative_full"."issue_id"
    1.23 +    WHERE "initiative"."revoked" ISNULL
    1.24      ORDER BY
    1.25        "uf_initiative"."recipient_id",
    1.26        "initiative"."issue_id",
     2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Mon Apr 04 23:55:22 2016 +0200
     2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Tue Apr 05 00:19:33 2016 +0200
     2.3 @@ -100,6 +100,7 @@
     2.4      "ignored_initiative"."member_id" = "supporter"."member_id" AND
     2.5      "ignored_initiative"."initiative_id" = "supporter"."initiative_id"
     2.6    WHERE "issue"."state" IN ('admission', 'discussion')
     2.7 +  AND "initiative"."revoked" ISNULL
     2.8    AND "ignored_initiative"."member_id" ISNULL
     2.9    AND (
    2.10      EXISTS (
    2.11 @@ -185,6 +186,7 @@
    2.12              WHERE "supporter"."member_id" = "member_id_v"
    2.13              AND "issue"."area_id" = "area_id_p"
    2.14              AND "issue"."state" IN ('admission', 'discussion', 'verification')
    2.15 +            AND "initiative"."revoked" ISNULL
    2.16              AND "self_support"."member_id" ISNULL
    2.17              AND NOT "initiative_id_ary" @> ARRAY["initiative"."id"]
    2.18              AND (
    2.19 @@ -253,6 +255,7 @@
    2.20        "uf_initiative_full"."id" = "uf_initiative"."initiative_id"
    2.21      JOIN "initiative" ON
    2.22        "initiative"."issue_id" = "uf_initiative_full"."issue_id"
    2.23 +    WHERE "initiative"."revoked" ISNULL
    2.24      ORDER BY
    2.25        "uf_initiative"."recipient_id",
    2.26        "initiative"."issue_id",

Impressum / About Us