# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1553678371 -3600
# Node ID ff58440ce809cbefafa06bdf20c537a4bcd71568
# Parent  c02cebff3f1635b70e74f04d7ed6fe759e34258d
Added staging_done to the longterm waterlevels selections.

diff -r c02cebff3f16 -r ff58440ce809 pkg/controllers/gauges.go
--- a/pkg/controllers/gauges.go	Tue Mar 26 19:37:55 2019 +0100
+++ b/pkg/controllers/gauges.go	Wed Mar 27 10:19:31 2019 +0100
@@ -85,7 +85,7 @@
   min(water_level) AS min,
   max(water_level) AS max
 FROM waterway.gauge_measurements, g
-WHERE fk_gauge_id = g.loc AND NOT predicted
+WHERE fk_gauge_id = g.loc AND NOT predicted AND staging_done
 GROUP BY extract(day from measure_date)::varchar || ':' ||
          extract(month from measure_date)::varchar;
 `
@@ -95,8 +95,9 @@
   water_level
 FROM waterway.gauge_measurements
 WHERE
-  NOT predicted
-  AND fk_gauge_id = (
+  NOT predicted AND
+  staging_done AND
+  fk_gauge_id = (
     $1::char(2),
     $2::char(3),
     $3::char(5),