liquid_feedback_core

changeset 546:f46ebb677898

Fixed unit/area/policy event triggers
author jbe
date Tue Jul 18 01:14:45 2017 +0200 (2017-07-18)
parents 9c433d24ed00
children 3cde0bb68adf
files core.sql update/core-update.v3.2.2-v4.0.0.sql
line diff
     1.1 --- a/core.sql	Fri Jul 14 21:17:26 2017 +0200
     1.2 +++ b/core.sql	Tue Jul 18 01:14:45 2017 +0200
     1.3 @@ -1722,10 +1722,14 @@
     1.4        IF TG_OP = 'UPDATE' THEN
     1.5          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
     1.6            RETURN NULL;
     1.7 +        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
     1.8 +          "event_v" := 'unit_created';
     1.9          ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.10            "event_v" := 'unit_removed';
    1.11 +        ELSIF OLD != NEW THEN
    1.12 +          "event_v" := 'unit_updated';
    1.13          ELSE
    1.14 -          "event_v" := 'unit_updated';
    1.15 +          RETURN NULL;
    1.16          END IF;
    1.17        ELSE
    1.18          "event_v" := 'unit_created';
    1.19 @@ -1751,10 +1755,14 @@
    1.20        IF TG_OP = 'UPDATE' THEN
    1.21          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    1.22            RETURN NULL;
    1.23 +        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.24 +          "event_v" := 'area_created';
    1.25          ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.26            "event_v" := 'area_removed';
    1.27 +        ELSIF OLD != NEW THEN
    1.28 +          "event_v" := 'area_updated';
    1.29          ELSE
    1.30 -          "event_v" := 'area_updated';
    1.31 +          RETURN NULL;
    1.32          END IF;
    1.33        ELSE
    1.34          "event_v" := 'area_created';
    1.35 @@ -1780,10 +1788,14 @@
    1.36        IF TG_OP = 'UPDATE' THEN
    1.37          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    1.38            RETURN NULL;
    1.39 +        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.40 +          "event_v" := 'policy_created';
    1.41          ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.42            "event_v" := 'policy_removed';
    1.43 +        ELSIF OLD != NEW THEN
    1.44 +          "event_v" := 'policy_updated';
    1.45          ELSE
    1.46 -          "event_v" := 'policy_updated';
    1.47 +          RETURN NULL;
    1.48          END IF;
    1.49        ELSE
    1.50          "event_v" := 'policy_created';
     2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Fri Jul 14 21:17:26 2017 +0200
     2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Tue Jul 18 01:14:45 2017 +0200
     2.3 @@ -985,10 +985,14 @@
     2.4        IF TG_OP = 'UPDATE' THEN
     2.5          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
     2.6            RETURN NULL;
     2.7 +        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
     2.8 +          "event_v" := 'unit_created';
     2.9          ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.10            "event_v" := 'unit_removed';
    2.11 +        ELSIF OLD != NEW THEN
    2.12 +          "event_v" := 'unit_updated';
    2.13          ELSE
    2.14 -          "event_v" := 'unit_updated';
    2.15 +          RETURN NULL;
    2.16          END IF;
    2.17        ELSE
    2.18          "event_v" := 'unit_created';
    2.19 @@ -1014,10 +1018,14 @@
    2.20        IF TG_OP = 'UPDATE' THEN
    2.21          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    2.22            RETURN NULL;
    2.23 +        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    2.24 +          "event_v" := 'area_created';
    2.25          ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.26            "event_v" := 'area_removed';
    2.27 +        ELSIF OLD != NEW THEN
    2.28 +          "event_v" := 'area_updated';
    2.29          ELSE
    2.30 -          "event_v" := 'area_updated';
    2.31 +          RETURN NULL;
    2.32          END IF;
    2.33        ELSE
    2.34          "event_v" := 'area_created';
    2.35 @@ -1043,10 +1051,14 @@
    2.36        IF TG_OP = 'UPDATE' THEN
    2.37          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    2.38            RETURN NULL;
    2.39 +        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    2.40 +          "event_v" := 'policy_created';
    2.41          ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    2.42            "event_v" := 'policy_removed';
    2.43 +        ELSIF OLD != NEW THEN
    2.44 +          "event_v" := 'policy_updated';
    2.45          ELSE
    2.46 -          "event_v" := 'policy_updated';
    2.47 +          RETURN NULL;
    2.48          END IF;
    2.49        ELSE
    2.50          "event_v" := 'policy_created';

Impressum / About Us