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';