liquid_feedback_core

diff core.sql @ 546:f46ebb677898

Fixed unit/area/policy event triggers
author jbe
date Tue Jul 18 01:14:45 2017 +0200 (2017-07-18)
parents ff2c21f883ce
children 3cde0bb68adf
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';

Impressum / About Us