Mercurial > gemma
diff pkg/controllers/gauges.go @ 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 | b5555005f51e |
| children | e6dc09896a4d |
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 {