Mercurial > gemma
changeset 2858:401bca8eaafb
Filter predicted values for waterlevels.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 28 Mar 2019 17:56:14 +0100 |
parents | 8a8a929182f9 |
children | 405c2fd252f1 |
files | pkg/controllers/gauges.go |
diffstat | 1 files changed, 15 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/pkg/controllers/gauges.go Thu Mar 28 17:19:27 2019 +0100 +++ b/pkg/controllers/gauges.go Thu Mar 28 17:56:14 2019 +0100 @@ -525,6 +525,21 @@ isrs.Hectometre, ) + fb.cond( + `NOT predicted + OR ( + date_issue = ( + SELECT max(date_issue) FROM waterway.gauge_measurements + WHERE fk_gauge_id = ($%d::char(2), $%d::char(3), $%d::char(5), $%d::char(5), $%d::int) + ) + )`, + isrs.CountryCode, + isrs.LoCode, + isrs.FairwaySection, + isrs.Orc, + isrs.Hectometre, + ) + if from := req.FormValue("from"); from != "" { fromTime, err := time.Parse(models.ImportTimeFormat, from) if err != nil {