Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/states/GaugeTimerangeState.java @ 5916:d6bf8353e0fc
Historical discharge curves: Do not add calculation relevant curve into list of available curves.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Tue, 07 May 2013 19:07:08 +0200 |
| parents | 1272d52e052e |
| children | af13ceeba52a |
comparison
equal
deleted
inserted
replaced
| 5915:4fafe8d147b2 | 5916:d6bf8353e0fc |
|---|---|
| 45 | 45 |
| 46 SQLQuery query = session.createSQLQuery( | 46 SQLQuery query = session.createSQLQuery( |
| 47 "SELECT min(start_time) as min, max(stop_time) as max " + | 47 "SELECT min(start_time) as min, max(stop_time) as max " + |
| 48 "FROM time_intervals WHERE id in " + | 48 "FROM time_intervals WHERE id in " + |
| 49 "(SELECT time_interval_id FROM discharge_tables " + | 49 "(SELECT time_interval_id FROM discharge_tables " + |
| 50 "WHERE gauge_id =:gid)"); | 50 "WHERE kind <> 0 and gauge_id =:gid)"); |
| 51 | 51 |
| 52 query.addScalar("min", StandardBasicTypes.CALENDAR); | 52 query.addScalar("min", StandardBasicTypes.CALENDAR); |
| 53 query.addScalar("max", StandardBasicTypes.CALENDAR); | 53 query.addScalar("max", StandardBasicTypes.CALENDAR); |
| 54 | 54 |
| 55 query.setInteger("gid", gauge.getId()); | 55 query.setInteger("gid", gauge.getId()); |