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