liquid_feedback_core
diff update/core-update.v3.2.2-v4.0.0.sql @ 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 |
line diff
1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Fri Jul 14 21:17:26 2017 +0200 1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Tue Jul 18 01:14:45 2017 +0200 1.3 @@ -985,10 +985,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 @@ -1014,10 +1018,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 @@ -1043,10 +1051,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';